| | |
|---|
| | | try { |
|---|
| | | // 查询起点货位:数量=0 |
|---|
| | | var startLoc = db.Queryable<TN_Location>().LeftJoin<TN_Loc_Container>((l, c) => l.S_CODE == c.S_LOC_CODE) |
|---|
| | | .Where((l,c) => l.N_LOCK_STATE == 0 && l.S_LOCK_STATE == "无" && l.C_ENABLE == "Y" && l.S_CODE == model.StartLoc && l.N_CURRENT_NUM == 1 && c.S_CNTR_CODE == model.CntrCode).First(); |
|---|
| | | .Where((l, c) => l.N_LOCK_STATE == 0 && l.S_LOCK_STATE == "无" && l.C_ENABLE == "Y" && l.S_CODE == model.StartLoc && l.N_CURRENT_NUM == 1 && c.S_CNTR_CODE == model.CntrCode).First(); |
|---|
| | | if (startLoc == null) { |
|---|
| | | return $"没有找到起点货位'{model.StartLoc}'!要求:锁状态='无',当前容器数量=1"; |
|---|
| | | } |
|---|
| | |
|---|
| | | return "数据库操作失败!"; |
|---|
| | | } |
|---|
| | | |
|---|
| | | tran.CommitTran() ; |
|---|
| | | tran.CommitTran(); |
|---|
| | | return "数据库操作成功"; |
|---|
| | | } |
|---|
| | | } |
|---|
| | | catch (Exception ex) { |
|---|
| | | |
|---|
| | | return ex.Message; |
|---|
| | | } |
|---|
| | | } |
|---|
