/// <summary> /// 根据供货收货单位名称或首字母模糊查询数据 /// </summary> /// <param name="name"></param> /// <param name="sqlWhere">条件语句</param> /// <returns></returns> public List <CmcsSupplyReceive> GetSupplyReceiveByNameOrChs(string name, string sqlWhere) { List <CmcsSupplyReceive> res = SelfDber.Entities <CmcsSupplyReceive>(sqlWhere); if (!string.IsNullOrEmpty(name)) { return(res.Where(a => { if (a.UnitName.ToUpper().Contains(name.ToUpper())) { return true; } if (ChsSpeller.GetFirst(a.UnitName).ToUpper().Contains(name.ToUpper())) { return true; } return false; }).ToList()); } else { return(res); } }
/// <summary> /// 根据运输单位名称或首字母模糊查询数据 /// </summary> /// <param name="name"></param> /// <param name="sqlWhere">条件语句</param> /// <returns></returns> public List <CmcsTransportCompany> GetTransportCompanyByNameOrChs(string name, string sqlWhere) { List <CmcsTransportCompany> res = SelfDber.Entities <CmcsTransportCompany>(sqlWhere); if (!string.IsNullOrEmpty(name)) { return(res.Where(a => { if (a.Name.ToUpper().Contains(name.ToUpper())) { return true; } if (ChsSpeller.GetFirst(a.Name).ToUpper().Contains(name.ToUpper())) { return true; } return false; }).ToList()); } else { return(res); } }