From 73b0bd21324fac6244493c42e8ee8a145d2c3bf3 Mon Sep 17 00:00:00 2001 From: 王 垚 <1402714037@qq.com> Date: 星期二, 09 十一月 2021 13:31:33 +0800 Subject: [PATCH] 采购订单 发布成功后的撤销功能 --- WebAPI/Controllers/PublicPageMethodController.cs | 6 +++--- 1 files changed, 3 insertions(+), 3 deletions(-) diff --git a/WebAPI/Controllers/PublicPageMethodController.cs b/WebAPI/Controllers/PublicPageMethodController.cs index b3d3f89..6315e17 100644 --- a/WebAPI/Controllers/PublicPageMethodController.cs +++ b/WebAPI/Controllers/PublicPageMethodController.cs @@ -1442,13 +1442,13 @@ { if (sWhere == null || sWhere.Equals("")) { - ds = oCN.RunProcReturn("Select HItemID,HParentID,HNumber,HName from Gy_EquipMent where HStopflag=0 Order by HItemID", "Gy_EquipMent"); + ds = oCN.RunProcReturn("Select HInterID,HEquipFileNumber,HName from Gy_EquipFileBillMain Order by HInterID", "Gy_EquipFileBillMain"); } else { - string sql1 = "Select HItemID,HParentID,HNumber,HName from Gy_EquipMent where 1 = 1 "; + string sql1 = "Select HInterID,HEquipFileNumber,HName from Gy_EquipFileBillMain where 1 = 1 "; string sql = sql1 + sWhere; - ds = oCN.RunProcReturn(sql, "Gy_EquipMent"); + ds = oCN.RunProcReturn(sql, "HEquipFileNumber"); } if (ds == null || ds.Tables[0].Rows.Count == 0) { -- Gitblit v1.9.1