public static List <Location> List(int levelId = 0) { List <Location> list = new List <Location>(); string sql = string.Format( "select l.*, v.Name Name2 from Location l inner join Level v on v.LevelId=l.LevelId " + "WHERE {0}=0 or l.LevelId={0} order by v.Name, l.Name;", levelId ); using (DataSet ds = DataAccess.RunSql(sql)) { list.Capacity = ds.Tables[0].Rows.Count; // list level locations foreach (DataRow r in ds.Tables[0].Rows) { Location loc = new Location(); loc._initFromRow(r); string name2 = r.StringOrBlank("Name2").Trim(); loc.Name = string.Format("{0} : {1}", name2 == "" ? string.Format("Level {0}", loc.LevelId) : name2, loc.Name ); list.Add(loc); } } return(list); }
public static List <Location> List(int levelId = 0) { List <Location> list = new List <Location>(); using (SqlCommand cmd = new SqlCommand() { CommandType = CommandType.Text, CommandText = "select l.*, v.Name Name2 from Location l inner join Level v on v.LevelId=l.LevelId " + "where @levelId=0 or l.LevelId=@levelId order by v.Name, l.Name;", }) { cmd.Parameters.AddWithValue("@levelId", levelId); cmd.ExecuteReaderExt((r) => { Location loc = new Location(); loc._initFromRow(r); string name2 = r.StringOrBlank("Name2").Trim(); loc.Name = string.Format("{0} : {1}", name2 == "" ? string.Format("Level {0}", loc.LevelId) : name2, loc.Name ); list.Add(loc); return(true); }); } return(list); }
public static List<Location> List(int levelId = 0) { List<Location> list = new List<Location>(); using (SqlCommand cmd = new SqlCommand() { CommandType = CommandType.Text, CommandText = "select l.*, v.Name Name2 from Location l inner join Level v on v.LevelId=l.LevelId " + "where @levelId=0 or l.LevelId=@levelId order by v.Name, l.Name;", }) { cmd.Parameters.AddWithValue("@levelId", levelId); cmd.ExecuteReaderExt((r) => { Location loc = new Location(); loc._initFromRow(r); string name2 = r.StringOrBlank("Name2").Trim(); loc.Name = string.Format("{0} : {1}", name2 == "" ? string.Format("Level {0}", loc.LevelId) : name2, loc.Name ); list.Add(loc); return true; }); } return list; }
public static List<Location> List(int levelId = 0) { List<Location> list = new List<Location>(); string sql = string.Format( "select l.*, v.Name Name2 from Location l inner join Level v on v.LevelId=l.LevelId " + "WHERE {0}=0 or l.LevelId={0} order by v.Name, l.Name;", levelId ); using (DataSet ds = DataAccess.RunSql(sql)) { list.Capacity = ds.Tables[0].Rows.Count; // list level locations foreach (DataRow r in ds.Tables[0].Rows) { Location loc = new Location(); loc._initFromRow(r); string name2 = r.StringOrBlank("Name2").Trim(); loc.Name = string.Format("{0} : {1}", name2 == "" ? string.Format("Level {0}", loc.LevelId) : name2, loc.Name ); list.Add(loc); } } return list; }