?? findother.cpp
字號:
item=IdToString(atoi(CCrack::strVARIANT(var)),i);
m_CtrlList.SetItemText( nItem,i,item);
continue;
}
m_CtrlList.SetItemText( nItem,i,CCrack::strVARIANT(var));
}
nItem++;
m_pRecordset->MoveNext();
}
}
catch (CDaoException* e)
{
e->ReportError();
e->Delete();
return;
}
}
CString CFindOther::IdToString(int ID,int Index) //將索引ID轉換為字符
{
CStringArray sa; //資產類別
CUIntArray ua;
bool flag=0;
switch(Index)
{
case 3:sa.Copy(m_saSort);ua.Copy(m_uaSort);break;//資產類別
case 15:sa.Copy(m_saDepartment);ua.Copy(m_uaDepartment);break;//使用部門
case 16:sa.Copy(m_saDepositary);ua.Copy(m_uaDepositary);break;//存放地點
case 17:sa.Copy(m_saAddType);ua.Copy(m_uaAddType);break;//增加方式
case 18:sa.Copy(m_saKeeper);ua.Copy(m_uaKeeper);break;//保管人員
}
int j;
for(j=0;j<ua.GetSize();j++)
{
if(ua[j]==unsigned(ID))
{
flag=1;
break;
}
}
if(flag)
return sa[j];
else
return "!!刪除!!";
}
void CFindOther::OnFdorCkname()
{
// TODO: Add your control notification handler code here
UpdateData(1);
if(!m_CKName)
{
m_strName.Empty();
UpdateData(0);
(CComboBox*)GetDlgItem(IDC_FDOR_NAME)->EnableWindow(0);
}
else
{
(CComboBox*)GetDlgItem(IDC_FDOR_NAME)->EnableWindow(1);
}
}
void CFindOther::OnFdorCkassetid()
{
// TODO: Add your control notification handler code here
UpdateData(1);
if(!m_CKAssetID)
{
m_strAssetID.Empty();
UpdateData(0);
(CComboBox*)GetDlgItem(IDC_FDOR_ASSETID)->EnableWindow(0);
}
else
{
(CComboBox*)GetDlgItem(IDC_FDOR_ASSETID)->EnableWindow(1);
}
}
void CFindOther::OnFdorCksort()
{
// TODO: Add your control notification handler code here
UpdateData(1);
if(!m_CKSort)
{
m_CtrlCBSort.SetCurSel(-1);
UpdateData(0);
(CComboBox*)GetDlgItem(IDC_FDOR_SORT)->EnableWindow(0);
}
else
{
(CComboBox*)GetDlgItem(IDC_FDOR_SORT)->EnableWindow(1);
}
}
void CFindOther::OnFdorCktype()
{
// TODO: Add your control notification handler code here
UpdateData(1);
if(!m_CKType)
{
m_strType.Empty();
UpdateData(0);
(CComboBox*)GetDlgItem(IDC_FDOR_TYPE)->EnableWindow(0);
}
else
{
(CComboBox*)GetDlgItem(IDC_FDOR_TYPE)->EnableWindow(1);
}
}
void CFindOther::OnFdorCklfdate()
{
// TODO: Add your control notification handler code here
UpdateData(1);
if(!m_CKLFDate)
{
m_LFDate1=CTime::GetCurrentTime();
m_LFDate2=CTime::GetCurrentTime();
UpdateData(0);
(CComboBox*)GetDlgItem(IDC_FDOR_LFDATE1)->EnableWindow(0);
(CComboBox*)GetDlgItem(IDC_FDOR_LFDATE2)->EnableWindow(0);
}
else
{
(CComboBox*)GetDlgItem(IDC_FDOR_LFDATE1)->EnableWindow(1);
(CComboBox*)GetDlgItem(IDC_FDOR_LFDATE2)->EnableWindow(1);
}
}
void CFindOther::OnFdorCkindate()
{
// TODO: Add your control notification handler code here
UpdateData(1);
if(!m_CKInDate)
{
m_InDate1=CTime::GetCurrentTime();
m_InDate2=CTime::GetCurrentTime();
UpdateData(0);
(CComboBox*)GetDlgItem(IDC_FDOR_INDATE1)->EnableWindow(0);
(CComboBox*)GetDlgItem(IDC_FDOR_INDATE2)->EnableWindow(0);
}
else
{
(CComboBox*)GetDlgItem(IDC_FDOR_INDATE1)->EnableWindow(1);
(CComboBox*)GetDlgItem(IDC_FDOR_INDATE2)->EnableWindow(1);
}
}
void CFindOther::OnFdorCkyearnum()
{
// TODO: Add your control notification handler code here
UpdateData(1);
if(!m_CKYearNum)
{
(CComboBox*)GetDlgItem(IDC_FDOR_YEARNUM1)->EnableWindow(0);
(CComboBox*)GetDlgItem(IDC_FDOR_YEARNUM2)->EnableWindow(0);
m_nYearNum1=0;
m_nYearNum2=0;
UpdateData(0);
}
else
{
(CComboBox*)GetDlgItem(IDC_FDOR_YEARNUM1)->EnableWindow(1);
(CComboBox*)GetDlgItem(IDC_FDOR_YEARNUM2)->EnableWindow(1);
}
}
void CFindOther::OnFdorCkaddtype()
{
// TODO: Add your control notification handler code here
UpdateData(1);
if(!m_CKAddType)
{
m_CtrlCBAddType.SetCurSel(-1);
UpdateData(0);
(CComboBox*)GetDlgItem(IDC_FDOR_ADDTYPE)->EnableWindow(0);
}
else
{
(CComboBox*)GetDlgItem(IDC_FDOR_ADDTYPE)->EnableWindow(1);
}
}
void CFindOther::OnFdorCkuseinfo()
{
// TODO: Add your control notification handler code here
UpdateData(1);
if(!m_CKUseInfo)
{
m_strUseInfo.Empty();
UpdateData(0);
(CComboBox*)GetDlgItem(IDC_FDOR_USEINFO)->EnableWindow(0);
}
else
{
(CComboBox*)GetDlgItem(IDC_FDOR_USEINFO)->EnableWindow(1);
}
}
void CFindOther::OnFdorCkdepartment()
{
// TODO: Add your control notification handler code here
UpdateData(1);
if(!m_CKDepartment)
{
m_CtrlCBDepartment.SetCurSel(-1);
UpdateData(0);
(CComboBox*)GetDlgItem(IDC_FDOR_DEPARTMENT)->EnableWindow(0);
}
else
{
(CComboBox*)GetDlgItem(IDC_FDOR_DEPARTMENT)->EnableWindow(1);
}
}
void CFindOther::OnFdorCkinterid()
{
// TODO: Add your control notification handler code here
UpdateData(1);
if(!m_CKInterID)
{
m_strInterID.Empty();
UpdateData(0);
(CComboBox*)GetDlgItem(IDC_FDOR_INTERID)->EnableWindow(0);
}
else
{
(CComboBox*)GetDlgItem(IDC_FDOR_INTERID)->EnableWindow(1);
}
}
void CFindOther::OnFdorCkposition()
{
// TODO: Add your control notification handler code here
UpdateData(1);
if(!m_CKPosition)
{
m_CtrlCBPosition.SetCurSel(-1);
UpdateData(0);
(CComboBox*)GetDlgItem(IDC_FDOR_POSITION)->EnableWindow(0);
}
else
{
(CComboBox*)GetDlgItem(IDC_FDOR_POSITION)->EnableWindow(1);
}
}
void CFindOther::OnFdorCkkeeper()
{
// TODO: Add your control notification handler code here
UpdateData(1);
if(!m_CKKeeper)
{
m_CtrlCBKeeper.SetCurSel(-1);
UpdateData(0);
(CComboBox*)GetDlgItem(IDC_FDOR_KEEPER)->EnableWindow(0);
}
else
{
(CComboBox*)GetDlgItem(IDC_FDOR_KEEPER)->EnableWindow(1);
}
}
void CFindOther::OnChangeFdorYearnum1()
{
UpdateData(1);
}
void CFindOther::OnChangeFdorYearnum2()
{
UpdateData(1);
}
void CFindOther::OnFdorFind()
{
UpdateData(1);
if(!m_pDatabase->IsOpen()) return;
if(!m_pRecordset) return;
if(m_pRecordset->IsOpen()) m_pRecordset->Close();
CString sql,strSql="select * from 資產信息";
if(m_CKName)
{
if(m_strName.IsEmpty()==0)
{
sql.Format( " where 資產名稱= '%s'",m_strName );
flag=1;
strSql+=sql;
}
}
if(m_CKAssetID)
{
if(m_strAssetID.IsEmpty()==0)
{
if(flag)
sql.Format( " and 資產編號 ='%s'",m_strAssetID );
else
sql.Format( " where 資產編號= '%s'",m_strAssetID );
flag=1;
strSql+=sql;
}
}
if(m_CKType)
{
if(m_strType.IsEmpty()==0)
{
if(flag)
sql.Format( " and 型號 = '%s'",m_strType );
else
sql.Format( " where 型號= '%s'",m_strType );
flag=1;
strSql+=sql;
}
}
if(m_CKSort)
{
if(m_CtrlCBSort.GetCurSel()!=-1)
{
if(flag)
sql.Format( " and 資產類別ID=%d",m_CtrlCBSort.GetItemData(m_CtrlCBSort.GetCurSel()) );
else
sql.Format( " where 資產類別ID=%d",m_CtrlCBSort.GetItemData(m_CtrlCBSort.GetCurSel()) );
flag=1;
strSql+=sql;
}
}
if(m_CKAddType)
{
if(m_CtrlCBAddType.GetCurSel()!=-1)
{
if(flag)
sql.Format( " and 增加方式ID=%d",m_CtrlCBAddType.GetItemData(m_CtrlCBAddType.GetCurSel()) );
else
sql.Format( " where 增加方式ID=%d",m_CtrlCBAddType.GetItemData(m_CtrlCBAddType.GetCurSel()) );
flag=1;
strSql+=sql;
}
}
if(m_CKPosition)
{
if(m_CtrlCBPosition.GetCurSel()!=-1)
{
if(flag)
sql.Format( " and 存放地點ID=%d",m_CtrlCBPosition.GetItemData(m_CtrlCBPosition.GetCurSel()) );
sql.Format( " where 存放地點ID=%d",m_CtrlCBPosition.GetItemData(m_CtrlCBPosition.GetCurSel()) );
flag=1;
strSql+=sql;
}
}
if(m_CKDepartment)
{
if(m_CtrlCBDepartment.GetCurSel()!=-1)
{
if(flag)
sql.Format( " and 使用部門ID=%d",m_CtrlCBDepartment.GetItemData(m_CtrlCBDepartment.GetCurSel()) );
else
sql.Format( " where 使用部門ID=%d",m_CtrlCBDepartment.GetItemData(m_CtrlCBDepartment.GetCurSel()) );
flag=1;
strSql+=sql;
}
}
if(m_CKKeeper)
{
if(m_CtrlCBKeeper.GetCurSel()!=-1)
{
if(flag)
sql.Format( " and 保管人員ID=%d",m_CtrlCBKeeper.GetItemData(m_CtrlCBKeeper.GetCurSel()) );
else
sql.Format( " where 保管人員ID=%d",m_CtrlCBKeeper.GetItemData(m_CtrlCBKeeper.GetCurSel()) );
flag=1;
strSql+=sql;
}
}
if(m_CKInterID)
{
if(m_strInterID.IsEmpty()==0)
{
if(flag)
sql.Format( " and 國際編號 = '%s'",m_strInterID );
else
sql.Format( " where 國際編號= '%s'",m_strInterID );
flag=1;
strSql+=sql;
}
}
if(m_CKUseInfo)
{
if(m_strUseInfo.IsEmpty()==0)
{
if(flag)
sql.Format( " and 使用情況 = '%s'",m_strUseInfo );
else
sql.Format( " where 使用情況= '%s'",m_strUseInfo );
flag=1;
strSql+=sql;
}
}
if(m_CKYearNum)
{
if(m_nYearNum1>m_nYearNum2)
{
int temp;
temp=m_nYearNum1;m_nYearNum1=m_nYearNum2;m_nYearNum2=temp;
}
if(flag)
sql.Format(" and 使用年限 between %d and %d",m_nYearNum1,m_nYearNum2);
else
sql.Format(" where 使用年限 between %d and %d",m_nYearNum1,m_nYearNum2);
strSql+=sql;
flag=1;
}
flag=0;
Refresh(strSql);
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -