From 06bf635016c8cdd691fac8cda56d6b50915a4996 Mon Sep 17 00:00:00 2001 From: yangle <admin@YINMOU> Date: 星期四, 18 五月 2023 08:44:32 +0800 Subject: [PATCH] 流转卡、生产订单、工序进站单、工序出站单只能自己删除自己的单据。(所有模块,做个系统参数,删除人和制单人必须一致) 流转卡列表批量删除批量删除(会误操作),删除的时候先根据生产订单去过滤 --- WebAPI/Controllers/CJGL/Sc_ProcExchWorkBackBillController.cs | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/WebAPI/Controllers/CJGL/Sc_ProcExchWorkBackBillController.cs b/WebAPI/Controllers/CJGL/Sc_ProcExchWorkBackBillController.cs index 1bc43f2..5f2b4d0 100644 --- a/WebAPI/Controllers/CJGL/Sc_ProcExchWorkBackBillController.cs +++ b/WebAPI/Controllers/CJGL/Sc_ProcExchWorkBackBillController.cs @@ -77,7 +77,7 @@ { SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); string sql = string.Format(@"select top 2 * from h_v_Sc_ProcessExchangeBillQuerySub"); - ds = oCN.RunProcReturn(sql + sWhere, "h_v_Sc_ProcessExchangeBillQuerySub"); + ds = oCN.RunProcReturn(sql + sWhere + " order by cast(娴佹按鍙� as int) ", "h_v_Sc_ProcessExchangeBillQuerySub"); objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "鑾峰彇淇℃伅鎴愬姛锛�"; -- Gitblit v1.9.1