private void initdata() { gridView1.Columns.Clear(); string con = "ProjectID='" + pid + "'and Typeqf='" + type + "'"; IList listTypes = Common.Services.BaseService.GetList("SelectPs_Table_TZMXByValue", con); DevExpress.XtraGrid.Columns.GridColumn column = new DevExpress.XtraGrid.Columns.GridColumn(); column = new DevExpress.XtraGrid.Columns.GridColumn(); column.FieldName = "Title"; column.Caption = "����"; column.VisibleIndex = 0; column.Width = 180; column.OptionsColumn.AllowEdit = false; this.gridView1.Columns.AddRange(new DevExpress.XtraGrid.Columns.GridColumn[] { column}); if (type == "pw-line") { if (listTypes.Count==0) { Ps_Table_TZMX pt = new Ps_Table_TZMX(); pt.ProjectID = pid; pt.Title = "�ܿ���·"; pt.Typeqf = "pw-line"; pt.BuildYear = buildyear; pt.BuildEnd = buildend; listTypes.Add(pt); Services.BaseService.Create<Ps_Table_TZMX>(pt); pt = new Ps_Table_TZMX(); pt.ProjectID = pid; pt.Title = "������·"; pt.Typeqf = "pw-line"; pt.BuildYear = buildyear; pt.BuildEnd = buildend; listTypes.Add(pt); Services.BaseService.Create<Ps_Table_TZMX>(pt); } //column = new DevExpress.XtraGrid.Columns.GridColumn(); //column.FieldName = "Vol"; //column.Caption = "��̬Ͷ��"+buildend.ToString()+"��"; //column.VisibleIndex = 1; //column.Width = 180; //column.OptionsColumn.AllowEdit = false; // this.gridView1.Columns.AddRange(new DevExpress.XtraGrid.Columns.GridColumn[] { //column}); } else if (type == "pw-pb") { if (listTypes.Count == 0) { Ps_Table_TZMX pt = new Ps_Table_TZMX(); pt.ProjectID = pid; pt.Title = "�����"; pt.Typeqf = "pw-pb"; pt.BuildYear = buildyear; pt.BuildEnd = buildend; listTypes.Add(pt); Services.BaseService.Create<Ps_Table_TZMX>(pt); pt = new Ps_Table_TZMX(); pt.ProjectID = pid; pt.Title = "��ʽ���վ"; pt.Typeqf = "pw-pb"; pt.BuildYear = buildyear; pt.BuildEnd = buildend; listTypes.Add(pt); Services.BaseService.Create<Ps_Table_TZMX>(pt); pt = new Ps_Table_TZMX(); pt.ProjectID = pid; pt.Title = "��������ѹ��"; pt.Typeqf = "pw-pb"; pt.BuildYear = buildyear; pt.BuildEnd = buildend; listTypes.Add(pt); Services.BaseService.Create<Ps_Table_TZMX>(pt); } } else if (type == "pw-kg") { if (listTypes.Count == 0) { Ps_Table_TZMX pt = new Ps_Table_TZMX(); pt.ProjectID = pid; pt.Title = "������"; pt.Typeqf = "pw-kg"; pt.BuildYear = buildyear; pt.BuildEnd = buildend; listTypes.Add(pt); Services.BaseService.Create<Ps_Table_TZMX>(pt); pt = new Ps_Table_TZMX(); pt.ProjectID = pid; pt.Title = "������"; pt.Typeqf = "pw-kg"; pt.BuildYear = buildyear; pt.BuildEnd = buildend; listTypes.Add(pt); Services.BaseService.Create<Ps_Table_TZMX>(pt); pt = new Ps_Table_TZMX(); pt.ProjectID = pid; pt.Title = "���Ͽ���"; pt.Typeqf = "pw-kg"; pt.BuildYear = buildyear; pt.BuildEnd = buildend; listTypes.Add(pt); Services.BaseService.Create<Ps_Table_TZMX>(pt); pt = new Ps_Table_TZMX(); pt.ProjectID = pid; pt.Title = "���·�֧��"; pt.Typeqf = "pw-kg"; pt.BuildYear = buildyear; pt.BuildEnd = buildend; listTypes.Add(pt); Services.BaseService.Create<Ps_Table_TZMX>(pt); } } int firyear = Convert.ToInt32(buildyear); int endyear = Convert.ToInt32(buildend); for (int i = firyear; i <= endyear; i++) { AddColumn(i); } column = new DevExpress.XtraGrid.Columns.GridColumn(); column.FieldName = "LendRate"; column.Caption = "�����ڴ�����Ϣ"; column.VisibleIndex = 2 + endyear - firyear+1; column.Width = 180; //column.OptionsColumn.AllowEdit = false; this.gridView1.Columns.AddRange(new DevExpress.XtraGrid.Columns.GridColumn[] { column}); column = new DevExpress.XtraGrid.Columns.GridColumn(); column.FieldName = "PrepChange"; column.Caption = "Ԥ������"; column.VisibleIndex = 3+endyear - firyear + 1; column.Width = 180; //column.OptionsColumn.AllowEdit = false; this.gridView1.Columns.AddRange(new DevExpress.XtraGrid.Columns.GridColumn[] { column}); column = new DevExpress.XtraGrid.Columns.GridColumn(); column.FieldName = "DynInvest"; column.Caption = "��̬Ͷ��"; column.VisibleIndex = 4 + endyear - firyear + 1; column.Width = 180; //column.OptionsColumn.AllowEdit = false; this.gridView1.Columns.AddRange(new DevExpress.XtraGrid.Columns.GridColumn[] { column}); this.gridControl1.DataSource = listTypes; }
/// <summary> /// 返回单位工程综合造价 /// </summary> /// <param name="pTT1"></param> /// <returns></returns> private double ReturnAmount(Ps_Table_TZMX pTT1, Ps_Table_TZGS pTT,string Typeqf) { string strTemp = null; int beginYear = 0; int EndYear = 0; int.TryParse(pTT1.BuildYear, out beginYear); int.TryParse(pTT1.BuildEnd, out EndYear); strTemp = null; for (int k = beginYear; k <= EndYear; ++k) { if (k == EndYear) strTemp += "y" + k; else strTemp += "y" + k + "+"; } return SelectAmount(strTemp, pTT.ID, "sub"); }
/// <summary> /// 写入高压数据 /// </summary> /// <param name="obj"></param> /// <param name="IntRow"></param> /// <param name="IntCol"></param> private void WriteHeightData(Itop.Client.Base.FormBase FB, FarPoint.Win.Spread.SheetView obj, int IntRow, int IntCol) { int RowTemp = IntRow; double Amount = 0; IList list = null; Ps_Table_TZGS pTT = new Ps_Table_TZGS(); Ps_Table_TZMX pTT1 = new Ps_Table_TZMX(); //IList list = null; //list = SelectVoltageClass(FB, "新建"); for (int i = 0; i < HP.INew.Count; i++) { pTT = (Ps_Table_TZGS)HP.INew[i]; PF.CreateSheetView(obj, HP.INewVolume[i].Count, 1, RowTemp, 2, pTT.BianInfo);//新建 list = HP.INewVolume[i]; for (int j = 0; j < list.Count; ++j) { pTT1 = (Ps_Table_TZMX)list[j]; PF.CreateSheetView(obj, 1, 1, (RowTemp + j), 3, pTT1.Vol.ToString() + unit);//新建 Amount = ReturnAmount(pTT1, pTT, "sub"); obj.SetValue(RowTemp, 4, Amount);//单位工程综合造价 obj.SetValue(RowTemp,5,strUnit+unit);//单位 obj.SetValue(RowTemp, 6, pTT.Col1);//备注 } if (HP.INewVolume[i].Count == 0) { RowTemp += 1; } else { RowTemp += HP.INewVolume[i].Count; } } //list = SelectVoltageClass(FB, "扩建"); for (int i = 0; i < HP.IExtends.Count; i ++) { pTT = (Ps_Table_TZGS)HP.IExtends[i]; PF.CreateSheetView(obj, HP.IExtendsVolume[i].Count, 1, RowTemp , 2, pTT.BianInfo);//扩建 list = HP.IExtendsVolume[i]; for (int j = 0; j < list.Count; ++j) { pTT1 = (Ps_Table_TZMX)list[j]; PF.CreateSheetView(obj, 1, 1, (RowTemp + j), 3, pTT1.Vol.ToString() + unit);//扩建 Amount = ReturnAmount(pTT1, pTT, "sub"); obj.SetValue(RowTemp, 4, Amount);//单位工程综合造价 obj.SetValue(RowTemp, 5, strUnit + unit);//单位 obj.SetValue(RowTemp, 6, pTT.Col1);//备注 } if (HP.IExtendsVolume[i].Count==0) { RowTemp += 1; } else { RowTemp += HP.IExtendsVolume[i].Count; } } //list = SelectVoltageClass(FB, "改造"); for (int i = 0; i < HP.IRebuild.Count; i ++) { pTT = (Ps_Table_TZGS)HP.IRebuild[i]; PF.CreateSheetView(obj, HP.IRebuildVolume[i].Count, 1, RowTemp , 2, pTT.BianInfo);//改造 list = HP.IRebuildVolume[i]; for (int j = 0; j < list.Count; ++j) { pTT1 = (Ps_Table_TZMX)list[j]; PF.CreateSheetView(obj, 1, 1, (RowTemp + j), 3, pTT1.Vol.ToString() + unit);//改造 Amount = ReturnAmount(pTT1, pTT, "sub"); obj.SetValue(RowTemp, 4, Amount);//单位工程综合造价 obj.SetValue(RowTemp, 5, strUnit + unit);//单位 obj.SetValue(RowTemp, 6, pTT.Col1);//备注 } if (HP.IRebuildVolume[i].Count==0) { RowTemp += 1; } else { RowTemp += HP.IRebuildVolume[i].Count; } } //架空线路 for(int i=0;i<HP.INew.Count;++i) { pTT = (Ps_Table_TZGS)HP.INew[i]; ////if (HP.Length[i].Count == 0 || HP.Length[i] == null) ////{ //// intTemp = 1; ////} ////else ////{ //// intTemp = HP.Length[i].Count; ////} PF.CreateSheetView(obj, 1, 1, RowTemp +i, 2, pTT.BianInfo);//新建架空电压等级 PF.CreateSheetView(obj, 1, 1, RowTemp+i, 3, pTT.Length.ToString());//新建架空线路 list = HP.Length[i]; for (int j = 0; j < list.Count;++j ) { pTT1 = (Ps_Table_TZMX)list[j]; Amount = ReturnAmount(pTT1, pTT, "line"); obj.SetValue(RowTemp + i, 4, Amount);//单位工程综合造价 obj.SetValue(RowTemp, 5, strUnit + strUnit1);//单位 obj.SetValue(RowTemp, 6, pTT.Col1);//备注 } } RowTemp += HP.INew.Count; //新建电缆线路 for(int i=0;i<HP.INew.Count;++i) { pTT = (Ps_Table_TZGS)HP.INew[i]; ////if (HP.Length[i].Count == 0 || HP.Length[i] == null) ////{ //// intTemp = 1; ////} ////else ////{ //// intTemp = HP.Length[i].Count; ////} PF.CreateSheetView(obj, 1, 1, RowTemp+i , 2, pTT.BianInfo);//新建电缆电压等级 PF.CreateSheetView(obj, 1, 1, RowTemp+i, 3, pTT.Length2.ToString());//新建电缆线路 list = HP.Length[i]; for (int j = 0; j < list.Count; ++j) { pTT1 = (Ps_Table_TZMX)list[j]; Amount = ReturnAmount(pTT1, pTT, "line"); obj.SetValue(RowTemp + i, 4, Amount);//单位工程综合造价 obj.SetValue(RowTemp, 5, strUnit + strUnit1);//单位 obj.SetValue(RowTemp, 6, pTT.Col1);//备注 } } RowTemp += HP.INew.Count; }
private void barButtonItem1_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (devicenum>gridView1.RowCount||devicenum==0) { Ps_Table_TZMX px = new Ps_Table_TZMX(); FormTZGSXXdialog fd = new FormTZGSXXdialog(); fd.type = type; fd.volt = volt; fd.buildyear =Convert.ToInt32(buildyear); fd.buildend =Convert.ToInt32(buildend) ; fd.tzmx = px; fd.ShowDialog(); if (fd.DialogResult==DialogResult.OK) { Ps_Table_TZMX pt = fd.tzmx; pt.ProjectID = pid; pt.Typeqf = type; pt.BuildYear = buildyear; pt.BuildEnd = buildend; Services.BaseService.Create<Ps_Table_TZMX>(pt); } initdata(); } else { MessageBox.Show("���վ����Ŀ�Ѿ��ﵽ!"); return; } }