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