/// <summary> /// 返回访问结果 /// </summary> /// <param name="info"></param> /// <param name="connect"></param> /// <returns></returns> private DataTable GetResult(QueryDepictInfo info, ConnectInfo connect) { ISourceHandle handle = null; switch (connect.connectType) { case SourceTypeEnum.Excel: handle = new ExcelHandle(JObject.Parse(connect.connectStr).ToObject <ExcelLogin>()); break; case SourceTypeEnum.Oracle: handle = new OracleHandle(JObject.Parse(connect.connectStr).ToObject <OracleLogin>()); break; case SourceTypeEnum.SAP: handle = new SapHandle(JObject.Parse(connect.connectStr).ToObject <SapLogin>()); break; case SourceTypeEnum.SqlServer: handle = new SqlServerHandle(JObject.Parse(connect.connectStr).ToObject <SqlServerLogin>()); break; case SourceTypeEnum.WebService: handle = new WebServiceHandle(JObject.Parse(connect.connectStr).ToObject <WebServiceLogin>()); break; default: break; } DataTable dt = new DataTable(); if (handle != null) { dt = handle.GetResult(info); } return(dt); }
/// <summary> /// 返回结果集 /// </summary> /// <param name="context"></param> /// <returns></returns> public JObject GetResult(HttpContext context) { JObject obj = new JObject(); try { YZRequest request = new YZRequest(context); //获取数据连接信息 int connectId = request.GetInt32("connectId"); ConnectInfo con = ConnectInfoManager.GetConnectInfo(connectId); WebServiceLogin login = JObject.Parse(con.connectStr).ToObject <WebServiceLogin>(); ISourceHandle handle = new WebServiceHandle(login); //获取接口信息 string functionName = request.GetString("functionName"); QueryDepictInfo info = handle.GetQueryInfo(functionName); //获取输入输出参数配置 StreamReader reader = new StreamReader(context.Request.InputStream); using (JsonTextReader streamReader = new JsonTextReader(reader)) { //获取参数配置 JsonSerializer serializer = new JsonSerializer(); JArray array = serializer.Deserialize(streamReader) as JArray; JObject jo = array[0] as JObject; JArray parameterArray = jo["parameter"] as JArray; //清空输入参数原始值 CommonHandle.ClearParameter(info.parameter); //配置输入参数值 foreach (JObject item in parameterArray) { ColumnInfo column = info.parameter.First(n => n.columnName == item["columnName"].ToString()); SetParameterValue(column, item); } //判断输出参数是否为无法识别类型 if (CommonHandle.IsSchemaNoType(info.schema)) { info = handle.GetQueryInfo(info); } JArray schemaArray = jo["schema"] as JArray; //清空输出参数原始值 CommonHandle.ClearParameter(info.schema); //配置输出参数值 foreach (JObject item in schemaArray) { ColumnInfo columnInfo = info.schema.First(n => n.columnName == item["columnName"].ToString()); SetOutputInfo(columnInfo, item); } } //获取运行结果 DataTable dt = handle.GetResult(info); JArray results = new JArray(); if (dt.Rows.Count > 0) { foreach (DataRow row in dt.Rows) { JObject item = new JObject(); foreach (DataColumn column in dt.Columns) { item[column.ColumnName] = row[column.ColumnName].ToString(); } results.Add(item); } } else { JObject item = new JObject(); foreach (DataColumn column in dt.Columns) { item[column.ColumnName] = ""; } results.Add(item); } obj["children"] = results; //执行数据 obj[YZJsonProperty.success] = true; return(obj); } catch (Exception ex) { obj[YZJsonProperty.success] = false; obj[YZJsonProperty.errorMessage] = ex.Message; return(obj); } }