private void btnAddPORepacking_Click(object sender, RoutedEventArgs e) { poRepackingReLoadList = dgPORepacking.Items.OfType <PORepackingModel>().ToList(); string productNo = ""; productNo = txtPORepacking.Text.ToUpper().Trim(); if (productNo == "") { txtPORepacking.Focus(); return; } var productNoExist = poRepackingReLoadList.Where(w => w.ProductNo == productNo).ToList(); if (productNoExist.Count > 0) { MessageBox.Show(string.Format("PO: {0} exist !", productNo), this.Title, MessageBoxButton.OK, MessageBoxImage.Information); return; } PORepackingModel newPO = new PORepackingModel(); newPO.ProductNo = productNo; newPO.CreatedTime = DateTime.Now; poRepackingReLoadList.Add(newPO); ReLoad(); }
private void btnClear_Click(object sender, RoutedEventArgs e) { poRepackingReLoadList = dgPORepacking.Items.OfType <PORepackingModel>().ToList(); currentPO = dgPORepacking.CurrentItem as PORepackingModel; stkControlAccount.Visibility = Visibility.Visible; txtPassword.Clear(); txtPassword.Focus(); modeClearOrSave = 1; }
public static bool Insert(PORepackingModel model) { var @ProductNo = new SqlParameter("@ProductNo", model.ProductNo); var @CreatedTime = new SqlParameter("@CreatedTime", model.CreatedTime); if (db.ExecuteStoreCommand("EXEC spm_InsertPORepacking @ProductNo, @CreatedTime", @ProductNo, @CreatedTime) >= 1) { return(true); } else { return(false); } }