private static CBB.ExceptionHelper.OperationResult UpdatePerMonthRanking(String permonthrankingtablename, String id, int year, int month, int scoresIncrease)
{
try
{
PerMonthRanking obj = GetPerMonthRanking(permonthrankingtablename, id, year, month);
//该时段没有分值记录
if (obj == null)
{
obj = new PerMonthRanking();
obj.ObjID = id;
obj.Year = year;
obj.Month = month;
}
obj.Scores += scoresIncrease;
MongoDatabase md = MongoDBHelper.MongoDB;
MongoCollection<PerMonthRanking> mc = md.GetCollection<PerMonthRanking>(permonthrankingtablename);
mc.Save(obj);
return new CBB.ExceptionHelper.OperationResult(true);
}
catch (System.Exception err)
{
throw new CBB.ExceptionHelper.OperationException(
CBB.ExceptionHelper.ErrType.SystemErr,
CBB.ExceptionHelper.ErrNo.DBOperationError,
err);
}
}
private static PerMonthRanking GetPerMonthRanking(String permonthrankingtablename, String id, int year, int month)
{
PerMonthRanking iv = new PerMonthRanking();
try
{
MongoDatabase md = MongoDBHelper.MongoDB;
MongoCollection<PerMonthRanking> mc = md.GetCollection<PerMonthRanking>(permonthrankingtablename);
iv = mc.FindOne(
Query.And(
Query.EQ("ObjID", id),
Query.EQ("Year", year),
Query.EQ("Month", month)
)
);
return iv;
}
catch (System.Exception err)
{
throw new CBB.ExceptionHelper.OperationException(
CBB.ExceptionHelper.ErrType.SystemErr,
CBB.ExceptionHelper.ErrNo.DBOperationError,
err);
}
}