public JsonResult SaveReportAccessory(ReportAccessoryInfo reportAccessory)
{
ResultModel <ReportAccessoryInfo> result = new ResultModel <ReportAccessoryInfo>();
if (CheckSession(false) == false)
{
return(Json(ResultModelBase.CreateTimeoutModel(), JsonRequestBehavior.AllowGet));
}
if (CheckSessionID() == false)
{
return(Json(ResultModelBase.CreateLogoutModel(), JsonRequestBehavior.AllowGet));
}
try
{
List <UploadFileInfo> fileReportAccessories = GetUploadFilesInSession();
if (fileReportAccessories != null)
{
foreach (UploadFileInfo file in fileReportAccessories)
{
file.FileContent = ParseBase64String(file.FileContent);
}
}
reportAccessory = dispatchManager.SaveReportAccessory(reportAccessory, fileReportAccessories);
result.Data = reportAccessory;
}
catch (Exception ex)
{
NLog.LogManager.GetCurrentClassLogger().Error(ex, ex.Message);
result.SetFailed(ResultCodes.SystemError, ControlManager.GetSettingInfo().ErrorMessage);
}
return(JsonResult(result));
}
public ReportAccessoryInfo SaveReportAccessory(ReportAccessoryInfo reportAccessory, List <UploadFileInfo> fileReportAccessories)
{
reportAccessory.ID = this.dispatchReportDao.AddReportAccessory(reportAccessory);
if (fileReportAccessories != null)
{
foreach (UploadFileInfo file in fileReportAccessories)
{
file.ObjectID = reportAccessory.ID;
file.ObjectName = ObjectTypes.ReportAccessory;
file.ID = this.fileManager.SaveUploadFile(file).ID;
file.FileContent = "";
}
reportAccessory.FileInfos = fileReportAccessories;
}
return(reportAccessory);
}
/// <summary>
/// 新增零配件信息
/// </summary>
/// <param name="reportAccessory">零配件信息信息</param>
/// <returns>零配件信息ID</returns>
public int AddReportAccessory(ReportAccessoryInfo reportAccessory)
{
sqlStr = "INSERT INTO tblReportAccessory(DispatchReportID, Name, SourceID, SupplierID, NewSerialCode, OldSerialCode, Qty, Amount) " +
" VALUES(@DispatchReportID, @Name, @SourceID, @SupplierID, @NewSerialCode, @OldSerialCode, @Qty, @Amount); " +
" SELECT @@IDENTITY";
using (SqlCommand command = ConnectionUtil.GetCommand(sqlStr))
{
command.Parameters.Add("@DispatchReportID", SqlDbType.Int).Value = reportAccessory.DispatchReportID;
command.Parameters.Add("@Name", SqlDbType.NVarChar).Value = SQLUtil.TrimNull(reportAccessory.Name);
command.Parameters.Add("@SourceID", SqlDbType.Int).Value = reportAccessory.Source.ID;
command.Parameters.Add("@SupplierID", SqlDbType.Int).Value = SQLUtil.ZeroToNull(reportAccessory.Supplier.ID);
command.Parameters.Add("@NewSerialCode", SqlDbType.VarChar).Value = SQLUtil.TrimNull(reportAccessory.NewSerialCode);
command.Parameters.Add("@OldSerialCode", SqlDbType.VarChar).Value = SQLUtil.TrimNull(reportAccessory.OldSerialCode);
command.Parameters.Add("@Qty", SqlDbType.Int).Value = reportAccessory.Qty;
command.Parameters.Add("@Amount", SqlDbType.Decimal).Value = reportAccessory.Amount;
reportAccessory.ID = SQLUtil.ConvertInt(command.ExecuteScalar());
}
return(reportAccessory.ID);
}
private void GenerateRequestRepair4Expense(ref int nextRequestId, ref int nextDispatchId, ref int nextDispatchReportId, DateTime fromDate)
{
DateTime yearEnd = GetYearEndDate(fromDate);
List <ServiceHisInfo> incomeInfos = this.queryDao.GetServiceHis(fromDate.Year);
List <EntityInfo> requestInfos = new List <EntityInfo>();
List <EntityInfo> requestEqupInfos = new List <EntityInfo>();
List <EntityInfo> dispatchInfos = new List <EntityInfo>();
List <EntityInfo> journalInfos = new List <EntityInfo>();
List <EntityInfo> reportInfos = new List <EntityInfo>();
List <EntityInfo> reportAccessoryInfos = new List <EntityInfo>();
foreach (ServiceHisInfo info in incomeInfos)
{
nextRequestId++;
RequestInfo requestInfo = new RequestInfo();
requestInfo.ID = nextRequestId;
requestInfo.RequestType.ID = RequestInfo.RequestTypes.Repair;
requestInfo.Source.ID = 1;
requestInfo.RequestUser.ID = 6;
requestInfo.FaultDesc = "无法开机";
requestInfo.Status.ID = 99;
requestInfo.DealType.ID = 1;
requestInfo.Priority.ID = 1;
requestInfo.MachineStatus.ID = 1;
requestInfo.RequestDate = GetRandom(fromDate, fromDate, yearEnd, yearEnd);
requestInfo.RequestDate = requestInfo.RequestDate.AddHours(this.rd.Next(8, 14)).AddMinutes(this.rd.Next(0, 60));
requestInfo.DistributeDate = requestInfo.RequestDate.AddMinutes(this.rd.Next(2, 5));
requestInfo.ResponseDate = requestInfo.DistributeDate.AddMinutes(this.rd.Next(5, 10));
requestInfo.CloseDate = requestInfo.ResponseDate.AddMinutes(this.rd.Next(30, 60));
requestInfos.Add(requestInfo);
requestEqupInfos.Add(new RequestEqptInfo()
{
RequestID = requestInfo.ID, EquipmentID = info.EquipmentID
});
nextDispatchId++;
DispatchInfo dispatchInfo = new DispatchInfo();
dispatchInfo.ID = nextDispatchId;
dispatchInfo.Request.ID = requestInfo.ID;
dispatchInfo.RequestType.ID = requestInfo.RequestType.ID;
dispatchInfo.Urgency.ID = 1;
dispatchInfo.MachineStatus.ID = 1;
dispatchInfo.Engineer.ID = 4;
dispatchInfo.ScheduleDate = requestInfo.DistributeDate;
dispatchInfo.Status.ID = 4;
dispatchInfo.CreateDate = dispatchInfo.ScheduleDate;
dispatchInfo.StartDate = requestInfo.ResponseDate;
dispatchInfo.EndDate = requestInfo.CloseDate;
dispatchInfos.Add(dispatchInfo);
DispatchJournalInfo journalInfo = new DispatchJournalInfo();
journalInfo.DispatchID = dispatchInfo.ID;
journalInfo.FaultCode = "错误代码112";
journalInfo.JobContent = "检查电源和操作系统";
journalInfo.ResultStatus.ID = 2;
journalInfo.Advice = "恢复出厂设置";
journalInfo.UserName = "******";
journalInfo.UserMobile = "18866881888";
journalInfo.Status.ID = 3;
journalInfos.Add(journalInfo);
nextDispatchReportId++;
DispatchReportInfo reportInfo = new DispatchReportInfo();
reportInfo.ID = nextDispatchReportId;
reportInfo.DispatchID = dispatchInfo.ID;
reportInfo.Type.ID = 1;
reportInfo.FaultCode = "112";
reportInfo.FaultDesc = "无法开机";
reportInfo.SolutionCauseAnalysis = "系统设置错误";
reportInfo.SolutionWay = "恢复出厂设置";
reportInfo.SolutionResultStatus.ID = 4;
reportInfo.Status.ID = 3;
reportInfos.Add(reportInfo);
ReportAccessoryInfo accessoryInfo = new ReportAccessoryInfo();
accessoryInfo.DispatchReportID = reportInfo.ID;
accessoryInfo.Name = "监控";
accessoryInfo.Source.ID = 1;
accessoryInfo.SupplierID = 3;
accessoryInfo.NewSerialCode = this.rd.Next(100000, 500000).ToString();
accessoryInfo.OldSerialCode = this.rd.Next(500000, 1000000).ToString();
accessoryInfo.Qty = 1;
if (info.EquipmentID == 528)
{
accessoryInfo.Amount = this.rd.Next((int)(info.Income * 1.29), (int)(info.Income * 1.31));
}
else
{
accessoryInfo.Amount = this.rd.Next((int)(info.Income * 0.29), (int)(info.Income * 0.31));
}
reportAccessoryInfos.Add(accessoryInfo);
}
this.importDao.ImportRequest(requestInfos);
this.importDao.ImportRequestEqpt(requestEqupInfos);
this.importDao.ImportDispatch(dispatchInfos);
this.importDao.ImportDispatchJournal(journalInfos);
this.importDao.ImportDispatchReport(reportInfos);
this.importDao.ImportReportAccessory(reportAccessoryInfos);
}
