void gridViewOperation_AfterEdit(PS_xl obj) { if (obj!=null) { Client.ClientHelper.PlatformSqlMap.Update<PS_xl>(obj); } }
public static LineAnaly LineLossAnaly(PS_xl line) { LineAnaly lineAnaly = new LineAnaly(); lineAnaly.LossRate = line.TheoryLoss / (line.LineP==Convert.ToDecimal(0)?Convert.ToDecimal(1):line.LineP); lineAnaly.EconomyLossRate = 2 * line.K * ((decimal)Math.Pow((double)(LineR(line) + ByqR(line)), 0.5)) / (Convert.ToDecimal(line.LineVol) * line.LineP / (decimal)(Math.Pow((double)(line.LineP * line.LineP + line.LineQ * line.LineQ), 0.5) * 1000)); lineAnaly.EconomyI = (decimal)Math.Pow((double)(ByqP0(line)/(3*line.K*(LineR(line) + ByqR(line)))),0.5); lineAnaly.EconomyByqLoad = (decimal)Math.Pow((double)(ByqP0(line) / ( (LineR(line) + ByqR(line)))), 0.5); return lineAnaly; }
public UCSharpeDxt(string lineCode) { InitializeComponent(); createCheckGroup(); PS_xl xl= ClientHelper.PlatformSqlMap.GetOne<PS_xl>("where linecode='" + lineCode + "'"); if (xl != null) _xl = xl; InitTree(); }
/// <summary> /// 计算线路长度 单位米 /// 1、计算线路杆塔的档距 /// 2、统计线路长度,包括分支线路。 /// </summary> /// <param name="xl"></param> public static double CountLineLen(PS_xl xl) { double dLen0 = 0;//总长度,包括下级线路 double dLen1 = 0;//当前线路长度 IList<PS_gt> gtList = Client.ClientHelper.PlatformSqlMap.GetList<PS_gt>("where linecode='" + xl.LineCode + "' order by gtcode"); PS_gt gt0 = new PS_gt(); List<object> updateList = new List<object>(); for(int i=0;i<gtList.Count;i++) { PS_gt gt = gtList[i]; double d1 = 0; if (gt.gtLat == 0 || gt.gtLon == 0) d1=-1; if (gt0.gtLat == 0 || gt0.gtLon == 0) { gt0 = gt; d1=-1; } if (d1 == 0) { d1 = GetDistance(new PointLatLng(gt.gtLat, gt.gtLon), new PointLatLng(gt0.gtLat, gt0.gtLon)); gt.gtSpan = (decimal)Math.Round(d1, 1); if (gt.gtSpan > 9999) { string err=string.Format("数据异常,计算终止。异常杆塔号{0}-{1},所在线路{2}",gt0.gth,gt.gth,xl.LineName); throw new Exception(err); } } else { gt.gtSpan = 0; d1 = 0; } //gt. updateList.Add(gt); dLen1 += d1; gt0 = gt; } xl.WireLength =(int)(dLen1);// Client.ClientHelper.PlatformSqlMap.ExecuteTransationUpdate(null, updateList, null); updateList.Clear(); IList<PS_xl> xlList = Client.ClientHelper.PlatformSqlMap.GetList<PS_xl>("where parentid='" + xl.LineID + "' and linevol='"+xl.LineVol+"'"); foreach(PS_xl xl0 in xlList){ double d0= CountLineLen(xl0); dLen0 += d0; if (xl0.TotalLength == (int)d0) continue; xl0.TotalLength = (int)d0; updateList.Add(xl0); } Client.ClientHelper.PlatformSqlMap.ExecuteTransationUpdate(null, updateList, null); dLen0 += dLen1; return dLen0; }
private void simpleButton1_Click(object sender, EventArgs e) { //查询 btnOK.Enabled = false; xl = null; xl = Client.ClientHelper.PlatformSqlMap.GetOne<PS_xl>(string.Format("where linecode='{0}'", txOldCode.Text.Trim())); if (xl != null) { StringBuilder sb = new StringBuilder(); sb.AppendLine("线路代码:" + xl.LineCode); sb.AppendLine("线路名称:" + xl.LineName); sb.AppendLine("电压等级:" + xl.LineVol); var xlnum = Client.ClientHelper.PlatformSqlMap.GetRowCount<PS_xl>(string.Format("where linecode like '{0}%' and linevol='{1}'", xl.LineCode, xl.LineVol)); sb.AppendLine("相关线路数:" + xlnum); var gtnum = Client.ClientHelper.PlatformSqlMap.GetRowCount<PS_gt>(string.Format("where linecode in (select linecode from ps_xl where linecode like '{0}%' and linevol='{1}')", xl.LineCode, xl.LineVol)); sb.AppendLine("线路杆塔基数:" +gtnum); btnOK.Enabled = true; memoEdit1.Text = sb.ToString(); } }
/// <summary> /// 线路的变压器开路损耗 /// </summary> /// <param name="listgt"></param> /// <returns></returns> public static decimal ByqP0(PS_xl line)//变压器开路损耗 { IList<PS_gt> listGT = Client.ClientHelper.PlatformSqlMap.GetList<PS_gt>("SelectPS_gtList", "where LineCode ='" + line.LineCode + "'"); decimal byqpk = 0; byqpk = ByqP0(listGT); return byqpk; }
/// <summary> /// 变压器等值电阻 /// </summary> /// <param name="line"></param> /// <returns></returns> public static decimal ByqR(PS_xl line)//变压器等值电阻 { decimal byqloss = 0; IList<PS_gt> listGT = Client.ClientHelper.PlatformSqlMap.GetList<PS_gt>("SelectPS_gtList", "where LineCode ='" + line.LineCode + "' order by gtCode"); decimal cap = ByqCapcity(listGT); if (cap!=0) { byqloss = Convert.ToDecimal(line.LineVol) * Convert.ToDecimal(line.LineVol) * ByqPk(listGT) / (cap * cap); } return byqloss; }
/// <summary> /// 线路变压器固定损耗 /// </summary> /// <param name="line"></param> /// <returns></returns> public static decimal ByqLoss(PS_xl line)//变压器固定损耗 { decimal byqloss = 0; IList<PS_gt> listGT = Client.ClientHelper.PlatformSqlMap.GetList<PS_gt>("SelectPS_gtList", "where LineCode ='" + line.LineCode + "'"); byqloss = ByqP0(listGT)*line.TotalT/1000; return byqloss; }
void treeViewOperator_CreatingObject(PS_xl newobj) { }
void treeViewOperator_AfterDelete(PS_xl newobj) { if (AfterDelete != null) AfterDelete(treeList1, newobj); }
void treeViewOperator_CreatingObject(PS_xl newobj) { string pid = getparentValue(); TreeListNode pnode=null; if (treeList1.Selection[0] != null) { pnode = treeList1.Selection[0].ParentNode; } if (newobj.ParentID == pid) {//同级 if(pnode!=null) Ebada.Core.ConvertHelper.CopyTo(pnode, newobj); newobj.LineCode = newobj.LineID = getcode(pnode, pnode!=null?pnode.Nodes:treeList1.Nodes); newobj.LineID += new Random().Next(10, 99); newobj.LineType =pnode==null?"1": Math.Min(3, pnode.Level + 2).ToString(); } else { newobj.LineCode = newobj.LineID = getcode(treeList1.Selection[0], treeList1.Selection[0].Nodes); newobj.LineID += new Random().Next(10, 99); newobj.LineType = Math.Min(3, treeList1.Selection[0].Level + 2).ToString(); } //newobj.LineVol = "10"; newobj.OrgCode = parentID; }
void treeViewOperator_CreatingObject(PS_xl newobj) { //newobj.OrgType = "0"; }
/// <summary> /// 新建对象设置Key值 /// </summary> /// <param name="newobj"></param> void gridViewOperation_CreatingObjectEvent(PS_xl newobj) { }
/// <summary> /// 文档格式预定义好的,只填写内容 /// </summary> /// <param name="obj"></param> public static void ExportExcel(PJ_19 objorg) { ExcelAccess ex = new ExcelAccess(); SaveFileDialog saveFileDialog1 = new SaveFileDialog(); string fname = Application.StartupPath + "\\00记录模板\\19高压配电设备完好率汇总表.xls"; ex.Open(fname); //此处写填充内容代码 ex.SetCellValue(objorg.OrgName, 4, 2); IList<PS_xl> objlist = Client.ClientHelper.PlatformSqlMap.GetListByWhere<PS_xl>("where OrgCode ='" + objorg.OrgCode + "' and len(linecode)=6"); //分页 将要变化的进行分页 //建立一个求总和的 PS_xl objz = new PS_xl(); objlist.Insert(0, objz); double xlsum = 0, xl1 = 0, xl2 = 0, xl3 = 0, pdbysum = 0, pdbyts = 0, pdby1 = 0, pdbyts1 = 0, pdby2 = 0, pdbyts2 = 0, pdby3 = 0, pdbyts3 = 0, pdssum = 0, pdstssum = 0, pds1 = 0, pdsts1 = 0, pds2 = 0, pdsts2 = 0, pds3 = 0, pdsts3 = 0; double zskgsum = 0, zskg1 = 0, zskg2 = 0, zskg3 = 0; int pageindex = 1; //杆塔搜索语句 if (pageindex < Ecommon.GetPagecount(objlist.Count, 13)) { pageindex = Ecommon.GetPagecount(objlist.Count, 13); } for (int j = 1; j <= pageindex; j++) { if (j > 1) { ex.CopySheet(1, j); } } ex.ShowExcel(); for (int j = 1; j <= pageindex; j++) { ex.ActiveSheet(j); int prepageindex = j - 1; //主题 int starow = prepageindex * 13 + 1; int endrow = j * 13; if (objlist.Count > endrow) { for (int i = 0; i < 13; i++) { PS_xl obj = objlist[starow - 1 + i]; if (j == 1 && i == 0) { //合计的先跳过 continue; } // ex.SetCellValue(obj.LineName, 8 + i, 1); //配电线路 string gtcon = string.Format(" gtID in (select gtID from ps_gt WHERE LineCode IN (SELECT lineid from ps_xl where left(LineCode,{0})='{1}' and linevol>=10.0))", obj.LineCode.Length, obj.LineCode); object nobj = Client.ClientHelper.PlatformSqlMap.GetObject("GetPS_xllength", string.Format("where left(LineCode,{0})='{1}' and linevol>=10.0", obj.LineCode.Length, obj.LineCode)); string length = nobj == null ? "0" : Convert.ToDouble(nobj) / 1000.0 + ""; string tqcon = "tqID in (select tqID from ps_tq where xlCode ='" + obj.LineCode + "')"; ex.SetCellValue(length, 8 + i, 2); xlsum += Convert.ToDouble(length); nobj = Client.ClientHelper.PlatformSqlMap.GetObject("GetPS_xllength", string.Format("where left(LineCode,{0})='{1}' and linevol>=10.0", obj.LineCode.Length, obj.LineCode)); length = nobj == null ? "0" : Convert.ToDouble(nobj) / 1000.0 + ""; ex.SetCellValue(length, 8 + i, 3); xl1 += Convert.ToDouble(length); length = "0";//二类 ex.SetCellValue(length, 8 + i, 4); xl2 += Convert.ToDouble(length); length = "0";//三类 ex.SetCellValue(length, 8 + i, 5); xl3 += Convert.ToDouble(length); ex.SetCellValue("100%", 8 + i, 6); //配电变压器 string rl = "0"; object ob = Client.ClientHelper.PlatformSqlMap.GetObject("GetPS_tqbyqbyqCapcity", "Where " + tqcon); if (ob != null) { rl = ob.ToString(); } string ts = "0"; ob = Client.ClientHelper.PlatformSqlMap.GetObject("GetPS_tqbyqRowCount", "Where " + tqcon); if (ob != null) { ts = ob.ToString(); } ex.SetCellValue(rl + "/" + ts, 8 + i, 7); pdbysum += Convert.ToDouble(rl); pdbyts += Convert.ToDouble(ts); rl = "0"; ts = "0"; ob = Client.ClientHelper.PlatformSqlMap.GetObject("GetPS_tqbyqbyqCapcity", "Where byqState='1'and " + tqcon); if (ob != null) { rl = ob.ToString(); } ob = Client.ClientHelper.PlatformSqlMap.GetObject("GetPS_tqbyqRowCount", "Where byqState='1'and " + tqcon); if (ob != null) { ts = ob.ToString(); } ex.SetCellValue(rl + "/" + ts, 8 + i, 8); pdby1 += Convert.ToDouble(rl); pdbyts1 += Convert.ToDouble(ts); rl = "0"; ts = "0"; ob = Client.ClientHelper.PlatformSqlMap.GetObject("GetPS_tqbyqbyqCapcity", "Where byqState='2'and " + tqcon); if (ob != null) { rl = ob.ToString(); } ob = Client.ClientHelper.PlatformSqlMap.GetObject("GetPS_tqbyqRowCount", "Where byqState='2'and " + tqcon); if (ob != null) { ts = ob.ToString(); } ex.SetCellValue(rl + "/" + ts, 8 + i, 9); pdby2 += Convert.ToDouble(rl); pdbyts2 += Convert.ToDouble(ts); rl = "0"; ts = "0"; ob = Client.ClientHelper.PlatformSqlMap.GetObject("GetPS_tqbyqbyqCapcity", "Where byqState='3'and " + tqcon); if (ob != null) { rl = ob.ToString(); } ob = Client.ClientHelper.PlatformSqlMap.GetObject("GetPS_tqbyqRowCount", "Where byqState='3'and " + tqcon); if (ob != null) { ts = ob.ToString(); } ex.SetCellValue(rl + "/" + ts, 8 + i, 10); pdby3 += Convert.ToDouble(rl); pdbyts3 += Convert.ToDouble(ts); ex.SetCellValue("100%", 8 + i, 11); rl = "0"; ts = "0"; //配电站 ob = Client.ClientHelper.PlatformSqlMap.GetObject("GetPS_tqRowCount", "Where xlCode ='" + obj.LineCode + "'"); if (ob != null) { ts = ob.ToString(); } pdssum += Convert.ToDouble(rl); pdstssum += Convert.ToDouble(ts); ex.SetCellValue(ts, 8 + i, 12); rl = "0"; ts = "0"; ob = Client.ClientHelper.PlatformSqlMap.GetObject("GetPS_tqRowCount", "Where xlCode ='" + obj.LineCode + "'"); if (ob != null) { ts = ob.ToString(); } ex.SetCellValue( ts, 8 + i, 13); pds1 += Convert.ToDouble(rl); pdsts1 += Convert.ToDouble(ts); rl = "0"; ts = "0"; ob = Client.ClientHelper.PlatformSqlMap.GetObject("GetPS_tqbyqRowCount", "Where byqModle='配电站'or byqModle='配电亭' and byqState='2'and " + tqcon); if (ob != null) { ts = ob.ToString(); } ex.SetCellValue(ts, 8 + i, 14); pds2 += Convert.ToDouble(rl); pdsts2 += Convert.ToDouble(ts); rl = "0"; ts = "0"; ob = Client.ClientHelper.PlatformSqlMap.GetObject("GetPS_tqbyqRowCount", "Where byqModle='配电站'or byqModle='配电亭' and byqState='3'and " + tqcon); if (ob != null) { ts = ob.ToString(); } ex.SetCellValue( ts, 8 + i, 15); pds3 += Convert.ToDouble(rl); pdsts3 += Convert.ToDouble(ts); ex.SetCellValue("100%", 8 + i, 16); rl = "0"; ts = "0"; //柱上开关 string kg = "0"; ob = Client.ClientHelper.PlatformSqlMap.GetObject("GetPS_kgRowCount", "Where" + gtcon); if (ob != null) kg = ob.ToString(); ex.SetCellValue(kg, 8 + i, 17); zskgsum += Convert.ToDouble(kg); kg = "0"; ob = Client.ClientHelper.PlatformSqlMap.GetObject("GetPS_kgRowCount", "Where " + gtcon); if (ob != null) { kg = ob.ToString(); } ex.SetCellValue(kg, 8 + i, 18); zskg1 += Convert.ToDouble(kg); kg = "0"; ob = Client.ClientHelper.PlatformSqlMap.GetObject("GetPS_kgRowCount", "Where kgkind='二类' and" + gtcon); if (ob != null) { kg = ob.ToString(); } ex.SetCellValue(kg, 8 + i, 19); zskg2 += Convert.ToDouble(kg); kg = "0"; ob = Client.ClientHelper.PlatformSqlMap.GetObject("GetPS_kgRowCount", "Where kgkind='三类' and" + gtcon); if (ob != null) { kg = ob.ToString(); } ex.SetCellValue(kg, 8 + i, 20); zskg3 += Convert.ToDouble(kg); ex.SetCellValue("100%", 8 + i, 21); } } else if (objlist.Count <= endrow && objlist.Count >= starow) { for (int i = 0; i < objlist.Count - starow + 1; i++) { PS_xl obj = objlist[starow - 1 + i]; if (j == 1 && i == 0) { //合计的先跳过 continue; } // ex.SetCellValue(obj.LineName, 8 + i, 1); //配电线路 object nobj = Client.ClientHelper.PlatformSqlMap.GetObject("GetPS_xllength", string.Format("where left(LineCode,{0})='{1}' and linevol>=10.0", obj.LineCode.Length, obj.LineCode)); string length = nobj == null ? "0" : Convert.ToDouble(nobj) / 1000.0 + ""; string gtcon = string.Format(" gtID in (select gtID from ps_gt WHERE LineCode IN (SELECT lineid from ps_xl where left(LineCode,{0})='{1}' and linevol>=10.0))", obj.LineCode.Length, obj.LineCode); string tqcon = "tqID in (select tqID from ps_tq where xlCode ='" + obj.LineCode + "')"; ex.SetCellValue(length, 8 + i, 2); xlsum += Convert.ToDouble(length); nobj = Client.ClientHelper.PlatformSqlMap.GetObject("GetPS_xllength", string.Format("where left(LineCode,{0})='{1}' and linevol>=10.0", obj.LineCode.Length, obj.LineCode)).ToString(); length = nobj == null ? "0" : Convert.ToDouble(nobj) / 1000.0 + ""; ex.SetCellValue(length, 8 + i, 3); xl1 += Convert.ToDouble(length); length = "0";// Client.ClientHelper.PlatformSqlMap.GetObject("GetPS_xllength", "where LineID='" + obj.LineCode + "'or(ParentID='" + obj.LineCode + "')and LineType='2'").ToString(); ex.SetCellValue(length, 8 + i, 4); xl2 += Convert.ToDouble(length); length = "0";// Client.ClientHelper.PlatformSqlMap.GetObject("GetPS_xllength", "where LineID='" + obj.LineCode + "'or(ParentID='" + obj.LineCode + "')and LineType='3'").ToString(); ex.SetCellValue(length, 8 + i, 5); xl3 += Convert.ToDouble(length); ex.SetCellValue("100%", 8 + i, 6); //配电变压器 object bj = Client.ClientHelper.PlatformSqlMap.GetObject("GetPS_tqbyqbyqCapcity", "Where " + tqcon); string rl = "0", ts = "0"; if (bj != null) { nobj = Client.ClientHelper.PlatformSqlMap.GetObject("GetPS_tqbyqbyqCapcity", "Where " + tqcon); rl = nobj == null ? "0" : nobj.ToString(); ts = Client.ClientHelper.PlatformSqlMap.GetObject("GetPS_tqbyqRowCount", "Where " + tqcon).ToString(); ex.SetCellValue(rl + "/" + ts, 8 + i, 7); pdbysum += Convert.ToDouble(rl); pdbyts += Convert.ToDouble(ts); nobj = Client.ClientHelper.PlatformSqlMap.GetObject("GetPS_tqbyqbyqCapcity", "Where " + tqcon); rl = nobj == null ? "0" : nobj.ToString(); ts = Client.ClientHelper.PlatformSqlMap.GetObject("GetPS_tqbyqRowCount", "Where " + tqcon).ToString(); ex.SetCellValue(rl + "/" + ts, 8 + i, 8); pdby1 += Convert.ToDouble(rl); pdbyts1 += Convert.ToDouble(ts); nobj = Client.ClientHelper.PlatformSqlMap.GetObject("GetPS_tqbyqbyqCapcity", "Where byqState='2'and " + tqcon); rl = nobj == null ? "0" : nobj.ToString(); ts = Client.ClientHelper.PlatformSqlMap.GetObject("GetPS_tqbyqRowCount", "Where byqState='2'and " + tqcon).ToString(); ex.SetCellValue(rl + "/" + ts, 8 + i, 9); pdby2 += Convert.ToDouble(rl); pdbyts2 += Convert.ToDouble(ts); nobj = Client.ClientHelper.PlatformSqlMap.GetObject("GetPS_tqbyqbyqCapcity", "Where byqState='3'and " + tqcon); rl = nobj == null ? "0" : nobj.ToString(); ts = Client.ClientHelper.PlatformSqlMap.GetObject("GetPS_tqbyqRowCount", "Where byqState='3'and " + tqcon).ToString(); ex.SetCellValue(rl + "/" + ts, 8 + i, 10); pdby3 += Convert.ToDouble(rl); pdbyts3 += Convert.ToDouble(ts); ex.SetCellValue("100%", 8 + i, 11); //配电站 ts = Client.ClientHelper.PlatformSqlMap.GetObject("GetPS_tqRowCount", "Where " + tqcon).ToString(); pdssum += Convert.ToDouble(rl); pdstssum += Convert.ToDouble(ts); ex.SetCellValue( ts, 8 + i, 12); ts = Client.ClientHelper.PlatformSqlMap.GetObject("GetPS_tqRowCount", "Where " + tqcon).ToString(); ex.SetCellValue(ts, 8 + i, 13); pds1 += Convert.ToDouble(rl); pdsts1 += Convert.ToDouble(ts); ts = Client.ClientHelper.PlatformSqlMap.GetObject("GetPS_tqbyqRowCount", "Where byqModle='配电站'or byqModle='配电亭' and byqState='2'and " + tqcon).ToString(); ex.SetCellValue( ts, 8 + i, 14); pds2 += Convert.ToDouble(rl); pdsts2 += Convert.ToDouble(ts); ts = Client.ClientHelper.PlatformSqlMap.GetObject("GetPS_tqbyqRowCount", "Where byqModle='配电站'or byqModle='配电亭' and byqState='3'and " + tqcon).ToString(); ex.SetCellValue( ts, 8 + i, 15); pds3 += Convert.ToDouble(rl); pdsts3 += Convert.ToDouble(ts); ex.SetCellValue("100%", 8 + i, 16); } //柱上开关 string kg = Client.ClientHelper.PlatformSqlMap.GetObject("GetPS_kgRowCount", "Where " + gtcon).ToString(); ex.SetCellValue(kg, 8 + i, 17); zskgsum += Convert.ToDouble(kg); kg = Client.ClientHelper.PlatformSqlMap.GetObject("GetPS_kgRowCount", "Where kgkind='一类' and " + gtcon).ToString(); ex.SetCellValue(kg, 8 + i, 18); zskg1 += Convert.ToDouble(kg); kg = Client.ClientHelper.PlatformSqlMap.GetObject("GetPS_kgRowCount", "Where kgkind='二类' and " + gtcon).ToString(); ex.SetCellValue(kg, 8 + i, 19); zskg2 += Convert.ToDouble(kg); kg = Client.ClientHelper.PlatformSqlMap.GetObject("GetPS_kgRowCount", "Where kgkind='三类' and " + gtcon).ToString(); ex.SetCellValue(kg, 8 + i, 20); zskg3 += Convert.ToDouble(kg); ex.SetCellValue("100%", 8 + i, 21); } } } ex.ActiveSheet(1); //合计 //配电线路 ex.SetCellValue(xlsum.ToString(), 8, 2); ex.SetCellValue(xl1.ToString(), 8, 3); ex.SetCellValue(xl2.ToString(), 8, 4); ex.SetCellValue(xl3.ToString(), 8, 5); ex.SetCellValue("100%", 8, 6); //配电变压器 ex.SetCellValue(pdbysum.ToString() + "/" + pdbyts.ToString(), 8, 7); ex.SetCellValue(pdby1.ToString() + "/" + pdbyts1.ToString(), 8, 8); ex.SetCellValue(pdby2.ToString() + "/" + pdbyts2.ToString(), 8, 9); ex.SetCellValue(pdby3.ToString() + "/" + pdbyts3.ToString(), 8, 10); ex.SetCellValue("100%", 8, 11); //变台边亭 ex.SetCellValue(pdstssum.ToString(), 8, 12); ex.SetCellValue( pdsts1.ToString(), 8, 13); ex.SetCellValue( pdsts2.ToString(), 8, 14); ex.SetCellValue( pdsts3.ToString(), 8, 15); ex.SetCellValue("100%", 8, 16); //开关 ex.SetCellValue(zskgsum.ToString(), 8, 17); ex.SetCellValue(zskg1.ToString(), 8, 18); ex.SetCellValue(zskg2.ToString(), 8, 19); ex.SetCellValue(zskg3.ToString(), 8, 20); ex.SetCellValue("100%", 8, 21); //在此处得到合计的内容 ex.ShowExcel(); }
void btGdsList_EditValueChanged(object sender, EventArgs e) { IList<mOrg> list = Client.ClientHelper.PlatformSqlMap.GetList<mOrg>("where orgcode='" + btGdsList.EditValue + "'"); mOrg org = null; if (list.Count > 0) { org = list[0]; } else { repositoryItemLookUpEdit2.DataSource = null; } if (org != null) { ParentObj = org; IList<PS_xl> xlList = Client.ClientHelper.PlatformSqlMap.GetListByWhere<PS_xl>(" where OrgCode='" + org.OrgCode + "' and len(Linecode)=6"); PS_xl xlTemp = new PS_xl(); xlTemp.LineCode = "0"; xlTemp.LineID = "0"; xlTemp.LineName = "所有线路"; xlList.Insert(0,xlTemp); repositoryItemLookUpEdit2.DataSource = xlList; if (SelectGdsChanged != null) SelectGdsChanged(this, org); } RefreshData(); }
private decimal lineLength(PS_xl line) { return line.WireLength / 1000m; //decimal length = 0, lineloss = 0; //IList<PS_gt> listGT = Client.ClientHelper.PlatformSqlMap.GetList<PS_gt>("SelectPS_gtList", "where LineCode ='" + line.LineCode + "' order by gtCode"); //foreach (PS_gt gt in listGT) { // IList<PS_xl> listxl = Client.ClientHelper.PlatformSqlMap.GetList<PS_xl>("SelectPS_xlList", " where ParentGT = '" + gt.gtCode + "'"); // if (listxl.Count == 0) { // lineloss += gt.gtSpan; // if (lineloss > length) { // length = lineloss; // } // } else { // foreach (PS_xl xl in listxl) { // lineloss += lineLength(xl); // if (lineloss > length) { // length = lineloss; // } // } // } //} //return length / 1000; }
public void SetXL(PS_xl xl) { m_xl = xl; }
public static LineOverlay CreateLine(GMapControl map, PS_xl xl){ LineOverlay lay = CreateLine(map, xl.LineCode, xl.LineName); GMapRoute route = lay.Routes[0]; if (route.Points.Count > 0) CreateLineSub(route, null); return lay; }
void treeViewOperator_AfterEdit(PS_xl newobj) { if (AfterAdd != null) AfterEdit(treeList1, newobj); }
/// <summary> /// 文档格式预定义好的,只填写内容 /// </summary> /// <param name="obj"></param> public static void ExportExcel(PJ_16 obj1) { PS_xl xl = new PS_xl() { LineCode = obj1.LineCode, LineName = obj1.LineName }; ExportExcel(xl); }
/// <summary> /// 线路可变损耗 /// </summary> /// <param name="line"></param> /// <returns></returns> public static decimal LineLoss(PS_xl line)//线路可变损耗 { IList<PS_gt> listGT = Client.ClientHelper.PlatformSqlMap.GetList<PS_gt>("SelectPS_gtList", "where LineCode ='" + line.LineCode + "' order by gtCode"); decimal capSum = ByqCapcity(listGT); decimal lineLoss = 0; if (capSum!=0) { if (string.IsNullOrEmpty(line.LineVol)) { MainHelper.ShowWarningMessageBox("线路" + line.LineName + "的电压等级不存在!"); return 0; } if (line.TotalT==0) { MainHelper.ShowWarningMessageBox("线路" + line.LineName + "的投入运行时间为0!"); return 0; } lineLoss = (LineR(line) / (capSum * capSum) + ByqR(line)) * line.K * line.K * (line.LineP * line.LineP + line.LineQ * line.LineQ) / (Convert.ToDecimal(line.LineVol) * Convert.ToDecimal(line.LineVol) * line.TotalT * 1000); } return lineLoss; }
public static void ExportExcel(PS_xl obj) { ExcelAccess ex = new ExcelAccess(); SaveFileDialog saveFileDialog1 = new SaveFileDialog(); string fname = Application.StartupPath + "\\00记录模板\\16高压配电线路条图汇总表.xls"; object ot = new object(); ex.Open(fname); //设置格式 try { ex.MyExcel.get_Range("A1", "T35").NumberFormat = "@";//文本格式 } catch { } //此处写填充内容代码 //线路名称 ex.SetCellValue(obj.LineName, 4, 2); //总的杆塔数 string sumgt = "0"; //ot = Client.ClientHelper.PlatformSqlMap.GetObject("GetPS_gtRowCount", "where LineCode='" + obj.LineCode + "'or LineCode in( select lineid from PS_xl where parentid='" + obj.LineCode + "')"); ot = Client.ClientHelper.PlatformSqlMap.GetObject("GetPS_gtRowCount", string.Format("where gtjg='否' and linecode in (select linecode from ps_xl where left(LineCode,{0})='{1}' and linevol='10')", obj.LineCode.Length, obj.LineCode)); if (ot != null) { sumgt = ot.ToString(); } ex.SetCellValue(sumgt, 7, 2); //铁塔 ot = Client.ClientHelper.PlatformSqlMap.GetObject("GetPS_gtRowCount", string.Format("where gtjg='否' and gtType='铁塔' and linecode in (select linecode from ps_xl where left(LineCode,{0})='{1}' and linevol='10')", obj.LineCode.Length, obj.LineCode)); if (ot != null) { sumgt = ot.ToString(); } ex.SetCellValue(sumgt, 8, 2); //钢管杆 ot = Client.ClientHelper.PlatformSqlMap.GetObject("GetPS_gtRowCount", string.Format("where gtjg='否' and gtType='钢管杆' and linecode in (select linecode from ps_xl where left(LineCode,{0})='{1}' and linevol='10')", obj.LineCode.Length, obj.LineCode)); if (ot != null) { sumgt = ot.ToString(); } ex.SetCellValue(sumgt, 9, 2); //水泥杆 ot = Client.ClientHelper.PlatformSqlMap.GetObject("GetPS_gtRowCount", string.Format("where gtjg='否' and gtType like '混凝土%' and linecode in (select linecode from ps_xl where left(LineCode,{0})='{1}' and linevol='10')", obj.LineCode.Length, obj.LineCode)); if (ot != null) { sumgt = ot.ToString(); } ex.SetCellValue(sumgt, 10, 2); //木杆 ot = Client.ClientHelper.PlatformSqlMap.GetObject("GetPS_gtRowCount", string.Format("where gtjg='否' and gtType='木杆' and linecode in (select linecode from ps_xl where left(LineCode,{0})='{1}' and linevol='10')", obj.LineCode.Length, obj.LineCode)); if (ot != null) { sumgt = ot.ToString(); } ex.SetCellValue(sumgt, 11, 2); //主干长 string length = "0"; ot = Client.ClientHelper.PlatformSqlMap.GetObject("GetPS_xllength", string.Format(" where LineCode='{0}'", obj.LineCode)); int lenzg = (int)ot; if (ot != null) { length = Math.Round(lenzg / 1000.0, 2) + "";//km } ex.SetCellValue(length, 9, 5);//主干 //总长度 ot = Client.ClientHelper.PlatformSqlMap.GetObject("GetPS_xllength", string.Format("where linecode like '{0}%' and linevol='10'", obj.LineCode)); if (ot != null) { length = Math.Round((int)ot / 1000.0, 2) + ""; } ex.SetCellValue(length, 9, 4);//小计(线路长度) ex.SetCellValue(length, 9, 3);//合计 //分支线的数目和长度 ot = Client.ClientHelper.PlatformSqlMap.GetObject("GetPS_xlRowCount", string.Format("where linecode like '{0}%' and linevol='10' and len(linecode)>6", obj.LineCode)); if (ot != null) { sumgt = (int)ot + ""; } ex.SetCellValue(sumgt, 9, 6); ot = Client.ClientHelper.PlatformSqlMap.GetObject("GetPS_xllength", string.Format("where linecode like '{0}%' and linevol='10' and len(linecode)>6", obj.LineCode)); if (ot != null) { length = Math.Round((int)ot / 1000.0, 2) + ""; } ex.SetCellValue(length, 9, 8); //供电半经 double gdbj = jsgdbj(obj.LineCode); length = Math.Round(gdbj / 1000.0, 2) + ""; ex.SetCellValue(length, 9, 13); //变压器容量和台 //总容量 string ts = "0"; Object bj = Client.ClientHelper.PlatformSqlMap.GetObject("GetPS_tqbyqbyqCapcity", "Where tqID in (select tqID from ps_tq where xlCode ='" + obj.LineCode + "')"); if (bj != null) { if (!string.IsNullOrEmpty(obj.LineCode)) { string rl = "0"; ot = bj;// Client.ClientHelper.PlatformSqlMap.GetObject("GetPS_tqbyqbyqCapcity", "Where tqID in (select tqID from ps_tq where xlCode ='" + obj.LineCode + "')"); if (ot != null) { rl = ot.ToString(); } ex.SetCellValue(rl, 15, 1); ot = Client.ClientHelper.PlatformSqlMap.GetObject("GetPS_tqbyqbyqCapcity", "Where byqVol like '6%'AND byqPhase='单相'and tqID in (select tqID from ps_tq where xlCode ='" + obj.LineCode + "')"); rl = "0"; if (ot != null) { rl = ot.ToString(); } ot = Client.ClientHelper.PlatformSqlMap.GetObject("GetPS_tqbyqRowCount", "Where byqVol like '6%'AND byqPhase='单相'and tqID in (select tqID from ps_tq where xlCode ='" + obj.LineCode + "')"); if (ot != null) { ts = ot.ToString(); } ex.SetCellValue(rl + "/" + ts, 15, 2); ot = Client.ClientHelper.PlatformSqlMap.GetObject("GetPS_tqbyqbyqCapcity", "Where byqVol like '10%'AND byqPhase='单相'and tqID in (select tqID from ps_tq where xlCode ='" + obj.LineCode + "')"); rl = "0"; if (ot != null) { rl = ot.ToString(); } ot = Client.ClientHelper.PlatformSqlMap.GetObject("GetPS_tqbyqRowCount", "Where byqVol like '10%'AND byqPhase='单相'and tqID in (select tqID from ps_tq where xlCode ='" + obj.LineCode + "')"); if (ot != null) { ts = ot.ToString(); } ex.SetCellValue(rl + "/" + ts, 15, 3); rl = "0"; ot = Client.ClientHelper.PlatformSqlMap.GetObject("GetPS_tqbyqbyqCapcity", "Where byqVol like '6%'AND byqPhase='三相'and tqID in (select tqID from ps_tq where xlCode ='" + obj.LineCode + "')"); if (ot != null) { rl = ot.ToString(); } ot = Client.ClientHelper.PlatformSqlMap.GetObject("GetPS_tqbyqRowCount", "Where byqVol like '6%'AND byqPhase='三相'and tqID in (select tqID from ps_tq where xlCode ='" + obj.LineCode + "')"); if (ot != null) { ts = ot.ToString(); } ex.SetCellValue(rl + "/" + ts, 15, 4); ot = Client.ClientHelper.PlatformSqlMap.GetObject("GetPS_tqbyqbyqCapcity", "Where byqVol like '10%'AND byqPhase='三相'and tqID in (select tqID from ps_tq where xlCode ='" + obj.LineCode + "')"); rl = "0"; if (ot != null) { rl = ot.ToString(); } ot = Client.ClientHelper.PlatformSqlMap.GetObject("GetPS_tqbyqRowCount", "Where byqVol like '10%'AND byqPhase='三相'and tqID in (select tqID from ps_tq where xlCode ='" + obj.LineCode + "')"); if (ot != null) { ts = ot.ToString(); } ex.SetCellValue((rl + "/" + ts).ToString(), 15, 5); } } object ot1 = null, ot2 = null; int 小计 = 0; int 合计 = 0; //开关 string kg = "0"; // ot = Client.ClientHelper.PlatformSqlMap.GetObject("GetPS_kgRowCount", "Where kgModle='油开关'and gtID in(select gtID from ps_gt WHERE LineCode IN (SELECT lineid from ps_xl where lineid='" + obj.LineCode + "'or ParentID='" + obj.LineCode + "'))"); ot = Client.ClientHelper.PlatformSqlMap.GetObject("GetPS_kgRowCount", "Where kgModle like '%DW%' and gtID in(select gtID from ps_gt WHERE LineCode IN (SELECT lineid from ps_xl where lineid='" + obj.LineCode + "'or ParentID='" + obj.LineCode + "'))"); ot = ot ?? 0; 合计 += Convert.ToInt32(ot); kg = ot.ToString(); ex.SetCellValue(kg, 15, 8); ot = Client.ClientHelper.PlatformSqlMap.GetObject("GetPS_kgRowCount", "Where kgModle like '%ZW%' and gtID in(select gtID from ps_gt WHERE LineCode IN (SELECT lineid from ps_xl where lineid='" + obj.LineCode + "'or ParentID='" + obj.LineCode + "'))"); ot = ot ?? 0; 合计 += Convert.ToInt32(ot); kg = ot.ToString(); ex.SetCellValue(kg, 16, 8); ot = Client.ClientHelper.PlatformSqlMap.GetObject("GetPS_kgRowCount", "Where kgModle like '%SF6%' and gtID in(select gtID from ps_gt WHERE LineCode IN (SELECT lineid from ps_xl where lineid='" + obj.LineCode + "'or ParentID='" + obj.LineCode + "'))"); ot = ot ?? 0; 合计 += Convert.ToInt32(ot); kg = ot.ToString(); ex.SetCellValue(kg, 17, 8); ot = Client.ClientHelper.PlatformSqlMap.GetObject("GetPS_kgRowCount", "Where kgModle like '%智能%' and gtID in(select gtID from ps_gt WHERE LineCode IN (SELECT lineid from ps_xl where lineid='" + obj.LineCode + "'or ParentID='" + obj.LineCode + "'))"); ot = ot ?? 0; 合计 += Convert.ToInt32(ot); kg = ot.ToString(); ex.SetCellValue(kg, 18, 8); //跌落开关 ot = Client.ClientHelper.PlatformSqlMap.GetObject("SelectOneInt", string.Format("select sum(sbNumber) from ps_tqsb Where sbname='跌落保险' and tqID in(select tqid from ps_tq WHERE xlCode ='{0}' )", obj.LineCode)); ot = ot ?? 0; 合计 += Convert.ToInt32(ot); kg = ot.ToString(); ex.SetCellValue(kg, 19, 8); //开关合计 //ot = Client.ClientHelper.PlatformSqlMap.GetObject("GetPS_kgRowCount", "Where gtID in(select gtID from ps_gt WHERE LineCode IN (SELECT lineid from ps_xl where lineid='" + obj.LineCode + "'or ParentID='" + obj.LineCode + "'))"); kg = 合计.ToString(); ex.SetCellValue(kg, 14, 8); 合计 = 0; //台区 ot = Client.ClientHelper.PlatformSqlMap.GetObject("GetPS_tqRowCount", "Where xlCode ='" + obj.LineCode + "'"); ts = "0"; if (ot != null) { ts = ot.ToString(); } ex.SetCellValue(ts, 21, 8); ts = "0"; ot = null;// Client.ClientHelper.PlatformSqlMap.GetObject("GetPS_tqbyqRowCount", "Where byqModle='配电站'and tqID in (select tqID from ps_tq where xlCode ='" + obj.LineCode + "'or xlCode2 in(select lineid from ps_xl where ParentID='" + obj.LineCode + "'))"); if (ot != null) { ts = ot.ToString(); } ex.SetCellValue(ts, 22, 8); ts = "0"; ot = null;// Client.ClientHelper.PlatformSqlMap.GetObject("GetPS_tqbyqRowCount", "Where byqModle='配电亭'and tqID in (select tqID from ps_tq where xlCode ='" + obj.LineCode + "'or xlCode2 in(select lineid from ps_xl where ParentID='" + obj.LineCode + "'))"); if (ot != null) { ts = ot.ToString(); } ex.SetCellValue(ts, 23, 8); //避雷器 string blq = "0"; //统计型号'Y%' //统计杆塔设备库 ot1 = Client.ClientHelper.PlatformSqlMap.GetObject("SelectOneInt", string.Format("select sum(sbNumber) from ps_gtsb Where sbname='避雷器' and sbModle like 'Y%' and gtID in(select gtID from ps_gt WHERE LineCode IN (SELECT linecode from ps_xl where left(LineCode,{0})='{1}' and linevol='10' ))", obj.LineCode.Length, obj.LineCode)); //统计台区设备库 ot2 = Client.ClientHelper.PlatformSqlMap.GetObject("SelectOneInt", string.Format("select sum(sbNumber) from ps_tqsb Where sbname='避雷器' and sbModle like 'Y%' and tqID in(select tqid from ps_tq WHERE xlCode ='{0}' )", obj.LineCode)); ot1 = ot1 ?? 0; ot2 = ot2 ?? 0; 小计 = Convert.ToInt32(ot1) + Convert.ToInt32(ot2); 合计 += 小计; blq = 小计.ToString(); ex.SetCellValue(blq, 15, 13); //统计型号'FZ%' ot1 = Client.ClientHelper.PlatformSqlMap.GetObject("SelectOneInt", string.Format("select sum(sbNumber) from ps_gtsb Where sbname='避雷器' and sbModle like 'FZ%' and gtID in(select gtID from ps_gt WHERE LineCode IN (SELECT linecode from ps_xl where left(LineCode,{0})='{1}' and linevol='10' ))", obj.LineCode.Length, obj.LineCode)); ot2 = Client.ClientHelper.PlatformSqlMap.GetObject("SelectOneInt", string.Format("select sum(sbNumber) from ps_tqsb Where sbname='避雷器' and sbModle like 'FZ%' and tqID in(select tqid from ps_tq WHERE xlCode ='{0}' )", obj.LineCode)); ot1 = ot1 ?? 0; ot2 = ot2 ?? 0; 小计 = Convert.ToInt32(ot1) + Convert.ToInt32(ot2); 合计 += 小计; blq = 小计.ToString(); ex.SetCellValue(blq, 16, 13); // blq = "0"; //ot = Client.ClientHelper.PlatformSqlMap.GetObject("GetPS_gtsbRowCount", string.Format("Where sbname='避雷器'and sbModle like '%Y5WZ-17/45%' and gtID in(select gtID from ps_gt WHERE LineCode IN (SELECT linecode from ps_xl where left(LineCode,{0})='{1}' and linevol='10' ))", obj.LineCode.Length, obj.LineCode)); if (ot != null) { blq = ot.ToString(); } ex.SetCellValue(blq, 17, 13); blq = 合计.ToString(); ex.SetCellValue(blq, 14, 13); 合计 = 0; //绝缘子 string jyuz = "0"; // ot = Client.ClientHelper.PlatformSqlMap.GetObject("GetPS_gtsbRowCount", "Where sbname='绝缘子' and gtID in(select gtID from ps_gt WHERE LineCode IN (SELECT lineid from ps_xl where lineid='" + obj.LineCode + "'or ParentID='" + obj.LineCode + "'))"); ot = Client.ClientHelper.PlatformSqlMap.GetObject("SelectOneInt", "select sum(sbNumber) from ps_gtsb Where (sbname='高压立瓶' or sbname='高压悬垂' or sbname='高压悬式绝缘子' or sbname='高压针式绝缘子' or sbname='10KV楔型耐张') and gtID in(select gtID from ps_gt WHERE LineCode IN (SELECT lineid from ps_xl where lineid='" + obj.LineCode + "'or ParentID='" + obj.LineCode + "'))"); if (ot != null) { jyuz = ot.ToString(); } ex.SetCellValue(jyuz, 21, 13); jyuz = "0"; // ot = Client.ClientHelper.PlatformSqlMap.GetObject("SelectOneInt", "select sum(sbNumber) from ps_gtsb Where (sbname='高压立瓶' or sbname='高压针式绝缘子')and (sbModle like 'fp%' or sbModle like 'p-%'or sbModle like '棕红色硅胶%') and gtID in(select gtID from ps_gt WHERE LineCode IN (SELECT lineid from ps_xl where lineid='" + obj.LineCode + "'or ParentID='" + obj.LineCode + "'))"); ot = Client.ClientHelper.PlatformSqlMap.GetObject("SelectOneInt", "select sum(sbNumber) from ps_gtsb Where (sbname='高压立瓶' or sbname='高压针式绝缘子') and gtID in(select gtID from ps_gt WHERE LineCode IN (SELECT lineid from ps_xl where lineid='" + obj.LineCode + "'or ParentID='" + obj.LineCode + "'))"); if (ot != null) { jyuz = ot.ToString(); } ex.SetCellValue(jyuz, 22, 13); jyuz = "0"; // ot = Client.ClientHelper.PlatformSqlMap.GetObject("SelectOneInt", "select sum(sbNumber) from ps_gtsb Where (sbname='高压悬垂' or sbname='高压悬式绝缘子')and (sbModle like 'fsw%' or sbModle like 'xp-%') and gtID in(select gtID from ps_gt WHERE LineCode IN (SELECT lineid from ps_xl where lineid='" + obj.LineCode + "'or ParentID='" + obj.LineCode + "'))"); ot = Client.ClientHelper.PlatformSqlMap.GetObject("SelectOneInt", "select sum(sbNumber) from ps_gtsb Where (sbname='高压悬垂' or sbname='高压悬式绝缘子') and gtID in(select gtID from ps_gt WHERE LineCode IN (SELECT lineid from ps_xl where lineid='" + obj.LineCode + "'or ParentID='" + obj.LineCode + "'))"); if (ot != null) { jyuz = ot.ToString(); } ex.SetCellValue(jyuz, 23, 13); jyuz = "0"; // ot = Client.ClientHelper.PlatformSqlMap.GetObject("SelectOneInt", "select sum(sbNumber) from ps_gtsb Where sbname='10KV楔型耐张'and sbModle like 'j10%' and gtID in(select gtID from ps_gt WHERE LineCode IN (SELECT lineid from ps_xl where lineid='" + obj.LineCode + "'or ParentID='" + obj.LineCode + "'))"); ot = Client.ClientHelper.PlatformSqlMap.GetObject("SelectOneInt", "select sum(sbNumber) from ps_gtsb Where sbname='10KV楔型耐张' and gtID in(select gtID from ps_gt WHERE LineCode IN (SELECT lineid from ps_xl where lineid='" + obj.LineCode + "'or ParentID='" + obj.LineCode + "'))"); if (ot != null) { jyuz = ot.ToString(); } ex.SetCellValue(jyuz, 24, 13); // ot = Client.ClientHelper.PlatformSqlMap.GetObject("GetPS_gtsbRowCount", "Where sbname='绝缘子'and sbModle='FPQ2W-10/3T20' and gtID in(select gtID from ps_gt WHERE LineCode IN (SELECT lineid from ps_xl where lineid='" + obj.LineCode + "'or ParentID='" + obj.LineCode + "'))"); // if (ot != null) { // jyuz = ot.ToString(); // } // ex.SetCellValue(jyuz, 25, 13); ex.ShowExcel(); Microsoft.Office.Interop.Excel.Worksheet ws = ex.MyExcel.ActiveSheet as Microsoft.Office.Interop.Excel.Worksheet; if (ws != null) ws.PrintPreview(true); }
/// <summary> /// 线路等值电阻 /// </summary> /// <param name="line"></param> /// <returns></returns> public static decimal LineR(PS_xl line)//线路等值电阻 { decimal lineloss = 0; IList<PS_gt> listGT = Client.ClientHelper.PlatformSqlMap.GetList<PS_gt>("SelectPS_gtList", "where LineCode ='" + line.LineCode + "' order by gtCode"); IList<PS_dxxh> listxh = Client.ClientHelper.PlatformSqlMap.GetList<PS_dxxh>("SelectPS_dxxhList", "where dydj = '" + line.LineVol + "' and dxxh = '" + line.WireType + "'"); if (listxh.Count<=0) { return 0; } PS_dxxh xh = listxh[0]; //IList<PS_gt> listGTAfterRemove = new List<PS_gt>(); ; //foreach (PS_gt gt in listGT) //{ // listGTAfterRemove.Add(gt); //} decimal capSum = ByqCapcity(listGT); IList<PS_XLSec> xlSecList = ListCacheHelper.GetXLSecList(line.SectionalizedMessage); foreach (PS_gt gt in listGT) { foreach (PS_XLSec xlSec in xlSecList) { if (Convert.ToDouble(gt.gtCode) > Convert.ToDouble( xlSec.StartGT) && Convert.ToDouble(gt.gtCode) <= Convert.ToDouble(xlSec.EndGT)) { IList<PS_dxxh> listxhnew = Client.ClientHelper.PlatformSqlMap.GetList<PS_dxxh>("SelectPS_dxxhList", "where dydj = '" + line.LineVol + "' and dxxh = '" + xlSec.LineType + "'"); if (listxh.Count > 0) { xh = listxhnew[0]; } break; } } //decimal cap = ByqCapcity(listGTAfterRemove); lineloss += xh.dwdz * gt.gtSpan * capSum * capSum; capSum -= ByqCapcity(gt); //listGTAfterRemove.Remove(gt); } IList<PS_xl> listXL = GetChildrenList(line.LineID); foreach (PS_xl linexl in listXL) { lineloss += LineR(linexl); } return lineloss; }
public UCPS_GT(PS_xl xl):this() { btGdsList.Visibility = DevExpress.XtraBars.BarItemVisibility.Never; btXlList.Visibility = DevExpress.XtraBars.BarItemVisibility.Never; ParentObj = xl; }
/// <summary> /// 线路变压器容量 /// </summary> /// <param name="gt"></param> /// <returns></returns> public static decimal ByqCapcityByLine(PS_xl line)//变压器容量 { IList<PS_gt> listGT = Client.ClientHelper.PlatformSqlMap.GetList<PS_gt>("SelectPS_gtList", "where LineCode ='" + line.LineCode + "'"); return ByqCapcity(listGT); }
private static string andparentlinename(PS_xl xl) { string linename = ""; PS_xl xl1 = Client.ClientHelper.PlatformSqlMap.GetOne<PS_xl>(" where lineid='" + xl.ParentID + "'"); if (xl1 == null) { linename = xl.LineName; } else { linename += andparentlinename(xl1) + " "; linename += xl.LineName; } return linename; }
/// <summary> /// 线路的变压器开路损耗 /// </summary> /// <param name="listgt"></param> /// <returns></returns> public static decimal CapacityLoss(PS_xl line)//电容器损耗 { return 0; }
public PS_xl GetXL() { if (!string.IsNullOrEmpty(frm.LineCode)) { if (mXL != null && mXL.LineCode == frm.LineCode) { } else { mXL = Client.ClientHelper.PlatformSqlMap.GetOne<PS_xl>(" where LineCode='" + frm.LineCode + "'"); } } return mXL; }
/// <summary> /// 线路线损 /// </summary> /// <param name="line">线路</param> /// <returns>输入线路的线损</returns> public static decimal Loss(PS_xl line)//线损 { decimal loss = 0; loss = LineLoss(line) + ByqLoss(line); return loss; }
void treeViewOperator_CreatingObject(PS_xl newobj) { string pid = getparentValue(); TreeListNode pnode = null; PS_xl xl1 = null; if (treeList1.Selection.Count > 0) { xl1 = treeList1.GetDataRecordByNode(treeList1.Selection[0]) as PS_xl; pnode = treeList1.Selection[0].ParentNode; } string linecode = ""; if (newobj.ParentID == pid) {//同级 linecode = getcode(pnode, pnode != null ? pnode.Nodes : treeList1.Nodes); } else { linecode = getcode(treeList1.Selection[0], treeList1.Selection[0].Nodes); } pid = newobj.ParentID; if (xl1 != null) Ebada.Core.ConvertHelper.CopyTo(xl1, newobj); else if (xl != null) { Ebada.Core.ConvertHelper.CopyTo(xl, newobj); newobj.LineType = "1"; newobj.Contractor = tq.Contractor; } newobj.ParentID = pid; if (pid == "0") newobj.ParentID = tq.tqCode; newobj.LineID = newobj.LineCode = linecode; newobj.LineID += new Random().Next(10, 99); newobj.LineVol = "0.4"; newobj.LineName = ""; newobj.ParentGT = ""; }