基本信息

---

下载

   友情提示：（无需注册或充值，赞助后即可获取资源下载链接）

---

     嘿，亲！知识可是无价之宝呢，但咱这精心整理的资料也耗费了不少心血呀。小小地破费一下，绝对物超所值哦！如有下载和支付问题，请联系我们QQ(微信同号)：78630559

本次赞助数额为： 2 元　

支付宝支付

微信支付

   源码介绍

---

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

namespace _1310506164
{
    public partial class EmpFrm : Form
    {
        public ListView listView = null;
        public int index = -1;

        public EmpFrm()
        {
            InitializeComponent();
        }

        public Boolean isChanged = false;
        MySqlDataReader dr = null;
        DatabaseOperate od = new DatabaseOperate();
        public SearchFrm searchFrm;
        public MainFrm mainFrm;

        private void EmpFrm_Load(object sender, EventArgs e)
        {
            if (index == -1)
            {
                showFirst();
            }
            else if (index == -2)
            {
                tsmDel.Enabled = false;
                tsmNext.Enabled = false;
                tsmPre.Enabled = false;
                txtID.ReadOnly = false;
            }
            else
            {
                showInfo();
            }
        }

        public void showInfo()
        {
            txtID.Text = listView.Items[index].SubItems[0].Text;
            txtName.Text = listView.Items[index].SubItems[1].Text;
            cmbGender.Text = listView.Items[index].SubItems[2].Text;
            txtCollege.Text = listView.Items[index].SubItems[3].Text;
            txtCard.Text = listView.Items[index].SubItems[4].Text;
            txtAddr.Text = listView.Items[index].SubItems[5].Text;
            txtEmail.Text = listView.Items[index].SubItems[6].Text;
            txtTel.Text = listView.Items[index].SubItems[7].Text;
            txtSignday.Text = listView.Items[index].SubItems[8].Text;
            txtWorkdays.Text = listView.Items[index].SubItems[9].Text;
            txtDueday.Text = listView.Items[index].SubItems[10].Text;
            txtDepart.Text = listView.Items[index].SubItems[11].Text;
            txtPost.Text = listView.Items[index].SubItems[12].Text;
            cmbState.Text = listView.Items[index].SubItems[13].Text;
            tsmUpdate.Enabled = false;
        }

        public void showFirst()
        {
            string strSel = "Select * from employee limit 1";
            dr = od.DBSelect(strSel);
            if (dr.Read())
            {
                txtID.Text = dr["emId"].ToString();
                txtName.Text = dr["name"].ToString();
                cmbGender.Text = dr["gender"].ToString();
                txtCollege.Text = dr["college"].ToString();
                txtCard.Text = dr["idNo"].ToString();
                txtAddr.Text = dr["homeAddr"].ToString();
                txtEmail.Text = dr["email"].ToString();
                txtTel.Text = dr["telNo"].ToString();
                txtDepart.Text = dr["depart"].ToString();
                txtPost.Text = dr["post"].ToString();
                txtSignday.Text = dr["hiredate"].ToString();
                txtDueday.Text = dr["dueDate"].ToString();
                cmbState.Text = dr["state"].ToString();
                txtWorkdays.Text = dr["tenure"].ToString();
                tsmUpdate.Enabled = false;
            }
        }

        private void 修改ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            update();
        }

        private void txtName_TextChanged(object sender, EventArgs e)
        {
            isChanged = true;
            tsmUpdate.Enabled = true;
        }

        private void cmbGender_SelectedValueChanged(object sender, EventArgs e)
        {
            isChanged = true;
            tsmUpdate.Enabled = true;
        }

        private void txtCollege_TextChanged(object sender, EventArgs e)
        {
            isChanged = true;
            tsmUpdate.Enabled = true;
        }

        private void update()
        {
            try
            {
                string UpdateStr = "update employee set name='"   txtName.Text.Trim()  
                                        "',gender='"   cmbGender.Text.Trim()  
                                        "',college='"   txtCollege.Text.Trim()  
                                        "',idNo='"   txtCard.Text.Trim()  
                                        "',homeAddr='"   txtAddr.Text.Trim()  
                                        "',email='"   txtEmail.Text.Trim()  
                                        "',telNo='"   txtTel.Text.Trim()  
                                        "',hiredate='"   txtSignday.Text.Trim()  
                                        "',tenure='"   txtWorkdays.Text.Trim()  
                                        "',dueDate='"   txtDueday.Text.Trim()  
                                        "',depart='"   txtDepart.Text.Trim()  
                                        "',post='"   txtPost.Text.Trim()  
                                        "',state='"   cmbState.Text.Trim()  
                                        "'where ( emId='"   txtID.Text.Trim()   "')";
                if (od.DBOpereate(UpdateStr))
                {
                    MessageBox.Show("修改成功!", "提示");
                    tsmUpdate.Enabled = false;
                }
                else
                    MessageBox.Show("修改失败!", "提示");
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }

        }

        private void txtCard_TextChanged(object sender, EventArgs e)
        {
            isChanged = true;
            tsmUpdate.Enabled = true;
        }

        private void txtAddr_TextChanged(object sender, EventArgs e)
        {
            isChanged = true;
            tsmUpdate.Enabled = true;
        }

        private void txtEmail_TextChanged(object sender, EventArgs e)
        {
            isChanged = true;
            tsmUpdate.Enabled = true;
        }

        private void txtTel_TextChanged(object sender, EventArgs e)
        {
            isChanged = true;
            tsmUpdate.Enabled = true;
        }

        private void txtDepart_TextChanged(object sender, EventArgs e)
        {
            isChanged = true;
            tsmUpdate.Enabled = true;
        }

        private void txtPost_TextChanged(object sender, EventArgs e)
        {
            isChanged = true;
            tsmUpdate.Enabled = true;
        }

        private void cmbState_SelectedValueChanged(object sender, EventArgs e)
        {
            isChanged = true;
            tsmUpdate.Enabled = true;
        }

        private void txtSignday_TextChanged(object sender, EventArgs e)
        {
            isChanged = true;
            tsmUpdate.Enabled = true;
        }

        private void txtDueday_TextChanged(object sender, EventArgs e)
        {
            isChanged = true;
            tsmUpdate.Enabled = true;
        }

        private void txtWorkdays_TextChanged(object sender, EventArgs e)
        {
            isChanged = true;
            tsmUpdate.Enabled = true;
        }

        private void 下一条ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            try
            {
                string strSel = "SELECT * FROM employee WHERE emId >'"   txtID.Text.Trim()   "' ORDER BY emId ASC LIMIT 1   ";
                dr = od.DBSelect(strSel);
                if (dr.Read())
                {
                    txtID.Text = dr["emId"].ToString();
                    txtName.Text = dr["name"].ToString();
                    cmbGender.Text = dr["gender"].ToString();
                    txtCollege.Text = dr["college"].ToString();
                    txtCard.Text = dr["idNo"].ToString();
                    txtAddr.Text = dr["homeAddr"].ToString();
                    txtEmail.Text = dr["email"].ToString();
                    txtTel.Text = dr["telNo"].ToString();
                    txtDepart.Text = dr["depart"].ToString();
                    txtPost.Text = dr["post"].ToString();
                    txtSignday.Text = dr["hiredate"].ToString();
                    txtDueday.Text = dr["dueDate"].ToString();
                    cmbState.Text = dr["state"].ToString();
                    txtWorkdays.Text = dr["tenure"].ToString();
                    tsmUpdate.Enabled = false;
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

        private void 上一条ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            string strSel = "SELECT * FROM employee WHERE emId <'" txtID.Text.Trim() "' ORDER BY emId DESC LIMIT 1 ";
            dr = od.DBSelect(strSel);
            if(dr.Read())
            {
                txtID.Text = dr["emId"].ToString();
                txtName.Text = dr["name"].ToString();
                cmbGender.Text = dr["gender"].ToString();
                txtCollege.Text = dr["college"].ToString();
                txtCard.Text = dr["idNo"].ToString();
                txtAddr.Text = dr["homeAddr"].ToString();
                txtEmail.Text = dr["email"].ToString();
                txtTel.Text = dr["telNo"].ToString();
                txtDepart.Text = dr["depart"].ToString();
                txtPost.Text = dr["post"].ToString();
                txtSignday.Text = dr["hiredate"].ToString();
                txtDueday.Text = dr["dueDate"].ToString();
                cmbState.Text = dr["state"].ToString();
                txtWorkdays.Text = dr["tenure"].ToString();
                tsmUpdate.Enabled = false;
            }
        }

        private void 删除ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            string strDel = "delete from employee where emId = '"   txtID.Text.Trim()   "'";
            if (od.DBOpereate(strDel))
            {
                MessageBox.Show("已经删除数据!","提示");
                showFirst();
            }
        }

        private void tsmInsert_Click(object sender, EventArgs e)
        {
            try
            {
                string strSQL = "insert into employee value('"   txtID.Text   "','"   txtName.Text   "','"   cmbGender.Text   "','"  
                                txtCollege.Text   "','"   txtCard.Text   "','"   txtAddr.Text   "','"   txtEmail.Text   "','"  
                                txtTel.Text   "','"   txtSignday.Text   "','"   Int32.Parse(txtWorkdays.Text)   "','"   txtDueday.Text   "','"  
                                txtDepart.Text   "','"   txtPost.Text   "','"   Int32.Parse(cmbState.Text)  
                                "')";
                if (od.DBOpereate(strSQL))
                {
                    MessageBox.Show("添加成功!", "提示");
                    tsmUpdate.Enabled = true;
                    tsmDel.Enabled = true;
                    tsmPre.Enabled = true;
                    tsmNext.Enabled = true;
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
    }
}