/// <summary>
/// เรียกดูข้อมูลจากตาราง CURRDISPLAY
/// </summary>
/// <param name="CurrDisplayCode">รหัสรุปแบบการแสดงผล หมวดวิชาศึกษาทั่วไป</param>
/// <returns>ข้อมูลจากตาราง CURRDISPLAY</returns>
public CurrDisplay getCurrDisplay(string CurrDisplayCode)
{
CurrDisplay CurrDisplayData = new CurrDisplay();
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle_tqf2();
oracleObj.SelectCommand = "Select * From CURRDISPLAY Where CURRDISPLAYCODE='" + CurrDisplayCode + "'";
DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView rowData in allData)
{
CurrDisplayData.CurrDisplayCode = rowData["CURRDISPLAYCODE"].ToString();
CurrDisplayData.CurrDisplayName = rowData["CURRDISPLAYNAME"].ToString();
}
return(CurrDisplayData);
}
/// <summary>
/// เรียกดูข้อมูลจากตาราง CURRDISPLAY
/// </summary>
/// <returns>ข้อมูลจากตาราง CURRDISPLAY</returns>
public List <CurrDisplay> getCurrDisplay()
{
List <CurrDisplay> CurrDisplayData = new List <CurrDisplay>();
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle_tqf2();
oracleObj.SelectCommand = "Select * From CURRDISPLAY Order By CURRDISPLAYCODE";
DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView rowData in allData)
{
CurrDisplay CurrDisplayRow = new CurrDisplay();
CurrDisplayRow.CurrDisplayCode = rowData["CURRDISPLAYCODE"].ToString();
CurrDisplayRow.CurrDisplayName = rowData["CURRDISPLAYNAME"].ToString();
CurrDisplayData.Add(CurrDisplayRow);
}
return(CurrDisplayData);
}
