private void bwImport_DoWork(object sender, DoWorkEventArgs e) { var importList = e.Argument as List <RawMaterialModel>; progressBar.Dispatcher.Invoke((Action)(() => progressBar.Maximum = importList.Count())); int indexPrg = 1; foreach (var import in importList) { var productNoRevise = new ProductNoReviseModel { ProductNo = import.ProductNo, SectionId = "WH", ReviseDate = DateTime.Now, }; // db excute RawMaterialController.InsertFromExcel(import); ProductNoReviseController.Insert(productNoRevise); Dispatcher.Invoke(new Action(() => { dgUpperMaterialSchedule.SelectedItem = import; dgUpperMaterialSchedule.ScrollIntoView(import); })); progressBar.Dispatcher.Invoke((Action)(() => progressBar.Value = indexPrg)); indexPrg++; } }
public static bool Insert(ProductNoReviseModel model) { var @ProductNo = new SqlParameter("@ProductNo", model.ProductNo); var @ReviseDate = new SqlParameter("@ReviseDate", model.ReviseDate); var @SectionId = new SqlParameter("@SectionId", model.SectionId); SaovietMasterScheduleEntities db = new SaovietMasterScheduleEntities(); if (db.ExecuteStoreCommand("EXEC spm_InsertProductNoRevise @ProductNo, @ReviseDate, @SectionId", @ProductNo, @ReviseDate, @SectionId) > 0) { return(true); } return(false); }