private void btnSave_Click(object sender, RoutedEventArgs e) { if (MessageBox.Show("Confirm Save?", this.Title, MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.No) { return; } dt = ((DataView)dgInsockMaterial.ItemsSource).ToTable(); for (int r = 0; r <= dt.Rows.Count - 1; r = r + 2) { DataRow dr = dt.Rows[r]; DataRow dr1 = dt.Rows[r + 1]; InsockSuppliersModel insockSupplier = (InsockSuppliersModel)dr["Supplier"]; if (insockSupplier != null) { int insockSupplierId = insockSupplier.InsockSupplierId; string actualDate = dr["ActualDate"] as String; DateTime dtActualDate = TimeHelper.Convert(actualDate); if (String.IsNullOrEmpty(actualDate) == false && dtActualDate != dtNothing) { InsockRawMaterialModel insockRawMaterial = new InsockRawMaterialModel { ProductNo = productNo, InsockSupplierId = insockSupplierId, ActualDate = dtActualDate, }; insockRawMaterialToInsertList.Add(insockRawMaterial); } for (int i = 0; i <= sizeRunList.Count - 1; i++) { string sizeNo = sizeRunList[i].SizeNo; int quantity = (Int32)dr[String.Format("Column{0}", i)]; int quantityReject = (Int32)dr1[String.Format("Column{0}", i)]; if (quantity >= 0 && quantityReject >= 0) { InsockMaterialModel model = new InsockMaterialModel { ProductNo = productNo, InsockSupplierId = insockSupplierId, SizeNo = sizeNo, Quantity = quantity, QuantityReject = quantityReject, }; insockMaterialToInsertList.Add(model); } } } } if (threadInsert.IsBusy == false) { this.Cursor = Cursors.Wait; btnSave.IsEnabled = false; threadInsert.RunWorkerAsync(); } }
public static bool UpdateActualDate(InsockRawMaterialModel model) { var @ProductNo = new SqlParameter("@ProductNo", model.ProductNo); var @InsockSupplierId = new SqlParameter("@InsockSupplierId", model.InsockSupplierId); var @ActualDate = new SqlParameter("@ActualDate", model.ActualDate); if (db.ExecuteStoreCommand("EXEC spm_UpdateInsockRawMaterialActualDate @ProductNo, @InsockSupplierId, @ActualDate", @ProductNo, @InsockSupplierId, @ActualDate) > 0) { return(true); } return(false); }
public static bool Insert(InsockRawMaterialModel model) { var @ProductNo = new SqlParameter("@ProductNo", model.ProductNo); var @InsockSupplierId = new SqlParameter("@InsockSupplierId", model.InsockSupplierId); var @ETD = new SqlParameter("@ETD", model.ETD); if (db.ExecuteStoreCommand("EXEC spm_InsertInsockRawMaterial @ProductNo, @InsockSupplierId, @ETD", @ProductNo, @InsockSupplierId, @ETD) > 0) { return(true); } return(false); }
private void bwInsert_DoWork(object sender, DoWorkEventArgs e) { rawMaterial.ETD = dtDefault; rawMaterial.IsETDUpdate = true; foreach (var insockRawMaterial in insockRawMaterialViewToDeleteList) { int insockSupplierId = insockRawMaterial.InsockSupplier.InsockSupplierId; InsockRawMaterialController.Delete(productNo, insockSupplierId); } if (insockRawMaterialViewToInsertList.Count > 0) { rawMaterial.ETD = insockRawMaterialViewToInsertList.Max(m => m.ETDReal); } foreach (var insockRawMaterial in insockRawMaterialViewToInsertList) { int insockSupplierId = insockRawMaterial.InsockSupplier.InsockSupplierId; DateTime etd = TimeHelper.Convert(insockRawMaterial.ETD); if (etd != dtDefault && etd != dtNothing) { var insertModel = new InsockRawMaterialModel() { ProductNo = productNo, InsockSupplierId = insockSupplierId, ETD = etd }; InsockRawMaterialController.Insert(insertModel); if (insertModel.ETD > rawMaterial.ETD) { rawMaterial.ETD = insertModel.ETD; } } } }