/// <summary>
/// 获取Csv数据,支持大数据下载
/// </summary>
/// <param name="inEnt"></param>
/// <param name="sqlStr"></param>
/// <returns></returns>
public async Task <ResultObj <List <byte> > > QueryExecuteCsv(QuerySearchDto inEnt)
{
ResultObj <List <byte> > reObj = new ResultObj <List <byte> >();
List <byte> reEnt = new List <byte>();
SysQueryEntity query = await dal.Single(i => i.code == inEnt.code);
if (query == null)
{
return(reObj);
}
JObject cfg = TypeChange.JsonToObject(query.queryCfgJson);
Dictionary <string, string> dict = new Dictionary <string, string>();
foreach (var item in cfg)
{
try
{
dict.Add(item.Key, item.Value["title"].ToString());
}
catch
{
}
}
string whereStr = "";
string AllSql = MakeSql(inEnt, query.queryConf, ref whereStr);
//如果条件为空
if (!string.IsNullOrEmpty(whereStr))
{
if (!whereStr.Trim().ToLower().StartsWith("where"))
{
whereStr = "where " + whereStr;
}
AllSql = string.Format(@"
SELECT T.* FROM
(
{0}
) T {1}
", AllSql, whereStr);
}
try
{
reObj.msg = AllSql;
reObj.data = dal.ExecuteBytesAsync(AllSql, null, dict);
}
catch (Exception e)
{
reObj.msg = e.Message;
reObj.success = false;
return(reObj);
}
return(reObj);
}
