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