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); }*/ }