From da00f1a9f67ddcc1f4d543c43fd9ec7cd19b45be Mon Sep 17 00:00:00 2001
From: 王 垚 <1402714037@qq.com>
Date: 星期一, 01 十一月 2021 09:38:46 +0800
Subject: [PATCH] nothing
---
WebAPI/Controllers/BaseSet/Gy_OrderBackInfoController.cs | 143 ++++++++++++++---------------------------------
1 files changed, 42 insertions(+), 101 deletions(-)
diff --git a/WebAPI/Controllers/BaseSet/Gy_OrderLevController.cs.txt b/WebAPI/Controllers/BaseSet/Gy_OrderBackInfoController.cs
similarity index 67%
rename from WebAPI/Controllers/BaseSet/Gy_OrderLevController.cs.txt
rename to WebAPI/Controllers/BaseSet/Gy_OrderBackInfoController.cs
index 814dedf..ac5da5a 100644
--- a/WebAPI/Controllers/BaseSet/Gy_OrderLevController.cs.txt
+++ b/WebAPI/Controllers/BaseSet/Gy_OrderBackInfoController.cs
@@ -11,7 +11,7 @@
namespace WebAPI.Controllers.BaseSet
{
- public class Gy_OrderLevController : ApiController
+ public class Gy_OrderBackInfoController : ApiController
{
public DBUtility.ClsPub.Enum_BillStatus BillStatus;
@@ -19,13 +19,13 @@
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
DataSet ds;
- #region 璁㈠崟绛夌骇鍒楄〃鏁版嵁
+ #region 璁㈠崟鍙嶉鐘舵�佸垪琛ㄦ暟鎹�
/// <summary>
- /// 杩斿洖璁㈠崟绛夌骇鍒楄〃
+ /// 杩斿洖璁㈠崟鍙嶉鐘舵�佸垪琛�
///鍙傛暟锛歴tring sql銆�
///杩斿洖鍊硷細object銆�
/// </summary>
- [Route("Gy_OrderLev/list")]
+ [Route("Gy_OrderBackInfo/list")]
[HttpGet]
public object list(string sWhere)
{
@@ -33,13 +33,13 @@
{
if (sWhere == null || sWhere.Equals(""))
{
- ds = oCN.RunProcReturn("select * from h_v_Gy_OrderLevList " + sWhere, "h_v_Gy_OrderLevList");
+ ds = oCN.RunProcReturn("select * from h_v_Gy_OrderBackInfoList " + sWhere, "h_v_Gy_OrderBackInfoList");
}
else
{
- string sql1 = "select * from h_v_Gy_OrderLevList where 1 = 1 ";
+ string sql1 = "select * from h_v_Gy_OrderBackInfoList where 1 = 1 ";
string sql = sql1 + sWhere;
- ds = oCN.RunProcReturn(sql, "h_v_Gy_OrderLevList");
+ ds = oCN.RunProcReturn(sql, "h_v_Gy_OrderBackInfoList");
}
if (ds == null || ds.Tables[0].Rows.Count == 0)
{
@@ -69,13 +69,13 @@
}
#endregion
- #region 璁㈠崟绛夌骇鏍规嵁鏍戝瀷ID鏌ヨ鎵�鏈夊眰绾у垪琛ㄦ暟鎹�
+ #region 璁㈠崟鍙嶉鐘舵�佹牴鎹爲鍨婭D鏌ヨ鎵�鏈夊眰绾у垪琛ㄦ暟鎹�
/// <summary>
/// 鏍规嵁鏍戝瀷ID 鏌ユ壘璁板綍
///鍙傛暟锛歴tring sql銆�
///杩斿洖鍊硷細object銆�
/// </summary>
- [Route("Gy_OrderLev/cx")]
+ [Route("Gy_OrderBackInfo/cx")]
[HttpGet]
public object cx(long HInterID)
{
@@ -83,7 +83,7 @@
{
//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");
+ 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)
{
objJsonResult.code = "0";
@@ -112,69 +112,20 @@
}
#endregion
- #region 鍒犻櫎璁㈠崟绛夌骇
+ #region 鍒犻櫎璁㈠崟鍙嶉鐘舵��
/// <summary>
- /// 璁㈠崟绛夌骇鍒楄〃鍒犻櫎鎸夐挳
+ /// 璁㈠崟鍙嶉鐘舵�佸垪琛ㄥ垹闄ゆ寜閽�
///鍙傛暟锛歴tring sql銆�
///杩斿洖鍊硷細object銆�
/// </summary>
- [Route("Gy_OrderLev/Delete_Json")]
+ [Route("Gy_OrderBackInfo/Delete_Json")]
[HttpGet]
public object Delete_Json(long HItemID, string User, string ModRightNameDelete)
{
- DAL.ClsGy_OrderLev_Ctl oDept = new DAL.ClsGy_OrderLev_Ctl();
- DAL.ClsGy_OrderLev_View oDeptHlp = new DAL.ClsGy_OrderLev_View();
+
try
{
- if (!DBUtility.ClsPub.Security_Log(ModRightNameDelete, 1, true, User))
- {
- objJsonResult.code = "0";
- objJsonResult.count = 0;
- objJsonResult.Message = "娌℃湁鍒犻櫎鏉冮檺";
- objJsonResult.data = null;
- return objJsonResult;
- }
- if (oDeptHlp.GetInfoByID(HItemID))
- {
- if (oDept.HavChildCodes(HItemID))
- {
- objJsonResult.code = "0";
- objJsonResult.count = 0;
- objJsonResult.Message = "姝ら」鐩瓨鍦ㄥ瓙椤圭洰,涓嶈兘鍒犻櫎锛�";
- objJsonResult.data = null;
- return objJsonResult;
- }
- //鍒犻櫎鍓嶅垽鏂槸鍚� 宸蹭娇鐢� 20141020
- if (oDeptHlp.omodel.HUseFlag != "鏈娇鐢�")
- {
- objJsonResult.code = "0";
- objJsonResult.count = 0;
- objJsonResult.Message = "姝ら」鐩凡浣跨敤鎴栬�呮湭妫�娴嬶紝涓嶈兘鍒犻櫎锛佽閲嶆柊妫�娴嬪啀鍒犻櫎锛�";
- objJsonResult.data = null;
- return objJsonResult;
- }
- //
- if (oDept.DeleteByID(HItemID))
- {
- //鍐欏叆鏃ュ織
- ClsPub.Add_Log("", "鍒犻櫎椤圭洰锛屼唬鐮侊細" + oDeptHlp.omodel.HNumber + ",鍚嶇О锛�" + oDeptHlp.omodel.HName, ClsPub.CurUserName);
- //鏇存柊涓婄骇涓� 鏈骇
- objJsonResult.code = "1";
- objJsonResult.count = 1;
- objJsonResult.Message = "鍒犻櫎鎴愬姛";
- objJsonResult.data = null;
- return objJsonResult;
- }
- else
- {
- objJsonResult.code = "0";
- objJsonResult.count = 0;
- objJsonResult.Message = "鍒犻櫎澶辫触";
- objJsonResult.data = null;
- return objJsonResult;
- }
- }
- //ds = oCN.RunProcReturn("delete from Gy_Department where HItemID = " + HItemID, "Gy_Department");
+ ds = oCN.RunProcReturn("delete from Gy_OrderBackInfo where HItemID = " + HItemID, "Gy_OrderBackInfo");
objJsonResult.code = "1";
objJsonResult.count = 1;
@@ -193,13 +144,13 @@
}
#endregion
- #region 璁㈠崟绛夌骇鏂板淇濆瓨
+ #region 璁㈠崟鍙嶉鐘舵�佹柊澧炰繚瀛�
/// <summary>
- /// 璁㈠崟绛夌骇-淇濆瓨鎸夐挳
+ /// 璁㈠崟鍙嶉鐘舵��-淇濆瓨鎸夐挳
///鍙傛暟锛歴tring sql銆�
///杩斿洖鍊硷細object銆�
/// </summary>
- [Route("Gy_OrderLev/AddBill")]
+ [Route("Gy_OrderBackInfo/AddBill")]
[HttpPost]
public object AddBill([FromBody] JObject oMain)
{
@@ -210,12 +161,7 @@
//鍙嶅簭鍒楀寲
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);
+ 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;
@@ -224,7 +170,6 @@
long HParentID = list[0].HParentID;
string HHelpCode = list[0].HHelpCode;
string HRemark = list[0].HRemark;
- string HYX = list[0].HYX;
bool HStopflag = list[0].HStopflag;
bool HUseFlag = list[0].HUseFlag;
@@ -240,15 +185,15 @@
//鑻AINDI閲嶅鍒欓噸鏂拌幏鍙�
oCN.BeginTran();
//涓昏〃
- oCN.RunProc("Insert Into Gy_OrderLev " +
+ oCN.RunProc("Insert Into Gy_OrderBackInfo " +
"(HNumber,HName,HHelpCode,HShortNumber,HParentID" +
- ",HLevel,HEndFlag,HStopflag,HRemark,HUseFlag,HYX) " +
+ ",HLevel,HEndFlag,HStopflag,HRemark,HUseFlag) " +
" values('" + HNumber + "','" + HName + "','" + HHelpCode + "','" + HShortNumber + "','" + HItemID + "'" +
- ",'1',0,'" + Convert.ToString(HStopflag ? 1 : 0) + "','" + HRemark + "','鏈娇鐢�','" + HYX + "')");
+ ",'1',0,'" + Convert.ToString(HStopflag ? 1 : 0) + "','" + HRemark + "','鏈娇鐢�')");
//淇敼涓婄骇涓洪潪鏈骇浠ｇ爜
if (list[0].HItemID.ToString() != "")
{
- oCN.RunProc("Update Gy_OrderLev set HEndflag=0 where HItemID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo);
+ oCN.RunProc("Update Gy_OrderBackInfo set HEndflag=0 where HItemID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo);
}
oCN.Commit();
objJsonResult.code = "1";
@@ -269,21 +214,19 @@
}
#endregion
- #region 璁㈠崟绛夌骇淇敼淇濆瓨
+ #region 璁㈠崟鍙嶉鐘舵�佷慨鏀逛繚瀛�
/// <summary>
/// 淇敼鍗曟嵁-淇濆瓨鎸夐挳
///鍙傛暟锛歴tring sql銆�
///杩斿洖鍊硷細object銆�
/// </summary>
- [Route("Gy_OrderLev/EditBill")]
+ [Route("Gy_OrderBackInfo/EditBill")]
[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();
@@ -295,7 +238,7 @@
//鍙嶅簭鍒楀寲
msg2 = "[" + msg2.ToString() + "]";
- List<Gy_OrderLevList> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Gy_OrderLevList>>(msg2);
+ List<Gy_OrderBackInfo> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Gy_OrderBackInfo>>(msg2);
long HItemID = int.Parse(msg3);
string HNumber = list[0].HNumber;
@@ -303,7 +246,6 @@
string HShortNumber = list[0].HNumber;
long HParentID = list[0].HParentID.ToString() == "" ? 0 : list[0].HParentID;
string HHelpCode = list[0].HHelpCode;
- string HYX = list[0].HYX;
string HRemark = list[0].HRemark;
bool HStopflag = list[0].HStopflag;
bool HUseFlag = list[0].HUseFlag;
@@ -329,32 +271,31 @@
return objJsonResult;
}
- if (oDept.HavSameNumber(HItemID, HNumber))
- {
- objJsonResult.code = "0";
- objJsonResult.count = 0;
- objJsonResult.Message = "浠ｇ爜閲嶅锛�";
- objJsonResult.data = null;
- return objJsonResult;
- }
+ //if (oDept.HavSameNumber(HItemID, HNumber))
+ //{
+ // objJsonResult.code = "0";
+ // objJsonResult.count = 0;
+ // objJsonResult.Message = "浠ｇ爜閲嶅锛�";
+ // objJsonResult.data = null;
+ // return objJsonResult;
+ //}
//鑻AINDI閲嶅鍒欓噸鏂拌幏鍙�
oCN.BeginTran();
//涓昏〃
- oCN.RunProc("Update Gy_OrderLev set " +
+ oCN.RunProc("Update Gy_OrderBackInfo set " +
" HNumber='" + HNumber + "'" +
",HName='" + HName + "'" +
",HShortNumber='" + HShortNumber + "'" +
",HHelpCode='" + HHelpCode + "'" +
- ",HYX='" + HYX + "'" +
",HParentID=" + HParentID +
",HStopflag='" + Convert.ToString(HStopflag ? 1 : 0) + "'" +
",HRemark= '" + HRemark + "' Where HItemID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo);
//淇敼瀛愰」鐩唬鐮�
//oCN.RunProc("exec h_p_Gy_UpdateNumber Gy_RepairCheck,'" + HNumber + ".','" + this.HOldNumber + ".'", ref DBUtility.ClsPub.sExeReturnInfo);
//灏嗕笂绾� 涓洪潪鏈骇
- oCN.RunProc("Update Gy_OrderLev set HEndflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo);
+ oCN.RunProc("Update Gy_OrderBackInfo set HEndflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo);
//
oCN.Commit();
objJsonResult.code = "1";
@@ -375,19 +316,19 @@
}
#endregion
- #region 璁㈠崟绛夌骇淇敼鑾峰彇缁戝畾鏁版嵁
+ #region 璁㈠崟鍙嶉鐘舵�佷慨鏀硅幏鍙栫粦瀹氭暟鎹�
/// <summary>
/// 缁翠慨鍒楄〃淇敼鎸夐挳鏂规硶
///鍙傛暟锛歴tring sql銆�
///杩斿洖鍊硷細object銆�
/// </summary>
- [Route("Gy_OrderLev/xg")]
+ [Route("Gy_OrderBackInfo/xg")]
[HttpGet]
public object xg(long HInterID)
{
try
{
- ds = oCN.RunProcReturn("select * from Gy_OrderLev where HItemID=" + HInterID, "Gy_OrderLev");
+ ds = oCN.RunProcReturn("select * from Gy_OrderBackInfo where HItemID=" + HInterID, "Gy_OrderBackInfo");
objJsonResult.code = "1";
objJsonResult.count = 1;
@@ -406,15 +347,15 @@
}
#endregion
- #region 璁㈠崟绛夌骇鑾峰彇鏍戝瀷鍒楄〃鏁版嵁
- [Route("Gy_OrderLev/LoadTree")]
+ #region 璁㈠崟鍙嶉鐘舵�佽幏鍙栨爲鍨嬪垪琛ㄦ暟鎹�
+ [Route("Gy_OrderBackInfo/LoadTree")]
[HttpGet]
public object LoadTree_Json(string sWhere)
{
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");
+ ds = oCN.RunProcReturn("select * from h_v_Gy_OrderBackInfoLoadTree", "h_v_Gy_OrderBackInfoLoadTree");
objJsonResult.code = "1";
objJsonResult.count = 1;
--
Gitblit v1.9.1