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