public List <DGia> LoadDGMa(string ma) { List <DGia> Listdgia = new List <DTO.DGia>(); DataTable data = DataProvider.Instance.ExecuteQuery("select * from DGia as d where d.MaDGia='" + ma + "'"); foreach (DataRow item in data.Rows) { DGia dgia = new DGia(item); Listdgia.Add(dgia); } return(Listdgia); }
public List <DGia> Search(string ma) { List <DGia> Listdgia = new List <DTO.DGia>(); DataTable data = DataProvider.Instance.ExecuteQuery("select * from DGia as d where [dbo].[fuConvertToUnsign1] (d.TenDGia) like N'%'+[dbo].[fuConvertToUnsign1] (N'" + ma + "%')"); foreach (DataRow item in data.Rows) { DGia dgia = new DGia(item); Listdgia.Add(dgia); } return(Listdgia); }
public List <DGia> LoadDG() { List <DGia> Listdgia = new List <DTO.DGia>(); DataTable data = DataProvider.Instance.ExecuteQuery("select * from DGia"); foreach (DataRow item in data.Rows) { DGia dgia = new DGia(item); Listdgia.Add(dgia); } return(Listdgia); }