Example #1
0
 public bool UpdateNewChickenBox(NewChickenBoxItemInfo info)
 {
     bool flag = false;
     try
     {
         SqlParameter[] SqlParameters = new SqlParameter[15]
     {
       new SqlParameter("@ID", (object) info.ID),
       new SqlParameter("@UserID", (object) info.UserID),
       new SqlParameter("@TemplateID", (object) info.TemplateID),
       new SqlParameter("@Count", (object) info.Count),
       new SqlParameter("@ValidDate", (object) info.ValidDate),
       new SqlParameter("@StrengthenLevel", (object) info.StrengthenLevel),
       new SqlParameter("@AttackCompose", (object) info.AttackCompose),
       new SqlParameter("@DefendCompose", (object) info.DefendCompose),
       new SqlParameter("@AgilityCompose", (object) info.AgilityCompose),
       new SqlParameter("@LuckCompose", (object) info.LuckCompose),
       new SqlParameter("@Position", (object) info.Position),
       new SqlParameter("@IsSelected", (object) (int) (info.IsSelected ? 1 : 0)),
       new SqlParameter("@IsSeeded", (object) (int) (info.IsSeeded ? 1 : 0)),
       new SqlParameter("@IsBinds", (object) (int) (info.IsBinds ? 1 : 0)),
       new SqlParameter("@Result", SqlDbType.Int)
     };
         SqlParameters[14].Direction = ParameterDirection.ReturnValue;
         this.db.RunProcedure("SP_UpdateNewChickenBox", SqlParameters);
         flag = (int)SqlParameters[14].Value == 0;
     }
     catch (Exception ex)
     {
         if (BaseBussiness.log.IsErrorEnabled)
             BaseBussiness.log.Error((object)"SP_UpdateNewChickenBox", ex);
     }
     return flag;
 }
Example #2
0
 public bool AddNewChickenBox(NewChickenBoxItemInfo info)
 {
     bool flag = false;
     try
     {
         SqlParameter[] SqlParameters = new SqlParameter[15];
         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("@TemplateID", (object)info.TemplateID);
         SqlParameters[3] = new SqlParameter("@Count", (object)info.Count);
         SqlParameters[4] = new SqlParameter("@ValidDate", (object)info.ValidDate);
         SqlParameters[5] = new SqlParameter("@StrengthenLevel", (object)info.StrengthenLevel);
         SqlParameters[6] = new SqlParameter("@AttackCompose", (object)info.AttackCompose);
         SqlParameters[7] = new SqlParameter("@DefendCompose", (object)info.DefendCompose);
         SqlParameters[8] = new SqlParameter("@AgilityCompose", (object)info.AgilityCompose);
         SqlParameters[9] = new SqlParameter("@LuckCompose", (object)info.LuckCompose);
         SqlParameters[10] = new SqlParameter("@Position", (object)info.Position);
         SqlParameters[11] = new SqlParameter("@IsSelected", (object)(int)(info.IsSelected ? 1 : 0));
         SqlParameters[12] = new SqlParameter("@IsSeeded", (object)(int)(info.IsSeeded ? 1 : 0));
         SqlParameters[13] = new SqlParameter("@IsBinds", (object)(int)(info.IsBinds ? 1 : 0));
         SqlParameters[14] = new SqlParameter("@Result", SqlDbType.Int);
         SqlParameters[14].Direction = ParameterDirection.ReturnValue;
         this.db.RunProcedure("SP_NewChickenBox_Add", SqlParameters);
         flag = (int)SqlParameters[14].Value == 0;
         info.ID = (int)SqlParameters[0].Value;
         info.IsDirty = false;
     }
     catch (Exception ex)
     {
         if (BaseBussiness.log.IsErrorEnabled)
             BaseBussiness.log.Error((object)"SP_NewChickenBox_Add", ex);
     }
     return flag;
 }