生产退料单

yusijie

2023-06-28 4cf8cdb357e04b1004b0fdfe3ed3dc367f0dd0c2

 WebAPI/Controllers/POStockInBillController.cs

@@ -969,7 +969,7 @@
                    string text4 = ClsPub.isStrNull(dataSet2.Tables[0].Rows[0]["HModel"]);
                    long num3 = (long)ClsPub.isInt(dataSet2.Tables[0].Rows[0]["HUnitID"]);
                    text = str3 + num2.ToString() + text2  + "#" + num;
                    text1 = str3 + num2.ToString() + text2;
                    text1 = str3 + num2.ToString() + text2;//组织代码+物料id+批号
                    //找源单
                    DataSet dataSet3 = clsCN.RunProcReturn(" select fid,FMATERIALID,FENTRYID,FBILLNO from h_v_RECEIVEQuery where FSRCBILLNO= '" + str2 + "' and  FLOT_TEXT = '" + text2 + "' and  FMATERIALID = " + num2.ToString(), "h_v_RECEIVEQuery");
                    //DataSet dataSet3 = clsCN.RunProcReturn(" select fid,FMATERIALID,FENTRYID,FBILLNO from h_v_RECEIVEQuery where FLOT_TEXT= '" + text2 + "' and FPRODUCEDATE = '" + dateTime + "' and  FMATERIALID = " + num2.ToString(), "h_v_RECEIVEQuery");
@@ -1431,7 +1431,8 @@
                        text = str9 + num35.ToString() + text25 + "#" + num34;
                        text1 = str9 + num35.ToString() + text25;
                        DataSet dataSet21 = clsCN4.RunProcReturn(" select * from Gy_BarCodeBill where HBarCode= '" + text1 + "'", "Gy_BarCodeBill");
                        bool flag15 = dataSet21.Tables[0].Rows.Count > 0;
                        bool flag15 = dataSet21.Tables[0].Rows.Count > 0;                       

                        if (!flag15)
                        {
                            string billCode4 = "85";
@@ -3448,7 +3449,7 @@
                //如果存在 再判断扫码临时表是否存在该条码
                //如果不存在  进行扫源单的方法
                DataSet Dss5;
                Dss5 = oCn.RunProcReturn(" select * from Gy_BarCodeBill where HBarCode= '" + HTM + "'", "Gy_BarCodeBill");
                Dss5 = oCn.RunProcReturn(" select * from Gy_BarCodeBill where HBarCode= '" + HTM + "' and HSourceBillNo='" + HSourceBillNo + "'", "Gy_BarCodeBill");
                if (Dss5.Tables[0].Rows.Count > 0)
                {
                    DataSet ds;