private void InsertCodeDomainLevel3(IList <mdmExcelRawEntity> codesyslist, string connstr)
{
var domains = codesyslist.Where(p => !string.IsNullOrEmpty(p.级域)).Select(p => new { levelcode = p.级域代码, levelname = p.级域, levl1code = p.一级域代码, levl1name = p.一级域, levl2code = p.二级域代码, levl2name = p.二级域 }).Distinct();
using (NpgsqlConnection conn = new NpgsqlConnection(connstr))
{
foreach (var item in domains)
{
var codedomain = new code_domain_entity
{
//domain_id = "168",
domain_code = item.levelcode,
domain_name = item.levelname,
spell_code = " ",
wb_code = " ",
parent_domain_id = 0,
note = "3",
oper_id = 2,
oper_time = DateTime.Now,
etl_time = DateTime.Now,
tenant_id = 0
};
var parentdomid = conn.Query <int>($"select domain_id from mdm.code_domain where note = '{"2"}' and domain_code = '{item.levl2code}'").FirstOrDefault();
codedomain.parent_domain_id = parentdomid;
var result = conn.Insert <code_domain_entity>(codedomain, commandTimeout: 15);
}
}
}
private void InsertCodeDomainLevel1(IList <mdmExcelRawEntity> codesyslist, string connstr)
{
var domains = codesyslist.Select(p => new { levelcode = p.一级域代码, levelname = p.一级域 }).Distinct();
using (NpgsqlConnection conn = new NpgsqlConnection(connstr))
{
foreach (var item in domains)
{
var codedomain = new code_domain_entity
{
//domain_id = "168",
domain_code = item.levelcode,
domain_name = item.levelname,
spell_code = " ",
wb_code = " ",
parent_domain_id = 0,
note = "1",
oper_id = 2,
oper_time = DateTime.Now,
etl_time = DateTime.Now,
tenant_id = 0
};
var result = conn.Insert <code_domain_entity>(codedomain, commandTimeout: 15);
}
}
}