/// <summary>
/// 查询前9项
/// </summary>
/// <param name="index">页数</param>
/// <param name="pagesize">页大小</param>
/// <returns></returns>
public async Task <ResponseModel <T4_House_Part> > QueryPage(GenericQueryModel queryBody, int index, int pagesize)
{
string wheresql = Build(queryBody);
// 获取修改的列
List <t4_code> fileds = await new t4_code().SelectAsync <t4_code>();
// 获取前9项实体属性
Type typeInfo = typeof(T4_House_Part);
var properties = typeInfo.GetProperties().ToList();
// 获取房源
List <T4_House_Part> houseList = new T4_House_Part().SelectPart <T4_House_Part>(typeof(T4_House).Name, index, pagesize, wheresql, "column1");
Parallel.ForEach(houseList, info =>
{
// 获取修改历史信息
List <t4_json> jsonList = new t4_json(true).Select <t4_json>(info.column1, "houseid");
Parallel.ForEach(jsonList, p =>
{
List <T4_ModifyJsonModel> modifyInfoList =
JsonConvert.DeserializeObject <List <T4_ModifyJsonModel> >(p.jsonstr);
T4_ModifyJsonModel mdify = modifyInfoList.OrderByDescending(a => a.Column207).FirstOrDefault();
t4_code columnName = fileds.Where(o => o.id == p.codeid).FirstOrDefault();
PropertyInfo proInfo = properties.Where(o => o.Name == columnName.name).FirstOrDefault();
if (proInfo != null)
{
proInfo.SetValue(info, mdify.Column205);
}
});
});
ResponseModel <T4_House_Part> resModel = new ResponseModel <T4_House_Part>(houseList);
return(resModel);
}
/// <summary>
/// 获取详情信息
/// </summary>
/// <param name="houseId">房屋ID</param>
/// <returns></returns>
public async Task <T4_House_Show> QueryInformation(string houseId)
{
// 获取房屋信息
string sql = $"select * from T4_House where column1='{houseId}'";
T4_House houseModel = await dataService.GetSingleAsync <T4_House>(sql);
// 获取房屋实体类属性
Type typeInfo = typeof(T4_House);
var properties = typeInfo.GetProperties().ToList();
// 获取可修改的列
List <t4_code> modifyColumns = new t4_code().Select <t4_code>();
Parallel.ForEach(modifyColumns, p =>
{
sql = $"select * from t4_json where houseid='{houseId}' and codeid='{p.id}'";
// 获取列修改的信息
List <t4_json> jsonModel = new t4_json(true).Select <t4_json>(sql);
List <T4_ModifyJsonModel> jsonModify = JsonConvert.DeserializeObject <List <T4_ModifyJsonModel> >(jsonModel[0].jsonstr);
T4_ModifyJsonModel mdify = jsonModify.OrderByDescending(a => a.Column207).FirstOrDefault();
PropertyInfo proInfo = properties.Where(o => o.Name == p.name).FirstOrDefault();
if (proInfo != null)
{
// 给房屋信息赋值
proInfo.SetValue(houseModel, mdify.Column205);
}
});
// 获取电话信息
List <t4_tel> telList = new t4_tel().Select <t4_tel>(houseModel.column10, "column202");
T4_House_Show houseShowModel = new T4_House_Show();
BaseModel.Mapper(houseShowModel, houseModel);
houseShowModel.column10 = telList;
return(houseShowModel);
}
public void Add()
{
int id = 0;
for (int i = 1; i <= 400000; i++)
{
for (int j = 1; j <= 5; j++)
{
id++;
t4_json jsonmodel = new t4_json();
List <T2_ModifyLogModel> lst = new List <T2_ModifyLogModel>();
for (int k = 1; k <= 5; k++)
{
T2_ModifyLogModel mmodel = new T2_ModifyLogModel();
mmodel.Column205 = "Column205" + "-" + k.ToString() + j.ToString();
mmodel.Column206 = "Column206" + "-" + k.ToString() + j.ToString();
mmodel.Column207 = "Column207" + "-" + k.ToString() + j.ToString();
lst.Add(mmodel);
}
jsonmodel.id = id;
jsonmodel.houseid = i;
jsonmodel.codeid = j;
jsonmodel.jsonstr = JsonHelper.Instance.Serialize(lst);;
jsonmodel.Insert();
}
}
}
public void Add()
{
int code = 0;
Parallel.For(1, 400001, i =>
{
Parallel.For(1, 6, j =>
{
t4_json jsonmodel = new t4_json();
List <T2_ModifyLogModel> lst = new List <T2_ModifyLogModel>();
Parallel.For(1, 6, k =>
{
T2_ModifyLogModel mmodel = new T2_ModifyLogModel();
mmodel.Column205 = "Column205" + "-" + k.ToString() + j.ToString();
mmodel.Column206 = "Column206" + "-" + k.ToString() + j.ToString();
mmodel.Column207 = "Column207" + "-" + k.ToString() + j.ToString();
lst.Add(mmodel);
});
int id;
lock (locker)
{
id = ++code;
};
jsonmodel.id = id;
jsonmodel.houseid = i;
jsonmodel.codeid = j;
jsonmodel.jsonstr = JsonHelper.Instance.Serialize(lst);;
jsonmodel.Insert();
});
});
//for (int i = 1; i <= 400000; i++)
//{
// for (int j = 1; j <= 5; j++)
// {
// t4_json jsonmodel = new t4_json();
// List<T2_ModifyLogModel> lst = new List<T2_ModifyLogModel>();
// for (int k = 1; i <= 5; i++)
// {
// T2_ModifyLogModel mmodel = new T2_ModifyLogModel();
// mmodel.Column205 = "Column205" + "-" + k.ToString() + j.ToString();
// mmodel.Column206 = "Column206" + "-" + k.ToString() + j.ToString();
// mmodel.Column207 = "Column207" + "-" + k.ToString() + j.ToString();
// lst.Add(mmodel);
// }
// jsonmodel.id = ++code;
// jsonmodel.houseid = i;
// jsonmodel.codeid = j;
// jsonmodel.jsonstr = JsonHelper.Instance.Serialize(lst); ;
// jsonmodel.Insert();
// }
//}
}
