public void ProcessRequest(HttpContext context) { try { context.Response.Clear(); context.Response.ContentType = "application/json"; Models.learnks m = new Models.learnks { sid = Convert.ToInt32(context.Request.QueryString["sid"]), stype = context.Request.QueryString["stype"], page = Convert.ToInt32(context.Request.QueryString["page"]) }; if (Utility.employeeLogin.isLogin) { string data = BLL.learn.learnsxBLL.exeLearnks(m); if (string.IsNullOrEmpty(data)) { context.Response.Write("null"); } else { context.Response.Write(data); } } else { throw new Exception(JsonConvert.SerializeObject(new { state = 4001, msg = "没有访问权限" })); } } catch (Exception m) { context.Response.Write(m.Message); } finally { context.Response.End(); } }
/// <summary> /// 获得快速背题 /// </summary> /// <param name="m"></param> /// <param name="count"></param> /// <returns></returns> public static string exeLearnks(Models.learnks m) { using (DAL.learn.learnsxDAL dal = new DAL.learn.learnsxDAL()) { using (Common.JsonParse jp = new Common.JsonParse()) { int count = 0; DataTable dt = dal.exeLearnks(m, out count); return(jp.ToTablePage(dt, count)); } } }
/// <summary> /// 获得快速背题 /// </summary> /// <param name="m"></param> /// <param name="count"></param> /// <returns></returns> public DataTable exeLearnks(Models.learnks m, out int count) { SqlParameter[] pars = { new SqlParameter("@sid", m.sid), new SqlParameter("@stype", m.stype), new SqlParameter("@pageNo", m.page), new SqlParameter("@groups", SqlDbType.Int) }; pars[3].Direction = ParameterDirection.Output; DataTable dt = SqlHelper.RunProcedure("[ln_learnks]", pars); count = Convert.ToInt32(pars[3].Value); return(dt); }