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