dp_dianpuset.aspx.cs

基于VS05和SQL05做的一个电子商务网站

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

public partial class DP_DianPuSet : System.Web.UI.Page
{
    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;
            }
            else
            {
                string userName = Session["username"].ToString();

                SqlConnection connections = new SqlConnection(ConfigurationManager.AppSettings["ConnStr"]);

                //绑定 类别下拉列表框
                String sql2 = "SELECT * FROM PType where parentId=0";
                SqlCommand command = new SqlCommand(sql2, connections);
                connections.Open();
                SqlDataReader dr2 = command.ExecuteReader();
                Select1.DataSource = dr2;
                Select1.DataTextField = "category_name";
                Select1.DataValueField = "category_ID";
                Select1.DataBind();
                dr2.Close();
                connections.Close();


                string sql = "select * from DianPuDetail where DianPuUser='" + userName + "'";
                SqlCommand commands = new SqlCommand(sql, connections);
                connections.Open();
                SqlDataReader dr = commands.ExecuteReader();
                if (dr.Read())
                {
                    string strid = dr["DianPuId"].ToString();
                    string dianpuname = dr["DianPuName"].ToString();
                    string dianpuclass = dr["DianPuClass"].ToString();
                    string dianpuitem = dr["DianPuItem"].ToString();
                    string dianpujieshao = dr["DianPuJieshao"].ToString();
                    img1.Src = "showProductShopLogo.aspx?id=" + strid;
                    TextBox1.Text = dianpuname;
                    Select1.Value = dianpuclass;
                    TextBox3.Text = dianpuitem;
                    DJieshao.Value = dianpujieshao;
                }
                dr.Close();
                connections.Close();


            }

        }
    }
    protected void Submit2_ServerClick(object sender, EventArgs e)
    {
        string dianpuname = TextBox1.Text.ToString();
        string dianpuclass = Select1.Value.ToString();
        string dianpuitem = TextBox3.Text.ToString();
        string dianpujieshao = DJieshao.Value.ToString();
        string userName = "";

        if (Session["username"] == null)
        {
            Response.Redirect("User_login.aspx");
        }
        else
        {
            userName = Session["username"].ToString();
        }

        string imgPath = uploadFile.PostedFile.FileName;
        System.Drawing.Image imgupload = null;
        try
        {
            imgupload = System.Drawing.Image.FromFile(imgPath);
        }
        catch
        {
            //Response.Write("请注意：因为系统桌面上以及我的文档里面的文件具有特殊权限，所以在选择图片时请选择其他地方的图片。");
        }
        //try
        //{
        if (dianpuname == "" || dianpuclass == "" || dianpuitem == "" || dianpujieshao == "")
        {
            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 if(uploadFile.PostedFile.FileName!="" && imgupload.Height>200 && imgupload.Width>200)
                {
                    Response.Write("<script>alert('上传的图片的高不的超过200 宽不的超过200!!')</script>");
                }*/
        else
        {

            string sql = "update DianPuDetail set DianPuName='" + dianpuname + "',DianPuClass='" + dianpuclass + "',DianPuItem='" + dianpuitem + "',DianPuJieshao='" + dianpujieshao + "' where DianPuUser='" + userName + "'";
            SqlConnection connections = new SqlConnection(ConfigurationManager.AppSettings["ConnStr"]);
            SqlCommand commands = new SqlCommand(sql, connections);
            connections.Open();
            commands.ExecuteNonQuery();
            connections.Close();

            if (uploadFile.PostedFile.FileName != "")
            {
                //----------- update图片
                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 sql="insert into image(image) values(@imgdata)";
                String Psql = "update [DianPuDetail] set [DianPuLogo]=@imgdata where DianPuUser='" + userName + "'";

                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>");

        } 
    }
}