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