public override string SearchDatatoWX(out string msg, string PUBLICID, string PUBLICIF, string updateValue, HttpContext context = null) { method = "POST"; Token = (new WX_Token()).getToken(PUBLICIF); Token1 oToken = new Token1(); oToken = JsonConvert.DeserializeObject <Token1>(Token); Url = "https://api.weixin.qq.com/cgi-bin/material/add_news?access_token=" + oToken.result; postData = JsonConvert.SerializeObject(Get_WX_News(out msg, PUBLICID, updateValue)); postData = Regex.Replace(postData, ",\"[^\"]+\":null", ""); string wxstring = WXRequestString(out msg, context, postData); //调接口发布数据 if (msg.Length > 0) { WriteToLog(msg); } else //发布成功 传接口返回数据,更新media_id { UpdateMediaID(updateValue, wxstring); } Url = PUBLICIF + "?func=PostNews"; Pub.Log4Net.WriteLog(LogLevel.INFO, Url); return(wxstring); }
public override List <TagJsonBQ> GetTagList(out string msg, string PUBLICID, string PUBLICIF, string updateValue, HttpContext context = null) { msg = string.Empty; method = "POST"; //var PUBLICIF1 = "http://wx.changyi.com/SaveWeChatData.ashx"; //Token = (new WX_Token()).getToken(PUBLICIF1); Token = (new WX_Token()).getToken(PUBLICIF); Token1 oToken = new Token1(); oToken = JsonConvert.DeserializeObject <Token1>(Token); Url = "https://api.weixin.qq.com/cgi-bin/tags/get?access_token=" + oToken.result; var result = JsonHelper <TagresultBQ> .ConvertJsonGET(Url); DbConnection conn = CyDbConnManager.GetActiveDbConnection("CRMDB"); CyQuery query = new CyQuery(conn); for (var i = 0; i < result.tags.Count; i++) { query.SQL.Text = "update WX_BQDY set COUNT=:COUNT"; query.SQL.Add(" where TAGID=:TAGID"); query.ParamByName("TAGID").AsInteger = result.tags[i].id; query.ParamByName("COUNT").AsInteger = result.tags[i].count; query.ExecSQL(); } return(result.tags); }
public HttpResponseMessage Post(Token1 value) { output = new Output(); output.ResponseMessage = Request.Headers.GetValues("Token").FirstOrDefault(); output.Data = value; return(Request.CreateResponse(HttpStatusCode.OK, output, "application/json")); }
public override TagJsonBJ DeleteTag(out string msg, string PUBLICID, string PUBLICIF, string updateValue, HttpContext context = null) { msg = string.Empty; method = "POST"; var PUBLICIF1 = "http://wx.changyi.com/SaveWeChatData.ashx"; Token = (new WX_Token()).getToken(PUBLICIF1); //Token = (new WX_Token()).getToken(PUBLICIF); Token1 oToken = new Token1(); oToken = JsonConvert.DeserializeObject <Token1>(Token); Url = "https://api.weixin.qq.com/cgi-bin/tags/delete?access_token=" + oToken.result; int updateValue2 = int.Parse(updateValue); var data = new { tag = new { id = updateValue2 } }; var postData = JsonConvert.SerializeObject(data); var postData1 = JsonConvert.DeserializeObject(postData); var postData2 = (postData1.ToString()); var result = JsonHelper <TagJsonBJ> .ConvertJson(Url, postData2); return(result); }
/////////////////////// // Overridden functions public override string ToString() { switch (_type) { case HqlCompareTokenType.SINGLE: return(String.Format("{0} {1} {2}", Token1.ToString(), Compare.Data, Token2.ToString())); case HqlCompareTokenType.IN: { StringBuilder sb = new StringBuilder("IN ("); for (int i = 0; i < _values.Count; ++i) { HqlToken token = (HqlToken)_values[i]; if (i > 0) { sb.Append(", "); } sb.Append(token.ToString()); } sb.Append(")"); return(sb.ToString()); } default: throw new NotSupportedException("Unknown type of COMPARETOKEN"); } }
//移出黑名单 public override TagJsonBJ DELHMD(out string msg, string PUBLICID, string PUBLICIF, string updateValue, HttpContext context = null) { msg = string.Empty; method = "POST"; //var PUBLICIF1 = "http://wx.changyi.com/SaveWeChatData.ashx"; //Token = (new WX_Token()).getToken(PUBLICIF1); Token = (new WX_Token()).getToken(PUBLICIF); Token1 oToken = new Token1(); oToken = JsonConvert.DeserializeObject <Token1>(Token); Url = "https://api.weixin.qq.com/cgi-bin/tags/members/batchunblacklist?access_token=" + oToken.result; var result = JsonHelper <TagJsonBJ> .ConvertJson(Url, updateValue); return(result); }
public override string DeleteNews(out string msg, string PUBLICID, string PUBLICIF, string updateValue, HttpContext context = null) { method = "POST"; Token = (new WX_Token()).getToken(PUBLICIF); Token1 oToken = new Token1(); oToken = JsonConvert.DeserializeObject <Token1>(Token); Url = "https://api.weixin.qq.com/cgi-bin/material/del_material?access_token=" + oToken.result; string wxstring = WXRequestString(out msg, context, updateValue); if (msg.Length > 0) { WriteToLog(msg); } else { MeidaInformation objMeida = JsonConvert.DeserializeObject <MeidaInformation>(updateValue); DbConnection conn = CyDbConnManager.GetDbConnection("CRMDB"); try { conn.Open(); } catch (Exception e) { throw new MyDbException(e.Message, true); } CyQuery query = new CyQuery(conn); try { query.SQL.Text = "delete from WX_MEDIADY where MEDIA_ID=:MEDIA_ID"; query.ParamByName("MEDIA_ID").AsString = objMeida.media_id; query.ExecSQL(); query.SQL.Text = "delete from WX_NEWSDY_ITEM where JLBH=(select JLBH from WX_MEDIADY where MEDIA_ID=:MEDIA_ID)"; query.ParamByName("MEDIA_ID").AsString = objMeida.media_id; query.ExecSQL(); } catch (Exception e) { if (e is MyDbException) { throw e; } throw new MyDbException(e.Message, query.SqlText); } } return(wxstring); }
public override List <TagJsonYHXX> GetYHXXList(out string msg, string PUBLICID, string PUBLICIF, string updateValue, HttpContext context = null) { msg = string.Empty; method = "POST"; //var PUBLICIF1 = "http://wx.changyi.com/SaveWeChatData.ashx"; //Token = (new WX_Token()).getToken(PUBLICIF1); Token = (new WX_Token()).getToken(PUBLICIF); Token1 oToken = new Token1(); oToken = JsonConvert.DeserializeObject <Token1>(Token); Url = "https://api.weixin.qq.com/cgi-bin/user/info/batchget?access_token=" + oToken.result; //获取粉丝token接口 var result = JsonHelper <TagJsonYHXX_list> .ConvertJson(Url, updateValue); return(result.user_info_list); }
protected void Page_Load(object sender, EventArgs e) { if (!Token1.IsTokenValid(Context)) { Response.StatusCode = 403; Response.StatusDescription = "TransactionError"; Response.End(); return; } //時間のかかる処理 System.Threading.Thread.Sleep(5000); Debug.WriteLine("処理終了"); //Token1.SaveToken(Context); }
protected override void SerializeValue <TDoc, TCursor>(MegaloScriptModel model, IO.TagElementStream <TDoc, TCursor, string> s) { bool reading = s.IsReading; model.MegaloVariant.SerializeStringTableIndex(s, "stringIndex", ref mStringIndex); if (!s.StreamAttributeOpt("tokenCount", ref mTokenCount, Predicates.IsNotZero) && reading) { TokenCount = 0; } if (reading) { ValidateTokenCount(); int max_tokens = MaxTokens; if (max_tokens >= 1) { Token0.Nullify(); } if (max_tokens >= 2) { Token1.Nullify(); } if (max_tokens >= 3) { Token2.Nullify(); } } if (TokenCount >= 1) { using (s.EnterCursorBookmark("Token0")) Token0.Serialize(model, s); } if (TokenCount >= 2) { using (s.EnterCursorBookmark("Token1")) Token1.Serialize(model, s); } if (TokenCount >= 3) { using (s.EnterCursorBookmark("Token2")) Token2.Serialize(model, s); } }
public override TagJson CreateTag(out string msg, string PUBLICID, string PUBLICIF, string updateValue, HttpContext context = null) { msg = string.Empty; method = "POST"; //var PUBLICIF1 = "http://wx.changyi.com/SaveWeChatData.ashx"; //Token = (new WX_Token()).getToken(PUBLICIF1); Token = (new WX_Token()).getToken(PUBLICIF); Token1 oToken = new Token1(); oToken = JsonConvert.DeserializeObject <Token1>(Token); Url = "https://api.weixin.qq.com/cgi-bin/tags/create?access_token=" + oToken.result; //BQ content_out = new BQ(); var data = new { tag = new { name = updateValue } }; var postData = JsonConvert.SerializeObject(data); var postData1 = JsonConvert.DeserializeObject(postData); var postData2 = (postData1.ToString()); var result = JsonHelper <Tagresult> .ConvertJson(Url, postData2); DbConnection conn = CyDbConnManager.GetActiveDbConnection("CRMDB"); CyQuery query = new CyQuery(conn); if (result.tag.id != 0 && result.tag.name != null) { query.SQL.Text = "update WX_BQDY set TAGID=:TAGID"; query.SQL.Add(" where TAGMC=:TAGMC"); query.ParamByName("TAGID").AsInteger = result.tag.id; query.ParamByName("TAGMC").AsString = result.tag.name; //query.ParamByName("COUNT").AsInteger = result.tag.count; query.ExecSQL(); } return(result.tag); }
//BUTTON[] button; //public override string SearchData(out string msg,HttpContext context=null) //{ // Url = "https://api.weixin.qq.com/cgi-bin/menu/get?access_token=" + Token; // returnString = WXRequestString(out msg); // return returnString; //} public override string SearchDatatoWX(out string msg, string PUBLICID, string PUBLICIF, string updateValue, HttpContext context = null) { method = "POST"; Token = (new WX_Token()).getToken(PUBLICIF); Token1 oToken = new Token1(); oToken = JsonConvert.DeserializeObject <Token1>(Token); Url = "https://api.weixin.qq.com/cgi-bin/menu/create?access_token=" + oToken.result; postData = JsonConvert.SerializeObject(Get_WX_PostMenu(out msg, PUBLICID)); postData = Regex.Replace(postData, ",\"[^\"]+\":null", ""); //我觉得这个可能没执行 string wxstring = WXRequestString(out msg, context, postData); if (msg.Length > 0) { WriteToLog(msg); } //到这里 Url = PUBLICIF + "?func=SetMenu"; Pub.Log4Net.WriteLog(LogLevel.INFO, Url); postData = ""; context = null; wxstring = WXRequestString(out msg, context, postData); Pub.Log4Net.WriteLog(LogLevel.INFO, wxstring); return(wxstring); }
public override void Serialize(MegaloScriptModel model, IO.BitStream s) { model.MegaloVariant.StreamStringTableIndexPointer(s, ref mStringIndex); s.Stream(ref mTokenCount, ValueType.BitLength); if (s.IsReading) { ValidateTokenCount(); int max_tokens = MaxTokens; if (max_tokens >= 1) { Token0.Nullify(); } if (max_tokens >= 2) { Token1.Nullify(); } if (max_tokens >= 3) { Token2.Nullify(); } } if (TokenCount >= 1) { Token0.Serialize(model, s); } if (TokenCount >= 2) { Token1.Serialize(model, s); } if (TokenCount >= 3) { Token2.Serialize(model, s); } }
//获取用户列表 public override TagJsonQBFS GetQBFSList(out string msg, string PUBLICID, string PUBLICIF, string updateValue, HttpContext context = null) { msg = string.Empty; method = "POST"; //var PUBLICIF1 = "http://wx.changyi.com/SaveWeChatData.ashx"; //Token = (new WX_Token()).getToken(PUBLICIF1); Token = (new WX_Token()).getToken(PUBLICIF); Token1 oToken = new Token1(); oToken = JsonConvert.DeserializeObject <Token1>(Token); if (updateValue != "{}") { Url = "https://api.weixin.qq.com/cgi-bin/user/get?access_token=" + oToken.result + "&next_openid=" + updateValue; //获取粉丝token接口 } else { Url = "https://api.weixin.qq.com/cgi-bin/user/get?access_token=" + oToken.result; //获取粉丝token接口 } var result = JsonHelper <TagJsonQBFS> .ConvertJson(Url, updateValue); return(result); }
public override TagJsonBJ UpdateTag(out string msg, string PUBLICID, string PUBLICIF, string updateValue, HttpContext context = null) { msg = string.Empty; method = "POST"; //var PUBLICIF1 = "http://wx.changyi.com/SaveWeChatData.ashx"; //Token = (new WX_Token()).getToken(PUBLICIF1); Token1 oToken = new Token1(); oToken = JsonConvert.DeserializeObject <Token1>(Token); Url = "https://api.weixin.qq.com/cgi-bin/tags/update?access_token=" + oToken.result; var result = JsonHelper <TagJsonBJ> .ConvertJson(Url, updateValue); string str = updateValue; JObject o = JObject.Parse(str); var id = o["tag"]["id"].ToString(); var name = o["tag"]["name"].ToString(); DbConnection conn = CyDbConnManager.GetActiveDbConnection("CRMDB"); CyQuery query = new CyQuery(conn); query.SQL.Text = "update WX_BQDY set TAGMC=:TAGMC"; query.SQL.Add(" where TAGID=:TAGID"); query.ParamByName("TAGID").AsInteger = int.Parse(id); query.ParamByName("TAGMC").AsString = name; query.ExecSQL(); return(result); }
//批量打标签 public override TagJsonBJ PLDBQTag(out string msg, string PUBLICID, string PUBLICIF, string updateValue, string iDJR, string sDJRMC, HttpContext context = null) { msg = string.Empty; method = "POST"; //var PUBLICIF1 = "http://wx.changyi.com/SaveWeChatData.ashx"; //Token = (new WX_Token()).getToken(PUBLICIF1); Token = (new WX_Token()).getToken(PUBLICIF); Token1 oToken = new Token1(); oToken = JsonConvert.DeserializeObject <Token1>(Token); Url = "https://api.weixin.qq.com/cgi-bin/tags/members/batchtagging?access_token=" + oToken.result; string str = updateValue; JObject o = JObject.Parse(str); var tagid = o["tagid"].ToString(); var openid_LS = o["openid_list"]; string str_LS = openid_LS.ToString(); int count = str_LS.Split(',').Length; DbConnection conn = CyDbConnManager.GetActiveDbConnection("CRMDB"); CyQuery query = new CyQuery(conn); for (var i = 0; i < count; i++) { var openid = o["openid_list"][i].ToString(); int iJLBH = SeqGenerator.GetSeq("WX_HYBQJL"); query.SQL.Text = "insert into WX_HYBQJL(JLBH,TAGID,OPENID,DJR,DJRMC,DJSJ,CZLX,PUBLICID)"; query.SQL.Add(" values(:JLBH,:TAGID,:OPENID,:DJR,:DJRMC,:DJSJ,:CZLX,:PUBLICID)"); query.ParamByName("JLBH").AsInteger = iJLBH; query.ParamByName("DJR").AsInteger = int.Parse(iDJR); query.ParamByName("DJRMC").AsString = sDJRMC; query.ParamByName("OPENID").AsString = openid; query.ParamByName("TAGID").AsInteger = int.Parse(tagid); query.ParamByName("CZLX").AsInteger = 0; query.ParamByName("DJSJ").AsDateTime = DateTime.Now; query.ParamByName("PUBLICID").AsInteger = int.Parse(PUBLICID); query.ExecSQL(); } var result = JsonHelper <TagJsonBJ> .ConvertJson(Url, updateValue); if (result.errmsg == "ok") { for (var i = 0; i < count; i++) { var openid = o["openid_list"][i].ToString(); query.SQL.Text = "update WX_HYBQJL set CZLX=1"; query.SQL.Add(" where OPENID=:OPENID AND TAGID=:TAGID "); query.ParamByName("TAGID").AsInteger = int.Parse(tagid); query.ParamByName("OPENID").AsString = openid; query.ExecSQL(); query.SQL.Text = "select * FROM WX_HYBQ where TAGID=" + int.Parse(tagid) + "and OPENID=" + "'" + openid + "'"; query.Open(); if (query.IsEmpty) { query.SQL.Text = "insert into WX_HYBQ(TAGID,OPENID,CREATETIME,PUBLICID)"; query.SQL.Add(" values(:TAGID,:OPENID,:CREATETIME,:PUBLICID)"); query.ParamByName("TAGID").AsInteger = int.Parse(tagid); query.ParamByName("OPENID").AsString = openid; query.ParamByName("CREATETIME").AsDateTime = DateTime.Now; query.ParamByName("PUBLICID").AsInteger = int.Parse(PUBLICID); query.ExecSQL(); } } } else { for (var i = 0; i < count; i++) { var openid = o["openid_list"][i].ToString(); query.SQL.Text = "update WX_HYBQJL set CZLX=2"; query.SQL.Add(" where OPENID=:OPENID AND TAGID=:TAGID "); query.ParamByName("TAGID").AsInteger = int.Parse(tagid); query.ParamByName("OPENID").AsString = openid; query.ExecSQL(); } } return(result); }
//批量取消标签 public override TagJsonBJ PLQXBQTag(out string msg, string PUBLICID, string PUBLICIF, string updateValue, string iDJR, string sDJRMC, HttpContext context = null) { msg = string.Empty; method = "POST"; //var PUBLICIF1 = "http://wx.changyi.com/SaveWeChatData.ashx"; //Token = (new WX_Token()).getToken(PUBLICIF1); Token = (new WX_Token()).getToken(PUBLICIF); Token1 oToken = new Token1(); oToken = JsonConvert.DeserializeObject <Token1>(Token); Url = "https://api.weixin.qq.com/cgi-bin/tags/members/batchuntagging?access_token=" + oToken.result; var result = JsonHelper <TagJsonBJ> .ConvertJson(Url, updateValue); string str = updateValue; JObject o = JObject.Parse(str); var tagid = o["tagid"].ToString(); var openid_LS = o["openid_list"]; string str_LS = openid_LS.ToString(); int count = str_LS.Split(',').Length; DbConnection conn = CyDbConnManager.GetActiveDbConnection("CRMDB"); CyQuery query = new CyQuery(conn); if (result.errmsg == "ok") { for (var i = 0; i < count; i++) { var openid = o["openid_list"][i].ToString(); query.SQL.Text = "update WX_HYBQJL set CZLX=3"; query.SQL.Add(" where OPENID=:OPENID AND TAGID=:TAGID "); query.ParamByName("TAGID").AsInteger = int.Parse(tagid); query.ParamByName("OPENID").AsString = openid; query.ExecSQL(); query.SQL.Text = "delete from WX_HYBQ where TAGID=" + int.Parse(tagid) + "And OPENID=" + "'" + openid + "'"; query.ExecSQL(); } } else { for (var i = 0; i < count; i++) { var openid = o["openid_list"][i].ToString(); query.SQL.Text = "update WX_HYBQJL set CZLX=4"; query.SQL.Add(" where OPENID=:OPENID AND TAGID=:TAGID "); query.ParamByName("TAGID").AsInteger = int.Parse(tagid); query.ParamByName("OPENID").AsString = openid; query.ExecSQL(); } } return(result); }