/// <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);
}
