frmusercheckchange.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;
namespace PMS
{
    public partial class frmUserCheckChange : Form
    {
        public frmUserCheckChange()
        {
            InitializeComponent();
        }
        DBOperate operate = new DBOperate();
        public string pid;
        public string pname;
        private void 退出ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        private void 修改ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            if (txtcontent.Text == "" || txtresult.Text == "" || txtscore.Text == "" || txtkp.Text == "")
            {
                MessageBox.Show("请将信息填写完整", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                return;
            }
            else
            {
                string sql = "update tb_check set PKpcontent='"+txtcontent.Text+"',PKpResult='"+txtresult.Text+"',PKpscore='"+txtscore.Text+"',PKpPeople='"+txtkp.Text+"',PKpDate='"+txtkpdate.Text+"' where PID='"+cbbnum.Text+"'";
                if (operate.OperateData(sql) > 0)
                {
                    MessageBox.Show("修改成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
            }
        }

        private void frmUserCheckChange_Load(object sender, EventArgs e)
        {
            this.Text = "考评管理[" + pname + "]";
            operate.BindDropdownlist("tb_employee", cbbnum, 1);
            string sql = "select * from tb_check where PID='" + pid+ "'";
            DataSet ds = operate.GetTable(sql);
            ds.Dispose();
            cbbnum.SelectedItem=ds.Tables[0].Rows[0][1].ToString();
            txtname.Text = ds.Tables[0].Rows[0][2].ToString();
            txtdep.Text = ds.Tables[0].Rows[0][3].ToString();
            txtcontent.Text = ds.Tables[0].Rows[0][4].ToString();
            txtresult.Text = ds.Tables[0].Rows[0][5].ToString();
            txtscore.Text = ds.Tables[0].Rows[0][6].ToString();
            txtkp.Text = ds.Tables[0].Rows[0][7].ToString();
            txtkpdate.Text = ds.Tables[0].Rows[0][8].ToString();

        }

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

        private void txtscore_TextChanged(object sender, EventArgs e)
        {
            if (txtscore.Text == "")
            {
                MessageBox.Show("分数不能为空", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                return;
            }
            else
            {
                if (Convert.ToInt32(txtscore.Text) > 100)
                {
                    MessageBox.Show("满分为100分", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    return;
                }
            }
        }
    }
}