From e94751d212251f720bdb1035bc2db0c7ba4b89f2 Mon Sep 17 00:00:00 2001
From: zgq <519541279@qq.com>
Date: 星期四, 15 四月 2021 15:32:37 +0800
Subject: [PATCH] 新增组托单缓存列表、及删除缓存数据接口
---
WebAPI/Controllers/Sc_GroupOrderBillController.cs | 81 ++++++++++++++++++++++++++++++++++++++++
1 files changed, 81 insertions(+), 0 deletions(-)
diff --git a/WebAPI/Controllers/Sc_GroupOrderBillController.cs b/WebAPI/Controllers/Sc_GroupOrderBillController.cs
index fa93207..2d9a7b8 100644
--- a/WebAPI/Controllers/Sc_GroupOrderBillController.cs
+++ b/WebAPI/Controllers/Sc_GroupOrderBillController.cs
@@ -207,6 +207,87 @@
}
}
+ /// <summary>
+ /// 杩斿洖缂撳瓨鍒楄〃
+ /// </summary>
+ /// <param name="sWhere">鎷兼帴鐨凷QL</param>
+ /// <returns>object</returns>
+ [Route("GroupOrderBill/CacheList")]
+ [HttpGet]
+ public object CacheList(string sWhere)
+ {
+ DataSet ds;
+ try
+ {
+ SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
+ if (sWhere == null || sWhere.Equals(""))
+ {
+ ds = oCN.RunProcReturn("select top 5000 * from h_v_GroupOrderBillCacheList order by 鎵爜鏃堕棿 desc", "h_v_GroupOrderBillCacheList");
+ }
+ else
+ {
+ string sql1 = "select * from h_v_GroupOrderBillCacheList where 1 = 1 ";
+ string sql = sql1 + sWhere;
+ string sql2 = " order by 鎵爜鏃堕棿 desc";
+ sql += sql2;
+ ds = oCN.RunProcReturn(sql, "h_v_GroupOrderBillCacheList");
+ }
+ if (ds == null || ds.Tables[0].Rows.Count == 0)
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "鏃犳暟鎹紒";
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ else
+ {
+ objJsonResult.code = "1";
+ objJsonResult.count = 1;
+ objJsonResult.Message = "Sucess锛�";
+ objJsonResult.data = ds.Tables[0];
+ return objJsonResult;
+ }
+
+ }
+ catch (Exception e)
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "Exception锛�" + e.ToString();
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ }
+
+ /// <summary>
+ /// 鏍规嵁ID鍒犻櫎缂撳瓨琛ㄤ腑鎵爜璁板綍
+ /// </summary>
+ /// <param name="sHitemID">缂撳瓨琛↖D</param>
+ /// <returns>object</returns>
+ [Route("GroupOrderBill/DelCacheList")]
+ [HttpGet]
+ public object DelCacheList(long sHitemID)
+ {
+ try
+ {
+ SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
+ oCn.RunProc("Delete from KF_PonderationBillMain_Temp where HitemID = " + sHitemID);
+ objJsonResult.code = "1";
+ objJsonResult.count = 1;
+ objJsonResult.Message = "鍒犻櫎鎴愬姛锛�";
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ catch (Exception e)
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "鍒犻櫎澶辫触锛�";
+ objJsonResult.data = e.ToString();
+ return objJsonResult;
+ }
+ }
//
}
--
Gitblit v1.9.1