public List <SYS_Region> SelectAllSYS_RegionByIDRegion(int IDRegion) { List <SYS_Region> sys_region = new List <SYS_Region>(); DbDataReader reader = null; DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString); conn.Open(); try { List <DbParameter> para = new List <DbParameter>(); para.Add(_DbHelper.CreateParameter(FIELD_ID, IDRegion, false)); reader = _DbHelper.ExecuteReader(conn, Common.DatabaseSchema + "[SYS_Region_SelectAllByIDRegion]", para.ToArray()); if (reader.HasRows) { SYS_RegionDataAccess.SetListSYS_RegionInfo(ref reader, ref sys_region); } return(sys_region); } catch (Exception ex) { throw new Exception(String.Format(" SelectAllSYS_RegionByIDRegion: {0}", ex.Message)); } finally { if (reader != null) { reader.Close(); } conn.Close(); } }
public List <SYS_Region> SelectAllSYS_Region() { List <SYS_Region> sys_region = new List <SYS_Region>(); DbDataReader reader = null; DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString); conn.Open(); try { reader = _DbHelper.ExecuteReader(conn, Common.DatabaseSchema + "[SYS_Region_SelectAll]", (DbParameter[])null); if (reader.HasRows) { SYS_RegionDataAccess.SetListSYS_RegionInfo(ref reader, ref sys_region); } return(sys_region); } catch (Exception ex) { throw new Exception(String.Format(" SYS_RegionDataAccess.SelectAll: {0}", ex.Message)); } finally { if (reader != null) { reader.Close(); } conn.Close(); } }