/// <summary>
/// 测试数据库连接情况，通过查询platinfo中的PlatZhos字段
/// </summary>
private void Wait()
{
SetSqllb("数据库连接测试中", Color.Red);
Thread.Sleep(2000);
try
{
// string n = Myadapter_p.ScalarTest("未启用").ToString();
// if (n != null)
if (MysqlHepler.SqlOpen())
{
SetSqllb("数据库测试通过", Color.Green);
MysqlHepler.SqlClose();
}
else
{
SetSqllb("数据库连接失败(1)", Color.Red);
}
}
catch (Exception)
{
SetSqllb("数据库连接失败(2)", Color.Red);
}
Thread.Sleep(200);
Setwait(false);
}
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);
}
private void Search_Load(object sender, EventArgs e)
{
if (!MysqlHepler.SqlOpen())
{
MessageBox.Show("数据库连接失败！");
}
string sql = "Select * From mygas_manufacture";
DataTable dt = MysqlHepler.SqlReturnDs(sql).Tables[0];
for (int i = 0; i < dt.Rows.Count; i++)
{
CLB_changjia.Items.Add(dt.Rows[i]["ManufactureName"].ToString());
manufacture[dt.Rows[i]["id"].ToString()] = dt.Rows[i]["ManufactureName"].ToString();
}
DGV_MeterInfo.Visible = true;
DGV_result.Visible = false;
DGV_MeterInfo.ClearSelection();
DGV_result.ClearSelection();
AutoSizeColumn(DGV_result);
AutoSizeColumn(DGV_MeterInfo);
}
private void Serach_Click(object sender, EventArgs e)
{
string sql = "Select * From mygas_meter_test WHERE 1=1";
string sql2 = "Select * From mygas_meterplat WHERE 1=1";
if (CB_MeterId.Checked == true)
{
sql += string.Format(@" AND MeterId = '{0}'", TB_MeterId.Text);
sql += string.Format(@" AND MeterId = '{0}'", TB_MeterId.Text);
}
if (CB_Time.Checked == true)
{
sql += string.Format(@" AND MeterTime > '{0}' AND MeterTime < '{1}'", DTP_Start.Value.ToString(), DTP_End.Value.ToString());
}
DataTable dt = MysqlHepler.SqlReturnDs(sql).Tables[0];
DataTable dt2 = MysqlHepler.SqlReturnDs(sql2).Tables[0];
IList <MeterInfo> li = Dt2serch(Dt2listmeter(dt), Dt2distmeterplat(dt2));
DGV_MeterInfo.DataSource = li;
AutoSizeColumn(DGV_MeterInfo);
}
