/// <summary> /// 增加 /// /// </summary> /// <param name="model">设备接口对象</param> /// <returns>返回处理结果</returns> public CommonResult <QC_DrumsFindLeakReport> AddQCDrumsFindLeakReport(QC_DrumsFindLeakReport model) { var result = new CommonResult <QC_DrumsFindLeakReport>(); try { var dbSession = new DBService <QC_DrumsFindLeakReport>().DbSession; var dbSession1 = new DBService <QC_FindLeakDrumsSetDetail>(dbSession.Context).DbSession; string strConnn = dbSession.Context.Database.Connection.ConnectionString; using (System.Transactions.TransactionScope ts = new System.Transactions.TransactionScope()) { model.FLVCode = PubRepository.GetAutomaticNumber(strConnn, "QCDF", 5, "FLVCode", "QC_DrumsFindLeakReport", model.CreateDate); var newModel = dbSession.Insert(model); //更新已检状态 var CurrQCDetail = dbSession1.GetQueryable(t => t.ArrangedVouchCode == newModel.SourceCode).FirstOrDefault(); if (CurrQCDetail != null) { CurrQCDetail.IsLeak = 1; dbSession1.Update(CurrQCDetail); } ForCfPExecuteServices.GetInstance(currUserSession.SessionId).InsertArrangedVouchLog(new ArrangedVouchLog() { ArrangedVouchCode = newModel.SourceCode, CraftsName = "检漏", OperatDesc = "检漏完成", Operator = currUserSession.UserName, OperatingTime = DateTime.Now, Frequency = newModel.Frequency }); ts.Complete(); result.Data = newModel; } } catch (Exception ex) { Utils.Logger.Error(ex.ToString()); throw ex; } return(result); }
/// <summary> /// 传入排配单,执行主表,操作日志汇总视图,保存ArrangedVouch排配单数据 /// </summary> /// <param name="model"></param> /// <returns></returns> public CommonResult <ArrangedVouch> InsterArrVouchByVw(vw_DurmsUpFeeding model) { // var result = new CommonResult<vw_DurmsUpFeeding>(); var Myresult = new CommonResult <ArrangedVouch>(); string MyArrangedVouchCode; try { var dbSession = new DBService <ArrangedVouch>().DbSession; MyArrangedVouchCode = PubRepository.GetAutomaticNumber(dbSession.Context.Database.Connection.ConnectionString, "PPDH", 5, "ArrangedVouchCode", "ArrangedVouch", DateTime.Now); Myresult.Data = dbSession.Insert(new ArrangedVouch() { ArrangedVouchCode = MyArrangedVouchCode, VouchDate = DateTime.Now, MaterialVouchCode = model.MaterialVouchCode, FormulaCode = model.FormulaCode, FormulaName = model.FormulaName, InputWeight = model.InputWeight, OutputWeight = model.OutputWeight, WeighingPounds = model.WeighingPounds, UserStatus = 1, InterruptionRemark = model.InterruptionRemark, InterruptionTime = model.InterruptionTime, Creator = model.Creator, CreateTime = DateTime.Now, ModifyPerson = model.ModifyPerson, ModifyTime = model.ModifyTime, LicenseNum = model.LicenseNum, VehicleWeight = model.VehicleWeight, WeightMan = model.WeightMan, TeachProgress = model.TeachProgress, RFIDCode = model.RFIDCode, VouchType = "DW01" //20170107新增排配类型字段 }); var dbSessionLineSet = new DBService <CraftsLineParamSet>().DbSession; var ParamdbSession = new DBService <CraftsLineParamSetDetail>(dbSessionLineSet.Context).DbSession; var resultLineSet = dbSessionLineSet.GetQueryable().OrderBy(t => t.Order).ToList(); var CraftParameList = ParamdbSession.GetQueryable().ToList(); var dbSessionCraftsProcess = new DBService <CraftsProcessExecute>().DbSession; var dbSessionCraftsProcessDetail = new DBService <CraftsProcessExecuteDetail>().DbSession; foreach (CraftsLineParamSet MyresultLine in resultLineSet) { var Craftsmodel = new CraftsProcessExecute() { ArrangedVouchCode = MyArrangedVouchCode, WorkbrachCode = model.WorkbrachCode, WorkbrachName = model.WorkbrachName, WorkshopName = MyresultLine.WorkShop, ExecuteOrder = MyresultLine.Order, CraftsCode = MyresultLine.CraftsCode, CraftsName = MyresultLine.CraftsName, PlanDuration = MyresultLine.CraftsTaskTime, ExecuteMode = MyresultLine.Treatment, }; if (Craftsmodel.ExecuteOrder == 1) { Craftsmodel.ExecuteStatus = 1; Craftsmodel.StartTime = DateTime.Now; } else if (Craftsmodel.ExecuteOrder == 2) { Craftsmodel.ExecuteStatus = 99; } else { Craftsmodel.ExecuteStatus = 0; } var ParamList = new List <CraftsProcessExecuteDetail>(); var CraftsProcessModel = dbSessionCraftsProcess.Insert(Craftsmodel); var CurrParameSetDetailList = CraftParameList.Where(t => t.ID == MyresultLine.ID && t.UserStatus == "0").ToList(); CurrParameSetDetailList.ForEach(item => { CraftsProcessExecuteDetail detail = new CraftsProcessExecuteDetail(); detail.ExecuteID = CraftsProcessModel.ExecuteID; detail.ExecuteStatus = 0; detail.Priority = item.Priority; detail.IntervalDuration = item.IntervalDuration; detail.IsValveCheck = item.IsValveCheck; detail.IsValveControl = item.IsValveControl; detail.LowerValue = item.LowerValue; detail.ParameterID = item.ParameterID; detail.StandardValue = item.StandardValue; detail.TriggerDuration = item.TriggerDuration; detail.UpperValue = item.UpperValue; ParamList.Add(detail); }); if (ParamList.Count > 0) { dbSessionCraftsProcessDetail.Insert(ParamList); } } } catch (Exception ex) { Utils.Logger.Error(ex.ToString()); throw ex; } // string CraftsArrangedVouchCode = PubRepository.GetAutomaticNumber(dbSessionCraftsProcess.Context.Database.Connection.ConnectionString, "PPDH", 5, "ArrangedVouchCode", "ArrangedVouch", DateTime.Now); return(Myresult); }
/// <summary> /// 传入排配单,执行主表,操作日志汇总视图,保存排配单数据 /// </summary> /// <param name="model"></param> /// <returns></returns> public CommonResult <ArrangedVouch> InsterArrVouchByVw(vw_DurmsUpFeeding model) { // var result = new CommonResult<vw_DurmsUpFeeding>(); var Myresult = new CommonResult <ArrangedVouch>(); string MyArrangedVouchCode; try { var dbSession = new DBService <ArrangedVouch>().DbSession; MyArrangedVouchCode = PubRepository.GetAutomaticNumber(dbSession.Context.Database.Connection.ConnectionString, "PPDH", 5, "ArrangedVouchCode", "ArrangedVouch", DateTime.Now); Myresult.Data = dbSession.Insert(new ArrangedVouch() { ArrangedVouchCode = MyArrangedVouchCode, // VouchDate = model.VouchDate, VouchDate = DateTime.Now, MaterialVouchCode = model.MaterialVouchCode, FormulaCode = model.FormulaCode, FormulaName = model.FormulaName, InputWeight = model.InputWeight, OutputWeight = model.OutputWeight, WeighingPounds = model.WeighingPounds, // UserStatus = model.UserStatus, UserStatus = 1, InterruptionRemark = model.InterruptionRemark, InterruptionTime = model.InterruptionTime, Creator = model.Creator, // CreateTime = model.CreateTime, CreateTime = DateTime.Now, ModifyPerson = model.ModifyPerson, ModifyTime = model.ModifyTime, LicenseNum = model.LicenseNum, VehicleWeight = model.VehicleWeight, WeightMan = model.WeightMan, TeachProgress = model.TeachProgress, RFIDCode = model.RFIDCode }); var dbSessionLineSet = new DBService <CraftsLineParamSet>().DbSession; var resultLineSet = dbSessionLineSet.GetQueryable().OrderBy(t => t.Order).ToList(); var dbSessionCraftsProcess = new DBService <CraftsProcessExecute>().DbSession; foreach (CraftsLineParamSet MyresultLine in resultLineSet) { var Craftsmodel = new CraftsProcessExecute() { ArrangedVouchCode = MyArrangedVouchCode, WorkbrachCode = model.WorkbrachName, WorkbrachName = model.WorkbrachName, WorkshopName = MyresultLine.WorkShop, ExecuteOrder = MyresultLine.Order, CraftsCode = MyresultLine.CraftsCode, CraftsName = MyresultLine.CraftsName, PlanDuration = MyresultLine.CraftsTaskTime, ExecuteMode = MyresultLine.Treatment, // ExecuteStatus = MyresultLine.Order == 1 ? 1 : 0 }; if (Craftsmodel.ExecuteOrder == 1) { Craftsmodel.ExecuteStatus = 1; Craftsmodel.StartTime = DateTime.Now; } else if (Craftsmodel.ExecuteOrder == 2) { Craftsmodel.ExecuteStatus = 99; } else { Craftsmodel.ExecuteStatus = 0; } dbSessionCraftsProcess.Insert(Craftsmodel); } } catch (Exception ex) { Myresult.IsSuccess = false; Myresult.Message = ex.Message; Myresult.StackTrace = ex.StackTrace; } // string CraftsArrangedVouchCode = PubRepository.GetAutomaticNumber(dbSessionCraftsProcess.Context.Database.Connection.ConnectionString, "PPDH", 5, "ArrangedVouchCode", "ArrangedVouch", DateTime.Now); return(Myresult); }
public PubFragment() { //otwaorzenie bazy danych pubService = new PubRepository(); }