/// <summary> /// 单条200字段查询 /// </summary> /// <param name="id"></param> /// <returns></returns> public async Task <t2_house_expand_copy> GetJsonHouse(string id) { string str = $"select jsonstr from t2_house where JSON_VALUE(jsonstr,'$.Column1')='{id}'"; var result = await dataService.GetSingleAsync <t2_house>(str); t2_house_expand t2Json = JsonConvert.DeserializeObject <t2_house_expand>(result.jsonstr); t2_house_expand_copy exp = new t2_house_expand_copy(); BaseModel.Mapper(exp, t2Json); T2_ModifyLogModel column4 = t2Json.column4.OrderByDescending(a => a.Column207).FirstOrDefault(); T2_ModifyLogModel column5 = t2Json.column5.OrderByDescending(a => a.Column207).FirstOrDefault(); T2_ModifyLogModel column6 = t2Json.column6.OrderByDescending(a => a.Column207).FirstOrDefault(); T2_ModifyLogModel column7 = t2Json.column7.OrderByDescending(a => a.Column207).FirstOrDefault(); T2_ModifyLogModel column8 = t2Json.column8.OrderByDescending(a => a.Column207).FirstOrDefault(); T2_ModifyJsonModel column10 = t2Json.column10.OrderByDescending(a => a.Column204).FirstOrDefault(); exp.column4 = column4.Column205; exp.column5 = column5.Column205; exp.column6 = column6.Column205; exp.column7 = column7.Column205; exp.column8 = column8.Column205; exp.column10 = column10; return(exp); }
public void Add() { for (int i = 1; i <= 400000; i++) { ColumnModel MianModel = new ColumnModel(); foreach (var p in MianModel.GetType().GetProperties().ToList()) { //µç»° if (p.Name == "Column30") { List <T2_ModifyJsonModel> lst = new List <T2_ModifyJsonModel>(); for (int j = 1; j <= 4; j++) { T2_ModifyJsonModel tel = new T2_ModifyJsonModel(); foreach (var t in tel.GetType().GetProperties().ToList()) { t.SetValue(tel, t.Name.ToString() + "-" + j.ToString()); } lst.Add(tel); } p.SetValue(MianModel, lst); } else if (p.Name == "Column4" || p.Name == "Column5" || p.Name == "Column6" || p.Name == "Column7" || p.Name == "Column8" ) { List <T2_ModifyLogModel> lst = new List <T2_ModifyLogModel>(); for (int j = 1; j <= 15; j++) { T2_ModifyLogModel mod = new T2_ModifyLogModel(); foreach (var t in mod.GetType().GetProperties().ToList()) { t.SetValue(mod, t.Name.ToString() + "-" + j.ToString()); } lst.Add(mod); } p.SetValue(MianModel, lst); } else { p.SetValue(MianModel, p.Name.ToString() + "-" + i.ToString()); } } t2_house house = new t2_house(); house.id = i; house.jsonstr = JsonHelper.Instance.Serialize(MianModel); house.Insert(); } }
public void AddJson() { for (int i = 285295; i <= 400000; i++) { for (int j = 1; j <= 200; j++) { if (j <= 50 && j != 10) { List <T2_ModifyLogModel> lst = new List <T2_ModifyLogModel>(); for (int k = 1; k <= 5; k++) { T2_ModifyLogModel mmodel = new T2_ModifyLogModel(); mmodel.Column205 = "Column205" + "-" + j.ToString() + k.ToString(); mmodel.Column206 = "Column206" + "-" + j.ToString() + k.ToString(); mmodel.Column207 = "Column207" + "-" + j.ToString() + k.ToString(); lst.Add(mmodel); } CreatModel(i, j, lst); } else if (j == 10) { List <T2_ModifyJsonModel> lst = new List <T2_ModifyJsonModel>(); for (int l = 1; l <= 4; l++) { T2_ModifyJsonModel tel = new T2_ModifyJsonModel(); foreach (var t in tel.GetType().GetProperties().ToList()) { t.SetValue(tel, t.Name.ToString() + "-" + l.ToString()); } lst.Add(tel); } CreatModel(i, j, lst); } else { T2_ModifyLogModel mmodel = new T2_ModifyLogModel(); mmodel.Column205 = "Column205" + "-" + j.ToString(); mmodel.Column206 = "Column206" + "-" + j.ToString(); mmodel.Column207 = "Column207" + "-" + j.ToString(); CreatModel(i, j, mmodel); } } } }