/// <summary>
/// 分页获取粉丝信息
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public PagerList <dynamic> GetWctInfoPageList(SysUsrWctQuery query)
{
var perssion = _permissionHelper.GetCondition(AbpSession.USR_TYPE, AbpSession.USR_SCOPE, "wct.bu_no", AbpSession.ORG_NO, AbpSession.BG_NO);
var joinSql = query.FOLLOW_STATUS == null ? "" : "wct.follow_status=" + query.FOLLOW_STATUS + "";
return(_sqlQuery.Select(@"
wct.Wct_Id,
wct.bu_no,
wct.usr_id,
wct.open_id,
wct.cus_svc_code,
wct.usr_source,
wct.reg_date,
wct.referee_usr_id,
wct.create_date,
wct.update_date,
usr.usr_name,
usr.usr_real_name,
usr.usr_mobile,
wct.UDF1 unfollow_date,
wct.UDF2 sex,
wct.UDF3 nickname,
(
CASE wct.follow_status
WHEN 1 THEN
'已关注'
ELSE
'取消关注'
END
) AS follow_status,
(
CASE wct.UDF4
WHEN '1' THEN
'是'
ELSE
'否'
END
) AS IsBlack,
wct.WX_AVATAR_URL,
wct.tag_name,
bu.BU_NAME,
bu.PARENT_BU_NAME" )
.Filter("wct.UDF3", query.nickName, Operator.Contains)
.Filter("usr.usr_real_name", query.realName, Operator.Contains)
.Filter("bu.PARENT_BU_NO", query.parentorgNo)
.Filter("bu.BU_NO", query.orgNo)
.Filter("wct.TAG_NAME", query.TAG_NAME)
.Filter("usr.usr_mobile", query.mobile)
.Filter("wct.reg_date", query.BEGIN_REG_DATE, Operator.GreaterEqual)
.Filter("wct.reg_date", query.END_REG_DATE, Operator.LessEqual)
.Filter("wct.del_flag", "1")
.And(perssion)
.And(joinSql)
.OrderBy("wct.create_date,wct.wct_id desc")
.GetPageList <dynamic>(@"sys_usr_wct wct
left join sys_usr_mstr usr on wct.usr_id=usr.usr_id
left join mdm_bu_mstr bu on wct.bu_no=bu.bu_no", Context.Database.GetDbConnection(), query));
}
public ActionResult GetWctInfoPageList(SysUsrWctQuery query)
{
try
{
query.BG_NO = AbpSession.BG_NO;
var result = _sysUsrWctRepository.GetWctInfoPageList(query);
return(Page(result.Data, result.Page));
}
catch (Exception ex)
{
return(Fail(ex.Message));
}
}
/// <summary>
/// 更改粉丝黑名单状态
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public ReturnMsg UpdateFansBlackStatus(SysUsrWctQuery query)
{
var rm = new ReturnMsg();
if (string.IsNullOrEmpty(query.WCT_ID))
{
rm.IsSuccess = false;
rm.msg = "请先选择粉丝";
return(rm);
}
var wct = _sysUsrWctRepository.FirstOrDefault(c => c.Id == query.WCT_ID && c.DEL_FLAG == 1);
if (wct == null)
{
rm.IsSuccess = false;
rm.msg = "该粉丝不存在";
return(rm);
}
var paInfo = _wxHelper.GetPaInfo(1, c => c.PA_ID_NO == AbpSession.ORG_NO, AbpSession.BG_NO);
if (paInfo == null)
{
rm.IsSuccess = false;
rm.msg = "公众号信息不存在";
return(rm);
}
var requestToken = _wxHelper.GetAccessToken(paInfo, wct.BG_NO);
if (!requestToken.IsSuccess)
{
return(rm);
}
if (query.IsBlack)
{
rm = BlackFans(wct.OPEN_ID, requestToken.result, rm);
}
else
{
rm = UnBlackFans(wct.OPEN_ID, requestToken.result, rm);
}
if (!rm.IsSuccess)
{
return(rm);
}
_initHelper.InitUpdate(wct, AbpSession.USR_ID);
wct.UDF4 = query.IsBlack.ToString();
_sysUsrWctRepository.Update(wct);
rm.IsSuccess = true;
return(rm);
}
public ActionResult UpdateFansBlackStatus([FromBody] SysUsrWctQuery query)
{
try
{
var wct = _sysUsrWctService.UpdateFansBlackStatus(query);
if (!wct.IsSuccess)
{
return(Fail(wct.msg));
}
return(Success("操作成功"));
}
catch (Exception ex)
{
return(Fail(ex.Message));
}
}
