using System;
using System.Data;
using System.Windows.Forms;
using DevComponents.DotNetBar;

namespace Cyberpipe
{
    public partial class FrmRoleInfoManager : Office2007Form
    {
        public static bool IS_OPEN;
        public FrmRoleInfoManager()
        {
            InitializeComponent();
        }

        private void FrmRoleInfoManager_Load(object sender, EventArgs e)
        {
            reloadGrid();
            if (Utility.userRole.IndexOf("角色新增") == -1)
            {
                btn_add.Visible = false;
            }
            if (Utility.userRole.IndexOf("角色删除") == -1)
            {
                dataGridViewX1.Columns["btndel"].Visible = false;
            }
            IS_OPEN = true;
        }

        private void reloadGrid()
        {
            string sql = "select id,nt from casic_userroletest where sysname='GHFX'";
            DataTable dt = OracleUtils.ExecuteDataset(OracleUtils.ConnectionString, CommandType.Text, sql).Tables[0];
            dataGridViewX1.DataSource = dt;
        }

        private void btn_add_Click(object sender, EventArgs e)
        {
            try
            {
                if (String.IsNullOrEmpty(txt_role_name.Text.Trim()))
                {
                    MessageBox.Show("角色名称不能为空！","警告",MessageBoxButtons.OK,MessageBoxIcon.Warning);
                    return;
                }
                string sql = "select count(*) from casic_userroletest where nt='" + txt_role_name.Text.Trim() + "' and sysname='GHFX'";
                int count = int.Parse(OracleUtils.ExecuteScalar(OracleUtils.ConnectionString, CommandType.Text, sql).ToString());
                if (count > 0)
                {
                    MessageBox.Show("角色名称已存在！", "警告", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    return;
                }
                sql = "insert into casic_userroletest (nt,sysname) values ('" + txt_role_name.Text.Trim() + "','GHFX')";
                OracleUtils.ExecuteNonQuery(OracleUtils.ConnectionString,CommandType.Text,sql);
                MessageBox.Show("新增成功!", "结果", MessageBoxButtons.OK, MessageBoxIcon.Information);
                reloadGrid();
            }
            catch (Exception ex)
            {
                MessageBox.Show("新增失败:" + ex, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }

        private void dataGridViewX1_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {
            if (e.RowIndex < 0 || e.ColumnIndex < 0)
            {
                return;
            }

            string cell = dataGridViewX1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString();
            if (cell.Equals("删除"))
            {
                try
                {
                    string dbid = dataGridViewX1.Rows[e.RowIndex].Cells["id"].Value.ToString();
                    if (MessageBox.Show("确定删除？", "确认", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
                    {
                        string sql = "delete from casic_userroletest where id=" + dbid;
                        OracleUtils.ExecuteNonQuery(OracleUtils.ConnectionString, CommandType.Text, sql);
                        reloadGrid();
                        MessageBox.Show("删除成功！", "结果", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    }
                }
                catch (Exception ex)
                {
                    MessageBox.Show("删除失败:" + ex, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
            }
        }

        private void FrmRoleInfoManager_FormClosing(object sender, FormClosingEventArgs e)
        {
            IS_OPEN = false;
        }



    }
}