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