⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 frmpersonelinfo.cs

📁 基于SQLSERVER C#2.0的企业ERP管理系统
💻 CS
📖 第 1 页 / 共 2 页
字号:
                newrow["Booker"] = this.txtBooker.Text;
                newrow["EmployeeAddress"] = this.txtEmployeeAddress.Text;
                newrow["EmployeeAge"] = Convert.ToInt16(this.txtEmployeeAge.Text);
                newrow["EmployeeCollege"] = this.txtEmployeeCollege.Text;
                newrow["EmployeeIDcard"] = this.txtEmployeeIDcard.Text;
                newrow["EmployeeKultuLevel"] = this.cbbEmployeeKultuLevel.Text;
                newrow["EmployeeLongSuit"] = this.txtEmployeeLongSuit.Text;
                newrow["EmployeeMobileTel"] = this.txtEmployeeMobileTel.Text;
                newrow["EmployeeName"] = this.txtEmployeeName.Text;
                newrow["EmployeeNativePlace"] = this.txtEmployeeNativePlace.Text;
                newrow["EmployeeOther"] = Convert.ToDouble(this.txtEmployeeOther.Text);
                newrow["EmployeeResume"] = this.txtEmployeeResume.Text;
                newrow["EmployeeSpeciality"] = this.txtEmployeeSpeciality.Text;
                newrow["EmployeeTel"] = this.txtEmployeeTel.Text;
                newrow["EmployeeUnitWorkAge"] = Convert.ToInt32(this.txtEmployeeUnitWorkAge.Text);
                newrow["EmployeeWorkAge"] = this.txtEmployeeWorkAge.Text;
                newrow["EmployeeBasePay"] = Convert.ToDouble(this.txtEmployeeBasePay.Text);
                newrow["EmployeeDept"] = this.cbbEmployeeDept.Text;
                newrow["EmployeeDutyType"] = this.cbbEmployeeDutyType.Text;
                newrow["EmployeeFolk"] = this.cbbEmployeeFolk.Text;
                newrow["EmployeeMarriage"] = this.cbbEmployeeMarriage.Text;
                newrow["EmployeePoliticsVisage"] = this.cbbEmployeePoliticsVisage.Text;
                newrow["EmployeePostTitle"] = this.cbbEmployeePostTitle.Text;
                newrow["EmployeeSex"] = this.cbbEmployeeSex.Text;
                newrow["EmployeeWorkType"] = this.cbbEmployeeWorkType.Text;
                newrow["BookInTime"] = this.dtpBookInTime.Text;
                newrow["EmployeeBirth"] = Convert.ToDateTime(this.dtpEmployeeBirth.Text);
                newrow["EmployeePartyTime"] = Convert.ToDateTime(this.dtpEmployeePartyTime.Text);
                newrow["EmployeeFoldTime"] = Convert.ToDateTime(this.dtpEmployeeFoldTime.Text);
                newrow["EmployeePhoto"] = bytes;
                ds.Tables["tb_Personnel"].Rows.Add(newrow);
                sda.Update(ds, "tb_Personnel");
                ds.Dispose();
                MessageBox.Show("数据添加成功!");
                this.empty();
                this.tlbtnAdd.Enabled = true;
                this.tlbtnEdit.Enabled = true;
                this.tlbtnDelete.Enabled = true;
                this.tlbtnAll.Enabled = true;
                this.tlbtnSearch.Enabled = true;
                this.tlbtnPrint.Enabled = true;
                this.tlbtnYes.Enabled = false;
                this.tlbtnReturn.Enabled = false;
                this.Bind();
            }
            catch
            {
                MessageBox.Show("数据添加失败!");
            }
         }
        private void tlbtnEdit_Click(object sender, EventArgs e)
        {
            try
            {
                SqlDataAdapter sda = sqlclass.sqlsda("select * from tb_Personnel where EmployeeID=" + this.txtEmployeeID.Text);
                DataSet ds = new DataSet();
                SqlCommandBuilder sb = new SqlCommandBuilder(sda);
                sda.Fill(ds, "tb_Personnel");

                ds.Tables["tb_Personnel"].Rows[0]["Booker"] = this.txtBooker.Text;
                ds.Tables["tb_Personnel"].Rows[0]["EmployeeAddress"] = this.txtEmployeeAddress.Text;
                ds.Tables["tb_Personnel"].Rows[0]["EmployeeAge"] = this.txtEmployeeAge.Text;
                ds.Tables["tb_Personnel"].Rows[0]["EmployeeCollege"] = this.txtEmployeeCollege.Text;
                ds.Tables["tb_Personnel"].Rows[0]["EmployeeIDcard"] = this.txtEmployeeIDcard.Text;
                ds.Tables["tb_Personnel"].Rows[0]["EmployeeKultuLevel"] = this.cbbEmployeeKultuLevel.Text;
                ds.Tables["tb_Personnel"].Rows[0]["EmployeeLongSuit"] = this.txtEmployeeLongSuit.Text;
                ds.Tables["tb_Personnel"].Rows[0]["EmployeeMobileTel"] = this.txtEmployeeMobileTel.Text;
                ds.Tables["tb_Personnel"].Rows[0]["EmployeeName"] = this.txtEmployeeName.Text;
                ds.Tables["tb_Personnel"].Rows[0]["EmployeeNativePlace"] = this.txtEmployeeNativePlace.Text;
                ds.Tables["tb_Personnel"].Rows[0]["EmployeeOther"] = this.txtEmployeeOther.Text;
                ds.Tables["tb_Personnel"].Rows[0]["EmployeeResume"] = this.txtEmployeeResume.Text;
                ds.Tables["tb_Personnel"].Rows[0]["EmployeeSpeciality"] = this.txtEmployeeSpeciality.Text;
                ds.Tables["tb_Personnel"].Rows[0]["EmployeeTel"] = this.txtEmployeeTel.Text;
                ds.Tables["tb_Personnel"].Rows[0]["EmployeeUnitWorkAge"] = this.txtEmployeeUnitWorkAge.Text;
                ds.Tables["tb_Personnel"].Rows[0]["EmployeeWorkAge"] = this.txtEmployeeWorkAge.Text;
                ds.Tables["tb_Personnel"].Rows[0]["EmployeeBasePay"] = this.txtEmployeeBasePay.Text;
                ds.Tables["tb_Personnel"].Rows[0]["EmployeeDept"] = this.cbbEmployeeDept.Text;
                ds.Tables["tb_Personnel"].Rows[0]["EmployeeDutyType"] = this.cbbEmployeeDutyType.Text;
                ds.Tables["tb_Personnel"].Rows[0]["EmployeeFolk"] = this.cbbEmployeeFolk.Text;
                ds.Tables["tb_Personnel"].Rows[0]["EmployeeMarriage"] = this.cbbEmployeeMarriage.Text;
                ds.Tables["tb_Personnel"].Rows[0]["EmployeePoliticsVisage"] = this.cbbEmployeePoliticsVisage.Text;
                ds.Tables["tb_Personnel"].Rows[0]["EmployeePostTitle"] = this.cbbEmployeePostTitle.Text;
                ds.Tables["tb_Personnel"].Rows[0]["EmployeeSex"] = this.cbbEmployeeSex.Text;
                ds.Tables["tb_Personnel"].Rows[0]["EmployeeWorkType"] = this.cbbEmployeeWorkType.Text;
                ds.Tables["tb_Personnel"].Rows[0]["BookInTime"] = this.dtpBookInTime.Text;
                ds.Tables["tb_Personnel"].Rows[0]["EmployeeBirth"] = this.dtpEmployeeBirth.Text;
                ds.Tables["tb_Personnel"].Rows[0]["EmployeePartyTime"] = this.dtpEmployeePartyTime.Text;
                ds.Tables["tb_Personnel"].Rows[0]["EmployeeFoldTime"] = this.dtpEmployeeFoldTime.Text;
                ds.Tables["tb_Personnel"].Rows[0]["EmployeePhoto"] = bytes;
                sda.Update(ds, "tb_Personnel");
                ds.Dispose();
                this.Bind();
                MessageBox.Show("数据修改成功!");
            }
            catch
            {
                MessageBox.Show("数据修改失败!");
            }
        }
        //查找图片
        private void btnImage_Click(object sender, EventArgs e)
        {
            OpenFileDialog MyFileDialog = new OpenFileDialog();
            MyFileDialog.ShowDialog();
            if (MyFileDialog.FileName.Trim() != "")
            {
                Stream MyStream = MyFileDialog.OpenFile();
                int length = (int)MyStream.Length;
                bytes = new byte[length];
                MyStream.Read(bytes, 0, length);
                this.image(bytes);
                MyStream.Close();
            }
        }
        //显示图片
        public void image(byte[] bytes)
        {
            MemoryStream memStream = new MemoryStream(bytes);
            try
            {
                Bitmap MyImage = new Bitmap(memStream);
                this.ptbEmployeePhoto.Image = MyImage;
            }
            catch
            {
                MessageBox.Show(this, "读取数据库中的图像信息失败!", "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                this.ptbEmployeePhoto.Image = null;
            }
        }

        private void tlbtnDelete_Click(object sender, EventArgs e)
        {

            string strid = Convert.ToString(dgvPersonnelManage[0, dgvPersonnelManage.CurrentCell.RowIndex].Value);
            if (strid != "")
            {
                try
                {
                    sqlclass.sqlcmd("delete from tb_Personnel where EmployeeID=" + strid);
                    this.Bind();
                }
                catch
                {
                    MessageBox.Show("操作失败!");
                }
            }
        }

        private void tlbtnAll_Click(object sender, EventArgs e)
        {
            this.Bind();
        }

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

        private void tlbtnSearch_Click(object sender, EventArgs e)
        {
            string strdata;
            switch (this.tlcbbData.Text)
            {
                case "编号":
                    strdata = "EmployeeID";
                    break;
                case "姓名":
                    strdata = "EmployeeName";
                    break;
                case "部门":
                    strdata = "EmployeeDept";
                    break;
                case "职务":
                    strdata = "EmployeeDutyType";
                    break;
                default:
                    MessageBox.Show("请选择一个正确的字段");
                    return;
            }
            if (tltxtKeyWord.Text == "")
            {
                MessageBox.Show("关键字不能为空!");
                return;
            }
            try
            {
                ds=persomclass.persomelSearch(strdata, this.tltxtKeyWord.Text);
                this.dgvPersonnelManage.DataSource = ds.Tables["tb_Personnel"];
                this.dgvPersonnelManage.Rows[0].Selected = true;
            }
            catch
            {
                MessageBox.Show("操作失败!");
            }
        }

        private void tlbtnPrint_Click(object sender, EventArgs e)
        {
            frmPersonelPrint frm_personelprint = new frmPersonelPrint();
            frm_personelprint.ds =this.ds;
            frm_personelprint.ShowDialog();

        }
    }
}

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -