public static int GetCount(string board_type)
{
return(PgSqlDapperHelper.RunGetQueryFromXml <int>("Sql/Board_pg.xml", "GetBoardCount", new
{
board_type = board_type,
}).FirstOrDefault());
}
/* 필요한가?
* public string UPDATE_IP { get; set; }
* public string UPDATE_USER { get; set; }
* public string UPDATE_USERNAME { get; set; }
* public DateTime? UPDATE_DATE { get; set; }
*/
public static BoardModel Get(string board_type, int seq)
{
return(PgSqlDapperHelper.RunGetQueryFromXml <BoardModel>("Sql/Board_pg.xml", "GetBoard", new
{
board_type = board_type,
seq = seq
}).FirstOrDefault());
}
public static async Task <BoardModel> GetAsync(string board_type, int seq)
{
var model = await PgSqlDapperHelper.RunGetQueryFromXmlAsync <BoardModel>("Sql/Board_pg.xml", "GetBoard", new
{
board_type = board_type,
seq = seq
});
return(model.FirstOrDefault());
}
public static async Task <IEnumerable <BoardModel> > GetListAsync(string board_type, int page = 1, int page_size = 20)
{
//데이터가 많아지면 LIMIT가 느려질수 있다고함, WHERE 로 모집합을 줄이고 LIMIT를 걸어야한다고....
var sql = PgSqlDapperHelper.GetSqlFromXml("Sql/Board_pg.xml", "GetBoardList");
var limit = $" LIMIT {(page - 1) * page_size}, {page_size}";
return(await PgSqlDapperHelper.RunGetQueryAsync <BoardModel>(sql, new
{
board_type = board_type,
}));
}
public int Insert(PgSqlDapperHelper db)
{
return(db.ExecuteFromXml("Sql/Board_pg.xml", "InsertBoard", this));
}
public int AddViewCount()
{
return(PgSqlDapperHelper.RunExecuteFromXml("Sql/Board_pg.xml", "UpdateViewCount", this));
}
