//从excel中导入人员
private void ExcuteCmdInputPersons()
{
string xpath;
List <viewPerson> viewPeople = new List <viewPerson>();
OpenFileDialog openFileDialog = new OpenFileDialog();
openFileDialog.Filter = "Excel(*.xlsx)|*.xlsx|Excel(*.xls)|*.xls";
if (openFileDialog.ShowDialog() == true)
{
xpath = openFileDialog.FileName;
viewPeople = NpoiHelper.ReadToList <viewPerson>(xpath, 0);
}
if (viewPeople.Count > 0)
{
using (var db = new DataModel())
{
foreach (var item in viewPeople)
{
if (db.Persons.Where(p => p.PersonName == item.Name && p.Department.DepartmentName == item.Department).Count() <= 0)
{
Department department = db.Departments.Where(d => d.DepartmentName == item.Department).First();
if (department != null)
{
Person person = new Person()
{
DepId = department.DepartmentId, PersonName = item.Name
};
db.Persons.Add(person);
}
}
}
db.SaveChanges();
}
int tempid = 0;
if (QueryDepartment != null)
{
tempid = QueryDepartment.DepartmentId;
}
Inital();
QueryDepartment = Departments.Where(d => d.DepartmentId == tempid).FirstOrDefault();
ExcuteCbChangeCommand();
}
}
