/// <summary>
/// 添加专业类型
/// </summary>
/// <param name="specility">专业信息</param>
public void AddStudentSpecility(StudentSpecility specility)
{
try
{
string strSql = "insert into usta_StudentSpecility(";
strSql += "specilityName) ";
strSql += " values (";
strSql += "@specilityName)";
SqlParameter[] parameters = {
new SqlParameter("@specilityName", SqlDbType.NVarChar,50)};
parameters[0].Value = specility.specilityName;
SqlHelper.ExecuteNonQuery(conn, CommandType.Text, strSql, parameters);
}
catch (Exception ex)
{
MongoDBLog.LogRecord(ex);
CommonUtility.RedirectUrl();
}
finally
{
conn.Close();
}
}
/// <summary>
/// 修改学生专业
/// </summary>
/// <param name="specility">学生专业</param>
public void UpdateStudentSpecility(StudentSpecility specility)
{
try
{
string strSql = "update usta_StudentSpecility set specilityName=@specilityName where specilityId=@specilityId";
SqlParameter[] parameters = new SqlParameter[2]{
new SqlParameter("@specilityId",specility.specilityId),
new SqlParameter("@specilityName",specility.specilityName),
};
SqlHelper.ExecuteNonQuery(conn, CommandType.Text, strSql, parameters);
}
catch (Exception ex)
{
MongoDBLog.LogRecord(ex);
CommonUtility.RedirectUrl();
}
finally
{
conn.Close();
}
}
/// <summary>
/// 根据专业主键查找
/// </summary>
/// <param name="specilityeId">专业主键</param>
/// <returns>专业信息</returns>
public StudentSpecility FindStudentSpecilityById(int specilityeId)
{
StudentSpecility model = null;
string commandstring = "select specilityId,specilityName from usta_StudentSpecility where specilityId=@specilityId";
SqlParameter[] parameters = new SqlParameter[1]{new SqlParameter("@specilityId",specilityeId)
};
SqlDataReader dr = SqlHelper.ExecuteReader(conn, CommandType.Text, commandstring, parameters);
if (dr.Read())
{
model = new StudentSpecility
{
specilityId = int.Parse(dr["specilityId"].ToString().Trim()),
specilityName = dr["specilityName"].ToString().Trim()
};
}
dr.Close();
conn.Close();
return model;
}