📄 dlgbaseinfom.cpp
字号:
m_pRs->MoveNext();
}
if (nIndex > 0)
{
m_dlg2.SetDlgItemText(IDC_ID, strData1[0].strID);
m_dlg2.SetDlgItemText(IDC_PRO_NAME, strData1[0].strProductorName);
m_dlg2.SetDlgItemText(IDC_RULE, strData1[0].strRuler);
m_dlg2.SetDlgItemText(IDC_ZJCODE, strData1[0].strZHjCode);
CString str;
str.Format("%.2f", strData1[0].dMoney);
m_dlg2.SetDlgItemText(IDC_MR_PRICE, str);
m_dlg2.SetDlgItemText(IDC_PRO_PROVIDER, strData1[0].strProvider);
m_dlg2.SetDlgItemText(IDC_PRO_MARK, strData1[0].strMark);
iDataIndex1 = 1;
}
else
{
m_dlg2.SetDlgItemText(IDC_ID, "");
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, "");
}
}
catch(...)
{
ADOFLAG = FALSE;
}
}
}
break;
case 2:
{
STORAGE_INFO StoreInfo;
if (ADOFLAG)
{
int nIndex = 0;
try
{
strsql.Format("select storagename from tb_storageinfo ");
m_pRs = m_pCon->Execute(_bstr_t(strsql), NULL, adCmdText);
strData2.clear();
while (!m_pRs->adoEOF)
{
nIndex++;
StoreInfo.strStorageName = (LPCSTR)_bstr_t(m_pRs->GetCollect("storagename"));
strData2.push_back(StoreInfo);
m_pRs->MoveNext();
}
if (nIndex > 0)
{
m_dlg3.SetDlgItemText(IDC_STORE_NAME, strData2[0].strStorageName);
iDataIndex2 = 1;
}
else
{
m_dlg3.SetDlgItemText(IDC_STORE_NAME, "");
}
}
catch(...)
{
ADOFLAG = FALSE;
}
}
}
break;
case 3:
{
PROVIDER_INFO ProviderInfo;
if (ADOFLAG)
{
int nIndex = 0;
try
{
strsql.Format("select providername, artificialperson,principal, phone, addr, web, e_mail \
from tb_providerinfo ");
m_pRs = m_pCon->Execute(_bstr_t(strsql), NULL, adCmdText);
strData3.clear();
while (!m_pRs->adoEOF)
{
nIndex++;
ProviderInfo.strProviderName = (LPCSTR)_bstr_t(m_pRs->GetCollect("providername"));
ProviderInfo.strCEO = (LPCSTR)_bstr_t(m_pRs->GetCollect("artificialperson"));
ProviderInfo.strManager = (LPCSTR)_bstr_t(m_pRs->GetCollect("principal"));
ProviderInfo.strPhone = (LPCSTR)_bstr_t(m_pRs->GetCollect("phone"));
ProviderInfo.strAddress = (LPCSTR)_bstr_t(m_pRs->GetCollect("addr"));
ProviderInfo.strNetAddress = (LPCSTR)_bstr_t(m_pRs->GetCollect("web"));
ProviderInfo.strEmail = (LPCSTR)_bstr_t(m_pRs->GetCollect("e_mail"));
strData3.push_back(ProviderInfo);
m_pRs->MoveNext();
}
if (nIndex > 0)
{
m_dlg4.SetDlgItemText(IDC_PROVIDER_NAME, strData3[0].strProviderName);
m_dlg4.SetDlgItemText(IDC_PRO_CEO, strData3[0].strCEO);
m_dlg4.SetDlgItemText(IDC_PRO_MANAGER, strData3[0].strManager);
m_dlg4.SetDlgItemText(IDC_PRO_PHONE, strData3[0].strPhone);
m_dlg4.SetDlgItemText(IDC_PRO_ADDRESS, strData3[0].strAddress);
m_dlg4.SetDlgItemText(IDC_PRO_NET_ADDRESS, strData3[0].strNetAddress);
m_dlg4.SetDlgItemText(IDC_PRO_EMAIL, strData3[0].strEmail);
iDataIndex3 = 1;
}
else
{
m_dlg2.SetDlgItemText(IDC_ID, "");
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, "");
}
}
catch(...)
{
ADOFLAG = FALSE;
}
}
}
break;
default:
break;
}
}
void CDlgBaseInfoM::OnDel()
{
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:
{
CAaaApp *pApp = (CAaaApp *)AfxGetApp();
if (pApp->iLevel<4)
{
MessageBox("您没有权限删除", "删除错误信息");
return;
}
OPERATOR oper;
if (ADOFLAG)
{
int nIndex = 0;
try
{
CString strName, strCount;
m_dlg1.GetDlgItemText(IDC_NAME, strName);
strsql.Format("select count(*) as nCount from tb_operator where name = '%s' ", strName);
m_pRs = m_pCon->Execute(_bstr_t(strsql), NULL, adCmdText);
strCount = (LPCSTR)_bstr_t(m_pRs->GetCollect("nCount"));
if (strCount != "1")
{
MessageBox("将要删除的操作员不存在", "删除信息错误");
m_dlg1.SetDlgItemText(IDC_NAME, "");
m_dlg1.SetDlgItemText(IDC_PASSWORD, "");
m_dlg1.SetDlgItemText(IDC_COMB_JB, "");
return;
}
strsql.Format("delete tb_operator where name = '%s' ", strName);
m_pCon->Execute(_bstr_t(strsql), NULL, adCmdText);
m_dlg1.SetDlgItemText(IDC_NAME, "");
m_dlg1.SetDlgItemText(IDC_PASSWORD, "");
m_dlg1.SetDlgItemText(IDC_COMB_JB, "");
}
catch(...)
{
MessageBox("删除操作员操作失败", "删除信息错误");
}
MessageBox("删除操作员成功", "删除信息");
}
else
{
ADOFLAG = FALSE;
MessageBox("删除操作员操作失败 数据库连接失败", "删除信息错误");
}
}
break;
case 1:
{
PRODUCTOR_INFO proInfo;
CAaaApp *pApp = (CAaaApp *)AfxGetApp();
if (pApp->iLevel<4)
{
MessageBox("您没有权限删除", "删除错误信息");
return;
}
if (ADOFLAG)
{
int nIndex = 0;
try
{
CString strID, strCount;
m_dlg2.GetDlgItemText(IDC_ID, strID);
strsql.Format("select count(*) as nCount from tb_merchandiseinfo where ID = '%s' ", strID);
m_pRs = m_pCon->Execute(_bstr_t(strsql), NULL, adCmdText);
strCount = (LPCSTR)_bstr_t(m_pRs->GetCollect("nCount"));
if (strCount != "1")
{
MessageBox("将要删除的操作员不存在", "删除信息错误");
return;
}
strsql.Format("delete tb_merchandiseinfo where ID = '%s' ", strID);
m_pCon->Execute(_bstr_t(strsql), NULL, adCmdText);
m_dlg2.SetDlgItemText(IDC_ID, "");
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, "");
}
catch(...)
{
MessageBox("删除操作失败", "删除信息错误");
}
MessageBox("删除操作成功", "删除信息");
}
else
{
ADOFLAG = FALSE;
MessageBox("删除操作失败 数据库连接失败", "删除信息错误");
}
}
break;
case 2:
{
CAaaApp *pApp = (CAaaApp *)AfxGetApp();
if (pApp->iLevel<4)
{
MessageBox("您没有权限删除", "删除错误信息");
return;
}
if (ADOFLAG)
{
int nIndex = 0;
try
{
CString strname, strCount;
m_dlg3.GetDlgItemText(IDC_PROVIDER_NAME, strname);
strsql.Format("select count(*) as nCount from tb_storageinfo where storagename = '%s' ", strname);
m_pRs = m_pCon->Execute(_bstr_t(strsql), NULL, adCmdText);
strCount = (LPCSTR)_bstr_t(m_pRs->GetCollect("nCount"));
if (strCount != "1")
{
MessageBox("将要删除的操作员不存在", "删除信息错误");
return;
}
strsql.Format("delete tb_storageinfo where storagename = '%s' ", strname);
m_pCon->Execute(_bstr_t(strsql), NULL, adCmdText);
m_dlg3.SetDlgItemText(IDC_STORE_NAME, "");
}
catch(...)
{
MessageBox("删除操作失败", "删除信息错误");
}
MessageBox("删除操作成功", "删除信息");
}
else
{
ADOFLAG = FALSE;
MessageBox("删除操作失败 数据库连接失败", "删除信息错误");
}
}
break;
case 3:
{
CAaaApp *pApp = (CAaaApp *)AfxGetApp();
if (pApp->iLevel<4)
{
MessageBox("您没有权限删除", "删除错误信息");
return;
}
if (ADOFLAG)
{
int nIndex = 0;
try
{
CString strname, strCount;
m_dlg4.GetDlgItemText(IDC_ID, strname);
strsql.Format("select count(*) as nCount from tb_providerinfo where providername = '%s' ", strname);
m_pRs = m_pCon->Execute(_bstr_t(strsql), NULL, adCmdText);
strCount = (LPCSTR)_bstr_t(m_pRs->GetCollect("nCount"));
if (strCount != "1")
{
MessageBox("将要删除的操作员不存在", "删除信息错误");
return;
}
strsql.Format("delete tb_providerinfo where providername = '%s' ", strname);
m_pCon->Execute(_bstr_t(strsql), NULL, adCmdText);
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, "");
}
catch(...)
{
MessageBox("删除操作失败", "删除信息错误");
}
MessageBox("删除操作成功", "删除信息");
}
else
{
ADOFLAG = FALSE;
MessageBox("删除操作失败", "删除信息错误");
}
}
break;
default:
break;
}
}
void CDlgBaseInfoM::OnFirst()
{
int iCur = m_tab.GetCurSel();
switch(iCur)
{
case 0:
{
int size = strData.size();
if (size <= 0)
{
m_dlg1.SetDlgItemText(IDC_NAME, "");
m_dlg1.SetDlgItemText(IDC_PASSWORD, "");
m_dlg1.SetDlgItemText(IDC_COMB_JB, "");
}
else
{
iDataIndex = 1;
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);
}
}
break;
case 1:
{
int size = strData1.size();
if (size <= 0)
{
m_dlg2.SetDlgItemText(IDC_ID, "");
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, "");
}
else
{
iDataIndex1 = 1;
m_dlg2.SetDlgItemText(IDC_ID, strData1[0].strID);
m_dlg2.SetDlgItemText(IDC_PRO_NAME, strData1[0].strProductorName);
m_dlg2.SetDlgItemText(IDC_RULE, strData1[0].strRuler);
m_dlg2.SetDlgItemText(IDC_ZJCODE, strData1[0].strZHjCode);
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -