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