formaddemp.cs

数据库开发与实例（1+1混合数据库开发实例丛书）人事管理系统的源代码

                DA.WriteImage(openfile.FileName, int.Parse(this.No_txt.Text.Trim()));
                MessageBox.Show("保存图片成功！");
            }
            else
            {
                MessageBox.Show("选择文件错误！");
            }
        }

        //添加或修改记录
        private void button1_Click(object sender, EventArgs e)
        {
            
            if (HRMan.HROper.FormEmpInfo.emploID == "insert") 
            {
                if (Certification.IsValidNumber(this.No_txt.Text.Trim()))
                {
                    string SqlText = "select * from EmployInfo where eId=" + int.Parse(this.No_txt.Text);
                    DataAccess DA = new DataAccess(); 
                    if (!DA.IsRead(SqlText))
                    {
                        if (this.Phone_txt.Text.Trim() != "")
                        {
                            if (Certification.IsValidPhono(this.Phone_txt.Text.Trim()))
                            {
                                this.EenMen_txt.Text = this.No_txt.Text.Trim();
                                this.Med_txt.Text = this.No_txt.Text.Trim();
                                this.Wa_txt.Text = this.No_txt.Text.Trim();
                                string[] str = new string[11];
                                str[0] = "insert into EmployInfo values(" + int.Parse(this.No_txt.Text.Trim()) + "," + int.Parse(this.RaceId_txt.Text.Trim()) + ",";
                                str[0] += int.Parse(this.SectionId_txt.Text.Trim()) + "," + int.Parse(this.JobId_txt.Text.Trim()) + "," + int.Parse(this.No_txt.Text.Trim()) + ",";
                                str[0] += int.Parse(this.TitleId_txt.Text.Trim()) + "," + int.Parse(this.No_txt.Text.Trim()) + "," + int.Parse(this.No_txt.Text.Trim()) + ",";
                                str[0] += int.Parse(this.No_txt.Text.Trim()) + "," + int.Parse(this.No_txt.Text.Trim()) + "," + int.Parse(this.No_txt.Text.Trim()) + ",";
                                str[0] += int.Parse(this.No_txt.Text.Trim()) + "," + int.Parse(this.No_txt.Text.Trim()) + "," + int.Parse(this.No_txt.Text.Trim()) + ",";
                                str[0] += int.Parse(this.No_txt.Text.Trim()) + "," + int.Parse(this.No_txt.Text.Trim()) + ",'" + this.Name_txt.Text + "','";
                                str[0] += this.Sex_cb.Text + "','" + this.Party_cb.Text + "','" + this.Birth_dtp.Value.ToShortDateString() + "','" + this.Place_cb.Text + "','";
                                str[0] += this.EmpTime_dtp.Value.ToShortDateString() + "','" + this.EmpType_cb.Text + "','" + this.Source_cb.Text + "','";
                                str[0] += this.Number_txt.Text.Trim() + "','" + this.Phone_txt.Text.Trim() + "','" + this.Adress_txt.Text + "','" + this.Marrige_cb.Text + "','";
                                str[0] += this.Edu_cb.Text + "','" + this.Pro_cb.Text + "','" + this.School_txt.Text + "','" + this.LeaveSchool_dtp.Value.ToShortDateString() + "','";
                                str[0] += this.Degree_cb.Text + "','" + this.App_cb.Text + "','1')";
                                str[1] = "insert into EndowmentInfo (endId,enId) values (" + int.Parse(this.No_txt.Text.Trim()) + "," + int.Parse(this.No_txt.Text.Trim()) + ")";
                                str[2] = "insert into HolidayInfo (hId) values (" + int.Parse(this.No_txt.Text.Trim()) + ")";
                                str[3] = "insert into MedicalInfo (meId,mId) values (" + int.Parse(this.No_txt.Text.Trim()) + "," + int.Parse(this.No_txt.Text.Trim()) + ")";
                                str[4] = "insert into PpInfo (pId) values (" + int.Parse(this.No_txt.Text.Trim()) + ")";
                                str[5] = "insert into SocietyInfo (seId) values (" + int.Parse(this.No_txt.Text.Trim()) + ")";
                                str[6] = "insert into TitleInfo (tiId) values (" + int.Parse(this.No_txt.Text.Trim()) + ")";
                                str[7] = "insert into TrainInfo (trId) values (" + int.Parse(this.No_txt.Text.Trim()) + ")";
                                str[8] = "insert into TransferInfo (traId) values (" + int.Parse(this.No_txt.Text.Trim()) + ")";
                                str[9] = "insert into WagesInfo (waId,Id) values (" + int.Parse(this.No_txt.Text.Trim()) + "," + int.Parse(this.No_txt.Text.Trim()) + ")";
                                str[10] = "insert into WorkInfo (wId) values (" + int.Parse(this.No_txt.Text.Trim()) + ")";
                                DataAccess dataaccess = new DataAccess();  
                                dataaccess.ExeSQLs(str);
                                MessageBox.Show("添加成功!");
                                HRMan.HROper.FormEmpInfo.emploinfo.Enabled = true;    
                                HRMan.HROper.FormEmpInfo.emploinfo.DBDataGrid();      
                                this.Close();
                            }
                            else
                            {
                                MessageBox.Show("电话号码格式错误!");
                            }
                        }
                        else
                        {
                            this.EenMen_txt.Text = this.No_txt.Text.Trim();
                            this.Med_txt.Text = this.No_txt.Text.Trim();
                            this.Wa_txt.Text = this.No_txt.Text.Trim();
                            string[] str = new string[11];
                            str[0] = "insert into EmployInfo values(" + int.Parse(this.No_txt.Text.Trim()) + "," + int.Parse(this.RaceId_txt.Text.Trim()) + ",";
                            str[0] += int.Parse(this.SectionId_txt.Text.Trim()) + "," + int.Parse(this.JobId_txt.Text.Trim()) + "," + int.Parse(this.No_txt.Text.Trim()) + ",";
                            str[0] += int.Parse(this.TitleId_txt.Text.Trim()) + "," + int.Parse(this.No_txt.Text.Trim()) + "," + int.Parse(this.No_txt.Text.Trim()) + ",";
                            str[0] += int.Parse(this.No_txt.Text.Trim()) + "," + int.Parse(this.No_txt.Text.Trim()) + "," + int.Parse(this.No_txt.Text.Trim()) + ",";
                            str[0] += int.Parse(this.No_txt.Text.Trim()) + "," + int.Parse(this.No_txt.Text.Trim()) + "," + int.Parse(this.No_txt.Text.Trim()) + ",";
                            str[0] += int.Parse(this.No_txt.Text.Trim()) + "," + int.Parse(this.No_txt.Text.Trim()) + ",'" + this.Name_txt.Text + "','";
                            str[0] += this.Sex_cb.Text + "','" + this.Party_cb.Text + "','" + this.Birth_dtp.Value.ToShortDateString() + "','" + this.Place_cb.Text + "','";
                            str[0] += this.EmpTime_dtp.Value.ToShortDateString() + "','" + this.EmpType_cb.Text + "','" + this.Source_cb.Text + "','";
                            str[0] += this.Number_txt.Text.Trim() + "','" + this.Phone_txt.Text.Trim() + "','" + this.Adress_txt.Text + "','" + this.Marrige_cb.Text + "','";
                            str[0] += this.Edu_cb.Text + "','" + this.Pro_cb.Text + "','" + this.School_txt.Text + "','" + this.LeaveSchool_dtp.Value.ToShortDateString() + "','";
                            str[0] += this.Degree_cb.Text + "','" + this.App_cb.Text + "','1')";
                            str[1] = "insert into EndowmentInfo (endId,enId) values (" + int.Parse(this.No_txt.Text.Trim()) + "," + int.Parse(this.No_txt.Text.Trim()) + ")";
                            str[2] = "insert into HolidayInfo (hId) values (" + int.Parse(this.No_txt.Text.Trim()) + ")";
                            str[3] = "insert into MedicalInfo (meId,mId) values (" + int.Parse(this.No_txt.Text.Trim()) + "," + int.Parse(this.No_txt.Text.Trim()) + ")";
                            str[4] = "insert into PpInfo (pId) values (" + int.Parse(this.No_txt.Text.Trim()) + ")";
                            str[5] = "insert into SocietyInfo (seId) values (" + int.Parse(this.No_txt.Text.Trim()) + ")";
                            str[6] = "insert into TitleInfo (tiId) values (" + int.Parse(this.No_txt.Text.Trim()) + ")";
                            str[7] = "insert into TrainInfo (trId) values (" + int.Parse(this.No_txt.Text.Trim()) + ")";
                            str[8] = "insert into TransferInfo (traId) values (" + int.Parse(this.No_txt.Text.Trim()) + ")";
                            str[9] = "insert into WagesInfo (waId,Id) values (" + int.Parse(this.No_txt.Text.Trim()) + "," + int.Parse(this.No_txt.Text.Trim()) + ")";
                            str[10] = "insert into WorkInfo (wId) values (" + int.Parse(this.No_txt.Text.Trim()) + ")";
                            DataAccess da = new DataAccess();  
                            da.ExeSQLs(str);
                            MessageBox.Show("添加成功!");
                            HRMan.HROper.FormEmpInfo.emploinfo.Enabled = true;   
                            HRMan.HROper.FormEmpInfo.emploinfo.DBDataGrid();     
                            this.Close();
                        }
                    }
                    else
                    {
                        MessageBox.Show("员工编号已存在！");
                    }
                }
                else
                {
                    MessageBox.Show("员工编号格式不正确!");
                }
            }
           //修改记录
            if (HRMan.HROper.FormEmpInfo.emploID == "update")
            {
                if (this.Phone_txt.Text.Trim() != "")
                {
                    if (Certification.IsValidPhono(this.Phone_txt.Text.Trim()))
                    {
                        string[] SqlText = new string[4];
                        SqlText[0] = "update EmployInfo set rId=" + int.Parse(this.RaceId_txt.Text.Trim()) + ",sId=" + int.Parse(this.SectionId_txt.Text.Trim());
                        SqlText[0] += ",jId=" + int.Parse(this.JobId_txt.Text.Trim()) + ",tId=" + int.Parse(this.TitleId_txt.Text.Trim()) + ",eName='";
                        SqlText[0] += this.Name_txt.Text.Trim() + "',eSex='" + this.Sex_cb.Text + "',eParty='" + this.Party_cb.Text + "',eBirth='" + this.Birth_dtp.Value.ToShortDateString();
                        SqlText[0] += "',ePlace='" + this.Place_cb.Text + "',eEmpTime='" + this.EmpTime_dtp.Value.ToShortDateString() + "',eEmpType='" + this.EmpType_cb.Text + "',eEmpDataSource='";
                        SqlText[0] += this.Source_cb.Text + "',eNumber='" + this.Number_txt.Text.Trim() + "',ePhone='" + this.Phone_txt.Text.Trim() + "',eAddress='";
                        SqlText[0] += this.Adress_txt.Text + "',eMarriage='" + this.Marrige_cb.Text + "',eEdu='" + this.Edu_cb.Text + "',ePro='" + this.Pro_cb.Text;
                        SqlText[0] += "',eSchool='" + this.School_txt.Text + "',eDate='" + this.LeaveSchool_dtp.Value.ToShortDateString() + "',eDegree='" + this.Degree_cb.Text + "',eApp='";
                        SqlText[0] += this.App_cb.Text + "' where eId=" + int.Parse(this.No_txt.Text);
                        SqlText[1] = "update EndowmentInfo set enId=" + int.Parse(this.EenMen_txt.Text.Trim()) + " where endId=" + int.Parse(this.No_txt.Text.Trim());
                        SqlText[2] = "update MedicalInfo set mId=" + int.Parse(this.Med_txt.Text.Trim()) + " where meId=" + int.Parse(this.No_txt.Text.Trim());
                        SqlText[3] = "update WagesInfo set ID=" + int.Parse(this.Wa_txt.Text.Trim()) + " where waId=" + int.Parse(this.No_txt.Text.Trim()); ;
                        DataAccess DA = new DataAccess();  
                        DA.ExeSQLs(SqlText);
                        MessageBox.Show("修改成功!");
                        HRMan.HROper.FormEmpInfo.emploinfo.Enabled = true;  
                        HRMan.HROper.FormEmpInfo.emploinfo.DBDataGrid();    
                        this.Close();
                    }
                    else
                    {
                        MessageBox.Show("电话号码格式错误!");
                    }
                }
                else
                {
                    string[] SqlText = new string[4];
                    SqlText[0] = "update EmployInfo set rId=" + int.Parse(this.RaceId_txt.Text.Trim()) + ",sId=" + int.Parse(this.SectionId_txt.Text.Trim());
                    SqlText[0] += ",jId=" + int.Parse(this.JobId_txt.Text.Trim()) + ",tId=" + int.Parse(this.TitleId_txt.Text.Trim()) + ",eName='";
                    SqlText[0] += this.Name_txt.Text.Trim() + "',eSex='" + this.Sex_cb.Text + "',eParty='" + this.Party_cb.Text + "',eBirth='" + this.Birth_dtp.Value.ToShortDateString();
                    SqlText[0] += "',ePlace='" + this.Place_cb.Text + "',eEmpTime='" + this.EmpTime_dtp.Value.ToShortDateString() + "',eEmpType='" + this.EmpType_cb.Text + "',eEmpDataSource='";
                    SqlText[0] += this.Source_cb.Text + "',eNumber='" + this.Number_txt.Text.Trim() + "',ePhone='" + this.Phone_txt.Text.Trim() + "',eAddress='";
                    SqlText[0] += this.Adress_txt.Text + "',eMarriage='" + this.Marrige_cb.Text + "',eEdu='" + this.Edu_cb.Text + "',ePro='" + this.Pro_cb.Text;
                    SqlText[0] += "',eSchool='" + this.School_txt.Text + "',eDate='" + this.LeaveSchool_dtp.Value.ToShortDateString() + "',eDegree='" + this.Degree_cb.Text + "',eApp='";
                    SqlText[0] += this.App_cb.Text + "' where eId=" + int.Parse(this.No_txt.Text);
                    SqlText[1] = "update EndowmentInfo set enId=" + int.Parse(this.EenMen_txt.Text.Trim()) + " where endId=" + int.Parse(this.No_txt.Text.Trim());
                    SqlText[2] = "update MedicalInfo set mId=" + int.Parse(this.Med_txt.Text.Trim()) + " where meId=" + int.Parse(this.No_txt.Text.Trim());
                    SqlText[3] = "update WagesInfo set ID=" + int.Parse(this.Wa_txt.Text.Trim()) + " where waId=" + int.Parse(this.No_txt.Text.Trim()); ;
                    DataAccess da = new DataAccess();  
                    da.ExeSQLs(SqlText);
                    MessageBox.Show("修改成功!");
                    HRMan.HROper.FormEmpInfo.emploinfo.Enabled = true;   
                    HRMan.HROper.FormEmpInfo.emploinfo.DBDataGrid();     
                    this.Close();
                }
            }
         
        }

        private void groupBox2_Enter(object sender, EventArgs e)
        {

        }
    }
}