public void ProcessRequest(HttpContext context) { int rows = Convert.ToInt32(context.Request["rows"]); int page = Convert.ToInt32(context.Request["page"]); string member = context.Request["member"]; string up_member = context.Request["up_member"]; string reg_member = context.Request["reg_member"]; string empty_bill = context.Request["empty_bill"]; string true_bill = context.Request["true_bill"]; string apply_pass = context.Request["apply_pass"]; string apply_other = context.Request["apply_other"]; string has_img = context.Request["has_img"]; string no_img = context.Request["no_img"]; string apply_cancel = context.Request["apply_cancel"]; string is_cancel = context.Request["is_cancel"]; string start = context.Request["start"]; string end = context.Request["end"]; string min_level = context.Request["min_level"]; string level_num = context.Request["level_num"]; string websiteOwner = bll.WebsiteOwner; string distributionOwners = ""; if (!string.IsNullOrWhiteSpace(up_member)) { distributionOwners = bllUser.GetSpreadUserIds(up_member, websiteOwner); } string regUserIds = ""; if (!string.IsNullOrWhiteSpace(reg_member)) { regUserIds = bllUser.GetSpreadUserIds(reg_member, websiteOwner); } string bill = ""; if (empty_bill == "1" && true_bill != "1") { bill = "1"; } else if (empty_bill != "1" && true_bill == "1") { bill = "0"; } string apply = ""; if (apply_pass == "1" && apply_other != "1") { apply = "1"; } else if (apply_pass != "1" && apply_other == "1") { apply = "0"; } string hasImg = ""; if (has_img == "1" && no_img != "1") { hasImg = "1"; } else if (has_img != "1" && no_img == "1") { hasImg = "0"; } if (!string.IsNullOrWhiteSpace(end)) { end = Convert.ToDateTime(end).AddDays(1).ToString("yyyy-MM-dd"); } int total = bll.GetShMemberCount(websiteOwner, min_level, member, distributionOwners, regUserIds, bill, apply, hasImg, start, end, level_num, apply_cancel: apply_cancel, is_cancel: is_cancel); List <dynamic> rList = new List <dynamic>(); if (total > 0) { List <UserInfo> list = bll.GetShMemberList(rows, page, websiteOwner, min_level, member, distributionOwners, regUserIds, bill, apply, hasImg, start, end, level_num, colName: "AutoID,UserID,Phone,TrueName,Regtime,DistributionOwner,RegUserID,RegisterWay,Stock,EmptyBill" + ",MemberApplyStatus,MemberApplyTime,MemberLevel,Ex1,WebsiteOwner,IsDisable,IsLock", apply_cancel: apply_cancel, is_cancel: is_cancel); if (list.Count > 0) { List <UserLevelConfig> lvlist = bllDis.QueryUserLevelList(websiteOwner, "DistributionOnLine", colName: "AutoId,LevelNumber,LevelString", showAll: true); Dictionary <int, string> dicLevel = new Dictionary <int, string>(); foreach (UserLevelConfig item in lvlist) { if (!dicLevel.ContainsKey(item.LevelNumber)) { dicLevel.Add(item.LevelNumber, item.LevelString); } } List <UserInfo> uList = new List <UserInfo>(); List <string> uIdList = list.Select(p => p.DistributionOwner).Where(pi => !string.IsNullOrWhiteSpace(pi)).Distinct().ToList(); uIdList.AddRange(list.Select(p => p.RegUserID).Where(pi => !string.IsNullOrWhiteSpace(pi)).Distinct().ToList()); if (uIdList.Count > 0) { string uIdsString = ZentCloud.Common.MyStringHelper.ListToStr(uIdList, "'", ","); uList = bll.GetColList <UserInfo>(int.MaxValue, 1, string.Format("UserID In ({0}) And WebsiteOwner='{1}'", uIdsString, websiteOwner), "AutoID,UserID,Phone,TrueName,WebsiteOwner"); } foreach (var item in list) { UserInfo regUser = uList.FirstOrDefault(p => p.UserID == item.RegUserID); UserInfo upUser = uList.FirstOrDefault(p => p.UserID == item.DistributionOwner); string lvString = dicLevel.ContainsKey(item.MemberLevel) ? dicLevel[item.MemberLevel] : ""; string memberStatus = item.EmptyBill == 1 ? "空单" : "实单"; memberStatus += (item.MemberApplyStatus == 9 ? "已审" : "未审"); if (item.IsDisable == 1 && item.MemberLevel == 0) { memberStatus = "已撤单"; } else if (item.IsDisable == 1 && item.MemberLevel > 0) { memberStatus = "申请撤单"; } rList.Add(new { id = item.AutoID, uid = item.UserID, name = bllUser.GetUserDispalyName(item), phone = item.Phone, up_user = upUser == null ? null : new { id = upUser.AutoID, uid = upUser.UserID, name = bllUser.GetUserDispalyName(upUser), phone = upUser.Phone }, reg_user = regUser == null ? null : new { id = regUser.AutoID, uid = regUser.UserID, name = bllUser.GetUserDispalyName(regUser), phone = regUser.Phone }, reg_time = item.MemberApplyTime.ToString("yyyy-MM-dd HH:mm:ss"), lv = lvString, status = memberStatus, way = item.RegisterWay, stock = item.Stock, ex1 = item.Ex1, is_lock = item.IsLock }); } } } apiResp.status = true; apiResp.code = (int)BLLJIMP.Enums.APIErrCode.IsSuccess; apiResp.msg = "查询列表完成"; apiResp.result = new { totalcount = total, list = rList }; bll.ContextResponse(context, apiResp); }
public void ProcessRequest(HttpContext context) { List <string> defFields = new List <string>() { "AutoID", "WXHeadimgurl", "UserID", "TotalScore", "UserType", "AccessLevel", "AccountAmount", "DistributionOwner", "WXNickname", "WebsiteOwner", "IsWeixinFollower" }; int rows = Convert.ToInt32(context.Request["rows"]); int page = Convert.ToInt32(context.Request["page"]); string mapping_type = context.Request["mapping_type"]; string keyWord = context.Request["KeyWord"]; string tagName = context.Request["TagName"]; string haveTrueName = context.Request["HaveTrueName"]; string haveWxNickNameAndTrueName = context.Request["HaveWxNickNameAndTrueName"]; string isFans = context.Request["IsFans"]; //是否是粉丝 string isReg = context.Request["IsReg"]; //是否是会员 string isDisOnLineUser = context.Request["IsDisOnLineUser"]; //是否商城分销会员 string isDisOffLineUser = context.Request["IsDisOffLineUser"]; //是否业务分销会员 string isPhoneReg = context.Request["IsPhoneReg"]; //是否手机验证会员 string isName = context.Request["isName"]; string isPhone = context.Request["isPhone"]; string isEmail = context.Request["isEmail"]; string isWxnickName = context.Request["isWxnickName"]; string isMember = context.Request["isMember"]; string isApp = context.Request["isApp"]; string userAutoId = context.Request["autoId"];//用户AutoId string isOrAnd = context.Request["isOrAnd"]; string userType = context.Request["user_type"]; string noDistributionOwner = context.Request["noDistributionOwner"];//不是分销员 List <UserInfo> userList = bll.GetMemberList(rows, page, mapping_type, defFields, bll.WebsiteOwner, keyWord, tagName, haveTrueName, haveWxNickNameAndTrueName, isFans, isReg, isDisOnLineUser, isDisOffLineUser, isPhoneReg, isName, isPhone, isEmail, isWxnickName, isMember, userAutoId, isOrAnd, userType, noDistributionOwner, isApp); int totalCount = bll.GetMemberCount(bll.WebsiteOwner, keyWord, tagName, haveTrueName, haveWxNickNameAndTrueName, isFans, isReg, isDisOnLineUser, isDisOffLineUser, isPhoneReg, isName, isPhone, isEmail, isWxnickName, isMember, userAutoId, isOrAnd, userType, noDistributionOwner, isApp); foreach (var item in userList) { if (string.IsNullOrWhiteSpace(item.WXNickname) && !string.IsNullOrWhiteSpace(item.WXOpenId)) { item.WXNickname = "微信用户"; } item.Password = ""; #region 美帆 if (item.WebsiteOwner == "meifan") { item.Ex1 = bllMeifan.GetMyDefualtCardNumber(item.UserID);//会员卡号 if (!string.IsNullOrEmpty(item.Ex1)) { var myCard = bllMeifan.Get <MeifanMyCard>(string.Format(" CardNum='{0}'", item.Ex1)); if (myCard != null) { var card = bllMeifan.GetCard(myCard.CardId); if (card != null) { item.Ex2 = card.CardType; } } } } #endregion } apiResp.result = new { totalcount = totalCount, list = userList }; apiResp.status = true; apiResp.code = (int)APIErrCode.IsSuccess; bll.ContextResponse(context, apiResp); }