dp_dianpugonggao.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.Configuration;
using System.Data.SqlClient;
namespace B2Bsite
{
	/// <summary>
	/// 店铺_公告栏设置
	/// </summary>
	public class DP_DianPuGongGao : System.Web.UI.Page
	{
		protected System.Web.UI.HtmlControls.HtmlTextArea TEXTAREA1;
		protected System.Web.UI.HtmlControls.HtmlInputButton Submit1;
	
		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;
                }

				string userName=Session["username"].ToString();
				string sql="select DianPuGongGao from DianPuDetail where DianPuUser='"+userName+"'";
				SqlConnection connections=new SqlConnection(ConfigurationSettings.AppSettings["ConnStr"]);
				SqlCommand commands=new SqlCommand(sql,connections);
				connections.Open();	
				SqlDataReader dr = commands.ExecuteReader();
                if (dr.Read () )
                {
                    string txtValue=dr["DianPuGongGao"].ToString();
                    TEXTAREA1.Value=txtValue;
                }
                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.Submit1.ServerClick += new System.EventHandler(this.Submit1_ServerClick);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void Submit1_ServerClick(object sender, System.EventArgs e)
		{
			
			string gonggao=TEXTAREA1.Value.ToString();
			string userName=Session["username"].ToString();
			if (userName==null) userName="游客";
			if(userName=="游客")
			{
				Response.Write("<script	language='JavaScript'>");
				Response.Write("alert('请登陆')");
				Response.Write("</script>");		
			}
			else if(gonggao=="")
			{
				Response.Write ("<script language='javaScript'>");
				Response.Write("alert('公告内容为空！！！')");
				Response.Write("</script>");	
			}
			else
			{
				string sql="update DianPuDetail set DianPuGongGao='"+gonggao+"' where DianPuUser='"+userName+"'";
				SqlConnection connections=new SqlConnection(ConfigurationSettings.AppSettings["ConnStr"]);
				SqlCommand commands=new SqlCommand(sql,connections);
				connections.Open();				
				commands.ExecuteNonQuery();		
				connections.Close();
			}		
		}
	}
}