public int AddFans(CT_Wechat_Fan fan)
{
string sql = "INSERT INTO CT_Wechat_Fans VALUES('" + fan.WF_OpenId + "','" + fan.WF_NickName + "','" + fan.WF_Sex + "','" + fan.WF_City + "','" + fan.WF_Province + "','" + fan.WF_Country + "','" + fan.WF_HeadImgurl + "',GETDATE(),'',1);";
int i = SqlHelper.ExecuteNonQuery(sql);
return(i);
}
/// <summary>
/// 顾问通讯
/// </summary>
private void AdviserCommunicate()
{
if (IsServiceConnectExpire())
{
if (IsSelectSend())
{
_CS_OpenId = SelectCutomerOpenId();
}
B_W_CustomerServiceConnection.AddServiceConnection(new CT_Wechat_CustomerServiceConnection()
{
CSC_AD_OpenId = _x.FromUserName,
CSC_CS_OpenId = _CS_OpenId,
CSC_Connection_dt = DateTime.Now,
CSC_Connection_Status = 1
});
B_W_Fans _b_fan = new B_W_Fans();
CT_Wechat_Fan _fan = _b_fan.GetFans(_x.FromUserName);
wechatHandle.SendCustom_text(_CS_OpenId, "@" + _fan.WF_NickName + "：" + _x.Content);
B_W_CustomSservice _b_custom = new B_W_CustomSservice();
_b_custom.AddCustomSservice(new CT_Wechat_CustomSservice()
{
WCS_FromOpenId = _x.FromUserName, WCS_ToOpenId = _CS_OpenId, WCS_Content = _x.Content, WM_CreateTime = wechatHandle.GetLocalTime(Convert.ToInt64(_x.CreateTime))
});
_b_custom.AddCustomSservice(_x.FromUserName, _CS_OpenId, _x.Content, 1);
}
else
{
wechatHandle.SendCustom_text(_x.FromUserName, "没有客户跟你进行客服连接");
}
}
public static CT_Wechat_Fan GetFans(string openId)
{
wechatFans _fans = requestUserInfo(openId);
if (_fans == null || _fans.errcode > 0)
{
B_W_Exception.AddExcep("wechatHandle >> GetFans", openId, "获取错误,errcode:" + _fans.errcode);
return(null);
}
#region 赋值
CT_Wechat_Fan o = new CT_Wechat_Fan();
o.WF_OpenId = _fans.openid;
o.WF_NickName = _fans.nickname;
switch (_fans.sex)
{
case 1:
o.WF_Sex = "男";
break;
case 2:
o.WF_Sex = "女";
break;
default:
o.WF_Sex = "未知";
break;
}
o.WF_Country = _fans.country;
o.WF_Province = _fans.province;
o.WF_City = _fans.city;
o.WF_HeadImgurl = _fans.headimgurl;
o.WF_SubscribeTime = GetLocalTime(_fans.subscribe_time);
#endregion
return(o);
}
public CT_Wechat_Fan GetFans(string OpenId)
{
string sql = "SELECT * FROM CT_Wechat_Fans WHERE WF_OpenId='" + OpenId + "';";
CT_Wechat_Fan o = DataHelper.ConvertToObject <CT_Wechat_Fan>(sql);
return(o);
}
/// <summary>
/// 关注事件处理
/// </summary>
/// <param name="x"></param>
public void EventHandle_subscribe(xml x)
{
B_W_Fans _b_fan = new B_W_Fans();
CT_Wechat_Fan o = wechatHandle.GetFans(x.FromUserName);
int i = _b_fan.AddFans(o);
wechatHandle.SendCustom_text(x.FromUserName, "亲爱的用户，欢迎使用大E库微信");
}
public int AddFans(CT_Wechat_Fan fan)
{
CT_Wechat_Fan o = _d_fan.GetFans(fan.WF_OpenId);
if (o != null)
{
int i = _d_fan.UpdateFans(fan.WF_OpenId, 1);
return(i);
}
return(_d_fan.AddFans(fan));
}
/// <summary>
/// 客户通讯
/// </summary>
private void CustomerCommunicate()
{
if (IsCustomConnectExpire())
{
B_W_CustomerServiceConnection.AddServiceConnection(new CT_Wechat_CustomerServiceConnection()
{
CSC_AD_OpenId = _AD_OpenId,
CSC_CS_OpenId = _x.FromUserName,
CSC_Connection_dt = DateTime.Now,
CSC_Connection_Status = 1
});
B_W_Fans _b_fan = new B_W_Fans();
CT_Wechat_Fan _fan = _b_fan.GetFans(_x.FromUserName);
wechatHandle.SendCustom_text(_AD_OpenId, "@" + _fan.WF_NickName + "：" + _x.Content);
B_W_CustomSservice _b_custom = new B_W_CustomSservice();
_b_custom.AddCustomSservice(new CT_Wechat_CustomSservice()
{
WCS_FromOpenId = _x.FromUserName, WCS_ToOpenId = _AD_OpenId, WCS_Content = _x.Content, WM_CreateTime = wechatHandle.GetLocalTime(Convert.ToInt64(_x.CreateTime))
});
_b_custom.AddCustomSservice(_AD_OpenId, _x.FromUserName, _x.Content, 0);
}
else
{
try
{
Convert.ToInt32(_x.Content);
CT_Wechat_Member _M_s = B_W_CT_Member.GetMember(_x.Content, 2);
if (_M_s == null)
{
wechatHandle.SendCustom_text(_x.FromUserName, "请你先选择推荐的顾问，再进行通话。");
wechatHandle.SendCustom_text(_x.FromUserName, B_W_TextMessage.GetMessage());
}
else
{
B_W_CustomerServiceConnection.AddServiceConnection(new CT_Wechat_CustomerServiceConnection()
{
CSC_AD_OpenId = _M_s.MB_OpenID,
CSC_CS_OpenId = _x.FromUserName,
CSC_Connection_dt = DateTime.Now,
CSC_Connection_Status = 1
});
wechatHandle.SendCustom_text(_x.FromUserName, _M_s.AU_Name + ":正在等待你的问题");
}
}
catch
{
wechatHandle.SendCustom_text(_x.FromUserName, "请你先选择顾问，再进行通话。否则，你的消息我们仅作留言处理，不能及时回复你。");
wechatHandle.SendCustom_text(_x.FromUserName, B_W_TextMessage.GetMessage());
AddTrack();
}
}
}
