documentsave.aspx.cs

很不错的公文流转系统

/******************************************************************
*  OI INC.												          *
*  Copyright (c) 2003 OI INC.									  *
*                                                                 *
*  All rights reserved. No part of this program or publication    *
*  may be reproduced, transmitted, transcribed, stored in a       *
*  retrieval system,or translated into any language or computer   *
*  language, in any form or by any means, electronic, mechanical, *
*  magnetic, optical, chemical,biological, or otherwise, without  *
*  the prior written permission.                                  *
*                                                                 *
******************************************************************/

/******************************************************************
*  Source File Name  : DocumentSave.cs                            *
*  Project Name:   OI.csproj				                      *
*  Engineer:  黎斌                                                *
*  Date Generated: 2003/12/09                                     *
*  Last Revision Date :											  *
*  Brief Description  : 文档保存辅助类，在 DocumentEdit.aspx 执行 *
*						保存操作时调用							  *
******************************************************************/
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 DocumentSave : 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)
		{
			// 在此处放置用户代码以初始化页面
			SqlCommand nCommand=null;
			string strSelectCmd;
			string strUpdateCmd;
			string strInsertCmd;
			string mCurrentStepID;

			//获取公文起草节点ID
			OI.cs.readStream oreadStream = new OI.cs.readStream();			
			oreadStream.StreamID = Convert.ToInt32(Session["StreamID"]);
			mCurrentStepID = oreadStream.GetNodeIdByType("公文起草");			

			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 =null;			
			try
			{
				mReader=mCommand.ExecuteReader(CommandBehavior.CloseConnection);
				bool HaveRecord =mReader.Read();
				
				if (HaveRecord)
				{
					mReader.Close();
					strUpdateCmd="update Document set Title=@Title,CurrentStepID=@CurrentStepID,TopicWord=@TopicWord,ExigenceDegreeID=@ExigenceDegreeID,"
						+"SecretGreadID=@SecretGreadID,RecordID=@RecordID,Template=@Template,Subject=@Subject,Author=@Author,"
						+"FileDate=@FileDate,FileType=@FileType,HtmlPath=@HtmlPath,Status=@Status,StreamID=@StreamID,"
					    +"DrawMan=@DrawMan,"
						+"UserID=@UserID,StreamStatus=@StreamStatus where RecordID='"+mRecordID+"'";
					nCommand = new SqlCommand(strUpdateCmd, DBAobj.GetConn());//更改

				}
				else
				{
					mReader.Close();
					strInsertCmd="insert into Document (StreamStatus,Title,CurrentStepID,TopicWord,ExigenceDegreeID,DocumentTypeID,SecretGreadID,RecordID,Template,Subject,Author,DrawMan,FileDate,FileType,HtmlPath,Status,StreamID,UserID)"
						+ " values (@StreamStatus,@Title,@CurrentStepID,@TopicWord,@ExigenceDegreeID,@DocumentTypeID,@SecretGreadID,@RecordID,@Template,@Subject,@Author,@DrawMan,@FileDate,@FileType,@HtmlPath,@Status,@StreamID,@UserID)";
					nCommand = new SqlCommand(strInsertCmd, DBAobj.GetConn());//更改				

					nCommand.Parameters.Add(new SqlParameter("@DocumentTypeID", SqlDbType.Int)); 
					nCommand.Parameters["@DocumentTypeID"].Value = Convert.ToInt32(Session["DocumentTypeID"]);
				}
			
				nCommand.Parameters.Add(new SqlParameter("@StreamStatus",SqlDbType.VarChar,2)); 
				nCommand.Parameters["@StreamStatus"].Value = "1";

				nCommand.Parameters.Add(new SqlParameter("@Title",SqlDbType.VarChar,200)); 
				nCommand.Parameters["@Title"].Value = Session["Title"].ToString();	
			
				nCommand.Parameters.Add(new SqlParameter("@CurrentStepID",SqlDbType.Int)); 
				nCommand.Parameters["@CurrentStepID"].Value = mCurrentStepID;//设置当前节点ID为公文起草

				nCommand.Parameters.Add(new SqlParameter("@TopicWord",SqlDbType.VarChar,200)); 
				nCommand.Parameters["@TopicWord"].Value = Session["TopicWord"].ToString();

				nCommand.Parameters.Add(new SqlParameter("@ExigenceDegreeID", SqlDbType.Int)); 
				nCommand.Parameters["@ExigenceDegreeID"].Value = Convert.ToInt32(Session["ExigenceDegreeID"]);				

				nCommand.Parameters.Add(new SqlParameter("@SecretGreadID", SqlDbType.Int)); 
				nCommand.Parameters["@SecretGreadID"].Value = Convert.ToInt32(Session["SecretGreadID"]);

				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.Parameters.Add(new SqlParameter("@StreamID",SqlDbType.Int)); 
				nCommand.Parameters["@StreamID"].Value =Convert.ToInt32(Session["StreamID"]);
				
				nCommand.Parameters.Add(new SqlParameter("@UserID",SqlDbType.Int)); 
				nCommand.Parameters["@UserID"].Value =Session["UserID"].ToString();
                
				nCommand.ExecuteNonQuery();
	
			    DBAobj.DataBaseClose();
				if (!HaveRecord)
				{ 			 
					object o=DBAobj.GetObjectBySql ("select max(documentid) from document");
				
					if(o!=null)
					{
						int idocumentID=int.Parse (o.ToString()) ;
						OI.cs.moveUsers mU=new OI.cs.moveUsers (idocumentID);						 
							idocumentID=System.Convert.ToInt32(o.ToString());	
							mU.MoveUsers ();						 
					}
				}
				Response.Redirect ("DraftFinished.aspx");

			}
			catch(SqlException ex)
			{
				mError=ex.ToString();
				RegisterStartupScript("","<script>alert('保存文档出错，请重新编辑！');window.location.href='DraftStart.aspx';</script>"); 
				return ;
			} 
		}

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