《在pb中设置多条件查询.doc》由会员分享,可在线阅读,更多相关《在pb中设置多条件查询.doc(7页珍藏版)》请在金锄头文库上搜索。
1、在pb中设置多条件查询/定义参数:查询条件综合结果string LookforCondition/定义参数:要查询的列string lookforItem1,lookforItem2,lookforItem3/定义参数:查询的符号string lookforHow1,lookforHow2,lookforHow3/定义参数:要查询的内容string lookforWhat1,lookforWhat2,lookforWhat3/定义参数:不同查询条件组合操作符号string lookforOperator1,lookforOperator2/查询符号的选择lookforHow1=ddlb_4.t
2、extlookforHow2=ddlb_5.textlookforHow3=ddlb_6.text/操作符号1的选择if ddlb_7.text=与 thenlookforOperator1=andelseif ddlb_7.text=或 thenlookforOperator1=orelseif ddlb_7.text=非 thenlookforOperator1=notend if/操作符号2的选择if ddlb_8.text=与 thenlookforOperator2=andelseif ddlb_8.text=或 thenlookforOperator2=orelseif ddlb_
3、8.text=非 thenlookforOperator2=notend if/查询子段1和查询内容1的选择if ddlb_1.text=员工号 thenlookforItem1 =emp_nolookforwhat1=sle_1.textelseif ddlb_1.text=员工姓名 thenlookforItem1=emp_namelookforwhat1=+sle_1.text+elseif ddlb_1.text=部门号 thenlookforItem1=dept_IDlookforwhat1=sle_1.textelseif ddlb_1.text=性别 thenlookforIte
4、m1=emp_genderlookforwhat1=+sle_1.text+elseif ddlb_1.text=出生年月 thenlookforItem1=emp_birthdaylookforwhat1=sle_1.textelseif ddlb_1.text=籍贯 thenlookforItem1=emp_hometownlookforwhat1=+sle_1.text+elseif ddlb_1.text=国籍 thenlookforItem1=emp_countrylookforwhat1=+sle_1.text+elseif ddlb_1.text= 民族 thenlookforI
5、tem1 = emp_nationlookforwhat1=+sle_1.text+elseif ddlb_1.text=身份证号 thenlookforItem1=emp_IDlookforwhat1=sle_1.textelseif ddlb_1.text=婚姻状况 thenlookforItem1=emp_marriagelookforwhat1=+sle_1.text+elseif ddlb_1.text=健康状况 thenlookforItem1=emp_healthlookforwhat1=+sle_1.text+elseif ddlb_1.text=政治面貌 thenlookfo
6、rItem1=emp_zzmmlookforwhat1=+sle_1.text+elseif ddlb_1.text=家庭住址 thenlookforItem1=emp_homeadresslookforwhat1=+sle_1.text+elseif ddlb_1.text=联系电话 thenlookforItem1=emp_TeleNolookforwhat1=sle_1.textlookforwhat1=+sle_1.text+end if/查询子段2和查询内容2的选择if ddlb_2.text=员工号 thenlookforItem2 =emp_nolookforwhat2=sle_
7、2.textelseif ddlb_2.text=员工姓名 thenlookforItem2=emp_namelookforwhat2=+sle_2.text+elseif ddlb_2.text=部门号 thenlookforItem2=dept_IDlookforwhat2=sle_2.textelseif ddlb_2.text=性别 thenlookforItem2=emp_genderlookforwhat2=+sle_2.text+elseif ddlb_2.text=出生年月 thenlookforItem2=emp_birthdaylookforwhat2=sle_2.text
8、elseif ddlb_2.text=籍贯 thenlookforItem2=emp_hometownlookforwhat2=+sle_2.text+elseif ddlb_2.text=国籍 thenlookforItem2=emp_countrylookforwhat2=+sle_2.text+elseif ddlb_2.text= 民族 thenlookforItem2 = emp_nationlookforwhat2=+sle_2.text+elseif ddlb_2.text=身份证号 thenlookforItem2=emp_IDlookforwhat2=sle_2.textel
9、seif ddlb_2.text=婚姻状况 thenlookforItem2=emp_marriagelookforwhat2=+sle_2.text+elseif ddlb_2.text=健康状况 thenlookforItem2=emp_healthlookforwhat2=+sle_2.text+elseif ddlb_2.text=政治面貌 thenlookforItem2=emp_zzmmlookforwhat2=+sle_2.text+elseif ddlb_2.text=家庭住址 thenlookforItem2=emp_homeadresslookforwhat2=+sle_2
10、.text+elseif ddlb_2.text=联系电话 thenlookforItem2=emp_TeleNolookforwhat2=sle_2.textlookforwhat2=+sle_2.text+end if/查询子段3和查询内容3的选择if ddlb_3.text=员工号 thenlookforItem3 =emp_nolookforwhat3=sle_3.textelseif ddlb_3.text=员工姓名 thenlookforItem3=emp_namelookforwhat3=+sle_3.text+elseif ddlb_3.text=部门号 thenlookfor
11、Item3=dept_IDlookforwhat3=sle_3.textelseif ddlb_3.text=性别 thenlookforItem3=emp_genderlookforwhat3=+sle_3.text+elseif ddlb_3.text=出生年月 thenlookforItem3=emp_birthdaylookforwhat3=sle_3.textelseif ddlb_3.text=籍贯 thenlookforItem3=emp_hometownlookforwhat3=+sle_3.text+elseif ddlb_3.text=国籍 thenlookforItem3
12、=emp_countrylookforwhat3=+sle_3.text+elseif ddlb_3.text= 民族 thenlookforItem3 = emp_nationlookforwhat3=+sle_3.text+elseif ddlb_3.text=身份证号 thenlookforItem3=emp_IDlookforwhat3=sle_3.textelseif ddlb_3.text=婚姻状况 thenlookforItem3=emp_marriagelookforwhat3=+sle_3.text+elseif ddlb_3.text=健康状况 thenlookforIte
13、m3=emp_healthlookforwhat3=+sle_3.text+elseif ddlb_3.text=政治面貌 thenlookforItem3=emp_zzmmlookforwhat3=+sle_3.text+elseif ddlb_3.text=家庭住址 thenlookforItem3=emp_homeadresslookforwhat3=+sle_3.text+elseif ddlb_3.text=联系电话 thenlookforItem3=emp_TeleNolookforwhat3=sle_3.textlookforwhat3=+sle_3.text+end if/查询条件的综合if ddlb_1.text= or ddlb_4.text= thenelseif ddlb_2.text= or ddlb_5.text= thenlookforCondition=lookforItem1+lookforHow1+lookforwhat1+elseif ddlb_3.text= or ddlb_6.text= thenlookforCondition=lookforItem1+lookforHow1+lookforwhat1+lo