📄 formnew.cs
字号:
//
this.txtBoxHomeAdd.Location = new System.Drawing.Point(98, 70);
this.txtBoxHomeAdd.MaxLength = 60;
this.txtBoxHomeAdd.Name = "txtBoxHomeAdd";
this.txtBoxHomeAdd.Size = new System.Drawing.Size(182, 21);
this.txtBoxHomeAdd.TabIndex = 11;
this.txtBoxHomeAdd.Text = "";
this.txtBoxHomeAdd.HelpRequested += new System.Windows.Forms.HelpEventHandler(this.txtBoxHomeAdd_HelpRequested);
//
// pictureBox3
//
this.pictureBox3.Image = ((System.Drawing.Image)(resources.GetObject("pictureBox3.Image")));
this.pictureBox3.Location = new System.Drawing.Point(18, 4);
this.pictureBox3.Name = "pictureBox3";
this.pictureBox3.Size = new System.Drawing.Size(48, 40);
this.pictureBox3.SizeMode = System.Windows.Forms.PictureBoxSizeMode.StretchImage;
this.pictureBox3.TabIndex = 7;
this.pictureBox3.TabStop = false;
//
// label8
//
this.label8.Location = new System.Drawing.Point(80, 22);
this.label8.Name = "label8";
this.label8.Size = new System.Drawing.Size(104, 16);
this.label8.TabIndex = 6;
this.label8.Text = "学生的联系方法";
//
// panel4
//
this.panel4.BackColor = System.Drawing.SystemColors.GrayText;
this.panel4.Location = new System.Drawing.Point(10, 50);
this.panel4.Name = "panel4";
this.panel4.Size = new System.Drawing.Size(436, 1);
this.panel4.TabIndex = 5;
//
// btnSubmit
//
this.btnSubmit.Location = new System.Drawing.Point(309, 292);
this.btnSubmit.Name = "btnSubmit";
this.btnSubmit.Size = new System.Drawing.Size(75, 24);
this.btnSubmit.TabIndex = 1;
this.btnSubmit.Text = "确定";
this.btnSubmit.Click += new System.EventHandler(this.btnSubmit_Click);
//
// btnCancel
//
this.btnCancel.DialogResult = System.Windows.Forms.DialogResult.Cancel;
this.btnCancel.Location = new System.Drawing.Point(397, 292);
this.btnCancel.Name = "btnCancel";
this.btnCancel.Size = new System.Drawing.Size(75, 24);
this.btnCancel.TabIndex = 2;
this.btnCancel.Text = "取消";
this.btnCancel.Click += new System.EventHandler(this.btnCancel_Click);
//
// FormNew
//
this.AcceptButton = this.btnSubmit;
this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
this.CancelButton = this.btnCancel;
this.ClientSize = new System.Drawing.Size(480, 326);
this.Controls.Add(this.btnCancel);
this.Controls.Add(this.btnSubmit);
this.Controls.Add(this.tabControl1);
this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedDialog;
this.HelpButton = true;
this.MaximizeBox = false;
this.MinimizeBox = false;
this.Name = "FormNew";
this.ShowInTaskbar = false;
this.StartPosition = System.Windows.Forms.FormStartPosition.CenterParent;
this.Text = "新建";
this.tabControl1.ResumeLayout(false);
this.tabPage1.ResumeLayout(false);
this.panel2.ResumeLayout(false);
this.tabPage2.ResumeLayout(false);
this.tabPage3.ResumeLayout(false);
this.ResumeLayout(false);
}
#endregion
private void Bind_cmbBoxEnterYear()
{
cmbBoxEnterYear.Items.Clear();
int y = System.DateTime.Now.Year;
for(int i=y; i>y-5; i--)
{
cmbBoxEnterYear.Items.Add(i.ToString()+"年");
}
cmbBoxEnterYear.Text = y.ToString() + "年";
}
private void Bind_cmbBoxCollege()
{
cmbBoxCollege.Items.Clear();
OleDbDataReader objReader = CommandBuilder.BuildOleDbDataReader("Select * From colleges Order By college_ID asc");
while(objReader.Read())
{
cmbBoxCollege.Items.Add(objReader["college_ID"].ToString().Trim() + "-" + objReader["college_name"].ToString().Trim());
}
}
private void Bind_cmbBoxSpeciality(string collegeID)
{
cmbBoxSpeciality.Items.Clear();
string sqlAppend = collegeID=="" ? "":" Where speciality_college='"+collegeID+"'";
OleDbDataReader objReader = CommandBuilder.BuildOleDbDataReader("Select * From speciality" + sqlAppend + " Order By speciality_ID asc");
while(objReader.Read())
{
cmbBoxSpeciality.Items.Add(objReader["speciality_ID"].ToString().Trim() + "-" + objReader["speciality_name"].ToString().Trim());
}
}
private void Bind_cmbBoxClass(string specialityID)
{
cmbBoxClass.Items.Clear();
string sqlApend = specialityID=="" ? "":" Where class_speciality='"+specialityID+"'";
OleDbDataReader objReader = CommandBuilder.BuildOleDbDataReader("Select * From classes" + sqlApend + " Order By class_ID asc");
while(objReader.Read())
{
cmbBoxClass.Items.Add(objReader["class_ID"].ToString().Trim() + "-" + objReader["class_name"].ToString().Trim());
}
}
private void btnCancel_Click(object sender, System.EventArgs e)
{
this.Close();
this.Dispose();
}
private void btnSubmit_Click(object sender, System.EventArgs e)
{
StudentEntity entity = new StudentEntity();
StudentManager manager = new StudentManager();
if(txtBoxName.Text.Trim()!="")
{
entity.StudentName = txtBoxName.Text.Trim();
}
else
{
MessageBox.Show("请输入学生姓名!","提示",MessageBoxButtons.OK,MessageBoxIcon.Warning);
return;
}
entity.StudentSex = rdoBtnMale.Checked ? "男":"女";
if(StringValidation.isChinaIDCardNumString(txtBoxIDCardNum.Text.Trim()))
{
entity.StudentIDCardNum = txtBoxIDCardNum.Text.Trim();
}
else
{
MessageBox.Show("请输入18或15位数字的学生身份证号码!","提示",MessageBoxButtons.OK,MessageBoxIcon.Warning);
return;
}
entity.StudentBirthday = System.DateTime.Parse(dateTimePickerBirth.Text.Trim());
entity.StudentNative = txtBoxNative.Text.Trim();
if(cmbBoxClass.Text!="" && cmbBoxClass.Text!="选择班级")
{
entity.StudentClass = cmbBoxClass.Text.Substring(0,6);
}
else
{
MessageBox.Show("请选择学生所在的班级!","提示",MessageBoxButtons.OK,MessageBoxIcon.Warning);
return;
}
if(StringValidation.isLengthSetNumString(txtBoxStuID.Text.Trim(),2))
{
entity.StudentID = cmbBoxClass.Text.Substring(0,6) + txtBoxStuID.Text.Trim();
}
else
{
MessageBox.Show("请输入学生学号的最后两位数字!","提示",MessageBoxButtons.OK,MessageBoxIcon.Warning);
return;
}
entity.StudentEnterYear = cmbBoxEnterYear.Text.Trim().Substring(0,4);
entity.StudentStuType = cmbBoxStuType.Text.Trim().Substring(0,1);
entity.StudentHomeTel = txtBoxHomeAdd.Text.Trim();
entity.StudentHomeTel = txtBoxHomeTel.Text.Trim();
entity.StudentFlatTel = txtBoxFlatTel.Text.Trim();
entity.StudentMobile = txtBoxMobile.Text.Trim();
if(StringValidation.isEmailString(txtBoxEmail.Text.Trim()))
{
entity.StudentEmail = txtBoxEmail.Text.Trim();
}
else
{
MessageBox.Show("您输入的电子邮件地址不是正确的格式，请重新输入!","提示",MessageBoxButtons.OK,MessageBoxIcon.Warning);
return;
}
try
{
if(manager.Insert(entity)==0)
{
MessageBox.Show("对不起，您输入的学号已经存在，不能添加数据!");
return;
}
else
{
this.DialogResult = DialogResult.OK;
}
}
catch(Exception e1)
{
MessageBox.Show(e1.Message);
return;
}
this.Close();
this.Dispose();
}
private void txtBoxName_HelpRequested(object sender, System.Windows.Forms.HelpEventArgs hlpevent)
{
toolTipHelp.SetToolTip(txtBoxName,"必填项，输入学生姓名!");
toolTipHelp.Active = true;
}
private void txtBoxIDCardNum_HelpRequested(object sender, System.Windows.Forms.HelpEventArgs hlpevent)
{
toolTipHelp.SetToolTip(txtBoxIDCardNum,"必填项，输入18位或15位身份证号码。");
toolTipHelp.Active = true;
}
private void dateTimePickerBirth_HelpRequested(object sender, System.Windows.Forms.HelpEventArgs hlpevent)
{
toolTipHelp.SetToolTip(dateTimePickerBirth,"必填项，按照格式输入或下拉菜单选择出生日期。");
toolTipHelp.Active = true;
}
private void txtBoxNative_HelpRequested(object sender, System.Windows.Forms.HelpEventArgs hlpevent)
{
toolTipHelp.SetToolTip( txtBoxNative,"必填项，输入学生籍贯。");
toolTipHelp.Active = true;
}
private void txtBoxStuID_HelpRequested(object sender, System.Windows.Forms.HelpEventArgs hlpevent)
{
toolTipHelp.SetToolTip(txtBoxStuID,"必填项，输入学生学号的最后两位数字，前六位根据您前面的选项已经确定。");
toolTipHelp.Active = true;
}
private void cmbBoxEnterYear_HelpRequested(object sender, System.Windows.Forms.HelpEventArgs hlpevent)
{
toolTipHelp.SetToolTip(cmbBoxEnterYear,"必填项，输入或选择学生入学年份。");
toolTipHelp.Active = true;
}
private void cmbBoxStuType_HelpRequested(object sender, System.Windows.Forms.HelpEventArgs hlpevent)
{
toolTipHelp.SetToolTip(cmbBoxStuType,"必填项，输入或选择学生学制。");
toolTipHelp.Active = true;
}
private void txtBoxHomeAdd_HelpRequested(object sender, System.Windows.Forms.HelpEventArgs hlpevent)
{
toolTipHelp.SetToolTip(txtBoxHomeAdd,"选填项，输入学生的家庭住址。");
toolTipHelp.Active = true;
}
private void txtBoxHomeTel_HelpRequested(object sender, System.Windows.Forms.HelpEventArgs hlpevent)
{
toolTipHelp.SetToolTip(txtBoxHomeTel,"选填项，输入学生的家庭电话号码。");
toolTipHelp.Active = true;
}
private void txtBoxFlatTel_HelpRequested(object sender, System.Windows.Forms.HelpEventArgs hlpevent)
{
toolTipHelp.SetToolTip(txtBoxFlatTel,"选填项，输入学生的宿舍电话号码。");
toolTipHelp.Active = true;
}
private void txtBoxMobile_HelpRequested(object sender, System.Windows.Forms.HelpEventArgs hlpevent)
{
toolTipHelp.SetToolTip(txtBoxMobile,"选填项，输入学生的移动电话号码。");
toolTipHelp.Active = true;
}
private void txtBoxEmail_HelpRequested(object sender, System.Windows.Forms.HelpEventArgs hlpevent)
{
toolTipHelp.SetToolTip(txtBoxEmail,"选填项，输入学生的电子邮件地址，必须是正确的Email格式。");
toolTipHelp.Active = true;
}
private void cmbBoxCollege_SelectedIndexChanged(object sender, System.EventArgs e)
{
Bind_cmbBoxSpeciality(cmbBoxCollege.Text.Substring(0,2));
cmbBoxSpeciality.Text = "";
cmbBoxClass.Text = "";
}
private void cmbBoxSpeciality_SelectedIndexChanged(object sender, System.EventArgs e)
{
int i = cmbBoxSpeciality.Text.IndexOf("-",3);
Bind_cmbBoxClass(cmbBoxSpeciality.Text.Substring(0,i));
cmbBoxClass.Text = "";
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -