coollib_add.aspx.cs

ASP.NET构建的笑傲江湖社区(C#,全源码提供)

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

namespace xajh.chat
{
	/// <summary>
	/// coollib_add 的摘要说明。
	/// </summary>
	public class coollib_add : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.TextBox cooltitle;
		protected System.Web.UI.WebControls.TextBox cooltext;
		protected System.Web.UI.WebControls.Button byts_submit;
		protected System.Web.UI.WebControls.Literal byts_errormsg;
		private x.UserInfo info;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			if (this.Session["info"] == null)
			{
				this.Server.Transfer ("../error.aspx?v=relogin");
			}
			info = (x.UserInfo) this.Session["info"];
			if (info.RoomID == "false")
			{
				this.Server.Transfer ("../error.aspx?v=outchat");
			}
		}

		#region Web Form Designer generated code
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: This call is required by the ASP.NET Web Form Designer.
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// Required method for Designer support - do not modify
		/// the contents of this method with the code editor.
		/// </summary>
		private void InitializeComponent()
		{    
			this.byts_submit.Click += new System.EventHandler(this.byts_submit_Click);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void byts_submit_Click(object sender, System.EventArgs e)
		{
			string mytitle = this.cooltitle.Text.Trim().Replace("\r","").Replace("\n","");
			string mytext = this.cooltext.Text.Trim().Replace("\r","").Replace("\n","");
			if (mytitle == "" || mytitle == null)
			{
				this.byts_errormsg.Text = "标题不能为空!";
				return;
			}
			if (mytext == "" || mytext == null || mytext == "//")
			{
				this.byts_errormsg.Text = "内容不能为空!";
				return;
			}
			if (mytitle.Length > 2)
			{
				this.byts_errormsg.Text = "标题长度不能超过\\\"2\\\"!";
				return;
			}
			if (mytext.Length > 60)
			{
				this.byts_errormsg.Text = "内容长度不能超过\\\"60\\\"!";
				return;
			}
			OleDbConnection MyConn = new OleDbConnection(var.public_conn);
			MyConn.Open();
			OleDbCommand MyComm = new OleDbCommand("select null from [动作词库] where [主题]=?",MyConn);
			MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("主题", System.Data.OleDb.OleDbType.VarWChar, 4, "主题"));
			MyComm.Parameters["主题"].Value = mytitle;
			OleDbDataReader dr = MyComm.ExecuteReader();
			if (dr.Read())
			{
				dr.Close();
				MyConn.Close();
				MyConn.Dispose();
				this.byts_errormsg.Text = "该主题已经存在,不能重复添加!";
				return;
			}
			else
			{
				dr.Close();
				MyComm.CommandText = @"insert into [动作词库]([主题], [内容], [作者], [时间]) values (?, ?, ?, ?)";
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("内容", System.Data.OleDb.OleDbType.VarWChar, 255, "内容"));
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("作者", System.Data.OleDb.OleDbType.VarWChar, 10, "作者"));
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("时间", System.Data.OleDb.OleDbType.VarWChar, 20, "时间"));
				MyComm.Parameters["内容"].Value = mytext;
				MyComm.Parameters["作者"].Value = info.UserName;
				MyComm.Parameters["时间"].Value = DateTime.Now;
				MyComm.ExecuteNonQuery();
				MyConn.Close();
				MyConn.Dispose();
				this.Response.Write ("<script language=javascript type=text/javascript>alert('新语句已经添加成功!');window.close()</script>");
				this.Response.End();
			}
		}
	}
}