/// <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); }
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); }
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); }
public static tbl_sp_api_urlItem QueryByVirtualPage(Shotgun.Database.IBaseDataClass2 dBase, string virtualPage) { var m = cache.FindFirstData(e => virtualPage.Equals(e.virtual_page, StringComparison.OrdinalIgnoreCase)); if (m != null) { return(m.Disable ? null : m); } var q = GetQueries(dBase); q.Filter.AndFilters.Add(Fields.virtual_page, virtualPage); m = q.GetRowByFilters(); if (m == null) { return(null); } cache.InsertItem(m); return(m.Disable ? null : m); }