private static void AddTest()
{
var repo = new AttacheFileRepository();
var model = new AttacheFileModel()
{
UserId = 5, BoardId = 4, ArticleId = 1, FileName = "photo.png", FileSize = 1024
};
repo.Add(model);
}
public void Add(AttacheFileModel model)
{
string sql = "AttachFileAdd";
//파라메터를 직접 구현
//db.Execute(sql, new { UserId = model.UserId}, commandType: CommandType.StoredProcedure );
var parameters = new DynamicParameters();
parameters.Add("@UserId", value: model.UserId, dbType: DbType.Int32, direction: ParameterDirection.Input);
parameters.Add("@BoardId", value: model.BoardId, dbType: DbType.Int32, direction: ParameterDirection.Input);
parameters.Add("@ArticleId", value: model.ArticleId, dbType: DbType.Int32, direction: ParameterDirection.Input);
parameters.Add("@FileName", value: model.FileName, dbType: DbType.String, direction: ParameterDirection.Input);
parameters.Add("@FileSize", value: model.FileSize, dbType: DbType.Int32, direction: ParameterDirection.Input);
db.Execute(sql, parameters, commandType: CommandType.StoredProcedure);
}
