~yxj/MES-WEB-API.git

			@@ -20,6 +20,9 @@
			DataSet ds;


			#region 维修方式

			#region 维修方式加载列表
			/// <summary>
			/// 返回维修方式列表
			///参数：string sql。
			@@ -67,8 +70,9 @@
			return objJsonResult;
			}
			}
			#endregion


			#region 维修方式根据树型id查询列表
			/// <summary>
			/// 根据基础资料ID 查找记录
			///参数：string sql。
			@@ -81,7 +85,7 @@
			try
			{

			ds = oCN.RunProcReturn("select * from h_v_IF_RepairTypeList where HitemID=" + HInterID, "h_v_IF_RepairTypeList");
			ds = oCN.RunProcReturn(string.Format(@"WITH a AS (SELECT * FROM dbo.h_v_IF_RepairTypeList WHERE HitemID="+ HInterID + " UNION ALL SELECT s.* FROM dbo.h_v_IF_RepairTypeList AS s,a WHERE s.parentid=a.HitemID) SELECT * FROM a"), "h_v_IF_RepairTypeList");
			if (ds == null \|\| ds.Tables[0].Rows.Count == 0)
			{
			objJsonResult.code = "0";
			@@ -108,7 +112,9 @@
			return objJsonResult;
			}
			}
			#endregion

			#region 维修方式删除
			/// <summary>
			/// 维修方式列表删除按钮
			///参数：string sql。
			@@ -122,7 +128,7 @@
			DAL.ClsGy_RepairType_View oDeptHlp = new DAL.ClsGy_RepairType_View();
			try
			{
			if (!DBUtility.ClsPub.Security_Log(ModRightNameDelete, 1, true, User))
			if (!DBUtility.ClsPub.Security_Log(ModRightNameDelete, 1, false, User))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			@@ -187,73 +193,9 @@
			return objJsonResult;
			}
			}
			#endregion

			//[Route("Gy_Department/LoadTree")]
			//[HttpGet]
			//public object LoadTree_Json()
			//{
			// DBUtility.Gy_BaseFun.LoadTree(tv, imageList1, this.Text, BillName);
			//}


			/// <summary>
			/// 维修方式列表禁用按钮
			///参数：string sql。
			///返回值：object。
			/// </summary>
			[Route("Gy_MaintenanceMode/JY_Json")]
			[HttpGet]
			public object JY_Json(long HItemID)
			{
			try
			{
			ds = oCN.RunProcReturn("update Gy_Department set HStopFlag = 1 where HItemID = " + HItemID, "Gy_Department");

			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "禁用成功";
			objJsonResult.data = null;
			return objJsonResult;
			}
			catch (Exception e)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "Exception！" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}

			/// <summary>
			/// 维修方式列表反禁用按钮
			///参数：string sql。
			///返回值：object。
			/// </summary>
			[Route("Gy_MaintenanceMode/FJY_Json")]
			[HttpGet]
			public object FJY_Json(long HItemID)
			{
			try
			{
			ds = oCN.RunProcReturn("update Gy_Department set HStopFlag = 0 where HItemID = " + HItemID, "Gy_Department");

			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "反禁用成功";
			objJsonResult.data = null;
			return objJsonResult;
			}
			catch (Exception e)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "Exception！" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}

			#region 维修方式新增保存
			/// <summary>
			/// 新增单据-保存按钮
			///参数：string sql。
			@@ -277,7 +219,7 @@

			List<MaintenanceMode> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<MaintenanceMode>>(msg1);

			long HItemID = list[0].HItemID;
			long HItemID = list[0].HItemID.ToString() == "" ? 0 : list[0].HItemID;
			string HNumber = list[0].HNumber;
			string HName = list[0].HName;
			string HShortNumber = list[0].HNumber;
			@@ -305,10 +247,13 @@
			oCN.RunProc("Insert Into Gy_RepairType " +
			"(HNumber,HName,HHelpCode,HShortNumber,HParentID" +
			",HLevel,HEndFlag,HStopflag,HRemark) " +
			" values('" + HNumber + "','"+ HName + "','"+ HHelpCode + "','" + HShortNumber + "','0'" +
			" values('" + HNumber + "','"+ HName + "','"+ HHelpCode + "','" + HShortNumber + "','" + HItemID + "'" +
			",'1',0,'" + HStopflag + "','"+ HRemark + "')");
			//修改上级为非末级代码
			oCN.RunProc("Update Gy_RepairType set HEndflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo);
			if (list[0].HItemID.ToString() != "")
			{
			oCN.RunProc("Update Gy_RepairType set HEndflag=0 where HItemID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo);
			}
			oCN.Commit();
			objJsonResult.code = "1";
			objJsonResult.count = 1;
			@@ -326,8 +271,9 @@
			return objJsonResult;
			}
			}
			#endregion


			#region 维修方式修改保存
			/// <summary>
			/// 修改单据-保存按钮
			///参数：string sql。
			@@ -358,7 +304,7 @@
			string HNumber = list[0].HNumber;
			string HName = list[0].HName;
			string HShortNumber = list[0].HNumber;
			long HParentID = list[0].HParentID;
			long HParentID = list[0].HParentID.ToString() == "" ? 0 : list[0].HParentID;
			string HHelpCode = list[0].HHelpCode;
			string HRemark = list[0].HRemark;
			string HStopflag = list[0].HStopflag;
			@@ -366,7 +312,7 @@


			//判断权限
			if (!ClsPub.Security_Log(msg5, 1, true, msg4))
			if (!ClsPub.Security_Log(msg5, 1, false, msg4))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			@@ -406,7 +352,7 @@
			",HStopflag='" + HStopflag + "'" +
			",HRemark= '" + HRemark + "' Where HItemID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo);
			//修改子项目代码
			//oCN.RunProc("exec h_p_Gy_UpdateNumber Gy_Department,'" + HNumber + ".','" + this.HOldNumber + ".'", ref DBUtility.ClsPub.sExeReturnInfo);
			//oCN.RunProc("exec h_p_Gy_UpdateNumber Gy_RepairType,'" + HNumber + ".','" + this.HOldNumber + ".'", ref DBUtility.ClsPub.sExeReturnInfo);
			//将上级为非末级
			oCN.RunProc("Update Gy_RepairType set HEndflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo);
			//
			@@ -427,6 +373,7 @@
			return objJsonResult;
			}
			}
			#endregion


			/// <summary>
			@@ -459,6 +406,8 @@
			}


			#region 维修方式修改获取选中数据

			/// <summary>
			/// 维修列表修改按钮方法
			///参数：string sql。
			@@ -487,8 +436,10 @@
			return objJsonResult;
			}
			}
			#endregion


			#region 维修方式获取树型数据

			[Route("Gy_MaintenanceMode/LoadTree")]
			[HttpGet]
			@@ -515,7 +466,9 @@
			return objJsonResult;
			}
			}
			#endregion

			#endregion


			//