?? findrepaired.cpp
字號:
}
var = m_pRecordset->GetFieldValue(12);
if(CCrack::strVARIANT(var)=="FALSE")
{
m_pRecordset->MoveNext();
continue;
}
var = m_pRecordset->GetFieldValue(0);
m_CtrlList.InsertItem(nItem,CCrack::strVARIANT(var));
for (i=0; i < nFields; i++)
{
var = m_pRecordset->GetFieldValue(i);
if(i>=2)
{
m_CtrlList.SetItemText( nItem,i+2,CCrack::strVARIANT(var));
}
if(i==1)
m_CtrlList.SetItemText( nItem,i,CCrack::strVARIANT(var));
}
CDaoRecordset *m_pSet;
m_pSet=new CDaoRecordset(m_pDatabase);
var = m_pRecordset->GetFieldValue(1);
select.Format("select 資產(chǎn)編號,資產(chǎn)名稱 from 資產(chǎn)信息 where 資產(chǎn)ID=%d",atoi(CCrack::strVARIANT(var)));
try{
m_pSet->Open(dbOpenDynaset,select);
var = m_pSet->GetFieldValue(0);
m_CtrlList.SetItemText( nItem,2,CCrack::strVARIANT(var));
var = m_pSet->GetFieldValue(1);
m_CtrlList.SetItemText( nItem,3,CCrack::strVARIANT(var));
m_pSet->Close();
}
catch(CDaoException* e){
m_CtrlList.SetItemText( nItem,2,"該項已刪除");
m_CtrlList.SetItemText( nItem,3,"該項已刪除");
e->Delete();}
m_pRecordset->MoveNext();
nItem++;
}
}
catch (CDaoException* e)
{
e->ReportError();
e->Delete();
return;
}
}
void CFindRepaired::OnFdrdCksddate()
{
// TODO: Add your control notification handler code here
UpdateData(1);
if(!m_CKSDDate)
{
m_SDDate1=CTime::GetCurrentTime();
m_SDDate2=CTime::GetCurrentTime();
UpdateData(0);
(CComboBox*)GetDlgItem(IDC_FDRD_SDDATE1)->EnableWindow(0);
(CComboBox*)GetDlgItem(IDC_FDRD_SDDATE2)->EnableWindow(0);
}
else
{
(CComboBox*)GetDlgItem(IDC_FDRD_SDDATE1)->EnableWindow(1);
(CComboBox*)GetDlgItem(IDC_FDRD_SDDATE2)->EnableWindow(1);
}
}
void CFindRepaired::OnFdrdCkrddate()
{
// TODO: Add your control notification handler code here
UpdateData(1);
if(!m_CKRDDate)
{
m_RDDate1=CTime::GetCurrentTime();
m_RDDate2=CTime::GetCurrentTime();
UpdateData(0);
(CComboBox*)GetDlgItem(IDC_FDRD_RDDATE1)->EnableWindow(0);
(CComboBox*)GetDlgItem(IDC_FDRD_RDDATE2)->EnableWindow(0);
}
else
{
(CComboBox*)GetDlgItem(IDC_FDRD_RDDATE1)->EnableWindow(1);
(CComboBox*)GetDlgItem(IDC_FDRD_RDDATE2)->EnableWindow(1);
}
}
void CFindRepaired::OnFdrdCksum()
{
// TODO: Add your control notification handler code here
UpdateData(1);
if(!m_CKSum)
{
(CComboBox*)GetDlgItem(IDC_FDRD_SUM1)->EnableWindow(0);
(CComboBox*)GetDlgItem(IDC_FDRD_SUM2)->EnableWindow(0);
m_dSum1=0;
m_dSum2=0;
UpdateData(0);
}
else
{
(CComboBox*)GetDlgItem(IDC_FDRD_SUM1)->EnableWindow(1);
(CComboBox*)GetDlgItem(IDC_FDRD_SUM2)->EnableWindow(1);
}
}
void CFindRepaired::OnFdrdCkname()
{
// TODO: Add your control notification handler code here
UpdateData(1);
if(!m_CKName)
{
m_strName.Empty();
UpdateData(0);
(CComboBox*)GetDlgItem(IDC_FDRD_NAME)->EnableWindow(0);
}
else
{
(CComboBox*)GetDlgItem(IDC_FDRD_NAME)->EnableWindow(1);
}
}
void CFindRepaired::OnFdrdCkassetid()
{
// TODO: Add your control notification handler code here
UpdateData(1);
if(!m_CKAssetID)
{
m_strAssetID.Empty();
UpdateData(0);
(CComboBox*)GetDlgItem(IDC_FDRD_ASSETID)->EnableWindow(0);
}
else
{
(CComboBox*)GetDlgItem(IDC_FDRD_ASSETID)->EnableWindow(1);
}
}
void CFindRepaired::OnFdrdCktype()
{
// TODO: Add your control notification handler code here
UpdateData(1);
if(!m_CKType)
{
m_strType.Empty();
UpdateData(0);
(CComboBox*)GetDlgItem(IDC_FDRD_TYPE)->EnableWindow(0);
}
else
{
(CComboBox*)GetDlgItem(IDC_FDRD_TYPE)->EnableWindow(1);
}
}
void CFindRepaired::OnFdrdCksort()
{
// TODO: Add your control notification handler code here
UpdateData(1);
if(!m_CKSort)
{
m_CtrlCBSort.SetCurSel(-1);
UpdateData(0);
(CComboBox*)GetDlgItem(IDC_FDRD_SORT)->EnableWindow(0);
}
else
{
(CComboBox*)GetDlgItem(IDC_FDRD_SORT)->EnableWindow(1);
}
}
void CFindRepaired::OnFdrdCkrepairer()
{
// TODO: Add your control notification handler code here
UpdateData(1);
if(!m_CKRepairer)
{
m_strRepairer.Empty();
UpdateData(0);
(CComboBox*)GetDlgItem(IDC_FDRD_REPAIRER)->EnableWindow(0);
}
else
{
(CComboBox*)GetDlgItem(IDC_FDRD_REPAIRER)->EnableWindow(1);
}
}
void CFindRepaired::OnFdrdCksender()
{
// TODO: Add your control notification handler code here
UpdateData(1);
if(!m_CKSender)
{
m_strSender.Empty();
UpdateData(0);
(CComboBox*)GetDlgItem(IDC_FDRD_SENDER)->EnableWindow(0);
}
else
{
(CComboBox*)GetDlgItem(IDC_FDRD_SENDER)->EnableWindow(1);
}
}
void CFindRepaired::OnFdrdCkposition()
{
// TODO: Add your control notification handler code here
UpdateData(1);
if(!m_CKPosition)
{
m_strPosition.Empty();
UpdateData(0);
(CComboBox*)GetDlgItem(IDC_FDRD_POSITION)->EnableWindow(0);
}
else
{
(CComboBox*)GetDlgItem(IDC_FDRD_POSITION)->EnableWindow(1);
}
}
void CFindRepaired::OnChangeFdrdSum1()
{
UpdateData(1);
}
void CFindRepaired::OnChangeFdrdSum2()
{
UpdateData(1);
}
void CFindRepaired::OnFdrdFind()
{
UpdateData(1);
if(!m_pDatabase->IsOpen()) return;
if(!m_pRecordset) return;
if(m_pRecordset->IsOpen()) m_pRecordset->Close();
CString sql,strSql="select * from 維修資產(chǎn)";
if(m_CKSender)
{
if(m_strSender.IsEmpty()==0)
{
sql.Format(" where 送修人 like '%s'",m_strSender);
strSql+=sql;
flag1=1;
}
}
if(m_CKRepairer)
{
if(m_strRepairer.IsEmpty()==0)
{
if(flag1)
sql.Format(" and 維修人 like '%s'",m_strRepairer);
else
sql.Format(" where 維修人 like '%s'",m_strRepairer);
strSql+=sql;
flag1=1;
}
}
if(m_CKPosition)
{
if(m_strPosition.IsEmpty()==0)
{
if(flag1)
sql.Format(" and 維修地點(diǎn) like '%s'",m_strPosition);
else
sql.Format(" where 維修地點(diǎn) like '%s'",m_strPosition);
strSql+=sql;
flag1=1;
}
}
if(m_CKSum)
{
if(m_dSum1>m_dSum2)
{
double temp;
temp=m_dSum1;m_dSum1=m_dSum2;m_dSum2=temp;
}
if(flag1)
sql.Format(" and 金額 between %f and %f",m_dSum1,m_dSum2);
else
sql.Format(" where 金額 between %f and %f",m_dSum1,m_dSum2);
strSql+=sql;
flag1=1;
}
if(m_CKName||m_CKSort||m_CKType||m_CKAssetID)
{
if(flag1)
sql.Format(" and 資產(chǎn)ID in (select 資產(chǎn)ID from 資產(chǎn)信息");
else
sql.Format(" where 資產(chǎn)ID in (select 資產(chǎn)ID from 資產(chǎn)信息");
strSql+=sql;
if(m_CKName)
{
if(m_strName.IsEmpty()==0)
{
sql.Format( " where 資產(chǎn)名稱= '%s'",m_strName );
flag2=1;
strSql+=sql;
}
}
if(m_CKAssetID)
{
if(m_strAssetID.IsEmpty()==0)
{
if(flag2)
sql.Format( " and 資產(chǎn)編號 ='%s'",m_strAssetID );
else
sql.Format( " where 資產(chǎn)編號= '%s'",m_strAssetID );
flag2=1;
strSql+=sql;
}
}
if(m_CKType)
{
if(m_strType.IsEmpty()==0)
{
if(flag2)
sql.Format( " and 型號 = '%s'",m_strType );
else
sql.Format( " where 型號= '%s'",m_strType );
flag2=1;
strSql+=sql;
}
}
if(m_CKSort)
{
if(m_CtrlCBSort.GetCurSel()!=-1)
{
if(flag2)
sql.Format( " and 資產(chǎn)類別ID=%d",m_CtrlCBSort.GetItemData(m_CtrlCBSort.GetCurSel()) );
else
sql.Format( " where 資產(chǎn)類別ID=%d",m_CtrlCBSort.GetItemData(m_CtrlCBSort.GetCurSel()) );
flag2=1;
strSql+=sql;
}
}
sql=")";
strSql+=sql;
}
flag1=0;
flag2=0;
Refresh(strSql);
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -