// // GET: /RPT/WIPDisplay/Detail public ActionResult Detail(WIPDisplayDetailQueryViewModel model) { using (LotQueryServiceClient client = new LotQueryServiceClient()) { PagingConfig cfg = new PagingConfig() { OrderBy = "CreateTime DESC", Where = GetQueryCondition(model) }; MethodReturnResult <IList <Lot> > result = client.Get(ref cfg); if (result.Code == 0) { ViewBag.PagingConfig = cfg; ViewBag.List = result.Data; } } if (Request.IsAjaxRequest()) { return(PartialView("_DetailListPartial")); } else { return(View(model)); } }
// //POST: /WIP/LotQuery/GetLotPatch public async Task <ActionResult> GetLotPatch(string lotNumber) { using (LotQueryServiceClient client = new LotQueryServiceClient()) { await Task.Run(() => { PagingConfig cfg = new PagingConfig() { IsPaging = false, Where = string.Format(@" EXISTS(FROM LotTransaction as p WHERE p.Key=self.Key.TransactionKey AND p.LotNumber='{0}' AND p.UndoFlag=0 AND p.Activity='{1}')" , lotNumber , Convert.ToInt32(EnumLotActivity.Scrap)), OrderBy = "EditTime" }; MethodReturnResult <IList <LotTransactionPatch> > result = client.GetLotTransactionPatch(ref cfg); if (result.Code == 0) { ViewBag.PatchList = result.Data; } }); } return(PartialView("_PatchListPartial")); }
public ActionResult Query(LotDefectQueryViewModel model) { if (ModelState.IsValid) { using (LotQueryServiceClient client = new LotQueryServiceClient()) { PagingConfig cfg = new PagingConfig() { OrderBy = "EditTime", Where = GetQueryCondition(model) }; MethodReturnResult <IList <LotTransactionDefect> > result = client.GetLotTransactionDefect(ref cfg); if (result.Code == 0) { ViewBag.PagingConfig = cfg; ViewBag.List = result.Data; } } } if (Request.IsAjaxRequest()) { return(PartialView("_ListPartial")); } else { return(View(model)); } }
public ActionResult QueryUndo(string lotNumber) { MethodReturnResult result = GetLot(lotNumber); if (result.Code > 0) { return(Json(result)); } using (LotQueryServiceClient client = new LotQueryServiceClient()) { PagingConfig cfg = new PagingConfig() { IsPaging = false, Where = string.Format("LotNumber='{0}' AND UndoFlag=0 AND Activity>'{1}'" , lotNumber , Convert.ToInt32(EnumLotActivity.Undo)), OrderBy = "CreateTime DESC" }; MethodReturnResult <IList <LotTransaction> > rst = client.GetTransaction(ref cfg); if (rst.Code > 0) { return(Json(rst)); } ViewBag.TransactionList = rst.Data; return(PartialView("_UndoListPartial", new LotViewModel())); } }
private MethodReturnResult GetLot(string lotNumber) { //如果本次请求有成功获取到批次对象,直接返回。 if (ViewBag.Lot != null) { return(ViewBag.Lot); } MethodReturnResult result = new MethodReturnResult(); MethodReturnResult <Lot> rst = null; Lot obj = null; using (LotQueryServiceClient client = new LotQueryServiceClient()) { rst = client.Get(lotNumber); if (rst.Code <= 0 && rst.Data != null) { obj = rst.Data; ViewBag.Lot = rst; } else { result.Code = rst.Code; result.Message = rst.Message; result.Detail = rst.Detail; return(result); } } if (obj == null || obj.Status == EnumObjectStatus.Disabled) { result.Code = 2001; result.Message = string.Format(WIPResources.StringResource.LotIsNotExists, lotNumber); return(result); } else if (obj.StateFlag == EnumLotState.Finished) { result.Code = 2002; result.Message = string.Format("批次({0})已完成。", lotNumber); return(result); } else if (obj.Status == EnumObjectStatus.Disabled || obj.DeletedFlag == true) { result.Code = 2003; result.Message = string.Format("批次({0})已结束。", lotNumber); return(result); } else if (obj.HoldFlag == true) { result.Code = 2004; result.Message = string.Format("批次({0})已暂停。", lotNumber); return(result); } else if (obj.PackageFlag == true) { result.Code = 2005; result.Message = string.Format("批次({0})已包装到({1})。", lotNumber, obj.PackageNo); return(result); } return(rst); }
public async Task <ActionResult> QueryWS(LotQueryViewModel model) { if (ModelState.IsValid) { using (LotQueryServiceClient client = new LotQueryServiceClient()) { await Task.Run(() => { PagingConfig cfg = new PagingConfig() { OrderBy = "CreateTime DESC,Key Desc", Where = GetQueryCondition(model) }; MethodReturnResult <IList <Lot> > result = client.Get(ref cfg); if (result.Code == 0) { ViewBag.PagingConfig = cfg; ViewBag.List = result.Data; } }); } } if (Request.IsAjaxRequest()) { return(PartialView("_ListPartial_ws", new LotViewModel())); } else { return(View("Index_ws", model)); } }
public ActionResult QueryForColor(LotMaterialListViewModel model) { string strErrorMessage = string.Empty; MethodReturnResult <DataSet> result = new MethodReturnResult <DataSet>(); try { using (LotQueryServiceClient client = new LotQueryServiceClient()) { //RPTLotMateriallistParameter param = new RPTLotMateriallistParameter(); //param.LotNumber = model.LotNumber; string lot = model.LotNumber; MethodReturnResult <DataSet> ds = client.GetLotColor(lot); ViewBag.HistoryList = ds; } } catch (Exception ex) { result.Code = 1000; result.Message = ex.Message; result.Detail = ex.ToString(); } if (Request.IsAjaxRequest()) { return(PartialView("_ColorListPartial", model)); } else { return(View("IndexColor", model)); } }
public MethodReturnResult GetLot(string lotNumber) { MethodReturnResult result = new MethodReturnResult(); MethodReturnResult <Lot> rst = null; Lot obj = null; using (LotQueryServiceClient client = new LotQueryServiceClient()) { rst = client.Get(lotNumber); if (rst.Code <= 0 && rst.Data != null) { obj = rst.Data; } else { result.Code = rst.Code; result.Message = rst.Message; result.Detail = rst.Detail; return(result); } } if (obj == null || obj.Status == EnumObjectStatus.Disabled) { result.Code = 2001; result.Message = string.Format(WIPResources.StringResource.LotIsNotExists, lotNumber); return(result); } //判断用户生产线权限 if (!string.IsNullOrEmpty(obj.PreLineCode)) { IList <Resource> lstResource = new List <Resource>(); using (UserAuthenticateServiceClient client = new UserAuthenticateServiceClient()) { MethodReturnResult <IList <Resource> > rst1 = client.GetResourceList(User.Identity.Name, ResourceType.ProductionLine); if (rst1.Code <= 0 && rst1.Data != null) { lstResource = rst1.Data; } else { result.Code = rst1.Code; result.Message = rst1.Message; result.Detail = rst1.Detail; return(result); } } var lnq = from item in lstResource where item.Data == obj.PreLineCode select item; if (lnq.Count() == 0) { result.Code = 1; result.Message = string.Format("用户({0})权限不足,对生产线({1})的操作不能撤销。", User.Identity.Name, obj.PreLineCode); return(result); } } return(rst); }
public MethodReturnResult GetLotTransaction(string key) { MethodReturnResult result = new MethodReturnResult(); LotTransaction obj = null; using (LotQueryServiceClient client = new LotQueryServiceClient()) { MethodReturnResult <LotTransaction> rst = client.GetTransaction(key); if (rst.Code <= 0 && rst.Data != null) { obj = rst.Data; } else { result.Code = rst.Code; result.Message = rst.Message; result.Detail = rst.Detail; return(result); } } if (obj == null) { result.Code = 2001; result.Message = "被撤销操作不存在。"; return(result); } //判断用户拥有的工序权限 IList <Resource> lstResource = new List <Resource>(); using (UserAuthenticateServiceClient client = new UserAuthenticateServiceClient()) { MethodReturnResult <IList <Resource> > rst = client.GetResourceList(User.Identity.Name, ResourceType.RouteOperation); if (rst.Code <= 0 && rst.Data != null) { lstResource = rst.Data; } else { result.Code = rst.Code; result.Message = rst.Message; result.Detail = rst.Detail; return(result); } } var lnq = from item in lstResource where item.Data == obj.RouteStepName select item; if (lnq.Count() == 0) { result.Code = 1; result.Message = string.Format("用户({0})权限不足,对工序({1})的操作不能撤销。", User.Identity.Name, obj.RouteStepName); return(result); } return(result); }
public MethodReturnResult GetLot(string lotNumber) { MethodReturnResult result = new MethodReturnResult(); MethodReturnResult <Lot> rst = null; Lot obj = null; using (LotQueryServiceClient client = new LotQueryServiceClient()) { rst = client.Get(lotNumber); if (rst.Code <= 0 && rst.Data != null) { obj = rst.Data; } else { result.Code = rst.Code; result.Message = rst.Message; result.Detail = rst.Detail; return(result); } } if (obj == null || obj.Status == EnumObjectStatus.Disabled) { result.Code = 2001; result.Message = string.Format(WIPResources.StringResource.LotIsNotExists, lotNumber); return(result); } else if (obj.StateFlag == EnumLotState.Finished) { result.Code = 2002; result.Message = string.Format("批次({0})已完成。", lotNumber); return(result); } else if (obj.Status == EnumObjectStatus.Disabled || obj.DeletedFlag == true) { result.Code = 2003; result.Message = string.Format("批次({0})已结束。", lotNumber); return(result); } else if (obj.HoldFlag == true) { result.Code = 2004; result.Message = string.Format("批次({0})已暂停。", lotNumber); return(result); } //判断批次状态是否已包装 //else if (obj.PackageNo != null && obj.PackageNo != "" || obj.PackageFlag == true) else if (obj.PackageFlag == true) { result.Code = 2005; result.Message = string.Format("批次({0})已包装。", lotNumber); return(result); } return(rst); }
public MethodReturnResult GetLot(LotPrintViewModel model) { MethodReturnResult result = new MethodReturnResult(); MethodReturnResult <IList <Lot> > rst = null; IList <Lot> lst = null; using (LotQueryServiceClient client = new LotQueryServiceClient()) { PagingConfig cfg = new PagingConfig() { IsPaging = false, OrderBy = "Key" }; if (string.IsNullOrEmpty(model.LotNumber1)) { cfg.Where = string.Format("Key='{0}'", model.LotNumber); } else { cfg.Where = string.Format("Key>='{0}' AND Key<='{1}'", model.LotNumber, model.LotNumber1); } rst = client.Get(ref cfg); if (rst.Code <= 0 && rst.Data != null) { lst = rst.Data; } else { result.Code = rst.Code; result.Message = rst.Message; result.Detail = rst.Detail; return(result); } } if (lst == null || lst.Count == 0) { result.Code = 2001; string message = string.Format("{0}-{1}", model.LotNumber, model.LotNumber1); result.Message = string.Format(WIPResources.StringResource.LotIsNotExists, message); return(result); } //else if (obj.StateFlag == EnumLotState.Finished) //{ // result.Code = 2002; // result.Message = string.Format("批次({0})已完成。", lotNumber); // return result; //} //else if (obj.Status == EnumObjectStatus.Disabled || obj.DeletedFlag == true) //{ // result.Code = 2003; // result.Message = string.Format("批次({0})已结束。", lotNumber); // return result; //} return(rst); }
public bool RerurnIsExecutePowerset(string lotNumber) { IList <RouteStepAttribute> lstRouteStepAttribute = new List <RouteStepAttribute>(); //工序属性 MethodReturnResult <Lot> rst = new MethodReturnResult <Lot>(); MethodReturnResult result = new MethodReturnResult(); Lot obj = null; using (LotQueryServiceClient client = new LotQueryServiceClient()) { rst = client.Get(lotNumber); if (rst.Code == 0 && rst.Data != null) { obj = rst.Data; } else { result.Code = rst.Code; result.Message = rst.Message; result.Detail = rst.Detail; return(false); } } //获取工序控制属性列表 using (RouteStepAttributeServiceClient client = new RouteStepAttributeServiceClient()) { PagingConfig cfg = new PagingConfig() { IsPaging = false, Where = string.Format("Key.RouteName='{0}' AND Key.RouteStepName='{1}'" , obj.RouteName , obj.RouteStepName) }; MethodReturnResult <IList <RouteStepAttribute> > r = client.Get(ref cfg); if (r.Code <= 0 && r.Data != null) { lstRouteStepAttribute = r.Data; } } //是否显示电流档(利用功率分档显示电流档)yanshan.xiao bool IsExecutePowerset = false; var lnq = from item in lstRouteStepAttribute where item.Key.AttributeName == "IsExecutePowerset" select item; RouteStepAttribute rsaTmp = lnq.FirstOrDefault(); if (rsaTmp != null) { bool.TryParse(rsaTmp.Value, out IsExecutePowerset); } return(IsExecutePowerset); }
public Lot GetLot(string lotNumber) { using (LotQueryServiceClient client = new LotQueryServiceClient()) { MethodReturnResult <Lot> result = client.Get(lotNumber); if (result.Code <= 0 && result.Data != null) { return(result.Data); } } return(null); }
public string GetEfficiency(string lotNumber) { using (LotQueryServiceClient client = new LotQueryServiceClient()) { MethodReturnResult <Lot> result = client.Get(lotNumber); if (result.Code == 0) { return(result.Data.Attr1); } } return(string.Empty); }
public LotTransactionHistory GetLotTransactionHistory(string key) { using (LotQueryServiceClient client = new LotQueryServiceClient()) { MethodReturnResult <LotTransactionHistory> result = client.GetLotTransactionHistory(key); if (result.Code <= 0) { return(result.Data); } } return(null); }
private Lot GetLot(string lotNumber) { MethodReturnResult <Lot> rst = null; Lot obj = null; using (LotQueryServiceClient client = new LotQueryServiceClient()) { rst = client.Get(lotNumber); if (rst.Code <= 0 && rst.Data != null) { obj = rst.Data; } } return(obj); }
public IList <LotAttribute> GetLotAttributes(string lotNumber) { using (LotQueryServiceClient client = new LotQueryServiceClient()) { PagingConfig cfg = new PagingConfig() { IsPaging = false, Where = string.Format("Key.LotNumber='{0}'", lotNumber) }; MethodReturnResult <IList <LotAttribute> > result = client.GetAttribute(ref cfg); if (result.Code <= 0 && result.Data != null) { return(result.Data); } } return(null); }
public Lot GetLotData(string packageNumber) { using (LotQueryServiceClient client = new LotQueryServiceClient()) { PagingConfig cfg = new PagingConfig() { Where = string.Format("PackageNo='{0}'", packageNumber), IsPaging = false }; MethodReturnResult <IList <Lot> > result = client.Get(ref cfg); if (result.Code == 0 && result.Data != null && result.Data.Count > 0) { return(result.Data.FirstOrDefault()); } } return(null); }
public List <string> GetLotDefect(string lotNumber) { string where = null; List <string> XY = new List <string>(); using (LotQueryServiceClient client = new LotQueryServiceClient()) { if (!string.IsNullOrEmpty(lotNumber)) { where = string.Format(@" EXISTS( From LotTransaction as p WHERE p.Key=self.Key.TransactionKey AND p.LotNumber='{0}')" , lotNumber); } PagingConfig cfg = new PagingConfig() { OrderBy = "EditTime", Where = where }; MethodReturnResult <IList <LotTransactionDefect> > result = client.GetLotTransactionDefect(ref cfg); if (result.Code == 0) { List <LotTransactionDefect> list = result.Data.ToList <LotTransactionDefect>(); foreach (var item in list) { StringBuilder lie = new StringBuilder(); using (LotDefectServiceClient LotQueryServiceClient = new LotDefectServiceClient()) { MethodReturnResult <DataSet> rt = LotQueryServiceClient.GetXY(item.Key.TransactionKey); if (rt.Code == 0 && rt.Data.Tables[0] != null && rt.Data.Tables[0].Rows.Count > 0) { foreach (DataRow i in rt.Data.Tables[0].Rows) { lie.Append(" " + i[0].ToString() + "; "); } } XY.Add(item.Key.ReasonCodeName + " " + lie.ToString()); lie = null; } } } } return(XY); }
public async Task <ActionResult> Query(CheckDataQueryViewModel model) { if (ModelState.IsValid) { using (LotQueryServiceClient client = new LotQueryServiceClient()) { await Task.Run(() => { PagingConfig cfg = new PagingConfig() { OrderBy = "CreateTime DESC", Where = GetQueryCondition(model) }; MethodReturnResult <IList <LotTransaction> > result = client.GetTransaction(ref cfg); string where = GetQueryCountCondition(model); MethodReturnResult <DataSet> count = client.GetLotCount(where); if (count.Code == 0 && count.Data.Tables[0].Rows.Count > 0) { string qty = count.Data.Tables[0].Rows[0][0].ToString(); ViewBag.count = qty; ViewBag.stime = string.Format("{0:yyyy-MM-dd HH:mm:ss}", model.StartCheckTime); ViewBag.etime = string.Format("{0:yyyy-MM-dd HH:mm:ss}", model.EndCheckTime); } if (result.Code == 0) { ViewBag.PagingConfig = cfg; ViewBag.List = result.Data; } }); } } if (Request.IsAjaxRequest()) { return(PartialView("_ListPartial", new CheckDataViewModel())); } else { return(View("Index", model)); } }
/// <summary> 获取最新的一条加工历史数据/// </summary> /// <param name="LotNumber"></param> /// <returns></returns> public LotTransaction GetLotLastTransaction(string LotNumber) { LotTransaction obj = null; using (LotQueryServiceClient client = new LotQueryServiceClient()) { PagingConfig cfg = new PagingConfig() { IsPaging = false, Where = string.Format("LotNumber='{0}' AND UndoFlag=0 AND Activity!='{1}'" , LotNumber , Convert.ToInt32(EnumLotActivity.Undo)), OrderBy = "EditTime DESC" }; MethodReturnResult <IList <LotTransaction> > rst = client.GetTransaction(ref cfg); obj = rst.Data[0]; } return(obj); }
public LotBOM GetLotBBBom(string lotNumber) { LotBOM lotBOMBB = null; using (LotQueryServiceClient client = new LotQueryServiceClient()) { PagingConfig cfg = new PagingConfig() { PageNo = 0, PageSize = 1, Where = string.Format("Key.LotNumber='{0}' AND MaterialCode like'130308%'", lotNumber) }; MethodReturnResult <IList <LotBOM> > result = client.GetLotBOM(ref cfg); if (result.Code <= 0 && result.Data != null && result.Data.Count > 0) { lotBOMBB = result.Data[0]; } } return(lotBOMBB); }
public Lot GetLot(string lotNumber) { Lot lot = null; using (LotQueryServiceClient client = new LotQueryServiceClient()) { PagingConfig cfg = new PagingConfig() { PageNo = 0, PageSize = 1, Where = string.Format("Key='{0}'", lotNumber) }; MethodReturnResult <IList <Lot> > result = client.Get(ref cfg); if (result.Code <= 0 && result.Data != null && result.Data.Count > 0) { lot = result.Data[0]; } } return(lot); }
// //POST: /WIP/LotQuery/GetLotAttribute public async Task <ActionResult> GetLotAttributeWS(string lotNumber) { using (LotQueryServiceClient client = new LotQueryServiceClient()) { await Task.Run(() => { PagingConfig cfg = new PagingConfig() { IsPaging = false, Where = string.Format("Key.LotNumber='{0}'", lotNumber), OrderBy = "EditTime" }; MethodReturnResult <IList <LotAttribute> > result = client.GetAttribute(ref cfg); if (result.Code == 0) { ViewBag.AttributeList = result.Data; } }); } return(PartialView("_AttributeListPartial_ws")); }
// //POST: /WIP/LotQuery/GetLotEquipment public async Task <ActionResult> GetLotEquipmentWS(string lotNumber) { using (LotQueryServiceClient client = new LotQueryServiceClient()) { await Task.Run(() => { PagingConfig cfg = new PagingConfig() { IsPaging = false, Where = string.Format("LotNumber='{0}' AND State>-1", lotNumber), OrderBy = "CreateTime" }; MethodReturnResult <IList <LotTransactionEquipment> > result = client.GetLotTransactionEquipment(ref cfg); if (result.Code == 0) { ViewBag.EquipmentList = result.Data; } }); } return(PartialView("_EquipmentListPartial_ws")); }
public LotBOM GetLotCellMaterial(string lotNumber) { LotBOM lotBOMObj = null; using (LotQueryServiceClient client = new LotQueryServiceClient()) { PagingConfig cfg = new PagingConfig() { PageNo = 0, PageSize = 1, //Where = string.Format("Key.LotNumber='{0}' AND Key.ItemNo=1", lotNumber) Where = string.Format("Key.LotNumber='{0}' AND (MaterialCode Like '11%' OR MaterialCode LIKE '1803%' OR MaterialCode LIKE '2511%') ", lotNumber) }; MethodReturnResult <IList <LotBOM> > result = client.GetLotBOM(ref cfg); if (result.Code <= 0 && result.Data != null && result.Data.Count > 0) { lotBOMObj = result.Data[0]; } } return(lotBOMObj); }
public ActionResult QueryLotProcessingHistory(LotMaterialList1ViewModel model) { string strErrorMessage = string.Empty; MethodReturnResult <DataSet> result = new MethodReturnResult <DataSet>(); try { RPTLotMateriallistParameter param = GetQueryConditionP(model); using (LotQueryServiceClient client = new LotQueryServiceClient()) { //RPTLotMateriallistParameter param = new RPTLotMateriallistParameter(); //param.LotNumber = model.LotNumber; MethodReturnResult <DataSet> ds = client.GetRPTLotProcessingHistory(ref param); ViewBag.ListData = ds.Data.Tables[0]; ViewBag.PagingConfig = new PagingConfig() { PageNo = model.PageNo, PageSize = model.PageSize, Records = param.TotalRecords }; model.TotalRecords = param.TotalRecords; } } catch (Exception ex) { result.Code = 1000; result.Message = ex.Message; result.Detail = ex.ToString(); } if (Request.IsAjaxRequest()) { return(PartialView("_LotProcessingHistoryListPartial", model)); } else { return(View("IndexLotProcessingHistory", model)); } }
// //POST: /WIP/LotQuery/GetLotJob public async Task <ActionResult> GetLotJob(string lotNumber) { using (LotQueryServiceClient client = new LotQueryServiceClient()) { await Task.Run(() => { PagingConfig cfg = new PagingConfig() { IsPaging = false, Where = string.Format(@" LotNumber='{0}'" , lotNumber), OrderBy = "CreateTime" }; MethodReturnResult <IList <LotJob> > result = client.GetLotJob(ref cfg); if (result.Code == 0) { ViewBag.JobList = result.Data; } }); } return(PartialView("_JobListPartial")); }
// //POST: /WIP/LotQuery/Detail public async Task <ActionResult> DetailWS(string lotNumber) { if (ModelState.IsValid) { using (LotQueryServiceClient client = new LotQueryServiceClient()) { await Task.Run(() => { MethodReturnResult <Lot> result = client.Get(lotNumber); if (result.Code == 0) { ViewBag.Lot = result.Data; } }); } } if (ViewBag.Lot == null) { ViewBag.Lot = new Lot(); } return(View("Detail_ws", new LotViewModel())); }
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 (LotQueryServiceClient client = new LotQueryServiceClient()) { await Task.Run(() => { PagingConfig cfg = new PagingConfig() { PageNo = pageNo, PageSize = pageSize, Where = where ?? string.Empty, OrderBy = orderBy ?? string.Empty }; MethodReturnResult <IList <LotTransactionDefect> > result = client.GetLotTransactionDefect(ref cfg); if (result.Code == 0) { ViewBag.PagingConfig = cfg; ViewBag.List = result.Data; } }); } } return(PartialView("_ListPartial")); }