public List <NguonMinhChung_MinhChungDTO> SearchListNguonMinhChung_MinhChung(string valueToSearch) { List <NguonMinhChung_MinhChungDTO> List = new List <NguonMinhChung_MinhChungDTO>(); string query = string.Format("SELECT NMChungMChung.ID_NguonMinhChung, NMChungMChung.ID_TaiLieu, NMChung.MaNguonMinhChung, NMChung.TenNguonMinhChung, MChung.MaTaiLieu, MChung.TenTaiLieu, NMChungMChung.GhiChu " + "FROM dbo.NguonMinhChung_MinhChung NMChungMChung, dbo.NguonMinhChung NMChung, dbo.MinhChung MChung " + "WHERE NMChungMChung.ID_NguonMinhChung = NMChung.ID_NguonMinhChung AND NMChungMChung.ID_TaiLieu = MChung.ID_TaiLieu AND CONCAT(NMChung.MaNguonMinhChung, NMChung.TenNguonMinhChung, MChung.MaTaiLieu, MChung.TenTaiLieu, NMChungMChung.GhiChu) LIKE N'%" + valueToSearch + "%'"); DataTable dataTable = DataBaseConnection.Instance.ExecuteQuery(query); foreach (DataRow dataRow in dataTable.Rows) { NguonMinhChung_MinhChungDTO nguonMinhChung_MinhChung = new NguonMinhChung_MinhChungDTO(dataRow); List.Add(nguonMinhChung_MinhChung); } return(List); }
public List <NguonMinhChung_MinhChungDTO> GetListNguonMinhChung_MinhChung() { List <NguonMinhChung_MinhChungDTO> List = new List <NguonMinhChung_MinhChungDTO>(); string query = "SELECT NMChungMChung.ID_NguonMinhChung, NMChungMChung.ID_TaiLieu, NMChung.TenNguonMinhChung, NMChung.NoiDungNguonMinhChung, MChung.MaTaiLieu, MChung.TenTaiLieu, NMChungMChung.GhiChu " + "FROM dbo.NguonMinhChung_MinhChung NMChungMChung, dbo.NguonMinhChung NMChung, dbo.MinhChung MChung " + "WHERE NMChungMChung.ID_NguonMinhChung = NMChung.ID_NguonMinhChung AND NMChungMChung.ID_TaiLieu = MChung.ID_TaiLieu"; DataTable dataTable = DataBaseConnection.Instance.ExecuteQuery(query); foreach (DataRow dataRow in dataTable.Rows) { NguonMinhChung_MinhChungDTO nguonMinhChung_MinhChung = new NguonMinhChung_MinhChungDTO(dataRow); List.Add(nguonMinhChung_MinhChung); } return(List); }