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;

			@@ -33,14 +34,39 @@
			sql = @"select * from TOrganization where status='Y'";
			var data = DapperHelper.selectdata(sql, dynamicParams);
			mes.code = "200";
			mes.Message = "查询成功!";
			mes.message = "查询成功!";
			mes.data = data;
			}
			catch (Exception e)
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			}
			#endregion

			#region[组织架构基础资料(无公司)]
			public static ToMessage PrentOrganizationNoCompany()
			{
			var sql = "";
			var dynamicParams = new DynamicParameters();
			string search = "";
			try
			{
			sql = @"select * from TOrganization where status='Y' and parent_id<>'0' or leve<>'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;
			@@ -58,14 +84,14 @@
			sql = @"select postcode,postname from TPost where status='Y'";
			var data = DapperHelper.selectdata(sql, dynamicParams);
			mes.code = "200";
			mes.Message = "查询成功!";
			mes.message = "查询成功!";
			mes.data = data;
			}
			catch (Exception e)
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -83,14 +109,14 @@
			sql = @"select rolecode,rolename from TRole where status='Y'";
			var data = DapperHelper.selectdata(sql, dynamicParams);
			mes.code = "200";
			mes.Message = "查询成功!";
			mes.message = "查询成功!";
			mes.data = data;
			}
			catch (Exception e)
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -108,14 +134,67 @@
			sql = @"select usergroupcode,usergroupname from TGroup where status='Y'";
			var data = DapperHelper.selectdata(sql, dynamicParams);
			mes.code = "200";
			mes.Message = "查询成功!";
			mes.message = "查询成功!";
			mes.data = data;
			}
			catch (Exception e)
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			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 = "查询成功!";
			mes.data = data;
			}
			catch (Exception e)
			{
			mes.code = "300";
			mes.count = 0;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -133,14 +212,14 @@
			if (data.Rows.Count > 0)
			{
			mes.code = "200";
			mes.Message = "查询成功!";
			mes.message = "查询成功!";
			mes.data = data;
			}
			else
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "无按钮档案数据!";
			mes.message = "无按钮档案数据!";
			mes.data = null;
			}
			}
			@@ -148,7 +227,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -166,14 +245,14 @@
			if (data.Rows.Count > 0)
			{
			mes.code = "200";
			mes.Message = "查询成功!";
			mes.message = "查询成功!";
			mes.data = data;
			}
			else
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "无数据权限档案数据!";
			mes.message = "无数据权限档案数据!";
			mes.data = null;
			}
			}
			@@ -181,7 +260,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -203,7 +282,7 @@
			from TUnit where isSingleUnit='1' and isGroup='0' and disabled='0'";
			var data = DapperHelper.selecttable(sql);
			mes.code = "200";
			mes.Message = "查询成功!";
			mes.message = "查询成功!";
			mes.data = data;
			}
			if (tunittype == "M")
			@@ -220,7 +299,7 @@
			data[i].children = data0;
			}
			mes.code = "200";
			mes.Message = "查询成功!";
			mes.message = "查询成功!";
			mes.data = data;
			}
			}
			@@ -228,7 +307,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -246,14 +325,39 @@
			sql = @"select code,name from TEqpType";
			var data = DapperHelper.selecttable(sql);
			mes.code = "200";
			mes.Message = "查询成功!";
			mes.message = "查询成功!";
			mes.data = data;
			}
			catch (Exception e)
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			}
			#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;
			@@ -271,14 +375,84 @@
			sql = @"select code,name from TSecStck";
			var data = DapperHelper.selecttable(sql);
			mes.code = "200";
			mes.Message = "查询成功!";
			mes.message = "查询成功!";
			mes.data = data;
			}
			catch (Exception e)
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			}
			#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,depth 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;
			@@ -296,19 +470,153 @@
			sql = @"select stepcode,stepname from TStep where enable='Y'";
			var data = DapperHelper.selecttable(sql);
			mes.code = "200";
			mes.Message = "查询成功!";
			mes.message = "查询成功!";
			mes.data = data;
			}
			catch (Exception e)
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			}
			#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
			}
			}