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); }
private void MapEditEvent(BulkUpdateData data) { string productIds = ""; foreach (var updateDetails in data.UpdateDetails) { productIds += updateDetails.ProductId + ","; } txtProductID.Text = !string.IsNullOrEmpty(productIds) ? productIds.TrimEnd(',') : "";; txtAddExecuteSDate.Text = data.UpdateEvent.ExecuteStartDate.ToString("yyyy-MM-dd"); txtAddExecuteEDate.Text = data.UpdateEvent.ExecuteEndDate.HasValue ? data.UpdateEvent.ExecuteEndDate.Value.ToString("yyyy-MM-dd") : ""; ddlAddExecuteTime.SelectedValue = data.UpdateEvent.ExecuteStartDate.ToString("HHmm"); txtAddUpdateName.Text = data.UpdateEvent.EventName; ddlAddBulkUpdateType.SelectedValue = data.UpdateEvent.EventType.ToString(); ddlAddBulkUpdateType_SelectedIndexChanged(ddlAddBulkUpdateType, null); ddlAddBulkUpdateType.Enabled = false; }
private BulkUpdateData MapProductBulkUpdate() { var bulkUpdateEvent = new BulkUpdateEvent(); var updateData = new BulkUpdateData(); var executeStartDatestr = txtAddExecuteSDate.Text + " " + ddlAddExecuteTime.SelectedItem.Text; bulkUpdateEvent.EventName = txtAddUpdateName.Text; bulkUpdateEvent.ExecuteStartDate = DateTime.Parse(executeStartDatestr); bulkUpdateEvent.EventType = int.Parse(ddlAddBulkUpdateType.SelectedValue); bulkUpdateEvent.SysId = btnEdit.Visible ? Guid.Parse(hfSysId.Value) : Guid.NewGuid(); if (divExecuteEDate.Visible) { var executeEndDatestr = txtAddExecuteEDate.Text + " " + ddlAddExecuteTime.SelectedItem.Text; bulkUpdateEvent.ExecuteEndDate = DateTime.Parse(executeEndDatestr); } updateData.UpdateDetails = MapProductUpdateDetails(bulkUpdateEvent); updateData.UpdateEvent = bulkUpdateEvent; return(updateData); }
private void MapEditDetails(BulkUpdateData data) { if (data.UpdateDetails == null || data.UpdateDetails.Count == 0) { return; } switch (data.UpdateEvent.EventType) { case (int)BulkUpdateType.品牌館權重調整: var productSort = (ProductSortUpdate)data.UpdateDetails.FirstOrDefault(); txtAddSort.Text = productSort.ProductSort.ToString(); break; case (int)BulkUpdateType.商品上下架時間: var productDate = (ProductDateUpdate)data.UpdateDetails.FirstOrDefault(); txtAddProductSDate.Text = productDate.StartDate.HasValue ? productDate.StartDate.Value.ToString("yyyy-MM-dd") : ""; txtAddProductEDate.Text = productDate.EndDate.HasValue ? productDate.EndDate.Value.ToString("yyyy-MM-dd") : ""; break; case (int)BulkUpdateType.商品下架: var productStatus = (ProductStatusUpdate)data.UpdateDetails.FirstOrDefault(); ddlAddProductStatus.SelectedValue = productStatus.ProductStatus.ToString(); break; case (int)BulkUpdateType.活動標題: var productEvent = (ProductEventUpdate)data.UpdateDetails.FirstOrDefault(); txtAddEventNameCN.Text = productEvent.EventNameCN.ToString(); txtAddEventNameEN.Text = productEvent.EventNameEN.ToString(); break; case (int)BulkUpdateType.預購: var productPreOrderUpdate = (ProductPreOrderUpdate)data.UpdateDetails.FirstOrDefault(); txtAddPreOrderQuantity.Text = productPreOrderUpdate.PreOrderQuantity.ToString(); ddlAddProductStatus.SelectedValue = productPreOrderUpdate.PreOrderStatus.ToString(); break; } }