public List <Z308> listZ308TED()
{
List <Z308> list = new List <Z308>();
string sql = "SELECT * FROM LSP00.Z308,LSP00.Z303 where Z308.Z308_ID=Z303.Z303_REC_KEY and Z308.Z308_REC_KEY like'01%'";
try
{
using (OracleDataReader oracleDataReader = new DBConnecting().GetDataReader(sql))
{
while (oracleDataReader.Read())
{
Z308 z = new Z308();
z.Z308_REC_KEY = oracleDataReader["Z308_REC_KEY"].ToString().Trim();
z.Z308_VERIFICATION = oracleDataReader["Z308_VERIFICATION"].ToString().Trim();
z.Z308_VERIFICATION_TYPE = oracleDataReader["Z308_VERIFICATION_TYPE"].ToString().Trim();
z.Z308_ID = oracleDataReader["Z308_ID"].ToString().Trim();
z.Z308_STATUS = oracleDataReader["Z308_STATUS"].ToString().Trim();
z.Z308_ENCRYPTION = oracleDataReader["Z303_NAME"].ToString().Trim();
z.Z303_NAME = oracleDataReader["Z303_NAME"].ToString().Trim();
z.Z303_BIRTH_DATE = oracleDataReader["Z303_BIRTH_DATE"].ToString().Trim();
z.Z303_FIELD_1 = oracleDataReader["Z303_FIELD_1"].ToString().Trim();
z.Z303_FIELD_2 = oracleDataReader["Z303_FIELD_2"].ToString().Trim();
z.Z303_FIELD_3 = oracleDataReader["Z303_FIELD_3"].ToString().Trim();
list.Add(z);
}
oracleDataReader.Close();
DBConnecting.conn.Close();
}
}
catch
{
}
return(list);
}
public List <Z308> GetListZ308()
{
var listZ308 = new List <Z308>(TotalRecordsZ308());
string sql = "SELECT * FROM LDC00.Z308,LDC00.Z303 where Z308.Z308_ID=Z303.Z303_REC_KEY and Z308.Z308_REC_KEY like'01%'";
try
{
using (OracleDataReader oracleDataReader = new DBConnecting().GetDataReader(sql))
{
while (oracleDataReader.Read())
{
var z308 = new Z308();
z308.Z308_REC_KEY = oracleDataReader["Z308_REC_KEY"].ToString().Trim();
z308.Z308_VERIFICATION = oracleDataReader["Z308_VERIFICATION"].ToString().Trim();
z308.Z308_VERIFICATION_TYPE = oracleDataReader["Z308_VERIFICATION_TYPE"].ToString().Trim();
z308.Z308_ID = oracleDataReader["Z308_ID"].ToString().Trim();
z308.Z308_STATUS = oracleDataReader["Z308_STATUS"].ToString().Trim();
z308.Z308_ENCRYPTION = oracleDataReader["Z303_NAME"].ToString().Trim();
z308.Z308_UPD_TIME_STAMP = oracleDataReader["Z308_UPD_TIME_STAMP"].ToString().Trim();
listZ308.Add(z308);
}
}
}
catch (OracleException ex)
{
log.Error(ex.Message);
}
return(listZ308);
}
