public void Addt4Tel()
{
int id = 0;
for (int i = 1; i <= 40000; i++)
{
for (int j = 1; j <= 4; j++)
{
id++;
t4_tel model = new t4_tel();
foreach (var p in model.GetType().GetProperties().ToList())
{
if (p.Name == "column201")
{
p.SetValue(model, id);
}
else if (p.Name == "column202")
{
p.SetValue(model, i);
}
else
{
p.SetValue(model, p.Name.ToString() + "-" + i.ToString() + "-" + j.ToString());
}
}
model.Insert();
}
}
}
/// <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);
}
