public static CustomList <HRM_EmpAddr> GetAllEmpAddrByEmpKey(string empKey) { ConnectionManager conManager = new ConnectionManager(ConnectionName.HR); CustomList <HRM_EmpAddr> HRM_EmpAddrCollection = new CustomList <HRM_EmpAddr>(); IDataReader reader = null; String sql = "select * from hrm_empaddr ea where ea.EmpKey = " + empKey; try { conManager.OpenDataReader(sql, out reader); while (reader.Read()) { HRM_EmpAddr newHRM_EmpAddr = new HRM_EmpAddr(); newHRM_EmpAddr.SetData(reader); HRM_EmpAddrCollection.Add(newHRM_EmpAddr); } HRM_EmpAddrCollection.InsertSpName = "spInsertHRM_EmpAddr"; HRM_EmpAddrCollection.UpdateSpName = "spUpdateHRM_EmpAddr"; HRM_EmpAddrCollection.DeleteSpName = "spDeleteHRM_EmpAddr"; return(HRM_EmpAddrCollection); } catch (Exception ex) { throw (ex); } finally { if (reader != null && !reader.IsClosed) { reader.Close(); } } }
public static HRM_EmpAddr GetSearchEmpAddress(long empKey) { ConnectionManager conManager = new ConnectionManager(ConnectionName.HR); IDataReader reader = null; String sql = "EXEC spGetSearchEmpAddress '" + empKey + "'"; try { HRM_EmpAddr newHRM_EmpAddr = new HRM_EmpAddr(); conManager.OpenDataReader(sql, out reader); while (reader.Read()) { newHRM_EmpAddr.SetDataSearchEmp(reader); } return(newHRM_EmpAddr); } catch (Exception ex) { throw (ex); } finally { if (reader != null && !reader.IsClosed) { reader.Close(); } } }