예제 #1
0
        private void initThongKe()
        {
            int       _nhomCcID   = 0;
            string    _nhomCcName = string.Empty;
            DataTable tblChungChi = new DataTable();

            lop               = new BO_LOP();
            boCapChungChi     = new BO_CAP_CHUNGCHI();
            _vDsThongKeCapGCN = new BcChungChi();
            int _ChcID = -1;

            if (lookupNhomCc.ItemIndex > -1 && lookupNhomCc.Enabled == true)
            {
                _nhomCcID   = int.Parse(lookupNhomCc.GetColumnValue("LOA_ID").ToString());
                _nhomCcName = lookupNhomCc.Text;
                if (lookChungChiTK.ItemIndex > -1 && lookChungChiTK.Enabled == true)
                {
                    _ChcID      = int.Parse(lookChungChiTK.GetColumnValue("CHC_ID").ToString());
                    tblChungChi = lop.getChungChiThongKeWithCcID(dateFrom.DateTime, dateEnd.DateTime, _nhomCcID, _ChcID);
                    initDataSetThongKeCapGCN(tblChungChi, _nhomCcName);
                }
                else
                {
                    tblChungChi = lop.getChungChiThongKe(dateFrom.DateTime, dateEnd.DateTime, _nhomCcID);
                    initDataSetThongKeCapGCN(tblChungChi, _nhomCcName);
                }
            }
            else
            {
                for (int iNhomCc = 0; iNhomCc < tblNhomChungChi.Rows.Count; iNhomCc++)
                {
                    _nhomCcID   = int.Parse(tblNhomChungChi.Rows[iNhomCc]["LOA_ID"].ToString());
                    _nhomCcName = tblNhomChungChi.Rows[iNhomCc]["LOA_Name"].ToString();
                    tblChungChi = lop.getChungChiThongKe(dateFrom.DateTime, dateEnd.DateTime, _nhomCcID);
                    initDataSetThongKeCapGCN(tblChungChi, _nhomCcName);
                }
            }
            rpThongKeCapGCN rpt = new rpThongKeCapGCN();

            rpt.SetDataSource(_vDsThongKeCapGCN.Tables["ThongKeCapChungChi"]);
            rpt.SetParameterValue("_fromDate", dateFrom.Text);
            rpt.SetParameterValue("_toDate", dateEnd.Text);
            rpt.SetParameterValue("_SumCapDoi", _SumCapDoi.ToString("#,##0"));
            rpt.SetParameterValue("_SumCapMoi", _SumCapMoi.ToString("#,##0"));
            rpt.SetParameterValue("_SumCapLai", _SumCapLai.ToString("#,##0"));
            rpt.SetParameterValue("_SumTotal", _SumTotal.ToString("#,##0"));
            crytalThongKe.ReportSource  = rpt;
            crytalThongKe.ToolPanelView = ToolPanelViewType.None;
            _SumCapDoi = 0;
            _SumCapMoi = 0;
            _SumCapLai = 0;
            _SumTotal  = 0;
        }