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