anlysis01.aspx.cs

报表主从报表结合在一起,简单的报表例子适合初学者

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;


namespace esurvey_anlysis
{
    public partial class anlysis_rpt : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!this.IsPostBack)
            {

                SetDdlData();

            }
        }

 

        private void SetDdlData()
        {
            //年資
            string strSQL = "select name, seniorityID from senioritys order by seniorityID";
            SqlCommand sqlCmd = new SqlCommand(strSQL);
            DataTable dtA041 = clsHhr_Sql.SqlGoDataTable(sqlCmd);
            DataRow drNew = dtA041.NewRow();
            drNew["seniorityID"] = -1;
            drNew["name"] = "未選擇";
            dtA041.Rows.InsertAt(drNew, 0);

            ddlSenioritys.DataTextField = "name";
            ddlSenioritys.DataValueField = "seniorityID";
            ddlSenioritys.DataSource = dtA041;
            ddlSenioritys.DataBind();



            //公司
            strSQL = "select cht_name, companyid from companys order by companyid";
            sqlCmd = new SqlCommand(strSQL);
            DataTable dtA042 = clsHhr_Sql.SqlGoDataTable(sqlCmd);
            drNew = dtA042.NewRow();
            drNew["companyid"] = -1;
            drNew["cht_name"] = "未選擇";
            dtA042.Rows.InsertAt(drNew, 0);

            ddlComp.DataTextField = "cht_name";
            ddlComp.DataValueField = "companyid";
            ddlComp.DataSource = dtA042;
            ddlComp.DataBind();
            

            //單位
            //string strSQL2 = "select a0411_un, (n + '  ' + isnull(nam, '')) as name from emp_a0411 order by a0411_un";
            //SqlCommand sqlCmd2 = new SqlCommand(strSQL2);
            //DataTable dtA0411 = clsHhr_Sql.SqlGoDataTable(sqlCmd2);
            //DataRow drNew2 = dtA0411.NewRow();
            //drNew2["a0411_un"] = -1;
            //drNew2["name"] = "未選擇";
            //dtA0411.Rows.InsertAt(drNew2, 0);

            //ddlUnit.DataTextField = "name";
            //ddlUnit.DataValueField = "a0411_un";
            //ddlUnit.DataSource = dtA0411;
            //ddlUnit.DataBind();

        }

        protected void ddlComp_SelectedIndexChanged(object sender, EventArgs e)
        {
            
            //部門
            if (ddlComp.SelectedValue != "-1")
            {

                string strSQL = "select name, decode from departments where companyid='" + ddlComp.SelectedValue + "' order by decode";
                SqlCommand sqlCmd = new SqlCommand(strSQL);
                DataTable dtA043 = clsHhr_Sql.SqlGoDataTable(sqlCmd);
                if (dtA043.Rows.Count == 0)
                {
                    DataRow drNew = dtA043.NewRow();
                    drNew["decode"] = -1;
                    drNew["name"] = "無資料";
                    dtA043.Rows.InsertAt(drNew, 0);

                    ddlDept.DataTextField = "name";
                    ddlDept.DataValueField = "decode";
                    ddlDept.DataSource = dtA043;
                    ddlDept.DataBind();
                }
                else
                {
                    DataRow drNew = dtA043.NewRow();
                    drNew["decode"] = -1;
                    drNew["name"] = "未選擇";
                    dtA043.Rows.InsertAt(drNew, 0);

                    ddlDept.DataTextField = "name";
                    ddlDept.DataValueField = "decode";
                    ddlDept.DataSource = dtA043;
                    ddlDept.DataBind();
                    getEmp(sender, e);
                }

            }
            
        }

        protected void getEmp(object sender, EventArgs e)
        {

            //部門
            if ((ddlComp.SelectedValue != "-1") && (ddlSenioritys.SelectedValue != "-1") && (ddlDept.SelectedValue != "-1"))
            {

                string strSQL = "select cht_name, employeeid from employees where companyid='" + ddlComp.SelectedValue +
                                    "' and decode='" + ddlDept.SelectedValue + "' and Seniorityid='" + ddlSenioritys.SelectedValue + "' order by employeeid";
                SqlCommand sqlCmd = new SqlCommand(strSQL);
                DataTable dtA044 = clsHhr_Sql.SqlGoDataTable(sqlCmd);
                if (dtA044.Rows.Count == 0)
                {
                    DataRow drNew = dtA044.NewRow();
                    drNew["employeeid"] = -1;
                    drNew["cht_name"] = "無資料";
                    dtA044.Rows.InsertAt(drNew, 0);

                    ddlemp.DataTextField = "cht_name";
                    ddlemp.DataValueField = "employeeid";
                    ddlemp.DataSource = dtA044;
                    ddlemp.DataBind();
                }
                else
                {
                    DataRow drNew = dtA044.NewRow();
                    drNew["employeeid"] = -1;
                    drNew["cht_name"] = "未選擇";
                    dtA044.Rows.InsertAt(drNew, 0);

                    ddlemp.DataTextField = "cht_name";
                    ddlemp.DataValueField = "employeeid";
                    ddlemp.DataSource = dtA044;
                    ddlemp.DataBind();
                }

            }

        }

        protected void Button1_Click(object sender, System.EventArgs e)
        {
            if (ddlSenioritys.Text == "-1")
            {
                lbwarTitle.Text = "警示訊息";
                lbwarMsg.Text = "您未選擇年資....";
            }
            else if (ddlComp.Text == "-1")
            {
                lbwarTitle.Text = "警示訊息";
                lbwarMsg.Text = "您未選擇公司....";
            }
            else
            {
                if (ddlemp.Items.Count == 0)
                {
                    ddlemp.DataTextField.Insert(0, "未選擇");
                    ddlemp.DataValueField.Insert(0, "-1");
                }
                Server.Transfer("AnlysisRpt01.aspx", true);
            }
        }

    }
}