?? dlgbaseinfom.cpp
字號:
}
catch(...)
{
ADOFLAG = FALSE;
MessageBox("添加供應商信息失敗", "增加信息");
}
MessageBox("添加供應商信息成功", "增加信息");
}
else
{
MessageBox("添加供應商信息失敗 數據庫連接失敗", "增加信息");
}
m_dlg4.SetDlgItemText(IDC_PROVIDER_NAME, "");
m_dlg4.SetDlgItemText(IDC_PRO_CEO, "");
m_dlg4.SetDlgItemText(IDC_PRO_MANAGER, "");
m_dlg4.SetDlgItemText(IDC_PRO_PHONE, "");
m_dlg4.SetDlgItemText(IDC_PRO_ADDRESS, "");
m_dlg4.SetDlgItemText(IDC_PRO_NET_ADDRESS, "");
m_dlg4.SetDlgItemText(IDC_PRO_EMAIL, "");
m_wndToolBar.GetToolBarCtrl().EnableButton(IDC_MODIFY, FALSE);
m_wndToolBar.GetToolBarCtrl().EnableButton(IDC_FIRST, FALSE);
m_wndToolBar.GetToolBarCtrl().EnableButton(IDC_BEFORE, FALSE);
m_wndToolBar.GetToolBarCtrl().EnableButton(IDC_AFTER, FALSE);
m_wndToolBar.GetToolBarCtrl().EnableButton(IDC_END, FALSE);
}
break;
default:
break;
}
}
void CDlgBaseInfoM::OnModify()
{
m_wndToolBar.GetToolBarCtrl().EnableButton(IDC_MODIFY, FALSE);
m_wndToolBar.GetToolBarCtrl().EnableButton(IDC_FIRST, FALSE);
m_wndToolBar.GetToolBarCtrl().EnableButton(IDC_BEFORE, FALSE);
m_wndToolBar.GetToolBarCtrl().EnableButton(IDC_AFTER, FALSE);
m_wndToolBar.GetToolBarCtrl().EnableButton(IDC_END, FALSE);
int iCur = m_tab.GetCurSel();
switch(iCur)
{
case 0:
{
int size = strData.size();
if (size <= 0)
{
MessageBox("原操作員名稱不存在 不能修改", "修改信息錯誤");
return;
}
CAaaApp *pApp = (CAaaApp *)AfxGetApp();
int iflag = 0; //操作員級別
CString strName, strPass, strCount;
m_dlg1.GetDlgItemText(IDC_NAME, strName);
m_dlg1.GetDlgItemText(IDC_PASSWORD, strPass);
iflag = m_dlg1.GetDlgItemInt(IDC_COMB_JB);
if (iflag<=0 || iflag>pApp->iLevel)
{
CString str;
str.Format("修改操作員級別必須為數字1到數字%d之間", pApp->iLevel);
MessageBox(str, "修改信息錯誤");
m_dlg1.SetDlgItemText(IDC_NAME, "");
m_dlg1.SetDlgItemText(IDC_PASSWORD, "");
m_dlg1.SetDlgItemText(IDC_COMB_JB, "");
return;
}
if (strName == "")
{
MessageBox("操作員名稱不能為空", "修改信息錯誤");
m_dlg1.SetDlgItemText(IDC_NAME, "");
m_dlg1.SetDlgItemText(IDC_PASSWORD, "");
m_dlg1.SetDlgItemText(IDC_COMB_JB, "");
return;
}
if (strName == pApp->strUser && iflag !=pApp->iLevel)
{
MessageBox("不能修改自己的級別", "修改信息錯誤");
m_dlg1.SetDlgItemText(IDC_NAME, "");
m_dlg1.SetDlgItemText(IDC_PASSWORD, "");
m_dlg1.SetDlgItemText(IDC_COMB_JB, "");
return;
}
if (strName != strData[iDataIndex-1].strOperName)
{
MessageBox("只能修改用戶的級別", "修改信息錯誤");
m_dlg1.SetDlgItemText(IDC_NAME, "");
m_dlg1.SetDlgItemText(IDC_PASSWORD, "");
m_dlg1.SetDlgItemText(IDC_COMB_JB, "");
return;
}
if (ADOFLAG)
{
try
{
if (strData[iDataIndex-1].strOperName == pApp->strUser)
{
if (strPass == "")
{
MessageBox("密碼不能為空", "修改信息錯誤");
return;
}
strsql.Format("update tb_operator set [Level] = %d, PassWord = '%s' where name = '%s' ",
iflag, strPass, strData[iDataIndex-1].strOperName);
}
else
{
strsql.Format("update tb_operator set [Level] = %d where name = '%s' ",
iflag, strData[iDataIndex-1].strOperName);
}
m_pCon->Execute(_bstr_t(strsql), NULL, adCmdText);
}
catch(...)
{
MessageBox("修改操作員失敗", "修改信息");
}
MessageBox("修改操作員成功", "修改信息");
}
else
{
ADOFLAG = FALSE;
MessageBox("修改操作員失敗", "修改信息");
}
m_dlg1.SetDlgItemText(IDC_NAME, "");
m_dlg1.SetDlgItemText(IDC_PASSWORD, "");
m_dlg1.SetDlgItemText(IDC_COMB_JB, "");
}
break;
case 1:
{
int size = strData1.size();
if (size <= 0)
{
MessageBox("沒有信息 不能修改", "修改信息錯誤");
return;
}
CAaaApp *pApp = (CAaaApp *)AfxGetApp();
CString strName, strGG, strZHj,strPrice,strProvider,strMark;
m_dlg2.GetDlgItemText(IDC_PRO_NAME, strName);
m_dlg2.GetDlgItemText(IDC_RULE, strGG);
m_dlg2.GetDlgItemText(IDC_ZJCODE, strZHj);
m_dlg2.GetDlgItemText(IDC_MR_PRICE, strPrice);
m_dlg2.GetDlgItemText(IDC_PRO_PROVIDER, strProvider);
m_dlg2.GetDlgItemText(IDC_PRO_MARK, strMark);
if (pApp->iLevel <= 2)
{
MessageBox("您的權限不夠", "修改信息錯誤");
return;
}
if (strName == "" ||strGG == ""||strZHj == ""||strPrice == ""||strProvider == ""||strMark == "")
{
MessageBox("信息不能為空項", "修改信息錯誤");
return;
}
if (ADOFLAG)
{
try
{
strsql.Format("update tb_merchandiseinfo set name='%s', spec='%s', shortname='%s', \
defaultprice=%.2f, manufacturer='%s', memo='%s' where ID='%s' ",
strName, strGG, strZHj,atof(strPrice),strProvider,strMark,
strData1[iDataIndex1-1].strID);
m_pCon->Execute(_bstr_t(strsql), NULL, adCmdText);
}
catch(...)
{
MessageBox("修改操作失敗", "修改信息");
return;
}
MessageBox("修改操作成功", "修改信息");
}
else
{
ADOFLAG = FALSE;
MessageBox("修改數據失敗 數據庫連接失敗", "修改信息");
}
m_dlg2.SetDlgItemText(IDC_PRO_NAME, "");
m_dlg2.SetDlgItemText(IDC_RULE, "");
m_dlg2.SetDlgItemText(IDC_ZJCODE, "");
m_dlg2.SetDlgItemText(IDC_MR_PRICE, "");
m_dlg2.SetDlgItemText(IDC_PRO_PROVIDER, "");
m_dlg2.SetDlgItemText(IDC_PRO_MARK, "");
}
break;
case 2:
{
int size = strData2.size();
if (size <= 0)
{
MessageBox("沒有信息 不能修改", "修改信息錯誤");
return;
}
CAaaApp *pApp = (CAaaApp *)AfxGetApp();
int iflag = 0; //操作員級別
CString strName;
m_dlg3.GetDlgItemText(IDC_STORE_NAME, strName);
if (pApp->iLevel <= 2)
{
MessageBox("您的權限不夠", "修改信息錯誤");
return;
}
if (strName == "" )
{
MessageBox("信息不能為空項", "修改信息錯誤");
return;
}
if (ADOFLAG)
{
try
{
strsql.Format("update tb_storageinfo set storagename='%s' where storagename='%s'",
strName, strData2[iDataIndex2-1].strStorageName);
m_pCon->Execute(_bstr_t(strsql), NULL, adCmdText);
}
catch(...)
{
MessageBox("修改操作失敗", "修改信息");
return;
}
MessageBox("修改操作成功", "修改信息");
}
else
{
ADOFLAG = FALSE;
MessageBox("修改操作失敗 數據庫連接失敗", "修改信息");
}
m_dlg3.SetDlgItemText(IDC_STORE_NAME, "");
}
break;
case 3:
{
int size = strData2.size();
if (size <= 0)
{
MessageBox("沒有信息 不能修改", "修改信息錯誤");
return;
}
CAaaApp *pApp = (CAaaApp *)AfxGetApp();
int iflag = 0; //操作員級別
CString strCEO, strManager, strPhone, stradr, strnetadr, stremai;
m_dlg4.GetDlgItemText(IDC_PRO_CEO, strCEO);
m_dlg4.GetDlgItemText(IDC_PRO_MANAGER, strManager);
m_dlg4.GetDlgItemText(IDC_PRO_PHONE, strPhone);
m_dlg4.GetDlgItemText(IDC_PRO_ADDRESS, stradr);
m_dlg4.GetDlgItemText(IDC_PRO_NET_ADDRESS, strnetadr);
m_dlg4.GetDlgItemText(IDC_PRO_EMAIL, stremai);
if (pApp->iLevel <= 2)
{
MessageBox("您的權限不夠", "修改信息錯誤");
return;
}
if (strCEO == ""|| strManager==""|| strPhone==""|| stradr==""|| strnetadr==""|| stremai=="")
{
MessageBox("信息不能為空項", "修改信息錯誤");
return;
}
if (ADOFLAG)
{
try
{
strsql.Format("update tb_providerinfo set artificialperson='%s', \
principal='%s', phone='%s', addr='%s', web='%s', e_mai='%s' \
where providername='%s'",
strCEO, strManager, strPhone, stradr, strnetadr, stremai,
strData3[iDataIndex3-1].strProviderName);
m_pCon->Execute(_bstr_t(strsql), NULL, adCmdText);
}
catch(...)
{
MessageBox("修改操作失敗", "修改信息");
return;
}
MessageBox("修改操作成功", "修改信息");
}
else
{
ADOFLAG = FALSE;
MessageBox("修改操作失敗 數據庫連接失敗", "修改信息");
}
m_dlg4.SetDlgItemText(IDC_PRO_CEO, strCEO);
m_dlg4.SetDlgItemText(IDC_PRO_MANAGER, strManager);
m_dlg4.SetDlgItemText(IDC_PRO_PHONE, strPhone);
m_dlg4.SetDlgItemText(IDC_PRO_ADDRESS, stradr);
m_dlg4.SetDlgItemText(IDC_PRO_NET_ADDRESS, strnetadr);
m_dlg4.SetDlgItemText(IDC_PRO_EMAIL, stremai);
}
break;
default:
break;
}
}
void CDlgBaseInfoM::OnQuery()
{
m_wndToolBar.GetToolBarCtrl().EnableButton(IDC_MODIFY, TRUE);
m_wndToolBar.GetToolBarCtrl().EnableButton(IDC_FIRST, TRUE);
m_wndToolBar.GetToolBarCtrl().EnableButton(IDC_BEFORE, TRUE);
m_wndToolBar.GetToolBarCtrl().EnableButton(IDC_AFTER, TRUE);
m_wndToolBar.GetToolBarCtrl().EnableButton(IDC_END, TRUE);
int iCur = m_tab.GetCurSel();
switch(iCur)
{
case 0:
{
CAaaApp *pApp = (CAaaApp *)AfxGetApp();
OPERATOR oper;
if (ADOFLAG)
{
int nIndex = 0;
try
{
strsql.Format("select name as userid, password,[level] as lev from tb_operator ");
m_pRs = m_pCon->Execute(_bstr_t(strsql), NULL, adCmdText);
strData.clear();
while (!m_pRs->adoEOF)
{
nIndex++;
oper.strOperName = (LPCSTR)_bstr_t(m_pRs->GetCollect("userid"));
oper.strOperPass = (LPCSTR)_bstr_t(m_pRs->GetCollect("password"));
if (pApp->strPassWord != oper.strOperPass)
{
oper.strOperPass = "******";
}
oper.strOperLevel = (LPCSTR)_bstr_t(m_pRs->GetCollect("lev"));
strData.push_back(oper);
m_pRs->MoveNext();
}
if (nIndex > 0)
{
m_dlg1.SetDlgItemText(IDC_NAME, strData[0].strOperName);
m_dlg1.SetDlgItemText(IDC_PASSWORD, strData[0].strOperPass);
m_dlg1.SetDlgItemText(IDC_COMB_JB, strData[0].strOperLevel);
iDataIndex = 1;
}
else
{
m_dlg1.SetDlgItemText(IDC_NAME, "");
m_dlg1.SetDlgItemText(IDC_PASSWORD, "");
m_dlg1.SetDlgItemText(IDC_COMB_JB, "");
}
}
catch(...)
{
ADOFLAG = FALSE;
}
}
}
break;
case 1:
{
PRODUCTOR_INFO proInfo;
if (ADOFLAG)
{
int nIndex = 0;
try
{
strsql.Format("select ID, name, spec, shortname, defaultprice, manufacturer, memo from tb_merchandiseinfo ");
m_pRs = m_pCon->Execute(_bstr_t(strsql), NULL, adCmdText);
strData1.clear();
while (!m_pRs->adoEOF)
{
nIndex++;
proInfo.strID = (LPCSTR)_bstr_t(m_pRs->GetCollect("ID"));
proInfo.strProductorName = (LPCSTR)_bstr_t(m_pRs->GetCollect("name"));
proInfo.strRuler = (LPCSTR)_bstr_t(m_pRs->GetCollect("spec"));
proInfo.strZHjCode = (LPCSTR)_bstr_t(m_pRs->GetCollect("shortname"));
proInfo.dMoney = atof((LPCSTR)_bstr_t(m_pRs->GetCollect("defaultprice")));
proInfo.strProvider = (LPCSTR)_bstr_t(m_pRs->GetCollect("manufacturer"));
proInfo.strMark = (LPCSTR)_bstr_t(m_pRs->GetCollect("memo"));
strData1.push_back(proInfo);
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -