rsgl/gwbd.aspx.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;

public partial class rsgl_gwbd : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            if (Session["username"] == null)
            {
                Response.Clear();
                Response.Write("<script language='javascript'>window.top.location.href='../login.aspx'</script>");
                Response.End();
            }
            else
            {
                GVDataBind();
                GVDataBind1();
            }
        }
    }

    //对GirdView绑定
    protected void GVDataBind()
    {
        string sqlstr = "select jq_mdyg_id,jq_mdyg_name,jq_mdyg_mdid,jq_mdyg_gwid,jq_mdyg_gwjbid,jq_mdyg_sfzh,jq_mdyg_sex,jq_mdyg_lxdh,jq_mdyg_zzqk from j_mdyg";
        DataTable dt = SQLHelper.ExecteTable(sqlstr, new SqlParameter("", ""));
        this.gvBaseInfo.DataSource = dt;
        this.gvBaseInfo.DataKeyNames = new string[] { "jq_mdyg_id" };
        this.gvBaseInfo.DataBind();

        //aaa.InnerText = dt.Rows.Count.ToString();
        //string sqlstr1 = "select jq_gwname from j_gwgl";
        //DataTable dt1 = SQLHelper.ExecteTable(sqlstr1, new SqlParameter("", ""));
        //for (int i = 0; i < dt1.Rows.Count; i++)
        //{
        //    this.dmc.InnerText += dt1.Rows[i][0].ToString();
        //    this.dmc.InnerText += "，";
        //}
    }

    protected void GVDataBind1()
    {
        string sqlstr = "select jq_gwbdid,jq_ryid,jq_ryname,jq_rzsj,jq_gwbdsj,jq_bdqgw,jq_bdhgw,jq_mdname,jq_gwjiname from j_gwbd";
        DataTable dt = SQLHelper.ExecteTable(sqlstr, new SqlParameter("", ""));
        this.gvddtable.DataSource = dt;
        this.gvddtable.DataKeyNames = new string[] { "jq_gwbdid" };
        this.gvddtable.DataBind();
    }

    protected string getMDById(string id)
    {
        string orgName = "";