frmpersonelinfo.cs

中小企业人力资源管理系统

                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["BookInTime"] = Convert.ToDateTime(this.dtpEmployeeBirth.Text);
                newrow["EmployeePartyTime"] = Convert.ToDateTime(this.dtpEmployeePartyTime.Text);
                newrow["EmployeeFoldTime"] = Convert.ToDateTime(this.dtpEmployeeFoldTime.Text);
                newrow["EmployeeJoinWorkTime"] = Convert.ToDateTime(this.dtpEmployeePartyTime.Text);
                newrow["EmployeePhoto"] = bytes;
                ds.Tables["tb_Personnel"].Rows.Add(newrow);
                /*
                string sqls = "insert into tb_Personnel values(" + "'" + newrow["EmployeeID"] + "'" + "," + "'" + newrow["Booker"] + "'" + "," + "'" + newrow["EmployeeAddress"] + "'" + "," + newrow["EmployeeAge"] + "," + "'" + newrow["EmployeeCollege"] + "'" + "," + "'" + newrow["EmployeeIDcard"] + "'" + "," + "'" + newrow["EmployeeKultuLevel"] + "'" + ",";
                sqls += "'" + newrow["EmployeeLongSuit"] + "'" + "," + "'" + newrow["EmployeeMobileTel"] + "'" + "," + "'" + newrow["EmployeeName"] + "'" + "," + "'" + newrow["EmployeeNativePlace"] + "'" + "," + newrow["EmployeeOther"] + "," + "'" + newrow["EmployeeResume"] + "'" + "," + "'" + newrow["EmployeeSpeciality"] + "'" + "," + "'" + newrow["EmployeeTel"] + "'," + newrow["EmployeeUnitWorkAge"] + ",";
                sqls += newrow["EmployeeWorkAge"] + "," + newrow["EmployeeBasePay"] + "," + "'"+newrow["EmployeeDept"] +"'"+","+"'"+ newrow["EmployeeDutyType"] +"'"+ "," + "'"+newrow["EmployeeFolk"] +"'"+ "," + "'"+newrow["EmployeeMarriage"] +"'"+ "," +"'"+ newrow["EmployeePoliticsVisage"] +"'"+ "," +"'"+ newrow["EmployeePostTitle"] +"'"+ "," +"'"+ newrow["EmployeeSex"] +"'"+ "," + "'"+newrow["EmployeeWorkType"] +"'"+ ",";
                sqls += newrow["BookInTime"] + "," + newrow["EmployeePartyTime"] + "," + newrow["EmployeePhoto"] + ")";
                sqlclass.sqlcmd(sqls);
                 * */
                
                try
                {
                    sda.Update(ds, "tb_Personnel");
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message + ";" + ex.Source);
                }
             
                
                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();

        }
    }
}