private WbsOrderLine[] JsonToWbsOrderLine(WbsOrder header, McJsonObject headJson, McJsonObject[] bodyJson) { var result = new List <WbsOrderLine>(); #region 数据处理 foreach (var lineJson in bodyJson) { var line = new WbsOrderLine(); //单号 line.OrderNo = header.OrderNo; line.OrderLineGuid = Guid.NewGuid().ToString(); //单LINE line.LineId = lineJson.IntValue("LINE_ID"); //单据行状态 line.LineStatus = lineJson.IntValue("LINE_STATUS"); //物料信息 line.MaterialNo = lineJson.StringValue("MATER_NO"); //等级 line.ProductGrade = lineJson.StringValue("PRODUCT_GRADE"); //单据数量 line.RequireQty = lineJson.IntValue("REQUIRE_QTY"); //实际数量 line.ActQty = lineJson.IntValue("ACT_QTY"); //发货数量 line.ShipQty = lineJson.IntValue("SHIP_QTY"); //工装编号 line.LimitPalletId = lineJson.StringValue("LIMIT_PALLET_ID"); //开始站台 line.LimitBinNo = lineJson.StringValue("LIMIT_BIN_NO"); //目的站台 line.ElocNo = lineJson.StringValue("ELOC_NO"); //产品GUID line.LimitProductGuid = lineJson.StringValue("LIMIT_PRODUCT_GUID"); //行任务分解 line.LineTaskFlag = lineJson.IntValue("LINE_TASK_FLAG"); //行项目唯一标示 line.OrderLineGuid = lineJson.StringValue("ORDER_LINE_GUID"); line.OrderLineGuid = Guid.NewGuid().ToString().ToUpper(); //是否已删除 line.DeleteFlag = "N"; //此单发货顺序 line.SortId = 1; //优先级 line.LinePriority = 50; //目标锁定 line.LockEndLoc = 1; result.Add(line); } #endregion return(result.ToArray()); }
private void UpdateOutputBillLine(WbsOrder bill, WbsOrderLine line) { var outLineService = TableViewServiceFactory.CreateInstance <IWbsOrderLineService>(); var update = new WbsOrderLine(); update.MaterialNo = line.MaterialNo; update.ProductGrade = line.ProductGrade; update.ElocNo = line.ElocNo; update.LimitBinNo = line.LimitBinNo; update.DeleteFlag = line.DeleteFlag; update.LimitBinNo = line.LimitBinNo; update.LimitProductGuid = line.LimitProductGuid; update.LimitPalletId = line.LimitPalletId; var where = new WbsOrderLine(); where.OrderLineGuid = line.OrderLineGuid; where.OrderNo = line.OrderNo; where.LineId = line.LineId; outLineService.Update(update, where); }
private void InsertOutputBillLine(WbsOrder bill, WbsOrderLine line) { var outLineService = TableViewServiceFactory.CreateInstance <IWbsOrderLineService>(); var insert = new WbsOrderLine(); insert.OrderNo = line.OrderNo; insert.LineId = line.LineId; insert.LineStatus = line.LineStatus; insert.MaterialNo = line.MaterialNo; insert.ProductGrade = line.ProductGrade; insert.ElocNo = line.ElocNo; insert.RequireQty = line.RequireQty; insert.ActQty = line.ActQty; insert.ShipQty = line.ShipQty; insert.LimitBinNo = line.LimitBinNo; insert.OrderLineGuid = Guid.NewGuid().ToString(); insert.DeleteFlag = "N"; insert.SortId = 1; insert.LinePriority = 50; insert.LockEndLoc = 1; outLineService.Insert(insert); }