Ejemplo n.º 1
0
        //
        // 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));
            }
        }
Ejemplo n.º 2
0
 //
 //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"));
 }
Ejemplo n.º 3
0
        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));
            }
        }
Ejemplo n.º 4
0
        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()));
            }
        }
Ejemplo n.º 5
0
        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);
        }
Ejemplo n.º 6
0
        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));
            }
        }
Ejemplo n.º 7
0
        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));
            }
        }
Ejemplo n.º 8
0
        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);
        }
Ejemplo n.º 9
0
        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);
        }
Ejemplo n.º 10
0
        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);
        }
Ejemplo n.º 11
0
        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);
        }
Ejemplo n.º 12
0
        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);
        }
Ejemplo n.º 13
0
 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);
 }
Ejemplo n.º 14
0
 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);
 }
Ejemplo n.º 15
0
 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);
 }
Ejemplo n.º 16
0
        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);
        }
Ejemplo n.º 17
0
 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);
 }
Ejemplo n.º 18
0
        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);
        }
Ejemplo n.º 19
0
        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);
        }
Ejemplo n.º 20
0
        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));
            }
        }
Ejemplo n.º 21
0
        /// <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);
        }
Ejemplo n.º 22
0
        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);
        }
Ejemplo n.º 23
0
        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);
        }
Ejemplo n.º 24
0
 //
 //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"));
 }
Ejemplo n.º 25
0
 //
 //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"));
 }
Ejemplo n.º 26
0
        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);
        }
Ejemplo n.º 27
0
        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));
            }
        }
Ejemplo n.º 28
0
 //
 //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"));
 }
Ejemplo n.º 29
0
        //
        //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()));
        }
Ejemplo n.º 30
0
        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"));
        }