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();
}
}
}
/// <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()
{
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();
// }
//}
}
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);
}
}
}
}
/// <summary>
/// 前九字段查询
/// </summary>
/// <param name="index"></param>
/// <param name="pageSize"></param>
/// <returns></returns>
public async Task <ResponseModel <t2_house_part_expand> > GetJsonHousePart(int index, int pageSize)
{
//string sql;
//if (index > 1)
//{
// sql = $"select top {pageSize} * from t2_house where id > (select max(id) from (select top(({index} - 1) * {pageSize}) id from t2_house order by id) as T) order by id";
//}
//else
//{
// sql = $"select top {pageSize} * from t2_house";
//}
string sql = $"select jsonstr from t2_house order by id offset {pageSize * (index - 1)} row fetch next {pageSize} rows only";
//string sql = $"select top {pageSize} jsonstr from t2_house where id >(select max(id) from (select id from t2_house order by id offset ({pageSize} * ({index} - 1)) row fetch next {pageSize} rows only) as T) order by id";
ConcurrentBag <t2_house_part_expand> t2modelList = new ConcurrentBag <t2_house_part_expand>();
var result = await dataService.GetListAsync <t2_house>(sql);
ParallelOptions opt = new ParallelOptions
{
MaxDegreeOfParallelism = 2
};
//string data = "Data Source=192.168.0.89 ; Initial Catalog = PressureTest; Persist Security Info=True; User ID = sa; Password=qj12345678@";
//ConcurrentBag<t2_house> cb = new ConcurrentBag<t2_house>();
//using (SqlConnection conn = new SqlConnection(data))
//{
// conn.Open();
// string sql = $"select top {pageSize} jsonstr from t2_house where id >(select max(id) from (select id from t2_house order by id offset ({pageSize} * ({index} - 2)) row fetch next {pageSize} rows only) as T) order by id";
// SqlCommand command = new SqlCommand(sql, conn);
// DataTable dt = new DataTable();
// SqlDataAdapter da = new SqlDataAdapter(command);
// da.Fill(dt);
// Parallel.For(0, dt.Rows.Count, i =>
// {
// Parallel.Invoke(() =>
// {
// cb.Add(new t2_house { jsonstr = dt.Rows[i][0].ToString() });
// });
// });
//}
Parallel.ForEach(result, opt, item =>
{
var model = JsonConvert.DeserializeObject <t2_house_expand>(item.jsonstr);
t2_house_part_expand modeltemp = new t2_house_part_expand();
Parallel.Invoke(() =>
{
T2_ModifyLogModel column4 = model.column4.OrderByDescending(a => a.Column207).FirstOrDefault();
T2_ModifyLogModel column5 = model.column5.OrderByDescending(a => a.Column207).FirstOrDefault();
T2_ModifyLogModel column6 = model.column6.OrderByDescending(a => a.Column207).FirstOrDefault();
T2_ModifyLogModel column7 = model.column7.OrderByDescending(a => a.Column207).FirstOrDefault();
T2_ModifyLogModel column8 = model.column8.OrderByDescending(a => a.Column207).FirstOrDefault();
BaseModel.Mapper(modeltemp, model);
modeltemp.column4 = column4.Column205;
modeltemp.column5 = column5.Column205;
modeltemp.column6 = column6.Column205;
modeltemp.column7 = column7.Column205;
modeltemp.column8 = column8.Column205;
t2modelList.Add(modeltemp);
});
});
ResponseModel <t2_house_part_expand> resModel = new ResponseModel <t2_house_part_expand>(t2modelList.ToList().OrderByDescending(o => o.column1).ToList());
return(resModel);
}
