frmusermanage.cs

企业客户资源管理系统 企业客户资源管理系统

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

namespace CRM.UserManage
{
    public partial class frmUserManage : Form
    {
        CRM.BaseClass.BaseOperate boperate = new CRM.BaseClass.BaseOperate();
        CRM.BaseClass.OperateAndValidate opAndvalidate = new CRM.BaseClass.OperateAndValidate();
        protected string M_str_sql = "select UserID as 用户编号,UserName as 用户名称,UserPwd as 用户密码,"
            + "UserRight as 用户权限 from tb_User";
        protected string M_str_table = "tb_User";
        protected int M_int_judge;
        public frmUserManage()
        {
            InitializeComponent();
        }

        private void frmUserManage_Load(object sender, EventArgs e)
        {
            DataSet myds = boperate.getds(M_str_sql, M_str_table);
            dgvUInfo.DataSource = myds.Tables[0];
            if (myds.Tables[0].Rows.Count > 0)
                tsbtnDel.Enabled = true;
            else
                tsbtnDel.Enabled = false;
        }

        private void tsbtnAdd_Click(object sender, EventArgs e)
        {
            opAndvalidate.autoNum("select UserID from tb_User", "tb_User", "UserID", "YH", "1000001", txtUserID);
            tsbtnSave.Enabled = true;
            M_int_judge = 0;
            txtUserName.Text = "";
            txtUserPwd.Text = "";
        }

        private void tsbtnEdit_Click(object sender, EventArgs e)
        {
            tsbtnSave.Enabled = true;
            M_int_judge = 1;
        }

        private void tsbtnSave_Click(object sender, EventArgs e)
        {
            if (M_int_judge == 0)
            {
                if (txtUserName.Text == "")
                {
                    MessageBox.Show("用户名称不能为空！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
                else
                {
                    boperate.getcom("insert into tb_User(UserID,UserName,UserPwd,UserRight) "
                        + "values('" + txtUserID.Text.Trim() + "','" + txtUserName.Text.Trim()
                        + "','" + txtUserPwd.Text.Trim() + "','" + cboxURight.Text.Trim() + "')");
                    frmUserManage_Load(sender, e);
                    MessageBox.Show("用户信息添加成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    tsbtnSave.Enabled = false;
                }
            }
            if (M_int_judge == 1)
            {
                if (txtUserName.Text == "")
                {
                    MessageBox.Show("用户名称不能为空！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
                else
                {
                    boperate.getcom("update tb_User set UserName='" + txtUserName.Text.Trim()
                        + "',UserPwd='" + txtUserPwd.Text.Trim() + "',UserRight='" + cboxURight.Text.Trim() 
                        + "' where UserID='" + txtUserID.Text.Trim() + "'");
                    frmUserManage_Load(sender, e);
                    MessageBox.Show("用户信息修改成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    tsbtnSave.Enabled = false;
                }
            }
        }

        private void tsbtnDel_Click(object sender, EventArgs e)
        {
            try
            {
                if (MessageBox.Show("确定要删除该用户吗？", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
                {
                    boperate.getcom("delete from tb_User where UserID='" + Convert.ToString(dgvUInfo[0, dgvUInfo.CurrentCell.RowIndex].Value).Trim() + "'");
                    frmUserManage_Load(sender, e);
                    MessageBox.Show("删除数据成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Information);
            }
        }

        private void tsbtnLook_Click(object sender, EventArgs e)
        {
            try
            {
                if (tstxtKeyWord.Text == "")
                {
                    frmUserManage_Load(sender, e);
                }
                if (tscboxCondition.Text.Trim() == "用户编号")
                {
                    DataSet myds = boperate.getds(M_str_sql + " where UserID like '%" + tstxtKeyWord.Text.Trim() + "%'", M_str_table);
                    if (myds.Tables[0].Rows.Count > 0)
                        dgvUInfo.DataSource = myds.Tables[0];
                    else
                        MessageBox.Show("没有要查找的相关记录！");
                }
                if (tscboxCondition.Text.Trim() == "用户名称")
                {
                    DataSet myds = boperate.getds(M_str_sql + " where UserName like '%" + tstxtKeyWord.Text.Trim() + "%'", M_str_table);
                    if (myds.Tables[0].Rows.Count > 0)
                        dgvUInfo.DataSource = myds.Tables[0];
                    else
                        MessageBox.Show("没有要查找的相关记录！");
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
        }

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

        private void dgvUInfo_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            txtUserID.Text = Convert.ToString(dgvUInfo[0, dgvUInfo.CurrentCell.RowIndex].Value).Trim();
            txtUserName.Text = Convert.ToString(dgvUInfo[1, dgvUInfo.CurrentCell.RowIndex].Value).Trim();
            txtUserPwd.Text = Convert.ToString(dgvUInfo[2, dgvUInfo.CurrentCell.RowIndex].Value).Trim();
            cboxURight.Text = Convert.ToString(dgvUInfo[3, dgvUInfo.CurrentCell.RowIndex].Value).Trim();
        }
    }
}