public static List <m_facility> getFacilityAllList() { NpgsqlDataReader dataReader = null; var res = new List <m_facility>(); using (var dbc = new DB.DBConnect()) { dbc.npg.Open(); StringBuilder sb = new StringBuilder(); sb.Append(@"select store_code,facility_code, facility_name "); sb.Append(@"from m_facility "); sb.Append(@"where m_facility.delete_flag = '0' "); sb.Append(@"order by store_code,facility_code"); var command = new NpgsqlCommand(sb.ToString(), dbc.npg); dataReader = command.ExecuteReader(); while (dataReader.Read()) { m_facility facility = new m_facility(); facility.store_code = dataReader["store_code"].ToString(); facility.facility_code = dataReader["facility_code"].ToString(); facility.facility_name = dataReader["facility_name"].ToString(); res.Add(facility); } } return(res); }
public static m_facility getSingle(string store_code, string code) { m_facility res = new m_facility(); using (var dbc = new DBConnect()) { res = dbc.m_facility.SingleOrDefault(x => x.store_code == store_code & x.facility_code == code); } return(res); }