draftsave.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.DraftOut
{
	/// <summary>
	/// DraftSave 的摘要说明。
	/// </summary>
	public class DraftSave : OI.PageBase 
	{
		string mRecordID="";
		string mTemplate="";
		string mSubject="";
		string mAuthor="";
		string mFileDate="";
		string mFileType="";
		string mHTMLPath="";
		string mStatus="";
		string mError="";
        string mDrawMan="";
		private OI.DatabaseOper.DatabaseConnect DBAobj = 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"] ;
			mDrawMan=Session["DrawMan"].ToString ();
			mStatus="READ";


//			strSelectCmd= "SELECT RecordID from  Document Where RecordID='" + mRecordID + "'";
//			SqlCommand mCommand = new SqlCommand(strSelectCmd,DBAobj.GetConn());//更改
//			SqlDataReader mReader = mCommand.ExecuteReader();
//			if (mReader.Read())
//			{
//				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, DBAobj.GetConn());//更改
//			}
//			else
//			{
				strInsertCmd="insert into Document (RecordID,Template,Subject,Author,DrawMan,FileDate,FileType,HtmlPath,Status) values (@RecordID,@Template,@Subject,@Author,@DrawMan,@FileDate,@FileType,@HtmlPath,@Status)";
				nCommand = new SqlCommand(strInsertCmd, DBAobj.GetConn());//更改
//			}
//			mReader.Close();
			try
			{
				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("@DrawMan",SqlDbType.VarChar,32)); 
				nCommand.Parameters["@DrawMan"].Value = mDrawMan;
				
				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;
				
				nCommand.ExecuteNonQuery();
				DBAobj.DataBaseClose();
				Response.Redirect ("DraftFinished.aspx");
			}
			catch(SqlException ex)
			{
				mError=ex.ToString();
			}

		}

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