private void GetUsetMenuRight(TreeNodeCollection treeNodes)
{
foreach (TreeNode tn in treeNodes)
{
if (tn.Checked)
{
EapUserMenuRight UserMenu = new EapUserMenuRight();
UserMenu.USER_ID = user.USER_ID;
UserMenu.MENU_ID = ((EapMenu)tn.Tag).MENU_ID;
list_menu_right.Add(UserMenu);
}
GetUsetMenuRight(tn.Nodes);
}
}
/// <summary>
/// 创建用户权限
/// </summary>
/// <param name="user"></param>
/// <returns></returns>
private string CreateUserMenu(EapUserMenuRight UserMenu)
{
StringBuilder sql = new StringBuilder();
sql.Append(" insert into T_EAP_USER_MENU_RIGHT (USER_MENU_RIGHT_ID, USER_ID, MENU_ID)");
sql.Append(" values (SEQ_EAP_USER_MENU_RIGHT.Nextval, :USER_ID,:MENU_ID)");
OracleParameter[] para = {
new OracleParameter(":USER_ID", OracleType.VarChar),
new OracleParameter(":MENU_ID", OracleType.VarChar)
};
para[0].Value = UserMenu.USER_ID;
para[1].Value = UserMenu.MENU_ID;
return Oracle.GetOracle().ExecSql(sql, para);
}
