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 BookSearch([FromBody] RequestNewsSearch request)
{
try
{
NewsBLL bll = new NewsBLL();
return(bll.BookSearch(request));
}
catch (Exception ex)
{
throw new HttpResponseException(
Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex.Message));
}
}
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);
}
}
}
