C# FarPoint类代码示例

原作者: [db:作者] 来自: [db:来源] 收藏邀请

本文整理汇总了C#中FarPoint类的典型用法代码示例。如果您正苦于以下问题：C# FarPoint类的具体用法？C# FarPoint怎么用？C# FarPoint使用的例子？那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。

FarPoint类属于命名空间，在下文中一共展示了FarPoint类的20个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于我们的系统推荐出更棒的C#代码示例。

示例1: CellType

        public void CellType(FarPoint.Win.Spread.SheetView obj_sheet)
        {
            for (int row = 2; row < 8; row++)
            {
                if (row!=3)
                {
                    for (int col = 3; col < 6; col++)
                    {
                        fc.Sheet_UnLockedandCellNumber(obj_sheet, row, col);
                    }
                    for (int col = 11; col < 13; col++)
                    {
                        fc.Sheet_UnLockedandCellNumber(obj_sheet, row, col);
                    }
                }
                for (int col = 6; col < 11; col++)
                {
                    fc.Sheet_UnLockedandCellNumber(obj_sheet, row, col);
                    if (col!=6)
                    {
                        obj_sheet.Cells[row, col].CellType = new FarPoint.Win.Spread.CellType.PercentCellType();
                    }

                }
            }
        }

开发者ID:EdgarEDT，项目名称:myitoppsp，代码行数:26，代码来源:Sheet32.cs

示例2: Build

        public void Build(FarPoint.Win.Spread.SheetView obj_sheet,int year,string ProjID,List<string[]> SxXjName)
        {
            //表格共10 行8 列
            rowcount = 10;
            colcount = 8;
            //工作表第一行的标题
            title = "表3‑4  "+year+"年铜陵市并网电厂装机容量表（MW）";
            //工作表名
            sheetname = "表3-4";
            //设定工作表行列值及标题和表名
            fc.Sheet_RowCol_Title_Name(obj_sheet, rowcount, colcount, title, sheetname);
            //设定表格线
            fc.Sheet_GridandCenter(obj_sheet);
            //设定行列模式，以便写公式使用
            fc.Sheet_Referen_R1C1(obj_sheet);
            //设定表格列宽度
            obj_sheet.Columns[0].Width = 60;
            obj_sheet.Columns[1].Width = 110;
            obj_sheet.Columns[2].Width = 80;
            obj_sheet.Columns[3].Width = 80;
            obj_sheet.Columns[4].Width = 80;
            obj_sheet.Columns[5].Width = 80;
            obj_sheet.Columns[6].Width = 80;
            obj_sheet.Columns[7].Width = 80;
            //设定表格行高度

            obj_sheet.Rows[1].Height = 20;
            obj_sheet.Rows[2].Height = 20;
            //写标题行列内容
            Sheet_AddItem(obj_sheet, SxXjName);
            //写入数据
            Sheet_AddData(obj_sheet, year, ProjID, SxXjName);
            //锁定表格
            fc.Sheet_Locked(obj_sheet);
        }

开发者ID:EdgarEDT，项目名称:myitoppsp，代码行数:35，代码来源:Sheet34.cs

示例3: AddData

        /// <summary>
        /// 加载数据同时保存数据到指定位置
        /// </summary>
        /// <param name="obj"></param>
        private void AddData(FarPoint.Win.Spread.FpSpread obj)
        {
            wait = new WaitDialogForm("", "正在加载数据, 请稍候...");
            try
            {
                //打开Excel表格
                //清空工作表
                fpSpread1.Sheets.Clear();
                obj.OpenExcel(System.Windows.Forms.Application.StartupPath + "\\xls\\中压配电网分析.xls");
                PF.SpreadRemoveEmptyCells(obj);
                //this.AddCellChanged();
                //this.barEditItem2.Visibility = DevExpress.XtraBars.BarItemVisibility.Never;
                //S4_2_1.AddBarEditItems(this.barEditItem2, this.barEditItem1, this);
            }
            catch (System.Exception e)
            {
                //如果打开出错则重新生成并保存
                LoadData();
                //判断文件夹是否存在，不存在则创建
                if (!Directory.Exists(System.Windows.Forms.Application.StartupPath + "\\xls"))
                {
                    Directory.CreateDirectory(System.Windows.Forms.Application.StartupPath + "\\xls");
                }
                //保存EXcel文件
                obj.SaveExcel(System.Windows.Forms.Application.StartupPath + "\\xls\\中压配电网分析.xls", FarPoint.Excel.ExcelSaveFlags.NoFlagsSet);
                // 定义要使用的Excel 组件接口
                // 定义Application 对象,此对象表示整个Excel 程序
                Microsoft.Office.Interop.Excel.Application excelApp = null;
                // 定义Workbook对象,此对象代表工作薄
                Microsoft.Office.Interop.Excel.Workbook workBook;
                // 定义Worksheet 对象,此对象表示Execel 中的一张工作表
                Microsoft.Office.Interop.Excel.Worksheet ws = null;
                Microsoft.Office.Interop.Excel.Range range = null;
                excelApp = new Microsoft.Office.Interop.Excel.Application();
                string filename = System.Windows.Forms.Application.StartupPath + "\\xls\\中压配电网分析.xls";
                workBook = excelApp.Workbooks.Open(filename, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);
                for (int i = 1; i <= workBook.Worksheets.Count; i++)
                {

                    ws = (Microsoft.Office.Interop.Excel.Worksheet)workBook.Worksheets[i];
                    //取消保护工作表
                    ws.Unprotect(Missing.Value);
                    //有数据的行数
                    int row = ws.UsedRange.Rows.Count;
                    //有数据的列数
                    int col = ws.UsedRange.Columns.Count;
                    //创建一个区域
                    range = ws.get_Range(ws.Cells[1, 1], ws.Cells[row, col]);
                    //设区域内的单元格自动换行
                    range.WrapText = true;
                    //保护工作表
                    ws.Protect(Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);
                }
                //保存工作簿
                workBook.Save();
                //关闭工作簿
                excelApp.Workbooks.Close();
            }
            wait.Close();
        }

开发者ID:EdgarEDT，项目名称:myitoppsp，代码行数:64，代码来源:FrmMediumVoltageDistributionNetworkParsing.cs

示例4: Sheet_AddData

 private void Sheet_AddData(FarPoint.Win.Spread.SheetView obj_sheet, int year, string ProjID)
 {
     //对于线路信息，OperationYear中存放的投产年份,Type='05'表示线路信息
     //LineType2存放的公用专用标识,RateVolt存放电压,为float类型
     //JXFS为接线方式,如环网、链式等
     string XLtiaojian = "";
     string[] JGType = { "环网", "放射型", "链式", "T型", "其它" };
     string JGLX = "";
     string DianYa = "";
     for (int row = 2; row < 11; row++)
     {
         for (int col = 2; col <= 3; col++)
         {
             JGLX = JGType[(row / 2) - 1];
             if (col == 2)
             {
                 DianYa = "110";
             }
             else
             {
                 DianYa = "35";
             }
             XLtiaojian = " OperationYear!='' and  year(cast(OperationYear as datetime))<=" + year + " and  Type='05' and  LineType2='公用' and RateVolt=" + DianYa + " and ProjectID='" + ProjID + "' and JXFS='" + JGLX + "'";
             int XLsum = 0;
             if (Services.BaseService.GetObject("SelectPSPDEV_CountAll", XLtiaojian) != null)
             {
                 XLsum = (int)Services.BaseService.GetObject("SelectPSPDEV_CountAll", XLtiaojian);
             }
             obj_sheet.SetValue(row, col, XLsum);
         }
         row++;
     }
 }

开发者ID:EdgarEDT，项目名称:myitoppsp，代码行数:33，代码来源:Sheet36.cs

示例5: SelectEditChange

        /// <summary>
        /// 选中下拉菜单中的数据连接数据库表,方案
        /// </summary>
        /// <param name="BE"></param>
        public void SelectEditChange(FarPoint.Win.Spread.FpSpread fPobj,FarPoint.Win.Spread.SheetView SheetView, object obj, Itop.Client.Base.FormBase FB)
        {
            //string strTitle = null;
            string strID = obj.ToString();
            InitTitle();
            //Ps_forecast_list pfl = null;
            projectID = FB.ProjectUID;
            //string con1 = "Title='" + strTitle + "' and UserID='" + projectID + "'";
            try
            {
                //查询下拉菜单所选中的数据
                //pfl = (Ps_forecast_list)Services.BaseService.GetObject("SelectPs_forecast_listByWhere", con1);
                //programID = pfl.ID;
                programID = strID;
                CityID = SelectID(strID, AreaType[0]);//市辖
                CountyID = SelectID(strID, AreaType[1]);//县级
                SelectDQ(CityID, AreaType[0]);
                SelectDQ(CountyID, AreaType[1]);
                SetLeftTitle(SheetView, 5, 0);//左侧标题
                WriteData(fPobj,SheetView, 5, 0);//数据

                PF.Sheet_GridandCenter(SheetView);//画边线，居中
                S10_1.ColReadOnly(SheetView, SheetView.Columns.Count);
                PF.SetWholeRowHeight(SheetView, SheetView.Rows.Count, SheetView.Columns.Count);//行高
            }
            catch (System.Exception e)
            {
                MessageBox.Show(e.Message);
            }
        }

开发者ID:EdgarEDT，项目名称:myitoppsp，代码行数:34，代码来源:Sheet4_4_1.cs

示例6: SetYears

        /// <summary>
        /// 设置年分
        /// </summary>
        ///<param name="FB">传入fromBase对象</param>
        /// <param name="obj">要传入SheetView对象</param>
        /// <param name="IntRow">行数</param>
        /// <param name="IntCol">列数</param>
        /// <param name="RowStep">要合并几个行的单元格</param>
        /// <param name="ColStep">要合并几个列的单元格</param>
        /// <param name="Title">标题</param>
        public void SetYears(string Title, Itop.Client.Base.FormBase FB, FarPoint.Win.Spread.SheetView obj, int IntRow, int IntCol, int RowStep, int ColStep)
        {
            GlobalFormBase = FB;
            Ps_YearRange py = new Ps_YearRange();
            py.Col4 = Title;
            py.Col5 = FB.ProjectUID;

            IList<Ps_YearRange> li = Services.BaseService.GetList<Ps_YearRange>("SelectPs_YearRangeByCol5andCol4", py);
            if (li.Count > 0)
            {
                GlobalFirstYear = li[0].StartYear;
                GlobalEndYear = li[0].FinishYear;
            }
            else
            {
                GlobalFirstYear = 2000;
                GlobalEndYear = 2009;
                py.BeginYear = 1990;
                py.FinishYear = GlobalEndYear;
                py.StartYear = GlobalFirstYear;
                py.EndYear = 2060;
                py.ID = Guid.NewGuid().ToString();
                Services.BaseService.Create<Ps_YearRange>(py);
            }
            GolobalYearCount = GlobalEndYear - GlobalFirstYear + FixationCol + 1;//后面有两个固定列,加1是起始年的加入
            SetYearsSheet2_1(FB, obj, GlobalFirstYear, GlobalEndYear, GolobalYearCount, IntRow, IntCol, RowStep, ColStep);
        }

开发者ID:EdgarEDT，项目名称:myitoppsp，代码行数:37，代码来源:Sheet2_N.cs

示例7: Build

 public void Build(FarPoint.Win.Spread.SheetView obj_sheet, string ProjID, List<string[]> SxXjName)
 {
     //表格共9 行9 列
     rowcount = 9;
     colcount = 9;
     //工作表第一行的标题
     title = "表5‑2  铜陵市接入110kV及以下配电网的新能源电厂装机容量情况（MW）";
     //工作表名
     sheetname = "表5‑2";
     //设定工作表行列值及标题和表名
     fc.Sheet_RowCol_Title_Name(obj_sheet, rowcount, colcount, title, sheetname);
     //设定表格线
     fc.Sheet_GridandCenter(obj_sheet);
     //设定行列模式，以便写公式使用
     fc.Sheet_Referen_R1C1(obj_sheet);
     //设定表格列宽度
     obj_sheet.Columns[0].Width = 60;
     obj_sheet.Columns[1].Width = 100;
     obj_sheet.Columns[2].Width = 90;
     obj_sheet.Columns[3].Width = 90;
     obj_sheet.Columns[4].Width = 90;
     obj_sheet.Columns[5].Width = 90;
     obj_sheet.Columns[6].Width = 90;
     obj_sheet.Columns[7].Width = 90;
     obj_sheet.Columns[8].Width = 90;
     //设定表格行高度
     obj_sheet.Rows[1].Height = 20;
     //写标题行列内容
     Sheet_AddItem(obj_sheet, SxXjName);
     //写入数据
     Sheet_AddData(obj_sheet, ProjID, SxXjName);
     //锁定表格
     fc.Sheet_Locked(obj_sheet);
 }

开发者ID:EdgarEDT，项目名称:myitoppsp，代码行数:34，代码来源:Sheet52.cs

示例8: Build

 public void Build(FarPoint.Win.Spread.SheetView obj_sheet,int year,string ProjID,List<string[]> SxXjName)
 {
     //表格共14 行4 列
     rowcount = 14;
     colcount = 4;
     //工作表第一行的标题
     title = "表3‑6 " + year + "年铜陵市高压配电网结构情况";
     //工作表名
     sheetname = "表3-6";
     //设定工作表行列值及标题和表名
     fc.Sheet_RowCol_Title_Name(obj_sheet, rowcount, colcount, title, sheetname);
     //设定表格线
     fc.Sheet_GridandCenter(obj_sheet);
     //设定行列模式，以便写公式使用
     fc.Sheet_Referen_R1C1(obj_sheet);
     //设定表格列宽度
     obj_sheet.Columns[0].Width = 80;
     obj_sheet.Columns[1].Width = 160;
     obj_sheet.Columns[2].Width = 150;
     obj_sheet.Columns[3].Width = 150;
     //写行列标题
     Sheet_AddItem(obj_sheet);
     //写入数据
     Sheet_AddData(obj_sheet,year,ProjID);
     //写入公式
     //求和公式
     fc.Sheet_WriteFormula_RowSum(obj_sheet, 2, 2, 5, 2, 12, 2, 2);
     //分项求比例公式
     fc.Sheet_WriteFormula_Percent_Row(obj_sheet, 2, 2, 1, 3, 2, 5, 2, 12);
     //总和求比例公式
     fc.Sheet_WriteFormula_Percent_Row(obj_sheet, 12, 2, 0, 13, 2, 1, 2, 12);
     //锁定表格
     fc.Sheet_Locked(obj_sheet);
 }

开发者ID:EdgarEDT，项目名称:myitoppsp，代码行数:34，代码来源:Sheet36.cs

示例9: SetColumnsTitle

        /// <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,string CurrentYear)
        {
            int intTemp = BeginYear;
            Redraw(FB, obj, BeginYear, EndYear, CurrentYear);

            WriteData(FB, obj, CurrentYear);
        }

开发者ID:EdgarEDT，项目名称:myitoppsp，代码行数:12，代码来源:Sheet3.cs

示例10: SelectEditChange

        /// <summary>
        /// 选中下拉菜单中的数据连接数据库表,方案
        /// </summary>
        /// <param name="BE"></param>
        public void SelectEditChange(FarPoint.Win.Spread.FpSpread  fPobj,FarPoint.Win.Spread.SheetView SheetView, object obj, Itop.Client.Base.FormBase FB)
        {
            string strID = null;
            //strTitle = obj.EditValue.ToString();
            strID=obj.ToString();
            Ps_forecast_list pfl = null;
            projectID = FB.ProjectUID;
            string con1 = "ID='" + strID + "' and UserID='" + projectID + "'";
            try
            {
                //查询下拉菜单所选中的数据
                pfl = (Ps_forecast_list)Services.BaseService.GetObject("SelectPs_forecast_listByWhere", con1);
                programID = pfl.ID;
                SetLeftTitle(SheetView, 5, 0);//左侧标题
                WriteData(SheetView, 5, 0);//数据
                S4_3.WriteData(fPobj,fPobj.Sheets[4], 5, 0);

                PF.Sheet_GridandCenter(SheetView);//画边线，居中
                S10_1.ColReadOnly(SheetView, SheetView.Columns.Count);
                PF.SetWholeRowHeight(SheetView, SheetView.Rows.Count, SheetView.Columns.Count);//行高
            }
            catch (System.Exception e)
            {
                //MessageBox.Show(e.Message);
            }
        }

开发者ID:EdgarEDT，项目名称:myitoppsp，代码行数:30，代码来源:Sheet4_2.cs

示例11: ColReadOnly

 /// <summary>
 /// 设置某列为只读
 /// </summary>
 /// <param name="obj">sheetView对象</param>
 /// <param name="IntCol">列数</param>
 public void ColReadOnly(FarPoint.Win.Spread.SheetView obj, int IntCol)
 {
     for (int i = 0; i < IntCol; i++)
     {
             obj.Columns[i].Locked = true;//列设置为只读
     }
 }

开发者ID:EdgarEDT，项目名称:myitoppsp，代码行数:12，代码来源:Sheet10_1.cs

示例12: SelectEditChange

 /// <summary>
 /// 选中下拉菜单中的数据连接数据库表,方案
 /// </summary>
 /// <param name="BE"></param>
 public void SelectEditChange(FarPoint.Win.Spread.SheetView SheetView, object obj, Itop.Client.Base.FormBase FB)
 {
     string strTitle = null;
     string strID = null;
     strID = obj.ToString();
     Ps_forecast_list pfl=null;
     string con1 = "ID='" + strID + "' and UserID='" + FB.ProjectUID + "'";
     try
     {
         //查询下拉菜单所选中的数据
         pfl = (Ps_forecast_list)Services.BaseService.GetObject("SelectPs_forecast_listByWhere", con1);
         strTitle = pfl.Title;
        //“十二五”电网投资（千瓦时/元）
        dTwelveFiveGridInvestment=TwelveFiveGridInvestment(pfl.ID, strTitle, FB);
        //(2015年网供最大负荷－2010年网供最大负荷)
        dNetworkMaxDuty=NetworkMaxDuty(pfl.ID, strTitle);
        //2015-2010年售电收入
        dSaleOfElectricity=SaleOfElectricity(pfl.ID, strTitle);
        //（电网2010年末资产原值+2015年电网年末资产原值）
        dInitialAssetValue=InitialAssetValue(pfl.ID, strTitle);
         //单年售电量
        dYearSaleEletricity=YearSaleEletricity(pfl.ID, strTitle, 2015);
        WriteData(SheetView, 5, 0);//数据
        }
     catch(System.Exception e)
     {
         //MessageBox.Show(e.Message);
     }
 }

开发者ID:EdgarEDT，项目名称:myitoppsp，代码行数:33，代码来源:Sheet10_11.cs

示例13: SetSheet_1Title

        //////////////////////////////////////////////////////////////////////////
        /// <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, bool IsTrue)
        {
            SelectValue(FB);
            int IntColCount = 5;
            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)";
            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 = " 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;

            IntRow = 5;
            IntCol = 0;
            SetLeftTitle(obj, IntRow, IntCol);
            if(!IsTrue)
            {
                WriteData(obj, IntRow, IntCol);
            }
            else//更新
            {
                ComparisonData(obj, 5, 2);
                WriteData(obj, IntRow, IntCol);
            }
            PF.SetWholeRowHeight(obj, obj.Rows.Count, obj.Columns.Count);//行高
        }

开发者ID:EdgarEDT，项目名称:myitoppsp，代码行数:66，代码来源:Sheet_1.cs

示例14: LockSheets

 /// <summary>
 /// 用来全部锁住工作簿的单元格
 /// </summary>
 /// <param name="obj"></param>
 public void LockSheets(FarPoint.Win.Spread.SheetView obj)
 {
     for(int j=0;j<obj.ColumnCount;++j)
     {
         obj.Columns[j].Locked = true;
     }
 }

开发者ID:EdgarEDT，项目名称:myitoppsp，代码行数:11，代码来源:PublicFunction.cs

示例15: Build

        public void Build(FarPoint.Win.Spread.SheetView obj_sheet,int year,string ProjID,List<string[]> SxXjName)
        {
            //表格共9 行6 列
            rowcount = 9;
            colcount = 6;
            //工作表第一行的标题
            title = "表3‑5  " + year + "年铜陵市220kV或330kV电网规模";
            //工作表名
            sheetname = "表3-5";
            //设定工作表行列值及标题和表名
            fc.Sheet_RowCol_Title_Name(obj_sheet, rowcount, colcount, title, sheetname);
            //设定表格线
            fc.Sheet_GridandCenter(obj_sheet);
            //设定行列模式，以便写公式使用
            fc.Sheet_Referen_R1C1(obj_sheet);
            //设定表格列宽度
            obj_sheet.Columns[0].Width = 60;
            obj_sheet.Columns[1].Width = 110;
            obj_sheet.Columns[2].Width = 80;
            obj_sheet.Columns[3].Width = 80;
            obj_sheet.Columns[4].Width = 80;
            obj_sheet.Columns[5].Width = 80;

            //添加行列标题
            Sheet_AddItem(obj_sheet);
            //添加数据
            Sheet_AddData(obj_sheet,year,ProjID);
            //写求和公式
            fc.Sheet_WriteFormula_RowSum(obj_sheet, 6, 2, 2, 1, 8, 2, 4);

            //锁定表格
            fc.Sheet_Locked(obj_sheet);
        }

开发者ID:EdgarEDT，项目名称:myitoppsp，代码行数:33，代码来源:Sheet35.cs

示例16: Build

        public void Build(FarPoint.Win.Spread.SheetView obj_sheet, string ProjID)
        {
            //计算市辖供电区条件
            string SXtiaojianarea = " AreaID='" + ProjID + "' and (S10='水电' or S10='煤电') and S9!='' and CAST(S1 as int) between 10 and 110 and S3!='' and  S5='市辖供电区'  group by S9";
            //计算县级供电区条件
            string XJtiaojianarea = " AreaID='" + ProjID + "' and (S10='水电' or S10='煤电') and S9!='' and CAST(S1 as int) between 10 and 110 and S3!='' and  S5!='市辖供电区'  group by S9";
            //存放市辖供电区分区名
            IList<string> SXareaid_List = Services.BaseService.GetList<string>("SelectPSP_PowerSubstation_Info_GroupS9", SXtiaojianarea);
            //存放县级供电区分区名
            IList<string> XJareaid_List = Services.BaseService.GetList<string>("SelectPSP_PowerSubstation_Info_GroupS9", XJtiaojianarea);

            //计算市辖电区电厂个数条件
            string SXtiaojian = " AreaID='" + ProjID + "' and (S10='水电' or S10='煤电') and S9!='' and CAST(S1 as int) between 10 and 110 and S3!='' and  S5='市辖供电区'";
            //计算县级供电区电厂个数条件
            string XJtiaojian = " AreaID='" + ProjID + "' and (S10='水电' or S10='煤电') and S9!='' and CAST(S1 as int) between 10 and 110 and S3!='' and  S5!='市辖供电区'";
            //市辖供电区电厂个数
            int SXsum = (int)Services.BaseService.GetObject("SelectPSP_PowerSubstation_InfoCountByObject", SXtiaojian);
            //县级供电区电厂个数
            int XJsum = (int)Services.BaseService.GetObject("SelectPSP_PowerSubstation_InfoCountByObject", XJtiaojian);
            //表标题行数
            int startrow = 3;

            //表格共10 行12 列
            rowcount = startrow+SXsum+XJsum;
            colcount = 12;
            //工作表第一行的标题
            title = "附表32  铜陵市接入110kV及以下配电网的电源规划方案";
            //工作表名
            sheetname = "表5-1 附表32";
            //设定工作表行列值及标题和表名
            fc.Sheet_RowCol_Title_Name(obj_sheet, rowcount, colcount, title, sheetname);
            //设定表格线
            fc.Sheet_GridandCenter(obj_sheet);
            //设定行列模式，以便写公式使用
            fc.Sheet_Referen_R1C1(obj_sheet);
            //设定表格列宽度
            obj_sheet.Columns[0].Width = 100;
            obj_sheet.Columns[1].Width = 110;
            obj_sheet.Columns[2].Width = 150;
            obj_sheet.Columns[3].Width = 60;
            obj_sheet.Columns[4].Width = 60;
            obj_sheet.Columns[5].Width = 60;
            obj_sheet.Columns[6].Width = 60;
            obj_sheet.Columns[7].Width = 60;
            obj_sheet.Columns[8].Width = 60;
            obj_sheet.Columns[9].Width = 60;
            obj_sheet.Columns[10].Width = 60;
            obj_sheet.Columns[11].Width = 60;
            //设定表格行高度
            obj_sheet.Rows[1].Height = 20;
            obj_sheet.Rows[2].Height = 20;
            //写标题行列内容
            Sheet_AddItem(obj_sheet, SXareaid_List, XJareaid_List);
            //写入数据
            Sheet_AddData(obj_sheet, ProjID, SXareaid_List, XJareaid_List);

            //锁定表格
            fc.Sheet_Locked(obj_sheet);
        }

开发者ID:EdgarEDT，项目名称:myitoppsp，代码行数:59，代码来源:Sheet51_32.cs

示例17: SetColumnsTitle

 /// <summary>
 /// 根据下拉菜单从新打印报表
 /// </summary>
 /// <param name="FB"></param>
 /// <param name="obj"></param>
 /// <param name="strEndYear"></param>
 public void SetColumnsTitle(Itop.Client.Base.FormBase FB, FarPoint.Win.Spread.SheetView obj,string strEndYear)
 {
     //查询变电站数据
     SelectBDZ(FB);
     SelectLine(FB,strEndYear,BDZList);
     //重绘
     ReDraw(FB,obj,strEndYear);
 }

开发者ID:EdgarEDT，项目名称:myitoppsp，代码行数:14，代码来源:Sheet6.cs

示例18: Build_Sheet

        public void Build_Sheet(FarPoint.Win.Spread.SheetView obj_sheet)
        {
            //���8 ��6 ��
            rowcount = 8;
            colcount = 6;
            //�������һ�еı���
            title = TC.GetTableTitle(this.GetType().Name);
            //�������й����
            //int[] TableYearsAry = TC.GetTableYears(this.GetType().Name);
            //��������
            sheetname = title;
            //�趨����������ֵ������ͱ���
            TC.Sheet_RowCol_Title_Name(obj_sheet, rowcount, colcount, title, sheetname);
            //�趨����ģʽ���Ա�д��ʽʹ��
            TC.Sheet_Referen_R1C1(obj_sheet);
            //�趨����п��
            obj_sheet.Columns[0].Width = 60;
            obj_sheet.Columns[1].Width = 100;
            obj_sheet.Columns[2].Width = 100;
            obj_sheet.Columns[3].Width = 80;
            obj_sheet.Columns[4].Width = 100;
            obj_sheet.Columns[5].Width = 80;
            //�趨����и߶�
            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.AddSpanCell(1, 1, 2, 1);
            obj_sheet.SetValue(1, 2, "������");
            obj_sheet.AddSpanCell(1, 3, 2, 1);
            obj_sheet.SetValue(1, 3, "�����ʣ�%��");
            obj_sheet.SetValue(1, 4, "���縺��");
            obj_sheet.AddSpanCell(1, 5, 2, 1);
            obj_sheet.SetValue(1, 5, "�����ʣ�%��");

            //3�б�������
            obj_sheet.SetValue(2, 2, "����ǧ��ʱ��");
            obj_sheet.SetValue(2, 4, "����ǧ�ߣ�");
            //д����������

            //1�б�������
            obj_sheet.SetValue(3, 0, "1");

            //2�б�������
            obj_sheet.SetValue(3, 1, "ȫ��");

            //�������
            Sheet_AddData(obj_sheet);

            //�趨�����
            TC.Sheet_GridandCenter(obj_sheet);

            //�������
            TC.Sheet_Locked(obj_sheet);
        }

开发者ID:EdgarEDT，项目名称:myitoppsp，代码行数:58，代码来源:Sheet221.cs

示例19: Build

        public void Build(FarPoint.Win.Spread.SheetView obj_sheet, int year, string ProjID, Hashtable area_key_id, List<string[]> SxXjName)
        {
            //计算市辖供电区条件
            string SXtiaojianarea = " AreaID='" + ProjID + "' and S9!='' and CAST(S1 as int) between 10 and 110 and CAST(S3 as int ) <=" + year + " and  S5='市辖供电区'  group by S9";
            //计算县级供电区条件
            string XJtiaojianarea = " AreaID='" + ProjID + "' and S9!='' and CAST(S1 as int) between 10 and 110 and CAST(S3 as int ) <=" + year + " and  S5!='市辖供电区'  group by S9";
            //存放市辖供电区分区名
            IList<string> SXareaid_List = Services.BaseService.GetList<string>("SelectPSP_PowerSubstation_Info_GroupS9", SXtiaojianarea);
            //存放县级供电区分区名
            IList<string> XJareaid_List = Services.BaseService.GetList<string>("SelectPSP_PowerSubstation_Info_GroupS9", XJtiaojianarea);

            //计算市辖电区电厂个数条件
            string SXtiaojian = " AreaID='" + ProjID + "' and S9!='' and CAST(S1 as int) between 10 and 110 and CAST(S3 as int ) <=" + year + " and  S5='市辖供电区'";
            //计算县级供电区电厂个数条件
            string XJtiaojian = " AreaID='" + ProjID + "' and S9!='' and CAST(S1 as int) between 10 and 110 and CAST(S3 as int ) <=" + year + " and  S5!='市辖供电区'";
            //市辖供电区电厂个数
            int SXsum = (int)Services.BaseService.GetObject("SelectPSP_PowerSubstation_InfoCountByObject", SXtiaojian);
            //县级供电区电厂个数
            int XJsum = (int)Services.BaseService.GetObject("SelectPSP_PowerSubstation_InfoCountByObject", XJtiaojian);
            //表标题行数
            int startrow = 2;

            //表格共10 行10 列
            rowcount = startrow+SXsum+XJsum+2;
            colcount = 10;
            //工作表第一行的标题
            title = "附表2  铜陵市电源装机容量及发电量情况（"+year+"年）（发策部、生技部）";
            //工作表名
            sheetname = "表3-4 附表2";
            //设定工作表行列值及标题和表名
            fc.Sheet_RowCol_Title_Name(obj_sheet, rowcount, colcount, title, sheetname);
            //设定表格线
            fc.Sheet_GridandCenter(obj_sheet);
            //设定行列模式，以便写公式使用
            fc.Sheet_Referen_R1C1(obj_sheet);
            //设定表格列宽度
            obj_sheet.Columns[0].Width = 90;
            obj_sheet.Columns[1].Width = 120;
            obj_sheet.Columns[2].Width = 120;
            obj_sheet.Columns[3].Width = 90;
            obj_sheet.Columns[4].Width = 70;
            obj_sheet.Columns[5].Width = 60;
            obj_sheet.Columns[6].Width = 60;
            obj_sheet.Columns[7].Width = 90;
            obj_sheet.Columns[8].Width = 60;
            obj_sheet.Columns[9].Width = 60;
            //设定表格行高度

            obj_sheet.Rows[1].Height = 40;
            //写标题行列内容
            Sheet_AddItem(obj_sheet, SXareaid_List, XJareaid_List);
            //写入数据
            Sheet_AddData(obj_sheet, year, ProjID, SXareaid_List, XJareaid_List);

            //锁定表格
            fc.Sheet_Locked(obj_sheet);
        }

开发者ID:EdgarEDT，项目名称:myitoppsp，代码行数:57，代码来源:Sheet34_2.cs

示例20: Build

 public void Build(FarPoint.Win.Spread.SheetView obj_sheet,int year,string ProjID,List<string[]> SxXjName)
 {
     //写标题行列内容
     //Sheet_AddItem(obj_sheet, SxXjName, DY_list);
     //写入数据
     //Sheet_AddData(obj_sheet, year, ProjID, SxXjName, DY_list);
     //锁定表格
     fc.Sheet_Locked(obj_sheet);
 }

开发者ID:EdgarEDT，项目名称:myitoppsp，代码行数:9，代码来源:Sheet主表.cs

注：本文中的FarPoint类示例整理自Github/MSDocs等源码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。

鲜花

握手

雷人

路过

鸡蛋

该文章已有0人参与评论

请发表评论

全部评论

专题导读

More+

10-27 六六分期app的软件客服如何联系？(六六分期

11-06 可心卡盟:win10系统火狐flash插件崩溃怎么

11-06 亲亲特价:怎么删除回收站图标

11-06 济南大学虚拟社区:鲁大师节能降温的具体办

11-06 xlueops.exe:无线网络安装向导

11-06 女斗合众国:win7系统cf与主机连接不稳定怎

11-06 0xc000022-[cf烟雾头]cf怎么调烟雾头

11-06 qizideyouhuo:应用程序无法正常启动0xc0000

11-06 ipz-185:win7系统vcf文件怎么打开

11-06 傻哥蹦迪:win10系统s4怎么打开usb调试

11-06 八神浩树gtaste:回收站清空了怎么恢复

11-06 妖尾之黑色守护:win10系统电脑没有1440x900

11-06 校园至尊魔王小说:win7系统浏览网页时字体

11-06 女斗合众国:win10系统访问共享文件夹提示请

11-06 tokyo hot n0654:恢复win7系统默认字体一招

11-06 雨酷仙境:设置win7系统转移临时文件夹腾出

11-06 阿穆纳伊之杖:win7系统开始菜单在右边还原

11-06 tunespotting:win10系统火狐flash插件总是

11-06 甘尔葛分析师：计谋网站seo关键词暴涨有什

11-06 蔡贵霖: 计谋网站seo关键词暴涨有什么秘密

11-06 博益网首页:ao3网页版进入不了解决方法

11-06 漏斗子专栏: 网站数据分析小白易懂精华篇

11-06 见证双虹怎么做:win7系统开启telnet命令的

11-06 颾狐蝶蜋:系统资源不足无法完成请求的服务

11-06 国光中学校歌:提交网站到alexa查询详细步骤

11-06 西安有情天:静态网页和动态网页的区别

11-06 红木雅尚斋:外部链接构造对网站的好处

11-06 前官礼遇：防止域名劫持–增强域安全性的10

11-06 密传二转答案: 中文分词算法有哪些

11-06 金泉家园邮编:百度快照劫持的表现及应对方

C# FarseerPhysics类代码示例发布时间：2022-05-24

C# FanKey类代码示例发布时间：2022-05-24

剪的笔顺,诠释剪的笔画,认识剪的部首

1 六六分期app的软件客服如何联系？(六六分期

六六分期app的软件客服如何联系？不知道吗？加qq群【895510560】即可！标题：六六分期

阅读：18011|2023-10-27

2 可心卡盟:win10系统火狐flash插件崩溃怎么

今天小编告诉大家如何处理win10系统火狐flash插件总是崩溃的问题，可能很多用户都不知

阅读：9587|2022-11-06

3 亲亲特价:怎么删除回收站图标

今天小编告诉大家如何对win10系统删除桌面回收站图标进行设置，可能很多用户都不知道

阅读：8136|2022-11-06

4 济南大学虚拟社区:鲁大师节能降温的具体办

今天小编告诉大家如何对win10系统电脑设置节能降温的设置方法，想必大家都遇到过需要

阅读：8520|2022-11-06

5 xlueops.exe:无线网络安装向导

我们在使用xp系统的过程中,经常需要对xp系统无线网络安装向导设置进行设置，可能很多

阅读：8424|2022-11-06

6 女斗合众国:win7系统cf与主机连接不稳定怎

今天小编告诉大家如何处理win7系统玩cf老是与主机连接不稳定的问题，可能很多用户都不

阅读：9323|2022-11-06

7 0xc000022-[cf烟雾头]cf怎么调烟雾头

电脑对日常生活的重要性小编就不多说了，可是一旦碰到win7系统设置cf烟雾头的问题，很

阅读：8387|2022-11-06

8 qizideyouhuo:应用程序无法正常启动0xc0000

我们在日常使用电脑的时候，有的小伙伴们可能在打开应用的时候会遇见提示应用程序无法

阅读：7820|2022-11-06

9 ipz-185:win7系统vcf文件怎么打开

今天小编告诉大家如何对win7系统打开vcf文件进行设置，可能很多用户都不知道怎么对win

阅读：8375|2022-11-06

10 傻哥蹦迪:win10系统s4怎么打开usb调试

今天小编告诉大家如何对win10系统s4开启USB调试模式进行设置，可能很多用户都不知道怎

阅读：7369|2022-11-06

客服电话

电子邮件

C# FarPoint类代码示例

示例1: CellType

示例2: Build

示例3: AddData

示例4: Sheet_AddData

示例5: SelectEditChange

示例6: SetYears

示例7: Build

示例8: Build

示例9: SetColumnsTitle

示例10: SelectEditChange

示例11: ColReadOnly

示例12: SelectEditChange

示例13: SetSheet_1Title

示例14: LockSheets

示例15: Build

示例16: Build

示例17: SetColumnsTitle

示例18: Build_Sheet

示例19: Build

示例20: Build

请发表评论

全部评论

上一篇：

下一篇：

librespeed/speedtest: Self-hosted Speedt

Atitit MATLAB 图像处理 经典书籍attilax总

avehtari/BDA_m_demos: Bayesian Data Anal

四维彩超怎么看性别？四维看男孩女孩诀窍

medfreeman/markdown-it-toc-and-anchor: m

剪的笔顺,诠释剪的笔画,认识剪的部首

六六分期app的软件客服如何联系？(六六分期

florent37/ViewAnimator: A fluent Android

florent37/Shrine-MaterialDesign2: implem

CVE-2020-36276

SimpleSoftwareIO/simple-sms: Send and re

关于我们

产品与服务

解决方案

139-2527-9053

Atitit MATLAB 图像处理经典书籍attilax总