コード例 #1
0
 private void metroTile1_Click(object sender, EventArgs e)
 {
     if (txtstatus.Text.Length == 0 || txtdate.Text.Length == 0 || cmbsalesorder.Text == "")
     {
         MessageBox.Show("Please check if your entered data to all the fields", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
     }
     else
     {
         String     status = txtstatus.Text;
         DBDelivery de     = new DBDelivery();
         int        line   = de.update(status, no);
         if (line == 1)
         {
             MessageBox.Show("Data entered successfully", "Error", MessageBoxButtons.OK, MessageBoxIcon.Information);
         }
     }
 }
コード例 #2
0
        private void mtadd_Click(object sender, EventArgs e)
        {
            if (txtstatus.Text.Length != 0 && txtdate.Text.Length != 0 && cmbsalesorder.SelectedIndex != 0)
            {
                String date   = txtdate.Text;
                String status = "Active";
                int    so_no  = Convert.ToInt32(cmbsalesorder.Text);

                DBDelivery d    = new DBDelivery();
                int        line = d.setDelivery(date, status, u_id, so_no);
                if (line == 1)
                {
                    MessageBox.Show("Data entered successfully", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
            }
            else
            {
                MessageBox.Show("Check if all the fields are filled", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
            }
        }
コード例 #3
0
        private void Delivery_Load(object sender, EventArgs e)
        {
            txtdate.Text = System.DateTime.Now.ToString("MM/dd/yyyy");
            DBSales       s = new DBSales();
            SqlDataReader DR;

            DR = s.getSalesOrderID();
            while (DR.Read())
            {
                cmbsalesorder.Items.Add(DR[0]);
            }
            SqlDataAdapter da;
            DBDelivery     i = new DBDelivery();

            da = i.getDelivery();
            DataTable dt = new DataTable();

            da.Fill(dt);
            dataGridView1.DataSource = dt;
        }