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); } }