shequ/huodongCiShu.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 huodongCiShu : 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 huodongCIShu where id=@id",
                new SqlParameter("@id", this.XQname.SelectedValue.ToString().Trim())
                    );

            this.HuoDongCiShu1.Value = dt_personDangan.Rows[0]["yue1"].ToString().Trim();
            this.HuoDongCiShu2.Value = dt_personDangan.Rows[0]["yue2"].ToString().Trim();
            this.HuoDongCiShu3.Value = dt_personDangan.Rows[0]["yue3"].ToString().Trim();
            this.HuoDongCiShu4.Value = dt_personDangan.Rows[0]["yue4"].ToString().Trim();
            this.HuoDongCiShu5.Value = dt_personDangan.Rows[0]["yue5"].ToString().Trim();
            this.HuoDongCiShu6.Value = dt_personDangan.Rows[0]["yue6"].ToString().Trim();
            this.HuoDongCiShu7.Value = dt_personDangan.Rows[0]["yue7"].ToString().Trim();
            this.HuoDongCiShu8.Value = dt_personDangan.Rows[0]["yue8"].ToString().Trim();
            this.HuoDongCiShu9.Value = dt_personDangan.Rows[0]["yue9"].ToString().Trim();
            this.HuoDongCiShu10.Value = dt_personDangan.Rows[0]["yue10"].ToString().Trim();
            this.HuoDongCiShu11.Value = dt_personDangan.Rows[0]["yue11"].ToString().Trim();
            this.HuoDongCiShu12.Value = dt_personDangan.Rows[0]["yue12"].ToString().Trim();
        }
        protected void xqnamechange(object sender, EventArgs e)
        {
            bindxinxi();