private void Sheet_AddData(FarPoint.Win.Spread.SheetView obj_sheet, int year, string ProjID, IList <double> obj_DY_List, IList <string> SXareaid_List, IList <string> XJareaid_List) { }
//此处为动态添加数据方法 private void Sheet_AddData(FarPoint.Win.Spread.SheetView obj_sheet) { int[] TableYearsAry = TC.GetTableYears(this.GetType().Name); int startrow = 2; int itemlength = 9; string sqlwhere = " ProjectID='" + Tcommon.ProjectID + "'"; IList <PS_Table_AreaWH> ptalist = Services.BaseService.GetList <PS_Table_AreaWH>("SelectPS_Table_AreaWHByConn", sqlwhere); //重新设定行数 obj_sheet.RowCount = startrow + (ptalist.Count + 1) * itemlength; string sqlwheretemp = " ForecastID='4' and Col4='" + Tcommon.ProjectID + "'"; IList phlisttemp = Services.BaseService.GetList("SelectPs_HistoryBYconnstr", sqlwheretemp); DataTable dttemp = DataConverter.ToDataTable(phlisttemp, typeof(Ps_History)); Ps_History AllRk = new Ps_History(); Ps_History CZrk = new Ps_History(); DataRow RowAllrk = dttemp.NewRow();; DataRow RowCZrk = dttemp.NewRow(); RowAllrk = DataConverter.ObjectToRow(AllRk, RowAllrk); RowCZrk = DataConverter.ObjectToRow(CZrk, RowCZrk); for (int i = 0; i < ptalist.Count; i++) { AddItems(obj_sheet, ptalist[i].Title, startrow + i * itemlength); string sqlwhere2 = " ForecastID='4' and Col4='" + Tcommon.ProjectID + "' and Title='" + ptalist[i].Title + "'"; IList <Ps_History> phlist = Services.BaseService.GetList <Ps_History>("SelectPs_HistoryBYconnstr", sqlwhere2); if (phlist.Count > 0) { string sqlwhere3 = " ForecastID='4' and Col4='" + Tcommon.ProjectID + "' and ParentID='" + phlist[0].ID + "'"; IList phlist3 = Services.BaseService.GetList("SelectPs_HistoryBYconnstr", sqlwhere3); DataTable dt = DataConverter.ToDataTable(phlist3, typeof(Ps_History)); DataRow[] rows1 = dt.Select("Title like '一产%'"); DataRow[] rows2 = dt.Select("Title like '二产%'"); DataRow[] rows3 = dt.Select("Title like '三产%'"); DataRow[] rows4 = dt.Select("Title like '人口%'"); DataRow[] rows7 = null; DataRow[] rows8 = null; if (rows4.Length != 0) { string sqlwhere4 = " ForecastID='4' and Col4='" + Tcommon.ProjectID + "' and ParentID='" + rows4[0]["ID"] + "'"; IList phlist4 = Services.BaseService.GetList("SelectPs_HistoryBYconnstr", sqlwhere4); DataTable dt2 = DataConverter.ToDataTable(phlist4, typeof(Ps_History)); rows7 = dt2.Select("Title like '城镇人口%'"); rows8 = dt2.Select("Title like '乡村人口%'"); } DataRow[] rows5 = dt.Select("Title like '行政面积%'"); DataRow[] rows6 = dt.Select("Title like '建成区面积%'"); //国内生产总值(亿元)=一产+二产+三产 TC.Sheet_WriteFormula_RowSum(obj_sheet, startrow + i * itemlength + 1, 2, 3, 1, startrow + i * itemlength, 2, TableYearsAry.Length); //人均GDP(万元)=国内生产总值(亿元)/人口; TC.Sheet_WriteFormula_OneRow_AnoterRow_nopercent(obj_sheet, startrow + i * itemlength + 4, 2, startrow + i * itemlength, startrow + i * itemlength + 5, TableYearsAry.Length); for (int j = 0; j < TableYearsAry.Length; j++) { int m = 0; //一产 string yearstr = "y" + TableYearsAry[j].ToString(); m++; if (rows1.Length != 0) { obj_sheet.SetValue(startrow + i * itemlength + m, 2 + j, rows1[0][yearstr]); } else { TC.WriteQuestion(title, ptalist[i].Title + "无一产数据", "查询 分区供电实绩,看是否有该区一产数据", ""); } //二产 m++; if (rows2.Length != 0) { obj_sheet.SetValue(startrow + i * itemlength + m, 2 + j, rows2[0][yearstr]); } else { TC.WriteQuestion(title, ptalist[i].Title + "无二产数据", "查询 分区供电实绩,看是否有该区二产数据", ""); } //三产 m++; if (rows3.Length != 0) { obj_sheet.SetValue(startrow + i * itemlength + m, 2 + j, rows3[0][yearstr]); } else { TC.WriteQuestion(title, ptalist[i].Title + "无三产数据", "查询 分区供电实绩,看是否有该区三产数据", ""); } //人口 m++; if (rows4.Length != 0) { obj_sheet.SetValue(startrow + i * itemlength + m, 2 + j, rows4[0][yearstr]); } else { TC.WriteQuestion(title, ptalist[i].Title + "无人口数据", "查询 分区供电实绩,看是否有该区人口数据", ""); } m++; //行政面积(平方千米) m++; if (rows5.Length != 0) { obj_sheet.SetValue(startrow + i * itemlength + m, 2 + j, rows5[0][yearstr]); } else { TC.WriteQuestion(title, ptalist[i].Title + "无行政面积数据", "查询 分区供电实绩,看是否有该区行政面积数据", ""); } //建成区面积(平方千米) m++; if (rows6.Length != 0) { obj_sheet.SetValue(startrow + i * itemlength + m, 2 + j, rows6[0][yearstr]); } else { TC.WriteQuestion(title, ptalist[i].Title + "无建成区面积数据", "查询 分区供电实绩,看是否有该区建成区面积数据", ""); } //城镇化率(%) m++; if (rows7 != null && rows4.Length != 0) { obj_sheet.SetValue(startrow + i * itemlength + m, 2 + j, Convert.ToDouble(rows7[0][yearstr]) / Convert.ToDouble(rows4[0][yearstr])); FarPoint.Win.Spread.CellType.PercentCellType newcelltype = new FarPoint.Win.Spread.CellType.PercentCellType(); newcelltype.DecimalPlaces = 2; obj_sheet.Cells[startrow + i * itemlength + m, 2 + j].CellType = newcelltype; RowAllrk[yearstr] = Convert.ToDouble(RowAllrk[yearstr]) + Convert.ToDouble(rows4[0][yearstr]); RowCZrk[yearstr] = Convert.ToDouble(RowCZrk[yearstr]) + Convert.ToDouble(rows7[0][yearstr]); } else { TC.WriteQuestion(title, ptalist[i].Title + "无城镇人口或总人口数据", "查询 分区供电实绩,看是否有该区城镇人口或总人口数据", ""); } } } } AddItems(obj_sheet, "全市", startrow + ptalist.Count * itemlength); TC.Sheet_WriteFormula_RowSum2(obj_sheet, startrow, 2, ptalist.Count, itemlength, startrow + ptalist.Count * itemlength, 2, 1, 3, TableYearsAry.Length); TC.Sheet_WriteFormula_RowSum2(obj_sheet, startrow, 2, ptalist.Count, itemlength, startrow + ptalist.Count * itemlength, 2, 6, 2, TableYearsAry.Length); //国内生产总值(亿元)=一产+二产+三产 TC.Sheet_WriteFormula_RowSum(obj_sheet, startrow + ptalist.Count * itemlength + 1, 2, 3, 1, startrow + ptalist.Count * itemlength, 2, TableYearsAry.Length); //人均GDP(万元)=国内生产总值(亿元)/人口; TC.Sheet_WriteFormula_OneRow_AnoterRow_nopercent(obj_sheet, startrow + ptalist.Count * itemlength + 4, 2, startrow + ptalist.Count * itemlength, startrow + ptalist.Count * itemlength + 5, TableYearsAry.Length); //最后城镇化率 for (int k = 0; k < TableYearsAry.Length; k++) { string yearstr = "y" + TableYearsAry[k].ToString(); obj_sheet.SetValue(startrow + ptalist.Count * itemlength + 8, 2 + k, Convert.ToDouble(RowCZrk[yearstr]) / Convert.ToDouble(RowAllrk[yearstr])); FarPoint.Win.Spread.CellType.PercentCellType newcelltype = new FarPoint.Win.Spread.CellType.PercentCellType(); newcelltype.DecimalPlaces = 2; obj_sheet.Cells[startrow + ptalist.Count * itemlength + 8, 2 + k].CellType = newcelltype; } //几何年平均增长率 for (int l = 0; l < (ptalist.Count + 1) * itemlength; l++) { obj_sheet.Cells[startrow + l, 2 + TableYearsAry.Length].Formula = " Power(R" + (startrow + l + 1) + "C" + (2 + TableYearsAry.Length) + "/R" + (startrow + l + 1) + "C" + 3 + "," + (1.000 / TableYearsAry.Length) + ")-1"; FarPoint.Win.Spread.CellType.PercentCellType newcelltype = new FarPoint.Win.Spread.CellType.PercentCellType(); newcelltype.DecimalPlaces = 2; obj_sheet.Cells[startrow + l, 2 + TableYearsAry.Length].CellType = newcelltype; } }
/// <summary> /// 清空指定的表 /// </summary> private void SheetNClear(FarPoint.Win.Spread.SheetView obj) { obj.RowCount = 0; obj.ColumnCount = 0; }
private void barBtnRefreshData_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { WaitDialogForm newwait = new WaitDialogForm("", "正在更新数据, 请稍候..."); //生成一个空表用来保存当前表 FarPoint.Win.Spread.SheetView obj_sheet = null; //生成一个空表,行列值都设为0用来做为程序处理时的当前表,这样可以提高处理速度 FarPoint.Win.Spread.SheetView activesheet = new FarPoint.Win.Spread.SheetView(); activesheet.RowCount = 0; activesheet.ColumnCount = 0; //添加空表 fpSpread1.Sheets.Add(activesheet); //保留当前表,以备程序结束后还原当前表 obj_sheet = fpSpread1.ActiveSheet; //将空表设为当前表 fpSpread1.ActiveSheet = activesheet; //更新表3-1 sh31.Sheet_AddData(fpSpread1.Sheets[0], year, ProjID, SxXjName); sh31.CellType(fpSpread1.Sheets[0]); //更新表3-2 sh32.Sheet_AddData(fpSpread1.Sheets[1], year, ProjID, SxXjName); sh32.CellType(fpSpread1.Sheets[1]); //更新表3-3全手写,无需更新 //更新表3-3附表1 分区有可能变化,所以先存数据,重建表,再比对写回数据 sh33_1.SaveData(fpSpread1.Sheets[3]); fpSpread1.Sheets[3].RowCount = 0; fpSpread1.Sheets[3].ColumnCount = 0; sh33_1.Build(fpSpread1.Sheets[3], year, ProjID, area_key_id, SxXjName); sh33_1.WriteData(fpSpread1.Sheets[3]); //更新表3-4 fpSpread1.Sheets[4].RowCount = 0; fpSpread1.Sheets[4].ColumnCount = 0; sh34.Build(fpSpread1.Sheets[4], year, ProjID, SxXjName); //更新表3-4附表2 fpSpread1.Sheets[5].RowCount = 0; fpSpread1.Sheets[5].ColumnCount = 0; sh34_2.Build(fpSpread1.Sheets[5], year, ProjID,area_key_id,SxXjName); //清除表格原有数据,这样写入速度快 //更新表3-5 fpSpread1.Sheets[6].RowCount = 0; fpSpread1.Sheets[6].ColumnCount = 0; sh35.Build(fpSpread1.Sheets[6],year,ProjID,SxXjName); //更新表3-6 fpSpread1.Sheets[7].RowCount = 0; fpSpread1.Sheets[7].ColumnCount = 0; sh36.Build(fpSpread1.Sheets[7], year, ProjID, SxXjName); //更新表3-7 有手写数据,只更新动态数据 sh37.Sheet_AddData(fpSpread1.Sheets[8],year,ProjID); //更新表3-7附表3 有手写,表格是动态 sh37_3.SaveData(fpSpread1.Sheets[9]); fpSpread1.Sheets[9].RowCount = 0; fpSpread1.Sheets[9].ColumnCount = 0; sh37_3.Build(fpSpread1.Sheets[9],year,ProjID,area_key_id,SxXjName); sh37_3.WriteData(fpSpread1.Sheets[9]); //更新表3-8 fpSpread1.Sheets[10].RowCount = 0; fpSpread1.Sheets[10].ColumnCount = 0; sh38.Build(fpSpread1.Sheets[10], year, ProjID, SxXjName); //更新表3-8附表8 fpSpread1.Sheets[11].RowCount = 0; fpSpread1.Sheets[11].ColumnCount = 0; sh38_8.Build(fpSpread1.Sheets[11], year, ProjID,area_key_name, area_key_id, SxXjName); //更新表3-9 fpSpread1.Sheets[12].RowCount = 0; fpSpread1.Sheets[12].ColumnCount = 0; sh39.Build(fpSpread1.Sheets[12], year, ProjID, SxXjName); //更新表3-9附表6 fpSpread1.Sheets[13].RowCount = 0; fpSpread1.Sheets[13].ColumnCount = 0; sh39_6.Build(fpSpread1.Sheets[13], year, ProjID, area_key_id, SxXjName); //更新表3-10 fpSpread1.Sheets[14].RowCount = 0; fpSpread1.Sheets[14].ColumnCount = 0; sh310.Build(fpSpread1.Sheets[14], year, ProjID, SxXjName); //更新表3-10附表5 fpSpread1.Sheets[15].RowCount = 0; fpSpread1.Sheets[15].ColumnCount = 0; sh310_5.Build(fpSpread1.Sheets[15], year, ProjID, area_key_id, SxXjName); //更新表3-11 fpSpread1.Sheets[16].RowCount = 0; fpSpread1.Sheets[16].ColumnCount = 0; sh311.Build(fpSpread1.Sheets[16], year, ProjID, SxXjName); //更新表3-11附表9 fpSpread1.Sheets[17].RowCount = 0; fpSpread1.Sheets[17].ColumnCount = 0; sh311_9.Build(fpSpread1.Sheets[17], year, ProjID, area_key_id, SxXjName); //更新表3-12 fpSpread1.Sheets[18].RowCount = 0; fpSpread1.Sheets[18].ColumnCount = 0; sh312.Build(fpSpread1.Sheets[18], year, ProjID, SxXjName); //更新表3-12附表10 fpSpread1.Sheets[19].RowCount = 0; fpSpread1.Sheets[19].ColumnCount = 0; sh312_10.Build(fpSpread1.Sheets[19],year,ProjID,area_key_id,SxXjName); //更新表3-13 fpSpread1.Sheets[20].RowCount = 0; fpSpread1.Sheets[20].ColumnCount = 0; sh313.Build(fpSpread1.Sheets[20], year, ProjID, SxXjName); //更新表3-13附表11 fpSpread1.Sheets[21].RowCount = 0; fpSpread1.Sheets[21].ColumnCount = 0; sh313_11.Build(fpSpread1.Sheets[21], year, ProjID, area_key_id, SxXjName); //更新表3-14 sh314.SaveData(fpSpread1.Sheets[22]); fpSpread1.Sheets[22].RowCount = 0; fpSpread1.Sheets[22].ColumnCount = 0; sh314.Build(fpSpread1.Sheets[22], year, ProjID, SxXjName); sh314.WriteData(fpSpread1.Sheets[22]); //更新表3-14附表12 sh314_12.SaveData(fpSpread1.Sheets[23]); fpSpread1.Sheets[23].RowCount = 0; fpSpread1.Sheets[23].ColumnCount = 0; sh314_12.Build(fpSpread1.Sheets[23], year, ProjID, area_key_id, SxXjName); sh314_12.WriteData(fpSpread1.Sheets[23]); //更新表3-15 fpSpread1.Sheets[24].RowCount = 0; fpSpread1.Sheets[24].ColumnCount = 0; sh315.Build(fpSpread1,fpSpread1.Sheets[24], year, ProjID, SxXjName); //更新表3-15附表14 fpSpread1.Sheets[25].RowCount = 0; fpSpread1.Sheets[25].ColumnCount = 0; sh315_14.Build(fpSpread1.Sheets[25], year, ProjID, area_key_id, SxXjName); //更新表3-16 fpSpread1.Sheets[26].RowCount = 0; fpSpread1.Sheets[26].ColumnCount = 0; sh316.Build(fpSpread1.Sheets[26], year, ProjID, SxXjName); //更新表3-16附表16 fpSpread1.Sheets[27].RowCount = 0; fpSpread1.Sheets[27].ColumnCount = 0; sh316_16.Build(fpSpread1.Sheets[27], year, ProjID, area_key_id, SxXjName); //更新表3-17 sh317.SaveData(fpSpread1.Sheets[28]); fpSpread1.Sheets[28].RowCount = 0; fpSpread1.Sheets[28].ColumnCount = 0; sh317.Build(fpSpread1.Sheets[28], year, ProjID, SxXjName); sh317.WriteData(fpSpread1.Sheets[28]); //更新表3-17附表17 sh317_17.SaveData(fpSpread1.Sheets[29]); fpSpread1.Sheets[29].RowCount = 0; fpSpread1.Sheets[29].ColumnCount = 0; sh317_17.Build(fpSpread1.Sheets[29], year, ProjID, area_key_id, SxXjName); sh317_17.WriteData(fpSpread1.Sheets[29]); //更新表3-18全部手写,无电压等级,表格固定无需更新 //表为fpSpread1.Sheets[30] //更新表3-18附表19(分区有可能更新,所以要保存原数据更新后写回) sh318_19.SaveData(fpSpread1.Sheets[31]); fpSpread1.Sheets[31].RowCount = 0; fpSpread1.Sheets[31].ColumnCount = 0; sh318_19.Build(fpSpread1.Sheets[31], year, ProjID, area_key_id, SxXjName); sh318_19.WriteData(fpSpread1.Sheets[31]); //更新表3-19 fpSpread1.Sheets[32].RowCount = 0; fpSpread1.Sheets[32].ColumnCount = 0; sh319.Build(fpSpread1.Sheets[32], year, ProjID, SxXjName); //更新表3-19附表20 fpSpread1.Sheets[33].RowCount = 0; fpSpread1.Sheets[33].ColumnCount = 0; sh319_20.Build(fpSpread1.Sheets[33], year, ProjID, area_key_id, SxXjName); //更新表3-20全部手写,无电压等级,表格固定无需更新 //表为fpSpread1.Sheets[34] //更新表3-20附表21(分区有可能更新,所以要保存原数据更新后写回) sh320_21.SaveData(fpSpread1.Sheets[35]); fpSpread1.Sheets[35].RowCount = 0; fpSpread1.Sheets[35].ColumnCount = 0; sh320_21.Build(fpSpread1.Sheets[35], year, ProjID, area_key_id, SxXjName); sh320_21.WriteData(fpSpread1.Sheets[35]); //移除空表 fpSpread1.Sheets.Remove(activesheet); //还原当前表 fpSpread1.ActiveSheet = obj_sheet; //设文本自动换行 fc.Sheet_Colautoenter(fpSpread1); newwait.Close(); MessageBox.Show("更新数据完成!"); }
/// <summary> /// 添加工作簿 /// </summary> private void AddSheets() { for(int i=0;i<SheetN;++i) { fpSpread1_SheetN[i] = new FarPoint.Win.Spread.SheetView(); fpSpread1.Sheets.Add(fpSpread1_SheetN[i]); } }
/// <summary> /// 更新数据 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void barButtonItem2_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { wait = new WaitDialogForm("", "正在更新数据, 请稍候..."); ////由于SheetView已经没有了所以移除SheetView //MessageBox.Show(fpSpread1.Sheets[0].SheetName); //=================================================== FarPoint.Win.Spread.SheetView obj = null; //由于更新数据时间太长需要建个空表做初始界面 FarPoint.Win.Spread.SheetView fpSpread1_SheetN = new FarPoint.Win.Spread.SheetView(); fpSpread1.Sheets.Add(fpSpread1_SheetN); obj = fpSpread1.ActiveSheet; fpSpread1.ActiveSheet = fpSpread1_SheetN; //PF.CreateSheet(this, fpSpread1, "kk"); //SheetIndex = fpSpread1.ActiveSheetIndex;//记住当前的SheetView的索引值 //fpSpread1.ActiveSheet=fpSpread1.Sheets[fpSpread1.Sheets.Count-1];//把当前界面给空表 PF.RemoveSheetView(this.fpSpread1, (fpSpread1.Sheets.Count - 1));//清空所有行列 //this.fpSpread1.Sheets.Clear(); IsCreateSheet = false; LoadData(); //newwait.Close(); IsCreateSheet = true; fpSpread1.ActiveSheet = fpSpread1.Sheets[SheetIndex];//把以前显示的界面在显示出来 //if (SheetIndex == 2) //{ // this.barEditItem2.Visibility = DevExpress.XtraBars.BarItemVisibility.Always; //} //删除临时SheetView //fpSpread1.Sheets.Remove(fpSpread1.Sheets[fpSpread1.Sheets.Count - 1]); fpSpread1.Sheets.Remove(fpSpread1_SheetN); //MessageBox.Show("更新数据完成!"); wait.Close(); }
/// <summary> /// 更新数据 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void barButtonItem3_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { wait1 = new WaitDialogForm("", "正在更新数据, 请稍候..."); ////由于SheetView已经没有了所以移除SheetView //MessageBox.Show(fpSpread1.Sheets[0].SheetName); //=================================================== //由于更新数据时间太长需要建个空表做初始界面 FarPoint.Win.Spread.SheetView obj = null; FarPoint.Win.Spread.SheetView fpSpread1_SheetN = new FarPoint.Win.Spread.SheetView(); SheetNClear(fpSpread1_SheetN); fpSpread1.Sheets.Add(fpSpread1_SheetN); obj = fpSpread1.ActiveSheet; fpSpread1.ActiveSheet = fpSpread1_SheetN; S10_10.SaveData(fpSpread1.Sheets[12], 5, 2, 1, 6); this.fpSpread1.Sheets.Clear(); //PF.CreateSheet(this, fpSpread1, "kk"); //SheetIndex = fpSpread1.ActiveSheetIndex;//记住当前的SheetView的索引值 //fpSpread1.ActiveSheet = fpSpread1.Sheets[fpSpread1.Sheets.Count - 1];//把当前界面给空表 //PF.RemoveSheetView(this.fpSpread1, (fpSpread1.Sheets.Count - 1));//清空所有行列 ////由于表10_10是手写所以不用更新,所以不用清除 //for (int i = 0; i < fpSpread1.Sheets.Count - 1; ++i) //{ // if(i!=12) // { // fpSpread1.Sheets[i].RowCount = 0; // fpSpread1.Sheets[i].ColumnCount = 0; // } //} //this.barEditItem1.Visibility = DevExpress.XtraBars.BarItemVisibility.Never; IsCreateSheet = false; Updateing(); IsCreateSheet = true; fpSpread1.ActiveSheet = fpSpread1.Sheets[SheetIndex];//把以前显示的界面在显示出来 //删除临时SheetView //fpSpread1.Sheets.Remove(fpSpread1.Sheets[fpSpread1.Sheets.Count - 1]); fpSpread1.Sheets.Remove(fpSpread1_SheetN); //if (SheetIndex == fpSpread1.Sheets.Count - 1) //{ // this.barEditItem1.Visibility = DevExpress.XtraBars.BarItemVisibility.Always ; //} //MessageBox.Show("更新数据完成!"); wait1.Close(); }
/// <summary> /// 设计器支持所需的方法 - 不要 /// 使用代码编辑器修改此方法的内容。 /// </summary> private void InitializeComponent() { this.components = new System.ComponentModel.Container(); System.Resources.ResourceManager resources = new System.Resources.ResourceManager(typeof(ucCardManage)); this.panel1 = new Neusoft.FrameWork.WinForms.Controls.NeuPanel(); this.textBox1 = new Neusoft.FrameWork.WinForms.Controls.NeuTextBox(); this.label1 = new Neusoft.FrameWork.WinForms.Controls.NeuLabel(); this.panel2 = new Neusoft.FrameWork.WinForms.Controls.NeuPanel(); this.fpSpread1 = new FarPoint.Win.Spread.FpSpread(); this.fpSpread1_Sheet1 = new FarPoint.Win.Spread.SheetView(); this.panel1.SuspendLayout(); this.panel2.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.fpSpread1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.fpSpread1_Sheet1)).BeginInit(); this.SuspendLayout(); // // panel1 // this.panel1.Controls.Add(this.textBox1); this.panel1.Controls.Add(this.label1); this.panel1.Dock = System.Windows.Forms.DockStyle.Top; this.panel1.Location = new System.Drawing.Point(0, 57); this.panel1.Name = "panel1"; this.panel1.Size = new System.Drawing.Size(1016, 39); this.panel1.TabIndex = 1; this.panel1.Visible = false; // // textBox1 // this.textBox1.Location = new System.Drawing.Point(80, 8); this.textBox1.Name = "textBox1"; this.textBox1.TabIndex = 1; this.textBox1.Text = ""; // // label1 // this.label1.AutoSize = true; this.label1.Location = new System.Drawing.Point(32, 8); this.label1.Name = "label1"; this.label1.Size = new System.Drawing.Size(29, 17); this.label1.TabIndex = 0; this.label1.Text = "查询"; this.label1.TextAlign = System.Drawing.ContentAlignment.MiddleLeft; // // panel2 // this.panel2.Controls.Add(this.fpSpread1); this.panel2.Dock = System.Windows.Forms.DockStyle.Fill; this.panel2.Location = new System.Drawing.Point(0, 96); this.panel2.Name = "panel2"; this.panel2.Size = new System.Drawing.Size(1016, 645); this.panel2.TabIndex = 2; // // fpSpread1 // this.fpSpread1.Dock = System.Windows.Forms.DockStyle.Fill; this.fpSpread1.Location = new System.Drawing.Point(0, 0); this.fpSpread1.Name = "fpSpread1"; this.fpSpread1.Sheets.AddRange(new FarPoint.Win.Spread.SheetView[] { this.fpSpread1_Sheet1 }); this.fpSpread1.Size = new System.Drawing.Size(1016, 645); this.fpSpread1.TabIndex = 0; this.fpSpread1.CellDoubleClick += new FarPoint.Win.Spread.CellClickEventHandler(this.fpSpread1_CellDoubleClick); // // fpSpread1_Sheet1 // this.fpSpread1_Sheet1.Reset(); //this.fpSpread1_Sheet1.AutoSortColumns = ((FarPoint.Win.Spread.SheetView.SaveAutoSortColumns)(resources.GetObject("fpSpread1_Sheet1.AutoSortColumns"))); this.fpSpread1_Sheet1.OperationMode = FarPoint.Win.Spread.OperationMode.SingleSelect; this.fpSpread1_Sheet1.RowHeader.Columns.Default.Resizable = false; this.fpSpread1_Sheet1.SelectionPolicy = FarPoint.Win.Spread.Model.SelectionPolicy.Single; this.fpSpread1_Sheet1.SelectionUnit = FarPoint.Win.Spread.Model.SelectionUnit.Row; this.fpSpread1_Sheet1.SheetName = "Sheet1"; // // frmCardManage // this.ClientSize = new System.Drawing.Size(1016, 741); this.Controls.Add(this.panel2); this.Controls.Add(this.panel1); this.Name = "frmCardManage"; this.Text = "病案卡管理"; this.Load += new System.EventHandler(this.frmCardManage_Load); this.panel1.ResumeLayout(false); this.panel2.ResumeLayout(false); ((System.ComponentModel.ISupportInitialize)(this.fpSpread1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.fpSpread1_Sheet1)).EndInit(); this.ResumeLayout(false); }
protected virtual void SetMoneyed(FarPoint.Win.Spread.SheetView sheet, DataView dv) { dv.RowFilter = "BALANCE_ITEM='6'"; this.SetFarpointValue(sheet, dv); }
/// <summary> /// 增加药品项目 /// </summary> /// <param name="item"></param> /// <param name="parms"></param> public int AddItem(FarPoint.Win.Spread.SheetView sv, int activeRow) { return(1); }
/// <summary> /// 设计器支持所需的方法 - 不要使用代码编辑器修改 /// 此方法的内容。 /// </summary> private void InitializeComponent() { this.components = new System.ComponentModel.Container(); System.Resources.ResourceManager resources = new System.Resources.ResourceManager(typeof(frmQueryPatient)); this.toolBar1 = new System.Windows.Forms.ToolBar(); this.toolBarButton4 = new System.Windows.Forms.ToolBarButton(); this.toolBarButton3 = new System.Windows.Forms.ToolBarButton(); this.toolBarButton1 = new System.Windows.Forms.ToolBarButton(); this.toolBarButton2 = new System.Windows.Forms.ToolBarButton(); this.imageList16 = new System.Windows.Forms.ImageList(this.components); this.panel1 = new System.Windows.Forms.Panel(); this.panel3 = new System.Windows.Forms.Panel(); this.fpSpread1 = new FarPoint.Win.Spread.FpSpread(); this.fpSpread1_Sheet1 = new FarPoint.Win.Spread.SheetView(); this.splitter1 = new System.Windows.Forms.Splitter(); this.panel2 = new System.Windows.Forms.Panel(); this.txtRefer4 = new System.Windows.Forms.ComboBox(); this.lblRefer4 = new System.Windows.Forms.Label(); this.txtRefer3 = new System.Windows.Forms.ComboBox(); this.txtRefer2 = new System.Windows.Forms.ComboBox(); this.txtRefer1 = new System.Windows.Forms.ComboBox(); this.cmbCondition = new System.Windows.Forms.ComboBox(); this.button1 = new System.Windows.Forms.Button(); this.lblRefer1 = new System.Windows.Forms.Label(); this.lblRefer3 = new System.Windows.Forms.Label(); this.lblRefer2 = new System.Windows.Forms.Label(); this.lblRefer1a = new System.Windows.Forms.Label(); this.panel1.SuspendLayout(); this.panel3.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.fpSpread1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.fpSpread1_Sheet1)).BeginInit(); this.panel2.SuspendLayout(); this.SuspendLayout(); // // toolBar1 // this.toolBar1.Appearance = System.Windows.Forms.ToolBarAppearance.Flat; this.toolBar1.Buttons.AddRange(new System.Windows.Forms.ToolBarButton[] { this.toolBarButton4, this.toolBarButton3, this.toolBarButton1, this.toolBarButton2 }); this.toolBar1.DropDownArrows = true; this.toolBar1.ImageList = this.imageList16; this.toolBar1.Location = new System.Drawing.Point(0, 0); this.toolBar1.Name = "toolBar1"; this.toolBar1.ShowToolTips = true; this.toolBar1.Size = new System.Drawing.Size(552, 41); this.toolBar1.TabIndex = 0; this.toolBar1.ButtonClick += new System.Windows.Forms.ToolBarButtonClickEventHandler(this.toolBar1_ButtonClick); // // toolBarButton4 // this.toolBarButton4.Style = System.Windows.Forms.ToolBarButtonStyle.Separator; // // toolBarButton3 // this.toolBarButton3.Style = System.Windows.Forms.ToolBarButtonStyle.Separator; // // toolBarButton1 // this.toolBarButton1.ImageIndex = 4; this.toolBarButton1.Text = "查询"; // // toolBarButton2 // this.toolBarButton2.ImageIndex = 14; this.toolBarButton2.Text = "退出"; // // imageList16 // this.imageList16.ColorDepth = System.Windows.Forms.ColorDepth.Depth32Bit; this.imageList16.ImageSize = new System.Drawing.Size(16, 16); this.imageList16.ImageStream = ((System.Windows.Forms.ImageListStreamer)(resources.GetObject("imageList16.ImageStream"))); this.imageList16.TransparentColor = System.Drawing.Color.Transparent; // // panel1 // this.panel1.Controls.Add(this.panel3); this.panel1.Controls.Add(this.splitter1); this.panel1.Controls.Add(this.panel2); this.panel1.Dock = System.Windows.Forms.DockStyle.Fill; this.panel1.Location = new System.Drawing.Point(0, 41); this.panel1.Name = "panel1"; this.panel1.Size = new System.Drawing.Size(552, 380); this.panel1.TabIndex = 1; // // panel3 // this.panel3.Controls.Add(this.fpSpread1); this.panel3.Dock = System.Windows.Forms.DockStyle.Fill; this.panel3.Location = new System.Drawing.Point(192, 0); this.panel3.Name = "panel3"; this.panel3.Size = new System.Drawing.Size(360, 380); this.panel3.TabIndex = 2; // // fpSpread1 // this.fpSpread1.Dock = System.Windows.Forms.DockStyle.Fill; this.fpSpread1.Location = new System.Drawing.Point(0, 0); this.fpSpread1.Name = "fpSpread1"; this.fpSpread1.Sheets.AddRange(new FarPoint.Win.Spread.SheetView[] { this.fpSpread1_Sheet1 }); this.fpSpread1.Size = new System.Drawing.Size(360, 380); this.fpSpread1.TabIndex = 0; this.fpSpread1.CellDoubleClick += new FarPoint.Win.Spread.CellClickEventHandler(this.fpSpread1_CellDoubleClick); // // fpSpread1_Sheet1 // this.fpSpread1_Sheet1.Reset(); this.fpSpread1_Sheet1.GrayAreaBackColor = System.Drawing.Color.White; this.fpSpread1_Sheet1.SheetName = "Sheet1"; // // splitter1 // this.splitter1.Location = new System.Drawing.Point(184, 0); this.splitter1.Name = "splitter1"; this.splitter1.Size = new System.Drawing.Size(8, 380); this.splitter1.TabIndex = 1; this.splitter1.TabStop = false; // // panel2 // this.panel2.Controls.Add(this.txtRefer4); this.panel2.Controls.Add(this.lblRefer4); this.panel2.Controls.Add(this.txtRefer3); this.panel2.Controls.Add(this.txtRefer2); this.panel2.Controls.Add(this.txtRefer1); this.panel2.Controls.Add(this.cmbCondition); this.panel2.Controls.Add(this.button1); this.panel2.Controls.Add(this.lblRefer1); this.panel2.Controls.Add(this.lblRefer3); this.panel2.Controls.Add(this.lblRefer2); this.panel2.Controls.Add(this.lblRefer1a); this.panel2.Dock = System.Windows.Forms.DockStyle.Left; this.panel2.Location = new System.Drawing.Point(0, 0); this.panel2.Name = "panel2"; this.panel2.Size = new System.Drawing.Size(184, 380); this.panel2.TabIndex = 0; // // txtRefer4 // this.txtRefer4.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Left) | System.Windows.Forms.AnchorStyles.Right))); this.txtRefer4.Location = new System.Drawing.Point(53, 170); this.txtRefer4.Name = "txtRefer4"; this.txtRefer4.Size = new System.Drawing.Size(121, 20); this.txtRefer4.TabIndex = 14; this.txtRefer4.Text = "comboBox4"; // // lblRefer4 // this.lblRefer4.Location = new System.Drawing.Point(4, 175); this.lblRefer4.Name = "lblRefer4"; this.lblRefer4.Size = new System.Drawing.Size(40, 16); this.lblRefer4.TabIndex = 13; this.lblRefer4.Text = "label3"; // // txtRefer3 // this.txtRefer3.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Left) | System.Windows.Forms.AnchorStyles.Right))); this.txtRefer3.Location = new System.Drawing.Point(52, 135); this.txtRefer3.Name = "txtRefer3"; this.txtRefer3.Size = new System.Drawing.Size(121, 20); this.txtRefer3.TabIndex = 12; this.txtRefer3.Text = "comboBox4"; // // txtRefer2 // this.txtRefer2.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Left) | System.Windows.Forms.AnchorStyles.Right))); this.txtRefer2.Location = new System.Drawing.Point(52, 98); this.txtRefer2.Name = "txtRefer2"; this.txtRefer2.Size = new System.Drawing.Size(121, 20); this.txtRefer2.TabIndex = 11; this.txtRefer2.Text = "comboBox3"; // // txtRefer1 // this.txtRefer1.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Left) | System.Windows.Forms.AnchorStyles.Right))); this.txtRefer1.Location = new System.Drawing.Point(52, 61); this.txtRefer1.Name = "txtRefer1"; this.txtRefer1.Size = new System.Drawing.Size(121, 20); this.txtRefer1.TabIndex = 10; this.txtRefer1.Text = "comboBox2"; // // cmbCondition // this.cmbCondition.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Left) | System.Windows.Forms.AnchorStyles.Right))); this.cmbCondition.Location = new System.Drawing.Point(52, 24); this.cmbCondition.Name = "cmbCondition"; this.cmbCondition.Size = new System.Drawing.Size(121, 20); this.cmbCondition.TabIndex = 9; this.cmbCondition.Text = "comboBox1"; this.cmbCondition.SelectedIndexChanged += new System.EventHandler(this.cmbCondition_SelectedIndexChanged); // // button1 // this.button1.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right))); this.button1.Location = new System.Drawing.Point(72, 226); this.button1.Name = "button1"; this.button1.TabIndex = 8; this.button1.Text = "查询"; this.button1.Click += new System.EventHandler(this.btnQuery_Click); // // lblRefer1 // this.lblRefer1.Location = new System.Drawing.Point(3, 64); this.lblRefer1.Name = "lblRefer1"; this.lblRefer1.Size = new System.Drawing.Size(40, 16); this.lblRefer1.TabIndex = 6; this.lblRefer1.Text = "label4"; // // lblRefer3 // this.lblRefer3.Location = new System.Drawing.Point(3, 140); this.lblRefer3.Name = "lblRefer3"; this.lblRefer3.Size = new System.Drawing.Size(40, 16); this.lblRefer3.TabIndex = 4; this.lblRefer3.Text = "label3"; // // lblRefer2 // this.lblRefer2.Location = new System.Drawing.Point(3, 102); this.lblRefer2.Name = "lblRefer2"; this.lblRefer2.Size = new System.Drawing.Size(40, 16); this.lblRefer2.TabIndex = 2; this.lblRefer2.Text = "label2"; // // lblRefer1a // this.lblRefer1a.Location = new System.Drawing.Point(3, 26); this.lblRefer1a.Name = "lblRefer1a"; this.lblRefer1a.Size = new System.Drawing.Size(40, 16); this.lblRefer1a.TabIndex = 0; this.lblRefer1a.Text = "条件"; // // frmQueryPatient // this.AcceptButton = this.button1; this.AutoScaleBaseSize = new System.Drawing.Size(6, 14); this.ClientSize = new System.Drawing.Size(552, 421); this.Controls.Add(this.panel1); this.Controls.Add(this.toolBar1); this.Name = "frmQueryPatient"; this.Text = "患者查询"; this.Load += new System.EventHandler(this.frmQueryPatient_Load); this.panel1.ResumeLayout(false); this.panel3.ResumeLayout(false); ((System.ComponentModel.ISupportInitialize)(this.fpSpread1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.fpSpread1_Sheet1)).EndInit(); this.panel2.ResumeLayout(false); this.ResumeLayout(false); }
////////////////////////////////////////////////////////////////////////// /// <summary> /// 填写表头 /// </summary> /// <param name="obj"></param> /// <param name="Title"></param> public void SetSheet_5Title(Itop.Client.Base.FormBase FB, FarPoint.Win.Spread.SheetView obj, string Title) { int IntColCount = 11; int IntRowCount = 6 + 2 + 3;//标题占3行,分区类型占2行 string title = null; obj.SheetName = Title; obj.Columns.Count = IntColCount; obj.Rows.Count = IntRowCount; IntCol = obj.Columns.Count; PF.Sheet_GridandCenter(obj);//画边线,居中 m_PF.LockSheets(obj); string strTitle = ""; IntRow = 3; strTitle = Title; PF.CreateSheetView(obj, IntRow, IntCol, 0, 0, Title); PF.SetSheetViewColumnsWidth(obj, 0, Title); IntCol = 1; strTitle = "单位:千伏 万千瓦 万千瓦时 % 小时 公里"; obj.AddSpanCell(IntRow, 0, 1, obj.Columns.Count); obj.SetValue(IntRow, 0, strTitle); PF.SetSheetViewColumnsWidth(obj, 0, strTitle); //右对齐 obj.Rows[IntRow].HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Right; //列标题 strTitle = "线路名称"; PF.CreateSheetView(obj, NextRowMerge += 1, NextColMerge, IntRow += 1, IntCol -= 1, strTitle); PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle); for (int i = 0; i < (IntColCount - 1); ++i) { switch (i) { case 0: strTitle = " 电压等级 "; break; case 1: strTitle = " 导线型号 "; break; case 2: strTitle = " 投运年限 "; break; case 3: strTitle = " 线路起讫 "; break; case 4: strTitle = " 线路长度 "; break; case 5: strTitle = " 最大允许输送负荷 "; break; case 6: strTitle = " 最大实际输送负荷 "; break; case 7: strTitle = " 最大实际电量 "; break; case 8: strTitle = " 线路负载率 "; break; case 9: strTitle = " 最大负荷利用小时数 "; break; } PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow, IntCol += 1, strTitle); PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle); } NextRowMerge = 1; NextColMerge = 1; IntRow = 5; IntCol = 0; //PF.SetWholeRowHeight(obj, obj.Rows.Count, obj.Columns.Count);//行高 }
/// <summary> /// 加载查询后的数据 /// </summary> private void LoadData(Itop.Client.Base.FormBase FB, FarPoint.Win.Spread.SheetView obj, int IntRow, string strYear) { string BDZname = null; PSPDEV pv = null; int RowCount = 0; if (list != null) { RowCount = list.Count; } for (int i = 0; i < RowCount; ++i) { pv = (PSPDEV)list[i]; for (int j = 0; j < obj.ColumnCount; ++j) { switch (j) { case 0: //线路名称 obj.SetValue((i + IntRow), j, pv.Name); break; case 1: //电压等级 obj.SetValue((i + IntRow), j, pv.RateVolt); break; case 2: //导线型号 obj.SetValue((i + IntRow), j, pv.LineType); break; case 3: //投运年限 obj.SetValue((i + IntRow), j, pv.OperationYear); break; case 4: //线路起讫 BDZname = SelectXLQQ(FB, pv.IName, pv.JName, strYear); obj.SetValue((i + IntRow), j, BDZname); break; case 5: //线路长度 obj.SetValue((i + IntRow), j, (pv.LineLength + pv.Length2)); break; case 6: //最大允许输送负荷 obj.SetValue((i + IntRow), j, pv.Burthen); break; case 7: //最大实际输送负荷 //obj.SetValue((i + IntRow), j, pv.Burthen); obj.Cells[i + IntRow, j].Locked = false; break; case 8: //最大实际电量 obj.Cells[i + IntRow, j].Locked = false; break; case 9: //线路负载率 obj.Cells[(i + IntRow), j].Formula = "H" + (i + IntRow + 1) + "/G" + (i + IntRow + 1); break; case 10: //最大负荷利用小时数 //obj.Cells[i + IntRow, j].Locked = false; obj.Cells[(i + IntRow), j].Formula = "I" + (i + IntRow + 1) + "/H" + (i + IntRow + 1); break; } } } }
private void barBtnRefrehData_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { WaitDialogForm newwait=new WaitDialogForm("", "正在更新数据, 请稍候..."); //清空原有sheet的数据,但保留sheetname fc.SpreadClearSheet(fpSpread1); //生成一个空表用来保存当前表 FarPoint.Win.Spread.SheetView obj_sheet = null; //生成一个空表,行列值都设为0用来做为程序处理时的当前表,这样可以提高处理速度 FarPoint.Win.Spread.SheetView activesheet = new FarPoint.Win.Spread.SheetView(); activesheet.RowCount = 0; activesheet.ColumnCount = 0; //添加空表 fpSpread1.Sheets.Add(activesheet); //保留当前表,以备程序结束后还原当前表 obj_sheet = fpSpread1.ActiveSheet; //将空表设为当前表 fpSpread1.ActiveSheet = activesheet; shjjbyyear = true; //年增长率法 build_ArverageIncreasing(); //外推法 build_Extrapolation(); //指数平滑 build_ExponentialSmoothing(); //弹性系数 build_CoefficientOfElasticity(); //相关法 build_CorrelationMethod(); //灰色模型 build_GrayModel(); shjjbyyear = false; fpSpread1.Sheets.Remove(activesheet); //移除空表 //还原当前表 fpSpread1.ActiveSheet = obj_sheet; newwait.Close(); MessageBox.Show("更新数据完成!"); }
////////////////////////////////////////////////////////////////////////// /// <summary> /// 填写表头 /// </summary> /// <param name="obj"></param> /// <param name="Title"></param> public void SetSheet4_2_1Title(FarPoint.Win.Spread.SheetView obj, string Title) { AreaType[0] = "市辖供电区"; AreaType[1] = "县级供电区"; int IntColCount = ColumnCount; int IntRowCount = 2 + 3;//标题占3行,分区类型占2行, string title = null; obj.SheetName = Title; obj.Columns.Count = IntColCount; obj.Rows.Count = IntRowCount; IntCol = obj.Columns.Count; PF.Sheet_GridandCenter(obj);//画边线,居中 S10_1.ColReadOnly(obj, IntColCount); //obj.OperationMode = FarPoint.Win.Spread.OperationMode.ReadOnly; string strTitle = ""; IntRow = 3; strTitle = Title; PF.CreateSheetView(obj, IntRow, IntCol, 0, 0, Title); PF.SetSheetViewColumnsWidth(obj, 0, Title); IntCol = 1; strTitle = " 类 型"; PF.CreateSheetView(obj, NextRowMerge += 1, NextColMerge, IntRow, IntCol -= 1, strTitle); PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle); strTitle = " 分区名称"; PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow, IntCol += 1, strTitle); PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle); strTitle = " 2010年"; PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow, IntCol += 1, strTitle); PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle); strTitle = " 2011年 "; PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow, IntCol += 1, strTitle); PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle); strTitle = " 2012年 "; PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow, IntCol += 1, strTitle); PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle); strTitle = " 2013年 "; PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow, IntCol += 1, strTitle); PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle); strTitle = " 2014年 "; PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow, IntCol += 1, strTitle); PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle); strTitle = " 2015年"; PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow, IntCol += 1, strTitle); PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle); strTitle = " “十二五”年均增长率"; PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow, IntCol += 1, strTitle); PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle); strTitle = " 2020年"; PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow, IntCol += 1, strTitle); PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle); strTitle = "“十三五”年均增长率"; PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow, IntCol += 1, strTitle); PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle); NextRowMerge = 1; NextColMerge = 1; IntRow = 5; IntCol = 0; PF.SetWholeRowHeight(obj, obj.Rows.Count, obj.Columns.Count);//行高 }
/// <summary> /// 获得日结实体 /// </summary> private void SetDayBalanceData() { FarPoint.Win.Spread.SheetView sheet = this.ucClinicDayBalanceReportNew1.neuSpread1_Sheet1; string strValue = string.Empty; #region 起止发票号 dayBalance = new Neusoft.Report.Finance.FinOpb.Class.ClinicDayBalanceNew(); dayBalance.InvoiceNO.ID = "A001"; dayBalance.InvoiceNO.Name = "起始结束票据号"; strValue = GetOneCellText(sheet, "A00101"); dayBalance.BegionInvoiceNO = strValue; strValue = GetOneCellText(sheet, "A00102"); dayBalance.EndInvoiceNo = strValue; //设置Cell显示数据的Tag和字段名称 dayBalance.SortID = "A00101|EXTENT_FIELD2、A00102|EXTENT_FIELD3"; dayBalance.TypeStr = "5"; this.SetDayBalance(); #endregion #region 票据总数 strValue = GetOneCellText(sheet, "A002"); this.SetOneCellDayBalance("A002", "票据总数", NConvert.ToDecimal(strValue), "5"); #endregion #region 效票据 strValue = GetOneCellText(sheet, "A003"); this.SetOneCellDayBalance("A003", "有效票据", NConvert.ToDecimal(strValue), "5"); #endregion #region 退费票据 dayBalance = new Neusoft.Report.Finance.FinOpb.Class.ClinicDayBalanceNew(); dayBalance.InvoiceNO.ID = "A004"; dayBalance.InvoiceNO.Name = "退费票据"; //票据数 strValue = this.GetOneCellText(sheet, "A00401"); dayBalance.TotCost = NConvert.ToDecimal(strValue); //票据号 strValue = this.GetOneCellText(sheet, "A00402"); dayBalance.CancelInvoiceNo = strValue; dayBalance.TypeStr = "5"; dayBalance.SortID = "A00401|TOT_COST、A00402|EXTENT_FIELD5"; this.SetDayBalance(); #endregion #region 作废票据 dayBalance = new Neusoft.Report.Finance.FinOpb.Class.ClinicDayBalanceNew(); dayBalance.InvoiceNO.ID = "A005"; dayBalance.InvoiceNO.Name = "作废票据"; strValue = this.GetOneCellText(sheet, "A00501"); dayBalance.TotCost = NConvert.ToDecimal(strValue); strValue = this.GetOneCellText(sheet, "A00502"); dayBalance.FalseInvoiceNo = strValue; dayBalance.TypeStr = "5"; dayBalance.SortID = "A00501|TOT_COST、A00502|EXTENT_FIELD4"; this.SetDayBalance(); #endregion #region 退费金额 strValue = GetOneCellText(sheet, "A006"); this.SetOneCellDayBalance("A006", "退费金额", NConvert.ToDecimal(strValue), "5"); #endregion #region 作废金额 strValue = GetOneCellText(sheet, "A007"); this.SetOneCellDayBalance("A007", "作废金额", NConvert.ToDecimal(strValue), "5"); #endregion #region 暂时无数据 #region 押金金额 strValue = GetOneCellText(sheet, "A008"); this.SetOneCellDayBalance("A008", "押金金额", NConvert.ToDecimal(strValue), "5"); #endregion #region 退押金额 strValue = GetOneCellText(sheet, "A009"); this.SetOneCellDayBalance("A009", "退押金额", NConvert.ToDecimal(strValue), "5"); #endregion #region 减免金额 strValue = GetOneCellText(sheet, "A010"); this.SetOneCellDayBalance("A010", "减免金额", NConvert.ToDecimal(strValue), "5"); #endregion #endregion #region 四舍五入 strValue = GetOneCellText(sheet, "A011"); this.SetOneCellDayBalance("A011", "四舍五入", NConvert.ToDecimal(strValue), "5"); #endregion #region 公费医疗 strValue = this.GetOneCellText(sheet, "A012"); SetOneCellDayBalance("A012", "公费医疗", NConvert.ToDecimal(strValue), "6"); #endregion #region 公费自付 strValue = this.GetOneCellText(sheet, "A013"); SetOneCellDayBalance("A013", "公费自费", NConvert.ToDecimal(strValue), "6"); #endregion #region 公费账户 strValue = this.GetOneCellText(sheet, "A026"); SetOneCellDayBalance("A026", "公费账户", NConvert.ToDecimal(strValue), "6"); #endregion #region 市保自付 strValue = this.GetOneCellText(sheet, "A014"); SetOneCellDayBalance("A014", "市保自费", NConvert.ToDecimal(strValue), "6"); #endregion #region 市保账户 strValue = this.GetOneCellText(sheet, "A015"); SetOneCellDayBalance("A015", "市保账户", NConvert.ToDecimal(strValue), "6"); #endregion #region 市保统筹 strValue = this.GetOneCellText(sheet, "A016"); SetOneCellDayBalance("A016", "市保统筹", NConvert.ToDecimal(strValue), "6"); #endregion #region 市保大额 strValue = this.GetOneCellText(sheet, "A017"); SetOneCellDayBalance("A017", "市保大额", NConvert.ToDecimal(strValue), "6"); #endregion #region 省保自付 strValue = this.GetOneCellText(sheet, "A018"); SetOneCellDayBalance("A018", "省保自费", NConvert.ToDecimal(strValue), "6"); #endregion #region 省保账户 strValue = this.GetOneCellText(sheet, "A019"); SetOneCellDayBalance("A019", "省保账户", NConvert.ToDecimal(strValue), "6"); #endregion #region 省保统筹 strValue = this.GetOneCellText(sheet, "A020"); SetOneCellDayBalance("A020", "省保统筹", NConvert.ToDecimal(strValue), "6"); #endregion #region 省保大额 strValue = this.GetOneCellText(sheet, "A021"); SetOneCellDayBalance("A021", "省保大额", NConvert.ToDecimal(strValue), "6"); #endregion #region 省公务员 strValue = this.GetOneCellText(sheet, "A022"); SetOneCellDayBalance("A022", "省公务员", NConvert.ToDecimal(strValue), "6"); #endregion #region 缴现金额 strValue = this.GetOneCellText(sheet, "A023"); SetOneCellDayBalance("A023", "上缴现金额", NConvert.ToDecimal(strValue), "6"); #endregion #region 缴支票额 strValue = this.GetOneCellText(sheet, "A024"); SetOneCellDayBalance("A024", "上缴支票额", NConvert.ToDecimal(strValue), "6"); #endregion #region 缴银联额 strValue = this.GetOneCellText(sheet, "A025"); SetOneCellDayBalance("A025", "上缴银联额", NConvert.ToDecimal(strValue), "6"); #endregion }
//public string[,,] Amount = null; //private Dictionary<string, int> resualt = new Dictionary<string, int>();//存放地区的集合 ////////////////////////////////////////////////////////////////////////// /// <summary> /// 填写表头 /// </summary> /// <param name="obj"></param> /// <param name="Title"></param> public void SetSheet10_1_1Title(FarPoint.Win.Spread.SheetView obj, string Title) { int IntColCount = 11; int IntRowCount = (ReturnArea() + 2) * VPCount + 2 + 3;//标题占3行,分区类型占2行,+2是有两行合并 //Amount=new string[2,City.Count+County.Count,4];//用来保存变电工程,线路工程的和给Sheet10_4_1附表数据 string title = null; obj.SheetName = Title; obj.Columns.Count = IntColCount; obj.Rows.Count = IntRowCount; IntCol = obj.Columns.Count; PF.Sheet_GridandCenter(obj);//画线,居中 S10_1.ColReadOnly(obj, IntColCount); //obj.OperationMode = FarPoint.Win.Spread.OperationMode.ReadOnly; string strTitle = ""; IntRow = 3; strTitle = Title; PF.CreateSheetView(obj, IntRow, IntCol, 0, 0, Title); PF.SetSheetViewColumnsWidth(obj, 0, Title); IntCol = 1; //加载数据 this.WriteData(obj, IntRow + 2, IntCol - 1, Title); strTitle = " 分区类型 "; PF.CreateSheetView(obj, NextRowMerge += 1, NextColMerge, IntRow, IntCol -= 1, strTitle); PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle); strTitle = " 分区名称"; PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow, IntCol += 1, strTitle); PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle); strTitle = " 电压等级"; PF.CreateSheetView(obj, NextRowMerge -= 1, NextColMerge, IntRow, IntCol += 1, strTitle); PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle); strTitle = " (kV) "; PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow += 1, IntCol, strTitle); PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle); strTitle = " 项 目"; PF.CreateSheetView(obj, NextRowMerge += 1, NextColMerge, IntRow -= 1, IntCol += 1, strTitle); PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle); strTitle = " 2010年"; PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow, IntCol += 1, strTitle); PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle); strTitle = " 2011年 "; PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow, IntCol += 1, strTitle); PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle); strTitle = " 2012年 "; PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow, IntCol += 1, strTitle); PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle); strTitle = " 2013年 "; PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow, IntCol += 1, strTitle); PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle); strTitle = " 2014年 "; PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow, IntCol += 1, strTitle); PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle); strTitle = " 2015年"; PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow, IntCol += 1, strTitle); PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle); strTitle = " “十二五”合计 "; PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow, IntCol += 1, strTitle); PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle); NextRowMerge = 1; NextColMerge = 1; PF.SetWholeRowHeight(obj, obj.Rows.Count, obj.Columns.Count);//行高 }
public void Build_sheet(FarPoint.Win.Spread.SheetView obj_sheet) { //表格共行7 列 string con = " ProjectID='" + ProjectID + "|pro" + "' and ParentID='0'"; //查分类数 IList <Ps_Table_BuildPro> listTypes = Common.Services.BaseService.GetList <Ps_Table_BuildPro>("SelectPs_Table_BuildProByConn", con); //表标题行数 int startrow = 3; rowcount = startrow; colcount = 7; //工作表第一行的标题 //title = CityName+"市高压配电网已开展工程项目列表"; title = TC.GetTableTitle(this.GetType().Name); sheetname = title; int[] TableYearsAry = TC.GetTableYears(this.GetType().Name); //工作表名 //sheetname = CityName + "市高压配电网已开展工程项目列表"; //int[] TableYearsAry = TC.GetTableYears(this.GetType().Name); //设定工作表行列值及标题和表名 TC.Sheet_RowCol_Title_Name(obj_sheet, rowcount, colcount, title, sheetname); //设定表格线 TC.Sheet_GridandCenter(obj_sheet); //设定行列模式,以便写公式使用 TC.Sheet_Referen_R1C1(obj_sheet); //设定表格列宽度 obj_sheet.Columns[0].Width = 60; obj_sheet.Columns[1].Width = 190; obj_sheet.Columns[2].Width = 60; obj_sheet.Columns[3].Width = 60; obj_sheet.Columns[4].Width = 90; obj_sheet.Columns[5].Width = 60; obj_sheet.Columns[6].Width = 60; //设定表格行高度 obj_sheet.Rows[0].Height = 20; obj_sheet.Rows[1].Height = 20; obj_sheet.Rows[2].Height = 20; //写标题行内容 //2行标题内容 obj_sheet.AddSpanCell(1, 0, 2, 1); obj_sheet.SetValue(1, 0, "序号"); obj_sheet.AddSpanCell(1, 1, 2, 1); obj_sheet.SetValue(1, 1, "项目名称"); obj_sheet.AddSpanCell(1, 2, 1, 2); obj_sheet.SetValue(1, 2, "建设规模"); obj_sheet.AddSpanCell(1, 4, 2, 1); obj_sheet.SetValue(1, 4, "所在区(县)"); obj_sheet.AddSpanCell(1, 5, 2, 1); obj_sheet.SetValue(1, 5, "当前进度"); obj_sheet.AddSpanCell(1, 6, 2, 1); obj_sheet.SetValue(1, 6, "投产年份"); //3行标题内容 obj_sheet.SetValue(2, 2, "线路长度"); obj_sheet.SetValue(2, 3, "变电容量"); //添加数据 Sheet_AddData(obj_sheet); TC.Sheet_GridandCenter(obj_sheet); //锁定表格 TC.Sheet_Locked(obj_sheet); }
private void Firstadddata() { //生成表9-1 FarPoint.Win.Spread.SheetView Sheet91 = new FarPoint.Win.Spread.SheetView(); //生成表9-1附表52 FarPoint.Win.Spread.SheetView Sheet91_52 = new FarPoint.Win.Spread.SheetView(); //添加表9-1 fpSpread1.Sheets.Add(Sheet91); //添加表9-1附表52 fpSpread1.Sheets.Add(Sheet91_52); //创建表9-1 sh91.Build(Sheet91,ProjID, SxXjName); //创建表9-1附表52 sh91_52.Build(Sheet91_52, ProjID); fc.Sheet_Colautoenter(fpSpread1); }
private void Firstadddata() { //生成表5-1 FarPoint.Win.Spread.SheetView Sheet51 = new FarPoint.Win.Spread.SheetView(); //生成表5-1附表32 FarPoint.Win.Spread.SheetView Sheet51_32 = new FarPoint.Win.Spread.SheetView(); //生成表5-2 FarPoint.Win.Spread.SheetView Sheet52 = new FarPoint.Win.Spread.SheetView(); //添加表5-1 fpSpread1.Sheets.Add(Sheet51); //添加表5-1附表32 fpSpread1.Sheets.Add(Sheet51_32); //添加5-2 fpSpread1.Sheets.Add(Sheet52); //创建表5-1 sh51.Build(Sheet51,ProjID, SxXjName); //创建表5-1附表32 sh51_32.Build(Sheet51_32, ProjID); //创建表5-2 sh52.Build(Sheet52, ProjID, SxXjName); fc.Sheet_Colautoenter(fpSpread1); }
private void recreatsheetbydt(string title, System.Data.DataTable dt, Dictionary<string, Columqk> viscol, int sheetindex) { FarPoint.Win.Spread.SheetView Sheet1 = new FarPoint.Win.Spread.SheetView(); if (fpSpread1.Sheets.Count-1>=sheetindex) { Sheet1 = fpSpread1.Sheets[sheetindex]; } else { Sheet1.SheetName = title; fpSpread1.Sheets.Add(Sheet1); } if (Sheet1.Rows.Count>0) { Sheet1.RowCount = 0; Sheet1.ColumnCount = 0; } Sheet1.Columns.Count = viscol.Count; Sheet1.Rows.Count = dt.Rows.Count + 1; //设表格线和居中 fc.Sheet_GridandCenter(Sheet1); //设表格模式为R1C1 fc.Sheet_Referen_R1C1(Sheet1); int visrowcount = 0; if (dt.Rows.Count > 0) { foreach (KeyValuePair<string, Columqk> kp in viscol) { for (int j = 0; j < dt.Columns.Count; j++) { if (kp.Key == dt.Columns[j].ColumnName) { Sheet1.SetValue(0, visrowcount, viscol[dt.Columns[j].ColumnName].colname); Sheet1.Columns[visrowcount].Width = 70; if (viscol[dt.Columns[j].ColumnName].CellType == 1) { Sheet1.Columns[visrowcount].CellType = new FarPoint.Win.Spread.CellType.PercentCellType(); } else if (viscol[dt.Columns[j].ColumnName].CellType == 2) { FarPoint.Win.Spread.CellType.NumberCellType newcelltype = new FarPoint.Win.Spread.CellType.NumberCellType(); newcelltype.DecimalPlaces = viscol[dt.Columns[j].ColumnName].weishu; Sheet1.Columns[visrowcount].CellType = newcelltype; } for (int k = 0; k < dt.Rows.Count; k++) { Sheet1.SetValue(k + 1, visrowcount, dt.Rows[k][j].ToString()); } visrowcount++; } } } //for (int i = 0; i < dt.Columns.Count; i++) //{ // if (viscol.ContainsKey(dt.Columns[i].ColumnName)) // { // Sheet1.SetValue(0, visrowcount, viscol[dt.Columns[i].ColumnName].colname); // Sheet1.Columns[visrowcount].Width = 70; // if (viscol[dt.Columns[i].ColumnName].CellType == 1) // { // Sheet1.Columns[visrowcount].CellType = new FarPoint.Win.Spread.CellType.PercentCellType(); // } // else if (viscol[dt.Columns[i].ColumnName].CellType == 2) // { // FarPoint.Win.Spread.CellType.NumberCellType newcelltype = new FarPoint.Win.Spread.CellType.NumberCellType(); // newcelltype.DecimalPlaces = viscol[dt.Columns[i].ColumnName].weishu; // Sheet1.Columns[visrowcount].CellType = newcelltype; // } // for (int j = 0; j < dt.Rows.Count; j++) // { // Sheet1.SetValue(j + 1, visrowcount, dt.Rows[j][i].ToString()); // } // visrowcount++; // } //} Sheet1.Rows[0].CellType = new FarPoint.Win.Spread.CellType.TextCellType(); } //使表格只读 fc.Sheet_Locked(Sheet1); }
/// <summary> /// 设置单元格的类型 /// </summary> /// <param name="obj"></param> /// <param name="ICT"></param> /// <param name="IntRow"></param> /// <param name="IntCol"></param> public void SetCellType(FarPoint.Win.Spread.SheetView obj, FarPoint.Win.Spread.CellType.ICellType ICT, int IntRow, int IntCol) { obj.Cells[IntRow, IntCol].CellType = ICT; }
private void barBtnRefreshData_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { WaitDialogForm newwait = new WaitDialogForm("", "正在更新数据, 请稍候..."); //生成一个空表用来保存当前表 FarPoint.Win.Spread.SheetView obj_sheet = null; //生成一个空表,行列值都设为0用来做为程序处理时的当前表,这样可以提高处理速度 FarPoint.Win.Spread.SheetView activesheet = new FarPoint.Win.Spread.SheetView(); activesheet.RowCount = 0; activesheet.ColumnCount = 0; //添加空表 fpSpread1.Sheets.Add(activesheet); //保留当前表,以备程序结束后还原当前表 obj_sheet = fpSpread1.ActiveSheet; //将空表设为当前表 fpSpread1.ActiveSheet = activesheet; //更新表3-1 sh31.Sheet_AddData(fpSpread1.Sheets[0], year, ProjID, SxXjName); sh31.CellType(fpSpread1.Sheets[0]); //移除空表 fpSpread1.Sheets.Remove(activesheet); //还原当前表 fpSpread1.ActiveSheet = obj_sheet; //设文本自动换行 fc.Sheet_Colautoenter(fpSpread1); newwait.Close(); MessageBox.Show("更新数据完成!"); }
/// <summary> /// 设置sheet_1的年份 /// </summary> /// <param name="obj">对象</param> /// <param name="firstyear">起始年份</param> /// <param name="endyear">结束年份</param> /// <param name="YearsCount">要显示几年的数据</param> /// <param name="IntRow">要写入的起始行数</param> /// <param name="IntCol">要写入的起始列数</param> /// <param name="RowStep">要合并单元格行的数量</param> /// <param name="ColStep">要合并单元格列的数量</param> private void SetYearsSheet2_1(Itop.Client.Base.FormBase FB, FarPoint.Win.Spread.SheetView obj, int firstyear, int endyear, int YearsCount, int IntRow, int IntCol, int RowStep, int ColStep) { GolobalYears = 0; string Title = null; string Title1 = ""; string SingleTitle = "全地区GDP(亿元)"; int TempYear = firstyear; for (int i = IntRow; i < ((YearsCount + IntRow)); i++) { if ((YearsCount + IntRow - 2) == i) { Title = "“十五”年均增长率"; PF.CreateSheetView(obj, RowStep, ColStep, ((i - GolobalYears)), IntCol, Title); //PF.SetRowHight(obj, ((i - GolobalYears)), IntCol, Title); FifteenYears(obj, (i - GolobalYears), IntCol); } else if ((YearsCount + IntRow - 1) == i) { if (TempYear < 2011) //这里写2011要注意 { Title = "2006-2009年均增长率"; ElevenFiveYear(obj, Title, (i - GolobalYears), IntCol); } else { Title = "“十一五”年均增长率"; ElevenFiveYear(obj, Title, (i - GolobalYears), IntCol); } PF.CreateSheetView(obj, RowStep, ColStep, ((i - GolobalYears)), IntCol, Title); PF.SetSheetViewColumnsWidth(obj, IntCol, Title1); //PF.SetRowHight(obj, ((i - GolobalYears)), IntCol, Title); } else { Title = TempYear + " 年"; if (TempYear != 2001 && TempYear != 2002 && TempYear != 2003 && TempYear != 2004) { PF.CreateSheetView(obj, RowStep, ColStep, ((i - GolobalYears)), IntCol, Title); Title1 = "一产"; SingleTitle = "全地区GDP(亿元)"; ViewSheet2_1Data(obj, Title1, FB, TempYear, ((i - GolobalYears)), (IntCol + 1), SingleTitle); SetCellType(obj, PC, (i - GolobalYears), IntCol + 1); //PF.SetRowHight(obj, ((i - GolobalYears)), IntCol+1, Title); Title1 = "二产"; ViewSheet2_1Data(obj, Title1, FB, TempYear, ((i - GolobalYears)), (IntCol + 2), SingleTitle); SetCellType(obj, PC, (i - GolobalYears), IntCol + 2); Title1 = "三产"; ViewSheet2_1Data(obj, Title1, FB, TempYear, ((i - GolobalYears)), (IntCol + 3), SingleTitle); SetCellType(obj, PC, (i - GolobalYears), IntCol + 3); SingleTitle = ""; Title1 = "城镇人口(万人)"; ViewSheet2_1Data(obj, Title1, FB, TempYear, ((i - GolobalYears)), (IntCol + 6), SingleTitle); //PF.SetRowHight(obj, ((i - GolobalYears)), (IntCol + 6), Title1); Title1 = "乡村人口(万人)"; ViewSheet2_1Data(obj, Title1, FB, TempYear, ((i - GolobalYears)), (IntCol + 7), SingleTitle); //PF.SetRowHight(obj, ((i - GolobalYears)), (IntCol + 6), Title1); Title1 = "年末总人口(万人)"; AccountPopulation(obj, TempYear, ((i - GolobalYears)), (IntCol + 4)); //PF.SetRowHight(obj, ((i - GolobalYears)), (IntCol + 6), Title1); Title1 = "人均GDP(万元/人)"; PerCapitaGDP(obj, FB, Title1, TempYear, ((i - GolobalYears)), (IntCol + 5)); //PF.SetRowHight(obj, ((i - GolobalYears)), (IntCol + 6), Title1); Title1 = "城镇化率(%)"; AccountUrbanizationRate(obj, TempYear, ((i - GolobalYears)), (IntCol + 8)); SetCellType(obj, PC, (i - GolobalYears), IntCol + 8); //PF.SetRowHight(obj, ((i - GolobalYears)), (IntCol + 8), Title1); } else { GolobalYears += 1; //年份没有数据的总和 } resualt.Clear(); ++TempYear; } } }
private void barBtnRefrehData_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { WaitDialogForm newwait=new WaitDialogForm("", "正在更新数据, 请稍候..."); //清空原有sheet的数据,但保留sheetname fc.SpreadClearSheet(fpSpread1); //生成一个空表用来保存当前表 FarPoint.Win.Spread.SheetView obj_sheet = null; //生成一个空表,行列值都设为0用来做为程序处理时的当前表,这样可以提高处理速度 FarPoint.Win.Spread.SheetView activesheet = new FarPoint.Win.Spread.SheetView(); activesheet.RowCount = 0; activesheet.ColumnCount = 0; //添加空表 fpSpread1.Sheets.Add(activesheet); //保留当前表,以备程序结束后还原当前表 obj_sheet = fpSpread1.ActiveSheet; //将空表设为当前表 fpSpread1.ActiveSheet = activesheet; build_sheet71(fpSpread1.Sheets[0]); build_Sheet72(fpSpread1.Sheets[1]); build_Sheet72_36(fpSpread1.Sheets[2]); build_Sheet73(fpSpread1.Sheets[3]); build_Sheet73_37(fpSpread1.Sheets[4]); build_Sheet74(fpSpread1.Sheets[5]); build_Sheet74_38(fpSpread1.Sheets[6]); build_Sheet75(fpSpread1.Sheets[7]); build_Sheet75_39(fpSpread1.Sheets[8]); build_Sheet76(fpSpread1.Sheets[9]); build_Sheet76_40(fpSpread1.Sheets[10]); build_Sheet77(fpSpread1.Sheets[11]); build_Sheet78(fpSpread1.Sheets[12]); build_Sheet79(fpSpread1.Sheets[13]); //移除空表 fpSpread1.Sheets.Remove(activesheet); //还原当前表 fpSpread1.ActiveSheet = obj_sheet; newwait.Close(); MessageBox.Show("更新数据完成!"); }
private void Sheet_AddData(FarPoint.Win.Spread.SheetView obj_sheet, string ProjID, IList <string> SXareaid_List, IList <string> XJareaid_List) { int startrow = 3; string tiaojian = ""; string areaname = ""; int xjrow = 0; int nowrow = startrow; for (int i = 0; i < SXareaid_List.Count; i++) { areaname = SXareaid_List[i].ToString(); tiaojian = " AreaID='" + ProjID + "' and (S10='水电' or S10='煤电') and CAST(S1 as int) between 10 and 110 and S3!='' and S5='市辖供电区' and S9='" + areaname + "'"; IList <PSP_PowerSubstation_Info> GDClist = Services.BaseService.GetList <PSP_PowerSubstation_Info>("SelectPSP_PowerSubstation_InfoListByWhere", tiaojian); obj_sheet.AddSpanCell(nowrow, 1, GDClist.Count, 1); obj_sheet.SetValue(nowrow, 1, areaname); for (int j = 0; j < GDClist.Count; j++) { //电厂名称 obj_sheet.SetValue(nowrow, 2, GDClist[j].Title); //电厂类型 obj_sheet.SetValue(nowrow, 3, GDClist[j].S10); //并网电压等级(kV) obj_sheet.SetValue(nowrow, 4, GDClist[j].S1); int year = 0; if (GDClist[j].S3 != "") { year = int.Parse(GDClist[j].S3); } if (year != 0) { if (year <= 2010) { double ZJRL = 0; if (GDClist[j].S2 != "") { ZJRL = double.Parse(GDClist[j].S2); } obj_sheet.SetValue(nowrow, 5, ZJRL); } else if (2016 <= year && year <= 2020) { double ZJRL = 0; if (GDClist[j].S2 != "") { ZJRL = double.Parse(GDClist[j].S2); } obj_sheet.SetValue(nowrow, 11, ZJRL); } else { double ZJRL = 0; if (GDClist[j].S2 != "") { ZJRL = double.Parse(GDClist[j].S2); } obj_sheet.SetValue(nowrow, year - 2005, ZJRL); } } nowrow += 1; } } if (SXareaid_List.Count > 0) { obj_sheet.AddSpanCell(startrow, 0, nowrow - startrow, 1); obj_sheet.SetValue(startrow, 0, "市辖供电区"); } xjrow = nowrow;; for (int i = 0; i < XJareaid_List.Count; i++) { areaname = XJareaid_List[i].ToString(); tiaojian = " AreaID='" + ProjID + "' and (S10='水电' or S10='煤电') and CAST(S1 as int) between 10 and 110 and S3!='' and S5!='市辖供电区' and S9='" + areaname + "'"; IList <PSP_PowerSubstation_Info> GDClist = Services.BaseService.GetList <PSP_PowerSubstation_Info>("SelectPSP_PowerSubstation_InfoListByWhere", tiaojian); obj_sheet.AddSpanCell(nowrow, 1, GDClist.Count, 1); obj_sheet.SetValue(nowrow, 1, areaname); for (int j = 0; j < GDClist.Count; j++) { //电厂名称 obj_sheet.SetValue(nowrow, 2, GDClist[j].Title); //电厂类型 obj_sheet.SetValue(nowrow, 3, GDClist[j].S10); //并网电压等级(kV) obj_sheet.SetValue(nowrow, 4, GDClist[j].S1); int year = 0; if (GDClist[j].S3 != "") { year = int.Parse(GDClist[j].S3); } if (year != 0) { if (year <= 2010) { double ZJRL = 0; if (GDClist[j].S2 != "") { ZJRL = double.Parse(GDClist[j].S2); } obj_sheet.SetValue(nowrow, 5, ZJRL); } else if (2016 <= year && year <= 2020) { double ZJRL = 0; if (GDClist[j].S2 != "") { ZJRL = double.Parse(GDClist[j].S2); } obj_sheet.SetValue(nowrow, 11, ZJRL); } else { double ZJRL = 0; if (GDClist[j].S2 != "") { ZJRL = double.Parse(GDClist[j].S2); } obj_sheet.SetValue(nowrow, year - 2005, ZJRL); } } nowrow += 1; } } if (XJareaid_List.Count > 0) { obj_sheet.AddSpanCell(xjrow, 0, nowrow - xjrow, 1); obj_sheet.SetValue(xjrow, 0, "县级供电区"); } }
private void Sheet_AddData(FarPoint.Win.Spread.SheetView obj_sheet, int year, string ProjID, List <string[]> SxXjName, IList <double> obj_DY_List) { //添加数据 //条件 string GorZ = ""; string tiaojian = ""; int startrow = 3; int dylenth = obj_DY_List.Count; int colcount = 7; for (int i = 0; i < SxXjName.Count; i++) { //合计部分不用计算 if (SxXjName[i][2].ToString() != "合计") { for (int j = 0; j < obj_DY_List.Count; j++) { //一次算公用一次算专用 for (int k = 0; k < 2; k++) { if (k == 0) { GorZ = "公用"; } else { GorZ = "专用"; } //配电室内主变台数 tiaojian = " b.OperationYear!='' and year(cast(b.OperationYear as datetime))<=" + year + " and b.ProjectID='" + ProjID + "' and b.Type='50' and a.LineType2='" + GorZ + "' and a.DQ='" + SxXjName[i][2] + "' and b.RateVolt=" + obj_DY_List[j]; int PDsum = 0; if (Services.BaseService.GetObject("SelectPSPDEV_SUMFlag", tiaojian) != null) { PDsum = (int)Services.BaseService.GetObject("SelectPSPDEV_SUMFlag", tiaojian); } //箱变座数 柱上变(台) tiaojian = " b.OperationYear!='' and year(cast(b.OperationYear as datetime))<=" + year + " and b.ProjectID='" + ProjID + "' and (b.Type='51' or b.Type='52') and a.LineType2='" + GorZ + "' and a.DQ='" + SxXjName[i][2] + "' and b.RateVolt=" + obj_DY_List[j]; int XBsum = 0; if (Services.BaseService.GetObject("SelectPSPDEV_Count_type50-59", tiaojian) != null) { XBsum = (int)Services.BaseService.GetObject("SelectPSPDEV_Count_type50-59", tiaojian); } //配变台数等于这三个数据和 obj_sheet.SetValue(startrow + i * dylenth + j, 3 + k * 2, PDsum + XBsum); //配变容量 tiaojian = " b.OperationYear!='' and year(cast(b.OperationYear as datetime))<=" + year + " and b.ProjectID='" + ProjID + "' and (b.Type='50' or b.Type='51' or b.Type='52') and a.LineType2='" + GorZ + "' and a.DQ='" + SxXjName[i][2] + "' and b.RateVolt=" + obj_DY_List[j]; double PBRLsum = 0; if (Services.BaseService.GetObject("SelectPSPDEV_SUMNum2_type50-59", tiaojian) != null) { PBRLsum = (double)Services.BaseService.GetObject("SelectPSPDEV_SUMNum2_type50-59", tiaojian); } obj_sheet.SetValue(startrow + i * dylenth + j, 4 + k * 2, PBRLsum); } } } else { //县级合计部分公式 if (i == 1) { fc.Sheet_WriteFormula_RowSum(obj_sheet, startrow + (i + 1) * dylenth, 3, 4, dylenth, startrow + i * dylenth, 3, colcount); } //全地区合计部分公式 else { fc.Sheet_WriteFormula_RowSum(obj_sheet, startrow, 3, 2, dylenth, startrow + i * dylenth, 3, colcount); } } } }
/// <summary> /// 设计器支持所需的方法 - 不要使用代码编辑器修改 /// 此方法的内容。 /// </summary> private void InitializeComponent() { this.components = new System.ComponentModel.Container(); FarPoint.Win.Spread.TipAppearance tipAppearance1 = new FarPoint.Win.Spread.TipAppearance(); System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(frmQueryMessage)); this.groupBox1 = new System.Windows.Forms.GroupBox(); this.groupBox3 = new System.Windows.Forms.GroupBox(); this.radioButton2 = new System.Windows.Forms.RadioButton(); this.radioButton1 = new System.Windows.Forms.RadioButton(); this.groupBox2 = new System.Windows.Forms.GroupBox(); this.dateTimePicker2 = new System.Windows.Forms.DateTimePicker(); this.dateTimePicker1 = new System.Windows.Forms.DateTimePicker(); this.label1 = new System.Windows.Forms.Label(); this.label3 = new System.Windows.Forms.Label(); this.comboBox1 = new Neusoft.FrameWork.WinForms.Controls.NeuComboBox(this.components); this.textBox1 = new System.Windows.Forms.TextBox(); this.label4 = new System.Windows.Forms.Label(); this.fpSpread1 = new FarPoint.Win.Spread.FpSpread(); this.fpSpread1_Sheet1 = new FarPoint.Win.Spread.SheetView(); this.toolBar1 = new System.Windows.Forms.ToolBar(); this.toolBarButton1 = new System.Windows.Forms.ToolBarButton(); this.toolBarButton2 = new System.Windows.Forms.ToolBarButton(); this.toolBarButton4 = new System.Windows.Forms.ToolBarButton(); this.toolBarButton3 = new System.Windows.Forms.ToolBarButton(); this.imageList1 = new System.Windows.Forms.ImageList(this.components); this.groupBox1.SuspendLayout(); this.groupBox2.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.fpSpread1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.fpSpread1_Sheet1)).BeginInit(); this.SuspendLayout(); // // groupBox1 // this.groupBox1.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Left) | System.Windows.Forms.AnchorStyles.Right))); this.groupBox1.Controls.Add(this.groupBox3); this.groupBox1.Controls.Add(this.radioButton2); this.groupBox1.Controls.Add(this.radioButton1); this.groupBox1.Controls.Add(this.groupBox2); this.groupBox1.Location = new System.Drawing.Point(8, 40); this.groupBox1.Name = "groupBox1"; this.groupBox1.Size = new System.Drawing.Size(712, 115); this.groupBox1.TabIndex = 0; this.groupBox1.TabStop = false; // // groupBox3 // this.groupBox3.Location = new System.Drawing.Point(363, 18); this.groupBox3.Name = "groupBox3"; this.groupBox3.Size = new System.Drawing.Size(333, 81); this.groupBox3.TabIndex = 10; this.groupBox3.TabStop = false; this.groupBox3.Text = "本人发通知查询"; // // radioButton2 // this.radioButton2.Location = new System.Drawing.Point(347, 22); this.radioButton2.Name = "radioButton2"; this.radioButton2.Size = new System.Drawing.Size(21, 24); this.radioButton2.TabIndex = 9; // // radioButton1 // this.radioButton1.Checked = true; this.radioButton1.Location = new System.Drawing.Point(8, 24); this.radioButton1.Name = "radioButton1"; this.radioButton1.Size = new System.Drawing.Size(13, 20); this.radioButton1.TabIndex = 8; this.radioButton1.TabStop = true; // // groupBox2 // this.groupBox2.Controls.Add(this.dateTimePicker2); this.groupBox2.Controls.Add(this.dateTimePicker1); this.groupBox2.Controls.Add(this.label1); this.groupBox2.Controls.Add(this.label3); this.groupBox2.Controls.Add(this.comboBox1); this.groupBox2.Controls.Add(this.textBox1); this.groupBox2.Location = new System.Drawing.Point(24, 19); this.groupBox2.Name = "groupBox2"; this.groupBox2.Size = new System.Drawing.Size(306, 80); this.groupBox2.TabIndex = 7; this.groupBox2.TabStop = false; this.groupBox2.Text = "科室统计"; // // dateTimePicker2 // this.dateTimePicker2.CustomFormat = "yyyy-MM-dd 23:59:59"; this.dateTimePicker2.Format = System.Windows.Forms.DateTimePickerFormat.Custom; this.dateTimePicker2.Location = new System.Drawing.Point(200, 16); this.dateTimePicker2.Name = "dateTimePicker2"; this.dateTimePicker2.Size = new System.Drawing.Size(90, 21); this.dateTimePicker2.TabIndex = 2; // // dateTimePicker1 // this.dateTimePicker1.CustomFormat = "yyyy-MM-dd 00:00:00"; this.dateTimePicker1.Format = System.Windows.Forms.DateTimePickerFormat.Custom; this.dateTimePicker1.Location = new System.Drawing.Point(88, 16); this.dateTimePicker1.Name = "dateTimePicker1"; this.dateTimePicker1.Size = new System.Drawing.Size(88, 21); this.dateTimePicker1.TabIndex = 1; // // label1 // this.label1.Location = new System.Drawing.Point(8, 24); this.label1.Name = "label1"; this.label1.Size = new System.Drawing.Size(72, 16); this.label1.TabIndex = 0; this.label1.Text = "通知时间:"; // // label3 // this.label3.Location = new System.Drawing.Point(13, 47); this.label3.Name = "label3"; this.label3.Size = new System.Drawing.Size(72, 23); this.label3.TabIndex = 5; this.label3.Text = "接收科室:"; // // comboBox1 // this.comboBox1.ArrowBackColor = System.Drawing.Color.Silver; this.comboBox1.IsEnter2Tab = false; this.comboBox1.IsFlat = false; this.comboBox1.IsLike = true; this.comboBox1.Location = new System.Drawing.Point(94, 43); this.comboBox1.Name = "comboBox1"; this.comboBox1.PopForm = null; this.comboBox1.ShowCustomerList = false; this.comboBox1.ShowID = false; this.comboBox1.Size = new System.Drawing.Size(96, 20); this.comboBox1.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.comboBox1.TabIndex = 4; this.comboBox1.Tag = ""; this.comboBox1.ToolBarUse = false; this.comboBox1.SelectedIndexChanged += new System.EventHandler(this.comboBox1_SelectedIndexChanged); // // textBox1 // this.textBox1.BackColor = System.Drawing.SystemColors.Control; this.textBox1.BorderStyle = System.Windows.Forms.BorderStyle.None; this.textBox1.Font = new System.Drawing.Font("宋体", 15F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.textBox1.Location = new System.Drawing.Point(182, 16); this.textBox1.Name = "textBox1"; this.textBox1.Size = new System.Drawing.Size(20, 23); this.textBox1.TabIndex = 9; this.textBox1.Text = "-"; // // label4 // this.label4.AutoSize = true; this.label4.ForeColor = System.Drawing.Color.Red; this.label4.Location = new System.Drawing.Point(16, 159); this.label4.Name = "label4"; this.label4.Size = new System.Drawing.Size(137, 12); this.label4.TabIndex = 6; this.label4.Text = "粉色代表没有处理的通知"; // // fpSpread1 // this.fpSpread1.About = "2.5.2007.2005"; this.fpSpread1.AccessibleDescription = "fpSpread1"; this.fpSpread1.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) | System.Windows.Forms.AnchorStyles.Left) | System.Windows.Forms.AnchorStyles.Right))); this.fpSpread1.Location = new System.Drawing.Point(8, 176); this.fpSpread1.Name = "fpSpread1"; this.fpSpread1.Sheets.AddRange(new FarPoint.Win.Spread.SheetView[] { this.fpSpread1_Sheet1 }); this.fpSpread1.Size = new System.Drawing.Size(704, 232); this.fpSpread1.TabIndex = 1; tipAppearance1.BackColor = System.Drawing.SystemColors.Info; tipAppearance1.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); tipAppearance1.ForeColor = System.Drawing.SystemColors.InfoText; this.fpSpread1.TextTipAppearance = tipAppearance1; this.fpSpread1.CellDoubleClick += new FarPoint.Win.Spread.CellClickEventHandler(this.fpSpread1_CellDoubleClick); this.fpSpread1_Sheet1.Reset(); this.fpSpread1_Sheet1.SheetName = "Sheet1"; // Formulas and custom names must be loaded with R1C1 reference style this.fpSpread1_Sheet1.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.R1C1; this.fpSpread1_Sheet1.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.A1; // // toolBar1 // this.toolBar1.Appearance = System.Windows.Forms.ToolBarAppearance.Flat; this.toolBar1.Buttons.AddRange(new System.Windows.Forms.ToolBarButton[] { this.toolBarButton1, this.toolBarButton2, this.toolBarButton4, this.toolBarButton3 }); this.toolBar1.DropDownArrows = true; this.toolBar1.ImageList = this.imageList1; this.toolBar1.Location = new System.Drawing.Point(0, 0); this.toolBar1.Name = "toolBar1"; this.toolBar1.ShowToolTips = true; this.toolBar1.Size = new System.Drawing.Size(720, 41); this.toolBar1.TabIndex = 2; this.toolBar1.ButtonClick += new System.Windows.Forms.ToolBarButtonClickEventHandler(this.toolBar1_ButtonClick); // // toolBarButton1 // this.toolBarButton1.ImageIndex = 0; this.toolBarButton1.Name = "toolBarButton1"; this.toolBarButton1.Text = "查询"; // // toolBarButton2 // this.toolBarButton2.ImageIndex = 1; this.toolBarButton2.Name = "toolBarButton2"; this.toolBarButton2.Style = System.Windows.Forms.ToolBarButtonStyle.Separator; // // toolBarButton4 // this.toolBarButton4.ImageIndex = 0; this.toolBarButton4.Name = "toolBarButton4"; this.toolBarButton4.Style = System.Windows.Forms.ToolBarButtonStyle.Separator; // // toolBarButton3 // this.toolBarButton3.ImageIndex = 1; this.toolBarButton3.Name = "toolBarButton3"; this.toolBarButton3.Text = "退出"; // // imageList1 // this.imageList1.ImageStream = ((System.Windows.Forms.ImageListStreamer)(resources.GetObject("imageList1.ImageStream"))); this.imageList1.TransparentColor = System.Drawing.Color.Transparent; this.imageList1.Images.SetKeyName(0, "退出.bmp"); this.imageList1.Images.SetKeyName(1, "查找.bmp"); // // frmQueryMessage // this.AutoScaleBaseSize = new System.Drawing.Size(6, 14); this.BackColor = System.Drawing.Color.White; this.ClientSize = new System.Drawing.Size(720, 422); this.Controls.Add(this.toolBar1); this.Controls.Add(this.fpSpread1); this.Controls.Add(this.groupBox1); this.Controls.Add(this.label4); this.Name = "frmQueryMessage"; this.Text = "查询通知信息"; this.WindowState = System.Windows.Forms.FormWindowState.Maximized; this.Load += new System.EventHandler(this.QueryMessage_Load); this.groupBox1.ResumeLayout(false); this.groupBox2.ResumeLayout(false); this.groupBox2.PerformLayout(); ((System.ComponentModel.ISupportInitialize)(this.fpSpread1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.fpSpread1_Sheet1)).EndInit(); this.ResumeLayout(false); this.PerformLayout(); }
private void Sheet_AddItem(FarPoint.Win.Spread.SheetView obj_sheet, Hashtable area_key_id, IList <double> obj_DY_List, IList <string> SXareaid_List, IList <string> XJareaid_List) { }
////////////////////////////////////////////////////////////////////////// /// <summary> /// 填写表头 /// </summary> /// <param name="obj"></param> /// <param name="Title"></param> public void SetSheet_4Title(Itop.Client.Base.FormBase FB, FarPoint.Win.Spread.SheetView obj, string Title) { SelectPW(FB, strYear); int IntColCount = 9; int IntRowCount = list.Count + 2 + 3;//标题占3行,分区类型占2行,1是其它用 string title = null; obj.SheetName = Title; obj.Columns.Count = IntColCount; obj.Rows.Count = IntRowCount; IntCol = obj.Columns.Count; PF.Sheet_GridandCenter(obj);//画边线,居中 S10_1.ColReadOnly(obj, IntColCount); //obj.OperationMode = FarPoint.Win.Spread.OperationMode.ReadOnly; string strTitle = ""; IntRow = 3; strTitle = Title; PF.CreateSheetView(obj, IntRow, IntCol, 0, 0, Title); PF.SetSheetViewColumnsWidth(obj, 0, Title); IntCol = 1; strTitle = " 序 号"; PF.CreateSheetView(obj, NextRowMerge += 1, NextColMerge, IntRow, IntCol -= 1, strTitle); PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle); strTitle = " 电压等级(kV)s"; PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow, IntCol += 1, strTitle); PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle); strTitle = " 线路名称"; PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow, IntCol += 1, strTitle); PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle); strTitle = " 起点变电站名 "; PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow, IntCol += 1, strTitle); PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle); strTitle = " 终点变电站名 "; PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow, IntCol += 1, strTitle); PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle); strTitle = " 导线型号"; PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow, IntCol += 1, strTitle); PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle); strTitle = " 线路长度(km)"; PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow, IntCol += 1, strTitle); PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle); strTitle = " 投运时间"; PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow, IntCol += 1, strTitle); PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle); strTitle = " 所在分区"; PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow, IntCol += 1, strTitle); PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle); NextRowMerge = 1; NextColMerge = 1; IntRow = 5; IntCol = 0; WriteData(FB, obj, IntRow, IntCol); PF.SetWholeRowHeight(obj, obj.Rows.Count, obj.Columns.Count);//行高 }
/// <summary> /// 写入数据 /// </summary> /// <param name="obj"></param> /// <param name="IntRow"></param> /// <param name="IntCol"></param> private void WriteData(FarPoint.Win.Spread.SheetView obj, int IntRow, int IntCol) { string strTitle = null; string strDQ = null; for (int i = IntRow; i < obj.RowCount; ++i) { strTitle = (string)PF.ReturnStr(obj, i, 0); strDQ = (string)PF.ReturnStr(obj, i, 1); for (int j = 2; j < obj.ColumnCount; ++j) { switch (j) { case 2: if (strTitle == "县级供电区") { obj.SetValue(i, j, SelectData(2010, programID, strDQ, CountyID)); } if (strTitle == "市辖供电区") { obj.SetValue(i, j, SelectData(2010, programID, strDQ, CityID)); } break; case 3: if (strTitle == "县级供电区") { obj.SetValue(i, j, SelectData(2011, programID, strDQ, CountyID)); } if (strTitle == "市辖供电区") { obj.SetValue(i, j, SelectData(2011, programID, strDQ, CityID)); } break; case 4: if (strTitle == "县级供电区") { obj.SetValue(i, j, SelectData(2012, programID, strDQ, CountyID)); } if (strTitle == "市辖供电区") { obj.SetValue(i, j, SelectData(2012, programID, strDQ, CityID)); } break; case 5: if (strTitle == "县级供电区") { obj.SetValue(i, j, SelectData(2013, programID, strDQ, CountyID)); } if (strTitle == "市辖供电区") { obj.SetValue(i, j, SelectData(2013, programID, strDQ, CityID)); } break; case 6: if (strTitle == "县级供电区") { obj.SetValue(i, j, SelectData(2014, programID, strDQ, CountyID)); } if (strTitle == "市辖供电区") { obj.SetValue(i, j, SelectData(2014, programID, strDQ, CityID)); } break; case 7: if (strTitle == "县级供电区") { obj.SetValue(i, j, SelectData(2015, programID, strDQ, CountyID)); } if (strTitle == "市辖供电区") { obj.SetValue(i, j, SelectData(2015, programID, strDQ, CityID)); } break; case 8: obj.Cells[i, j].Formula = "POWER(H" + (i + 1) + " / C" + (i + 1) + ", 1 / 5) - 1"; break; case 9: if (strTitle == "县级供电区") { obj.SetValue(i, j, SelectData(2020, programID, strDQ, CountyID)); } if (strTitle == "市辖供电区") { obj.SetValue(i, j, SelectData(2020, programID, strDQ, CityID)); } break; case 10: obj.Cells[i, j].Formula = "POWER(J" + (i + 1) + " / H" + (i + 1) + ", 1 / 5) - 1"; break; default: break; } } } }
/// <summary> /// 按照起始和结束年份写入列标题 /// </summary> /// <param name="BeginYear"></param> /// <param name="EndYear"></param> public void SetColumnsTitle(Itop.Client.Base.FormBase FB, FarPoint.Win.Spread.SheetView obj, int BeginYear, int EndYear) { int intTemp = BeginYear; Redraw(obj, BeginYear, EndYear); for (int i = BeginYear; i <= (EndYear + list.Count); ++i) { obj.AddSpanCell(4, (i - BeginYear + 1), 2, 1); //if(i!=EndYear+list.Count)//和下面eles对应 //{ obj.SetValue(4, (i - BeginYear + 1), intTemp); if (i == 2006) { obj.SetValue(4, (i - BeginYear + 1), "“十五”年均增速"); intTemp--; } if (i == (2011 + 1))//中间空一行所以加一 { obj.SetValue(4, (i - BeginYear + 1), "“十一五”年均增速"); intTemp--; } if (i == (2016 + 2)) { obj.SetValue(4, (i - BeginYear + 1), "“十二五”年均增速"); intTemp--; } if (i == (2021 + 3)) { obj.SetValue(4, (i - BeginYear + 1), "“十三五”年均增速"); intTemp--; } //} //else//这是预计的列现在先不用 //{ // if (i != 2006 && i != (2011 + 1) && i != (2016 + 2) && i != (2021 + 3)) // { // obj.SetValue(4, (i - BeginYear + 1), intTemp + "预计"); // } // else // { // if (i == 2006) // { // obj.SetValue(4, (i - BeginYear + 1), "“十五”年均增速"); // intTemp--; // } // if (i == (2011 + 1))//中间空一行所以加一 // { // obj.SetValue(4, (i - BeginYear + 1), "“十一五”年均增速"); // intTemp--; // } // if (i == (2016 + 2)) // { // obj.SetValue(4, (i - BeginYear + 1), "“十二五”年均增速"); // intTemp--; // } // if (i == (2021 + 3)) // { // obj.SetValue(4, (i - BeginYear + 1), "“十三五”年均增速"); // intTemp--; // } // } //} intTemp++; } list.Clear(); WriteData(FB, obj); }
/// <summary> /// 写入数据 /// </summary> private void WriteData(FarPoint.Win.Spread.SheetView obj, int IntRow, int IntCol, string Title) { //int CityCount= AreaTitle("市辖供电区"); SA.VoltageClass = new string[VCCount]; for (int i = 0; i < VCCount; ++i) { if (i == 0) { SA.VoltageClass[i] = "110(66)"; } if (i == 1) { SA.VoltageClass[i] = "35"; } if (i == 2) { SA.VoltageClass[i] = "10(6、20)"; } } //MessageBox.Show(obj.RowCount.ToString()); //int CountyCount=AreaTitle("县级供电区"); for (int i = 0; i < 2; ++i) //两个分区类型 { if (i == 0) { PF.CreateSheetView(obj, (SA.CityCount + 1) * VPCount, 1, IntRow + i, IntCol, "市辖供电区"); } else { PF.CreateSheetView(obj, (SA.SumCountyCount + 1) * VPCount, 1, IntRow + i * (SA.CityCount + 1) * VPCount, IntCol, "县级供电区"); } for (int j = 0; j < (SA.CityCount + 1); ++j) //+2是有两个合计,市 { for (int c = 0; c < VCCount; ++c) { PF.CreateSheetView(obj, 2, 1, (IntRow + c * (VCCount - 1)) + j * VPCount, IntCol + 2, SA.VoltageClass[c]); //电压等级 } if (i == 0) { if (j == 0) { PF.CreateSheetView(obj, VPCount, 1, IntRow + j * VPCount, IntCol + 1, "合计"); //分区名称 } else { PF.CreateSheetView(obj, VPCount, 1, IntRow + j * VPCount, IntCol + 1, this.City[j - 1].ToString()); } } } for (int j = 0; j < (SA.SumCountyCount + 1); ++j) //县辖供电区 { for (int c = 0; c < VCCount; ++c) { PF.CreateSheetView(obj, 2, 1, (IntRow + c * (VCCount - 1)) + j * VPCount + (SA.CityCount + 1) * VPCount, IntCol + 2, SA.VoltageClass[c]); //电压等级 } if (j == 0) { PF.CreateSheetView(obj, VPCount, 1, (IntRow + j * VPCount + (SA.CityCount + 1) * VPCount), IntCol + 1, "合计"); } else { PF.CreateSheetView(obj, VPCount, 1, (IntRow + j * VPCount + (SA.CityCount + 1) * VPCount), IntCol + 1, this.County[j - 1].ToString()); } } } int year = 2010; double Amount = 0; string strColTitle = null; string TempDQ = null; //地区 string DQType = null; //地区类型 //写入项目及以后的列 for (int i = 0; i < (SA.SumCountyCount + 1 + (SA.CityCount + 1)); ++i) { for (int j = 0; j < VPCount; ++j) //项目 { year = 2010; for (int col = 4; col < obj.ColumnCount; ++col) //数据 { if (i != 0 && i != SA.CityCount + 1) { switch (j) { case 0: // PF.CreateSheetView(obj, 1, 1, (IntRow + i * VPCount + j), IntCol + 3, "变电工程"); TempDQ = (ReturnNext0fStr(obj, (IntRow + i * VPCount + j), (IntCol + 1), j + 1, 1)); if (i >= 1 + SA.CityCount) //总体行数减去市辖地区的数量就是县级地区 { DQType = ReturnNext0fStr(obj, (IntRow + i * VPCount + j), (IntCol), (i * VPCount + j + 1 - SA.CityCount * VPCount), 1); } else { DQType = ReturnNext0fStr(obj, (IntRow + i * VPCount + j), (IntCol), (i * VPCount + j + 1), 1); } Amount = SelectArea(year, ReturnSql(SA.VoltageClass[0]), DQType, TempDQ, "bian"); obj.SetValue((IntRow + i * VPCount + j), (IntCol + col), Amount); if (col == obj.ColumnCount - 1) //最后一列 { obj.Cells[(IntRow + i * VPCount + j), (IntCol + col)].Formula = "SUM(F" + (IntRow + i * VPCount + j + 1) + ":J" + (IntRow + i * VPCount + j + 1) + ")"; } //MessageBox.Show(ReturnNext0fStr(obj, (IntRow + i * VPCount + j), (IntCol + 1), (j+1), 1)); break; case 1: PF.CreateSheetView(obj, 1, 1, (IntRow + i * VPCount + j), IntCol + 3, "线路工程"); TempDQ = (ReturnNext0fStr(obj, (IntRow + i * VPCount + j), (IntCol + 1), j + 1, 1)); if (i >= 1 + SA.CityCount) //总体行数减去市辖地区的数量就是县级地区 { DQType = ReturnNext0fStr(obj, (IntRow + i * VPCount + j), (IntCol), (i * VPCount + j + 1 - SA.CityCount * VPCount), 1); } else { DQType = ReturnNext0fStr(obj, (IntRow + i * VPCount + j), (IntCol), (i * VPCount + j + 1), 1); } Amount = SelectArea(year, ReturnSql(SA.VoltageClass[0]), DQType, TempDQ, "line"); obj.SetValue((IntRow + i * VPCount + j), (IntCol + col), Amount); if (col == obj.ColumnCount - 1) //最后一列 { obj.Cells[(IntRow + i * VPCount + j), (IntCol + col)].Formula = "SUM(F" + (IntRow + i * VPCount + j + 1) + ":J" + (IntRow + i * VPCount + j + 1) + ")"; } break; case 2: PF.CreateSheetView(obj, 1, 1, (IntRow + i * VPCount + j), IntCol + 3, "变电工程"); TempDQ = (ReturnNext0fStr(obj, (IntRow + i * VPCount + j), (IntCol + 1), j + 1, 1)); if (i >= 1 + SA.CityCount) //总体行数减去市辖地区的数量就是县级地区 { DQType = ReturnNext0fStr(obj, (IntRow + i * VPCount + j), (IntCol), (i * VPCount + j + 1 - SA.CityCount * VPCount), 1); } else { DQType = ReturnNext0fStr(obj, (IntRow + i * VPCount + j), (IntCol), (i * VPCount + j + 1), 1); } Amount = SelectArea(year, ReturnSql(SA.VoltageClass[1]), DQType, TempDQ, "bian"); obj.SetValue((IntRow + i * VPCount + j), (IntCol + col), Amount); if (col == obj.ColumnCount - 1) //最后一列 { obj.Cells[(IntRow + i * VPCount + j), (IntCol + col)].Formula = "SUM(F" + (IntRow + i * VPCount + j + 1) + ":J" + (IntRow + i * VPCount + j + 1) + ")"; } break; case 3: PF.CreateSheetView(obj, 1, 1, (IntRow + i * VPCount + j), IntCol + 3, "线路工程"); TempDQ = (ReturnNext0fStr(obj, (IntRow + i * VPCount + j), (IntCol + 1), j + 1, 1)); if (i >= 1 + SA.CityCount) //总体行数减去市辖地区的数量就是县级地区 { DQType = ReturnNext0fStr(obj, (IntRow + i * VPCount + j), (IntCol), (i * VPCount + j + 1 - SA.CityCount * VPCount), 1); } else { DQType = ReturnNext0fStr(obj, (IntRow + i * VPCount + j), (IntCol), (i * VPCount + j + 1), 1); } Amount = SelectArea(year, ReturnSql(SA.VoltageClass[1]), DQType, TempDQ, "line"); obj.SetValue((IntRow + i * VPCount + j), (IntCol + col), Amount); if (col == obj.ColumnCount - 1) //最后一列 { obj.Cells[(IntRow + i * VPCount + j), (IntCol + col)].Formula = "SUM(F" + (IntRow + i * VPCount + j + 1) + ":J" + (IntRow + i * VPCount + j + 1) + ")"; } break; case 4: PF.CreateSheetView(obj, 1, 1, (IntRow + i * VPCount + j), IntCol + 3, "配变工程"); TempDQ = (ReturnNext0fStr(obj, (IntRow + i * VPCount + j), (IntCol + 1), j + 1, 1)); if (i >= 1 + SA.CityCount) //总体行数减去市辖地区的数量就是县级地区 { DQType = ReturnNext0fStr(obj, (IntRow + i * VPCount + j), (IntCol), (i * VPCount + j + 1 - SA.CityCount * VPCount), 1); } else { DQType = ReturnNext0fStr(obj, (IntRow + i * VPCount + j), (IntCol), (i * VPCount + j + 1), 1); } Amount = SelectArea(year, ReturnSql(SA.VoltageClass[2]), DQType, TempDQ, "pw-pb"); obj.SetValue((IntRow + i * VPCount + j), (IntCol + col), Amount); if (col == obj.ColumnCount - 1) //最后一列 { obj.Cells[(IntRow + i * VPCount + j), (IntCol + col)].Formula = "SUM(F" + (IntRow + i * VPCount + j + 1) + ":J" + (IntRow + i * VPCount + j + 1) + ")"; } break; case 5: PF.CreateSheetView(obj, 1, 1, (IntRow + i * VPCount + j), IntCol + 3, "线路工程"); TempDQ = (ReturnNext0fStr(obj, (IntRow + i * VPCount + j), (IntCol + 1), j + 1, 1)); if (i >= 1 + SA.CityCount) //总体行数减去市辖地区的数量就是县级地区 { DQType = ReturnNext0fStr(obj, (IntRow + i * VPCount + j), (IntCol), (i * VPCount + j + 1 - SA.CityCount * VPCount), 1); } else { DQType = ReturnNext0fStr(obj, (IntRow + i * VPCount + j), (IntCol), (i * VPCount + j + 1), 1); } Amount = SelectArea(year, ReturnSql(SA.VoltageClass[2]), DQType, TempDQ, "pw-line"); obj.SetValue((IntRow + i * VPCount + j), (IntCol + col), Amount); if (col == obj.ColumnCount - 1) //最后一列 { obj.Cells[(IntRow + i * VPCount + j), (IntCol + col)].Formula = "SUM(F" + (IntRow + i * VPCount + j + 1) + ":J" + (IntRow + i * VPCount + j + 1) + ")"; } break; case 6: //手写 PF.CreateSheetView(obj, 1, 1, (IntRow + i * VPCount + j), IntCol + 3, "低压工程"); obj.Cells[(IntRow + i * VPCount + j), (IntCol + col)].Locked = false; //读写 if (col == obj.ColumnCount - 1) //最后一列 { obj.Cells[(IntRow + i * VPCount + j), (IntCol + col)].Locked = true; //读写 obj.Cells[(IntRow + i * VPCount + j), (IntCol + col)].Formula = "SUM(F" + (IntRow + i * VPCount + j + 1) + ":J" + (IntRow + i * VPCount + j + 1) + ")"; } break; case 7: //项目的最后一个项目"分项合计" PF.CreateSheetView(obj, 1, 1, (IntRow + i * VPCount + j), IntCol + 3, "分项合计"); //MessageBox.Show(ReturnNext0fStr(obj, (IntRow + i * VPCount + j), (IntCol + 1), (j + 1), 1)); switch (col) { case 4: strColTitle = "E"; break; case 5: strColTitle = "F"; break; case 6: strColTitle = "G"; break; case 7: strColTitle = "H"; break; case 8: strColTitle = "I"; break; case 9: strColTitle = "J"; break; default: break; } if (col == obj.ColumnCount - 1) //最后一列 { obj.Cells[(IntRow + i * VPCount + j), (IntCol + col)].Formula = "SUM(F" + (IntRow + i * VPCount + j + 1) + ":J" + (IntRow + i * VPCount + j + 1) + ")"; } else { obj.Cells[(IntRow + i * VPCount + j), (IntCol + col)].Formula = "SUM(" + strColTitle + (IntRow + i * VPCount + j - VPCount + 2) + ":" + strColTitle + (IntRow + i * VPCount + j - 1 + 1) + ")"; } break; default: break; } } else { switch (j) { case 0: PF.CreateSheetView(obj, 1, 1, (IntRow + i * VPCount + j), IntCol + 3, "变电工程"); break; case 1: PF.CreateSheetView(obj, 1, 1, (IntRow + i * VPCount + j), IntCol + 3, "线路工程"); break; case 2: PF.CreateSheetView(obj, 1, 1, (IntRow + i * VPCount + j), IntCol + 3, "变电工程"); break; case 3: PF.CreateSheetView(obj, 1, 1, (IntRow + i * VPCount + j), IntCol + 3, "线路工程"); break; case 4: PF.CreateSheetView(obj, 1, 1, (IntRow + i * VPCount + j), IntCol + 3, "配变工程"); break; case 5: PF.CreateSheetView(obj, 1, 1, (IntRow + i * VPCount + j), IntCol + 3, "线路工程"); break; case 6: PF.CreateSheetView(obj, 1, 1, (IntRow + i * VPCount + j), IntCol + 3, "低压工程"); break; case 7: PF.CreateSheetView(obj, 1, 1, (IntRow + i * VPCount + j), IntCol + 3, "分项合计 "); break; default: break; } } year++; } } } //写入合计的数据 string Formula = null; for (int i = 0; i < (1); ++i) //市 CityCount { for (int j = 0; j < VPCount; ++j) //项目 { for (int col = 4; col < obj.ColumnCount; ++col) { switch (col) { case 4: for (int c = 1; c <= SA.CityCount; ++c) { if (c == SA.CityCount) { Formula += "E" + ((IntRow + i * VPCount + j + 1) + c * VPCount); obj.Cells[(IntRow + i * VPCount + j), (IntCol + col)].Formula = Formula; Formula = ""; } else { Formula += "E" + ((IntRow + i * VPCount + j + 1) + c * VPCount) + "+"; } } break; case 5: for (int c = 1; c <= SA.CityCount; ++c) { if (c == SA.CityCount) { Formula += "F" + ((IntRow + i * VPCount + j + 1) + c * VPCount); obj.Cells[(IntRow + i * VPCount + j), (IntCol + col)].Formula = Formula; Formula = ""; } else { Formula += "F" + ((IntRow + i * VPCount + j + 1) + c * VPCount) + "+"; } } break; case 6: for (int c = 1; c <= SA.CityCount; ++c) { if (c == SA.CityCount) { Formula += "G" + ((IntRow + i * VPCount + j + 1) + c * VPCount); obj.Cells[(IntRow + i * VPCount + j), (IntCol + col)].Formula = Formula; Formula = ""; } else { Formula += "G" + ((IntRow + i * VPCount + j + 1) + c * VPCount) + "+"; } } break; case 7: for (int c = 1; c <= SA.CityCount; ++c) { if (c == SA.CityCount) { Formula += "H" + ((IntRow + i * VPCount + j + 1) + c * VPCount); obj.Cells[(IntRow + i * VPCount + j), (IntCol + col)].Formula = Formula; Formula = ""; } else { Formula += "H" + ((IntRow + i * VPCount + j + 1) + c * VPCount) + "+"; } } break; case 8: for (int c = 1; c <= SA.CityCount; ++c) { if (c == SA.CityCount) { Formula += "I" + ((IntRow + i * VPCount + j + 1) + c * VPCount); obj.Cells[(IntRow + i * VPCount + j), (IntCol + col)].Formula = Formula; Formula = ""; } else { Formula += "I" + ((IntRow + i * VPCount + j + 1) + c * VPCount) + "+"; } } break; case 9: for (int c = 1; c <= SA.CityCount; ++c) { if (c == SA.CityCount) { Formula += "J" + ((IntRow + i * VPCount + j + 1) + c * VPCount); obj.Cells[(IntRow + i * VPCount + j), (IntCol + col)].Formula = Formula; Formula = ""; } else { Formula += "J" + ((IntRow + i * VPCount + j + 1) + c * VPCount) + "+"; } } break; case 10: //十二五 obj.Cells[(IntRow + i * VPCount + j), (IntCol + col)].Formula = "SUM(F" + (IntRow + i * VPCount + j + 1) + ":J" + (IntRow + i * VPCount + j + 1) + ")"; break; default: break; } } } } for (int i = 0; i < 1; ++i) //县SA.SumCountyCount { for (int j = 0; j < VPCount; ++j) //项目 { for (int col = 4; col < obj.ColumnCount; ++col) { switch (col) { case 4: for (int c = 1; c <= SA.SumCountyCount; ++c) { if (c == SA.SumCountyCount) { Formula += "E" + ((IntRow + i * VPCount + j + (SA.CityCount + 1) * VPCount + 1) + c * VPCount); obj.Cells[(IntRow + i * VPCount + j + (SA.CityCount + 1) * VPCount), (IntCol + col)].Formula = Formula; Formula = ""; } else { Formula += "E" + ((IntRow + i * VPCount + j + (SA.CityCount + 1) * VPCount + 1) + c * VPCount) + "+"; } } break; case 5: for (int c = 1; c <= SA.SumCountyCount; ++c) { if (c == SA.SumCountyCount) { Formula += "F" + ((IntRow + i * VPCount + j + (SA.CityCount + 1) * VPCount + 1) + c * VPCount); obj.Cells[(IntRow + i * VPCount + j + (SA.CityCount + 1) * VPCount), (IntCol + col)].Formula = Formula; Formula = ""; } else { Formula += "F" + ((IntRow + i * VPCount + j + (SA.CityCount + 1) * VPCount + 1) + c * VPCount) + "+"; } } break; case 6: for (int c = 1; c <= SA.SumCountyCount; ++c) { if (c == SA.SumCountyCount) { Formula += "G" + ((IntRow + i * VPCount + j + (SA.CityCount + 1) * VPCount + 1) + c * VPCount); obj.Cells[(IntRow + i * VPCount + j + (SA.CityCount + 1) * VPCount), (IntCol + col)].Formula = Formula; Formula = ""; } else { Formula += "G" + ((IntRow + i * VPCount + j + (SA.CityCount + 1) * VPCount + 1) + c * VPCount) + "+"; } } break; case 7: for (int c = 1; c <= SA.SumCountyCount; ++c) { if (c == SA.SumCountyCount) { Formula += "H" + ((IntRow + i * VPCount + j + (SA.CityCount + 1) * VPCount + 1) + c * VPCount); obj.Cells[(IntRow + i * VPCount + j + (SA.CityCount + 1) * VPCount), (IntCol + col)].Formula = Formula; Formula = ""; } else { Formula += "H" + ((IntRow + i * VPCount + j + (SA.CityCount + 1) * VPCount + 1) + c * VPCount) + "+"; } } break; case 8: for (int c = 1; c <= SA.SumCountyCount; ++c) { if (c == SA.SumCountyCount) { Formula += "I" + ((IntRow + i * VPCount + j + (SA.CityCount + 1) * VPCount + 1) + c * VPCount); obj.Cells[(IntRow + i * VPCount + j + (SA.CityCount + 1) * VPCount), (IntCol + col)].Formula = Formula; Formula = ""; } else { Formula += "I" + ((IntRow + i * VPCount + j + (SA.CityCount + 1) * VPCount + 1) + c * VPCount) + "+"; } } break; case 9: for (int c = 1; c <= SA.SumCountyCount; ++c) { if (c == SA.SumCountyCount) { Formula += "J" + ((IntRow + i * VPCount + j + (SA.CityCount + 1) * VPCount + 1) + c * VPCount); obj.Cells[(IntRow + i * VPCount + j + (SA.CityCount + 1) * VPCount), (IntCol + col)].Formula = Formula; Formula = ""; } else { Formula += "J" + ((IntRow + i * VPCount + j + (SA.CityCount + 1) * VPCount + 1) + c * VPCount) + "+"; } } break; case 10: //十二五 obj.Cells[(IntRow + i * VPCount + j + (SA.CityCount + 1) * VPCount), (IntCol + col)].Formula = "SUM(F" + (IntRow + i * VPCount + j + (SA.CityCount + 1) * VPCount + 1) + ":J" + (IntRow + i * VPCount + j + (SA.CityCount + 1) * VPCount + 1) + ")"; break; default: break; } } } } }
/// <summary> /// 重绘 /// </summary> /// <param name="obj"></param> private void Redraw(FarPoint.Win.Spread.SheetView obj, int BeginYear, int EndYear) { //list.Clear(); list = AddColumnTitle(BeginYear, EndYear); obj.RowCount = 0; obj.ColumnCount = 0; obj.ColumnCount = 1 + (EndYear - BeginYear + 1) + list.Count; int IntRowCount = 7 + 2 + 3;//标题占3行,分区类型占2行,1是其它用 obj.RowCount = IntRowCount; string strTitle = ""; IntRow = 3; PF.Sheet_GridandCenter(obj);//画边线,居中 strTitle = "附表1 铜陵县" + BeginYear + "~" + EndYear + "年国民生产总值GDP情况表"; PF.CreateSheetView(obj, IntRow, obj.ColumnCount, 0, 0, strTitle); PF.SetSheetViewColumnsWidth(obj, 0, strTitle); IntCol = 1; strTitle = "单位:万元、万人 万元/人"; obj.AddSpanCell(IntRow, 0, 1, obj.Columns.Count); obj.SetValue(IntRow, 0, strTitle); //右对齐 obj.Rows[IntRow].HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Right; strTitle = " 指 标 名 称"; PF.CreateSheetView(obj, NextRowMerge += 1, NextColMerge, IntRow += 1, IntCol -= 1, strTitle); PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle); strTitle = " GDP"; PF.CreateSheetView(obj, NextRowMerge -= 1, NextColMerge, IntRow += 2, IntCol, strTitle); PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle); strTitle = "人均GDP"; PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow += 1, IntCol, strTitle); PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle); strTitle = " 第一产业比重"; PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow += 1, IntCol, strTitle); PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle); strTitle = "第二产业比重"; PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow += 1, IntCol, strTitle); PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle); strTitle = "第三产业比重"; PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow += 1, IntCol, strTitle); PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle); strTitle = " 总 人 口 "; PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow += 1, IntCol, strTitle); PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle); NextRowMerge = 1; NextColMerge = 1; IntRow = 5; IntCol = 0; m_PF.LockSheets(obj); //PF.SetWholeRowHeight(obj, obj.Rows.Count, obj.Columns.Count);//行高 }
private void Firstadddata() { //生成表2242zhu FarPoint.Win.Spread.SheetView sheet2242zhu = new FarPoint.Win.Spread.SheetView(); //生成表Sheet212 FarPoint.Win.Spread.SheetView Sheet212 = new FarPoint.Win.Spread.SheetView(); //添加表2242zhu fpSpread1.Sheets.Add(sheet2242zhu); //添加表Sheet212 fpSpread1.Sheets.Add(Sheet212); //创建表2242zhu OBJ2242zhu.Build_sheet(sheet2242zhu); //创建表Sheet212 OBJ212.Build_Sheet(Sheet212); }
////////////////////////////////////////////////////////////////////////// /// <summary> /// 填写表头 /// </summary> /// <param name="obj"></param> /// <param name="Title"></param> public void SetSheet_1Title(Itop.Client.Base.FormBase FB, FarPoint.Win.Spread.SheetView obj, string Title) { int IntColCount = 5; int IntRowCount = 7 + 2 + 3;//标题占3行,分区类型占2行,1是其它用 string title = null; obj.SheetName = Title; obj.Columns.Count = IntColCount; obj.Rows.Count = IntRowCount; IntCol = obj.Columns.Count; PF.Sheet_GridandCenter(obj);//画边线,居中 m_PF.LockSheets(obj); string strTitle = ""; IntRow = 3; strTitle = Title; PF.CreateSheetView(obj, IntRow, IntCol, 0, 0, Title); PF.SetSheetViewColumnsWidth(obj, 0, Title); IntCol = 1; strTitle = "单位:万元、万人 万元/人"; obj.AddSpanCell(IntRow, 0, 1, obj.Columns.Count); obj.SetValue(IntRow, 0, strTitle); //右对齐 obj.Rows[IntRow].HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Right; strTitle = " 指 标 名 称"; PF.CreateSheetView(obj, NextRowMerge += 1, NextColMerge, IntRow += 1, IntCol -= 1, strTitle); PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle); strTitle = " GDP"; PF.CreateSheetView(obj, NextRowMerge -= 1, NextColMerge, IntRow += 2, IntCol, strTitle); PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle); strTitle = "人均GDP"; PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow += 1, IntCol, strTitle); PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle); strTitle = " 第一产业比重"; PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow += 1, IntCol, strTitle); PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle); strTitle = "第二产业比重"; PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow += 1, IntCol, strTitle); PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle); strTitle = "第三产业比重"; PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow += 1, IntCol, strTitle); PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle); strTitle = " 总 人 口 "; PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow += 1, IntCol, strTitle); PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle); NextRowMerge = 1; NextColMerge = 1; IntRow = 5; IntCol = 0; //PF.SetWholeRowHeight(obj, obj.Rows.Count, obj.Columns.Count);//行高 }
private void barButtonItem1_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { //生成一个空表用来保存当前表 FarPoint.Win.Spread.SheetView obj_sheet = null; //生成一个空表,行列值都设为0用来做为程序处理时的当前表,这样可以提高处理速度 FarPoint.Win.Spread.SheetView activesheet = new FarPoint.Win.Spread.SheetView(); activesheet.RowCount = 0; activesheet.ColumnCount = 0; //添加空表 fpSpread1.Sheets.Add(activesheet); //保留当前表,以备程序结束后还原当前表 obj_sheet = fpSpread1.ActiveSheet; //将空表设为当前表 fpSpread1.ActiveSheet = activesheet; WaitDialogForm newwait = new WaitDialogForm("", "正在更新数据, 请稍候..."); sh91_52.SaveData(fpSpread1.Sheets[1]); fpSpread1.Sheets[1].RowCount = 0; fpSpread1.Sheets[1].ColumnCount = 0; sh91_52.Build(fpSpread1.Sheets[1], ProjID); sh91_52.WriteData(fpSpread1.Sheets[1]); newwait.Close(); //移除空表 fpSpread1.Sheets.Remove(activesheet); //还原当前表 fpSpread1.ActiveSheet = obj_sheet; //设文本自动换行 fc.Sheet_Colautoenter(fpSpread1); MessageBox.Show("更新数据完成!"); }
/// <summary> /// 写入行 /// </summary> ///<param name="IntRow">起始行数</param> ///<param name="IntCol">起始列数</param> ///<param name="obj"></param> ///<param name="Title"></param> private void WriteData(FarPoint.Win.Spread.SheetView obj, int IntRow, int IntCol, string Title) { int year = 2010; int Voltage = 0; string ColTitle = null; int RowRI = 0; //Ps_Table_TZGS BianInfo = null; double SumAmount = 0.000; InitDate(); #region 填写除了县级供电区和全地区合计的数据 for (int j = 0; j < TTCount; ++j) //有7个类型 { PF.CreateSheetView(obj, VPCount, 1, IntRow + j * VPCount, IntCol, Title0[j]); //编号 PF.CreateSheetView(obj, VPCount, 1, IntRow + j * VPCount, IntCol + 1, TitleType[j]); //类型 for (int c = 0; c < VCCount; ++c) { PF.CreateSheetView(obj, 2, 1, (IntRow + c * (VCCount - 1)) + j * VPCount, IntCol + 2, VoltageClass[c]); //电压等级 } for (int i = 0; i < VPCount; ++i) //9个项目 { if (i < VPCount - 3) { PF.CreateSheetView(obj, 1, 1, (IntRow + i) + j * VPCount, IntCol + 3, VoltageProject[i]);//项目 } else { PF.CreateSheetView(obj, 1, 2, (IntRow + i) + j * VPCount, IntCol + 2, VoltageProject[i]);//项目 } //添加数据从数据库读取的数据 //这个循环是从列等于4开始 year = 2010; if (i < 2) { Voltage = 0; } if (i == 2 && i < 4) { Voltage = 1; } if (i == 4 && i < 6) { Voltage = 2; } for (int m = 4; m < obj.ColumnCount; ++m) //column { if (j != 1 && j != TTCount - 1) //不是县级供电区,全地区合计 { switch (i) { case 0: //变电工程 SumAmount = ReturnVoltageClass(VoltageClass[Voltage], year, TitleType1[j], "bian"); obj.SetValue((IntRow + i) + j * VPCount, IntCol + m, SumAmount); if (m == obj.ColumnCount - 1) //最后一列 { obj.Cells[(IntRow + i) + j * VPCount, IntCol + m].Formula = "SUM(F" + ((IntRow + i) + j * VPCount + 1) + ":J" + ((IntRow + i) + j * VPCount + 1) + ")"; } break; case 1: //线路工程 SumAmount = ReturnVoltageClass(VoltageClass[Voltage], year, TitleType1[j], "line"); obj.SetValue((IntRow + i) + j * VPCount, IntCol + m, SumAmount); if (m == obj.ColumnCount - 1) //最后一列 { obj.Cells[(IntRow + i) + j * VPCount, IntCol + m].Formula = "SUM(F" + ((IntRow + i) + j * VPCount + 1) + ":J" + ((IntRow + i) + j * VPCount + 1) + ")"; } break; case 2: //变电工程 SumAmount = ReturnVoltageClass(VoltageClass[Voltage], year, TitleType1[j], "bian"); obj.SetValue((IntRow + i) + j * VPCount, IntCol + m, SumAmount); if (m == obj.ColumnCount - 1) //最后一列 { obj.Cells[(IntRow + i) + j * VPCount, IntCol + m].Formula = "SUM(F" + ((IntRow + i) + j * VPCount + 1) + ":J" + ((IntRow + i) + j * VPCount + 1) + ")"; } break; case 3: //线路工程 SumAmount = ReturnVoltageClass(VoltageClass[Voltage], year, TitleType1[j], "line"); obj.SetValue((IntRow + i) + j * VPCount, IntCol + m, SumAmount); if (m == obj.ColumnCount - 1) //最后一列 { obj.Cells[(IntRow + i) + j * VPCount, IntCol + m].Formula = "SUM(F" + ((IntRow + i) + j * VPCount + 1) + ":J" + ((IntRow + i) + j * VPCount + 1) + ")"; } break; case 4: //配变工程 SumAmount = ReturnVoltageClass(VoltageClass[Voltage], year, TitleType1[j], "pw-pb"); obj.SetValue((IntRow + i) + j * VPCount, IntCol + m, SumAmount); if (m == obj.ColumnCount - 1) //最后一列 { obj.Cells[(IntRow + i) + j * VPCount, IntCol + m].Formula = "SUM(F" + ((IntRow + i) + j * VPCount + 1) + ":J" + ((IntRow + i) + j * VPCount + 1) + ")"; } break; case 5: //线路工程 SumAmount = ReturnVoltageClass(VoltageClass[Voltage], year, TitleType1[j], "pw-line"); obj.SetValue((IntRow + i) + j * VPCount, IntCol + m, SumAmount); if (m == obj.ColumnCount - 1) //最后一列 { obj.Cells[(IntRow + i) + j * VPCount, IntCol + m].Formula = "SUM(F" + ((IntRow + i) + j * VPCount + 1) + ":J" + ((IntRow + i) + j * VPCount + 1) + ")"; } break; case 6: //低压工程 obj.Cells[(IntRow + i) + j * VPCount, IntCol + m].Locked = false; //可写 if (m == obj.ColumnCount - 1) //最后一列 { //obj.Cells[(IntRow + i) + j * VPCount, IntCol + m].Formula = "SUM(F" + ((IntRow + i) + j * VPCount + 1) + ":J" + ((IntRow + i) + j * VPCount + 1) + ")"; RowRI = ((IntRow + i) + j * VPCount + 1); obj.Cells[(IntRow + i) + j * VPCount, IntCol + m].Formula = "F" + RowRI + "+G" + RowRI + "+H" + RowRI + "+I" + RowRI + "+J" + RowRI; obj.Cells[(IntRow + i) + j * VPCount, IntCol + m].Locked = true; //只读 } break; case 7: //其它工程 obj.Cells[(IntRow + i) + j * VPCount, IntCol + m].Locked = false; //可写 if (m == obj.ColumnCount - 1) //最后一列 { //obj.Cells[(IntRow + i) + j * VPCount, IntCol + m].Formula = "SUM(F" + ((IntRow + i) + j * VPCount + 1) + ":J" + ((IntRow + i) + j * VPCount + 1) + ")"; RowRI = ((IntRow + i) + j * VPCount + 1); obj.Cells[(IntRow + i) + j * VPCount, IntCol + m].Formula = "F" + RowRI + "+G" + RowRI + "+H" + RowRI + "+I" + RowRI + "+J" + RowRI; obj.Cells[(IntRow + i) + j * VPCount, IntCol + m].Locked = true; //只读 } break; case 8: //合计 switch (m) { case 4: ColTitle = "E"; break; case 5: ColTitle = "F"; break; case 6: ColTitle = "G"; break; case 7: ColTitle = "H"; break; case 8: ColTitle = "I"; break; case 9: ColTitle = "J"; break; default: break; } if (m == obj.ColumnCount - 1) //最后一列 { obj.Cells[(IntRow + i) + j * VPCount, IntCol + m].Locked = true; //只读 obj.Cells[(IntRow + i) + j * VPCount, IntCol + m].Formula = "SUM(F" + ((IntRow + i) + j * VPCount + 1) + ":J" + ((IntRow + i) + j * VPCount + 1) + ")"; } else { obj.Cells[(IntRow + i) + j * VPCount, IntCol + m].Formula = "SUM(" + ColTitle + ((IntRow + i) + j * VPCount - 7) + ":" + ColTitle + ((IntRow + i) + j * VPCount) + ")"; } break; default: break; } } year += 1; } } } #endregion //因为先计算出县级一下的数据,所以最后写入县级数据,和全地区数据 #region 填写县级供电区和全地区合计的数据 IntRow = 14; IntCol = 0; int RangeRow = 45; //距离要写入的下一行隔着45行 for (int i = 0; i < 2; ++i) //有两个地区最后写数据 { for (int r = 0; r < VPCount; ++r) { for (int j = 4; j < obj.ColumnCount; ++j) { switch (j) { case 4: ColTitle = "E"; if (i == 0) { obj.Cells[IntRow + r + i * RangeRow, IntCol + j].Formula = ColTitle + (IntRow + r + i * RangeRow + VPCount + 1) + "+" + ColTitle + (IntRow + r + i * RangeRow + VPCount * 2 + 1) + "+" + ColTitle + (IntRow + r + i * RangeRow + VPCount * 3 + 1) + "+" + ColTitle + (IntRow + r + i * RangeRow + VPCount * 4 + 1); //隔着45行在写入数据 } if (i == 1) { obj.Cells[IntRow + r + i * RangeRow, IntCol + j].Formula = ColTitle + (IntRow + r + i * RangeRow - VPCount * 6 + 1) + "+" + ColTitle + (IntRow + r + i * RangeRow - VPCount * 5 + 1); } break; case 5: ColTitle = "F"; if (i == 0) { obj.Cells[IntRow + r + i * RangeRow, IntCol + j].Formula = ColTitle + (IntRow + r + i * RangeRow + VPCount + 1) + "+" + ColTitle + (IntRow + r + i * RangeRow + VPCount * 2 + 1) + "+" + ColTitle + (IntRow + r + i * RangeRow + VPCount * 3 + 1) + "+" + ColTitle + (IntRow + r + i * RangeRow + VPCount * 4 + 1); //隔着45行在写入数据 } if (i == 1) { obj.Cells[IntRow + r + i * RangeRow, IntCol + j].Formula = ColTitle + (IntRow + r + i * RangeRow - VPCount * 6 + 1) + "+" + ColTitle + (IntRow + r + i * RangeRow - VPCount * 5 + 1); } break; case 6: ColTitle = "G"; if (i == 0) { obj.Cells[IntRow + r + i * RangeRow, IntCol + j].Formula = ColTitle + (IntRow + r + i * RangeRow + VPCount + 1) + "+" + ColTitle + (IntRow + r + i * RangeRow + VPCount * 2 + 1) + "+" + ColTitle + (IntRow + r + i * RangeRow + VPCount * 3 + 1) + "+" + ColTitle + (IntRow + r + i * RangeRow + VPCount * 4 + 1); //隔着45行在写入数据 } if (i == 1) { obj.Cells[IntRow + r + i * RangeRow, IntCol + j].Formula = ColTitle + (IntRow + r + i * RangeRow - VPCount * 6 + 1) + "+" + ColTitle + (IntRow + r + i * RangeRow - VPCount * 5 + 1); } break; case 7: ColTitle = "H"; if (i == 0) { obj.Cells[IntRow + r + i * RangeRow, IntCol + j].Formula = ColTitle + (IntRow + r + i * RangeRow + VPCount + 1) + "+" + ColTitle + (IntRow + r + i * RangeRow + VPCount * 2 + 1) + "+" + ColTitle + (IntRow + r + i * RangeRow + VPCount * 3 + 1) + "+" + ColTitle + (IntRow + r + i * RangeRow + VPCount * 4 + 1); //隔着45行在写入数据 } if (i == 1) { obj.Cells[IntRow + r + i * RangeRow, IntCol + j].Formula = ColTitle + (IntRow + r + i * RangeRow - VPCount * 6 + 1) + "+" + ColTitle + (IntRow + r + i * RangeRow - VPCount * 5 + 1); } break; case 8: ColTitle = "I"; if (i == 0) { obj.Cells[IntRow + r + i * RangeRow, IntCol + j].Formula = ColTitle + (IntRow + r + i * RangeRow + VPCount + 1) + "+" + ColTitle + (IntRow + r + i * RangeRow + VPCount * 2 + 1) + "+" + ColTitle + (IntRow + r + i * RangeRow + VPCount * 3 + 1) + "+" + ColTitle + (IntRow + r + i * RangeRow + VPCount * 4 + 1); //隔着45行在写入数据 } if (i == 1) { obj.Cells[IntRow + r + i * RangeRow, IntCol + j].Formula = ColTitle + (IntRow + r + i * RangeRow - VPCount * 6 + 1) + "+" + ColTitle + (IntRow + r + i * RangeRow - VPCount * 5 + 1); } break; case 9: ColTitle = "J"; if (i == 0) { obj.Cells[IntRow + r + i * RangeRow, IntCol + j].Formula = ColTitle + (IntRow + r + i * RangeRow + VPCount + 1) + "+" + ColTitle + (IntRow + r + i * RangeRow + VPCount * 2 + 1) + "+" + ColTitle + (IntRow + r + i * RangeRow + VPCount * 3 + 1) + "+" + ColTitle + (IntRow + r + i * RangeRow + VPCount * 4 + 1); //隔着45行在写入数据 } if (i == 1) { obj.Cells[IntRow + r + i * RangeRow, IntCol + j].Formula = ColTitle + (IntRow + r + i * RangeRow - VPCount * 6 + 1) + "+" + ColTitle + (IntRow + r + i * RangeRow - VPCount * 5 + 1); } break; case 10: //最后一列 RowRI = (IntRow + r + i * RangeRow + 1); obj.Cells[IntRow + r + i * RangeRow, IntCol + j].Formula = "F" + RowRI + "+G" + RowRI + "+H" + RowRI + "+I" + RowRI + "+J" + RowRI; break; default: break; } } } #endregion } }
private void barBtnRefrehData_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { WaitDialogForm newwait=new WaitDialogForm("", "正在更新数据, 请稍候..."); //清空原有sheet的数据,但保留sheetname fc.SpreadClearSheet(fpSpread1); //生成一个空表用来保存当前表 FarPoint.Win.Spread.SheetView obj_sheet = null; //生成一个空表,行列值都设为0用来做为程序处理时的当前表,这样可以提高处理速度 FarPoint.Win.Spread.SheetView activesheet = new FarPoint.Win.Spread.SheetView(); activesheet.RowCount = 0; activesheet.ColumnCount = 0; //添加空表 fpSpread1.Sheets.Add(activesheet); //保留当前表,以备程序结束后还原当前表 obj_sheet = fpSpread1.ActiveSheet; //将空表设为当前表 fpSpread1.ActiveSheet = activesheet; shjjbyyear = true; //形成基础数据电力发展实绩历年地区生产 build_dlhistoryGDP(); //电力发展实绩分行业统计 build_dlhistoryfhy(); //电力发展实绩社会经济用电情况 build_dlhistoryjjyd(); //分区县供电实绩 build_fqxgdsj(); //分区县用电情况 //全市拟建主要工业项目及用电需求情况表 build_njxmandydl(); //重点建设工业及用电需求表 build_zdjsxm(); //典型日最大负荷 build_dxfh(); //月最大负荷数据 build_monthmax(); //年最大负荷数据 build_YearMAX(); //变电站情况表 build_bdzqk(); //输电线路情况表 build_lineqk(); shjjbyyear = false; fpSpread1.Sheets.Remove(activesheet); //移除空表 //还原当前表 fpSpread1.ActiveSheet = obj_sheet; newwait.Close(); MessageBox.Show("更新数据完成!"); }
/// <summary> /// 加载10_1表头 /// </summary> /// <param name="obj"></param> /// <param name="Title"></param> public void SetSheet10_1Title(FarPoint.Win.Spread.SheetView obj, string Title) { int IntColCount = 11; int IntRowCount = 64 + 1 + 3;//标题占3行,类型占1行, string title = null; obj.SheetName = Title; obj.Columns.Count = IntColCount; obj.Rows.Count = IntRowCount; IntCol = obj.Columns.Count; PF.Sheet_GridandCenter(obj);//画线,居中 ColReadOnly(obj, IntColCount); //obj.OperationMode = FarPoint.Win.Spread.OperationMode.ReadOnly; string strTitle = ""; IntRow = 3; strTitle = Title; PF.CreateSheetView(obj, IntRow, IntCol, 0, 0, Title); PF.SetSheetViewColumnsWidth(obj, 0, Title); IntCol = 1; //加载数据 WriteData(obj, IntRow + 2, IntCol - 1, Title); strTitle = " 编 号 "; PF.CreateSheetView(obj, NextRowMerge += 1, NextColMerge, IntRow, IntCol -= 1, strTitle); PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle); strTitle = " 类 型 "; PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow, IntCol += 1, strTitle); PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle); strTitle = " 电压等级 "; PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow, IntCol += 1, strTitle); PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle); strTitle = " 项 目"; PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow, IntCol += 1, strTitle); PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle); strTitle = " 2010年"; PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow, IntCol += 1, strTitle); PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle); strTitle = " 2011年 "; PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow, IntCol += 1, strTitle); PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle); strTitle = " 2012年 "; PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow, IntCol += 1, strTitle); PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle); strTitle = " 2013年 "; PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow, IntCol += 1, strTitle); PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle); strTitle = " 2014年 "; PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow, IntCol += 1, strTitle); PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle); strTitle = " 2015年"; PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow, IntCol += 1, strTitle); PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle); strTitle = " “十二五”合计 "; PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow, IntCol += 1, strTitle); PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle); NextRowMerge = 1; NextColMerge = 1; PF.SetWholeRowHeight(obj, obj.Rows.Count, obj.Columns.Count);//行高 }
private void barBtnRefrehData_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { WaitDialogForm newwait=new WaitDialogForm("", "正在更新数据, 请稍候..."); //清空原有sheet的数据,但保留sheetname fc.SpreadClearSheet(fpSpread1); //生成一个空表用来保存当前表 FarPoint.Win.Spread.SheetView obj_sheet = null; //生成一个空表,行列值都设为0用来做为程序处理时的当前表,这样可以提高处理速度 FarPoint.Win.Spread.SheetView activesheet = new FarPoint.Win.Spread.SheetView(); activesheet.RowCount = 0; activesheet.ColumnCount = 0; //添加空表 fpSpread1.Sheets.Add(activesheet); //保留当前表,以备程序结束后还原当前表 obj_sheet = fpSpread1.ActiveSheet; //将空表设为当前表 fpSpread1.ActiveSheet = activesheet; shjjbyyear = true; //500千伏分区分年电容量计算表 build_500rltj(); //500千伏分区分年容载比计算表 build_500rzbtj(); shjjbyyear = false; fpSpread1.Sheets.Remove(activesheet); //移除空表 //还原当前表 fpSpread1.ActiveSheet = obj_sheet; newwait.Close(); MessageBox.Show("更新数据完成!"); }
public void Sheet_AddData(FarPoint.Win.Spread.SheetView obj_sheet, int year, string ProjID) { //将类型存入数组,便于读取 string[] dq = { "市辖供电区", "县级直供直管", "县级控股", "县级参股", "县级代管" }; //存放读出的类型 string dqstr = ""; //存电压条件 string dianya = ""; //存放查询条件 string BDtiaojian = ""; //存放公用还是专用 string GorZ = ""; //数组下标 int index = 0; for (int row = 3; row < 15; row++) { //跳过县级合并部分 if (row == 5) { row = row + 2; } //使行数与类型的数组标识对应起来 if (row < 5) { index = (row - 3) / 2; } else { index = (row - 5) / 2; } dqstr = dq[index]; if (row % 2 == 0) { dianya = " and L1=35 "; } else { dianya = " and (L1=110 or L1=66) "; } //计算公用变电站座数 GorZ = "公用"; BDtiaojian = " S2!='' and Cast(substring(S2,1,4) as int)<=" + year + " and AreaID='" + ProjID + "' and DQ='" + dqstr + "' and S4='" + GorZ + "' " + dianya; int GBDsum = (int)Services.BaseService.GetObject("SelectPSP_Substation_InfoCountall", BDtiaojian); obj_sheet.SetValue(row, 3, GBDsum); //计算专用变电站座数 GorZ = "专用"; BDtiaojian = " S2!='' and Cast(substring(S2,1,4) as int)<=" + year + " and AreaID='" + ProjID + "' and DQ='" + dqstr + "' and S4='" + GorZ + "' " + dianya; int ZBDsum = (int)Services.BaseService.GetObject("SelectPSP_Substation_InfoCountall", BDtiaojian); obj_sheet.SetValue(row, 5, ZBDsum); //计算公用主变台数(台) GorZ = "公用"; BDtiaojian = " S2!='' and Cast(substring(S2,1,4) as int)<=" + year + " and AreaID='" + ProjID + "' and DQ='" + dqstr + "' and S4='" + GorZ + "' " + dianya; int GZBsum = 0; if (Services.BaseService.GetObject("SelectPSP_Substation_InfoSUML3", BDtiaojian) != null) { GZBsum = (int)Services.BaseService.GetObject("SelectPSP_Substation_InfoSUML3", BDtiaojian); } obj_sheet.SetValue(row, 6, GZBsum); //计算专用主变台数(台) GorZ = "专用"; BDtiaojian = " S2!='' and Cast(substring(S2,1,4) as int)<=" + year + " and AreaID='" + ProjID + "' and DQ='" + dqstr + "' and S4='" + GorZ + "' " + dianya; int ZZBsum = 0; if (Services.BaseService.GetObject("SelectPSP_Substation_InfoSUML3", BDtiaojian) != null) { ZZBsum = (int)Services.BaseService.GetObject("SelectPSP_Substation_InfoSUML3", BDtiaojian); } obj_sheet.SetValue(row, 8, ZZBsum); //计算公用变电容量 GorZ = "公用"; BDtiaojian = " S2!='' and Cast(substring(S2,1,4) as int)<=" + year + " and AreaID='" + ProjID + "' and DQ='" + dqstr + "' and S4='" + GorZ + "' " + dianya; double GBDRLsum = 0; if (Services.BaseService.GetObject("SelectPSP_Substation_InfoSUML2", BDtiaojian) != null) { GBDRLsum = (double)Services.BaseService.GetObject("SelectPSP_Substation_InfoSUML2", BDtiaojian); } obj_sheet.SetValue(row, 9, GBDRLsum); //计算专用变电容量 GorZ = "专用"; BDtiaojian = " S2!='' and Cast(substring(S2,1,4) as int)<=" + year + " and AreaID='" + ProjID + "' and DQ='" + dqstr + "' and S4='" + GorZ + "' " + dianya; double ZBDRLsum = 0; if (Services.BaseService.GetObject("SelectPSP_Substation_InfoSUML2", BDtiaojian) != null) { ZBDRLsum = (double)Services.BaseService.GetObject("SelectPSP_Substation_InfoSUML2", BDtiaojian); } obj_sheet.SetValue(row, 10, ZBDRLsum); //计算公用10(20)kV出线间隔总数(回) //GorZ = "公用"; //BDtiaojian = " S2!='' and L13!='' and Cast(substring(S2,1,4) as int)<=" + year + " and AreaID='" + ProjID + "' and DQ='" + dqstr + "' and S4='" + GorZ + "' " + dianya; //int GCXJGsum = 0; //if (Services.BaseService.GetObject("SelectPSP_Substation_InfoSUML13", BDtiaojian) != null) //{ // GCXJGsum = (int)Services.BaseService.GetObject("SelectPSP_Substation_InfoSUML13", BDtiaojian); //} //obj_sheet.SetValue(row, 11, GCXJGsum); //计算公用10(20)已出线间隔总数(回) //BDtiaojian = " S2!='' and L14!='' and Cast(substring(S2,1,4) as int)<=" + year + " and AreaID='" + ProjID + "' and DQ='" + dqstr + "' and S4='" + GorZ + "' " + dianya; //int GYCXJGsum = 0; //if (Services.BaseService.GetObject("SelectPSP_Substation_InfoSUML14", BDtiaojian) != null) //{ // GYCXJGsum = (int)Services.BaseService.GetObject("SelectPSP_Substation_InfoSUML14", BDtiaojian); //} //obj_sheet.SetValue(row, 12, GYCXJGsum); //计算公用无功补偿容量(Mvar) BDtiaojian = " S2!='' and L5!='' and Cast(substring(S2,1,4) as int)<=" + year + " and AreaID='" + ProjID + "' and DQ='" + dqstr + "' and S4='" + GorZ + "' " + dianya; double GWGBCsum = 0; if (Services.BaseService.GetObject("SelectPSP_Substation_InfoSUML5", BDtiaojian) != null) { GWGBCsum = (double)Services.BaseService.GetObject("SelectPSP_Substation_InfoSUML5", BDtiaojian); } obj_sheet.SetValue(row, 13, GWGBCsum); } }
private void Firstadddata() { //生成表 //FarPoint.Win.Spread.SheetView sheet2251 = new FarPoint.Win.Spread.SheetView(); //FarPoint.Win.Spread.SheetView sheet2253 = new FarPoint.Win.Spread.SheetView(); FarPoint.Win.Spread.SheetView sheet2255 = new FarPoint.Win.Spread.SheetView(); //添加表 //fpSpread1.Sheets.Add(sheet2251); //fpSpread1.Sheets.Add(sheet2253); fpSpread1.Sheets.Add(sheet2255); //创建表 //OBJ2251.Build_Sheet(sheet2251); //OBJ2253.Build_Sheet(sheet2253); OBJ2255.Build_Sheet(sheet2255); }
private void Sheet_AddItem(FarPoint.Win.Spread.SheetView obj_sheet) { //写标题行内容 //2行标题内容 obj_sheet.AddSpanCell(1, 0, 2, 1); obj_sheet.SetValue(1, 0, "编号"); obj_sheet.AddSpanCell(1, 1, 2, 1); obj_sheet.SetValue(1, 1, "类型"); obj_sheet.AddSpanCell(1, 2, 2, 1); obj_sheet.SetValue(1, 2, "电压等级(kV)"); obj_sheet.AddSpanCell(1, 3, 1, 3); obj_sheet.SetValue(1, 3, "变电站座数(座)"); obj_sheet.AddSpanCell(1, 6, 1, 3); obj_sheet.SetValue(1, 6, "主变台数(台)"); obj_sheet.AddSpanCell(1, 9, 1, 2); obj_sheet.SetValue(1, 9, "变电容量(MVA)"); obj_sheet.SetValue(1, 11, "10(20)kV出线间隔总数(回)"); obj_sheet.SetValue(1, 12, "10(20)已出线间隔总数(回)"); obj_sheet.SetValue(1, 13, "无功补偿容量(Mvar)"); obj_sheet.SetValue(1, 14, "10kV平均供电半径(km)"); //3行标题内容 obj_sheet.SetValue(2, 3, "公用"); obj_sheet.SetValue(2, 4, "其中:单线单变座数"); obj_sheet.SetValue(2, 5, "专用"); obj_sheet.SetValue(2, 6, "公用"); obj_sheet.SetValue(2, 7, "其中:有载调压主变"); obj_sheet.SetValue(2, 8, "专用"); obj_sheet.SetValue(2, 9, "公用"); obj_sheet.SetValue(2, 10, "专用"); obj_sheet.SetValue(2, 11, "公用"); obj_sheet.SetValue(2, 12, "公用"); obj_sheet.SetValue(2, 13, "公用"); obj_sheet.SetValue(2, 14, "公用"); //写标题列内容 //1列标题内容 obj_sheet.AddSpanCell(3, 0, 2, 1); obj_sheet.SetValue(3, 0, "1"); obj_sheet.AddSpanCell(5, 0, 2, 1); obj_sheet.SetValue(5, 0, "2"); obj_sheet.AddSpanCell(7, 0, 2, 1); obj_sheet.SetValue(7, 0, "2.1"); obj_sheet.AddSpanCell(9, 0, 2, 1); obj_sheet.SetValue(9, 0, "2.2"); obj_sheet.AddSpanCell(11, 0, 2, 1); obj_sheet.SetValue(11, 0, "2.3"); obj_sheet.AddSpanCell(13, 0, 2, 1); obj_sheet.SetValue(13, 0, "2.4"); obj_sheet.AddSpanCell(15, 0, 2, 1); obj_sheet.SetValue(15, 0, "3"); //2列标题内容 obj_sheet.AddSpanCell(3, 1, 2, 1); obj_sheet.SetValue(3, 1, "市辖供电区"); obj_sheet.AddSpanCell(5, 1, 2, 1); obj_sheet.SetValue(5, 1, "县级供电区"); obj_sheet.AddSpanCell(7, 1, 2, 1); obj_sheet.SetValue(7, 1, "其中:直供直管"); obj_sheet.AddSpanCell(9, 1, 2, 1); obj_sheet.SetValue(9, 1, "控股"); obj_sheet.AddSpanCell(11, 1, 2, 1); obj_sheet.SetValue(11, 1, "参股"); obj_sheet.AddSpanCell(13, 1, 2, 1); obj_sheet.SetValue(13, 1, "代管"); obj_sheet.AddSpanCell(15, 1, 2, 1); obj_sheet.SetValue(15, 1, "全地区"); //3列标题内容 obj_sheet.SetValue(3, 2, "110(66)"); obj_sheet.SetValue(4, 2, "35"); obj_sheet.SetValue(5, 2, "110(66)"); obj_sheet.SetValue(6, 2, "35"); obj_sheet.SetValue(7, 2, "110(66)"); obj_sheet.SetValue(8, 2, "35"); obj_sheet.SetValue(9, 2, "110(66)"); obj_sheet.SetValue(10, 2, "35"); obj_sheet.SetValue(11, 2, "110(66)"); obj_sheet.SetValue(12, 2, "35"); obj_sheet.SetValue(13, 2, "110(66)"); obj_sheet.SetValue(14, 2, "35"); obj_sheet.SetValue(15, 2, "110(66)"); obj_sheet.SetValue(16, 2, "35"); }
private void Firstadddata() { //生成表3-1 FarPoint.Win.Spread.SheetView Sheet31 = new FarPoint.Win.Spread.SheetView(); //生成表3-2 FarPoint.Win.Spread.SheetView Sheet32 = new FarPoint.Win.Spread.SheetView(); //生成表3-3 FarPoint.Win.Spread.SheetView Sheet33 = new FarPoint.Win.Spread.SheetView(); //生成表3-3附表1 FarPoint.Win.Spread.SheetView Sheet33_1 = new FarPoint.Win.Spread.SheetView(); //生成表3-4 FarPoint.Win.Spread.SheetView Sheet34 = new FarPoint.Win.Spread.SheetView(); //生成表3-4附表2 FarPoint.Win.Spread.SheetView Sheet34_2 = new FarPoint.Win.Spread.SheetView(); //生成表3-5 FarPoint.Win.Spread.SheetView Sheet35 = new FarPoint.Win.Spread.SheetView(); //生成表3-6 FarPoint.Win.Spread.SheetView Sheet36 = new FarPoint.Win.Spread.SheetView(); //生成表3-7 FarPoint.Win.Spread.SheetView Sheet37 = new FarPoint.Win.Spread.SheetView(); //生成表3-7附表3 FarPoint.Win.Spread.SheetView Sheet37_3 = new FarPoint.Win.Spread.SheetView(); //生成表3-8 FarPoint.Win.Spread.SheetView Sheet38 = new FarPoint.Win.Spread.SheetView(); //生成表3-8附表8 FarPoint.Win.Spread.SheetView Sheet38_8 = new FarPoint.Win.Spread.SheetView(); //生成表3-9 FarPoint.Win.Spread.SheetView Sheet39 = new FarPoint.Win.Spread.SheetView(); //生成表3-9附表6 FarPoint.Win.Spread.SheetView Sheet39_6 = new FarPoint.Win.Spread.SheetView(); //生成表3-10 FarPoint.Win.Spread.SheetView Sheet310 = new FarPoint.Win.Spread.SheetView(); //生成表3-10附表5 FarPoint.Win.Spread.SheetView Sheet310_5 = new FarPoint.Win.Spread.SheetView(); //生成表3-11 FarPoint.Win.Spread.SheetView Sheet311 = new FarPoint.Win.Spread.SheetView(); //生成表3-11附表9 FarPoint.Win.Spread.SheetView Sheet311_9 = new FarPoint.Win.Spread.SheetView(); //生成表3-12 FarPoint.Win.Spread.SheetView Sheet312 = new FarPoint.Win.Spread.SheetView(); //生成表3-12附表10 FarPoint.Win.Spread.SheetView Sheet312_10 = new FarPoint.Win.Spread.SheetView(); //生成表3-13 FarPoint.Win.Spread.SheetView Sheet313 = new FarPoint.Win.Spread.SheetView(); //生成表3-13附表11 FarPoint.Win.Spread.SheetView Sheet313_11 = new FarPoint.Win.Spread.SheetView(); //生成表3-14 FarPoint.Win.Spread.SheetView Sheet314 = new FarPoint.Win.Spread.SheetView(); //生成表3-14附表12 FarPoint.Win.Spread.SheetView Sheet314_12 = new FarPoint.Win.Spread.SheetView(); //生成表3-15 FarPoint.Win.Spread.SheetView Sheet315 = new FarPoint.Win.Spread.SheetView(); //生成表3-15附表14 FarPoint.Win.Spread.SheetView Sheet315_14 = new FarPoint.Win.Spread.SheetView(); //生成表3-16 FarPoint.Win.Spread.SheetView Sheet316 = new FarPoint.Win.Spread.SheetView(); //生成表3-16附表16 FarPoint.Win.Spread.SheetView Sheet316_16 = new FarPoint.Win.Spread.SheetView(); //生成表3-17 FarPoint.Win.Spread.SheetView Sheet317 = new FarPoint.Win.Spread.SheetView(); //生成表3-17附表17 FarPoint.Win.Spread.SheetView Sheet317_17 = new FarPoint.Win.Spread.SheetView(); //生成表3-18 FarPoint.Win.Spread.SheetView Sheet318 = new FarPoint.Win.Spread.SheetView(); //生成表3-18附表19 FarPoint.Win.Spread.SheetView Sheet318_19 = new FarPoint.Win.Spread.SheetView(); //生成表3-19 FarPoint.Win.Spread.SheetView Sheet319 = new FarPoint.Win.Spread.SheetView(); //生成表3-19附表20 FarPoint.Win.Spread.SheetView Sheet319_20 = new FarPoint.Win.Spread.SheetView(); //生成表3-20 FarPoint.Win.Spread.SheetView Sheet320 = new FarPoint.Win.Spread.SheetView(); //生成表3-20附表21 FarPoint.Win.Spread.SheetView Sheet320_21 = new FarPoint.Win.Spread.SheetView(); //添加表3-1 fpSpread1.Sheets.Add(Sheet31); //添加表3-2 fpSpread1.Sheets.Add(Sheet32); //添加3-3 fpSpread1.Sheets.Add(Sheet33); //添加表3-3附表1 fpSpread1.Sheets.Add(Sheet33_1); //添加表3-4 fpSpread1.Sheets.Add(Sheet34); //添加表3-4附表2 fpSpread1.Sheets.Add(Sheet34_2); //添加表35 fpSpread1.Sheets.Add(Sheet35); //添加表36 fpSpread1.Sheets.Add(Sheet36); //添加表37 fpSpread1.Sheets.Add(Sheet37); //添加表37附表3 fpSpread1.Sheets.Add(Sheet37_3); //添加表38 fpSpread1.Sheets.Add(Sheet38); //添加表38附表8 fpSpread1.Sheets.Add(Sheet38_8); //添加表39 fpSpread1.Sheets.Add(Sheet39); //添加表39附表6 fpSpread1.Sheets.Add(Sheet39_6); //添加表310 fpSpread1.Sheets.Add(Sheet310); //添加表310附表5 fpSpread1.Sheets.Add(Sheet310_5); //添加表311 fpSpread1.Sheets.Add(Sheet311); //添加表311附表9 fpSpread1.Sheets.Add(Sheet311_9); //添加表312 fpSpread1.Sheets.Add(Sheet312); //添加表312附表12 fpSpread1.Sheets.Add(Sheet312_10); //添加表313 fpSpread1.Sheets.Add(Sheet313); //添加表313附表11 fpSpread1.Sheets.Add(Sheet313_11); //添加表314 fpSpread1.Sheets.Add(Sheet314); //添加表314附表12 fpSpread1.Sheets.Add(Sheet314_12); //添加表315 fpSpread1.Sheets.Add(Sheet315); //添加表315附表14 fpSpread1.Sheets.Add(Sheet315_14); //添加表316 fpSpread1.Sheets.Add(Sheet316); //添加表316附表16 fpSpread1.Sheets.Add(Sheet316_16); //添加表317 fpSpread1.Sheets.Add(Sheet317); //添加表317附表17 fpSpread1.Sheets.Add(Sheet317_17); //添加表318 fpSpread1.Sheets.Add(Sheet318); //添加表318附表19 fpSpread1.Sheets.Add(Sheet318_19); //添加表319 fpSpread1.Sheets.Add(Sheet319); //添加表319附表20 fpSpread1.Sheets.Add(Sheet319_20); //添加表320 fpSpread1.Sheets.Add(Sheet320); //添加表320附表21 fpSpread1.Sheets.Add(Sheet320_21); //创建表3-1 sh31.Build(Sheet31, year, ProjID, SxXjName); //创建表3-2 sh32.Build(Sheet32, year, ProjID, SxXjName); //创建表3-3 sh33.Build(Sheet33, year, ProjID, SxXjName); //创建表3-3附表1 sh33_1.Build(Sheet33_1, year, ProjID, area_key_id, SxXjName); //创建表3-4 sh34.Build(Sheet34, year, ProjID, SxXjName); //创建表3-4附表2 sh34_2.Build(Sheet34_2, year, ProjID, area_key_id, SxXjName); //创建表35 sh35.Build(Sheet35, year, ProjID, SxXjName); //创建表36 sh36.Build(Sheet36, year, ProjID, SxXjName); //创建表37 sh37.Build(Sheet37, year, ProjID, SxXjName); //创建表37附表3 sh37_3.Build(Sheet37_3, year, ProjID, area_key_id, SxXjName); //创建表38 sh38.Build(Sheet38, year, ProjID, SxXjName); //创建表38附表8 sh38_8.Build(Sheet38_8,year, ProjID,area_key_name, area_key_id, SxXjName); //创建表39 sh39.Build(Sheet39, year, ProjID, SxXjName); //创建表39附表6 sh39_6.Build(Sheet39_6, year, ProjID, area_key_id, SxXjName); //创建表310 sh310.Build(Sheet310, year, ProjID, SxXjName); //创建表39附表6 sh310_5.Build(Sheet310_5, year, ProjID, area_key_id, SxXjName); //创建表311 sh311.Build(Sheet311, year, ProjID, SxXjName); //创建表311附表9 sh311_9.Build(Sheet311_9, year, ProjID, area_key_id, SxXjName); //创建表312 sh312.Build(Sheet312, year, ProjID, SxXjName); //创建表312附表10 sh312_10.Build(Sheet312_10, year, ProjID, area_key_id, SxXjName); //创建表313 sh313.Build(Sheet313, year, ProjID, SxXjName); //创建表313附表11 sh313_11.Build(Sheet313_11, year, ProjID, area_key_id, SxXjName); //创建表314 sh314.Build(Sheet314, year, ProjID, SxXjName); //创建表314附表12 sh314_12.Build(Sheet314_12, year, ProjID, area_key_id, SxXjName); //创建表315 sh315.Build(fpSpread1,Sheet315, year, ProjID, SxXjName); //创建表315附表14 sh315_14.Build(Sheet315_14, year, ProjID, area_key_id, SxXjName); //创建表316 sh316.Build(Sheet316, year, ProjID, SxXjName); //创建表316附表16 sh316_16.Build(Sheet316_16, year, ProjID,area_key_id,SxXjName); //创建表317 sh317.Build(Sheet317, year, ProjID, SxXjName); //创建表316附表16 sh317_17.Build(Sheet317_17, year, ProjID, area_key_id, SxXjName); //创建表318 sh318.Build(Sheet318, year, ProjID, SxXjName); //创建表316附表16 sh318_19.Build(Sheet318_19, year, ProjID, area_key_id, SxXjName); //创建表319 sh319.Build(Sheet319, year, ProjID, SxXjName); //创建表316附表16 sh319_20.Build(Sheet319_20, year, ProjID, area_key_id, SxXjName); //创建表320 sh320.Build(Sheet320, year, ProjID, SxXjName); //创建表320附表21 sh320_21.Build(Sheet320_21, year, ProjID, area_key_id, SxXjName); fc.Sheet_Colautoenter(fpSpread1); }
/// <summary> /// 设计器支持所需的方法 - 不要 /// 使用代码编辑器修改此方法的内容。 /// </summary> private void InitializeComponent() { FarPoint.Win.Spread.TipAppearance tipAppearance2 = new FarPoint.Win.Spread.TipAppearance(); this.fpEnter1 = new Neusoft.FrameWork.WinForms.Controls.NeuFpEnter(); this.fpEnter1_Sheet1 = new FarPoint.Win.Spread.SheetView(); this.contextMenu1 = new System.Windows.Forms.ContextMenu(); this.menuItem2 = new System.Windows.Forms.MenuItem(); this.panel1 = new Neusoft.FrameWork.WinForms.Controls.NeuPanel(); this.txtCmethod = new Neusoft.FrameWork.WinForms.Controls.NeuTextBox(); this.txtCmodeid = new Neusoft.FrameWork.WinForms.Controls.NeuTextBox(); this.label29 = new Neusoft.FrameWork.WinForms.Controls.NeuLabel(); this.dtenddate3 = new Neusoft.FrameWork.WinForms.Controls.NeuDateTimePicker(); this.label20 = new Neusoft.FrameWork.WinForms.Controls.NeuLabel(); this.dtbegindate3 = new Neusoft.FrameWork.WinForms.Controls.NeuDateTimePicker(); this.label21 = new Neusoft.FrameWork.WinForms.Controls.NeuLabel(); this.label22 = new Neusoft.FrameWork.WinForms.Controls.NeuLabel(); this.txtday3 = new Neusoft.FrameWork.WinForms.Controls.ValidatedTextBox(); this.label23 = new Neusoft.FrameWork.WinForms.Controls.NeuLabel(); this.txttime3 = new Neusoft.FrameWork.WinForms.Controls.ValidatedTextBox(); this.dtenddate2 = new Neusoft.FrameWork.WinForms.Controls.NeuDateTimePicker(); this.label16 = new Neusoft.FrameWork.WinForms.Controls.NeuLabel(); this.dtbegindate2 = new Neusoft.FrameWork.WinForms.Controls.NeuDateTimePicker(); this.label17 = new Neusoft.FrameWork.WinForms.Controls.NeuLabel(); this.label18 = new Neusoft.FrameWork.WinForms.Controls.NeuLabel(); this.txtday2 = new Neusoft.FrameWork.WinForms.Controls.ValidatedTextBox(); this.label19 = new Neusoft.FrameWork.WinForms.Controls.NeuLabel(); this.txttime2 = new Neusoft.FrameWork.WinForms.Controls.ValidatedTextBox(); this.dtenddate1 = new Neusoft.FrameWork.WinForms.Controls.NeuDateTimePicker(); this.label15 = new Neusoft.FrameWork.WinForms.Controls.NeuLabel(); this.dtbegindate1 = new Neusoft.FrameWork.WinForms.Controls.NeuDateTimePicker(); this.label14 = new Neusoft.FrameWork.WinForms.Controls.NeuLabel(); this.label13 = new Neusoft.FrameWork.WinForms.Controls.NeuLabel(); this.txtday1 = new Neusoft.FrameWork.WinForms.Controls.ValidatedTextBox(); this.label12 = new Neusoft.FrameWork.WinForms.Controls.NeuLabel(); this.txttime1 = new Neusoft.FrameWork.WinForms.Controls.ValidatedTextBox(); this.label11 = new Neusoft.FrameWork.WinForms.Controls.NeuLabel(); this.label8 = new Neusoft.FrameWork.WinForms.Controls.NeuLabel(); this.txtgy3 = new Neusoft.FrameWork.WinForms.Controls.ValidatedTextBox(); this.label6 = new Neusoft.FrameWork.WinForms.Controls.NeuLabel(); this.txtgy2 = new Neusoft.FrameWork.WinForms.Controls.ValidatedTextBox(); this.label7 = new Neusoft.FrameWork.WinForms.Controls.NeuLabel(); this.label5 = new Neusoft.FrameWork.WinForms.Controls.NeuLabel(); this.txtgy1 = new Neusoft.FrameWork.WinForms.Controls.ValidatedTextBox(); this.txtRdeviceid = new Neusoft.FrameWork.WinForms.Controls.NeuTextBox(); this.txtRprocessid = new Neusoft.FrameWork.WinForms.Controls.NeuTextBox(); this.txtRmodeid = new Neusoft.FrameWork.WinForms.Controls.NeuTextBox(); this.label3 = new Neusoft.FrameWork.WinForms.Controls.NeuLabel(); this.label2 = new Neusoft.FrameWork.WinForms.Controls.NeuLabel(); this.label1 = new Neusoft.FrameWork.WinForms.Controls.NeuLabel(); this.label4 = new Neusoft.FrameWork.WinForms.Controls.NeuLabel(); this.label28 = new Neusoft.FrameWork.WinForms.Controls.NeuLabel(); ((System.ComponentModel.ISupportInitialize)(this.fpEnter1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.fpEnter1_Sheet1)).BeginInit(); this.panel1.SuspendLayout(); this.SuspendLayout(); // // fpEnter1 // this.fpEnter1.About = "2.5.2007.2005"; this.fpEnter1.AccessibleDescription = ""; this.fpEnter1.Dock = System.Windows.Forms.DockStyle.Fill; this.fpEnter1.EditModePermanent = true; this.fpEnter1.EditModeReplace = true; this.fpEnter1.Location = new System.Drawing.Point(0, 168); this.fpEnter1.Name = "fpEnter1"; this.fpEnter1.SelectNone = false; this.fpEnter1.Sheets.AddRange(new FarPoint.Win.Spread.SheetView[] { this.fpEnter1_Sheet1 }); this.fpEnter1.ShowListWhenOfFocus = false; this.fpEnter1.Size = new System.Drawing.Size(840, 384); this.fpEnter1.TabIndex = 0; tipAppearance2.BackColor = System.Drawing.SystemColors.Info; tipAppearance2.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); tipAppearance2.ForeColor = System.Drawing.SystemColors.InfoText; this.fpEnter1.TextTipAppearance = tipAppearance2; // // fpEnter1_Sheet1 // this.fpEnter1_Sheet1.Reset(); this.fpEnter1_Sheet1.SheetName = "Sheet1"; // Formulas and custom names must be loaded with R1C1 reference style this.fpEnter1_Sheet1.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.R1C1; this.fpEnter1_Sheet1.ColumnCount = 8; this.fpEnter1_Sheet1.ActiveSkin = new FarPoint.Win.Spread.SheetSkin("CustomSkin1", System.Drawing.SystemColors.Control, System.Drawing.Color.Empty, System.Drawing.Color.Empty, System.Drawing.Color.LightGray, FarPoint.Win.Spread.GridLines.Both, System.Drawing.Color.White, System.Drawing.Color.Empty, System.Drawing.Color.Empty, System.Drawing.Color.Empty, System.Drawing.Color.Empty, System.Drawing.Color.Empty, false, false, true, true, true); this.fpEnter1_Sheet1.ColumnHeader.Cells.Get(0, 0).Value = "时间"; this.fpEnter1_Sheet1.ColumnHeader.Cells.Get(0, 1).Value = "药物名称"; this.fpEnter1_Sheet1.ColumnHeader.Cells.Get(0, 2).Value = "单位"; this.fpEnter1_Sheet1.ColumnHeader.Cells.Get(0, 3).Value = "疗程"; this.fpEnter1_Sheet1.ColumnHeader.Cells.Get(0, 4).Value = "结果"; this.fpEnter1_Sheet1.ColumnHeader.Cells.Get(0, 5).Value = "用量"; this.fpEnter1_Sheet1.ColumnHeader.Cells.Get(0, 6).Value = "药品编码"; this.fpEnter1_Sheet1.ColumnHeader.Cells.Get(0, 7).Value = "序号"; this.fpEnter1_Sheet1.ColumnHeader.DefaultStyle.BackColor = System.Drawing.Color.White; this.fpEnter1_Sheet1.ColumnHeader.DefaultStyle.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Bold); this.fpEnter1_Sheet1.ColumnHeader.DefaultStyle.Locked = false; this.fpEnter1_Sheet1.ColumnHeader.DefaultStyle.Parent = "HeaderDefault"; this.fpEnter1_Sheet1.Columns.Get(0).Label = "时间"; this.fpEnter1_Sheet1.Columns.Get(0).Width = 65F; this.fpEnter1_Sheet1.RowHeader.Columns.Default.Resizable = false; this.fpEnter1_Sheet1.RowHeader.Columns.Get(0).Width = 40F; this.fpEnter1_Sheet1.RowHeader.DefaultStyle.BackColor = System.Drawing.Color.White; this.fpEnter1_Sheet1.RowHeader.DefaultStyle.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Bold); this.fpEnter1_Sheet1.RowHeader.DefaultStyle.Locked = false; this.fpEnter1_Sheet1.RowHeader.DefaultStyle.Parent = "HeaderDefault"; this.fpEnter1_Sheet1.SheetCornerStyle.BackColor = System.Drawing.Color.White; this.fpEnter1_Sheet1.SheetCornerStyle.Locked = false; this.fpEnter1_Sheet1.SheetCornerStyle.Parent = "HeaderDefault"; this.fpEnter1_Sheet1.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.A1; // // contextMenu1 // this.contextMenu1.MenuItems.AddRange(new System.Windows.Forms.MenuItem[] { this.menuItem2 }); // // menuItem2 // this.menuItem2.Index = 0; this.menuItem2.Text = "删除"; this.menuItem2.Click += new System.EventHandler(this.menuItem2_Click); // // panel1 // this.panel1.BackColor = System.Drawing.Color.Azure; this.panel1.Controls.Add(this.txtCmethod); this.panel1.Controls.Add(this.txtCmodeid); this.panel1.Controls.Add(this.label29); this.panel1.Controls.Add(this.dtenddate3); this.panel1.Controls.Add(this.label20); this.panel1.Controls.Add(this.dtbegindate3); this.panel1.Controls.Add(this.label21); this.panel1.Controls.Add(this.label22); this.panel1.Controls.Add(this.txtday3); this.panel1.Controls.Add(this.label23); this.panel1.Controls.Add(this.txttime3); this.panel1.Controls.Add(this.dtenddate2); this.panel1.Controls.Add(this.label16); this.panel1.Controls.Add(this.dtbegindate2); this.panel1.Controls.Add(this.label17); this.panel1.Controls.Add(this.label18); this.panel1.Controls.Add(this.txtday2); this.panel1.Controls.Add(this.label19); this.panel1.Controls.Add(this.txttime2); this.panel1.Controls.Add(this.dtenddate1); this.panel1.Controls.Add(this.label15); this.panel1.Controls.Add(this.dtbegindate1); this.panel1.Controls.Add(this.label14); this.panel1.Controls.Add(this.label13); this.panel1.Controls.Add(this.txtday1); this.panel1.Controls.Add(this.label12); this.panel1.Controls.Add(this.txttime1); this.panel1.Controls.Add(this.label11); this.panel1.Controls.Add(this.label8); this.panel1.Controls.Add(this.txtgy3); this.panel1.Controls.Add(this.label6); this.panel1.Controls.Add(this.txtgy2); this.panel1.Controls.Add(this.label7); this.panel1.Controls.Add(this.label5); this.panel1.Controls.Add(this.txtgy1); this.panel1.Controls.Add(this.txtRdeviceid); this.panel1.Controls.Add(this.txtRprocessid); this.panel1.Controls.Add(this.txtRmodeid); this.panel1.Controls.Add(this.label3); this.panel1.Controls.Add(this.label2); this.panel1.Controls.Add(this.label1); this.panel1.Controls.Add(this.label4); this.panel1.Controls.Add(this.label28); this.panel1.Dock = System.Windows.Forms.DockStyle.Top; this.panel1.Location = new System.Drawing.Point(0, 0); this.panel1.Name = "panel1"; this.panel1.Size = new System.Drawing.Size(840, 168); this.panel1.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.panel1.TabIndex = 1; // // txtCmethod // this.txtCmethod.Location = new System.Drawing.Point(304, 136); this.txtCmethod.MaxLength = 6; this.txtCmethod.Name = "txtCmethod"; this.txtCmethod.Size = new System.Drawing.Size(100, 21); this.txtCmethod.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.txtCmethod.TabIndex = 60; this.txtCmethod.Enter += new System.EventHandler(this.Cmethod_Enter); this.txtCmethod.TextChanged += new System.EventHandler(this.Cmethod_TextChanged); this.txtCmethod.KeyDown += new System.Windows.Forms.KeyEventHandler(this.Cmethod_KeyDown); // // txtCmodeid // this.txtCmodeid.Location = new System.Drawing.Point(88, 136); this.txtCmodeid.MaxLength = 6; this.txtCmodeid.Name = "txtCmodeid"; this.txtCmodeid.Size = new System.Drawing.Size(100, 21); this.txtCmodeid.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.txtCmodeid.TabIndex = 52; this.txtCmodeid.Enter += new System.EventHandler(this.Cmodeid_Enter); this.txtCmodeid.TextChanged += new System.EventHandler(this.Cmodeid_TextChanged); this.txtCmodeid.KeyDown += new System.Windows.Forms.KeyEventHandler(this.Cmodeid_KeyDown); // // label29 // this.label29.AutoSize = true; this.label29.Location = new System.Drawing.Point(232, 136); this.label29.Name = "label29"; this.label29.Size = new System.Drawing.Size(53, 12); this.label29.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.label29.TabIndex = 51; this.label29.Text = "化疗方法"; this.label29.TextAlign = System.Drawing.ContentAlignment.MiddleLeft; // // dtenddate3 // this.dtenddate3.Location = new System.Drawing.Point(576, 104); this.dtenddate3.Name = "dtenddate3"; this.dtenddate3.Size = new System.Drawing.Size(112, 21); this.dtenddate3.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.dtenddate3.TabIndex = 41; this.dtenddate3.KeyDown += new System.Windows.Forms.KeyEventHandler(this.end_date3_KeyDown); // // label20 // this.label20.Location = new System.Drawing.Point(536, 104); this.label20.Name = "label20"; this.label20.Size = new System.Drawing.Size(32, 23); this.label20.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.label20.TabIndex = 40; this.label20.Text = "止日"; this.label20.TextAlign = System.Drawing.ContentAlignment.MiddleLeft; // // dtbegindate3 // this.dtbegindate3.Location = new System.Drawing.Point(408, 104); this.dtbegindate3.Name = "dtbegindate3"; this.dtbegindate3.Size = new System.Drawing.Size(112, 21); this.dtbegindate3.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.dtbegindate3.TabIndex = 39; this.dtbegindate3.KeyDown += new System.Windows.Forms.KeyEventHandler(this.begin_date3_KeyDown); // // label21 // this.label21.Location = new System.Drawing.Point(376, 104); this.label21.Name = "label21"; this.label21.Size = new System.Drawing.Size(32, 23); this.label21.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.label21.TabIndex = 38; this.label21.Text = "起日"; this.label21.TextAlign = System.Drawing.ContentAlignment.MiddleLeft; // // label22 // this.label22.Location = new System.Drawing.Point(344, 104); this.label22.Name = "label22"; this.label22.Size = new System.Drawing.Size(24, 23); this.label22.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.label22.TabIndex = 37; this.label22.Text = "天"; this.label22.TextAlign = System.Drawing.ContentAlignment.MiddleLeft; // // txtday3 // this.txtday3.AllowNegative = false; this.txtday3.AutoPadRightZero = false; this.txtday3.Location = new System.Drawing.Point(304, 104); this.txtday3.MaxDigits = 0; this.txtday3.MaxLength = 6; this.txtday3.Name = "txtday3"; this.txtday3.Size = new System.Drawing.Size(32, 21); this.txtday3.TabIndex = 36; this.txtday3.WillShowError = false; this.txtday3.KeyDown += new System.Windows.Forms.KeyEventHandler(this.day3_KeyDown); // // label23 // this.label23.Location = new System.Drawing.Point(272, 104); this.label23.Name = "label23"; this.label23.Size = new System.Drawing.Size(24, 23); this.label23.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.label23.TabIndex = 35; this.label23.Text = "次"; this.label23.TextAlign = System.Drawing.ContentAlignment.MiddleLeft; // // txttime3 // this.txttime3.AllowNegative = false; this.txttime3.AutoPadRightZero = false; this.txttime3.Location = new System.Drawing.Point(232, 104); this.txttime3.MaxDigits = 0; this.txttime3.MaxLength = 6; this.txttime3.Name = "txttime3"; this.txttime3.Size = new System.Drawing.Size(32, 21); this.txttime3.TabIndex = 34; this.txttime3.WillShowError = false; this.txttime3.KeyDown += new System.Windows.Forms.KeyEventHandler(this.time3_KeyDown); // // dtenddate2 // this.dtenddate2.Location = new System.Drawing.Point(576, 72); this.dtenddate2.Name = "dtenddate2"; this.dtenddate2.Size = new System.Drawing.Size(112, 21); this.dtenddate2.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.dtenddate2.TabIndex = 33; this.dtenddate2.KeyDown += new System.Windows.Forms.KeyEventHandler(this.end_date2_KeyDown); // // label16 // this.label16.Location = new System.Drawing.Point(536, 72); this.label16.Name = "label16"; this.label16.Size = new System.Drawing.Size(32, 23); this.label16.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.label16.TabIndex = 32; this.label16.Text = "止日"; this.label16.TextAlign = System.Drawing.ContentAlignment.MiddleLeft; // // dtbegindate2 // this.dtbegindate2.Location = new System.Drawing.Point(408, 72); this.dtbegindate2.Name = "dtbegindate2"; this.dtbegindate2.Size = new System.Drawing.Size(112, 21); this.dtbegindate2.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.dtbegindate2.TabIndex = 31; this.dtbegindate2.KeyDown += new System.Windows.Forms.KeyEventHandler(this.begin_date2_KeyDown); // // label17 // this.label17.Location = new System.Drawing.Point(376, 72); this.label17.Name = "label17"; this.label17.Size = new System.Drawing.Size(32, 23); this.label17.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.label17.TabIndex = 30; this.label17.Text = "起日"; this.label17.TextAlign = System.Drawing.ContentAlignment.MiddleLeft; // // label18 // this.label18.Location = new System.Drawing.Point(344, 72); this.label18.Name = "label18"; this.label18.Size = new System.Drawing.Size(24, 23); this.label18.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.label18.TabIndex = 29; this.label18.Text = "天"; this.label18.TextAlign = System.Drawing.ContentAlignment.MiddleLeft; // // txtday2 // this.txtday2.AllowNegative = false; this.txtday2.AutoPadRightZero = false; this.txtday2.Location = new System.Drawing.Point(304, 72); this.txtday2.MaxDigits = 0; this.txtday2.MaxLength = 6; this.txtday2.Name = "txtday2"; this.txtday2.Size = new System.Drawing.Size(32, 21); this.txtday2.TabIndex = 28; this.txtday2.WillShowError = false; this.txtday2.KeyDown += new System.Windows.Forms.KeyEventHandler(this.day2_KeyDown); // // label19 // this.label19.Location = new System.Drawing.Point(272, 72); this.label19.Name = "label19"; this.label19.Size = new System.Drawing.Size(24, 23); this.label19.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.label19.TabIndex = 27; this.label19.Text = "次"; this.label19.TextAlign = System.Drawing.ContentAlignment.MiddleLeft; // // txttime2 // this.txttime2.AllowNegative = false; this.txttime2.AutoPadRightZero = false; this.txttime2.Location = new System.Drawing.Point(232, 72); this.txttime2.MaxDigits = 0; this.txttime2.MaxLength = 6; this.txttime2.Name = "txttime2"; this.txttime2.Size = new System.Drawing.Size(32, 21); this.txttime2.TabIndex = 26; this.txttime2.WillShowError = false; this.txttime2.KeyDown += new System.Windows.Forms.KeyEventHandler(this.time2_KeyDown); // // dtenddate1 // this.dtenddate1.Location = new System.Drawing.Point(576, 40); this.dtenddate1.Name = "dtenddate1"; this.dtenddate1.Size = new System.Drawing.Size(112, 21); this.dtenddate1.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.dtenddate1.TabIndex = 25; this.dtenddate1.KeyDown += new System.Windows.Forms.KeyEventHandler(this.end_date1_KeyDown); // // label15 // this.label15.Location = new System.Drawing.Point(536, 40); this.label15.Name = "label15"; this.label15.Size = new System.Drawing.Size(32, 23); this.label15.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.label15.TabIndex = 24; this.label15.Text = "止日"; this.label15.TextAlign = System.Drawing.ContentAlignment.MiddleLeft; // // dtbegindate1 // this.dtbegindate1.Location = new System.Drawing.Point(408, 40); this.dtbegindate1.Name = "dtbegindate1"; this.dtbegindate1.Size = new System.Drawing.Size(112, 21); this.dtbegindate1.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.dtbegindate1.TabIndex = 23; this.dtbegindate1.KeyDown += new System.Windows.Forms.KeyEventHandler(this.begin_date1_KeyDown); // // label14 // this.label14.Location = new System.Drawing.Point(376, 40); this.label14.Name = "label14"; this.label14.Size = new System.Drawing.Size(32, 23); this.label14.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.label14.TabIndex = 22; this.label14.Text = "起日"; this.label14.TextAlign = System.Drawing.ContentAlignment.MiddleLeft; // // label13 // this.label13.Location = new System.Drawing.Point(344, 40); this.label13.Name = "label13"; this.label13.Size = new System.Drawing.Size(24, 23); this.label13.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.label13.TabIndex = 21; this.label13.Text = "天"; this.label13.TextAlign = System.Drawing.ContentAlignment.MiddleLeft; // // txtday1 // this.txtday1.AllowNegative = false; this.txtday1.AutoPadRightZero = false; this.txtday1.Location = new System.Drawing.Point(304, 40); this.txtday1.MaxDigits = 0; this.txtday1.MaxLength = 6; this.txtday1.Name = "txtday1"; this.txtday1.Size = new System.Drawing.Size(32, 21); this.txtday1.TabIndex = 20; this.txtday1.WillShowError = false; this.txtday1.KeyDown += new System.Windows.Forms.KeyEventHandler(this.day1_KeyDown); // // label12 // this.label12.Location = new System.Drawing.Point(272, 40); this.label12.Name = "label12"; this.label12.Size = new System.Drawing.Size(24, 23); this.label12.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.label12.TabIndex = 19; this.label12.Text = "次"; this.label12.TextAlign = System.Drawing.ContentAlignment.MiddleLeft; // // txttime1 // this.txttime1.AllowNegative = false; this.txttime1.AutoPadRightZero = false; this.txttime1.Location = new System.Drawing.Point(232, 40); this.txttime1.MaxDigits = 0; this.txttime1.MaxLength = 6; this.txttime1.Name = "txttime1"; this.txttime1.Size = new System.Drawing.Size(32, 21); this.txttime1.TabIndex = 18; this.txttime1.WillShowError = false; this.txttime1.KeyDown += new System.Windows.Forms.KeyEventHandler(this.time1_KeyDown); // // label11 // this.label11.AutoSize = true; this.label11.Location = new System.Drawing.Point(16, 104); this.label11.Name = "label11"; this.label11.Size = new System.Drawing.Size(65, 12); this.label11.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.label11.TabIndex = 16; this.label11.Text = "转移灶计量"; this.label11.TextAlign = System.Drawing.ContentAlignment.MiddleLeft; // // label8 // this.label8.Location = new System.Drawing.Point(192, 104); this.label8.Name = "label8"; this.label8.Size = new System.Drawing.Size(24, 23); this.label8.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.label8.TabIndex = 14; this.label8.Text = "GY"; this.label8.TextAlign = System.Drawing.ContentAlignment.MiddleLeft; // // txtgy3 // this.txtgy3.AllowNegative = false; this.txtgy3.AutoPadRightZero = false; this.txtgy3.Location = new System.Drawing.Point(88, 104); this.txtgy3.MaxDigits = 0; this.txtgy3.MaxLength = 6; this.txtgy3.Name = "txtgy3"; this.txtgy3.Size = new System.Drawing.Size(100, 21); this.txtgy3.TabIndex = 12; this.txtgy3.WillShowError = false; this.txtgy3.KeyDown += new System.Windows.Forms.KeyEventHandler(this.gy3_KeyDown); // // label6 // this.label6.Location = new System.Drawing.Point(192, 72); this.label6.Name = "label6"; this.label6.Size = new System.Drawing.Size(24, 23); this.label6.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.label6.TabIndex = 11; this.label6.Text = "GY"; this.label6.TextAlign = System.Drawing.ContentAlignment.MiddleLeft; // // txtgy2 // this.txtgy2.AllowNegative = false; this.txtgy2.AutoPadRightZero = false; this.txtgy2.Location = new System.Drawing.Point(88, 72); this.txtgy2.MaxDigits = 0; this.txtgy2.MaxLength = 6; this.txtgy2.Name = "txtgy2"; this.txtgy2.Size = new System.Drawing.Size(100, 21); this.txtgy2.TabIndex = 9; this.txtgy2.WillShowError = false; this.txtgy2.KeyDown += new System.Windows.Forms.KeyEventHandler(this.gy2_KeyDown); // // label7 // this.label7.AutoSize = true; this.label7.Location = new System.Drawing.Point(16, 72); this.label7.Name = "label7"; this.label7.Size = new System.Drawing.Size(65, 12); this.label7.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.label7.TabIndex = 10; this.label7.Text = "区域淋巴结"; this.label7.TextAlign = System.Drawing.ContentAlignment.MiddleLeft; // // label5 // this.label5.Location = new System.Drawing.Point(192, 40); this.label5.Name = "label5"; this.label5.Size = new System.Drawing.Size(24, 23); this.label5.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.label5.TabIndex = 8; this.label5.Text = "GY"; this.label5.TextAlign = System.Drawing.ContentAlignment.MiddleLeft; // // txtgy1 // this.txtgy1.AllowNegative = false; this.txtgy1.AutoPadRightZero = false; this.txtgy1.Location = new System.Drawing.Point(88, 40); this.txtgy1.MaxDigits = 0; this.txtgy1.MaxLength = 6; this.txtgy1.Name = "txtgy1"; this.txtgy1.Size = new System.Drawing.Size(100, 21); this.txtgy1.TabIndex = 6; this.txtgy1.WillShowError = false; this.txtgy1.KeyDown += new System.Windows.Forms.KeyEventHandler(this.gy1_KeyDown); // // txtRdeviceid // this.txtRdeviceid.Location = new System.Drawing.Point(520, 8); this.txtRdeviceid.MaxLength = 5; this.txtRdeviceid.Name = "txtRdeviceid"; this.txtRdeviceid.Size = new System.Drawing.Size(100, 21); this.txtRdeviceid.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.txtRdeviceid.TabIndex = 5; this.txtRdeviceid.Enter += new System.EventHandler(this.Rdeviceid_Enter); this.txtRdeviceid.TextChanged += new System.EventHandler(this.Rdeviceid_TextChanged); this.txtRdeviceid.KeyDown += new System.Windows.Forms.KeyEventHandler(this.Rdeviceid_KeyDown); // // txtRprocessid // this.txtRprocessid.Location = new System.Drawing.Point(312, 8); this.txtRprocessid.MaxLength = 5; this.txtRprocessid.Name = "txtRprocessid"; this.txtRprocessid.Size = new System.Drawing.Size(100, 21); this.txtRprocessid.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.txtRprocessid.TabIndex = 4; this.txtRprocessid.Enter += new System.EventHandler(this.Rprocessid_Enter); this.txtRprocessid.TextChanged += new System.EventHandler(this.Rprocessid_TextChanged); this.txtRprocessid.KeyDown += new System.Windows.Forms.KeyEventHandler(this.Rprocessid_KeyDown); // // txtRmodeid // this.txtRmodeid.Location = new System.Drawing.Point(88, 8); this.txtRmodeid.MaxLength = 5; this.txtRmodeid.Name = "txtRmodeid"; this.txtRmodeid.Size = new System.Drawing.Size(100, 21); this.txtRmodeid.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.txtRmodeid.TabIndex = 3; this.txtRmodeid.Enter += new System.EventHandler(this.Rmodeid_Enter); this.txtRmodeid.TextChanged += new System.EventHandler(this.Rmodeid_TextChanged); this.txtRmodeid.KeyDown += new System.Windows.Forms.KeyEventHandler(this.Rmodeid_KeyDown); // // label3 // this.label3.AutoSize = true; this.label3.Location = new System.Drawing.Point(432, 8); this.label3.Name = "label3"; this.label3.Size = new System.Drawing.Size(53, 12); this.label3.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.label3.TabIndex = 2; this.label3.Text = "放疗装置"; this.label3.TextAlign = System.Drawing.ContentAlignment.MiddleLeft; // // label2 // this.label2.AutoSize = true; this.label2.Location = new System.Drawing.Point(232, 8); this.label2.Name = "label2"; this.label2.Size = new System.Drawing.Size(53, 12); this.label2.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.label2.TabIndex = 1; this.label2.Text = "放疗程式"; this.label2.TextAlign = System.Drawing.ContentAlignment.MiddleLeft; // // label1 // this.label1.AutoSize = true; this.label1.Location = new System.Drawing.Point(16, 8); this.label1.Name = "label1"; this.label1.Size = new System.Drawing.Size(53, 12); this.label1.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.label1.TabIndex = 0; this.label1.Text = "放疗方式"; this.label1.TextAlign = System.Drawing.ContentAlignment.MiddleLeft; // // label4 // this.label4.AutoSize = true; this.label4.Location = new System.Drawing.Point(16, 40); this.label4.Name = "label4"; this.label4.Size = new System.Drawing.Size(65, 12); this.label4.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.label4.TabIndex = 7; this.label4.Text = "原发灶计量"; this.label4.TextAlign = System.Drawing.ContentAlignment.MiddleLeft; // // label28 // this.label28.AutoSize = true; this.label28.Location = new System.Drawing.Point(16, 136); this.label28.Name = "label28"; this.label28.Size = new System.Drawing.Size(53, 12); this.label28.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.label28.TabIndex = 50; this.label28.Text = "化疗方式"; this.label28.TextAlign = System.Drawing.ContentAlignment.MiddleLeft; // // ucTumourCard // this.ContextMenu = this.contextMenu1; this.Controls.Add(this.fpEnter1); this.Controls.Add(this.panel1); this.Name = "ucTumourCard"; this.Size = new System.Drawing.Size(840, 552); this.Load += new System.EventHandler(this.ucTumourCard_Load); ((System.ComponentModel.ISupportInitialize)(this.fpEnter1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.fpEnter1_Sheet1)).EndInit(); this.panel1.ResumeLayout(false); this.panel1.PerformLayout(); this.ResumeLayout(false); }
private void Firstadddata() { //生成表3-1 FarPoint.Win.Spread.SheetView Sheet31 = new FarPoint.Win.Spread.SheetView(); //添加表3-1 fpSpread1.Sheets.Add(Sheet31); //创建表3-1 sh31.Build(Sheet31, year, ProjID, SxXjName); fc.Sheet_Colautoenter(fpSpread1); }
/// <summary> /// 更新 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void barButtonItem2_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { wait = new WaitDialogForm("", "正在更新数据, 请稍候..."); ////由于SheetView已经没有了所以移除SheetView //MessageBox.Show(fpSpread1.Sheets[0].SheetName); //=================================================== FarPoint.Win.Spread.SheetView obj = null; //由于更新数据时间太长需要建个空表做初始界面 FarPoint.Win.Spread.SheetView fpSpread1_SheetN = new FarPoint.Win.Spread.SheetView(); fpSpread1.Sheets.Add(fpSpread1_SheetN); obj = fpSpread1.ActiveSheet; fpSpread1.ActiveSheet = fpSpread1_SheetN; //PF.CreateSheet(this, fpSpread1, "kk"); SheetIndex = fpSpread1.ActiveSheetIndex;//记住当前的SheetView的索引值 //fpSpread1.ActiveSheet=fpSpread1.Sheets[fpSpread1.Sheets.Count-1];//把当前界面给空表 //PF.RemoveSheetView(this.fpSpread1, (fpSpread1.Sheets.Count - 1));//清空所有行列 //this.fpSpread1.Sheets.Clear(); IsCreateSheet = false; fpSpread1.Sheets[1].RowCount = 0; fpSpread1.Sheets[1].ColumnCount = 0; S_15.SetSheet_15Title(this, fpSpread1.Sheets[1], "铜陵县分行业用电历史实绩统计表"); fpSpread1.Sheets[2].RowCount = 0; fpSpread1.Sheets[2].ColumnCount = 0; S_16.SetSheet_16Title(this, fpSpread1.Sheets[2], "附表16 铜陵县历年用电量及负荷分区统计"); //fpSpread1.Sheets[3].RowCount = 0; //fpSpread1.Sheets[3].ColumnCount = 0; //S_17.SetSheet_17Title(this, fpSpread1.Sheets[3], "附表17 规划年铜陵县经济发展预测结果表"); fpSpread1.Sheets[4].RowCount = 0; fpSpread1.Sheets[4].ColumnCount = 0; S_18.SetSheet_18Title(this, fpSpread1.Sheets[4], "附表18 规划年铜陵县大用户统计信息表"); //fpSpread1.Sheets[5].RowCount = 0; //fpSpread1.Sheets[5].ColumnCount = 0; //S_19.SetSheet_19Title(this, fpSpread1.Sheets[5], "2010-2020年铜陵县县负荷预测表"); fpSpread1.Sheets[6].RowCount = 0; fpSpread1.Sheets[6].ColumnCount = 0; S_20.SetSheet_20Title(this, fpSpread1.Sheets[6], "附表20 规划年铜陵县规划装机进度表"); //newwait.Close(); IsCreateSheet = true; fpSpread1.ActiveSheet = obj;//fpSpread1.Sheets[SheetIndex];//把以前显示的界面在显示出来 //if (obj.SheetName == "附表10 铜陵县中压线路“N-1”分析" || obj.SheetName == "附表11 铜陵县110kV及35kV变电站主变故障或检修“N-1”通过情况") //{ // this.barEditItem1.Visibility = DevExpress.XtraBars.BarItemVisibility.Never; //} //删除临时SheetView //fpSpread1.Sheets.Remove(fpSpread1.Sheets[fpSpread1.Sheets.Count - 1]); fpSpread1.Sheets.Remove(fpSpread1_SheetN); wait.Close(); MessageBox.Show("更新数据完成!"); }
/// <summary> /// 更新 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void barButtonItem2_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { wait = new WaitDialogForm("", "正在更新数据, 请稍候..."); ////由于SheetView已经没有了所以移除SheetView //MessageBox.Show(fpSpread1.Sheets[0].SheetName); //=================================================== FarPoint.Win.Spread.SheetView obj = null; //由于更新数据时间太长需要建个空表做初始界面 FarPoint.Win.Spread.SheetView fpSpread1_SheetN = new FarPoint.Win.Spread.SheetView(); fpSpread1.Sheets.Add(fpSpread1_SheetN); obj = fpSpread1.ActiveSheet; fpSpread1.ActiveSheet = fpSpread1_SheetN; //PF.CreateSheet(this, fpSpread1, "kk"); SheetIndex = fpSpread1.ActiveSheetIndex;//记住当前的SheetView的索引值 //fpSpread1.ActiveSheet=fpSpread1.Sheets[fpSpread1.Sheets.Count-1];//把当前界面给空表 PF.RemoveSheetView(this.fpSpread1, (fpSpread1.Sheets.Count - 1));//清空所有行列 //this.fpSpread1.Sheets.Clear(); IsCreateSheet = false; S_30.SetSheet_30Title(this, fpSpread1.Sheets[0], "附表30 本地区“十二五”规划项目资金需求表 "); //newwait.Close(); IsCreateSheet = true; fpSpread1.ActiveSheet = obj;//fpSpread1.Sheets[SheetIndex];//把以前显示的界面在显示出来 //if (obj.SheetName == "附表10 铜陵县中压线路“N-1”分析" || obj.SheetName == "附表11 铜陵县110kV及35kV变电站主变故障或检修“N-1”通过情况") //{ // this.barEditItem1.Visibility = DevExpress.XtraBars.BarItemVisibility.Never; //} //删除临时SheetView //fpSpread1.Sheets.Remove(fpSpread1.Sheets[fpSpread1.Sheets.Count - 1]); fpSpread1.Sheets.Remove(fpSpread1_SheetN); //MessageBox.Show("更新数据完成!"); wait.Close(); }
private void Firstadddata() { //如果没有文件,则全部表格重写 //新建表7-1 FarPoint.Win.Spread.SheetView Sheet71 = new FarPoint.Win.Spread.SheetView(); //新建表7-2 FarPoint.Win.Spread.SheetView Sheet72 = new FarPoint.Win.Spread.SheetView(); //新建表7-2附表36 FarPoint.Win.Spread.SheetView Sheet72_36 = new FarPoint.Win.Spread.SheetView(); //新建表7-3 FarPoint.Win.Spread.SheetView Sheet73 = new FarPoint.Win.Spread.SheetView(); //新建表7-3附表37 FarPoint.Win.Spread.SheetView Sheet73_37 = new FarPoint.Win.Spread.SheetView(); //新建表7-4 FarPoint.Win.Spread.SheetView Sheet74 = new FarPoint.Win.Spread.SheetView(); //新建表7-4附表38 FarPoint.Win.Spread.SheetView Sheet74_38 = new FarPoint.Win.Spread.SheetView(); //新建表7-5 FarPoint.Win.Spread.SheetView Sheet75 = new FarPoint.Win.Spread.SheetView(); //新建表7-5附表39 FarPoint.Win.Spread.SheetView Sheet75_39 = new FarPoint.Win.Spread.SheetView(); //新建表7-6 FarPoint.Win.Spread.SheetView Sheet76 = new FarPoint.Win.Spread.SheetView(); //新建表7-6附表40 FarPoint.Win.Spread.SheetView Sheet76_40 = new FarPoint.Win.Spread.SheetView(); //新建表7-7 FarPoint.Win.Spread.SheetView Sheet77 = new FarPoint.Win.Spread.SheetView(); //新建表7-8 FarPoint.Win.Spread.SheetView Sheet78 = new FarPoint.Win.Spread.SheetView(); //新建表7-9 FarPoint.Win.Spread.SheetView Sheet79 = new FarPoint.Win.Spread.SheetView(); //根据窗口变化全部添满 fpSpread1.Dock = System.Windows.Forms.DockStyle.Fill; Sheet71.SheetName = "表7-1"; fpSpread1.Sheets.Add(Sheet71); Sheet72.SheetName = "表7-2"; fpSpread1.Sheets.Add(Sheet72); Sheet72_36.SheetName = "表7-2 附表36"; fpSpread1.Sheets.Add(Sheet72_36); Sheet73.SheetName = "表7-3"; fpSpread1.Sheets.Add(Sheet73); Sheet73_37.SheetName = "表7-3 附表37"; fpSpread1.Sheets.Add(Sheet73_37); Sheet74.SheetName = "表7-4 "; fpSpread1.Sheets.Add(Sheet74); Sheet74_38.SheetName = "表7-4 附表38"; fpSpread1.Sheets.Add(Sheet74_38); Sheet75.SheetName = "表7-5"; fpSpread1.Sheets.Add(Sheet75); Sheet75_39.SheetName = "表7-5 附表39"; fpSpread1.Sheets.Add(Sheet75_39); Sheet76.SheetName = "表7-6"; fpSpread1.Sheets.Add(Sheet76); Sheet76_40.SheetName = "表7-6 附表40"; fpSpread1.Sheets.Add(Sheet76_40); Sheet77.SheetName = "表7-7"; fpSpread1.Sheets.Add(Sheet77); Sheet78.SheetName = "表7-8"; fpSpread1.Sheets.Add(Sheet78); Sheet79.SheetName = "表7-9"; fpSpread1.Sheets.Add(Sheet79); build_sheet71(fpSpread1.Sheets[0]); build_Sheet72(fpSpread1.Sheets[1]); build_Sheet72_36(fpSpread1.Sheets[2]); build_Sheet73(fpSpread1.Sheets[3]); build_Sheet73_37(fpSpread1.Sheets[4]); build_Sheet74(fpSpread1.Sheets[5]); build_Sheet74_38(fpSpread1.Sheets[6]); build_Sheet75(fpSpread1.Sheets[7]); build_Sheet75_39(fpSpread1.Sheets[8]); build_Sheet76(fpSpread1.Sheets[9]); build_Sheet76_40(fpSpread1.Sheets[10]); build_Sheet77(fpSpread1.Sheets[11]); build_Sheet78(fpSpread1.Sheets[12]); build_Sheet79(fpSpread1.Sheets[13]); }