Beispiel #1
0
        public IActionResult Capacity(VCXplanning model, int panel, int panel1, string actionType)
        {
            if (panel == 0)
            {
                panel = 1;
            }
            ViewData["panel"] = panel;
            ViewData["Title"] = "MRP Data";

            DateTime?F1       = System.DateTime.Now;
            DateTime?F2       = System.DateTime.Now;
            bool     accStock = false;

            if (ModelState.IsValid)
            {
                try{
                    F1               = model.CplanDateFrom;
                    F2               = model.CplanDateTo;
                    accStock         = model.CPlancStock;
                    ViewData["F1"]   = F1;
                    ViewData["F2"]   = F2;
                    ViewData["ACSt"] = accStock;
                }
                catch {}
            }
            else
            {
                panel1 = 1;
            }                //solo valida en panel 1
            ViewData["panel1"] = panel1;
            ////var dbContext = new MyErpDBContext();
            if (actionType == "Validate")
            {
                //graba Planning data por proveedor,po, material, cantidad
                //actualiza material stock Location en transito con lo que lo
                //tendra en cuenta en el proximo calculo MRP
                ValidateReqs(F1, F2, accStock);
            }
            //if (actionType=="Refresh")
            //{
            string errors = ExecPythonScript(F1);

            if (errors != "")
            {
                ViewData["Errors"] = "Python¨:" + errors;
                //return View("~/Views/Errores/Index.cshtml");
            }
            //}
            try{
                CreateVB_LCP(F1, F2);
                CreateVB_cMRP(F1, F2, accStock);  //ListCustPlan
                return(View(model));
            }
            catch (Exception Ex) {
                string mensaje = Ex.Message;
                return(View("Error"));
            }
        }
Beispiel #2
0
        public IActionResult Capacity(int?wcent, int?material, DateTime?F1, DateTime?F2, bool accStock, int panel, int panel1, string actionType, string parqs)
        {
            //decodifica _parqs y carga todos los pares key value

            /*
             * try{
             * var _parqs = HttpUtility.ParseQueryString(parqs);
             * foreach (String s in _parqs.AllKeys)
             *  {
             *      switch(s)
             *      {
             *          case "F1":
             *              F1=Convert.ToDateTime(_parqs[s]);
             *              break;
             *          case "F2":
             *              F2=Convert.ToDateTime(_parqs[s]);
             *              break;
             *          case "wcent":
             *              wcent=Convert.ToInt32(_parqs[s]);
             *              break;
             *          case "material":
             *              material=Convert.ToInt32(_parqs[s]);
             *              break;
             *          case "accStock":
             *              accStock=Convert.ToBoolean(_parqs[s]);
             *              break;
             *          case "panel":
             *              panel=Convert.ToInt32(_parqs[s]);
             *              break;
             *          case "panel1":
             *              panel1=Convert.ToInt32(_parqs[s]);
             *              break;
             *          default:
             *              break;
             *      }
             *  }
             * }
             * catch(Exception ex){
             *  string mensaje = ex.Message;
             * }
             */
            if (wcent == null)
            {
                wcent = 0;
            }
            if (panel == 0)
            {
                panel = 1;
            }
            ViewData["panel"]  = panel;
            ViewData["panel1"] = panel1;
            if (F1 == null)
            {
                F1 = System.DateTime.Now;
            }
            if (F2 == null)
            {
                F2 = System.DateTime.Now;
            }

            //////var dbContext = new MyErpDBContext();
            ViewData["F1"]    = F1;
            ViewData["F2"]    = F2;
            ViewData["ACSt"]  = accStock;
            ViewData["WCent"] = wcent;
            ViewData["MatPO"] = material;

            /*
             * string errors =ExecPythonScript(F1);
             *  if (errors !=""){
             *      ViewData["Errors"]="Python¨:"+errors;
             *  //return View("~/Views/Errores/Index.cshtml");
             * }
             */
            try{
                CreateVB_LCP(F1, F2);
                CreateVB_cMRP(F1, F2, accStock, wcent, material);  //ListCustPlan

                //List<VCCplanning> _mode = (List<VCCplanning>)ViewBag.ListCustPlan;
                //var model = _mode[0];
                VCXplanning model = new VCXplanning {
                    CplanDateFrom = F1,
                    CplanDateTo   = F2,
                    CPlancStock   = accStock
                };
                //model.CplanDateFrom=F1;
                //model.CplanDateTo=F2;
                return(View(model));
            }
            catch (Exception Ex) {
                string mensaje = Ex.Message;
                ViewData["Error"] = mensaje;
                return(View("~/Views/Errores/Index.cshtml"));
            }
        }