MES-WEB-API.git

			@@ -1150,7 +1150,52 @@
			}
			}

			/// <summary>
			/// 获取仓库列表 --添加模具仓库条件用于只查询模具仓库
			/// </summary>
			/// <returns></returns>
			[Route("Web/GetWarehouseList_Json_MJ")]
			[HttpGet]
			public object GetWarehouseList_Json_MJ(string Warehouse, Int64 HOrgID)
			{
			sWhere = " Where HStopFlag=0 and HEndFlag=1 and HWarehouseType='模具仓库' and HUSEORGID =" + HOrgID + "";
			//sWhere = " Where HStopFlag=0 and HEndFlag=1 and HUSEORGID = " + DBUtility.ClsPub.HORGANIZATIONSID.ToString();
			if (Warehouse != "")
			{
			sWhere = sWhere + " and ( HNumber like '%" + Warehouse + "%' or HName like '%" + Warehouse + "%' or HUSEORGID like '%" + Warehouse + "%' ) ";
			}

			try
			{
			WebS.WebService1 oWeb = new WebS.WebService1();
			ds = oWeb.GetWarehouseList(sWhere, ref DBUtility.ClsPub.sErrInfo);
			if (ds == null \|\| ds.Tables[0].Rows.Count <= 0)
			{
			objjson.code = "0";
			objjson.count = 0;
			objjson.Message = "获取失败" + DBUtility.ClsPub.sErrInfo;
			objjson.data = null;
			return objjson;
			}
			else
			{
			objjson.code = "0";
			objjson.count = 1;
			objjson.Message = "获取成功!";
			objjson.data = ds.Tables[0];
			return objjson;
			}
			}
			catch (Exception ex)
			{

			objjson.code = "0";
			objjson.count = 0;
			objjson.Message = "获取失败" + ex.ToString();
			objjson.data = null;
			return objjson;
			}
			}

			/// <summary>
			/// 获取仓位列表
			@@ -1466,14 +1511,68 @@
			}
			}

			#region 获取职员列表 (添加车间筛选)
			[Route("Web/GetEmployeeList_Json")]
			[HttpGet]
			public object GetEmployeeList_Json3(string Employee, Int64 HGroupID, Int64 HDeptID = -1)
			{
			// 给部门(车间)ID设置默认值，当没有传入值或者值为0的时候，走旧有的函数，否则走新的逻辑
			if(HDeptID == -1 \|\| HDeptID == 0)
			{
			return GetEmployeeList_Json2(Employee, HGroupID);
			}else
			{
			sWhere = $" Where HStopFlag=0 and HEndFlag=1 and HDeptID=${HDeptID}";

			if(Employee != "")
			{
			sWhere += " and ( HNumber like '%" + Employee + "%' or HName like '%" + Employee + "%' )";
			}
			if(HGroupID != 0)
			{
			sWhere += " and HGroupID=" + HGroupID.ToString();
			}

			try
			{
			string sql = $"Select * from h_v_IF_Emp {sWhere} Order by HNumber";
			ds = oCN.RunProcReturn(sql, "h_v_IF_Emp");
			if (ds == null \|\| ds.Tables[0].Rows.Count <= 0)
			{
			// 如果递入部门没有维护人员列表则降级使用老方案
			return GetEmployeeList_Json2(Employee, HGroupID);
			}
			else
			{
			objjson.code = "0";
			objjson.count = 1;
			objjson.Message = "获取成功!";
			objjson.data = ds.Tables[0];
			return objjson;
			}
			}
			catch (Exception ex)
			{

			objjson.code = "0";
			objjson.count = 0;
			objjson.Message = "获取失败" + ex.ToString();
			objjson.data = null;
			return objjson;
			}

			}
			}
			#endregion


			/// <summary>
			/// 获取职员列表
			/// </summary>
			/// <returns></returns>
			[Route("Web/GetEmployeeList_Json")]
			[HttpGet]
			public object GetEmployeeList_Json(string Employee, Int64 HGroupID)
			// [Route("Web/GetEmployeeList_Json")]
			// [HttpGet]
			public object GetEmployeeList_Json2(string Employee, Int64 HGroupID)
			{
			sWhere = " Where HStopFlag=0 and HEndFlag=1";
			//sWhere = " Where HStopFlag=0 and HEndFlag=1 and HUSEORGID = " + DBUtility.ClsPub.HORGANIZATIONSID.ToString();
			@@ -1492,11 +1591,11 @@
			{
			if (Employee != "")
			{
			sWhere = " Where HStopFlag=0 and HWHID=" + HGroupID.ToString() + " and ( HNumber like '%" + Employee + "%' or HName like '%" + Employee + "%' ) ";
			sWhere = " Where HStopFlag=0 and HGroupID=" + HGroupID.ToString() + " and ( HNumber like '%" + Employee + "%' or HName like '%" + Employee + "%' ) ";
			}
			else
			{
			sWhere = " Where HStopFlag=0 and HWHID=" + HGroupID.ToString();
			sWhere = " Where HStopFlag=0 and HGroupID=" + HGroupID.ToString();
			}
			}
			try
			@@ -1531,6 +1630,7 @@
			}
			}



			/// <summary>
			/// 获取班次列表
			@@ -20070,7 +20170,7 @@
			List<object> columnNameList = new List<object>();

			SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
			string sql = "Select * from h_v_Gy_GetSampleSchemeListView where 1 = 1 " + sWhere + "Order by hmainid ";
			string sql = "Select * from h_v_Gy_GetSampleSchemeListView where 1 = 1 and HUSEORGID = "+OrganizationID + sWhere + "Order by hmainid ";
			ds = oCN.RunProcReturn(sql, "h_v_Gy_GetSampleSchemeListView");

			//添加列名
			@@ -23175,5 +23275,255 @@
			}
			}
			#endregion

			#region 用于连接的健康度检验，只要能访问通这个接口，则表明连接可用
			[Route("Health")]
			[HttpGet]
			public IHttpActionResult CheckHealth()
			{
			// 返回 200 状态码确认健康状态
			return Ok();
			}
			#endregion

			#region 登录用户与设备ClientID 的关系写入数据库
			[Route("Web/SetGy_UserClientIdConnection")]
			[HttpPost]
			public object SetGy_UserClientIdConnection([FromBody] JObject msg)
			{
			DataSet ds;
			oCN.BeginTran();
			try
			{
			ds = oCN.RunProcReturn($@"exec h_p_SetGy_UserClientIdRelation
			@HUserbm=N'{msg["HUserbm"].ToString()}',
			@HUserName=N'{msg["HUserName"].ToString()}',
			@HClientID=N'{msg["HClientID"].ToString()}',
			@HOnline={msg["HOnline"].ToString()}
			", "h_p_SetGy_UserClientIdRelation");

			if(ds.Tables[0].Rows[0]["HStatus"].ToString() == "1")
			{
			oCN.Commit();
			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "保存设备信息成功！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			else
			{
			oCN.RollBack();
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "保存设备信息失败！" + ds.Tables[0].Rows[0]["msg"];
			objJsonResult.data = null;
			return objJsonResult;
			}
			}catch(Exception e)
			{
			oCN.RollBack();
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "保存设备信息失败！" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			#endregion

			#region APP 根据模块获取该模块下需要显示消息标识的子模块
			[Route("Web/getMessageIdentified")]
			[HttpGet]
			public object getMessageIdentified(string user, string moduleName)
			{
			DataSet oDs = oCN.RunProcReturn($"exec h_p_getMessageIdentifier_APP '{user}', '{moduleName}'", "h_p_getMessageIdentifier_APP");
			if(oDs == null \|\| oDs.Tables[0].Rows.Count == 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "获取消息标识失败！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			else
			{
			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "获取消息标识成功！";
			objJsonResult.data = oDs.Tables[0];
			return objJsonResult;
			}
			}
			#endregion

			#region 模具待上模查询获取
			[Route("Web/getSc_MouldUpperAwaitQuery")]
			[HttpGet]
			public object getSc_MouldUpperAwaitQuery(string user, string HBeginDate = "", string HEndDate = "")
			{
			if(HBeginDate == "") // 默认7天间距
			{
			HBeginDate = DateTime.Now.AddDays(-7).ToString("yyyy-MM-dd");
			}

			if(HEndDate == "")
			{
			HEndDate = DateTime.Today.ToString("yyyy-MM-dd");
			}
			List<object> columnNameList = new List<object>();
			try
			{
			DataSet oDs = oCN.RunProcReturn($" exec h_p_Sc_MouldUpperAwaitQuery '{user}', '{HBeginDate}', '{HEndDate}'", "h_p_Sc_MouldUpperAwaitQuery");
			if(oDs == null \|\| oDs.Tables[0].Rows.Count == 0)
			{
			objjson.code = "0";
			objjson.count = 0;
			objjson.Message = "获取失败, 单据无返回值!";
			objjson.data = null;
			return objjson;
			}else
			{
			//添加列名
			foreach (DataColumn col in oDs.Tables[0].Columns)
			{
			Type dataType = col.DataType;
			string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}";
			columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//获取到DataColumn列对象的列名
			}

			objjson.code = "1";
			objjson.count = 1;
			objjson.Message = "获取成功!";
			objjson.data = oDs.Tables[0];
			objjson.list = columnNameList;
			return objjson;
			}

			}catch(Exception ex)
			{
			LogService.Write(ex.ToString());
			objjson.code = "0";
			objjson.count = 0;
			objjson.Message = "获取失败" + ex.Message.ToString();
			objjson.data = null;
			return objjson;
			}
			}
			#endregion

			#region 待开工列表获取
			[Route("Web/getCj_StationInBillAwaitQuery")]
			[HttpGet]
			public object getCj_StationInBillAwaitQuery(string user, string HBeginDate = "", string HEndDate = "")
			{
			if (HBeginDate == "") // 默认7天间距
			{
			HBeginDate = DateTime.Now.AddDays(-7).ToString("yyyy-MM-dd");
			}

			if (HEndDate == "")
			{
			HEndDate = DateTime.Today.ToString("yyyy-MM-dd");
			}
			List<object> columnNameList = new List<object>();
			try
			{
			DataSet oDs = oCN.RunProcReturn($" exec h_p_Cj_StationInBillAwaitQuery '{user}', '{HBeginDate}', '{HEndDate}'", "h_p_Cj_StationInBillAwaitQuery");
			if (oDs == null \|\| oDs.Tables[0].Rows.Count == 0)
			{
			objjson.code = "0";
			objjson.count = 0;
			objjson.Message = "获取失败, 单据无返回值!";
			objjson.data = null;
			return objjson;
			}
			else
			{
			//添加列名
			foreach (DataColumn col in oDs.Tables[0].Columns)
			{
			Type dataType = col.DataType;
			string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}";
			columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//获取到DataColumn列对象的列名
			}

			objjson.code = "1";
			objjson.count = 1;
			objjson.Message = "获取成功!";
			objjson.data = oDs.Tables[0];
			objjson.list = columnNameList;
			return objjson;
			}

			}
			catch (Exception ex)
			{
			LogService.Write(ex.ToString());
			objjson.code = "0";
			objjson.count = 0;
			objjson.Message = "获取失败" + ex.Message.ToString();
			objjson.data = null;
			return objjson;
			}
			}
			#endregion

			#region 模具待下模查询获取
			[Route("Web/getSc_MouldLowerBillAwaitQuery")]
			[HttpGet]
			public object getSc_MouldLowerBillAwaitQuery(string user, string HBeginDate = "", string HEndDate = "")
			{
			if (HBeginDate == "") // 默认7天间距
			{
			HBeginDate = DateTime.Now.AddDays(-7).ToString("yyyy-MM-dd");
			}

			if (HEndDate == "")
			{
			HEndDate = DateTime.Today.ToString("yyyy-MM-dd");
			}
			List<object> columnNameList = new List<object>();
			try
			{
			DataSet oDs = oCN.RunProcReturn($" exec h_p_Sc_MouldLowerBillAwaitQuery '{user}', '{HBeginDate}', '{HEndDate}'", "h_p_Sc_MouldLowerBillAwaitQuery");
			if (oDs == null \|\| oDs.Tables[0].Rows.Count == 0)
			{
			objjson.code = "0";
			objjson.count = 0;
			objjson.Message = "获取失败, 单据无返回值!";
			objjson.data = null;
			return objjson;
			}
			else
			{
			//添加列名
			foreach (DataColumn col in oDs.Tables[0].Columns)
			{
			Type dataType = col.DataType;
			string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}";
			columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//获取到DataColumn列对象的列名
			}

			objjson.code = "1";
			objjson.count = 1;
			objjson.Message = "获取成功!";
			objjson.data = oDs.Tables[0];
			objjson.list = columnNameList;
			return objjson;
			}

			}
			catch (Exception ex)
			{
			LogService.Write(ex.ToString());
			objjson.code = "0";
			objjson.count = 0;
			objjson.Message = "获取失败" + ex.Message.ToString();
			objjson.data = null;
			return objjson;
			}
			}
			#endregion
			}
			}