public Model.PageModel <Model.CAS_MAIN_INFO> PageSearchCasList(QueryModel.CAS_MAIN_INFOQuery casQuery) { int num = 0; try { IQueryable <CAS_MAIN_INFO> cas = context.CAS_MAIN_INFO.AsQueryable <CAS_MAIN_INFO>(); if (!string.IsNullOrWhiteSpace(casQuery.CAS_NUMBER)) { cas = from d in cas where d.CAS_NUMBER.Contains(casQuery.CAS_NUMBER) || d.CHINESE.Equals(casQuery.CAS_NUMBER) || d.CHINESE_ALIAS.Equals(casQuery.CAS_NUMBER) || d.ENGLISH.Equals(casQuery.CAS_NUMBER) || d.ENGLISH_ALIAS.Equals(casQuery.CAS_NUMBER) select d; } if (!string.IsNullOrWhiteSpace(casQuery.CAS_NUMBERList)) { List <string> listcas = new List <string>(); string[] array = casQuery.CAS_NUMBERList.Split('~'); for (int i = 0; i < array.Length; i++) { if (!string.IsNullOrWhiteSpace(array[i])) { listcas.Add(array[i]); } } cas = from d in cas where (from p in listcas select p).Contains(d.CAS_NUMBER) select d; } cas = cas.GetPage(out num, casQuery.PageNo, casQuery.PageSize, (IQueryable <CAS_MAIN_INFO> d) => from o in d orderby o.ADD_DATE descending select o); return(new PageModel <CAS_MAIN_INFO>() { Models = cas, Total = num }); } catch (Exception) { return(null); } }
public Model.PageModel <Model.CAS_MAIN_INFO> GetCasList(QueryModel.CAS_MAIN_INFOQuery casQuery) { int num = 0; IQueryable <CAS_MAIN_INFO> cas = context.CAS_MAIN_INFO.AsQueryable <CAS_MAIN_INFO>(); if (!string.IsNullOrWhiteSpace(casQuery.CAS_NUMBER)) { cas = from d in cas where d.CAS_NUMBER.Equals(casQuery.CAS_NUMBER) select d; } if (!string.IsNullOrWhiteSpace(casQuery.type)) { int i; int k; if (int.TryParse(casQuery.type, out i)) { k = int.Parse(casQuery.type); cas = from d in cas where d.IS_AUDIT == k select d; } } cas = cas.GetPage(out num, casQuery.PageNo, casQuery.PageSize, (IQueryable <CAS_MAIN_INFO> d) => from o in d orderby o.ADD_DATE descending select o); return(new PageModel <CAS_MAIN_INFO>() { Models = cas, Total = num }); }
public int SearchCasInfoListCount(QueryModel.CAS_MAIN_INFOQuery casQuery, string islike) { int num = 0; try { IQueryable <CAS_MAIN_INFO> cas = context.CAS_MAIN_INFO.AsQueryable <CAS_MAIN_INFO>(); if (!string.IsNullOrWhiteSpace(casQuery.CAS_NUMBER)) { string search = casQuery.CAS_NUMBER; if (islike == "0") { if (Regex.IsMatch(search, @"[0-9?-]") && !Regex.IsMatch(search, @"[A-Za-z]+")) { cas = (from u in cas where u.CAS_NUMBER.Contains(search) orderby u.ADD_DATE descending select u); } else if (Regex.IsMatch(search, @"[\u4E00-\u9FA5]")) { cas = (from u in cas where u.CHINESE.Contains(search) || u.CHINESE_ALIAS.Contains(search) orderby u.ADD_DATE descending select u); } //else if (Regex.IsMatch(search, @"[A-Za-z0-9]+")) else { cas = (from u in cas where u.ENGLISH.Contains(search) || u.ENGLISH_ALIAS.Contains(search) orderby u.ADD_DATE descending select u); } } else //精确查询 { if (Regex.IsMatch(search, @"[0-9?-]") && !Regex.IsMatch(search, @"[A-Za-z]+")) { cas = (from u in cas where u.CAS_NUMBER.Equals(search) orderby u.ADD_DATE descending select u); } else if (Regex.IsMatch(search, @"[\u4E00-\u9FA5]")) { cas = (from u in cas where u.CHINESE.Equals(search) || u.CHINESE_ALIAS.Equals(search) orderby u.ADD_DATE descending select u); } //else if (Regex.IsMatch(search, @"[A-Za-z0-9]+")) else { cas = (from u in cas where u.ENGLISH.Equals(search) || u.ENGLISH_ALIAS.Equals(search) orderby u.ADD_DATE descending select u); } } } if (!string.IsNullOrWhiteSpace(casQuery.CAS_NUMBERList)) { List <string> listcas = new List <string>(); string[] array = casQuery.CAS_NUMBERList.Split('~'); for (int i = 0; i < array.Length; i++) { if (!string.IsNullOrWhiteSpace(array[i])) { listcas.Add(array[i]); } } cas = from d in cas where (from p in listcas select p).Contains(d.CAS_NUMBER) select d; } cas = cas.GetPage(out num, casQuery.PageNo, casQuery.PageSize, (IQueryable <CAS_MAIN_INFO> d) => from o in d orderby o.ADD_DATE descending select o); return(num); } catch (Exception) { return(0); } }
public PageModel <CAS_MAIN_INFO> SearchCasInfoList(QueryModel.CAS_MAIN_INFOQuery casQuery, string islike) { int num = 0; try { IQueryable <CAS_MAIN_INFO> cas = context.CAS_MAIN_INFO.AsQueryable <CAS_MAIN_INFO>(); if (!string.IsNullOrWhiteSpace(casQuery.CAS_NUMBER)) { string search = casQuery.CAS_NUMBER; #region 模糊查询 if (islike == "0") { if (Regex.IsMatch(search, @"[0-9?-]") && !Regex.IsMatch(search, @"[A-Za-z]+")) { cas = (from u in cas where u.CAS_NUMBER.Contains(search) orderby u.UPDATE_TIME descending select u).Skip(casQuery.PageSize * (casQuery.PageNo - 1)).Take(casQuery.PageSize); } else if (Regex.IsMatch(search, @"[\u4E00-\u9FA5]")) { cas = (from u in cas where u.CHINESE.Contains(search) || u.CHINESE_ALIAS.Contains(search) orderby u.UPDATE_TIME descending select u).Skip(casQuery.PageSize * (casQuery.PageNo - 1)).Take(casQuery.PageSize); } else { cas = (from u in cas where u.ENGLISH.Contains(search) || u.ENGLISH_ALIAS.Contains(search) orderby u.UPDATE_TIME descending select u).Skip(casQuery.PageSize * (casQuery.PageNo - 1)).Take(casQuery.PageSize); } } #endregion #region 精确查询 else { if (Regex.IsMatch(search, @"[0-9?-]") && !Regex.IsMatch(search, @"[A-Za-z]+")) { cas = (from u in cas where u.CAS_NUMBER.Equals(search) orderby u.UPDATE_TIME descending select u).Skip(casQuery.PageSize * (casQuery.PageNo - 1)).Take(casQuery.PageSize); } else if (Regex.IsMatch(search, @"[\u4E00-\u9FA5]")) { cas = (from u in cas where u.CHINESE.Equals(search) || u.CHINESE_ALIAS.Equals(search) orderby u.UPDATE_TIME descending select u).Skip(casQuery.PageSize * (casQuery.PageNo - 1)).Take(casQuery.PageSize); } else { cas = (from u in cas where u.ENGLISH.Equals(search) || u.ENGLISH_ALIAS.Equals(search) orderby u.UPDATE_TIME descending select u).Skip(casQuery.PageSize * (casQuery.PageNo - 1)).Take(casQuery.PageSize); } } #endregion } if (!string.IsNullOrWhiteSpace(casQuery.CAS_NUMBERList)) { List <string> listcas = new List <string>(); string[] array = casQuery.CAS_NUMBERList.Split('~'); for (int i = 0; i < array.Length; i++) { if (!string.IsNullOrWhiteSpace(array[i])) { listcas.Add(array[i]); } } cas = (from d in cas where (from p in listcas select p).Contains(d.CAS_NUMBER) orderby d.UPDATE_TIME descending select d).Skip(casQuery.PageSize * (casQuery.PageNo - 1)).Take(casQuery.PageSize); } return(new PageModel <CAS_MAIN_INFO>() { Models = cas, Total = cas.Count <CAS_MAIN_INFO>() }); } catch (Exception) { return(null); } }