/// <summary> /// 分页查询 /// </summary> /// <param name="pSpPagingParam">查询参数</param> /// <param name="total">表总条数</param> /// <returns>表格</returns> public DataTable QueryPageTable(SpPagingParam pSpPagingParam, ref int total) { try { MySqlParameter[] parameters = { new MySqlParameter("?p_tablename", MySqlDbType.VarChar, 100), new MySqlParameter("?p_sort", MySqlDbType.VarChar, 100), new MySqlParameter("?p_pagesize", MySqlDbType.Int32), new MySqlParameter("?p_startindex", MySqlDbType.Int32), new MySqlParameter("?p_filter", MySqlDbType.VarChar, 100), new MySqlParameter("?p_fields", MySqlDbType.VarChar, 100), new MySqlParameter("?p_outrows", MySqlDbType.Int32), }; parameters[0].Value = pSpPagingParam.tableName; parameters[1].Value = pSpPagingParam.sort; parameters[2].Value = pSpPagingParam.pageSize; parameters[3].Value = pSpPagingParam.page; parameters[4].Value = pSpPagingParam.whereClause; parameters[5].Value = pSpPagingParam.fields; parameters[6].Direction = ParameterDirection.Output; DataSet ds = new DataSet(); DataTable dtResult = ApplicationManager.DefaultConnection.QueryData("GetDataByPageTABLE", parameters, 1).Tables[0]; total = Convert.ToInt32(parameters[6].Value); return(dtResult); } catch (Exception ex) { throw ex; } }
protected override string OnExecute() { HttpContext context = this.SpContext as HttpContext; try { string tableName = "p_terminal"; //设备表 string fields = "cid,sbbm,sbmc,jxh,jd,wd"; //返回字段 string whereClause = context.Request["keyWord"] ?? ""; //where部分 string strPage = context.Request["start"] ?? "1"; // string strPageSize = context.Request["pageSize"] ?? "15"; string sort = context.Request["sort"] ?? ""; string userName = context.Request["userName"] ?? ""; int page = Convert.ToInt32(strPage); if (page <= 0) { page = 1; } if (!string.IsNullOrEmpty(whereClause)) { whereClause = string.Format("where CONCAT(IFNULL(sbmc,''),' ',IFNULL(sbbm,''),' ',IFNULL(jxh,'')) LIKE '%{0}%'", whereClause); } int pageSize = Convert.ToInt32(strPageSize); SpPagingParam pSpPagingParam = new SpPagingParam() { tableName = tableName, pageSize = pageSize, page = page, sort = sort, whereClause = whereClause, fields = fields }; IUtilService utilService = SpServiceFactory.CreateUtilService(); int total = 0; DataTable dtResult = utilService.QueryPageTable(pSpPagingParam, ref total); return(this.ToJsonP(dtResult.ToStandardJson(true, total, "分页列表数据"))); } catch (Exception ex) { Log.Error("分页查询异常:" + ex.Message.ToString()); throw ex; } }