缓存列表编辑返回界面表头信息获取调用方法新增，上传生成模具出入库单有源单关联数量回填

yanxiaojun

2021-10-06 e4a34bc16ab46d4419133999eb9c939572f93b74

缓存列表编辑返回界面表头信息获取调用方法新增，上传生成模具出入库单有源单关联数量回填

 CLOUDWEB/WebService1.asmx.cs

@@ -33233,6 +33233,23 @@
            return DS;
        }

        //删除模治具列表中选中行记录
        [WebMethod]
        public bool set_DelSc_MouldStockBillMain_Temp(long HInterID, long HMouldInterID, string sHBillType, ref string sErrMsg)
        {
            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
            try
            {
                oCn.RunProc("Delete from Sc_MouldStockBillMain_Temp where HInterID=" + HInterID.ToString() + " and HBillType='" + sHBillType + "' and HMouldID=" + HMouldInterID.ToString() + " and HQty<>0", ref DBUtility.ClsPub.sExeReturnInfo);
                return true;
            }
            catch (Exception e)
            {
                sErrMsg = "删除模治具出入库临时表记录失败！" + e.Message;
                return false;
            }
        }

        //上传生成模具出入库单
        [WebMethod]
        public bool set_SaveMouldStockBill_New(Model.ClsSc_MouldStockBillMain oMain, string sHSourceType, ref string sErrMsg)
@@ -33259,6 +33276,12 @@
                oCn.BeginTran();
                string HMouldBillType = oMain.HBillType;
                oCn.RunProc("EXEC h_p_Sc_MouldStockBill_Insert_New " + oMain.HInterID.ToString() + ",'" + oMain.HBillType + "','" + HMouldBillType + "'," + oMain.HSupID.ToString() + "," + oMain.HKeeperID.ToString() + "," + oMain.HSecManagerID.ToString() + "," + oMain.HDeptID.ToString() + "," + oMain.HCorrespondentTypeID.ToString());
                //更新关联数量
                if (oMain.HBillType == "3841" && sHSourceType == "3840")
                {
                    //器具分步调入单，源单：器具分步调出单
                    oCn.RunProc("exec h_p_Sc_UpDateMouldMoveStockStepOutRelation_Add " + oMain.HInterID.ToString());
                }
                oCn.Commit();
                return true;
            }
@@ -33270,7 +33293,7 @@
            }
        }

        #region 模具单据列表处理方法
        #region 模具缓存列表处理方法

        //缓存列表界面，选择编辑时，判断所选单据是否存在已上传记录
        [WebMethod]
@@ -33292,6 +33315,15 @@
                sErrMsg = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HRemark"]);
                return false;
            }
        }

        //缓存列表界面，返回缓存表头信息
        [WebMethod]
        public DataSet GetMouldSource(string HBillType, string HSourceBillNo, string HSourceType, ref string sErrMsg)
        {
            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
            DataSet DS = oCn.RunProcReturn("exec h_p_Sc_MouldSourceList '" + HBillType.ToString() + "','" + HSourceBillNo + "','" + HSourceType + "'", "h_p_Sc_MouldSourceList");
            return DS;
        }

        //缓存列表界面，返回缓存列表信息
@@ -33382,22 +33414,6 @@
            return DS;
        }

        //删除模治具列表中选中行记录
        [WebMethod]
        public bool set_DelSc_MouldStockBillMain_Temp(long HInterID, long HMouldInterID, string sHBillType, ref string sErrMsg)
        {
            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
            try
            {
                oCn.RunProc("Delete from Sc_MouldStockBillMain_Temp where HInterID=" + HInterID.ToString() + " and HBillType='" + sHBillType + "' and HMouldID=" + HMouldInterID.ToString(), ref DBUtility.ClsPub.sExeReturnInfo);
                return true;
            }
            catch (Exception e)
            {
                sErrMsg = "删除模治具出入库临时表记录失败！" + e.Message;
                return false;
            }
        }

        #endregion