| | |
| | | endLoc.N_LOCK_STATE = 1; |
| | | endLoc.S_LOCK_STATE = "入库锁"; |
| | | |
| | | var locCntList = new List<TN_Loc_Container>(); |
| | | string cntStr = ""; |
| | | for (int i = 0; i < model.cntCount; i++) |
| | | { |
| | | cntStr += Guid.NewGuid().ToString("D")+","; |
| | | var locCnt = new TN_Loc_Container() |
| | | { |
| | | S_LOC_CODE = startLoc.S_CODE, |
| | | S_CNTR_CODE = Guid.NewGuid().ToString("D"), |
| | | }; |
| | | cntStr += locCnt.S_CNTR_CODE + ","; |
| | | |
| | | locCntList.Add(locCnt); |
| | | } |
| | | cntStr.Trim(','); |
| | | var locCnt = new TN_Loc_Container() |
| | | { |
| | | S_LOC_CODE = startLoc.S_CODE, |
| | | S_CNTR_CODE = cntStr, |
| | | }; |
| | | cntStr= cntStr.Trim(','); |
| | | |
| | | |
| | | var task = new TN_Task() |
| | | { |
| | |
| | | N_SCHEDULE_TYPE = 1, |
| | | N_B_STATE = 0, |
| | | S_B_STATE = "等待", |
| | | S_CNTR_CODE = locCnt.S_CNTR_CODE, |
| | | S_CNTR_CODE = cntStr, |
| | | }; |
| | | |
| | | if ( |
| | | db.Updateable<TN_Location>(startLoc).UpdateColumns(it => new { it.N_CURRENT_NUM, it.N_LOCK_STATE, it.S_LOCK_STATE }).ExecuteCommand() == 1 && |
| | | db.Updateable<TN_Location>(endLoc).UpdateColumns(it => new { it.N_LOCK_STATE, it.S_LOCK_STATE }).ExecuteCommand() == 1 && |
| | | db.Insertable<TN_Loc_Container>(locCnt).ExecuteCommand() == 1 && |
| | | db.Insertable<TN_Loc_Container>(locCntList).ExecuteCommand() == 1 && |
| | | db.Insertable<TN_Task>(task).ExecuteCommand() == 1 |
| | | ) |
| | | { |
| | | Task task1 = Task.Run(() => |
| | | { |
| | | WMSHelper.InsertOpInfo(model.staff, "点对点", locCnt.S_CNTR_CODE); |
| | | WMSHelper.InsertOpInfo(model.staff, "点对点", cntStr); |
| | | }); |
| | | |
| | | trans.CommitTran(); |