public bool UpdateProduct(Guid eventId)
{
var sql = @" UPDATE WP
SET WP07 = ProductStatus
FROM WP
INNER JOIN [ScheduleEvent].[dbo].ProductStatusUpdate PSU ON PSU.ProductId = WP.WP01
INNER JOIN [ScheduleEvent].[dbo].BulkUpdateEvent BUE ON BUE.SysId = PSU.EventId
WHERE BUE.SysId = @EventId
AND BUE.Status = 1
AND PSU.Status = 1 ";
var cmd = new SqlCommand {
CommandText = sql
};
var cmdUpdateStatus = new SqlCommand {
CommandText = "UPDATE [ScheduleEvent].[dbo].BulkUpdateEvent SET Status = 2 WHERE SysId = @EventId"
};
cmd.Parameters.Add(SafeSQL.CreateInputParam("@EventId", SqlDbType.UniqueIdentifier, eventId));
cmdUpdateStatus.Parameters.Add(SafeSQL.CreateInputParam("@EventId", SqlDbType.UniqueIdentifier, eventId));
var cmdList = new List <SqlCommand>();
cmdList.Add(cmd);
cmdList.Add(cmdUpdateStatus);
return(SqlDbmanager.executeNonQryMutiSqlCmd(cmdList) == 1);
}
public int DeleteBulkUpdate(Guid eventId)
{
var exludeUpdateCol = new List <string> {
"SysId", "ExecuteStartDate", "EventType"
};
var cmdList = new List <SqlCommand>();
var bulkupdateEvent = new BulkUpdateEvent {
SysId = eventId, Status = (int)BulkUpdateStatus.已刪除
};
cmdList.Add(SqlExtension.getUpdateSqlCmd("[ScheduleEvent].[dbo].BulkUpdateEvent", bulkupdateEvent, exludeUpdateCol, new List <string> {
"SysId=@SysId"
}));
cmdList.Add(SqlExtension.getUpdateSqlCmd("[ScheduleEvent].[dbo].ProductDateUpdate", bulkupdateEvent, exludeUpdateCol, new List <string> {
"EventId=@SysId"
}));
cmdList.Add(SqlExtension.getUpdateSqlCmd("[ScheduleEvent].[dbo].ProductEventUpdate", bulkupdateEvent, exludeUpdateCol, new List <string> {
"EventId=@SysId"
}));
cmdList.Add(SqlExtension.getUpdateSqlCmd("[ScheduleEvent].[dbo].ProductPreOrderUpdate", bulkupdateEvent, exludeUpdateCol, new List <string> {
"EventId=@SysId"
}));
cmdList.Add(SqlExtension.getUpdateSqlCmd("[ScheduleEvent].[dbo].ProductSortUpdate", bulkupdateEvent, exludeUpdateCol, new List <string> {
"EventId=@SysId"
}));
cmdList.Add(SqlExtension.getUpdateSqlCmd("[ScheduleEvent].[dbo].ProductStatusUpdate", bulkupdateEvent, exludeUpdateCol, new List <string> {
"EventId=@SysId"
}));
return(SqlDbmanager.executeNonQryMutiSqlCmd(cmdList));
}
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 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);
}
