Exemple #1
0
 public bool UpdateqPet(PetEquipDataInfo info)
 {
     bool flag = false;
     try
     {
         SqlParameter[] SqlParameters = new SqlParameter[9]
     {
       new SqlParameter("@ID", (object) info.ID),
       new SqlParameter("@UserID", (object) info.UserID),
       new SqlParameter("@PetID", (object) info.PetID),
       new SqlParameter("@eqType", (object) info.eqType),
       new SqlParameter("@eqTemplateID", (object) info.eqTemplateID),
       new SqlParameter("@startTime", (object) info.startTime),
       new SqlParameter("@ValidDate", (object) info.ValidDate),
       new SqlParameter("@IsExit", (object) (int) (info.IsExit ? 1 : 0)),
       new SqlParameter("@Result", SqlDbType.Int)
     };
         SqlParameters[8].Direction = ParameterDirection.ReturnValue;
         this.db.RunProcedure("SP_eqPet_Update", SqlParameters);
         flag = (int)SqlParameters[8].Value == 0;
     }
     catch (Exception ex)
     {
         if (BaseBussiness.log.IsErrorEnabled)
             BaseBussiness.log.Error((object)"Init", ex);
     }
     return flag;
 }
Exemple #2
0
 public bool AddeqPet(PetEquipDataInfo info)
 {
     bool flag = false;
     try
     {
         SqlParameter[] SqlParameters = new SqlParameter[9];
         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("@PetID", (object)info.PetID);
         SqlParameters[3] = new SqlParameter("@eqType", (object)info.eqType);
         SqlParameters[4] = new SqlParameter("@eqTemplateID", (object)info.eqTemplateID);
         SqlParameters[5] = new SqlParameter("@startTime", (object)info.startTime);
         SqlParameters[6] = new SqlParameter("@ValidDate", (object)info.ValidDate);
         SqlParameters[7] = new SqlParameter("@IsExit", (object)(int)(info.IsExit ? 1 : 0));
         SqlParameters[8] = new SqlParameter("@Result", SqlDbType.Int);
         SqlParameters[8].Direction = ParameterDirection.ReturnValue;
         flag = this.db.RunProcedure("SP_User_Add_eqPet", SqlParameters);
         flag = (int)SqlParameters[8].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;
 }