printsalary.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_Salary_PrintSalary : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        // 在此处放置用户代码以初始化页面
        if (!IsPostBack)
        {
            //如果网页是第一次生成时，执行如下操作：

            //设置界面控件的显示方式。
          
            lblMessage.Visible = false;
            
            int iYear, i, iStartYear;

            //获取当前年份。
            iYear = DateTime.Now.Year;

            //从 Web.Config 文件中读取公司的起始年份。
            iStartYear =  DateTime.Now.Year-30;

            //填充年份选择下拉框的内容：从起始年份到当前年份逐年添加。
            for (i = iStartYear; i <= iYear; i++)
            {
                cmbYear.Items.Add(i.ToString());
                cmbYear.Items[cmbYear.Items.Count - 1].Value = i.ToString();
            }

            //设定年份选择下拉框的默认显示为当前年份。
            cmbYear.SelectedIndex = cmbYear.Items.Count - 1;

            //以 12 个月填充月份选择下拉框的内容。
            for (i = 1; i <= 12; i++)
            {
                cmbMonth.Items.Add(i.ToString());
                cmbMonth.Items[cmbMonth.Items.Count - 1].Value = i.ToString();
            }

            //设定月份选择下拉框的默认显示为上一月份。
            cmbMonth.SelectedIndex = DateTime.Now.Month - 2;

        }
    }
    protected void btnSearch_Click(object sender, EventArgs e)
    {
        DataSet dsResult = new DataSet();
        string strStartDate, strEndDate;

        
        strStartDate = cmbYear.SelectedValue.ToString() + "/" + cmbMonth.SelectedValue.ToString() + "/01";

       
        strEndDate = cmbYear.SelectedValue.ToString() + "/" + (int.Parse(cmbMonth.SelectedValue) + 1).ToString() + "/01";

       
        int iEmpID;
        iEmpID = int.Parse((string)Session["EmployeeID"]);
        SqlConnection conn = db.mysqll();
        conn.Open();

        string strsql = "seelect * from 查看员工薪资历史信息 where  员工编号='" + iEmpID + "' and  薪资发放时间 >'" + strStartDate + "'and 薪资发放时间< ='" + strEndDate + "'";
       
       
        //SqlDataAdapter da=new SqlDataAdapter(strsql ,conn);
        //da.Fill (dsResult,"员工工资");



        //薪资发放时间 >= '" + strStartDate + "' and  薪资发放时间 <= '" + strEndDate + "'and

        SqlCommand cmd = new SqlCommand(strsql, conn);
        SqlDataReader rd = cmd.ExecuteReader();
        rd.Read();

        if (rd.Read())
        {

           
            rd.Close();
            
            
            lblSalaryID.Text = rd["薪资编号"].ToString();

           
            lblBasicSalary.Text = rd["员工基本薪资"].ToString();

            
            lblOvertimeSalary.Text = rd["加班薪资"].ToString();

            
            lblAbsenceSalary.Text = rd["缺勤扣除"].ToString();

           
            lblOtherSalary.Text = rd["其他薪资"].ToString();

           

            Decimal aa = (Decimal)rd["员工基本薪资"] + (Decimal)rd["加班薪资"] - (Decimal)rd["缺勤扣除"] + (Decimal)rd["其他薪资"];
            lblActualSalary.Text = aa.ToString (); 
           

           
            pnlDetail.Visible = true;
             
            lblMessage.Visible = false;
       
}
        else
        {
            lblMessage.Text = "没有找到任何记录！";

            pnlDetail.Visible = false;
            lblMessage.Visible = true;
            
        }
        return;
    }

    protected void Button1_Click(object sender, EventArgs e)
    {
        int iSalaryID;
        iSalaryID = int.Parse(lblSalaryID.Text);

        //打开一个新的浏览器窗口，该窗口显示 Print.aspx 网页，并传递工资单编号信息。
        Response.Write("<script>window.open(\"Print.aspx?SalaryID=" + iSalaryID + "\")</script>");
    }
}