📄 consignmentinvoice.cpp
字号:
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"));
// CComboBox clientList=GetDlgItem(IDC_client);
// AfxMessageBox(((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pClientRecordset->GetCollect("clientID")));
while(!(m_pDepartmentRecordset->adoEOF))
{
m_departmentCombo.AddString(((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pDepartmentRecordset->GetCollect("departmentName")));
m_pDepartmentRecordset->MoveNext();
}
}
}
m_pDepartmentRecordset->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"));
// CComboBox clientList=GetDlgItem(IDC_client);
// AfxMessageBox(((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pClientRecordset->GetCollect("clientID")));
while(!(m_pSaleTypeRecordset->adoEOF))
{
m_saleTypeCombo.AddString(((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pSaleTypeRecordset->GetCollect("saleTypeName")));
m_pSaleTypeRecordset->MoveNext();
}
}
}
m_pSaleTypeRecordset->Close();
strSQL="select * from orderForm";
_RecordsetPtr m_pOrderFormRecordset;
hTRes = m_pOrderFormRecordset.CreateInstance(_T("ADODB.Recordset"));
if (SUCCEEDED(hTRes))
{
//----------------------------------------------------
hTRes = m_pOrderFormRecordset->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_pOrderFormRecordset->adoEOF))
{
m_orderFormIDCombo.AddString(((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pOrderFormRecordset->GetCollect("quoteID")));
m_pOrderFormRecordset->MoveNext();
}
}
}
m_pOrderFormRecordset->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"));
// CComboBox clientList=GetDlgItem(IDC_client);
// AfxMessageBox(((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pClientRecordset->GetCollect("clientID")));
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"));
// CComboBox clientList=GetDlgItem(IDC_client);
// AfxMessageBox(((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pClientRecordset->GetCollect("clientID")));
while(!(m_pPayConditionTypeRecordset->adoEOF))
{
m_payConditionCombo.AddString(((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pPayConditionTypeRecordset->GetCollect("payConditionTypeName")));
m_pPayConditionTypeRecordset->MoveNext();
}
}
}
m_pPayConditionTypeRecordset->Close();
strSQL="select * from storeHouse";
_RecordsetPtr m_pStoreHouseRecordset;
hTRes = m_pStoreHouseRecordset.CreateInstance(_T("ADODB.Recordset"));
if (SUCCEEDED(hTRes))
{
//----------------------------------------------------
hTRes = m_pStoreHouseRecordset->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_pStoreHouseRecordset->adoEOF))
{
m_storeHouseCombo.AddString(((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pStoreHouseRecordset->GetCollect("storeHouseID")));
m_pStoreHouseRecordset->MoveNext();
}
}
}
m_pStoreHouseRecordset->Close();
strSQL="select * from transportCompany";
_RecordsetPtr m_pTransportCompanyRecordset;
hTRes = m_pTransportCompanyRecordset.CreateInstance(_T("ADODB.Recordset"));
if (SUCCEEDED(hTRes))
{
//----------------------------------------------------
hTRes = m_pTransportCompanyRecordset->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_pTransportCompanyRecordset->adoEOF))
{
m_transportCompanyCombo.AddString(((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pTransportCompanyRecordset->GetCollect("transportCompanyID")));
m_pTransportCompanyRecordset->MoveNext();
}
}
}
m_pTransportCompanyRecordset->Close();
flag=2;
tx_consignmentFormID->EnableWindow(false);
tx_orderFormID->EnableWindow(true);
tx_formDate->EnableWindow(true);
tx_transportType->EnableWindow(true);
tx_transportCompany->EnableWindow(true);
tx_clientName->EnableWindow(true);
tx_payCondition->EnableWindow(true);
tx_seller->EnableWindow(true);
tx_saleType->EnableWindow(true);
tx_department->EnableWindow(true);
tx_consignmentAddress->EnableWindow(true);
tx_storeHouse->EnableWindow(true);
tx_remark->EnableWindow(true);
}
UpdateData(false);
}
void CConsignmentInvoice::OnNew()
{
bt_checked->EnableWindow(false);
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;
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"));
// CComboBox clientList=GetDlgItem(IDC_client);
// AfxMessageBox(((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pClientRecordset->GetCollect("clientID")));
while(!(m_pDepartmentRecordset->adoEOF))
{
m_departmentCombo.AddString(((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pDepartmentRecordset->GetCollect("departmentName")));
m_pDepartmentRecordset->MoveNext();
}
}
}
m_pDepartmentRecordset->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"));
// CComboBox clientList=GetDlgItem(IDC_client);
// AfxMessageBox(((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pClientRecordset->GetCollect("clientID")));
while(!(m_pSaleTypeRecordset->adoEOF))
{
m_saleTypeCombo.AddString(((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pSaleTypeRecordset->GetCollect("saleTypeName")));
m_pSaleTypeRecordset->MoveNext();
}
}
}
m_pSaleTypeRecordset->Close();
strSQL="select * from orderForm where checked='T'";
_RecordsetPtr m_pOrderFormRecordset;
hTRes = m_pOrderFormRecordset.CreateInstance(_T("ADODB.Recordset"));
if (SUCCEEDED(hTRes))
{
//----------------------------------------------------
hTRes = m_pOrderFormRecordset->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_pOrderFormRecordset->adoEOF))
{
m_orderFormIDCombo.AddString(((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pOrderFormRecordset->GetCollect("quoteID")));
m_pOrderFormRecordset->MoveNext();
}
}
}
m_pOrderFormRecordset->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();
strSQL="select * from storeHouse";
_RecordsetPtr m_pStoreHouseRecordset;
hTRes = m_pStoreHouseRecordset.CreateInstance(_T("ADODB.Recordset"));
if (SUCCEEDED(hTRes))
{
hTRes = m_pStoreHouseRecordset->Open((LPTSTR)strSQL.GetBuffer(130),
((CSaleApp*)AfxGetApp())->m_pConn.GetInterfacePtr(),
adOpenDynamic,adLockPessimistic,adCmdText);
if(SUCCEEDED(hTRes))
{
TRACE(_T("连接成功!\n"));
while(!(m_pStoreHouseRecordset->adoEOF))
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -