📄 saleorderform.cpp
字号:
m_companyContractPerson=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pOrderFormRecordset->GetCollect("companyContractPerson"));
m_saleType=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pOrderFormRecordset->GetCollect("saleType"));
m_clientContractPerson=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pOrderFormRecordset->GetCollect("clientContractPerson"));
m_subscription=atof(((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pOrderFormRecordset->GetCollect("subscription")));
m_transportType=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pOrderFormRecordset->GetCollect("transportType"));
m_clientName=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pOrderFormRecordset->GetCollect("clientName"));
m_seller=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pOrderFormRecordset->GetCollect("seller"));
m_department=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pOrderFormRecordset->GetCollect("department"));
m_payCondition=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pOrderFormRecordset->GetCollect("payCondition"));
m_consignmentAddress=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pOrderFormRecordset->GetCollect("consignmentAddress"));
DATE dt;
COleDateTime da;
dt=m_pOrderFormRecordset->GetCollect("formDate").date;
da=COleDateTime(dt);
m_formDate.SetDate(da.GetYear(),da.GetMonth(),da.GetDay());
m_remark=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pOrderFormRecordset->GetCollect("remark"));
CString checked;
checked=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pOrderFormRecordset->GetCollect("checked"));
if(checked=="T")
{
bt_modify->EnableWindow(false);
SetDlgItemText(IDC_auditing,"弃审");
}
else
{
bt_modify->EnableWindow(true);
SetDlgItemText(IDC_auditing,"审核");
}
strSQL="select * from orderFormView where orderFormID='";
strSQL=strSQL+((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pOrderFormRecordset->GetCollect("orderFormID"));
strSQL+="'";
}
//---------------------------------------
hTRes = m_pRecordset.CreateInstance(_T("ADODB.Recordset"));
hTRes = m_pRecordset->Open((LPTSTR)strSQL.GetBuffer(130),
((CSaleApp*)AfxGetApp())->m_pConn.GetInterfacePtr(),
adOpenDynamic,adLockPessimistic,adCmdText);
// m_pRecordset->MoveFirst();
int i=0;
m_orderFormList.DeleteAllItems();
while(!(m_pRecordset->adoEOF))
{
m_orderFormList.InsertItem(i,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("commidityID")));
m_orderFormList.SetItemText(i,1,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("commodityName")));
m_orderFormList.SetItemText(i,2,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("standardPrice")));
m_orderFormList.SetItemText(i,3,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("num")));
m_orderFormList.SetItemText(i,4,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("truePrice")));
if (!(m_pRecordset->adoEOF))
{
m_pRecordset->MoveNext();
i++;
}
}
bt_firstPage->EnableWindow(true);
bt_prevPage->EnableWindow(true);
UpdateData(false);
}
void CSaleOrderForm::OnNew()
{
bt_checked->EnableWindow(false);
SetDlgItemText(IDC_auditing,"审核");
CString strSQL;
HRESULT hTRes;
strSQL="select * from client";
_RecordsetPtr m_pClientRecordset;
hTRes = m_pClientRecordset.CreateInstance(_T("ADODB.Recordset"));
if (SUCCEEDED(hTRes))
{
//----------------------------------------------------
hTRes = m_pClientRecordset->Open((LPTSTR)strSQL.GetBuffer(130),
((CSaleApp*)AfxGetApp())->m_pConn.GetInterfacePtr(),
adOpenDynamic,adLockPessimistic,adCmdText);
if(SUCCEEDED(hTRes))
{
TRACE(_T("连接成功!\n"));
while(!(m_pClientRecordset->adoEOF))
{
m_clientNameCombo.AddString(((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pClientRecordset->GetCollect("clientID")));
m_pClientRecordset->MoveNext();
}
}
}
m_pClientRecordset->Close();
strSQL="select * from transportType";
_RecordsetPtr m_pTransportTypeRecordset;
hTRes = m_pTransportTypeRecordset.CreateInstance(_T("ADODB.Recordset"));
if (SUCCEEDED(hTRes))
{
hTRes = m_pTransportTypeRecordset->Open((LPTSTR)strSQL.GetBuffer(130),
((CSaleApp*)AfxGetApp())->m_pConn.GetInterfacePtr(),
adOpenDynamic,adLockPessimistic,adCmdText);
if(SUCCEEDED(hTRes))
{
TRACE(_T("连接成功!\n"));
while(!(m_pTransportTypeRecordset->adoEOF))
{
m_transportTypeCombo.AddString(((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pTransportTypeRecordset->GetCollect("transportTypeName")));
m_pTransportTypeRecordset->MoveNext();
}
}
}
m_pTransportTypeRecordset->Close();
strSQL="select * from department";
_RecordsetPtr m_pDepartmentRecordset;
hTRes = m_pDepartmentRecordset.CreateInstance(_T("ADODB.Recordset"));
if (SUCCEEDED(hTRes))
{
hTRes = m_pDepartmentRecordset->Open((LPTSTR)strSQL.GetBuffer(130),
((CSaleApp*)AfxGetApp())->m_pConn.GetInterfacePtr(),
adOpenDynamic,adLockPessimistic,adCmdText);
if(SUCCEEDED(hTRes))
{
TRACE(_T("连接成功!\n"));
while(!(m_pDepartmentRecordset->adoEOF))
{
m_departmentCombo.AddString(((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pDepartmentRecordset->GetCollect("departmentName")));
m_pDepartmentRecordset->MoveNext();
}
}
}
m_pDepartmentRecordset->Close();
strSQL="select * from saleContract where checked='T'";
_RecordsetPtr m_pSaleContractRecordset;
hTRes = m_pSaleContractRecordset.CreateInstance(_T("ADODB.Recordset"));
if (SUCCEEDED(hTRes))
{
//----------------------------------------------------
hTRes = m_pSaleContractRecordset->Open((LPTSTR)strSQL.GetBuffer(130),
((CSaleApp*)AfxGetApp())->m_pConn.GetInterfacePtr(),
adOpenDynamic,adLockPessimistic,adCmdText);
if(SUCCEEDED(hTRes))
{
TRACE(_T("连接成功!\n"));
while(!(m_pSaleContractRecordset->adoEOF))
{
m_contractIDCombo.AddString(((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pSaleContractRecordset->GetCollect("contractID")));
m_pSaleContractRecordset->MoveNext();
}
}
}
m_pSaleContractRecordset->Close();
strSQL="select * from saleType";
_RecordsetPtr m_pSaleTypeRecordset;
hTRes = m_pSaleTypeRecordset.CreateInstance(_T("ADODB.Recordset"));
if (SUCCEEDED(hTRes))
{
//----------------------------------------------------
hTRes = m_pSaleTypeRecordset->Open((LPTSTR)strSQL.GetBuffer(130),
((CSaleApp*)AfxGetApp())->m_pConn.GetInterfacePtr(),
adOpenDynamic,adLockPessimistic,adCmdText);
if(SUCCEEDED(hTRes))
{
TRACE(_T("连接成功!\n"));
while(!(m_pSaleTypeRecordset->adoEOF))
{
m_saleTypeCombo.AddString(((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pSaleTypeRecordset->GetCollect("saleTypeName")));
m_pSaleTypeRecordset->MoveNext();
}
}
}
m_pSaleTypeRecordset->Close();
strSQL="select * from quote where checked='T'";
_RecordsetPtr m_pQuoteRecordset;
hTRes = m_pQuoteRecordset.CreateInstance(_T("ADODB.Recordset"));
if (SUCCEEDED(hTRes))
{
//----------------------------------------------------
hTRes = m_pQuoteRecordset->Open((LPTSTR)strSQL.GetBuffer(130),
((CSaleApp*)AfxGetApp())->m_pConn.GetInterfacePtr(),
adOpenDynamic,adLockPessimistic,adCmdText);
if(SUCCEEDED(hTRes))
{
TRACE(_T("连接成功!\n"));
while(!(m_pQuoteRecordset->adoEOF))
{
m_quoteIDCombo.AddString(((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pQuoteRecordset->GetCollect("quoteID")));
m_pQuoteRecordset->MoveNext();
}
}
}
m_pQuoteRecordset->Close();
strSQL="select * from staff";
_RecordsetPtr m_pStaffRecordset;
hTRes = m_pStaffRecordset.CreateInstance(_T("ADODB.Recordset"));
if (SUCCEEDED(hTRes))
{
//----------------------------------------------------
hTRes = m_pStaffRecordset->Open((LPTSTR)strSQL.GetBuffer(130),
((CSaleApp*)AfxGetApp())->m_pConn.GetInterfacePtr(),
adOpenDynamic,adLockPessimistic,adCmdText);
if(SUCCEEDED(hTRes))
{
TRACE(_T("连接成功!\n"));
while(!(m_pStaffRecordset->adoEOF))
{
m_sellerCombo.AddString(((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pStaffRecordset->GetCollect("staffID")));
m_pStaffRecordset->MoveNext();
}
}
}
m_pStaffRecordset->Close();
strSQL="select * from payConditionType";
_RecordsetPtr m_pPayConditionTypeRecordset;
hTRes = m_pPayConditionTypeRecordset.CreateInstance(_T("ADODB.Recordset"));
if (SUCCEEDED(hTRes))
{
//----------------------------------------------------
hTRes = m_pPayConditionTypeRecordset->Open((LPTSTR)strSQL.GetBuffer(130),
((CSaleApp*)AfxGetApp())->m_pConn.GetInterfacePtr(),
adOpenDynamic,adLockPessimistic,adCmdText);
if(SUCCEEDED(hTRes))
{
TRACE(_T("连接成功!\n"));
while(!(m_pPayConditionTypeRecordset->adoEOF))
{
m_payConditionCombo.AddString(((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pPayConditionTypeRecordset->GetCollect("payConditionTypeName")));
m_pPayConditionTypeRecordset->MoveNext();
}
}
}
m_pPayConditionTypeRecordset->Close();
tx_quoteID->EnableWindow(true);
tx_contractID->EnableWindow(true);
tx_orderFormID->EnableWindow(false);
tx_companyContractPerson->EnableWindow(true);
tx_saleType->EnableWindow(true);
tx_clientContractPerson->EnableWindow(true);
tx_subscription->EnableWindow(true);
tx_transportType->EnableWindow(true);
tx_clientName->EnableWindow(true);
tx_seller->EnableWindow(true);
tx_department->EnableWindow(true);
tx_payCondition->EnableWindow(true);
tx_consignmentAddress->EnableWindow(true);
tx_formDate->EnableWindow(true);
tx_remark->EnableWindow(true);
m_quoteID = _T("");
m_contractID = _T("");
int saleOrderFormID=((CSaleApp*)AfxGetApp())->m_pIDRecordset->GetCollect("saleOrderFormID").intVal;
if(saleOrderFormID<10)
m_orderFormID.Format("saleOrderForm0000%d",saleOrderFormID);
else if(saleOrderFormID<100&&saleOrderFormID>9)
m_orderFormID.Format("saleOrderForm000%d",saleOrderFormID);
else if(saleOrderFormID<1000&&saleOrderFormID>99)
m_orderFormID.Format("saleOrderForm00%d",saleOrderFormID);
CString str;
str.Format("%d",saleOrderFormID+1);
((CSaleApp*)AfxGetApp())->m_pIDRecordset->PutCollect("saleOrderFormID",_variant_t(str));
((CSaleApp*)AfxGetApp())->m_pIDRecordset->Update();
m_companyContractPerson = _T("");
m_saleType = _T("");
m_clientContractPerson = _T("");
m_subscription = 0.0f;
m_transportType = _T("");
m_clientName = _T("");
m_seller = _T("");
m_department = _T("");
m_payCondition = _T("");
m_consignmentAddress = _T("");
m_formDate = COleDateTime::GetCurrentTime();
m_remark = _T("");
m_orderFormList.DeleteAllItems();
bt_firstPage->EnableWindow(false);
bt_prevPage->EnableWindow(false);
bt_nextPage->EnableWindow(false);
bt_lastPage->EnableWindow(false);
bt_delete->EnableWindow(false);
bt_add->EnableWindow(false);
bt_modify->EnableWindow(false);
bt_save->EnableWindow(true);
bt_addLine->EnableWindow(true);
bt_deleteLine->EnableWindow(true);
bt_cancellation->EnableWindow(true);
flag=1;
UpdateData(false);
}
void CSaleOrderForm::OnModify()
{
CString str;
if(m_pOrderFormRecordset->adoEOF)
m_pOrderFormRecordset->MovePrevious();
str=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pOrderFormRecordset->GetCollect("checked"));
if(str=="T")
{
AfxMessageBox("已经通过审核，不可以修改！");
return;
}
else
{
SetDlgItemText(IDC_auditing,"审核");
CString strSQL;
HRESULT hTRes;
strSQL="select * from client";
_RecordsetPtr m_pClientRecordset;
hTRes = m_pClientRecordset.CreateInstance(_T("ADODB.Recordset"));
if (SUCCEEDED(hTRes))
{
//----------------------------------------------------
hTRes = m_pClientRecordset->Open((LPTSTR)strSQL.GetBuffer(130),
((CSaleApp*)AfxGetApp())->m_pConn.GetInterfacePtr(),
adOpenDynamic,adLockPessimistic,adCmdText);
if(SUCCEEDED(hTRes))
{
TRACE(_T("连接成功!\n"));
// CComboBox clientList=GetDlgItem(IDC_client);
// AfxMessageBox(((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pClientRecordset->GetCollect("clientID")));
while(!(m_pClientRecordset->adoEOF))
{
m_clientNameCombo.AddString(((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pClientRecordset->GetCollect("clientID")));
m_pClientRecordset->MoveNext();
}
}
}
m_pClientRecordset->Close();
strSQL="select * from transportType";
_RecordsetPtr m_pTransportTypeRecordset;
hTRes = m_pTransportTypeRecordset.CreateInstance(_T("ADODB.Recordset"));
if (SUCCEEDED(hTRes))
{
hTRes = m_pTransportTypeRecordset->Open((LPTSTR)strSQL.GetBuffer(130),
((CSaleApp*)AfxGetApp())->m_pConn.GetInterfacePtr(),
adOpenDynamic,adLockPessimistic,adCmdText);
if(SUCCEEDED(hTRes))
{
TRACE(_T("连接成功!\n"));
while(!(m_pTransportTypeRecordset->adoEOF))
{
m_transportTypeCombo.AddString(((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pTransportTypeRecordset->GetCollect("transportTypeName")));
m_pTransportTypeRecordset->MoveNext();
}
}
}
m_pTransportTypeRecordset->Close();
strSQL="select * from department";
_RecordsetPtr m_pDepartmentRecordset;
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -