JLApi.git - Gitblit

			@@ -5,6 +5,7 @@
			using System.Data.SqlClient;
			using System.Linq;
			using System.Threading.Tasks;
			using VueWebCoreApi.Models;
			using VueWebCoreApi.Models.UnitMaterial;
			using VueWebCoreApi.Tools;

			@@ -106,6 +107,59 @@
			try
			{
			sql = @"select usergroupcode,usergroupname from TGroup where status='Y'";
			var data = DapperHelper.selectdata(sql, dynamicParams);
			mes.code = "200";
			mes.Message = "查询成功!";
			mes.data = data;
			}
			catch (Exception e)
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.data = null;
			}
			return mes;
			}
			#endregion

			#region[人员基础资料]
			public static ToMessage PersonPermissions()
			{
			var sql = "";
			var dynamicParams = new DynamicParameters();
			string search = "";
			try
			{
			sql = @"select usercode,username from TUser where status='Y'";
			var data = DapperHelper.selectdata(sql, dynamicParams);
			mes.code = "200";
			mes.Message = "查询成功!";
			mes.data = data;
			}
			catch (Exception e)
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.data = null;
			}
			return mes;
			}
			#endregion

			#region[班组查找人员基础资料]
			public static ToMessage GroupsPersonPermissions(string groupcode)
			{
			var sql = "";
			var dynamicParams = new DynamicParameters();
			try
			{
			sql = @"select stuff((select ',' + usercode
			from (select usercode from TUser
			where ',' + group_code + ',' LIKE @groupcode and status='Y') as A
			FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 1, '') AS usercode_list";
			dynamicParams.Add("@groupcode", "%," + groupcode + ",%");
			var data = DapperHelper.selectdata(sql, dynamicParams);
			mes.code = "200";
			mes.Message = "查询成功!";
			@@ -260,6 +314,31 @@
			}
			#endregion

			#region[设备基础资料]
			public static ToMessage EqpPermissions()
			{
			var sql = "";
			var dynamicParams = new DynamicParameters();
			string search = "";
			try
			{
			sql = @"select code,name from TEqpInfo where enable='Y'";
			var data = DapperHelper.selectdata(sql, dynamicParams);
			mes.code = "200";
			mes.Message = "查询成功!";
			mes.data = data;
			}
			catch (Exception e)
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.data = null;
			}
			return mes;
			}
			#endregion

			#region[仓库基础资料]
			public static ToMessage WareHouse()
			{
			@@ -285,6 +364,76 @@
			}
			#endregion

			#region[仓库库位基础资料]
			public static ToMessage WareHouseLocation()
			{
			string sql = "";
			var dynamicParams = new DynamicParameters();
			List<WareHouseLocation> list = new List<WareHouseLocation>();
			try
			{
			//获取仓库数据
			sql = @"select code,name from TSecStck where status='0'";
			var data = DapperHelper.selecttable(sql);
			for (int i = 0; i < data.Rows.Count; i++)
			{
			WareHouseLocation warhouse = new WareHouseLocation();
			warhouse.value = data.Rows[i]["code"].ToString();
			warhouse.text = data.Rows[i]["name"].ToString();
			warhouse.children = new List<LocationData>();
			//获取库位
			sql = @"select code,name from TSecLoca where status='0' and idwarehouse=@idwarehouse";
			dynamicParams.Add("@idwarehouse", data.Rows[i]["code"].ToString());
			var data0 = DapperHelper.selectdata(sql, dynamicParams);
			for (int j = 0; j < data0.Rows.Count; j++)
			{
			LocationData locat = new LocationData();
			locat.value = data0.Rows[j]["code"].ToString();
			locat.text = data0.Rows[j]["name"].ToString();
			warhouse.children.Add(locat);
			}
			list.Add(warhouse);
			}
			mes.code = "200";
			mes.Message = "查询成功!";
			mes.data = list;
			}
			catch (Exception e)
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.data = null;
			}
			return mes;
			}
			#endregion

			#region[仓库查找仓位信息]
			public static ToMessage WareHouseSelectLocation(string warhousecode)
			{
			var sql = "";
			var dynamicParams = new DynamicParameters();
			try
			{
			sql = @"select code,name from TSecLoca where status='0' and idwarehouse=@idwarehouse";
			dynamicParams.Add("@idwarehouse", warhousecode);
			var data = DapperHelper.selectdata(sql, dynamicParams);
			mes.code = "200";
			mes.Message = "查询成功!";
			mes.data = data;
			}
			catch (Exception e)
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.data = null;
			}
			return mes;
			}
			#endregion

			#region[工序基础资料]
			public static ToMessage StepData()
			{
			@@ -293,7 +442,7 @@
			try
			{
			//获取仓库数据
			sql = @"select stepcode,stepname from TStep";
			sql = @"select stepcode,stepname from TStep where enable='Y'";
			var data = DapperHelper.selecttable(sql);
			mes.code = "200";
			mes.Message = "查询成功!";
			@@ -310,5 +459,139 @@
			}
			#endregion

			#region[缺陷基础资料]
			public static ToMessage DefectPermissions()
			{
			var sql = "";
			var dynamicParams = new DynamicParameters();
			string search = "";
			try
			{
			sql = @"select code,name from TDefect";
			var data = DapperHelper.selectdata(sql, dynamicParams);
			mes.code = "200";
			mes.Message = "查询成功!";
			mes.data = data;
			}
			catch (Exception e)
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.data = null;
			}
			return mes;
			}
			#endregion

			#region[往来单位基础资料]
			public static ToMessage CustomerPermissions()
			{
			var sql = "";
			var dynamicParams = new DynamicParameters();
			try
			{
			sql = @"select code,name from TCustomer where status='0'";
			var data = DapperHelper.selectdata(sql, dynamicParams);
			mes.code = "200";
			mes.Message = "查询成功!";
			mes.data = data;
			}
			catch (Exception e)
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.data = null;
			}
			return mes;
			}
			#endregion

			#region[存货树型基础资料]
			public static ToMessage InventoryTreePermissions()
			{
			var sql = "";
			var dynamicParams = new DynamicParameters();
			try
			{
			sql = @"WITH RecursiveCTE AS (
			SELECT code, name, idparent
			FROM TMateriel_Class
			WHERE code in(select distinct idinventoryclass from TMateriel_Info where status='0')
			UNION ALL
			SELECT c.code, c.name, c.idparent
			FROM TMateriel_Class c
			INNER JOIN RecursiveCTE r ON c.code = r.idparent
			)
			SELECT distinct code, name, idparent as parentid
			FROM RecursiveCTE CTE
			union all
			select partcode as code,partname as name,idinventoryclass as parentid
			from TMateriel_Info
			where status='0'";
			var data = DapperHelper.selectdata(sql, dynamicParams);
			mes.code = "200";
			mes.Message = "查询成功!";
			mes.data = data;
			}
			catch (Exception e)
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.data = null;
			}
			return mes;
			}
			#endregion

			#region[模具检验项目下拉列表]
			public static ToMessage MouldCheckItemSelect()
			{
			string sql = "";
			try
			{
			//获取模具点检项目数据
			sql = @"select code,name,description from TMouldchk_Item";
			var data = DapperHelper.selecttable(sql);
			mes.code = "200";
			mes.Message = "查询成功!";
			mes.data = data;
			}
			catch (Exception e)
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.data = null;
			}
			return mes;
			}
			#endregion

			#region[模具保养项目下拉列表]
			public static ToMessage MouldRepairItemSelect()
			{
			string sql = "";
			try
			{
			//获取模具保养项目数据
			sql = @"select code,name,description from TMouldmai_Item";
			var data = DapperHelper.selecttable(sql);
			mes.code = "200";
			mes.Message = "查询成功!";
			mes.data = data;
			}
			catch (Exception e)
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.data = null;
			}
			return mes;
			}
			#endregion
			}
			}