public virtual DataTable GetProcedureDataNoPaged(HttpContext context)
{
YZRequest request = new YZRequest(context);
string dataSourceName = request.GetString("DataSource", null);
string procedureName = request.GetString("ProcedureName");
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);
@params.Add(paramater);
}
}
using (BPMConnection cn = new BPMConnection())
{
cn.WebOpen();
FlowDataTable table = DataSourceManager.ExecProcedure(cn, dataSourceName, procedureName, @params);
return(table.ToDataTable());
}
}
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 GetUserDataESB(BPMConnection cn, JObject request)
{
string esbObjectName = (string)request["ESB"];
YZDSFilterCollection filters = request["Filter"] != null ? request["Filter"].ToObject <YZDSFilterCollection>() : null;
//获取参数
string[] strs = esbObjectName.Split(':');
SourceTypeEnum sourceType = (SourceTypeEnum)Enum.Parse(typeof(SourceTypeEnum), strs[0]);
SourceInfo sourceInfo = SourceInfoManager.GetSourceInfo(sourceType, strs[1]);
SourceVisit visit = new SourceVisit(sourceInfo);
BPMObjectNameCollection names = new BPMObjectNameCollection();
List <ColumnInfo> values = new List <ColumnInfo>();
if (filters != null)
{
foreach (KeyValuePair <string, YZDSFilter> filter in filters)
{
names.Add(filter.Key);
values.Add(new ColumnInfo()
{
columnName = filter.Key,
defaultValue = filter.Value.value
});
}
foreach (ColumnInfo column in visit.GetParameter())
{
if (!names.Contains(column.rename))
{
names.Add(column.rename);
values.Add(new ColumnInfo()
{
columnName = column.rename,
defaultValue = column.defaultValue
});
}
}
}
DataTable dt = visit.GetResult(values);
FlowDataTable table = new FlowDataTable(dt);
return(this.ToResult(table, false));
}
public virtual DataTable GetESBDataNoPaged(HttpContext context)
{
YZRequest request = new YZRequest(context);
string esbObjectName = request.GetString("ESB");
YZDSFilterCollection filters = JObject.Parse(request.GetString("Filter", "{}")).ToObject <YZDSFilterCollection>();
//获取参数
string[] strs = esbObjectName.Split(':');
SourceTypeEnum sourceType = (SourceTypeEnum)Enum.Parse(typeof(SourceTypeEnum), strs[0]);
SourceInfo sourceInfo = SourceInfoManager.GetSourceInfo(sourceType, strs[1]);
SourceVisit visit = new SourceVisit(sourceInfo);
BPMObjectNameCollection names = new BPMObjectNameCollection();
List <ColumnInfo> values = new List <ColumnInfo>();
if (filters != null)
{
foreach (KeyValuePair <string, YZDSFilter> filter in filters)
{
names.Add(filter.Key);
values.Add(new ColumnInfo()
{
columnName = filter.Key,
defaultValue = filter.Value.value
});
}
foreach (ColumnInfo column in visit.GetParameter())
{
if (!names.Contains(column.rename))
{
names.Add(column.rename);
values.Add(new ColumnInfo()
{
columnName = column.rename,
defaultValue = column.defaultValue
});
}
}
}
return(visit.GetResult(values));
}
public virtual JObject GetUserDataProcedure(BPMConnection cn, JObject request)
{
string dataSourceName = (string)request["DataSource"];
string procedureName = (string)request["ProcedureName"];
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);
@params.Add(paramater);
}
}
FlowDataTable table = DataSourceManager.ExecProcedure(cn, dataSourceName, procedureName, @params);
return(this.ToResult(table, false));
}
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));
}
