/// <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());
}
