/// <summary> /// 获取注册后的微信用户ID /// </summary> /// <param name="OpenId"></param> /// <returns></returns> public CT_Wechat_Member GetWechat_Member(string OpenId) { string sql = string.Format(@"SELECT * FROM CT_Wechat_Member WHERE MB_OpenID='{0}';", OpenId); CT_Wechat_Member o = DataHelper.ConvertToObject <CT_Wechat_Member>(sql); return(o); }
/// <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(); } } }
/// <summary> /// 通讯类型,顾问和客户 /// </summary> private void IsCommunicatorType() { CT_Wechat_Member _M = B_W_CT_Member.GetMember(_x.FromUserName, 1); if (_M == null) { new CustomerControl(_x); } else { new AdviserControl(_x); } }
/// <summary> /// 获取注册后的粉丝信息 type=1 code=OpenID; type=2 code=De_code /// </summary> /// <param name="Code"></param> /// <param name="_type"></param> /// <returns></returns> public CT_Wechat_Member GetMember(string Code, int _type) { string sql = string.Empty; if (_type == 1) { sql = "SELECT AU_Code,MB.* FROM CT_Dealer_Empl INNER JOIN CT_Wechat_Member MB ON DE_AU_Code=MB_AU_Code INNER JOIN CT_All_Users ON AU_Code=DE_Code WHERE MB_OpenID='" + Code + "';"; } else if (_type == 2) { sql = "SELECT AU_Name,MB.* FROM CT_Dealer_Empl INNER JOIN CT_Wechat_Member MB ON DE_AU_Code=MB_AU_Code INNER JOIN CT_All_Users ON AU_Code=DE_AU_Code WHERE DE_Code=" + Code + ";"; } CT_Wechat_Member o = DataHelper.ConvertToObject <CT_Wechat_Member>(sql); return(o); }
private void Server_01_Get_Service_List(dynamic data) { string code = string.Empty; if (data.codes != null) { code = data.codes; } string OpenId = _getOpenId(code); _User_Member = getWechat_Member(OpenId); if (_User_Member == null) { _object = -1; } else { _object = _b_serverHis.GetHistory_Service(_User_Member.MB_AU_Code, null); } }
private void Key_01_AppList(dynamic data) { string code = string.Empty; if (data.codes != null) { code = data.codes; } string OpenId = _getOpenId(code); _User_Member = getWechat_Member(OpenId); if (_User_Member == null) { _object = -1; } else { _object = _b_app.GetAppList_Json(_User_Member.MB_AU_Code); } }