convocationwatchtoweradd.aspx.cs

很不错的公文流转系统

/**************************************************************************************
作者：蒲丰. 
创建日期：2003-11-17
修改者：
修改日期：
修改部分：
类功能： 会议管理的增加
****************************/
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;

namespace OI.convocation
{
	/// <summary>
	/// convocationwatchtowerAdd 的摘要说明。
	/// </summary>
	public class convocationwatchtowerAdd : OI.PageBase
	{
		protected System.Web.UI.WebControls.TextBox TextBoxSpeaker;
		protected System.Web.UI.WebControls.TextBox TextBoxAudience;
		protected System.Web.UI.WebControls.TextBox TextBoxLocation;
		protected System.Web.UI.WebControls.TextBox TextBoxContent;
		protected System.Web.UI.WebControls.TextBox TextBoxMemo;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator1;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator2;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator3;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator4;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator5;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator6;
		protected System.Web.UI.WebControls.TextBox TextBoxTitle;
		protected System.Web.UI.WebControls.ImageButton ImageButton1;
	    protected OI.DatabaseOper.DatabaseConnect Dbc=new OI.DatabaseOper.DatabaseConnect ();
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			if (Session["userid"]==null)
			{
				Response.Write ("<script>alert('超时,请重新登录');top.location.href='../userpass.aspx';</script>");
				return ;
			}
			if (!Page.IsPostBack )
			{
				try
				{
					ViewState["class"]=Request.QueryString ["class"];
					//ButtonBack.Attributes["onclick"]="window.location.href='convocationwatchtower.aspx?class="+ViewState["class"].ToString ()+"'";
				}
				catch
				{
					return;
				}
			}
			
		}

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

		}
		#endregion

		private void ButtonSave_Click(object sender, System.EventArgs e)
		{
			Replace();
		    string strSQL="insert meetrecord(title,content,speaker,audience,location,talkdate,memo,userid,meetingtypename)"+
				" values('" +TextBoxTitle.Text +"','"+TextBoxContent.Text +"','"+TextBoxSpeaker.Text +"','"+TextBoxAudience.Text +"','"+TextBoxLocation.Text +"','"+System.DateTime .Now +"','"+TextBoxMemo.Text +"',"+Session["userid"].ToString ()+",'"+ViewState["class"].ToString ()+"')";
		    Dbc.ExecuteSQL (strSQL);
			Response.Redirect ("convocationwatchtower.aspx?class="+ViewState["class"].ToString ());
		}
		private void Replace()
		{
			TextBoxTitle.Text=TextBoxTitle.Text.Replace ("'","＇");
			TextBoxSpeaker.Text=TextBoxSpeaker.Text.Replace ("'","＇");
			TextBoxAudience.Text=TextBoxAudience.Text.Replace ("'","＇");
			TextBoxLocation.Text=TextBoxLocation.Text.Replace ("'","＇");
			TextBoxMemo.Text=TextBoxMemo.Text.Replace ("'","＇");
			TextBoxContent.Text=TextBoxContent.Text.Replace ("'","＇");
		}

		private void ButtonBack_Click(object sender, System.EventArgs e)
		{
			Response.Redirect ("convocationwatchtower.aspx?class="+ViewState["class"].ToString ());
		}

		private void ImageButton1_Click(object sender, System.Web.UI.ImageClickEventArgs e)
		{
			Replace();
			string strSQL="insert meetrecord(title,content,speaker,audience,location,talkdate,memo,userid,meetingtypename)"+
				" values('" +TextBoxTitle.Text +"','"+TextBoxContent.Text +"','"+TextBoxSpeaker.Text +"','"+TextBoxAudience.Text +"','"+TextBoxLocation.Text +"','"+System.DateTime .Now +"','"+TextBoxMemo.Text +"',"+Session["userid"].ToString ()+",'"+ViewState["class"].ToString ()+"')";
			Dbc.ExecuteSQL (strSQL);
			Response.Redirect ("convocationwatchtower.aspx?class="+ViewState["class"].ToString ());
		}
	}
}