| | |
|---|
| | | string stockDetailSql = $@"select LockQty-{lessQty} as morelockQty from DataStockDetail where IsDel='0' and SkuNo='{d.SkuNo}' and LotNo='{d.LotNo}' and PalletNo='{dr["PalletNo"] + ""}'"; |
|---|
| | | decimal morelockQty = Db.Ado.GetDecimal(stockDetailSql); |
|---|
| | | |
|---|
| | | if (morelockQty >= 0) |
|---|
| | | if (morelockQty > 0) |
|---|
| | | { |
|---|
| | | sqlList.Add($@"update DataStockDetail set LockQty=LockQty-{lessQty} where IsDel='0' and SkuNo='{d.SkuNo}' and LotNo='{d.LotNo}' and PalletNo='{dr["PalletNo"] + ""}'"); |
|---|
| | | } |
|---|
| | | else if (morelockQty == 0) |
|---|
| | | { |
|---|
| | | sqlList.Add($@"update DataStockDetail set LockQty=0,Status='0' where IsDel='0' and SkuNo='{d.SkuNo}' and LotNo='{d.LotNo}' and PalletNo='{dr["PalletNo"] + ""}'"); |
|---|
| | | } |
|---|
| | | } |
|---|
| | | |
|---|
| | | } |
|---|
