public int AddStudent(StudentInf studentInf)
{
SqlParameter[] parms =
{
MakeInParm(ST_ID, SqlDbType.VarChar, 20, studentInf.St_Id),
MakeInParm(CL_ID, SqlDbType.Char, 30, studentInf.Cl_Id),
MakeInParm(ST_NAME, SqlDbType.VarChar, 20, studentInf.St_Name),
MakeInParm(ST_SEX, SqlDbType.Char, 2, studentInf.St_Sex),
MakeInParm(ST_BIRTHDAY, SqlDbType.DateTime, 0, studentInf.St_Birthday),
MakeInParm(MZ_NAME, SqlDbType.VarChar, 16, studentInf.Mz_Name),
MakeInParm(ST_IDENTTITY, SqlDbType.Char, 18, studentInf.St_Identity),
MakeInParm(ST_TEL, SqlDbType.Char, 11, studentInf.St_Tel),
MakeInParm(ST_PROVINCE, SqlDbType.VarChar, 10, studentInf.St_Province),
MakeInParm(ST_FACE, SqlDbType.VarChar, 10, studentInf.St_Face),
MakeInParm(ST_ADDRESS, SqlDbType.VarChar, 20, studentInf.St_Address),
MakeInParm(ST_REMARK, SqlDbType.VarChar, 600, studentInf.St_Remark)
};
try
{
return(ExecProc("AddStudent", parms));
}
catch
{
return(0);
}
}
protected void btnAddStudent_Click(object sender, EventArgs e)
{
try
{
birthday = Convert.ToDateTime(txtBirthday.Text);
StudentInf studentInf = new StudentInf(txtStudentNumber.Text, ddlClass.SelectedValue, txtStudentName.Text, ddlSex.SelectedItem.Value, birthday, txtIdentity.Text, txtTel.Text, ddlProvince.SelectedValue, ddlStuFace.SelectedItem.Text, ddlMingZu.SelectedValue, txtHomeAddress.Text, txtRemark.Text);
student.AddStudent(studentInf);
}
catch
{
JScript.AlertAndRedirect("日期格式错误!", "AddStudent.aspx");
}
}
public void AddStudent(StudentInf studentInf)
{
int result = student.AddStudent(studentInf);
switch (result)
{
case 1: JScript.AlertAndRedirect("添加学生成功!", "AddStudent.aspx");
break;
case -2: JScript.Alert("添加失败,该学号已经存在,请换其他学号");
JScript.GoHistory(-1);
break;
case 0: JScript.Alert("添加失败,请仔细检查输入!");
JScript.GoHistory(-1);
break;
}
}
