/// <summary>
/// 获取用户列表
/// </summary>
/// <param name="page"></param>
/// <returns></returns>
public RequestResult QueryUserRoleList(ReqBasePage page, string userId)
{
var roleList = _roleShareBll.GetPageList(x => !x.RoleId.Equals(""), x => x.RoleSeq, out int total, page.pageSize, page.pageIndex);
var pageList = ResBasePage <Sys_Role> .GetInstance(roleList, total);
return(RequestResult.Success(ExecutSuccessMsgEnum.QuerySuccess.GetRemark(), pageList));
}
/// <summary>
/// 获取用户信息
/// </summary>
/// <param name="userid"></param>
/// <param name="page"></param>
/// <returns></returns>
public List <ResUserInfoAPI> GetUserInfo(string userid, ReqBasePage page)
{
string sql = string.Format(@"exec Common_PageList '{0}','{1}','{2}',{3},{4},'{5}',{6}",
"Sys_User", "*", !string.IsNullOrWhiteSpace(userid) ? string.Format(" userid=''{0}''", userid) : "1=1",
page.pageIndex, page.pageSize, "userid", 0);
//第一 net fk4.8环境下已经改善字符拼接写法
string field = !string.IsNullOrWhiteSpace(userid) ? string.Format(" userid=''{0}''", userid) : "1 = 1";
string sql1 = $"exec Common_PageList '{"Sys_User"}''{"*"}''{ field}'{page.pageIndex},{page.pageSize}'{"userid"}',{0}";
//第二，可以用这种方式声明，简单明了
SqlParameter[] m_parms = new SqlParameter[7]
{
new SqlParameter("@tab", "Sys_User"),
new SqlParameter("@strFld", "*"),
new SqlParameter("@strWhere", field),
new SqlParameter("@PageIndex", page.pageIndex),
new SqlParameter("@PageSize", page.pageSize),
new SqlParameter("@Sort", "userid"),
new SqlParameter("@IsGetCount", 0)
};
string sql2 = $"exec Common_PageList @tab,@strFld,@strWhere,@PageIndex,@PageSize,@Sort,@IsGetCount";
using (var db = CurrentContext)
{
var result = db.Database.SqlQuery <ResUserInfoAPI>(sql2, m_parms).ToList();
db.Database.Log = (x) => Log.Write(LogLevel.Info, x); ///这个是获取db的sql执行代码，内部委托
return(result);
}
}
public ActionResult QueryNavMenuList(ReqBasePage page)
{
var userId = Session[ConstString.SysUserLoginId];
var userRole = new NavMenuAction(_menuShareBll, _navMenuBll);
var result = userRole.QueryNavMenuList(page, userId.ToString());
return(RequestAction(result));
}
public ActionResult QueryUserRoleList(ReqBasePage page)
{
var userId = Session[ConstString.SysUserLoginId];
var userRole = new UserRoleManagementAction(_roleShareBll);
var result = userRole.QueryUserRoleList(page, userId.ToString());
return(RequestAction(result));
}
public ActionResult QueryUserList(ReqBasePage page)
{
var userId = Session[ConstString.SysUserLoginId];
var userList = _userShareBll.GetPageList(x => !x.UserId.Equals(""), x => x.UserSeq, out int total, page.pageSize, page.pageIndex);
var pageList = ResBasePage <Sys_User> .GetInstance(userList, total);
var result = RequestResult.Success(ExecutSuccessMsgEnum.QuerySuccess.GetRemark(), pageList);
return(RequestAction(result));
}
public ActionResult GetUserInfo(string userid, ReqBasePage page)
{
var userId = Session[ConstString.SysUserLoginId];
if (userId == null)
{
return(Json(ResMessage.CreatMessage(QueryUserMenu.NullUser)));
}
var userinfo = _userBll.GetUserInfo(userid, page);
if (userinfo != null)
{
return(Json(ResMessage.CreatMessage(ResultTypeEnum.Success, "获取用户信息成功", userinfo)));
}
return(Json(ResMessage.CreatMessage(ResultTypeEnum.Error, "当前没有数据", userinfo)));
}
/// <summary>
/// 获取菜单列表
/// </summary>
/// <param name="page"></param>
/// <param name="userId"></param>
/// <returns></returns>
public RequestResult QueryNavMenuList(ReqBasePage page, string userId)
{
//用户菜单信息
var userMenus = _navMenuBll.GetNavMenuByUserId(userId);
userMenus.ForEach(x =>
{
x.Url = x.Url ?? "#";
x.IconClass = x.IconClass ?? "icon icon-target";
x.IconUrl = string.Format("<i class='{0}'></i>", x.IconClass);
});
var menuList = userMenus.OrderBy(x => x.Seq)
.Skip((page.pageIndex - 1) * page.pageSize)
.Take(page.pageSize).ToList();
var pageList = ResBasePage <Sys_NavMenu> .GetInstance(menuList, userMenus.Count);
ResMessage.CreatMessage(ResultTypeEnum.Success, null, pageList);
return(RequestResult.Success("", pageList));
}
/// <summary>
/// API获取菜单列表
/// </summary>
/// <param name="page"></param>
/// <returns></returns>
public ResMessage APIQueryNavMenus(ReqBasePage page)
{
//用户菜单信息
var userMenus = _menuShareBll.LoadEntities();
var menuList = userMenus.OrderBy(x => x.Seq)
.Skip((page.pageIndex - 1) * page.pageSize)
.Take(page.pageSize).ToList();
var userMenuAPI = menuList.Select(x => new ResUserMenuAPI
{
MenuId = x.MenuId,
MenuName = x.MenuName,
ParentMenId = x.ParentMenId,
Level = x.Level,
Url = x.Url,
IconClass = x.IconClass,
IconUrl = x.IconUrl,
Seq = x.Seq ?? 0
}).ToList();
var pageList = ResBasePage <ResUserMenuAPI> .GetInstance(userMenuAPI, userMenus.Count);
return(ResMessage.CreatMessage(ResultTypeEnum.Success, null, pageList));
}
public List <ResUserInfoAPI> GetUserInfo(string userid, ReqBasePage page)
{
return(_user.GetUserInfo(userid, page));
}
