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; }
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; }