oa/pxgl/Pxcx_View.aspx.cs

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

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

namespace hkoa.oa.pxgl
{
    public partial class Pxcx_View : System.Web.UI.Page
    {
        public void Page_Load(object Sender, EventArgs E)
        {
            mydb hkdb = new mydb();
            hkdb.VeriSess("4");

            if (!IsPostBack)
            {
                hkdb.PassTo("11502", "0");

                //参数判断 
                if (!string.IsNullOrEmpty(Request.QueryString["id"]))
                {
                    lbltitle.Text = "查看";
                    SqlDataReader datar = SqlHelper.ExecuteReader("select * from OA_PXGL where pxid='" + Request.QueryString["id"].ToString() + "'");
                    if (datar.Read())
                    {
                        kczt.Text = datar["kczt"].ToString();
                        pxkssj.Text = (datar["pxkssj"] == System.DBNull.Value ? "" : string.Format("{0:d}", datar["pxkssj"]));
                        pxjssj.Text = (datar["pxjssj"] == System.DBNull.Value ? "" : string.Format("{0:d}", datar["pxjssj"]));
                        pxdx.Text = (datar["pxdx"] == System.DBNull.Value ? "" : datar["pxdx"].ToString());
                        pxjs.Text = (datar["pxjs"] == System.DBNull.Value ? "" : datar["pxjs"].ToString());
                        pxdd.Text = (datar["pxdd"] == System.DBNull.Value ? "" : datar["pxdd"].ToString());
                        pxdw.Text = (datar["pxdw"] == System.DBNull.Value ? "" : datar["pxdw"].ToString());
                        kcnr.Text = (datar["kcnr"] == System.DBNull.Value ? "" : datar["kcnr"].ToString());
                        datar.Close();
                    }
                    else
                    {
                        datar.Close();
                        ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('该培训记录不存在，可能已被删除！'); window.close();<" + "/script>");
                    }
                }
            }
        }

    }
}