/// <summary>
/// 根据Id修改四六级报名相关状态信息
/// </summary>
/// <param name="studentNo"></param>
/// <param name="examPlace"></param>
/// <param name="examType"></param>
/// <param name="englishExamId"></param>
/// <returns></returns>
public int UpdateEnglishExamSignUpState(EnglishExam model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update usta_EnglishExam set ");
strSql.Append("examCertificateState=@examCertificateState,");
strSql.Append("examCertificateRemark=@examCertificateRemark,");
strSql.Append("isPaid=@isPaid,");
strSql.Append("isPaidRemark=@isPaidRemark,");
strSql.Append("grade=@grade,");
strSql.Append("gradeCertificateState=@gradeCertificateState,");
strSql.Append("gradeCertificateRemark=@gradeCertificateRemark ");
strSql.Append(" where englishExamId=@englishExamId");
strSql.Append(" AND studentNo=@studentNo");
strSql.Append(" AND englishExamNotifyId=@englishExamNotifyId;");
SqlParameter[] parameters = {
new SqlParameter("@examCertificateState", SqlDbType.NChar,10),
new SqlParameter("@examCertificateRemark", SqlDbType.NChar,100),
new SqlParameter("@isPaid", SqlDbType.TinyInt,1),
new SqlParameter("@isPaidRemark", SqlDbType.NVarChar,100),
new SqlParameter("@grade", SqlDbType.NChar,10),
new SqlParameter("@gradeCertificateState", SqlDbType.NChar,10),
new SqlParameter("@gradeCertificateRemark", SqlDbType.NVarChar,100),
new SqlParameter("@englishExamId", SqlDbType.Int,4),
new SqlParameter("@studentNo", SqlDbType.NChar,10),
new SqlParameter("@englishExamNotifyId", SqlDbType.Int,4)};
parameters[0].Value = model.examCertificateState;
parameters[1].Value = model.examCertificateRemark;
parameters[2].Value = model.isPaid;
parameters[3].Value = model.isPaidRemark;
parameters[4].Value = model.grade;
parameters[5].Value = model.gradeCertificateState;
parameters[6].Value = model.gradeCertificateRemark;
parameters[7].Value = model.englishExamId;
parameters[8].Value = model.studentNo;
parameters[9].Value = model.englishExamNotifyId;
return SqlHelper.ExecuteNonQuery(conn, CommandType.Text, strSql.ToString(), parameters); ;
}
//修改
protected void btnConfirm_Click(object sender, EventArgs e)
{
try
{
DalOperationAboutEnglishExam dalOperationAboutEnglishExam = new DalOperationAboutEnglishExam();
EnglishExam model = new EnglishExam { studentNo = studentNo, englishExamId = englishExamId, englishExamNotifyId=englishExamNotifyId, examCertificateRemark=txtExamCertificateStateRemark.Text.Trim(), gradeCertificateRemark=txtGradeCertificateStateRemark.Text.Trim(), isPaidRemark=txtIsPaidRemark.Text.Trim(),
grade=txtGrade.Text.Trim(),
gradeCertificateState= ddlGradeCertificate.SelectedValue,
examCertificateState=ddlExamCertificate.SelectedValue,
isPaid = int.Parse(ddlIspaid.SelectedValue)
};
dalOperationAboutEnglishExam.UpdateEnglishExamSignUpState(model);
Javascript.RefreshParentWindow("修改报名相关状态信息成功！", "/Teacher/EnglishExamManage.aspx?fragment=1", Page);
}
catch (Exception ex)
{
MongoDBLog.LogRecord(ex);
Javascript.GoHistory(-1, "修改报名相关状态信息失败,请检查格式是否有误！", Page);
}
}
/// <summary>
/// 根据学号和englishExamId查找相关的四六级报名信息
/// </summary>
/// <returns></returns>
public EnglishExam GetEnglishExamSignUpInfoByStudentNo(string studentNo,int englishExamId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 englishExamId,examCertificateState,examCertificateRemark,isPaid,studentNo,examPlace,examType,grade,gradeCertificateState,gradeCertificateRemark,englishExamNotifyId,englishExamSignUpConfirm from usta_EnglishExam ");
strSql.Append(" where studentNo=@studentNo AND englishExamId=@englishExamId");
SqlParameter[] parameters = {
new SqlParameter("@studentNo", SqlDbType.NChar,10),
new SqlParameter("@englishExamId", SqlDbType.Int,4)
};
parameters[0].Value = studentNo;
parameters[1].Value = englishExamId;
EnglishExam model = new EnglishExam();
DataSet ds = SqlHelper.ExecuteDataset(conn,CommandType.Text,strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["englishExamId"] != null && ds.Tables[0].Rows[0]["englishExamId"].ToString().Trim() != "")
{
model.englishExamId = int.Parse(ds.Tables[0].Rows[0]["englishExamId"].ToString().Trim());
}
if (ds.Tables[0].Rows[0]["examCertificateState"] != null && ds.Tables[0].Rows[0]["examCertificateState"].ToString().Trim() != "")
{
model.examCertificateState = ds.Tables[0].Rows[0]["examCertificateState"].ToString().Trim();
}
if (ds.Tables[0].Rows[0]["examCertificateRemark"] != null && ds.Tables[0].Rows[0]["examCertificateRemark"].ToString().Trim() != "")
{
model.examCertificateRemark = ds.Tables[0].Rows[0]["examCertificateRemark"].ToString().Trim();
}
if (ds.Tables[0].Rows[0]["isPaid"] != null && ds.Tables[0].Rows[0]["isPaid"].ToString().Trim() != "")
{
model.isPaid = int.Parse(ds.Tables[0].Rows[0]["isPaid"].ToString().Trim());
}
if (ds.Tables[0].Rows[0]["studentNo"] != null && ds.Tables[0].Rows[0]["studentNo"].ToString().Trim() != "")
{
model.studentNo = ds.Tables[0].Rows[0]["studentNo"].ToString().Trim();
}
if (ds.Tables[0].Rows[0]["examPlace"] != null && ds.Tables[0].Rows[0]["examPlace"].ToString().Trim() != "")
{
model.examPlace = ds.Tables[0].Rows[0]["examPlace"].ToString().Trim();
}
if (ds.Tables[0].Rows[0]["examType"] != null && ds.Tables[0].Rows[0]["examType"].ToString().Trim() != "")
{
model.examType = ds.Tables[0].Rows[0]["examType"].ToString().Trim();
}
if (ds.Tables[0].Rows[0]["grade"] != null && ds.Tables[0].Rows[0]["grade"].ToString().Trim() != "")
{
model.grade = ds.Tables[0].Rows[0]["grade"].ToString().Trim();
}
if (ds.Tables[0].Rows[0]["gradeCertificateState"] != null && ds.Tables[0].Rows[0]["gradeCertificateState"].ToString().Trim() != "")
{
model.gradeCertificateState = ds.Tables[0].Rows[0]["gradeCertificateState"].ToString().Trim();
}
if (ds.Tables[0].Rows[0]["gradeCertificateRemark"] != null && ds.Tables[0].Rows[0]["gradeCertificateRemark"].ToString().Trim() != "")
{
model.gradeCertificateRemark = ds.Tables[0].Rows[0]["gradeCertificateRemark"].ToString().Trim();
}
if (ds.Tables[0].Rows[0]["englishExamNotifyId"] != null && ds.Tables[0].Rows[0]["englishExamNotifyId"].ToString().Trim() != "")
{
model.englishExamNotifyId = int.Parse(ds.Tables[0].Rows[0]["englishExamNotifyId"].ToString().Trim());
}
if (ds.Tables[0].Rows[0]["englishExamSignUpConfirm"] != null && ds.Tables[0].Rows[0]["englishExamSignUpConfirm"].ToString().Trim() != "")
{
model.englishExamSignUpConfirm = int.Parse(ds.Tables[0].Rows[0]["englishExamSignUpConfirm"].ToString().Trim());
}
return model;
}
else
{
return null;
}
}