using Dapper;
|
using System;
|
using System.Collections.Generic;
|
using System.Data;
|
using System.Data.SqlClient;
|
using System.Linq;
|
using System.Threading.Tasks;
|
using VueWebCoreApi.Models.UnitMaterial;
|
using VueWebCoreApi.Tools;
|
|
namespace VueWebCoreApi.DLL.DAL
|
{
|
public class GeneralBasicDataDAL
|
{
|
public static DataTable dt; //定义全局变量dt
|
public static bool res; //定义全局变量dt
|
public static ToMessage mes = new ToMessage(); //定义全局返回信息对象
|
public static string strProcName = ""; //定义全局sql变量
|
public static List<SqlParameter> listStr = new List<SqlParameter>(); //定义全局参数集合
|
public static SqlParameter[] parameters; //定义全局SqlParameter参数数组
|
public static dynamic CompanyCode = AppSetting.GetAppSetting("CompanyCode");
|
public static dynamic CompanyName = AppSetting.GetAppSetting("CompanyName");
|
|
|
#region [组织架构查找]
|
public static ToMessage PrentOrganization()
|
{
|
var sql = "";
|
var dynamicParams = new DynamicParameters();
|
string search = "";
|
try
|
{
|
sql = @"select * from TOrganization 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 PostPermissions()
|
{
|
var sql = "";
|
var dynamicParams = new DynamicParameters();
|
string search = "";
|
try
|
{
|
sql = @"select postcode,postname from TPost 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 RolePermissions()
|
{
|
var sql = "";
|
var dynamicParams = new DynamicParameters();
|
string search = "";
|
try
|
{
|
sql = @"select rolecode,rolename from TRole 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 GroupsPermissions()
|
{
|
var sql = "";
|
var dynamicParams = new DynamicParameters();
|
string search = "";
|
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 ButtonData()
|
{
|
string sql = "";
|
try
|
{
|
sql = @"select buttoncode,buttonname from TButton";
|
var data = DapperHelper.selecttable(sql);
|
if (data.Rows.Count > 0)
|
{
|
mes.code = "200";
|
mes.Message = "查询成功!";
|
mes.data = data;
|
}
|
else
|
{
|
mes.code = "300";
|
mes.count = 0;
|
mes.Message = "无按钮档案数据!";
|
mes.data = null;
|
}
|
}
|
catch (Exception e)
|
{
|
mes.code = "300";
|
mes.count = 0;
|
mes.Message = e.Message;
|
mes.data = null;
|
}
|
return mes;
|
}
|
#endregion
|
|
#region[数据权限基础资料]
|
public static ToMessage DataPermissions()
|
{
|
string sql = "";
|
try
|
{
|
sql = @"select datacode,dataname from TData";
|
var data = DapperHelper.selecttable(sql);
|
if (data.Rows.Count > 0)
|
{
|
mes.code = "200";
|
mes.Message = "查询成功!";
|
mes.data = data;
|
}
|
else
|
{
|
mes.code = "300";
|
mes.count = 0;
|
mes.Message = "无数据权限档案数据!";
|
mes.data = null;
|
}
|
}
|
catch (Exception e)
|
{
|
mes.code = "300";
|
mes.count = 0;
|
mes.Message = e.Message;
|
mes.data = null;
|
}
|
return mes;
|
}
|
#endregion
|
|
|
#region[单位信息查询]
|
public static ToMessage UnitSerch(string tunittype)
|
{
|
List<Unit> list = new List<Unit>();
|
var dynamicParams = new DynamicParameters();
|
string sql = "";
|
try
|
{
|
if (tunittype == "S")
|
{
|
sql = @"select code as unitcode,name as unitname,isSingleUnit,isMainUnit,isGroup
|
from TUnit where isSingleUnit='1' and isGroup='0' and disabled='0'";
|
var data = DapperHelper.selecttable(sql);
|
mes.code = "200";
|
mes.Message = "查询成功!";
|
mes.data = data;
|
}
|
if (tunittype == "M")
|
{
|
sql = @"select code as unitcode,name as unitname from TUnitGroup";
|
var data = DapperHelper.selectdatalist<Unit>(sql);
|
|
for (int i = 0; i < data.Count; i++)
|
{
|
sql = @"select code as unitcode,name as unitname,isSingleUnit,isMainUnit,isGroup
|
from TUnit where isGroup='1' and disabled='0' and idunitgroup=@unitcode";
|
dynamicParams.Add("@unitcode", data[i].unitcode);
|
var data0 = DapperHelper.select<unitporject>(sql, dynamicParams);
|
data[i].children = data0;
|
}
|
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 DeviceTypeData()
|
{
|
string sql = "";
|
var dynamicParams = new DynamicParameters();
|
try
|
{
|
//获取设备类型数据
|
sql = @"select code,name from TEqpType";
|
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 WareHouse()
|
{
|
string sql = "";
|
var dynamicParams = new DynamicParameters();
|
try
|
{
|
//获取仓库数据
|
sql = @"select code,name from TSecStck";
|
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 StepData()
|
{
|
string sql = "";
|
var dynamicParams = new DynamicParameters();
|
try
|
{
|
//获取仓库数据
|
sql = @"select stepcode,stepname from TStep where enable='Y'";
|
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
|
|
}
|
}
|
