From dac1d793ad118eebf9048588a356ae0ea8a3aa95 Mon Sep 17 00:00:00 2001 From: zzr99 <1940172413@qq.com> Date: 星期四, 10 二月 2022 17:42:41 +0800 Subject: [PATCH] 基础建模每个模块的权限 --- WebAPI/Controllers/XSGL/Xs_SeOutStockBillController.cs | 16 +++++++++++++--- 1 files changed, 13 insertions(+), 3 deletions(-) diff --git a/WebAPI/Controllers/XSGL/Xs_SeOutStockBillController.cs b/WebAPI/Controllers/XSGL/Xs_SeOutStockBillController.cs index 867097a..db24e1a 100644 --- a/WebAPI/Controllers/XSGL/Xs_SeOutStockBillController.cs +++ b/WebAPI/Controllers/XSGL/Xs_SeOutStockBillController.cs @@ -82,12 +82,12 @@ if (sWhere == null || sWhere.Equals("")) { - ds = oCN.RunProcReturn("select * from h_v_IF_SeOutStockBillList " + sWhere, "h_v_IF_SeOutStockBillList"); + ds = oCN.RunProcReturn("select * from h_v_IF_SeOutStockBillList order by hmainid desc", "h_v_IF_SeOutStockBillList"); } else { string sql1 = "select * from h_v_IF_SeOutStockBillList where 1 = 1 "; - string sql = sql1 + sWhere; + string sql = sql1 + sWhere+ " order by hmainid desc"; ds = oCN.RunProcReturn(sql, "h_v_IF_SeOutStockBillList"); } if (ds == null || ds.Tables[0].Rows.Count == 0) @@ -122,10 +122,20 @@ /// <returns></returns> [Route("Xs_SeOutStockBill/DeltetSeOutStockBill")] [HttpGet] - public object DeltetSeOutStockBill(string HInterID) + public object DeltetSeOutStockBill(string HInterID,string user) { try { + //鍒ゆ柇鏄惁鏈夊垹闄ゆ潈闄� + if (!DBUtility.ClsPub.Security_Log("Xs_SeOutStockBill_Drop", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犳潈闄愬垹闄�!"; + objJsonResult.data = null; + return objJsonResult; + } + oCN.BeginTran(); oCN.RunProc("Delete From Xs_SeOutStockBillMain where HInterID = " + HInterID); oCN.RunProc("Delete From Xs_SeOutStockBillSub where HInterID = " + HInterID); -- Gitblit v1.9.1