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