优化自动产生工作联系单方法

zrg

7 天以前 981ea6f779477b4b729c6796cfc42ee933c781b0

 WebAPI/Controllers/MJGL/Sc_MouldProdOutBillController.cs

@@ -29,7 +29,8 @@
        private json objJsonResult = new json();
        SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
        public DAL.ClsSc_MouldProdOutBill oBill = new DAL.ClsSc_MouldProdOutBill();

        //获取系统参数
        Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter();

        #region 器具领用出库单分页列表
        [Route("Sc_MouldProdOutBillController/page")]
@@ -355,26 +356,7 @@
                    return new { code = "0", count = 0, Message = "托数必须大于0！" };


                string checkAuditSql = $@"
                    SELECT HBillStatus 
                    FROM Sc_MouldStockBillMain
                    WHERE HInterID = {hmainid}";

                DataSet dsAudit = oCn.RunProcReturn(checkAuditSql, "CheckAudit");

                if (dsAudit != null && dsAudit.Tables[0].Rows.Count > 0)
                {
                    int hBillStatus = Convert.ToInt32(dsAudit.Tables[0].Rows[0]["HBillStatus"]);
              
                    if (hBillStatus == 2)
                    {
                        return new { code = "0", count = 0, Message = "单据已审核，不能修改托数！" };
                    }
                }
                else
                {
                    return new { code = "0", count = 0, Message = "单据不存在！" };
                }
     

                // 直接更新托数
                string updateSql = $@"
@@ -832,6 +814,26 @@

                if (bResult)
                {
                    string sReturn = "";
                    // 华舟 保存成功后下推工作联系单 
                    if (oSystemParameter.ShowBill(ref sReturn) == true)
                    {
                        if (oSystemParameter.omodel.WMS_CampanyName == "华舟")
                        {
                            //自动生成工作联系单
                            var ds2 = oCn.RunProcReturn("exec h_p_OA_WorkLinkBill_Create " + oBill.omodel.HInterID + "," + 3802, "h_p_OA_WorkLinkBill_Create");

                            if (ds2 != null && ds2.Tables[0].Rows.Count > 0)
                            {
                                int HInterID = int.Parse(ds2.Tables[0].Rows[0]["NewHInterID"].ToString());
                                LogService.Write("执行消息推送..." + HInterID);

                                // 触发消息推送
                                Service.GeTuiService.PubishSingle(HInterID);
                            }
                        }
                    }

                    objJsonResult.code = "0";
                    objJsonResult.count = 1;
                    objJsonResult.Message = DBUtility.ClsPub.sExeReturnInfo;  //成功！