/// <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="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="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_linkman GetLinkManById(int p) { return(LinqHelper.GetDataContext().cst_linkman.Where(l => l.lkm_id == p).SingleOrDefault()); }
/// <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 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 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_customer GetCustomerByName(string p) { return(LinqHelper.GetDataContext().cst_customer.Where(c => c.cust_name == p).FirstOrDefault()); }