销售出库单提交只生成WMS单据调用方法，审核时增加信用控制判断

yxj

2023-11-13 9cd0addce97d49b2738a3bc2db7e770bef898947

销售出库单提交只生成WMS单据调用方法，审核时增加信用控制判断

 CLOUDWEB/WebService1.asmx.cs

@@ -17805,16 +17805,7 @@
                    oCn.RollBack();
                    return false;
                }

                if (oSystemParameterMain.Kf_SellOutBill_AutoCheck == "Y") //系统参数  自动审核 
                {
                    //审核WMS单据
                    oCn.RunProc("Update Kf_ICStockBillMain Set HChecker='" + oMain.HMaker + "',HCheckDate=convert(varchar(10),getdate(),120),HBillStatus=2 where HInterID= " + oMain.HInterID.ToString());
                }

                sErrMsg = "生成销售出库单成功！单据号为：" + oMain.HBillNo;
                oCn.Commit();
                return true;
            }
            catch (Exception e)
            {
@@ -17822,6 +17813,45 @@
                oCn.RollBack();
                return false;
            }

            if (oSystemParameterMain.Kf_SellOutBill_AutoCheck == "Y") //系统参数  自动审核 
            {
                DataSet ds2 = oCn.RunProcReturn("exec h_p_Kf_CheckSellOutBill_CrediControl " + oMain.HInterID.ToString(), "h_p_Kf_CheckSellOutBill_CrediControl");
                if (ds2 == null || ds2.Tables[0].Rows.Count == 0)
                {
                    sErrMsg = "生成销售出库单成功，审核单据失败！单据号：" + oMain.HBillNo + "，单据ID：" + oMain.HInterID + "；审核销售出库单，信用控制判断错误！";
                    return true;
                }
                else if (DBUtility.ClsPub.isLong(ds2.Tables[0].Rows[0][0]) == 1)
                {
                    sErrMsg = "生成销售出库单成功，审核单据失败！单据号：" + oMain.HBillNo + "，单据ID：" + oMain.HInterID + "；" + DBUtility.ClsPub.isStrNull(ds2.Tables[0].Rows[0]["HRemark"]);
                    return true;
                }
                else
                {
                    DataSet ds = oCn.RunProcReturn("exec h_p_Kf_SellOutBill_Check " + oMain.HInterID.ToString() + ",'1205','" + oMain.HMaker + "'", "h_p_Kf_SellOutBill_Check");
                    if (ds == null || ds.Tables[0].Rows.Count == 0)
                    {
                        sErrMsg = "生成销售出库单成功，审核单据失败！单据号：" + oMain.HBillNo + "，单据ID：" + oMain.HInterID + "；审核销售出库单判断错误！";
                        return true;
                    }
                    else if (DBUtility.ClsPub.isLong(ds.Tables[0].Rows[0][0]) == 1)
                    {
                        sErrMsg = "生成销售出库单成功，审核单据失败！单据号：" + oMain.HBillNo + "，单据ID：" + oMain.HInterID + "；" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HRemark"]);
                        return true;
                    }
                    else
                    {
                        sErrMsg = "生成并审核销售出库单成功！单据号为：" + oMain.HBillNo;
                        return true;
                    }
                }
            }
            else
            {
                sErrMsg = "生成销售出库单成功！单据号为：" + oMain.HBillNo;
                return true;
            }
        }

        #endregion