C# Itop类代码示例

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

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

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

示例1: 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

示例2: 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

示例3: 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

示例4: 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

示例5: 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

示例6: 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

示例7: 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

示例8: SetSheet_13Title

        //////////////////////////////////////////////////////////////////////////
        /// <summary>
        /// 填写表头
        /// </summary>
        /// <param name="obj"></param>
        /// <param name="Title"></param>
        public void SetSheet_13Title(Itop.Client.Base.FormBase FB, FarPoint.Win.Spread.SheetView obj, string Title)
        {
            int IntColCount = 3;
            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;
                     default:
                        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);//行高
        }

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

示例9: AddBarEditItems

 /// <summary>
 /// add BareditItems of years
 /// </summary>
 /// <param name="BE">BarEditItem object</param>
 public void AddBarEditItems(DevExpress.XtraBars.BarEditItem BE, DevExpress.XtraBars.BarEditItem BE1, Itop.Client.Base.FormBase FB)
 {
     IList list = SelectProgramme(FB);
     Ps_forecast_list pfl = null;
     //BE.EditValue = "2000";
     for(int i=0;i<list.Count;++i)
     {
         pfl = (Ps_forecast_list)list[i];
         ((DevExpress.XtraEditors.Repository.RepositoryItemComboBox)BE.Edit).Items.Add(pfl.Title);
         ((DevExpress.XtraEditors.Repository.RepositoryItemComboBox)BE1.Edit).Items.Add(pfl.ID);
     }
 }

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

示例10: PrintHelper

 public PrintHelper(ItopVectorControl tc, Itop.MapView.IMapViewObj map)
 {
     //int chose = Convert.ToInt32(ConfigurationSettings.AppSettings.Get("chose"));
     //if (chose == 1)
     //{ map = new Itop.MapView.MapViewObj(); }
     //else if (chose == 2)
     //{ map = new Itop.MapView.MapViewObj2(); }
     tlVectorControl1 = tc;
     mapview = map;
     pdoc = new PrintDocument();
     pdoc.PrintPage += new PrintPageEventHandler(pdoc_PrintPage);
     pageSetting = pdoc.PrinterSettings.DefaultPageSettings;
 }

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

示例11: AddLookUpEditValue

 /// <summary>
 /// 这个是用lookupEdit控件的方法现在没有用这个控件
 /// </summary>
 /// <param name="LE"></param>
 /// <param name="FB"></param>
 public void AddLookUpEditValue(DevExpress.XtraEditors.LookUpEdit LE, Itop.Client.Base.FormBase FB)
 {
     IList list = SelectProgramme(FB);
     Ps_forecast_list pfl = null;
     LE.EditValue = list;
     //BE.EditValue = "2000";
     //for (int i = 0; i < list.Count; ++i)
     //{
     //    pfl = (Ps_forecast_list)list[i];
     //    LE.EditValue = pfl;
     //    //((DevExpress.XtraEditors.Repository.RepositoryItemComboBox)LE.EditValue).Items.Add(pfl.Title);
     //}
 }

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

示例12: SetSheet_8Title

        //////////////////////////////////////////////////////////////////////////
        /// <summary>
        /// 填写表头
        /// </summary>
        /// <param name="obj"></param>
        /// <param name="Title"></param>
        public void SetSheet_8Title(Itop.Client.Base.FormBase FB, FarPoint.Win.Spread.SheetView obj, string Title)
        {
            int IntColCount = 1;
            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);

            NextRowMerge = 1;
            NextColMerge = 1;

            IntRow = 5;
            IntCol = 0;
            //PF.SetWholeRowHeight(obj, obj.Rows.Count, obj.Columns.Count);//行高
        }

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

示例13: SelectCurrentData

 /// <summary>
 /// 找到当前列的数据
 /// </summary>
 /// <param name="obj"></param>
 /// <param name="CurrentYear">列标题包括（当前年份，土地面积）</param>
 /// <param name="strTitle">指标名称</param>
 private object SelectCurrentData(Itop.Client.Base.FormBase FB, string CurrentYear, string strTitle,string BeginYear)
 {
     string sql = null;
     string sql1 = null;
     string ID = null;
     object value = 0;
     //先找到地区的id
     sql = " ProjectId='" + FB.ProjectUID + "' and Area='" + strTitle + "'";
     try
     {
         ID = (string)Services.BaseService.GetObject("SelectAreaDataOfID", sql);
     }
     catch (System.Exception e)
     {
         MessageBox.Show(e.Message);
     }
     if(CurrentYear=="面积")
     {
         sql1 = "select TotalArea from ps_table_AreaData where parentId='" + ID + "' and ProjectId='" + FB.ProjectUID + "' and yearf='" + BeginYear + "'";
     }
     else
     {
         sql1 = "select population from ps_table_AreaData where parentId='" + ID + "' and ProjectId='" + FB.ProjectUID + "' and yearf='" + CurrentYear + "'";
     }
     try
     {
         value = (double)Services.BaseService.GetObject("SelectAreaDataOfCurrent", sql1);
     }
     catch (Exception e)
     {
         //MessageBox.Show("错误，错误原因："+ e.Message,"提示错误",MessageBoxButtons.OK,MessageBoxIcon.Information);
     }
     return value;
 }

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

示例14: SelectProgramme

 /// <summary>
 /// 查询方案内容，给下拉菜单用
 /// </summary>
 private IList SelectProgramme(Itop.Client.Base.FormBase FB)
 {
     IList Programme = null;//方案
     //Ps_forecast_list report = new Ps_forecast_list();
     //report.UserID =FB. ProjectUID;
     Programme = Services.BaseService.GetList("SelectPs_forecast_listByUserID", FB.ProjectUID);
     return Programme;
 }

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

示例15: SetSheet_6Title

        //////////////////////////////////////////////////////////////////////////
        /// <summary>
        /// 填写表头
        /// </summary>
        /// <param name="obj"></param>
        /// <param name="Title"></param>
        public void SetSheet_6Title(Itop.Client.Base.FormBase FB, FarPoint.Win.Spread.SheetView obj, string Title)
        {
            SelectLine(FB, strYear);
            int IntColCount = 14;
            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 = " 中压线路名";
            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 = " 电压等级(kV) ";
            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 = " 线路总长度(km)";
            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 = " 架空线路长度(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);

            strTitle = " 最大电流(A)";
            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);//行高
        }

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

示例16: WriteData

 /// <summary>
 /// 写入数据
 /// </summary>
 /// <param name="obj"></param>
 /// <param name="IntRow"></param>
 /// <param name="IntCol"></param>
 private void WriteData(Itop.Client.Base.FormBase FB, FarPoint.Win.Spread.SheetView obj, int IntRow, int IntCol)
 {
     PSPDEV psDev = null;
     Object Value = null;
     for (int i = 0; i < list.Count; ++i)
     {
         psDev = (PSPDEV)list[i];
         SelectBDZ(FB, psDev.Name);
         for (int j = 0; j < obj.ColumnCount; ++j)
         {
             switch (j)
             {
                 case 0:
                     Value = i + 1;//序号
                     break;
                 case 1:
                     Value = psDev.Name;//中压线路名
                     break;
                 case 2:
                     if (BDZ == null)
                     {
                         Value = "";//BDZ1.Title;
                     }
                     else if (BDZ1 == null)
                     {
                         Value = "";// BDZ.Title;
                     }
                     else
                     {
                         Value = BDZ.Title + "," + BDZ1.Title;//变电站名
                     } break;
                 case 3:
                     Value = psDev.RateVolt;//电压等级(kV)
                     break;
                 case 4:
                     Value = psDev.LineType2;//线路属性
                     break;
                 case 5://***************************************
                    //干线长度(km)(A),手写
                     break;
                 case 6:
                     Value = psDev.Length2 + psDev.LineLength;//线路总长度(km)
                          break;
                 case 7:
                     Value = psDev.Length2;//电缆线路长度(km)
                      break;
                 case 8:
                     Value = psDev.LineLength;//架空线路长度(km)
                     break;
                 case 9:
                     Value = psDev.LineType;//主干线型号
                     break;
                 case 10:
                     if (psDev.LineLength > psDev.Length2)
                         Value = "架空";//架设方式
                     else
                         Value = "电缆";
                     break;
                 case 11:
                     Value = psDev.Burthen * 1000;//最大电流(A)
                     break;
                 case 12:
                     Value =psDev.OperationYear;//线路投运时间
                     break;
                 default:
                     break;
             }
             if(j==obj.ColumnCount-1||j==5)
             {
                 obj.Cells[IntRow + i, j].Locked = false;
             }
             else
             {
                 obj.SetValue(IntRow + i, j, Value);//
             }
         }
     }
 }

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

示例17: SelectLine

 /// <summary>
 /// 寻找线路所有数据
 /// </summary>
 private void SelectLine(Itop.Client.Base.FormBase FB, string year)
 {
     string con = " where IName!=''and JName!=''and RateVolt<'35' and Type='05'  and ProjectID='" + FB.ProjectUID + "' and OperationYear <='" + year + "'";
     try
     {
         list = Services.BaseService.GetList("SelectPSPDEVByCondition", con);
     }
     catch (System.Exception e)
     {
         MessageBox.Show(e.Message);
     }
 }

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

示例18: SelectBDZ

 /// <summary>
 /// 查询变电站数据
 /// </summary>
 private void SelectBDZ(Itop.Client.Base.FormBase FB, string strName)
 {
     string sql = " AreaID='" + FB.ProjectUID + "'and uid in(select svguid from pspDEV where  ProjectID='" + FB.ProjectUID + "' and  Type='01'and Name in(select JName from pspdev where Name='" + strName + "'))";
     string sql1 = " AreaID='" + FB.ProjectUID + "'and uid in(select svguid from pspDEV where  ProjectID='" + FB.ProjectUID + "' and  Type='01'and Name in(select IName from pspdev where Name='" + strName + "'))";
     try
     {
         BDZ = (PSP_Substation_Info)Services.BaseService.GetObject("SelectPSP_Substation_InfoListByWhere", sql);
         BDZ1 = (PSP_Substation_Info)Services.BaseService.GetObject("SelectPSP_Substation_InfoListByWhere", sql1);
     }
     catch (System.Exception e)
     {
         MessageBox.Show(e.Message);
     }
 }

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

示例19: SetSheet_25Title

        //////////////////////////////////////////////////////////////////////////
        /// <summary>
        /// 填写表头
        /// </summary>
        /// <param name="obj"></param>
        /// <param name="Title"></param>
        public void SetSheet_25Title(Itop.Client.Base.FormBase FB, FarPoint.Win.Spread.SheetView obj, string Title)
        {
            int Temp = 0;
            int IntColCount = 6;
            SelectData(FB);
            int IntRowCount = HList.Count+Llist.Count+1 + 2 + 3;//标题占3行，分区类型占2行

            int BringIntoPproductionTime = 6;//投产时间的列数

            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;
            //列标题

            IntRow = 4;
            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 = "建设内容";
            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 = 6;
            IntCol = 0;
            //PF.SetWholeRowHeight(obj, obj.Rows.Count, obj.Columns.Count);//行高
            //SetLeftTitle();
            WriteData(obj,IntRow);
        }

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

示例20: SelectData

 /// <summary>
 /// 查询 高压 ，中低压数据 
 /// </summary>
 /// <param name="FB"></param>
 private void SelectData(Itop.Client.Base.FormBase FB)
 {
     string sql = "select a.* FROM Ps_Table_TZGS a,Ps_Table_TZGS b,Ps_Table_TZGS c,Ps_Table_TZGS d"
                 + "  where  a.ID = b.ParentID AND b.Col4 = 'pw-line'"
                 + "  AND a.ID = c.ParentID AND c.Col4 = 'pw-pb'"
                 + "  and a.ID = d.ParentID AND d.Col4 = 'pw-kg'"
                 + "    and a.ProjectID='"+FB.ProjectUID+"'"
                 + "    and a.BuildEd between '2010' and '2015'";
     string sql1 = "Select a.*  FROM  Ps_Table_TZGS a INNER JOIN"
                  +" Ps_Table_TZGS b ON a.ID = b.ParentID INNER JOIN"
                  +" Ps_Table_TZGS c ON a.ID = c.ParentID"
                  +" where b.Col4 = 'bian' and c.Col4='line'and "
                  + "   a.ProjectID='" + FB.ProjectUID + "'and a.BuildEd between '2010' and '2015'";
     try
     {
         Llist = Services.BaseService.GetList("SelectTZGSEveryField", sql);//低压数据
         HList = Services.BaseService.GetList("SelectTZGSEveryField", sql1);//高压数据
     }
     catch (System.Exception e)
     {
         MessageBox.Show(e.Message);
     }
 }

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

注：本文中的Itop类示例整理自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# JArray类代码示例发布时间：2022-05-24

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

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

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

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

阅读：18084|2023-10-27

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

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

阅读：9615|2022-11-06

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

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

阅读：8147|2022-11-06

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

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

阅读：8530|2022-11-06

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

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

阅读：8432|2022-11-06

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

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

阅读：9344|2022-11-06

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

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

阅读：8396|2022-11-06

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

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

阅读：7833|2022-11-06

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

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

阅读：8387|2022-11-06

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

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

阅读：7380|2022-11-06

客服电话

电子邮件

C# Itop类代码示例

示例1: SelectEditChange

示例2: SetColumnsTitle

示例3: SelectEditChange

示例4: SetYears

示例5: SelectEditChange

示例6: SetSheet_1Title

示例7: SetColumnsTitle

示例8: SetSheet_13Title

示例9: AddBarEditItems

示例10: PrintHelper

示例11: AddLookUpEditValue

示例12: SetSheet_8Title

示例13: SelectCurrentData

示例14: SelectProgramme

示例15: SetSheet_6Title

示例16: WriteData

示例17: SelectLine

示例18: SelectBDZ

示例19: SetSheet_25Title

示例20: SelectData

请发表评论

全部评论

上一篇：

下一篇：

solegalli/feature-selection-for-machine-

tianli/matlab_offscreen: Matlab offscree

win7系统重装系统初始设置的操作方法

これがマストドンだ！ 使い方からインスタ

matlab如何将画的图复制到word中

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

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

florent37/ViewAnimator: A fluent Android

florent37/Shrine-MaterialDesign2: implem

CVE-2020-36276

SimpleSoftwareIO/simple-sms: Send and re

关于我们

产品与服务

解决方案

139-2527-9053

これがマストドンだ！使い方からインスタ