checkperform.aspx.cs

人事管理系统

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class web_Performance_CheckPerform : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        grdResult.Visible = false;
        pnlHeader.Visible = false;

       
        int iEmpID;

        //检查员工的登录信息是否丢失，是则显示出错信息。
        if (Session["EmployeeID"] == null)
        {
            lblMessage.Text = "登录信息丢失，请重新登录！";
            return;
        }

        //获取保存在 Session 中的员工编号信息。
        iEmpID = int.Parse((string)(Session["EmployeeID"]));

        string StrSelect = "select * from 员工表 where 员工编号='" + Session["EmployeeID"].ToString() + "' and 员工职位名称 like '%经理' ";

        SqlDataReader Dr;
        SqlConnection conn = db.mysqll();
        conn.Open();
        SqlCommand cmd = new SqlCommand(StrSelect,conn);
        Dr = cmd.ExecuteReader();

        if (!Dr.Read())
        {

            lblMessage.Text = "对不起，该网页属经理专用，请退出！";
            return;
        }
        else
        {

            
            if (Dr["员工职位职位名称"].ToString() == "总经理")
            {
                Dr.Close();
                lblMessage.Text = "对不起，没有您要查看的信息！";
                return;

            }
            else
            {




                if (Request["Year"] == null)
                {
                    
                    lblYear.Text = DateTime.Now.Year.ToString();
                    lblSeason.Text = ((DateTime.Now.Month + 2) / 3).ToString();
                }
                else
                {
                    //如果网页的 URL 中已指定了年份和季度信息，则使用该信息。
                    lblYear.Text = (string)Request["Year"];
                    lblSeason.Text = (string)Request["Season"];
                }

                pnlHeader.Visible = true;

                //保存部门编号。
                lblDeptID.Text = Dr["员工所属部门编号"].ToString();
                Dr.Close();
                //借用 RefreshPage 方法，设置网页其他控件的显示内容和方式。
                RefreshPage();
            }


        }

    }
    void RefreshPage()
    {

        DataSet dsResult = new DataSet();
        int iYear, iSeason, iDeptID;

        
        iYear = int.Parse(lblYear.Text);
        iSeason = int.Parse(lblSeason.Text);
        iDeptID = int.Parse(lblDeptID.Text);

        
        int iStartYear;
        iStartYear = DateTime.Now.Year-30;

        if ( iSeason == 1)
        {
            //如果当前季度为公司起始年份的第一个季度，则应禁用“上一季度”按钮。
            btnPrev.Enabled = false;
        }
        else
        {
            //否则启用该按钮。
            btnPrev.Enabled = true;
        }

        if (iYear == DateTime.Now.Year && iSeason == (int)((DateTime.Now.Month + 2) / 3))
        {
             
            btnNext.Enabled = false;
        }
        else
        {
            //否则启用该按钮。
            btnNext.Enabled = true;
        }

        string sqltotal = "select * from 查看员工业绩评定中的子项目 where 员工所属部门编号='" + iDeptID + "' and 年份='" + iYear.ToString() + "' and 季度='" + iSeason.ToString() + "' ";

        SqlDataAdapter dar;
        SqlConnection conn = db.mysqll();
        conn.Open();
        dar = new SqlDataAdapter(sqltotal ,conn);
        dar.Fill(dsResult);

        if (dsResult.Tables[0].Rows.Count > 0)
        {
             
            DataView dv = new DataView(dsResult.Tables[0]);

            dv.Sort = "PerformID Asc";
            grdResult.DataSource = dv;
            grdResult.DataBind();
            grdResult.Visible = true;
            lblNoResult.Visible = false;
        }
        else
        {
             
            grdResult.Visible = false;
            lblNoResult.Visible = true;
            return;
        }

    }
    protected void btnPrev_Click(object sender, EventArgs e)
    {
        int iYear, iSeason;
        int iStartYear;


        iStartYear =  DateTime.Now.Year-30;


         
        iYear = int.Parse(lblYear.Text);
        iSeason = int.Parse(lblSeason.Text) - 1;

         
        if (iSeason == 0)
        {
            iSeason = 4;
            iYear -= 1;
        }

        //保存更新后的年份和季度。
        lblYear.Text = iYear.ToString();
        lblSeason.Text = iSeason.ToString();
 
        RefreshPage();
    }
    protected void btnNext_Click(object sender, EventArgs e)
    {
        int iYear, iSeason;
        int iStartYear;


        iStartYear =  DateTime.Now.Year-30;


         
        iYear = int.Parse(lblYear.Text);
        iSeason = int.Parse(lblSeason.Text) + 1;

       
        if (iSeason == 5)
        {
            iSeason = 1;
            iYear += 1;
        }

      
        lblYear.Text = iYear.ToString();
        lblSeason.Text = iSeason.ToString();

         
        RefreshPage();
    }
    protected void grdResult_ItemCommand(object source, DataGridCommandEventArgs e)
    {
        if (e.CommandName == "Check")
        {

            int iEmpID, iYear, iSeason;

        
            iEmpID = int.Parse(e.Item.Cells[1].Text);

       
            iYear = int.Parse(lblYear.Text);
            iSeason = int.Parse(lblSeason.Text);

            
            Response.Redirect("ShowDetail.aspx?EmpID=" + iEmpID + "&Year=" + iYear + "&Season=" + iSeason);
        }
    }
}