コード例 #1
0
        private void Btn_Save_Click(object sender, EventArgs e)
        {
            if (AddNew == false)
            {
                MessageBox.Show("يجب الضغط على زر جديد اولا", "خطأ", MessageBoxButtons.OK, MessageBoxIcon.Error); return;
            }
            if ((MessageBox.Show("هل انت متأكد من حفظ عمليةالشراء ؟", "تأكيد", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes))
            {
                DataTable ddt = PrepareData();
                ccon.Comm.Connection  = DBConnect.Conn;
                ccon.Comm.CommandType = CommandType.StoredProcedure;
                ccon.Comm.CommandText = "Sp_SalesInsert";
                ccon.Comm.Parameters.Clear();

                ccon.Comm.Parameters.AddWithValue("@Cust_ID", int.Parse(Cmb_CustName.SelectedValue.ToString()));
                ccon.Comm.Parameters.AddWithValue("@Sales_Date", DateTime.Parse(DTP_Purchase.Text));
                ccon.Comm.Parameters.AddWithValue("@Total_Value", double.Parse(Txt_Total.Text));
                ccon.Comm.Parameters.AddWithValue("@Payed_Value", double.Parse(Txt_Payed.Text));
                ccon.Comm.Parameters.AddWithValue("@Remain_Value", double.Parse(Txt_Remain.Text));
                ccon.Comm.Parameters.AddWithValue("@Sales_Notes", Txt_Notes.Text);
                ccon.Comm.Parameters.AddWithValue("@User_ID", Login.UserID);
                ccon.Comm.Parameters.AddWithValue("@Store_ID", int.Parse(Cmb_StoreName.SelectedValue.ToString()));
                ccon.Comm.Parameters.AddWithValue("@SalesDataTable", PrepareData());
                ccon.Comm.ExecuteNonQuery();
                MessageBox.Show("تم الحفظ بنجاح", "تم", MessageBoxButtons.OK, MessageBoxIcon.Information);

                AddNew = false;



                if ((MessageBox.Show("هل تريد طباعة عمليةالشراء ؟", "تأكيد", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes))
                {
                    DBConnect Connn = new DBConnect();
                    Connn.Comm.Connection  = DBConnect.Conn;
                    Connn.Comm.CommandType = CommandType.StoredProcedure;
                    Connn.Comm.CommandText = "Sp_MainSalesSelectMax";

                    SqlDataAdapter Da = new SqlDataAdapter(Connn.Comm);
                    DataSet        Ds = new DataSet();
                    Da.Fill(Ds, "BillSales");

                    BillReport_Sales Rpt = new BillReport_Sales();
                    Rpt.SetDataSource(Ds.Tables["BillSales"]);

                    Frm_Report Frm = new Frm_Report();
                    Frm.crystalReportViewer1.ReportSource = Rpt;

                    Frm.ShowDialog();
                }
            }
        }
コード例 #2
0
        private void Btn_Report_Click(object sender, EventArgs e)
        {
            DBConnect Connn = new DBConnect();

            Connn.Comm.Connection  = DBConnect.Conn;
            Connn.Comm.CommandType = CommandType.StoredProcedure;
            Connn.Comm.CommandText = "Sp_MainSalesSelectMax";

            SqlDataAdapter Da = new SqlDataAdapter(Connn.Comm);
            DataSet        Ds = new DataSet();

            Da.Fill(Ds, "BillSales");

            BillReport_Sales Rpt = new BillReport_Sales();

            Rpt.SetDataSource(Ds.Tables["BillSales"]);

            Frm_Report Frm = new Frm_Report();

            Frm.crystalReportViewer1.ReportSource = Rpt;

            Frm.ShowDialog();
        }