protected void TVWMenu_SelectedNodeChanged(object sender, EventArgs e)
{
string menuid = TVWMenu.SelectedNode.Value;
KPI_MenuEntity sysMenu = KPI_MenuDal.GetEntity(menuid);
if (sysMenu != null)
{
lbl_MenuID.Text = sysMenu.MenuID;
ddl_MenuParentID.Value = sysMenu.MenuParentID;
tbx_MenuCode.Text = sysMenu.MenuCode;
tbx_MenuName.Text = sysMenu.MenuName;
tbx_MenuDesc.Text = sysMenu.MenuDesc;
rbl_MenuIsDisplay.SelectedValue = sysMenu.MenuIsDisplay.ToString();
rbl_MenuType.SelectedValue = sysMenu.MenuType.ToString();
tbx_MenuURL.Text = sysMenu.MenuURL;
tbx_MenuGIF.Text = sysMenu.MenuGIF;
rbl_MenuTarget.SelectedValue = sysMenu.MenuTarget.ToString();
//lbl_MenuGroups.Text = sysMenu.MenuGroups;
rbl_MenuIsValid.SelectedValue = sysMenu.MenuIsValid.ToString();
tbx_MenuNote.Text = sysMenu.MenuNote;
//弹出的框需要用到
//strGroupCollections = sysMenu.MenuGroups;
//SetGroupSelected(dtGroups, strGroupCollections);
}
}
/// <summary>
/// 绑定 Treeview Controls
/// </summary>
void BindGrid()
{
//ddl_PlantIsValid.Value = "1";
this.TVWMenu.Nodes.Clear();
//
lbl_MenuID.Text = "";
//
//string GroupCode = ddl_MenuGroups.Value;
strGroupSigle = ddl_MenuGroups.SelectedValue;
//DataSet dsMenus = KPI_MenuDal.GetMenus("");
//if (dsMenus == null)
{
dsMenus = KPI_MenuDal.GetMenus("");
}
TreeNode pNode = new TreeNode();
AddTree(strGroupSigle, dsMenus, "", null);
//this.TVWMenu.DataSource = pNode;
//this.TVWMenu.Nodes.Add(pNode);
this.TVWMenu.ExpandAll();
}
protected void SetNodeGroupAndIndex(TreeNodeCollection cnodes, string menugroup, ref int menuindex)
{
//确认 static DataSet变量修改并保存。
for (int i = 0; i < cnodes.Count; i++)
{
menuindex = menuindex + 1;
//本节点
KPI_MenuEntity mnEntity = new KPI_MenuEntity();
mnEntity.MenuID = cnodes[i].Value;
if (cnodes[i].Parent != null)
{
mnEntity.MenuParentID = cnodes[i].Parent.Value;
}
mnEntity.MenuIndex = menuindex;
//check
bool check = cnodes[i].Checked;
//group
string groups = dsMenus.Tables[0].Select("MenuID='" + mnEntity.MenuID + "'")[0]["MenuGroups"].ToString();
if (check)
{
if (!groups.Contains(menugroup))
{
groups += menugroup + ",";
}
// Regex re = new Regex(menugroup);
// Match m = re.Match(groups); // 在字符串中匹配
// if (m.Success)
// {
// }
}
else
{
if (groups.Contains(menugroup))
{
groups = groups.Replace(menugroup + ",", "");
}
}
mnEntity.MenuGroups = groups;
//
KPI_MenuDal.Update(mnEntity);
//子节点
SetNodeGroupAndIndex(cnodes[i].ChildNodes, menugroup, ref menuindex);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
btnImport.Attributes.Add("onclick", "setDivPos('Lay1');Lay1.style.visibility=''; progress_update();");
TVWMenu.Attributes.Add("onclick", "postBackByObject()");
btnMenuAdd.Attributes.Add("onclick", "javascript:return confirm('确认添加吗？');");
btnMenuModify.Attributes.Add("onclick", "javascript:return confirm('确认修改吗？');");
btnDel.Attributes.Add("onclick", "javascript:return confirm('确认删除该节点及其所有子节点吗？');");
//
lbl_MenuID.Text = "";
//lbl_MenuGroups.Text = "";
//授权列表
//权限集合
//dtGroups For Menu
DataTable dtGroups = GroupDal.GetGroupsForMenu();
ddl_MenuGroups.Items.Add(new ListItem("sisadmin", "AA"));
foreach (DataRow dr in dtGroups.Rows)
{
ddl_MenuGroups.Items.Add(new ListItem(dr["GroupName"].ToString(), dr["GroupCode"].ToString()));
}
//目录列表
DataTable dt = KPI_MenuDal.GetDirectories();
ddl_MenuParentID.Items.Add(new ListItem("", ""));
foreach (DataRow dr in dt.Rows)
{
ddl_MenuParentID.Items.Add(new ListItem(dr["Name"].ToString(), dr["ID"].ToString()));
}
//Treeview
BindGrid();
}
}
protected void SetNodeIndex(TreeNodeCollection cnodes, ref int menuindex)
{
for (int i = 0; i < cnodes.Count; i++)
{
menuindex = menuindex + 1;
//本节点
KPI_MenuEntity mnEntity = new KPI_MenuEntity();
mnEntity.MenuID = cnodes[i].Value;
if (cnodes[i].Parent != null)
{
mnEntity.MenuParentID = cnodes[i].Parent.Value;
}
mnEntity.MenuIndex = menuindex;
KPI_MenuDal.Update(mnEntity);
//子节点
SetNodeIndex(cnodes[i].ChildNodes, ref menuindex);
}
}
protected void btnDel_Click(object sender, ImageClickEventArgs e)
{
string menuid = lbl_MenuID.Text.Trim();
if (menuid == "")
{
MessageBox.popupClientMessage(this.Page, "请选择节点！", "call();");
return;
}
if (KPI_MenuDal.Delete(menuid))
{
MessageBox.popupClientMessage(this.Page, "删除成功！", "call();");
}
else
{
MessageBox.popupClientMessage(this.Page, "删除错误！", "call();");
}
BindGrid();
}
protected void ImportFromExcelToCreate(DataSet ds)
{
try
{
System.Data.DataTable dt = ds.Tables[0];
int nAll = dt.Rows.Count;
int nCreate = 0;
foreach (System.Data.DataRow dr in dt.Rows)
{
if (dr["SelectX"].ToString().ToLower() == "x")
{
string menuid = Guid.NewGuid().ToString();
string menuparentid = lbl_MenuID.Text.Trim();
//string menucode = tbx_MenuCode.Text.Trim();
string menuname = dr["MenuName"].ToString().Trim();
string menudesc = dr["MenuDesc"].ToString().Trim();
int menuisdisplay = int.Parse(dr["MenuIsDisplay"].ToString().Trim());
int menuindex = int.Parse(dr["MenuIndex"].ToString().Trim());
int menutype = int.Parse(dr["MenuType"].ToString().Trim());
string menuurl = dr["MenuURL"].ToString().Trim();
string menugif = dr["MenuGIF"].ToString().Trim();
int menutarget = int.Parse(dr["MenuTarget"].ToString().Trim());
string menugroups = "AA,";
int menuisvalid = int.Parse(dr["MenuIsValid"].ToString().Trim());
string menunote = dr["MenuNote"].ToString().Trim();
string menucreatetime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss");
string menumodifytime = menucreatetime;
KPI_MenuEntity sysMenu = new KPI_MenuEntity();
sysMenu.MenuID = menuid;
sysMenu.MenuParentID = menuparentid;
//sysMenu.MenuCode = menucode;
sysMenu.MenuName = menuname;
sysMenu.MenuDesc = menudesc;
sysMenu.MenuIsDisplay = menuisdisplay;
sysMenu.MenuIndex = menuindex;
sysMenu.MenuType = menutype;
sysMenu.MenuURL = menuurl;
sysMenu.MenuGIF = menugif;
sysMenu.MenuTarget = menutarget;
sysMenu.MenuGroups = menugroups;
sysMenu.MenuIsValid = menuisvalid;
sysMenu.MenuNote = menunote;
sysMenu.MenuCreateTime = menucreatetime;
sysMenu.MenuModifyTime = menumodifytime;
if (KPI_MenuDal.Insert(sysMenu))
{
nCreate += 1;
}
}
}
string strInfor = "菜单总数：{0}个, 创建成功：{1}个。";
strInfor = string.Format(strInfor, nAll, nCreate);
MessageBox.popupClientMessage(this.Page, strInfor, "call();");
BindGrid();
return;
}
catch (Exception)
{
//
//MessageBox.popupClientMessage(this.Page, ee.Message, "call();");
return;
}
}
protected void btnMenuModify_Click(object sender, EventArgs e)
{
string menuid = lbl_MenuID.Text.Trim();
if (menuid == "")
{
MessageBox.popupClientMessage(this.Page, "请选择节点！", "call();");
return;
}
////////////////////////////////////////////////////////////////////////
//strGroupCollections = GetGroupSelected(dtGroups);
//lbl_MenuGroups.Text = strGroupCollections;
string menuparentid = ddl_MenuParentID.Value;
string menucode = tbx_MenuCode.Text.Trim();
string menuname = tbx_MenuName.Text.Trim();
string menudesc = tbx_MenuDesc.Text.Trim();
int menuisdisplay = int.Parse(rbl_MenuIsDisplay.SelectedValue);
//int menuindex = 0;
int menutype = int.Parse(rbl_MenuType.SelectedValue);
string menuurl = tbx_MenuURL.Text.Trim();
string menugif = tbx_MenuGIF.Text.Trim();
int menutarget = int.Parse(rbl_MenuTarget.SelectedValue);
//string menugroups = lbl_MenuGroups.Text.Trim();
int menuisvalid = int.Parse(rbl_MenuIsValid.SelectedValue);
string menunote = tbx_MenuNote.Text.Trim();
//string menucreatetime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss");
string menumodifytime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss");;
KPI_MenuEntity sysMenu = new KPI_MenuEntity();
sysMenu.MenuID = menuid;
sysMenu.MenuParentID = menuparentid;
sysMenu.MenuCode = menucode;
sysMenu.MenuName = menuname;
sysMenu.MenuDesc = menudesc;
sysMenu.MenuIsDisplay = menuisdisplay;
//sysMenu.MenuIndex = menuindex;
sysMenu.MenuType = menutype;
sysMenu.MenuURL = menuurl;
sysMenu.MenuGIF = menugif;
sysMenu.MenuTarget = menutarget;
//sysMenu.MenuGroups = menugroups;
sysMenu.MenuIsValid = menuisvalid;
sysMenu.MenuNote = menunote;
//sysMenu.MenuCreateTime = menucreatetime;
sysMenu.MenuModifyTime = menumodifytime;
if (KPI_MenuDal.Update(sysMenu))
{
MessageBox.popupClientMessage(this.Page, "修改成功！", "call();");
}
else
{
MessageBox.popupClientMessage(this.Page, "修改错误！", "call();");
}
BindGrid();
}
