private void BT_UpdateAnswer_Click(object sender, RoutedEventArgs e)
{
int auswahdg = QS_Anzeige.SelectedIndex;
if ((TB_Answer.Text != listanswers[QS_Anzeige.SelectedIndex].Answerq))
{
string answerAlt = listanswers[auswahdg].Answerq;
Model.answer answerAs = new Model.answer(user.Id, listanswers[auswahdg].QuestionId, listanswers[auswahdg].Question, TB_Answer.Text,
listanswers[auswahdg].Exam_id, DateTime.Now, 0);
//answer(int UserId, int QuestionId, string Question, string Answer, int Exam_id, DateTime Createdon, int Note)
listanswers.RemoveAt(auswahdg);
listanswers.Add(answerAs);
QS_Anzeige.ItemsSource = null;
QS_Anzeige.ItemsSource = listanswers;
}
updateReady = true;
foreach (var answer in listanswers)
{
if (answer.Answerq.Length == 0)
{
updateReady = false; break;
}
}
if (updateReady)
{
BT_SendAnswers.IsEnabled = true;
}
}
/// <summary>
/// 根据新闻ID添加评论
/// </summary>
/// <param name="Ma">实体层answer类的对象</param>
/// <returns>DataSet数据集</returns>
public bool AddAnswerByNewsID(Model.answer Ma)
{
int cindex = 1;
if (GetCindexByNewsID(Ma.newID).Tables[0].Rows[0][0].ToString() == "")
{
cindex = 1;
}
else
{
cindex = int.Parse(GetCindexByNewsID(Ma.newID).Tables[0].Rows[0][0].ToString());
cindex += 1;
}
string strSQL = "insert into answer (A_user,A_qq,A_email,A_word,A_time,newsID,cindex) values ('" + Ma.A_user + "','" + Ma.A_qq + "','" + Ma.A_email + "','" + Ma.A_word + "','" + Ma.A_time + "'," + Ma.newID + "," + cindex + ")";
return(db.ExecuteNonQuery(false, strSQL));
}
/// <summary>
/// 根据新闻ID添加评论
/// </summary>
/// <param name="Ma">实体层answer类的对象</param>
/// <returns>DataSet数据集</returns>
public bool AddAnswerByNewsID(Model.answer Ma)
{
return(DAL_a.AddAnswerByNewsID(Ma));
}
/// <summary>
/// 根据新闻ID删除该新闻的全部评论
/// </summary>
/// <param name="Ma">实体层answer类的对象</param>
/// <returns>true,false</returns>
public bool DeleteAllByNewsID(Model.answer Ma)
{
return(DAL_a.DeleteAllByNewsID(Ma.newID));
}
