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("当前时间段无查询结果!"); } }