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