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