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