public Model.QuestionnaireHead GetModel(int HeadId, int TeacherId)
{
SqlConnection co = SQLSeverOpen();
SqlCommand cmd = new SqlCommand();
cmd.Connection = co;
Model.QuestionnaireHead Questionnaire = new Model.QuestionnaireHead();
Questionnaire.Item = new List <Model.SelectQuestion>();
cmd.CommandText = "select * from [V_SelectQuestion_Question] where QuestionnaireHeadId=@QuestionnaireHeadId";
cmd.Parameters.AddWithValue("@QuestionnaireHeadId", HeadId);
cmd.Connection = co;
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
Model.SelectQuestion item = new Model.SelectQuestion();
item.QuestionHeadId = HeadId;
item.QuestionId = Convert.ToInt32(dr["QuestionId"]);
Model.Question question = new Model.Question();
question.Id = item.QuestionId;
question.Content = Convert.ToString(dr["content"]);
item.Question = question;
Questionnaire.Item.Add(item);
Questionnaire.ScoreList = GetQuestionScore(HeadId, TeacherId);
}
dr.Close();
co.Close();
return(Questionnaire);
}
public JsonResult GetModel(int HeadId, int TeacherId)
{
BLL.QuestionnaireHead bll = new BLL.QuestionnaireHead();
Model.QuestionnaireHead model = bll.GetModel(HeadId, TeacherId);
List <object> fullItem = new List <object>();
for (int i = 0; i < model.Item.Count; i++)
{
Model.SelectQuestion sq = model.Item[i];
Model.Question question = new Model.Question();
question.Id = sq.Question.Id;
question.Content = sq.Question.Content;
object obj = new
{
Question = question,
QuestionHeadId = sq.QuestionHeadId,
AVGScore = model.ScoreList[i] / new BLL.QuestionnaireHead().GetWritenTimes(sq.QuestionHeadId, TeacherId)
};
fullItem.Add(obj);
}
return(Json(new { Item = fullItem }));
//return Json(model);
}
