📄 salecontract.cpp
字号:
}
}
m_pContractTypeRecordset->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_planIDCombo.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_sellorCombo.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();
flag=1;
bt_addLine->EnableWindow(true);
if(m_contractList.GetItemCount()>=1)
bt_deleteLine->EnableWindow(true);
else
bt_deleteLine->EnableWindow(false);
tx_planID->EnableWindow(true);
tx_formDate->EnableWindow(true);
tx_saleType->EnableWindow(true);
tx_department->EnableWindow(true);
tx_clientName->EnableWindow(true);
tx_contractType->EnableWindow(true);
tx_seller->EnableWindow(true);
tx_companyContractPerson->EnableWindow(true);
tx_transportType->EnableWindow(true);
tx_consignmentAddress->EnableWindow(true);
tx_clientContractPerson->EnableWindow(true);
tx_payCondition->EnableWindow(true);
tx_subscription->EnableWindow(true);
tx_contractEndDate->EnableWindow(true);
tx_remark->EnableWindow(true);
tx_contractID->EnableWindow(true);
bt_nextPage->EnableWindow(false);
bt_firstPage->EnableWindow(false);
bt_prevPage->EnableWindow(false);
bt_lastPage->EnableWindow(false);
bt_modify->EnableWindow(false);
bt_delete->EnableWindow(false);
bt_save->EnableWindow(true);
int saleContractID=((CSaleApp*)AfxGetApp())->m_pIDRecordset->GetCollect("saleContractID").intVal;
if(saleContractID<10)
m_contractID.Format("saleContract0000%d",saleContractID);
else if(saleContractID<100&&saleContractID>9)
m_contractID.Format("saleContract000%d",saleContractID);
else if(saleContractID<1000&&saleContractID>99)
m_contractID.Format("saleContract00%d",saleContractID);
CString str;
str.Format("%d",saleContractID+1);
((CSaleApp*)AfxGetApp())->m_pIDRecordset->PutCollect("saleContractID",_variant_t(str));
((CSaleApp*)AfxGetApp())->m_pIDRecordset->Update();
m_planID = _T("");
m_formDate = COleDateTime::GetCurrentTime();
m_saleType = _T("");
m_department = _T("");
m_clientName = _T("");
m_contractType = _T("");
m_seller = _T("");
m_companyContractPerson = _T("");
m_transportType = _T("");
m_consignmentAddress = _T("");
m_clientContractPerson = _T("");
m_payCondition = _T("");
m_subscription = 0.0f;
m_contractEndDate = COleDateTime::GetCurrentTime();
m_remark = _T("");
// m_contractID = _T("");
UpdateData(false);
}
void CSaleContract::OnModify()
{
CString str;
if(m_psaleContractRecordset->adoEOF)
m_psaleContractRecordset->MovePrevious();
str=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_psaleContractRecordset->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"));
while(!(m_pClientRecordset->adoEOF))
{
m_clientCombo.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 contractType";
_RecordsetPtr m_pContractTypeRecordset;
hTRes = m_pContractTypeRecordset.CreateInstance(_T("ADODB.Recordset"));
if (SUCCEEDED(hTRes))
{
hTRes = m_pContractTypeRecordset->Open((LPTSTR)strSQL.GetBuffer(130),
((CSaleApp*)AfxGetApp())->m_pConn.GetInterfacePtr(),
adOpenDynamic,adLockPessimistic,adCmdText);
if(SUCCEEDED(hTRes))
{
TRACE(_T("连接成功!\n"));
while(!(m_pContractTypeRecordset->adoEOF))
{
m_contractTypeCombo.AddString(((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pContractTypeRecordset->GetCollect("contractTypeName")));
m_pContractTypeRecordset->MoveNext();
}
}
}
m_pContractTypeRecordset->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_planIDCombo.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_sellorCombo.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();
flag=2;
tx_planID->EnableWindow(true);
tx_formDate->EnableWindow(true);
tx_saleType->EnableWindow(true);
tx_department->EnableWindow(true);
tx_clientName->EnableWindow(true);
tx_contractType->EnableWindow(true);
tx_seller->EnableWindow(true);
tx_companyContractPerson->EnableWindow(true);
tx_transportType->EnableWindow(true);
tx_consignmentAddress->EnableWindow(true);
tx_clientContractPerson->EnableWindow(true);
tx_payCondition->EnableWindow(true);
tx_subscription->EnableWindow(true);
tx_contractEndDate->EnableWindow(true);
tx_remark->EnableWindow(true);
tx_contractID->EnableWindow(true);
bt_addLine->EnableWindow(true);
bt_deleteLine->EnableWindow(true);
bt_save->EnableWindow(true);
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -