删除包装单方法

yangle

2023-10-23 71dec792e53e631390781685d9adcb098f0e677b

删除包装单方法

 WebAPI/Controllers/LMESController.cs

@@ -1099,6 +1099,36 @@
        }

        /// <summary>
        /// 删除对应的包装单
        /// </summary>
        /// <param name="sWhere"></param>
        /// <returns></returns>
        [Route("LEMS/DelMES_ProductionLinePackagingList")]
        [HttpGet]
        public object DelMES_ProductionLinePackagingList(string HInterID)
        {
            try
            {
                SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
                oCN.RunProc("Delete from Sc_PackUnionBillMain where HInterID = " + HInterID);
                oCN.RunProc("Delete from Sc_PackUnionBillSub where HInterID = " + HInterID);
                oCN.RunProc("Delete from KF_PonderationBillMain_Temp where HInterID = " + HInterID);
                objJsonResult.code = "1";
                objJsonResult.count = 1;
                objJsonResult.Message = "删除成功！";
                objJsonResult.data = null;
                return objJsonResult;
            }
            catch (Exception e)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "删除失败！";
                objJsonResult.data = e.ToString();
                return objJsonResult;
            }
        }
        /// <summary>
        /// 扫批次条码方法（产线组装追溯单）--根据批次条码到条码档案表中获取数据保存到temp表
        ///参数：string sql。
        ///返回值：object。