/// <summary> /// 保存微信聊天记录 /// </summary> /// <param name="msg"></param> /// <returns></returns> public int SaveCUST_MSG_RECORD(WXCUST_MSG_RECORD msg) { if (msg.ID == 0) { return((int)_set.Insert(msg)); } else { return(_set.Update(msg)); } }
/// <summary> /// 保存微信消息记录 /// </summary> /// <param name="msg"></param> /// <returns></returns> public int SaveMsg(WXCUST_MSG_RECORD msg) { return(_set.SaveMsg(msg)); }
/// <summary> /// 回复消息(微信信息返回) /// </summary> /// <param name="weixinXML"></param> private void ResponseMsg(WXCUST_MSG_HIS requestXML) { string resxml = "<xml><ToUserName><![CDATA[" + requestXML.FROMUSERNAME + "]]></ToUserName><FromUserName><![CDATA[" + requestXML.TOUSERNAME + "]]></FromUserName><CreateTime>" + ConvertDateTimeInt(DateTime.Now) + "</CreateTime>"; try { if (requestXML.MSGTYPE == "text") { if (requestXML.CONTENT == "海报") { new SeaNews().SeadSeaNews(requestXML.FROMUSERNAME); resxml += "<MsgType><![CDATA[text]]></MsgType><Content><![CDATA[生成海报]]></Content><FuncFlag>0</FuncFlag></xml>"; } else { int count = 0; List <Information_EX> list = sbo.GetModelList(string.Format(" ((KeyWords like '%{0}%' and MatchingType=0) or (KeyWords ='{0}' and MatchingType=1)) AND replytype={1} and ToUserName='******'", requestXML.CONTENT, 1, requestXML.TOUSERNAME)); if (list.Count == 1 || (list.Count > 1 && list[0].MsgType != "news")) { Information_EX f = list[0];// ibo.GetModel(requestXML.EventKey, 4); //自定义菜单回复 if (f != null) { switch (f.MsgType) { case "text": resxml += "<MsgType><![CDATA[text]]></MsgType><Content><![CDATA[" + f.Content + "]]></Content><FuncFlag>0</FuncFlag></xml>"; break; case "news": resxml += "<MsgType><![CDATA[news]]></MsgType><ArticleCount>1</ArticleCount><Articles>"; resxml += "<item><Title><![CDATA[" + f.Title + "]]></Title><Description><![CDATA[" + f.Description + "]]></Description><PicUrl><![CDATA[" + ConfigurationSettings.AppSettings["WebUrl"] + f.PicUrl + "]]></PicUrl><Url><![CDATA[" + (f.IsURL ? (f.FulltextUrl.Contains("?id") ? (f.FulltextUrl + "&FromUserName="******"&ToUserName="******"") : (f.FulltextUrl + "?FromUserName="******"&ToUserName="******"")) : (ConfigurationSettings.AppSettings["WebUrl"] + "/GraphicDisplay.aspx?id=" + f.DID)) + "]]></Url></item>"; //URL是点击之后跳转去那里,这里跳转到百度 resxml += "</Articles><FuncFlag>0</FuncFlag></xml>"; break; case "music": resxml += string.Format(@"<MsgType><![CDATA[music]]></MsgType> <Music> <Title><![CDATA[{0}]]></Title> <Description><![CDATA[{1}]]></Description> <MusicUrl><![CDATA[{2}]]></MusicUrl> <HQMusicUrl><![CDATA[{2}]]></HQMusicUrl> </Music> <FuncFlag>0</FuncFlag> </xml>", f.Title, f.Description, ConfigurationSettings.AppSettings["WebUrl"] + f.PicUrl); break; default: //resxml += "<MsgType><![CDATA[text]]></MsgType><Content><![CDATA[感谢您的支持]]></Content><FuncFlag>0</FuncFlag></xml>"; break; } } } else if (list.Count > 1) //多图 { count = list.Count; resxml += "<MsgType><![CDATA[news]]></MsgType><ArticleCount>" + count + "</ArticleCount><Articles>"; for (int i = 0; i < count; i++) { resxml += "<item><Title><![CDATA[" + list[i].Title + "]]></Title><Description><![CDATA[" + list[i].Description + "]]></Description><PicUrl><![CDATA[" + ConfigurationSettings.AppSettings["WebUrl"] + list[i].PicUrl + "]]></PicUrl><Url><![CDATA[" + (list[i].IsURL ? (list[i].FulltextUrl.Contains("?id") ? (list[i].FulltextUrl + "&FromUserName="******"&ToUserName="******"") : (list[i].FulltextUrl + "?FromUserName="******"&ToUserName="******"")) : (ConfigurationSettings.AppSettings["WebUrl"] + "/GraphicDisplay.aspx?id=" + list[i].DID)) + "]]></Url></item>";//URL是点击之后跳转去那里,这里跳转到百度 } resxml += "</Articles><FuncFlag>0</FuncFlag></xml>"; } else { list = sbo.GetModelList(string.Format(" replytype={0} and ToUserName='******'", 3, requestXML.TOUSERNAME)); if (list.Count == 1 || (list.Count > 1 && list[0].MsgType != "news")) { Information_EX f = list[0]; if (f != null) { switch (f.MsgType) { case "text": resxml += "<MsgType><![CDATA[text]]></MsgType><Content><![CDATA[" + f.Content + "]]></Content><FuncFlag>0</FuncFlag></xml>"; break; case "news": resxml += "<MsgType><![CDATA[news]]></MsgType><ArticleCount>1</ArticleCount><Articles>"; resxml += "<item><Title><![CDATA[" + f.Title + "]]></Title><Description><![CDATA[" + f.Description + "]]></Description><PicUrl><![CDATA[" + ConfigurationSettings.AppSettings["WebUrl"] + f.PicUrl + "]]></PicUrl><Url><![CDATA[" + (f.IsURL ? (f.FulltextUrl.Contains("?id") ? (f.FulltextUrl + "&FromUserName="******"&ToUserName="******"") : (f.FulltextUrl + "?FromUserName="******"&ToUserName="******"")) : (ConfigurationSettings.AppSettings["WebUrl"] + "/GraphicDisplay.aspx?id=" + f.DID)) + "]]></Url></item>"; //URL是点击之后跳转去那里,这里跳转到百度 resxml += "</Articles><FuncFlag>0</FuncFlag></xml>"; break; case "music": resxml += string.Format(@"<MsgType><![CDATA[music]]></MsgType> <Music> <Title><![CDATA[{0}]]></Title> <Description><![CDATA[{1}]]></Description> <MusicUrl><![CDATA[{2}]]></MusicUrl> <HQMusicUrl><![CDATA[{2}]]></HQMusicUrl> </Music> <FuncFlag>0</FuncFlag> </xml>", f.Title, f.Description, ConfigurationSettings.AppSettings["WebUrl"] + f.PicUrl); break; default: //resxml += "<MsgType><![CDATA[text]]></MsgType><Content><![CDATA[感谢您的支持]]></Content><FuncFlag>0</FuncFlag></xml>"; break; } } } else if (list.Count > 1) //多图 { int count2 = list.Count; resxml += "<MsgType><![CDATA[news]]></MsgType><ArticleCount>" + count + "</ArticleCount><Articles>"; for (int z = 0; z < count2; z++) { resxml += "<item><Title><![CDATA[" + list[z].Title + "]]></Title><Description><![CDATA[" + list[z].Description + "]]></Description><PicUrl><![CDATA[" + ConfigurationSettings.AppSettings["WebUrl"] + list[z].PicUrl + "]]></PicUrl><Url><![CDATA[" + (list[z].IsURL ? (list[z].FulltextUrl.Contains("?id") ? (list[z].FulltextUrl + "&FromUserName="******"&ToUserName="******"") : (list[z].FulltextUrl + "?FromUserName="******"&ToUserName="******"")) : (ConfigurationSettings.AppSettings["WebUrl"] + "/GraphicDisplay.aspx?id=" + list[z].DID)) + "]]></Url></item>";//URL是点击之后跳转去那里,这里跳转到百度 } resxml += "</Articles><FuncFlag>0</FuncFlag></xml>"; } } } } else if (requestXML.MSGTYPE == "event") { if (requestXML.WXEVENT == "CLICK") { if (requestXML.EVENTKEY.ToLower() == "dkf") //多客服接口 { resxml += "<MsgType><![CDATA[transfer_customer_service]]></MsgType></xml>"; } else { List <CustomMenu_EX> list = sbo.GetCustomMenuModelList(string.Format(" c.ID='{0}'", requestXML.EVENTKEY)); if (list.Count == 1 || (list.Count > 1 && list[0].MsgType != "news")) { CustomMenu_EX f = list[0];// ibo.GetModel(requestXML.EventKey, 4); //自定义菜单回复 if (f != null) { switch (f.MsgType) { case "text": resxml += "<MsgType><![CDATA[text]]></MsgType><Content><![CDATA[" + f.Content + "]]></Content><FuncFlag>0</FuncFlag></xml>"; break; case "news": resxml += "<MsgType><![CDATA[news]]></MsgType><ArticleCount>1</ArticleCount><Articles>"; resxml += "<item><Title><![CDATA[" + f.Title + "]]></Title><Description><![CDATA[" + f.Description + "]]></Description><PicUrl><![CDATA[" + ConfigurationSettings.AppSettings["WebUrl"] + f.PicUrl + "]]></PicUrl><Url><![CDATA[" + (f.IsURL ? (f.FulltextUrl.Contains("?id") ? (f.FulltextUrl + "&FromUserName="******"&ToUserName="******"") : (f.FulltextUrl + "?FromUserName="******"&ToUserName="******"")) : (ConfigurationSettings.AppSettings["WebUrl"] + "/GraphicDisplay.aspx?id=" + f.DID)) + "]]></Url></item>"; //URL是点击之后跳转去那里,这里跳转到百度 resxml += "</Articles><FuncFlag>0</FuncFlag></xml>"; break; case "music": resxml += string.Format(@"<MsgType><![CDATA[music]]></MsgType> <Music> <Title><![CDATA[{0}]]></Title> <Description><![CDATA[{1}]]></Description> <MusicUrl><![CDATA[{2}]]></MusicUrl> <HQMusicUrl><![CDATA[{2}]]></HQMusicUrl> </Music> <FuncFlag>0</FuncFlag> </xml>", f.Title, f.Description, ConfigurationSettings.AppSettings["WebUrl"] + f.PicUrl); break; default: //resxml += "<MsgType><![CDATA[text]]></MsgType><Content><![CDATA[感谢您的支持]]></Content><FuncFlag>0</FuncFlag></xml>"; break; } } } else if (list.Count > 1) //多图 { int count = list.Count; resxml += "<MsgType><![CDATA[news]]></MsgType><ArticleCount>" + count + "</ArticleCount><Articles>"; for (int i = 0; i < count; i++) { resxml += "<item><Title><![CDATA[" + list[i].Title + "]]></Title><Description><![CDATA[" + list[i].Description + "]]></Description><PicUrl><![CDATA[" + ConfigurationSettings.AppSettings["WebUrl"] + list[i].PicUrl + "]]></PicUrl><Url><![CDATA[" + (list[i].IsURL ? (list[i].FulltextUrl.Contains("?id") ? (list[i].FulltextUrl + "&FromUserName="******"&ToUserName="******"") : (list[i].FulltextUrl + "?FromUserName="******"&ToUserName="******"")) : (ConfigurationSettings.AppSettings["WebUrl"] + "/GraphicDisplay.aspx?id=" + list[i].DID)) + "]]></Url></item>";//URL是点击之后跳转去那里,这里跳转到百度 } resxml += "</Articles><FuncFlag>0</FuncFlag></xml>"; } } } else if (requestXML.WXEVENT == "unsubscribe") { //取消关注 把粉丝表更新状态为0 InsertFS(requestXML.FROMUSERNAME, requestXML.TOUSERNAME, 0); //插入粉丝信息 } else if (requestXML.WXEVENT.ToLower() == "location") //获取地理位置 { } else if (requestXML.WXEVENT.ToLower() == "scan" || (requestXML.WXEVENT.ToLower() == "subscribe" && requestXML.EVENTKEY.ToLower().Contains("qrscene"))) //扫描二维码 { string EVENTKEY = requestXML.EVENTKEY; requestXML.EVENTKEY = requestXML.EVENTKEY.ToLower().Contains("qrscene") ? requestXML.EVENTKEY.Split('_')[1] : requestXML.EVENTKEY; new MySmallShopService().SaveQRLog(new ORG_WX_QRLog { CreateTime = DateTime.Now, FromUserName = requestXML.FROMUSERNAME, QRCodeID = int.Parse(requestXML.EVENTKEY), EVENTKEY = EVENTKEY }); if (requestXML.WXEVENT.ToLower() == "subscribe") { resxml = Subscribe(requestXML, resxml); } //string jg = InsertQR(requestXML.FROMUSERNAME, requestXML.EVENTKEY); //插入扫描记录 //if (jg == "扫描成功") //{ // WXGraphicDetail i = sbo.GetGraphicDetail(53); // if (i != null) // { // resxml += "<MsgType><![CDATA[news]]></MsgType><ArticleCount>1</ArticleCount><Articles>"; // resxml += "<item><Title><![CDATA[" + i.Title + "]]></Title><Description><![CDATA[" + i.Describe + "]]></Description><PicUrl><![CDATA[" + WebUrl() + i.URL + "]]></PicUrl><Url><![CDATA[" + (i.IsURL.Value ? (i.URL.Contains("?id") ? (i.URL + "&FromUserName="******"&ToUserName="******"") : (i.URL + "?FromUserName="******"&ToUserName="******"")) : (WebUrl() + "/GraphicDisplay.aspx?id=" + i.ID)) + "]]></Url></item>";//URL是点击之后跳转去那里,这里跳转到百度 // resxml += "</Articles><FuncFlag>0</FuncFlag></xml>"; // } //} //else //resxml += "<MsgType><![CDATA[text]]></MsgType><Content><![CDATA[" + jg + "]]></Content><FuncFlag>0</FuncFlag></xml>"; } //关注 else if (requestXML.WXEVENT.ToLower() == "subscribe") { resxml = Subscribe(requestXML, resxml); } } requestXML.RESXML = resxml; if (!resxml.Contains("</xml>")) { resxml = ""; //resxml += "<MsgType><![CDATA[text]]></MsgType><Content></Content><FuncFlag>0</FuncFlag></xml>"; } if (requestXML.MSGTYPE == "text") { try { WXCUST_MSG_RECORD msg = new WXCUST_MSG_RECORD(); msg.CONTENT = requestXML.CONTENT; msg.CREATE_DATE = DateTime.Now; msg.FROMUSERNAME = requestXML.FROMUSERNAME; msg.GraphicID = 0; msg.IS_RETURN = false; msg.IS_STAR = false; msg.MSGTYPE = "text"; msg.ReturnID = 0; msg.State = 0; msg.TOUSERNAME = requestXML.TOUSERNAME; sbo.SaveCUST_MSG_RECORD(msg); } catch (Exception) { } } sbo.AddCUST_MSG_HIS(requestXML); } catch (Exception ex) { //WriteTxt("异常:" + ex.Message); //WriteTxt(sql); resxml += "<MsgType><![CDATA[text]]></MsgType><Content><![CDATA[" + ex.Message.ToString() + "]]></Content><FuncFlag>0</FuncFlag></xml>"; Response.Write(resxml); } //if (!resxml.Contains("</xml>")) //{ // resxml += "<MsgType><![CDATA[text]]></MsgType><Content><![CDATA[]]></Content><FuncFlag>0</FuncFlag></xml>"; //} WriteTxt("返回给粉丝的消息:" + resxml); Response.Write(resxml); Response.End(); }