//hien thi danh sach goi mon
public List <goiMonDB> tim_ma(string ma_tang, string ma_ban)
{
List <goiMonDB> tim_ma = new List <goiMonDB>();
try
{
SqlConnection cn = new SqlConnection(ketnoi.cn);
cn.Open();
string sql = "SELECT * FROM goi_mon where ma_tang = '" + ma_tang + "' and ma_ban = '" + ma_ban + "' and trang_thai = 'True'";
SqlCommand cmd = new SqlCommand(sql, cn);
SqlDataReader rd = cmd.ExecuteReader();
while (rd.Read())
{
goiMonDB gm = new goiMonDB();
gm.ma_goimon = rd.GetString(0);
gm.matang = rd.GetString(1);
gm.maban = rd.GetString(2);
gm.matk = rd.GetString(3);
tim_ma.Add(gm);
}
rd.Close();
}
catch
{
}
return(tim_ma);
}
public List <goiMonDB> laymasogoimon(string maban)
{
List <goiMonDB> laymasogoimon = new List <goiMonDB>();
try
{
SqlConnection cn = new SqlConnection(ketnoi.cn);
cn.Open();
string sql = "SELECT ma_goi_mon FROM goi_mon where ma_ban = '" + maban + "' and trangthai = 'True'";
SqlCommand cmd = new SqlCommand(sql, cn);
SqlDataReader rd = cmd.ExecuteReader();
while (rd.Read())
{
goiMonDB gm = new goiMonDB();
gm.ma_goimon = rd.GetString(0);
laymasogoimon.Add(gm);
}
rd.Close();
}
catch
{
}
return(laymasogoimon);
}
//load du lieu
public List <goiMonDB> loadGoiMon()
{
List <goiMonDB> loadGoiMon = new List <goiMonDB>();
try
{
SqlConnection cn = new SqlConnection(ketnoi.cn);
cn.Open();
string sql = "SELECT * FROM goi_mon";
SqlCommand cmd = new SqlCommand(sql, cn);
SqlDataReader rd = cmd.ExecuteReader();
while (rd.Read())
{
goiMonDB gm = new goiMonDB();
gm.ma_goimon = rd.GetString(0);
gm.matang = rd.GetString(1);
gm.maban = rd.GetString(2);
gm.matk = rd.GetString(3);
loadGoiMon.Add(gm);
}
rd.Close();
}
catch
{
}
return(loadGoiMon);
}
