private void AddAmmeter_Click(object sender, EventArgs e) { string areaNo = ""; if (this.AreaNoList_Add.SelectedIndex == -1) { MessageBox.Show("请选择线路!"); return; } areaNo = this.AreaNoList_Add.SelectedItem.ToString().Trim().Split(' ')[0]; if (this.AmmeterNo_Add.Text.ToString().Trim() == "") { MessageBox.Show("请填写电表编号!"); return; } string ammeterNo = this.AmmeterNo_Add.Text.ToString().Trim(); bool state = false; if (Constant.ERROR == this.areaAmmeterAction.checkAANo(areaNo, ammeterNo, ref state)) { return; } if (!state) { MessageBox.Show("该电表编号已经存在!"); return; } AreaAmmeterInfo raInfo = new AreaAmmeterInfo(); raInfo.AreaNo = areaNo; raInfo.AmmeterNo = ammeterNo; if ("" == this.AmmeterName_Add.Text.ToString().Trim()) { MessageBox.Show("请填写电表名称!"); return; } raInfo.AmmeterName = this.AmmeterName_Add.Text.ToString().Trim(); if ("" == this.AmmeterMulti_Add.Text.ToString().Trim()) { MessageBox.Show("请填写电表倍率!"); return; } raInfo.AreaAmmeterMulti = this.AmmeterMulti_Add.Text.ToString().Trim(); if (Constant.OK == this.areaAmmeterAction.addAAInfo(ref raInfo)) { MessageBox.Show("添加成功!"); return; } else { MessageBox.Show("添加失败!"); return; } }
/** * 添加台区电表信息 * @param ref AreaAmmeterInfo aAInfo:台区电表信息 * @return int 值为Constant.OK:执行成功,值为Constant.ERROR为执行失败 * @author Rick **/ public int addAAInfo(ref AreaAmmeterInfo aAInfo) { string strAdd = "insert into AreaAmmeterInfo values (" + aAInfo.AreaNo + "," + aAInfo.AmmeterNo + ",'" + aAInfo.AmmeterName + "'," + aAInfo.AreaAmmeterMulti + ", getdate())"; try { SQLUtl.ExecuteSql(strAdd); return Constant.OK; } catch (Exception) { return Constant.ERROR; } }
private void UpdateAmmeter_Click(object sender, EventArgs e) { string areaNo = ""; string ammeterNo = ""; if (-1 == this.AreaNoList.SelectedIndex) { MessageBox.Show("请选择线路号!"); return; } if (-1 == this.AmmeterList.SelectedIndex) { MessageBox.Show("请选择电表!"); return; } areaNo = this.AreaNoList.SelectedItem.ToString().Trim().Split(' ')[0]; ammeterNo = this.AmmeterList.SelectedItem.ToString().Trim().Split(' ')[0]; if (this.AmmeterName.Text.ToString().Trim() == "") { MessageBox.Show("电表名称不能为空!"); return; } if (this.AmmeterMulti.Text.ToString().Trim() == "") { MessageBox.Show("电表倍率不能为空值!"); return; } AreaAmmeterInfo raInfo = new AreaAmmeterInfo(); raInfo.AreaNo = areaNo; raInfo.AmmeterNo = ammeterNo; raInfo.AmmeterName = this.AmmeterName.Text.ToString().Trim(); raInfo.AreaAmmeterMulti = this.AmmeterMulti.Text.ToString().Trim(); if (Constant.OK == this.areaAmmeterAction.updateAAInfo(areaNo, ammeterNo, ref raInfo)) { MessageBox.Show("电表信息更新成功!"); return; } else { MessageBox.Show("电表信息更新失败!"); return; } }
private void AmmeterList_SelectedIndexChanged(object sender, EventArgs e) { string areaNo = ""; string ammeterNo = ""; if (-1 == this.AreaNoList.SelectedIndex) { MessageBox.Show("请选择线路号!"); return; } if (-1 == this.AmmeterList.SelectedIndex) { MessageBox.Show("请选择电表!"); return; } areaNo = this.AreaNoList.SelectedItem.ToString().Trim().Split(' ')[0]; ammeterNo = this.AmmeterList.SelectedItem.ToString().Trim().Split(' ')[0]; AreaAmmeterInfo raInfo = new AreaAmmeterInfo(); if (Constant.OK == this.areaAmmeterAction.getAAInfoById(areaNo, ammeterNo, ref raInfo)) { //MessageBox.Show("") this.AmmeterNo.Text = raInfo.AmmeterNo; this.AmmeterName.Text = raInfo.AmmeterName; this.AmmeterMulti.Text = raInfo.AreaAmmeterMulti; } }
/** * 更新台区电表信息 * @param string aaNo:台区电表编号 * @param ref AreaAmmeterInfo aaInfo:台区信息 * @return int 值为Constant.OK:执行成功,值为Constant.ERROR为执行失败 * @author Rick **/ public int updateAAInfo(string areaNo, string aaNo, ref AreaAmmeterInfo aaInfo) { string strUpdate = "update AreaAmmeterInfo set AmmeterName = '" + aaInfo.AmmeterName + "', AreaAmmeterMulti = " + aaInfo.AreaAmmeterMulti + ", AreaAmmeterDate = getdate() where AreaNo = " + areaNo + " and AmmeterNo = " + aaNo; try { SQLUtl.ExecuteSql(strUpdate); return Constant.OK; } catch (Exception) { return Constant.ERROR; } }
/** * 添加新的台区电表信息 * @param string aaNo:变压器编号 * @param ref AreaAmmeterInfo aaInfo:台区信息 * @return int 值为Constant.OK:执行成功,值为Constant.ERROR为执行失败 * @author Rick **/ public int getAAInfoById(string areaNo, string aaNo, ref AreaAmmeterInfo aaInfo) { string strSelect = "select * from AreaAmmeterInfo where AreaNo = " + areaNo + " and AmmeterNo = " + aaNo; try { DataSet ds = SQLUtl.Query(strSelect); DataTable dt = ds.Tables[0]; if (null != dt.Rows[0].ItemArray[0]) { aaInfo.AreaNo = dt.Rows[0].ItemArray[0].ToString().Trim(); } else { aaInfo.AreaNo = ""; } if (null != dt.Rows[0].ItemArray[1]) { aaInfo.AmmeterNo = dt.Rows[0].ItemArray[1].ToString().Trim(); } else { aaInfo.AmmeterNo = ""; } if (null != dt.Rows[0].ItemArray[2]) { aaInfo.AmmeterName = dt.Rows[0].ItemArray[2].ToString().Trim(); } else { aaInfo.AmmeterName = ""; } if (null != dt.Rows[0].ItemArray[3]) { aaInfo.AreaAmmeterMulti = dt.Rows[0].ItemArray[3].ToString().Trim(); } else { aaInfo.AreaAmmeterMulti = ""; } if (null != dt.Rows[0].ItemArray[4]) { aaInfo.AreaAmmeterDate = dt.Rows[0].ItemArray[4].ToString().Trim(); } else { aaInfo.AreaAmmeterDate = ""; } return Constant.OK; } catch (Exception) { return Constant.ERROR; } }