public List <Z30> listZ30() { List <Z30> list = new List <Z30>(); string sql = "SELECT * FROM LDC50.Z30"; using (OracleDataReader oracleDataReader = new DBConnecting().GetDataReader(sql)) { while (oracleDataReader.Read()) { Z30 z = new Z30(); z.Z30_REC_KEY = oracleDataReader["Z30_REC_KEY"].ToString().Trim(); z.Z30_BARCODE = oracleDataReader["Z30_BARCODE"].ToString().Trim(); z.Z30_SUB_LIBRARY = oracleDataReader["Z30_SUB_LIBRARY"].ToString().Trim(); list.Add(z); } //oracleDataReader.Close(); //DBConnecting.conn.Close(); } return(list); }
public Section() { Z13 = new Z13(); Z30 = new Z30(); }