private static BulkUpdateEvent GetBulkUpdateEvent(Guid id)
{
var sql = "SELECT SysId, EventName,ExecuteStartDate, ExecuteEndDate,EventType FROM [ScheduleEvent].[dbo].BulkUpdateEvent WHERE SysId=@id ";
var cmd = new SqlCommand {
CommandText = sql
};
cmd.Parameters.Add(SafeSQL.CreateInputParam("@id", SqlDbType.UniqueIdentifier, id));
var dt = SqlDbmanager.queryBySql(cmd);
var updateEvent = new BulkUpdateEvent();
foreach (DataRow dr in dt.Rows)
{
updateEvent.SysId = Guid.Parse(dr["SysId"].ToString());
updateEvent.EventName = dr["EventName"].ToString();
updateEvent.ExecuteStartDate = DateTime.Parse(dr["ExecuteStartDate"].ToString());
updateEvent.EventType = int.Parse(dr["EventType"].ToString());
if (!string.IsNullOrEmpty(dr["ExecuteEndDate"].ToString()))
{
updateEvent.ExecuteEndDate = DateTime.Parse(dr["ExecuteEndDate"].ToString());
}
}
return(updateEvent);
}
private List <UpdateDetails> MapProductUpdateDetails(BulkUpdateEvent bulkUpdate)
{
var productIds = txtProductID.Text.TrimEnd(',').Split(',');
var eventList = new List <UpdateDetails>();
foreach (var pid in productIds)
{
switch (bulkUpdate.EventType)
{
case (int)BulkUpdateType.活動標題:
eventList.Add(MapProductEventUpdate(bulkUpdate.SysId, int.Parse(pid)));
break;
case (int)BulkUpdateType.商品上下架時間:
eventList.Add(MapProductDateUpdate(bulkUpdate.SysId, int.Parse(pid)));
break;
case (int)BulkUpdateType.品牌館權重調整:
eventList.Add(MapProductSortUpdate(bulkUpdate.SysId, int.Parse(pid)));
break;
case (int)BulkUpdateType.商品下架:
eventList.Add(MapProductStatusUpdate(bulkUpdate.SysId, int.Parse(pid)));
break;
case (int)BulkUpdateType.預購:
eventList.Add(MapProductPreOrderUpdate(bulkUpdate.SysId, int.Parse(pid)));
break;
}
}
return(eventList);
}
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));
}
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);
}
