Backup/shequ/xiaoQuxxMan.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.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.IO;
using System.Text;
using System.Data;

namespace shequ
{
    public partial class xiaoQuxxMan : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                bindshequ();
                bindxinxi();

            }
        }
        public void bindshequ()
        {
            DataTable dt_shequ = sqlconn.ExecuteDataTable(sqlconn.SM_SQLConnStr, CommandType.Text, "select * from SQname"
                        );
            this.Dw_shequname.DataValueField = dt_shequ.Columns[0].ToString();
            this.Dw_shequname.DataTextField = dt_shequ.Columns[1].ToString();

            this.Dw_shequname.DataSource = dt_shequ;
            this.Dw_shequname.DataBind();
            this.Dw_shequname.Items.Insert(0, new ListItem("--全部--", "0"));

        }
        public void bindxinxi()
        {
            DataTable dt_personDangan = sqlconn.ExecuteDataTable(sqlconn.SM_SQLConnStr, CommandType.Text, "select * from XqXinXi where sqid=@id",
                new SqlParameter("@id", this.Dw_shequname.SelectedValue.ToString().Trim())
                    );

            this.zongDongshu.Value = dt_personDangan.Rows[0]["ZongDongShu"].ToString().Trim();
            this.zaijianDongshu.Value = dt_personDangan.Rows[0]["zaijianDongShu"].ToString().Trim();
            this.zongHushu.Value = dt_personDangan.Rows[0]["ZongHuShu"].ToString().Trim();
            this.changzhuHushu.Value = dt_personDangan.Rows[0]["ChangZhuHu"].ToString().Trim();
            this.baozhangfanghu.Value = dt_personDangan.Rows[0]["baoZhangFang"].ToString().Trim();
            this.baozhangfangjinqizhu.Value = dt_personDangan.Rows[0]["JinQiZhu"].ToString().Trim();
            this.zuhu.Value = dt_personDangan.Rows[0]["ZuHu"].ToString().Trim();
            this.shangPushu.Value = dt_personDangan.Rows[0]["ShangPu"].ToString().Trim();
        }
        protected void xqnamechange(object sender, EventArgs e)
        {
            bindxinxi();
        }
        protected void Dw_shequname_SelectedIndexChanged1(object sender, EventArgs e)
        {

            bindxinxi();