/// <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(); // } //} }