public void MyBind() { M_Exam_Sys_Questions model = questionBll.GetSelect(QID); if (model == null) { function.WriteErrMsg("无效id!"); } Title_L.Text = model.p_title; Grade_L.Text = B_GradeOption.GetGradeOption(model.p_Views).GradeName; Diff_L.Text = questionBll.GetDiffStr(model.p_Difficulty); QType_L.Text = M_Exam_Sys_Questions.GetTypeStr(model.p_Type); if (!string.IsNullOrEmpty(model.Tagkey)) { KeyWord_L.Text = knowBll.GetNamesByIDS(model.Tagkey); } Content_Li.Text = model.p_Content; if (model.p_Type == 10) { Content_Li.Text = model.LargeContent; Option_Li.Visible = false; Quest_RPT.Visible = true; DataTable dt = questionBll.SelByIDSForExam(model.p_id.ToString()); dt.DefaultView.RowFilter = "pid>0"; dt.DefaultView.Sort = "order desc"; Quest_RPT.DataSource = dt; Quest_RPT.DataBind(); } else { Option_Li.Text = questionBll.GetSubmit(model.p_id, model.p_Type, ref AngularJS); } Socre_L.Text = model.p_defaultScores.ToString(); QuestNum_L.Text = model.p_ChoseNum.ToString(); Answer_L.Text = model.p_Answer; AnswerHtml_Li.Text = model.p_shuming; Jiexi_Li.Text = model.Jiexi; }
//根据IDS计算出各类型题的数目,给Js展示 public string GetCountByIDS(string ids) { ids = ids ?? ""; ids = ids.Trim(','); string result = ""; string sql = "SELECT p_Type as type,typestr='',COUNT(*) AS count FROM " + strTableName + " WHERE p_id IN(" + ids + ") GROUP BY p_Type"; if (string.IsNullOrEmpty(ids)) { return(result); } SafeSC.CheckIDSEx(ids); DataTable dt = SqlHelper.ExecuteTable(CommandType.Text, sql); if (dt != null && dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { dt.Rows[i]["typestr"] = M_Exam_Sys_Questions.GetTypeStr(DataConvert.CLng(dt.Rows[i]["type"])); } result = JsonConvert.SerializeObject(dt); } return(result); }
//取题型 public string GetType(string id) { return(M_Exam_Sys_Questions.GetTypeStr(DataConverter.CLng(id))); }