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, PrintKanBanCardInfo cardInfo, 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.Routing, 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, 7, 2, "IMAGE", num);//此行图片 this.SetRowCell(pageIndex, 10, 0, kanBanCard.ReferenceItemCode, num); string barCode = Utility.BarcodeHelper.GetBarcodeStr("$K" + cardInfo.CardNo, this.barCodeFontName); this.SetRowCell(pageIndex, 13, 0, kanBanCard.ItemDescription, num); this.SetRowCell(pageIndex, 16, 3, cardInfo.Sequence.ToString() + "/" + kanBanCard.Qty.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.PackType, num);//PackType this.SetRowCell(pageIndex, 21, 2, kanBanCard.UnitCount.ToString("0.########"), num);//UnitCount this.SetRowCell(pageIndex, 24, 0, kanBanCard.MultiStation, num);//多工位 this.SetRowCell(pageIndex, 27, 0, kanBanCard.ItemCategory, num); this.SetRowCell(pageIndex, 27, 2, DateTime.Now.ToString("yyyy-MM-dd"), num); this.SetRowCell(pageIndex, 29, 0,num+"-"+count,num); }