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