public async Task <int> InsertAsync(ExternNews model, IDbTransaction trans, IDbConnection conn)
{
string sql = "INSERT INTO ExternNews (SourceType,SourceId,IsPublish,Title,ContractId) VALUES (@SourceType,@SourceId,@IsPublish,@Title,@ContractId);";
if (trans == null)
{
return(await conn.ExecuteAsync(sql, param : model, commandType : CommandType.Text));
}
else
{
return(await conn.ExecuteAsync(sql, param : model, commandType : CommandType.Text, transaction : trans));
}
}
public async Task <int> UpdateAsync(ExternNews model, IDbTransaction trans, IDbConnection conn)
{
string sql = "UPDATE ExternNews SET SourceType=@SourceType, SourceId=@SourceId, IsPublish=@IsPublish, Title=@Title, ContractId=@ContractId WHERE 1=1 AND Id=@Id";
if (trans == null)
{
return(await conn.ExecuteAsync(sql, param : model, commandType : CommandType.Text));
}
else
{
return(await conn.ExecuteAsync(sql, param : model, commandType : CommandType.Text, transaction : trans));
}
}
public async Task <int> InsertUpdateAsync(ExternNews model, IDbTransaction trans, IDbConnection conn)
{
string sql = "UPDATE ExternNews SET SourceType=@SourceType, SourceId=@SourceId, IsPublish=@IsPublish, Title=@Title, ContractId=@ContractId WHERE 1=1 AND Id=@Id;INSERT INTO ExternNews (SourceType,SourceId,IsPublish,Title,ContractId) SELECT @SourceType,@SourceId,@IsPublish,@Title,@ContractId WHERE NOT EXISTS (SELECT 1 FROM ExternNews where 1=1 AND Id=@Id)";
if (trans == null)
{
return(await conn.ExecuteAsync(sql, param : model, commandType : CommandType.Text));
}
else
{
return(await conn.ExecuteAsync(sql, param : model, commandType : CommandType.Text, transaction : trans));
}
}
public async Task <int> InsertAsync(ExternNews model)
{
using Connector conn = ConnectionProvider.GetConnection();
return(await InsertAsync(model, null, conn.Connection));
}
public int Insert(ExternNews model)
{
using Connector conn = ConnectionProvider.GetConnection();
return(Insert(model, null, conn.Connection));
}
public int Update(ExternNews model)
{
using Connector conn = ConnectionProvider.GetConnection();
return(Update(model, null, conn.Connection));
}
