public virtual DataTable GetTableDataNoPaged(HttpContext context) { YZRequest request = new YZRequest(context); string dataSourceName = request.GetString("DataSource", null); string tableName = request.GetString("TableName"); string orderBy = request.GetString("OrderBy", null); YZDSFilterCollection filters = JObject.Parse(request.GetString("Filter", "{}")).ToObject <YZDSFilterCollection>(); BPMDBParameterCollection @params = new BPMDBParameterCollection(); if (filters != null) { foreach (KeyValuePair <string, YZDSFilter> filter in filters) { BPMDBParameter paramater = new BPMDBParameter(filter.Key, typeof(String), filter.Value.value); paramater.ParameterCompareType = BPMDBParameter.ParseOp(filter.Value.op, ParameterCompareType.Equ) | ParameterCompareType.NecessaryCondition; @params.Add(paramater); } } using (BPMConnection cn = new BPMConnection()) { cn.WebOpen(); FlowDataTable table = DataSourceManager.LoadTableData(cn, dataSourceName, tableName, @params, orderBy); return(table.ToDataTable()); } }
public virtual JObject GetUserDataTable(BPMConnection cn, JObject request) { string dataSourceName = (string)request["DataSource"]; string tableName = (string)request["TableName"]; string orderBy = (string)request["OrderBy"]; YZDSFilterCollection filters = request["Filter"] != null ? request["Filter"].ToObject <YZDSFilterCollection>() : null; BPMDBParameterCollection @params = new BPMDBParameterCollection(); if (filters != null) { foreach (KeyValuePair <string, YZDSFilter> filter in filters) { BPMDBParameter paramater = new BPMDBParameter(filter.Key, typeof(String), filter.Value.value); paramater.ParameterCompareType = BPMDBParameter.ParseOp(filter.Value.op, ParameterCompareType.Equ) | ParameterCompareType.NecessaryCondition; @params.Add(paramater); } } FlowDataTable table = DataSourceManager.LoadTableData(cn, dataSourceName, tableName, @params, orderBy); return(this.ToResult(table, false)); }