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