Ejemplo n.º 1
0
        /// <summary>
        /// 角色权限
        /// </summary>
        /// <param name="request"></param>
        /// <returns></returns>
        public BsTableDataSource <RoleDetailViewModel> GetRoleDetaileList(GetRoleDetaileList request)
        {
            if (RowID != 1)
            {
                throw new Exception("权限异常");
            }
            using (var db = DbFactory.Open())
            {
                var builder = db.From <RoleDetail>();
                if (null != request.rid && request.rid.Value > 0)
                {
                    builder.Where(w => w.RoleID == request.rid);
                }
                var count = db.Select(builder).Count;

                if (!string.IsNullOrEmpty(request.Sort) && !string.IsNullOrEmpty(request.Order) && request.Order == "asc")
                {
                    builder.OrderBy(o => request.Sort);
                }
                else if (!string.IsNullOrEmpty(request.Sort) && !string.IsNullOrEmpty(request.Order) && request.Order == "desc")
                {
                    builder.OrderByDescending(o => request.Sort);
                }
                else
                {
                    builder.OrderBy(o => o.RoleDetailID);
                }
                var PageSize  = request.PageSize == 0 ? 15 : request.PageSize;
                var PageIndex = request.PageIndex == 0 ? 0 : (request.PageIndex) * PageSize;
                builder.Limit(PageIndex, PageSize);
                var RList = db.Select <RoleDetailViewModel>(builder);
                return(new BsTableDataSource <RoleDetailViewModel>()
                {
                    rows = RList, total = count
                });
            }
        }
 public BsTableDataSource <RoleDetailViewModel> Get(GetRoleDetaileList request)
 {
     return(ColumnManager.GetRoleDetaileList(request));
 }