findother.cpp

一个用vc++做的数据库系统

					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()) );
		  else
               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);	
}