/// <summary>
/// 详细信息的查询
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public async Task <ApiResponse> GetHouseInfo(string id)
{
List <t4_house> list = new List <t4_house>();
List <t4_code> fileds = new t4_code().Select <t4_code>().ToList();
Type typeInfo = typeof(t4_house);
var properties = typeInfo.GetProperties().ToList();
List <t5_history> listHistory = new List <t5_history>();
ApiResponse resp = new ApiResponse(null).OK();
string sqlStr = $@"select * from t4_house where column1 = {id}";
list.AddRange(await dataService.GetAsync <t4_house>(sqlStr));
foreach (var item in list)
{
string sqlHistory = $@"select * from t5_history where houseid = {item.column1}";
listHistory = (await dataService.GetAsync <t5_history>(sqlHistory)).ToList();
listHistory = (listHistory.Where((x, i) => listHistory.FindLastIndex(z => z.codeid == x.codeid) == i)).ToList();
Parallel.ForEach(listHistory, i =>
{
t4_code columnName = fileds.Where(o => o.id == i.codeid).FirstOrDefault();
PropertyInfo proInfo = properties.Where(o => o.Name == columnName.name).FirstOrDefault();
if (proInfo != null)
{
proInfo.SetValue(item, i.value);
}
});
}
resp.Model = list;
return(resp);
}
/// <summary>
/// 分页查询
/// </summary>
/// <param name="queryBody"></param>
/// <param name="index"></param>
/// <param name="pageSize"></param>
/// <returns></returns>
public ResponseModel <Result> GetHouse(int pageIndex, int pageSize)
{
List <t4_code> fileds = new t4_code().Select <t4_code>().ToList();
Type typeInfo = typeof(Result);
var properties = typeInfo.GetProperties().ToList();
List <Result> List = new Result().SelectPart <Result>(typeof(t4_house).Name, pageIndex, pageSize, "column1");
Parallel.ForEach(List, item =>
{
List <t5_history> listHistory = new t5_history(true).Select <t5_history>(item.column1, "houseid");
listHistory = (listHistory.Where((x, i) => listHistory.FindLastIndex(z => z.codeid == x.codeid) == i)).ToList();
Parallel.ForEach(listHistory, i =>
{
t4_code columnName = fileds.Where(o => o.id == i.codeid).FirstOrDefault();
PropertyInfo proInfo = properties.Where(o => o.Name == columnName.name).FirstOrDefault();
if (proInfo != null)
{
proInfo.SetValue(item, i.value);
}
});
});
ResponseModel <Result> resModel = new ResponseModel <Result>(List);
return(resModel);
}