private void button1_Click(object sender, EventArgs e)
{
try
{
com = comNames.Text.Trim();
XlName = ComUserName.Text.Trim();
comUsers = comUser.Text.Trim();
TxtUlogsS = TxtUlogs.Text.Trim();
comDs = ComDKQ.Text.Trim();
SQbase.ReplaceSQLChar(com);
SQbase.ReplaceSQLChar(XlName);
SQbase.ReplaceSQLChar(comUsers);
SQbase.ReplaceSQLChar(TxtUlogsS);
SQbase.ReplaceSQLChar(Comlogs.Text.Trim());
if (grid == 1)
{
da1 = DateTime.Parse(dpic1.Value.ToString(dati));
da2 = DateTime.Parse(dpic2.Value.ToString(datis));
if (da1 >= da2)
{
MessageBox.Show("开始时间必须小于结束时间", "提示");
}
else
{
string sql = string.Format(" where 1=1");
if (com == "全部")
{
sql += string.Format(@"");
}
else
{
sql += string.Format(@" and holderName='" + com + "'");
}
if (comDs == "全部")
{
sql += string.Format(@"");
}
else
{
sql += string.Format(@" and Name='" + comDs + "'");
}
if (CKBox.Checked != true)
{
sql += string.Format(@" and '" + da2.ToString() + "'>= g.[OPtime] and g.[OPtime] >='" + da1.ToString() + "'");
}
else
{
sql += string.Format(@"");
}
sql += " ORDER BY g.[OPtime] DESC ";
DataGdv.DataSource = SKJLS.Cardlogs_Getdate(sql);
SQbase.Roswtxt(DataGdv, RoswSTxt);
}
}
if (grid == 2)
{
da1 = DateTime.Parse(dpic1.Value.ToString(dati));
da2 = DateTime.Parse(dpic2.Value.ToString(datis));
if (da1 >= da2)
{
MessageBox.Show("开始时间必须小于结束时间", "提示");
}
else
{
string sql = string.Format(" where 1=1");
if (comUsers == "全部")
{
sql += string.Format(@"");
}
else
{
sql += string.Format(@"and ul.[Name] = '" + comUsers + "'");
}
if (!string.IsNullOrEmpty(TxtUlogsS))
{
if (TxtUlogsS == "全部")
{
sql += string.Format(@" and [oEvent] like '%%'");
}
else
{
sql += string.Format(@" and [oEvent] like '%" + TxtUlogsS + "%'");
}
}
if (!string.IsNullOrEmpty(Comlogs.Text.Trim()))
{
if (Comlogs.Text.Trim() == "全部")
{
sql += string.Format(@"");
}
else
{
sql += string.Format(@" and [EventType] like '%" + Comlogs.Text.Trim().ToString() + "%'");
}
}
if (CKBox.Checked != true)
{
sql += string.Format(@" and ('" + da2.ToString() + "'>OPtime and OPtime>'" + da1.ToString() + "')");
}
else
{
sql += string.Format(@"");
}
sql += " order by [OPtime] desc";
DataGdv.DataSource = YHCZJLS.Userlogs_Getdate(sql);
SQbase.Roswtxt(DataGdv, RoswSTxt);
}
}
if (grid == 3)
{
da1 = DateTime.Parse(dpic1.Value.ToString(dati));
da2 = DateTime.Parse(dpic2.Value.ToString(datis));
if (da1 >= da2)
{
MessageBox.Show("开始时间必须小于结束时间", "提示");
}
else
{
string sql = "where 1=1";
if (!string.IsNullOrEmpty(XlName))
{
if (XlName == "全部")
{
sql += string.Format(@"");
}
else
{
sql += string.Format(@" and [Name]='" + XlName + "'");
}
}
if (!string.IsNullOrEmpty(com))
{
if (com == "全部")
{
sql += string.Format(@"");
}
else
{
sql += string.Format(@" and holderName='" + com + "'");
}
}
if (CKBox.Checked != true)
{
sql += string.Format(@" and '" + da2.ToString() + "'>=OPtime and OPtime >='" + da1.ToString() + "'");
}
else
{
sql += string.Format(@"");
}
sql += string.Format(@" order by [OPtime] desc ");
DataGdv.DataSource = XGJLS.Routelogs_getdate(sql);
SQbase.Roswtxt(DataGdv, RoswSTxt);
}
}
if (grid == 4)
{
da1 = DateTime.Parse(dpic1.Value.ToString(dati));
da2 = DateTime.Parse(dpic2.Value.ToString(datis));
if (da1 >= da2)
{
MessageBox.Show("开始时间必须小于结束时间", "提示");
}
else
{
string sql = "";
if (!string.IsNullOrEmpty(XlName))
{
if (XlName == "全部")
{
sql += string.Format(@"");
}
else
{
sql += string.Format(@" and [Name]='" + XlName + "'");
}
}
if (!string.IsNullOrEmpty(com))
{
if (com == "全部")
{
sql += string.Format(@"");
}
else
{
sql += string.Format(@" and [holderName]='" + com + "'");
}
}
if (CKBox.Checked != true)
{
sql += string.Format(@" and '" + da2.ToString() + "'>=OPtime and OPtime >='" + da1.ToString() + "'");
}
else
{
sql += string.Format(@"");
}
sql += string.Format(@" order by [RouteLogID],[order]");
XGXxShowS(DataGdv, sql);
SQbase.Roswtxt(DataGdv, RoswSTxt);
}
}
if (grid == 5)
{
da1 = DateTime.Parse(dpic1.Value.ToString(dati));
da2 = DateTime.Parse(dpic2.Value.ToString(datis));
if (da1 >= da2)
{
MessageBox.Show("开始时间必须小于结束时间", "提示");
}
else
{
string sql = " where [order]=1";
if (!string.IsNullOrEmpty(XlName))
{
if (XlName == "全部")
{
sql += string.Format(@"");
}
else
{
sql += string.Format(@" and t.[Name] ='" + XlName + "'");
}
}
if (!string.IsNullOrEmpty(com))
{
if (com == "全部")
{
sql += string.Format(@"");
}
else
{
sql += string.Format(@" and [holderName]='" + com + "'");
}
}
if (CKBox.Checked != true)
{
sql += string.Format(@" and '" + da2.ToString() + "'> NextActioT and NextActioT>'" + da1.ToString() + "'");
}
else
{
sql += string.Format(@"");
}
sql += string.Format(@" order by Startuptime,e.[RouteID],[Order] ");
XLXGS(DataGdv, sql);
if (!string.IsNullOrEmpty(XlName) && XlName != "全部")
{
DataTable dtco = new DataTable();
dtco = bl.countS(XlName);
foreach (DataRow dr in dtco.Rows)
{
if (dr[0].ToString() != "0")
{
DataGdv.Rows[0].Cells[4].Value = dr[0].ToString();
}
else
{
RoswSTxt.Text = "";
}
}
}
SQbase.Roswtxt(DataGdv, RoswSTxt);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
C#多条件联合查询,多个文本或者下拉的情况下
最新推荐文章于 2022-05-26 11:03:12 发布