#region

using System.Collections.Generic;
using System.Data;
using CSFrameworkV5.Common;
using CSFrameworkV5.Core;
using CSFrameworkV5.Interfaces;
using CSFrameworkV5.Interfaces.InterfaceModels;
using CSFrameworkV5.Models;

#endregion

namespace CSFrameworkV5.DataAccess
{
    public class dalPermission : dalBaseDataDict, IBridge_Permission
    {
        public dalPermission(Loginer loginer)
            : base(loginer)
        {
            _Database = DatabaseProvider.SystemDatabase;
        }

        public int DeleteAllMenu()
        {
            var i = _Database.ExecuteSQL("DELETE FROM tb_MyMenu;");
            return i;
        }

        public DataTable GetActionData()
        {
            return new dalActions(_Loginer).GetActionData();
        }

        public DataTable GetChildUser(string account)
        {
            var sp = _Database.CreateSqlProc("usp_GetChildUser");
            sp.AddParam("Account", DbType.String, account);
            return _Database.GetTable(sp.Command, tb_MyUser.__TableName);
        }

        public List<DataPermissionModel> GetDataPermissionConfig(string account)
        {
            var cmd =
                _Database.CreateSqlProc("usp_GetDataPermissionConfigByUser");
            cmd.AddParam("DataSetID", Loginer.CurrentUser.DBID);
            cmd.AddParam("Account", account);
            return _Database
                .ExecuteReaderList<DataPermissionModel>(cmd.Command);
        }

        public DataTable GetDataPermissionConfigByGroup(string groupCode)
        {
            var cmd =
                _Database.CreateSqlProc("usp_GetDataPermissionConfigByGroup");
            cmd.AddParam("DataSetID", Loginer.CurrentUser.DBID);
            cmd.AddParam("GroupCode", groupCode);
            return _Database.GetTable(cmd.Command, "sys_DataPermission");
        }

        public DataTable GetDataPermissionConfigByUser(string account)
        {
            var cmd =
                _Database.CreateSqlProc("usp_GetDataPermissionConfigByUser");
            cmd.AddParam("DataSetID", Loginer.CurrentUser.DBID);
            cmd.AddParam("Account", account);
            return _Database.GetTable(cmd.Command, "sys_DataPermission");
        }

        /// <summary>
        ///     获取自定义按钮名称
        /// </summary>
        /// <returns></returns>
        public DataTable GetFormTagCustomName()
        {
            var sql =
                $"SELECT * FROM tb_MyFormTagName WHERE DataSetID={_Database.ParamSymboName}DataSetID";
            var sp = _Database.CreateCommand(sql);
            sp.AddParam("DataSetID", DbType.String, _Loginer.DBID);
            return _Database.GetTable(sp.Command, tb_MyFormTagName.__TableName);
        }

        public DataTable GetFormTagName()
        {
            var sql =
                $"SELECT * FROM tb_MyFormTagName WHERE DataSetID={_Database.ParamSymboName}DataSetID";
            var sp = _Database.CreateCommand(sql);
            sp.AddParam("DataSetID", DbType.String, _Loginer.DBID);
            return _Database.GetTable(sp.Command, tb_MyFormTagName.__TableName);
        }

        public DataTable GetGridPermission(string userID)
        {
            var sql =
                $"SELECT * FROM sys_GridPermission WHERE UserId={_Database.ParamSymboName}UserId";
            var cmd = _Database.CreateCommand(sql);
            cmd.AddParam("UserId", userID);
            return _Database.GetTable(cmd.Command, "sys_GridPermission");
        }

        public string GetGridPermissionById(string userID, string viewId)
        {
            var sql =
                $"SELECT HiddenColumns FROM sys_GridPermission WHERE UserId={_Database.ParamSymboName}UserId AND GridId={_Database.ParamSymboName}GridId";
            var cmd = _Database.CreateCommand(sql);
            cmd.AddParam("UserId", userID);
            cmd.AddParam("GridId", viewId);
            var o = _Database.ExecuteScalar(cmd.Command);
            return ConvertEx.ToString(o);
        }

        public DataTable GetLookupMenu()
        {
            var sql =
                $"SELECT MenuName,MenuCaption FROM tb_MyMenu WHERE DataSetID={_Database.ParamSymboName}DataSetID ORDER BY ParentMenuName,MenuName";
            var sp = _Database.CreateCommand(sql);
            sp.AddParam("DataSetID", DbType.String, _Loginer.DBID);
            return _Database.GetTable(sp.Command, tb_MyMenu.__TableName);
        }

        public DataTable GetMenuByUser(string account, string dataSetID)
        {
            var sp = _Database.CreateSqlProc("usp_GetMenuByUser");
            sp.AddParam("DataSetID", DbType.String, dataSetID);
            sp.AddParam("Account", DbType.String, account);
            return _Database.GetTable(sp.Command, tb_MyMenu.__TableName);
        }

        public DataTable GetMenuData()
        {
            return new dalMenu(_Loginer).GetSummaryData();
        }

        public DataTable GetMenuPicker()
        {
            return new dalMenu(_Loginer).GetMenuPicker();
        }

        public DataTable GetModuleData()
        {
            var sql = "SELECT * FROM sys_ModuleFileList";

            return DatabaseProvider.GetDatabase(_Loginer.DBID)
                .GetTable(sql, "sys_ModuleFileList");
        }

        public DataSet GetOwnersByMenu(string menuID)
        {
            var sp = _Database.CreateSqlProc("usp_GetOwnersByMenu");
            sp.AddParam("MenuName", DbType.String, menuID);
            sp.AddParam("DataSetID", DbType.String, _Loginer.DBID);
            var ds = _Database.GetDataSet(sp.Command);
            ds.Tables[0].TableName = tb_MyRole.__TableName;
            ds.Tables[1].TableName = tb_MyGroup.__TableName;
            ds.Tables[2].TableName = tb_MyUser.__TableName;
            return ds;
        }

        public DataTable GetRoleAction(string roleID)
        {
            return new dalRole(_Loginer).GetRoleAction(roleID);
        }

        public DataTable GetRoleData()
        {
            return new dalRole(_Loginer).GetRoleData();
        }

        public DataSet GetRoleOwners(string roleID)
        {
            return new dalRole(_Loginer).GetRoleOwners(roleID);
        }

        public int GetUserActions(string account, string menuName)
        {
            return new dalUser(_Loginer).GetUserActions(account, menuName);
        }

        public DataTable GetUserActionsList(string account)
        {
            return new dalUser(_Loginer).GetUserActionsList(account);
        }

        public bool Init()
        {
            var sp = _Database.CreateSqlProc("usp_InitPermission");
            var i = _Database.ExecuteCommand(sp.Command);
            return true;
        }

        public bool IsExistsAction(int actionValue)
        {
            return new dalActions(_Loginer).IsExistsAction(actionValue);
        }

        public bool IsExistsModule(int moduleID)
        {
            var sql =
                "SELECT COUNT(*) FROM sys_ModuleFileList WHERE ModuleID=" +
                moduleID.ToStringEx();
            var o = DatabaseProvider.GetDatabase(_Loginer.DBID)
                .ExecuteScalar(sql);
            return ConvertEx.ToInt(o) > 0;
        }

        public bool IsExistsRole(string roleID)
        {
            return new dalRole(_Loginer).IsExistsRole(roleID);
        }

        public bool IsOwner(string docUser, string leader)
        {
            var sp = _Database.CreateSqlProc("usp_IsOwner");
            sp.AddParam("DataSetID", DbType.String, _Loginer.DBID);
            sp.AddParam("DocUser", DbType.String, docUser);
            sp.AddParam("Leader", DbType.String, leader);
            var dt = _Database.GetTable(sp.Command);
            return dt.Rows.Count > 0;
        }

        public bool IsUserBelongRole(string user, string roleID)
        {
            var sp = _Database.CreateSqlProc("usp_IsUserBelongRole");
            sp.AddParam("DataSetID", DbType.String, _Loginer.DBID);
            sp.AddParam("Account", DbType.String, user);
            sp.AddParam("RoleID", DbType.String, roleID);
            var dt = _Database.GetTable(sp.Command);
            return dt.Rows.Count > 0;
        }

        public DataTable Query(string roleType, string content)
        {
            var sp = _Database.CreateSqlProc("usp_QueryRole");
            sp.AddParam("RoleType", DbType.String, roleType);
            sp.AddParam("Content", DbType.String, content);
            var dt = _Database.GetTable(sp.Command, "tb_MyRole");
            return dt;
        }

        public bool SaveDataPermission(DataTable data)
        {
            var ds = new DataSet();
            ds.Tables.Add(data.Copy());
            return new dalBaseDataDict(Loginer.CurrentUser,
                    typeof(sys_DataPermission), Globals.DEF_SYSTEM_DBID)
                .Update(ds);
        }

        public bool SaveGridPermission(DataTable data)
        {
            var ds = new DataSet();
            ds.Tables.Add(data.Copy());
            return new dalBaseDataDict(Loginer.CurrentUser,
                    typeof(sys_GridPermission), Globals.DEF_SYSTEM_DBID)
                .Update(ds);
        }
    }
}