委外接收的删除 判断 瑞琪的条码生成规则 新增通过删除修改的接口 工厂日历的完善

yangle

2023-08-01 de1dccd289b272a99aff32d20b57c9a7211e3bf2

 WebAPI/Controllers/»ù´¡×ÊÁÏ/»ù´¡×ÊÁÏ/Gy_SOPBillListController.cs

@@ -281,6 +281,38 @@
                return objJsonResult;
            }
        }

        /// <summary>
        /// å¯¹æ•°æ®åº“进行操作
        /// </summary>
        /// <param name="sWhere"></param>
        /// <returns></returns>
        [Route("Gy_SOPBillList/UpDelSQL")]
        [HttpGet]
        public object UpDelSQL(string sWhere)
        {
            try
            {
                oCN.BeginTran();
                oCN.RunProc(sWhere);
                oCN.Commit();

                objJsonResult.code = "1";
                objJsonResult.count = 1;
                objJsonResult.Message = "Sucess！";
                objJsonResult.data = null;
                return objJsonResult;
            }
            catch (Exception e)
            {
                oCN.RollBack();
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "Exception！" + e.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }
        #endregion
    }
}