예제 #1
0
        private void frmCustomersRecord1_FormClosing(object sender, FormClosingEventArgs e)
        {
            Hide();
            var frm = new frmInvoice();

            frm.label6.Text = label1.Text;
            frm.Show();
        }
예제 #2
0
        private void salesToolStripMenuItem_Click(object sender, EventArgs e)
        {
            Hide();
            var frm = new frmInvoice();

            frm.label6.Text = lblUser.Text;
            frm.Show();
        }
예제 #3
0
        private void DataGridView2_RowHeaderMouseClick(object sender, DataGridViewCellMouseEventArgs e)
        {
            try
            {
                var dr = DataGridView2.SelectedRows[0];
                Hide();
                var frmSales = new frmInvoice();


                frmSales.Show();
                frmSales.txtInvoiceNo.Text    = dr.Cells[0].Value.ToString();
                frmSales.dtpInvoiceDate.Text  = dr.Cells[1].Value.ToString();
                frmSales.txtCustomerID.Text   = dr.Cells[2].Value.ToString();
                frmSales.txtCustomerName.Text = dr.Cells[3].Value.ToString();
                frmSales.txtSubTotal.Text     = dr.Cells[4].Value.ToString();
                frmSales.txtTaxPer.Text       = dr.Cells[5].Value.ToString();
                frmSales.txtTaxAmt.Text       = dr.Cells[6].Value.ToString();
                frmSales.txtTotal.Text        = dr.Cells[7].Value.ToString();
                frmSales.txtTotalPayment.Text = dr.Cells[8].Value.ToString();
                frmSales.txtPaymentDue.Text   = dr.Cells[9].Value.ToString();
                frmSales.txtRemarks.Text      = dr.Cells[10].Value.ToString();
                frmSales.btnUpdate.Enabled    = true;
                frmSales.Delete.Enabled       = true;
                frmSales.btnPrint.Enabled     = true;
                frmSales.Save.Enabled         = false;
                frmSales.label6.Text          = label9.Text;
                con = new OleDbConnection(cs);
                con.Open();
                cmd = new OleDbCommand("SELECT Config.ConfigID,Config.Productname,ProductSold.Price,ProductSold.Quantity,ProductSold.TotalAmount from Sales,ProductSold,Config where Sales.InvoiceNo=ProductSold.InvoiceNo and Config.ConfigID=ProductSold.ConfigID and Sales.InvoiceNo='" + dr.Cells[0].Value.ToString() + "'", con);
                rdr = cmd.ExecuteReader();
                while (rdr.Read())
                {
                    var lst = new ListViewItem();
                    lst.SubItems.Add(rdr[0].ToString().Trim());
                    lst.SubItems.Add(rdr[1].ToString().Trim());
                    lst.SubItems.Add(rdr[2].ToString().Trim());
                    lst.SubItems.Add(rdr[3].ToString().Trim());
                    lst.SubItems.Add(rdr[4].ToString().Trim());
                    frmSales.ListView1.Items.Add(lst);
                }
                frmSales.ListView1.Enabled = false;
                frmSales.Button7.Enabled   = false;
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "ล้มเหลว", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
예제 #4
0
        private void dataGridView1_RowHeaderMouseClick(object sender, DataGridViewCellMouseEventArgs e)
        {
            try
            {
                var dr = dataGridView1.SelectedRows[0];
                Hide();
                var frm = new frmInvoice();
                frm.Show();
                frm.txtCustomerID.Text = dr.Cells[0].Value.ToString();
                frm.txtCustomerName.Text = dr.Cells[1].Value.ToString();
                frm.label6.Text = label1.Text;
            }

            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "ล้มเหลว", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
예제 #5
0
        private void dataGridView1_RowHeaderMouseClick(object sender, DataGridViewCellMouseEventArgs e)
        {
            try
            {
                var dr = dataGridView1.SelectedRows[0];
                Hide();
                var frm = new frmInvoice();
                frm.Show();
                frm.txtCustomerID.Text   = dr.Cells[0].Value.ToString();
                frm.txtCustomerName.Text = dr.Cells[1].Value.ToString();
                frm.label6.Text          = label1.Text;
            }

            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "ล้มเหลว", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
예제 #6
0
 private void salesToolStripMenuItem_Click(object sender, EventArgs e)
 {
     Hide();
     var frm = new frmInvoice();
     frm.label6.Text = lblUser.Text;
     frm.Show();
 }
예제 #7
0
 private void frmCustomersRecord1_FormClosing(object sender, FormClosingEventArgs e)
 {
     Hide();
     var frm = new frmInvoice();
     frm.label6.Text = label1.Text;
     frm.Show();
 }
예제 #8
0
        private void DataGridView2_RowHeaderMouseClick(object sender, DataGridViewCellMouseEventArgs e)
        {
            try
            {
                var dr = DataGridView2.SelectedRows[0];
                Hide();
                var frmSales = new frmInvoice();


                frmSales.Show();
                frmSales.txtInvoiceNo.Text = dr.Cells[0].Value.ToString();
                frmSales.dtpInvoiceDate.Text = dr.Cells[1].Value.ToString();
                frmSales.txtCustomerID.Text = dr.Cells[2].Value.ToString();
                frmSales.txtCustomerName.Text = dr.Cells[3].Value.ToString();
                frmSales.txtSubTotal.Text = dr.Cells[4].Value.ToString();
                frmSales.txtTaxPer.Text = dr.Cells[5].Value.ToString();
                frmSales.txtTaxAmt.Text = dr.Cells[6].Value.ToString();
                frmSales.txtTotal.Text = dr.Cells[7].Value.ToString();
                frmSales.txtTotalPayment.Text = dr.Cells[8].Value.ToString();
                frmSales.txtPaymentDue.Text = dr.Cells[9].Value.ToString();
                frmSales.txtRemarks.Text = dr.Cells[10].Value.ToString();
                frmSales.btnUpdate.Enabled = true;
                frmSales.Delete.Enabled = true;
                frmSales.btnPrint.Enabled = true;
                frmSales.Save.Enabled = false;
                frmSales.label6.Text = label9.Text;
                con = new SqlConnection(cs);
                con.Open();
                cmd = new SqlCommand("SELECT Config.ConfigID,Config.Productname,ProductSold.Price,ProductSold.Quantity,ProductSold.TotalAmount from Sales,ProductSold,Config where Sales.InvoiceNo=ProductSold.InvoiceNo and Config.ConfigID=ProductSold.ConfigID and Sales.InvoiceNo='" + dr.Cells[0].Value.ToString() + "'", con);
                rdr = cmd.ExecuteReader();
                while (rdr.Read())
                {
                    var lst = new ListViewItem();
                    lst.SubItems.Add(rdr[0].ToString().Trim());
                    lst.SubItems.Add(rdr[1].ToString().Trim());
                    lst.SubItems.Add(rdr[2].ToString().Trim());
                    lst.SubItems.Add(rdr[3].ToString().Trim());
                    lst.SubItems.Add(rdr[4].ToString().Trim());
                    frmSales.ListView1.Items.Add(lst);
                }
                frmSales.ListView1.Enabled = false;
                frmSales.Button7.Enabled = false;
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "ล้มเหลว", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }