From 76e698b1f23dc868f527f8ca0209e5dcdb8e1465 Mon Sep 17 00:00:00 2001
From: 沈泽 <211959439@qq.com>
Date: 星期三, 15 九月 2021 08:22:35 +0800
Subject: [PATCH] 1
---
WebAPI/Controllers/MJGL/Sc_MouldOtherOutBillController.cs | 59 ++++++++++++++++++++++++++++++++++++++++++++++++++---------
1 files changed, 50 insertions(+), 9 deletions(-)
diff --git a/WebAPI/Controllers/MJGL/Sc_MouldOtherOutBillController.cs b/WebAPI/Controllers/MJGL/Sc_MouldOtherOutBillController.cs
index 55338e2..621316e 100644
--- a/WebAPI/Controllers/MJGL/Sc_MouldOtherOutBillController.cs
+++ b/WebAPI/Controllers/MJGL/Sc_MouldOtherOutBillController.cs
@@ -11,19 +11,16 @@
private json objJsonResult = new json();
public DataSet ds = new DataSet();
- #region 妯℃不鍏峰叾浠栧嚭搴撳崟
+ #region 妯℃不鍏峰叾浠栧嚭搴撳崟鍒楄〃
- /// <summary>
- /// 妯℃不鍏峰叾浠栧嚭搴撳崟鍒楄〃 list鍒楄〃鏁版嵁鍔犺浇
- /// </summary>
- /// <returns></returns>
- [Route("Sc_MouldOtherOutBill/GetMouldOtherOutBillList")]
+ [Route("Sc_MouldProdMoveBillList/GetMouldOtherOutBillList")]
[HttpGet]
public object GetMouldOtherOutBillList(string sWhere)
{
try
{
- ds = Sc_MouldOtherOutBillList_s(sWhere);
+
+ ds = Sc_MouldProdMoveBillList(sWhere);
objJsonResult.code = "1";
objJsonResult.count = 1;
objJsonResult.Message = "杩斿洖璁板綍鎴愬姛锛�";
@@ -39,6 +36,51 @@
return objJsonResult;
}
}
+
+ public static DataSet Sc_MouldProdMoveBillList(string sWhere)
+ {
+ if (sWhere == null || sWhere.Equals(""))
+ {
+ return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldOtherOutBillListDetail ", "h_v_Sc_MouldOtherOutBillListDetail");
+ }
+ else
+ {
+ string sql1 = "select * from h_v_Sc_MouldOtherOutBillListDetail where 1 = 1 ";
+ string sql = sql1 + sWhere;
+ return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sc_MouldOtherOutBillListDetail");
+ }
+
+ }
+ #endregion
+
+ //#region 妯℃不鍏峰叾浠栧嚭搴撳崟
+
+ ///// <summary>
+ ///// 妯℃不鍏峰叾浠栧嚭搴撳崟鍒楄〃 list鍒楄〃鏁版嵁鍔犺浇
+ ///// </summary>
+ ///// <returns></returns>
+ //[Route("Sc_MouldOtherOutBill/GetMouldOtherOutBillList")]
+ //[HttpGet]
+ //public object GetMouldOtherOutBillList(string sWhere)
+ //{
+ // try
+ // {
+ // ds = Sc_MouldOtherOutBillList_s(sWhere);
+ // objJsonResult.code = "1";
+ // objJsonResult.count = 1;
+ // objJsonResult.Message = "杩斿洖璁板綍鎴愬姛锛�";
+ // objJsonResult.data = ds.Tables[0];
+ // return objJsonResult;
+ // }
+ // catch (Exception ex)
+ // {
+ // objJsonResult.code = "0";
+ // objJsonResult.count = 0;
+ // objJsonResult.Message = "娌℃湁杩斿洖浠讳綍璁板綍锛�" + ex.ToString();
+ // objJsonResult.data = null;
+ // return objJsonResult;
+ // }
+ //}
#region sql璇彞
@@ -319,7 +361,6 @@
- #endregion
-
+
}
}
\ No newline at end of file
--
Gitblit v1.9.1