public void ProcessRequest(HttpContext context) { evalCourse evalCourse = new evalCourse(); JsonModel jsonModel = new JsonModel(); PagedDataModel<evalCourse> jsonPagedDataModel = new PagedDataModel<evalCourse>(); jc_Public jcPublic = new jc_Public(); int totalcount = 0; var userId = context.Request.QueryString["userId"]; var evalStatus = context.Request.QueryString["evalStatus"]; var PageIndex = context.Request.QueryString["PageIndex"]; var PageSize = context.Request.QueryString["PageSize"]; if (string.IsNullOrEmpty(userId) || string.IsNullOrEmpty(evalStatus) || string.IsNullOrEmpty(PageIndex) || string.IsNullOrEmpty(PageSize)) { jsonModel.Status = "0"; jsonModel.Message = "缺少必要参数!"; } else { string strWhere = "and u.evalUserId=" + userId + " and u.evalStatus=" + evalStatus; string strSql = @" SELECT u.evalUserId, c.evalCourseName, c.evalCourseTeacher, c.evalCourseDate,u.evalStatus,c.evalCourseId, c.evalSurveryId FROM jc_EvaluateCourseUser u, jc_EvaluateCourse c WHERE u.evalCourseId = c.evalCourseId "; jsonPagedDataModel.PagedData = evalCourse.GetevalCourseList(jcPublic.GetList(strSql + strWhere, "evalUserId", int.Parse(PageIndex), int.Parse(PageSize), out totalcount).Tables[0]); jsonPagedDataModel.PageCount = totalcount / int.Parse(PageIndex); jsonPagedDataModel.PageIndex = int.Parse(PageIndex); jsonPagedDataModel.RowCount = totalcount; jsonModel.Data = jsonPagedDataModel; jsonModel.Status = "1"; jsonModel.Message = "查询成功!"; } var js = new JavaScriptSerializer(); context.Response.Write(js.Serialize(jsonModel)); }
/// <summary> /// 得到一个对象实体 /// </summary> public evalCourse DataRowToModel(DataRow row) { var model = new evalCourse(); if (row != null) { if (row["evalUserId"] != null && row["evalUserId"].ToString() != "") { model.evalUserId = int.Parse(row["evalUserId"].ToString()); } if (row["evalCourseName"] != null) { model.evalCourseName = row["evalCourseName"].ToString(); } if (row["evalCourseTeacher"] != null) { model.evalCourseTeacher = row["evalCourseTeacher"].ToString(); } if (row["evalCourseDate"] != null && row["evalCourseDate"].ToString() != "") { model.evalCourseDate = DateTime.Parse(row["evalCourseDate"].ToString()); } if (row["evalStatus"] != null && row["evalStatus"].ToString() != "") { model.evalStatus = int.Parse(row["evalStatus"].ToString()); } if (row["evalCourseId"] != null && row["evalCourseId"].ToString() != "") { model.evalCourseId = int.Parse(row["evalCourseId"].ToString()); } if (row["evalSurveryId"] != null && row["evalSurveryId"].ToString() != "") { model.evalSurveryId = int.Parse(row["evalSurveryId"].ToString()); } } return model; }