public List <HangBEAN> getListHang()
{
string sql = "SELECT * FROM Hang";
SqlCommand cmd = new SqlCommand(sql, DungChung.cn);
SqlDataReader rs = cmd.ExecuteReader();
List <HangBEAN> ds = new List <HangBEAN>();
while (rs.Read())
{
string maHang = rs["MaHang"].ToString();
string tenHang = rs["TenHang"].ToString();
HangBEAN ban = new HangBEAN(maHang, tenHang);
ds.Add(ban);
}
rs.Close();
return(ds);
}
public List <HangBEAN> themHang(List <HangBEAN> ds, string maHang, string tenHang, long gia, long soLuong, string donViTinh, out Boolean kq)
{
kq = false;
// lấy về tất cả các loại có mã là maLoai
var q = from l in ds
where l.MaHang.Equals(maHang)
select l;
if (q.Count() == 0)
{
// thêm csdl
hang.themHang(maHang, tenHang, gia, soLuong, donViTinh);
// thêm bộ nhớ
HangBEAN h = new HangBEAN(maHang, tenHang, gia, soLuong, donViTinh);
ds.Add(h);
kq = true;
}
return(ds);
}
public List<HangBEAN> getListHang()
{
string sql = "SELECT * FROM Hang";
SqlCommand cmd = new SqlCommand(sql, DungChung.cn);
SqlDataReader rs = cmd.ExecuteReader();
List<HangBEAN> ds = new List<HangBEAN>();
while (rs.Read())
{
string maHang = rs["MaHang"].ToString();
string tenHang = rs["TenHang"].ToString();
string gia = rs["Gia"].ToString();
string soLuong = rs["SoLuong"].ToString();
string donViTinh = rs["DonViTinh"].ToString();
HangBEAN hang = new HangBEAN(maHang, tenHang, long.Parse(gia),long.Parse(soLuong),donViTinh);
ds.Add(hang);
}
rs.Close();
return ds;
}
public List<HangBEAN> timHang(string key)
{
string sql = "SELECT * FROM Hang WHERE TenHang LIKE @tenHang ";
SqlCommand cmd = new SqlCommand(sql, DungChung.cn);
SqlParameter ts = new SqlParameter("@tenHang", "%" + key + "%");
cmd.Parameters.Add(ts);
SqlDataReader rs = cmd.ExecuteReader();
List<HangBEAN> ds = new List<HangBEAN>();
while (rs.Read())
{
string maHang = rs["MaHang"].ToString();
string tenHang = rs["TenHang"].ToString();
string gia = rs["Gia"].ToString();
string soLuong = rs["SoLuong"].ToString();
string donViTinh = rs["DonViTinh"].ToString();
HangBEAN hang = new HangBEAN(maHang, tenHang, long.Parse(gia), long.Parse(soLuong), donViTinh);
ds.Add(hang);
}
rs.Close();
return ds;
}
