/// <summary>
///
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int UpdateStudentGradeCheckApply(StudentsGradeCheckApply model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update usta_StudentsGradeCheckApply set ");
strSql.Append("studentNo=@studentNo,");
strSql.Append("updateTime=@updateTime,");
strSql.Append("courseNo=@courseNo,");
strSql.Append("ClassID=@ClassID,");
strSql.Append("termTag=@termTag,");
strSql.Append("gradeCheckApplyType=@gradeCheckApplyType,");
strSql.Append("applyReason=@applyReason");
strSql.Append(" where gradeCheckApplyId=@gradeCheckApplyId AND studentNo=@studentNo");
SqlParameter[] parameters = {
new SqlParameter("@studentNo", SqlDbType.NChar,10),
new SqlParameter("@updateTime", SqlDbType.DateTime),
new SqlParameter("@courseNo", SqlDbType.NChar,20),
new SqlParameter("@ClassID", SqlDbType.NVarChar,50),
new SqlParameter("@termTag", SqlDbType.NVarChar,50),
new SqlParameter("@gradeCheckApplyType", SqlDbType.NChar,10),
new SqlParameter("@gradeCheckApplyId", SqlDbType.Int,4),
new SqlParameter("@applyReason", SqlDbType.NVarChar,50)};
parameters[0].Value = model.studentNo;
parameters[1].Value = model.updateTime;
parameters[2].Value = model.courseNo;
parameters[3].Value = model.ClassID;
parameters[4].Value = model.termTag;
parameters[5].Value = model.gradeCheckApplyType;
parameters[6].Value = model.gradeCheckApplyId;
parameters[7].Value = model.applyReason;
return SqlHelper.ExecuteNonQuery(conn, CommandType.Text, strSql.ToString(), parameters);
}
/// <summary>
///
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int AddStudentGradeCheckApply(StudentsGradeCheckApply model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into usta_StudentsGradeCheckApply(");
strSql.Append("studentNo,updateTime,courseNo,ClassID,termTag,gradeCheckApplyType,applyReason,applyUpdateTime)");
strSql.Append(" values (");
strSql.Append("@studentNo,@updateTime,@courseNo,@ClassID,@termTag,@gradeCheckApplyType,@applyReason,@applyUpdateTime);");
SqlParameter[] parameters = {
new SqlParameter("@studentNo", SqlDbType.NChar,10),
new SqlParameter("@updateTime", SqlDbType.DateTime),
new SqlParameter("@courseNo", SqlDbType.NChar,20),
new SqlParameter("@ClassID", SqlDbType.NVarChar,50),
new SqlParameter("@termTag", SqlDbType.NVarChar,50),
new SqlParameter("@gradeCheckApplyType", SqlDbType.NChar,10),
new SqlParameter("@applyReason", SqlDbType.NVarChar,50),
new SqlParameter("@applyUpdateTime", SqlDbType.DateTime)};
parameters[0].Value = model.studentNo;
parameters[1].Value = DateTime.Now;
parameters[2].Value = model.courseNo;
parameters[3].Value = model.ClassID;
parameters[4].Value = model.termTag;
parameters[5].Value = model.gradeCheckApplyType;
parameters[6].Value = model.applyReason;
parameters[7].Value = model.applyUpdateTime;
return SqlHelper.ExecuteNonQuery(conn, CommandType.Text, strSql.ToString(), parameters);
}
