Example #1
0
 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;
 }
Example #2
0
 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;
 }