public List <MyFriendsEntity> GetMyFriends(System.Guid managerId, System.Int32 pageIndex, System.Int32 pageSize, ref System.Int32 totalRecord)
{
var database = new SqlDatabase(this.ConnectionString);
DbCommand commandWrapper = database.GetStoredProcCommand("C_Friend_GetMyFriend");
database.AddInParameter(commandWrapper, "@ManagerId", DbType.Guid, managerId);
database.AddInParameter(commandWrapper, "@PageIndex", DbType.Int32, pageIndex);
database.AddInParameter(commandWrapper, "@PageSize", DbType.Int32, pageSize);
database.AddParameter(commandWrapper, "@TotalRecord", DbType.Int32, ParameterDirection.InputOutput, "", DataRowVersion.Current, totalRecord);
List <MyFriendsEntity> list = new List <MyFriendsEntity>();
using (IDataReader reader = database.ExecuteReader(commandWrapper))
{
while (reader.Read())
{
var obj = new MyFriendsEntity();
obj.Idx = (System.Int32)reader["Idx"];
obj.FriendId = (System.Guid)reader["FriendId"];
obj.Intimacy = (System.Int32)reader["Intimacy"];
obj.Name = (System.String)reader["Name"];
obj.Level = (System.Int32)reader["Level"];
obj.ByHelpTrainCount = (System.Int32)reader["ByHelpTrainCount"];
obj.DayHelpTrainCount = (System.Int32)reader["DayHelpTrainCount"];
obj.RecordDate = (System.DateTime)reader["RecordDate"];
obj.FRecordDate = (System.DateTime)reader["FRecordDate"];
obj.VipLevel = (System.Int32)reader["VipLevel"];
list.Add(obj);
}
}
totalRecord = (System.Int32)database.GetParameterValue(commandWrapper, "@TotalRecord");
return(list);
}
bool CheckByHelp(MyFriendsEntity entity, DateTime curDate)
{
if (entity.RecordDate != curDate)
{
return(true);
}
int maxByHelpCount = CacheFactory.VipdicCache.GetEffectValue(entity.VipLevel,
EnumVipEffect.TrainHelpAcceptCount);
return(entity.ByHelpTrainCount < maxByHelpCount);
}
void CalMatchTimes(MyFriendsEntity entity, DateTime curDate)
{
if (entity.FRecordDate != curDate)
{
entity.DayMatchCount = 0;
entity.ByHelpTrainCount = 0;
}
if (entity.RecordDate != curDate)
{
entity.DayCanMatchCount = _friendDayMatchMax;
entity.ByHelpTrainCount = 0;
}
else if (entity.DayMatchCount < _friendDayMatchMax)
{
entity.DayCanMatchCount = _friendDayMatchMax - entity.DayMatchCount;
}
else
{
entity.DayCanMatchCount = 0;
}
entity.RecordDate = curDate;
entity.FRecordDate = curDate;
}
