/// <summary>
/// 获取粉丝的消息记录
/// </summary>
/// <param name="OpenId"></param>
/// <returns></returns>
public MD_FansList GetAllFanContent(string OpenId)
{
string sql = "select a.*,U.AU_Username from CT_All_Users U right join (select T.WT_LogContent,F.WF_OpenId,F.WF_NickName,F.WF_HeadImgurl,T.WT_CreateTime,'' AU_Code from CT_Wechat_Fans F inner join CT_Wechat_TrackLog T on WF_OpenId=WT_FromOpenId where WT_LogType=1 and F.WF_OpenId='" + OpenId + "' union select WR_Content,WR_WT_Openid,'','',WR_CreateTime,WR_AU_Code AU_Code from CT_Wechat_ReplyLog where WR_WT_Openid='" + OpenId + "')a on U.AU_Code=a.AU_Code order by a.WT_CreateTime desc ;";
MD_FansList o = new MD_FansList();
o.Fans = DataHelper.ConvertToList <CT_Wechat_Fan>(sql);
return(o);
}
/// <summary>
/// 获取的所有关注的粉丝
/// </summary>
/// <returns></returns>
public MD_FansList GetAllFan()
{
string sql = "SELECT * FROM CT_Wechat_Fans WHERE WF_DataStatus=1;";
DataSet ds = SqlHelper.ExecuteDataset(sql);
MD_FansList o = new MD_FansList();
o.Fans = DataHelper.ConvertToList <CT_Wechat_Fan>(ds);
return(o);
}
public static MD_FansList GetAllFan()
{
BL_Wechat o = new BL_Wechat();
MD_FansList F = new MD_FansList();
F = o.GetAllFan();
for (int i = 0; i < F.Fans.Count; i++)
{
F.Fans[i].WF_NickName_EC = HttpUtility.UrlEncode(F.Fans[i].WF_NickName);
}
return(F);
}
public static MD_FansList GetAllFanContent(string data)
{
data d = JsonConvert.DeserializeObject <data>(data);
BL_Wechat o = new BL_Wechat();
MD_FansList F = o.GetAllFanContent(d.OpenId);
for (int i = 0; i < F.Fans.Count; i++)
{
F.Fans[i].WF_NickName_EC = HttpUtility.UrlEncode(F.Fans[i].WF_NickName);
F.Fans[i].WT_CreateTime_S = F.Fans[i].WT_CreateTime.ToString("MM/dd/yyyy mm:ss");
if (F.Fans[i].AU_Code != 0)
{
F.Fans[i].WF_NickName = F.Fans[i].AU_Username;
F.Fans[i].WF_HeadImgurl = "/images/DeK.jpg";
}
}
return(F);
}
