oa/khgl/Khhf01_View.aspx.cs

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

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

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.khgl
{
    public partial class Khhf01_View : System.Web.UI.Page
    {
        public void Page_Load(object Sender, EventArgs E)
        {
            mydb hkdb = new mydb();
            hkdb.VeriSess("4");

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

                //参数判断 
                if (!string.IsNullOrEmpty(Request.QueryString["id"]))
                {
                    lbltitle.Text = "修改";
                    SqlDataReader datar = SqlHelper.ExecuteReader("select * from OA_KHDA01 where khid='" + Request.QueryString["id"].ToString() + "'");
                    if (datar.Read())
                    {
                        gmr.Text = (datar["gmr"] == System.DBNull.Value ? "" : datar["gmr"].ToString());
                        sf.Text = (datar["sf"] == System.DBNull.Value ? "" : datar["sf"].ToString());
                        cs.Text = (datar["cs"] == System.DBNull.Value ? "" : datar["cs"].ToString());
                        gmrdh.Text = (datar["gmrdh"] == System.DBNull.Value ? "" : datar["gmrdh"].ToString());
                        gmrdw.Text = (datar["gmrdw"] == System.DBNull.Value ? "" : datar["gmrdw"].ToString());
                        gmrbs.Text = (datar["gmrbs"] == System.DBNull.Value ? "" : datar["gmrbs"].ToString());
                        gmrzw.Text = (datar["gmrzw"] == System.DBNull.Value ? "" : datar["gmrzw"].ToString());
                        gmrq.Text = (datar["gmrq"] == System.DBNull.Value ? "" : string.Format("{0:d}", datar["gmrq"]));
                        spmc.Text = (datar["spmc"] == System.DBNull.Value ? "" : datar["spmc"].ToString());
                        gmsl.Text = (datar["gmsl"] == System.DBNull.Value ? "" : datar["gmsl"].ToString());
                        email.Text = (datar["email"] == System.DBNull.Value ? "" : datar["email"].ToString());
                        yzdz.Text = (datar["yzdz"] == System.DBNull.Value ? "" : datar["yzdz"].ToString());
                        gmbz.Text = (datar["gmbz"] == System.DBNull.Value ? "" : datar["gmbz"].ToString());
                        syr.Text = (datar["syr"] == System.DBNull.Value ? "" : datar["syr"].ToString());
                        syrdh.Text = (datar["syrdh"] == System.DBNull.Value ? "" : datar["syrdh"].ToString());
                        syrdz.Text = (datar["syrdz"] == System.DBNull.Value ? "" : datar["syrdz"].ToString());
                        syrdw.Text = (datar["syrdw"] == System.DBNull.Value ? "" : datar["syrdw"].ToString());
                        sjzg.Text = (datar["sjzg"] == System.DBNull.Value ? "" : datar["sjzg"].ToString());
                        sybz.Text = (datar["sybz"] == System.DBNull.Value ? "" : datar["sybz"].ToString());

                        RBL1hfqk.SelectedValue = (datar["hfqk1"] == System.DBNull.Value ? "" : datar["hfqk1"].ToString());
                        RBL2hfqk.SelectedValue = (datar["hfqk2"] == System.DBNull.Value ? "" : datar["hfqk2"].ToString());
                        RBL3hfqk.SelectedValue = (datar["hfqk3"] == System.DBNull.Value ? "" : datar["hfqk3"].ToString());
                        datar.Close();
                    }