/// <summary> /// 包含查询 ///0:部门查找,1:联系人姓名,2:联系电话,3.办公电话 ///4.联系地址,5.公司名称,6.联系人属性,7.往来业务 /// </summary> /// <param name="queryDto"></param> /// <returns></returns> internal List <CollaborateContactLibModel> FindBy(QueryContactDto queryDto) { try { if (queryDto.Department == null || queryDto.Department == string.Empty) { return(new List <CollaborateContactLibModel>()); } switch (queryDto.SearchMode) { ///部门 case 0: return(irep.Entities.Where(e => e.IsDelete == queryDto.IsDelete && e.Department == queryDto.Department).ToList()); ///联系人姓名 case 1: return(irep.Entities.Where(e => e.IsDelete == queryDto.IsDelete && e.Department == queryDto.Department && e.ContactPerson.Contains(queryDto.QueryContent)).ToList()); ///联系电话 case 2: return(irep.Entities.Where(e => e.IsDelete == queryDto.IsDelete && e.Department == queryDto.Department && e.Telephone.Contains(queryDto.QueryContent)).ToList()); ///办公电话 case 3: return(irep.Entities.Where(e => e.IsDelete == queryDto.IsDelete && e.Department == queryDto.Department && e.OfficeTelephone.Contains(queryDto.QueryContent)).ToList()); ///联系地址 case 4: return(irep.Entities.Where(e => e.IsDelete == queryDto.IsDelete && e.Department == queryDto.Department && e.ContactAdress.Contains(queryDto.QueryContent)).ToList()); ///公司名称 case 5: return(irep.Entities.Where(e => e.IsDelete == queryDto.IsDelete && e.Department == queryDto.Department && e.ContactCompany.Contains(queryDto.QueryContent)).ToList()); ///联系人属性 case 6: return(irep.Entities.Where(e => e.IsDelete == queryDto.IsDelete && e.Department == queryDto.Department && e.CustomerCategory.Contains(queryDto.QueryContent)).ToList()); ///往来业务 case 7: return(irep.Entities.Where(e => e.IsDelete == queryDto.IsDelete && e.Department == queryDto.Department && e.ContactMemo.Contains(queryDto.QueryContent)).ToList()); default: return(new List <CollaborateContactLibModel>()); } } catch (Exception ex) { throw new Exception(ex.Message); } }
public JsonResult GetCollaborateContactDatas(string department, int searchMode, string queryContent) { department = "品保部"; QueryContactDto queryDto = new QueryContactDto() { SearchMode = searchMode, Department = department, QueryContent = queryContent, IsExactQuery = false, }; var datas = 0; /*ToolOnlineService.ContactManager.GetContactLibDatasBy(queryDto);*/ return(Json(datas, JsonRequestBehavior.AllowGet)); }