convocationwatchtowermodify.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>
	/// convocationwatchtowerModify 的摘要说明。
	/// </summary>
	public class convocationwatchtowerModify : OI.PageBase
	{
		protected System.Web.UI.WebControls.Button ButtonSave;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator6;
		protected System.Web.UI.WebControls.TextBox TextBoxMemo;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator5;
		protected System.Web.UI.WebControls.TextBox TextBoxContent;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator4;
		protected System.Web.UI.WebControls.TextBox TextBoxLocation;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator3;
		protected System.Web.UI.WebControls.TextBox TextBoxAudience;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator2;
		protected System.Web.UI.WebControls.TextBox TextBoxSpeaker;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator1;
		protected System.Web.UI.WebControls.TextBox TextBoxTitle;
		protected System.Web.UI.WebControls.Button ButtonBack;
	    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["id"]=Request.QueryString ["id"].ToString ();
					ViewState["class"]=Request.QueryString ["class"].ToString ();
				}
				catch
				{
					Response.Redirect ("../userpass.aspx");
				}
				DisplayDeafultData();

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

		}
		#endregion
        
		private void DisplayDeafultData()
		{
			string str="select * from meetrecord where TalkID="+ViewState["id"].ToString ();
			DataSet ds=new DataSet ();
			ds=Dbc.getBinding(str,"t");
            DataRow dr=ds.Tables[0].Rows[0];
			TextBoxTitle.Text =dr["title"].ToString ();
            TextBoxSpeaker.Text =dr["speaker"].ToString ();
			TextBoxAudience.Text =dr["audience"].ToString ();
            TextBoxLocation.Text =dr["location"].ToString ();
			TextBoxContent.Text =dr["content"].ToString ();
			TextBoxMemo.Text =dr["memo"].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 ButtonSave_Click(object sender, System.EventArgs e)
		{
			Replace();
    		string str="update  meetrecord set Title='"+TextBoxTitle.Text +"', Content='"+TextBoxContent.Text +"',";
			str +=" Speaker='"+TextBoxSpeaker.Text +"',Audience='"+TextBoxAudience.Text +"',Location='"+TextBoxLocation.Text +"',";
			str +=" TalkDate='"+System.DateTime.Now +"',Memo='"+TextBoxMemo.Text +"',userID=" +Session["userid"].ToString ()+" where  TalkID="+ ViewState["id"].ToString ();
		    Dbc.ExecuteSQL (str);
			Page.RegisterStartupScript ("","<script>alert('修改成功');window.location.href='convocationwatchtower.aspx?class="+ViewState["class"].ToString ()+"'</script>");
		}

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