public static tbl_cp_trone_rateItem QueryBySpTroneId(Shotgun.Database.IBaseDataClass2 dBase, int spTroneId, int cpId) { var m = _cache.FindFirstData(e => e.sp_trone_id == spTroneId && e.cp_id == cpId); if (m != null) { return(m); } var q = GetQueries(dBase); q.Filter.AndFilters.Add(Fields.cp_id, cpId); q.Filter.AndFilters.Add(Fields.sp_trone_id, spTroneId); m = q.GetRowByFilters(); if (m != null) { _cache.InsertItem(m); } else { _cache.InsertItem(m = new tbl_cp_trone_rateItem() { cp_id = cpId, sp_trone_id = spTroneId }); } return(m); }
/// <summary> /// 从缓存中获取日月限制 /// </summary> /// <param name="spTroneId"></param> /// <param name="cpId"></param> /// <param name="date"></param> /// <returns></returns> public static tbl_day_month_limitItem GetOrCreateItem(IBaseDataClass2 dBase, int spTroneId, int cpId, DateTime date) { var m = cache.FindFirstData(e => e.sp_trone_id == spTroneId && e.cp_id == cpId && e.fee_date.Date == date.Date); if (m != null) { return(m); } var l = GetQueries(dBase); l.Filter.AndFilters.Add(Fields.sp_trone_id, spTroneId); l.Filter.AndFilters.Add(Fields.cp_id, cpId); l.Filter.AndFilters.Add(Fields.fee_date, date.Date); m = l.GetRowByFilters(); if (m != null) { cache.InsertItem(m); return(m); } m = new tbl_day_month_limitItem(); m.fee_date = date.Date; m.cp_id = cpId; m.sp_trone_id = spTroneId; return(m); }
/// <summary> /// 根据主键查找指定的行,返回指定字段 /// </summary> /// <param name="dBase"></param> /// <param name="id">主键值</param> /// <param name="fields">返回字段</param> /// <returns></returns> public static tbl_troneItem GetRowById(Shotgun.Database.IBaseDataClass2 dBase, int id, string[] fields) { tbl_troneItem m = null; lock (cache.SyncRoot) { m = cache.GetDataByIdx(id); if (m != null) { return(m); } } var q = GetQueries(dBase); m = q.GetRowById(id); cache.InsertItem(m); return(m); }
public static tbl_sp_api_urlItem QueryById(Shotgun.Database.IBaseDataClass2 dBase, int id) { var m = cache.GetDataByIdx(id); if (m != null) { return(m); } var q = GetQueries(dBase); m = q.GetRowById(id); if (m == null) { return(null); } cache.InsertItem(m); return(m); }
/// <summary> /// 根据主键查找指定的行,返回指定字段 /// </summary> /// <param name="dBase"></param> /// <param name="id">主键值</param> /// <param name="fields">返回字段</param> /// <returns></returns> public static tbl_sp_troneItem GetRowById(Shotgun.Database.IBaseDataClass2 dBase, int id, string[] fields) { var m = _cache.GetDataByIdx(id); if (m != null) { return(m); } var q = GetQueries(dBase); //q.Fields = fields; q.Filter.AndFilters.Add(identifyField, id); m = q.GetRowByFilters(); if (m != null) { _cache.InsertItem(m); } return(m); }
public static IEnumerable <tbl_trone_orderItem> QueryByTroneIdWithCache(Shotgun.Database.IBaseDataClass2 dBase, int troneId) { IEnumerable <tbl_trone_orderItem> lst = null; var t = cache.GetCacheData(true); if (t != null) { lock (cache.SyncRoot) { lst = from item in t where !item.disable && item.trone_id == troneId select item; return(lst.ToArray()); } } #if DEBUG if (isWinform) { Console.WriteLine("QueryByTroneIdWithCache from database:troneId {0} ", troneId); } else #endif Shotgun.Library.SimpleLogRecord.WriteLog("Cache2Sql", string.Format("QueryByTroneIdWithCache from database:troneId {0} ", troneId)); var l = LightDataModel.tbl_trone_orderItem.GetQueries(dBase); l.Filter.AndFilters.Add(LightDataModel.tbl_trone_orderItem.Fields.trone_id, troneId); l.Filter.AndFilters.Add(LightDataModel.tbl_trone_orderItem.Fields.disable, 0); l.PageSize = int.MaxValue; lst = l.GetDataList(); if (lst == null || lst.Count() == 0) { return(lst); } foreach (var m in lst) { cache.InsertItem(m); } return(lst); }
public static tbl_cp_push_urlItem GetRowByIdWithCache(Shotgun.Database.IBaseDataClass2 dBase, int id) { var m = cache.GetDataByIdx(id); if (m != null) { return(m); } m = GetRowById(dBase, id, null); if (m != null) { cache.InsertItem(m); } return(m); }
public static tbl_trone_paycodeItem QueryPayCodeByTroneId(Shotgun.Database.IBaseDataClass2 dBase, int troneId) { var data = cache.FindFirstData(e => e.trone_id == troneId); if (data != null) { return(data); } var q = GetQueries(dBase); q.Filter.AndFilters.Add(Fields.trone_id, troneId); data = q.GetRowByFilters(); if (data != null) { cache.InsertItem(data); } return(data); }
private void DoRequest(string[] cmd) { //paycode*#imsi#imei#ip#iccid#package var sb = new StringBuilder(); sb.AppendFormat("phone={0}", _mo.mobile); int i = 0; if (cmd[i].Length > 7) { sb.AppendFormat("&feecode={0}", cmd[i++].Substring(1, 6)); } else { sb.AppendFormat("&feecode={0}", cmd[i++].Substring(1)); } if (cmd.Length > i) { sb.AppendFormat("&imsi={0}", cmd[i++]); } if (cmd.Length > i) { sb.AppendFormat("&imei={0}", cmd[i++]); } if (cmd.Length > i) { sb.AppendFormat("&clientip={0}", cmd[i++]); } if (cmd.Length > i) { sb.AppendFormat("&iccid={0}", cmd[i++]); } if (cmd.Length > i) { sb.AppendFormat("&package={0}", Server.UrlEncode(cmd[i++])); } if (cmd[0].Length > 7) { sb.AppendFormat("&cpparams={0}", Server.UrlEncode(cmd[0].Substring(7))); } string url; if (!cmd[0].Contains("100344")) { url = "http://pool.spcode.cn/getcmd.ashx?" + sb.ToString().Replace("feecode", "poolid"); } else { url = "http://api.spcode.cn/wuxian.jsp?" + sb.ToString(); } Shotgun.Library.SimpleLogRecord.WriteLog("sms2web", url); string html = null; try { html = n8wan.Public.Library.DownloadHTML(url, null, null, null); } catch (System.Net.WebException) { return; } if (string.IsNullOrEmpty(html)) { return; } var jtk = JToken.Parse(html); var jObj = jtk["status"]; if (jObj == null || jObj.Value <int>() != 1011) { return; } jObj = jtk["orderNum"]; var orderNum = jObj.Value <string>(); var m = new NoSqlModel.Sms2WebModel(); m.mobile = _mo.mobile; m.orderNum = orderNum; cache.InsertItem(m); }