/**
* 根据ID获取变损类型
* @param ref DataTable dt 存储查询出来信息
* @return int 值为Constant.OK：执行成功，值为Constant.ERROR为执行失败
* @author Rick
**/
public int getTLoseTypeById(string TLoseNo, ref TransformerLose t_lose)
{
string strSelect = "select distinct TransformerLoseNo, TransformerType, standarVolume from TransformerLoseInfo where TransformerLoseNo = " + TLoseNo;
try
{
DataTable dt = SQLUtl.Query(strSelect).Tables[0];
if (null != dt.Rows[0].ItemArray[0])
{
t_lose.TransformerLoseNo = dt.Rows[0].ItemArray[0].ToString().Trim();
}
else
{
t_lose.TransformerLoseNo = "";
}
if (null != dt.Rows[0].ItemArray[1])
{
t_lose.TransformerType = dt.Rows[0].ItemArray[1].ToString().Trim();
}
else
{
t_lose.TransformerType = "";
}
if (null != dt.Rows[0].ItemArray[2])
{
t_lose.StandarVolume = dt.Rows[0].ItemArray[2].ToString().Trim();
}
else
{
t_lose.StandarVolume = "";
}
return Constant.OK;
}catch(Exception)
{
return Constant.ERROR;
}
}
/**
* 添加新变损信息
* @param string t_no：变损编号
* @param ref List<TransformerLose> list：变损信息
* @return int 值为Constant.OK：执行成功，值为Constant.ERROR为执行失败
* @author Rick
**/
public int getTLoseById(string t_lose_no, ref List<TransformerLose> list)
{
string strSelect = "select * from TransformerLoseInfo where TransformerLoseNo = " + t_lose_no;
try
{
DataSet ds = SQLUtl.Query(strSelect);
DataTable dt = ds.Tables[0];
int count = dt.Rows.Count;
int i = 0;
while (count > 0)
{
TransformerLose t_lose = new TransformerLose();
//给对象t_lose_no赋值
if (null != dt.Rows[i].ItemArray[0])
{
t_lose.TransformerLoseNo = dt.Rows[i].ItemArray[0].ToString().Trim();
}
else
{
t_lose.TransformerLoseNo = "";
}
if (null != dt.Rows[i].ItemArray[1])
{
t_lose.TransformerType = dt.Rows[i].ItemArray[1].ToString().Trim();
}
else
{
t_lose.TransformerType = "";
}
if (null != dt.Rows[i].ItemArray[2])
{
t_lose.StandarVolume = dt.Rows[i].ItemArray[2].ToString().Trim();
}
else
{
t_lose.StandarVolume = "";
}
if (null != dt.Rows[i].ItemArray[3])
{
t_lose.MonthUsed = dt.Rows[i].ItemArray[3].ToString().Trim();
}
else
{
t_lose.MonthUsed = "";
}
if (null != dt.Rows[i].ItemArray[4])
{
t_lose.TranformerLose = dt.Rows[i].ItemArray[4].ToString().Trim();
}
else
{
t_lose.TranformerLose = "";
}
if (null != dt.Rows[i].ItemArray[5])
{
t_lose.LessOrMoreFlag = dt.Rows[i].ItemArray[5].ToString().Trim();
}
else
{
t_lose.LessOrMoreFlag = "";
}
list.Add(t_lose);
count = count - 1;
i = i + 1;
}
return Constant.OK;
}
catch (Exception)
{
return Constant.ERROR;
}
}
private void Add_Button_Click(object sender, EventArgs e)
{
List<TransformerLose> t_lose_list = new List<TransformerLose>();
if (this.LoseNo_Add.Text.ToString().Trim() == "")
{
MessageBox.Show("请填写变损编号！");
return;
}
bool state = false;
this.t_lose_action.checkTLoseNo(this.LoseNo_Add.Text.ToString().Trim(), ref state);
if (!state)
{
MessageBox.Show("该变损编号已经存在！");
return;
}
if ("" == this.TType_Add.Text.ToString().Trim())
{
MessageBox.Show("电压器类型不能为空！");
return;
}
if ("" == this.Limit_Add.Text.ToString().Trim())
{
MessageBox.Show("额定容量不能为空！");
return;
}
if ("" == this.Less_Add_11.Text.ToString().Trim() || "" == this.Less_Add_12.Text.ToString().Trim())
{
MessageBox.Show("变损信息没有填写！");
return;
}
else
{
TransformerLose t_lose_1 = new TransformerLose();
t_lose_1.TransformerLoseNo = this.LoseNo_Add.Text.ToString().Trim();
t_lose_1.TransformerType = this.TType_Add.Text.ToString().Trim();
t_lose_1.StandarVolume = this.Limit_Add.Text.ToString().Trim();
t_lose_1.MonthUsed = this.Less_Add_11.Text.ToString().Trim();
t_lose_1.TranformerLose = this.Less_Add_12.Text.ToString().Trim();
t_lose_1.LessOrMoreFlag = "0";
t_lose_list.Add(t_lose_1);
}
if ("" == this.Less_Add_21.Text.ToString().Trim() || "" == this.Less_Add_22.Text.ToString().Trim())
{
MessageBox.Show("变损信息没有填写！");
return;
}
else
{
TransformerLose t_lose_2 = new TransformerLose();
t_lose_2.TransformerLoseNo = this.LoseNo_Add.Text.ToString().Trim();
t_lose_2.TransformerType = this.TType_Add.Text.ToString().Trim();
t_lose_2.StandarVolume = this.Limit_Add.Text.ToString().Trim();
t_lose_2.MonthUsed = this.Less_Add_21.Text.ToString().Trim();
t_lose_2.TranformerLose = this.Less_Add_22.Text.ToString().Trim();
t_lose_2.LessOrMoreFlag = "0";
t_lose_list.Add(t_lose_2);
}
if ("" == this.Less_Add_31.Text.ToString().Trim() || "" == this.Less_Add_32.Text.ToString().Trim())
{
MessageBox.Show("变损信息没有填写！");
return;
}
else
{
TransformerLose t_lose_3 = new TransformerLose();
t_lose_3.TransformerLoseNo = this.LoseNo_Add.Text.ToString().Trim();
t_lose_3.TransformerType = this.TType_Add.Text.ToString().Trim();
t_lose_3.StandarVolume = this.Limit_Add.Text.ToString().Trim();
t_lose_3.MonthUsed = this.Less_Add_31.Text.ToString().Trim();
t_lose_3.TranformerLose = this.Less_Add_32.Text.ToString().Trim();
t_lose_3.LessOrMoreFlag = "0";
t_lose_list.Add(t_lose_3);
}
if ("" == this.More_Add.Text.ToString().Trim())
{
MessageBox.Show("变损信息没有填写！");
return;
}
else
{
TransformerLose t_lose_4 = new TransformerLose();
t_lose_4.TransformerLoseNo = this.LoseNo_Add.Text.ToString().Trim();
t_lose_4.TransformerType = this.TType_Add.Text.ToString().Trim();
t_lose_4.StandarVolume = this.Limit_Add.Text.ToString().Trim();
t_lose_4.MonthUsed = this.Less_Add_31.Text.ToString().Trim();
t_lose_4.TranformerLose = this.More_Add.Text.ToString().Trim();
t_lose_4.LessOrMoreFlag = "1";
t_lose_list.Add(t_lose_4);
}
if (Constant.OK == this.t_lose_action.addTLose(ref t_lose_list))
{
MessageBox.Show("添加成功！");
this.T_List_init();
this.LoseNo_Add.Text = "";
this.Limit_Add.Text = "";
this.TType_Add.Text = "";
this.Less_Add_11.Text = "";
this.Less_Add_12.Text = "";
this.Less_Add_21.Text = "";
this.Less_Add_22.Text = "";
this.Less_Add_31.Text = "";
this.Less_Add_32.Text = "";
this.More_Add.Text = "";
// this.T_List.SelectedIndex = -1;
this.Refresh();
return;
}
else
{
MessageBox.Show("添加失败！");
return;
}
}
private void Update_Lose_Click(object sender, EventArgs e)
{
List<TransformerLose> t_lose_list = new List<TransformerLose>();
if ("" == this.TType.Text.ToString().Trim())
{
MessageBox.Show("电压器类型不能为空！");
return;
}
if ("" == this.Limit.Text.ToString().Trim())
{
MessageBox.Show("额定容量不能为空！");
return;
}
if ("" == this.Less_11.Text.ToString().Trim() || "" == this.Less12.Text.ToString().Trim())
{
MessageBox.Show("变损信息没有填写！");
return;
}
else
{
TransformerLose t_lose_1 = new TransformerLose();
t_lose_1.TransformerLoseNo = this.LoseNo.Text.ToString().Trim();
t_lose_1.TransformerType = this.TType.Text.ToString().Trim();
t_lose_1.StandarVolume = this.Limit.Text.ToString().Trim();
t_lose_1.MonthUsed = this.Less_11.Text.ToString().Trim();
t_lose_1.TranformerLose = this.Less12.Text.ToString().Trim();
t_lose_1.LessOrMoreFlag = "0";
t_lose_list.Add(t_lose_1);
}
if ("" == this.Less22.Text.ToString().Trim() || "" == this.Less21.Text.ToString().Trim())
{
MessageBox.Show("变损信息没有填写！");
return;
}
else
{
TransformerLose t_lose_2 = new TransformerLose();
t_lose_2.TransformerLoseNo = this.LoseNo.Text.ToString().Trim();
t_lose_2.TransformerType = this.TType.Text.ToString().Trim();
t_lose_2.StandarVolume = this.Limit.Text.ToString().Trim();
t_lose_2.MonthUsed = this.Less21.Text.ToString().Trim();
t_lose_2.TranformerLose = this.Less22.Text.ToString().Trim();
t_lose_2.LessOrMoreFlag = "0";
t_lose_list.Add(t_lose_2);
}
if ("" == this.Less32.Text.ToString().Trim() || "" == this.Less31.Text.ToString().Trim())
{
MessageBox.Show("变损信息没有填写！");
return;
}
else
{
TransformerLose t_lose_3 = new TransformerLose();
t_lose_3.TransformerLoseNo = this.LoseNo.Text.ToString().Trim();
t_lose_3.TransformerType = this.TType.Text.ToString().Trim();
t_lose_3.StandarVolume = this.Limit.Text.ToString().Trim();
t_lose_3.MonthUsed = this.Less31.Text.ToString().Trim();
t_lose_3.TranformerLose = this.Less32.Text.ToString().Trim();
t_lose_3.LessOrMoreFlag = "0";
t_lose_list.Add(t_lose_3);
}
if ("" == this.More.Text.ToString().Trim())
{
MessageBox.Show("变损信息没有填写！");
return;
}
else
{
TransformerLose t_lose_4 = new TransformerLose();
t_lose_4.TransformerLoseNo = this.LoseNo.Text.ToString().Trim();
t_lose_4.TransformerType = this.TType.Text.ToString().Trim();
t_lose_4.StandarVolume = this.Limit.Text.ToString().Trim();
t_lose_4.MonthUsed = this.Less31.Text.ToString().Trim();
t_lose_4.TranformerLose = this.More.Text.ToString().Trim();
t_lose_4.LessOrMoreFlag = "1";
t_lose_list.Add(t_lose_4);
}
if (Constant.OK == this.t_lose_action.updateTLose(this.LoseNo.Text.ToString().Trim(), ref t_lose_list))
{
MessageBox.Show("更新成功！");
return;
}
else
{
MessageBox.Show("更新失败！");
return;
}
}
private void T_List_SelectedIndexChanged(object sender, EventArgs e)
{
//TransformerInfo transfomerInfo = new TransformerInfo();
TransformerLose transformerLose = new TransformerLose();
List<TransformerLose> t_lose_list = new List<TransformerLose>();
if (-1 != this.T_List.SelectedIndex)
{
//char c = ;
string key = this.T_List.SelectedItem.ToString().Trim().Split(' ')[0];
if (key == "")
{
return;
}
if (Constant.OK == this.t_lose_action.getTLoseById(key, ref t_lose_list))
{
//string item = transformerLose.TransformerLoseNo + " " + transformerLose.TransformerType + " " + transformerLose.StandarVolume;
//this.T_Lose_Type.SelectedItem = item;
this.LoseNo.Text = t_lose_list[0].TransformerLoseNo;
this.LoseNo.Enabled = false;
this.TType.Text = t_lose_list[0].TransformerType;
this.Limit.Text = t_lose_list[0].StandarVolume;
int count = t_lose_list.Count;
switch(count)
{
case 1:
{
this.Less_11.Text = t_lose_list[0].MonthUsed;
this.Less12.Text = t_lose_list[0].TranformerLose;
break;
}
case 2:
{
this.Less_11.Text = t_lose_list[0].MonthUsed;
this.Less12.Text = t_lose_list[0].TranformerLose;
this.Less21.Text = t_lose_list[1].MonthUsed;
this.Less22.Text = t_lose_list[1].TranformerLose;
break;
}
case 3:
{
this.Less_11.Text = t_lose_list[0].MonthUsed;
this.Less12.Text = t_lose_list[0].TranformerLose;
this.Less21.Text = t_lose_list[1].MonthUsed;
this.Less22.Text = t_lose_list[1].TranformerLose;
this.Less31.Text = t_lose_list[2].MonthUsed;
this.Less32.Text = t_lose_list[2].TranformerLose;
break;
}
case 4:
{
this.Less_11.Text = t_lose_list[0].MonthUsed;
this.Less12.Text = t_lose_list[0].TranformerLose;
this.Less21.Text = t_lose_list[1].MonthUsed;
this.Less22.Text = t_lose_list[1].TranformerLose;
this.Less31.Text = t_lose_list[2].MonthUsed;
this.Less32.Text = t_lose_list[2].TranformerLose;
this.More.Text = t_lose_list[3].TranformerLose;
break;
}
default:
{
break;
}
//this.Less_11.Text = t_lose_list[0].TranformerLose;
//this.Less12.Text = t_lose_list[0].MonthUsed;
}
}
else
{
//do nothing
}
}
}
private void T_List_SelectedIndexChanged(object sender, EventArgs e)
{
TransformerInfo transfomerInfo = new TransformerInfo();
TransformerLose transformerLose = new TransformerLose();
if (-1 != this.T_List.SelectedIndex)
{
if (Constant.OK == this.t_info_action.getTInfoById(this.T_List.SelectedItem.ToString().Trim().Split(' ')[0], ref transfomerInfo))
{
this.T_Code.Text = transfomerInfo.TransformerNo;
this.T_Code.Enabled = false;
this.T_Name.Text = transfomerInfo.TransformerName;
if ("" != transfomerInfo.TransformerLoseNo)
{
if (Constant.OK == this.t_lose_action.getTLoseTypeById(transfomerInfo.TransformerLoseNo, ref transformerLose))
{
string item = transformerLose.TransformerLoseNo + " " + transformerLose.TransformerType + " " + transformerLose.StandarVolume;
this.T_Lose_Type.SelectedItem = item;
}
}else
{
//do nothing
}
}
}
}