frmchangeuserredeploy.cs

随着我国市场经济的快速发展

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using PMS.PMSClass;
using System.Text.RegularExpressions;
namespace PMS
{
    public partial class frmChangeUserRedeploy : Form
    {
        public frmChangeUserRedeploy()
        {
            InitializeComponent();
        }
        DBOperate operate = new DBOperate();
        public string id;
        public string name;
        private void 退出ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        private void frmChangeUserRedeploy_Load(object sender, EventArgs e)
        {
            this.Text = "人员调动详细信息["+name+"]";
            operate.BindDropdownlist("tb_employee",cbbnum,1);
            operate.BindDropdownlist("tb_department", cbbdep2, 1);
            operate.BindDropdownlist("tb_userJob", cbbjob2, 1);
            string sql = "select * from tb_redeploy where UID='"+id+"'";
            DataSet ds = operate.GetTable(sql);
            ds.Dispose();
            cbbnum.Text = ds.Tables[0].Rows[0][1].ToString();
            txtname.Text = ds.Tables[0].Rows[0][2].ToString();
            txtdep1.Text = ds.Tables[0].Rows[0][4].ToString();
            cbbdep2.SelectedItem = ds.Tables[0].Rows[0][5].ToString();
            txtjob1.Text = ds.Tables[0].Rows[0][6].ToString();
            cbbjob2.SelectedItem=ds.Tables[0].Rows[0][7].ToString();
            txtpay1.Text = ds.Tables[0].Rows[0][8].ToString();
            txtNewPay.Text = ds.Tables[0].Rows[0][9].ToString();
            txtdate.Text = ds.Tables[0].Rows[0][3].ToString();
            txtexplain.Text = ds.Tables[0].Rows[0][10].ToString();
        }

        private void 增加ToolStripMenuItem_Click(object sender, EventArgs e)
        {
             if (cbbdep2.Text == "" || cbbjob2.Text == "" || txtNewPay.Text == "" || txtdate.Text == "" || txtexplain.Text == "")
             {
                 MessageBox.Show("请将信息填写完整！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
             }
             else
             {
                 string updatestr = "update tb_redeploy set UNewDep='"+cbbdep2.Text+"',UNewJob='"+cbbjob2.Text+"',UNewPay='"+txtNewPay.Text.Trim()+"',URemoveDate='"+txtdate.Text+"',UPayExplain='"+txtexplain.Text+"' where UID='"+cbbnum.Text+"'";
                 if (operate.OperateData(updatestr) > 0)
                 {
                     MessageBox.Show("修改成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                 }
             }
        }

        private void txtNewPay_KeyPress(object sender, KeyPressEventArgs e)
        {
            if (e.KeyChar != 8 && !char.IsDigit(e.KeyChar))
            {
                MessageBox.Show("只能输入数字", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                e.Handled = true;
            }
        }
    }
}