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);
}
