// 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);
}
}
