documentregister.aspx.cs

很不错的公文流转系统

/**************************************************************************************
作者：蒲丰. 
创建日期：2004-2-14
修改者：
修改日期：
修改部分：
类功能： 外来文档登记
****************************/
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;

namespace OI.ReceivDocument
{
	/// <summary>
	/// documentRegister 的摘要说明。
	/// </summary>
	public class documentRegister : OI.PageBase
	{
		protected System.Web.UI.WebControls.TextBox txtReceiveFileNumber;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator1;
		protected System.Web.UI.WebControls.TextBox txtSendDepartment;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator5;
		protected System.Web.UI.WebControls.TextBox txtDocumentTitle;
		protected System.Web.UI.WebControls.TextBox txtDocumentCount;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator7;
		protected System.Web.UI.WebControls.DropDownList dstExigenceDegreeID;
		protected System.Web.UI.WebControls.TextBox txtReceivedeclare;
		protected System.Web.UI.WebControls.ImageButton imgbtnSave;
		protected System.Web.UI.HtmlControls.HtmlInputFile upfile;
        protected OI.UserControls .DateOper DateReceiveDate ;
		protected System.Web.UI.WebControls.TextBox txtBackDate;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator9;
		protected System.Web.UI.WebControls.TextBox txtworkDepartment;
		protected System.Web.UI.WebControls.DropDownList SecretGreadid;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator3;
	    protected OI.DatabaseOper.DatabaseConnect Dbc=new OI.DatabaseOper.DatabaseConnect (); 
		private void Page_Load(object sender, System. EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			if (!Page.IsPostBack )
			{
				if (Session["userid"]==null)
				{
					Response.Write ("<script>alert('超时,请重新登录');top.location.href='../userpass.aspx';</script>");
					return ;
				}
				else
				{
					string str="select  username from accounts_users where userid="+Session["userid"] ;
					string username=Dbc.GetValueBySql (str);
					if (username.IndexOf ("收文人员") >=1)
					{
						//dataBind();
					}
					else
					{
						Response.Write ("<img src='../images/documentRegister.jpg',border=0>");
						Response.End ();
					}
				}
				dstExigenceDegreeID_Bind();
			}
		}

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

		}
		#endregion

		

		private void imgbtnadd_Click(object sender, System.Web.UI.ImageClickEventArgs e)
		{
		}
		private void dstExigenceDegreeID_Bind()
		{
			string sql=" select * from exigencedegree ";
			System.Data.DataSet ds=new DataSet ();
			ds=Dbc.getBinding (sql,"t");
			dstExigenceDegreeID.DataSource =ds.Tables[0];
			dstExigenceDegreeID.DataTextField =ds.Tables[0].Columns ["ExigenceDegreeName"].ToString ();
			dstExigenceDegreeID.DataValueField  =ds.Tables[0].Columns ["ExigenceDegreeid"].ToString ();
            dstExigenceDegreeID.DataBind ();
			string sql1=" select * from SecretGread ";
			DataSet ds1=Dbc.getBinding(sql1,"t1");
			SecretGreadid.DataSource=ds1.Tables["t1"];
			SecretGreadid.DataTextField="SecretGreadName";
            SecretGreadid.DataValueField="SecretGreadID";
            SecretGreadid.DataBind();

		}
		//private bool Check()
		//{
			//string  ruser= txtReceiveUser.Text .Trim ().Replace ("'","''");
			//if (int.Parse(Dbc.GetValueBySql ("select count(*) from Accounts_Users where UserName ='"+ruser+"'" ))>0) 
			//{
			////	return true;
		//	}
		//	else
		//	{
			//	Response.Write ("收文用户不存在!<a href=\"#\" onclick=javascript:history.back()>返回</a> ");
		////		Response.End ();
//				return false;
		//	}
		//}
//		private int getuser()
//		{
//			string  ruser= txtReceiveUser.Text .Trim ().Replace ("'","''");
//			int userid=int.Parse(Dbc.GetValueBySql ("select userid from Accounts_Users where UserName ='"+ruser+"'" ));
//			if (userid >0) 
//			{
//				return userid ;
//			}
//			else
//			{
//				Response.Write ("收文用户不存在!<a href=\"#\" onclick=javascript:history.back()>返回</a> ");
//				Response.End ();
//				return 0;
//			}
//		}
		/// <summary>
		/// 新增
		/// </summary>
		private void Register()
		{
			string ReceiveFileNumber =txtReceiveFileNumber.Text.Trim().Replace ("'","''");
			string SendDepartment =txtSendDepartment.Text .Trim ().Replace ("'","''");
			string DocumentTitle =txtDocumentTitle.Text .Trim ().Replace ("'","''");
			string DocumentCount =txtDocumentCount.Text .Trim ().Replace ("'","''");
			//string ReceiveUser =txtReceiveUser.Text .Trim ().Replace ("'","''");
			string workDepartment =txtworkDepartment.Text .Trim ().Replace ("'","''");
			string Receivedeclare =txtReceivedeclare.Text .Replace ("'","''");
			string BackDate =txtBackDate.Text .Trim ().Replace ("'","''");
		    string UpfilePath=UPFile().Trim ();
			string instr=" insert into receiveDocument    values('"+ReceiveFileNumber +"'" ;
				   instr +=",'"+ DateReceiveDate.DATE +"'";
			       instr +=",'"+ SendDepartment +"'";
				   instr +=",'"+ DocumentTitle+"'";
			       instr +=",'"+ DocumentCount +"'"; //份数
			       instr +=",'"+ dstExigenceDegreeID.SelectedValue  +"'";
			       instr +=",'"+ workDepartment +"'"; 
			       instr +=","+Session["userid"].ToString () ;  //收文用户;
                   instr +=",'" + BackDate+"'";
			       instr +=",'" + Receivedeclare+"'";
			       instr +=",'" + UpfilePath +"'";
				   instr +=",0,''"; 
				   instr +=","+SecretGreadid.SelectedValue+")";
			try
			{
				Dbc.ExecuteSQL (instr);
			}
			catch(Exception er)
			{
				DelFile(UpfilePath);
				Response.Write ( er.Message +"<a href=\"#\" onclick=javascript:history.back()>返回</a> ");
				Response.End ();
			}
			Response.Redirect ("transmitNo.aspx");
		}

		private void imgbtnSave_Click(object sender, System.Web.UI.ImageClickEventArgs e)
		{
			
			//Check();
		  	Register();
			
		}
		/// <summary>
		/// 上传文件
		/// </summary>
		private string UPFile()
		{   
			string fileName="";
			HttpPostedFile upfiles=upfile.PostedFile ;
			if (upfiles.ContentLength >0 && upfiles.ContentLength<8388608)
			{
			
				string path=Server.MapPath (System.Configuration.ConfigurationSettings.AppSettings["receiveDocument"] ) ;
				try
				{
					
					fileName=upfiles.FileName ;
					int beginNumber=fileName.LastIndexOf (@"\");
					fileName=fileName.Substring (beginNumber+1);
				    fileName=GetNewFile(fileName);
					upfiles.SaveAs (path+"\\"+fileName) ;
				}
				catch(Exception er)
				{
					Response.Write (er.Message);
					Response.Write ("<br>上传文件路径错误:"+path+"\\"+fileName +"<br>请联系系统管理员!");
					Response.End ();
					return "";
				}
			}
				return  fileName;
		}
		/// <summary>
		/// 得到唯一标识的文件名
		/// </summary>
		/// <param name="filename"></param>
		/// <returns></returns>
		private string GetNewFile(string filename)
		{
			if (filename !=null || filename !="")
				return System.Guid.NewGuid ().ToString ()+filename ;  
			else
			{
				return "";
			}
		}
		private void DelFile(string fileName)
		{  
			if (fileName !="")
			{
				string path=Server.MapPath (System.Configuration.ConfigurationSettings.AppSettings["receiveDocument"] ) ;
				path=path+"\\"+fileName ;
				if (System.IO.File.Exists (path)) 
				{
					try
					{
						System.IO.File.Delete (path);
					}
					catch
					{
					}
				}
			}
		}

	}
}