📄 addform.cs
字号:
{
this.Race_cb.Items.Add(dt.Rows[i]["rName"].ToString());
}
}
#endregion
#region 把部门表绑定到部门下拉列表中
private void DBSection_cb()
{
string str = "select * from SectionInfo";
DataTable dt = new DataTable();
Base bb = new Base();
dt = bb.ExeSQLdt(str);
for(int i = 0 ; i < dt.Rows.Count ; i ++)
{
this.Section_cb.Items.Add(dt.Rows[i]["sName"].ToString());
}
}
#endregion
#region 把职务表绑定到职务下拉列表中
private void DBJob_cb()
{
string str = "select * from JobInfo";
DataTable dt = new DataTable();
Base bb = new Base();
dt = bb.ExeSQLdt(str);
for(int i = 0 ; i < dt.Rows.Count ; i ++)
{
this.Job_cb.Items.Add(dt.Rows[i]["JName"].ToString());
}
}
#endregion
#region 把职称表绑定到职称下拉列表中
private void DBTitle_cb()
{
string str = "select * from Title";
DataTable dt = new DataTable();
Base bb = new Base();
dt = bb.ExeSQLdt(str);
for(int i = 0 ; i < dt.Rows.Count; i ++)
{
this.Title_cb.Items.Add(dt.Rows[i]["tName"].ToString());
}
}
#endregion
#region 确定（确定添加一条新记录或确定一条修改后的记录）
private void button1_Click(object sender, System.EventArgs e)
{
#region 添加记录
if(empInfoForm.empID == "insert")
{
if(Regexlib.IsValidNumber(this.No_txt.Text.Trim()))
{
string ss = "select * from EmployInfo where eId=" + int.Parse(this.No_txt.Text);
Base bb = new Base();
if(!bb.IsRead(ss))
{
if(this.Phone_txt.Text.Trim() != "")
{
if(Regexlib.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()) + ")";
Base b = new Base();
b.ExeSQLs(str);
MessageBox.Show("添加成功!");
empInfoForm.eif.Enabled = true;
empInfoForm.eif.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()) + ")";
Base b = new Base();
b.ExeSQLs(str);
MessageBox.Show("添加成功!");
empInfoForm.eif.Enabled = true;
empInfoForm.eif.DBDataGrid();
this.Close();
}
}
else
{
MessageBox.Show("员工编号已存在！");
}
}
else
{
MessageBox.Show("员工编号格式不正确!");
}
}
#endregion
#region 修改记录
if(empInfoForm.empID == "update")
{
if(this.Phone_txt.Text.Trim() != "")
{
if(Regexlib.IsValidPhono(this.Phone_txt.Text.Trim()))
{
string [] str = new string[4];
str[0] = "update EmployInfo set rId=" + int.Parse(this.RaceId_txt.Text.Trim()) + ",sId=" + int.Parse(this.SectionId_txt.Text.Trim());
str[0] += ",jId=" + int.Parse(this.JobId_txt.Text.Trim()) + ",tId=" + int.Parse(this.TitleId_txt.Text.Trim()) + ",eName='";
str[0] += this.Name_txt.Text.Trim() + "',eSex='" + this.Sex_cb.Text + "',eParty='" + this.Party_cb.Text + "',eBirth='" + this.Birth_dtp.Value.ToShortDateString();
str[0] += "',ePlace='" + this.Place_cb.Text + "',eEmpTime='" + this.EmpTime_dtp.Value.ToShortDateString() + "',eEmpType='" + this.EmpType_cb.Text + "',eEmpDataSource='";
str[0] += this.Source_cb.Text + "',eNumber='" + this.Number_txt.Text.Trim() + "',ePhone='" + this.Phone_txt.Text.Trim() + "',eAddress='";
str[0] += this.Adress_txt.Text + "',eMarriage='" + this.Marrige_cb.Text + "',eEdu='" + this.Edu_cb.Text + "',ePro='" + this.Pro_cb.Text;
str[0] += "',eSchool='" + this.School_txt.Text + "',eDate='" + this.LeaveSchool_dtp.Value.ToShortDateString() + "',eDegree='" + this.Degree_cb.Text + "',eApp='";
str[0] += this.App_cb.Text + "' where eId=" + int.Parse(this.No_txt.Text);
str[1] = "update EndowmentInfo set enId=" + int.Parse(this.EenMen_txt.Text.Trim()) + " where endId=" + int.Parse(this.No_txt.Text.Trim());
str[2] = "update MedicalInfo set mId=" + int.Parse(this.Med_txt.Text.Trim()) + " where meId=" + int.Parse(this.No_txt.Text.Trim());
str[3] = "update WagesInfo set ID=" + int.Parse(this.Wa_txt.Text.Trim()) + " where waId=" + int.Parse(this.No_txt.Text.Trim());;
Base b = new Base();
b.ExeSQLs(str);
MessageBox.Show("修改成功!");
empInfoForm.eif.Enabled = true;
empInfoForm.eif.DBDataGrid();
this.Close();
}
else
{
MessageBox.Show("电话号码格式错误!");
}
}
else
{
string [] str = new string[4];
str[0] = "update EmployInfo set rId=" + int.Parse(this.RaceId_txt.Text.Trim()) + ",sId=" + int.Parse(this.SectionId_txt.Text.Trim());
str[0] += ",jId=" + int.Parse(this.JobId_txt.Text.Trim()) + ",tId=" + int.Parse(this.TitleId_txt.Text.Trim()) + ",eName='";
str[0] += this.Name_txt.Text.Trim() + "',eSex='" + this.Sex_cb.Text + "',eParty='" + this.Party_cb.Text + "',eBirth='" + this.Birth_dtp.Value.ToShortDateString();
str[0] += "',ePlace='" + this.Place_cb.Text + "',eEmpTime='" + this.EmpTime_dtp.Value.ToShortDateString() + "',eEmpType='" + this.EmpType_cb.Text + "',eEmpDataSource='";
str[0] += this.Source_cb.Text + "',eNumber='" + this.Number_txt.Text.Trim() + "',ePhone='" + this.Phone_txt.Text.Trim() + "',eAddress='";
str[0] += this.Adress_txt.Text + "',eMarriage='" + this.Marrige_cb.Text + "',eEdu='" + this.Edu_cb.Text + "',ePro='" + this.Pro_cb.Text;
str[0] += "',eSchool='" + this.School_txt.Text + "',eDate='" + this.LeaveSchool_dtp.Value.ToShortDateString() + "',eDegree='" + this.Degree_cb.Text + "',eApp='";
str[0] += this.App_cb.Text + "' where eId=" + int.Parse(this.No_txt.Text);
str[1] = "update EndowmentInfo set enId=" + int.Parse(this.EenMen_txt.Text.Trim()) + " where endId=" + int.Parse(this.No_txt.Text.Trim());
str[2] = "update MedicalInfo set mId=" + int.Parse(this.Med_txt.Text.Trim()) + " where meId=" + int.Parse(this.No_txt.Text.Trim());
str[3] = "update WagesInfo set ID=" + int.Parse(this.Wa_txt.Text.Trim()) + " where waId=" + int.Parse(this.No_txt.Text.Trim());;
Base b = new Base();
b.ExeSQLs(str);
MessageBox.Show("修改成功!");
empInfoForm.eif.Enabled = true;
empInfoForm.eif.DBDataGrid();
this.Close();
}
}
#endregion
}
#endregion
#region 民族下拉菜单索引变化RaceId_txt的内容相应的变化
private void Race_cb_SelectedIndexChanged(object sender, System.EventArgs e)
{
string s = "select * from RaceInfo";
DataTable dt = new DataTable();
Base bb = new Base();
dt = bb.ExeSQLdt(s);
for(int i = 0 ; i < dt.Rows.Count ; i ++)
{
if(this.Race_cb.Text == dt.Rows[i]["rName"].ToString())
{
this.RaceId_txt.Text = dt.Rows[i]["rId"].ToString();
break;
}
}
}
#endregion
#region 部门下拉菜单索引变化SectionId_txt的内容相应的变化
private void Section_cb_SelectedIndexChanged(object sender, System.EventArgs e)
{
string s = "select * from SectionInfo";
DataTable dt = new DataTable();
Base bb = new Base();
dt = bb.ExeSQLdt(s);
for(int i = 0 ; i < dt.Rows.Count ; i ++)
{
if(this.Section_cb.Text == dt.Rows[i]["sName"].ToString())
{
this.SectionId_txt.Text = dt.Rows[i]["sId"].ToString();
break;
}
}
}
#endregion
#region 职务下拉菜单索引变化JobId_txt的内容相应的变化
private void Job_cb_SelectedIndexChanged(object sender, System.EventArgs e)
{
string s = "select * from JobInfo";
DataTable dt = new DataTable();
Base bb = new Base();
dt = bb.ExeSQLdt(s);
for(int i = 0 ; i < dt.Rows.Count ; i ++)
{
if(this.Job_cb.Text == dt.Rows[i]["JName"].ToString())
{
this.JobId_txt.Text = dt.Rows[i]["jId"].ToString();
break;
}
}
}
#endregion
#region 职称下拉菜单索引变化TitleId_txt的内容相应的变化
private void Title_cb_SelectedIndexChanged(object sender, System.EventArgs e)
{
string s = "select * from Title";
DataTable dt = new DataTable();
Base bb = new Base();
dt = bb.ExeSQLdt(s);
for(int i = 0 ; i < dt.Rows.Count ; i ++)
{
if(this.Title_cb.Text == dt.Rows[i]["tName"].ToString())
{
this.TitleId_txt.Text = dt.Rows[i]["tId"].ToString();
break;
}
}
}
#endregion
#region 双击相片框选择相片
private void pictureBox1_DoubleClick(object sender, System.EventArgs e)
{
if(openfile.ShowDialog() == DialogResult.OK)
{
this.pictureBox1.Image = Image.FromFile(openfile.FileName);
}
}
#endregion
#region 上传图片
private void button3_Click(object sender, System.EventArgs e)
{
Base b = new Base();
b.WriteImage(openfile.FileName,int.Parse(this.No_txt.Text.Trim()));
MessageBox.Show("保存图片成功！");
}
#endregion
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -