public static ArrayList GetCollection(int flag_value) { MySqlConnection myConn = DBProxy.GetMySqlConnection(); DBProxy.OpenConnectionForObject(ref myConn); MySqlCommand myCmd = new MySqlCommand("SELECT * from `tablename` WHERE flag_column = " + flag_value, myConn); MySqlDataReader myRdr = null; ArrayList aCltn = new ArrayList(); if (DBProxy.ExecuteSQLReader(ref myCmd, ref myRdr, "GETTER") == false) { if (myRdr != null && myRdr.IsClosed == false) { myRdr.Close(); } DBProxy.CloseConnectionForObject(ref myConn); return(aCltn); } while (myRdr.Read()) { Classname me = new Classname( /* getters */ ); aCltn.Add(me); } myRdr.Close(); DBProxy.CloseConnectionForObject(ref myConn); return(aCltn); }
public static ArrayList GetCollection(int flag_value) { MySqlConnection myConn = DBProxy.GetMySqlConnection(); DBProxy.OpenConnectionForObject(ref myConn); MySqlCommand myCmd = new MySqlCommand("SELECT * from `tsystransxRecon` WHERE flag_column = " + flag_value, myConn); MySqlDataReader myRdr = null; ArrayList aCltn = new ArrayList(); if (DBProxy.ExecuteSQLReader(ref myCmd, ref myRdr, "GETTER") == false) { if (myRdr != null && myRdr.IsClosed == false) { myRdr.Close(); } DBProxy.CloseConnectionForObject(ref myConn); return(aCltn); } while (myRdr.Read()) { TsystransxRecon me = new TsystransxRecon( (myRdr.IsDBNull(0) == true ? 0 : myRdr.GetInt32(0)) , (myRdr.IsDBNull(1) == true ? 0 : myRdr.GetInt32(1)) , (myRdr.IsDBNull(2) == true ? Utility.GetNullDate() : myRdr.GetDateTime(2)) , (myRdr.IsDBNull(3) == true ? Utility.GetNullDate() : myRdr.GetDateTime(3)) ); aCltn.Add(me); } myRdr.Close(); DBProxy.CloseConnectionForObject(ref myConn); return(aCltn); }
public static ArrayList GetCollection(int flag_value) { MySqlConnection myConn = DBProxy.GetMySqlConnection(); DBProxy.OpenConnectionForObject(ref myConn); MySqlCommand myCmd = new MySqlCommand("SELECT * from `eb` WHERE flag_column = " + flag_value, myConn); MySqlDataReader myRdr = null; ArrayList aCltn = new ArrayList(); if (DBProxy.ExecuteSQLReader(ref myCmd, ref myRdr, "GETTER") == false) { if (myRdr != null && myRdr.IsClosed == false) { myRdr.Close(); } DBProxy.CloseConnectionForObject(ref myConn); return(aCltn); } while (myRdr.Read()) { SWEB me = new SWEB( (myRdr.IsDBNull(0) == true ? 0 : myRdr.GetInt32(0)) , (myRdr.IsDBNull(1) == true ? "" : myRdr.GetString(1)) , (myRdr.IsDBNull(2) == true ? "" : myRdr.GetString(2)) , (myRdr.IsDBNull(3) == true ? "" : myRdr.GetString(3)) , (myRdr.IsDBNull(4) == true ? "" : myRdr.GetString(4)) , (myRdr.IsDBNull(5) == true ? "" : myRdr.GetString(5)) , (myRdr.IsDBNull(6) == true ? "" : myRdr.GetString(6)) , (myRdr.IsDBNull(7) == true ? "" : myRdr.GetString(7)) , (myRdr.IsDBNull(8) == true ? "" : myRdr.GetString(8)) , (myRdr.IsDBNull(9) == true ? "" : myRdr.GetString(9)) , (myRdr.IsDBNull(10) == true ? "" : myRdr.GetString(10)) , (myRdr.IsDBNull(11) == true ? "" : myRdr.GetString(11)) , (myRdr.IsDBNull(12) == true ? "" : myRdr.GetString(12)) , (myRdr.IsDBNull(13) == true ? "" : myRdr.GetString(13)) , (myRdr.IsDBNull(14) == true ? "" : myRdr.GetString(14)) , (myRdr.IsDBNull(15) == true ? "" : myRdr.GetString(15)) , (myRdr.IsDBNull(16) == true ? "" : myRdr.GetString(16)) , (myRdr.IsDBNull(17) == true ? "" : myRdr.GetString(17)) , (myRdr.IsDBNull(18) == true ? "" : myRdr.GetString(18)) , (myRdr.IsDBNull(19) == true ? "" : myRdr.GetString(19)) , (myRdr.IsDBNull(20) == true ? "" : myRdr.GetString(20)) , (myRdr.IsDBNull(21) == true ? "" : myRdr.GetString(21)) , (myRdr.IsDBNull(22) == true ? "" : myRdr.GetString(22)) , (myRdr.IsDBNull(23) == true ? "" : myRdr.GetString(23)) , (myRdr.IsDBNull(24) == true ? "" : myRdr.GetString(24)) , (myRdr.IsDBNull(25) == true ? "" : myRdr.GetString(25)) , (myRdr.IsDBNull(26) == true ? "" : myRdr.GetString(26)) , (myRdr.IsDBNull(27) == true ? "" : myRdr.GetString(27)) , (myRdr.IsDBNull(28) == true ? "" : myRdr.GetString(28)) , (myRdr.IsDBNull(29) == true ? "" : myRdr.GetString(29)) , (myRdr.IsDBNull(30) == true ? "" : myRdr.GetString(30)) , (myRdr.IsDBNull(31) == true ? "" : myRdr.GetString(31)) , (myRdr.IsDBNull(32) == true ? "" : myRdr.GetString(32)) , (myRdr.IsDBNull(33) == true ? "" : myRdr.GetString(33)) , (myRdr.IsDBNull(34) == true ? "" : myRdr.GetString(34)) , (myRdr.IsDBNull(35) == true ? "" : myRdr.GetString(35)) , (myRdr.IsDBNull(36) == true ? "" : myRdr.GetString(36)) , (myRdr.IsDBNull(37) == true ? "" : myRdr.GetString(37)) , (myRdr.IsDBNull(38) == true ? "" : myRdr.GetString(38)) , (myRdr.IsDBNull(39) == true ? "" : myRdr.GetString(39)) , (myRdr.IsDBNull(40) == true ? "" : myRdr.GetString(40)) , (myRdr.IsDBNull(41) == true ? "" : myRdr.GetString(41)) , (myRdr.IsDBNull(42) == true ? "" : myRdr.GetString(42)) , (myRdr.IsDBNull(43) == true ? "" : myRdr.GetString(43)) , (myRdr.IsDBNull(44) == true ? "" : myRdr.GetString(44)) , (myRdr.IsDBNull(45) == true ? "" : myRdr.GetString(45)) , (myRdr.IsDBNull(46) == true ? "" : myRdr.GetString(46)) , (myRdr.IsDBNull(47) == true ? "" : myRdr.GetString(47)) , (myRdr.IsDBNull(48) == true ? "" : myRdr.GetString(48)) , (myRdr.IsDBNull(49) == true ? "" : myRdr.GetString(49)) , (myRdr.IsDBNull(50) == true ? "" : myRdr.GetString(50)) , (myRdr.IsDBNull(51) == true ? "" : myRdr.GetString(51)) , (myRdr.IsDBNull(52) == true ? "" : myRdr.GetString(52)) , (myRdr.IsDBNull(53) == true ? 0 : myRdr.GetInt32(53)) , (myRdr.IsDBNull(54) == true ? 0 : myRdr.GetInt32(54)) , (myRdr.IsDBNull(55) == true ? "" : myRdr.GetString(55)) , (myRdr.IsDBNull(56) == true ? "" : myRdr.GetString(56)) ); aCltn.Add(me); } myRdr.Close(); DBProxy.CloseConnectionForObject(ref myConn); return(aCltn); }