private List <FBPaperItem> GetFBItem()
{
//List<TrainFBQuestion> question= _DalFBQues.GetFBQuestionByConditon(string.Empty, -1);
FeedBackPaper paper = _IFeedBackPaper.GetFeedBackPaperById(_Course.CourseFeedBackPaper.FeedBackPaperId);
if (paper == null || paper.FBQuestions == null)
{
return(new List <FBPaperItem>());
}
List <TrainFBQuestion> question = paper.FBQuestions;
List <FBPaperItem> paperItems = new List <FBPaperItem>();
foreach (TrainFBQuestion ques in question)
{
if (ques.FBItems.Count != 0 && ques.FBItems != null)
{
FBPaperItem item = new FBPaperItem();
item.FBQuestion = ques.Description;
item.FBQueItems = GetItemString(ques.FBItems);
item.Worths = GetItemWorth(ques.FBItems);
paperItems.Add(item);
}
}
return(paperItems);
}
/// <summary>
/// 新增课程反馈题目
/// </summary>
/// <param name="courseId"></param>
/// <param name="item"></param>
/// <returns></returns>
private static int InsertCourseFB(int courseId, FBPaperItem item)
{
int pkid;
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.Parameters.Add(_PKID, SqlDbType.Int).Direction = ParameterDirection.Output;
sqlCommand.Parameters.Add(_CourseID, SqlDbType.Int).Value = courseId;
sqlCommand.Parameters.Add(_FBQues, SqlDbType.NVarChar, 200).Value = item.FBQuestion;
sqlCommand.Parameters.Add(_FBItems, SqlDbType.NVarChar, 2000).Value = item.FBQueItems;
sqlCommand.Parameters.Add(_FBItemsScore, SqlDbType.NVarChar, 50).Value = item.Worths;
SqlHelper.ExecuteNonQueryReturnPKID("CourseFBInsert", sqlCommand, out pkid);
return(pkid);
}
private static List <FBPaperItem> GetFBPaperItem(int courseId)
{
List <FBPaperItem> items = new List <FBPaperItem>();
SqlCommand sqlCommmand = new SqlCommand();
sqlCommmand.Parameters.Add(_CourseID, SqlDbType.Int).Value = courseId;
using (SqlDataReader sdr = SqlHelper.ExecuteReader("GetCourseFBByCourseID", sqlCommmand))
{
while (sdr.Read())
{
FBPaperItem item = new FBPaperItem();
item.FBPaperItemId = (Int32)sdr[_DBPKID];
item.FBQuestion = sdr[_DBFBQues].ToString();
item.FBQueItems = sdr[_DBFBItems].ToString();
item.Worths = sdr[_DBFBItemsScore].ToString();
items.Add(item);
}
}
return(items);
}
