templateaddedit.aspx.cs

很不错的公文流转系统

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 OI.DatabaseOper ;

namespace OI.DocTemplate
{
	/// <summary>
	/// TemplateAddEdit 的摘要说明。
	/// </summary>
	public class TemplateAddEdit : OI.PageBase
	{
		protected System.Web.UI.WebControls.TextBox TextBoxTitle;
		protected System.Web.UI.WebControls.Label Label1;
		protected System.Web.UI.WebControls.TextBox TextBoxContent;
		private DatabaseOper.DatabaseConnect dc;
		protected System.Web.UI.WebControls.TextBox TextBoxID;		
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			dc=new DatabaseConnect ();
			
			if(this.IsPostBack )
			{
				this.SaveData ();
			}
			else
			{					
				this.initData ();
			}

		}
		private void initData()
		{
			int id;
			try
			{
				id=Convert.ToInt32 (Request.Params ["id"].Trim ().ToString ());
				TextBoxID.Text =id.ToString ();
			}
			catch
			{
				return;
			}
			string sql="";			
			if(id>-1)
			{
				sql="SELECT CyclostyleName,Content FROM DocumentCyclostyle WHERE CyclostyleID='"+id+"'";
				ArrayList al=dc.getData (sql);
				if(al.Count >0)
				{
					TextBoxTitle.Text =al[0].ToString ();
					TextBoxContent.Text =al[1].ToString ();
				}
			}
		}
		private void SaveData()
		{	
			int id=Convert.ToInt32 (TextBoxID.Text .Trim ());
			string sql="";
			string strTitle=TextBoxTitle.Text .Trim ().Replace ("'","''");
			string strContent=TextBoxContent.Text .Trim ().Replace ("'","''");
			if(TextBoxTitle.Text .Trim ()=="")
			{
				Page.RegisterStartupScript ("","<script>alert('名称不能为空')</script>");
			}
			if(id==-1)
			{
				sql="INSERT INTO DocumentCyclostyle(CyclostyleName,CyclostyleDescription,Content,DefaultText) "+
					"VALUES('"+strTitle+"','','"+strContent+"','')";
			}
			else if(id>-1)
			{
				sql="UPDATE DocumentCyclostyle SET CyclostyleName='"+strTitle+"',Content='"+strContent+"' WHERE CyclostyleID='"+id+"'";
			}
			try
			{
				dc.addData (sql);
				Page.RegisterStartupScript ("","<script>alert('存储成功')</script>");
				Response.Redirect ("DocTemplate.aspx");
			}
			catch
			{
				Page.RegisterStartupScript ("","<script>alert('存储失败')</script>");
			}
		}

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

		}
		#endregion
	}
}