public static DMTreeGroup InitTreeChonDienDan(PLDMTreeGroup tree, bool? IsAdd)
{
if (IsAdd == true)
{
tree.InitReadOnly("NAME", "V_DIEN_DAN_CHUYEN_MUC", null, "ID", "PARENT_ID",
new string[] { "NAME" },
new string[] { "Diễn đàn" });
}
else
{
tree.InitReadOnly("NAME", "V_DIEN_DAN_CHUYEN_MUC", null, "ID", "PARENT_ID",
new string[] { "NAME" },
new string[] { "Diễn đàn" });
}
string sql="";
if (DienDanPermission.I.IsPermission==false)
{
sql= @"SELECT DD.ID,DD.NAME,DD.ID_CHA PARENT_ID,DD.ID_ROOT,DD.VISIBLE_BIT,'Y' IS_GROUP
FROM NHOM_DIEN_DAN DD WHERE DD.VISIBLE_BIT = 'Y'
UNION SELECT CM.ID,CM.NAME,CM.ID_NHOM_DIEN_DAN PARENT_ID,
(SELECT N.ID_ROOT FROM NHOM_DIEN_DAN N WHERE N.ID = CM.ID_NHOM_DIEN_DAN),
CM.VISIBLE_BIT,'N' IS_GROUP
FROM CHUYEN_MUC CM WHERE CM.VISIBLE_BIT = 'Y'";
}
else
{
string nddids = DienDanPermission.I._getPermissionResGroupStrIDs(PermissionOfResource.RES_PERMISSION_TYPE.READ);
string cmids = DienDanPermission.I._getPermissionResStrIDs(PermissionOfResource.RES_PERMISSION_TYPE.READ);
if (nddids == "") nddids = "-1";
if (cmids == "") cmids = "-1";
sql = @"SELECT DD.ID,DD.NAME,DD.ID_CHA PARENT_ID,DD.ID_ROOT,DD.VISIBLE_BIT,'Y' IS_GROUP
FROM NHOM_DIEN_DAN DD WHERE DD.VISIBLE_BIT = 'Y' and (dd.id=dd.ID_ROOT or dd.id in (" + nddids+ @")
or dd.id in (select cmuc.ID_NHOM_DIEN_DAN from CHUYEN_MUC cmuc where cmuc.id in (" + cmids + @")))
UNION SELECT CM.ID,CM.NAME,CM.ID_NHOM_DIEN_DAN PARENT_ID,
(SELECT N.ID_ROOT FROM NHOM_DIEN_DAN N WHERE N.ID = CM.ID_NHOM_DIEN_DAN),
CM.VISIBLE_BIT,'N' IS_GROUP
FROM CHUYEN_MUC CM WHERE CM.VISIBLE_BIT = 'Y' and cm.id in (" + cmids +")";
}
PopupContainerControl popup = tree.Controls["popupContainerControl1"] as PopupContainerControl;
if (popup == null) return null;
DMTreeGroup tr = popup.Controls["plGroupCatNew1"] as DMTreeGroup;
if (tr == null) return null;
foreach (TreeListColumn col in tr.TreeList_1.Columns)
{
col.OptionsColumn.AllowFocus = false;
}
tr.TreeList_1.DataSource= HelpDB.getDatabase().LoadDataSet(sql,"DIEN_DAN").Tables[0];
DataTable dt = tr.TreeList_1.DataSource as DataTable;
dt.DefaultView.Sort = "IS_GROUP DESC ,NAME ASC";
return tr;
}
public static void InitTreeChonNhanVien_Choice1(PLDMTreeGroup tree, bool? IsAdd)
{
if (IsAdd == true)
{
tree.InitReadOnly("NAME", "V_PHONG_BAN_NHAN_VIEN_VISBLE", null, "ID", "PARENT_ID",
new string[] { "NAME" },
new string[] { "Nhân viên" });
}
else
{
tree.InitReadOnly("NAME", "V_PHONG_BAN_NHAN_VIEN", null, "ID", "PARENT_ID",
new string[] { "NAME" },
new string[] { "Nhân viên" });
}
PopupContainerControl popup = tree.Controls["popupContainerControl1"] as PopupContainerControl;
if (popup == null) return;
DMTreeGroup tr = popup.Controls["plGroupCatNew1"] as DMTreeGroup;
if (tr == null) return;
foreach (TreeListColumn col in tr.TreeList_1.Columns)
{
col.OptionsColumn.AllowFocus = false;
}
int IndexGroupImage = -1;
int IndexImage = -1;
int IndexRootImage = -1;
tr.TreeList_1.SelectImageList = null;
DataTable dt = tr.TreeList_1.DataSource as DataTable;
ImageCollection imList = new ImageCollection();
imList.ImageSize = new Size(20, 20);
dt.DefaultView.Sort = "IS_GROUP DESC ,NAME ASC";
Image rimg = ResourceMan.getImage("navNoiBaoHanh.png");
Image gimg = ResourceMan.getImage("mnbKhachHangNhom.png");
Image img = ResourceMan.getImage("mnbTTinKhachHang.png");
if (gimg != null || img != null || rimg != null)
{
IndexRootImage = imList.Images.Add(rimg, "navNoiBaoHanh.png");
IndexGroupImage = imList.Images.Add(gimg, "mnbKhachHangNhom.png");
IndexImage = imList.Images.Add(img, "mnbTTinKhachHang.png");
tr.TreeList_1.StateImageList = imList;
}
else tr.TreeList_1.StateImageList = null;
tr.TreeList_1.OptionsView.ShowIndicator = false;
tr.TreeList_1.GetStateImage += delegate(object sender, DevExpress.XtraTreeList.GetStateImageEventArgs e)
{
if (e.Node.Level == 0)
{
e.Node.StateImageIndex = IndexRootImage;
}
else
{
if (e.Node["IS_GROUP"].ToString() == "Y")
{
e.Node.StateImageIndex = IndexGroupImage;
}
else e.Node.StateImageIndex = IndexImage;
}
};
tr.TreeList_1.FocusedNodeChanged += delegate(object sender, DevExpress.XtraTreeList.FocusedNodeChangedEventArgs e)
{
if (e.Node["IS_GROUP"].ToString() == "Y")
{
tr.btnAdd.Owner.Items["btnSelect"].Enabled = false;
}
else
{
tr.btnAdd.Owner.Items["btnSelect"].Enabled = true;
}
};
long selected = -1;
tree.popupContainerEdit1.Popup += delegate(object sender, EventArgs e)
{
selected = tree._getSelectedID();
};
tree.popupContainerEdit1.QueryCloseUp += delegate(object sender, System.ComponentModel.CancelEventArgs e)
{
if (tr.SelectedNode != null)
{
if (tr.SelectedNode["IS_GROUP"].ToString() == "Y")
{
e.Cancel = true;
DevExpress.XtraTreeList.Nodes.TreeListNode n = tr.TreeList_1.FindNodeByFieldValue("ID", selected);
//if (n != null)
tr.SelectedNode = n;
tree._setSelectedID(selected);
}
}
};
}
