public int AddBulkUpdate(BulkUpdateData productBulkUpdateData)
{
_bulkUpdateDetailsService = _updateDetailsFactory.CreateService(productBulkUpdateData.UpdateEvent.EventType);
var cmdList = new List <SqlCommand>();
cmdList.Add(SqlExtension.getInsertSqlCmd("[ScheduleEvent].[dbo].BulkUpdateEvent", productBulkUpdateData.UpdateEvent));
cmdList.AddRange(_bulkUpdateDetailsService.AddBulkUpdate(productBulkUpdateData.UpdateDetails));
return(SqlDbmanager.executeNonQryMutiSqlCmd(cmdList));
}
public BulkUpdateData GetBulkUpdateData(Guid id)
{
var updateEvent = GetBulkUpdateEvent(id);
var eventData = new BulkUpdateData();
_bulkUpdateDetailsService = _updateDetailsFactory.CreateService(updateEvent.EventType);
eventData.UpdateEvent = updateEvent;
eventData.UpdateDetails = _bulkUpdateDetailsService.GetBulkUpdate(updateEvent.SysId);
return(eventData);
}
public bool UpdateBulkUpdate(BulkUpdateData productBulkUpdate)
{
_bulkUpdateDetailsService = _updateDetailsFactory.CreateService(productBulkUpdate.UpdateEvent.EventType);
var excludeUpdateColumns = new List <string> {
"ProductID", "SysId", "ExecuteDate"
};
var whereColumns = new List <string> {
"SysId=@SysId"
};
var cmd = SqlExtension.getUpdateSqlCmd("[ScheduleEvent].[dbo].BulkUpdateEvent", productBulkUpdate.UpdateEvent, excludeUpdateColumns, whereColumns);
var cmdList = new List <SqlCommand>();
cmdList.Add(cmd);
cmdList.AddRange(_bulkUpdateDetailsService.EditBulkUpdate(productBulkUpdate.UpdateDetails));
return(SqlDbmanager.executeNonQryMutiSqlCmd(cmdList) == 1);
}
