public bool AddUserTreasureInfo(UserTreasureInfo item)
{
bool flag = false;
try
{
SqlParameter[] SqlParameters = new SqlParameter[11];
SqlParameters[0] = new SqlParameter("@ID", (object)item.ID);
SqlParameters[0].Direction = ParameterDirection.Output;
SqlParameters[1] = new SqlParameter("@UserID", (object)item.UserID);
SqlParameters[2] = new SqlParameter("@NickName", (object)item.NickName);
SqlParameters[3] = new SqlParameter("@logoinDays", (object)item.logoinDays);
SqlParameters[4] = new SqlParameter("@treasure", (object)item.treasure);
SqlParameters[5] = new SqlParameter("@treasureAdd", (object)item.treasureAdd);
SqlParameters[6] = new SqlParameter("@friendHelpTimes", (object)item.friendHelpTimes);
SqlParameters[7] = new SqlParameter("@isEndTreasure", (object)(int)(item.isEndTreasure ? 1 : 0));
SqlParameters[8] = new SqlParameter("@isBeginTreasure", (object)(int)(item.isBeginTreasure ? 1 : 0));
SqlParameters[9] = new SqlParameter("@LastLoginDay", (object)item.LastLoginDay);
SqlParameters[10] = new SqlParameter("@Result", SqlDbType.Int);
SqlParameters[10].Direction = ParameterDirection.ReturnValue;
this.db.RunProcedure("SP_Users_Treasure_Add", SqlParameters);
flag = (int)SqlParameters[10].Value == 0;
item.ID = (int)SqlParameters[0].Value;
item.IsDirty = false;
}
catch (Exception ex)
{
if (BaseBussiness.log.IsErrorEnabled)
BaseBussiness.log.Error((object)"Init", ex);
}
return flag;
}
public bool UpdateUserTreasureInfo(UserTreasureInfo item)
{
bool flag = false;
try
{
SqlParameter[] SqlParameters = new SqlParameter[10]
{
new SqlParameter("@UserID", (object) item.UserID),
new SqlParameter("@NickName", (object) item.NickName),
new SqlParameter("@logoinDays", (object) item.logoinDays),
new SqlParameter("@treasure", (object) item.treasure),
new SqlParameter("@treasureAdd", (object) item.treasureAdd),
new SqlParameter("@friendHelpTimes", (object) item.friendHelpTimes),
new SqlParameter("@isEndTreasure", (object) (int) (item.isEndTreasure ? 1 : 0)),
new SqlParameter("@isBeginTreasure", (object) (int) (item.isBeginTreasure ? 1 : 0)),
new SqlParameter("@LastLoginDay", (object) item.LastLoginDay),
new SqlParameter("@Result", SqlDbType.Int)
};
SqlParameters[9].Direction = ParameterDirection.ReturnValue;
this.db.RunProcedure("SP_UpdateUserTreasure", SqlParameters);
flag = (int)SqlParameters[9].Value == 0;
}
catch (Exception ex)
{
if (BaseBussiness.log.IsErrorEnabled)
BaseBussiness.log.Error((object)"SP_UpdateUserTreasure", ex);
}
return flag;
}
