shop_manage.aspx.cs

B2B网上商城

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

using System.Configuration;
using System.Data.SqlClient;

public partial class shop_manage : System.Web.UI.Page
{
    public string shopinfo = "";
    public string dianpuID = "";
    public string mydianpu;
    public string kaidian;
    public SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["ConnStr"]);

    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["username"] == null)
        {
            Response.Redirect("User_login.aspx");
        }

        if (!IsPostBack)
        {
            String sql = "SELECT * FROM DianPuDetail where DianPuUser='" + Session["username"].ToString() + "'";
            SqlCommand command = new SqlCommand(sql, conn);
            conn.Open();
            SqlDataReader dr = command.ExecuteReader();
            if (dr.Read())
            {
                dianpuID = dr["DianPuId"].ToString();
                mydianpu = "<a href='shop_display.aspx?id=" + dianpuID + "' target=_blank>[店铺]查看我的店铺</a>";
                kaidian = "免费注册卖家！";

                shopinfo = "<TR><TD><FONT color=#cccccc>★</FONT></TD>\n";
                shopinfo += "<TD><A href=\"DP_DianPuSet.aspx\" target=myshop_list >[店铺]基本设置</A></TD></TR>\n";
                shopinfo += "<TR><TD><FONT color=#cccccc>★</FONT></TD>\n";
                shopinfo += "<TD><a href=\"DP_DianPugonggao.aspx\" target=myshop_list>[店铺]公告设置</a></TD>\n";
                shopinfo += "</TR>\n";
            }
            else
            {
                mydianpu = "[店铺]查看我的店铺";
                kaidian = "<A href='DP_kaidian.aspx' target=myshop_list >免费注册卖家！</A>";
            }
            dr.Close();
            conn.Close();
        }
    }
}