//网络表更新
private void RefreshNetGrid()
{
NetGrid.Rows.Clear();
IEnumerator <GMapRoute> ir = Net.Routes.GetEnumerator();
if (NewNetMap.Count == 0)
{
return;
}
//IDictionaryEnumerator IdTor = NewNetMap.GetEnumerator();
while (ir.MoveNext())
{
double dist = 0;
GMapRoute de = (GMapRoute)ir.Current;
string[] name = de.Name.Split('-');
if (DistMap.Contains(de.Name))
{
dist = double.Parse((string)DistMap[de.Name]);
}
else
{
dist = UtilityClass.CalcDistance(GetGpsFromName(name[0]), GetGpsFromName(name[1]));
DistMap.Add(de.Name, dist.ToString());
}
string[] rowstr = { (name[0]).TrimStart('节', '点'), name[1].TrimStart('节', '点'), (dist.ToString("F01")) };
NetGrid.Rows.Add(rowstr);
}
NetGrid.Sort(NetGrid.Columns[0], ListSortDirection.Ascending);
for (int i = 0; i < NetGrid.Rows.Count; i++)
{
DataGridViewComboBoxCell Dcell = (DataGridViewComboBoxCell)NetGrid.Rows[i].Cells[3];
Dcell.Value = Dcell.Items[0];
Dcell.ToolTipText = Dcell.Value.ToString();
}
}
private static User AddUser(StreetContext context, NetGrid net, string name)
{
var user = context.Users.SingleOrDefault(s => s.UserName == name && s.NetGrid.Contains(net));
if (user == null)
{
user = new User {
UserName = name, Password = "******"
};
context.Users.Add(user);
}
return(user);
}
/// <summary>
/// 添加网格，及网格员
/// </summary>
/// <param name="context"></param>
/// <param name="community">网格所属社区</param>
/// <param name="role">用户组</param>
/// <param name="userName">用户名</param>
private static void AddGrid(StreetContext context, Community community, int gridCount, Role role, string userName)
{
for (int i = 1; i <= gridCount; i++)
{
//网格
var netGrid = context.NetGrids.SingleOrDefault(s => s.Name == i.ToString() && s.Community.Id == community.Id);
if (netGrid == null)
{
netGrid = new NetGrid {
Name = i.ToString()
};
netGrid.Community = community;
context.NetGrids.Add(netGrid);
}
//网格员
var user = AddUser(context, netGrid, userName + i.ToString());
AddUser2Role(context, role, user);
netGrid.User = user;
}
}
private void Add2DB(List <string> data)
{
//if (data.Count > 0)
for (_i = 0; _i < data.Count; _i++)
{
_currentLine = data[_i];
string[] item = _currentLine.Split(',');
//string[] item = data[0].Split(',');
if (IsEmpty(item, 7))
{
continue;
}
CheckAllValue(item, 7);
using (var context = new StreetContext())
{
//街道
StreetUnit street = context.Streets.SingleOrDefault(s => s.Name == "徐家棚");
if (street == null)
{
street = new StreetUnit {
Name = "徐家棚"
};
context.Streets.Add(street);
}
//社区
var community = context.Communitys.SingleOrDefault(s => s.Name == item[0].Replace("社区", ""));
if (community == null)
{
//CheckValue(item,0);
community = new Community {
Name = item[0].Replace("社区", "")
};
community.Street = street;
//street.Communities.Add(community);
context.Communitys.Add(community);
}
//网格
var netGrid = context.NetGrids.SingleOrDefault(s => s.Community.Id == community.Id && s.Name == item[1].Replace("网格", ""));
if (netGrid == null)
{
// CheckValue(item, 1);
netGrid = new NetGrid {
Name = item[1].Replace("网格", "")
};
netGrid.Community = community;
context.NetGrids.Add(netGrid);
}
//小区
var subdivision = context.Subdivisions.SingleOrDefault(s => s.Name == item[3].Replace("小区", ""));
if (subdivision == null)
{
//CheckValue(item,3);
subdivision = new Subdivision {
Name = item[3].Replace("小区", "")
};
subdivision.Street = street;
context.Subdivisions.Add(subdivision);
}
//楼栋
//var building = netGrid.Buildings.SingleOrDefault(s => s.Name == item[4]);
var building = context.Buildings.SingleOrDefault(s => s.Subdivision.Id == subdivision.Id && s.Name == item[4].Replace("栋", ""));
if (building == null)
{
building = new Building
{
Name = item[4].Replace("栋", ""),
//房屋地址
Address = item[2],
};
building.NetGrid = netGrid;
building.Subdivision = subdivision;
context.Buildings.Add(building);
//subdivision.Buildings.Add(building);
}
//房屋
string roomName = $"{item[5].Replace("单元", "")}-{item[6].Replace("号", "")}";
var room = context.Rooms.SingleOrDefault(r => r.Building.Id == building.Id && r.Name == roomName);
if (room == null)
{
room = new Room
{
Name = roomName,
Category = item[7],
Use = item[8],
Area = item[10],
Other = item[9],
};
room.Building = building;
context.Rooms.Add(room);
}
//单位信息
// var companyinfo = new CompanyInfo { };
if (item[11] != "")
{
var companyinfo = new CompanyInfo
{
Name = item[11],
Character = item[12],
SocialId = item[13],
ContactPerson = item[14],
PersonId = item[15],
Phone = item[16],
Area = item[17]
};
companyinfo.Room = room;
context.CompanyInfos.Add(companyinfo);
}
//人
var person = context.Persons.SingleOrDefault(p => p.PersonId == item[20]);
//检测空名空身份证号
if (!CheckItem(item))
{
continue;
}
//检测同身份证号不同名
if (!CheckPerson(person, item))
{
continue;
}
if (person == null)
{
person = new Person
{
Name = item[18],
EthnicGroups = item[19].Replace("族", ""),
PersonId = item[20],
Phone = item[21],
//户籍地址
DomicileAddress = item[22],
Company = item[27],
PoliticalState = item[28],
OrganizationalRelation = item[29],
IsOverseasChinese = (item[30] == "是"),
MerriedStatus = item[31],
};
// person.CompanyInfo = companyinfo;
context.Persons.Add(person);
//单位信息
//if (item[11] != "")
//{
// var companyinfo = new CompanyInfo
// {
// Name = item[11],
// Character = item[12],
// SocialId = item[13],
// ContactPerson = item[14],
// PersonId = item[15],
// Phone = item[16],
// Area = item[17]
// };
// context.CompanyInfos.Add(companyinfo);
//}
//特殊人群
if (item[34] != "")
{
//var specialGroup = context.SpecialGroups.SingleOrDefault(s => s.PersonId == item[20]);
//if (specialGroup == null)
var specialGroup = new SpecialGroup {
PersonId = item[20], Type = item[34]
};
context.SpecialGroups.Add(specialGroup);
}
// 困难人群
if (item[35] != "")
{
var poorPeople = new PoorPeople
{
PersonId = item[20],
Type = item[35],
Child = item[36],
Youngsters = item[37],
SpecialHelp = item[38]
};
context.PoorPeoples.Add(poorPeople);
}
//服役状况
if (item[39] != "")
{
var militaryService = new MilitaryService {
PersonId = item[20], Type = item[39]
};
context.MilitaryService.Add(militaryService);
}
//残疾
//var disability = context.Disabilitys.SingleOrDefault(s => s.PersonId == item[20]);
//if (disability == null)
if (item[40] != "")
{
var disability = new Disability
{
PersonId = item[20],
Type = item[40],
Class = item[41],
};
context.Disability.Add(disability);
}
//其他信息
//var otherInfos = context.OtherInfos.SingleOrDefault(s => s.PersonId == item[20]);
// if (otherInfos == null)
if (item[42] != "")
{
var otherInfos = new OtherInfos
{
PersonId = item[20],
//Key = item[42],
Value = item[42],
};
context.OtherInfos.Add(otherInfos);
}
}
//personroom 人房信息
var personHouse = new PersonRoom
{
PersonId = item[20],
IsHouseholder = (item[23] == "是"),
RelationWithHouseholder = item[24],
IsOwner = (item[25] == "是"),
IsLiveHere = (item[26] == "是"),
PopulationCharacter = item[32],
LodgingReason = item[33]
};
personHouse.Person = person;
personHouse.Room = room;
context.PersonRooms.Add(personHouse);
context.SaveChanges();
_preItem = item;
}
}
// tbInfo_err.Text = "";
tbInfo.Text = "Add personroomdata OK!";
tbInfo_err.Text += _errorMessage;
}
