private static void Test_Person()
{
var model = new Person
{
Username = "******",
Password = "******",
Age = 1
};
var personDao = new PersonDao();
var isOkDelete = personDao.DeleteById(1);
var id = personDao.Add(model);
var isOkUpadte = personDao.UpdateById(new Person()
{
Username = "******"
}, id);
var model01 = personDao.FindById(id);
var whereModel = new Person {
Id = id
};
var model02 = personDao.FindList(whereModel, "id=@id", 1);
//---
#region where--比较推荐的写法--可以提高程序的可读性
var where = new WhereEntity <Person>()
{
Model = new Person()
{
Id = id
},
Sql = "id=@id",
OrderBy = "id"
};
//
var model03 = personDao.FindListByPage(where.Model, where.Sql, where.OrderBy, 0, 10);
var count = personDao.Count(where.Model, where.Sql);
#endregion
}
public void ModifyManagedEmployees(IList <ManagedEmployee> updatedEmployees, IList <ManagedEmployee> newEmployees)
{
foreach (var updatedEmployee in updatedEmployees)
{
var person = _personDao.FindById(updatedEmployee.BusinessEntityID);
person.FirstName = updatedEmployee.FirstName;
person.LastName = updatedEmployee.LastName;
person.EmailPromotion = updatedEmployee.EmailPromotion;
person.ModifiedDate = DateTime.Now;
_personDao.Update(person);
var employee = _employeeDao.FindById(updatedEmployee.BusinessEntityID);
employee.NationalIDNumber = updatedEmployee.NationalIDNumber;
employee.LoginID = updatedEmployee.LoginID;
employee.JobTitle = updatedEmployee.JobTitle;
employee.BirthDate = updatedEmployee.BirthDate;
employee.MaritalStatus = updatedEmployee.MaritalStatus;
employee.Gender = updatedEmployee.Gender;
employee.HireDate = updatedEmployee.HireDate;
employee.SalariedFlag = updatedEmployee.SalariedFlag;
employee.VacationHours = updatedEmployee.VacationHours;
employee.SickLeaveHours = updatedEmployee.SickLeaveHours;
employee.CurrentFlag = updatedEmployee.CurrentFlag;
employee.ModifiedDate = DateTime.Now;
_employeeDao.Update(employee);
}
foreach (var newEmployee in newEmployees)
{
var businessEntity = _businessEntityDao.Insert();
var person = new Person
{
BusinessEntityID = businessEntity.BusinessEntityID,
PersonType = "EM",
FirstName = newEmployee.FirstName,
LastName = newEmployee.LastName,
EmailPromotion = newEmployee.EmailPromotion,
ModifiedDate = DateTime.Now
};
_personDao.Insert(person);
var employee = new Employee
{
BusinessEntityID = businessEntity.BusinessEntityID,
NationalIDNumber = newEmployee.NationalIDNumber,
LoginID = newEmployee.LoginID,
JobTitle = newEmployee.JobTitle,
BirthDate = newEmployee.BirthDate,
MaritalStatus = newEmployee.MaritalStatus,
Gender = newEmployee.Gender,
HireDate = newEmployee.HireDate,
SalariedFlag = newEmployee.SalariedFlag,
VacationHours = newEmployee.VacationHours,
SickLeaveHours = newEmployee.SickLeaveHours,
CurrentFlag = newEmployee.CurrentFlag,
ModifiedDate = DateTime.Now
};
_employeeDao.Insert(employee);
}
}
