public List <LoaiSanPham_DTO> Retrieve_LoaiSanPham() { List <LoaiSanPham_DTO> dsLSP = new List <LoaiSanPham_DTO>(); string sql = @"select * from LoaiSanPham"; SqlDataReader dr = DataProvider.Retrieve_Table(sql); while (dr.Read()) { LoaiSanPham_DTO lsp = new LoaiSanPham_DTO(); if (!dr.IsDBNull(0)) { lsp.MaLoaiSP = (string)dr["MaLoaiSP"]; } if (!dr.IsDBNull(1)) { lsp.TenLoaiSP = (string)dr["TenLoaiSP"]; } if (!dr.IsDBNull(2)) { lsp.TrangThai = (Boolean)dr["TrangThai"]; } dsLSP.Add(lsp); } return(dsLSP); }
public List <LoaiSanPham_DTO> LoadToanBoLoaiSanPham() { List <LoaiSanPham_DTO> lstLoaiSP = new List <LoaiSanPham_DTO>(); DataTable data = DataProvider.Instance.ExecuteQuery("LoadToanBoLoaiSanPham"); foreach (DataRow item in data.Rows) { LoaiSanPham_DTO loaiSP = new LoaiSanPham_DTO(item); lstLoaiSP.Add(loaiSP); } return(lstLoaiSP); }
public List <LoaiSanPham_DTO> TimKiemLSP(string str) { List <LoaiSanPham_DTO> DanhSachLSP = new List <LoaiSanPham_DTO>(); string query = "select * from LoaiSanPham where TenLoai like N'%" + str + "'"; DataTable data = DataProvider.Instance.ExecuteQuery(query); foreach (DataRow item in data.Rows) { LoaiSanPham_DTO LSP = new LoaiSanPham_DTO(item); DanhSachLSP.Add(LSP); } return(DanhSachLSP); }
public List <LoaiSanPham_DTO> LayTatCaLoaiSanPham() { List <LoaiSanPham_DTO> DanhSachLSP = new List <LoaiSanPham_DTO>(); string query = "select * from LoaiSanPham"; DataTable data = DataProvider.Instance.ExecuteQuery(query); foreach (DataRow item in data.Rows) { LoaiSanPham_DTO LSP = new LoaiSanPham_DTO(item); DanhSachLSP.Add(LSP); } return(DanhSachLSP); }