private void dataGridView1_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
string bs = this.dataGridView1.SelectedRows[0].Cells[11].Value.ToString();
if (!"未处理".Equals(bs))
{
string hostcode = this.dataGridView1.SelectedRows[0].Cells[2].Value.ToString();
string metercode = this.dataGridView1.SelectedRows[0].Cells[3].Value.ToString();
string time = this.dataGridView1.SelectedRows[0].Cells[0].Value.ToString();
service.warningCheckService wcs = new service.warningCheckService();
DataTable dtw = wcs.warningCheck(hostcode + "_" + metercode, time);
if (dtw.Rows.Count > 0)
{
warningHandle wh = new warningHandle();
wh.Text = this.dataGridView1.SelectedRows[0].Cells[1].Value.ToString() + "报警处理";
wh.label2.Text = dtw.Rows[0][1].ToString();
wh.textBox1.Text = time;
wh.dateTimePicker1.Value = Convert.ToDateTime(dtw.Rows[0][3].ToString());
wh.textBox3.Text = dtw.Rows[0][4].ToString();
wh.textBox4.Text = dtw.Rows[0][5].ToString();
wh.richTextBox1.Text = dtw.Rows[0][6].ToString();
wh.button1.Visible = false;
wh.button2.Visible = false;
wh.Show();
}
}
else
{
MessageBox.Show("报警未处理！请先处理报警信息。");
}
}
private void button1_Click(object sender, EventArgs e)
{
bean.warningHandleBean whb = new bean.warningHandleBean();
whb.handleUser = this.label2.Text;
whb.warningTime = this.textBox1.Text;//报警时间
whb.handleTime = this.dateTimePicker1.Text.ToString();
whb.handleType = this.textBox3.Text;
whb.handleResult = this.textBox4.Text;
whb.measureMeterCode = this.textBox5.Text;
whb.handleTetails = this.richTextBox1.Text;
whb.createTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
DateTime BaoJin = Convert.ToDateTime(whb.warningTime);
DateTime XianZai = Convert.ToDateTime(whb.handleTime);
int cha = DateTime.Compare(XianZai, BaoJin);
if (cha > 0)
{
if (whb.handleType != null && !"".Equals(whb.handleType) && whb.handleResult != null && !"".Equals(whb.handleResult))
{
service.warningCheckService wc = new service.warningCheckService();
bool bl = wc.addWarningHandleInfo(whb);
//bool bl = true;
if (bl)
{
this.Close();
this.DialogResult = DialogResult.OK;
MessageBox.Show("报警处理信息保存成功！");
}
}
else
{
MessageBox.Show("处理方式和处理结果都不能为空，请重新填写！");
}
}
else
{
MessageBox.Show("报警处理时间不得早于报警时间！");
}
}
private void button1_Click(object sender, EventArgs e)
{
time1 = this.dateTimePicker1.Text.ToString();
time2 = this.dateTimePicker2.Text.ToString();
service.warningCheckService wcs = new service.warningCheckService();
dt = wcs.warningHandlecheck(time1, time2);
service.deviceInformationService ds = new service.deviceInformationService();
DataTable dts = ds.selectHouseTypeK();
if (dts.Rows.Count > 0)
{
for (int i = 0; i < dts.Rows.Count; i++)
{
for (int j = 0; j < dt.Rows.Count; j++)
{
if (dts.Rows[i]["measureMeterCode"].ToString() == dt.Rows[j]["measureMeterCode"].ToString())
{
dt.Rows[i].Delete();
}
}
}
dt.AcceptChanges();
}
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
string a = Convert.ToDateTime(dt.Rows[i]["handleTime"]).ToString("yyyy/MM/dd HH:mm:ss"); //格式转换
dt.Rows[i]["handleTime"] = a; //dt.Rows[i]["warningTime"] = //dt.Rows[i]["warningTime"] =
}
dt.Columns["warningTime"].SetOrdinal(6);
this.dataGridView1.DataSource = dt;
this.dataGridView1.Columns[0].Visible = false;
this.dataGridView1.Columns[1].HeaderCell.Value = "处理人员";
this.dataGridView1.Columns[2].HeaderCell.Value = "处理时间";
this.dataGridView1.Columns[3].HeaderCell.Value = "处理方式";
this.dataGridView1.Columns[4].HeaderCell.Value = "处理结果";
this.dataGridView1.Columns[5].HeaderCell.Value = "详细描述";
this.dataGridView1.Columns[6].HeaderCell.Value = "报警时间";
this.dataGridView1.Columns[7].Visible = false;
this.dataGridView1.Columns[8].Visible = false;
this.dataGridView1.Columns[9].HeaderCell.Value = "测点名称";
this.dataGridView1.Columns[1].Width = 90;
this.dataGridView1.Columns[2].Width = 180;
this.dataGridView1.Columns[3].Width = 150;
this.dataGridView1.Columns[4].Width = 150;
this.dataGridView1.Columns[5].Width = 270;
this.dataGridView1.Columns[6].Width = 150;
this.dataGridView1.Columns[9].Width = 250;
this.dataGridView1.RowsDefaultCellStyle.ForeColor = Color.Black;
for (int count = 0; (count <= (this.dataGridView1.Rows.Count - 2)); count++)
{
this.dataGridView1.Rows[count].HeaderCell.Value = String.Format("{0}", count + 1);
}
this.dataGridView1.AllowUserToAddRows = false;
}
else
{
MessageBox.Show("当前时间段无查询结果！");
}
}
