/// <summary>
/// 生成配置数据
/// </summary>
/// <param name="code"></param>
/// <param name="sqlStr"></param>
/// <returns></returns>
public async Task <ResultObj <string> > MakeQueryCfg(string code)
{
ResultObj <String> reObj = new ResultObj <String>();
QuerySearchDto inEnt = new QuerySearchDto()
{
code = code
};
JObject reEnt = new JObject();
SysQueryEntity query = await dal.Single(i => i.code == inEnt.code);
if (query == null)
{
return(reObj);
}
IList <QueryCfg> cfg = new List <QueryCfg>();
if (!string.IsNullOrEmpty(query.queryCfgJson))
{
cfg = TypeChange.ToJsonObject <List <QueryCfg> >(query.queryCfgJson);
}
string whereStr = "";
string AllSql = MakeSql(inEnt, query.queryConf, ref whereStr);
reObj.msg = MakePageSql(AllSql);
try
{
DataTable dt = dal.GetDataTable(reObj.msg);
for (int i = 0; i < dt.Columns.Count; i++)
{
var t = dt.Columns[i];
var tmp = t.DataType.FullName.ToLower().Substring(t.DataType.FullName.IndexOf(".") + 1);
IList <string> numberList = new[] { "int", "decimal", "double", "int64", "int16" };
if (numberList.Contains(tmp))
{
tmp = "int";
}
string searchType = "";
switch (tmp)
{
case "int":
searchType = "numberbox";
break;
case "datetime":
searchType = "datetimebox";
break;
default:
searchType = "text";
break;
}
JObject itemObj = new JObject();
itemObj["title"] = t.ColumnName;
itemObj["type"] = searchType;
itemObj["editable"] = true;
reEnt[t.ColumnName] = itemObj;
}
reObj.data = reEnt.ToString();
return(reObj);
}
catch
{
return(reObj);
}
}