From 552ac362ab031223b230d92352c40427d891a6aa Mon Sep 17 00:00:00 2001 From: yusijie <ysj@hz-kingdee.com> Date: 星期四, 03 八月 2023 10:20:43 +0800 Subject: [PATCH] 1 --- WebAPI/Controllers/基础资料/基础资料/Gy_SOPBillListController.cs | 32 ++++++++++++++++++++++++++++++++ 1 files changed, 32 insertions(+), 0 deletions(-) diff --git "a/WebAPI/Controllers/\345\237\272\347\241\200\350\265\204\346\226\231/\345\237\272\347\241\200\350\265\204\346\226\231/Gy_SOPBillListController.cs" "b/WebAPI/Controllers/\345\237\272\347\241\200\350\265\204\346\226\231/\345\237\272\347\241\200\350\265\204\346\226\231/Gy_SOPBillListController.cs" index 9da1975..c328f82 100644 --- "a/WebAPI/Controllers/\345\237\272\347\241\200\350\265\204\346\226\231/\345\237\272\347\241\200\350\265\204\346\226\231/Gy_SOPBillListController.cs" +++ "b/WebAPI/Controllers/\345\237\272\347\241\200\350\265\204\346\226\231/\345\237\272\347\241\200\350\265\204\346\226\231/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 } } \ No newline at end of file -- Gitblit v1.9.1