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