/// <summary>
/// 更新用户每日计费信息
/// </summary>
/// <param name="dBase"></param>
/// <param name="troneId"></param>
/// <param name="customId"></param>
/// <param name="mrDate"></param>
private static void UpdateUserLimit(Shotgun.Database.IBaseDataClass2 dBase, int troneId, string customId, DateTime mrDate)
{
var key = CustomFeeModel.GetIdKey(customId, troneId, mrDate);
var m = cache.GetDataByIdx(key);
if (m != null)
{//找到用户计费缓存数据
Shotgun.Library.SimpleLogRecord.WriteLog("api_userlimit_update",
string.Format("customid:{0},troneId:{1},Count:{2} +1", customId, troneId, m.Count));
lock (m)
m.Count++;
return;
}
var trone = LightDataModel.tbl_troneItem.GetRowById(dBase, troneId);
var spTrone = LightDataModel.tbl_sp_troneItem.GetRowById(dBase, trone.sp_trone_id);
var data = cache.GetCacheData(false);
bool iFound = false;
if (data != null)
{
lock (cache.SyncRoot)
{
foreach (var item in data)
{
if (item.SpToneId == spTrone.id && item.Id == key)
{
iFound = true;
break;
}
}
}
}
if (iFound)//用户的缓存已经加载，但没有此通道计费情况
{
m = new CustomFeeModel();
m.SpToneId = spTrone.id;
m.TroneId = trone.id;
m.Date = mrDate.Date;
m.Count = 1;
m.Fee = decimal.ToInt32(trone.price * 100);
cache.InsertItem(m);
Shotgun.Library.SimpleLogRecord.WriteLog("api_userlimit_update",
string.Format("customid:{0},troneId:{1}, found other trone!", customId, troneId));
return;
}
else
{
Shotgun.Library.SimpleLogRecord.WriteLog("api_userlimit_update",
string.Format("customid:{0},troneId:{1},not found!", customId, troneId));
}
//无缓存数据时，无需任何处理
//因为在通道计算时，无缓存数据时，会主动从数据库读取最新信息
//LoadFromDBase(dBase, spTrone.id, customId);
}
static IEnumerable <CustomFeeModel> LoadFromDBase(Shotgun.Database.IBaseDataClass2 dBase, int spTroneId, string customId)
{
var trones = LightDataModel.tbl_troneItem.GetTroneIdsBySptroneId(dBase, spTroneId);
if (trones.Count() == 0)
{
return new CustomFeeModel[] { }
}
;
string sql;
if (string.IsNullOrEmpty(customId))
{//整个通道信息
sql = string.Format("SELECT trone_id,fee_date= current_Date() isToday , sum(count) FROM daily_log.tbl_custom_fee_count "
+ " where trone_id in({0}) "
+ " group by trone_id,isToday",
string.Join(",", trones.Select(e => e.id)), DateTime.Today);
}
else
{//用户计费信息
sql = string.Format("SELECT trone_id,fee_date= current_Date() isToday , sum(count) FROM daily_log.tbl_custom_fee_count "
+ " where trone_id in({0}) and custom_id='{1}'"
+ " group by trone_id,isToday",
string.Join(",", trones.Select(e => e.id)), dBase.SqlEncode(customId));
}
var cmd = dBase.Command();
cmd.CommandText = sql;
System.Data.IDataReader dr = null;
List <CustomFeeModel> rlt = new List <CustomFeeModel>();
try
{
dr = dBase.ExecuteReader(cmd);
while (dr.Read())
{
var m = new CustomFeeModel();
m.CustomId = customId;
m.SpToneId = spTroneId;
m.TroneId = dr.GetInt32(0);
m.Date = dr.GetBoolean(1) ? DateTime.Today : DateTime.Today.AddDays(-1);
m.Count = dr.GetInt32(2);
m.Fee = decimal.ToInt32(100 * trones.First(e => e.id == m.TroneId).price);
rlt.Add(m);
cache.InsertItem(m);
}
}
finally
{
if (dr != null)
{
dr.Dispose();
}
cmd.Dispose();
}
if (rlt.Count == 0)
{//表示该用户，日月限缓存已经建立
var trone = trones.First();
var m = new CustomFeeModel();
m.CustomId = customId;
m.SpToneId = spTroneId;
m.TroneId = trone.id;
m.Date = DateTime.Today;
m.Count = 0;
m.Fee = decimal.ToInt32(100 * trone.price);
rlt.Add(m);
cache.InsertItem(m);
}
return(rlt);
}