private void GetDataList(HttpContext context) { string where = ""; string filters = RDIFramework.WebCommon.PublicMethod.GetString(getObj("filters")); if (filters != "") { string grouptype; IList <SearchFilter> list = SearchFilter.GetSearchList(filters, out grouptype); where = SearchFilter.ToSql(list, grouptype); } int _pageindex = 1; int _pagesize = 20; if (pageindex > 0) { _pageindex = pageindex; } if (pagesize > 0) { _pagesize = pagesize; } int recordCount = 0; DataTable dtException = RDIFrameworkService.Instance.LogService.GetDTByPage(Utils.UserInfo, out recordCount, _pageindex, _pagesize, where, (sortName + " " + sortType)); if (dtException != null && dtException.Rows.Count > 0) { string json = RDIFramework.WebCommon.JSONhelper.FormatJSONForJQgrid(RDIFramework.WebCommon.DbHelper.SqlServer.SqlEasy.GetDataPages(_pagesize, recordCount), _pageindex, recordCount, dtException); context.Response.Write(json); } else { context.Response.Write("系统无异常数据!"); } }
/// <summary> /// 按查询引擎主键列表得到对应的查询引擎定义列表 /// </summary> private void GetDynamicJsonByQueryEngineDefineId(HttpContext context) { try { var queryEngineDefineId = PublicMethod.GetString(WebCommon.StringHelper.GetRequestObject("queryEngineDefineId")); int pageSize = Convert.ToInt32(WebCommon.StringHelper.GetRequestObject("pageSize")); int pageIndex = Convert.ToInt32(WebCommon.StringHelper.GetRequestObject("pageNumber")); //排序字段 string sortName = RDIFramework.Utilities.BusinessLogic.ConvertToString(WebCommon.StringHelper.GetRequestObject("sort")); //排序方式 string sortType = RDIFramework.Utilities.BusinessLogic.ConvertToString(WebCommon.StringHelper.GetRequestObject("order")); var where = ""; var filters = RDIFramework.Utilities.BusinessLogic.ConvertToString(WebCommon.StringHelper.GetRequestObject("filter")); if (!string.IsNullOrEmpty(filters)) { string grouptype; var list = SearchFilter.GetSearchList(filters, out grouptype); where = SearchFilter.ToSql(list, grouptype); } var _pageindex = pageIndex > 0 ? pageIndex : 1; var _pagesize = pageSize > 0 ? pageSize : 10; var recordCount = 0; UserInfo vUser = Utils.UserInfo; QueryEngineDefineEntity queryEngineDefineEntity = RDIFrameworkService.Instance.QueryEngineService.GetQueryEngineDefineEntity(vUser, queryEngineDefineId); CiDbLinkDefineEntity dblinkEntity = null; IDbProvider dbProvider = null; if (queryEngineDefineEntity != null && !string.IsNullOrEmpty(queryEngineDefineEntity.DataBaseLinkName)) { dblinkEntity = RDIFrameworkService.Instance.DbLinkDefineService.GetEntity(vUser, queryEngineDefineEntity.DataBaseLinkName); } if (dblinkEntity != null) { var DbDefine = RDIFrameworkService.Instance.DbLinkDefineService.GetEntityByLinkName(vUser, dblinkEntity.LinkName); dbProvider = DbDefine != null?DbFactoryProvider.GetProvider((CurrentDbType)Enum.Parse(typeof(CurrentDbType), DbDefine.LinkType, true), SecretHelper.AESDecrypt(DbDefine.LinkData)) : DbFactoryProvider.GetProvider(SystemInfo.BusinessDbType, SystemInfo.BusinessDbConnectionString); } var dtDynamicJsonDt = dbProvider.GetDTByPage(out recordCount, queryEngineDefineEntity.QueryString, _pageindex, _pagesize, string.Empty, queryEngineDefineEntity.OrderByField); var JsonData = new { page = _pageindex, total = recordCount, rows = dtDynamicJsonDt }; string returnJson = Newtonsoft.Json.JsonConvert.SerializeObject(JsonData); //{ "columns":"[[ {"field":"field1","title":"title1"},{...} ]]",data:[{page:"pageIndex",total:"totalNum",rows:[{name1:value,name2:value},{...}]}]} returnJson = "{\"columns\":" + CreateDataGridColumnModel(dtDynamicJsonDt) + ",\"data\":[" + returnJson + "]}"; //TODO:待处理,处理异常情况(如:数据库连接失败等),前端应该提示 context.Response.Write(returnJson); } catch (Exception ex) { throw ex; } }