/// <summary>
/// 系统用户分页列表
/// </summary>
/// <param name="filter">筛选条件</param>
/// <returns>用户分页列表</returns>
/// <remarks>
/// 2013-08-05 黄志勇 创建
/// 2016-03-23 陈海裕 修改 若用户为代理商，则只能看到自身及其创建的用户
/// </remarks>
public Pager <CBSyUser> GetSyUser(ParaSyUserFilter filter)
{
if (Authentication.AdminAuthenticationBo.Instance.Current.IsAgent && !Authentication.AdminAuthenticationBo.Instance.Current.IsBindAllDealer)
{
filter.CreatedBy = Authentication.AdminAuthenticationBo.Instance.Current.Base.SysNo;
}
var pager = ISyUserDao.Instance.GetSyUser(filter);
return(pager);
}
/// <summary>
/// 用户列表分页
/// </summary>
/// <param name="filter">传入的实体参数</param>
/// <returns>用户信息</returns>
/// <remarks>2013-07-16 黄志勇 添加</remarks>
public override Pager <CBSyUser> GetSyUser(ParaSyUserFilter filter)
{
const string sql =
@"(select distinct a.sysno, a.Account, a.UserName, a.MobilePhoneNumber, a.EmailAddress, a.Status, a.CreatedDate, a.CreatedBy, a.LastUpdateDate, a.LastUpdateBy
from SyUser a
left join SyGroupUser b on a.sysno=b.UserSysNo
where
(@0 is null or CHARINDEX(a.Account,@0)>0) and --帐号
(@1 is null or CHARINDEX(a.UserName,@1)>0) and --姓名
(@2 is null or CHARINDEX(a.MobilePhoneNumber,@2)>0) and --手机号
(@3 is null or CHARINDEX(convert(varchar(4),a.Status),convert(varchar(4),@3))>0) and --状态
(@4 is null or exists (select 1 from SyGroupUser sgu where sgu.GroupSysNo = @4 and sgu.UserSysNo = a.SysNo)) and --用户组
(@5 is null or exists (select 1 from SyUserWarehouse suw where suw.WarehouseSysNo = @5 and suw.UserSysNo = a.SysNo)) and --仓库
(@6 is null or (@6=a.CreatedBy or a.sysno=@6))
) tb";
var paras = new object[]
{
filter.Account,
filter.UserName,
filter.MobilePhoneNumber,
filter.Status,
filter.GroupSysNo,
filter.WarehouseSysNo,
filter.CreatedBy
};
var dataList = Context.Select <CBSyUser>("tb.*").From(sql);
var dataCount = Context.Select <int>("count(0)").From(sql);
dataList.Parameters(paras);
dataCount.Parameters(paras);
var pager = new Pager <CBSyUser>
{
PageSize = filter.PageSize,
CurrentPage = filter.Id
};
pager.TotalRows = dataCount.QuerySingle();
var list = dataList.OrderBy("tb.SysNo desc").Paging(pager.CurrentPage, filter.PageSize).QueryMany();
if (list != null && list.Count > 0)
{
foreach (var item in list)
{
item.GroupUsers = GetGroupUser(item.SysNo);
}
}
pager.Rows = list;
return(pager);
}
public ActionResult GetUserPageIndex(int?id, int?status, int?levelSysNo, int?emailStatus, int?mobilePhoneStatus, int?isReceiveEmail, int?isReceiveShortMessage, int?isPublicAccount, int?isLevelFixed, int?isExperiencePointFixed, int?isExperienceCoinFixed, string account = null, int agentSysNo = 0, int dealerSysNo = 0)
{
ParaSyUserFilter filter = new ParaSyUserFilter();
filter.Id = id == null?1:(int)id;
filter.Status = status;
filter.Account = account;
IDictionary <int, string> dictStatus = EnumUtil.ToDictionary(typeof(CustomerStatus.会员状态));
ViewBag.dictStatus = dictStatus;
var pager = SyUserBo.Instance.GetSyUser(filter);
var list = new PagedList <CBSyUser>
{
TData = pager.Rows,
CurrentPageIndex = pager.CurrentPage,
TotalItemCount = pager.TotalRows
};
if (Request.IsAjaxRequest())
{
return(PartialView("_AjaxCrCustomer", list));
}
return(View(list));
}
/// <summary> /// 用户列表分页 /// </summary> /// <param name="filter">传入的实体参数</param> /// <returns>用户信息</returns> /// <remarks>2013-07-16 黄志勇 添加</remarks> public abstract Pager <CBSyUser> GetSyUser(ParaSyUserFilter filter);
