/// <summary> /// 带事务的Update /// </summary> /// <param name="entity"></param> /// <param name="trans">The trans.</param> /// <returns></returns> /// <remarks>2014/10/31 16:41:29</remarks> public bool Update(ConfigRevelationcheckpointEntity entity, DbTransaction trans) { var database = new SqlDatabase(this.ConnectionString); DbCommand commandWrapper = database.GetStoredProcCommand("dbo.P_ConfigRevelationcheckpoint_Update"); database.AddInParameter(commandWrapper, "@Mark", DbType.Int32, entity.Mark); database.AddInParameter(commandWrapper, "@SmallClearance", DbType.Int32, entity.SmallClearance); database.AddInParameter(commandWrapper, "@CheckpointPlayers", DbType.String, entity.CheckpointPlayers); database.AddInParameter(commandWrapper, "@Describe", DbType.String, entity.Describe); database.AddInParameter(commandWrapper, "@TheStory", DbType.String, entity.TheStory); database.AddInParameter(commandWrapper, "@Team", DbType.String, entity.Team); database.AddInParameter(commandWrapper, "@AgainstTheTeam", DbType.String, entity.AgainstTheTeam); database.AddInParameter(commandWrapper, "@Formation", DbType.Int32, entity.Formation); database.AddInParameter(commandWrapper, "@TheGoalkeeperID", DbType.Int32, entity.TheGoalkeeperID); database.AddInParameter(commandWrapper, "@TheGoalkeeperName", DbType.String, entity.TheGoalkeeperName); database.AddInParameter(commandWrapper, "@PlayersID1", DbType.Int32, entity.PlayersID1); database.AddInParameter(commandWrapper, "@PlayersName1", DbType.String, entity.PlayersName1); database.AddInParameter(commandWrapper, "@PlayersID2", DbType.Int32, entity.PlayersID2); database.AddInParameter(commandWrapper, "@PlayersName2", DbType.String, entity.PlayersName2); database.AddInParameter(commandWrapper, "@PlayersID3", DbType.Int32, entity.PlayersID3); database.AddInParameter(commandWrapper, "@PlayersName3", DbType.String, entity.PlayersName3); database.AddInParameter(commandWrapper, "@PlayersID4", DbType.Int32, entity.PlayersID4); database.AddInParameter(commandWrapper, "@PlayersName4", DbType.String, entity.PlayersName4); database.AddInParameter(commandWrapper, "@PlayersID5", DbType.Int32, entity.PlayersID5); database.AddInParameter(commandWrapper, "@PlayersName5", DbType.String, entity.PlayersName5); database.AddInParameter(commandWrapper, "@PlayersID6", DbType.Int32, entity.PlayersID6); database.AddInParameter(commandWrapper, "@PlayersName6", DbType.String, entity.PlayersName6); database.AddInParameter(commandWrapper, "@PlayersID7", DbType.Int32, entity.PlayersID7); database.AddInParameter(commandWrapper, "@PlayersName7", DbType.String, entity.PlayersName7); database.AddInParameter(commandWrapper, "@PlayersID8", DbType.Int32, entity.PlayersID8); database.AddInParameter(commandWrapper, "@PlayersName8", DbType.String, entity.PlayersName8); database.AddInParameter(commandWrapper, "@PlayersID9", DbType.Int32, entity.PlayersID9); database.AddInParameter(commandWrapper, "@PlayersName9", DbType.String, entity.PlayersName9); database.AddInParameter(commandWrapper, "@PlayersID10", DbType.Int32, entity.PlayersID10); database.AddInParameter(commandWrapper, "@PlayersName10", DbType.String, entity.PlayersName10); int results = 0; if (trans != null) { results = database.ExecuteNonQuery(commandWrapper, trans); } else { results = database.ExecuteNonQuery(commandWrapper); } return(Convert.ToBoolean(results)); }
/// <summary> /// GetById /// </summary> /// <param name="mark">mark</param> /// <param name="smallClearance">smallClearance</param> /// <returns>ConfigRevelationcheckpointEntity</returns> /// <remarks>2014/10/31 16:41:29</remarks> public ConfigRevelationcheckpointEntity GetById(System.Int32 mark, System.Int32 smallClearance) { var database = new SqlDatabase(this.ConnectionString); DbCommand commandWrapper = database.GetStoredProcCommand("P_ConfigRevelationcheckpoint_GetById"); database.AddInParameter(commandWrapper, "@Mark", DbType.Int32, mark); database.AddInParameter(commandWrapper, "@SmallClearance", DbType.Int32, smallClearance); ConfigRevelationcheckpointEntity obj = null; using (IDataReader reader = database.ExecuteReader(commandWrapper)) { if (reader.Read()) { obj = LoadSingleRow(reader); } } return(obj); }
/// <summary> /// 将IDataReader的当前记录读取到ConfigRevelationcheckpointEntity 对象 /// </summary> /// <param name="reader"></param> /// <returns></returns> public ConfigRevelationcheckpointEntity LoadSingleRow(IDataReader reader) { var obj = new ConfigRevelationcheckpointEntity(); obj.Mark = (System.Int32)reader["Mark"]; obj.SmallClearance = (System.Int32)reader["SmallClearance"]; obj.CheckpointPlayers = (System.String)reader["CheckpointPlayers"]; obj.Describe = (System.String)reader["Describe"]; obj.TheStory = (System.String)reader["TheStory"]; obj.Team = (System.String)reader["Team"]; obj.AgainstTheTeam = (System.String)reader["AgainstTheTeam"]; obj.Formation = (System.Int32)reader["Formation"]; obj.TheGoalkeeperID = (System.Int32)reader["TheGoalkeeperID"]; obj.TheGoalkeeperName = (System.String)reader["TheGoalkeeperName"]; obj.PlayersID1 = (System.Int32)reader["PlayersID1"]; obj.PlayersName1 = (System.String)reader["PlayersName1"]; obj.PlayersID2 = (System.Int32)reader["PlayersID2"]; obj.PlayersName2 = (System.String)reader["PlayersName2"]; obj.PlayersID3 = (System.Int32)reader["PlayersID3"]; obj.PlayersName3 = (System.String)reader["PlayersName3"]; obj.PlayersID4 = (System.Int32)reader["PlayersID4"]; obj.PlayersName4 = (System.String)reader["PlayersName4"]; obj.PlayersID5 = (System.Int32)reader["PlayersID5"]; obj.PlayersName5 = (System.String)reader["PlayersName5"]; obj.PlayersID6 = (System.Int32)reader["PlayersID6"]; obj.PlayersName6 = (System.String)reader["PlayersName6"]; obj.PlayersID7 = (System.Int32)reader["PlayersID7"]; obj.PlayersName7 = (System.String)reader["PlayersName7"]; obj.PlayersID8 = (System.Int32)reader["PlayersID8"]; obj.PlayersName8 = (System.String)reader["PlayersName8"]; obj.PlayersID9 = (System.Int32)reader["PlayersID9"]; obj.PlayersName9 = (System.String)reader["PlayersName9"]; obj.PlayersID10 = (System.Int32)reader["PlayersID10"]; obj.PlayersName10 = (System.String)reader["PlayersName10"]; return(obj); }
/// <summary> /// Update /// </summary> /// <param name="entity"></param> /// <returns></returns> /// <remarks>2014/10/31 16:41:29</remarks> public bool Update(ConfigRevelationcheckpointEntity entity) { return(Update(entity, null)); }
/// <summary> /// Insert /// </summary> /// <param name="entity"></param> /// <param name="trans">The trans.</param> /// <returns></returns> /// <remarks>2014/10/31 16:41:29</remarks> public bool Insert(ConfigRevelationcheckpointEntity entity) { return(Insert(entity, null)); }
public static bool Update(ConfigRevelationcheckpointEntity configRevelationcheckpointEntity, DbTransaction trans = null, string zoneId = "") { var provider = new ConfigRevelationcheckpointProvider(zoneId); return(provider.Update(configRevelationcheckpointEntity, trans)); }