public List <TieuChi_NguonMinhChungDTO> SearchListTieuChi_NguonMinhChung(string valueToSearch) { List <TieuChi_NguonMinhChungDTO> List = new List <TieuChi_NguonMinhChungDTO>(); string query = string.Format("SELECT TChiNMChung.ID_TieuChi, TChiNMChung.ID_NguonMinhChung, TChi.MaTieuChi, TChi.TenTieuChi, NMChung.MaNguonMinhChung, NMChung.TenNguonMinhChung, TChiNMChung.GhiChu " + "FROM dbo.TieuChi_NguonMinhChung TChiNMChung, dbo.TieuChi TChi, dbo.NguonMinhChung NMChung " + "WHERE TChiNMChung.ID_TieuChi = TChi.ID_TieuChi AND TChiNMChung.ID_NguonMinhChung = NMChung.ID_NguonMinhChung AND CONCAT(TChi.MaTieuChi, TChi.TenTieuChi, NMChung.MaNguonMinhChung, NMChung.TenNguonMinhChung, TChiNMChung.GhiChu) LIKE N'%" + valueToSearch + "%'"); DataTable dataTable = DataBaseConnection.Instance.ExecuteQuery(query); foreach (DataRow dataRow in dataTable.Rows) { TieuChi_NguonMinhChungDTO tieuChi_NguonMinhChung = new TieuChi_NguonMinhChungDTO(dataRow); List.Add(tieuChi_NguonMinhChung); } return(List); }
public List <TieuChi_NguonMinhChungDTO> GetListTieuChi_NguonMinhChung() { List <TieuChi_NguonMinhChungDTO> List = new List <TieuChi_NguonMinhChungDTO>(); string query = "SELECT TChiNMChung.ID_TieuChi, TChiNMChung.ID_NguonMinhChung, TChi.TenTieuChi, TChi.NoiDungTieuChi, NMChung.TenNguonMinhChung, NMChung.NoiDungNguonMinhChung, TChiNMChung.GhiChu " + "FROM dbo.TieuChi_NguonMinhChung TChiNMChung, dbo.TieuChi TChi, dbo.NguonMinhChung NMChung " + "WHERE TChiNMChung.ID_TieuChi = TChi.ID_TieuChi AND TChiNMChung.ID_NguonMinhChung = NMChung.ID_NguonMinhChung"; DataTable dataTable = DataBaseConnection.Instance.ExecuteQuery(query); foreach (DataRow dataRow in dataTable.Rows) { TieuChi_NguonMinhChungDTO tieuChi_NguonMinhChung = new TieuChi_NguonMinhChungDTO(dataRow); List.Add(tieuChi_NguonMinhChung); } return(List); }