/// <summary>
/// 创建用户按钮权限
/// </summary>
/// <param name="UserButton">权限实体</param>
/// <returns>错误信息，成功为空</returns>
internal string CreateUserFormButtonRight(EapUserButtonRight UserButton)
{
StringBuilder sql = new StringBuilder();
sql.Append("INSERT INTO T_EAP_USER_BUTTON_RIGHT (USER_BUTTON_RIGHT_ID,USER_ID,BUTTON_ID)");
sql.Append(" VALUES(SEQ_EAP_BUTTON.NEXTVAL,:USER_ID,:BUTTON_ID)");
OracleParameter[] para = {
new OracleParameter(":USER_ID", OracleType.VarChar),
new OracleParameter(":BUTTON_ID", OracleType.VarChar)
};
para[0].Value = UserButton.USER_ID;
para[1].Value = UserButton.BUTTON_ID;
return Oracle.GetOracle().ExecSql(sql, para);
}
private void GetUsetButtonRight(TreeNodeCollection treeNodes, ref List <EapUserButtonRight> list_button_right, ref EapMenu button_right_menu)
{
foreach (TreeNode tn in treeNodes)
{
if (tn.Tag is EapMenu)
{
button_right_menu = tn.Tag as EapMenu;
}
if (tn.Tag is EapButton)
{
if (tn.Checked)
{
EapUserButtonRight user_button = new EapUserButtonRight();
user_button.USER_ID = user.USER_ID;
user_button.BUTTON_ID = ((EapButton)tn.Tag).BUTTON_ID;
list_button_right.Add(user_button);
}
}
GetUsetButtonRight(tn.Nodes, ref list_button_right, ref button_right_menu);
}
}
/// <summary>
/// 创建用户按钮权限
/// </summary>
/// <param name="UserButton">权限实体</param>
/// <returns>错误信息，成功为空</returns>
private string CreateUserFormButtonRight(EapUserButtonRight UserButton)
{
return(DalOracle.GetDalOracle().CreateUserFormButtonRight(UserButton));
}