public override void UpdateIn(DataTable table) { for (int i = 0; i < table.Rows.Count; i++) { if (table.Rows[i][0].ToString().IndexOf("合计") > 0 || table.Rows[i][1].ToString().IndexOf("合计") > 0) { continue; } PSP_Substation_Info area = new PSP_Substation_Info(); //area.UID += "|" + ProjectID; area.AreaID = ProjectID; // area.CreateDate = DateTime.Now; foreach (DataColumn col in table.Columns) { try { if (table.Rows[i][col] != null) { string inserted = table.Rows[i][col].ToString(); if (inserted == "规划" || inserted == "现状") { area.GetType().GetProperty("Flag").SetValue(area, inserted == "规划" ? "2" : "1", null); } else { Type type = area.GetType().GetProperty(col.ColumnName).PropertyType;//.GetValue(area, null).GetType(); if (type == typeof(int)) { area.GetType().GetProperty(col.ColumnName).SetValue(area, int.Parse(inserted == "" ? "0" : inserted), null); } else if (type == typeof(string)) { area.GetType().GetProperty(col.ColumnName).SetValue(area, inserted, null); } else if (type == typeof(decimal)) { area.GetType().GetProperty(col.ColumnName).SetValue(area, decimal.Parse(inserted == "" ? "0" : inserted), null); } else if (type == typeof(double)) { area.GetType().GetProperty(col.ColumnName).SetValue(area, double.Parse(inserted == "" ? "0.0" : inserted), null); } else if (type == typeof(DateTime)) { } } } } catch { MessageBox.Show(string.Format("第{0}行{1}列插入有问题", i.ToString(), col.Caption)); } } DataService.Create <PSP_Substation_Info>(area); } }
/// <summary> /// 重绘 /// </summary> /// <param name="FB"></param> /// <param name="obj"></param> /// <param name="strEndYear"></param> private void ReDraw(Itop.Client.Base.FormBase FB, FarPoint.Win.Spread.SheetView obj, string strEndYear) { PSP_Substation_Info psi = null; int IntColCount = ColBDZlist.Count + 1; int IntRowCount = RowBDZList.Count + 1 + 2 + 3;//标题占3行,分区类型占2行 obj.RowCount = 0; obj.ColumnCount = 0; obj.Columns.Count = IntColCount; obj.Rows.Count = IntRowCount; IntCol = obj.Columns.Count; PF.Sheet_GridandCenter(obj);//画边线,居中 m_PF.LockSheets(obj); string strTitle = "截至" + strEndYear + "年底铜陵县35kV变电站联络情况"; IntRow = 3; obj.SheetName = strTitle; PF.CreateSheetView(obj, IntRow, IntCol, 0, 0, strTitle); PF.SetSheetViewColumnsWidth(obj, 0, strTitle); IntCol = 1; strTitle = "单位:条"; obj.AddSpanCell(IntRow, 0, 1, obj.Columns.Count); obj.SetValue(IntRow, 0, strTitle); PF.SetSheetViewColumnsWidth(obj, 0, strTitle); //右对齐 obj.Rows[IntRow].HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Right; //列标题 strTitle = " 变 电 站 "; PF.CreateSheetView(obj, NextRowMerge += 1, NextColMerge, IntRow += 1, IntCol -= 1, strTitle); PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle); for (int i = 0; i < ColBDZlist.Count; ++i) { psi = (PSP_Substation_Info)ColBDZlist[i]; obj.AddSpanCell(IntRow, 1 + i, 2, 1); obj.SetValue(IntRow, i + 1, psi.Title); } //行标题 for (int i = 0; i < RowBDZList.Count; ++i) { psi = (PSP_Substation_Info)RowBDZList[i]; obj.SetValue(6 + i, 0, psi.Title); } NextRowMerge = 1; NextColMerge = 1; IntRow = 6; IntCol = 0; WriteData(FB, obj, strEndYear, IntRow); }
public override void Delete() { DataRow row = gridView1.GetDataRow(gridView1.FocusedRowHandle); if (row != null) { PSP_Substation_Info dev = Itop.Common.DataConverter.RowToObject <PSP_Substation_Info>(row); DialogResult dr = Itop.Common.MsgBox.ShowYesNo("是否确认删除变电站[" + dev.Title + "]?"); if (dr == DialogResult.Yes) { DataService.Delete <PSP_Substation_Info>(dev); ((DataTable)gridControl1.DataSource).Rows.Remove(row); //删除第二层数据 string delcon = "SvgUID='" + dev.UID + "'and ProjectID = '" + Itop.Client.MIS.ProgUID + "'"; DataService.Update("DeletePSPDEVbywhere", delcon); } } }
//排除设备 void barDeleteDevice_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (strID == null || curDevice == null) { MessageBox.Show("选择有问题!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } if (curDevice.SelectedDevice != null) { if (curDevice.SelectedDevice.GetType() == typeof(PSPDEV)) { PSPDEV dev = curDevice.SelectedDevice as PSPDEV; PSP_ElcDevice elcdevice = new PSP_ElcDevice(); elcdevice.ProjectSUID = strID; elcdevice.DeviceSUID = dev.SUID; Services.BaseService.Delete <PSP_ElcDevice>(elcdevice); } else if (curDevice.SelectedDevice.GetType() == typeof(PSP_Substation_Info)) { PSP_Substation_Info dev = curDevice.SelectedDevice as PSP_Substation_Info; PSP_ElcDevice elcdevice = new PSP_ElcDevice(); elcdevice.ProjectSUID = strID; elcdevice.DeviceSUID = dev.UID; Services.BaseService.Delete <PSP_ElcDevice>(elcdevice); } else if (curDevice.SelectedDevice.GetType() == typeof(PSP_PowerSubstation_Info)) { PSP_PowerSubstation_Info dev = curDevice.SelectedDevice as PSP_PowerSubstation_Info; PSP_ElcDevice elcdevice = new PSP_ElcDevice(); elcdevice.ProjectSUID = strID; elcdevice.DeviceSUID = dev.UID; Services.BaseService.Delete <PSP_ElcDevice>(elcdevice); } } if (curDevice != null) { curDevice.strCon = ",psp_elcdevice where psp_elcdevice.devicesuid = pspdev.suid and psp_elcdevice.projectsuid = '" + strID + "' and "; curDevice.Init(); } }
public override void Alldel() { if (Itop.Common.MsgBox.ShowYesNo("是否确认删除所有数据") == DialogResult.Yes) { DataTable dat = gridView1.GridControl.DataSource as DataTable; foreach (DataRow dr in dat.Rows) { if (dr != null) { PSP_Substation_Info dev = Itop.Common.DataConverter.RowToObject <PSP_Substation_Info>(dr); UCDeviceBase.DataService.Delete <PSP_Substation_Info>(dev); //删除第二层数据 string delcon = "SvgUID='" + dr["UID"].ToString() + "'and ProjectID = '" + Itop.Client.MIS.ProgUID + "'"; DataService.Update("DeletePSPDEVbywhere", delcon); } } dat.Clear(); gridView1.GridControl.DataSource = dat; } }
public override void Edit() { frmBDZdlg dlg = new frmBDZdlg(); dlg.CsbuttonVisble(true); DataRow row = gridView1.GetDataRow(gridView1.FocusedRowHandle); if (row != null) { PSP_Substation_Info dev = Itop.Common.DataConverter.RowToObject <PSP_Substation_Info>(row); dlg.DeviceMx = dev; dlg.IsRead = false; if (dlg.ShowDialog() == DialogResult.OK) { //更新记录 dev = dlg.DeviceMx; dev.AreaID = Itop.Client.MIS.ProgUID; DataService.Update <PSP_Substation_Info>(dev); Itop.Common.DataConverter.ObjectToRow(dev, row); } } }
public override void Add() { frmBDZdlg dlg = new frmBDZdlg(); dlg.ProjectID = Itop.Client.MIS.ProgUID; dlg.Name = ""; dlg.CsbuttonVisble(true); dlg.IsRead = false; if (dlg.ShowDialog() == DialogResult.OK) { //增加记录 PSP_Substation_Info dev = dlg.DeviceMx; dev.AreaID = Itop.Client.MIS.ProgUID; if (dlg.bcflag) //在点击设备参数的时候 已经进行了保存 { DataService.Update <PSP_Substation_Info>(dev); } else { DataService.Create <PSP_Substation_Info>(dev); } DataRow row = datatable1.NewRow(); Itop.Common.DataConverter.ObjectToRow(dev, row); datatable1.Rows.Add(row); } else { if (dlg.bcflag) { PSP_Substation_Info dev = dlg.DeviceMx; dev.AreaID = Itop.Client.MIS.ProgUID; DataService.Update <PSP_Substation_Info>(dev); DataRow row = datatable1.NewRow(); Itop.Common.DataConverter.ObjectToRow(dev, row); datatable1.Rows.Add(row); } } }
private void fpfhyj(PSP_Substation_Info sub, ref double zgfh, ref Dictionary <PSP_Substation_Info, IList <PSPDEV> > listfhfp) { //首先需找最低压母线 string con = "where SvgUID='" + sub.UID + "'and Type='01' and ProjectID='" + Itop.Client.MIS.ProgUID + "' order by RateVolt"; IList <PSPDEV> list = UCDeviceBase.DataService.GetList <PSPDEV>("SelectPSPDEVByCondition", con); List <int> listnum = new List <int>(); //记录那几个母线 要进行考虑到系统分析中\ IList <PSPDEV> list1 = new List <PSPDEV>(); double minv = sub.L1; if (list.Count == 0) { return; } bool flag = false; for (int i = 0; i < list.Count; i++) { if (list[i].RateVolt <= minv) { minv = list[i].RateVolt; } if (list[i].RateVolt == sub.L1) { flag = true; } } for (int i = 0; i < list.Count; i++) { if (list[i].RateVolt == minv) { con = "where IName='" + list[i].Name + "'and Type='12' and ProjectID='" + Itop.Client.MIS.ProgUID + "'"; PSPDEV obj = UCDeviceBase.DataService.GetObject("SelectPSPDEVByCondition", con) as PSPDEV; if (obj != null) { list1.Add(obj); } else { list1.Add(list[i]); } } if (flag) { if (list[i].RateVolt == sub.L1) { con = "where IName='" + list[i].Name + "'and Type='12' and ProjectID='" + Itop.Client.MIS.ProgUID + "'"; PSPDEV obj = UCDeviceBase.DataService.GetObject("SelectPSPDEVByCondition", con) as PSPDEV; if (obj != null) { zgfh += obj.OutP; } else { zgfh += list[i].HuganTQ1; } } } } listfhfp[sub] = list1; }
private void repositoryItemHyperLinkEdit1_Click(object sender, EventArgs e) { int ihand = gridView1.FocusedRowHandle; if (ihand < 0) { return; } DataRow dr = gridView1.GetDataRow(ihand); PSP_Substation_Info pj = Itop.Common.DataConverter.RowToObject <PSP_Substation_Info>(dr); double rl = 0; int bts = 0; frmDeviceManager_children frmc = new frmDeviceManager_children(); frmc.ParentObj = pj; string[] types = new string[] { "01", "02", "03", "12" }; frmc.childrendevice(types); if (frmc.DialogResult == DialogResult.OK) { string rlgc = ""; string where = "where projectid='" + Itop.Client.MIS.ProgUID + "'and type in ('02','03')and SvgUID='" + pj.UID + "'"; IList <PSPDEV> list = UCDeviceBase.DataService.GetList <PSPDEV>("SelectPSPDEVByCondition", where); foreach (PSPDEV pd in list) { if (!string.IsNullOrEmpty(pd.OperationYear) && !string.IsNullOrEmpty(pd.Date2) && pd.Date2.Length == 4 && !string.IsNullOrEmpty(pj.L29) && !string.IsNullOrEmpty(pj.L28)) { if (Convert.ToInt32(pd.OperationYear) >= Convert.ToInt32(pj.L28) && Convert.ToInt32(pd.Date2) <= Convert.ToInt32(pj.L29)) { if (pd.Type == "03") { rl += pd.SiN; rlgc += pd.SiN.ToString("G") + "+"; } else { rl += (double)pd.Burthen; rlgc += ((double)pd.Burthen).ToString("G") + "+"; } bts++; } } else { if (pd.Type == "03") { rl += pd.SiN; rlgc += pd.SiN.ToString("G") + "+"; } else { rl += (double)pd.Burthen; rlgc += ((double)pd.Burthen).ToString("G") + "+"; } bts++; } } if (rlgc.Length > 0) { pj.L4 = rlgc.Substring(0, rlgc.Length - 1); dr["L4"] = pj.L4; } if (rl != 0) { pj.L2 = rl; pj.L3 = bts; dr["L2"] = rl; dr["L3"] = bts; } UCDeviceBase.DataService.Update <PSP_Substation_Info>(pj); } }