| | |
| | | public long HSourceEntryID = 0;//HSourceEntryIDCol |
| | | public int? 叫料数量 = 0;//HBHGQtyCol |
| | | public int? 已叫料数量 = 0;//HBHGQtyCol |
| | | public int? 已配送数量 = 0;//HBHGQtyCol |
| | | public double? 退料数量 = 0;//退料数量 |
| | | public long HSTOCKID = 0;//HSTOCKID |
| | | public string 退料原因 { get; set; }//退料原因 |
| | |
| | | { |
| | | if (listCa[i].退料数量 > 0) |
| | | { |
| | | if (listCa[i].退料数量 > listCa[i].已叫料数量) |
| | | if (listCa[i].退料数量 > listCa[i].已配送数量) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "退料数量大于已叫料数量!"; |
| | | objJsonResult.Message = "退料数量大于已配送数量!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | |
| | | ds = oCN.RunProcReturn("select sum(HQty) from JIT_CallGoodsBackRequestBillSub " + |
| | | $"where HSourceInterID={listCa[i].HSouceInterID} and HSourceEntryID ={listCa[i].HSourceEntryID} and HSourceBillNo = '{listCa[i].HSourceBillNo}' and HMaterID={listCa[i].HMaterialID}", "JIT_CallGoodsBackRequestBillSub"); |
| | | |
| | | if ((double.Parse(ds.Tables[0].Rows[0][0].ToString())+listCa[i].退料数量) > listCa[i].已叫料数量) |
| | | if ((double.Parse(ds.Tables[0].Rows[0][0].ToString()==""?"0": ds.Tables[0].Rows[0][0].ToString()) +listCa[i].退料数量) > listCa[i].已叫料数量) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | |
| | | { |
| | | if (listCa[i].退料数量 > 0) |
| | | { |
| | | if (listCa[i].退料数量 > listCa[i].已叫料数量) |
| | | if (listCa[i].退料数量 > listCa[i].已配送数量) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "退料数量大于已叫料数量!"; |
| | | objJsonResult.Message = "退料数量大于已配送数量!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | |
| | | ds = oCN.RunProcReturn("select sum(HQty) from JIT_CallGoodsBackRequestBillSub " + |
| | | $"where HSourceInterID={listCa[i].HSouceInterID} and HSourceEntryID ={listCa[i].HSourceEntryID} and HSourceBillNo = '{listCa[i].HSourceBillNo}' and HMaterID={listCa[i].HMaterialID}", "JIT_CallGoodsBackRequestBillSub"); |
| | | |
| | | if ((double.Parse(ds.Tables[0].Rows[0][0].ToString()) + listCa[i].退料数量) > listCa[i].已叫料数量) |
| | | if ((double.Parse(ds.Tables[0].Rows[0][0].ToString() == "" ? "0" : ds.Tables[0].Rows[0][0].ToString()) + listCa[i].退料数量) > listCa[i].已叫料数量) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | |
| | | { |
| | | if (listCa[i].退料数量 > 0) |
| | | { |
| | | if (listCa[i].退料数量 > listCa[i].已叫料数量) |
| | | if (listCa[i].退料数量 > listCa[i].已配送数量) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "退料数量大于已叫料数量!"; |
| | | objJsonResult.Message = "退料数量大于已配送数量!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | |
| | | ds = oCN.RunProcReturn("select sum(HQty) from JIT_CallGoodsBackRequestBillSub " + |
| | | $"where HSourceInterID={listCa[i].HSouceInterID} and HSourceEntryID ={listCa[i].HSourceEntryID} and HSourceBillNo = '{listCa[i].HSourceBillNo}' and HMaterID={listCa[i].HMaterialID}", "JIT_CallGoodsBackRequestBillSub"); |
| | | |
| | | if ((double.Parse(ds.Tables[0].Rows[0][0].ToString()) + listCa[i].退料数量) > listCa[i].已叫料数量) |
| | | if ((double.Parse(ds.Tables[0].Rows[0][0].ToString() == "" ? "0" : ds.Tables[0].Rows[0][0].ToString()) + listCa[i].退料数量) > listCa[i].已叫料数量) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |