/// <summary> /// 绑定账号更新用户信息 /// </summary> public int MemberBindUpdate(CustomerExtRequest model) { int rowsAffected = DBContext.Update(strTableName) .Column("OpenId", model.OpenId) .Column("Nickname", model.Nickname) .Column("HeadImgUrl", model.HeadImgUrl) .Where("sysNo", model.SysNo) .Execute(); return(rowsAffected); }
/// <summary> /// 获取会员扩展信息分页列表 /// </summary> /// <param name="request">查询参数</param> /// <returns>会员扩展信息分页列表</returns> public PagedList <CustomerExt> GetExtPagerList(CustomerExtRequest request) { const string sqlForm = "crcustomer c left join crcustomer rc on c.ReferrerSysNo = rc.SysNo"; var dataCount = DBContext.Select <int>("count(0)").From(sqlForm); var dataList = DBContext.Select <CustomerExt>("c.*,rc.RealName as ReferrerName").From(sqlForm); Action <string, string, object> setWhere = (@where, name, value) => { dataCount.AndWhere(where).Parameter(name, value); dataList.AndWhere(where).Parameter(name, value); }; if (request.ReferrerSysNo.HasValue) { setWhere("c.ReferrerSysNo = @ReferrerSysNo", "ReferrerSysNo", request.ReferrerSysNo.Value); } if (request.LevelCustomerSysNo.HasValue) { setWhere("CONCAT(',',c.LevelCustomerStr,',') like CONCAT('%',@LevelCustomerSysNo,'%')", "LevelCustomerSysNo", request.LevelCustomerSysNo.Value); } if (request.Level.HasValue) { setWhere("c.Level = @Level", "Level", request.Level.Value); } if (request.Grade.HasValue) { setWhere("c.Grade = @Grade", "Grade", request.Grade.Value); } if (!string.IsNullOrWhiteSpace(request.RealName)) { setWhere("c.RealName LIKE CONCAT('%',@RealName,'%')", "RealName", request.RealName); } if (!string.IsNullOrWhiteSpace(request.RealName)) { setWhere("c.Account LIKE CONCAT('%',@Account,'%')", "Account", request.RealName); } if (!string.IsNullOrWhiteSpace(request.ReferrerName)) { setWhere("rc.RealName LIKE CONCAT('%',@ReferrerName,'%')", "ReferrerName", request.ReferrerName); } if (!string.IsNullOrWhiteSpace(request.Account)) { setWhere("rc.Account LIKE CONCAT('%',@Account,'%')", "Account", request.Account); } return(new PagedList <CustomerExt> { TData = dataList.Paging(request.CurrentPageIndex.GetHashCode(), request.PageSize.GetHashCode()).OrderBy("c.SysNo desc").QueryMany(), CurrentPageIndex = request.CurrentPageIndex.GetHashCode(), TotalCount = dataCount.QuerySingle() }); }
/// <summary> /// 我的团队分页查询 /// </summary> /// <param name="request">输入参数</param> /// <returns>Json</returns> public JsonResult MyTeamQuery(CustomerExtRequest request) { request.LevelCustomerSysNo = CustomerContext.Context.SysNo; var pagerList = CustomerApp.Instance.GetExtPagerList(request); var data = new { Status = true, Data = pagerList.TData.ToList(), Count = pagerList.TotalCount }; return(Json(data, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 获取会员扩展信息列表 /// </summary> /// <param name="request">查询参数</param> /// <returns>会员扩展信息列表</returns> public IList <CrCustomer> GetList(CustomerExtRequest request) { var dataList = DBContext.Select <CrCustomer>("*").From(strTableName); Action <string, string, object> setWhere = (@where, name, value) => dataList.AndWhere(@where).Parameter(name, value); if (request.LevelCustomerSysNo.HasValue) { setWhere(string.Format("CONCAT(',',LevelCustomerStr,',') like '%,{0},%'", request.LevelCustomerSysNo.Value), "", ""); } if (request.SelfLevelCustomerSysNo.HasValue) { setWhere(string.Format("CONCAT(',',SysNo,',',LevelCustomerStr,',') like '%,{0},%'", request.SelfLevelCustomerSysNo.Value), "", ""); } if (request.Level.HasValue) { setWhere("Level = @Level", "Level", request.Level.Value); } if (!string.IsNullOrWhiteSpace(request.Keyword)) { setWhere("(RealName = @Keyword or SerialNumber = @Keyword)", "Keyword", request.Keyword); } if (request.Grade.HasValue) { setWhere("Grade = @Grade", "Grade", request.Grade.Value); } if (request.CustomerSysNoList != null && request.CustomerSysNoList.Any()) { setWhere("CustomerSysNo in(@CustomerSysNoList)", "CustomerSysNoList", string.Join(",", request.CustomerSysNoList)); } if (request.LevelList != null && request.LevelList.Any()) { setWhere("Level in(@LevelList)", "LevelList", string.Join(",", request.LevelList)); } return(dataList.OrderBy("SysNo desc").QueryMany()); }