private void button2_Click(object sender, EventArgs e)
{
DialogResult rr = MessageBox.Show("确定要删除当前数据吗？", "确定要删除提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1);
int tt = (int)rr;
if (tt == 1)
{
string code = this.dataGridView1.SelectedRows[0].Cells[0].Value.ToString();
if (code != null && !"".Equals(code) && !"1".Equals(code))
{
bool bl = hts.deleteHouseTypeById(code);
if (bl)
{ //删除库房数据的同时修改仪表表中的house_code
service.deviceInformationService dis = new service.deviceInformationService();
dis.updateIformationByHouseCode(code);
//刷新页面
queryhouseManage();
MessageBox.Show("删除成功！");
}
}
else
{
MessageBox.Show("当前库房信息不能被删除，只能修改库房信息，因为软件系统使用中！");
}
}
}
private void checkPointInfo()
{
service.deviceInformationService dis = new service.deviceInformationService();
int flag = 0;
DataTable dt = dis.checkPointInfo(flag);
if (dt != null)
{
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].Visible = false;
this.dataGridView1.Columns[5].HeaderCell.Value = "通信协议";
this.dataGridView1.Columns[6].Visible = false;
this.dataGridView1.Columns[7].Visible = false;
this.dataGridView1.Columns[8].Visible = false;
this.dataGridView1.Columns[9].Visible = false;
this.dataGridView1.Columns[10].Visible = false;
this.dataGridView1.Columns[11].HeaderCell.Value = "库房类型名称";
this.dataGridView1.Columns[12].Visible = false;
this.dataGridView1.RowsDefaultCellStyle.ForeColor = Color.Black;
this.dataGridView1.Columns[1].Width = 150;
this.dataGridView1.Columns[2].Width = 130;
this.dataGridView1.Columns[3].Width = 150;
this.dataGridView1.Columns[5].Width = 220;
this.dataGridView1.AllowUserToAddRows = false;
}
else
{
this.dataGridView1.DataSource = null;
}
}
private void button4_Click(object sender, EventArgs e)
{
DialogResult rr = MessageBox.Show("确定要删除测点(仪表)数据吗？", "确定要删除提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1);
int tt = (int)rr;
if (tt == 1)
{
string code = this.dataGridView1.SelectedRows[0].Cells[1].Value.ToString();
string meter = this.dataGridView1.SelectedRows[0].Cells[2].Value.ToString();
if (code != null && !"".Equals(code) && meter != null && !"".Equals(meter))
{
bean.deviceInformation di = new bean.deviceInformation();
di.measureCode = code;
di.meterNo = meter;
service.deviceInformationService dis = new service.deviceInformationService();
bool bl = dis.deletetDeviceInformation(di);
if (bl)
{ //删除仪表数据的同时修改管理主机的仪表数量
service.manageHostService mhs = new service.manageHostService();
bean.manageHose mh = new bean.manageHose();
mh.measureCode = di.measureCode;
mhs.updateManageHostCdNum(mh);
//刷新仪表页面
checkPointInfo();
MessageBox.Show("删除成功！");
//刷新首页
if (this.RefreshEvent != null)
{
RefreshEvent(1, null);
}
}
}
}
}
private void button4_Click(object sender, EventArgs e)
{
if (flag)
{
foreach (Control ctr in this.pictureBox1.Controls)
{
//判断该控件是不是Label
if (ctr is Label)
{ //将ctr转换成Label并赋值给ck
Label lb = ctr as Label;
string[] code1 = lb.Name.Split('_');
Point tt = lb.Location;
bean.deviceInformation di = new bean.deviceInformation();
di.measureCode = code1[0].ToString();
di.meterNo = code1[1].ToString();
di.pointX = tt.X;
di.pointY = tt.Y;
service.deviceInformationService dis = new service.deviceInformationService();
dis.updateIformationByPoint(di);
}
}
MessageBox.Show("平面图仪表位置信息保存成功！");
string code = this.comboBox1.SelectedValue.ToString();
imgWenshidu(code);
flag = false;
}
else
{
MessageBox.Show("请先编辑测点位置，再点击保存！");
}
}
private void readHistoryData_Load(object sender, EventArgs e)
{
string str = Application.StartupPath;//项目路径
this.button1_click.BackgroundImage = Image.FromFile(@str + "/images/read.png");
this.button4.BackgroundImage = Image.FromFile(@str + "/images/stop.png");
this.button2.BackgroundImage = Image.FromFile(@str + "/images/clear.png");
this.button3.BackgroundImage = Image.FromFile(@str + "/images/close.png");
service.deviceInformationService dis = new service.deviceInformationService();
int flag = 0;
dtcdinfo = dis.checkPointInfo(flag);
}
private void button1_Click(object sender, EventArgs e)
{
string name = this.textBox3.Text;
string codemeter = this.textBox4.Text;
string t_high = this.numericUpDown4.Value.ToString();
string t_low = this.numericUpDown2.Value.ToString();
string h_high = this.numericUpDown1.Value.ToString();
string h_low = this.numericUpDown5.Value.ToString();
if (name != null && double.Parse(t_high) > double.Parse(t_low))
{
bean.deviceInformation di = new bean.deviceInformation();
string[] mm = codemeter.Split('-');
di.measureCode = mm[0];
di.meterNo = mm[1];
di.terminalname = name;
di.t_high = float.Parse(t_high);
di.t_low = float.Parse(t_low);
di.h_high = float.Parse(h_high);
di.h_low = float.Parse(h_low);
if (this.checkBox1.Checked)
{
di.powerflag = Int32.Parse(this.checkBox1.Tag.ToString());
}
else
{
di.powerflag = 1;
};
service.deviceInformationService dis = new service.deviceInformationService();
bool isok = dis.updateIformation(di);
if (isok)
{
this.DialogResult = DialogResult.OK;
}
}
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("当前时间段无查询结果！");
}
}
private void button1_Click(object sender, EventArgs e)
{
string name = this.textBox1.Text;
string t_high = this.numericUpDown1.Value.ToString();
string t_low = this.numericUpDown2.Value.ToString();
string h_high = this.numericUpDown3.Value.ToString();
string h_low = this.numericUpDown4.Value.ToString();
string id = this.textBox2.Text.ToString();
if (name != null && !"".Equals(name) && id != null && !"".Equals(id))
{
bean.houseInfo di = new bean.houseInfo();
di.name = name;
di.t_high = float.Parse(t_high);
di.t_low = float.Parse(t_low);
di.h_high = float.Parse(h_high);
di.h_low = float.Parse(h_low);
di.id = id;
if (this.checkBox2.Checked)
{
di.isUsed = 1;
}
else
{
di.isUsed = 0;
}
service.houseTypeService his = new service.houseTypeService();
bool isok = his.updateHouseInfoById(di);
if (isok)
{
service.deviceInformationService dis = new service.deviceInformationService();
if (this.checkBox1.Checked)
{
bool bl = dis.updateWsdByHouseCode(di);
if (bl)
{
if (di.isUsed == 1)
{
MessageBox.Show(di.name + " 库房下所有的测点(仪表)都已修改为空库测点！");
}
MessageBox.Show(di.name + " 库房下所有的测点(仪表)温湿度上下限已同步修改成功！");
}
}
else
{
bool bl = dis.updateWsdByHouseKong(di);
if (bl)
{
if (di.isUsed == 1)
{
MessageBox.Show(di.name + " 库房下所有的测点(仪表)都已修改为空库测点！");
}
else
{
MessageBox.Show(di.name + " 库房下所有的测点(仪表)都已取消空库设定！");
}
}
}
this.DialogResult = DialogResult.OK;
}
}
}
private void button1_Click(object sender, EventArgs e)
{
string name = this.textBox1.Text;
//验证主机名称是否重复
service.manageHostService mhs = new service.manageHostService();
DataTable dt = mhs.queryManageHost();
DataRow[] drr = dt.Select("hostName = '" + name + "'");
if (drr.Length > 0)
{
MessageBox.Show("主机名称已存在，请重新输入！");
return;
}
string cdnum = this.numericUpDown1.Value.ToString();
string cktype = this.comboBox3.SelectedItem.ToString();
string txxy = this.comboBox2.SelectedItem.ToString();
string kflx = this.comboBox1.SelectedValue.ToString();
/////////////////////////设置主机信息
int RecordM = int.Parse(this.numericUpDown7.Value.ToString());
int WarningM = int.Parse(this.numericUpDown6.Value.ToString());
string PhoneNo = this.textBox5.Text.ToString();
int State = 1;
if (PhoneNo == "" || PhoneNo.Length != 11)
{
MessageBox.Show("请输入正确的手机号码！"); return;
}
////////////////////////////////
if (name != null && !"".Equals(name) && cdnum != null && cktype != null && txxy != null && kflx != null)
{
mh = new bean.manageHose();
bool istrue = false;
mh.hostName = name;
mh.CommunicationType = txxy;
mh.portNumber = cdnum;
mh.storeType = cktype;
mh.houseType = kflx;
/////////////////////////设置主机信息
mh.RecordM = RecordM;
mh.WarningM = WarningM;
mh.PhoneNo = PhoneNo;
mh.State = State;
////////////////////////////////
if (this.radioButton1.Checked)
{
mh.hostAddress = this.numericUpDown2.Value.ToString();
mh.serialPort = this.comboBox5.Text;
mh.tcp_ip_Port = "";
mh.networkType = "COM";
}
else if (this.radioButton2.Checked)
{
mh.hostAddress = this.numericUpDown5.Value.ToString();
mh.serialPort = "";
mh.tcp_ip_Port = this.textBox3.Text + ":" + this.numericUpDown3.Value.ToString();
mh.networkType = "TCP";
}
else if (this.radioButton4.Checked)
{
mh.hostAddress = "";
mh.serialPort = "";
mh.tcp_ip_Port = "";
mh.networkType = "YUN";
}
else
{
MessageBox.Show("请选择通讯方式");
return;
}
if (this.textBox2.Text != null && !"".Equals(this.textBox2.Text))
{
mh.measureCode = this.textBox2.Text;
//验证主机主机编号是否重复
DataRow[] drr0 = dt.Select("measureCode = '" + mh.measureCode + "'");
if (drr0.Length > 0)
{
MessageBox.Show("主机编号已存在，请重新输入！");
return;
}
//添加主机
istrue = mhs.addManageHost(mh);
}
else
{
MessageBox.Show("管理主机编号为空，请输入...");
}
if (istrue)
{
service.deviceInformationService ds = new service.deviceInformationService();
bool isfalse = ds.addDeviceInformation(mh);
if (isfalse)
{
this.DialogResult = DialogResult.OK;
}
}
}
else
{
MessageBox.Show("信息填写不完整，请重新填写！");
}
}
private void button3_Click(object sender, EventArgs e)
{
this.timer1.Stop();
this.pictureBox1.Controls.Clear();
string code = this.comboBox1.SelectedValue.ToString();
service.deviceInformationService dis = new service.deviceInformationService();
DataTable dt = dis.queryDeviceByHouseTypeCode(code);
int count = dt.Rows.Count;
if (count > 0)
{
labels = new Label[count];//例如10个
int p = 10;
for (int x = 0; x < count; x++)
{
string pointx = dt.Rows[x]["pointX"].ToString();
string pointy = dt.Rows[x]["pointY"].ToString();
labels[x] = new Label();
labels[x].AutoSize = true;
labels[x].Name = dt.Rows[x]["measureCode"].ToString() + "_" + dt.Rows[x]["meterNo"].ToString();
labels[x].Text = dt.Rows[x]["terminalname"].ToString();
labels[x].BorderStyle = BorderStyle.None;
labels[x].Font = new Font(privateFonts.Families[0], 10.0F, FontStyle.Regular, GraphicsUnit.Point, ((byte)(134)));
if (pointx != null && !"".Equals(pointx) && pointy != null && !"".Equals(pointy))
{
labels[x].Location = new Point(Int32.Parse(pointx), Int32.Parse(pointy));
}
else
{
if (x < 20)
{
labels[x].Location = new Point(10, p);
p += 45;
}
else if (x >= 20 && x < 40)
{
if (x == 20)
{
p = 10;
}
;
labels[x].Location = new Point(160, p);
p += 45;
}
else if (x >= 40 && x < 60)
{
if (x == 40)
{
p = 10;
}
;
labels[x].Location = new Point(310, p);
p += 45;
}
else if (x >= 60 && x < 80)
{
if (x == 60)
{
p = 10;
}
;
labels[x].Location = new Point(460, p);
p += 45;
}
else if (x >= 80 && x < 100)
{
if (x == 80)
{
p = 10;
}
;
labels[x].Location = new Point(610, p);
p += 45;
}
else if (x >= 100 && x < 120)
{
if (x == 100)
{
p = 10;
}
;
labels[x].Location = new Point(760, p);
p += 45;
}
else if (x >= 120 && x < 140)
{
if (x == 120)
{
p = 10;
}
;
labels[x].Location = new Point(910, p);
p += 45;
}
else if (x >= 140 && x < 160)
{
if (x == 140)
{
p = 10;
}
;
labels[x].Location = new Point(1060, p);
p += 45;
}
else if (x >= 160 && x < 180)
{
if (x == 160)
{
p = 10;
}
;
labels[x].Location = new Point(1210, p);
p += 45;
}
else if (x >= 180 && x < 200)
{
if (x == 180)
{
p = 10;
}
;
labels[x].Location = new Point(1360, p);
p += 45;
}
}
labels[x].MouseMove += new MouseEventHandler(this.label_MouseMove);
labels[x].MouseDown += new MouseEventHandler(this.label_MouseDown);
this.pictureBox1.Controls.Add(labels[x]);
}
flag = true;
}
else
{
MessageBox.Show("此库房没有对应的测点(仪表)，请去测点管理功能中添加或修改测点(仪表)数据！");
}
}
