public object UpdateRFIDStatus(string RFIDNum) { try { var result = new QZDBRepository().UpdateRFIDStatus(RFIDNum); return(result); //using (System.Transactions.TransactionScope ts = new System.Transactions.TransactionScope()) //{ // var result = new QZDBRepository().UpdateRFIDStatus(RFIDNum); // ts.Complete(); // return result; //} } catch (Exception ex) { Utils.Logger.Error(ex.Message); throw ex; } }
/// <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); }