private bool isEmpty() { if (dressnametextBox.Text.Trim() == string.Empty) { MessageBox.Show("Dress Name is Required", "Error ", MessageBoxButtons.OK, MessageBoxIcon.Error); dressnametextBox.Focus(); return(false); } if (dressizetextBox.Text.Trim() == string.Empty) { MessageBox.Show("Dress Size is Required", "Error ", MessageBoxButtons.OK, MessageBoxIcon.Error); dressizetextBox.Focus(); return(false); } if (pricePerItemtextBox.Text.Trim() == string.Empty) { MessageBox.Show("Price Per Item is Required", "Error ", MessageBoxButtons.OK, MessageBoxIcon.Error); pricePerItemtextBox.Focus(); return(false); } if (QuantitytextBox.Text.Trim() == string.Empty) { MessageBox.Show("Quantity is Required", "Error ", MessageBoxButtons.OK, MessageBoxIcon.Error); QuantitytextBox.Focus(); return(false); } if (descriptionrichTextBox.Text.Trim() == string.Empty) { MessageBox.Show("Description is Required", "Error ", MessageBoxButtons.OK, MessageBoxIcon.Error); descriptionrichTextBox.Focus(); return(false); } return(true); }
public MainWindow() { InitializeComponent(); //设置全屏 this.Left = 0.0; this.Top = 0.0; this.Width = System.Windows.SystemParameters.PrimaryScreenWidth; this.Height = System.Windows.SystemParameters.PrimaryScreenHeight; QuantitytextBox.AddHandler(TextBox.MouseLeftButtonDownEvent, new MouseButtonEventHandler(this.MouseEnter), true); CostTextBox.AddHandler(TextBox.MouseLeftButtonDownEvent, new MouseButtonEventHandler(this.MouseEnter), true); dt.Columns.Add(commodity); dt.Columns.Add(Quantity); dt.Columns.Add(Cost); DynamicOderButton(); }
private void ReturnQuantity_Click(object sender, EventArgs e) { string conStr = ConfigurationManager.ConnectionStrings["coonstring"].ToString(); SqlConnection con = new SqlConnection(conStr); con.Open(); SqlCommand cmd = new SqlCommand("PurchaseReturnonBatch", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@SupplierName", SupplierName_txtbox.Text); cmd.Parameters.AddWithValue("@ItemName", ItemName_txtbox.Text); cmd.Parameters.AddWithValue("@CompanyName", CompanyName_txtbox.Text); cmd.Parameters.AddWithValue("@Batch", Batch_txtbox.Text); cmd.Parameters.AddWithValue("@Reason", Reason_Txtbox.Text); cmd.Parameters.AddWithValue("@Rate", Rate_textBox.Text); cmd.Parameters.AddWithValue("@Quantity", QuantitytextBox.Text); int i = cmd.ExecuteNonQuery(); if (i != 0) { // MessageBox.Show("DataEntered"); DisplayData(); } // else //{ ////MessageBox.Show("Data Not Saved"); // } con.Close(); SupplierName_txtbox.Clear(); ItemName_txtbox.Clear(); CompanyName_txtbox.Clear(); Batch_txtbox.Clear(); Rate_textBox.Clear(); Reason_Txtbox.Clear(); QuantitytextBox.Clear(); SqlDataReader myReader = null; SqlConnection myConnection = new SqlConnection(conStr); SqlCommand myCommand = new SqlCommand("sumtotal_PurchaseReturn", myConnection); myConnection.Open(); myReader = myCommand.ExecuteReader(); if (myReader.Read()) { total_txtbox.Text = myReader.GetValue(0).ToString(); } }