/// <summary>
/// 获取数据表数据
/// </summary>
/// <param name="_"></param>
/// <returns></returns>
private Response GetDataTable(dynamic _)
{
reqModel req = this.GetReqData <reqModel>();// 获取模板请求数据
var data = dataSourceIBLL.GetDataTable(req.code, "");
string md5 = Md5Helper.Encrypt(data.ToJson(), 32);
if (md5 == req.ver)
{
return(Success("no update"));
}
else
{
var jsondata = new
{
data = data,
ver = md5
};
return(Success(jsondata));
}
}
/// <summary>
/// 获取数据
/// </summary>
/// <param name="_"></param>
/// <returns></returns>
public Response GetSqlData(dynamic _)
{
reqModel req = this.GetReqData <reqModel>();// 获取模板请求数据
switch (req.type)
{
case "Target":
var data = dTTargetIBLL.GetEntity(req.id);
if (data != null && !string.IsNullOrEmpty(data.F_Sql))
{
DataTable dt = databaseLinkIBLL.FindTable(data.F_DataSourceId, data.F_Sql);
var jsonData2 = new
{
Id = req.id,
value = dt.Rows[0][0]
};
return(Success(jsonData2));
}
else
{
var jsonData = new
{
Id = req.id,
value = ""
};
return(Success(jsonData));
}
case "chart":
var chartData = dTChartIBLL.GetEntity(req.id);
if (chartData != null && !string.IsNullOrEmpty(chartData.F_Sql))
{
DataTable dt = databaseLinkIBLL.FindTable(chartData.F_DataSourceId, chartData.F_Sql);
var jsonData2 = new
{
Id = req.id,
value = dt
};
return(Success(jsonData2));
}
else
{
var jsonData = new
{
Id = req.id
};
return(Success(jsonData));
}
case "list":
var listdata = dTListIBLL.GetEntity(req.id);
if (listdata != null && !string.IsNullOrEmpty(listdata.F_Sql))
{
DataTable dt = databaseLinkIBLL.FindTable(listdata.F_DataSourceId, listdata.F_Sql);
var jsonData2 = new
{
Id = req.id,
value = dt
};
return(Success(jsonData2));
}
else
{
var jsonData = new
{
Id = req.id
};
return(Success(jsonData));
}
}
return(Success(new
{
Id = req.id
}));
}
