protected override void GetReceiptNotes(Resolver resolver) { DetachedCriteria criteria = DetachedCriteria.For(typeof(PickList)); criteria.Add(Expression.Eq("IsPrinted", false)); OrderHelper.SetOpenOrderStatusCriteria(criteria, "Status"); //订单状态 SecurityHelper.SetRegionSearchCriteria(criteria, "PartyFrom.Code", resolver.UserCode); //区域权限 IList <PickList> pickList = criteriaMgr.FindAll <PickList>(criteria, 0, 5); List <ReceiptNote> receiptNotes = new List <ReceiptNote>(); if (pickList != null && pickList.Count > 0) { foreach (PickList pl in pickList) { string newUrl = reportMgr.WriteToFile("PickList.xls", pl.PickListNo); pl.IsPrinted = true;//to be refactored pickListMgr.UpdatePickList(pl); ReceiptNote receiptNote = PickList2ReceiptNote(pl); receiptNote.PrintUrl = newUrl; receiptNotes.Add(receiptNote); } } resolver.ReceiptNotes = receiptNotes; }
private void PrintPickList(Resolver resolver, string[] region) { DetachedCriteria criteria = DetachedCriteria.For(typeof(PickList)); criteria.Add(Expression.Eq("IsPrinted", false)); criteria.Add(Expression.Eq("Status", BusinessConstants.CODE_MASTER_STATUS_VALUE_SUBMIT)); criteria.Add(Expression.In("PartyFrom.Code", region)); IList <PickList> pickList = criteriaMgr.FindAll <PickList>(criteria); List <ReceiptNote> receiptNotes = new List <ReceiptNote>(); if (pickList != null && pickList.Count > 0) { foreach (PickList pl in pickList) { string newUrl = reportMgr.WriteToFile("PickList.xls", pl.PickListNo); pl.IsPrinted = true;//to be refactored pickListMgr.UpdatePickList(pl); ReceiptNote receiptNote = PickList2ReceiptNote(pl); receiptNote.PrintUrl = newUrl; receiptNotes.Add(receiptNote); } } if (resolver.ReceiptNotes == null) { resolver.ReceiptNotes = receiptNotes; } else { IListHelper.AddRange <ReceiptNote>(resolver.ReceiptNotes, receiptNotes); } }
protected override bool FillValuesImpl(String templateFileName, IList <object> list) { try { PickList pickList = (PickList)list[0]; IList <PickListDetail> pickListDetails = pickList.PickListDetails; if (pickList == null || pickListDetails == null || pickListDetails.Count == 0) { return(false); } if (pickList.PartyFrom.Code == "YFK-RW" || pickList.PartyFrom.Code == "YFK-RM-HD") // if (!pickList.PartyFrom.Code.Contains("YFK-BJ") && (pickList.PartyFrom.Code.Contains("-RM") || pickList.PartyFrom.Code.Contains("RM-"))) { pickListDetails = pickListDetails.OrderBy(pd => pd.PrintLocationCode).ToList(); } this.barCodeFontName = this.GetBarcodeFontName(0, 7); //this.SetRowCellBarCode(0, 0, 7); this.CopyPage(pickListDetails.Count); this.FillHead(pickList); int pageIndex = 1; int rowIndex = 0; int rowTotal = 0; int no = 1; foreach (PickListDetail pickListDetail in pickListDetails) { // No. this.SetRowCell(pageIndex, rowIndex, 0, "" + (no++)); //零件号 Item Code this.SetRowCell(pageIndex, rowIndex, 1, pickListDetail.Item.Code); //描述Description this.SetRowCell(pageIndex, rowIndex, 2, pickListDetail.Item.Description); //单包装UC this.SetRowCell(pageIndex, rowIndex, 3, pickListDetail.UnitCount.ToString("0.########")); //需求 Request 包装 int UCs = (int)Math.Ceiling(pickListDetail.Qty / pickListDetail.UnitCount); this.SetRowCell(pageIndex, rowIndex, 4, UCs.ToString()); //需求 Request 零件数 this.SetRowCell(pageIndex, rowIndex, 5, pickListDetail.Qty.ToString("0.########")); //库位(loc) this.SetRowCell(pageIndex, rowIndex, 6, pickListDetail.PrintLocationCode); //批号(LOT) this.SetRowCell(pageIndex, rowIndex, 7, pickListDetail.LotNo != null ? pickListDetail.LotNo : String.Empty); //实收 Received 包装 this.SetRowCell(pageIndex, rowIndex, 8, String.Empty); //实收 Received 零件数 this.SetRowCell(pageIndex, rowIndex, 9, String.Empty); //备注 this.SetRowCell(pageIndex, rowIndex, 10, pickListDetail.Memo); if (this.isPageBottom(rowIndex, rowTotal))//页的最后一行 { pageIndex++; rowIndex = 0; } else { rowIndex++; } rowTotal++; } this.sheet.DisplayGridlines = false; this.sheet.IsPrintGridlines = false; if (pickList.IsPrinted == null || pickList.IsPrinted == false) { pickList.IsPrinted = true; pickListMgr.UpdatePickList(pickList); } } catch (Exception) { return(false); } return(true); }
protected override bool FillValuesImpl(String templateFileName, IList <object> list) { try { PickList pickList = (PickList)list[0]; IList <PickListDetail> pickListDetails = pickList.PickListDetails; if (pickList == null || pickListDetails == null || pickListDetails.Count == 0) { return(false); } this.SetRowCellBarCode(0, 2, 7); this.CopyPage(pickListDetails.Count); this.FillHead(pickList); int pageIndex = 1; int rowIndex = 0; int rowTotal = 0; foreach (PickListDetail pickListDetail in pickListDetails) { //"订单号Order No." this.SetRowCell(pageIndex, rowIndex, 0, pickListDetail.OrderLocationTransaction.OrderDetail.OrderHead.OrderNo); //物料号 this.SetRowCell(pageIndex, rowIndex, 1, pickListDetail.Item.Code); //物料描述 this.SetRowCell(pageIndex, rowIndex, 2, pickListDetail.Item.Description); //"单位Unit" this.SetRowCell(pageIndex, rowIndex, 3, pickListDetail.Uom.Code); //"单包装UC" this.SetRowCell(pageIndex, rowIndex, 4, pickListDetail.UnitCount.ToString("0.########")); //库位 this.SetRowCell(pageIndex, rowIndex, 5, pickListDetail.Location.Code); //库区 this.SetRowCell(pageIndex, rowIndex, 6, pickListDetail.StorageArea == null ? string.Empty : pickListDetail.StorageArea.Code); //库格 this.SetRowCell(pageIndex, rowIndex, 7, pickListDetail.StorageBin == null ? string.Empty : pickListDetail.StorageBin.Code); //批号 this.SetRowCell(pageIndex, rowIndex, 8, pickListDetail.LotNo); //订单数 this.SetRowCell(pageIndex, rowIndex, 9, pickListDetail.Qty.ToString("0.########")); if (this.isPageBottom(rowIndex, rowTotal))//页的最后一行 { pageIndex++; rowIndex = 0; } else { rowIndex++; } rowTotal++; } this.sheet.DisplayGridlines = false; this.sheet.IsPrintGridlines = false; if (pickList.IsPrinted == null || pickList.IsPrinted == false) { pickList.IsPrinted = true; pickListMgr.UpdatePickList(pickList); } } catch (Exception) { return(false); } return(true); }