private void BT_over_Click(object sender, EventArgs e)
{
for (int i = 0; i < CLB_changjia.Items.Count; i++)
{
if (CLB_changjia.GetItemChecked(i))
{
CLB_changjia.SetItemChecked(i, false);
}
else
{
CLB_changjia.SetItemChecked(i, true);
}
}
}
private void BT_result_Click(object sender, EventArgs e)
{
string sql = "select * From mygas_meter_result INNER JOIN mygas_manufacture on ManufactureName_id = id WHERE 1=1";
string sql2 = "Select * From mygas_meterplat WHERE 1=1";
if (CB_id.Checked == true)
{
sql += string.Format(@" AND MeterId = '{0}'", TB_ID.Text);
sql += string.Format(@" AND MeterId = '{0}'", TB_ID.Text);
}
if (CB_checktime.Checked == true)
{
sql += string.Format(@" AND CheckTime>'{0}' AND CheckTime<'{1}'", dtp_checktime_start, dtp_chencktime_end);
}
int f = 0;
sql += " AND(1=1";
for (int i = 0; i < CLB_changjia.Items.Count; i++)
{
if (CLB_changjia.GetItemChecked(i))
{
if (f == 0)
{
sql += string.Format(@" AND ManufactureName='{0}'", CLB_changjia.GetItemText(CLB_changjia.Items[i]));
}
else
{
sql += string.Format(@" OR ManufactureName='{0}'", CLB_changjia.GetItemText(CLB_changjia.Items[i]));
}
f++;
}
}
sql += " )";
f = 0;
DataTable dt = MysqlHepler.SqlReturnDs(sql).Tables[0];
DataTable dt2 = MysqlHepler.SqlReturnDs(sql2).Tables[0];
IList <MeterSearch> li = Dt2serch_result(Dt2listmetersearch(dt), Dt2distmeterplat(dt2));
DGV_result.DataSource = li;
AutoSizeColumn(DGV_result);
}