/// <summary>
/// 教师回答学生疑问
/// </summary>
/// <param name="n">答疑实体类</param>
public void Answer(dayi n)
{
SqlParameter[] paras = new SqlParameter[]
{
new SqlParameter("@answerContent", n.AnswerContent),
new SqlParameter("@answerTime", n.AnswerTime),
new SqlParameter("@modifier", n.Modifier),
new SqlParameter("@dayiId", n.DayiId),
};
sqlhelper.ExecuteQuery("UPDATE dayi SET answerContent = @answerContent,modifier=@modifier,answerTime = @answerTime,lastmodify = getdate() where dayiId=@dayiId", paras, CommandType.Text);
}
/// <summary>
/// 学生更新问题
/// </summary>
/// <param name="n">答疑实体类</param>
public void UpdateByStu(dayi n)
{
SqlParameter[] paras = new SqlParameter[]
{
new SqlParameter("@classId", n.ClassId),
new SqlParameter("@modifier", n.Modifier),
new SqlParameter("@dayiName", n.DayiName),
new SqlParameter("@publishTime", n.PublishTime),
new SqlParameter("@questionContent", n.QuestionContent),
new SqlParameter("@dayiId", n.DayiId),
};
sqlhelper.ExecuteQuery("UPDATE dayi SET modifier=@modifier,dayiName = @dayiName,publishTime=@publishTime, questionContent=@questionContent ,lastmodify = getdate() where dayiId=@dayiId ", paras, CommandType.Text);
}
/// <summary>
/// 删除问题
/// </summary>
/// <param name="n">答疑实体类</param>
/// <returns></returns>
public bool Delete(dayi n)
{
bool flag = false;
SqlParameter[] paras = new SqlParameter[]
{
new SqlParameter("@dayiId", n.DayiId),
};
int res = sqlhelper.ExecuteNonQuery("DELETE FROM dayi where dayiId=@dayiId", paras, CommandType.Text);
if (res > 0)
{
flag = true;
}
return(flag);
}
/// <summary>
/// 学生提交问题
/// </summary>
/// <param name="n">答疑实体类</param>
/// <returns></returns>
public bool Insert(dayi n)
{
bool flag = false;
SqlParameter[] paras = new SqlParameter[]
{
new SqlParameter("@classId", n.ClassId),
new SqlParameter("@creater", n.Creater),
new SqlParameter("@modifier", n.Creater),
new SqlParameter("@dayiName", n.DayiName),
new SqlParameter("@publishTime", n.PublishTime),
new SqlParameter("@questionContent", n.QuestionContent),
new SqlParameter("@studentId", n.StudentId),
};
int res = sqlhelper.ExecuteNonQuery("INSERT INTO dayi (classId, creater, modifier, dayiName,publishTime, questionContent, studentId) VALUES (@classId,@creater,@creater,@dayiName,@publishTime,@questionContent,@studentId)", paras, CommandType.Text);
if (res > 0)
{
flag = true;
}
return(flag);
}
/// <summary>
/// 删除问题
/// </summary>
/// <param name="n">答疑实体类</param>
/// <returns></returns>
public bool Delete(dayi n)
{
return(ndao.Delete(n));
}
/// <summary>
/// 教师回答学生疑问
/// </summary>
/// <param name="n">答疑实体类</param>
/// <returns></returns>
public void Answer(dayi n)
{
ndao.Answer(n);
}
/// <summary>
/// 学生更新问题
/// </summary>
/// <param name="n">答疑实体类</param>
/// <returns></returns>
public void UpdateByStu(dayi n)
{
ndao.UpdateByStu(n);
}
/// <summary>
/// 学生提交问题
/// </summary>
/// <param name="n">答疑实体类</param>
/// <returns></returns>
public bool Insert(dayi n)
{
return(ndao.Insert(n));
}
