private void btnRemove_Click(object sender, RoutedEventArgs e) { IsRemove = true; string rackNumber = ""; int cartonNumber = 0; rackNumber = txtRackNumber.Text.ToUpper().ToString(); Int32.TryParse(txtCartonNumber.Text.ToString(), out cartonNumber); if (String.IsNullOrEmpty(rackNumber)) { txtRackNumber.SelectAll(); txtRackNumber.Focus(); return; } if (cartonNumber == 0) { txtCartonNumber.SelectAll(); txtCartonNumber.Focus(); return; } rackModel = new OutsoleMaterialRackPositionModel() { ProductNo = productNo, OutsoleSupplierId = supplier.OutsoleSupplierId, RackNumber = rackNumber, CartonNumber = cartonNumber }; this.Close(); }
public static bool Delete(OutsoleMaterialRackPositionModel model) { var @ProductNo = new SqlParameter("@ProductNo", model.ProductNo); var @OutsoleSupplierId = new SqlParameter("@OutsoleSupplierId", model.OutsoleSupplierId); var @RackNumber = new SqlParameter("@RackNumber", model.RackNumber); var @CartonNumber = new SqlParameter("@CartonNumber", model.CartonNumber); if (db.ExecuteStoreCommand("EXEC spm_DeleteOutsoleMaterialRackPosition @ProductNo, @OutsoleSupplierId, @RackNumber, @CartonNumber", @ProductNo, @OutsoleSupplierId, @RackNumber, @CartonNumber) >= 1) { return(true); } return(false); }
public static bool Insert(OutsoleMaterialRackPositionModel model) { var @ProductNo = new SqlParameter("@ProductNo", model.ProductNo); var @OutsoleSupplierId = new SqlParameter("@OutsoleSupplierId", model.OutsoleSupplierId); var @RackNumber = new SqlParameter("@RackNumber", model.RackNumber); var @CartonNumber = new SqlParameter("@CartonNumber", model.CartonNumber); var @SizeNo = new SqlParameter("@SizeNo", model.SizeNo); var @Pairs = new SqlParameter("@Pairs", model.Pairs); if (db.ExecuteStoreCommand("EXEC spm_InsertOutsoleMaterialRackPosition_3 @ProductNo, @OutsoleSupplierId, @RackNumber, @CartonNumber,@SizeNo,@Pairs", @ProductNo, @OutsoleSupplierId, @RackNumber, @CartonNumber, @SizeNo, @Pairs) >= 1) { return(true); } return(false); //var pairs = model.Pairs > 0 ? model.Pairs : 0; }
private void GetDataFromDatagrid(string rackNumber, int cartonNumber) { rackPositionCurrentList.Clear(); // Get quantity and sizeno from datagrid. try { DataTable dt = ((DataView)dgSizeNoAndQuantity.ItemsSource).ToTable(); foreach (DataRow dr in dt.Rows) { for (int i = 0; i < sizeNoList.Count(); i++) { string sizeNo = sizeNoList[i].ToString(); int quantity = 0; Int32.TryParse(dr[String.Format("Column{0}", i)].ToString(), out quantity); int rackPositionId = 0; if (actionType == ActionType.UPDATE) { rackPositionId = rackUpdateList.FirstOrDefault(w => w.SizeNo == sizeNo).RackPositionID; } var rackModel = new OutsoleMaterialRackPositionModel() { RackPositionID = rackPositionId, ProductNo = productNo, OutsoleSupplierId = supplier.OutsoleSupplierId, RackNumber = rackNumber, CartonNumber = cartonNumber, SizeNo = sizeNo, Pairs = quantity, //Quantity = quantity.ToString(), }; rackPositionCurrentList.Add(rackModel); } } } catch (Exception e) { MessageBox.Show(e.ToString(), "Master Schedule", MessageBoxButton.OK, MessageBoxImage.Error); } }