示例#1
0
        public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
        {
            CrystalReport2 rpt = new CrystalReport2();

            rpt.Site = this.Site;
            return(rpt);
        }
        private void flatButton2_Click(object sender, EventArgs e)
        {
            if (metroTextBox4.Text == "0")
            {
                MessageBox.Show("لايمكن الحفظ لأن مبلغ الفاتورة= 0 /n هناك تغييرات لم تقم بحفظها يرجى التحديث ثم معاودة الحفظ ", "خطأ", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
            else
            {
                if (metroTextBox3.Text == string.Empty)
                {
                    MessageBox.Show("يرجى أدخال تاريخ التعديل وشكرا", "خطأ", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
                else
                {
                    string           sql1  = "data source = Data.db";
                    SQLiteConnection conn1 = new SQLiteConnection(sql1);
                    conn1.Open();
                    string        query_save1 = "update Bills2 set Bills_date=@Bills_date,Bills_date_update=@Bills_date_update,Bills_sum=@Bills_sum where Bills_id = '" + Convert.ToInt64(metroTextBox1.Text) + "'";
                    SQLiteCommand cmd1        = new SQLiteCommand(query_save1, conn1);
                    cmd1.Parameters.AddWithValue("@Bills_date", metroTextBox5.Text);
                    cmd1.Parameters.AddWithValue("@Bills_date_update", metroTextBox3.Text);
                    cmd1.Parameters.AddWithValue("@Bills_sum", Convert.ToInt64(metroTextBox4.Text));
                    cmd1.ExecuteNonQuery();

                    string        query_save3 = "update Bills set Bills_date_update=@Bills_date_update,Bills_sum=@Bills_sum where Bills_id = '" + Convert.ToInt64(metroTextBox1.Text) + "'";
                    SQLiteCommand cmd3        = new SQLiteCommand(query_save3, conn1);
                    cmd3.Parameters.AddWithValue("@Bills_sum", Convert.ToInt64(metroTextBox4.Text));
                    cmd3.Parameters.AddWithValue("@Bills_date_update", metroTextBox3.Text);
                    cmd3.Parameters.AddWithValue("@Bills_date", metroTextBox5.Text);
                    cmd3.ExecuteNonQuery();
                    conn1.Close();


                    string           sql  = "data source = Data.db";
                    SQLiteConnection con4 = new SQLiteConnection(sql);
                    DS1            ds     = new DS1();
                    CrystalReport2 cr2    = new CrystalReport2();
                    Print          p      = new Print();
                    con4.Open();
                    SQLiteDataAdapter da1 = new SQLiteDataAdapter("select Bills_id,Bills_members_name,Bills_pharm_name,Bills_pharm_ghram,Bills_pharm_quan,Bills_pharm_price,Bills_count,Bills_unit from Bills where Bills_id=@Bills_id", con4);
                    da1.SelectCommand.Parameters.AddWithValue("@Bills_id", Convert.ToInt64(dataGridView1.CurrentRow.Cells[0].Value.ToString()));
                    da1.Fill(ds, "Bills");
                    cr2.SetDataSource(ds.Tables["Bills"]);
                    p.crystalReportViewer1.ReportSource = cr2;
                    p.Show();
                    this.Close();
                }
            }
        }
示例#3
0
 private void flatButton7_Click(object sender, EventArgs e)
 {
     if (dataGridView1.CurrentRow == null)
     {
         MessageBox.Show("لم يتم تحديد أي فاتورة", "خطأ", MessageBoxButtons.OK, MessageBoxIcon.Error);
     }
     else
     {
         string           sql = "data source = Data.db";
         SQLiteConnection con = new SQLiteConnection(sql);
         DS             ds    = new DS();
         CrystalReport2 cr2   = new CrystalReport2();
         Print          p     = new Print();
         con.Open();
         SQLiteDataAdapter da = new SQLiteDataAdapter("select Bills_id,Bills_members_name,Bills_pharm_name,Bills_pharm_ghram,Bills_pharm_quan,Bills_pharm_price,Bills_count,Bills_unit from Bills where Bills_id=@Bills_id", con);
         da.SelectCommand.Parameters.AddWithValue("@Bills_id", Convert.ToInt64(dataGridView1.CurrentRow.Cells[0].Value.ToString()));
         da.Fill(ds, "Bills");
         cr2.SetDataSource(ds.Tables["Bills"]);
         p.crystalReportViewer1.ReportSource = cr2;
         p.Show();
         this.Close();
     }
 }