| | |
| | | } |
| | | } |
| | | |
| | | internal static void addOnShelves(TN_Outbound_Order task,string cntr_code, int action) |
| | | { |
| | | var db = new SqlHelper<object>().GetInstance(); |
| | | var s_action = ""; |
| | | if (action == 1) |
| | | { |
| | | s_action = "上架"; |
| | | } |
| | | else |
| | | { |
| | | s_action = "下架"; |
| | | } |
| | | try |
| | | { |
| | | var itemlist = db.Queryable<CntrItemRel>().Where(a => a.S_CNTR_CODE == cntr_code).ToList(); |
| | | if (itemlist.Count > 0) |
| | | { |
| | | foreach (var item in itemlist) |
| | | { |
| | | var info = new TN_OnOff_Shelves |
| | | { |
| | | S_NO = task.S_NO, |
| | | N_ACTION = action, |
| | | S_ACTION = s_action, |
| | | S_ITEM_CODE = item.S_ITEM_CODE, |
| | | S_ITEM_NAME = item.S_ITEM_NAME, |
| | | S_LOC_CODE = task.S_END_LOC, |
| | | S_AREA_CODE = task.S_END_AREA, |
| | | S_CNTR_CODE = cntr_code, |
| | | S_BATCH_NO = item.S_BATCH_NO, |
| | | S_SERIAL_NO = item.S_SERIAL_NO, |
| | | //D_PRD_DATE = item.D_PRD_DATE, |
| | | F_QTY = item.F_QTY |
| | | }; |
| | | db.Insertable(info).ExecuteCommand(); |
| | | } |
| | | } |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | LogHelper.Error($"上架记录添加异常 异常信息={ex.Message}", ex); |
| | | } |
| | | } |
| | | |
| | | internal static void AddChange(WCSTask task) |
| | | { |
| | | var db = new SqlHelper<object>().GetInstance(); |