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_OrderLevController.cs | 68 +++++++++++++++++-----------------
1 files changed, 34 insertions(+), 34 deletions(-)
diff --git a/WebAPI/Controllers/BaseSet/Gy_OrderLevController.cs b/WebAPI/Controllers/BaseSet/Gy_OrderLevController.cs
index d68528f..814dedf 100644
--- a/WebAPI/Controllers/BaseSet/Gy_OrderLevController.cs
+++ b/WebAPI/Controllers/BaseSet/Gy_OrderLevController.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_OrderLevController : 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 璁㈠崟绛夌骇鏍规嵁鏍戝瀷ID鏌ヨ鎵�鏈夊眰绾у垪琛ㄦ暟鎹�
/// <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_OrderLevList WHERE HitemID=" + HInterID + " UNION ALL SELECT s.* FROM dbo.h_v_Gy_OrderLevList AS s,a WHERE s.parentid=a.HitemID) SELECT * FROM a"), "h_v_Gy_OrderLevList");
if (ds == null || ds.Tables[0].Rows.Count == 0)
@@ -111,7 +111,7 @@
}
}
#endregion
-
+
#region 鍒犻櫎璁㈠崟绛夌骇
/// <summary>
/// 璁㈠崟绛夌骇鍒楄〃鍒犻櫎鎸夐挳
@@ -175,7 +175,7 @@
}
}
//ds = oCN.RunProcReturn("delete from Gy_Department where HItemID = " + HItemID, "Gy_Department");
-
+
objJsonResult.code = "1";
objJsonResult.count = 1;
objJsonResult.Message = "鍒犻櫎鎴愬姛";
@@ -192,7 +192,7 @@
}
}
#endregion
-
+
#region 璁㈠崟绛夌骇鏂板淇濆瓨
/// <summary>
/// 璁㈠崟绛夌骇-淇濆瓨鎸夐挳
@@ -209,14 +209,14 @@
string msg1 = _value.ToString();
//鍙嶅簭鍒楀寲
msg1 = "[" + msg1.ToString() + "]";
-
+
DAL.ClsGy_OrderLev_Ctl oDept = new DAL.ClsGy_OrderLev_Ctl();
DAL.ClsGy_OrderLev_View oDeptHlp = new DAL.ClsGy_OrderLev_View();
-
-
-
+
+
+
List<Gy_OrderLevList> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Gy_OrderLevList>>(msg1);
-
+
long HItemID = list[0].HItemID.ToString() == "" ? 0 : list[0].HItemID;
string HNumber = list[0].HNumber;
string HName = list[0].HName;
@@ -227,7 +227,7 @@
string HYX = list[0].HYX;
bool HStopflag = list[0].HStopflag;
bool HUseFlag = list[0].HUseFlag;
-
+
if (!DBUtility.ClsPub.AllowNumber(HNumber))
{
objJsonResult.code = "0";
@@ -236,7 +236,7 @@
objJsonResult.data = null;
return objJsonResult;
}
-
+
//鑻AINDI閲嶅鍒欓噸鏂拌幏鍙�
oCN.BeginTran();
//涓昏〃
@@ -268,7 +268,7 @@
}
}
#endregion
-
+
#region 璁㈠崟绛夌骇淇敼淇濆瓨
/// <summary>
/// 淇敼鍗曟嵁-淇濆瓨鎸夐挳
@@ -279,12 +279,12 @@
[HttpPost]
public object EditBill([FromBody] JObject oMain)
{
-
+
try
{
DAL.ClsGy_OrderLev_Ctl oDept = new DAL.ClsGy_OrderLev_Ctl();
DAL.ClsGy_OrderLev_View oDeptHlp = new DAL.ClsGy_OrderLev_View();
-
+
var _value = oMain["oMain"].ToString();
string msg1 = _value.ToString();
string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
@@ -292,11 +292,11 @@
string msg3 = sArray[1].ToString();
string msg4 = sArray[2].ToString();
string msg5 = sArray[3].ToString();
-
+
//鍙嶅簭鍒楀寲
msg2 = "[" + msg2.ToString() + "]";
List<Gy_OrderLevList> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Gy_OrderLevList>>(msg2);
-
+
long HItemID = int.Parse(msg3);
string HNumber = list[0].HNumber;
string HName = list[0].HName;
@@ -307,8 +307,8 @@
string HRemark = list[0].HRemark;
bool HStopflag = list[0].HStopflag;
bool HUseFlag = list[0].HUseFlag;
-
-
+
+
//鍒ゆ柇鏉冮檺
if (!ClsPub.Security_Log(msg5, 1, true, msg4))
{
@@ -318,8 +318,8 @@
objJsonResult.data = null;
return objJsonResult;
}
-
-
+
+
if (!DBUtility.ClsPub.AllowNumber(HNumber))
{
objJsonResult.code = "0";
@@ -328,7 +328,7 @@
objJsonResult.data = null;
return objJsonResult;
}
-
+
if (oDept.HavSameNumber(HItemID, HNumber))
{
objJsonResult.code = "0";
@@ -337,8 +337,8 @@
objJsonResult.data = null;
return objJsonResult;
}
-
-
+
+
//鑻AINDI閲嶅鍒欓噸鏂拌幏鍙�
oCN.BeginTran();
//涓昏〃
@@ -374,7 +374,7 @@
}
}
#endregion
-
+
#region 璁㈠崟绛夌骇淇敼鑾峰彇缁戝畾鏁版嵁
/// <summary>
/// 缁翠慨鍒楄〃淇敼鎸夐挳鏂规硶
@@ -388,7 +388,7 @@
try
{
ds = oCN.RunProcReturn("select * from Gy_OrderLev where HItemID=" + HInterID, "Gy_OrderLev");
-
+
objJsonResult.code = "1";
objJsonResult.count = 1;
objJsonResult.Message = "";
@@ -405,7 +405,7 @@
}
}
#endregion
-
+
#region 璁㈠崟绛夌骇鑾峰彇鏍戝瀷鍒楄〃鏁版嵁
[Route("Gy_OrderLev/LoadTree")]
[HttpGet]
@@ -413,9 +413,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_OrderLevLoadTree", "h_v_Gy_OrderLevLoadTree");
-
+
objJsonResult.code = "1";
objJsonResult.count = 1;
objJsonResult.Message = "Sucess锛�";
@@ -424,4 +424,4 @@
}
#endregion
}
-}
+}
\ No newline at end of file
--
Gitblit v1.9.1