📄 medicinesalemanagesdlg.cpp
字号:
m_pRecordset1->PutCollect("total",m_pRecordset->GetCollect("total"));
m_pRecordset1->PutCollect("costprice",m_pRecordset->GetCollect("costprice"));
m_pRecordset1->PutCollect("costtotal",m_pRecordset->GetCollect("costtotal"));
m_pRecordset1->PutCollect("taxprice",m_pRecordset->GetCollect("taxprice"));
m_pRecordset1->PutCollect("taxtotal",m_pRecordset->GetCollect("taxtotal"));
m_pRecordset1->PutCollect("batchno",m_pRecordset->GetCollect("batchno"));
m_pRecordset1->PutCollect("makedate",m_pRecordset->GetCollect("makedate"));
m_pRecordset1->PutCollect("validdate",m_pRecordset->GetCollect("validdate"));
m_pRecordset1->PutCollect("commissionflag",m_pRecordset->GetCollect("commissionflag"));
m_pRecordset1->PutCollect("supplier_id",m_pRecordset->GetCollect("supplier_id"));
m_pRecordset1->PutCollect("location_id",m_pRecordset->GetCollect("location_id"));
m_pRecordset1->PutCollect("storetype",m_pRecordset->GetCollect("storetype"));
m_pRecordset1->PutCollect("price_id",m_pRecordset->GetCollect("price_id"));
m_pRecordset1->PutCollect("order_id",m_pRecordset->GetCollect("order_id"));
m_pRecordset1->PutCollect("unitid",m_pRecordset->GetCollect("unitid"));
m_pRecordset1->PutCollect("smb_id",m_pRecordset->GetCollect("smb_id"));
m_pRecordset1->PutCollect("comment",m_pRecordset->GetCollect("comment"));
m_pRecordset1->PutCollect("oldcommissionflag",m_pRecordset->GetCollect("oldcommissionflag"));
m_pRecordset1->PutCollect("jsprice",m_pRecordset->GetCollect("jsprice"));
m_pRecordset1->Update();
if(!(m_pRecordset->adoEOF))
m_pRecordset->MoveNext();
m_progress1.StepIt();
}
m_pRecordset->Close();
m_pRecordset1->Close();
try
{
CString strSQL="SELECT * FROM billidx";
m_pRecordset1->Open((LPTSTR)strSQL.GetBuffer(strSQL.GetLength()+1),
((CMedicineSaleManagesApp*)AfxGetApp())->m_pConn1.GetInterfacePtr(),
adOpenDynamic,adLockPessimistic,adCmdText);
}
catch(_com_error *e)
{
AfxMessageBox(e->ErrorMessage());
}
strSQL="select * from billidx";
m_pRecordset->Open((LPTSTR)strSQL.GetBuffer(strSQL.GetLength()+1),
((CMedicineSaleManagesApp*)AfxGetApp())->m_pConn.GetInterfacePtr(),
adOpenDynamic,adLockPessimistic,adCmdText);
while(!(m_pRecordset->adoEOF))
{
m_pRecordset1->AddNew();
m_pRecordset1->PutCollect("billdate",m_pRecordset->GetCollect("billdate"));
m_pRecordset1->PutCollect("billnumber",m_pRecordset->GetCollect("billnumber"));
m_pRecordset1->PutCollect("billtype",m_pRecordset->GetCollect("billtype"));
m_pRecordset1->PutCollect("a_id",m_pRecordset->GetCollect("a_id"));
m_pRecordset1->PutCollect("c_id",m_pRecordset->GetCollect("c_id"));
m_pRecordset1->PutCollect("e_id",m_pRecordset->GetCollect("e_id"));
m_pRecordset1->PutCollect("sout_id",m_pRecordset->GetCollect("sout_id"));
m_pRecordset1->PutCollect("sin_id",m_pRecordset->GetCollect("sin_id"));
m_pRecordset1->PutCollect("auditman",m_pRecordset->GetCollect("auditman"));
m_pRecordset1->PutCollect("inputman",m_pRecordset->GetCollect("inputman"));
m_pRecordset1->PutCollect("ysmoney",m_pRecordset->GetCollect("ysmoney"));
m_pRecordset1->PutCollect("ssmoney",m_pRecordset->GetCollect("ssmoney"));
m_pRecordset1->PutCollect("quantity",m_pRecordset->GetCollect("quantity"));
m_pRecordset1->PutCollect("taxrate",m_pRecordset->GetCollect("taxrate"));
m_pRecordset1->PutCollect("period",m_pRecordset->GetCollect("period"));
m_pRecordset1->PutCollect("billstates",m_pRecordset->GetCollect("billstates"));
m_pRecordset1->PutCollect("order_id",m_pRecordset->GetCollect("order_id"));
m_pRecordset1->PutCollect("department_id",m_pRecordset->GetCollect("department_id"));
m_pRecordset1->PutCollect("posid",m_pRecordset->GetCollect("posid"));
m_pRecordset1->PutCollect("region_id",m_pRecordset->GetCollect("region_id"));
m_pRecordset1->PutCollect("auditdate",m_pRecordset->GetCollect("auditdate"));
m_pRecordset1->PutCollect("skdate",m_pRecordset->GetCollect("skdate"));
m_pRecordset1->PutCollect("jsye",m_pRecordset->GetCollect("jsye"));
m_pRecordset1->PutCollect("jsflag",m_pRecordset->GetCollect("jsflag"));
//m_pRecordset1->PutCollect("note",m_pRecordset->GetCollect("note"));
//m_pRecordset1->PutCollect("summary",m_pRecordset->GetCollect("summary"));
//m_pRecordset1->PutCollect("invoice",m_pRecordset->GetCollect("invoice"));
//m_pRecordset1->PutCollect("transcount",m_pRecordset->GetCollect("transcount"));
//m_pRecordset1->PutCollect("lasttranstime",m_pRecordset->GetCollect("lasttranstime"));
//m_pRecordset1->PutCollect("GUID",m_pRecordset->GetCollect("GUID"));
//m_pRecordset1->PutCollect("InvoiceTotal",m_pRecordset->GetCollect("InvoiceTotal"));
//m_pRecordset1->PutCollect("InvoiceNO",m_pRecordset->GetCollect("InvoiceNO"));
m_pRecordset1->PutCollect("BusinessType",m_pRecordset->GetCollect("BusinessType"));
m_pRecordset1->Update();
if(!(m_pRecordset->adoEOF))
m_pRecordset->MoveNext();
m_progress1.StepIt();
}
m_pRecordset->Close();
m_pRecordset1->Close();*/
try
{
CString strSQL="SELECT * FROM price";
m_pRecordset1->Open((LPTSTR)strSQL.GetBuffer(strSQL.GetLength()+1),
((CMedicineSaleManagesApp*)AfxGetApp())->m_pConn1.GetInterfacePtr(),
adOpenDynamic,adLockPessimistic,adCmdText);
}
catch(_com_error *e)
{
AfxMessageBox(e->ErrorMessage());
}
strSQL="select * from price";
m_pRecordset->Open((LPTSTR)strSQL.GetBuffer(strSQL.GetLength()+1),
((CMedicineSaleManagesApp*)AfxGetApp())->m_pConn.GetInterfacePtr(),
adOpenDynamic,adLockPessimistic,adCmdText);
while(!(m_pRecordset->adoEOF))
{
m_pRecordset1->AddNew();
m_pRecordset1->PutCollect("p_id",m_pRecordset->GetCollect("p_id"));
m_pRecordset1->PutCollect("u_id",m_pRecordset->GetCollect("u_id"));
m_pRecordset1->PutCollect("retailprice",m_pRecordset->GetCollect("retailprice"));
m_pRecordset1->PutCollect("recprice",m_pRecordset->GetCollect("recprice"));
m_pRecordset1->PutCollect("price1",m_pRecordset->GetCollect("price1"));
m_pRecordset1->PutCollect("price2",m_pRecordset->GetCollect("price2"));
m_pRecordset1->PutCollect("price3",m_pRecordset->GetCollect("price3"));
m_pRecordset1->PutCollect("price4",m_pRecordset->GetCollect("price4"));
m_pRecordset1->PutCollect("gpprice",m_pRecordset->GetCollect("gpprice"));
m_pRecordset1->PutCollect("glprice",m_pRecordset->GetCollect("glprice"));
m_pRecordset1->PutCollect("specialprice",m_pRecordset->GetCollect("specialprice"));
m_pRecordset1->PutCollect("unittype",m_pRecordset->GetCollect("unittype"));
m_pRecordset1->PutCollect("lowprice",m_pRecordset->GetCollect("lowprice"));
//m_pRecordset1->PutCollect("ModifyDate",m_pRecordset->GetCollect("ModifyDate"));
m_pRecordset1->PutCollect("lastprice",m_pRecordset->GetCollect("lastprice"));
m_pRecordset1->PutCollect("lasttime",m_pRecordset->GetCollect("lasttime"));
m_pRecordset1->PutCollect("billid",m_pRecordset->GetCollect("billid"));
m_pRecordset1->Update();
if(!(m_pRecordset->adoEOF))
m_pRecordset->MoveNext();
m_progress1.StepIt();
}
m_pRecordset->Close();
m_pRecordset1->Close();
try
{
CString strSQL="SELECT * FROM unit";
m_pRecordset1->Open((LPTSTR)strSQL.GetBuffer(strSQL.GetLength()+1),
((CMedicineSaleManagesApp*)AfxGetApp())->m_pConn1.GetInterfacePtr(),
adOpenDynamic,adLockPessimistic,adCmdText);
}
catch(_com_error *e)
{
AfxMessageBox(e->ErrorMessage());
}
strSQL="select * from unit";
m_pRecordset->Open((LPTSTR)strSQL.GetBuffer(strSQL.GetLength()+1),
((CMedicineSaleManagesApp*)AfxGetApp())->m_pConn.GetInterfacePtr(),
adOpenDynamic,adLockPessimistic,adCmdText);
while(!(m_pRecordset->adoEOF))
{
m_pRecordset1->AddNew();
m_pRecordset1->PutCollect("unit_id",m_pRecordset->GetCollect("unit_id"));
m_pRecordset1->PutCollect("name",m_pRecordset->GetCollect("name"));
//m_pRecordset1->PutCollect("ModifyDate",m_pRecordset->GetCollect("ModifyDate"));
m_pRecordset1->PutCollect("deleted",m_pRecordset->GetCollect("deleted"));
m_pRecordset1->Update();
if(!(m_pRecordset->adoEOF))
m_pRecordset->MoveNext();
m_progress1.StepIt();
}
///写入剂型
m_pRecordset->Close();
m_pRecordset1->Close();
try
{
CString strSQL="SELECT * FROM medtype";
m_pRecordset1->Open((LPTSTR)strSQL.GetBuffer(strSQL.GetLength()+1),
((CMedicineSaleManagesApp*)AfxGetApp())->m_pConn1.GetInterfacePtr(),
adOpenDynamic,adLockPessimistic,adCmdText);
}
catch(_com_error *e)
{
AfxMessageBox(e->ErrorMessage());
}
strSQL="select * from medtype";
m_pRecordset->Open((LPTSTR)strSQL.GetBuffer(strSQL.GetLength()+1),
((CMedicineSaleManagesApp*)AfxGetApp())->m_pConn.GetInterfacePtr(),
adOpenDynamic,adLockPessimistic,adCmdText);
while(!(m_pRecordset->adoEOF))
{
m_pRecordset1->AddNew();
m_pRecordset1->PutCollect("mt_id",m_pRecordset->GetCollect("mt_id"));
m_pRecordset1->PutCollect("mt_code",m_pRecordset->GetCollect("mt_code"));
m_pRecordset1->PutCollect("mt_name",m_pRecordset->GetCollect("mt_name"));
m_pRecordset1->PutCollect("deleted",m_pRecordset->GetCollect("deleted"));
//m_pRecordset1->PutCollect("ModifyDate",m_pRecordset->GetCollect("ModifyDate"));
m_pRecordset1->Update();
if(!(m_pRecordset->adoEOF))
m_pRecordset->MoveNext();
m_progress1.StepIt();
}
///
m_pRecordset->Close();
m_pRecordset1->Close();
m_pRecordset=NULL;
m_pRecordset1=NULL;
NewView();
m_progress1.StepIt();
theApp.m_pConn->Close();
theApp.m_pConn=NULL;
m_progress1.StepIt();
theApp.m_pConn1->Close();
theApp.m_pConn1=NULL;
m_progress1.StepIt();
theApp.CompressDatabase();
m_progress1.StepIt();
theApp.makeaccessdatabase();
m_progress1.StepIt();
theApp.EndWaitCursor();
AfxMessageBox("数据更新完毕!");
m_progress1.SetPos(0);
}
}
void CMedicineSaleManagesDlg::OnEnChangeFindname()//自动根据搜索框中的关键字在数据库中搜索出相应药品名并填入药品名框中
{
m_name.ShowDropDown(FALSE);
m_name.ResetContent();
m_fication.ResetContent();
m_factory.ResetContent();
//
SetDlgItemText(IDC_MONEY,_T(""));
m_number.SetCurSel(-1);
m_unit.SetCurSel(-1);
m_readem.SetCurSel(0);
//
CString vaual,str;
CString strSQL;
GetDlgItemText(IDC_FINDNAME,vaual);
strSQL="select name from products WHERE name LIKE '%["+vaual+"]%'";
HRESULT hTRes;
hTRes = m_pRecordset.CreateInstance(_T("ADODB.Recordset"));
if (SUCCEEDED(hTRes))
{
hTRes = m_pRecordset->Open((LPTSTR)strSQL.GetBuffer(strSQL.GetLength()+1),
((CMedicineSaleManagesApp*)AfxGetApp())->m_pConn1.GetInterfacePtr(),
adOpenDynamic,adLockPessimistic,adCmdText);
while(!(m_pRecordset->adoEOF))
{
str=(LPCSTR)_bstr_t(m_pRecordset->GetCollect("name"));
if(!str.IsEmpty())
m_name.AddString(str);
if(!(m_pRecordset->adoEOF))
m_pRecordset->MoveNext();
}
m_name.ShowDropDown(TRUE);
m_pRecordset->Close();
m_name.ShowDropDown(FALSE);
}
m_pRecordset=NULL;
}
void CMedicineSaleManagesDlg::OnCbnSelchangeName()//列出该药的规格
{
m_fication.ResetContent();
m_factory.ResetContent();
SetDlgItemText(IDC_MONEY,_T(""));
m_number.SetCurSel(-1);
m_unit.SetCurSel(-1);
m_readem.SetCurSel(0);
CString vaual,str;
CString strSQL;
m_name.GetLBText(m_name.GetCurSel(),vaual);
strSQL="select standard from products WHERE name='"+vaual+"'";
HRESULT hTRes;
hTRes = m_pRecordset.CreateInstance(_T("ADODB.Recordset"));
if (SUCCEEDED(hTRes))
{
hTRes = m_pRecordset->Open((LPTSTR)strSQL.GetBuffer(strSQL.GetLength()+1),
((CMedicineSaleManagesApp*)AfxGetApp())->m_pConn1.GetInterfacePtr(),
adOpenDynamic,adLockPessimistic,adCmdText);
while(!(m_pRecordset->adoEOF))
{
str=(LPCSTR)_bstr_t(m_pRecordset->GetCollect("standard"));
if(!str.IsEmpty())
m_fication.AddString(str);
if(!(m_pRecordset->adoEOF))
m_pRecordset->MoveNext();
}
m_pRecordset->Close();
}
m_pRecordset=NULL;
}
void CMedicineSaleManagesDlg::OnCbnSelchangeFication()//列出该规格药品的生的厂家
{
m_factory.ResetContent();
SetDlgItemText(IDC_MONEY,_T(""));
m_number.SetCurSel(-1);
m_unit.SetCurSel(-1);
m_readem.SetCurSel(0);
CString vaual1,vaual2,str;
CString strSQL;
m_name.GetLBText(m_name.GetCurSel(),vaual1);
m_fication.GetLBText(m_fication.GetCurSel(),vaual2);
strSQL="select makearea from products WHERE name='"+vaual1+"'";
strSQL+=" and standard='"+vaual2+"'";
HRESULT hTRes;
hTRes = m_pRecordset.CreateInstance(_T("ADODB.Recordset"));
if (SUCCEEDED(hTRes))
{
hTRes = m_pRecordset->Open((LPTSTR)strSQL.GetBuffer(strSQL.GetLength()+1),
((CMedicineSaleManagesApp*)AfxGetApp())->m_pConn1.GetInterfacePtr(),
adOpenDynamic,adLockPessimistic,adCmdText);
while(!(m_pRecordset->adoEOF))
{
str=(LPCSTR)_bstr_t(m_pRecordset->GetCollect("makearea"));
if(!str.IsEmpty())
m_factory.AddString(str);
if(!(m_pRecordset->adoEOF))
m_pRecordset->MoveNext();
}
m_pRecordset->Close();
}
m_pRecordset=NULL;
}
void CMedicineSaleManagesDlg::OnCbnSelchangeFactory()//列出该药的价格及单位
{
SetDlgItemText(IDC_MONEY,_T(""));
m_number.SetCurSel(-1);
m_unit.SetCurSel(-1);
m_readem.SetCurSel(0);
CString vaual0,vaual1,vaual2,str0,str1;
CString strSQL;
m_name.GetLBText(m_name.GetCurSel(),vaual0);
m_fication.GetLBText(m_fication.GetCurSel(),vaual1);
m_factory.GetLBText(m_factory.GetCurSel(),vaual2);
strSQL="select productdetail.price,productdetail.comment from productdetail,products WHERE products.name='"+vaual0+"'";
strSQL+=" and products.standard='"+vaual1+"'";
strSQL+=" and products.makearea='"+vaual2+"'";
strSQL+=" and products.product_id=productdetail.p_id";
HRESULT hTRes;
hTRes = m_pRecordset.CreateInstance(_T("ADODB.Recordset"));
if (SUCCEEDED(hTRes))
{
hTRes = m_pRecordset->Open((LPTSTR)strSQL.GetBuffer(strSQL.GetLength()+1),
((CMedicineSaleManagesApp*)AfxGetApp())->m_pConn1.GetInterfacePtr(),
adOpenDynamic,adLockPessimistic,adCmdText);
if(!(m_pRecordset->adoEOF))
{
str0=(LPCSTR)_bstr_t(m_pRecordset->GetCollect("price"));
str1=(LPCSTR)_bstr_t(m_pRecordset->GetCollect("comment"));
CString strf;
strf.Format("￥%f",atof(str0));
if(!str0.IsEmpty())
SetDlgItemText(IDC_STATICMONEYTEXT,strf.Left(strf.Find('.',0)+1)+strf.Mid(strf.Find('.',0)+1,2));
else
SetDlgItemText(IDC_STATICMONEYTEXT,_T("￥error"));
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -