public ActionResult GetMemberList()
{
GetMemberListArgs args = RequestArgs <GetMemberListArgs>();
if (args == null)
{
return(RespondResult(false, "参数无效。"));
}
GetItemListResult result =
_memberManager.GetMemberList(UserContext.User.Domain, DomainContext.AppId, args);
return(RespondDataResult(result));
}
public GetItemListResult GetMemberList(Guid domainId, string appId, GetMemberListArgs args)
{
List <CommandParameter> parameterList = new List <CommandParameter>();
parameterList.Add(new CommandParameter("@domainId", domainId));
parameterList.Add(new CommandParameter("@appId", appId));
parameterList.Add(new CommandParameter("@page", args.Page));
parameterList.Add(new CommandParameter("@pageSize", args.PageSize));
//GroupId:-1 全部，-2 已取消关注
if (args.GroupId != -1)
{
parameterList.Add(new CommandParameter("@groupId", args.GroupId));
}
else
{
parameterList.Add(new CommandParameter("@groupId", DBNull.Value));
}
if (String.IsNullOrEmpty(args.NickName) == false)
{
parameterList.Add(new CommandParameter("@nickName", args.NickName));
}
else
{
parameterList.Add(new CommandParameter("@nickName", DBNull.Value));
}
if (String.IsNullOrEmpty(args.MobilePhone) == false)
{
parameterList.Add(new CommandParameter("@mobilePhone", args.MobilePhone));
}
else
{
parameterList.Add(new CommandParameter("@mobilePhone", DBNull.Value));
}
if (String.IsNullOrEmpty(args.CardNumber) == false)
{
parameterList.Add(new CommandParameter("@cardNumber", args.CardNumber));
}
else
{
parameterList.Add(new CommandParameter("@cardNumber", DBNull.Value));
}
DataSet dsResult =
_dataBase.ExecuteDataSet(CommandType.StoredProcedure, "GetMemberList", parameterList, new string[] { "result" });
if (dsResult.Tables[0].Rows.Count == 0 && args.Page > 1)
{
args.Page--;
return(GetMemberList(domainId, appId, args));
}
GetItemListResult result = new GetItemListResult();
result.ItemList = dsResult.Tables[0];
int totalCount = int.Parse(dsResult.Tables[1].Rows[0][0].ToString());
result.TotalPage = totalCount / args.PageSize;
if (totalCount % args.PageSize > 0)
{
result.TotalPage++;
}
result.Page = args.Page;
return(result);
}
