public static void SaveCustomer(Customer customer) { using (var dbContext = new CrmEntities()){ if(customer.ID > 0){ if(dbContext.Customer.Any(c => c.Tel == customer.Tel && c.ID != customer.ID)) throw new Exception("已存在此电话的客户!"); if(dbContext.Customer.Any(c => c.Number == customer.Number && c.ID != customer.ID)) throw new Exception("已存在此编号的客户!"); } else{ if(dbContext.Customer.Any(c => c.Tel == customer.Tel)) throw new Exception("已存在此电话的客户!"); if(dbContext.Customer.Any(c => c.Number == customer.Number)) throw new Exception("已存在此编号的客户!"); dbContext.Customer.Add(customer); } dbContext.SaveChanges(); } }
public static PagedList<Customer> GetCustomerList(CustomerRequest request = null) { request = request ?? new CustomerRequest(); using (var dbContext = new CrmEntities()){ IQueryable<Customer> queryList = dbContext.Customer; if(request.Customer.UserId > 0) queryList = queryList.Where(d => d.UserId == request.Customer.UserId); if(!string.IsNullOrEmpty(request.Customer.Name)) queryList = queryList.Where(d => d.Name.Contains(request.Customer.Name)); if(!string.IsNullOrEmpty(request.Customer.Number)) queryList = queryList.Where(d => d.Number.Contains(request.Customer.Number)); if(!string.IsNullOrEmpty(request.Customer.Username)) queryList = queryList.Where(d => d.Username.Contains(request.Customer.Username)); if(!string.IsNullOrEmpty(request.Customer.Tel)) queryList = queryList.Where(d => d.Tel.Contains(request.Customer.Tel)); if(request.Customer.Gender > 0) queryList = queryList.Where(d => d.Gender == request.Customer.Gender); if(request.Customer.Category > 0) queryList = queryList.Where(d => d.Category == request.Customer.Category); if(request.Customer.Profession > 0) queryList = queryList.Where(d => d.Profession == request.Customer.Profession); if(request.Customer.AgeGroup > 0) queryList = queryList.Where(d => d.AgeGroup == request.Customer.AgeGroup); return queryList.OrderByDescending(x => x.ID).ToPagedList(request.PageIndex, request.PageSize); } }
public Customer GetCustomer(int id) { using (var dbContext = new CrmEntities()){ return dbContext.Customer.Find(id); } }
public static void DeleteCustomer(List<int> ids) { using (var dbContext = new CrmEntities()){ dbContext.Customer.Where(u => ids.Contains(u.ID)).Delete(); } }