private Result GetTag(HttpContext context) { int id = Convert.ToInt32(context.Request["id"]); LinkTagInfo obj = LinkTagLog_DataAccess.Instance.GetTag(id); return(Result.GetSuccessedResult(obj, true)); }
private void UpdateCache(LinkTagInfo obj) { if (!string.IsNullOrEmpty(obj.LinkUrl) && !string.IsNullOrEmpty(url91comIPs)) { try { string url = string.Format(@"http://url.felinkapps.com/{0}?pid={1}&mt={2}&url={3}&update_cache=1", obj.LinkTag, obj.SoftID, obj.Platform, System.Web.HttpUtility.UrlEncode(obj.LinkUrl)); string[] ips = url91comIPs.Split(','); foreach (string ip in ips) { if (string.IsNullOrEmpty(ip)) { continue; } net91com.Core.Web.WebHelper.GetPage(url, proxy: ip); LogHelper.WriteDebug(string.Format("更新缓存:IP={0},{1}", ip, obj.LinkUrl)); } } catch (Exception ex) { LogHelper.WriteException("更新url缓存异常,url91comIPs=" + url91comIPs, ex); } } }
private Result EditTag(HttpContext context) { string value = context.Request["obj"]; LinkTagInfo obj = JsonConvert.DeserializeObject <LinkTagInfo>(value); obj.AppStoreUrlEncode(); bool result = false; if (obj.ID == 0) { result = LinkTagLog_DataAccess.Instance.AddTag(obj); } else { result = LinkTagLog_DataAccess.Instance.UpdateTag(obj); } if (result) { // 刷新缓存 UpdateCache(obj); return(Result.GetSuccessedResult(null, true)); } else { return(Result.GetFailedResult("保存失败!")); } }
public bool AddTag(LinkTagInfo obj) { string cmdText = @" insert into Cfg_LinkTags (SoftID,Platform,Tag,TagID,LinkName,Url,CID,Updatetime,LinkType,ChannelId) select ?softid,?platform,?tag,0,?name,?url,?cid,now(),?type,?ChannelId from dual where not exists(select 1 from Cfg_LinkTags where Tag=?tag); select last_insert_id();"; MySqlParameter[] para = new MySqlParameter[] { new MySqlParameter("?softid", obj.SoftID), new MySqlParameter("?platform", obj.Platform), new MySqlParameter("?tag", obj.LinkTag), new MySqlParameter("?name", obj.LinkName), new MySqlParameter("?url", obj.LinkUrl), new MySqlParameter("?cid", obj.CID), new MySqlParameter("?type", obj.LinkType), new MySqlParameter("?ChannelId", obj.ChannelId) }; int id = Convert.ToInt32(MySqlHelper.ExecuteScalar(MySQLConnectionString, cmdText, para)); return(id > 0); }
public List <LinkTagInfo> GetTagInfoList(int softId, int platform, int cid) { string cmdText = @" select id,tag,linkname,linktype,url,Updatetime,ChannelId from Cfg_LinkTags where SoftID=?softid and Platform=?platform and CID=?cid"; MySqlParameter[] param = new MySqlParameter[] { new MySqlParameter("?softid", softId), new MySqlParameter("?platform", platform), new MySqlParameter("?cid", cid) }; List <LinkTagInfo> list = new List <LinkTagInfo>(); using (IDataReader dataReader = MySqlHelper.ExecuteReader(MySQLConnectionString, cmdText, param)) { while (dataReader.Read()) { LinkTagInfo obj = new LinkTagInfo(dataReader); obj.AppStoreUrlDecode(); list.Add(obj); } } return(list); }
public LinkTagInfo GetTag(int id) { LinkTagInfo obj = null; string cmdText = @" select SoftID,Platform,Tag,LinkName,Url,CID,Updatetime,LinkType,channelId from Cfg_LinkTags where id=" + id; using (IDataReader dataReader = MySqlHelper.ExecuteReader(MySQLConnectionString, cmdText)) { if (dataReader.Read()) { obj = new LinkTagInfo(dataReader); obj.AppStoreUrlDecode(); } } return(obj); }
public bool UpdateTag(LinkTagInfo obj) { string cmdText = @" update Cfg_LinkTags set LinkName=?name, Url=?url, CID=?cid, LinkType=?type, Updatetime=now(), ChannelId=?channelid where id=?id"; var para = new MySqlParameter[] { new MySqlParameter("?id", obj.ID), new MySqlParameter("?name", obj.LinkName), new MySqlParameter("?url", obj.LinkUrl), new MySqlParameter("?cid", obj.CID), new MySqlParameter("?type", obj.LinkType), new MySqlParameter("?channelid", obj.ChannelId) }; int cc = Convert.ToInt32(MySqlHelper.ExecuteNonQuery(MySQLConnectionString, cmdText, para)); return(cc > 0); }