MES-WEB-API.git

			@@ -1,4 +1,5 @@
			using DBUtility;
			using Newtonsoft.Json;
			using Newtonsoft.Json.Linq;
			using System;
			using System.Collections.Generic;
			@@ -26,6 +27,7 @@
			{
			try
			{
			List<object> columnNameList = new List<object>();
			if (!DBUtility.ClsPub.Security_Log("Sb_EquipMaintainPlanBillList", 1, false, user))
			{
			objJsonResult.code = "0";
			@@ -46,11 +48,19 @@
			ds = oCN.RunProcReturn(sql, "h_v_Sc_EquipMaintainPlan");
			}


			//添加列名
			foreach (DataColumn col in ds.Tables[0].Columns)
			{
			Type dataType = col.DataType;
			string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}";
			columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//获取到DataColumn列对象的列名
			}

			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "Sucess！";
			objJsonResult.data = ds.Tables[0];
			objJsonResult.list = columnNameList;
			return objJsonResult;
			}
			catch (Exception ex)
			@@ -69,6 +79,59 @@
			public static DataSet Sb_EquipMaintainPlanBillList_s(string sWhere)
			{
			return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sb_EquipMaintainPlanBillList ", "h_v_Sb_EquipMaintainPlanBillList");
			}
			#endregion

			#region 设备保养计划表分页查询
			[Route("Sb_EquipMaintainPlanBill/GetEquipMaintainPlanBillListPage")]
			[HttpGet]
			public object GetEquipMaintainPlanBillListPage(string sWhere, string user, int page, int size)
			{
			try
			{
			List<object> columnNameList = new List<object>();
			//编辑权限
			if (!DBUtility.ClsPub.Security_Log_second("Sb_EquipMaintainPlanBillList", 3, false, user))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "无查看权限！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			sWhere = sWhere.Replace("'", "''");
			if (sWhere == null \|\| sWhere.Equals(""))
			{
			ds = oCN.RunProcReturn("exec h_p_Sc_EquipMaintainPlanListPage " + page + "," + size + ",''", "h_p_Sc_EquipMaintainPlanListPage");
			}
			else
			{
			ds = oCN.RunProcReturn("exec h_p_Sc_EquipMaintainPlanListPage " + page + "," + size + ",'" + sWhere + "'", "h_p_Sc_EquipMaintainPlanListPage");
			}

			//添加列名
			foreach (DataColumn col in ds.Tables[0].Columns)
			{
			Type dataType = col.DataType;
			string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}";
			columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//获取到DataColumn列对象的列名
			}

			objJsonResult.code = "1";
			objJsonResult.count = int.Parse(ds.Tables[1].Rows[0]["count"].ToString());
			objJsonResult.Message = "Sucess！";
			objJsonResult.list = columnNameList;
			objJsonResult.data = ds.Tables[0];
			return objJsonResult;
			}
			catch (Exception e)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "Exception！" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			#endregion

			@@ -113,6 +176,8 @@
			UserName = oItem.HMaker; //制单人
			oItem.HBillType = "3902";
			oItem.HBillSubType = "3902";
			oItem.HMainSourceInterID = oItem.HMouldMaintainRuleID;
			oItem.HMainSourceBillNo = oItem.HMouldMaintainRuleNo;

			//oItem.HInterID =0;
			//oItem.HBillNo = "";
			@@ -413,6 +478,93 @@
			}
			#endregion

			#region[设备保养记录表，选保养计划获取保养计划清单信息]
			[Route("Sb_EquipMaintainPlanBill/Sb_EquipMaintainPlanBill_PlanList")]
			[HttpGet]
			public object Sb_EquipMaintainPlanBill_PlanList(string HInterID, string HDate)
			{
			DataSet ds,ds1;
			try
			{
			SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();

			List<DataTable> tableList = new List<DataTable>();

			//获取保养项目
			ds = oCN.RunProcReturn("exec h_p_Sb_EquipMaintain_GetPlanList " + HInterID + ",'" + HDate + "'", "h_p_Sb_EquipMaintain_GetPlanList");

			//获取配件项目编辑数据
			string sql1 = "select HMaterID, 配件代码 HMaterNumber,配件名称 HMaterName,单位ID HUnitID,单位代码 HUnitNumber,单位名称 HUnitName,用量 HQty,标准用量 HQtyMust,表体备注 HRemark,负责人ID HManagerID,负责人代码 HManagerNumber,负责人 HManagerName from h_v_Sb_EquipMaintainPlanBillList where 1 = 1 and hmainid = " + HInterID;
			ds1 = oCN.RunProcReturn(sql1, "h_v_Sb_EquipMaintainPlanBillList");

			tableList.Add(ds.Tables[0]);
			tableList.Add(ds1.Tables[0]);

			if (ds.Tables[0].Rows.Count != 0 \|\| ds != null)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "获取信息成功！";
			objJsonResult.data = tableList;
			}
			else
			{
			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "没有查询到数据信息！";
			objJsonResult.data = tableList;
			}
			}
			catch (Exception e)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "发生异常，没有返回任何计划！" + e.ToString();
			objJsonResult.data = null;
			}
			return objJsonResult;
			}
			#endregion

			#region[设备保养计划表编辑时获取表体数据--保养计划]
			[Route("Sb_EquipMaintainPlanBill/GetPlanList")]
			[HttpGet]
			public object GetPlanList(string sqlWhere)
			{
			DataSet ds;
			try
			{
			SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
			if (sqlWhere == null \|\| sqlWhere.Equals(""))
			{
			ds = oCN.RunProcReturn("select * from h_v_Sb_EquipMaintainPlanList", "h_v_Sb_EquipMaintainPlanList");
			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "获取信息成功！";
			objJsonResult.data = ds.Tables[0];
			}
			else
			{
			string sql1 = "select * from h_v_Sb_EquipMaintainPlanList where 1 = 1 ";
			string sql = sql1 + sqlWhere;
			ds = oCN.RunProcReturn(sql, "h_v_Sb_EquipMaintainPlanList");
			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "获取信息成功！";
			objJsonResult.data = ds.Tables[0];
			}
			}
			catch (Exception e)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "没有返回任何计划！" + e.ToString();
			objJsonResult.data = null;
			}
			return objJsonResult;
			}
			#endregion

			#region 设备保养计划单审核/反审核功能
			[Route("Sb_EquipMaintainPlanBill/CheckSb_EquipMaintainPlanBill")]
			[HttpGet]
			@@ -453,6 +605,8 @@
			objJsonResult.data = null;
			return objJsonResult;
			}
			//自动生成点检计划单
			oCN.RunProc("exec h_p_Sb_EquipMaintainPlan_Auto " + HInterID);
			}
			else
			{