예제 #1
0
 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)
 {
 }
예제 #2
0
        //此处为动态添加数据方法
        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;
            }
        }
예제 #3
0
 /// <summary>
 /// 清空指定的表
 /// </summary>
 private void SheetNClear(FarPoint.Win.Spread.SheetView obj)
 {
     obj.RowCount    = 0;
     obj.ColumnCount = 0;
 }
예제 #4
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("更新数据完成!");
        }
예제 #5
0
 /// <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]);
     }
 }
예제 #6
0
        /// <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();
        }
예제 #7
0
        /// <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();
        }
예제 #8
0
        /// <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);
        }
예제 #9
0
 protected virtual void SetMoneyed(FarPoint.Win.Spread.SheetView sheet, DataView dv)
 {
     dv.RowFilter = "BALANCE_ITEM='6'";
     this.SetFarpointValue(sheet, dv);
 }
예제 #10
0
 /// <summary>
 /// 增加药品项目
 /// </summary>
 /// <param name="item"></param>
 /// <param name="parms"></param>
 public int AddItem(FarPoint.Win.Spread.SheetView sv, int activeRow)
 {
     return(1);
 }
예제 #11
0
 /// <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);
 }
예제 #12
0
        //////////////////////////////////////////////////////////////////////////
        /// <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);//行高
        }
예제 #13
0
        /// <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;
                    }
                }
            }
        }
예제 #14
0
        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("更新数据完成!");
        }
예제 #15
0
        //////////////////////////////////////////////////////////////////////////
        /// <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);//行高
        }
예제 #16
0
        /// <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
        }
예제 #17
0
        //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);//行高
        }
예제 #18
0
        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);
        }
예제 #19
0
        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);
        }
예제 #20
0
        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);
        }
예제 #21
0
        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);
        }
예제 #22
0
 /// <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;
 }
예제 #23
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]);

            //移除空表
            fpSpread1.Sheets.Remove(activesheet);
            //还原当前表
            fpSpread1.ActiveSheet = obj_sheet;
            //设文本自动换行
            fc.Sheet_Colautoenter(fpSpread1);
            newwait.Close();
            MessageBox.Show("更新数据完成!");
        }
예제 #24
0
        /// <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;
                }
            }
        }
예제 #25
0
        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("更新数据完成!");
        }
예제 #26
0
        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, "县级供电区");
            }
        }
예제 #27
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);
                    }
                }
            }
        }
예제 #28
0
 /// <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();
 }
예제 #29
0
 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)
 {
 }
예제 #30
0
        //////////////////////////////////////////////////////////////////////////
        /// <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);//行高
        }
예제 #31
0
        /// <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;
                    }
                }
            }
        }
예제 #32
0
        /// <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);
        }
예제 #33
0
        /// <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;
                        }
                    }
                }
            }
        }
예제 #34
0
        /// <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);//行高
        }
예제 #35
0
        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);
        }
예제 #36
0
        //////////////////////////////////////////////////////////////////////////
        /// <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);//行高
        }
예제 #37
0
 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("更新数据完成!");
 }
예제 #38
0
        /// <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
            }
        }
예제 #39
0
        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("更新数据完成!");
        }
예제 #40
0
        /// <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);//行高
        }
예제 #41
0
        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("更新数据完成!");
        }
예제 #42
0
        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);
            }
        }
예제 #43
0
        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);
        }
예제 #44
0
        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");
        }
예제 #45
0
        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);
        }
예제 #47
0
        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);
        }
예제 #48
0
        /// <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("更新数据完成!");
        }
예제 #49
0
        /// <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();
        }
예제 #50
0
        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]);
        }