智云MES后端API代码
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
yusijie
2024-10-07 d8fc6ac36336cb02a00f1e5f4e90b7bdfb34fb85 
 WebAPI/Controllers/Sc_MouldOtherInBillController.cs


@@ -17,7 +17,9 @@


        private json objJsonResult = new json();


        public DataSet ds = new DataSet();


        public WebServer webserver = new WebServer();




        public SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();


        Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter();


        DAL.ClsSc_MouldOtherInBill oBill = new DAL.ClsSc_MouldOtherInBill();


        public DAL.ClsSc_MouldScrapInBill BillNew0 = new DAL.ClsSc_MouldScrapInBill();   //模具报废入库对应单据类


        public DAL.ClsSc_MouldScrapInBill BillOld0 = new DAL.ClsSc_MouldScrapInBill();   //模具报废入库对应单据类




@@ -83,12 +85,22 @@




        [Route("Sc_MouldOtherInBill/GetMouldOtherInBill")]


        [HttpGet]


        public object GetMouldOtherInBill(string sWhere)


        public object GetMouldOtherInBill(string sWhere,string user, string Organization)


        {


            try


            {


                //编辑权限


                if (!DBUtility.ClsPub.Security_Log("Sc_MouldOtherInBillList", 1, false, user))


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "无查看权限！";


                    objJsonResult.data = null;


                    return objJsonResult;


                }




                ds = Sc_MouldOtherInBill(sWhere);


                ds = Sc_MouldOtherInBill(sWhere, Organization);




                objJsonResult.code = "1";


                objJsonResult.count = 1;


                objJsonResult.Message = "返回记录成功！";


@@ -105,16 +117,16 @@


            }


        }




        public static DataSet Sc_MouldOtherInBill(string sWhere)


        public static DataSet Sc_MouldOtherInBill(string sWhere, string Organization)


        {


            string sql1 = string.Format(@"select * from h_v_Sc_MouldOtherInBillList where 库存组织='" + Organization + "'");


            if (sWhere == null || sWhere.Equals(""))


            {


                return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldOtherInBillList ", "h_v_Sc_MouldOtherInBillList");


                return new SQLHelper.ClsCN().RunProcReturn(sql1 + "order by 制单日期 desc", "h_v_Sc_MouldOtherInBillList");


            }


            else


            {


                string sql1 = "select * from h_v_Sc_MouldOtherInBillList where 1 = 1 ";


                string sql = sql1 + sWhere;


                string sql = sql1 + sWhere+ "order by 制单日期 desc";


                return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sc_MouldOtherInBillList");


            }




@@ -122,16 +134,16 @@




        #endregion




        #region[器具分布式调出单编辑时获取表头数据]


        #region[器具其他入库单编辑时获取表头数据]


        [Route("Sc_MouldOtherInBill/Sc_MouldOtherInBillListCheckDetai")]


        [HttpGet]


        public ApiResult<DataSet> Sc_MouldOtherInBillListCheckDetai(string HID)


        public ApiResult<DataSet> Sc_MouldOtherInBillListCheckDetai(string HID)  


        {


            if (string.IsNullOrEmpty(HID))


                return new ApiResult<DataSet> { code = -1, msg = "ID不能为空" };


            SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();




            var dataSet = oCN.RunProcReturn("select top 1 * from    where hmainid= " + HID + " ", "h_v_Sc_MouldOtherInBillList");


             var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Sc_MouldOtherInBillList  where hmainid= " + HID + " ", "h_v_Sc_MouldOtherInBillList");


            if (dataSet == null || dataSet.Tables[0].Rows.Count == 0)


                return new ApiResult<DataSet> { code = -1, msg = "不存在退库单号" };




@@ -139,12 +151,14 @@


        }


        #endregion




        #region[器具分布式调出单编辑时获取表体数据]


        #region[器具其他入库单编辑时获取表体数据]


        [Route("Sc_MouldOtherInBill/Sc_MouldOtherInBillListProjectDetai")]


        [HttpGet]


        public object Sc_MouldOtherInBillListProjectDetai(string sqlWhere)


        {


            DataSet ds;


            DataSet ds1;


            List<object> list = new List<object>();


            try


            {


                SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();


@@ -152,30 +166,32 @@


                {


                    ds = oCN.RunProcReturn(string.Format(@"SELECT HMaterID,模具代码 HMaterCode,模具名称 HMaterName,规格型号 HMaterSpec,批次 HBatchNo,


                                                设计寿命 HDesignLife, 剩余寿命 HLeaveLife, 累积使用寿命 HUseLife, 应发数量 HQtyMust, 实发数量 HQty, 


                                                单价 HPrice, 金额 HMoney,HWHSonID HWHID, 发料仓库代码 HWHCode, 发料仓库 HWHName,HSPID, 


                                                仓位代码 HSPCode, 仓位 HSPName,表体备注 HRemark FROM h_v_Sc_MouldOtherInBillList"), "h_v_Sc_MouldOtherInBillList");


                                                单价 HPrice, 金额 HMoney,收料仓库ID HWHID, 收料仓库代码 HWHCode, 收料仓库 HWHName,HSPID, 


                                                仓位代码 HSPCode, 仓位 HSPName,表体备注 HRemark,HStockOrgID FROM h_v_Sc_MouldOtherInBillList"), "h_v_Sc_MouldOtherInBillList");




                    objJsonResult.code = "0";


                    objJsonResult.count = 1;


                    objJsonResult.Message = "获取信息成功！";


                    objJsonResult.data = ds.Tables[0];


                }


                else


                {




                    //string sql1 = "select HRepairCheckID,HRepairCheckContent,HManagerID,HRemark  from Sc_MouldRepairCheckBillSub where 1 = 1 ";


                    string sql1 = string.Format(@"SELECT HMaterID,模具代码 HMaterCode,模具名称 HMaterName,规格型号 HMaterSpec,批次 HBatchNo,


                                                设计寿命 HDesignLife, 剩余寿命 HLeaveLife, 累积使用寿命 HUseLife, 应发数量 HQtyMust, 实发数量 HQty, 


                                                单价 HPrice, 金额 HMoney,HWHSonID HWHID, 发料仓库代码 HWHCode, 发料仓库 HWHName,HSPID, 


                                                仓位代码 HSPCode, 仓位 HSPName,表体备注 HRemark FROM h_v_Sc_MouldOtherInBillList where 1 = 1 ");


                                                单价 HPrice, 金额 HMoney,收料仓库ID HWHID, 收料仓库代码 HWHCode, 收料仓库 HWHName,HSPID, 


                                                仓位代码 HSPCode, 仓位 HSPName,表体备注 HRemark,HStockOrgID FROM h_v_Sc_MouldOtherInBillList where 1 = 1 ");


                    string sql = sql1 + sqlWhere;


                    ds = oCN.RunProcReturn(sql, "h_v_Sc_MouldOtherInBillList");




                    objJsonResult.code = "0";


                    objJsonResult.count = 1;


                    objJsonResult.Message = "获取信息成功！";


                    objJsonResult.data = ds.Tables[0];


                }


                //查汇总


                ds1 = oCN.RunProcReturn(string.Format(@"select  物料代码,max(物料名称)物料名称,规格型号,max(单据号)单据号,批次,sum(实发数量)实发数量,


                                            收料仓库ID,max(收料仓库代码)收料仓库代码,max(收料仓库)收料仓库,表体备注 from h_v_Sc_MouldOtherInBillList 


                                            where 1=1 " + sqlWhere + " group by 物料代码,规格型号,收料仓库ID,批次,表体备注"), "h_v_Sc_MouldOtherInBillList");




                list.Add(ds.Tables[0]);


                list.Add(ds1.Tables[0]);


                objJsonResult.code = "0";


                objJsonResult.count = 1;


                objJsonResult.Message = "获取信息成功！";


                objJsonResult.list = list;


            }


            catch (Exception e)


            {


@@ -188,7 +204,158 @@


        }


        #endregion




        #region 器具分布式调出单保存/编辑


        #region 器具其他入库单保存/编辑    20240702作废


        /// <summary>


        /// 保存模具领用单


        /// </summary>


        /// <param name="msg"></param>


        /// <returns></returns>


        //[Route("Sc_MouldOtherInBill/SaveGetMouldOtherInBillList")]


        //[HttpPost]


        //public object SaveGetMouldOtherInBillList([FromBody] JObject msg)


        //{


        //    var _value = msg["msg"].ToString();


        //    string msg1 = _value.ToString();


        //    string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);


        //    string msg2 = sArray[0].ToString();


        //    string msg3 = sArray[1].ToString();


        //    string msg4 = sArray[2].ToString();




        //    string UserName = "";


        //    ListModels oListModels = new ListModels();


        //    try


        //    {


        //        //编辑权限


        //        if (!DBUtility.ClsPub.Security_Log("Sc_MouldOtherInBill_Edit", 1, false, msg4))


        //        {


        //            objJsonResult.code = "0";


        //            objJsonResult.count = 0;


        //            objJsonResult.Message = "无保存权限！";


        //            objJsonResult.data = null;


        //            return objJsonResult;


        //        }




        //        DLL.ClsSc_MouldOtherInBill oBill = new DLL.ClsSc_MouldOtherInBill();


        //        List<Model.ClsSc_MouldOtherInBillMain> lsmain = new List<Model.ClsSc_MouldOtherInBillMain>();


        //        msg2 = msg2.Replace("\\", "");


        //        msg2 = msg2.Replace("\n", "");  //\n


        //        lsmain = oListModels.getObjectByJson_Sc_MouldOtherInBillMain(msg2);


        //        foreach (Model.ClsSc_MouldOtherInBillMain oItem in lsmain)


        //        {


        //            //oItem.HMaker = "";


        //            UserName = oItem.HMaker;  //制单人


        //            oItem.HBillType = "3841";


        //            oItem.HBillSubType = "3841";


        //            //oItem.HBillNo = "";    //单据号


        //            //oItem.HDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd"));//  --日期


        //            //oItem.HInnerBillNo = "";  //  --内部单据号


        //            oItem.HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year);


        //            oItem.HMakeDate = DBUtility.ClsPub.isStrNull(DateTime.Now.ToString("yyyy-MM-dd"));


        //            //oItem.HEquipID = 0;    //设备ID(Gy_EquipMent)


        //            //oItem.HPeriod = 0;


        //            //oItem.HCheckBeginDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd"));  //  --维修日期


        //            //oItem.HCheckResult = "";     //验收结论--(正常，异常)


        //            //oItem.HEmpID = 0;           //验收人(Gy_Employee)


        //            //oItem.HManagerID = 0;      //负责人(Gy_Employee)


        //            //oItem.HDeptID = 0;        //验收部门(Gy_Department)


        //            //oItem.HExplanation = "";  //摘要(故障描述)  


        //            //oItem.HRemark = "";       //备注




        //            //oItem.HMainSourceInterID = oItem.HInterID;




        //            //oItem.HInterID = DBUtility.ClsPub.CreateBillID_SRMProd("1103", ref DBUtility.ClsPub.sExeReturnInfo);


        //            if (DBUtility.ClsPub.isStrNull(oItem.HDate) == "")


        //            {


        //                objJsonResult.code = "0";


        //                objJsonResult.count = 0;


        //                objJsonResult.Message = "保存失败！没有单据日期，无法保存！";


        //                objJsonResult.data = 1;


        //                return objJsonResult;


        //            }


        //            oBill.omodel = oItem;


        //        }


        //        //表体数据


        //        //按 },{来拆分数组 //去掉【和】


        //        msg3 = msg3.Substring(1, msg3.Length - 2);


        //        msg3 = msg3.Replace("\\", "");


        //        msg3 = msg3.Replace("\n", "");  //\n


        //        //msg2 = msg2.Replace("'", "’");


        //        List<Model.ClsSc_MouldStockBillSub> ls = new List<Model.ClsSc_MouldStockBillSub>();


        //        ls = oListModels.getObjectByJson_Gy_MouldStockBillSub(msg3);


        //        int i = 0;


        //        foreach (Model.ClsSc_MouldStockBillSub oItemSub in ls)


        //        {




        //            i++;


        //            oItemSub.HEntryID = i;




        //            //oItemSub.HRepairCheckID = 0;   //验收项目ID


        //            //oItemSub.HRepairCheckContent = ""; //验收内容


        //            //oItemSub.HManagerID = 0;   //负责人ID


        //            //oItemSub.HCloseMan = "";       //行关闭


        //            oItemSub.HEntryCloseDate = DBUtility.ClsPub.isDate(DateTime.Now);


        //            oItemSub.HCloseType = false;   //关闭类型


        //            //oItemSub.HRemark = "";         //备注


        //            oItemSub.HSourceInterID = 0;     // 源单主内码


        //            oItemSub.HSourceEntryID = 0;   //源单子内码


        //            //oItemSub.HSourceBillNo = "";  //源单单号


        //            //oItemSub.HSourceBillType = ""; //源单类型


        //            //oItemSub.HRelationQty = 0;     //关联数量


        //            //oItemSub.HRelationMoney = 0;   //关联金额 


        //            //oItemSub.HRepairID = 0;       //维修项目


        //            //oItemSub.HRepairExplanation ="";   //维修要求


        //            //oItemSub.HMoney = 0;        //维修费用


        //            oBill.DetailColl.Add(oItemSub);




        //        }


        //        //保存


        //        //保存完毕后处理


        //        bool bResult;


        //        if (oBill.omodel.HInterID == 0)


        //        {


        //            // bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo);


        //            bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo);


        //            string sql = string.Format($"exec h_p_Sc_MouldChangeFileStatus  'in','{oBill.omodel.HInterID.ToString()}' ");


        //            oCn.RunProc(sql);


        //        }


        //        else


        //        {


        //            bResult = oBill.ModifyBill(oBill.omodel.HInterID, ref DBUtility.ClsPub.sExeReturnInfo);


        //            //修改成功


        //            //string sql = string.Format($"exec h_p_Sc_MouldChangeNowWHID  1,{oBill.omodel.HInterID.ToString()},' ' ");


        //            string sql = string.Format($"exec h_p_Sc_MouldChangeNowWHID ");


        //            oCn.RunProc(sql);


        //        }


        //        if (bResult)


        //        {


        //            objJsonResult.code = "0";


        //            objJsonResult.count = 1;


        //            objJsonResult.Message = "保存成功！";


        //            //WebAPIController.Add_Log("送货单下推", UserName, "生成送货单");


        //            objJsonResult.data = 1;


        //            return objJsonResult;


        //        }


        //        else


        //        {


        //            objJsonResult.code = "0";


        //            objJsonResult.count = 0;


        //            objJsonResult.Message = "保存失败！" + DBUtility.ClsPub.sExeReturnInfo;


        //            objJsonResult.data = 1;


        //            return objJsonResult;


        //        }


        //    }


        //    catch (Exception e)


        //    {


        //        objJsonResult.code = "0";


        //        objJsonResult.count = 0;


        //        objJsonResult.Message = "保存失败！" + e.ToString();


        //        objJsonResult.data = 1;


        //        return objJsonResult;


        //    }


        //}


        #endregion




        #region 器具其他入库单保存/编辑    20240702


        /// <summary>


        /// 保存模具领用单


        /// </summary>


@@ -201,106 +368,121 @@


            var _value = msg["msg"].ToString();


            string msg1 = _value.ToString();


            string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);


            string msg2 = sArray[0].ToString();


            string msg3 = sArray[1].ToString();






            string UserName = "";


            ListModels oListModels = new ListModels();


            string sMainStr = sArray[0].ToString();         //主表数据


            string sSubStr = sArray[1].ToString();          //子表数据


            string HMaker = sArray[2].ToString();           //制单人


            try


            {


                DLL.ClsSc_MouldOtherInBill oBill = new DLL.ClsSc_MouldOtherInBill();


                List<Model.ClsSc_MouldOtherInBillMain> lsmain = new List<Model.ClsSc_MouldOtherInBillMain>();


                msg2 = msg2.Replace("\\", "");


                msg2 = msg2.Replace("\n", "");  //\n


                lsmain = oListModels.getObjectByJson_Sc_MouldOtherInBillMain(msg2);


                foreach (Model.ClsSc_MouldOtherInBillMain oItem in lsmain)


                //判断权限


                if (!DBUtility.ClsPub.Security_Log("Sc_MouldOtherInBill_Edit", 1, false, HMaker))


                {


                    //oItem.HMaker = "";


                    UserName = oItem.HMaker;  //制单人


                    oItem.HBillType = "3841";


                    oItem.HBillSubType = "3841";


                    //oItem.HBillNo = "";    //单据号


                    //oItem.HDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd"));//  --日期


                    //oItem.HInnerBillNo = "";  //  --内部单据号


                    oItem.HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year);


                    oItem.HMakeDate = DBUtility.ClsPub.isStrNull(DateTime.Now.ToString("yyyy-MM-dd"));


                    //oItem.HEquipID = 0;    //设备ID(Gy_EquipMent)


                    //oItem.HPeriod = 0;


                    //oItem.HCheckBeginDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd"));  //  --维修日期


                    //oItem.HCheckResult = "";     //验收结论--(正常，异常)


                    //oItem.HEmpID = 0;           //验收人(Gy_Employee)


                    //oItem.HManagerID = 0;      //负责人(Gy_Employee)


                    //oItem.HDeptID = 0;        //验收部门(Gy_Department)


                    //oItem.HExplanation = "";  //摘要(故障描述)  


                    //oItem.HRemark = "";       //备注




                    //oItem.HMainSourceInterID = oItem.HInterID;




                    //oItem.HInterID = DBUtility.ClsPub.CreateBillID_SRMProd("1103", ref DBUtility.ClsPub.sExeReturnInfo);


                    if (DBUtility.ClsPub.isStrNull(oItem.HDate) == "")


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "您没有该模块新增/编辑权限,请与管理员联系！";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


                //表头赋值


                sMainStr = sMainStr.Replace("\\", "");


                sMainStr = sMainStr.Replace("\n", "");


                sMainStr = "[" + sMainStr.ToString() + "]";


                List<Model.ClsSc_MouldStockBillMain> lsmain = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsSc_MouldStockBillMain>>(sMainStr);


                foreach (Model.ClsSc_MouldStockBillMain oItem in lsmain)


                {


                    if (oItem.HInterID == 0)


                    {


                        BillStatus = DBUtility.ClsPub.Enum_BillStatus.BillStatus_AddNew;


                    }


                    else


                    {


                        BillStatus = DBUtility.ClsPub.Enum_BillStatus.BillStatus_Modify;


                    }


                    //单据号是否重复


                    if (oBill.IsExistBillNo(ref ClsPub.sExeReturnInfo, oItem.HBillNo, BillStatus, oItem.HInterID))


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 0;


                        objJsonResult.Message = "保存失败！没有单据日期，无法保存！";


                        objJsonResult.data = 1;


                        objJsonResult.Message = "单据号重复！不允许保存！";


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


                    //判断会计期是否合理


                    string s = "";


                    int sYear = 0;


                    int sPeriod = 0;


                    if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod(oItem.HDate, ref sYear, ref sPeriod, ref s) == false)


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 0;


                        objJsonResult.Message = s;


                        objJsonResult.data = null;


                        return objJsonResult;


                    }




                    oItem.HYear = sYear;


                    oItem.HPeriod = sPeriod;


                    DBUtility.ClsPub.CurUserName = oItem.HMaker;


                    oBill.omodel = oItem;


                }


                //表体数据


                //表体赋值


                //按 },{来拆分数组 //去掉【和】


                msg3 = msg3.Substring(1, msg3.Length - 2);


                msg3 = msg3.Replace("\\", "");


                msg3 = msg3.Replace("\n", "");  //\n


                //msg2 = msg2.Replace("'", "’");


                List<Model.ClsSc_MouldStockBillSub> ls = new List<Model.ClsSc_MouldStockBillSub>();


                ls = oListModels.getObjectByJson_Gy_MouldStockBillSub(msg3);


                sSubStr = sSubStr.Substring(1, sSubStr.Length - 2);


                sSubStr = sSubStr.Replace("\\", "");


                sSubStr = sSubStr.Replace("\n", "");


                sSubStr = "[" + sSubStr.ToString() + "]";


                List<Model.ClsSc_MouldStockBillSub> ls = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsSc_MouldStockBillSub>>(sSubStr);


                int i = 0;


                foreach (Model.ClsSc_MouldStockBillSub oItemSub in ls)


                {




                    i++;


                    oItemSub.HEntryID = i;




                    //oItemSub.HRepairCheckID = 0;   //验收项目ID


                    //oItemSub.HRepairCheckContent = ""; //验收内容


                    //oItemSub.HManagerID = 0;   //负责人ID


                    //oItemSub.HCloseMan = "";       //行关闭


                    oItemSub.HEntryCloseDate = DBUtility.ClsPub.isDate(DateTime.Now);


                    oItemSub.HCloseType = false;   //关闭类型


                    //oItemSub.HRemark = "";         //备注


                    oItemSub.HSourceInterID = 0;     // 源单主内码


                    oItemSub.HSourceEntryID = 0;   //源单子内码


                    //oItemSub.HSourceBillNo = "";  //源单单号


                    //oItemSub.HSourceBillType = ""; //源单类型


                    //oItemSub.HRelationQty = 0;     //关联数量


                    //oItemSub.HRelationMoney = 0;   //关联金额 


                    //oItemSub.HRepairID = 0;       //维修项目


                    //oItemSub.HRepairExplanation ="";   //维修要求


                    //oItemSub.HMoney = 0;        //维修费用


                    oBill.DetailColl.Add(oItemSub);




                }


                //保存


                //保存完毕后处理




                string sErrMsg = "";


                bool bResult;


                if (oBill.omodel.HInterID == 0)


                //获取系统参数


                if (oSystemParameter.ShowBill(ref sErrMsg) == true)


                {


                    // bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo);


                    bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo);


                    //保存


                    if (oBill.omodel.HInterID == 0)   //新增保存


                    {


                        bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo);




                        if (oSystemParameter.omodel.WMS_CampanyName == "四维尔") //系统参数  客户定制化名称     空白为通用


                        {


                            //修改器具档案位置


                            string sql1 = string.Format($"exec h_p_Sc_MouldChangeFileStatus  'in','{oBill.omodel.HInterID.ToString()}' ");


                            oCn.RunProc(sql1);


                        }


                    }


                    else                        //编辑保存


                    {


                        bResult = oBill.ModifyBill(oBill.omodel.HInterID, ref DBUtility.ClsPub.sExeReturnInfo);




                        if (oSystemParameter.omodel.WMS_CampanyName == "四维尔") //系统参数  客户定制化名称     空白为通用


                        {


                            //修改器具档案位置


                            string sql = string.Format($"exec h_p_Sc_MouldChangeNowWHID ");


                            oCn.RunProc(sql);


                        }


                    }


                }


                else


                {


                    bResult = oBill.ModifyBill(oBill.omodel.HInterID, ref DBUtility.ClsPub.sExeReturnInfo);


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "获取系统参数失败！ " + sErrMsg;


                    objJsonResult.data = null;


                    return objJsonResult;


                }




                if (bResult)


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 1;


                    objJsonResult.Message = "保存成功！";


                    //WebAPIController.Add_Log("送货单下推", UserName, "生成送货单");


                    objJsonResult.data = 1;


                    objJsonResult.Message = DBUtility.ClsPub.sExeReturnInfo;  //成功！


                    objJsonResult.data = null;


                    return objJsonResult;


                }


                else


@@ -308,7 +490,7 @@


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "保存失败！" + DBUtility.ClsPub.sExeReturnInfo;


                    objJsonResult.data = 1;


                    objJsonResult.data = null;


                    return objJsonResult;


                }


            }


@@ -316,31 +498,31 @@


            {


                objJsonResult.code = "0";


                objJsonResult.count = 0;


                objJsonResult.Message = "保存失败！" + e.ToString();


                objJsonResult.data = 1;


                objJsonResult.Message = "保存失败！" + e.Message;


                objJsonResult.data = null;


                return objJsonResult;


            }


        }


        #endregion




        #region [器具分布式调入单删除功能]


        #region [器具其他入库单删除功能]


        /// <summary>


        /// 模具处理领用单删除功能


        /// </summary>


        /// <returns></returns>


        [Route("Sc_MouldOtherInBill/DeltetMouldOtherInBill")]


        [HttpGet]


        public object DeltetMouldOtherInBill(string HInterID)


        public object DeltetMouldOtherInBill(string HInterID,string user)


        {


            //编辑权限


            //if (!DBUtility.ClsPub.Security_Log("Sc_MouldProdBackBill_Delete", 1, true, DBUtility.ClsPub.CurUserName))


            //{


            //    objJsonResult.code = "0";


            //    objJsonResult.count = 0;


            //    objJsonResult.Message = "无删除权限！";


            //    objJsonResult.data = null;


            //    return objJsonResult;


            //}


            if (!DBUtility.ClsPub.Security_Log("Sc_MouldOtherOutBill_Delete", 1, false, user))


            {


                objJsonResult.code = "0";


                objJsonResult.count = 0;


                objJsonResult.Message = "无删除权限！";


                objJsonResult.data = null;


                return objJsonResult;


            }






            Int64 lngBillKey = 0;


@@ -372,10 +554,21 @@


                    objJsonResult.data = null;


                    return objJsonResult;


                }




                //删除前查找当前单据的所有器具ID


                //string swhere = "";


                //DataSet ds = oCn.RunProcReturn("select HMaterID from Sc_MouldStockBillSub where HinterID=" + HInterID, "Sc_MouldStockBillSub");


                //for (var i = 0; i < ds.Tables[0].Rows.Count; i++)


                //{


                //    swhere = swhere + ds.Tables[0].Rows[i]["HMaterID"].ToString() + ",";


                //}


                //swhere = swhere.Substring(0, swhere.Length - 1);


                bool IsDete = oBill.DeleteBill(oBill.omodel.HInterID, ref DBUtility.ClsPub.sExeReturnInfo);


                if (IsDete)


                {


                    //删除成功修改器具档案位置


                    //string sql = string.Format($"exec h_p_Sc_MouldChangeNowWHID  0,0,'{swhere}' ");


                    string sql = string.Format($"exec h_p_Sc_MouldChangeNowWHID ");


                    oCn.RunProc(sql);


                    objJsonResult.code = "0";


                    objJsonResult.count = 1;


                    objJsonResult.Message = DBUtility.ClsPub.sExeReturnInfo;