Core/SM/Dal/RoleDal.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Common;
using Common.Data;
using Core.SM.Model;
using Common.Data.Filter;
using Common.Provider;
using System.Data;
using System.Data.SqlClient;
using Common.Data.SqlServer;

namespace Core.SM.Dal
{
    public class RoleDal : BaseRepository<Role>
    {

        public static RoleDal Instance
        {
            get { return SingletonProvider<RoleDal>.Instance; }
        }

       
        /// <summary>
        /// 取得角色授權及按鈕
        /// </summary>
        /// <param name="roleid">角色KeyID</param>
        /// <returns></returns>
        public DataTable GetRoleTreeBtnsBy(params int[] roleid)
        {
            var roleids = roleid.Aggregate("", (current, i) => current + (i.ToString() + ",")).TrimEnd(',');
            string sql = "select a.*,b.ButtonTag from SM_ROLES_DET a join SM_BUTTONS b on a.BtnId=b.KeyId where a.RoleId in (" + roleids + ")";
            return SqlEasy.ExecuteDataTable(sql);
        }

        public string JsonDataForEasyUIdataGrid(int pageindex, int pagesize, string filterJson, string sort = "KeyId", string order = "asc")
        {
            string sortorder = sort + " " + order;

            var pcp = new ProcSmPage("SM_ROLES_MAS")
            {
                PageIndex = pageindex,
                PageSize = pagesize,
                OrderFields = sortorder,
                WhereString = FilterTranslator.ToSql(filterJson)
            };
            int recordCount;
            DataTable dt = base.GetPageWithSp(pcp, out recordCount);
            return JSONhelper.FormatJSONForEasyuiDataGrid(recordCount, dt);

        }






    }
}