public async Task <List <CommonModel> > GetCommonJavLibraryModelByType(CommonModelType type)
{
var sql = @"SELECT * FROM CommonJavLibraryModel WITH(NOLOCK) WHERE Type = @type";
return(await QueryAsync <CommonModel>(sql, new { type }));
}
public async Task <int> InsertAvMapping(int avId, int commonId, CommonModelType typeId)
{
var sql = @"INSERT INTO AvMapping (AvId, CommonId, CommonType) VALUES (@avId, @commonId, @typeId)";
return(await ExecuteAsync(sql, new { avId, commonId, typeId }));
}
