public static List <PoolSetModel> QueryPoolSetById(Shotgun.Database.IBaseDataClass2 dBase, int poolId)
{
var data = cache.GetCacheData(false);
if (data == null)
{
lock (cache)
{
data = cache.GetCacheData(false);
if (data == null)
{
if (LoadFromDbase(dBase) == 0)
{
return(null);
}
data = cache.GetCacheData(false);
}
}
}
if (poolId == 0)
{
return(null);
}
if (data == null)
{
return(null);
}
lock (cache.SyncRoot)
{ return(data.Where(e => e.cp_pool_id == poolId).ToList()); }
}
/// <summary>
/// 计算用户的日月限信息
/// </summary>
/// <param name="customId">为空时，表示整个通道</param>
/// <returns>始终不为空</returns>
public static CustomLimitInfo QueryLimit(Shotgun.Database.IBaseDataClass2 dBase, int spTroneId, string customId)
{
if (string.IsNullOrEmpty(customId))
{
customId = null;//保证一致信息，string.empty => null
}
var data = cache.GetCacheData(false);
IEnumerable <CustomFeeModel> cfm = null;
if (data != null)
{
lock (cache.SyncRoot)
cfm = data.Where(e => e.SpToneId == spTroneId && customId == e.CustomId).ToList();
}
if (cfm == null || cfm.Count() == 0)
{
cfm = LoadFromDBase(dBase, spTroneId, customId);
}
var cli = new CustomLimitInfo()
{
CustomId = customId
};
var today = DateTime.Today;
foreach (var cf in cfm)
{
if (cf.Date >= today)
{
cli.DayCount += cf.Count;
cli.DayAmount += cf.TotalFee;
}
else
{
cli.MonthCount += cf.Count;
cli.MonthAmount += cf.TotalFee;
}
}
cli.MonthAmount += cli.DayAmount;
cli.MonthCount += cli.DayCount;
return(cli);
}
