Exemple #1
0
        public ActionResult Check()
        {
            List <ListItemExtension> lieList     = new List <ListItemExtension>();
            List <string>            deportments = new List <string>()
            {
                "精工工厂", "加工工厂", "模具工厂", "智能设备工厂", "智能机器"
            };

            foreach (var fanName in deportments)
            {
                ListItem item = new ListItem();
                item.Text  = fanName;
                item.Value = fanName;
                ListItemExtension lie = new ListItemExtension(item);
                lieList.Add(lie);
            }

            ViewBag.Deportment = lieList.ToArray();

            int year  = DateTime.Now.Year;
            int month = DateTime.Now.Month;

            ViewBag.RecordCount = db.CapCompleteRate.Where(p => p.PlanDate.Value.Year == year && p.PlanDate.Value.Month == month).Count();
            return(View(PagingHelper <CapCompleteRate> .GetPagedDataTable(0, 20, ViewBag.RecordCount, db.CapCompleteRate.Where(p => p.PlanDate.Value.Year == year && p.PlanDate.Value.Month == month).ToList())));
        }
Exemple #2
0
        public ActionResult Grid1_PageIndexChanged(string[] Grid1_fields, int Grid1_pageIndex, DateTime?yearMonth, string deportment)
        {
            List <ProductQua> pmList;

            int year  = DateTime.Now.Year;
            int month = DateTime.Now.Month;

            if (yearMonth != null)
            {
                pmList = db.ProductQua.Where(p => p.DATE.Value.Year == yearMonth.Value.Year && p.DATE.Value.Month == yearMonth.Value.Month).ToList();
            }
            else
            {
                pmList = db.ProductQua.Where(p => p.DATE.Value.Year == year && p.DATE.Value.Month == month).ToList();
            }

            if (!string.IsNullOrEmpty(deportment))
            {
                pmList = pmList.Where(p => p.FAB_NAME == deportment).ToList();
            }

            var grid1 = UIHelper.Grid("Grid1");

            var recordCount = pmList.Count();

            grid1.RecordCount(recordCount);

            var dataSource = PagingHelper <ProductQua> .GetPagedDataTable(Grid1_pageIndex, 20, recordCount, pmList);

            grid1.DataSource(dataSource, Grid1_fields);

            return(UIHelper.Result());
        }
Exemple #3
0
        public ActionResult Index(string[] Grid1_fields, DateTime?yearMonth, string deportment)
        {
            List <CapCompleteRate> pmList;

            int year  = DateTime.Now.Year;
            int month = DateTime.Now.Month;

            if (yearMonth != null)
            {
                pmList = db.CapCompleteRate.Where(p => p.PlanDate.Value.Year == yearMonth.Value.Year && p.PlanDate.Value.Month == yearMonth.Value.Month).ToList();
            }
            else
            {
                pmList = db.CapCompleteRate.Where(p => p.PlanDate.Value.Year == year && p.PlanDate.Value.Month == month).ToList();
            }

            if (!string.IsNullOrEmpty(deportment))
            {
                pmList = pmList.Where(p => p.FAB_NAME == deportment).ToList();
            }

            var grid1 = UIHelper.Grid("Grid1");

            var recordCount = pmList.Count();

            grid1.RecordCount(recordCount);

            var dataSource = PagingHelper <CapCompleteRate> .GetPagedDataTable(0, 20, recordCount, pmList);

            grid1.DataSource(dataSource, Grid1_fields);

            return(UIHelper.Result());
        }
Exemple #4
0
        public ActionResult Index(string[] Grid1_fields, DateTime?yearMonth)
        {
            List <SaleManage> smList;

            if (yearMonth != null)
            {
                smList = db.SaleManage.Where(p => p.PLAN_DATE.Year == yearMonth.Value.Year && p.PLAN_DATE.Month == yearMonth.Value.Month).ToList();
            }
            else
            {
                smList = db.SaleManage.ToList();
            }

            var grid1 = UIHelper.Grid("Grid1");

            var recordCount = smList.Count();

            grid1.RecordCount(recordCount);

            var dataSource = PagingHelper <SaleManage> .GetPagedDataTable(0, 20, recordCount, smList);

            grid1.DataSource(dataSource, Grid1_fields);

            return(UIHelper.Result());
        }
Exemple #5
0
        public ActionResult Grid1_YearPlan_PageIndexChanged(string[] Grid1_fields, int Grid1_pageIndex)
        {
            List <YearPlan> ypList;

            ypList = db.YearPlan.ToList();

            var grid1 = UIHelper.Grid("Grid1");

            var recordCount = ypList.Count();

            grid1.RecordCount(recordCount);

            var dataSource = PagingHelper <YearPlan> .GetPagedDataTable(Grid1_pageIndex, 20, recordCount, ypList);

            grid1.DataSource(dataSource, Grid1_fields);

            return(UIHelper.Result());
        }
        public ActionResult Index()
        {
            List <ListItemExtension> lieList     = new List <ListItemExtension>();
            List <string>            deportments = new List <string>()
            {
                "精工工厂", "加工工厂", "模具工厂", "智能设备工厂", "智能机器"
            };

            foreach (var fanName in deportments)
            {
                ListItem item = new ListItem();
                item.Text  = fanName;
                item.Value = fanName;
                ListItemExtension lie = new ListItemExtension(item);
                lieList.Add(lie);
            }

            ViewBag.Deportment = lieList.ToArray();

            ViewBag.RecordCount = db.VentureCapa.Count();
            return(View(PagingHelper <VentureCapa> .GetPagedDataTable(0, 20, ViewBag.RecordCount, db.VentureCapa.ToList())));
        }
        public ActionResult Index(string[] Grid1_fields, string deportment)
        {
            List <VentureCapa> pmList;

            pmList = db.VentureCapa.ToList();

            if (!string.IsNullOrEmpty(deportment))
            {
                pmList = pmList.Where(p => p.FAB_NAME == deportment).ToList();
            }

            var grid1 = UIHelper.Grid("Grid1");

            var recordCount = pmList.Count();

            grid1.RecordCount(recordCount);

            var dataSource = PagingHelper <VentureCapa> .GetPagedDataTable(0, 20, recordCount, pmList);

            grid1.DataSource(dataSource, Grid1_fields);

            return(UIHelper.Result());
        }
Exemple #8
0
        public ActionResult Compute(string[] Grid1_fields, DateTime?yearMonth)
        {
            List <SaleManage>    smList;
            List <ProductManage> pmList;

            if (yearMonth != null)
            {
                smList = db.SaleManage.Where(p => p.PLAN_DATE.Year == yearMonth.Value.Year && p.PLAN_DATE.Month == yearMonth.Value.Month).ToList();
                pmList = db.ProductManage.Where(p => p.PLAN_DATE.Value.Year == yearMonth.Value.Year && p.PLAN_DATE.Value.Month == yearMonth.Value.Month).ToList();

                foreach (var sm in smList)
                {
                    sm.SALE_PLAN   = pmList.Where(p => p.FAB_NAME == sm.RSPO_DEPT).Sum(p => p.OUTPUT_VALUE);
                    sm.SALE_FINISH = Convert.ToDouble(sapreader.GetProductWeightCount(GetFactoryCode(sm.RSPO_DEPT), DateTime.Now).ToString("0.00"));
                }

                db.SaveChanges();
            }
            else
            {
                smList = db.SaleManage.ToList();
            }


            var grid1 = UIHelper.Grid("Grid1");

            var recordCount = smList.Count();

            grid1.RecordCount(recordCount);

            var dataSource = PagingHelper <SaleManage> .GetPagedDataTable(0, 20, recordCount, smList);

            grid1.DataSource(dataSource, Grid1_fields);

            return(UIHelper.Result());
        }
Exemple #9
0
        public ActionResult btnSubmit_Click(string[] Grid1_fields, JArray Grid1_modifiedData, int pageIndex, DateTime?yearMonth)
        {
            foreach (JObject mergedRow in Grid1_modifiedData)
            {
                string  status   = mergedRow.Value <string>("status");
                int     rowIndex = mergedRow.Value <int>("index");
                JObject values   = mergedRow.Value <JObject>("values");

                if (status == "modified")
                {
                    int id = mergedRow.Value <int>("id");

                    CapCompleteRate pm = db.CapCompleteRate.Where(p => p.ID == id).FirstOrDefault();

                    string   FAB_NAME       = values.Value <string>("FAB_NAME");
                    string   Venture        = values.Value <string>("Venture");
                    string   Operation      = values.Value <string>("Operation");
                    double?  CompleteRate   = values.Value <double?>("CompleteRate");
                    double?  PromptnessRate = values.Value <double?>("PromptnessRate");
                    double?  PassRate       = values.Value <double?>("PassRate");
                    DateTime?PlanDate       = values.Value <DateTime?>("PlanDate");

                    if (FAB_NAME != null)
                    {
                        pm.FAB_NAME = FAB_NAME;
                    }
                    if (Venture != null)
                    {
                        pm.Venture = Venture;
                    }
                    if (Operation != null)
                    {
                        pm.Operation = Operation;
                    }
                    if (CompleteRate != null)
                    {
                        pm.CompleteRate = CompleteRate;
                    }
                    if (PromptnessRate != null)
                    {
                        pm.PromptnessRate = PromptnessRate;
                    }
                    if (PassRate != null)
                    {
                        pm.PassRate = PassRate;
                    }
                    if (PlanDate != null)
                    {
                        pm.PlanDate = PlanDate;
                    }

                    db.SaveChanges();
                }
                else if (status == "newadded")
                {
                    CapCompleteRate pm = new CapCompleteRate();

                    string FAB_NAME       = values.Value <string>("FAB_NAME");
                    string Venture        = values.Value <string>("Venture");
                    string Operation      = values.Value <string>("Operation");
                    double?CompleteRate   = values.Value <double?>("CompleteRate");
                    double?PromptnessRate = values.Value <double?>("PromptnessRate");
                    double?PassRate       = values.Value <double?>("PassRate");
                    string PlanDate       = values.Value <string>("PlanDate");


                    if (FAB_NAME != null)
                    {
                        pm.FAB_NAME = FAB_NAME;
                    }
                    if (Venture != null)
                    {
                        pm.Venture = Venture;
                    }
                    if (Operation != null)
                    {
                        pm.Operation = Operation;
                    }
                    if (CompleteRate != null)
                    {
                        pm.CompleteRate = CompleteRate;
                    }
                    if (PromptnessRate != null)
                    {
                        pm.PromptnessRate = PromptnessRate;
                    }
                    if (PassRate != null)
                    {
                        pm.PassRate = PassRate;
                    }
                    if (!string.IsNullOrEmpty(PlanDate))
                    {
                        pm.PlanDate = Convert.ToDateTime(PlanDate);
                    }

                    db.CapCompleteRate.Add(pm);
                    db.SaveChanges();
                }
                else if (status == "deleted")
                {
                    int id = mergedRow.Value <int>("id");

                    CapCompleteRate pm = db.CapCompleteRate.Where(p => p.ID == id).FirstOrDefault();

                    db.CapCompleteRate.Remove(pm);

                    db.SaveChanges();
                }
            }

            List <CapCompleteRate> pmList;

            int year  = DateTime.Now.Year;
            int month = DateTime.Now.Month;

            if (yearMonth != null)
            {
                pmList = db.CapCompleteRate.Where(p => p.PlanDate.Value.Year == yearMonth.Value.Year && p.PlanDate.Value.Month == yearMonth.Value.Month).ToList();
            }
            else
            {
                pmList = db.CapCompleteRate.Where(p => p.PlanDate.Value.Year == year && p.PlanDate.Value.Month == month).ToList();
            }

            var dataSource = PagingHelper <CapCompleteRate> .GetPagedDataTable(pageIndex, 20, pmList.Count(), pmList);

            UIHelper.Grid("Grid1").DataSource(dataSource, Grid1_fields);
            Alert.Show("操作成功!");

            return(UIHelper.Result());
        }
Exemple #10
0
        public ActionResult btnSubmit_Click(string[] Grid1_fields, JArray Grid1_modifiedData, int pageIndex, DateTime?yearMonth)
        {
            foreach (JObject mergedRow in Grid1_modifiedData)
            {
                string  status   = mergedRow.Value <string>("status");
                int     rowIndex = mergedRow.Value <int>("index");
                JObject values   = mergedRow.Value <JObject>("values");

                if (status == "modified")
                {
                    int id = mergedRow.Value <int>("id");

                    ProductQua pm = db.ProductQua.Where(p => p.ID == id).FirstOrDefault();

                    string   FAB_NAME       = values.Value <string>("FAB_NAME");
                    string   VENTURENAME    = values.Value <string>("VENTURENAME");
                    string   OPERATION_NAME = values.Value <string>("OPERATION_NAME");
                    int?     TOTALQTY       = values.Value <int?>("TOTALQTY");
                    int?     QUAQTY         = values.Value <int?>("QUAQTY");
                    DateTime?DATE           = values.Value <DateTime?>("DATE");
                    double?  RATE           = values.Value <double?>("RATE");

                    if (FAB_NAME != null)
                    {
                        pm.FAB_NAME = FAB_NAME;
                    }
                    if (VENTURENAME != null)
                    {
                        pm.VENTURENAME = VENTURENAME;
                    }
                    if (OPERATION_NAME != null)
                    {
                        pm.OPERATION_NAME = OPERATION_NAME;
                    }
                    if (TOTALQTY != null)
                    {
                        pm.TOTALQTY = TOTALQTY;
                    }
                    if (QUAQTY != null)
                    {
                        pm.QUAQTY = QUAQTY;
                    }
                    if (DATE != null)
                    {
                        pm.DATE = DATE;
                    }
                    if (RATE != null)
                    {
                        pm.RATE = RATE;
                    }

                    db.SaveChanges();
                }
                else if (status == "newadded")
                {
                    ProductQua pm = new ProductQua();

                    string FAB_NAME       = values.Value <string>("FAB_NAME");
                    string VENTURENAME    = values.Value <string>("VENTURENAME");
                    string OPERATION_NAME = values.Value <string>("OPERATION_NAME");
                    int?   TOTALQTY       = values.Value <int?>("TOTALQTY");
                    int?   QUAQTY         = values.Value <int?>("QUAQTY");
                    string DATE           = values.Value <string>("DATE");
                    double?RATE           = values.Value <double?>("RATE");


                    if (FAB_NAME != null)
                    {
                        pm.FAB_NAME = FAB_NAME;
                    }
                    if (VENTURENAME != null)
                    {
                        pm.VENTURENAME = VENTURENAME;
                    }
                    if (OPERATION_NAME != null)
                    {
                        pm.OPERATION_NAME = OPERATION_NAME;
                    }
                    if (TOTALQTY != null)
                    {
                        pm.TOTALQTY = TOTALQTY;
                    }
                    if (QUAQTY != null)
                    {
                        pm.QUAQTY = QUAQTY;
                    }
                    if (RATE != null)
                    {
                        pm.RATE = RATE;
                    }
                    if (!string.IsNullOrEmpty(DATE))
                    {
                        pm.DATE = Convert.ToDateTime(DATE);
                    }

                    db.ProductQua.Add(pm);
                    db.SaveChanges();
                }
                else if (status == "deleted")
                {
                    int id = mergedRow.Value <int>("id");

                    ProductQua pm = db.ProductQua.Where(p => p.ID == id).FirstOrDefault();

                    db.ProductQua.Remove(pm);

                    db.SaveChanges();
                }
            }

            List <ProductQua> pmList;

            int year  = DateTime.Now.Year;
            int month = DateTime.Now.Month;

            if (yearMonth != null)
            {
                pmList = db.ProductQua.Where(p => p.DATE.Value.Year == yearMonth.Value.Year && p.DATE.Value.Month == yearMonth.Value.Month).ToList();
            }
            else
            {
                pmList = db.ProductQua.Where(p => p.DATE.Value.Year == year && p.DATE.Value.Month == month).ToList();
            }

            var dataSource = PagingHelper <ProductQua> .GetPagedDataTable(pageIndex, 20, pmList.Count(), pmList);

            UIHelper.Grid("Grid1").DataSource(dataSource, Grid1_fields);
            Alert.Show("操作成功!");

            return(UIHelper.Result());
        }
Exemple #11
0
        public ActionResult btnSubmit_Click(string[] Grid1_fields, JArray Grid1_modifiedData, int pageIndex, DateTime?yearMonth)
        {
            foreach (JObject mergedRow in Grid1_modifiedData)
            {
                string  status   = mergedRow.Value <string>("status");
                int     rowIndex = mergedRow.Value <int>("index");
                JObject values   = mergedRow.Value <JObject>("values");

                if (status == "modified")
                {
                    int id = mergedRow.Value <int>("id");

                    OtdDpmo pm = db.OtdDpmo.Where(p => p.ID == id).FirstOrDefault();

                    string   FAB_NAME          = values.Value <string>("FAB_NAME");
                    double?  OTD               = values.Value <double?>("OTD");
                    double?  OTDComplete       = values.Value <double?>("OTDComplete");
                    double?  DPMO              = values.Value <double?>("DPMO");
                    double?  DPMOCompletefloat = values.Value <double?>("DPMOCompletefloat");
                    double?  Ncr               = values.Value <double?>("Ncr");
                    double?  HourYearComplete  = values.Value <double?>("HourYearComplete");
                    double?  HourMonthPlan     = values.Value <double?>("HourMonthPlan");
                    double?  HourMonthComplete = values.Value <double?>("HourMonthComplete");
                    double?  JGGSPlan          = values.Value <double?>("JGGSPlan");
                    double?  JGGSComplete      = values.Value <double?>("JGGSComplete");
                    double?  CJGDWPlan         = values.Value <double?>("CJGDWPlan");
                    double?  CJGDWComplete     = values.Value <double?>("CJGDWComplete");
                    double?  JJGDWPlan         = values.Value <double?>("JJGDWPlan");
                    double?  JJGDWComplete     = values.Value <double?>("JJGDWComplete");
                    double?  Odds              = values.Value <double?>("Odds");
                    double?  OddsComplete      = values.Value <double?>("OddsComplete");
                    DateTime?Date              = values.Value <DateTime?>("Date");

                    if (FAB_NAME != null)
                    {
                        pm.FAB_NAME = FAB_NAME;
                    }
                    if (OTD != null)
                    {
                        pm.OTD = OTD;
                    }
                    if (OTDComplete != null)
                    {
                        pm.OTDComplete = OTDComplete;
                    }
                    if (DPMO != null)
                    {
                        pm.DPMO = DPMO;
                    }
                    if (DPMOCompletefloat != null)
                    {
                        pm.DPMOCompletefloat = DPMOCompletefloat;
                    }
                    if (Ncr != null)
                    {
                        pm.Ncr = Ncr;
                    }
                    if (HourYearComplete != null)
                    {
                        pm.HourYearComplete = HourYearComplete;
                    }
                    if (HourMonthPlan != null)
                    {
                        pm.HourMonthPlan = HourMonthPlan;
                    }
                    if (HourMonthComplete != null)
                    {
                        pm.HourMonthComplete = HourMonthComplete;
                    }
                    if (JGGSPlan != null)
                    {
                        pm.JGGSPlan = JGGSPlan;
                    }
                    if (JGGSComplete != null)
                    {
                        pm.JGGSComplete = JGGSComplete;
                    }
                    if (CJGDWPlan != null)
                    {
                        pm.CJGDWPlan = CJGDWPlan;
                    }
                    if (CJGDWComplete != null)
                    {
                        pm.CJGDWComplete = CJGDWComplete;
                    }
                    if (JJGDWPlan != null)
                    {
                        pm.JJGDWPlan = JJGDWPlan;
                    }
                    if (JJGDWComplete != null)
                    {
                        pm.JJGDWComplete = JJGDWComplete;
                    }
                    if (Odds != null)
                    {
                        pm.Odds = Odds;
                    }
                    if (OddsComplete != null)
                    {
                        pm.OddsComplete = OddsComplete;
                    }
                    if (Date != null)
                    {
                        pm.Date = Date;
                    }

                    db.SaveChanges();
                }
                else if (status == "newadded")
                {
                    OtdDpmo pm = new OtdDpmo();

                    string FAB_NAME          = values.Value <string>("FAB_NAME");
                    double?OTD               = values.Value <double?>("OTD");
                    double?OTDComplete       = values.Value <double?>("OTDComplete");
                    double?DPMO              = values.Value <double?>("DPMO");
                    double?DPMOCompletefloat = values.Value <double?>("DPMOCompletefloat");
                    double?Ncr               = values.Value <double?>("Ncr");
                    double?HourYearComplete  = values.Value <double?>("HourYearComplete");
                    double?HourMonthPlan     = values.Value <double?>("HourMonthPlan");
                    double?HourMonthComplete = values.Value <double?>("HourMonthComplete");
                    double?JGGSPlan          = values.Value <double?>("JGGSPlan");
                    double?JGGSComplete      = values.Value <double?>("JGGSComplete");
                    double?CJGDWPlan         = values.Value <double?>("CJGDWPlan");
                    double?CJGDWComplete     = values.Value <double?>("CJGDWComplete");
                    double?JJGDWPlan         = values.Value <double?>("JJGDWPlan");
                    double?JJGDWComplete     = values.Value <double?>("JJGDWComplete");
                    double?Odds              = values.Value <double?>("Odds");
                    double?OddsComplete      = values.Value <double?>("OddsComplete");
                    string Date              = values.Value <string>("Date");


                    if (FAB_NAME != null)
                    {
                        pm.FAB_NAME = FAB_NAME;
                    }
                    if (OTD != null)
                    {
                        pm.OTD = OTD;
                    }
                    if (OTDComplete != null)
                    {
                        pm.OTDComplete = OTDComplete;
                    }
                    if (DPMO != null)
                    {
                        pm.DPMO = DPMO;
                    }
                    if (DPMOCompletefloat != null)
                    {
                        pm.DPMOCompletefloat = DPMOCompletefloat;
                    }
                    if (Ncr != null)
                    {
                        pm.Ncr = Ncr;
                    }
                    if (HourYearComplete != null)
                    {
                        pm.HourYearComplete = HourYearComplete;
                    }
                    if (HourMonthPlan != null)
                    {
                        pm.HourMonthPlan = HourMonthPlan;
                    }
                    if (HourMonthComplete != null)
                    {
                        pm.HourMonthComplete = HourMonthComplete;
                    }
                    if (JGGSPlan != null)
                    {
                        pm.JGGSPlan = JGGSPlan;
                    }
                    if (JGGSComplete != null)
                    {
                        pm.JGGSComplete = JGGSComplete;
                    }
                    if (CJGDWPlan != null)
                    {
                        pm.CJGDWPlan = CJGDWPlan;
                    }
                    if (CJGDWComplete != null)
                    {
                        pm.CJGDWComplete = CJGDWComplete;
                    }
                    if (JJGDWPlan != null)
                    {
                        pm.JJGDWPlan = JJGDWPlan;
                    }
                    if (JJGDWComplete != null)
                    {
                        pm.JJGDWComplete = JJGDWComplete;
                    }
                    if (Odds != null)
                    {
                        pm.Odds = Odds;
                    }
                    if (OddsComplete != null)
                    {
                        pm.OddsComplete = OddsComplete;
                    }
                    if (!string.IsNullOrEmpty(Date))
                    {
                        pm.Date = Convert.ToDateTime(Date);
                    }

                    db.OtdDpmo.Add(pm);
                    db.SaveChanges();
                }
                else if (status == "deleted")
                {
                    int id = mergedRow.Value <int>("id");

                    OtdDpmo pm = db.OtdDpmo.Where(p => p.ID == id).FirstOrDefault();

                    db.OtdDpmo.Remove(pm);

                    db.SaveChanges();
                }
            }

            List <OtdDpmo> pmList;

            int year  = DateTime.Now.Year;
            int month = DateTime.Now.Month;

            if (yearMonth != null)
            {
                pmList = db.OtdDpmo.Where(p => p.Date.Value.Year == yearMonth.Value.Year && p.Date.Value.Month == yearMonth.Value.Month).ToList();
            }
            else
            {
                pmList = db.OtdDpmo.Where(p => p.Date.Value.Year == year && p.Date.Value.Month == month).ToList();
            }

            var dataSource = PagingHelper <OtdDpmo> .GetPagedDataTable(pageIndex, 20, pmList.Count(), pmList);

            UIHelper.Grid("Grid1").DataSource(dataSource, Grid1_fields);
            Alert.Show("操作成功!");

            return(UIHelper.Result());
        }
Exemple #12
0
        public ActionResult btnSubmit_Click(string[] Grid1_fields, JArray Grid1_modifiedData, int pageIndex, DateTime?yearMonth)
        {
            foreach (JObject mergedRow in Grid1_modifiedData)
            {
                string  status   = mergedRow.Value <string>("status");
                int     rowIndex = mergedRow.Value <int>("index");
                JObject values   = mergedRow.Value <JObject>("values");

                if (status == "modified")
                {
                    int id = mergedRow.Value <int>("id");

                    SaleManage sm = db.SaleManage.Where(p => p.ID == id).FirstOrDefault();

                    string   RSPO_DEPT   = values.Value <string>("RSPO_DEPT");
                    double?  MANAGE_PLAN = values.Value <double?>("MANAGE_PLAN");
                    double?  SALE_PLAN   = values.Value <double?>("SALE_PLAN");
                    double?  SALE_FINISH = values.Value <double?>("SALE_FINISH");
                    DateTime?PLAN_DATE   = values.Value <DateTime?>("PLAN_DATE");
                    string   REMARK      = values.Value <string>("REMARK");
                    string   Company     = values.Value <string>("Company");
                    int?     SellYear    = values.Value <int>("SellYear");

                    if (RSPO_DEPT != null)
                    {
                        sm.RSPO_DEPT = RSPO_DEPT;
                    }
                    if (MANAGE_PLAN != null)
                    {
                        sm.MANAGE_PLAN = (double)MANAGE_PLAN;
                    }
                    if (SALE_PLAN != null)
                    {
                        sm.SALE_PLAN = SALE_PLAN;
                    }
                    if (SALE_FINISH != null)
                    {
                        sm.SALE_FINISH = SALE_FINISH;
                    }
                    if (PLAN_DATE != null)
                    {
                        sm.PLAN_DATE = (DateTime)PLAN_DATE;
                    }
                    if (REMARK != null)
                    {
                        sm.REMARK = REMARK;
                    }
                    if (Company != null)
                    {
                        sm.Company = Company;
                    }
                    if (SellYear != null)
                    {
                        sm.SellYear = (int)SellYear;
                    }

                    db.SaveChanges();
                }
                else if (status == "newadded")
                {
                    SaleManage sm = new SaleManage();

                    string RSPO_DEPT   = values.Value <string>("RSPO_DEPT");
                    double?MANAGE_PLAN = values.Value <double?>("MANAGE_PLAN");
                    double?SALE_PLAN   = values.Value <double?>("SALE_PLAN");
                    double?SALE_FINISH = values.Value <double?>("SALE_FINISH");
                    string PLAN_DATE   = values.Value <string>("PLAN_DATE");
                    string REMARK      = values.Value <string>("REMARK");
                    string Company     = values.Value <string>("Company");
                    int?   SellYear    = values.Value <int>("SellYear");

                    if (RSPO_DEPT != null)
                    {
                        sm.RSPO_DEPT = RSPO_DEPT;
                    }
                    if (MANAGE_PLAN != null)
                    {
                        sm.MANAGE_PLAN = (double)MANAGE_PLAN;
                    }
                    if (SALE_PLAN != null)
                    {
                        sm.SALE_PLAN = SALE_PLAN;
                    }
                    if (SALE_FINISH != null)
                    {
                        sm.SALE_FINISH = SALE_FINISH;
                    }
                    if (PLAN_DATE != null)
                    {
                        sm.PLAN_DATE = Convert.ToDateTime(PLAN_DATE);
                    }
                    if (REMARK != null)
                    {
                        sm.REMARK = REMARK;
                    }
                    if (Company != null)
                    {
                        sm.Company = Company;
                    }
                    if (SellYear != null)
                    {
                        sm.SellYear = (int)SellYear;
                    }


                    db.SaleManage.Add(sm);
                    db.SaveChanges();
                }
                else if (status == "deleted")
                {
                    int id = mergedRow.Value <int>("id");

                    SaleManage sm = db.SaleManage.Where(p => p.ID == id).FirstOrDefault();

                    db.SaleManage.Remove(sm);

                    db.SaveChanges();
                }
            }

            List <SaleManage> smList;

            if (yearMonth != null)
            {
                smList = db.SaleManage.Where(p => p.PLAN_DATE.Year == yearMonth.Value.Year && p.PLAN_DATE.Month == yearMonth.Value.Month).ToList();
            }
            else
            {
                smList = db.SaleManage.ToList();
            }

            var dataSource = PagingHelper <SaleManage> .GetPagedDataTable(pageIndex, 20, smList.Count(), smList);

            UIHelper.Grid("Grid1").DataSource(dataSource, Grid1_fields);
            Alert.Show("操作成功!");

            return(UIHelper.Result());
        }
Exemple #13
0
        public ActionResult btnSubmit_YearPlan_Click(string[] Grid1_fields, JArray Grid1_modifiedData, int pageIndex)
        {
            foreach (JObject mergedRow in Grid1_modifiedData)
            {
                string  status   = mergedRow.Value <string>("status");
                int     rowIndex = mergedRow.Value <int>("index");
                JObject values   = mergedRow.Value <JObject>("values");

                if (status == "modified")
                {
                    int id = mergedRow.Value <int>("id");

                    YearPlan yp = db.YearPlan.Where(p => p.ID == id).FirstOrDefault();

                    string Factory      = values.Value <string>("Factory");
                    int?   Year         = values.Value <int?>("Year");
                    double?SellYearPlan = values.Value <double?>("SellYearPlan");
                    double?YearPlan1    = values.Value <double?>("YearPlan1");

                    if (Factory != null)
                    {
                        yp.Factory = Factory;
                    }
                    if (Year != null)
                    {
                        yp.Year = (int)Year;
                    }
                    if (SellYearPlan != null)
                    {
                        yp.SellYearPlan = (double)SellYearPlan;
                    }
                    if (YearPlan1 != null)
                    {
                        yp.YearPlan1 = (double)YearPlan1;
                    }

                    db.SaveChanges();
                }
                else if (status == "newadded")
                {
                    YearPlan yp = new YearPlan();

                    string Factory      = values.Value <string>("Factory");
                    int?   Year         = values.Value <int?>("Year");
                    double?SellYearPlan = values.Value <double?>("SellYearPlan");
                    double?YearPlan1    = values.Value <double?>("YearPlan1");

                    if (Factory != null)
                    {
                        yp.Factory = Factory;
                    }
                    if (Year != null)
                    {
                        yp.Year = (int)Year;
                    }
                    if (SellYearPlan != null)
                    {
                        yp.SellYearPlan = (double)SellYearPlan;
                    }
                    if (YearPlan1 != null)
                    {
                        yp.YearPlan1 = (double)YearPlan1;
                    }


                    db.YearPlan.Add(yp);
                    db.SaveChanges();
                }
                else if (status == "deleted")
                {
                    int id = mergedRow.Value <int>("id");

                    YearPlan yp = db.YearPlan.Where(p => p.ID == id).FirstOrDefault();

                    db.YearPlan.Remove(yp);

                    db.SaveChanges();
                }
            }

            List <YearPlan> ypList;

            ypList = db.YearPlan.ToList();

            var dataSource = PagingHelper <YearPlan> .GetPagedDataTable(pageIndex, 20, ypList.Count(), ypList);

            UIHelper.Grid("Grid1").DataSource(dataSource, Grid1_fields);
            Alert.Show("操作成功!");

            return(UIHelper.Result());
        }
Exemple #14
0
 // GET: ProductManages
 public ActionResult Index()
 {
     ViewBag.RecordCount = db.SaleManage.Count();
     return(View(PagingHelper <SaleManage> .GetPagedDataTable(0, 20, db.SaleManage.Count(), db.SaleManage.ToList())));
 }
Exemple #15
0
        public ActionResult btnSubmit_Click(string[] Grid1_fields, JArray Grid1_modifiedData, int pageIndex, DateTime?yearMonth)
        {
            foreach (JObject mergedRow in Grid1_modifiedData)
            {
                string  status   = mergedRow.Value <string>("status");
                int     rowIndex = mergedRow.Value <int>("index");
                JObject values   = mergedRow.Value <JObject>("values");

                if (status == "modified")
                {
                    int id = mergedRow.Value <int>("id");

                    TimelyRate pm = db.TimelyRate.Where(p => p.ID == id).FirstOrDefault();

                    string   FAB_NAME = values.Value <string>("FAB_NAME");
                    double?  Week1    = values.Value <double?>("Week1");
                    double?  Week2    = values.Value <double?>("Week2");
                    double?  Week3    = values.Value <double?>("Week3");
                    double?  Week4    = values.Value <double?>("Week4");
                    double?  Month1   = values.Value <double?>("Month1");
                    double?  RealPlan = values.Value <double?>("RealPlan");
                    DateTime?PlanDate = values.Value <DateTime?>("PlanDate");

                    if (FAB_NAME != null)
                    {
                        pm.FAB_NAME = FAB_NAME;
                    }
                    if (Week1 != null)
                    {
                        pm.Week1 = Week1;
                    }
                    if (Week2 != null)
                    {
                        pm.Week2 = Week2;
                    }
                    if (Week3 != null)
                    {
                        pm.Week3 = Week3;
                    }
                    if (Week4 != null)
                    {
                        pm.Week4 = Week4;
                    }
                    if (Month1 != null)
                    {
                        pm.Month1 = Month1;
                    }
                    if (RealPlan != null)
                    {
                        pm.RealPlan = RealPlan;
                    }
                    if (PlanDate != null)
                    {
                        pm.PlanDate = PlanDate;
                    }

                    db.SaveChanges();
                }
                else if (status == "newadded")
                {
                    TimelyRate pm = new TimelyRate();

                    string FAB_NAME = values.Value <string>("FAB_NAME");
                    double?Week1    = values.Value <double?>("Week1");
                    double?Week2    = values.Value <double?>("Week2");
                    double?Week3    = values.Value <double?>("Week3");
                    double?Week4    = values.Value <double?>("Week4");
                    double?Month1   = values.Value <double?>("Month1");
                    double?RealPlan = values.Value <double?>("RealPlan");
                    string PlanDate = values.Value <string>("PlanDate");


                    if (FAB_NAME != null)
                    {
                        pm.FAB_NAME = FAB_NAME;
                    }
                    if (Week1 != null)
                    {
                        pm.Week1 = Week1;
                    }
                    if (Week2 != null)
                    {
                        pm.Week2 = Week2;
                    }
                    if (Week3 != null)
                    {
                        pm.Week3 = Week3;
                    }
                    if (Week4 != null)
                    {
                        pm.Week4 = Week4;
                    }
                    if (Month1 != null)
                    {
                        pm.Month1 = Month1;
                    }
                    if (RealPlan != null)
                    {
                        pm.RealPlan = RealPlan;
                    }
                    if (!string.IsNullOrEmpty(PlanDate))
                    {
                        pm.PlanDate = Convert.ToDateTime(PlanDate);
                    }

                    db.TimelyRate.Add(pm);
                    db.SaveChanges();
                }
                else if (status == "deleted")
                {
                    int id = mergedRow.Value <int>("id");

                    TimelyRate pm = db.TimelyRate.Where(p => p.ID == id).FirstOrDefault();

                    db.TimelyRate.Remove(pm);

                    db.SaveChanges();
                }
            }

            List <TimelyRate> pmList;

            int year  = DateTime.Now.Year;
            int month = DateTime.Now.Month;

            if (yearMonth != null)
            {
                pmList = db.TimelyRate.Where(p => p.PlanDate.Value.Year == yearMonth.Value.Year && p.PlanDate.Value.Month == yearMonth.Value.Month).ToList();
            }
            else
            {
                pmList = db.TimelyRate.Where(p => p.PlanDate.Value.Year == year && p.PlanDate.Value.Month == month).ToList();
            }

            var dataSource = PagingHelper <TimelyRate> .GetPagedDataTable(pageIndex, 20, pmList.Count(), pmList);

            UIHelper.Grid("Grid1").DataSource(dataSource, Grid1_fields);
            Alert.Show("操作成功!");

            return(UIHelper.Result());
        }
        public ActionResult btnSubmit_Click(string[] Grid1_fields, JArray Grid1_modifiedData, int pageIndex)
        {
            foreach (JObject mergedRow in Grid1_modifiedData)
            {
                string  status   = mergedRow.Value <string>("status");
                int     rowIndex = mergedRow.Value <int>("index");
                JObject values   = mergedRow.Value <JObject>("values");

                if (status == "modified")
                {
                    int id = mergedRow.Value <int>("id");

                    VentureCapa pm = db.VentureCapa.Where(p => p.ID == id).FirstOrDefault();

                    string FAB_NAME           = values.Value <string>("FAB_NAME");
                    string VENTURENAME        = values.Value <string>("VENTURENAME");
                    string OPERATIONNAME      = values.Value <string>("OPERATIONNAME");
                    double?PROCUT_QUOTA       = values.Value <double?>("PROCUT_QUOTA");
                    double?PROCUT_QUOTA_WEEK  = values.Value <double?>("PROCUT_QUOTA_WEEK");
                    double?PROCUT_QUOTA_MONTH = values.Value <double?>("PROCUT_QUOTA_MONTH");

                    if (FAB_NAME != null)
                    {
                        pm.FAB_NAME = FAB_NAME;
                    }
                    if (VENTURENAME != null)
                    {
                        pm.VENTURENAME = VENTURENAME;
                    }
                    if (OPERATIONNAME != null)
                    {
                        pm.OPERATIONNAME = OPERATIONNAME;
                    }
                    if (PROCUT_QUOTA != null)
                    {
                        pm.PROCUT_QUOTA = PROCUT_QUOTA;
                    }
                    if (PROCUT_QUOTA_WEEK != null)
                    {
                        pm.PROCUT_QUOTA_WEEK = PROCUT_QUOTA_WEEK;
                    }
                    if (PROCUT_QUOTA_MONTH != null)
                    {
                        pm.PROCUT_QUOTA_MONTH = PROCUT_QUOTA_MONTH;
                    }

                    db.SaveChanges();
                }
                else if (status == "newadded")
                {
                    VentureCapa pm = new VentureCapa();

                    string FAB_NAME           = values.Value <string>("FAB_NAME");
                    string VENTURENAME        = values.Value <string>("VENTURENAME");
                    string OPERATIONNAME      = values.Value <string>("OPERATIONNAME");
                    double?PROCUT_QUOTA       = values.Value <double?>("PROCUT_QUOTA");
                    double?PROCUT_QUOTA_WEEK  = values.Value <double?>("PROCUT_QUOTA_WEEK");
                    double?PROCUT_QUOTA_MONTH = values.Value <double?>("PROCUT_QUOTA_MONTH");


                    if (FAB_NAME != null)
                    {
                        pm.FAB_NAME = FAB_NAME;
                    }
                    if (VENTURENAME != null)
                    {
                        pm.VENTURENAME = VENTURENAME;
                    }
                    if (OPERATIONNAME != null)
                    {
                        pm.OPERATIONNAME = OPERATIONNAME;
                    }
                    if (PROCUT_QUOTA != null)
                    {
                        pm.PROCUT_QUOTA = PROCUT_QUOTA;
                    }
                    if (PROCUT_QUOTA_WEEK != null)
                    {
                        pm.PROCUT_QUOTA_WEEK = PROCUT_QUOTA_WEEK;
                    }
                    if (PROCUT_QUOTA_MONTH != null)
                    {
                        pm.PROCUT_QUOTA_MONTH = PROCUT_QUOTA_MONTH;
                    }

                    db.VentureCapa.Add(pm);
                    db.SaveChanges();
                }
                else if (status == "deleted")
                {
                    int id = mergedRow.Value <int>("id");

                    VentureCapa pm = db.VentureCapa.Where(p => p.ID == id).FirstOrDefault();

                    db.VentureCapa.Remove(pm);

                    db.SaveChanges();
                }
            }

            List <VentureCapa> pmList;

            int year  = DateTime.Now.Year;
            int month = DateTime.Now.Month;

            pmList = db.VentureCapa.ToList();

            var dataSource = PagingHelper <VentureCapa> .GetPagedDataTable(pageIndex, 20, pmList.Count(), pmList);

            UIHelper.Grid("Grid1").DataSource(dataSource, Grid1_fields);
            Alert.Show("操作成功!");

            return(UIHelper.Result());
        }