dp_dianpuset.aspx.cs

b to b 模式 电子商务系统

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;

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

namespace B2Bsite
{
	/// <summary>
	/// 店铺_基本信息设置
	/// </summary>
	public class DP_DianPuSet : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.TextBox TextBox1;
		protected System.Web.UI.WebControls.TextBox TextBox3;
		protected System.Web.UI.HtmlControls.HtmlSelect Select1;
		protected System.Web.UI.HtmlControls.HtmlTextArea DJieshao;
		protected System.Web.UI.HtmlControls.HtmlInputButton Reset1;
        protected System.Web.UI.HtmlControls.HtmlImage img1;
		protected System.Web.UI.HtmlControls.HtmlInputButton Submit2;
        protected System.Web.UI.HtmlControls.HtmlInputFile uploadFile;
	
		private void Page_Load(object sender, System.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(ConfigurationSettings.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();
	
                    
				}

			}
		}

		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
            this.Submit2.ServerClick += new System.EventHandler(this.Submit2_ServerClick);
            this.Load += new System.EventHandler(this.Page_Load);

        }
		#endregion

		private void Submit2_ServerClick(object sender, System.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(ConfigurationSettings.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(ConfigurationSettings.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>");
                   
                } 
            //}
            //catch
            //{
             //   Response.Write ("<script language='javaScript'>");
             //   Response.Write("alert('修改失败！！！')");				
              //  Response.Write("</script>");
            //}

		}

	}
}