employeereport.cs

教材管理系统全使用于简单的课程设计方便各位朋友

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;

using CrystalDecisions.CrystalReports.Engine;  //添加引用
using CrystalDecisions.Shared;
using GoodsReportManage.ItemClass;


namespace GoodsReportManage.CrystalReport
{
    public partial class EmployeeReport : Form
    {
        public EmployeeReport()
        {
            InitializeComponent();
        }

        SqlBaseClass G_SqlClass = new SqlBaseClass();  //声明数据库操作类对象
        WinOperationClass G_OperationForm = new WinOperationClass();

        private void EmployeeReport_Load(object sender, EventArgs e)
        {
            G_OperationForm.BindComboBox("SELECT * FROM tb_Post", cbxPost, "PostName");  //绑定ComboBox控件
            G_OperationForm.BindComboBox("SELECT * FROM tb_Department", cbxDepName, "DepName");

            this.cbxSex.SelectedIndex = 0;  //设定默认项
        }

        private void btnFindOk_Click(object sender, EventArgs e)
        {
            //为报表设定查询语句
            string P_selectionFormula = "{tb_User.Name} like "
                + "'*" + this.txtName.Text + "*' and {tb_User.Sex}='" + this.cbxSex.Items[this.cbxSex.SelectedIndex].ToString() + "'";
            P_selectionFormula += " and {tb_User.Post}='" + this.cbxPost.SelectedValue.ToString();
            P_selectionFormula += "' and {tb_User.Department}='" + this.cbxDepName.SelectedValue.ToString() + "'";

            this.crystalReportViewer1.ReportSource = G_OperationForm.CrystalReports("CrystalEmployeeReport.rpt",P_selectionFormula); ;  //显示满足条件的报表信息
        }

    }
}