private void writeContent(string companyCode, int pageIndex, int num, PrintKanBanCard kanBanCard,int count)
        {
            //this.SetMergedRegion(pageIndex, 1, 4, 9, 4, num);
            //ICell cell = this.GetCell(this.GetRowIndexAbsolute(pageIndex, getRowIndex(1, num)), getColumnIndex(4, num));
            //ICellStyle cellStyle = workbook.CreateCellStyle();
            //IFont font = workbook.CreateFont();
            //font.FontName = "宋体";
            //font.FontHeightInPoints = 24;
            //font.Boldweight = (short)NPOI.SS.UserModel.FontBoldWeight.BOLD;
            //cellStyle.SetFont(font);
            //cellStyle.Alignment = NPOI.SS.UserModel.HorizontalAlignment.CENTER;
            //cellStyle.VerticalAlignment = NPOI.SS.UserModel.VerticalAlignment.TOP;
            //cellStyle.Rotation = (short)-90;
            //cell.CellStyle = workbook.CreateCellStyle();
            //cell.CellStyle.CloneStyleFrom(cellStyle);
            //this.SetRowCell(pageIndex, 1, 4, companyCode, num);

            this.SetRowCell(pageIndex, 1, 0, kanBanCard.Flow, num);
            this.SetRowCell(pageIndex, 1, 2, kanBanCard.LocBin, num);
            this.SetRowCell(pageIndex, 4, 0, kanBanCard.OpRefSequence, num);
            this.SetRowCell(pageIndex, 4, 2, kanBanCard.GroupDesc, num);
            this.SetRowCell(pageIndex, 7, 0, kanBanCard.Item, num);
            this.SetRowCell(pageIndex, 7, 2, "IMAGE", num);//此行图片
            this.SetRowCell(pageIndex, 10, 0, kanBanCard.ReferenceItemCode, num);

            string barCode = Utility.BarcodeHelper.GetBarcodeStr("$K" + kanBanCard.CardNo, this.barCodeFontName);
            this.SetRowCell(pageIndex, 13, 0, kanBanCard.ItemDescription, num);
            this.SetRowCell(pageIndex, 16, 3, kanBanCard.Number.ToString() + "/" + kanBanCard.TotalCount.ToString(), num);
            this.SetRowCell(pageIndex, 17, 0, barCode, num);
            
           // this.SetRowCell(pageIndex, 17, 2, kanBanCard.UnitCount.ToString("0.########"), num);
            this.SetRowCell(pageIndex, 21, 0, kanBanCard.Container, num);//PackType
            this.SetRowCell(pageIndex, 21, 2, kanBanCard.Qty.ToString("0.########"), num);//UnitCount
            this.SetRowCell(pageIndex, 24, 0, kanBanCard.MultiStation, num);//多工位
            this.SetRowCell(pageIndex, 27, 0, kanBanCard.ItemType, num);
            this.SetRowCell(pageIndex, 27, 2, DateTime.Now.ToString("yyyy-MM-dd"), num);

            this.SetRowCell(pageIndex, 29, 0,num+"-"+count,num);

        }
        private void writeContent(string companyCode, int pageIndex, int num, PrintKanBanCardInfo cardInfo, PrintKanBanCard kanBanCard, int count)
        {

            this.SetRowCell(pageIndex, 1, 0, kanBanCard.Flow, num);
            this.SetRowCell(pageIndex, 2, 5, kanBanCard.ThumbNo == null ? "" : kanBanCard.ThumbNo.ToString(), num);
            this.SetRowCell(pageIndex, 4, 0, cardInfo.CardNo, num);
            this.SetRowCell(pageIndex, 4, 2, kanBanCard.LocationTo, num);
            this.SetRowCell(pageIndex, 7, 0, kanBanCard.Item, num);
            this.SetRowCell(pageIndex, 10, 0, kanBanCard.ItemDescription, num);
           
            string barCode = Utility.BarcodeHelper.GetBarcodeStr("$K" + cardInfo.CardNo, this.barCodeFontName);
            this.SetRowCell(pageIndex, 14, 0, barCode, num);

            //this.SetRowCell(pageIndex, 18, 0, kanBanCard.PackType, num);
            this.SetRowCell(pageIndex, 18, 2, kanBanCard.UnitCount.ToString("0.########"), num);
            this.SetRowCell(pageIndex, 21, 0, kanBanCard.MultiStation, num);

            //this.SetRowCell(pageIndex, 24, 0, kanBanCard.ItemCategory, num);
            this.SetRowCell(pageIndex, 24, 2, DateTime.Now.ToString("yyyy-MM-dd"), num);
            this.SetRowCell(pageIndex, 7, 2, kanBanCard.ReferenceItemCode, num);
            this.SetRowCell(pageIndex, 26, 0, num + "-" + count, num);

        }
        private void writeContent(string companyCode, int pageIndex, int num, PrintKanBanCard kanBanCard, int count)
        {
            // HY号:(旧图号)
            this.SetRowCell(pageIndex, 0, 2, kanBanCard.ReferenceItemCode, num);

            // PRP号(新图号)
            this.SetRowCell(pageIndex, 1, 2, kanBanCard.Item, num);

            this.SetRowCell(pageIndex, 1, 3, kanBanCard.Flow, num);
            this.SetRowCell(pageIndex, 2, 2, kanBanCard.ItemDescription, num);
            this.SetRowCell(pageIndex, 3, 2, kanBanCard.LocationTo, num);

            this.SetRowCell(pageIndex, 4, 2, kanBanCard.Code, num);

            this.SetRowCell(pageIndex, 3, 3, kanBanCard.PackType, num);
            /*
            else if (hu.Item.Type.Equals("P")) //原材料
            {
                //画方框
                Cell cell1 = this.GetCell(this.GetRowIndexAbsolute(pageIndex, getRowIndex(2, num)), getColumnIndex(4, num));
                CellStyle cellStyle1 = workbook.CreateCellStyle();
                cellStyle1.BorderBottom = NPOI.SS.UserModel.CellBorderType.NONE;
                cellStyle1.BorderLeft = NPOI.SS.UserModel.CellBorderType.THIN;
                cellStyle1.BorderRight = NPOI.SS.UserModel.CellBorderType.THIN;
                cellStyle1.BorderTop = NPOI.SS.UserModel.CellBorderType.THIN;
                cell1.CellStyle = workbook.CreateCellStyle();
                cell1.CellStyle.CloneStyleFrom(cellStyle1);

                CellStyle cellStyle2 = workbook.CreateCellStyle();
                Cell cell2 = this.GetCell(this.GetRowIndexAbsolute(pageIndex, getRowIndex(3, num)), getColumnIndex(4, num));
                cellStyle2.BorderLeft = NPOI.SS.UserModel.CellBorderType.THIN;
                cellStyle2.BorderRight = NPOI.SS.UserModel.CellBorderType.THIN;
                cellStyle2.BorderBottom = NPOI.SS.UserModel.CellBorderType.THIN;
                cellStyle2.BorderTop = NPOI.SS.UserModel.CellBorderType.NONE;
                cell2.CellStyle = workbook.CreateCellStyle();
                cell2.CellStyle.CloneStyleFrom(cellStyle2);

                //hu id内容
                string barCode = Utility.BarcodeHelper.GetBarcodeStr(hu.HuId, this.barCodeFontName);
                this.SetRowCell(pageIndex, 0, 0, barCode, num);
                //hu id内容
                this.SetRowCell(pageIndex, 1, 0, hu.HuId, num);
                //PART NO.内容
                this.SetRowCell(pageIndex, 3, 0, hu.Item.Code, num);
                //批号LotNo
                this.SetRowCell(pageIndex, 5, 0, hu.LotNo, num);
                //QUANTITY.
                this.SetRowCell(pageIndex, 4, 2, "QUANTITY.", num);
                //QUANTITY.
                this.SetRowCell(pageIndex, 5, 2, hu.Qty.ToString("0.########"), num);
                //DESCRIPTION	
                this.SetRowCell(pageIndex, 6, 0, "DESCRIPTION.", num);
                //DESCRIPTION内容
                this.SetRowCell(pageIndex, 7, 0, hu.Item.Description, num);
                //SUPPLIER
                this.SetRowCell(pageIndex, 8, 0, "SUPPLIER.", num);
                //SUPPLIER内容
                this.SetRowCell(pageIndex, 9, 0, hu.ManufactureParty == null ? string.Empty : hu.ManufactureParty.Name, num);
                //PRINTED DATE:内容
                this.SetRowCell(pageIndex, 10, 1, DateTime.Now.ToString("MM/dd/yy"), num);
                //print name 内容
                this.SetRowCell(pageIndex, 10, 3, userName, num);

            }*/
        }