public List <TStationEntity> GetStationListByQueryModel(StationQuery lineQuery) { var mResult = new List <TStationEntity>(); using (IDbConnection conn = new SqlConnection(GetConnstr)) { StringBuilder strSql = new StringBuilder("Select * from tStation where 1=1 "); if (!string.IsNullOrWhiteSpace(lineQuery.keyWords)) { strSql.Append(" and (StationCode=@keyWords or StationName=@keyWords or StationFullName=@keyWords or LineCode=@keyWords or LineName=@keyWords) "); } var param = new { keyWords = lineQuery.keyWords }; mResult = conn.Query <TStationEntity>(strSql.ToString(), param).ToList(); } return(mResult); }
public ActionResult StationListResult(StationQuery stationQuery) { var stationList = tStationRepository.GetStationListByQueryModel(stationQuery); return View(stationList); }