dp_kaidian.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;
using System.IO;

public partial class DP_kaidian : System.Web.UI.Page
{
    public SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["ConnStr"]);
    
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            if (Session["username"] == null)
            {
                Response.Write("<script language='JavaScript'>");
                Response.Write("alert('请先登录！')");
                Response.Write("</script>");
                Response.End();
                return;
            }
            //绑定 类别下拉列表框
            String sql = "SELECT * FROM PType where parentId=0";
            SqlCommand command = new SqlCommand(sql, conn);
            conn.Open();
            SqlDataReader dr = command.ExecuteReader();
            Select1.DataSource = dr;
            Select1.DataTextField = "category_name";
            Select1.DataValueField = "category_ID";
            Select1.DataBind();
            dr.Close();
            conn.Close();
        }
    }
    protected void Submit2_ServerClick(object sender, EventArgs e)
    {
        string dName = TextBox1.Text;//店铺名称		
        string dClass = Select1.Value;//店铺类别
        ////店铺图片
        string dItem = TextBox3.Text;//店铺主要项目
        string dJieshao = DJieshao.Value;//店铺介绍
        if (dName == null) dName = "";
        //if(dClass=="请选择类别") dClass="";//if(dClass.ToString()=="请选择类别")	dClass="";
        if (dItem == null) dItem = "";
        if (dJieshao == null) dJieshao = "";
        SqlConnection connection = new SqlConnection(ConfigurationManager.AppSettings["ConnStr"]);
        string sql = "select * from DianPuDetail where DianPuName='" + dName + "'";
        SqlCommand command = new SqlCommand(sql, connection);
        connection.Open();
        SqlDataReader dr = command.ExecuteReader();

        string imgPath = uploadFile.PostedFile.FileName;
        System.Drawing.Image imgupload = null;
        try
        {
            imgupload = System.Drawing.Image.FromFile(imgPath);
        }
        catch
        {
        }

        if (dName == "" || dClass == "" || dItem == "" || dJieshao == "")
        {
            Response.Write("<script language='javaScript'>");
            Response.Write("alert('请填写完整！！！')");
            Response.Write("</script>");

        }
        else if (dr.Read())
        {
            Response.Write("<script language='javaScript'>");
            Response.Write("alert('抱歉，此店名已被人注册！！！')");
            Response.Write("</script>");
        }
        else if (uploadFile.PostedFile.FileName != "" && (Path.GetExtension(uploadFile.PostedFile.FileName) != ".gif" && Path.GetExtension(uploadFile.PostedFile.FileName) != ".jpg"))
        {
            Response.Write("<Script>alert('上传的图片格式必须为gif或jpg!!')</Script>");
        }
        else
        {
            string userName = Session["username"].ToString();
            sql = "insert into DianPuDetail(DianPuName,DianPuUser,DianPuClass,DianPuItem,DianPuJieshao) values('" + dName + "','" + userName + "','" + dClass + "','" + dItem + "','" + dJieshao + "')";
            SqlConnection connections = new SqlConnection(ConfigurationManager.AppSettings["ConnStr"]);
            SqlCommand commands = new SqlCommand(sql, connections);
            connections.Open();
            commands.ExecuteNonQuery();
            connections.Close();

            if (uploadFile.PostedFile.FileName != "")
            {
                Stream imagedatastream;
                SqlConnection myConn = new SqlConnection(ConfigurationManager.AppSettings["ConnStr"]);
                imagedatastream = Request.Files["uploadFile"].InputStream;
                int imagedatalen = Request.Files["uploadFile"].ContentLength;
                string imagedatatype = Request.Files["uploadFile"].ContentType;

                byte[] image = new byte[imagedatalen];
                imagedatastream.Read(image, 0, imagedatalen);

                String Psql = "update [DianPuDetail] set [DianPuLogo]=@imgdata where DianPuId=" +
                    "(select top 1 DianPuId from [DianPuDetail] where DianPuUser='" + userName + "' order by DianPuId desc)";

                SqlCommand Pcommand = new SqlCommand(Psql, myConn);

                SqlParameter imgdata = new SqlParameter("@imgdata", SqlDbType.Image);
                imgdata.Value = image;
                Pcommand.Parameters.Add(imgdata);

                myConn.Open();
                Pcommand.ExecuteReader();
                myConn.Close();

            }

            Response.Write("<script language='javaScript'>");
            Response.Write("alert('恭喜！！！注册成功！！！')");
            Response.Write("</script>");
         }
    }
}