/// <summary>
/// 传入对象，保存数据到CraftsProcessExecute工艺流程执行主表中XCQ20161217
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public CommonResult <CraftsProcessExecute> InsertCraftsProcessExecute(CraftsProcessExecute model)
{
var result = new CommonResult <CraftsProcessExecute>();
try
{
if (result.IsSuccess)
{
var dbSession = new DBService <CraftsProcessExecute>().DbSession;
result.Data = dbSession.Insert(model);
}
}
catch (Exception ex)
{
Utils.Logger.Error(ex.ToString());
throw ex;
}
return(result);
}
/// <summary>
/// 传入对象，保存数据到工艺流程执行主表中XCQ20161217
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public CommonResult <CraftsProcessExecute> InsertCraftsProcessExecute(CraftsProcessExecute model)
{
var result = new CommonResult <CraftsProcessExecute>();
try
{
if (result.IsSuccess)
{
var dbSession = new DBService <CraftsProcessExecute>().DbSession;
result.Data = dbSession.Insert(model);
}
}
catch (Exception ex)
{
result.IsSuccess = false;
result.Message = ex.Message;
result.StackTrace = ex.StackTrace;
}
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);
}
