public bool bankPhoneExist(string sPhone) { bool bRetVal = false; GLOBAL_SQL_READER reader = null; GLOBAL_SQL_CONN conn = null; try { conn = new GLOBAL_SQL_CONN(this); GLOBAL_SQL_COMMAND command = new GLOBAL_SQL_COMMAND("select * from bank_phone where phone='" + sPhone + "' ", conn); reader = new GLOBAL_SQL_READER(command); if (reader.Read()) { // string sId = reader.c("id").ToString(); // string sBankPhone = reader.c("phone").ToString(); bRetVal = true; } } catch (Exception eee) { } finally { reader.Close(); conn.Close(); } return(bRetVal); }
public bool bankPhoneExist(string sPhone) { bool bRetVal = false; GLOBAL_SQL_READER reader = null; GLOBAL_SQL_CONN conn = null; try { conn = new GLOBAL_SQL_CONN(this); GLOBAL_SQL_COMMAND command = new GLOBAL_SQL_COMMAND("select * from bank_phone where phone='" + sPhone + "' ", conn); reader = new GLOBAL_SQL_READER(command); if (reader.Read()) { // string sId = reader.c("id").ToString(); // string sBankPhone = reader.c("phone").ToString(); bRetVal = true; } } catch (Exception eee) { } finally { reader.Close(); conn.Close(); } return bRetVal; }