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