📄 eq_searchdlg.cpp
字号:
break;
}
j++;
}
if(flag==0)
{
temp[count]=eq_type;
count++;
m_combo2.AddString(eq_type);
}
rs.MoveNext();
}
}
break;
case 4://设备状态
{
m_combo2.ResetContent ();
m_combo2.AddString ("1安装");
m_combo2.AddString ("2使用");
m_combo2.AddString ("3维修");
m_combo2.AddString ("4报废");
}
break;
case 5://购入日期
{
CString temp[100];
int count=0;
m_combo2.ResetContent ();
while(!rs.IsEOF())
{
CString pur_date;
int j=0,flag=0;
rs.GetFieldValue((short)6,pur_date);
pur_date=pur_date.Mid (0,7);
//向列表框中添加所有设备类别
while(j<=count)
{
if(temp[j]==pur_date)
{
flag=1;
break;
}
j++;
}
if(flag==0)
{
temp[count]=pur_date;
count++;
m_combo2.AddString(pur_date);
}
rs.MoveNext();
}
}
break;
case 6://安装日期
{
CString temp[100];
int count=0;
m_combo2.ResetContent ();
while(!rs.IsEOF())
{
CString install_date;
int j=0,flag=0;
rs.GetFieldValue((short)7,install_date);
install_date=install_date.Mid (0,7);
//向列表框中添加所有设备类别
while(j<=count)
{
if(temp[j]==install_date)
{
flag=1;
break;
}
j++;
}
if(flag==0)
{
temp[count]=install_date;
count++;
m_combo2.AddString(install_date);
}
rs.MoveNext();
}
}
break;
case 7://部门编号
{
CString temp[100];
int count=0;
m_combo2.ResetContent ();
while(!rs.IsEOF())
{
CString dep_id;
int j=0,flag=0;
rs.GetFieldValue((short)8,dep_id);
//向列表框中添加所有设备类别
while(j<=count)
{
if(temp[j]==dep_id)
{
flag=1;
break;
}
j++;
}
if(flag==0)
{
temp[count]=dep_id;
count++;
m_combo2.AddString(dep_id);
}
rs.MoveNext();
}
}
break;
case 8://原值
{
CString temp[100];
int count=0;
m_combo2.ResetContent ();
while(!rs.IsEOF())
{
CString eq_val;
int j=0,flag=0;
rs.GetFieldValue((short)9,eq_val);
//向列表框中添加所有设备类别
while(j<=count)
{
if(temp[j]==eq_val)
{
flag=1;
break;
}
j++;
}
if(flag==0)
{
temp[count]=eq_val;
count++;
m_combo2.AddString(eq_val);
}
rs.MoveNext();
}
}
break;
case 9://安装地点
{
CString temp[100];
int count=0;
m_combo2.ResetContent ();
while(!rs.IsEOF())
{
CString fix_place;
int j=0,flag=0;
rs.GetFieldValue((short)10,fix_place);
//向列表框中添加所有设备类别
while(j<=count)
{
if(temp[j]==fix_place)
{
flag=1;
break;
}
j++;
}
if(flag==0)
{
temp[count]=fix_place;
count++;
m_combo2.AddString(fix_place);
}
rs.MoveNext();
}
}
break;
case 10://生产厂
{
CString temp[100];
int count=0;
m_combo2.ResetContent ();
while(!rs.IsEOF())
{
CString manfac;
int j=0,flag=0;
rs.GetFieldValue((short)11,manfac);
//向列表框中添加所有设备类别
while(j<=count)
{
if(temp[j]==manfac)
{
flag=1;
break;
}
j++;
}
if(flag==0)
{
temp[count]=manfac;
count++;
m_combo2.AddString(manfac);
}
rs.MoveNext();
}
}
break;
case 11://使用日期
{
CString temp[100];
int count=0;
m_combo2.ResetContent ();
while(!rs.IsEOF())
{
CString use_date;
int j=0,flag=0;
rs.GetFieldValue((short)12,use_date);
use_date=use_date.Mid (0,7);
//向列表框中添加所有设备类别
while(j<=count)
{
if(temp[j]==use_date)
{
flag=1;
break;
}
j++;
}
if(flag==0)
{
temp[count]=use_date;
count++;
m_combo2.AddString(use_date);
}
rs.MoveNext();
}
}
break;
case 12://使用年限
{
CString temp[100];
int count=0;
m_combo2.ResetContent ();
while(!rs.IsEOF())
{
CString fix_year;
int j=0,flag=0;
rs.GetFieldValue((short)13,fix_year);
//向列表框中添加所有设备类别
while(j<=count)
{
if(temp[j]==fix_year)
{
flag=1;
break;
}
j++;
}
if(flag==0)
{
temp[count]=fix_year;
count++;
m_combo2.AddString(fix_year);
}
rs.MoveNext();
}
}
break;
case 13://残值
{
CString temp[100];
int count=0;
m_combo2.ResetContent ();
while(!rs.IsEOF())
{
CString rem_val;
int j=0,flag=0;
rs.GetFieldValue((short)14,rem_val);
//向列表框中添加所有设备类别
while(j<=count)
{
if(temp[j]==rem_val)
{
flag=1;
break;
}
j++;
}
if(flag==0)
{
temp[count]=rem_val;
count++;
m_combo2.AddString(rem_val);
}
rs.MoveNext();
}
}
break;
case 14://月折旧金额
{
CString temp[100];
int count=0;
m_combo2.ResetContent ();
while(!rs.IsEOF())
{
CString mon_val;
int j=0,flag=0;
rs.GetFieldValue((short)15,mon_val);
//向列表框中添加所有设备类别
while(j<=count)
{
if(temp[j]==mon_val)
{
flag=1;
break;
}
j++;
}
if(flag==0)
{
temp[count]=mon_val;
count++;
m_combo2.AddString(mon_val);
}
rs.MoveNext();
}
}
break;
default:
break;
}
rs.Close();
//更新数据
m_combo2.SetCurSel(0);
UpdateData();
}
void CEq_SEARCHDlg::OnButton1()
{
// TODO: Add your control notification handler code here
UpdateData(TRUE);
CString edit_temp;
edit_temp=m_edit1;
edit_temp+="条件为:"+m_com1+"="+m_com2+"\r\n";
//m_edit1.GetFocus ();
//m_edit1.SetWindowText (edit_temp);
m_edit1=edit_temp;
UpdateData(FALSE);
cond_num++;
condition1[cond_num]=m_com2;
cond_state[cond_num]=m_combo1.GetCurSel ();
}
void CEq_SEARCHDlg::OnButton2()
{
// TODO: Add your control notification handler code here
m_list1.DeleteAllItems();
m_mo.Format("");
m_edit1="";
UpdateData(FALSE);
}
void CEq_SEARCHDlg::OnBUTTONmo()
{
// TODO: Add your control notification handler code here
if(!UpdateData())
return;
m_mo_c.GetWindowText(m_mo);
TRY
{
if(m_mo=="")
{MessageBox("您没有输入查询条件");}
else
{
CRecordset rs(&m_db);
CString sql;
//查询模糊的设备记录
//向界面中显示设备信息
CString temp;
temp.Format(_T("%s"),m_mo);
m_mo="%"+m_mo+"%";
sql.Format("Select * from eq_info where eq_name like '%s'",m_mo );
rs.Open(CRecordset::dynaset,sql);
CString id,name,eq_class_id,eq_type,pur_date,install_date,dep_id,fix_place,manfac,use_date,remark;
int eq_amount,eq_state,fix_year,rem_val,mon_val,eq_val;
CDBVariant var;
while(!rs.IsEOF())
{
rs.GetFieldValue((short)0,id);
rs.GetFieldValue((short)1,name);
rs.GetFieldValue((short)2,eq_class_id);
rs.GetFieldValue((short)3,eq_type);
rs.GetFieldValue((short)4,var,SQL_C_SLONG);
if(var.m_dwType!=DBVT_NULL)
eq_amount=var.m_lVal;
else
eq_amount=0;
var.Clear();
rs.GetFieldValue((short)5,var,SQL_C_SLONG);
if(var.m_dwType!=DBVT_NULL)
eq_state=var.m_lVal;
else
eq_state=0;
var.Clear();
rs.GetFieldValue((short)6,pur_date);
pur_date=pur_date.Mid(0,10);//节取字符串
rs.GetFieldValue((short)7,install_date);
install_date=pur_date.Mid(0,10);
rs.GetFieldValue((short)8,dep_id);
rs.GetFieldValue((short)9,var,SQL_C_SLONG);
if(var.m_dwType!=DBVT_NULL)
eq_val=var.m_lVal;
else
eq_val=0;
var.Clear();
rs.GetFieldValue((short)10,fix_place);
rs.GetFieldValue((short)11,manfac);
rs.GetFieldValue((short)12,use_date);
use_date=pur_date.Mid(0,10);
rs.GetFieldValue((short)13,var,SQL_C_SLONG);
if(var.m_dwType!=DBVT_NULL)
fix_year=var.m_lVal;
else
fix_year=0;
var.Clear();
rs.GetFieldValue((short)14,var,SQL_C_SLONG);
if(var.m_dwType!=DBVT_NULL)
rem_val=var.m_lVal;
else
rem_val=0;
var.Clear();
rs.GetFieldValue((short)15,var,SQL_C_SLONG);
if(var.m_dwType!=DBVT_NULL)
mon_val=var.m_lVal;
else
mon_val=0;
var.Clear();
rs.GetFieldValue((short)16,remark);
InsertEq(id,name,eq_class_id,eq_type,eq_amount,eq_state,pur_date,install_date,dep_id,eq_val,fix_place,manfac,use_date,fix_year,rem_val,mon_val,remark);
rs.MoveNext();
}
rs.Close();
int index=m_list1.GetItemCount();
if(index==0)
{MessageBox("没有您输入查询条件的结果");}
}
}
CATCH(CDBException,ex)
{
AfxMessageBox("问题出在插入");
AfxMessageBox(ex->m_strError);
AfxMessageBox(ex->m_strStateNativeOrigin);
}
AND_CATCH(CMemoryException,pEx)
{
pEx->ReportError();
AfxMessageBox("memory exception");
}
AND_CATCH(CException,e)
{
TCHAR szError[100];
e->GetErrorMessage(szError,100);
AfxMessageBox(szError);
}
END_CATCH
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -