From 308263701da4760b517c116ffef4f9b1ca842261 Mon Sep 17 00:00:00 2001 From: yangle <admin@YINMOU> Date: 星期一, 17 七月 2023 10:54:27 +0800 Subject: [PATCH] 瑞琪的,报废的生成入库单的时候把传的值 之前是=KCZT08_SYS 现在改成=KCZT001 乔一入库报表,生产报表 过滤条件 按照排产日期查询,加一个自定义条件 --- WebAPI/Controllers/MJGL/Sc_MouldRepairChangeBillController.cs | 6 +++--- 1 files changed, 3 insertions(+), 3 deletions(-) diff --git a/WebAPI/Controllers/MJGL/Sc_MouldRepairChangeBillController.cs b/WebAPI/Controllers/MJGL/Sc_MouldRepairChangeBillController.cs index 5c98c51..cd56a54 100644 --- a/WebAPI/Controllers/MJGL/Sc_MouldRepairChangeBillController.cs +++ b/WebAPI/Controllers/MJGL/Sc_MouldRepairChangeBillController.cs @@ -71,12 +71,12 @@ { if (sWhere == null || sWhere.Equals("")) { - return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldRepairChangeBillList " + sWhere + "order by hmainid desc", "h_v_Sc_MouldRepairChangeBillList"); + return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldRepairChangeBillList " + sWhere + "order by 鍒跺崟鏃ユ湡 desc", "h_v_Sc_MouldRepairChangeBillList"); } else { string sql1 = "select * from h_v_Sc_MouldRepairChangeBillList where 1 = 1 "; - string sql = sql1 + sWhere+ "order by hmainid desc"; + string sql = sql1 + sWhere+ "order by 鍒跺崟鏃ユ湡 desc"; return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sc_MouldRepairChangeBillList"); } @@ -601,7 +601,7 @@ objJsonResult.data = null; return objJsonResult; } - DLL.ClsSc_MouldProdOutBill oBill = new DLL.ClsSc_MouldProdOutBill(); + DLL.ClsSc_MouldRepairChangeBill oBill = new DLL.ClsSc_MouldRepairChangeBill(); if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo)) { if (flag == 1) -- Gitblit v1.9.1