templatesave.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 System.Data.SqlClient;

namespace OI.DocTemplate.Template
{
	/// <summary>
	/// TemplateSave 的摘要说明。
	/// </summary>
	public class TemplateSave : OI.PageBase
	{
		string mRecordID="";
//		string mFileName="";
		string mDescript="";
		
		
		string mFileType="";
		string mDocumentTypeID="";		
		string mUserName="";
		private int departmentid;
		private OI.DatabaseOper.DatabaseConnect oConn = 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 ;
			}
			try {
				departmentid=Convert.ToUInt16(Request["departmentid"].ToString ()); 
			}
			catch{
				departmentid=1;
			}
			 

			SqlCommand nCommand;
			string strUpdateCmd;
			bool mResult=false;			 

			mRecordID=Request.Form["RecordID"] ;
			//mFileName=Request.Form["FileName"] ;
			mDescript=Request.Form["Descript"] ;

			mFileType=Request.Form["FileType"] ;
			mDocumentTypeID =Request.Form["DocumentTypeID"];
			mUserName=Request.Form["UserName"] ;	

			strUpdateCmd="Update Template Set DocumentTypeID=" +mDocumentTypeID+",UserName='"+mUserName+"',Descript = '"+ mDescript +"',departmentid="+departmentid+"  Where RecordID='"+ mRecordID +"'";
			nCommand = new SqlCommand(strUpdateCmd, oConn.GetConn());//更改
			
			try {
				nCommand.ExecuteNonQuery();
				mResult=true;
			}
			catch(SqlException ex) {
				Response.Write(ex.ToString());
				mResult=false;
			}
			if (mResult) {
				if( System.Convert.ToInt32(Session["manageid"])==1) {
					try {
						string str="update template set departmentid=0 where RecordID="+mRecordID;
						oConn.ExecuteSQL (str);
					}
					catch {
					}
					Response.Redirect("TemplateList.aspx?manageid=1");
				}
				else {
					Response.Redirect("TemplateList.aspx");
				}
			}
		} 

		#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
	}
}