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