public DTO.PSWechatFanQuery WechatFanQuery(DTO.PQWechatFanQuery request)
{
DTO.PSWechatFanQuery response = new DTO.PSWechatFanQuery();
try
{
DAL.cOtherDAL dal = new DAL.cOtherDAL(con);
dal.WechatFanQueryBuild(request);
response.data = dal.Query <DTO.LWechatFanQuery>();
int num = dal.Count();
response.Page = request.Page;
response.MaxNum = num;
response.count = num;
response.MaxPage = MathExpansion.CaculatPage(num, request.PageRow);
response.ErrorMessage = rm.GetString(response.ErrorCode);
response.code = response.ErrorCode == "A_0" ? "0" : response.ErrorCode;
response.msg = response.ErrorMessage;
}
catch (Exception ex)
{
LogHelper.Error("cOtherBLL.WechatFanQuery！", ex);
throw;
}
return(response);
}
public void WechatFanQueryBuild(DTO.PQWechatFanQuery request)
{
this.AppendInit();
this.AppendFieldRownum("wf.WechatFanID");
this.AppendFieldStr("wf.openid");
this.AppendFieldStr("wf.subscribe");
this.AppendFieldStr("wf.nickname");
this.AppendFieldStr("wf.sex");
this.AppendFieldStr("wf.city");
this.AppendFieldStr("wf.country");
this.AppendFieldStr("wf.province");
this.AppendFieldStr("wf.language");
this.AppendFieldStr("wf.subscribe_time");
this.AppendFieldStr("wf.unionid");
this.AppendFieldStr("wf.remark");
this.AppendFieldStr("wf.groupid");
this.AppendFieldStr("wf.tagid_list");
this.AppendFieldStr("wf.subscribe_scene");
this.AppendFieldStr("wf.qr_scene");
this.AppendFieldStr("wf.qr_scene_str");
this.AppendFromStr("from tbWechatFan wf");
this.AppendComplete(request.Page, request.PageRow);
}
