/// <summary>
/// 得到报表查询条件参照数据 web
/// </summary>
/// <param name="reportRequest"></param>
/// <returns></returns>
public BasicResponse <Hashtable> GetFKDataByHashTable(Sys.Safety.Request.ReportGetFKDataByHashTableRequest reportRequest)
{
//如果测点参照要根据开始时间和结束时间过滤已删除的数据即 activitiy=1 or (activitiy=0 && 定义的时间在查询时间范围内)
//则sql语句的条件应该这么写 activitiy=1 or (activitiy=0 && (开始时间 between Createtime and deletetime or 结束时间 between Createtime and deletetime))
BasicResponse <Hashtable> response = new BasicResponse <Hashtable>();
var strFKCode = reportRequest.strFKCode;
DataTable dtfklib = _Repository.QueryTable("global_Report_GetFKDataByHashTable1", new object[] { reportRequest.strFKCode });
if (dtfklib == null || dtfklib.Rows.Count == 0)
{
throw new Exception("未找到参照编码为" + strFKCode + "的记录，请查看参照表配置！");
}
string strsql = Convert.ToString(dtfklib.Rows[0]["strSQL"]);
SqlRequest sqlRequest = new SqlRequest
{
Sql = strsql
};
DataTable dataSource = _SqlService.QueryTableBySql(sqlRequest).Data;
Hashtable lookInfo = new Hashtable();
lookInfo.Add("StrDsiplayMember", Convert.ToString(dtfklib.Rows[0]["StrDsiplayMember"]).Trim());
lookInfo.Add("StrValueMember", Convert.ToString(dtfklib.Rows[0]["StrValueMember"]).Trim());
lookInfo.Add("StrColumns", Convert.ToString(dtfklib.Rows[0]["StrColumns"]).Trim());
lookInfo.Add("StrParentField", Convert.ToString(dtfklib.Rows[0]["StrParentField"]).Trim());
lookInfo.Add("dataSource", ConvertDataTable(dataSource));
//string strReturn = PublicClass.JsonSerializer<Hashtable>(lookInfo);
//测试反序列化
//Hashtable bb = PublicClass.JsonDeserialize<Hashtable>(strReturn);
//DataTable dtaa = PublicClass.JsonDeserialize<DataTable>(bb["dataSource"].ToString());
response.Data = lookInfo;
return(response);
}
public BasicResponse <Hashtable> GetFKDataByHashTable(Sys.Safety.Request.ReportGetFKDataByHashTableRequest reportRequest)
{
var responseStr = HttpClientHelper.Post(Webapi + "/v1/Report/GetFKDataByHashTable?token=" + Token, JSONHelper.ToJSONString(reportRequest));
return(JSONHelper.ParseJSONString <BasicResponse <Hashtable> >(responseStr));
}
public BasicResponse <Hashtable> GetFKDataByHashTable(Sys.Safety.Request.ReportGetFKDataByHashTableRequest reportRequest)
{
return(reportService.GetFKDataByHashTable(reportRequest));
}
