/// <summary>
/// 确定提交按钮
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btSubmitSubject_Click(object sender, EventArgs e)
{
Forum thisForum = new Forum();
Search search = new Search();
SubjectInfo subject = new SubjectInfo();
Teacher t = new Teacher();
if (Session["UserName"] != null)
{
//课程名
subject.StrCourseName = course;
//提交时间
subject.DtReleaseTime = DateTime.Now;
//提交内容
subject.StrContents = tbxSubjectContent.Text.Replace("\r\n", "<br/>");
//用户名
if (Convert.ToString(Session["Type"]) == "Student")
{
subject.StrReleasePsnName = search.GetStudentByUsername(Convert.ToString(Session["UserName"])).StrStudentName;
}
else
{
subject.StrReleasePsnName = t.GetTeacherByUserName(Convert.ToString(Session["UserName"])).StrTeacherName;
}
//主题
subject.StrTheme = subjectname.Text.Trim();
if (thisForum.AddSubeject(subject))
{
//Page.ClientScript.RegisterStartupScript(this.GetType(), "Alert","<script>alert('发表成功！')</script>");
Response.Redirect("SubjectList.aspx");
}
else
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "Alert", "<script>alert('发表失败！')</script>");
}
}
else
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "Alert", "<script>alert('您还未登录！')</script>");
//胡媛媛添加，当匿名用户添加留言时清空内容，2009-10-30
subjectname.Text = null;
tbxSubjectContent.Text = null;
}
}
/// <summary>
/// ��������
/// </summary>
/// <param name="mSubject">����ӵ��������</param>
/// <returns>�Ƿ���ӳɹ����ɹ���true,ʧ����false</returns>
public bool AddSubeject(SubjectInfo mSubject)
{
SqlParameter[] parms = {
new SqlParameter("@theme",mSubject.StrTheme),
new SqlParameter("@contents",mSubject.StrContents),
new SqlParameter("@realeasePsnName",mSubject.StrReleasePsnName),
new SqlParameter("@releaseTime",mSubject.DtReleaseTime),
new SqlParameter("@courseName",mSubject.StrCourseName)
};
bool isSuccess = false;
int affectedRows = SQLHelper.ExecuteNonQuery(SQLHelper.ConnectionStringSTEduSys,
CommandType.StoredProcedure, "SP_AddSubject", parms);
if (affectedRows > 0)
{
isSuccess = true;
}
return isSuccess;
}
/// <summary>
/// ��������
/// </summary>
/// <param name="mSubject">����ӵ��������</param>
/// <returns>�Ƿ���ӳɹ����ɹ���true,ʧ����false</returns>
public bool AddSubeject(SubjectInfo mSubject)
{
return dal.AddSubeject(mSubject);
}
/// <summary>
/// ���������Id�õ�����Ķ���
/// </summary>
/// <param name="iSubjectId">�����Id</param>
/// <returns>����Ķ���</returns>
public SubjectInfo GetSubjectById(int iSubjectId)
{
SqlParameter param = new SqlParameter("@subjectID", iSubjectId);
SubjectInfo subject = new SubjectInfo();
using (SqlDataReader dr = SQLHelper.ExecuteReader(SQLHelper.ConnectionStringSTEduSys,
CommandType.StoredProcedure, "SP_GetSubjectByID", param))
{
if (dr.Read())
{
subject.ISubjectId = dr.GetInt32(0);
subject.StrTheme = dr.GetString(1);
subject.StrContents = dr.GetString(2);
subject.StrReleasePsnName = dr.GetString(3);
subject.DtReleaseTime = dr.GetDateTime(4);
}
}
return subject;
}
