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)); }