コード例 #1
0
        private void AppendToXlscell(ReportFile RF, int index, ReportFileColumns RFC)
        {
            ISheet sheet1   = RF.hssfworkbook.GetSheet("Sheet1");
            int    Rowindex = index;
            IRow   newRow   = sheet1.CreateRow(Rowindex);

            newRow.HeightInPoints = 20;
            ICellStyle cellstyle = RF.hssfworkbook.CreateCellStyle();

            cellstyle.BorderBottom      = NPOI.SS.UserModel.BorderStyle.Thin;
            cellstyle.BorderTop         = NPOI.SS.UserModel.BorderStyle.Thin;
            cellstyle.BorderLeft        = NPOI.SS.UserModel.BorderStyle.Thin;
            cellstyle.BorderRight       = NPOI.SS.UserModel.BorderStyle.Thin;
            cellstyle.VerticalAlignment = VerticalAlignment.Center;
            //  ICellStyle DatecellStype = RF.hssfworkbook.CreateCellStyle();
            // IDataFormat format = RF.hssfworkbook.CreateDataFormat();
            for (int i = 0; i < 13; i++)
            {
                ICell cell = newRow.CreateCell(i);

                cell.SetCellValue((string)RFC.GetType().GetFields()[i].GetValue(RFC));
                cell.CellStyle = cellstyle;

                /*  if (i == 10)
                 * {
                 *    cell.SetCellValue((DateTime)RFC.GetType().GetFields()[i].GetValue(RFC));
                 *
                 *    DatecellStype.BorderBottom = NPOI.SS.UserModel.BorderStyle.Thin;
                 *    DatecellStype.BorderTop = NPOI.SS.UserModel.BorderStyle.Thin;
                 *    DatecellStype.BorderLeft = NPOI.SS.UserModel.BorderStyle.Thin;
                 *    DatecellStype.BorderRight = NPOI.SS.UserModel.BorderStyle.Thin;
                 *    DatecellStype.VerticalAlignment = VerticalAlignment.Center;
                 *    DatecellStype.DataFormat = format.GetFormat("m/d/yy");
                 *    cell.CellStyle = DatecellStype;
                 *    // cell.CellStyle.WrapText = true;
                 * }
                 * else
                 * {*/
            }
            sheet1.ForceFormulaRecalculation = true;
        }
コード例 #2
0
        public ReportFileColumns AppendATMDataToColumnsFormat(int rowindex)
        {
            IRow Row = sourceWB.GetSheet("Sheet1").GetRow(rowindex);
            ReportFileColumns temRFcolumns = new ReportFileColumns();

            temRFcolumns.Model = "HT" + getCellValue(Row, AStruct.Model);  //Row.GetCell(1).StringCellValue;
            //temRFcolumns.Model = "HT-" + temRFcolumns.Model;
            temRFcolumns.ProductID = getCellValue(Row, AStruct.ProductID); //Row.GetCell(2).StringCellValue;
            string tempCellValue = Row.GetCell(AStruct.WorkStyle).StringCellValue;

            if (tempCellValue == "PM")
            {
                temRFcolumns.ErrorSrc = "PM";
                temRFcolumns.DealSrc  = "PM";
            }
            else if (tempCellValue.Substring(0, 2) == "升级")
            {
                temRFcolumns.ErrorSrc = "升级";
                temRFcolumns.DealSrc  = "升级";
            }
            else if (tempCellValue.IndexOf("协助对账") != -1)
            {
                temRFcolumns.ErrorSrc = tempCellValue.Substring(4);
                temRFcolumns.DealSrc  = "协助对账";
            }
            else
            {
                temRFcolumns.ErrorSrc = getCellValue(Row, AStruct.ErrorSrc); //Row.GetCell(16).StringCellValue;
                temRFcolumns.DealSrc  = getCellValue(Row, AStruct.DealSrc);  //Row.GetCell(17).StringCellValue;
            }
            string bank = getCellValue(Row, AStruct.bank);

            bank = parseBankName(bank);
            temRFcolumns.ClientName      = bank + getCellValue(Row, AStruct.ClientName);     //Row.GetCell(29).StringCellValue;
            temRFcolumns.Engineer        = getCellValue(Row, AStruct.Engineer);              //Row.GetCell(20).StringCellValue;
            temRFcolumns.MaintenanceDate = getCellValue(Row, AStruct.MaintenanceDate, true); //Row.GetCell(11).Stri
            temRFcolumns.PaiID           = getCellValue(Row, AStruct.PaiID);                 //Row.GetCell(3).StringCellValue;
            temRFcolumns.ServiceID       = getCellValue(Row, AStruct.ServiceID);             //Row.GetCell(4).StringCellValue;
            return(temRFcolumns);
        }
コード例 #3
0
        public ReportFileColumns AppendSetupDataToColumnsFormat(int rowindex)
        {
            IRow Row = sourceWB.GetSheet("Sheet1").GetRow(rowindex);
            ReportFileColumns temRFcolumns = new ReportFileColumns();

            temRFcolumns.Model = "HT" + getCellValue(Row, 2); //Row.GetCell(1).StringCellValue;
                                                              //temRFcolumns.Model = "HT-" + temRFcolumns.Model;
            temRFcolumns.ProductID = getCellValue(Row, 1);    //Row.GetCell(2).StringCellValue;

            temRFcolumns.ErrorSrc = "新装机";
            temRFcolumns.DealSrc  = "新装机";

            string bank = getCellValue(Row, 24);

            bank = parseBankName(bank);
            temRFcolumns.ClientName = bank + getCellValue(Row, 26);    //Row.GetCell(29).StringCellValue;
            temRFcolumns.Engineer   = getCellValue(Row, 33);           //Row.GetCell(20).StringCellValue;

            temRFcolumns.MaintenanceDate = getCellValue(Row, 4, true); //Row.GetCell(11).Stri
            temRFcolumns.PaiID           = getCellValue(Row, 43);      //Row.GetCell(3).StringCellValue;
            temRFcolumns.ServiceID       = getCellValue(Row, 0);       //Row.GetCell(4).StringCellValue;
            return(temRFcolumns);
        }
コード例 #4
0
        //{ textBox1.Text = "工号为空,请输入工号!"; }


        /*      public void AppendToColumnsFormatForWebpage()
         *    {
         *        RFcolumns.PaiID = DFList.PaiID;
         *        RFcolumns.ServiceID = DFList.ServiceID;
         *        RFcolumns.ProductID = DFList.MID;
         *        RFcolumns.MaintenanceDate = DFList.AvTime;
         *        RFcolumns.ErrorSrc = DFList.ErrorScr;
         *        RFcolumns.DealSrc = DFList.DealScr;
         *        RFcolumns.Engineer = DFList.staffnum;
         *    }*/
        public ReportFileColumns AppendOtherDataToColumnsFormat(ISheet sheet, int rowindex)
        {
            IRow Row = sheet.GetRow(rowindex);
            ReportFileColumns temRFcolumns = new ReportFileColumns();

            temRFcolumns.Model = getCellValue(Row, GGStruct.Model);                                               //Row.GetCell(1).StringCellValue;
            //temRFcolumns.Model = "HT-" + temRFcolumns.Model;
            temRFcolumns.ProductID = getCellValue(Row, GGStruct.ProductID).Replace(temRFcolumns.Model + " ", ""); //Row.GetCell(2).StringCellValue;
            if (Row.GetCell(GGStruct.WorkStyle).StringCellValue == "PM")
            {
                temRFcolumns.ErrorSrc = "PM";
                temRFcolumns.DealSrc  = "PM";
            }
            else if (Row.GetCell(GGStruct.WorkStyle).StringCellValue.Substring(0, 2) == "升级")
            {
                temRFcolumns.ErrorSrc = "升级";
                temRFcolumns.DealSrc  = "升级";
            }
            else
            {
                temRFcolumns.ErrorSrc = getCellValue(Row, GGStruct.ErrorSrc); //Row.GetCell(16).StringCellValue;
                temRFcolumns.DealSrc  = getCellValue(Row, GGStruct.DealSrc);  //Row.GetCell(17).StringCellValue;
            }
            string bank = getCellValue(Row, GGStruct.bank);

            //bank = parseBankName(bank);
            temRFcolumns.ClientName = getCellValue(Row, GGStruct.ClientName); //Row.GetCell(29).StringCellValue;
            temRFcolumns.Engineer   = getCellValue(Row, GGStruct.Engineer);   //Row.GetCell(20).StringCellValue;
            //temRFcolumns.MaintenanceDate = getCellValue(Row, 24); //Row.GetCell(11).StringCellValue;
            string temDate = getCellValue(Row, GGStruct.MaintenanceDate);     //Row.GetCell(11).StringCellValue;

            temRFcolumns.MaintenanceDate = temDate.Remove(temDate.IndexOf(' ')).Replace("-", "/");
            temRFcolumns.PaiID           = getCellValue(Row, GGStruct.PaiID);     //Row.GetCell(3).StringCellValue;
            temRFcolumns.ServiceID       = getCellValue(Row, GGStruct.ServiceID); //Row.GetCell(4).StringCellValue;
            return(temRFcolumns);
        }