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)); }