public ResponseNewsSearch BookSearch(RequestNewsSearch request) { ResponseNewsSearch response = new ResponseNewsSearch(); using (cnn = GetConnection()) { var ts = cnn.BeginTransaction(); try { string sql = @"select id,title,content from TKS_FAS_News where type=@Type and status=1 order by Sort "; List <TKS_FAS_News> data = cnn.Query <TKS_FAS_News>(sql, new { Type = request.Type }, ts).ToList(); ts.Commit(); response.IsSuccess = true; response.Message = "加载完毕"; response.Data = data; return(response); } catch (Exception ex) { ts.Rollback(); return(this.DealException(response, ex) as ResponseNewsSearch); } } }
public ResponseNewsSearch NewsSearch(RequestNewsSearch request) { ResponseNewsSearch response = new ResponseNewsSearch(); using (cnn = GetConnection()) { var ts = cnn.BeginTransaction(); try { var user = this.UserInfoGetButAccount(request.Token, ts); string sql = this.GetPageSql("*", @" TKS_FAS_News where type=@Type and title like @Title ", " published_at desc ", request.PageSize, request.PageIndex); List <TKS_FAS_News> data = cnn.Query <TKS_FAS_News>(sql, new { Title = "%" + request.Title + "%", Type = request.Type }, ts).ToList(); string countSql = @"select count(1) from TKS_FAS_News where type=@Type and title like @Title "; int total = int.Parse(cnn.ExecuteScalar(countSql, new { Title = "%" + request.Title + "%", Type = request.Type }, ts).ToString()); ts.Commit(); response.IsSuccess = true; response.Message = "加载完毕"; response.PageIndex = request.PageIndex; response.Data = data; response.Total = total; return(response); } catch (Exception ex) { ts.Rollback(); return(this.DealException(response, ex) as ResponseNewsSearch); } } }