private void MenuMergeArchorInfo_Click(object sender, RoutedEventArgs e)
{
var win = new AreaTreeWindow();
if (win.ShowDialog() == true)
{
var area = win.SelectedArea;
var archors = DbInfoHelper.GetArchors().FindAll(i => i.ParentId == area.Id);
var devs = DbInfoHelper.GetDevInfos().FindAll(i => i.ParentId == area.Id);
foreach (var item in archors)
{
item.DevInfo = devs.Find(i => i.Id == item.DevInfoId);
}
var archorSettings = DbInfoHelper.GetArchorSettings().FindAll(i => i.FloorName == area.Name);
foreach (var item in archorSettings)
{
item.Archor = archors.Find(i => i.Id == item.ArchorId);
}
Bll bll = new Bll();
var archors2 = bll.Archors.FindAll(i => i.ParentId == area.Id);
var devs2 = bll.DevInfos.FindAll(i => i.ParentId == area.Id);
var archorSettings2 = bll.ArchorSettings.FindAll(i => i.FloorName == area.Name);
bll.Archors.RemoveList(archors2);
bll.DevInfos.RemoveList(devs2);
bll.ArchorSettings.RemoveList(archorSettings2);
bll.DevInfos.AddRange(devs);
foreach (var item in archors)
{
item.DevInfoId = item.DevInfo.Id;
}
bll.Archors.AddRange(archors);
foreach (var item in archorSettings)
{
if (item.Archor != null)
{
item.ArchorId = item.Archor.Id;
}
}
bll.ArchorSettings.AddRange(archorSettings);
}
}
public static void LoadArchorList(string tag)
{
try
{
DateTime start = DateTime.Now;
Log.Info(tag, "LoadArchorList Start");
var Path = AppDomain.CurrentDomain.BaseDirectory + "\\Data\\DbInfos\\";
string file1 = Path + "DevInfo.xls";
string file2 = Path + "Archor.xls";
string file3 = Path + "ArchorSetting.xls";
Bll bll = Bll.NewBllNoRelation();
Log.Info(tag, "archors_ms");
var archors_ms = DbInfoHelper.GetArchors(); //老的SQLServer
Log.Info(tag, "archors_my");
var archors_my = bll.Archors.ToList(); //现在的mysql中的基站
Log.Info(tag, "archors2Dict_my");
var archors2Dict_my = bll.Archors.ToDictionary();
Log.Info(tag, "archorSettings_my");
var archorSettings_my = DbInfoHelper.GetArchorSettings();
Log.Info(tag, "archors_list");
var archors_list = ArchorHelper.LoadArchoDevInfo().ArchorList;//清单文件
Log.Info(tag, "archors_engine");
var archors_engine0 = bll.bus_anchors.ToList();
var archors_engine1 = archors_engine0.FindAll(i => i.enabled != 1); //引擎数据
var archors_engine = archors_engine0.FindAll(i => i.enabled == 1); //引擎数据
Log.Info(tag, "archorConfig_engine");
var archorConfig_engine = bll.bus_anchor_config.ToList().FindAll(i => i.net_gate != null);
Log.Info(tag, "devs_ms_all");
var devs_ms_all = DbInfoHelper.GetDevInfos();
Log.Info(tag, "devs_ms");
var devs_ms = devs_ms_all.FindAll(i => i.Local_TypeCode == 20180821);
Log.Info(tag, "devs_my");
var devs_my = bll.DevInfos.FindAll(i => i.Local_TypeCode == 20180821);
Log.Info(tag, "archorSettings2");
var archorSettings2 = bll.ArchorSettings.ToList();
Log.Info(tag, "areas_ms");
var areas_ms = DbInfoHelper.GetAreas().ToDictionary(i => i.Id);
Log.Info(tag, "InitArea(areas_ms)");
InitArea(areas_ms, tag);
Log.Info(tag, "areas_my");
var areas_my_list = bll.Areas.ToList();
var areas_my = areas_my_list.ToDictionary(i => i.Id);
Log.Info(tag, "InitArea(areas_my)");
InitArea(areas_my, tag);
foreach (var item in archors_my)
{
item.DevInfo = devs_my.Find(i => i.Id == item.DevInfoId);
}
foreach (var item in archors_ms)
{
item.DevInfo = devs_ms.Find(i => i.Id == item.DevInfoId);
}
bll.Archors.RemoveList(archors_my);
bll.DevInfos.RemoveList(devs_my);
bll.ArchorSettings.RemoveList(archorSettings2);
//foreach (var item in archors_ms)
for (int j = 0; j < archors_ms.Count; j++)
{
var item = archors_ms[j];
//Log.Info(tag, string.Format("SetParent : {0}/{1}", j, archors_ms.Count));
var dev = item.DevInfo;
if (dev != null)
{
item.DevInfoId = dev.Id;
if (dev.ParentId != null)
{
var pid = (int)dev.ParentId;
var p1 = areas_ms[pid];
var p2 = areas_my_list.Find(i => i.Path == p1.Path);
if (p2 != null)
{
dev.ParentId = p2.Id;
item.ParentId = p2.Id;
}
}
}
}
bll.DevInfos.AddRange(devs_ms);
foreach (var item in archors_ms)
{
item.DevInfoId = item.DevInfo.Id;
}
bll.Archors.AddRange(archors_ms);
archors_my = archors_ms;
foreach (var item in archorSettings_my)
{
if (item.Archor != null)
{
item.ArchorId = item.Archor.Id;
}
}
bll.ArchorSettings.AddRange(archorSettings_my);
//{
// List<Archor> temp11 = new List<Archor>();
// List<Archor> temp12 = new List<Archor>();
// foreach (var item in archors_my)
// {
// var old = archors_ms.Find(i => i.Code == item.Code);
// if (old != null)
// {
// temp11.Add(item);
// archors_ms.Remove(old);
// }
// else
// {
// temp12.Add(item);
// }
// }
//}
//{
// List<Archor> temp11 = new List<Archor>();
// List<Archor> temp12 = new List<Archor>();
// foreach (var item in archors_my)
// {
// var old = archors_list.Find(i => i.ArchorID == item.Code);
// if (old != null)
// {
// temp11.Add(item);
// archors_list.Remove(old);
// }
// else
// {
// temp12.Add(item);
// }
// }
//}
{
List <Archor> temp11 = new List <Archor>();
List <Archor> temp12 = new List <Archor>();
foreach (var item in archors_my)
{
var old = archorConfig_engine.Find(i => i.anchor_id == item.Code);
if (old != null)
{
temp11.Add(item);
archorConfig_engine.Remove(old);
}
else
{
temp12.Add(item);
}
}
List <DevInfo> devs = new List <DevInfo>();
foreach (var item in temp12)
{
devs.Add(item.DevInfo);
}
bll.Archors.RemoveList(temp12);
bll.DevInfos.RemoveList(devs);
}
var time = DateTime.Now - start;
Log.Info(tag, "LoadArchorList End:" + time);
}
catch (Exception ex)
{
Log.Error(tag, ex.ToString());
}
}
