documentsave.aspx.cs

很不错的公文流转系统

using System; 
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
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.DocTemplate
{
	/// <summary>
	/// DocumentSave 的摘要说明。
	/// </summary>
	public class DocumentSave : OI.PageBase 
	{
		string mRecordID="";
		string mTemplate="";
		string mSubject="";
		string mAuthor="";
		string mFileDate="";
		string mFileType="";
		string mHTMLPath="";
		string mStatus="";
//		string mError="";

		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 ;
			}
			SqlCommand nCommand;
			string strSelectCmd;
			string strUpdateCmd;
			string strInsertCmd;			
   
			mRecordID=Request.Form["RecordID"] ;
			mTemplate=Request.Form["Template"] ;
			mSubject=Request.Form["Subject"] ;
			mAuthor=Request.Form["Author"] ;
			mFileDate=Request.Form["FileDate"] ;
			mFileType=Request.Form["FileType"] ;
			mHTMLPath=Request.Form["HTMLPath"] ;
			mStatus="READ";

			strSelectCmd= "SELECT RecordID from  Document Where RecordID='" + mRecordID + "'";
			SqlCommand mCommand = new SqlCommand(strSelectCmd,oConn.GetConn());//更改
			SqlDataReader mReader;
		
			mReader = mCommand.ExecuteReader(CommandBehavior.CloseConnection);			
			if (mReader.Read())
			{
				mReader.Close();
				
				strUpdateCmd="update Document set RecordID=@RecordID,Template=@Template,Subject=@Subject,Author=@Author,FileDate=@FileDate,FileType=@FileType,HtmlPath=@HtmlPath,Status=@Status where RecordID='"+mRecordID+"'";
				nCommand = new SqlCommand(strUpdateCmd, oConn.GetConn());//更改
			}
			else
			{
				mReader.Close();
				
				strInsertCmd="insert into Document (RecordID,Template,Subject,Author,FileDate,FileType,HtmlPath,Status) values (@RecordID,@Template,@Subject,@Author,@FileDate,@FileType,@HtmlPath,@Status)";
				nCommand = new SqlCommand(strInsertCmd, oConn.GetConn());//更改
			} 
			 
			nCommand.Parameters.Add(new SqlParameter("@RecordID", SqlDbType.VarChar,16)); 
			nCommand.Parameters["@RecordID"].Value = mRecordID;

				
			nCommand.Parameters.Add(new SqlParameter("@Template",SqlDbType.VarChar,16)); 
			nCommand.Parameters["@Template"].Value = mTemplate;

				
			nCommand.Parameters.Add(new SqlParameter("@Subject",SqlDbType.VarChar,32)); 
			nCommand.Parameters["@Subject"].Value = mSubject;
				
				
			nCommand.Parameters.Add(new SqlParameter("@Author",SqlDbType.VarChar,32)); 
			nCommand.Parameters["@Author"].Value = mAuthor;
				
			nCommand.Parameters.Add(new SqlParameter("@FileDate",SqlDbType.DateTime)); 
			nCommand.Parameters["@FileDate"].Value = mFileDate;
				
			nCommand.Parameters.Add(new SqlParameter("@FileType",SqlDbType.VarChar,4)); 
			nCommand.Parameters["@FileType"].Value = mFileType;
				
			nCommand.Parameters.Add(new SqlParameter("@HtmlPath",SqlDbType.VarChar,64)); 
			nCommand.Parameters["@HtmlPath"].Value = mHTMLPath;

			nCommand.Parameters.Add(new SqlParameter("@Status",SqlDbType.VarChar,64)); 
			nCommand.Parameters["@Status"].Value = mStatus;
			if(	nCommand.ExecuteNonQuery()==1)
			{
				oConn.DataBaseClose();
				Response.Redirect ("DocumentList.aspx");
			}
			else
			{
				oConn.DataBaseClose();
			}
		}
			
	


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