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