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";
                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

    }
}