From 15cd183e1954f46567f2cfc62eccd31672fa5e7f Mon Sep 17 00:00:00 2001 From: zgq <519541279@qq.com> Date: 星期三, 11 八月 2021 14:46:37 +0800 Subject: [PATCH] 新增即时库存查询功能、扫码详情删除功能 --- WebAPI/Controllers/SellOutController.cs | 5 +++-- 1 files changed, 3 insertions(+), 2 deletions(-) diff --git a/WebAPI/Controllers/SellOutController.cs b/WebAPI/Controllers/SellOutController.cs index 331f8c9..42299c1 100644 --- a/WebAPI/Controllers/SellOutController.cs +++ b/WebAPI/Controllers/SellOutController.cs @@ -280,12 +280,13 @@ [HttpGet] public object DisBillEntryList_Webs_Json(long HBillID, string HBillType, string sWhere) { + SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); try { - ds = webserver.GetKf_PonderationBillMain_Temp(HBillID, HBillType, sWhere); + //ds = webserver.GetKf_PonderationBillMain_Temp(HBillID, HBillType, sWhere); + ds = oCn.RunProcReturn("Select * from h_v_KF_PonderationBillMain_Temp Where HInterID=" + HBillID.ToString() + " and HBillType='" + HBillType + "' " + sWhere+ " order by HMakeDate desc", "h_v_KF_PonderationBillMain_Temp", ref DBUtility.ClsPub.sExeReturnInfo); if (ds == null || ds.Tables[0].Rows.Count <= 0) { - objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "娌℃湁杩斿洖浠讳綍璁板綍锛�"; -- Gitblit v1.9.1