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);
}
