private void load()
{
DataSetFILM.TbQuanLyLichChieuDataTable dsQLLC = new DataSetFILM.TbQuanLyLichChieuDataTable();
DataAccess.dt = dsQLLC;
ReSource = "SELECT * FROM TbQuanLyLichChieu ORDER BY MaLichChieu ASC";
DataAccess_source();
}
private void treeView_SM_AfterSelect(object sender, TreeViewEventArgs e)
{
if (treeView_SM.Nodes["Root"] == treeView_SM.SelectedNode)
{
load();
}
DataSetFILM.TbQuanLyLichChieuDataTable dsQLLC = new DataSetFILM.TbQuanLyLichChieuDataTable();
DataAccess.dt = dsQLLC;
if (treeView_SM.Nodes["NodeDate"] == treeView_SM.SelectedNode.Parent)
{
DateTime temp = Convert.ToDateTime(treeView_SM.SelectedNode.Tag);
ReSource = string.Format("SELECT * FROM TbQuanLyLichChieu WHERE NgayChieu = '{0}'", temp.ToString("yyyy-MM-dd"));
DataAccess_source();
}
if (treeView_SM.Nodes["NodeMovie"] == treeView_SM.SelectedNode.Parent)
{
ReSource = string.Format("SELECT a.* FROM TbQuanLyLichChieu AS a JOIN TbPhim AS b ON a.MaPhim = b.MaPhim WHERE b.TenPhim = N'{0}'", treeView_SM.SelectedNode.Text);
DataAccess_source();
}
}
