// Lấy danh sách mã chứng khoán public static List <MaCK> LayDSMaCK(string soTKLK) { try { List <MaCK> list = new List <MaCK>(); OracleCommand oracleCommand = new OracleCommand(); oracleCommand.CommandText = oracleCommand.CommandText = "SELECT CHI_TIET_RO.MA_CK FROM KHACH_HANG,CHI_TIET_RO WHERE KHACH_HANG.MA_RO = CHI_TIET_RO.MA_RO AND KHACH_HANG.SO_TKLK = :soTKLK GROUP BY CHI_TIET_RO.MA_CK"; oracleCommand.Parameters.Add(new OracleParameter("soTKLK", soTKLK)); OracleDataReader oracleDataReader = DataProvider.GetOracleDataReader(oracleCommand); if (oracleDataReader != null && oracleDataReader.HasRows) { while (oracleDataReader.Read()) { MaCK maCK = new MaCK(); maCK.MaCk = oracleDataReader.GetString(0); list.Add(maCK); } } oracleCommand.Connection.Dispose(); return(list); } catch (Exception e) { MessageBox.Show("Lỗi: " + e.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error); return(null); } }
// lấy danh sách mã CK public static List <MaCK> layDSMaCk() { try { List <MaCK> list = new List <MaCK>(); OracleCommand oracleCommand = new OracleCommand(); oracleCommand.CommandText = "SELECT * FROM CHUNG_KHOAN"; OracleDataReader oracleDataReader = DataProvider.GetOracleDataReader(oracleCommand); if (oracleDataReader != null && oracleDataReader.HasRows) { while (oracleDataReader.Read()) { MaCK maCK = new MaCK(); maCK.MaCk = oracleDataReader.GetString(0); list.Add(maCK); } } oracleCommand.Connection.Dispose(); return(list); } catch (Exception e) { MessageBox.Show("Lỗi: " + e.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error); return(null); } }