コード例 #1
0
ファイル: Ribbon1.cs プロジェクト: psuedo98/DataImport2019
        private void button3_Click(object sender, RibbonControlEventArgs e)
        {
            try
            {
                Excel.Application app     = Globals.ThisAddIn.Application;
                Excel.Workbook    wkbook  = app.ActiveWorkbook;
                Excel.Worksheet   wksheet = wkbook.ActiveSheet;

                string jobnumber = wksheet.Cells[1, "A"].Value;

                var wip = new adoEntities();

                Kickoff    ko  = wip.Kickoffs.Find(jobnumber);
                ActualsRep act = wip.ActualsReps.Find(jobnumber);

                //RecordDataView recorddataview = db.RecordDataView.SingleOrDefault(m => m.Record_number == id);

                JobMetric jo = wip.JobMetrics.FirstOrDefault(m => m.BaseID == jobnumber);
                // JobMetric jo = wip.JobMetrics.Find(jobnumber);



                //Quoted Hours
                wksheet.Cells[16, "B"].Value = ko.DesignEst;
                wksheet.Cells[17, "B"].Value = ko.PlanningEst;
                wksheet.Cells[18, "B"].Value = ko.WaterjetEst;
                wksheet.Cells[19, "B"].Value = ko.WeldEst;
                wksheet.Cells[20, "B"].Value = ko.NCEst;
                wksheet.Cells[21, "B"].Value = ko.ConventionalEst;
                wksheet.Cells[22, "B"].Value = ko.AssemblyEst;
                wksheet.Cells[23, "B"].Value = ko.InspectionEst;

                //Adjusted Hours

                wksheet.Cells[16, "E"].Value = ko.Design;
                wksheet.Cells[17, "E"].Value = ko.Planning;
                wksheet.Cells[18, "E"].Value = ko.Waterjet;
                wksheet.Cells[19, "E"].Value = ko.Weld;
                wksheet.Cells[20, "E"].Value = ko.NC;
                wksheet.Cells[21, "E"].Value = ko.Convetional;
                wksheet.Cells[22, "E"].Value = ko.Assy;
                wksheet.Cells[23, "E"].Value = ko.Inspection;

                //Actual Hours
                MessageBox.Show("Time for the Actuals");
                try
                {
                    wksheet.Cells[16, "H"].Value = act.Design;
                    wksheet.Cells[17, "H"].Value = act.Planning;
                    wksheet.Cells[18, "H"].Value = act.Waterjet;
                    wksheet.Cells[19, "H"].Value = act.Weld;
                    wksheet.Cells[20, "H"].Value = act.Nc;
                    wksheet.Cells[21, "H"].Value = act.Machining;
                    wksheet.Cells[22, "H"].Value = act.Assy;
                    wksheet.Cells[23, "H"].Value = act.Inspection;

                    wksheet.Cells[16, "I"].Value = act.DesignCost;
                    wksheet.Cells[17, "I"].Value = act.PlanningCost;
                    wksheet.Cells[18, "I"].Value = act.WaterJetCost;
                    wksheet.Cells[19, "I"].Value = act.WeldCost;
                    wksheet.Cells[20, "I"].Value = act.NcCost;
                    wksheet.Cells[21, "I"].Value = act.MachiningCost;
                    wksheet.Cells[22, "I"].Value = act.AssyCost;
                    wksheet.Cells[23, "I"].Value = act.InspectionCost;
                }

                catch (Exception ef)
                {
                    MessageBox.Show(ef.ToString());
                }


                //Margin

                wksheet.Cells[8, "I"].Value = jo.Margin;
                wksheet.Cells[9, "I"].Value = jo.Actual;
                wksheet.Cells[1, "F"].Value = jo.POValue;
                wksheet.Cells[2, "F"].Value = jo.ContractDate;
                wksheet.Cells[1, "I"].Value = "FUCKIFIKNOW";
                wksheet.Cells[2, "I"].Value = jo.ShipDate;
            }

            catch (Exception ef)
            {
                MessageBox.Show(ef.Message.ToString());
            }

            //Convert.ToInt32(wksheet.Cells[20, "BV"].Value);
        }
コード例 #2
0
ファイル: Ribbon1.cs プロジェクト: psuedo98/DataImport2019
        private void button4_Click(object sender, RibbonControlEventArgs e)
        {
            Excel.Application app     = Globals.ThisAddIn.Application;
            Excel.Workbook    wkbook  = app.ActiveWorkbook;
            Excel.Worksheet   wksheet = wkbook.ActiveSheet;


            string item = wksheet.Name.ToString();
            string lot  = item.Substring(item.Length - 1);


            int iPlanning     = 0;
            int iDesign       = 0;
            int iWaterjet     = 0;
            int iWeld         = 0;
            int iNC           = 0;
            int iConventional = 0;
            int iOutsource    = 0;
            int iAssembly     = 0;
            int iInspection   = 0;
            int iShipping     = 0;

            int iPlanningEst     = 0;
            int iDesignEst       = 0;
            int iWaterjetEst     = 0;
            int iWeldEst         = 0;
            int iNCEst           = 0;
            int iConventionalEst = 0;
            int iOutsourceEst    = 0;
            int iAssemblyEst     = 0;
            int iInspectionEst   = 0;
            int iShippingEst     = 0;

            int z = 8;


            string jobnumber = wksheet.Cells[5, "BV"].Value;

            iPlanning        += Convert.ToInt32(wksheet.Cells[7, "BV"].Value);
            iPlanningEst     += Convert.ToInt32(wksheet.Cells[7, "BI"].Value);
            iDesign          += Convert.ToInt32(wksheet.Cells[12, "BV"].Value);
            iDesignEst       += Convert.ToInt32(wksheet.Cells[12, "BI"].Value);
            iWaterjet        += Convert.ToInt32(wksheet.Cells[16, "BV"].Value);
            iWaterjetEst     += Convert.ToInt32(wksheet.Cells[16, "BI"].Value);
            iWeld            += Convert.ToInt32(wksheet.Cells[20, "BV"].Value);
            iWeldEst         += Convert.ToInt32(wksheet.Cells[20, "BI"].Value);
            iNC              += Convert.ToInt32(wksheet.Cells[28, "BV"].Value);
            iNCEst           += Convert.ToInt32(wksheet.Cells[28, "BI"].Value);
            iConventional    += Convert.ToInt32(wksheet.Cells[36, "BV"].Value);
            iConventionalEst += Convert.ToInt32(wksheet.Cells[36, "BI"].Value);
            iOutsource       += Convert.ToInt32(wksheet.Cells[40, "BW"].Value);
            iOutsourceEst    += Convert.ToInt32(wksheet.Cells[40, "BJ"].Value);
            iAssembly        += Convert.ToInt32(wksheet.Cells[53, "BV"].Value);
            iAssemblyEst     += Convert.ToInt32(wksheet.Cells[53, "BI"].Value);
            iInspection      += Convert.ToInt32(wksheet.Cells[60, "BV"].Value);
            iInspectionEst   += Convert.ToInt32(wksheet.Cells[60, "BI"].Value);
            iShipping        += Convert.ToInt32(wksheet.Cells[67, "BV"].Value);
            iShippingEst     += Convert.ToInt32(wksheet.Cells[67, "BI"].Value);

            var wip = new adoEntities();

            Kickoff ko = new Kickoff();

            ko.Assy            = iAssembly;
            ko.AssemblyEst     = iAssemblyEst;
            ko.BaseID          = jobnumber;
            ko.Convetional     = iConventional;
            ko.ConventionalEst = iConventionalEst;
            ko.Shipping        = iShipping;
            ko.ShippingEst     = iShippingEst;
            ko.Planning        = iPlanning;
            ko.PlanningEst     = iPlanningEst;
            ko.Design          = iDesign;
            ko.DesignEst       = iDesignEst;
            ko.Waterjet        = iWaterjet;
            ko.WaterjetEst     = iWaterjetEst;
            ko.Weld            = iWeld;
            ko.WeldEst         = iWeldEst;
            ko.NC            = iNC;
            ko.NCEst         = iNCEst;
            ko.Outsource     = iOutsource;
            ko.OutsourceEst  = iOutsourceEst;
            ko.Inspection    = iInspection;
            ko.InspectionEst = iInspectionEst;
            ko.Design        = iDesign;
            ko.DesignEst     = iDesignEst;
            try
            {
                wip.Kickoffs.Add(ko);
            }
            catch (Exception x)
            {
                MessageBox.Show(x.Message);
            }

            try
            {
                wip.SaveChanges();
            }
            catch (Exception xx)
            {
                MessageBox.Show(xx.Message);
            }

            finally
            {
                MessageBox.Show("SUCCESS!!! F**K YEA");
            }
        }