private void btnUpdateMachineRequirement_Click(object sender, RoutedEventArgs e) { if (MessageBox.Show("Confirm Save?", this.Title, MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.No) { return; } if (bwUpdate.IsBusy == false) { this.Cursor = Cursors.Wait; btnUpdateMachineRequirement.IsEnabled = false; machineRequirementToUpdate = dgMachineRequirement.Items.OfType <MachineRequirementModel>().FirstOrDefault(); bwUpdate.RunWorkerAsync(); } }
private void bwDelete_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e) { this.Cursor = null; btnDelete.IsEnabled = true; btnSearch.IsEnabled = true; if (e.Error != null) { MessageBox.Show(e.Error.Message, "Error", MessageBoxButton.OK, MessageBoxImage.Error); return; } machineRequirementModel = null; dgMachineRequirement.ItemsSource = null; btnUpdateMachineRequirement.IsEnabled = false; MessageBox.Show("Deleted!", this.Title, MessageBoxButton.OK, MessageBoxImage.Information); }
public static bool Insert(MachineRequirementModel model) { var @ArticleNo = new SqlParameter("@ArticleNo", model.ArticleNo); var @ShoeName = new SqlParameter("@ShoeName", model.ShoeName); var @PM = new SqlParameter("@PM", model.PM); // Cutting var @CuttingQuantity = new SqlParameter("@CuttingQuantity", model.CuttingQuantity); var @CuttingWorker = new SqlParameter("@CuttingWorker", model.CuttingWorker); var @CuttingArmClicker = new SqlParameter("@CuttingArmClicker", model.CuttingArmClicker); var @CuttingBeam = new SqlParameter("@CuttingBeam", model.CuttingBeam); var @CuttingCutStrap = new SqlParameter("@CuttingCutStrap", model.CuttingCutStrap); var @CuttingLaser = new SqlParameter("@CuttingLaser", model.CuttingLaser); var @CuttingPuncherHole = new SqlParameter("@CuttingPuncherHole", model.CuttingPuncherHole); var @CuttingSkiving = new SqlParameter("@CuttingSkiving", model.CuttingSkiving); // Prep var @PrepWorker = new SqlParameter("@PrepWorker", model.PrepWorker); var @PrepVerticalHF = new SqlParameter("@PrepVerticalHF", model.PrepVerticalHF); var @PrepHorizontalHF = new SqlParameter("@PrepHorizontalHF", model.PrepHorizontalHF); var @PrepOnlineHeatPress = new SqlParameter("@PrepOnlineHeatPress", model.PrepOnlineHeatPress); var @PrepAutoHF = new SqlParameter("@PrepAutoHF", model.PrepAutoHF); var @PrepInye = new SqlParameter("@PrepInye", model.PrepInye); var @PrepHotmeltMachine = new SqlParameter("@PrepHotmeltMachine", model.PrepHotmeltMachine); // Sewing var @SewingQuantity = new SqlParameter("@SewingQuantity", model.SewingQuantity); var @SewingWorker = new SqlParameter("@SewingWorker", model.SewingWorker); var @SewingSmallComputer = new SqlParameter("@SewingSmallComputer", model.SewingSmallComputer); var @SewingBigComputer = new SqlParameter("@SewingBigComputer", model.SewingBigComputer); var @SewingUltrasonic = new SqlParameter("@SewingUltrasonic", model.SewingUltrasonic); var @Sewing4NeedleFlat = new SqlParameter("@Sewing4NeedleFlat", model.Sewing4NeedleFlat); var @Sewing4NeedlePost = new SqlParameter("@Sewing4NeedlePost", model.Sewing4NeedlePost); var @SewingLongTable = new SqlParameter("@SewingLongTable", model.SewingLongTable); var @SewingEyeleting = new SqlParameter("@SewingEyeleting", model.SewingEyeleting); var @SewingZZBinding = new SqlParameter("@SewingZZBinding", model.SewingZZBinding); var @SewingHotmeltMachine = new SqlParameter("@SewingHotmeltMachine", model.SewingHotmeltMachine); var @SewingHandHeldHotmelt = new SqlParameter("@SewingHandHeldHotmelt", model.SewingHandHeldHotmelt); var @SewingStationaryHHHotmelt = new SqlParameter("@SewingStationaryHHHotmelt", model.SewingStationaryHHHotmelt); // Stockfit var @StockfitQuantity = new SqlParameter("@StockfitQuantity", model.StockfitQuantity); var @StockfitWorker = new SqlParameter("@StockfitWorker", model.StockfitWorker); var @StockfitVerticalBuffing = new SqlParameter("@StockfitVerticalBuffing", model.StockfitVerticalBuffing); var @StockfitHorizontalBuffing = new SqlParameter("@StockfitHorizontalBuffing", model.StockfitHorizontalBuffing); var @StockfitSideBuffing = new SqlParameter("@StockfitSideBuffing", model.StockfitSideBuffing); var @StockfitOutsoleStitching = new SqlParameter("@StockfitOutsoleStitching", model.StockfitOutsoleStitching); var @StockfitAutoBuffing = new SqlParameter("@StockfitAutoBuffing", model.StockfitAutoBuffing); var @StockfitHydraulicCutting = new SqlParameter("@StockfitHydraulicCutting", model.StockfitHydraulicCutting); var @StockfitPadPrinting = new SqlParameter("@StockfitPadPrinting", model.StockfitPadPrinting); // Assembly var @AssemblyQuantity = new SqlParameter("@AssemblyQuantity", model.AssemblyQuantity); var @AssemblyWorker = new SqlParameter("@AssemblyWorker", model.AssemblyWorker); var @AssemblyToeLasting = new SqlParameter("@AssemblyToeLasting", model.AssemblyToeLasting); var @AssemblySideLasting = new SqlParameter("@AssemblySideLasting", model.AssemblySideLasting); var @AssemblyHeelLasting = new SqlParameter("@AssemblyHeelLasting", model.AssemblyHeelLasting); var @AssemblySidePress = new SqlParameter("@AssemblySidePress", model.AssemblySidePress); var @AssemblyTopDown = new SqlParameter("@AssemblyTopDown", model.AssemblyTopDown); var @AssemblyHotmeltMachine = new SqlParameter("@AssemblyHotmeltMachine", model.AssemblyHotmeltMachine); var @AssemblySocklinerHotmelt = new SqlParameter("@AssemblySocklinerHotmelt", model.AssemblySocklinerHotmelt); var @AssemblyVWrinkleRemover = new SqlParameter("@AssemblyVWrinkleRemover", model.AssemblyVWrinkleRemover); SaovietMasterScheduleEntities db = new SaovietMasterScheduleEntities(); if (db.ExecuteStoreCommand(@"EXEC spm_InsertMachineRequirement @ArticleNo,@ShoeName,@PM, @CuttingQuantity,@CuttingWorker,@CuttingArmClicker,@CuttingBeam,@CuttingCutStrap,@CuttingLaser,@CuttingPuncherHole,@CuttingSkiving, @PrepWorker,@PrepVerticalHF,@PrepHorizontalHF,@PrepOnlineHeatPress,@PrepAutoHF,@PrepInye,@PrepHotmeltMachine, @SewingQuantity,@SewingWorker,@SewingSmallComputer,@SewingBigComputer,@SewingUltrasonic,@Sewing4NeedleFlat,@Sewing4NeedlePost, @SewingLongTable,@SewingEyeleting,@SewingZZBinding,@SewingHotmeltMachine,@SewingHandHeldHotmelt,@SewingStationaryHHHotmelt, @StockfitQuantity,@StockfitWorker,@StockfitVerticalBuffing,@StockfitHorizontalBuffing,@StockfitSideBuffing,@StockfitOutsoleStitching, @StockfitAutoBuffing,@StockfitHydraulicCutting,@StockfitPadPrinting, @AssemblyQuantity,@AssemblyWorker,@AssemblyToeLasting,@AssemblySideLasting,@AssemblyHeelLasting,@AssemblySidePress, @AssemblyTopDown,@AssemblyHotmeltMachine,@AssemblySocklinerHotmelt,@AssemblyVWrinkleRemover", @ArticleNo, @ShoeName, @PM, @CuttingQuantity, @CuttingWorker, @CuttingArmClicker, @CuttingBeam, @CuttingCutStrap, @CuttingLaser, @CuttingPuncherHole, @CuttingSkiving, @PrepWorker, @PrepVerticalHF, @PrepHorizontalHF, @PrepOnlineHeatPress, @PrepAutoHF, @PrepInye, @PrepHotmeltMachine, @SewingQuantity, @SewingWorker, @SewingSmallComputer, @SewingBigComputer, @SewingUltrasonic, @Sewing4NeedleFlat, @Sewing4NeedlePost, @SewingLongTable, @SewingEyeleting, @SewingZZBinding, @SewingHotmeltMachine, @SewingHandHeldHotmelt, @SewingStationaryHHHotmelt, @StockfitQuantity, @StockfitWorker, @StockfitVerticalBuffing, @StockfitHorizontalBuffing, @StockfitSideBuffing, @StockfitOutsoleStitching, @StockfitAutoBuffing, @StockfitHydraulicCutting, @StockfitPadPrinting, @AssemblyQuantity, @AssemblyWorker, @AssemblyToeLasting, @AssemblySideLasting, @AssemblyHeelLasting, @AssemblySidePress, @AssemblyTopDown, @AssemblyHotmeltMachine, @AssemblySocklinerHotmelt, @AssemblyVWrinkleRemover) > 0) { return(true); } return(false); }
private void bwLoad_DoWork(object sender, DoWorkEventArgs e) { Excel.Application excelApplication = new Excel.Application(); Excel.Workbook excelWorkbook = excelApplication.Workbooks.Open(filePath); //excelApplication.Visible = true; Excel.Worksheet excelWorksheet; Excel.Range excelRange; try { excelWorksheet = (Excel.Worksheet)excelWorkbook.Worksheets[1]; excelRange = excelWorksheet.UsedRange; progressBar.Dispatcher.Invoke((Action)(() => progressBar.Maximum = excelRange.Rows.Count)); //int[] column = {2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50 }; for (int i = 3; i <= excelRange.Rows.Count; i++) { #region // read each excel column MachineRequirementModel machineRequirement = new MachineRequirementModel(); var articleNoValue = (excelRange.Cells[i, 1] as Excel.Range).Value2; if (articleNoValue != null) { string articleNo = articleNoValue.ToString(); machineRequirement.ArticleNo = articleNo; var shoeNameValue = (excelRange.Cells[i, 2] as Excel.Range).Value2; string shoeName = ""; if (shoeNameValue != null) { shoeName = shoeNameValue.ToString(); } machineRequirement.ShoeName = shoeName; var pMValue = (excelRange.Cells[i, 3] as Excel.Range).Value2; string pM = ""; if (pMValue != null) { pM = pMValue.ToString(); } machineRequirement.PM = pM; // Cutting //float cuttingQuantity = 0; var cuttingQuantityValue = (excelRange.Cells[i, 4] as Excel.Range).Value2; string cuttingQuantity = ""; if (cuttingQuantityValue != null) { cuttingQuantity = cuttingQuantityValue.ToString(); } machineRequirement.CuttingQuantity = cuttingQuantity; //float cuttingWorker = 0; var cuttingWorkerValue = (excelRange.Cells[i, 5] as Excel.Range).Value2; string cuttingWorker = ""; if (cuttingWorkerValue != null) { cuttingWorker = cuttingWorkerValue.ToString(); } machineRequirement.CuttingWorker = cuttingWorker; //float cuttingArmCliker = 0; var cuttingArmClikerValue = (excelRange.Cells[i, 6] as Excel.Range).Value2; string cuttingArmClicker = ""; if (cuttingArmClikerValue != null) { cuttingArmClicker = cuttingArmClikerValue.ToString(); } machineRequirement.CuttingArmClicker = cuttingArmClicker; //float cuttingBeam = 0; var cuttingBeamValue = (excelRange.Cells[i, 7] as Excel.Range).Value2; string cuttingBeam = ""; if (cuttingBeamValue != null) { cuttingBeam = cuttingBeamValue.ToString(); } machineRequirement.CuttingBeam = cuttingBeam; //float cuttingCutStrap = 0; var cuttingCutStrapValue = (excelRange.Cells[i, 8] as Excel.Range).Value2; string cuttingCutStrap = ""; if (cuttingCutStrapValue != null) { cuttingCutStrap = cuttingCutStrapValue.ToString(); } machineRequirement.CuttingCutStrap = cuttingCutStrap; //float cuttingLaser = 0; var cuttingLaserValue = (excelRange.Cells[i, 9] as Excel.Range).Value2; string cuttingLaser = ""; if (cuttingLaserValue != null) { cuttingLaser = cuttingLaserValue.ToString(); } machineRequirement.CuttingLaser = cuttingLaser; var cuttingPuncherHoleValue = (excelRange.Cells[i, 10] as Excel.Range).Value2; string cuttingPuncherHole = ""; if (cuttingPuncherHoleValue != null) { cuttingPuncherHole = cuttingPuncherHoleValue.ToString(); } machineRequirement.CuttingPuncherHole = cuttingPuncherHole; //float cuttingSkiving = 0; var cuttingSkivingValue = (excelRange.Cells[i, 11] as Excel.Range).Value2; string cuttingSkiving = ""; if (cuttingSkivingValue != null) { cuttingSkiving = cuttingSkivingValue.ToString(); } machineRequirement.CuttingSkiving = cuttingSkiving; // Prep //float prepWorker = 0; var prepWorkerValue = (excelRange.Cells[i, 12] as Excel.Range).Value2; string prepWorker = ""; if (prepWorkerValue != null) { prepWorker = prepWorkerValue.ToString(); } machineRequirement.PrepWorker = prepWorker; //float prepVerticalHF = 0; var prepVerticalHFValue = (excelRange.Cells[i, 13] as Excel.Range).Value2; string prepVerticalHF = ""; if (prepVerticalHFValue != null) { prepVerticalHF = prepVerticalHFValue.ToString(); } machineRequirement.PrepVerticalHF = prepVerticalHF; //float prepHorizontalHF = 0; var prepHorizontalHFValue = (excelRange.Cells[i, 14] as Excel.Range).Value2; string prepHorizontalHF = ""; if (prepHorizontalHFValue != null) { prepHorizontalHF = prepHorizontalHFValue.ToString(); } machineRequirement.PrepHorizontalHF = prepHorizontalHF; var prepOnlineHeatPressValue = (excelRange.Cells[i, 15] as Excel.Range).Value2; string prepOnlineHeatPress = ""; if (prepOnlineHeatPressValue != null) { prepOnlineHeatPress = prepOnlineHeatPressValue.ToString(); } machineRequirement.PrepOnlineHeatPress = prepOnlineHeatPress; //float prepAutoHF = 0; var prepAutoHFValue = (excelRange.Cells[i, 16] as Excel.Range).Value2; string prepAutoHF = ""; if (prepAutoHFValue != null) { prepAutoHF = prepAutoHFValue.ToString(); } machineRequirement.PrepAutoHF = prepAutoHF; //float prepInye = 0; var prepInyeValue = (excelRange.Cells[i, 17] as Excel.Range).Value2; string prepInye = ""; if (prepInyeValue != null) { prepInye = prepInyeValue.ToString(); } machineRequirement.PrepInye = prepInye; //float prepHotmeltMachine = 0; var prepHotmeltMachineValue = (excelRange.Cells[i, 18] as Excel.Range).Value2; string prepHotmeltMachine = ""; if (prepHotmeltMachineValue != null) { prepHotmeltMachine = prepHotmeltMachineValue.ToString(); } machineRequirement.PrepHotmeltMachine = prepHotmeltMachine; // Sewing var sewingQuantityValue = (excelRange.Cells[i, 19] as Excel.Range).Value2; string sewingQuantity = ""; if (sewingQuantityValue != null) { sewingQuantity = sewingQuantityValue.ToString(); } machineRequirement.SewingQuantity = sewingQuantity; //float sewingWorker = 0; var sewingWorkerValue = (excelRange.Cells[i, 20] as Excel.Range).Value2; string sewingWorker = ""; if (sewingWorkerValue != null) { sewingWorker = sewingWorkerValue.ToString(); } machineRequirement.SewingWorker = sewingWorker; //float sewingSmallComputer = 0; var sewingSmallComputerValue = (excelRange.Cells[i, 21] as Excel.Range).Value2; string sewingSmallComputer = ""; if (sewingSmallComputerValue != null) { sewingSmallComputer = sewingSmallComputerValue.ToString(); } machineRequirement.SewingSmallComputer = sewingSmallComputer; //float sewingBigComputer = 0; var sewingBigComputerValue = (excelRange.Cells[i, 22] as Excel.Range).Value2; string sewingBigComputer = ""; if (sewingBigComputerValue != null) { sewingBigComputer = sewingBigComputerValue.ToString(); } machineRequirement.SewingBigComputer = sewingBigComputer; //float sewingUltrasonic = 0; var sewingUltrasonicValue = (excelRange.Cells[i, 23] as Excel.Range).Value2; string sewingUltrasonic = ""; if (sewingUltrasonicValue != null) { sewingUltrasonic = sewingUltrasonicValue.ToString(); } machineRequirement.SewingUltrasonic = sewingUltrasonic; //float sewingFourNeeldleFlat = 0; var sewing4NeeldleFlatValue = (excelRange.Cells[i, 24] as Excel.Range).Value2; string sewing4NeeldleFlat = ""; if (sewing4NeeldleFlatValue != null) { sewing4NeeldleFlat = sewing4NeeldleFlatValue.ToString(); } machineRequirement.Sewing4NeedleFlat = sewing4NeeldleFlat; //float sewingFourNeedlePost = 0; var sewing4NeedlePostValue = (excelRange.Cells[i, 25] as Excel.Range).Value2; string sewing4NeedlePost = ""; if (sewing4NeedlePostValue != null) { sewing4NeedlePost = sewing4NeedlePostValue.ToString(); } machineRequirement.Sewing4NeedlePost = sewing4NeedlePost; //float sewingLongTable = 0; var sewingLongTableValue = (excelRange.Cells[i, 26] as Excel.Range).Value2; string sewingLongTable = ""; if (sewingLongTableValue != null) { sewingLongTable = sewingLongTableValue.ToString(); } machineRequirement.SewingLongTable = sewingLongTable; //float sewingEyeleting = 0; var sewingEyeletingValue = (excelRange.Cells[i, 27] as Excel.Range).Value2; string sewingEyeleting = ""; if (sewingEyeletingValue != null) { sewingEyeleting = sewingEyeletingValue.ToString(); } machineRequirement.SewingEyeleting = sewingEyeleting; //float sewingZZBinding = 0; var sewingZZBindingValue = (excelRange.Cells[i, 28] as Excel.Range).Value2; string sewingZZBinding = ""; if (sewingZZBindingValue != null) { sewingZZBinding = sewingZZBindingValue.ToString(); } machineRequirement.SewingZZBinding = sewingZZBinding; //float sewingHotmeltMachine = 0; var sewingHotmeltMachineValue = (excelRange.Cells[i, 29] as Excel.Range).Value2; string sewingHotmeltMachine = ""; if (sewingHotmeltMachineValue != null) { sewingHotmeltMachine = sewingHotmeltMachineValue.ToString(); } machineRequirement.SewingHotmeltMachine = sewingHotmeltMachine; //float sewingHotmeltHeldMachine = 0; var sewingHotmeltHeldMachineValue = (excelRange.Cells[i, 30] as Excel.Range).Value2; string sewingHotmeltHeldMachine = ""; if (sewingHotmeltHeldMachineValue != null) { sewingHotmeltHeldMachine = sewingHotmeltHeldMachineValue.ToString(); } machineRequirement.SewingHandHeldHotmelt = sewingHotmeltHeldMachine; //float sewingStationaryHHHotmelt = 0; var sewingStationaryHHHotmeltValue = (excelRange.Cells[i, 31] as Excel.Range).Value2; string sewingStationaryHHHotmelt = ""; if (sewingStationaryHHHotmeltValue != null) { sewingStationaryHHHotmelt = sewingStationaryHHHotmeltValue.ToString(); } machineRequirement.SewingStationaryHHHotmelt = sewingStationaryHHHotmelt; // Stockfit //float stockfitQuantity = 0; var stockfitQuantityValue = (excelRange.Cells[i, 32] as Excel.Range).Value2; string stockfitQuantity = ""; if (stockfitQuantityValue != null) { stockfitQuantity = stockfitQuantityValue.ToString(); } machineRequirement.StockfitQuantity = stockfitQuantity; //float stockfitWorker = 0; var stockfitWorkerValue = (excelRange.Cells[i, 33] as Excel.Range).Value2; string stockfitWorker = ""; if (stockfitWorkerValue != null) { stockfitWorker = stockfitWorkerValue.ToString(); } machineRequirement.StockfitWorker = stockfitWorker; //float stockfitVerticalBuffing = 0; var stockfitVerticalBuffingValue = (excelRange.Cells[i, 34] as Excel.Range).Value2; string stockfitVerticalBuffing = ""; if (stockfitVerticalBuffingValue != null) { stockfitVerticalBuffing = stockfitVerticalBuffingValue.ToString(); } machineRequirement.StockfitVerticalBuffing = stockfitVerticalBuffing; //float stockfitHorizontalBuffing = 0; var stockfitHorizontalBuffingValue = (excelRange.Cells[i, 35] as Excel.Range).Value2; string stockfitHorizontalBuffing = ""; if (stockfitHorizontalBuffingValue != null) { stockfitHorizontalBuffing = stockfitHorizontalBuffingValue.ToString(); } machineRequirement.StockfitHorizontalBuffing = stockfitHorizontalBuffing; //float stockfitSideBuffing = 0; var stockfitSideBuffingValue = (excelRange.Cells[i, 36] as Excel.Range).Value2; string stockfitSideBuffing = ""; if (stockfitSideBuffingValue != null) { stockfitSideBuffing = stockfitSideBuffingValue.ToString(); } machineRequirement.StockfitSideBuffing = stockfitSideBuffing; //float stockfitOutsoleStitching = 0; var stockfitOutsoleStitchingValue = (excelRange.Cells[i, 37] as Excel.Range).Value2; string stockfitOutsoleStitching = ""; if (stockfitOutsoleStitchingValue != null) { stockfitOutsoleStitching = stockfitOutsoleStitchingValue.ToString(); } machineRequirement.StockfitOutsoleStitching = stockfitOutsoleStitching; //float stockfitAutoBuffing = 0; var stockfitAutoBuffingValue = (excelRange.Cells[i, 38] as Excel.Range).Value2; string stockfitAutoBuffing = ""; if (stockfitAutoBuffingValue != null) { stockfitAutoBuffing = stockfitAutoBuffingValue.ToString(); } machineRequirement.StockfitAutoBuffing = stockfitAutoBuffing; //float stockfitHydraulicCutting = 0; var stockfitHydraulicCuttingValue = (excelRange.Cells[i, 39] as Excel.Range).Value2; string stockfitHydraulicCutting = ""; if (stockfitHydraulicCuttingValue != null) { stockfitHydraulicCutting = stockfitHydraulicCuttingValue.ToString(); } machineRequirement.StockfitHydraulicCutting = stockfitHydraulicCutting; //float stockfitPadPrinting = 0; var stockfitPadPrintingValue = (excelRange.Cells[i, 40] as Excel.Range).Value2; string stockfitPadPrinting = ""; if (stockfitPadPrintingValue != null) { stockfitPadPrinting = stockfitPadPrintingValue.ToString(); } machineRequirement.StockfitPadPrinting = stockfitPadPrinting; // Assembly //float assemblyQuantity = 0; var assemblyQuantityValue = (excelRange.Cells[i, 41] as Excel.Range).Value2; string assemblyQuantity = ""; if (assemblyQuantityValue != null) { assemblyQuantity = assemblyQuantityValue.ToString(); } machineRequirement.AssemblyQuantity = assemblyQuantity; //float assemblyWorker = 0; var assemblyWorkerValue = (excelRange.Cells[i, 42] as Excel.Range).Value2; string assemblyWorker = ""; if (assemblyWorkerValue != null) { assemblyWorker = assemblyWorkerValue.ToString(); } machineRequirement.AssemblyWorker = assemblyWorker; //float assemblyToeLasting = 0; var assemblyToeLastingValue = (excelRange.Cells[i, 43] as Excel.Range).Value2; string assemblyToeLasting = ""; if (assemblyToeLastingValue != null) { assemblyToeLasting = assemblyToeLastingValue.ToString(); } machineRequirement.AssemblyToeLasting = assemblyToeLasting; //float assemblySideLasting = 0; var assemblySideLastingValue = (excelRange.Cells[i, 44] as Excel.Range).Value2; string assemblySideLasting = ""; if (assemblySideLastingValue != null) { assemblySideLasting = assemblySideLastingValue.ToString(); } machineRequirement.AssemblySideLasting = assemblySideLasting; //float assemblyHeelLasting = 0; var assemblyHeelLastingValue = (excelRange.Cells[i, 45] as Excel.Range).Value2; string assemblyHeelLasting = ""; if (assemblyHeelLastingValue != null) { assemblyHeelLasting = assemblyHeelLastingValue.ToString(); } machineRequirement.AssemblyHeelLasting = assemblyHeelLasting; //float assemblySidePress = 0; var assemblySidePressValue = (excelRange.Cells[i, 46] as Excel.Range).Value2; string assemblySidePress = ""; if (assemblySidePressValue != null) { assemblySidePress = assemblySidePressValue.ToString(); } machineRequirement.AssemblySidePress = assemblySidePress; //float assemblyTopDown = 0; var assemblyTopDownValue = (excelRange.Cells[i, 47] as Excel.Range).Value2; string assemblyTopDown = ""; if (assemblyTopDownValue != null) { assemblyTopDown = assemblyTopDownValue.ToString(); } machineRequirement.AssemblyTopDown = assemblyTopDown; //float assemblyHotmeltMachine = 0; var assemblyHotmeltMachineValue = (excelRange.Cells[i, 48] as Excel.Range).Value2; string assemblyHotmeltMachine = ""; if (assemblyHotmeltMachineValue != null) { assemblyHotmeltMachine = assemblyHotmeltMachineValue.ToString(); } machineRequirement.AssemblyHotmeltMachine = assemblyHotmeltMachine; //float assemblySocklinerHotmelt = 0; var assemblySocklinerHotmeltValue = (excelRange.Cells[i, 49] as Excel.Range).Value2; string assemblySocklinerHotmelt = ""; if (assemblySocklinerHotmeltValue != null) { assemblySocklinerHotmelt = assemblySocklinerHotmeltValue.ToString(); } machineRequirement.AssemblySocklinerHotmelt = assemblySocklinerHotmelt; //float assemblyVWrinkleRemover = 0; var assemblyVWrinkleRemoverValue = (excelRange.Cells[i, 50] as Excel.Range).Value2; string assemblyVWrinkleRemover = ""; if (assemblyVWrinkleRemoverValue != null) { assemblyVWrinkleRemover = assemblyVWrinkleRemoverValue.ToString(); } machineRequirement.AssemblyVWrinkleRemover = assemblyVWrinkleRemover; // Add model to List machineRequirementList.Add(machineRequirement); } progressBar.Dispatcher.Invoke((Action)(() => progressBar.Value = i)); #endregion } } catch { machineRequirementList.Clear(); } finally { excelWorkbook.Close(false, Missing.Value, Missing.Value); excelApplication.Quit(); } }
private void bwSearch_DoWork(object sender, DoWorkEventArgs e) { machineRequirementModel = MachineRequirementController.SelectTop1(articleNo); }