public ActionResult <string> SetData(WorkOrderDetailModifyModel data)
{
var newData = new WorkOrderDetail()
{
DetailID = data.DetailID,
WorkOrderID = data.WorkOrderID,
SN = data.SN,
CreateTime = data.CreateTime,
TestCount = data.TestCount
};
try
{
if (repository.SaveData(newData))
{
return(ActionResult <string> .SetSuccess($"保存 {ItemName} 成功", "保存成功"));
}
else
{
return(ActionResult <string> .SetError($"{ItemName} 已经被删除", "保存失败"));
}
}
catch (Exception ex)
{
return(ActionResult <string> .SetError(ex.Message, "保存失败"));
}
}
public JsonResult Update([Bind(Include = "WoNumber,Customer,CustomerPO,SalesOrder,DueDate,AssemblyNumber,QuantityToBuild,WoStatus,SalesOrderLineItemNo")] WorkOrderDetail detail)
{
if (ModelState.IsValid)
{
WorkOrder workorder = new WorkOrder();
CopyPropertyValues.CopyPropertiesTo <WorkOrderDetail, WorkOrder>(detail, workorder);
WorkOrder updated = workOrdersRepo.Update(workorder);
return(Json(new { success = true, model = updated }));
}
return(JsonErrorResult());
}
public ActionResult Add([Bind(Include = "WoNumber,Customer,CustomerPO,SalesOrder,DueDate,AssemblyNumber,QuantityToBuild,WoStatus,SalesOrderLineItemNo")] WorkOrderDetail detail)
{
if (ModelState.IsValid)
{
WorkOrder workorder = new WorkOrder();
CopyPropertyValues.CopyPropertiesTo <WorkOrderDetail, WorkOrder>(detail, workorder);
try
{
WorkOrder retrieved = workOrdersRepo.Add(workorder);
return(Json(new { success = true, model = retrieved }));
}
catch (Exception ex)
{
if (ex.Message == "Duplicate WoNumber")
{
ModelState.AddModelError("WoNumber", "Duplicate WO Number.");
}
}
}
return(JsonErrorResult());
}
public JsonResult Delete([Bind(Include = "WoNumber")] WorkOrderDetail detail)
{
if (detail.WoNumber == null)
{
return(Json(new { success = false, ErrorMessage = "WoNumber cannot be null." }));
}
try
{
var result = workOrdersRepo.Remove(detail.WoNumber);
if (result == 1)
{
return(Json(new { success = true }));
}
return(Json(new { success = false, ErrorMessage = "Failed to delete WoNumber " + detail.WoNumber }));
}
catch (Exception ex)
{
return(Json(new { success = false, ErrorMessage = ex.Message }));
}
}
public static List <WorkOrderDetail> ConverToViewModel(this List <bx_consumer_review> workOrderDetail)
{
List <WorkOrderDetail> list = new List <WorkOrderDetail>();
WorkOrderDetail detail;
if (workOrderDetail != null)
{
foreach (var item in workOrderDetail)
{
detail = new WorkOrderDetail();
detail.Id = item.id;
detail.Result_Status = item.result_status;
detail.Recall_Time = item.next_review_date.HasValue ? item.next_review_date.Value.ToString("yyyy-MM-dd HH:mm") : null;
detail.Agent_Id = item.operatorId;
detail.AgentName = item.operatorName;
detail.Create_Time = item.create_time.HasValue ? item.create_time.Value.ToString("yyyy-MM-dd HH:mm") : null;
detail.IntentionCompany = item.intentioncompany;
detail.Remark = item.content;
list.Add(detail);
}
}
return(list);
}
public int Delete(WorkOrderDetail _WorkOrderDetail)
{
return(WorkOrderDetailDaoRepository.Delete(_WorkOrderDetail));
}
public int Update(WorkOrderDetail _WorkOrderDetail)
{
return(WorkOrderDetailDaoRepository.Update(_WorkOrderDetail));
}
public int Insert(WorkOrderDetail _WorkOrderDetail)
{
return(WorkOrderDetailDaoRepository.Insert(_WorkOrderDetail));
}
public bool Validate(WorkOrderDetail _WorkOrderDetail, out List <string> lstMessages)
{
return(WorkOrderDetailDaoRepository.Validate(_WorkOrderDetail, out lstMessages));
}
/// <summary>
/// There are no comments for WorkOrderDetail in the schema.
/// </summary>
public void AddToWorkOrderDetail(WorkOrderDetail workOrderDetail)
{
base.AddObject("WorkOrderDetail", workOrderDetail);
}
/// <summary>
/// Create a new WorkOrderDetail object.
/// </summary>
/// <param name="workFlowDetailId">Initial value of WorkFlowDetailId.</param>
/// <param name="priorityId">Initial value of PriorityId.</param>
public static WorkOrderDetail CreateWorkOrderDetail(int workFlowDetailId, int priorityId)
{
WorkOrderDetail workOrderDetail = new WorkOrderDetail();
workOrderDetail.WorkFlowDetailId = workFlowDetailId;
workOrderDetail.PriorityId = priorityId;
return workOrderDetail;
}
public DataValidatorReturn Delete(int activityTypeID)
{
DVR = MethodHelper.IsGreaterThanZero("Activity Type", activityTypeID);
if (DVR.IsValid == false)
{
return(DVR);
}
DataValidatorReturn dvr = new DataValidatorReturn();
dvr = Find(activityTypeID);
if (dvr.ItemFound == false)
{
DVR.IsValid = false;
DVR.ReturnText = activityTypeID + " not found.";
DVR.ItemFound = false;
return(DVR);
}
using (var context = new WorkOrderLogEntities())
{
try
{
int numWorkOrderDetails = 0;
int numActivities = 0;
int currentActivityId = 0;
//Delete foreign relationships etc.
//Get the activities.
var activities = context.Activities.Where(x => x.ActivityTypeID == activityTypeID).ToList();
if (activities.Any())
{
numActivities = activities.Count();
for (int i = 0; i < numActivities; i++)
{
currentActivityId = activities[i].ActivityID;
List <WorkOrderDetail> workOrderDetails = context.WorkOrderDetails.Where(x => x.ActivityID == currentActivityId).ToList();
if (workOrderDetails.Any())
{
numWorkOrderDetails = workOrderDetails.Count();
for (int j = 0; j < numWorkOrderDetails; j++)
{
WorkOrderDetail workOrderDetail = workOrderDetails[j];
context.WorkOrderDetails.Remove(workOrderDetail);
}
}
Activity activity = activities[i];
context.Activities.Remove(activity);
}
}
ActivityType activityType = context.ActivityTypes.Where(x => x.ActivityTypeID == activityTypeID).FirstOrDefault();
context.ActivityTypes.Remove(activityType);
context.SaveChanges();
DVR.IsValid = true;
DVR.ReturnText = activityType.ShortDescription + " Removed Successfully." + Environment.NewLine + numActivities.ToString() +
" Activities Removed successfully." + Environment.NewLine +
numWorkOrderDetails + " Removed Successfully.";
}
catch (Exception exception)
{
DVR.IsValid = false;
DVR.ErrorText = exception.Message;
}
}
return(DVR);
}
public DataValidatorReturn Create(int workOrderID, int itemNumber, int activityID)
{
WorkOrderHeader workOrderHeader = null;
DVR = MethodHelper.IsGreaterThanZero("Work Order Number", workOrderID);
if (DVR.IsValid == false)
{
return(DVR);
}
DVR = MethodHelper.IsGreaterThanZero("Item Number", itemNumber);
if (DVR.IsValid == false)
{
return(DVR);
}
DVR = MethodHelper.IsGreaterThanZero("Activity ID", activityID);
if (DVR.IsValid == false)
{
return(DVR);
}
if (Find(workOrderID, itemNumber, activityID).ItemFound)
{
DVR.IsValid = false;
DVR.ReturnText = "Work Order Detail # " + workOrderID.ToString() + " already exists.";
DVR.ItemFound = true;
return(DVR);
}
BO_WorkOrderHeader bo_WorkOrderHeader = new BO_WorkOrderHeader();
DVR = bo_WorkOrderHeader.Find(workOrderID);
if (DVR.ItemFound == false)
{
DVR.IsValid = false;
DVR.ReturnText = "Work Order Header # " + workOrderID.ToString() + " doesn't exist.";
DVR.ItemFound = true;
return(DVR);
}
else
{
workOrderHeader = DVR.ReturnType as WorkOrderHeader;
}
using (var context = new WorkOrderLogEntities())
{
// Find the work Order Header here.
WorkOrderDetail workOrderDetail = new WorkOrderDetail()
{
WOHdrID = workOrderID,
ItemNumber = itemNumber,
ActivityID = activityID
};
try
{
int activityTypeID = 2;
context.WorkOrderDetails.Add(workOrderDetail);
context.SaveChanges();
//Once we have created a work order detail need to look for the
//Activity using the activity Id, and then get the activityTypeId
//Go to the sourcescripthdr table and get the sourcescripthdrid
//and use the info from the sourcescriptdtl table to create
//WorkOrderDtlScript records also need to create these actual files
//by retrieving the source items and pasting to the new files.
BO_SourceScriptHdr bo_SourceScriptHdr = new BO_SourceScriptHdr();
DataValidatorReturn dataValidatorReturn = bo_SourceScriptHdr.Find(activityTypeID);
if (dataValidatorReturn.ItemFound)
{
var sourceScriptHdr = dataValidatorReturn.ReturnType as SourceScriptHdr;
var sourceScriptDtls = sourceScriptHdr.SourceScriptDtls;
if (sourceScriptDtls.Any())
{
string sourceFileFullPath = string.Empty;
string sourceFile = string.Empty;
string sourceClientCode = string.Empty;
string destFile = string.Empty;
string destClientCode = string.Empty;
string destFileFullPath = string.Empty;
string destFolder = string.Empty;
string sourceFileContents = string.Empty;
string destFileContents = string.Empty;
foreach (SourceScriptDtl sourceScriptDtl in sourceScriptDtls)
{
// Set the source File.
sourceFile = sourceScriptDtl.SourceFile;
sourceClientCode = sourceScriptDtl.ClientCode;
sourceFileFullPath = Path.Combine(sourceScriptDtl.Client.ClientFolder, sourceScriptDtl.SourceFile);
destClientCode = workOrderHeader.ClientCode;
destFile = sourceFile.Replace(sourceClientCode, destClientCode);
destFolder = workOrderHeader.Client.ClientFolder;
destFileFullPath = Path.Combine(destFolder, destFile);
// Logic change instead of copying, replace text required
sourceFileContents = File.ReadAllText(sourceFileFullPath);
destFileContents = sourceFileContents.Replace(sourceClientCode, destClientCode);
destFileContents = destFileContents.Replace("0", workOrderHeader.WOHdrID.ToString());
File.WriteAllText(destFileFullPath, destFileContents);
//Create WorkOrderDetailScripts foreach script created.
BO_WorkOrderDtlScripts bo_WorkOrderDtlScripts = new BO_WorkOrderDtlScripts();
bo_WorkOrderDtlScripts.Create(workOrderDetail.WODtlId, destFile);
}
context.SaveChanges();
}
}
DVR.IsValid = true;
DVR.ReturnText = "Work Order Detail #" + workOrderID.ToString() + " Added to the Database.";
DVR.ReturnType = workOrderDetail;
}
catch (Exception exception)
{
DVR.IsValid = false;
DVR.ReturnText = exception.Message;
}
}
return(DVR);
}
