using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using DevComponents.DotNetBar;
using System.Data.OracleClient;

namespace Cyberpipe
{
    public delegate void ReloadSysUserRoleGrid(int pageIndex);
    public partial class FrmUserInfoRole : Office2007Form
    {
        private string dbid;
        public event ReloadSysUserRoleGrid reloadGrid;
        public FrmUserInfoRole(string dbid)
        {
            InitializeComponent();
            this.dbid = dbid;
        }

        private void FrmUserInfoRole_Load(object sender, EventArgs e)
        {
            string sql = "select name from ems_role_info";
            using (OracleDataReader reader = OracleUtils.ExecuteReader(OracleUtils.ConnectionString, CommandType.Text, sql))
            {
                while (reader.Read())
                {
                    combo_role.Items.Add(reader[0]);
                }
            }
        }

        private void btnOk_Click(object sender, EventArgs e)
        {
            try
            {
                if (String.IsNullOrEmpty(combo_role.Text.Trim()))
                {
                    MessageBox.Show("角色不能为空！", "警告", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    combo_role.Focus();
                    return;
                }
                string sql = "update ems_user_info set role1='" + combo_role.Text.Trim() + "' where dbid =" + dbid;
                OracleUtils.ExecuteNonQuery(OracleUtils.ConnectionString, CommandType.Text, sql);
                MessageBox.Show("授权成功！", "结果", MessageBoxButtons.OK, MessageBoxIcon.Information);
                reloadGrid(-1);
                this.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show("授权失败:" + ex.ToString(), "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
    }
}