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;
}
}
