private string strWhere() { RealTimeBLL rtbll = new RealTimeBLL(); //if () string[,] strArray = null; string str = string.Empty; if (chkLead.Checked) { str = string.Format("(select EnumID from EnumTable" + " where FunID = 4 and EnumValue = '1')"); } if (!chkLead.Checked) { strArray = new string[5, 4]{{"cs.CodeSenderAddress","=",txtCodeSender.Text,"int"}, {"ei.EmpName","=",txtEmpName.Text,"string"}, {"ew.WorkTypeID","=",cmbWorkType.SelectedValue.ToString()=="0"?"":cmbWorkType.SelectedValue.ToString(),"int"}, {"enc.DeptID","=",cmbDept.SelectedValue.ToString()=="0"?"":cmbDept.SelectedValue.ToString(),"int"}, {"di.DutyClassID","in",str,"int"} }; } else { strArray = new string[5, 4]{{"cs.CodeSenderAddress","=",txtCodeSender.Text,"int"}, {"ei.EmpName","=",txtEmpName.Text,"string"}, {"ew.WorkTypeID","=",cmbWorkType.SelectedValue.ToString()=="0"?"":cmbWorkType.SelectedValue.ToString(),"int"}, {"enc.DeptID","=",cmbDept.SelectedValue.ToString()=="0"?"":cmbDept.SelectedValue.ToString(),"int"}, {"di.DutyClassID","in",str,"int"} }; } return rtbll.SelectWhere(strArray, 0); }
// 查询 根据标识 描述查询 private void bcpSelect_Click(object sender, EventArgs e) { string[,] strArray = new string[2, 4]{{"DetectionInfo","like",txtD.Text==""?"":(txtD.Text+"%"),"string"}, {"Directional","like",txtWhere.Text==""?"":(txtWhere.Text+"%"),"string"} }; RealTimeBLL rtbll = new RealTimeBLL(); string where = rtbll.SelectWhere(strArray, 1); getInfo(1, where); }
private string strWhere() { RealTimeBLL rtbll = new RealTimeBLL(); string[,] strArray = null; string str = string.Empty; if (chkLead.Checked) { str = string.Format("(select EnumID from EnumTable" + " where FunID = 4 and EnumValue = '1')"); } if (!chkLead.Checked) { if (DeptTree.SelectedNode != null && DeptTree.SelectedNode.Name != "0") { //strArray = new string[4, 4]{{"cs.CodeSenderAddress","=",txtCodeSender.Text,"int"}, // {"ei.EmpName","=",txtEmpName.Text,"string"}, // {"ei.DeptID","=",DeptTree.SelectedNode.Name,"int"}, // {"di.DutyClassID","in",str,"int"} //}; strArray = new string[3, 4]{{"codeSender","=",txtCodeSender.Text,"int"}, {"empName","=",txtEmpName.Text,"string"}, {"deptID","=",DeptTree.SelectedNode.Name,"int"} }; } else { //strArray = new string[3, 4]{{"cs.CodeSenderAddress","=",txtCodeSender.Text,"int"}, // {"ei.EmpName","=",txtEmpName.Text,"string"}, // {"di.DutyClassID","in",str,"int"} //}; strArray = new string[2, 4]{{"codeSender","=",txtCodeSender.Text,"int"}, {"empName","=",txtEmpName.Text,"string"} }; } } else { if (DeptTree.SelectedNode != null && DeptTree.SelectedNode.Name != "0") { strArray = new string[4, 4]{{"cs.CodeSenderAddress","=",txtCodeSender.Text,"int"}, {"ei.EmpName","=",txtEmpName.Text,"string"}, {"ei.DeptID","=",DeptTree.SelectedNode.Name,"int"}, {"di.DutyClassID","in",str,"int"} }; } else { strArray = new string[3, 4]{{"cs.CodeSenderAddress","=",txtCodeSender.Text,"int"}, {"ei.EmpName","=",txtEmpName.Text,"string"}, {"di.DutyClassID","in",str,"int"} }; } } return rtbll.SelectWhere(strArray, 0); }