📄 f_manfile.cs
字号:
}
private void button8_Click(object sender, EventArgs e)
{
S_Photo.Image = null;
imgBytesIn = new byte[65536];
Ima_n = 2;
}
private void button2_Click(object sender, EventArgs e)
{
hold_n = 1;
if (tabControl1.SelectedTab.Name == "tabPage2")
{
MyMC.Clear_Control(this.groupBox7.Controls);
Part_ID = MyMC.GetAutocoding("tb_WordResume", "ID"); //自动添加编号;
}
if (tabControl1.SelectedTab.Name == "tabPage3")
{
MyMC.Clear_Control(this.groupBox10.Controls);
Part_ID = MyMC.GetAutocoding("tb_Family", "ID"); //自动添加编号;
}
if (tabControl1.SelectedTab.Name == "tabPage4")
{
MyMC.Clear_Control(this.groupBox12.Controls);
Part_ID = MyMC.GetAutocoding("tb_TrainNote", "ID"); //自动添加编号;
}
if (tabControl1.SelectedTab.Name == "tabPage5")
{
MyMC.Clear_Control(this.groupBox14.Controls);
Part_ID = MyMC.GetAutocoding("tb_RANDP", "ID"); //自动添加编号;
}
MyMC.Ena_Button(Part_Add, Part_Amend, Part_Cancel, Part_Save, 1, 0, 1, 1);
}
private void Part_Save_Click(object sender, EventArgs e)
{
string s = "";
if (tabControl1.SelectedTab.Name == "tabPage2")
{
s = "ID,Sut_ID,BeginDate,EndDate,Branch,Business,WordUnit";
//"select Sut_ID,ID,BeginDate as 开始时间,EndDate as 结束时间, Branch as 部门, Business as 职务, WordUnit as 工作单位 from tb_WordResume
ModuleClass.MyModule.ADDs = "";
if (hold_n == 2)
{
if (dataGridView2.RowCount < 2)
{
MessageBox.Show("数据表为空，不可以修改");
}
else
Part_ID = dataGridView2[1, dataGridView2.CurrentCell.RowIndex].Value.ToString();
}
MyMC.Part_SaveClass(s, tem_ID, Part_ID, this.groupBox7.Controls, "Word_","tb_WordResume", 7, hold_n);
}
if (tabControl1.SelectedTab.Name == "tabPage3")
{
s = "ID,Sut_ID,LeaguerName,Nexus,BirthDate,WordUnit,Business,Visage,Phone";
ModuleClass.MyModule.ADDs = "";
if (hold_n == 2)
{
if (dataGridView3.RowCount < 2)
{
MessageBox.Show("数据表为空，不可以修改");
}
else
Part_ID = dataGridView3[1, dataGridView3.CurrentCell.RowIndex].Value.ToString();
}
MyMC.Part_SaveClass(s, tem_ID, Part_ID, this.groupBox10.Controls, "Famity_", "tb_Family", 9, hold_n);
}
if (tabControl1.SelectedTab.Name == "tabPage4")
{
s = "ID,Sut_ID,TrainFashion,BeginDate,EndDate,Speciality,TrainUnit,KulturMemo,Charge,Effect";
ModuleClass.MyModule.ADDs = "";
if (hold_n == 2)
{
if (dataGridView4.RowCount < 2)
{
MessageBox.Show("数据表为空，不可以修改");
}
else
Part_ID = dataGridView4[1, dataGridView4.CurrentCell.RowIndex].Value.ToString();
}
MyMC.Part_SaveClass(s, tem_ID, Part_ID, this.groupBox12.Controls, "TrainNote_", "tb_TrainNote", 10, hold_n);
}
if (tabControl1.SelectedTab.Name == "tabPage5")
{
s = "ID,Sut_ID,RPKind,RPDate,SealMan,QuashDate,QuashWhys";
ModuleClass.MyModule.ADDs = "";
if (hold_n == 2)
{
if (dataGridView5.RowCount < 2)
{
MessageBox.Show("数据表为空，不可以修改");
}
else
Part_ID = dataGridView5[1, dataGridView5.CurrentCell.RowIndex].Value.ToString();
}
MyMC.Part_SaveClass(s, tem_ID, Part_ID, this.groupBox14.Controls, "RANDP_", "tb_RANDP", 7, hold_n);
}
if (ModuleClass.MyModule.ADDs != "")
MyDataClass.getsqlcom(ModuleClass.MyModule.ADDs);
Part_Cancel_Click(sender, e);
}
private void Part_Amend_Click(object sender, EventArgs e)
{
hold_n = 2;
MyMC.Ena_Button(Part_Add, Part_Amend, Part_Cancel, Part_Save, 0, 1, 1, 1);
}
private void Part_Cancel_Click(object sender, EventArgs e)
{
if (tabControl1.SelectedTab.Name == "tabPage2")
{
DataSet WDset = MyDataClass.getDataSet("select Sut_ID,ID,BeginDate as 开始时间,EndDate as 结束时间, Branch as 部门, Business as 职务, WordUnit as 工作单位 from tb_WordResume where Sut_ID='" + tem_ID + "'", "tb_WordResume");
MyMC.Correlation_Table(WDset, dataGridView2);
}
if (tabControl1.SelectedTab.Name == "tabPage3")
{
DataSet FDset = MyDataClass.getDataSet("select Sut_ID,ID,LeaguerName as 家庭成员名称,Nexus as 与本人的关系, BirthDate as 出生日期, WordUnit as 工作单位, Business as 职务, Visage as 政治面貌, Phone as 电话 from tb_Family where Sut_ID='" + tem_ID + "'", "tb_Family");
MyMC.Correlation_Table(FDset, dataGridView3);
}
if (tabControl1.SelectedTab.Name == "tabPage4")
{
DataSet TDset = MyDataClass.getDataSet("select Sut_ID,ID,TrainFashion as 培训方式,BeginDate as 培训开始时间, EndDate as 培训结束时间, Speciality as 培训专业, TrainUnit as 培训单位, KulturMemo as 培训内容, Charge as 费用, Effect as 效果 from tb_TrainNote where Sut_ID='" + tem_ID + "'", "tb_TrainNote");
MyMC.Correlation_Table(TDset, dataGridView4);
}
if (tabControl1.SelectedTab.Name == "tabPage5")
{
DataSet RDset = MyDataClass.getDataSet("select Sut_ID,ID,RPKind as 奖惩种类,RPDate as 奖惩时间, SealMan as 批准人, QuashDate as 撤消时间, QuashWhys as 撤消原因 from tb_RANDP where Sut_ID='" + tem_ID + "'", "tb_RANDP");
MyMC.Correlation_Table(RDset, dataGridView5);
}
hold_n = 0; //恢复原始标识
MyMC.Ena_Button(Part_Add, Part_Amend, Part_Cancel, Part_Save, 1, 1, 0, 0);
}
private void dataGridView2_CellEnter(object sender, DataGridViewCellEventArgs e)
{
MyMC.Show_DGrid(dataGridView2, groupBox7.Controls, "Word_");
}
private void S_Pact_B_Leave(object sender, EventArgs e)
{
MyMC.Estimate_Date((MaskedTextBox)sender);
}
private void S_Pact_B_KeyPress(object sender, KeyPressEventArgs e)
{
MyMC.Estimate_Key(e, "", 0);
}
private void S_Pact_E_KeyPress(object sender, KeyPressEventArgs e)
{
MyMC.Estimate_Key(e, "", 0);
}
private void S_Pact_E_Leave(object sender, EventArgs e)
{
bool TDate = MyMC.Estimate_Date((MaskedTextBox)sender);
if (TDate == true)
if (MyMC.Date_Format(S_27.Text) != "" && MyMC.Date_Format(S_28.Text) != "")
{
if (Convert.ToDateTime(S_28.Text) <= Convert.ToDateTime(S_27.Text))
MessageBox.Show("当前日期必须大于它前一个日期。");
}
}
private void S_GraduateDate_Leave(object sender, EventArgs e)
{
MyMC.Estimate_Date((MaskedTextBox)sender);
}
private void S_GraduateDate_KeyPress(object sender, KeyPressEventArgs e)
{
MyMC.Estimate_Key(e, "", 0);
}
private void S_Workdate_Leave(object sender, EventArgs e)
{
MyMC.Estimate_Date((MaskedTextBox)sender);
}
private void S_Workdate_KeyPress(object sender, KeyPressEventArgs e)
{
MyMC.Estimate_Key(e, "", 0);
}
private void S_M_Pay_KeyPress(object sender, KeyPressEventArgs e)
{
MyMC.Estimate_Key(e, ((TextBox)sender).Text, 1);
}
private void S_Pact_Y_KeyPress(object sender, KeyPressEventArgs e)
{
MyMC.Estimate_Key(e, "", 0);
}
private void S_Age_KeyPress(object sender, KeyPressEventArgs e)
{
MyMC.Estimate_Key(e, "", 0);
}
private void S_WorkLength_KeyPress(object sender, KeyPressEventArgs e)
{
MyMC.Estimate_Key(e, "", 0);
}
private void Part_Delete_Click(object sender, EventArgs e)
{
string Delete_Table = "";
string Delete_ID = "";
if (tabControl1.SelectedTab.Name == "tabPage2")
{
if (dataGridView2.RowCount < 2)
{
MessageBox.Show("数据表为空，不可以删除。");
return;
}
MyMC.Clear_Control(this.groupBox7.Controls);
Delete_ID = dataGridView2[1, dataGridView2.CurrentCell.RowIndex].Value.ToString();
Delete_Table="tb_WordResume";
}
if (tabControl1.SelectedTab.Name == "tabPage3")
{
if (dataGridView3.RowCount < 2)
{
MessageBox.Show("数据表为空，不可以删除。");
return;
}
MyMC.Clear_Control(this.groupBox10.Controls);
Delete_ID = dataGridView3[1, dataGridView3.CurrentCell.RowIndex].Value.ToString();
Delete_Table = "tb_Family";
}
if (tabControl1.SelectedTab.Name == "tabPage4")
{
if (dataGridView4.RowCount < 2)
{
MessageBox.Show("数据表为空，不可以删除。");
return;
}
MyMC.Clear_Control(this.groupBox12.Controls);
Delete_ID = dataGridView4[1, dataGridView4.CurrentCell.RowIndex].Value.ToString();
Delete_Table = "tb_TrainNote";
}
if (tabControl1.SelectedTab.Name == "tabPage5")
{
if (dataGridView5.RowCount < 2)
{
MessageBox.Show("数据表为空，不可以删除。");
return;
}
MyMC.Clear_Control(this.groupBox14.Controls);
Delete_ID = dataGridView5[1, dataGridView5.CurrentCell.RowIndex].Value.ToString();
Delete_Table = "tb_RANDP";
}
if ((Delete_ID.Trim()).Length > 0)
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -