private IList <RouteStepParameter> GetParameterList(string routeName, string routeStepName, EnumLotState stateFlag) { if (stateFlag != EnumLotState.WaitTrackIn && stateFlag != EnumLotState.WaitTrackOut) { return(null); } using (RouteStepParameterServiceClient client = new RouteStepParameterServiceClient()) { PagingConfig cfg = new PagingConfig() { IsPaging = false, OrderBy = "ParamIndex", Where = string.Format(@"DataFrom='{0}' AND DCType='{1}' AND IsDeleted=0 AND Key.RouteName='{2}' AND Key.RouteStepName='{3}'" , Convert.ToInt32(EnumDataFrom.Manual) , stateFlag == EnumLotState.WaitTrackIn ? Convert.ToInt32(EnumDataCollectionAction.TrackIn) : Convert.ToInt32(EnumDataCollectionAction.TrackOut) , routeName , routeStepName) }; MethodReturnResult <IList <RouteStepParameter> > result = client.Get(ref cfg); if (result.Code <= 0 && result.Data != null) { return(result.Data); } } return(null); }
/// <summary> 取得工序需扣料清单 </summary> /// <param name="routeName">工艺流程</param> /// <param name="routeStepName">工序</param> /// <returns></returns> public IEnumerable <SelectListItem> GetMaterialName(string routeName, string routeStepName) { IList <RouteStepParameter> lstRouteStepParameter = new List <RouteStepParameter>(); using (RouteStepParameterServiceClient client = new RouteStepParameterServiceClient()) { PagingConfig cfg = new PagingConfig() { IsPaging = false, OrderBy = "ParamIndex", Where = string.Format(@"DataFrom='{0}' AND IsDeleted=0 AND Key.RouteName='{1}' AND Key.RouteStepName='{2}'" , Convert.ToInt32(EnumDataFrom.Manual) , routeName , routeStepName) }; MethodReturnResult <IList <RouteStepParameter> > result = client.Get(ref cfg); if (result.Code <= 0 && result.Data != null) { lstRouteStepParameter = result.Data; } } return(from item in lstRouteStepParameter select new SelectListItem() { Text = item.Key.ParameterName, //Value = item.Key.ParameterName Value = item.MaterialType }); }
public async Task <ActionResult> Query(RouteStepParameterQueryViewModel model) { if (ModelState.IsValid) { using (RouteStepParameterServiceClient client = new RouteStepParameterServiceClient()) { await Task.Run(() => { StringBuilder where = new StringBuilder(); if (model != null) { where.AppendFormat(" {0} Key.RouteName = '{1}'" , where.Length > 0 ? "AND" : string.Empty , model.RouteName); where.AppendFormat(" {0} Key.RouteStepName = '{1}'" , where.Length > 0 ? "AND" : string.Empty , model.RouteStepName); if (!string.IsNullOrEmpty(model.ParameterName)) { where.AppendFormat(" {0} Key.ParameterName LIKE '{1}%'" , where.Length > 0 ? "AND" : string.Empty , model.ParameterName); } } PagingConfig cfg = new PagingConfig() { OrderBy = "ParamIndex", Where = where.ToString() }; MethodReturnResult <IList <RouteStepParameter> > result = client.Get(ref cfg); if (result.Code == 0) { ViewBag.PagingConfig = cfg; ViewBag.List = result.Data; } }); } } return(PartialView("_ListPartial", new RouteStepParameterViewModel() { RouteName = model.RouteName, RouteStepName = model.RouteStepName })); }
// // GET: /FMM/RouteStepParameter/Modify public async Task <ActionResult> Modify(string routeName, string routeStepName, string parameterName) { RouteStepParameterViewModel viewModel = new RouteStepParameterViewModel(); using (RouteStepParameterServiceClient client = new RouteStepParameterServiceClient()) { MethodReturnResult <RouteStepParameter> result = await client.GetAsync(new RouteStepParameterKey() { RouteName = routeName, RouteStepName = routeStepName, ParameterName = parameterName }); if (result.Code == 0) { viewModel = new RouteStepParameterViewModel() { RouteName = result.Data.Key.RouteName, RouteStepName = result.Data.Key.RouteStepName, ParameterName = result.Data.Key.ParameterName, DataFrom = result.Data.DataFrom, DataType = result.Data.DataType, DCType = result.Data.DCType, IsDeleted = result.Data.IsDeleted, MaterialType = result.Data.MaterialType, IsMustInput = result.Data.IsMustInput, IsReadOnly = result.Data.IsReadOnly, IsUsePreValue = result.Data.IsUsePreValue, ParamIndex = result.Data.ParamIndex, ValidateFailedMessage = result.Data.ValidateFailedMessage, ValidateFailedRule = result.Data.ValidateFailedRule, ValidateRule = result.Data.ValidateRule, Editor = result.Data.Editor, EditTime = result.Data.EditTime }; return(PartialView("_ModifyPartial", viewModel)); } else { ModelState.AddModelError("", result.Message); } } return(PartialView("_ModifyPartial")); }
// // GET: /FMM/RouteStepParameter/ public async Task <ActionResult> Index(string routeName, string routeStepName) { using (RouteStepServiceClient client = new RouteStepServiceClient()) { MethodReturnResult <RouteStep> result = await client.GetAsync(new RouteStepKey() { RouteName = routeName, RouteStepName = routeStepName }); if (result.Code > 0 || result.Data == null) { return(RedirectToAction("Index", "RouteStep", new { @RouteName = routeName })); } ViewBag.RouteStep = result.Data; } using (RouteStepParameterServiceClient client = new RouteStepParameterServiceClient()) { await Task.Run(() => { PagingConfig cfg = new PagingConfig() { Where = string.Format(" Key.RouteName='{0}' AND Key.RouteStepName = '{1}'" , routeName , routeStepName), OrderBy = "ParamIndex" }; MethodReturnResult <IList <RouteStepParameter> > result = client.Get(ref cfg); if (result.Code == 0) { ViewBag.PagingConfig = cfg; ViewBag.List = result.Data; } }); } return(View(new RouteStepParameterQueryViewModel() { RouteName = routeName, RouteStepName = routeStepName })); }
public ActionResult GetMaxParamterIndex(string routeName, string routeStepName) { using (RouteStepParameterServiceClient client = new RouteStepParameterServiceClient()) { PagingConfig cfg = new PagingConfig() { PageNo = 0, PageSize = 1, OrderBy = "ParamIndex Desc", Where = string.Format("Key.RouteName='{0}' AND Key.RouteStepName='{1}'" , routeName , routeStepName) }; MethodReturnResult <IList <RouteStepParameter> > result = client.Get(ref cfg); if (result.Code <= 0 && result.Data != null && result.Data.Count > 0) { return(Json(result.Data[0].ParamIndex + 1, JsonRequestBehavior.AllowGet)); } } return(Json(1, JsonRequestBehavior.AllowGet)); }
public async Task <ActionResult> Delete(string routeName, string routeStepName, string parameterName) { MethodReturnResult result = new MethodReturnResult(); using (RouteStepParameterServiceClient client = new RouteStepParameterServiceClient()) { result = await client.DeleteAsync(new RouteStepParameterKey() { RouteName = routeName, RouteStepName = routeStepName, ParameterName = parameterName }); if (result.Code == 0) { result.Message = string.Format(FMMResources.StringResource.RouteStepParameter_Delete_Success , parameterName); } return(Json(result)); } }
public async Task <ActionResult> SaveModify(RouteStepParameterViewModel model) { using (RouteStepParameterServiceClient client = new RouteStepParameterServiceClient()) { MethodReturnResult <RouteStepParameter> result = await client.GetAsync(new RouteStepParameterKey() { RouteName = model.RouteName, RouteStepName = model.RouteStepName, ParameterName = model.ParameterName }); if (result.Code == 0) { result.Data.DataFrom = model.DataFrom; result.Data.DataType = model.DataType; result.Data.DCType = model.DCType; result.Data.IsDeleted = model.IsDeleted; result.Data.IsMustInput = model.IsMustInput; result.Data.IsReadOnly = model.IsReadOnly; result.Data.MaterialType = model.MaterialType; result.Data.IsUsePreValue = model.IsUsePreValue; result.Data.ParamIndex = model.ParamIndex; result.Data.ValidateFailedMessage = model.ValidateFailedMessage; result.Data.ValidateFailedRule = model.ValidateFailedRule; result.Data.ValidateRule = model.ValidateRule; result.Data.Editor = User.Identity.Name; result.Data.EditTime = DateTime.Now; MethodReturnResult rst = await client.ModifyAsync(result.Data); if (rst.Code == 0) { rst.Message = string.Format(FMMResources.StringResource.RouteStepParameter_SaveModify_Success , result.Data.Key); } return(Json(rst)); } return(Json(result)); } }
public async Task <ActionResult> PagingQuery(string where, string orderBy, int?currentPageNo, int?currentPageSize) { if (ModelState.IsValid) { int pageNo = currentPageNo ?? 0; int pageSize = currentPageSize ?? 20; if (Request["PageNo"] != null) { pageNo = Convert.ToInt32(Request["PageNo"]); } if (Request["PageSize"] != null) { pageSize = Convert.ToInt32(Request["PageSize"]); } using (RouteStepParameterServiceClient client = new RouteStepParameterServiceClient()) { await Task.Run(() => { PagingConfig cfg = new PagingConfig() { PageNo = pageNo, PageSize = pageSize, Where = where ?? string.Empty, OrderBy = orderBy ?? string.Empty }; MethodReturnResult <IList <RouteStepParameter> > result = client.Get(ref cfg); if (result.Code == 0) { ViewBag.PagingConfig = cfg; ViewBag.List = result.Data; } }); } } return(PartialView("_ListPartial", new RouteStepParameterViewModel() { })); }
public async Task <ActionResult> Save(RouteStepParameterViewModel model) { using (RouteStepParameterServiceClient client = new RouteStepParameterServiceClient()) { RouteStepParameter obj = new RouteStepParameter() { Key = new RouteStepParameterKey() { RouteName = model.RouteName, RouteStepName = model.RouteStepName, ParameterName = model.ParameterName }, MaterialType = model.MaterialType, DataFrom = model.DataFrom, DataType = model.DataType, DCType = model.DCType, IsDeleted = model.IsDeleted, IsMustInput = model.IsMustInput, IsReadOnly = model.IsReadOnly, IsUsePreValue = model.IsUsePreValue, ParamIndex = model.ParamIndex, ValidateFailedMessage = model.ValidateFailedMessage, ValidateFailedRule = model.ValidateFailedRule, ValidateRule = model.ValidateRule, Editor = User.Identity.Name, EditTime = DateTime.Now, }; MethodReturnResult rst = await client.AddAsync(obj); if (rst.Code == 0) { rst.Message = string.Format(FMMResources.StringResource.RouteStepParameter_Save_Success , obj.Key); } return(Json(rst)); } }
public async Task <ActionResult> SaveCopy(RouteViewModel model) { Route obj = new Route() { Key = model.Name, RouteType = model.RouteType, Status = model.Status, Description = model.Description, Creator = User.Identity.Name, CreateTime = DateTime.Now, Editor = User.Identity.Name, EditTime = DateTime.Now }; MethodReturnResult result = new MethodReturnResult(); using (RouteServiceClient client = new RouteServiceClient()) { result = await client.AddAsync(obj); if (result.Code == 0) { result.Message = "复制工艺流程主体成功"; StringBuilder where = new StringBuilder(); using (RouteStepServiceClient routeStepServiceClient = new RouteStepServiceClient()) { where.AppendFormat(" Key.RouteName ='{0}'", model.ParentName); PagingConfig cfg = new PagingConfig() { IsPaging = false, OrderBy = "SortSeq", Where = where.ToString() }; MethodReturnResult <IList <RouteStep> > routeStep = routeStepServiceClient.Get(ref cfg); if (routeStep.Code == 0) { List <RouteStep> listOfRouteStep = routeStep.Data.ToList <RouteStep>(); foreach (RouteStep itemOfRouteStep in listOfRouteStep) { #region 制工步信息 RouteStep objRouteStep = new RouteStep() { Key = new RouteStepKey() { RouteName = model.Name, RouteStepName = itemOfRouteStep.Key.RouteStepName }, DefectReasonCodeCategoryName = itemOfRouteStep.DefectReasonCodeCategoryName, Duration = itemOfRouteStep.Duration, ScrapReasonCodeCategoryName = itemOfRouteStep.ScrapReasonCodeCategoryName, SortSeq = itemOfRouteStep.SortSeq, RouteOperationName = itemOfRouteStep.RouteOperationName, Description = itemOfRouteStep.Description, Editor = User.Identity.Name, EditTime = DateTime.Now, CreateTime = DateTime.Now, Creator = User.Identity.Name }; MethodReturnResult rstOfRouteStep = await routeStepServiceClient.AddAsync(objRouteStep); if (rstOfRouteStep.Code != 0) { result.Code = 1001; result.Message = "复制工步信息失败" + rstOfRouteStep.Message; return(Json(result)); } #endregion #region 制工步参数 using (RouteStepParameterServiceClient routeStepParameterServiceClient = new RouteStepParameterServiceClient()) { #region 除新增工艺流程工步带过来的工步参数 cfg = new PagingConfig() { Where = string.Format(" Key.RouteName='{0}' AND Key.RouteStepName = '{1}'" , model.Name , itemOfRouteStep.Key.RouteStepName), OrderBy = "ParamIndex" }; MethodReturnResult <IList <RouteStepParameter> > routeStepParameterNewAdd = routeStepParameterServiceClient.Get(ref cfg); if (routeStepParameterNewAdd.Code == 0) { List <RouteStepParameter> listOfRouteStepParameterNewAdd = routeStepParameterNewAdd.Data.ToList <RouteStepParameter>(); foreach (RouteStepParameter itemOfRouteStepParameterNewAdd in listOfRouteStepParameterNewAdd) { MethodReturnResult rstOfRouteStepParameterNewAdd = routeStepParameterServiceClient.Delete(itemOfRouteStepParameterNewAdd.Key); if (rstOfRouteStepParameterNewAdd.Code != 0) { result.Code = 1001; result.Message = "删除初始工步参数信息失败" + rstOfRouteStepParameterNewAdd.Message; return(Json(result)); } } } #endregion #region 制工步参数 cfg = new PagingConfig() { Where = string.Format(" Key.RouteName='{0}' AND Key.RouteStepName = '{1}'" , model.ParentName , itemOfRouteStep.Key.RouteStepName), OrderBy = "ParamIndex" }; MethodReturnResult <IList <RouteStepParameter> > routeStepParameter = routeStepParameterServiceClient.Get(ref cfg); if (routeStepParameter.Code == 0) { List <RouteStepParameter> listOfRouteStepParameter = routeStepParameter.Data.ToList <RouteStepParameter>(); foreach (RouteStepParameter itemOfRouteStepParameter in listOfRouteStepParameter) { RouteStepParameter objRouteStepParameter = new RouteStepParameter() { Key = new RouteStepParameterKey() { RouteName = model.Name, RouteStepName = itemOfRouteStepParameter.Key.RouteStepName, ParameterName = itemOfRouteStepParameter.Key.ParameterName }, MaterialType = itemOfRouteStepParameter.MaterialType, DataFrom = itemOfRouteStepParameter.DataFrom, DataType = itemOfRouteStepParameter.DataType, DCType = itemOfRouteStepParameter.DCType, IsDeleted = itemOfRouteStepParameter.IsDeleted, IsMustInput = itemOfRouteStepParameter.IsMustInput, IsReadOnly = itemOfRouteStepParameter.IsReadOnly, IsUsePreValue = itemOfRouteStepParameter.IsUsePreValue, ParamIndex = itemOfRouteStepParameter.ParamIndex, ValidateFailedMessage = itemOfRouteStepParameter.ValidateFailedMessage, ValidateFailedRule = itemOfRouteStepParameter.ValidateFailedRule, ValidateRule = itemOfRouteStepParameter.ValidateRule, Editor = User.Identity.Name, EditTime = DateTime.Now, }; MethodReturnResult rstOfRouteStepParameter = await routeStepParameterServiceClient.AddAsync(objRouteStepParameter); if (rstOfRouteStepParameter.Code != 0) { result.Code = 1001; result.Message = "复制工步参数信息失败" + rstOfRouteStepParameter.Message; return(Json(result)); } } } #endregion } #endregion #region 制工步属性 using (RouteStepAttributeServiceClient routeStepAttributeServiceClient = new RouteStepAttributeServiceClient()) { #region 除新增工艺流程工步带过来的工步属性 cfg = new PagingConfig() { Where = string.Format(" Key.RouteName='{0}' AND Key.RouteStepName = '{1}'" , model.Name , itemOfRouteStep.Key.RouteStepName), OrderBy = "Key.AttributeName" }; MethodReturnResult <IList <RouteStepAttribute> > routeStepAttributeNewAdd = routeStepAttributeServiceClient.Get(ref cfg); if (routeStepAttributeNewAdd.Code == 0) { List <RouteStepAttribute> listOfRouteStepAttributeNewAdd = routeStepAttributeNewAdd.Data.ToList <RouteStepAttribute>(); foreach (RouteStepAttribute itemOfRouteStepAttributeNewAdd in listOfRouteStepAttributeNewAdd) { MethodReturnResult rstOfRouteStepAttributeNewAdd = routeStepAttributeServiceClient.Delete(itemOfRouteStepAttributeNewAdd.Key); if (rstOfRouteStepAttributeNewAdd.Code != 0) { result.Code = 1001; result.Message = "删除初始工步属性信息失败" + rstOfRouteStepAttributeNewAdd.Message; return(Json(result)); } } } #endregion #region 制工步属性 cfg = new PagingConfig() { Where = string.Format(" Key.RouteName='{0}' AND Key.RouteStepName = '{1}'" , model.ParentName , itemOfRouteStep.Key.RouteStepName), OrderBy = "Key.AttributeName" }; MethodReturnResult <IList <RouteStepAttribute> > routeStepAttribute = routeStepAttributeServiceClient.Get(ref cfg); if (routeStepAttribute.Code == 0) { List <RouteStepAttribute> listOfRouteStepAttribute = routeStepAttribute.Data.ToList <RouteStepAttribute>(); foreach (RouteStepAttribute itemOfRouteStepAttribute in listOfRouteStepAttribute) { RouteStepAttribute objRouteStepAttribute = new RouteStepAttribute() { Key = new RouteStepAttributeKey() { RouteName = model.Name, RouteStepName = itemOfRouteStepAttribute.Key.RouteStepName, AttributeName = itemOfRouteStepAttribute.Key.AttributeName }, Value = itemOfRouteStepAttribute.Value, Editor = User.Identity.Name, EditTime = DateTime.Now, }; MethodReturnResult rstOfRouteStepAttribute = await routeStepAttributeServiceClient.AddAsync(objRouteStepAttribute); if (rstOfRouteStepAttribute.Code != 0) { result.Code = 1001; result.Message = "复制工步属性信息失败" + rstOfRouteStepAttribute.Message; return(Json(result)); } } } #endregion } #endregion } result.Message += " \r\n 复制工艺流程工步参数及工步属性成功"; } } } } return(Json(result)); }