main_d.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

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.OleDb;
using qiupeng.Public;
using System.IO;
namespace qphr
{
    public partial class main_d : System.Web.UI.Page
    {
        Db List = new Db();
        protected void Page_Load(object sender, EventArgs e)
        {
            if (this.Session["username"] == null)
            {
                Response.Redirect("default.aspx");
                return;
            }

            // 下载于www.51aspx.com
            string SQL_tb = "select   * from qp_hr_DIYMould where username='" + this.Session["username"] + "'  order by PaiXun asc";
            OleDbDataReader NewReaderTB = List.GetList(SQL_tb);

            this.Label.Text = null;
            int glTMP1 = 0;
            this.Label.Text += "<table width=\"100%\"   border=\"0\" cellspacing=\"0\" cellpadding=\"0\" >";
            this.Label.Text += "<tr>";
            while (NewReaderTB.Read())
            {
                string SQL_tbx = null;
                string lstr = null;

                if (NewReaderTB["Name"].ToString() == "正式合同到期")
                {
                    SQL_tbx = "select top  " + NewReaderTB["LookMuch"] + "  * from qp_hr_HtManage  where    datediff(dd,getdate(),HeTongqxsj)<=" + NewReaderTB["TiXing"] + " and datediff(dd,getdate(),HeTongqxsj)>=0  and  QiXian='有'  and  HtZt='生效中' order by id desc";
                    OleDbDataReader NewReaderTBx = List.GetList(SQL_tbx);

                    lstr += "<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"4\">";
                    while (NewReaderTBx.Read())
                    {
                        lstr += "<tr><td>&nbsp;&nbsp;<a href=\"javascript:void(0)\"  onclick=\"showfromht(" + NewReaderTBx["id"] + ");\"  title=\"合同编号：" + NewReaderTBx["HtBianHao"] + "&#13;合同名称：" + NewReaderTBx["HtMc"] + "&#13;员工姓名：" + NewReaderTBx["XingMing"] + "&#13;员工部门：" + NewReaderTBx["BuMen"] + "\"><img src=\"images/news.gif\" width=\"15\" height=\"10\" border=\"0\" />" + NewReaderTBx["HtMc"] + "</a></td></tr>";
                    }
                    lstr += "</table>";
                    NewReaderTBx.Close();
                }//正式合同到期


                if (NewReaderTB["Name"].ToString() == "试用合同到期")
                {
                    SQL_tbx = "select top  " + NewReaderTB["LookMuch"] + "  * from qp_hr_HtManage  where    datediff(dd,getdate(),ShiYongDq)<=" + NewReaderTB["TiXing"] + " and datediff(dd,getdate(),ShiYongDq)>=0  and  QiXian='有'  and  HtZt='试用中' order by id desc";
                    OleDbDataReader NewReaderTBx = List.GetList(SQL_tbx);

                    lstr += "<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"4\">";