摇一摇优惠券开源码/51wsb_weijuan/admin/redboxlist.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;
namespace wxyaoyao.admin
{
    public partial class redboxlist : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!this.IsPostBack)
            {
                try
                {
                    ViewState["username"] = Request.Cookies["site"]["adminame"];
                    ViewState["hdid"] = Request.QueryString["id"].ToString();
                    binder();
                    hdname();
                }
                catch
                {
                    Response.Redirect("login.aspx");
                }
            }
        }
        public void hdname()
        {
            SqlConnection con = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["sqldb"].ToString());
            SqlCommand cmd = new SqlCommand();
            cmd.Connection = con;
            cmd.CommandText = "select title from wx_yaoyao where id=@id";
            cmd.Parameters.Add("@id", SqlDbType.Int);
            cmd.Parameters["@id"].Value = Convert.ToInt32(ViewState["hdid"]);
            con.Open();
            Label1.Text = cmd.ExecuteScalar().ToString() + "—";
            con.Close();
        }

        public void binder()
        {
            SqlConnection con = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["sqldb"].ToString());
            SqlCommand cmd = new SqlCommand();
            cmd.Connection = con;
            cmd.CommandText = "select * from redboxlist where hdid=@hdid order by id asc";
            cmd.Parameters.Add("@hdid", SqlDbType.Int);
            cmd.Parameters["@hdid"].Value = Convert.ToInt32(ViewState["hdid"]);
            DataSet ds = new DataSet();
            ds.Clear();
            con.Open();
            SqlDataAdapter sda = new SqlDataAdapter(cmd);
            sda.Fill(ds, "redboxlist");