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