/// <summary>
/// 查询客户贡献报表数据
/// </summary>
/// <param name="searchEntity"></param>
/// <returns></returns>
public List <ContributeReportModel> GetContributesBySearchEntity(orders searchEntity)
{
var db = LinqHelper.GetDataContext();
if (searchEntity.odr_id > 0)
{
return((from p in db.orders_line
where p.orders.odr_cust_name.Contains
(searchEntity.odr_cust_name == null ? "" : searchEntity.odr_cust_name) &&
p.orders.odr_date.Year == searchEntity.odr_id
group p by p.orders.odr_cust_name into g
select new ContributeReportModel
{
Name = g.Key,
TotalMoney = g.Sum(p => p.odd_price.Value)
}).ToList());
}
else
{
return((from p in db.orders_line
where p.orders.odr_cust_name.Contains
(searchEntity.odr_cust_name == null ? "" : searchEntity.odr_cust_name)
group p by p.orders.odr_cust_name into g
select new ContributeReportModel
{
Name = g.Key,
TotalMoney = g.Sum(p => p.odd_price.Value)
}).ToList());
}
}
/// <summary>
/// 根据查询对象获得库存集合
/// </summary>
/// <param name="searchEntity"></param>
/// <returns></returns>
public List <storage> GetStoragesBySearchEntity(storage searchEntity)
{
return((from s in LinqHelper.GetDataContext().storage
where s.product.prod_name.Contains(searchEntity.product.prod_name == null ? "" : searchEntity.product.prod_name) &&
s.stk_warehouse.Contains(searchEntity.stk_warehouse == null ? "" : searchEntity.stk_warehouse)
select s).ToList());
}
/// <summary>
/// 根据查询对象获得商品集合
/// </summary>
/// <param name="searchEntity"></param>
/// <returns></returns>
public List <product> GetProductsBySearchEntity(product searchEntity)
{
return((from p in LinqHelper.GetDataContext().product
where p.prod_name.Contains(searchEntity.prod_name == null ? "" : searchEntity.prod_name) &&
p.prod_type.Contains(searchEntity.prod_type == null ? "" : searchEntity.prod_type) &&
p.prod_batch.Contains(searchEntity.prod_batch == null ? "" : searchEntity.prod_batch)
select p).ToList());
}
/// <summary>
/// 根据查询对象获得数据集合
/// </summary>
/// <param name="searchEntity"></param>
/// <returns></returns>
public List <bas_dict> GetDictsBySearchEntity(bas_dict searchEntity)
{
return((from d in LinqHelper.GetDataContext().bas_dict
where d.dict_type.Contains(searchEntity.dict_type == null ? "" : searchEntity.dict_type) &&
d.dict_item.Contains(searchEntity.dict_item == null ? "" : searchEntity.dict_item) &&
d.dict_value.Contains(searchEntity.dict_value == null ? "" : searchEntity.dict_value)
select d).ToList());
}
/// <summary>
/// 根据查询对象获得服务集合
/// </summary>
/// <param name="searchEntity"></param>
/// <returns></returns>
public List <cst_service> GetServicesBySearchEntity(cst_service searchEntity)
{
return((from s in LinqHelper.GetDataContext().cst_service
where s.svr_cust_name.Contains(searchEntity.svr_cust_name == null ? "" : searchEntity.svr_cust_name) &&
s.svr_title.Contains(searchEntity.svr_title == null ? "" : searchEntity.svr_title) &&
s.svr_type.Contains(searchEntity.svr_type == null ? "" : searchEntity.svr_type) &&
s.svr_status == searchEntity.svr_status
select s).ToList());
}
/// <summary>
/// 根据机会查询对象获得机会集合
/// </summary>
/// <param name="searchEntity"></param>
/// <returns></returns>
public List <sal_chance> GetSalsBySearchEntity(sal_chance searchEntity)
{
List <sal_chance> list = new List <sal_chance>();
list = (from s in LinqHelper.GetDataContext().sal_chance
where s.chc_cust_name.Contains(searchEntity.chc_cust_name == null ? "" : searchEntity.chc_cust_name) &&
s.chc_title.Contains(searchEntity.chc_title == null ? "" : searchEntity.chc_title) &&
s.chc_linkman.Contains(searchEntity.chc_linkman == null ? "" : searchEntity.chc_linkman)
orderby s.chc_id descending
select s).ToList();
return(list);
}
/// <summary>
/// 根据流失客户查询对象获得符合条件的流失客户集合
/// </summary>
/// <param name="searchEntity"></param>
/// <returns></returns>
public List <cst_lost> GetLostCustomerBySearchEntity(cst_lost searchEntity)
{
List <cst_lost> list = (from l in LinqHelper.GetDataContext().cst_lost
where l.lst_cust_name.Contains(searchEntity.lst_cust_name == null ? "" : searchEntity.lst_cust_name) &&
l.lst_cust_manager_name.Contains(searchEntity.lst_cust_manager_name == null ? "" : searchEntity.lst_cust_manager_name)
select l).ToList();
if (searchEntity.lst_status > 0)
{
list = list.Where(l => l.lst_status == searchEntity.lst_status).ToList();
}
return(list);
}
/// <summary>
/// 根据搜索条件获得客户信息集合
/// </summary>
/// <param name="searchEntity"></param>
/// <returns></returns>
public List <cst_customer> GetCustomersBySearchEntity(cst_customer searchEntity)
{
List <cst_customer> list = (from c in LinqHelper.GetDataContext().cst_customer
where c.cust_no.Contains(searchEntity.cust_no == null ? "" : searchEntity.cust_no) &&
c.cust_name.Contains(searchEntity.cust_name == null ? "" : searchEntity.cust_name) &&
c.cust_manager_name.Contains(searchEntity.cust_manager_name == null ? "" : searchEntity.cust_manager_name) &&
c.cust_region.Contains(searchEntity.cust_region == null?"":searchEntity.cust_region)
orderby c.cust_Id descending
select c).ToList();
if (searchEntity.cust_level > 0)
{
list = list.Where(c => c.cust_level == searchEntity.cust_level).ToList();
}
return(list);
}
/// <summary>
/// 查询客户构成报表数据
/// </summary>
/// <param name="searchEntity"></param>
/// <returns></returns>
public List <ComposingReportModel> GetComposingReportBySearchEntity(ComposingReportModel searchEntity)
{
var db = LinqHelper.GetDataContext();
if (searchEntity.TypeName == "按等级")
{
return((from c in db.cst_customer
group c by c.cust_level_label into nc
select new ComposingReportModel
{
TypeName = nc.Key.ToString(),
CustomerCount = nc.Count()
}).ToList());
}
else if (searchEntity.TypeName == "按信用度")
{
var list = from c in db.cst_customer
group c by c.cust_credit into nc
select new ComposingReportModel
{
TypeName = db.bas_dict.Where(b => b.dict_type == "客户信用度" && b.dict_value == nc.Key.Value.ToString()).Select(b => b.dict_item).FirstOrDefault(),
CustomerCount = nc.Count()
};
return(list.ToList());
}
else
{
return((from c in db.cst_customer
group c by c.cust_satisfy into nc
select new ComposingReportModel
{
TypeName = db.bas_dict.Where(b => b.dict_type == "客户满意度" && b.dict_value == nc.Key.Value.ToString()).Select(b => b.dict_item).FirstOrDefault(),
CustomerCount = nc.Count()
}).ToList());
}
}
/// <summary>
/// 根据客户编号获得交往记录集合
/// </summary>
/// <param name="p"></param>
/// <returns></returns>
public List <Model.cst_activity> GetActivityByCustomerId(string p)
{
return(LinqHelper.GetDataContext().cst_activity.Where(a => a.atv_cust_no == p).ToList());
}
/// <summary>
/// 根据角色编号获得用户列表
/// </summary>
/// <param name="roleId"></param>
/// <returns></returns>
public List <sys_user> GetUserByRoleId(int roleId)
{
return((from u in LinqHelper.GetDataContext().sys_user
where u.usr_role_id == roleId
select u).ToList());
}
/// <summary>
/// 根据用户编号查找指定用户对象
/// </summary>
/// <param name="userId"></param>
/// <returns></returns>
public sys_user GetUserByUserId(int userId)
{
return((from u in LinqHelper.GetDataContext().sys_user
where u.usr_id == userId
select u).SingleOrDefault());
}
/// <summary>
/// 获得所有用户信息（包含其角色等附加信息）
/// </summary>
/// <returns></returns>
public List <sys_user> GetAllUsers()
{
return((from u in LinqHelper.GetDataContext().sys_user
select u).ToList());
}
/// <summary>
/// 根据客户编号获得订单集合
/// </summary>
/// <param name="p"></param>
/// <returns></returns>
public List <orders> GetOrdersByCustomerNo(string p)
{
return(LinqHelper.GetDataContext().orders.Where(o => o.odr_cust_no == p).OrderBy(o => o.odr_date).ToList());
}
/// <summary>
/// 根据服务编号获得服务对象
/// </summary>
/// <param name="p"></param>
/// <returns></returns>
public cst_service GetServiceByServiceId(int p)
{
return(LinqHelper.GetDataContext().cst_service.Where(s => s.svr_id == p).FirstOrDefault());
}
/// <summary>
/// 根据机会编号获得计划集合
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public List <Model.sal_plan> GetPlanBySalId(int id)
{
return(LinqHelper.GetDataContext().sal_plan.Where(p => p.pla_chc_id == id).ToList());
}
/// <summary>
/// 根据类型获得字典集合
/// </summary>
/// <param name="p"></param>
/// <returns></returns>
public List <bas_dict> GetDictsByType(string p)
{
return(LinqHelper.GetDataContext().bas_dict.Where(d => d.dict_type == p).ToList());
}
/// <summary>
/// 根据记录编号获得记录对象
/// </summary>
/// <param name="p"></param>
/// <returns></returns>
public cst_activity GetActivityById(int p)
{
return(LinqHelper.GetDataContext().cst_activity.Where(a => a.atv_id == p).SingleOrDefault());
}
/// <summary>
/// 根据客户名称获得客户对象
/// </summary>
/// <param name="p"></param>
/// <returns></returns>
public cst_customer GetCustomerByName(string p)
{
return(LinqHelper.GetDataContext().cst_customer.Where(c => c.cust_name == p).FirstOrDefault());
}
/// <summary>
/// 根据公司编号获得联系人对象集合
/// </summary>
/// <param name="p"></param>
/// <returns></returns>
public List <cst_linkman> GetLinkMansByCustomerId(int p)
{
return(LinqHelper.GetDataContext().cst_linkman.Where(l => l.cst_customer.cust_Id == p).ToList());
}
/// <summary>
/// 根据联系人编号获得联系人对象
/// </summary>
/// <param name="p"></param>
/// <returns></returns>
public cst_linkman GetLinkManById(int p)
{
return(LinqHelper.GetDataContext().cst_linkman.Where(l => l.lkm_id == p).SingleOrDefault());
}
