public void InitSodata() { if (ctrlPowerEachList1.FocusedObject == null) return; string sid = typeFlag2= ctrlPowerEachList1.FocusedObject.UID; Hashtable hs = new Hashtable(); Hashtable hs1 = new Hashtable(); ddd = DateTime.Now; sss += "2:" + ddd.ToString(); IList<Itop.Domain.Graphics.LineInfo> listLineInfo = Services.BaseService.GetList<Itop.Domain.Graphics.LineInfo>("SelectLineInfoByPowerID", sid); foreach (Itop.Domain.Graphics.LineInfo l1 in listLineInfo) { hs.Add(Guid.NewGuid().ToString(), l1.UID); } ddd = DateTime.Now; sss += "3:" + ddd.ToString(); IList<substation> listsubstation = Services.BaseService.GetList<substation>("SelectsubstationByPowerID2", sid); foreach (substation s1 in listsubstation) { hs.Add(Guid.NewGuid().ToString(), s1.UID); } ddd = DateTime.Now; sss += "4:" + ddd.ToString(); PSP_PowerProValues_LangFang psp_Type = new PSP_PowerProValues_LangFang(); psp_Type.Flag2 = sid; IList<PSP_PowerProValues_LangFang> listProTypes = Common.Services.BaseService.GetList<PSP_PowerProValues_LangFang>("SelectPSP_PowerProValues_LangFangByFlag2", psp_Type); foreach (PSP_PowerProValues_LangFang ps in listProTypes) { hs1.Add(Guid.NewGuid().ToString(), ps.Code); } ddd = DateTime.Now; sss += "5:" + ddd.ToString(); foreach (PSP_PowerProValues_LangFang p1 in listProTypes) { if (p1.Code != "" && !hs.ContainsValue(p1.Code) && p1.ParentID != "0") { //删除 Services.BaseService.Delete<PSP_PowerProValues_LangFang>(p1); } } ddd = DateTime.Now; sss += "6:" + ddd.ToString(); foreach (Itop.Domain.Graphics.LineInfo l2 in listLineInfo) { if (!hs1.ContainsValue(l2.UID) && l2.Voltage != "") { //添加 try { PSP_PowerProValues_LangFang ps2 = new PSP_PowerProValues_LangFang(); 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; ps2.ID = Guid.NewGuid().ToString(); Services.BaseService.Create<PSP_PowerProValues_LangFang>(ps2); } catch( Exception ex){ System.Console.WriteLine(ex.Message); } } if (hs1.ContainsValue(l2.UID) && l2.Voltage != "") { //更新 try { PSP_PowerProValues_LangFang p2 = new PSP_PowerProValues_LangFang(); p2.Code = l2.UID; p2.Flag2 = sid; PSP_PowerProValues_LangFang ps2=(PSP_PowerProValues_LangFang)Services.BaseService.GetObject("SelectPSP_PowerProValues_LangFangByselectObject", p2); ps2.ParentID = l2.Voltage.ToUpper().Replace("KV", ""); ps2.L3 = l2.LineName; ps2.Flag = 1; ps2.L4 = l2.Voltage; ps2.L8 = double.Parse(l2.Length).ToString(); ; ps2.L9 = l2.LineType; Services.BaseService.Update("UpdatePSP_PowerProValues_LangFangByCode", ps2); } catch (Exception ex) { System.Console.WriteLine(ex.Message); } } } ddd = DateTime.Now; sss += "7:" + ddd.ToString(); //ps.Type = OBJ.L7; 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_PowerProValues_LangFang ps3 = new PSP_PowerProValues_LangFang(); ps3.ParentID = s2.ObligateField1; ps3.L3 = s2.EleName; ps3.Code = s2.UID; ps3.Flag = 2; ps3.Flag2 = sid; ps3.L4 = s2.ObligateField1.ToString(); 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_PowerProValues_LangFang>(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_PowerProValues_LangFang p3 = new PSP_PowerProValues_LangFang(); p3.Code = s2.UID; p3.Flag2 = sid; PSP_PowerProValues_LangFang ps3 = (PSP_PowerProValues_LangFang)Services.BaseService.GetObject("SelectPSP_PowerProValues_LangFangByselectObject", p3); ps3.ParentID = s2.ObligateField1; ps3.L3 = s2.EleName; ps3.Flag = 2; ps3.L4 = s2.ObligateField1.ToString(); 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();//总容量 Services.BaseService.Update("UpdatePSP_PowerProValues_LangFangByCode", ps3); } catch { } } } ddd = DateTime.Now; sss += "8:" + ddd.ToString(); if (updat == "true") { LoadDatadata(); } else if (updat == "false") { UpdataLoadDatadata(); updat = "true"; } else { LoadData(); updat = "true"; } ddd = DateTime.Now; sss += "9:" + ddd.ToString(); }
/// <summary> /// ɾ��������� /// </summary> public void DeleteObject(string lb) { //��ȡ������� PowerEachList obj = FocusedObject; if (obj == null) { bl = false; return; } int coun = 0; switch (lb) { case "xuqiu": PowerTypes pt = new PowerTypes(); pt.Flag2 = obj.UID; IList<PowerTypes> li = Services.BaseService.GetList<PowerTypes>("SelectPowerTypesByFlag2", pt); coun = li.Count; break; case "xihua": PowerProjectTypes pt1 = new PowerProjectTypes(); pt1.Flag2 = obj.UID; IList<PowerProjectTypes> li1 = Services.BaseService.GetList<PowerProjectTypes>("SelectPowerProjectTypesByFlag2", pt1); coun = li1.Count; break; case "shebei": PowerStuffTypes pt2 = new PowerStuffTypes(); pt2.Flag2 = obj.UID; IList<PowerStuffTypes> li2 = Services.BaseService.GetList<PowerStuffTypes>("SelectPowerStuffTypesByFlag2", pt2); coun = li2.Count; break; case "fanwei": PowersTypes pt3 = new PowersTypes(); pt3.Flag2 = obj.UID; IList<PowersTypes> li3 = Services.BaseService.GetList<PowersTypes>("SelectPowersTypesByFlag2", pt3); coun = li3.Count; break; case "sb": PowerProTypes pt4 = new PowerProTypes(); pt4.Flag2 = obj.UID; IList<PowerProTypes> li4 = Services.BaseService.GetList<PowerProTypes>("SelectPowerProTypesByFlag2INParent", pt4); coun = li4.Count; break; case "gusuan": PSP_PowerProValues_LangFang pt5 = new PSP_PowerProValues_LangFang(); pt5.Flag2 = obj.UID; IList<PSP_PowerProValues_LangFang> li5 = Services.BaseService.GetList<PSP_PowerProValues_LangFang>("SelectPSP_PowerProValues_LangFangByFlag2INParent", pt5); coun = li5.Count; break; } if (coun > 0) { MsgBox.Show("�÷��������м�¼����ɾ��"); bl = false; return; } //����ȷ�� if (MsgBox.ShowYesNo(Strings.SubmitDelete) != DialogResult.Yes) { bl = false; return; } //ִ��ɾ������ try { Services.BaseService.Delete<PowerEachList>(obj); if (lb == "sb") { Services.BaseService.Update("DeletePowerPicSelect1", obj.UID); Services.BaseService.Update("DeletePowerProTypesInFlag2", obj.UID); } if (lb == "gusuan") { Services.BaseService.Update("DeletePowerPicSelect1", obj.UID); Services.BaseService.Update("DeletePowerProTypesInFlag2", obj.UID); } } catch { //Debug.Fail(exc.Message); //HandleException.TryCatch(exc); return; } this.gridView.BeginUpdate(); //��ס��ǰ���������� int iOldHandle = this.gridView.FocusedRowHandle; //��������ɾ�� ObjectList.Remove(obj); //ˢ�±�� gridControl.RefreshDataSource(); //�����µĽ��������� GridHelper.FocuseRowAfterDelete(this.gridView, iOldHandle); this.gridView.EndUpdate(); }
private void barButtonItem12_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { TreeListNode focusedNode = treeList1.FocusedNode; if (focusedNode == null) { return; } FormAddInfo_LangFang frm = new FormAddInfo_LangFang(); frm.Text = "增加" + focusedNode.GetValue("L3") + "的子项目"; frm.FlagId = typeFlag2; frm.ParentID = focusedNode.GetValue("ID").ToString(); frm.Isupdate = false; if (frm.ShowDialog() == DialogResult.OK) { obj = frm.OBJ; TreeListColumn column = treeList1.Columns["L10"]; CalculateSum(focusedNode, column, obj.L10, false); //// LoadData(); //// FoucsLocation(psp_Type.ID, treeList1.Nodes); //treeList1.RefreshDataSource(); //dataTable.Rows.Add(Itop.Common.DataConverter.ObjectToRow(psp_Type, dataTable.NewRow())); WaitDialogForm wait = null; try { wait = new WaitDialogForm("", "正在计算数据, 请稍候..."); LoadDatadata(); wait.Close(); // MsgBox.Show("计算成功"); } catch { wait.Close(); } //treeList1.FocusedNode.SetValue(treeList1.FocusedColumn.FieldName, lastEditValue); } }
private void barButtonItem14_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (treeList1.FocusedNode == null) { return; } if (treeList1.FocusedNode.HasChildren) { MsgBox.Show("此项目下有子项目,请先删除子项目!"); return; } if (treeList1.FocusedNode.ParentNode == null) { if (MsgBox.ShowYesNo("是否删除项目 " + treeList1.FocusedNode.GetValue("L3") + "?") == DialogResult.Yes) { PowerProValues PowerValues = new PowerProValues(); PowerValues.TypeID = treeList1.FocusedNode["ID"].ToString(); PowerValues.Year = typeFlag2; PSP_PowerProValues_LangFang ppss = new PSP_PowerProValues_LangFang(); ppss.ID = treeList1.FocusedNode["ID"].ToString(); ppss.Flag2 = typeFlag2; PSP_PowerProValues_LangFang ppss1 = Services.BaseService.GetOneByKey<PSP_PowerProValues_LangFang>(ppss); PowerValues.TypeID1 = ppss1.Code; try { //DeletePowerValuesByType里面删除数据和分类 Common.Services.BaseService.Update("DeletePowerProValuesByType", PowerValues); TreeListNode brotherNode = null; try { if (treeList1.FocusedNode.ParentNode.Nodes.Count > 1) { brotherNode = treeList1.FocusedNode.PrevNode; if (brotherNode == null) { brotherNode = treeList1.FocusedNode.NextNode; } } } catch { } Common.Services.BaseService.Update("DeletePSP_PowerProValues_LangFangByIDFlag2", ppss); treeList1.DeleteNode(treeList1.FocusedNode); WaitDialogForm wait = null; try { wait = new WaitDialogForm("", "正在计算数据, 请稍候..."); LoadDatadata(); wait.Close(); // MsgBox.Show("计算成功"); } catch { wait.Close(); } } catch (Exception ex) { MsgBox.Show("删除出错:" + ex.Message); } } return; } else { if (MsgBox.ShowYesNo("是否删除项目 " + treeList1.FocusedNode.GetValue("L3") + "?") == DialogResult.Yes) { bool flag = false; PowerProValues PowerValues = new PowerProValues(); PowerValues.TypeID = treeList1.FocusedNode["ID"].ToString(); PowerValues.Year = typeFlag2; PSP_PowerProValues_LangFang ppss = new PSP_PowerProValues_LangFang(); ppss.ID=treeList1.FocusedNode["ID"].ToString(); ppss.Flag2=typeFlag2; PSP_PowerProValues_LangFang ppss1 = Services.BaseService.GetOneByKey<PSP_PowerProValues_LangFang>(ppss); PowerValues.TypeID1 = ppss1.Code; try { //DeletePowerValuesByType里面删除数据和分类 Common.Services.BaseService.Update("DeletePowerProValuesByType", PowerValues); TreeListNode brotherNode = null; try { if (treeList1.FocusedNode.ParentNode.Nodes.Count > 1) { flag = false; brotherNode = treeList1.FocusedNode.PrevNode; if (brotherNode == null) { brotherNode = treeList1.FocusedNode.NextNode; } } if (treeList1.FocusedNode.ParentNode.Nodes.Count == 1) { flag = true; } } catch { } Common.Services.BaseService.Update("DeletePSP_PowerProValues_LangFangByIDFlag2",ppss); TreeListColumn column = treeList1.Columns["L10"]; treeList1.DeleteNode(treeList1.FocusedNode); if(flag==false) CalculateSum(treeList1.FocusedNode.ParentNode, column, 0,false); else CalculateSum(treeList1.FocusedNode, column, 0,false); WaitDialogForm wait = null; try { wait = new WaitDialogForm("", "正在计算数据, 请稍候..."); LoadDatadata(); wait.Close(); //MsgBox.Show("计算成功"); } catch { wait.Close(); } } catch (Exception ex) { MsgBox.Show("删除出错:" + ex.Message); } } } // InitSodata(); //obj= frm.OBJ; // CalculateSum(focusedNode, column, double.Parse(obj.L10)); }
private bool SaveRemarkValue(string typeID, string value) { PSP_PowerProValues_LangFang ppt = new PSP_PowerProValues_LangFang(); ppt.ID = typeID; ppt.Flag2=typeFlag2; PSP_PowerProValues_LangFang ps = Services.BaseService.GetOneByKey<PSP_PowerProValues_LangFang>(ppt);//<PowerProTypes>(typeID); ps.Remark = value; try { Common.Services.BaseService.Update<PSP_PowerProValues_LangFang>(ps); } catch (Exception ex) { MsgBox.Show("保存数据出错:" + ex.Message); return false; } return true; }
//重新计算造价 private void UpdataLoadDatadata() { try { if (dataTable != null) { dataTable.Columns.Clear(); treeList1.Nodes.Clear(); } ddd = DateTime.Now; sss += " 10:" + ddd.ToString(); PSP_PowerProValues_LangFang psp_Type = new PSP_PowerProValues_LangFang(); psp_Type.Flag2 = typeFlag2; IList listTypes = new ArrayList(); try { listTypes = Common.Services.BaseService.GetList("SelectPSP_PowerProValues_LangFangByFlag2", psp_Type); } catch (Exception ex) { MsgBox.Show(ex.Message); } ddd = DateTime.Now; sss += " 11:" + ddd.ToString(); Project_Sum ps = new Project_Sum(); ps.S5 = "1"; IList<Project_Sum> sumline = Common.Services.BaseService.GetList<Project_Sum>("SelectProject_SumByS5", ps); ps.S5 = "2"; IList<Project_Sum> sumsubsation = Common.Services.BaseService.GetList<Project_Sum>("SelectProject_SumByS5", ps); Hashtable ha = new Hashtable(); ArrayList al = new ArrayList(); foreach (PSP_PowerProValues_LangFang psplf in listTypes) { if (psplf.Flag == 1)//纯线路造价计算 { if (psplf.L8 == "" || psplf.L8 == null) { psplf.L8 = "0"; } foreach (Project_Sum psum in sumline) { if (psum.L1 == psplf.L9 && psum.S1 == psplf.L4) { if (psum.Num.ToString() == null || psum.Num.ToString() == "") psum.Num = 0; psplf.L10 =Math.Round(psum.Num * double.Parse(psplf.L8),2); if (psplf.L11 == "" || psplf.L11 == null) { psplf.L11 = "0"; } psplf.L12 = Math.Round(psplf.L10 + double.Parse(psplf.L11), 2); break; } } } if (psplf.Flag == 2) { ha.Clear(); al.Clear(); double sumvaluedata = 0; double sumvalueLine = 0; if (psplf.L6 != "" && psplf.L6 != null && psplf.L5 != "" && psplf.L5 != null)//变电站内的电站造价计算 { foreach (Project_Sum psum in sumsubsation) { if (psum.S1 == psplf.L4) { try { double mva = double.Parse(psplf.IsConn.ToString()); double t5 = Convert.ToDouble(psum.T5);//单台容量 int ta = Convert.ToInt32(psum.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()); } psplf.L5 = ha[va].ToString(); psplf.L6 = va.ToString(); } else { psplf.L5 = ""; psplf.L6 = ""; } } } foreach (Project_Sum psum in sumsubsation) { if (psum.T1 == psplf.L5 && psum.T5 == psplf.L6 && psum.S1 == psplf.L4) { if (psum.Num.ToString() == null || psum.Num.ToString() == "") psum.Num = 0; sumvaluedata = psum.Num; break; } } } if (psplf.L8 != "" && psplf.L8 != null)//变电站内的线路造价计算 { foreach (Project_Sum psum in sumline) { if (psum.L1 == psplf.L9 && psum.S1 == psplf.L4) { if (psum.Num.ToString() == null || psum.Num.ToString() == "") psum.Num = 0; sumvalueLine = psum.Num * double.Parse(psplf.L8); break; } } } psplf.L10 =Math.Round(sumvaluedata + sumvalueLine,2); if (psplf.L11== "" || psplf.L11 == null) { psplf.L11 = "0"; } psplf.L12 =Math.Round(psplf.L10 + double.Parse(psplf.L11),2); Services.BaseService.Update("UpdatePSP_PowerProValues_LangFangByid",psplf); } } ddd = DateTime.Now; sss += " 12:" + ddd.ToString();//测试运算时间,可删除 sss += " 13:" + ddd.ToString();//测试运算时间,可删除 dataTable = Itop.Common.DataConverter.ToDataTable(listTypes, typeof(PSP_PowerProValues_LangFang)); treeList1.DataSource = dataTable; treeList1.Columns["L3"].Caption = "工程名称"; treeList1.Columns["L3"].Width = 80; treeList1.Columns["L3"].OptionsColumn.AllowEdit = false; treeList1.Columns["L3"].OptionsColumn.AllowSort = false; treeList1.Columns["Title"].VisibleIndex = -1; treeList1.Columns["Title"].OptionsColumn.ShowInCustomizationForm = false; treeList1.Columns["Flag"].VisibleIndex = -1; treeList1.Columns["Flag"].SortOrder = System.Windows.Forms.SortOrder.None; treeList1.Columns["Flag"].OptionsColumn.ShowInCustomizationForm = false; treeList1.Columns["Flag2"].VisibleIndex = -1; treeList1.Columns["Flag2"].OptionsColumn.ShowInCustomizationForm = false; treeList1.Columns["CreateTime"].VisibleIndex = -1; treeList1.Columns["CreateTime"].OptionsColumn.ShowInCustomizationForm = false; treeList1.Columns["CreateTime"].SortOrder = System.Windows.Forms.SortOrder.None; treeList1.Columns["UpdateTime"].VisibleIndex = -1; treeList1.Columns["UpdateTime"].OptionsColumn.ShowInCustomizationForm = false; treeList1.Columns["UpdateTime"].VisibleIndex = -1; treeList1.Columns["UpdateTime"].OptionsColumn.ShowInCustomizationForm = false; treeList1.Columns["Code"].VisibleIndex = -1; treeList1.Columns["Code"].OptionsColumn.ShowInCustomizationForm = false; treeList1.Columns["L1"].VisibleIndex = -1; treeList1.Columns["L1"].OptionsColumn.ShowInCustomizationForm = false; treeList1.Columns["L2"].VisibleIndex = -1; treeList1.Columns["L2"].OptionsColumn.ShowInCustomizationForm = false; treeList1.Columns["L11"].VisibleIndex = -1; treeList1.Columns["L11"].OptionsColumn.ShowInCustomizationForm = false; treeList1.Columns["L12"].VisibleIndex = -1; treeList1.Columns["L12"].OptionsColumn.ShowInCustomizationForm = false; treeList1.Columns["L13"].VisibleIndex = -1; treeList1.Columns["L13"].OptionsColumn.ShowInCustomizationForm = false; treeList1.Columns["L14"].VisibleIndex = -1; treeList1.Columns["L14"].OptionsColumn.ShowInCustomizationForm = false; treeList1.Columns["L15"].VisibleIndex = -1; treeList1.Columns["L15"].OptionsColumn.ShowInCustomizationForm = false; treeList1.Columns["L16"].VisibleIndex = -1; treeList1.Columns["L16"].OptionsColumn.ShowInCustomizationForm = false; treeList1.Columns["L17"].VisibleIndex = -1; treeList1.Columns["L17"].OptionsColumn.ShowInCustomizationForm = false; treeList1.Columns["L18"].VisibleIndex = -1; treeList1.Columns["L18"].OptionsColumn.ShowInCustomizationForm = false; treeList1.Columns["L19"].VisibleIndex = -1; treeList1.Columns["L19"].OptionsColumn.ShowInCustomizationForm = false; treeList1.Columns["Remark"].VisibleIndex = -1; treeList1.Columns["Remark"].OptionsColumn.ShowInCustomizationForm = false; AddColumn2(); PowerProYears psp_Year = new PowerProYears(); psp_Year.Flag = typeFlag2; Application.DoEvents(); LoadValues(); TreeListColumn column = treeList1.Columns["L10"]; TreeListColumn column1 = treeList1.Columns["L12"]; for (int i = 0; i < treeList1.Nodes.Count; i++) { CalculateNodesValue(treeList1.Nodes[i], column, column1); } treeList1.ExpandAll(); } catch { } }
private void LoadDatadata() { try { if (dataTable != null) { dataTable.Columns.Clear(); treeList1.Nodes.Clear(); } ddd = DateTime.Now; sss += " 10:" + ddd.ToString(); PSP_PowerProValues_LangFang psp_Type = new PSP_PowerProValues_LangFang(); psp_Type.Flag2 = typeFlag2; IList listTypes = new ArrayList(); try { listTypes = Common.Services.BaseService.GetList("SelectPSP_PowerProValues_LangFangByFlag2", psp_Type); } catch (Exception ex) { MsgBox.Show(ex.Message); } ddd = DateTime.Now; sss += " 11:" + ddd.ToString(); Project_Sum ps = new Project_Sum(); ps.S5 = "1"; IList<Project_Sum> sumline = Common.Services.BaseService.GetList<Project_Sum>("SelectProject_SumByS5", ps); ps.S5 = "2"; IList<Project_Sum> sumsubsation = Common.Services.BaseService.GetList<Project_Sum>("SelectProject_SumByS5", ps); foreach (PSP_PowerProValues_LangFang psplf in listTypes) { if (psplf.Flag == 1)//纯线路造价计算 { if (psplf.L8 == "" || psplf.L8 == null) { psplf.L8 = "0"; } foreach (Project_Sum psum in sumline) { if (psum.L1 == psplf.L9 && psum.S1 == psplf.L4) { if (psum.Num.ToString() == null || psum.Num.ToString() == "") psum.Num = 0; psplf.L10 = Math.Round(psum.Num * double.Parse(psplf.L8), 2); if (psplf.L11 == "" || psplf.L11 == null) { psplf.L11 = "0"; } psplf.L12 = Math.Round(psplf.L10 + double.Parse(psplf.L11), 2); break; } } } if (psplf.Flag == 2) { double sumvaluedata = 0; double sumvalueLine = 0; if (psplf.L6 != "" && psplf.L6 != null && psplf.L5 != "" && psplf.L5 != null)//变电站内的电站造价计算 { foreach (Project_Sum psum in sumsubsation) { if (psum.T1 == psplf.L5 && psum.T5 == psplf.L6 && psum.S1 == psplf.L4) { if (psum.Num.ToString() == null || psum.Num.ToString() == "") psum.Num = 0; sumvaluedata = psum.Num; break; } } } if (psplf.L8 != "" && psplf.L8 != null)//变电站内的线路造价计算 { foreach (Project_Sum psum in sumline) { if (psum.L1 == psplf.L9 && psum.S1 == psplf.L4) { if (psum.Num.ToString() == null || psum.Num.ToString() == "") psum.Num = 0; sumvalueLine = psum.Num * double.Parse(psplf.L8); break; } } } psplf.L10 = Math.Round(sumvaluedata + sumvalueLine, 2); if (psplf.L11 == "" || psplf.L11 == null) { psplf.L11 = "0"; } psplf.L12 = Math.Round(psplf.L10 + double.Parse(psplf.L11), 2); } } ddd = DateTime.Now; sss += " 12:" + ddd.ToString();//测试运算时间,可删除 sss += " 13:" + ddd.ToString();//测试运算时间,可删除 dataTable = Itop.Common.DataConverter.ToDataTable(listTypes, typeof(PSP_PowerProValues_LangFang)); //dataTable.DefaultView.Sort = "L4 desc"; //dataTable.DefaultView.Sort = "Title desc"; //dataTable.DefaultView.Sort = "CreateTime desc"; ////foreach (DataRow rw in dataTable.Rows) ////{ //// string ss = rw["Code"].ToString(); //// LineInfo li = Common.Services.BaseService.GetOneByKey<LineInfo>(ss); ////if (li != null && li.EleID != "") ////{ //// rw["L3"] = li.LineName; //// rw["L8"] = li.Length; //// rw["L9"] = li.LineType; ////} ////substation li1 = Common.Services.BaseService.GetOneByKey<substation>(ss); ////if (li1 != null && li1.EleID != "") ////{ //// rw["L3"] = li1.EleName; //// //rw["L5"] = li1.ObligateField2; //// //rw["L2"] = li1.Number; //// //rw["L6"] = li1.Burthen; ////} ////} treeList1.DataSource = dataTable; treeList1.Columns["L3"].Caption = "工程名称"; treeList1.Columns["L3"].Width = 80; treeList1.Columns["L3"].OptionsColumn.AllowEdit = false; treeList1.Columns["L3"].OptionsColumn.AllowSort = false; treeList1.Columns["Title"].VisibleIndex = -1; treeList1.Columns["Title"].OptionsColumn.ShowInCustomizationForm = false; treeList1.Columns["Flag"].VisibleIndex = -1; treeList1.Columns["Flag"].SortOrder = System.Windows.Forms.SortOrder.None; treeList1.Columns["Flag"].OptionsColumn.ShowInCustomizationForm = false; treeList1.Columns["Flag2"].VisibleIndex = -1; treeList1.Columns["Flag2"].OptionsColumn.ShowInCustomizationForm = false; treeList1.Columns["CreateTime"].VisibleIndex = -1; treeList1.Columns["CreateTime"].OptionsColumn.ShowInCustomizationForm = false; treeList1.Columns["CreateTime"].SortOrder = System.Windows.Forms.SortOrder.None; treeList1.Columns["UpdateTime"].VisibleIndex = -1; treeList1.Columns["UpdateTime"].OptionsColumn.ShowInCustomizationForm = false; treeList1.Columns["UpdateTime"].VisibleIndex = -1; treeList1.Columns["UpdateTime"].OptionsColumn.ShowInCustomizationForm = false; treeList1.Columns["Code"].VisibleIndex = -1; treeList1.Columns["Code"].OptionsColumn.ShowInCustomizationForm = false; treeList1.Columns["L1"].VisibleIndex = -1; treeList1.Columns["L1"].OptionsColumn.ShowInCustomizationForm = false; treeList1.Columns["L2"].VisibleIndex = -1; treeList1.Columns["L2"].OptionsColumn.ShowInCustomizationForm = false; treeList1.Columns["L11"].VisibleIndex = -1; treeList1.Columns["L11"].OptionsColumn.ShowInCustomizationForm = false; treeList1.Columns["L12"].VisibleIndex = -1; treeList1.Columns["L12"].OptionsColumn.ShowInCustomizationForm = false; treeList1.Columns["L13"].VisibleIndex = -1; treeList1.Columns["L13"].OptionsColumn.ShowInCustomizationForm = false; treeList1.Columns["L14"].VisibleIndex = -1; treeList1.Columns["L14"].OptionsColumn.ShowInCustomizationForm = false; treeList1.Columns["L15"].VisibleIndex = -1; treeList1.Columns["L15"].OptionsColumn.ShowInCustomizationForm = false; treeList1.Columns["L16"].VisibleIndex = -1; treeList1.Columns["L16"].OptionsColumn.ShowInCustomizationForm = false; treeList1.Columns["L17"].VisibleIndex = -1; treeList1.Columns["L17"].OptionsColumn.ShowInCustomizationForm = false; treeList1.Columns["L18"].VisibleIndex = -1; treeList1.Columns["L18"].OptionsColumn.ShowInCustomizationForm = false; treeList1.Columns["L19"].VisibleIndex = -1; treeList1.Columns["L19"].OptionsColumn.ShowInCustomizationForm = false; treeList1.Columns["Remark"].VisibleIndex = -1; treeList1.Columns["Remark"].OptionsColumn.ShowInCustomizationForm = false; AddColumn2(); PowerProYears psp_Year = new PowerProYears(); psp_Year.Flag = typeFlag2; Application.DoEvents(); LoadValues(); TreeListColumn column = treeList1.Columns["L10"]; TreeListColumn column1 = treeList1.Columns["L12"]; for (int i = 0; i < treeList1.Nodes.Count; i++) { CalculateNodesValue(treeList1.Nodes[i], column, column1); } treeList1.ExpandAll(); } catch { } }
private bool SaveCellValue(string UID, string value) { PSP_PowerProValues_LangFang PowerValues = new PSP_PowerProValues_LangFang(); PowerValues.ID = UID; try { PowerValues = (PSP_PowerProValues_LangFang)Common.Services.BaseService.GetObject("SelectPSP_PowerProValues_LangFangByID", PowerValues); PowerValues.L10 =double.Parse(value); Common.Services.BaseService.Update("UpdatePSP_PowerProValues_LangFangByID", PowerValues); } catch (Exception ex) { MsgBox.Show("保存数据出错:" + ex.Message); return false; } return true; }
private void InsertLineData1() { PowerEachList pel = this.ctrlPowerEachList1.FocusedObject; bool bl = true; string parentid = ""; string id = ""; string flag2 = ""; TreeListNode tln = treeList1.FocusedNode; //if (tln != null) //{ // bl = false; // try // { // parentid = tln["ParentID"].ToString(); // id = tln["ID"].ToString(); // flag2 = tln["Flag2"].ToString(); // } // catch // { } //} //else // { id = "0"; flag2 = pel.UID; //} PSP_PowerProValues_LangFang z = new PSP_PowerProValues_LangFang(); PowerProYears h = new PowerProYears(); PowerProValues j = new PowerProValues(); object obj = Services.BaseService.GetObject("SelectPowerProTypesList", ""); try { DataTable dts = new DataTable(); OpenFileDialog op = new OpenFileDialog(); op.Filter = "Excel文件(*.xls)|*.xls"; if (op.ShowDialog() == DialogResult.OK) { dts = GetExcel(op.FileName); for (int i = 1; i < dts.Rows.Count; i++) { if (dts.Rows[i][1].ToString().IndexOf("合计") >= 0) continue; z.ID = Guid.NewGuid().ToString(); string strflag = ""; foreach (DataColumn dc in dts.Columns) { strflag = dc.Caption.ToString(); try { switch (strflag) { case "项目名称": z.Title = dts.Rows[i][dc.ColumnName].ToString(); break; case "工程名称": z.L3 = dts.Rows[i][dc.ColumnName].ToString(); break; case "电压等级": z.L4 = dts.Rows[i][dc.ColumnName].ToString(); break; case "主变台数": z.L5 = dts.Rows[i][dc.ColumnName].ToString(); break; case "单台容量(MVA)": z.L6 = dts.Rows[i][dc.ColumnName].ToString(); break; case "总容量(MVA)": z.IsConn = dts.Rows[i][dc.ColumnName].ToString(); break; case "建设形式": z.L7 = dts.Rows[i][dc.ColumnName].ToString(); break; case "线路长度(KM)": z.L8 = dts.Rows[i][dc.ColumnName].ToString(); break; case "导线型号": z.L9 = dts.Rows[i][dc.ColumnName].ToString(); break; //case "投资造价": // z.L11 = dts.Rows[i][dc.ColumnName].ToString(); // break; //case "造价比例": // z.L12 = dts.Rows[i][dc.ColumnName].ToString(); // break; case "标准造价(万元)": z.L10 =double.Parse(dts.Rows[i][dc.ColumnName].ToString()); break; case "造价调整(万元)": z.L11 = dts.Rows[i][dc.ColumnName].ToString(); break; case "工程总价(万元)": z.L12 = double.Parse(dts.Rows[i][dc.ColumnName].ToString()); break; default: j.Value = dts.Rows[i][dc.ColumnName].ToString(); j.TypeID = z.ID; j.Year = dc.ColumnName; j.TypeID1 = flag2; Services.BaseService.Update<PowerProValues>(j); break; } } catch { } } z.Flag2 = flag2; z.ParentID = "0"; //z.Flag = 1; PSP_PowerProValues_LangFang lf=(PSP_PowerProValues_LangFang)Services.BaseService.GetObject("SelectPSP_PowerProValues_LangFangByObject",z); if (lf == null) { Services.BaseService.Create<PSP_PowerProValues_LangFang>(z); } else { z.Code = lf.Code; z.Flag = lf.Flag; Services.BaseService.Update("UpdatePSP_PowerProValues_LangFangBytable", z); } } } ReLoadData(); } catch { MsgBox.Show("导入格式不正确!"); } }
private void FormAddInfo_LangFang_Load(object sender, EventArgs e) { if (isupdate == true) { PSP_PowerProValues_LangFang ppt = new PSP_PowerProValues_LangFang(); ppt.ID = poweruid; ppt.Flag2 = flag; obj = Common.Services.BaseService.GetOneByKey<PSP_PowerProValues_LangFang>(ppt); OBJ = obj; isupdate = true; IList<PSP_PowerProValues_LangFang> list = new List<PSP_PowerProValues_LangFang>(); list.Add(OBJ); this.vGridControl1.DataSource = list; UpDateInit(); } if (isupdate == false) { OBJ.ID = Guid.NewGuid().ToString(); OBJ.CreateTime = DateTime.Now; OBJ.UpdateTime = DateTime.Now; OBJ.ParentID = parentID; OBJ.Flag2 = flag; OBJ.L12 = 0; OBJ.Flag = 2; OBJ.L4 = "220"; OBJ.L5 = "1"; OBJ.L7 = "户内站"; OBJ.L11= "0"; OBJ.L10 = 0; CreateInit(); IList<PSP_PowerProValues_LangFang> list = new List<PSP_PowerProValues_LangFang>(); list.Add(OBJ); this.vGridControl1.DataSource = list; } // this.电压等级.Properties.RowEdit.EditValueChanging+=new ChangingEventHandler(RowEdit_EditValueChanging1); this.电压等级.Properties.RowEdit.Click += new EventHandler(RowEdit_Click); // this.电压等级.Properties.RowEdit.Click += new EventHandler(RowEdit_Click); this.主变台数及容量.Properties.RowEdit.Click +=new EventHandler(RowEdit_Click1); this.出线规模.Properties.RowEdit.Click += new EventHandler(RowEdit_Click2); this.接线形式.Properties.RowEdit.Click += new EventHandler(RowEdit_Click3); this.无功配置.Properties.RowEdit.Click += new EventHandler(RowEdit_Click4); this.投资造价.Properties.RowEdit.Click += new EventHandler(RowEdit_Click5); this.造价比例.Properties.RowEdit.Click += new EventHandler(RowEdit_Click6); this.投资造价.Properties.RowEdit.EditValueChanged += new EventHandler(RowEdit_EditValueChanged); this.造价比例.Properties.RowEdit.EditValueChanging += new ChangingEventHandler(RowEdit_EditValueChanging); LineInfo li22 = Common.Services.BaseService.GetOneByKey<LineInfo>(powerid); if (li22 != null || OBJ.Flag == 1) { isline = true; } substation sb = Common.Services.BaseService.GetOneByKey<substation>(powerid); if (sb != null || OBJ.Flag == 2) { isPower = true; } }
private void simpleButton1_Click(object sender, EventArgs e) { // string z="自定义列"; type = psp_Year.Year = spinEdit1.Text; psp_Year.Flag = flag2; if (type.ToString() == "") { MsgBox.Show("类别名称不能为空"); return; } try { if (!IsUpdate) { if (Common.Services.BaseService.GetObject("SelectPowerProYearsByYearFlag", psp_Year) == null) { try { Common.Services.BaseService.Create<PowerProYears>(psp_Year); this.DialogResult = DialogResult.OK; } catch (Exception ex) { MsgBox.Show("出错啦:" + ex.Message); } } else { MsgBox.Show("此分类已经存在,请重新输入!"); } } else { try { PSP_PowerProValues_LangFang psp_Type = new PSP_PowerProValues_LangFang(); psp_Type.Flag2 = type1; IList<PSP_PowerProValues_LangFang> listTypes = new List<PSP_PowerProValues_LangFang>(); try { listTypes = Common.Services.BaseService.GetList<PSP_PowerProValues_LangFang>("SelectPSP_PowerProValues_LangFangByFlag2", psp_Type); } catch (Exception ex) { MsgBox.Show(ex.Message); } foreach (PSP_PowerProValues_LangFang pstt in listTypes) { PowerProValues psv = new PowerProValues(); psv.TypeID = pstt.ID; psv.Year = psp_Year.Year; psv.Value = year2; psv.TypeID1 = type1; Common.Services.BaseService.Update("UpdatePowerProValuesByYear1", psv); } Common.Services.BaseService.Update<PowerProYears>(psp_Year); this.DialogResult = DialogResult.OK; } catch (Exception ex) { MsgBox.Show("出错啦:" + ex.Message); } } } catch(Exception ex) { MsgBox.Show("出错啦:" + ex.Message); } }
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; }
private void FrmEditProject_Load(object sender, EventArgs e) { SetData(); string q1 = ""; string q2 = ""; string q3 = ""; string q4 = ""; string q5 = ""; string q6 = ""; string q7 = ""; string q8 = ""; string q9 = ""; string q10 = ""; string q11 = ""; string q12 = ""; int t1 = 0; PSP_PowerProValues_LangFang ppt = new PSP_PowerProValues_LangFang(); ppt.ID = poweruid; ppt.Flag2 = flag; PSP_PowerProValues_LangFang ps = Common.Services.BaseService.GetOneByKey<PSP_PowerProValues_LangFang>(ppt); if (ps != null) { groupBox1.Text = ps.Title; powerid = ps.Code; t1 = ps.Flag; // q1 = ps.L1; // q2 = ps.L2; q3 = ps.L3; q4 = ps.L4; q5 = ps.L5; q6 = ps.L6; q7 = ps.L7; q8 = ps.L8; q9 = ps.L9; q10 = ps.L10.ToString(); q11 = ps.L11; q12 = ps.L12.ToString(); } LineInfo li22 = Common.Services.BaseService.GetOneByKey<LineInfo>(powerid); if (li22 != null || t1==1) { isline = true; } substation sb = Common.Services.BaseService.GetOneByKey<substation>(powerid); if (sb != null || t1 == 2) { isPower = true; } PowerProValues ppv = new PowerProValues(); ppv.TypeID = poweruid; ppv.TypeID1 = flag; IList<PowerProValues> listValues = Common.Services.BaseService.GetList<PowerProValues>("SelectPowerProValuesList", ppv); PowerProYears pps = new PowerProYears(); pps.Flag = flag; IList<PowerProYears> li = Common.Services.BaseService.GetList<PowerProYears>("SelectPowerProYearsListByFlag", pps); lb=new Label[li.Count]; te=new TextEdit[li.Count]; int i=0; //if (!isPower) // { ////lt1.Text = "�豸����:"; ////lt1.Location = new Point(52, 27 + 33 * i); ////groupBox1.Controls.Add(lt1); ////tt1 = new TextEdit(); ////tt1.Location = new Point(157, 26 + 33 * i); ////tt1.Size = new Size(231, 21); ////tt1.TextChanged += new EventHandler(tt1_TextChanged); ////tt1.Properties.DisplayFormat.FormatString = "n4"; ////tt1.Properties.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric; ////tt1.Properties.EditFormat.FormatString = "n4"; ////tt1.Properties.EditFormat.FormatType = DevExpress.Utils.FormatType.Numeric; ////tt1.Properties.Mask.EditMask = "#####0.####"; ////tt1.Properties.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.Numeric; ////groupBox1.Controls.Add(tt1); ////i++; ////lt2.Text = "̨��:"; ////lt2.Location = new Point(52, 27 + 33 * i); ////groupBox1.Controls.Add(lt2); ////tt2 = new TextEdit(); ////tt2.Location = new Point(157, 26 + 33 * i); ////tt2.Size = new Size(231, 21); ////groupBox1.Controls.Add(tt2); ////i++; // } //if (!isline) { lt3.Text = "�� �� �� �� :"; lt3.Location = new Point(52, 27 + 33 * i); groupBox1.Controls.Add(lt3); // tt3 = new TextEdit(); cb0.Location = new Point(157, 26 + 33 * i); cb0.Size = new Size(231, 21); cb0.Properties.DisplayFormat.FormatString = "n0"; cb0.Properties.DisplayFormat.FormatType = DevExpress.Utils.FormatType.None; cb0.Properties.EditFormat.FormatString = "n0"; cb0.Properties.EditFormat.FormatType = DevExpress.Utils.FormatType.None; // cb0.Properties.Mask.EditMask = "########"; cb0.Properties.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.None; groupBox1.Controls.Add(cb0); i++; lt4.Text = "�� ѹ �� �� :"; lt4.Location = new Point(52, 27 + 33 * i); groupBox1.Controls.Add(lt4); // tt4 = new TextEdit(); cb1.Location = new Point(157, 26 + 33 * i); cb1.Size = new Size(231, 21); cb1.Properties.DisplayFormat.FormatString = "n4"; cb1.Properties.DisplayFormat.FormatType = DevExpress.Utils.FormatType.None; cb1.Properties.EditFormat.FormatString = "n4"; cb1.Properties.EditFormat.FormatType = DevExpress.Utils.FormatType.None; // cb1.Properties.Mask.EditMask = "#####0.####"; cb1.Properties.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.None; groupBox1.Controls.Add(cb1); i++; lt5.Text = "�� �� ̨ �� :"; lt5.Location = new Point(52, 27 + 33 * i); groupBox1.Controls.Add(lt5); // tt5 = new TextEdit(); cb2.Location = new Point(157, 26 + 33 * i); cb2.Size = new Size(231, 21); cb2.Properties.DisplayFormat.FormatString = "####.##"; cb2.Properties.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric; cb2.Properties.EditFormat.FormatString = "####.##"; cb2.Properties.EditFormat.FormatType = DevExpress.Utils.FormatType.Numeric; // cb2.Properties.Mask.EditMask = "P2"; cb2.Properties.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.Numeric; groupBox1.Controls.Add(cb2); i++; lt6.Text = "��̨������MVA��:"; lt6.Location = new Point(50, 27 + 33 * i); lt6.Width = 105; groupBox1.Controls.Add(lt6); //tt6 = new TextEdit(); cb3.Location = new Point(157, 26 + 33 * i); cb3.Size = new Size(231, 21); cb3.Properties.DisplayFormat.FormatString = "n4"; cb3.Properties.DisplayFormat.FormatType = DevExpress.Utils.FormatType.None; cb3.Properties.EditFormat.FormatString = "n4"; cb3.Properties.EditFormat.FormatType = DevExpress.Utils.FormatType.None; // cb3.Properties.Mask.EditMask = "#####0.####"; cb3.Properties.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.None; groupBox1.Controls.Add(cb3); i++; lt7.Text = "�� �� �� ʽ :"; lt7.Location = new Point(52, 27 + 33 * i); groupBox1.Controls.Add(lt7); //tt6 = new TextEdit(); cb4.Location = new Point(157, 26 + 33 * i); cb4.Size = new Size(231, 21); cb4.Properties.DisplayFormat.FormatString = "n4"; cb4.Properties.DisplayFormat.FormatType = DevExpress.Utils.FormatType.None; cb4.Properties.EditFormat.FormatString = "n4"; cb4.Properties.EditFormat.FormatType = DevExpress.Utils.FormatType.None; // cb4.Properties.Mask.EditMask = "#####0.####"; cb4.Properties.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.None; groupBox1.Controls.Add(cb4); i++; lt8.Text = "��·���ȣ�KM��:"; lt8.Location = new Point(52, 27 + 33 * i); groupBox1.Controls.Add(lt8); //tt6 = new TextEdit(); tt4.Location = new Point(157, 26 + 33 * i); tt4.Size = new Size(231, 21); tt4.Properties.DisplayFormat.FormatString = "n4"; tt4.Properties.DisplayFormat.FormatType = DevExpress.Utils.FormatType.None; tt4.Properties.EditFormat.FormatString = "n4"; tt4.Properties.EditFormat.FormatType = DevExpress.Utils.FormatType.None; // tt4.Properties.Mask.EditMask = "#####0.####"; tt4.Properties.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.None; groupBox1.Controls.Add(tt4); i++; lt9.Text = "�� �� �� �� :"; lt9.Location = new Point(52, 27 + 33 * i); groupBox1.Controls.Add(lt9); //tt6 = new TextEdit(); cb5.Location = new Point(157, 26 + 33 * i); cb5.Size = new Size(231, 21); cb5.Properties.DisplayFormat.FormatString = "n4"; cb5.Properties.DisplayFormat.FormatType = DevExpress.Utils.FormatType.None; cb5.Properties.EditFormat.FormatString = "n4"; cb5.Properties.EditFormat.FormatType = DevExpress.Utils.FormatType.None; // cb5.Properties.Mask.EditMask = "#####0.####"; cb5.Properties.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.None; groupBox1.Controls.Add(cb5); i++; Project_Sum sum = new Project_Sum(); sum.S5 = islineflag; sum.S1 = q4; IList<Project_Sum> list = Services.BaseService.GetList<Project_Sum>("SelectProject_SumByS1andS5",sum); upedit.Properties.DataSource = list; LookUpColumnInfo a = new LookUpColumnInfo(); a.FieldName = "T3"; a.Caption = "������ʽ"; LookUpColumnInfo c = new LookUpColumnInfo(); c.FieldName = "T2"; c.Caption = "���߹�ģ"; LookUpColumnInfo b = new LookUpColumnInfo(); b.FieldName = "T1"; b.Caption = "����̨��������"; LookUpColumnInfo d = new LookUpColumnInfo(); d.Caption = "��̬Ͷ��"; d.FieldName = "Num"; LookUpColumnInfo nn = new LookUpColumnInfo(); nn.FieldName = "Name"; nn.Caption = "���"; LookUpColumnInfo f = new LookUpColumnInfo(); f.FieldName = "Type"; f.Caption = "����"; upedit.Properties.Columns.Add(f); upedit.Properties.Columns.Add(nn); upedit.Properties.Columns.Add(b); upedit.Properties.Columns.Add(c); upedit.Properties.Columns.Add(a); upedit.Properties.Columns.Add(d); upedit.Properties.DisplayMember = "Num"; //upedit.Properties.SearchMode = SearchMode.AutoComplete; //upedit.Properties.AutoSearchColumnIndex = 5; upedit.Properties.DropDownRows =5; upedit.Properties.PopupWidth = 500; upedit.Properties.ShowHeader = true; lt10.Text = "Ͷ �� �� �� :"; lt10.Location = new Point(52, 27 + 33 * i); groupBox1.Controls.Add(lt10); upedit.Location = new Point(157, 26 + 33 * i); upedit.Size = new Size(231, 21); upedit.Properties.DisplayFormat.FormatString = "n4"; upedit.Properties.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric; upedit.Properties.EditFormat.FormatString = "n4"; upedit.Properties.EditFormat.FormatType = DevExpress.Utils.FormatType.Numeric; upedit.Properties.Mask.EditMask = "###############0.####"; upedit.Properties.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.Numeric; upedit.Properties.AllowNullInput=DevExpress.Utils.DefaultBoolean.True; upedit.TextChanged += new EventHandler(upedit_TextChanged); groupBox1.Controls.Add(upedit); i++; lt11.Text = "�� �� �� �� :"; lt11.Location = new Point(52, 27 + 33 * i); groupBox1.Controls.Add(lt11); //tt6 = new TextEdit(); tt6.Location = new Point(157, 26 + 33 * i); tt6.Size = new Size(231, 21); tt6.Properties.DisplayFormat.FormatString = "n4"; tt6.Properties.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric; tt6.Properties.EditFormat.FormatString = "n4"; tt6.Properties.EditFormat.FormatType = DevExpress.Utils.FormatType.Numeric; tt6.Properties.Mask.EditMask = "###############0.####"; tt6.Properties.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.Numeric; tt6.TextChanged += new EventHandler(tt6_TextChanged); groupBox1.Controls.Add(tt6); i++; lt12.Text = "�� �� �� �� :"; lt12.Location = new Point(52, 27 + 33 * i); groupBox1.Controls.Add(lt12); //tt6 = new TextEdit(); tt5.Location = new Point(157, 26 + 33 * i); tt5.Size = new Size(231, 21); tt5.Properties.DisplayFormat.FormatString = "n4"; tt5.Properties.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric; tt5.Properties.EditFormat.FormatString = "n4"; tt5.Properties.EditFormat.FormatType = DevExpress.Utils.FormatType.Numeric; tt5.Properties.Mask.EditMask = "###############0.####"; tt5.Properties.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.Numeric; groupBox1.Controls.Add(tt5); i++; } int j = 0; foreach (PowerProYears ppy in li) { lb[j] = new Label(); lb[j].Name = "Label" + ppy.Year; lb[j].Text = ppy.Year + ":"; lb[j].Location = new Point(52, 27 + 33 * i); groupBox1.Controls.Add(lb[j]); te[j] = new TextEdit(); te[j].Name = "Text" + ppy.Year; te[j].Location = new Point(157, 26 + 33 * i); te[j].Size = new Size(231, 21); groupBox1.Controls.Add(te[j]); foreach (PowerProValues ppy1 in listValues) { if (ppy.Year == ppy1.Year) te[j].Text = ppy1.Value; } j++; i++; } if (isline) { try { // cb5.Properties.Items.Contains(q9.ToString()); //tt1.Text = q3.ToString(); //tt2.Text = q4.ToString(); //if (li22 != null) //{ // tt1.Text = li22.Length; // tt2.Text = li22.LineType; //} } catch { } } if (isPower) { try { ////tt3.Text = q1.ToString(); //tt4.Text = q4.ToString(); //tt5.Text = q5.ToString(); //tt6.Text = q6.ToString(); //if (sb != null) //{ // tt5.Text = sb.Number.ToString(); // tt4.Text = sb.ObligateField2; // tt6.Text = sb.Burthen.ToString(); //} } catch { } } PSP_PowerProValues_LangFang pplf = new PSP_PowerProValues_LangFang(); pplf.Flag2 = flag; IList<PSP_PowerProValues_LangFang> plfs = Common.Services.BaseService.GetList<PSP_PowerProValues_LangFang>("SelectPSP_PowerProValues_LangFangByFlag2OrderL3", pplf); tt4.Text = q8.ToString(); tt5.Text = q10.ToString(); tt6.Text = q12.ToString(); if (plfs.Count == 0) { cb0.Text = ""; } foreach (PSP_PowerProValues_LangFang pv in plfs) { if(pv.L3!=""&&pv.L3.Length>0) cb0.Properties.Items.Add(pv.L3); } cb0.Text = q3.ToString(); cb1.Text = q4.ToString(); cb2.Text = q5.ToString(); cb3.Text = q6.ToString(); cb4.Text = q7.ToString(); cb5.Text = q9.ToString(); lookupedit = q11; upedit.Properties.NullText = q11; groupBox1.Size = new Size(434, 40+ 33 * i); simpleButton1.Location = new Point(296, 60 + 33 * i); simpleButton2.Location = new Point(389, 60 + 33 * i); this.Size = new Size(490, 130 + 33 * i); }