public bool UpdateUserChristmas(UserChristmasInfo info) { bool flag = false; try { SqlParameter[] SqlParameters = new SqlParameter[13] { new SqlParameter("@ID", (object) info.ID), new SqlParameter("@UserID", (object) info.UserID), new SqlParameter("@exp", (object) info.exp), new SqlParameter("@awardState", (object) info.awardState), new SqlParameter("@count", (object) info.count), new SqlParameter("@packsNumber", (object) info.packsNumber), new SqlParameter("@lastPacks", (object) info.lastPacks), new SqlParameter("@gameBeginTime", (object) info.gameBeginTime), new SqlParameter("@gameEndTime", (object) info.gameEndTime), new SqlParameter("@isEnter", (object) (int) (info.isEnter ? 1 : 0)), new SqlParameter("@dayPacks", (object) info.dayPacks), new SqlParameter("@AvailTime", (object) info.AvailTime), new SqlParameter("@Result", SqlDbType.Int) }; SqlParameters[12].Direction = ParameterDirection.ReturnValue; this.db.RunProcedure("SP_UpdateUserChristmas", SqlParameters); flag = (int)SqlParameters[12].Value == 0; } catch (Exception ex) { if (BaseBussiness.log.IsErrorEnabled) BaseBussiness.log.Error((object)"SP_UpdateUserChristmas", ex); } return flag; }
public bool AddUserChristmas(UserChristmasInfo info) { bool flag = false; try { SqlParameter[] SqlParameters = new SqlParameter[13]; SqlParameters[0] = new SqlParameter("@ID", (object)info.ID); SqlParameters[0].Direction = ParameterDirection.Output; SqlParameters[1] = new SqlParameter("@UserID", (object)info.UserID); SqlParameters[2] = new SqlParameter("@exp", (object)info.exp); SqlParameters[3] = new SqlParameter("@awardState", (object)info.awardState); SqlParameters[4] = new SqlParameter("@count", (object)info.count); SqlParameters[5] = new SqlParameter("@packsNumber", (object)info.packsNumber); SqlParameters[6] = new SqlParameter("@lastPacks", (object)info.lastPacks); SqlParameters[7] = new SqlParameter("@gameBeginTime", (object)info.gameBeginTime); SqlParameters[8] = new SqlParameter("@gameEndTime", (object)info.gameEndTime); SqlParameters[9] = new SqlParameter("@isEnter", (object)(int)(info.isEnter ? 1 : 0)); SqlParameters[10] = new SqlParameter("@dayPacks", (object)info.dayPacks); SqlParameters[11] = new SqlParameter("@AvailTime", (object)info.AvailTime); SqlParameters[12] = new SqlParameter("@Result", SqlDbType.Int); SqlParameters[12].Direction = ParameterDirection.ReturnValue; this.db.RunProcedure("SP_UserChristmas_Add", SqlParameters); flag = (int)SqlParameters[12].Value == 0; info.ID = (int)SqlParameters[0].Value; info.IsDirty = false; } catch (Exception ex) { if (BaseBussiness.log.IsErrorEnabled) BaseBussiness.log.Error((object)"Init", ex); } return flag; }