public List <YeuCau_MocThamChieuDTO> SearchListYeuCau_MocThamChieu(string valueToSearch)
{
List <YeuCau_MocThamChieuDTO> List = new List <YeuCau_MocThamChieuDTO>();
string query = string.Format("SELECT YCauMTChieu.ID_YeuCau, YCauMTChieu.ID_MocThamChieu, YCau.MaYeuCau, YCau.TenYeuCau, MTChieu.MaMocThamChieu, MTChieu.TenMocThamChieu, YCauMTChieu.GhiChu " +
"FROM dbo.YeuCau_MocThamChieu YCauMTChieu, dbo.YeuCau YCau, dbo.MocThamChieu MTChieu " +
"WHERE YCauMTChieu.ID_YeuCau = YCau.ID_YeuCau AND YCauMTChieu.ID_MocThamChieu = MTChieu.ID_MocThamChieu AND CONCAT(YCau.MaYeuCau, YCau.TenYeuCau, MTChieu.MaMocThamChieu, MTChieu.TenMocThamChieu, YCauMTChieu.GhiChu) LIKE '%" + valueToSearch + "%'");
DataTable dataTable = DataBaseConnection.Instance.ExecuteQuery(query);
foreach (DataRow dataRow in dataTable.Rows)
{
YeuCau_MocThamChieuDTO yeuCau_MocThamChieu = new YeuCau_MocThamChieuDTO(dataRow);
List.Add(yeuCau_MocThamChieu);
}
return(List);
}
public List <YeuCau_MocThamChieuDTO> GetListYeuCau_MocThamChieu()
{
List <YeuCau_MocThamChieuDTO> List = new List <YeuCau_MocThamChieuDTO>();
string query = "SELECT YCauMTChieu.ID_YeuCau, YCauMTChieu.ID_MocThamChieu, YCau.TenYeuCau, YCau.NoiDungYeuCau, MTChieu.TenMocThamChieu, MTChieu.NoiDungMocThamChieu, YCauMTChieu.GhiChu " +
"FROM dbo.YeuCau_MocThamChieu YCauMTChieu, dbo.YeuCau YCau, dbo.MocThamChieu MTChieu " +
"WHERE YCauMTChieu.ID_YeuCau = YCau.ID_YeuCau AND YCauMTChieu.ID_MocThamChieu = MTChieu.ID_MocThamChieu";
DataTable dataTable = DataBaseConnection.Instance.ExecuteQuery(query);
foreach (DataRow dataRow in dataTable.Rows)
{
YeuCau_MocThamChieuDTO yeuCau_MocThamChieu = new YeuCau_MocThamChieuDTO(dataRow);
List.Add(yeuCau_MocThamChieu);
}
return(List);
}
