private void btnRelease_Click(object sender, RoutedEventArgs e) { if (MessageBox.Show("Confirm Release?", this.Title, MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.No) { return; } outsoleReleaseMaterialToInsertList.Clear(); foreach (StackPanel sp in spMain.Children) { foreach (UIElement ui in sp.Children) { if (ui.GetType() == typeof(DataGrid)) { DataGrid dg = (DataGrid)ui; List <Object> tags = dg.Tag as List <Object>; string productNo = tags[0] as String; List <SizeRunModel> sizeRunList = sizeRunAllList.Where(s => s.ProductNo == productNo).ToList(); DataTable dt = ((DataView)dg.ItemsSource).ToTable(); foreach (DataRow dr in dt.Rows) { int cycle = 0; if (int.TryParse(dr["Cycle"].ToString(), out cycle) == true) { for (int i = 0; i <= sizeRunList.Count - 1; i++) { SizeRunModel sizeRun = sizeRunList[i]; int qtyRelease = 0; int.TryParse(dr[String.Format("Column{0}", i)].ToString(), out qtyRelease); OutsoleReleaseMaterialModel outsoleReleaseMaterial = new OutsoleReleaseMaterialModel { ReportId = reportId, ProductNo = productNo, Cycle = cycle, SizeNo = sizeRun.SizeNo, Quantity = qtyRelease, }; outsoleReleaseMaterialToInsertList.Add(outsoleReleaseMaterial); } } } } } } if (outsoleReleaseMaterialToInsertList.Count > 0 && bwInsert.IsBusy == false) { this.Cursor = Cursors.Wait; btnRelease.IsEnabled = false; bwInsert.RunWorkerAsync(); } }
public static bool Insert(OutsoleReleaseMaterialModel model) { var @ReportId = new SqlParameter("@ReportId", model.ReportId); var @ProductNo = new SqlParameter("@ProductNo", model.ProductNo); var @Cycle = new SqlParameter("@Cycle", model.Cycle); var @SizeNo = new SqlParameter("@SizeNo", model.SizeNo); var @Quantity = new SqlParameter("@Quantity", model.Quantity); SaovietMasterScheduleEntities db = new SaovietMasterScheduleEntities(); if (db.ExecuteStoreCommand("EXEC spm_InsertOutsoleReleaseMaterial @ReportId,@ProductNo,@Cycle,@SizeNo,@Quantity", @ReportId, @ProductNo, @Cycle, @SizeNo, @Quantity) >= 1) { return(true); } return(false); }