private void InitSodata2()
{
string sid = "1";
Hashtable hs1 = new Hashtable();
Hashtable hs3 = new Hashtable();
IList <substation> listsubstation = Services.BaseService.GetList <substation>("SelectsubstationByPowerIDStuff", sid);
foreach (substation s1 in listsubstation)
{
hs1.Add(Guid.NewGuid().ToString(), s1.UID);
}
IList <Substation_Info> ll2 = Common.Services.BaseService.GetList <Substation_Info>("SelectSubstation_InfoByFlag", sid);
foreach (Substation_Info ps in ll2)
{
hs3.Add(Guid.NewGuid().ToString(), ps.Code);
}
foreach (Substation_Info p2 in ll2)
{
if (p2.Code != "" && !hs1.ContainsValue(p2.Code))
{
//删除
Services.BaseService.Delete <Substation_Info>(p2);
}
}
foreach (substation s2 in listsubstation)
{
if (!hs3.ContainsValue(s2.UID) && s2.ObligateField1 != "")
{
//添加
try
{
Substation_Info substation1 = new Substation_Info();
substation1.L1 = int.Parse(s2.ObligateField1);
substation1.Title = s2.EleName;
substation1.Code = s2.UID;
substation1.Flag = sid;
Services.BaseService.Create <Substation_Info>(substation1);
}
catch { }
}
}
}
private void barDel1_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
GridColumn gc = this.ctrlLine_Info1.GridView.FocusedColumn;
if (gc == null)
{
return;
}
if (gc.FieldName.Substring(0, 1) != "S")
{
MsgBox.Show("不能删除固定列");
return;
}
if (MsgBox.ShowYesNo("是否删除 " + gc.Caption + " 的所有数据？") != DialogResult.Yes)
{
return;
}
foreach (GridBand gc1 in this.ctrlLine_Info1.GridView.Bands)
{
try
{
if (gc1.Columns[0].Name == gc.Name)
{
gc1.Visible = false;
}
}
catch { }
}
//gc.Visible = false;
//InitVisuble();
gc.OptionsColumn.ShowInCustomizationForm = false;
Substation_Info si = new Substation_Info();
si.Title = gc.FieldName + "=''";
si.Flag = flag;
Itop.Client.Common.Services.BaseService.Update("UpdateLine_beizhuByFlag", si);
Line_beicong psl = new Line_beicong();
psl.ClassType = gc.FieldName;
psl.Flag = flag;
psl.Type = type;
psl.Title = gc.Caption;
psl.Type2 = type2;
Itop.Client.Common.Services.BaseService.Update("DeleteLine_beicongByAll", psl);
}
public bool RefreshDataOut(string addConn)
{
try
{
string filepath = "";
string con = "AreaID='" + projectid + "'";
con += addConn;
IList <Substation_Info> list = Services.BaseService.GetList <Substation_Info>("SelectSubstation_InfoByCon", con);
if (xmlflag == "guihua")
{
filepath = Path.GetTempPath() + "\\" + Path.GetFileName("SubstationGuiHua.xml");
}
else
{
filepath = Path.GetTempPath() + "\\" + Path.GetFileName("SubstationLayOut11.xml");
}
if (File.Exists(filepath))
{
this.bandedGridView1.RestoreLayoutFromXml(filepath);
}
Substation_Info info = new Substation_Info();
info.Title = "合计";
info.L9 = 0.0;
info.L3 = 0;
for (int i = 0; i < list.Count; i++)
{
info.L5 = Convert.ToString(double.Parse(info.L5 == "" ? "0" : info.L5) + double.Parse((list[i] as Substation_Info).L5 == "" ? "0" : (list[i] as Substation_Info).L5));
info.L6 = Convert.ToString(double.Parse(info.L6 == "" ? "0" : info.L6) + double.Parse((list[i] as Substation_Info).L6 == "" ? "0" : (list[i] as Substation_Info).L6));
info.L3 += ((list[i] as Substation_Info).L3 == null ? 0 : (list[i] as Substation_Info).L3);
info.L2 += (list[i] as Substation_Info).L2;
info.L9 += (list[i] as Substation_Info).L9;
info.L14 = Convert.ToString(double.Parse(info.L14 == "" ? "0" : info.L14) + double.Parse((list[i] as Substation_Info).L14 == "" ? "0" : (list[i] as Substation_Info).L14));
info.L13 = Convert.ToString(double.Parse(info.L13 == "" ? "0" : info.L13) + double.Parse((list[i] as Substation_Info).L13 == "" ? "0" : (list[i] as Substation_Info).L13));
info.S9 = Convert.ToString(double.Parse(info.S9 == "" ? "0" : info.S9) + double.Parse((list[i] as Substation_Info).S9 == "" ? "0" : (list[i] as Substation_Info).S9));
info.S10 = Convert.ToString(double.Parse(info.S10 == "" ? "0" : info.S10) + double.Parse((list[i] as Substation_Info).S10 == "" ? "0" : (list[i] as Substation_Info).S10));
}
info.L10 = (info.L2 == 0 ? 0 : info.L9 / info.L2) * 100;
info.S6 = Convert.ToString(double.Parse(info.L13) == 0.0 ? 0 : double.Parse(info.L14 == "" ? "0" : info.L14) * 100 / double.Parse(info.L13));
list.Add(info);
this.gridControl.DataSource = list;
}
catch (Exception exc)
{
Debug.Fail(exc.Message);
HandleException.TryCatch(exc);
return(false);
}
return(true);
}
public bool RefreshData(string layer, bool isrun, string power)
{
IList <Substation_Info> lists = new List <Substation_Info>();
try
{
Substation_Info ll1 = new Substation_Info();
ll1.AreaID = layer;
ll1.L1 = int.Parse(power);
if (isrun)
{
lists = UCDeviceBase.DataService.GetList <Substation_Info>("SelectSubstation_InfoByXZ", ll1);
}
else
{
lists = UCDeviceBase.DataService.GetList <Substation_Info>("SelectSubstation_InfoByGH", ll1);
}
this.gridControl.DataSource = lists;
bandedGridView1.OptionsView.ColumnAutoWidth = true;
foreach (GridColumn gc in this.bandedGridView1.Columns)
{
gc.Visible = false;
gc.OptionsColumn.ShowInCustomizationForm = false;
if (gc.FieldName == "Title" || gc.FieldName == "L9" || gc.FieldName == "L2" || gc.FieldName == "L1" || gc.FieldName == "L10")
{
gc.Visible = true;
gc.OptionsColumn.ShowInCustomizationForm = true;
}
//if (gc.FieldName.Substring(0, 1) == "S")
//{
// gc.Visible = false;
// gc.OptionsColumn.ShowInCustomizationForm = false;
//}
}
}
catch (Exception exc)
{
Debug.Fail(exc.Message);
HandleException.TryCatch(exc);
return(false);
}
return(true);
}
private void barButtonItem4_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
GridColumn gc = this.ctrlSubstation_Info1.GridView.FocusedColumn;
if (gc == null)
{
return;
}
if (gc.FieldName.Substring(0, 1) != "S")
{
MsgBox.Show("不能删除固定列");
return;
}
if (MsgBox.ShowYesNo("是否删除 " + gc.Caption + " 的所有数据？") != DialogResult.Yes)
{
return;
}
foreach (GridBand gc1 in ctrlSubstation_Info1.GridView.Bands)
{
try
{
if (gc1.Columns[0].Name == gc.Name)
{
gc1.Visible = false;
}
}
catch { }
}
gc.Visible = false;
gc.OptionsColumn.ShowInCustomizationForm = false;
Substation_Info si = new Substation_Info();
si.Title = gc.FieldName + "=''";
si.Flag = flag;
UCDeviceBase.DataService.Update("UpdateSubstation_InfoByFlag", si);
PowerSubstationLine psl = new PowerSubstationLine();
psl.ClassType = gc.FieldName;
psl.Flag = flag;
psl.Type = type;
psl.Title = gc.Caption;
psl.Type2 = "SubstationGuiHua";
UCDeviceBase.DataService.Update("DeletePowerSubstationLineByAll", psl);
}
/// <summary>
/// 删除焦点对象
/// </summary>
public void DeleteObject()
{
//获取焦点对象
Substation_Info obj = FocusedObject;
if (obj == null)
{
return;
}
//请求确认
if (MsgBox.ShowYesNo(Strings.SubmitDelete) != DialogResult.Yes)
{
return;
}
//执行删除操作
try
{
Services.BaseService.Delete <Substation_Info>(obj);
}
catch (Exception exc)
{
Debug.Fail(exc.Message);
HandleException.TryCatch(exc);
return;
}
this.bandedGridView1.BeginUpdate();
//记住当前焦点行索引
int iOldHandle = this.bandedGridView1.FocusedRowHandle;
//从链表中删除
ObjectList.Remove(obj);
//刷新表格
int i = 1;
foreach (Substation_Info info in ObjectList)
{
info.L23 = i.ToString();
i++;
}
gridControl.RefreshDataSource();
//设置新的焦点行索引
GridHelper.FocuseRowAfterDelete(this.bandedGridView1, iOldHandle);
this.bandedGridView1.EndUpdate();
}
/// <summary>
/// 刷新表格中的数据
/// </summary>
/// <returns>ture:成功 false:失败</returns>
public bool RefreshData1(PSP_ELCPROJECT proj)
{
try
{
string filepath = "";
// IList<Substation_Info> list = UCDeviceBase.DataService.GetList<Substation_Info>("SelectSubstation_InfoByFlag",flags1);
string con = " AreaID = '" + Itop.Client.MIS.ProgUID + "' AND UID IN (SELECT PSPDEV.SVGUID FROM PSPDEV, PSP_ELCDEVICE WHERE PSPDEV.SUID = PSP_ELCDEVICE.DeviceSUID AND PSP_ELCDEVICE.ProjectSUID = '" + proj.ID + "'AND Type='01')";
IList <Substation_Info> list = UCDeviceBase.DataService.GetList <Substation_Info>("SelectSubstation_InfoByCon", con);
for (int i = 0; i < list.Count; i++)
{
Substation_Info sb = (Substation_Info)list[i];
if (Convert.ToInt32(sb.L2) != 0 && sb.L2 != null)
{
sb.L10 = Convert.ToDouble(Convert.ToDouble(sb.L9) / sb.L2 * 100);
//sb.GetType().GetProperty("L10").SetValue(sb, LL10, null);
}
else
{
sb.L10 = 0;
}
}
if (xmlflag == "guihua")
{
filepath = Path.GetTempPath() + "\\" + Path.GetFileName("SubstationGuiHua.xml");
}
else
{
filepath = Path.GetTempPath() + "\\" + Path.GetFileName("SubstationLayOut11.xml");
}
if (File.Exists(filepath))
{
this.bandedGridView1.RestoreLayoutFromXml(filepath);
}
this.gridControl.DataSource = list;
}
catch (Exception exc)
{
Debug.Fail(exc.Message);
HandleException.TryCatch(exc);
return(false);
}
return(true);
}
/// <summary>
/// 添加对象
/// </summary>
public void AddObject()
{
//检查对象链表是否已经加载
if (ObjectList == null)
{
return;
}
//新建对象
Substation_Info obj = new Substation_Info();
obj.Flag = flags1;
obj.CreateDate = DateTime.Now;
//obj.L1 = 100;
//obj.L2 = 100;
//obj.L3 = 100;
//执行添加操作
using (FrmSubstation_Info_LangFangDialog dlg = new FrmSubstation_Info_LangFangDialog())
{
dlg.Type = types1;
dlg.Flag = flags2;
dlg.Type2 = types2;
dlg.ctrlSubstation_Info = this;
dlg.IsCreate = true; //设置新建标志
dlg.Object = obj;
if (dlg.ShowDialog() != DialogResult.OK)
{
return;
}
}
//将新对象加入到链表中
ObjectList.Add(obj);
int i = 1;
foreach (Substation_Info info in ObjectList)
{
info.L23 = i.ToString();
i++;
}
//刷新表格，并将焦点行定位到新对象上。
gridControl.RefreshDataSource();
GridHelper.FocuseRow(this.bandedGridView1, obj);
}
/// <summary>
/// 刷新表格中的数据
/// </summary>
/// <returns>ture:成功 false:失败</returns>
public bool RefreshData1()
{
try
{
string filepath = "";
// IList<Substation_Info> list = UCDeviceBase.DataService.GetList<Substation_Info>("SelectSubstation_InfoByFlag",flags1);
string con = "Flag<='" + flags1 + "' and AreaID='" + projectid + "'";
IList <Substation_Info> list = UCDeviceBase.DataService.GetList <Substation_Info>("SelectSubstation_InfoByCon", con);
for (int i = 0; i < list.Count; i++)
{
Substation_Info sb = (Substation_Info)list[i];
if (sb.L2 != 0 && sb.L2 != null)
{
sb.L10 = Convert.ToDouble(Convert.ToDouble(sb.L9) / sb.L2 * 100);
//sb.GetType().GetProperty("L10").SetValue(sb, LL10, null);
}
else
{
sb.L10 = 0;
}
}
if (xmlflag == "guihua")
{
filepath = Path.GetTempPath() + "\\" + Path.GetFileName("SubstationGuiHua.xml");
}
else
{
filepath = Path.GetTempPath() + "\\" + Path.GetFileName("SubstationLayOut11.xml");
}
if (File.Exists(filepath))
{
this.bandedGridView1.RestoreLayoutFromXml(filepath);
}
this.gridControl.DataSource = list;
}
catch (Exception exc)
{
Debug.Fail(exc.Message);
HandleException.TryCatch(exc);
return(false);
}
return(true);
}
private void bh_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
{
frmSubSelS f = new frmSubSelS();
if (getSubType(LabelTxt) == "规划")
{
f.ReDate(layerID, false, false, getLvl(LabelTxt));
}
else
{
f.ReDate("", true, false, getLvl(LabelTxt));
}
if (f.ShowDialog() == DialogResult.OK)
{
p = f.ctrlSubstation_Info1.FocusedObject;
sub.EleName = p.Title;
if (p.L2 == null || p.L2 == 0)
{
sub.Number = 0;
}
else
{
sub.Number = Convert.ToDecimal(p.L2);
}
sub.ObligateField2 = p.L1.ToString();
if (p.L9 == null || p.L9 == 0)
{
sub.Burthen = 0;
}
else
{
sub.Burthen = Convert.ToDecimal(p.L9);
}
bh.Text = sub.EleName;
fhl.EditValue = sub.ObligateField2;
Maxfh.Text = sub.Burthen.ToString("#####.##");
dl.Text = sub.Number.ToString("#####.##");
OldUID = p.Code;
p.Code = sub.UID;
SubUpdate = true;
}
}
/// <summary>
/// 删除焦点对象
/// </summary>
public void DeleteObject()
{
//获取焦点对象
Substation_Info obj = FocusedObject;
if (obj == null)
{
return;
}
if (obj.S4 == "no")
{
MessageBox.Show("此行不能删除!", "删除"); return;
}
//请求确认
if (MsgBox.ShowYesNo(Strings.SubmitDelete) != DialogResult.Yes)
{
return;
}
//执行删除操作
try
{
Services.BaseService.Delete <Substation_Info>(obj);
}
catch (Exception exc)
{
Debug.Fail(exc.Message);
HandleException.TryCatch(exc);
return;
}
this.bandedGridView1.BeginUpdate();
//记住当前焦点行索引
//int iOldHandle = this.bandedGridView1.FocusedRowHandle;
////从链表中删除
//ObjectList.Remove(obj);
////刷新表格
//gridControl.RefreshDataSource();
////设置新的焦点行索引
//GridHelper.FocuseRowAfterDelete(this.bandedGridView1, iOldHandle);
CalcTotal();
this.bandedGridView1.EndUpdate();
}
/// <summary>
/// 添加对象
/// </summary>
public void AddObject()
{
//检查对象链表是否已经加载
if (ObjectList == null)
{
return;
}
//新建对象
Substation_Info obj = new Substation_Info();
obj.Flag = flags;
if (ObjectList.Count > 0)
{
obj.AreaID = Convert.ToInt32(ObjectList[ObjectList.Count - 1].AreaID) + 1 + "";
}
else
{
obj.AreaID = "1";
}
//执行添加操作
using (FrmSubstation_InfoDialog_TongLing dlg = new FrmSubstation_InfoDialog_TongLing())
{
dlg.Type1 = types1;
dlg.Flag = flags1;
dlg.Type2 = types2;
dlg.ctrlSubstation_Info = this;
dlg.IsCreate = true; //设置新建标志
dlg.Object = obj;
if (dlg.ShowDialog() != DialogResult.OK)
{
return;
}
}
//将新对象加入到链表中
ObjectList.Add(obj);
RowCalculate(ref obj);
//刷新表格，并将焦点行定位到新对象上。
gridControl.RefreshDataSource();
GridHelper.FocuseRow(this.gridView, obj);
}
/// <summary>
/// 添加对象
/// </summary>
public void AddObject()
{
//检查对象链表是否已经加载
//if (ObjectList == null)
//{
// return;
//}
//新建对象
Substation_Info obj = new Substation_Info();
obj.Flag = flags1;
obj.CreateDate = DateTime.Now;
//obj.L1 = 100;
//obj.L2 = 100;
//obj.L3 = 100;
//执行添加操作
using (FrmSubstation_InfoDialog dlg = new FrmSubstation_InfoDialog())
{
dlg.SetVisible();
dlg.Type = types1;
dlg.Flag = flags1;
dlg.ctrlSubstation_Info = this;
dlg.ProjectID = projectid;
dlg.IsCreate = true; //设置新建标志
dlg.Object = obj;
if (dlg.ShowDialog() != DialogResult.OK)
{
return;
}
}
this.bandedGridView1.BeginUpdate();
CalcTotal();
//CalcTotal(" order by convert(int,L1) desc,AreaName desc,S4,CreateDate,convert(int,S5) ");
this.bandedGridView1.EndUpdate();
//将新对象加入到链表中
//ObjectList.Add(obj);
////刷新表格，并将焦点行定位到新对象上。
//gridControl.RefreshDataSource();
//GridHelper.FocuseRow(this.bandedGridView1, obj);
}
/// <summary>
/// 修改焦点对象
/// </summary>
public void UpdateObject()
{
//获取焦点对象
Substation_Info obj = FocusedObject;
if (obj == null)
{
return;
}
if (obj.S4 == "no")
{
MessageBox.Show("此行不能修改!"); return;
}
//创建对象的一个副本
Substation_Info objCopy = new Substation_Info();
DataConverter.CopyTo <Substation_Info>(obj, objCopy);
//执行修改操作
using (FrmSubstation_InfoDialog dlg = new FrmSubstation_InfoDialog())
{
dlg.SetVisible();
dlg.IsSelect = isselect;
dlg.Type = types1;
dlg.Flag = flags1;
dlg.ctrlSubstation_Info = this;
dlg.ProjectID = projectid;
dlg.Object = objCopy; //绑定副本
if (dlg.ShowDialog() != DialogResult.OK)
{
return;
}
}
//用副本更新焦点对象
DataConverter.CopyTo <Substation_Info>(objCopy, obj);
this.bandedGridView1.BeginUpdate();
CalcTotal();
//刷新表格
//gridControl.RefreshDataSource();
this.bandedGridView1.EndUpdate();
}
private void btnOK_Click(object sender, EventArgs e)
{
if (_obj.AreaName == "")
{
MsgBox.Show("建设地点为必填项！");
return;
}
if (_obj.Title == "")
{
MsgBox.Show("变电站名称为必填项！");
return;
}
if (isselect)
{
DialogResult = DialogResult.OK;
return;
}
if (!InputCheck())
{
return;
}
if (SaveRecord())
{
if (checkEdit1.Checked)
{
ctrls.RefreshData();
_obj = new Substation_Info();
_obj.Flag = flags1;
IList <Substation_Info> list1 = new List <Substation_Info>();
list1.Add(_obj);
this.vGridControl.DataSource = list1;
}
else
{
DialogResult = DialogResult.OK;
}
}
}
/// <summary>
/// 修改焦点对象
/// </summary>
public void UpdateObject()
{
//获取焦点对象
Substation_Info obj = FocusedObject;
if (obj == null)
{
return;
}
//创建对象的一个副本
Substation_Info objCopy = new Substation_Info();
DataConverter.CopyTo <Substation_Info>(obj, objCopy);
//执行修改操作
using (FrmSubstation_Info_LangFangDialog dlg = new FrmSubstation_Info_LangFangDialog())
{
dlg.IsSelect = isselect;
dlg.Type = types1;
dlg.Flag = flags2;
dlg.Type2 = types2;
dlg.ctrlSubstation_Info = this;
dlg.Object = objCopy; //绑定副本
if (dlg.ShowDialog() != DialogResult.OK)
{
return;
}
}
//用副本更新焦点对象
DataConverter.CopyTo <Substation_Info>(objCopy, obj);
//刷新表格
gridControl.RefreshDataSource();
}
private void InsertSubstation_Info()
{
//LayoutList ll1 = this.ctrlLayoutList1.FocusedObject;
//if (ll1 == null)
// return;
string columnname = "";
try
{
DataTable dts = new DataTable();
OpenFileDialog op = new OpenFileDialog();
op.Filter = "Excel文件(*.xls)|*.xls";
if (op.ShowDialog() == DialogResult.OK)
{
dts = GetExcel(op.FileName);
IList <Substation_Info> lii = new List <Substation_Info>();
DateTime s8 = DateTime.Now;
int x = 0;
for (int i = 0; i < dts.Rows.Count; i++)
{
if (dts.Rows[i][1].ToString().IndexOf("合计") >= 0)
{
continue;
}
Substation_Info l1 = new Substation_Info();
foreach (DataColumn dc in dts.Columns)
{
columnname = dc.ColumnName;
if (dts.Rows[i][dc.ColumnName].ToString() == "")
{
continue;
}
switch (dc.ColumnName)
{
case "L2":
case "L9":
double LL2 = 0;
try
{
LL2 = Convert.ToDouble(dts.Rows[i][dc.ColumnName].ToString());
}
catch { }
l1.GetType().GetProperty(dc.ColumnName).SetValue(l1, LL2, null);
break;
case "L10":
double L10 = 0;
try
{
L10 = ChangeDou(dts.Rows[i][dc.ColumnName].ToString());
}
catch { }
l1.GetType().GetProperty(dc.ColumnName).SetValue(l1, L10, null);
break;
case "L1":
case "L3":
int LL3 = 0;
try
{
LL3 = Convert.ToInt32(dts.Rows[i][dc.ColumnName].ToString());
}
catch { }
l1.GetType().GetProperty(dc.ColumnName).SetValue(l1, LL3, null);
break;
default:
l1.GetType().GetProperty(dc.ColumnName).SetValue(l1, dts.Rows[i][dc.ColumnName].ToString(), null);
break;
}
}
l1.Flag = selectid;
l1.CreateDate = s8.AddSeconds(i);
l1.AreaID = ProjectUID;
lii.Add(l1);
}
foreach (Substation_Info lll in lii)
{
Substation_Info l1 = new Substation_Info();
l1.AreaName = lll.AreaName;
l1.Title = lll.Title;
l1.AreaID = ProjectUID;
l1.Flag = selectid;
string con = "AreaID='" + ProjectUID + "' and Title='" + l1.Title + "' and Flag='" + selectid + "'";
object obj = Services.BaseService.GetObject("SelectSubstation_InfoByCon", con);
if (obj != null)
{
lll.UID = ((Substation_Info)obj).UID;
Services.BaseService.Update <Substation_Info>(lll);
}
else
{
Services.BaseService.Create <Substation_Info>(lll);
}
}
this.ctrlSubstation_Info1.CalcTotal();
}
}
catch (Exception ex) { MsgBox.Show(columnname + ex.Message); MsgBox.Show("导入格式不正确！"); }
}
private void InitSodata2()
{
string sid = selectid;
if (sid == "")
{
return;
}
Hashtable hs1 = new Hashtable();
Hashtable hs3 = new Hashtable();
substation suub = new substation();
suub.UID = sid;
suub.EleName = leixing;
IList <substation> listsubstation = Services.BaseService.GetList <substation>("SelectsubstationByPowerID1", sid);
foreach (substation s1 in listsubstation)
{
hs1.Add(Guid.NewGuid().ToString(), s1.UID);
}
IList <Substation_Info> ll2 = Common.Services.BaseService.GetList <Substation_Info>("SelectSubstation_InfoByFlag", sid);
foreach (Substation_Info ps in ll2)
{
hs3.Add(Guid.NewGuid().ToString(), ps.Code);
}
foreach (Substation_Info p2 in ll2)
{
if (p2.Code != "" && !hs1.ContainsValue(p2.Code))
{
//删除
Services.BaseService.Delete <Substation_Info>(p2);
}
}
foreach (substation s2 in listsubstation)
{
if (!hs3.ContainsValue(s2.UID) && s2.ObligateField1 != "")
{
//添加
try
{
Substation_Info substation1 = new Substation_Info();
substation1.L1 = int.Parse(s2.ObligateField1);
substation1.Title = s2.EleName;
substation1.Code = s2.UID;
substation1.Flag = sid;
try
{
substation1.L1 = int.Parse(s2.ObligateField1);
}
catch { }
try
{
substation1.L10 = double.Parse(s2.ObligateField2);
}
catch { }
try
{
substation1.L2 = Convert.ToDouble(s2.Number);
}
catch { }
try
{
substation1.L9 = Convert.ToDouble(s2.Burthen);
}
catch { }
substation1.AreaID = ProjectUID;
Services.BaseService.Create <Substation_Info>(substation1);
}
catch { }
}
}
}
private void InsertSubstation_Info()
{
string columnname = "";
try
{
DataTable dts = new DataTable();
OpenFileDialog op = new OpenFileDialog();
op.Filter = "Excel文件(*.xls)|*.xls";
if (op.ShowDialog() == DialogResult.OK)
{
dts = GetExcel(op.FileName);
IList <Substation_Info> lii = new List <Substation_Info>();
DateTime s8 = DateTime.Now;
for (int i = 2; i < dts.Rows.Count; i++)
{
if (dts.Rows[i][1].ToString().IndexOf("合计") >= 0)
{
continue;
}
Substation_Info l1 = new Substation_Info();
foreach (DataColumn dc in dts.Columns)
{
columnname = dc.ColumnName;
if (dts.Rows[i][dc.ColumnName].ToString() == "")
{
continue;
}
switch (dc.ColumnName)
{
case "L2":
case "L9":
case "L10":
double LL2 = 0;
try
{
LL2 = Convert.ToDouble(dts.Rows[i][dc.ColumnName].ToString());
}
catch { }
l1.GetType().GetProperty(dc.ColumnName).SetValue(l1, LL2, null);
break;
case "L1":
case "L3":
int LL3 = 0;
try
{
LL3 = Convert.ToInt32(dts.Rows[i][dc.ColumnName].ToString());
}
catch { }
l1.GetType().GetProperty(dc.ColumnName).SetValue(l1, LL3, null);
break;
case "L13":
case "L14":
case "L15":
case "L16":
case "L17":
case "L18":
case "L19":
case "L20":
////int LL3 = 0;
////try
////{
//// LL3 = Convert.ToInt32(dts.Rows[i][dc.ColumnName].ToString());
////}
////catch { }
l1.GetType().GetProperty(dc.ColumnName).SetValue(l1, dts.Rows[i][dc.ColumnName].ToString(), null);
break;
default:
l1.GetType().GetProperty(dc.ColumnName).SetValue(l1, dts.Rows[i][dc.ColumnName].ToString(), null);
break;
}
}
l1.Flag = "1";
l1.CreateDate = s8.AddSeconds(i);
lii.Add(l1);
}
foreach (Substation_Info lll in lii)
{
Substation_Info l1 = new Substation_Info();
l1.AreaName = lll.AreaName;
l1.Title = lll.Title;
l1.Flag = "1";
object obj = Services.BaseService.GetObject("SelectSubstation_InfoByNameFlag", l1);
if (obj != null)
{
lll.UID = ((Substation_Info)obj).UID;
Services.BaseService.Update <Substation_Info>(lll);
}
else
{
Services.BaseService.Create <Substation_Info>(lll);
}
}
this.ctrlSubstation_Info_LangFang1.RefreshData();
}
}
catch (Exception ex) { MsgBox.Show(columnname + ex.Message); MsgBox.Show("导入格式不正确！"); }
}
public void CalcTotal()
{
int x5 = 1, x1 = 1, x2 = 1, x1z = 1, x35 = 1;
double h5 = 0, h1 = 0, h2 = 0, h1z = 0, h35 = 0, z5 = 0, z1 = 0, z2 = 0, z1z = 0, z35 = 0;
int index5 = -1, index2 = -1, index1 = -1, index1z = -1, index35 = -1;
Hashtable table = new Hashtable();
bool one = true, five = true, two = true, onez = true, three = true;
string area = "";
int j = 0;
int now = 0;
string con = "Flag='" + flags1 + "' and AreaID='" + projectid + "'";
string[] que = new string[60] {
"一", "二", "三", "四", "五", "六", "七", "八", "九", "十",
"十一", "十二", "十三", "十四", "十五", "十六", "十七", "十八", "十九", "二十", "二十一", "二十二", "二十三", "二十四", "二十五", "二十六", "二十七",
"二十八", "二十九", "三十", "三十一", "三十二", "三十三", "三十四", "三十五", "三十六", "三十七", "三十八", "三十九", "四十", "四十一", "四十二", "四十三", "四十四",
"四十五", "四十六", "四十七", "四十八", "四十九", "五十", "五十一", "五十二", "五十三", "五十四", "五十五", "五十六", "五十七", "五十八", "五十九", "六十"
};
IList list = Common.Services.BaseService.GetList("SelectSubstation_InfoByCon", con);
string conn = "L1=110";
// IList groupList = Common.Services.BaseService.GetList("SelectAreaNameGroupByConn", conn);
IList <string> groupList = new List <string>();
for (int i = 0; i < list.Count; i++)
{
if (((Substation_Info)list[i]).L1 == 500)
{
if (five)
{
index5 = i;
five = false;
}
((Substation_Info)list[i]).S3 = x5.ToString();
h5 += ((Substation_Info)list[i]).L2;
try
{
z5 += double.Parse(((Substation_Info)list[i]).L5);
}
catch { }
x5++;
}
else if (((Substation_Info)list[i]).L1 == 220)
{
if (two)
{
index2 = i; two = false;
}
((Substation_Info)list[i]).S3 = x2.ToString();
h2 += ((Substation_Info)list[i]).L2;
try
{
z2 += double.Parse(((Substation_Info)list[i]).L5);
}
catch { }
x2++;
}
else if (((Substation_Info)list[i]).L1 == 110 && ((Substation_Info)list[i]).S4 == "专用")
{
if (onez)
{
index1z = i; onez = false;
}
((Substation_Info)list[i]).S3 = x1z.ToString();
h1z += ((Substation_Info)list[i]).L2;
try
{
z1z += double.Parse(((Substation_Info)list[i]).L5);
}
catch { }
x1z++;
}
else if (((Substation_Info)list[i]).L1 == 110 && ((Substation_Info)list[i]).S4 != "专用")
{
if (((Substation_Info)list[i]).AreaName != area)
{
table.Add(((Substation_Info)list[i]).AreaName, i);
groupList.Add(((Substation_Info)list[i]).AreaName);
// table[((Substation_Info)list[i]).AreaName] = i;
area = ((Substation_Info)list[i]).AreaName;
}
if (one)
{
index1 = i; one = false;
}
((Substation_Info)list[i]).S3 = x1.ToString();
h1 += ((Substation_Info)list[i]).L2;
try
{
z1 += double.Parse(((Substation_Info)list[i]).L5);
}
catch { }
x1++;
}
else if (((Substation_Info)list[i]).L1 == 35)
{
if (three)
{
index35 = i; three = false;
}
((Substation_Info)list[i]).S3 = x35.ToString();
h35 += ((Substation_Info)list[i]).L2;
try
{
z35 += double.Parse(((Substation_Info)list[i]).L5);
}
catch { }
x35++;
}
}
if (x5 > 1)
{
Substation_Info info = new Substation_Info();
info.S3 = que[j];
j++;
info.Title = "500千伏";
info.L2 = h5;
info.L5 = z5.ToString();
info.L1 = 500;
info.S4 = "no";
list.Insert(index5, info);//.Add(info);
now++;
}
if (x2 > 1)
{
Substation_Info info2 = new Substation_Info();
info2.S3 = que[j];
j++;
info2.Title = "220千伏";
info2.L2 = h2;
info2.L5 = z2.ToString();
info2.L1 = 220;
info2.S4 = "no";
list.Insert(index2 + now, info2);
now++;
}
if (x1 > 1)
{
Substation_Info info1 = new Substation_Info();
info1.S3 = que[j];
j++;
info1.Title = "110千伏公变";
info1.L2 = h1;
info1.L5 = z1.ToString();
info1.L1 = 110;
info1.S4 = "no";
list.Insert(index1 + now, info1);
now++;
for (int k = 0; k < groupList.Count; k++)
{
Substation_Info infok = new Substation_Info();
infok.S3 = Convert.ToChar(k + 65).ToString().ToLower();
infok.Title = groupList[k];
conn = "L1=110 and AreaName='" + groupList[k] + "'";
IList temList = Common.Services.BaseService.GetList("SelectSumSubstation_InfoByConn", conn);
infok.L2 = ((Substation_Info)temList[0]).L2;
infok.L5 = ((Substation_Info)temList[0]).L5;
infok.L1 = 110;
infok.S4 = "no";
list.Insert(int.Parse(table[groupList[k]].ToString()) + now, infok);
now++;
}
}
if (x1z > 1)
{
Substation_Info info1z = new Substation_Info();
info1z.S3 = que[j];
j++;
info1z.Title = "110千伏专变";
info1z.L2 = h1z;
info1z.L5 = z1z.ToString();
info1z.L1 = 110;
info1z.S4 = "no";
list.Insert(index1z + now, info1z);
now++;
}
if (x35 > 1)
{
Substation_Info info35 = new Substation_Info();
info35.S3 = que[j];
j++;
info35.Title = "35千伏";
info35.L2 = h35;
info35.L5 = z35.ToString();
info35.L1 = 35;
info35.S4 = "no";
list.Insert(index35 + now, info35);
now++;
}
this.gridControl.DataSource = list;
}
private void barRel_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
for (int i = 0; i < this.ctrlSubstation_Info1.GridView.RowCount; i++)
{
Substation_Info trans = this.ctrlSubstation_Info1.GridView.GetRow(i) as Substation_Info;
int num = Convert.ToInt32(trans.L3);
double fuhepercent = Convert.ToDouble(trans.L10);
bool flag = false;
int zeroflag = 0; //如果主变台数为零时给个提醒
switch (num)
{
case 0:
{
zeroflag = 1;
break;
}
case 1:
{
zeroflag = 2;
break;
}
case 2:
{
if (fuhepercent >= 65)
{
flag = true;
}
break;
}
case 3:
{
if (fuhepercent >= 87)
{
flag = true;
}
break;
}
case 4:
{
if (fuhepercent >= 97)
{
flag = true;
}
break;
}
}
if (flag)
{
row_num.Add(i);
trans.S1 = "不合格"; //此列是产生在分类管理中
}
else if (!flag && zeroflag == 0)
{
trans.S1 = "合格";
}
else if (zeroflag == 1)
{
trans.S1 = "主变台数为零";
}
else if (zeroflag == 2)
{
trans.S1 = "此为单台主变";
}
UCDeviceBase.DataService.Update <Substation_Info>(trans);
}
foreach (GridBand gc in this.ctrlSubstation_Info1.GridView.Bands)
{
try
{
if (gc.Columns[0].FieldName.Substring(0, 1) == "S")
{
gc.Visible = false;
}
if (gc.Columns[0].FieldName == "S1")
{
gc.Visible = true;
gc.Caption = "合格判断";
gc.Columns[0].Caption = "合格判断";
gc.Columns[0].Visible = true;
gc.Columns[0].OptionsColumn.ShowInCustomizationForm = true;
}
}
catch { }
}
this.ctrlSubstation_Info1.kekaoflag = true;
this.ctrlSubstation_Info1.row_num = row_num;
//this.ctrlSubstation_Info1.RefreshData1();
this.ctrlSubstation_Info1.RefreshData1(parentobj);
}
private void simpleButton1_Click(object sender, EventArgs e)
{
if (bh.Text == "")
{
MessageBox.Show("变电站名称不能为空。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
//if (dl.Text == "") {
// MessageBox.Show("变电站容量不能为空。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
// return;
//}
//if (getObligateField4(LabelTxt) == "局有")
//{
// if (fhl.Text == "")
// {
// MessageBox.Show("负荷率不能为空。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
// return;
// }
//}
//if (Maxfh.Text == "")
//{
// MessageBox.Show("最大负荷不能为空。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
// return;
//}
//if (comboTcnf.Text != "" && comy.Text != "")
//{
sub.ObligateField5 = comboTcnf.Text;// +"-" + comy.Text;
//}
if (IsCreate)
{
//gPro.ParentEleID = "1";
substation _s = new substation();
_s.EleName = sub.EleName;
_s.SvgUID = sub.SvgUID;
IList mlist = Services.BaseService.GetList("SelectsubstationByEleNameCK", _s);
if (mlist.Count > 0)
{
MessageBox.Show("变电站名称重复。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
//return;
}
sub.ObligateField1 = getLvl(LabelTxt);
sub.ObligateField3 = getSubType(LabelTxt);
sub.ObligateField4 = getObligateField4(LabelTxt);
sub.ObligateField6 = jsdd.Text;
sub.ObligateField7 = zbts.Text;
Services.BaseService.Create <substation>(sub);
}
else
{
sub.LayerID = layerID;
sub.ObligateField1 = getLvl(LabelTxt);
sub.ObligateField3 = getSubType(LabelTxt);
sub.ObligateField4 = getObligateField4(LabelTxt);
sub.ObligateField6 = jsdd.Text;
sub.ObligateField7 = zbts.Text;
Services.BaseService.Update <substation>(sub);
}
if (SubUpdate)
{
Substation_Info temp = (Substation_Info)Services.BaseService.GetObject("SelectSubstation_InfoByCode", sub.UID);
if (temp != null)
{
temp.Code = "";
Services.BaseService.Update <Substation_Info>(temp);
}
substation _s = new substation();
_s.UID = OldUID;
substation _temps = Services.BaseService.GetOneByKey <substation>(_s);
if (_temps != null)
{
if (_temps.EleID == "")
{
Services.BaseService.Update("Deletesubstation", _temps);
}
}
Services.BaseService.Update <Substation_Info>(p);
}
Substation_Info ppt = (Substation_Info)Services.BaseService.GetObject("SelectSubstation_InfoByCode", sub.UID);
if (ppt != null)
{
ppt.L1 = Convert.ToInt32(sub.ObligateField1.ToLower().Replace("kv", ""));
ppt.Title = sub.EleName;//名称
//ppt.L1 = "";//台数
try
{
// ppt.L2 = Convert.ToDouble(sub.Number);//容量
ppt.L10 = Convert.ToDouble(sub.ObligateField2); //负荷率
ppt.L9 = Convert.ToDouble(sub.Burthen); //最大负荷
ppt.L22 = sub.ObligateField5;
Services.BaseService.Update <Substation_Info>(ppt);
}
catch { }
}
this.DialogResult = DialogResult.OK;
this.Close();
}
public void Calc(string addConn)
{
int x5 = 1, x1 = 1, x2 = 1, x1z = 1, x35 = 1, x10 = 1, x6 = 1, t5 = 0, t2 = 0, t1 = 0, t1z = 0, t35 = 0, t10 = 0, t6 = 0;
double h5 = 0, h1 = 0, h2 = 0, h1z = 0, h35 = 0, h10 = 0, h6 = 0, z5 = 0, z1 = 0, z2 = 0, z1z = 0, z35 = 0, z10 = 0, z6 = 0;
int index5 = -1, index2 = -1, index1 = -1, index1z = -1, index35 = -1, index10 = -1, index6 = -1;
Hashtable table = new Hashtable();
bool one = true, five = true, two = true, onez = true, three = true, ten = true, six = true;
string area = "1@3$5q99z99";
int j = 0;
int now = 0;
string con = "AreaID='" + projectid + "'";
con += addConn;
con += " order by convert(int,L1) desc,S4,AreaName,CreateDate,convert(int,S5)";
string[] que = new string[60] {
"一", "二", "三", "四", "五", "六", "七", "八", "九", "十",
"十一", "十二", "十三", "十四", "十五", "十六", "十七", "十八", "十九", "二十", "二十一", "二十二", "二十三", "二十四", "二十五", "二十六", "二十七",
"二十八", "二十九", "三十", "三十一", "三十二", "三十三", "三十四", "三十五", "三十六", "三十七", "三十八", "三十九", "四十", "四十一", "四十二", "四十三", "四十四",
"四十五", "四十六", "四十七", "四十八", "四十九", "五十", "五十一", "五十二", "五十三", "五十四", "五十五", "五十六", "五十七", "五十八", "五十九", "六十"
};
//IList list = Common.Services.BaseService.GetList("SelectSubstation_InfoByCon", con);
IList list = Common.Services.BaseService.GetList("SelectSubstation_InfoByWhere", con);
string conn = "L1=110";
// IList groupList = Common.Services.BaseService.GetList("SelectAreaNameGroupByConn", conn);
IList <string> groupList = new List <string>();
Hashtable table2 = new Hashtable();
IList <string> groupList2 = new List <string>();
string area2 = "1@3$5q99z99";
for (int i = 0; i < list.Count; i++)
{
if (((Substation_Info)list[i]).L1 == 500)
{
if (five)
{
index5 = i;
five = false;
}
((Substation_Info)list[i]).S3 = x5.ToString();
h5 += ((Substation_Info)list[i]).L2;
try
{
z5 += double.Parse(((Substation_Info)list[i]).L5);
}
catch { }
try
{
t5 += (int)((Substation_Info)list[i]).L3;
}
catch { }
x5++;
}
else if (((Substation_Info)list[i]).L1 == 220)
{
if (two)
{
index2 = i; two = false;
}
((Substation_Info)list[i]).S3 = x2.ToString();
h2 += ((Substation_Info)list[i]).L2;
try
{
z2 += double.Parse(((Substation_Info)list[i]).L5);
}
catch { }
try
{
t2 += (int)((Substation_Info)list[i]).L3;
}
catch { }
x2++;
}
else if (((Substation_Info)list[i]).L1 == 110 && ((Substation_Info)list[i]).S4 == "专用")
{
if (((Substation_Info)list[i]).AreaName != area2)
{
if (!table2.Contains(((Substation_Info)list[i]).AreaName))
{
table2.Add(((Substation_Info)list[i]).AreaName, i);
groupList2.Add(((Substation_Info)list[i]).AreaName);
// table[((Substation_Info)list[i]).AreaName] = i;
}
area2 = ((Substation_Info)list[i]).AreaName;
}
if (onez)
{
index1z = i; onez = false;
}
((Substation_Info)list[i]).S3 = x1z.ToString();
h1z += ((Substation_Info)list[i]).L2;
try
{
z1z += double.Parse(((Substation_Info)list[i]).L5);
}
catch { }
try
{
t1z += (int)((Substation_Info)list[i]).L3;
}
catch { }
x1z++;
}
else if (((Substation_Info)list[i]).L1 == 110 && ((Substation_Info)list[i]).S4 != "专用")
{
if (((Substation_Info)list[i]).AreaName != area)
{
if (!table.Contains(((Substation_Info)list[i]).AreaName))
{
table.Add(((Substation_Info)list[i]).AreaName, i);
groupList.Add(((Substation_Info)list[i]).AreaName);
// table[((Substation_Info)list[i]).AreaName] = i;
}
area = ((Substation_Info)list[i]).AreaName;
}
if (one)
{
index1 = i; one = false;
}
((Substation_Info)list[i]).S3 = x1.ToString();
h1 += ((Substation_Info)list[i]).L2;
try
{
z1 += double.Parse(((Substation_Info)list[i]).L5);
}
catch { }
try
{
t1 += (int)((Substation_Info)list[i]).L3;
}
catch { }
x1++;
}
else if (((Substation_Info)list[i]).L1 == 35)
{
if (three)
{
index35 = i; three = false;
}
((Substation_Info)list[i]).S3 = x35.ToString();
h35 += ((Substation_Info)list[i]).L2;
try
{
z35 += double.Parse(((Substation_Info)list[i]).L5);
}
catch { }
try
{
t35 += (int)((Substation_Info)list[i]).L3;
}
catch { }
x35++;
}
else if (((Substation_Info)list[i]).L1 == 10)
{
if (ten)
{
index10 = i; ten = false;
}
((Substation_Info)list[i]).S3 = x10.ToString();
h10 += ((Substation_Info)list[i]).L2;
try
{
z10 += double.Parse(((Substation_Info)list[i]).L5);
}
catch { }
try
{
t10 += (int)((Substation_Info)list[i]).L3;
}
catch { }
x10++;
}
else if (((Substation_Info)list[i]).L1 == 6)
{
if (six)
{
index6 = i; six = false;
}
((Substation_Info)list[i]).S3 = x6.ToString();
h6 += ((Substation_Info)list[i]).L2;
try
{
z6 += double.Parse(((Substation_Info)list[i]).L5);
}
catch { }
try
{
t6 += (int)((Substation_Info)list[i]).L3;
}
catch { }
x6++;
}
}
if (x5 > 1)
{
Substation_Info info = new Substation_Info();
info.S3 = que[j];
j++;
info.Title = "500千伏";
info.L2 = h5;
info.L5 = z5.ToString();
info.L3 = t5;
info.L1 = 500;
info.S4 = "no";
list.Insert(index5, info);//.Add(info);
now++;
}
if (x2 > 1)
{
Substation_Info info2 = new Substation_Info();
info2.S3 = que[j];
j++;
info2.Title = "220千伏";
info2.L2 = h2;
info2.L5 = z2.ToString();
info2.L3 = t2;
info2.L1 = 220;
info2.S4 = "no";
list.Insert(index2 + now, info2);
now++;
}
if (x1 > 1)
{
Substation_Info info1 = new Substation_Info();
info1.S3 = que[j];
j++;
info1.Title = "110千伏公变";
info1.L2 = h1;
info1.L5 = z1.ToString();
info1.L3 = t1;
info1.L1 = 110;
info1.S4 = "no";
list.Insert(index1 + now, info1);
now++;
for (int k = 0; k < groupList.Count; k++)
{
Substation_Info infok = new Substation_Info();
infok.S3 = Convert.ToChar(k + 65).ToString().ToLower();
//infok.Title = groupList[k];
infok.AreaName = groupList[k];
conn = "L1=110 and AreaID='" + projectid + "' and AreaName='" + groupList[k] + "' and S4!='专用'";
IList temList = Common.Services.BaseService.GetList("SelectSumSubstation_InfoByConn", conn);
infok.L2 = ((Substation_Info)temList[0]).L2;
infok.L5 = ((Substation_Info)temList[0]).L5;
infok.L1 = 110;
infok.S4 = "no";
temList = Common.Services.BaseService.GetList("SelectSubstation_InfoByWhere", conn);
infok.L3 = 0;
foreach (Substation_Info temp in temList)
{
try
{
infok.L3 += (int)temp.L3;
}
catch
{
}
}
list.Insert(int.Parse(table[groupList[k]].ToString()) + now, infok);
now++;
}
}
if (x1z > 1)
{
Substation_Info info1z = new Substation_Info();
info1z.S3 = que[j];
j++;
info1z.Title = "110千伏专变";
info1z.L2 = h1z;
info1z.L5 = z1z.ToString();
info1z.L3 = t1z;
info1z.L1 = 110;
info1z.S4 = "no";
list.Insert(index1z + now, info1z);
now++;
for (int k = 0; k < groupList2.Count; k++)
{
Substation_Info infok = new Substation_Info();
infok.S3 = Convert.ToChar(k + 65).ToString().ToLower();
//infok.Title = groupList2[k];
infok.AreaName = groupList2[k];
conn = "L1=110 and AreaID='" + projectid + "' and AreaName='" + groupList2[k] + "' and S4='专用'";
IList temList = Common.Services.BaseService.GetList("SelectSumSubstation_InfoByConn", conn);
infok.L2 = ((Substation_Info)temList[0]).L2;
infok.L5 = ((Substation_Info)temList[0]).L5;
infok.L1 = 110;
infok.S4 = "no";
temList = Common.Services.BaseService.GetList("SelectSubstation_InfoByWhere", conn);
infok.L3 = 0;
foreach (Substation_Info temp in temList)
{
try
{
infok.L3 += (int)temp.L3;
}
catch
{
}
}
list.Insert(int.Parse(table2[groupList2[k]].ToString()) + now, infok);
now++;
}
}
if (x35 > 1)
{
Substation_Info info35 = new Substation_Info();
info35.S3 = que[j];
j++;
info35.Title = "35千伏";
info35.L2 = h35;
info35.L5 = z35.ToString();
info35.L3 = t35;
info35.L1 = 35;
info35.S4 = "no";
list.Insert(index35 + now, info35);
now++;
}
if (x10 > 1)
{
Substation_Info info10 = new Substation_Info();
info10.S3 = que[j];
j++;
info10.Title = "10千伏";
info10.L2 = h10;
info10.L5 = z10.ToString();
info10.L3 = t10;
info10.L1 = 10;
info10.S4 = "no";
list.Insert(index10 + now, info10);
now++;
}
if (x6 > 1)
{
Substation_Info info6 = new Substation_Info();
info6.S3 = que[j];
j++;
info6.Title = "6千伏";
info6.L2 = h6;
info6.L5 = z6.ToString();
info6.L3 = t6;
info6.L1 = 6;
info6.S4 = "no";
list.Insert(index6 + now, info6);
now++;
}
this.gridControl.DataSource = list;
}
private void InitSodata2()
{
string sid = "1";
Hashtable hs1 = new Hashtable();
Hashtable hs3 = new Hashtable();
IList <substation> listsubstation = Services.BaseService.GetList <substation>("SelectsubstationByPowerIDStuff", sid);
foreach (substation s1 in listsubstation)
{
hs1.Add(Guid.NewGuid().ToString(), s1.UID);
}
IList <Substation_Info> ll2 = Common.Services.BaseService.GetList <Substation_Info>("SelectSubstation_InfoByFlag", sid);
foreach (Substation_Info ps in ll2)
{
hs3.Add(Guid.NewGuid().ToString(), ps.Code);
}
foreach (Substation_Info p2 in ll2)
{
if (p2.Code != "" && !hs1.ContainsValue(p2.Code))
{
//删除
Services.BaseService.Delete <Substation_Info>(p2);
}
}
foreach (substation s2 in listsubstation)
{
if (!hs3.ContainsValue(s2.UID) && s2.ObligateField1 != "")
{
//添加
try
{
Substation_Info substation1 = new Substation_Info();
substation1.L1 = int.Parse(s2.ObligateField1);
substation1.Title = s2.EleName;
substation1.Code = s2.UID;
substation1.Flag = sid;
try
{
substation1.L1 = int.Parse(s2.ObligateField1);
}
catch { }
try
{
substation1.L10 = double.Parse(s2.ObligateField2);
}
catch { }
try
{
substation1.L2 = Convert.ToDouble(s2.Number);
}
catch { }
try
{
substation1.L9 = Convert.ToDouble(s2.Burthen);
}
catch { }
try
{
substation1.L22 = s2.ObligateField5; //建设年份
}
catch { }
try
{
substation1.AreaName = s2.ObligateField6; //建设地点
}
catch { }
Services.BaseService.Create <Substation_Info>(substation1);
//Substation_Info substation1 = new Substation_Info();
//substation1.L1 = int.Parse(s2.ObligateField1);
//substation1.Title = s2.EleName;
//substation1.Code = s2.UID;
//substation1.Flag = sid;
//Services.BaseService.Create<Substation_Info>(substation1);
}
catch (Exception ex) {
System.Console.WriteLine(ex.Message);
}
}
}
}
public void InitSodata()
{
if (ctrlPowerEachList1.FocusedObject == null)
{
return;
}
string sid = typeFlag = ctrlPowerEachList1.FocusedObject.UID;
ctrlPSP_Project_List1.Flag = typeFlag;
Hashtable hs = new Hashtable();
Hashtable hs1 = new Hashtable();
IList <LineInfo> listLineInfo = Services.BaseService.GetList <LineInfo>("SelectLineInfoByPowerID", sid);
foreach (LineInfo l1 in listLineInfo)
{
hs.Add(Guid.NewGuid().ToString(), l1.UID);
}
IList <substation> listsubstation = Services.BaseService.GetList <substation>("SelectsubstationByPowerID2", sid);
foreach (substation s1 in listsubstation)
{
hs.Add(Guid.NewGuid().ToString(), s1.UID);
}
PSP_Project_List psp_Type = new PSP_Project_List();
psp_Type.Flag2 = sid;
IList <PSP_Project_List> listProTypes = Common.Services.BaseService.GetList <PSP_Project_List>("SelectPSP_Project_ListByFlag2", psp_Type);
foreach (PSP_Project_List ps in listProTypes)
{
hs1.Add(Guid.NewGuid().ToString(), ps.Code);
}
foreach (PSP_Project_List p1 in listProTypes)
{
if (p1.Code != "" && !hs.ContainsValue(p1.Code) && p1.ParentID != "0")
{
//删除
Services.BaseService.Delete <PSP_Project_List>(p1);
}
}
foreach (LineInfo l2 in listLineInfo)
{
if (!hs1.ContainsValue(l2.UID) && l2.Voltage != "")
{
//添加
try
{
PSP_Project_List ps2 = new PSP_Project_List();
ps2.ParentID = l2.Voltage.ToUpper().Replace("KV", "");
ps2.L3 = l2.LineName;
ps2.Code = l2.UID;
ps2.Flag = 1;
ps2.Flag2 = sid;
ps2.L4 = l2.Voltage;
ps2.L8 = double.Parse(l2.Length).ToString();;
ps2.L9 = l2.LineType;
if (l2.ObligateField1 == "运行")
{
ps2.L2 = "扩建";
}
else if (l2.ObligateField1 == "规划")
{
ps2.L2 = "新建";
}
ps2.L15 = l2.ObligateField3;
ps2.ID = Guid.NewGuid().ToString();
Services.BaseService.Create <PSP_Project_List>(ps2);
}
catch (Exception ex)
{
System.Console.WriteLine(ex.Message);
}
}
if (hs1.ContainsValue(l2.UID) && l2.Voltage != "")
{
//更新
try
{
PSP_Project_List p2 = new PSP_Project_List();
p2.Code = l2.UID;
p2.Flag2 = sid;
PSP_Project_List ps2 = (PSP_Project_List)Services.BaseService.GetObject("SelectPSP_Project_ListByObject", p2);
ps2.ParentID = l2.Voltage.ToUpper().Replace("KV", "");
ps2.Flag = 1;
if (l2.ObligateField1 == "运行")
{
l2.ObligateField1 = "扩建";
}
else if (l2.ObligateField1 == "规划")
{
l2.ObligateField1 = "新建";
}
if (double.Parse(l2.Length).ToString() == "" || double.Parse(l2.Length).ToString() == null)
{
l2.Length = "0";
}
if (ps2.L3 != l2.LineName || ps2.L4 != l2.Voltage || ps2.L8 != double.Parse(l2.Length).ToString() || ps2.L9 != l2.LineType || l2.ObligateField1 != ps2.L2 || ps2.L15 != l2.ObligateField3)
{
ps2.L3 = l2.LineName;
ps2.L4 = l2.Voltage;
ps2.L8 = double.Parse(l2.Length).ToString();
ps2.L9 = l2.LineType;
if (l2.ObligateField1 == "运行")
{
ps2.L2 = "扩建";
}
else if (l2.ObligateField1 == "规划")
{
ps2.L2 = "新建";
}
ps2.L15 = l2.ObligateField3;
Services.BaseService.Update("UpdatePSP_Project_ListByCode", ps2);
}
}
catch (Exception ex)
{
System.Console.WriteLine(ex.Message);
}
}
}
Project_Sum psp = new Project_Sum();
psp.S5 = "2";
IList <Project_Sum> sum = Common.Services.BaseService.GetList <Project_Sum>("SelectProject_SumByS5", psp);
Hashtable ha = new Hashtable();
ArrayList al = new ArrayList();
foreach (substation s2 in listsubstation)
{
if (!hs1.ContainsValue(s2.UID) && s2.ObligateField1 != "")
{
ha.Clear();
al.Clear();
int kk = 0;
//添加
try
{
Substation_Info sub = new Substation_Info();
sub.Code = s2.UID;
//Substation_Info station = (Substation_Info)Common.Services.BaseService.GetObject("SelectSubstation_InfoByCode", sub);
PSP_Project_List ps3 = new PSP_Project_List();
ps3.ParentID = s2.ObligateField1;
ps3.L3 = s2.EleName;
ps3.Code = s2.UID;
ps3.Flag = 2;
ps3.Flag2 = sid;
ps3.L4 = s2.ObligateField1.ToString();
if (s2.ObligateField3 == "运行")
{
ps3.L2 = "扩建";
}
else if (s2.ObligateField3 == "规划")
{
ps3.L2 = "新建";
}
ps3.L15 = s2.ObligateField5;
//if (station != null)
//{
// ps3.L5 = station.L3.ToString();
//}
foreach (Project_Sum ps1 in sum)
{
if (s2.ObligateField1.ToString() == ps1.S1.ToString())
{
try
{
double mva = double.Parse(s2.Number.ToString());
double t5 = Convert.ToDouble(ps1.T5); //单台容量
int ta = Convert.ToInt32(ps1.T1); //主变台数
if (mva == (t5 * ta))
{
ha.Add(t5, ta);
al.Add(t5);
}
}
catch { }
}
}
if (al.Count > 0)
{
double va = Convert.ToDouble(al[0].ToString());
for (int ii = 0; ii < al.Count; ii++)
{
if (va < Convert.ToDouble(al[ii].ToString()))
{
va = Convert.ToDouble(al[ii].ToString());
}
}
ps3.L5 = ha[va].ToString();
ps3.L6 = va.ToString();
}
else
{
ps3.L5 = "";
ps3.L6 = "";
}
ps3.IsConn = double.Parse(s2.Number.ToString()).ToString();//总容量
ps3.ID = Guid.NewGuid().ToString();
Services.BaseService.Create <PSP_Project_List>(ps3);
}
catch { }
}
if (hs1.ContainsValue(s2.UID) && s2.ObligateField1 != "")
{
ha.Clear();
al.Clear();
int kk = 0;
//更新
try
{
Substation_Info sub = new Substation_Info();
sub.Code = s2.UID;
//Substation_Info station = (Substation_Info)Common.Services.BaseService.GetObject("SelectSubstation_InfoByCode", sub);
PSP_Project_List p3 = new PSP_Project_List();
p3.Code = s2.UID;
p3.Flag2 = sid;
PSP_Project_List ps3 = (PSP_Project_List)Services.BaseService.GetObject("SelectPSP_Project_ListByObject", p3);
ps3.ParentID = s2.ObligateField1;
ps3.Flag = 2;
if (s2.ObligateField3 == "运行")
{
s2.ObligateField3 = "扩建";
}
else if (s2.ObligateField3 == "规划")
{
s2.ObligateField3 = "新建";
}
string l5 = "";
string l6 = "";
foreach (Project_Sum ps1 in sum)
{
if (s2.ObligateField1.ToString() == ps1.S1.ToString())
{
try
{
double mva = 0;
if (s2.Number.ToString() != "" && s2.Number.ToString() != null)
{
mva = double.Parse(s2.Number.ToString());
}
double t5 = Convert.ToDouble(ps1.T5); //单台容量
int ta = Convert.ToInt32(ps1.T1); //主变台数
if (mva == (t5 * ta))
{
ha.Add(t5, ta);
al.Add(t5);
}
}
catch { }
}
}
if (al.Count > 0)
{
double va = Convert.ToDouble(al[0].ToString());
for (int ii = 0; ii < al.Count; ii++)
{
if (va < Convert.ToDouble(al[ii].ToString()))
{
va = Convert.ToDouble(al[ii].ToString());
}
}
l5 = ha[va].ToString();
l6 = va.ToString();
}
else
{
l5 = "";
l6 = "";
}
if (ps3.L3 != s2.EleName || ps3.L4 != s2.ObligateField1.ToString() || s2.ObligateField3 != ps3.L2 || ps3.L15 != s2.ObligateField5 || ps3.L5 != l5 || ps3.L6 != l6)
{
ps3.L3 = s2.EleName;
ps3.L4 = s2.ObligateField1.ToString();
if (s2.ObligateField3 == "运行")
{
ps3.L2 = "扩建";
}
else if (s2.ObligateField3 == "规划")
{
ps3.L2 = "新建";
}
ps3.L15 = s2.ObligateField5;
//if (station != null)
//{
// ps3.L5 = station.L3.ToString();
//}
ps3.IsConn = double.Parse(s2.Number.ToString()).ToString();//总容量
Services.BaseService.Update("UpdatePSP_Project_ListByCode", ps3);
}
}
catch { }
}
}
}
private void simpleButton1_Click(object sender, EventArgs e)
{
for (int i = 0; i < te.Length; i++)
{
SaveCellValue(te[i].Name.Replace("Text", ""), poweruid, te[i].Text.Trim());
}
if (isline)
{
try
{
LineInfo li = Common.Services.BaseService.GetOneByKey <LineInfo>(powerid);
if (li != null)
{
li.LineName = cb0.Text;
li.Voltage = cb1.Text;
li.Length = tt4.Text;
li.LineType = cb5.Text;
Common.Services.BaseService.Update <LineInfo>(li);
}
}
catch { }
}
if (isPower)
{
try
{
substation sb = Common.Services.BaseService.GetOneByKey <substation>(powerid);
Substation_Info sub = new Substation_Info();
sub.Code = powerid;
Substation_Info sbinfo = (Substation_Info)Common.Services.BaseService.GetObject("SelectSubstation_InfoByCode", sub);
if (sbinfo != null)
{
sbinfo.L2 = double.Parse(cb3.Text);
sbinfo.L3 = int.Parse(cb2.Text);
Common.Services.BaseService.Update("UpdateSubstation_InfoByUID", sub);
}
if (sb != null)
{
try
{
sb.EleName = cb0.Text;
sb.ObligateField1 = cb1.Text;
}
catch { }
Common.Services.BaseService.Update <substation>(sb);
}
}
catch { }
}
try
{
PSP_PowerProValues_LangFang ppts = new PSP_PowerProValues_LangFang();
ppts.ID = poweruid;
ppts.Flag2 = flag;
PSP_PowerProValues_LangFang ppt1 = Common.Services.BaseService.GetOneByKey <PSP_PowerProValues_LangFang>(ppts);
try
{
ppt1.L3 = cb0.Text.ToString();
ppt1.L4 = cb1.Text.ToString();
ppt1.L5 = cb2.Text.ToString();
ppt1.L6 = cb3.Text.ToString();
ppt1.L7 = cb4.Text.ToString();
ppt1.L8 = tt4.Text.ToString();
ppt1.L9 = cb5.Text.ToString();
ppt1.L10 = double.Parse(tt5.Text.ToString());
ppt1.L11 = lookupedit;
ppt1.L12 = double.Parse(tt6.Text.ToString());
}
catch { }
Common.Services.BaseService.Update <PSP_PowerProValues_LangFang>(ppt1);
}
catch { }
this.DialogResult = DialogResult.OK;
}
