public int Save(BookParagraphEntity data)
{
try
{
return(Connection.Db.Query <int>("spBookParagraphSet",
new
{
ID = data.Id,
BookId = data.BookId,
TitleNumber = data.TitleNumber,
HeadrNumber = data.HeadrNumber,
Title = data.Title,
Text = data.Text,
}, commandType: CommandType.StoredProcedure).SingleOrDefault());
}
catch (Exception ex)
{
SaveLog.Save(ex);
return(-1);
}
}
public List <BookParagraphEntity> Search(BookParagraphEntity data)
{
try
{
return(Connection.Db.Query <BookParagraphEntity>("spBookParagraphSearch",
new
{
ID = data.Id,
BookId = data.BookId,
TitleNumber = data.TitleNumber,
HeadrNumber = "%" + data.HeadrNumber + "%",
Title = "%" + data.Title + "%",
Text = "%" + data.Text + "%",
}, commandType: CommandType.StoredProcedure).ToList());
}
catch (Exception ex)
{
SaveLog.Save(ex);
return(new List <BookParagraphEntity>());
}
}
