/// <summary>
/// 更新ArrangedVouch排配单工艺数据，用于转鼓空鼓上料XCQ20161228
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public CommonResult <ArrangedVouch> UpdateArrangedVouchCode(vw_DurmsUpFeeding model)
{
var Myresult = new CommonResult <ArrangedVouch>();
try
{
if (Myresult.IsSuccess)
{
var dbSession = new DBService <ArrangedVouch>().DbSession;
var currModel = dbSession.GetQueryable(t => t.ArrangedVouchCode == model.ArrangedVouchCode).FirstOrDefault();
if (currModel != null)
{
currModel.MaterialVouchCode = model.MaterialVouchCode;
currModel.FormulaCode = model.FormulaCode;
currModel.FormulaName = model.FormulaName;
currModel.InputWeight = model.InputWeight;
currModel.RFIDCode = model.RFIDCode;
currModel.ProPlanNum = model.ProPlanNum;
}
Myresult.Data = dbSession.Update(currModel);
}
}
catch (Exception ex)
{
Utils.Logger.Error(ex.ToString());
throw ex;
}
return(Myresult);
}
/// <summary>
/// 更新排配单工艺数据，用于转鼓空鼓上料XCQ20161228
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public CommonResult <ArrangedVouch> UpdateArrangedVouchCode(vw_DurmsUpFeeding model)
{
var Myresult = new CommonResult <ArrangedVouch>();
try
{
if (Myresult.IsSuccess)
{
var dbSession = new DBService <ArrangedVouch>().DbSession;
var currModel = dbSession.GetQueryable(t => t.ArrangedVouchCode == model.ArrangedVouchCode).FirstOrDefault();
if (currModel != null)
{
currModel.MaterialVouchCode = model.MaterialVouchCode;
currModel.FormulaCode = model.FormulaCode;
currModel.FormulaName = model.FormulaName;
currModel.InputWeight = model.InputWeight;
currModel.RFIDCode = model.RFIDCode;
}
Myresult.Data = dbSession.Update(currModel);
}
}
catch (Exception ex)
{
Myresult.IsSuccess = false;
Myresult.Message = ex.Message;
Myresult.StackTrace = ex.StackTrace;
}
return(Myresult);
}
/// <summary>
/// 更新ArrangedVouch转鼓排配单车号信息，包括车重，毛重，皮重，等信息20170104XCQ
/// </summary>
/// <param name="model">传入vw_DurmsUpFeeding模型数据进来</param>
/// <returns></returns>
public CommonResult <ArrangedVouch> UpdateArrangedVouchWeight(vw_DurmsUpFeeding model)
{
var Myresult = new CommonResult <ArrangedVouch>();
try
{
var dbSession = new DBService <ArrangedVouch>().DbSession;
using (System.Transactions.TransactionScope ts = new System.Transactions.TransactionScope())
{
var currModel = dbSession.GetQueryable(t => t.ArrangedVouchCode == model.ArrangedVouchCode).FirstOrDefault();
if (currModel == null)
{
Myresult.IsSuccess = false;
Myresult.Message = "该设备信息已经不存在";
}
else if (currModel != null)
{
currModel.WeighingPounds = model.WeighingPounds;
currModel.InputWeight = model.InputWeight;
currModel.OutputWeight = model.OutputWeight;
currModel.LicenseNum = model.LicenseNum;
currModel.VehicleWeight = model.VehicleWeight;
currModel.WeightMan = model.WeightMan;
}
if (Myresult.IsSuccess)
{
Myresult.Data = dbSession.Update(currModel);
ts.Complete();
}
}
}
catch (Exception ex)
{
Utils.Logger.Error(ex.Message);
throw ex;
}
return(Myresult);
}
public Server.Utility.CommonResult <ArrangedVouch> UpdateArrangedVouchWeight(string sessionId, vw_DurmsUpFeeding model)
{
try
{
return(ForCfPExecute.GetInstance(sessionId).UpdateArrangedVouchWeight(model));
}
catch (Exception ex)
{
throw new FaultException <CustomFaultMessage>(new CustomFaultMessage()
{
ErrorCode = ex.HResult,
Message = ex.Message,
StackTrace = ex.StackTrace
}, ex.Message);
}
}
public CommonResult <CraftsProcessExecute> UpdateCraftsProcessData(string sessionId, string ProPlanNum, vw_DurmsUpFeeding model)
{
try
{
var result = ForCfPExecuteServices.GetInstance(sessionId).UpdateCraftsProcessData(ProPlanNum, model);
// 对接调度中心
if (result.IsSuccess)
{
DispatchCenterSerivce.DispatchArrangedCraftsProcessAsync(DisCenterHandler.Start, result.Data.ArrangedVouchCode);
}
return(result);
}
catch (Exception ex)
{
throw new FaultException <CustomFaultMessage>(new CustomFaultMessage()
{
ErrorCode = ex.HResult,
Message = ex.Message,
StackTrace = ex.StackTrace
}, ex.Message);
}
}
public CommonResult <bool> InsterCraProDataById(string sessionId, string ProPlanNum, vw_DurmsUpFeeding model)
{
try
{
return(ForCfPExecuteServices.GetInstance(sessionId).InsterCraProDataById(ProPlanNum, model));
}
catch (Exception ex)
{
throw new FaultException <CustomFaultMessage>(new CustomFaultMessage()
{
ErrorCode = ex.HResult,
Message = ex.Message,
StackTrace = ex.StackTrace
}, ex.Message);
}
}
public Server.Utility.CommonResult <ArrangedVouch> InsterArrVouchByVw(string sessionId, vw_DurmsUpFeeding model)
{
try
{
var result = ForCfPExecuteServices.GetInstance(sessionId).InsterArrVouchByVw(model);
//对接调度中心
//if (result.IsSuccess)
// DispatchCenterSerivce.DispatchArrangedCraftsProcessAsync(DisCenterHandler.Start, result.Data.ArrangedVouchCode);
return(result);
}
catch (Exception ex)
{
throw new FaultException <CustomFaultMessage>(new CustomFaultMessage()
{
ErrorCode = ex.HResult,
Message = ex.Message,
StackTrace = ex.StackTrace
}, ex.Message);
}
}
/// <summary>
/// 修改原来思路，在上料时生成三个表单，在绑卡时修正数据
/// </summary>
/// <param name="ProPlanNum"></param>
/// <param name="model"></param>
/// <returns></returns>
public CommonResult <CraftsProcessExecute> UpdateCraftsProcessData(string ProPlanNum, vw_DurmsUpFeeding model)
{
var result = new CommonResult <CraftsProcessExecute>();
try
{
var dbSession = new DBService <CraftsProcessExecute>().DbSession;
var ActProData = QZDBRepository.GetQZProPlanNumData(ProPlanNum);
var TestUpate = new QZDBRepository().UpdateRFIDStatus(model.RFIDCode); //测试修改勤哲RFID卡号
using (System.Transactions.TransactionScope ts = new System.Transactions.TransactionScope())
{
var Updatemodel = dbSession.GetQueryable(t => t.ArrangedVouchCode == model.ArrangedVouchCode && t.ExecuteOrder == 5).FirstOrDefault();
if (Updatemodel == null)
{
result.IsSuccess = false;
result.Message = "该设备信息已经不存在";
}
if (result.IsSuccess)
{
// and [属性]='主表项'
var ret = ActProData.Select(string.Format("[工艺名称]='烘料' and [项名称]='工艺总耗时'")).FirstOrDefault();
if (ret != null && ret.ItemArray.Count() > 0)
{
string Test = ret["标准值"].ToString();
Updatemodel.PlanDuration = Convert.ToInt32(Convert.ToDecimal(ret["标准值"]));
// Updatemodel.PlanDuration = (ret["标准值"] != null && ret["标准值"].ToString() != "") ? Convert.ToInt32(ret["标准值"].ToString()) : Updatemodel.PlanDuration;
}
result.Data = dbSession.Update(Updatemodel);
// ts.Complete();
}
// var ActProDataTail = QZDBRepository.GetQZProPlanNumData(ProPlanNum);
//修改执行字表
var dbSessionTail = new DBService <CraftsProcessExecuteDetail>().DbSession;
var listParam = new DBService <CraftsParameterContrast>().DbSession.GetQueryable().ToList();
var CraftsProcessData = dbSession.GetQueryable(t => t.ArrangedVouchCode == model.ArrangedVouchCode).ToList();
foreach (var item in CraftsProcessData)
{
var CraftsProcessTailData = dbSessionTail.GetQueryable(t => t.ExecuteID == item.ExecuteID).ToList();
foreach (var itemTail in CraftsProcessTailData)
{
//and [标志]={2} 暂时取消标志
//var UpdatemodelTail = dbSessionTail.GetQueryable(t => t.ExecuteID == item.ExecuteID && t.ParameterName == itemTail.ParameterName).FirstOrDefault();
var UpdatemodelTail = dbSessionTail.GetQueryable(t => t.ExecuteID == item.ExecuteID && t.ParameterID == itemTail.ParameterID).FirstOrDefault();
// and [属性]='明细项'
//var retTail = ActProData.Select(string.Format("[工艺编号]='{0}' and [项名称]='{1}'", item.CraftsCode, itemTail.ParameterName)).FirstOrDefault();
var paramName = listParam.Where(t => t.ParameterID == itemTail.ParameterID).FirstOrDefault();
var retTail = ActProData.Select(string.Format("[工艺编号]='{0}' and [项名称]='{1}'", item.CraftsCode, paramName.ParamName)).FirstOrDefault();
//if (item.CraftsName == "烘料" && (itemTail.ParameterName == "温度"))
//{
if (retTail != null && retTail.ItemArray.Count() > 0)
{
UpdatemodelTail.StandardValue = (retTail["标准值"] != null && retTail["标准值"].ToString() != "") ? retTail["标准值"].ToString() : UpdatemodelTail.StandardValue;
UpdatemodelTail.UpperValue = (retTail["上限值"] != null && retTail["上限值"].ToString() != "") ? retTail["上限值"].ToString() : UpdatemodelTail.UpperValue;
UpdatemodelTail.LowerValue = (retTail["下限值"] != null && retTail["下限值"].ToString() != "") ? retTail["下限值"].ToString() : UpdatemodelTail.LowerValue;
}
dbSessionTail.Update(UpdatemodelTail);
// }
}
}
ts.Complete();
}
}
catch (Exception ex)
{
Utils.Logger.Error(ex.Message);
throw ex;
}
return(result);
}
/// <summary>
///2017-02-23BY -XCQ 更改数据源，将原来238XCQ设计的数据源修正为即将使用的ZJY的数据源，并修正流程，原有是在上料的时候生成排配单，工艺执行主表还有工艺执行字表
/// </summary>现有需要秀正在在上料的时候生成排配单，在扫卡绑定的时候才进行生成工艺执行主表还有子表的操作，其中技术节点需要处理工艺规划编号引起的变动在生成表单的时候一并处理
/// <param name="ProPlanNum"></param>工艺规划编号
/// <returns></returns>20170226BY XCQ 停用
public CommonResult <bool> InsterCraProDataById(string ProPlanNum, vw_DurmsUpFeeding model)
{
var result = new CommonResult <bool>();
try
{
var dbSessionLineSet = new DBService <CraftsLineParamSet>().DbSession;
var ParamdbSession = new DBService <vw_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;
var ActProData = QZDBRepository.GetQZProPlanNumData(ProPlanNum);
// var DBActProData = new DBService<ActProData>().DbSession;
foreach (CraftsLineParamSet MyresultLine in resultLineSet)
{
var Craftsmodel = new CraftsProcessExecute()
{
ArrangedVouchCode = model.ArrangedVouchCode,
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.ExecuteMode == "1")
{
var ret = ActProData.Select(string.Format("[工艺编号]='{0}' and [项名称]='工艺总耗时' and [属性]='主表项' ", Craftsmodel.CraftsCode)).FirstOrDefault();
if (ret != null && ret.ItemArray.Count() > 0)
{
Craftsmodel.PlanDuration = (ret["[标准值]"] != null && ret["[标准值]"].ToString() != "") ? Convert.ToInt32(ret["[标准值]"].ToString()) : Craftsmodel.PlanDuration;
}
}
//----------------------------------------------------------------------------------------------------------------//
if (Craftsmodel.ExecuteOrder == 1)
{
Craftsmodel.ExecuteStatus = 1;
Craftsmodel.StartTime = DateTime.Now;
}
else if (Craftsmodel.ExecuteOrder == 2)
{
Craftsmodel.ExecuteStatus = 99;
}
else
{
Craftsmodel.ExecuteStatus = 0;
}
var CraftsProcessModel = dbSessionCraftsProcess.Insert(Craftsmodel);
var ParamList = new List <CraftsProcessExecuteDetail>();
//--------------------------------------分割线，上面是生成执行主表数据，下面是生成执行子表数据--------------------------------------------------------------//
var CurrParameSetDetailList = CraftParameList.Where(t => t.ID == MyresultLine.ID).OrderBy(t => t.AutoID).ToList();
foreach (var item in CurrParameSetDetailList)
{
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;
// if (true)
//{
// var ret = ActProData.Select(string.Format("[工艺编号]='{0}' and [项名称]='{1}'", Craftsmodel.CraftsCode, detail.ParameterName)).FirstOrDefault();
// if (ret != null && ret.ItemArray.Count() > 0)
// {
// }
//}
//else
//{ }
//var ret = ActProData.Select(string.Format("[工艺编号]='{0}' and [项名称]='{1}' and [标志]={2} and [属性]='明细项'", Craftsmodel.CraftsCode, detail.ParameterName, item.CraftsID)).FirstOrDefault();
var ret = ActProData.Select(string.Format("[工艺编号]='{0}' and [项名称]='{1}' and [标志]={2} and [属性]='明细项'", Craftsmodel.CraftsCode, item.ParamName, item.CraftsID)).FirstOrDefault();
if (ret != null && ret.ItemArray.Count() > 0)
{
detail.StandardValue = (ret["[标准值]"] != null && ret["[标准值]"].ToString() != "") ? ret["[标准值]"].ToString() : detail.StandardValue;
detail.UpperValue = (ret["[上限值]"] != null && ret["[上限值]"].ToString() != "") ? ret["[上限值]"].ToString() : detail.UpperValue;
detail.LowerValue = (ret["[下限值]"] != null && ret["[下限值]"].ToString() != "") ? ret["[下限值]"].ToString() : detail.LowerValue;
}
ParamList.Add(detail);
}
if (ParamList.Count > 0)
{
dbSessionCraftsProcessDetail.Insert(ParamList);
}
}
}
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);
}
