예제 #1
0
        public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
        {
            uras rpt = new uras();

            rpt.Site = this.Site;
            return(rpt);
        }
예제 #2
0
        private void report_Load(object sender, EventArgs e)
        {
            exsql   eq   = new exsql();
            string  rstr = "SELECT [user].username, role.role, authority.authority, subauthority.subauthority FROM [user] INNER JOIN userper ON [user].userid = userper.userid INNER JOIN role ON userper.roleid = role.roleid INNER JOIN authority ON userper.authorityid = authority.authorityid INNER JOIN subauthority ON userper.subauthorityid = subauthority.subauthorityid INNER JOIN userrole ON [user].userid = userrole.userid AND role.roleid = userrole.roleid INNER JOIN roleauthority ON role.roleid = roleauthority.roleid AND authority.authorityid = roleauthority.authorityid INNER JOIN authsub ON authority.authorityid = authsub.authorityid AND subauthority.subauthorityid = authsub.subauthorityid";
            DataSet ds   = eq.excuterdataset(rstr);

            uras rpt = new uras();

            rpt.SetDataSource(ds.Tables[0]);

            crystalReportViewer1.ReportSource = rpt;
        }