public GridModel qryNewsDataForGrid(int page, int pageSize, string title, bool isRenge = false)
{
CommonService commonService = new CommonService();
List <TbNewsData> list = new List <TbNewsData>();
GridModel gridModel = new GridModel();
int totalCount = 0;
using (SqlConnection dbConn = new SqlConnection(DbConnection.connString)){
dbConn.Open();
dao.dbConn = dbConn;
try
{
int[] rowIndex = commonService.getRowRange(page, pageSize);
list = dao.qryNewsDataForGrid(rowIndex[0], rowIndex[1], title, isRenge);
totalCount = dao.qryNewsDataForGridCount(title, isRenge);
gridModel = commonService.setGridModel(page, pageSize, totalCount, list);
}
catch (Exception e)
{
logger.Error(e, e.Message);
}
}
return(gridModel);
}