staffmanage.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 超市信息管理系统.MarketSystem
{
    public partial class StaffManage : Form
    {
     
        public StaffManage()
        {
            InitializeComponent();
        }

        private void StaffManage_Load(object sender, EventArgs e)
        {
            
            sqlDataAdapter1.Fill(dataSet11);
            sqlConnection1.Close();
        }
        
        /// <summary>
        /// 添加新员工
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>

        private void button4_Click(object sender, EventArgs e)
        {
            if (ID.Text.Trim() == string.Empty)
            {
                MessageBox.Show("请输入员工ID");
                return;
            }
            if (name.Text.Trim() == string.Empty)
            {
                MessageBox.Show("请输入员工姓名");
                return;
            }
            if (identify.Text.Trim() == string.Empty)
            {
                MessageBox.Show("请输入员工身份证");
                return;
            }
            if (jiguan.Text.Trim() == string.Empty)
            {
                MessageBox.Show("请输入员工的籍贯");
                return;
            }
            string insert_sql = "insert into staff values('" + ID.Text.Trim() + "','" + name.Text.Trim() + "','";
            insert_sql += sex.Text.Trim() + "','" + jiguan.Text.Trim() + "','" + xueli.Text.Trim() + "','";
            insert_sql += leibie.Text.Trim() + "'," + Convert.ToDouble(gongzi.Text.Trim()) + ",'" + dianhua.Text.Trim() + "','";
            insert_sql += dizhi.Text.Trim() + "','" + identify.Text.Trim() + "','" + riqi.Value + "','" + text.Text.Trim() + "')";
            DataBaseConnection.insert(insert_sql);

            //向数据集添加一条新记录
            DataRow row = dataSet11.Tables["staffAdd"].NewRow();
            row[0]=ID.Text.Trim ();
            row[1]= name.Text.Trim();
            row[2]= sex.Text.Trim();
            row[3]= jiguan.Text.Trim();
            row[4]= xueli.Text.Trim();
            row[5]= leibie.Text.Trim();
            row[6]= Convert.ToDouble(gongzi.Text.Trim());
            row[7]= dianhua.Text.Trim();
            row[8]= dizhi.Text.Trim();
            row[9]= identify.Text.Trim();
            row[10]= riqi.Value;
            row[11]= text.Text.Trim();
            dataSet11.Tables["staffAdd"].Rows.Add(row);
        }
        
        /// <summary>
        /// 更新员工信息
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void button1_Click(object sender, EventArgs e)
        {
            string update_Sql = "update staff set staffName='" + textBox2.Text.Trim()+"',sex='" + comboBox1.Text.Trim() + "',Home='"+textBox3.Text.Trim()+"',";
            update_Sql += "diploma='" +comboBox2.Text.Trim() + "',kind='" +comboBox4.Text.Trim() + "',salary='" + textBox4.Text.Trim() + "',";
            update_Sql += "Phone='" + textBox5.Text.Trim() + "',address='" + textBox6.Text.Trim() + "',staffText='" + textBox8.Text.Trim() + "' where staffID='" + textBox1.Text.Trim() + "'";
            DataBaseConnection.update(update_Sql);
            updateStaff();

        }
        /// <summary>
        /// 删除员工信息
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void button2_Click(object sender, EventArgs e)
        {
            string delete_Sql = "delete from staff where staffID='" + textBox1.Text.Trim() + "'";
            DataBaseConnection.delete(delete_Sql);
            updateStaff();
        }

        /// <summary>
        /// 更新员工的数据集
        /// </summary>
        private void updateStaff()
        {
            string str = "select * from staff";
            sqlConnection1.Open();
            sqlDataAdapter1.SelectCommand = new SqlCommand(str,sqlConnection1);
            dataSet11.Clear();
            sqlDataAdapter1.Fill(dataSet11);
            sqlConnection1.Close();
        }
    
    }
}