From c9f2d8386d02da81fe65479e7ecd53fc0c8c7569 Mon Sep 17 00:00:00 2001 From: ch <37327@LLOOCCY> Date: 星期一, 01 十一月 2021 10:24:24 +0800 Subject: [PATCH] nothing --- WebAPI/Controllers/BaseSet/Gy_OrderBackInfoController.cs | 62 +++++++++++++++--------------- 1 files changed, 31 insertions(+), 31 deletions(-) diff --git a/WebAPI/Controllers/BaseSet/Gy_OrderBackInfoController.cs b/WebAPI/Controllers/BaseSet/Gy_OrderBackInfoController.cs index 4e46692..ac5da5a 100644 --- a/WebAPI/Controllers/BaseSet/Gy_OrderBackInfoController.cs +++ b/WebAPI/Controllers/BaseSet/Gy_OrderBackInfoController.cs @@ -1,4 +1,4 @@ -锘縰sing DBUtility; +using DBUtility; using Newtonsoft.Json.Linq; using System; using System.Collections.Generic; @@ -8,17 +8,17 @@ using System.Net.Http; using System.Web.Http; using WebAPI.Models; - + namespace WebAPI.Controllers.BaseSet { public class Gy_OrderBackInfoController : ApiController { public DBUtility.ClsPub.Enum_BillStatus BillStatus; - + private json objJsonResult = new json(); SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); DataSet ds; - + #region 璁㈠崟鍙嶉鐘舵�佸垪琛ㄦ暟鎹� /// <summary> /// 杩斿洖璁㈠崟鍙嶉鐘舵�佸垪琛� @@ -68,7 +68,7 @@ } } #endregion - + #region 璁㈠崟鍙嶉鐘舵�佹牴鎹爲鍨婭D鏌ヨ鎵�鏈夊眰绾у垪琛ㄦ暟鎹� /// <summary> /// 鏍规嵁鏍戝瀷ID 鏌ユ壘璁板綍 @@ -81,7 +81,7 @@ { try { - + //ds = oCN.RunProcReturn("select * from h_v_IF_RepairCheckList where HitemID=" + HInterID, "h_v_IF_RepairCheckList"); ds = oCN.RunProcReturn(string.Format(@"WITH a AS (SELECT * FROM dbo.h_v_Gy_OrderBackInfoList WHERE HitemID=" + HInterID + " UNION ALL SELECT s.* FROM dbo.h_v_Gy_OrderBackInfoList AS s,a WHERE s.parentid=a.HitemID) SELECT * FROM a"), "h_v_Gy_OrderBackInfoList"); if (ds == null || ds.Tables[0].Rows.Count == 0) @@ -111,7 +111,7 @@ } } #endregion - + #region 鍒犻櫎璁㈠崟鍙嶉鐘舵�� /// <summary> /// 璁㈠崟鍙嶉鐘舵�佸垪琛ㄥ垹闄ゆ寜閽� @@ -122,11 +122,11 @@ [HttpGet] public object Delete_Json(long HItemID, string User, string ModRightNameDelete) { - + try { ds = oCN.RunProcReturn("delete from Gy_OrderBackInfo where HItemID = " + HItemID, "Gy_OrderBackInfo"); - + objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "鍒犻櫎鎴愬姛"; @@ -143,7 +143,7 @@ } } #endregion - + #region 璁㈠崟鍙嶉鐘舵�佹柊澧炰繚瀛� /// <summary> /// 璁㈠崟鍙嶉鐘舵��-淇濆瓨鎸夐挳 @@ -160,9 +160,9 @@ string msg1 = _value.ToString(); //鍙嶅簭鍒楀寲 msg1 = "[" + msg1.ToString() + "]"; - + List<Gy_OrderBackInfo> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Gy_OrderBackInfo>>(msg1); - + long HItemID = list[0].HItemID.ToString() == "" ? 0 : list[0].HItemID; string HNumber = list[0].HNumber; string HName = list[0].HName; @@ -172,7 +172,7 @@ string HRemark = list[0].HRemark; bool HStopflag = list[0].HStopflag; bool HUseFlag = list[0].HUseFlag; - + if (!DBUtility.ClsPub.AllowNumber(HNumber)) { objJsonResult.code = "0"; @@ -181,7 +181,7 @@ objJsonResult.data = null; return objJsonResult; } - + //鑻AINDI閲嶅鍒欓噸鏂拌幏鍙� oCN.BeginTran(); //涓昏〃 @@ -213,7 +213,7 @@ } } #endregion - + #region 璁㈠崟鍙嶉鐘舵�佷慨鏀逛繚瀛� /// <summary> /// 淇敼鍗曟嵁-淇濆瓨鎸夐挳 @@ -224,10 +224,10 @@ [HttpPost] public object EditBill([FromBody] JObject oMain) { - + try { - + var _value = oMain["oMain"].ToString(); string msg1 = _value.ToString(); string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); @@ -235,11 +235,11 @@ string msg3 = sArray[1].ToString(); string msg4 = sArray[2].ToString(); string msg5 = sArray[3].ToString(); - + //鍙嶅簭鍒楀寲 msg2 = "[" + msg2.ToString() + "]"; List<Gy_OrderBackInfo> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Gy_OrderBackInfo>>(msg2); - + long HItemID = int.Parse(msg3); string HNumber = list[0].HNumber; string HName = list[0].HName; @@ -249,8 +249,8 @@ string HRemark = list[0].HRemark; bool HStopflag = list[0].HStopflag; bool HUseFlag = list[0].HUseFlag; - - + + //鍒ゆ柇鏉冮檺 if (!ClsPub.Security_Log(msg5, 1, true, msg4)) { @@ -260,8 +260,8 @@ objJsonResult.data = null; return objJsonResult; } - - + + if (!DBUtility.ClsPub.AllowNumber(HNumber)) { objJsonResult.code = "0"; @@ -270,7 +270,7 @@ objJsonResult.data = null; return objJsonResult; } - + //if (oDept.HavSameNumber(HItemID, HNumber)) //{ // objJsonResult.code = "0"; @@ -279,8 +279,8 @@ // objJsonResult.data = null; // return objJsonResult; //} - - + + //鑻AINDI閲嶅鍒欓噸鏂拌幏鍙� oCN.BeginTran(); //涓昏〃 @@ -315,7 +315,7 @@ } } #endregion - + #region 璁㈠崟鍙嶉鐘舵�佷慨鏀硅幏鍙栫粦瀹氭暟鎹� /// <summary> /// 缁翠慨鍒楄〃淇敼鎸夐挳鏂规硶 @@ -329,7 +329,7 @@ try { ds = oCN.RunProcReturn("select * from Gy_OrderBackInfo where HItemID=" + HInterID, "Gy_OrderBackInfo"); - + objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = ""; @@ -346,7 +346,7 @@ } } #endregion - + #region 璁㈠崟鍙嶉鐘舵�佽幏鍙栨爲鍨嬪垪琛ㄦ暟鎹� [Route("Gy_OrderBackInfo/LoadTree")] [HttpGet] @@ -354,9 +354,9 @@ { SQLHelper.ClsCN SubCn = new SQLHelper.ClsCN(); //ds = oCN.RunProcReturn("select * from h_v_IF_GroupList " + sWhere, "h_v_IF_GroupList"); - + ds = oCN.RunProcReturn("select * from h_v_Gy_OrderBackInfoLoadTree", "h_v_Gy_OrderBackInfoLoadTree"); - + objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "Sucess锛�"; -- Gitblit v1.9.1