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