/// <summary>
/// 返回参数
/// </summary>
/// <param name="context"></param>
/// <returns></returns>
public JObject GetParameter(HttpContext context)
{
JObject obj = new JObject();
try
{
YZRequest request = new YZRequest(context);
//获取数据连接信息
int connectId = request.GetInt32("connectId");
ConnectInfo con = ConnectInfoManager.GetConnectInfo(connectId);
SapLogin login = JObject.Parse(con.connectStr).ToObject <SapLogin>();
ISourceHandle handle = new SapHandle(login);
//接口名称
string rfcName = request.GetString("rfcName");
QueryDepictInfo info = handle.GetQueryInfo(rfcName);
//序列化
JArray parameterArray = new JArray();
obj["parameter"] = parameterArray;
if (info.parameter != null && info.parameter.Count > 0)
{
if (CommonHandle.IsParameterNoType(info.parameter))
{
obj[YZJsonProperty.success] = false;
obj[YZJsonProperty.errorMessage] = "输入参数中有不符合规定的类型，无法进行配置！";
return(obj);
}
foreach (ColumnInfo item in info.parameter)
{
parameterArray.Add(BizCommon.GetColumnJson(item));
}
}
//输出参数
JArray schemaArray = new JArray();
obj["schema"] = schemaArray;
if (info.schema != null && info.schema.Count > 0)
{
foreach (var item in info.schema)
{
schemaArray.Add(BizCommon.GetColumnJson(item));
}
}
else
{
obj[YZJsonProperty.success] = false;
obj[YZJsonProperty.errorMessage] = "该接口没有返回值，不可调用！";
return(obj);
}
obj[YZJsonProperty.success] = true;
return(obj);
}
catch (Exception ex)
{
obj[YZJsonProperty.success] = false;
obj[YZJsonProperty.errorMessage] = ex.ToString();
return(obj);
}
}
/// <summary>
/// 连接sap服务
/// </summary>
/// <param name="context"></param>
/// <returns></returns>
public JObject JoinSap(HttpContext context)
{
JObject obj = new JObject();
YZRequest request = new YZRequest(context);
SapLogin login = new SapLogin();
login.systemName = request.GetString("systemName");
login.SAPRouter = request.GetString("saprouter", "");
login.serverHost = request.GetString("serverHost");
login.systemNumber = request.GetString("systemNumber");
login.client = request.GetString("client");
login.user = request.GetString("user");
login.pwd = request.GetString("pwd");
login.language = request.GetString("language");
string message = null;
bool flag = CommonHandle.IsSapJoin(login, out message);
obj[YZJsonProperty.success] = true;
obj[YZJsonProperty.errorMessage] = flag ? "连接成功！" : String.Format("连接失败！原因：<br/>{0}", message);
return(obj);
}
/// <summary>
/// 保存数据源
/// </summary>
/// <param name="context"></param>
/// <returns></returns>
public JObject SaveSource(HttpContext context)
{
JObject obj = new JObject();
YZRequest request = new YZRequest(context);
try
{
//操作类型
string joinType = request.GetString("joinType");
string sourceName = request.GetString("sourceName");
string caption = request.GetString("caption", "");
int connectId = request.GetInt32("connectId");
int sourceId = request.GetInt32("sourceId", 0);
//判断是否重名
bool isNameOnly = SourceInfoManager.IsSourceNameRepeat(sourceName, SourceTypeEnum.SAP, sourceId);
if (isNameOnly)
{
obj[YZJsonProperty.success] = false;
obj[YZJsonProperty.errorMessage] = "已存在同名的数据源，请重命名数据源名称！";
return(obj);
}
ConnectInfo con = ConnectInfoManager.GetConnectInfo(connectId);
SapLogin login = JObject.Parse(con.connectStr).ToObject <SapLogin>();
ISourceHandle handle = new SapHandle(login);
//获取接口信息
string rfcName = request.GetString("rfcName");
QueryDepictInfo info = handle.GetQueryInfo(rfcName);
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);
}
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);
}
}
if (joinType.ToUpper().Equals("THEEDIT"))
{
SourceInfo sourceInfo = SourceInfoManager.GetSourceInfo(sourceId);
sourceInfo.sourceName = sourceName;
sourceInfo.caption = caption;
sourceInfo.updateTime = DateTime.Now;
sourceInfo.sourceStr = JObject.FromObject(info).ToString();
SourceInfoManager.EditSource(sourceInfo);
}
else
{
SourceInfo sourceInfo = new SourceInfo();
sourceInfo.sourceName = sourceName;
sourceInfo.sourceType = SourceTypeEnum.SAP;
sourceInfo.connectInfo = ConnectInfoManager.GetConnectInfo(connectId);
sourceInfo.caption = caption;
sourceInfo.isvalid = true;
sourceInfo.createTime = DateTime.Now;
sourceInfo.updateTime = DateTime.Now;
sourceInfo.sourceStr = JObject.FromObject(info).ToString();
SourceInfoManager.AddSource(sourceInfo);
}
obj[YZJsonProperty.success] = true;
obj[YZJsonProperty.errorMessage] = "保存成功";
return(obj);
}
catch (Exception ex)
{
obj[YZJsonProperty.success] = false;
obj[YZJsonProperty.errorMessage] = ex.ToString();
return(obj);
}
}
/// <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");
string rfcName = request.GetString("rfcName");
ConnectInfo con = ConnectInfoManager.GetConnectInfo(connectId);
SapLogin login = JObject.Parse(con.connectStr).ToObject <SapLogin>();
ISourceHandle handle = new SapHandle(login);
QueryDepictInfo info = handle.GetQueryInfo(rfcName);
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);
}
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);
}
}
/// <summary>
/// 保存sap数据连接
/// </summary>
/// <param name="context"></param>
/// <returns></returns>
public JObject SaveSapConnect(HttpContext context)
{
JObject obj = new JObject();
YZRequest request = new YZRequest(context);
try
{
//获取操作模式
string joinType = request.GetString("joinType");
//获取连接数据
SapLogin login = new SapLogin();
login.systemName = request.GetString("systemName");
login.serverHost = request.GetString("serverHost");
login.SAPRouter = request.GetString("saprouter", "");
login.systemNumber = request.GetString("systemNumber");
login.client = request.GetString("client");
login.user = request.GetString("user");
login.pwd = request.GetString("pwd");
login.language = request.GetString("language");
string message = null;
if (!CommonHandle.IsSapJoin(login, out message))
{
obj[YZJsonProperty.success] = false;
obj[YZJsonProperty.errorMessage] = "服务无法连接！";
return(obj);
}
if (joinType.ToUpper().Equals("THEEDIT"))
{
//编辑模式
ConnectInfo info = ConnectInfoManager.GetConnectInfo(request.GetInt32("connectId", -1));
info.caption = request.GetString("caption", "");
info.connectStr = JObject.FromObject(login).ToString();
info.updateTime = DateTime.Now;
info.isvalid = true;
//更新
ConnectInfoManager.EditConnect(info);
obj["connectId"] = info.connectId;
}
else
{
//新增模式
if (ConnectInfoManager.IsConnectRepeat(request.GetString("connectName", ""), SourceTypeEnum.SAP))
{
obj[YZJsonProperty.success] = false;
obj[YZJsonProperty.errorMessage] = "已存在同名的数据源";
return(obj);
}
ConnectInfo info = new ConnectInfo();
info.connectName = request.GetString("connectName", "");
info.connectType = SourceTypeEnum.SAP;
info.caption = request.GetString("caption", "");
info.connectStr = JObject.FromObject(login).ToString();
info.createTime = DateTime.Now;
info.updateTime = DateTime.Now;
info.isvalid = true;
//新增
ConnectInfoManager.AddConnect(info);
obj["connectId"] = ConnectInfoManager.GetConnectInfo(SourceTypeEnum.SAP, info.connectName).connectId;
}
obj[YZJsonProperty.success] = true;
obj[YZJsonProperty.errorMessage] = "数据连接保存成功";
return(obj);
}
catch (Exception ex)
{
string msg = string.Format("保存失败:{0}", ex.ToString());
obj[YZJsonProperty.success] = false;
obj[YZJsonProperty.errorMessage] = msg;
return(obj);
}
}
