frmeditright.cs

客户关系管理系统

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace CRM.UserManage
{
    public partial class frmEditRight : Form
    {
        CRM.BaseClass.BaseOperate boperate = new CRM.BaseClass.BaseOperate();
        CRM.BaseClass.OperateAndValidate opAndvalidate = new CRM.BaseClass.OperateAndValidate();
        public frmEditRight()
        {
            InitializeComponent();
        }

        private void frmEditRight_Load(object sender, EventArgs e)
        {
            opAndvalidate.cboxBind("select UserName from tb_User", "tb_User", "UserName", cboxUName);
        }

        private void btnSure_Click(object sender, EventArgs e)
        {
            boperate.getcom("update tb_User set UserRight='"
                + cboxURight.Text.Trim() + "'where UserName='" + cboxUName.Text.Trim() + "'");
            MessageBox.Show("权限修改成功！", "信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
        }

        private void btnExit_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        private void cboxUName_SelectedIndexChanged(object sender, EventArgs e)
        {
            SqlDataReader sqlread = boperate.getread("select UserName,UserRight from tb_User "
                + "where UserName='" + cboxUName.Text + "'");
            if (sqlread.Read())
            {
                cboxURight.Text = sqlread["UserRight"].ToString().Trim();
            }
            sqlread.Close();
        }
    }
}