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();
}
}
