Пример #1
0
        private void button6_Click(object sender, EventArgs e)
        {
            frmReportCrystal frmCrystal = new frmReportCrystal();
            Form2            frmPrint   = new Form2();

            frmPrint.Show();
            frmCrystal.Show();
        }
Пример #2
0
        private void btnReprint_Click(object sender, EventArgs e)
        {
            frmReportCrystal frmprint = new frmReportCrystal();

            SQLCON.da = new MySqlDataAdapter("Select * from v_invoice where invoiceNo ='" + txtInvoiceNo.Text + "'", SQLCON.cnn);
            //DataTable dt = new DataTable();
            SQLCON.dsa.Clear();
            SQLCON.da.Fill(SQLCON.dsa, "rptInvoice");              //  name of ttx File
            SQLCON.reportName = "cryInvoice";                      // report name
            frmprint.Show();
        }
Пример #3
0
        private void saveInvoice_Print()
        {
            try
            {
                SQLCON.openConn();
                if (txtRecieveDollar.Text != "" && txtRecieveDollar.Text == "")
                {
                    MessageBox.Show("Can't Sale Products when not Recieve money yet !", "Recieve Money Requied");
                    return;
                }

                //when cash reciev is Dollar

                if (txtRecieveDollar.Text != "" && txtRecieveReil.Text == "")
                {
                    SQLCON.cmd = new MySqlCommand("Insert Into tbl_invoice(invoiceNo,saleBy,saleDate,totalDollar,totalRiel,cash_D_R_all,cashRecieveDollar,cashReturnDollar,cashReturnRiel)" +
                                                  " Values (@invoiceNo,'Sopheak',sysdate(),ROUND(@totalDollar,2),ROUND(@totalRiel,2),@cash_D_R_all,@cashRecieveDollar,@cashReturnDollar,@cashReturnRiel)", SQLCON.cnn);
                    SQLCON.cmd.Parameters.AddWithValue("@invoiceNo", txtInvoiceNo.Text);
                    SQLCON.cmd.Parameters.AddWithValue("@totalDollar", txtGrandTotalDollar.Text);
                    SQLCON.cmd.Parameters.AddWithValue("@totalRiel", txtGrandTotalRiel.Text);
                    SQLCON.cmd.Parameters.AddWithValue("@cash_D_R_all", 0);
                    SQLCON.cmd.Parameters.AddWithValue("@cashRecieveDollar", txtRecieveDollar.Text);
                    SQLCON.cmd.Parameters.AddWithValue("@cashReturnDollar", txtCashReturnDollar.Text);
                    SQLCON.cmd.Parameters.AddWithValue("@cashReturnRiel", txtCashReturnRiel.Text);

                    //SQLCON.cmd.Parameters.AddWithValue("@cash", txt.Text);
                }
                else if (txtRecieveReil.Text != "" && txtRecieveDollar.Text == "")
                {
                    // When cash reciev is Riel
                    SQLCON.cmd = new MySqlCommand("Insert Into tbl_invoice (invoiceNo,saleBy,saleDate,totalDollar,totalRiel,cash_D_R_all,cashRecieveRiel,cashReturnRiel)" +
                                                  " Values (@invoiceNo,'Sopheak', sysdate(),@totalRiel,@cashRecieveRiel,@cash_D_R_all)", SQLCON.cnn);
                    SQLCON.cmd.Parameters.AddWithValue("@totalDollar", txtGrandTotalDollar.Text);
                    SQLCON.cmd.Parameters.AddWithValue("@totalRiel", txtGrandTotalRiel.Text);
                    SQLCON.cmd.Parameters.AddWithValue("@cashRecieveRiel", txtRecieveReil.Text);
                    SQLCON.cmd.Parameters.AddWithValue("@cash_D_R_all", 1);
                }


                //SQLCON.cmd = new MySqlCommand("Insert Into tbl_invoice (invoiceNo,saleBy,saleDate,totalDollar,totalRiel,cash_D_R_all,cashRecieveDollar,cashRecieveRiel,cashReturnDollar,isPay)" +
                // " Values (@invoiceNo,'Sopheak', sysdate(),@totalDollar,@cashRecieveDollar,@cash_D_R_all)", SQLCON.cnn);

                //SQLCON.cmd.Parameters.AddWithValue("@invoiceNo", txtInvoiceNo.Text);
                //SQLCON.cmd.ExecuteNonQuery();
                int p = SQLCON.cmd.ExecuteNonQuery();
                if (p > 0)
                {
                    SQLCON.cmd = new MySqlCommand("Select * from v_invoice where invoiceNo=@invoiceNoPrintINvoice", SQLCON.cnn);

                    SQLCON.cmd.Parameters.AddWithValue("@invoiceNoPrintINvoice", txtInvoiceNo.Text);
                    SQLCON.da = new MySqlDataAdapter(SQLCON.cmd);
                    //DataTable dt = new DataTable();
                    SQLCON.dsa.Clear();
                    SQLCON.da.Fill(SQLCON.dsa, "rptInvoice");              // rpt is the name of ttx File

                    SQLCON.reportName = "cryInvoice";                      // report name
                    frmReportCrystal frmprint = new frmReportCrystal();

                    frmprint.ShowDialog();
                    btnNewSale.PerformClick();

                    foreach (Control t in pProductCash.Controls)
                    {
                        if (t is TextBox)
                        {
                            t.Text = "";
                        }
                    }
                }

                // SQLCON.cnn.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
                return;
            }
        }