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 <Z303Entity> listZ303() { List <Z303Entity> list = new List <Z303Entity>(); string sql = "SELECT * FROM LSP00.Z303,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()) { Z303Entity z = new Z303Entity(); //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.Z308_UPD_TIME_STAMP = oracleDataReader["Z308_UPD_TIME_STAMP"].ToString().Trim(); list.Add(z); } oracleDataReader.Close(); DBConnecting.conn.Close(); } } catch { } return(list); }
public bool CheckBarcode(string barcode) { bool result = false; string sql = "SELECT Z308_REC_KEY FROM LSP00.Z308 where Z308.Z308_REC_KEY like'01" + barcode + "%'"; try { using (OracleDataReader oracleDataReader = new DBConnecting().GetDataReader(sql)) { if (oracleDataReader.Read()) { result = true; } oracleDataReader.Close(); DBConnecting.conn.Close(); } } catch { result = false; } return(result); }
public int CountPatron() { int result = 0; string sql = "SELECT Z308_ID FROM (SELECT Z308_ID FROM LSP00.Z308 where Z308_ID like '000%' and Z308_REC_KEY like '01%' order by TO_NUMBER(Z308_ID) desc) WHERE ROWNUM <= 1"; try { using (OracleDataReader oracleDataReader = new DBConnecting().GetDataReader(sql)) { while (oracleDataReader.Read()) { result = int.Parse(oracleDataReader["Z308_ID"].ToString().Trim()); } oracleDataReader.Close(); DBConnecting.conn.Close(); } } catch { result = 0; } return(result); }