public List <SYS_Position> SelectAllSYS_Position() { DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString); conn.Open(); List <SYS_Position> sys_position = new List <SYS_Position>(); DbDataReader reader = null; try { reader = _DbHelper.ExecuteReader(conn, Common.DatabaseSchema + "[SYS_Position_SelectAll]", (DbParameter[])null); if (reader.HasRows) { SYS_PositionDataAccess.SetListSYS_PositionInfo(ref reader, ref sys_position); } return(sys_position); } catch (Exception ex) { throw new Exception(String.Format(" SYS_PositionDataAccess.SelectAll: {0}", ex.Message)); } finally { if (reader != null) { reader.Close(); } conn.Close(); } }
public List <SYS_Position> SYS_Position_GetByIDSYS_OrganizationPositionRole(int OrganizationId) { DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString); conn.Open(); List <SYS_Position> sys_position = new List <SYS_Position>(); DbDataReader reader = null; try { List <DbParameter> para = new List <DbParameter>(); para.Add(_DbHelper.CreateParameter(FIELD_ID, OrganizationId, false)); reader = _DbHelper.ExecuteReader(conn, Common.DatabaseSchema + "[SYS_Position_GetByIDSYS_OrganizationPositionRole]", para.ToArray()); if (reader.HasRows) { SYS_PositionDataAccess.SetListSYS_PositionInfo(ref reader, ref sys_position); } return(sys_position); } catch (Exception ex) { throw new Exception(String.Format("SYS_Position_GetByIDSYS_OrganizationPositionRole.SelectById: {0}", ex.Message)); } finally { if (reader != null) { reader.Close(); } conn.Close(); } }