public RegTypeData getRegType(String RegType_Code)
{
RegTypeData RegType_data = new RegTypeData();
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
oracleObj.SelectCommand = "Select * From REG_TYPE Where regtype_code='" + RegType_Code + "'";
DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView rowData in allData)
{
RegType_data.RegType_Code = rowData["regtype_code"].ToString();
RegType_data.RegType_Thai = rowData["regtype_thai"].ToString();
RegType_data.RegType_Eng = rowData["regtype_eng"].ToString();
}
return(RegType_data);
}
public List <RegTypeData> getRegType()
{
List <RegTypeData> RegType_data = new List <RegTypeData>();
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
oracleObj.SelectCommand = "Select * From REG_TYPE Order By RegType_Code";
DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView rowData in allData)
{
RegTypeData RegType = new RegTypeData();
RegType.RegType_Code = rowData["regtype_code"].ToString();
RegType.RegType_Thai = rowData["regtype_thai"].ToString();
RegType.RegType_Eng = rowData["regtype_eng"].ToString();
RegType_data.Add(RegType);
}
return(RegType_data);
}
