public void IEReport(cIncomeExpensesReport report)
 {
     IEReportYear          = report.year;
     IEReportMonth         = report.month;
     IEReportIncomeTotal   = report.incomeTotal;
     IEReportExpensesTotal = report.expensesTotal;
 }
Пример #2
0
        public void GetParticularIncomePaymentRecode(cIncomeExpensesReport Report)
        {
            Dt.Clear();
            SqlCommand cmd = new SqlCommand("SELECT * FROM incomePayment WHERE YEAR (incomeDate) = @Year and MONTH (incomeDate) = @Month", con);

            // cmd.CommandType = CommandType.Text;

            cmd.Parameters.AddWithValue("@Year", Report.year);
            cmd.Parameters.AddWithValue("@Month", Report.month);

            con.Open();
            SqlDataReader sdr = cmd.ExecuteReader();

            Dt.Load(sdr);
            con.Close();

            //    Ex.ExpensesDataGrid.DataSource = Dt;
        }