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