瑞琪入库判断汇报数量是否大于金蝶云的汇报-入库数量

yangle

2023-05-31 58da69b16ac993d831c55ac2acd5381027f88861

瑞琪入库判断汇报数量是否大于金蝶云的汇报-入库数量

 WebAPI/Controllers/Sc_ProcessMangementController.cs

@@ -703,22 +703,26 @@
                    if (oSystemParameter.omodel.WMS_CampanyName == "瑞与祺")
                    {
                        //判断金蝶云生产汇报单 数量 是否 大于 末道出站数量
                        ds = oCN.RunProcReturn($@"select sum(FFinishQty)-(select HQty from Sc_StationOutBillMain where HBillNo='{BillNo}') 
                        ds = oCN.RunProcReturn($@"select sum(FFinishQty)-sum(FSTOCKINQUASELQTY)-(select HQty from Sc_StationOutBillMain where HBillNo='{BillNo}') 
                        from  AIS20220308151944..T_PRD_MORPT rpt3 
                        left join AIS20220308151944..T_PRD_MORPTENTRY  rpt2 on rpt3.FID = rpt2.FID
                        left join AIS20220308151944..T_PRD_MORPTENTRY_A  rpt1 on rpt2.FID = rpt1.FID
                        where F_bsv_Text=(select HProcExchBillNo from Sc_StationOutBillMain where HBillNo='{BillNo}')", "SumCount");

                        if (double.Parse(ds.Tables[0].Rows[0][0].ToString()) < 0)
                        {
                            objJsonResult.code = "0";
                            objJsonResult.count = 0;
                            objJsonResult.Message = "金蝶云汇报数量小于本地出站数量!";
                            objJsonResult.data = null;
                            return objJsonResult;
                        }
                    }
                }



                if (double.Parse(ds.Tables[0].Rows[0][0].ToString()) < 0) {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "金蝶云汇报数量小于本地出站数量!";
                    objJsonResult.data = null;
                    return objJsonResult;
                }
              


                JObject model = new JObject();