addedit.aspx.cs

很不错的公文流转系统

/***********************************************
 * Author:吴高发
 * Date:04-2-6
 * ********************************************/
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.PersonSend
{
	/// <summary>
	/// AddEdit 的摘要说明。
	/// </summary>
	public class AddEdit : System.Web .UI .Page 
	{
		protected System.Web.UI.WebControls.Label DispTitle;
		protected System.Web.UI.WebControls.TextBox TextBoxTitle;
		protected System.Web.UI.WebControls.TextBox TextBoxContent;
		protected System.Web.UI.HtmlControls.HtmlInputFile UpFile;
		protected System.Web.UI.HtmlControls.HtmlInputText Handers;
		protected System.Web.UI.HtmlControls.HtmlInputHidden HandersID;
		protected System.Web.UI.WebControls.DropDownList ExigenceDegree;
		protected System.Web.UI.WebControls.TextBox FileName;
		protected System.Web.UI.WebControls.ImageButton ImageButtonSend;
		protected System.Web.UI.WebControls.Label LabelFile;
		protected System.Web.UI.WebControls.TextBox TextBoxID;
		private OI.DatabaseOper .DatabaseConnect dc;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			if (Session["userid"]==null)
			{
				Response.Write ("<script>alert('超时,请重新登录');top.location.href='../userpass.aspx';</script>");
				return ;
			}	
			if(!this.IsPostBack )
			{
				this.InitData ();
			}
		}
		private void InitData()
		{
			this.BindExigence ();

			if(Request["title"] !=null) {
				TextBoxTitle.Text=Request["title"].ToString();
			}

			int nSendid=Convert.ToInt32 (Request.Params ["id"].Trim ().ToString ());
			TextBoxID.Text =nSendid.ToString ();
			if(nSendid==-1)
			{
				DispTitle.Text ="<img src=\"../images/button8.gif\" border=\"0\">发送资料";
				LabelFile.Visible  =false;
				this.DispComp (true);
			}
			else if(nSendid>-1)
			{
				DispTitle.Text ="<img src=\"../images/button8.gif\" border=\"0\">转发资料";
				UpFile.Visible=false;
				LabelFile.Visible  =true;
				this.DispComp (true);
				string sql="SELECT dbo.datumPersonSend.Title, dbo.datumPersonSend.Content, "+
							"dbo.datumPersonSend.FileName, dbo.ExigenceDegree.ExigenceDegreeName "+
							"FROM dbo.datumPersonSend,dbo.ExigenceDegree "+
							"WHERE dbo.datumPersonSend.ExigenceDegreeID = dbo.ExigenceDegree.ExigenceDegreeID "+
							"AND dbo.datumPersonSend.DatumID="+nSendid;
				ArrayList al=dc.getData (sql);
				if(al.Count >0)
				{
					TextBoxTitle.Text =al[0].ToString ();
					TextBoxContent.Text =al[1].ToString ();
					FileName.Text =al[2].ToString ();
					if(al[3].ToString ().Trim ()!="")						
						ExigenceDegree.Items .FindByText (al[3].ToString ()).Selected=true ;
				}
				string strFile=FileName.Text .Trim ();				
				if(strFile==""||strFile=="&nbsp;")
				{
					LabelFile.Text ="没有附件";
				}
				else 
				{
					string strURL=OI.Modules .Config .GetSetting ("ReadDocuments").ToString ()+"/"+strFile;
					LabelFile.Text ="<a href=\"#\" onclick=\""+
						"window.open ('"+strURL+
						"','fj','top=100,left=100,toolbar=0,,status=1,menubar=0,scrollbars=1,resizable=1,width=500,height=300')"+
						"\"><img src=\"../images/open.gif\" border=\"0\"></a>";
				}
			}
		}
		private void DispComp(bool isCan)
		{
			TextBoxTitle.Enabled =isCan;
			TextBoxContent.Enabled =isCan;
			ExigenceDegree.Enabled =isCan;
		}
		private void BindExigence()
		{
			dc=new OI.DatabaseOper.DatabaseConnect ();
			string sql="SELECT ExigenceDegreeID,ExigenceDegreeName FROM dbo.ExigenceDegree order by ExigenceDegreeID desc";
			DataSet ds=dc.getBinding (sql,"tempTable");
			ExigenceDegree.DataSource =ds.Tables ["tempTable"].DefaultView ;
			ExigenceDegree.DataTextField ="ExigenceDegreeName";
			ExigenceDegree.DataValueField ="ExigenceDegreeID";
			ExigenceDegree.DataBind ();
		}

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

		}
		#endregion

		private void ImageButtonSend_Click(object sender, System.Web.UI.ImageClickEventArgs e)
		{
			string strTitle=TextBoxTitle.Text .Trim ().Replace ("'","’");
			string strContent=TextBoxContent.Text.Replace ("'","’");
			string strFileName="";

			if(strTitle=="")
			{
				Page.RegisterStartupScript ("","<script>alert(\"标题不能为空\")</script>");
				return;
			}
			if(HandersID.Value .Trim ().Length ==0)
			{
				Page.RegisterStartupScript ("","<script>alert(\"接收人不能为空\")</script>");
				return;
			}

			int id=Convert.ToInt32 (TextBoxID.Text .Trim ());
			bool isAdd=id>-1?false:true;

			
			if(isAdd)
			{
				strFileName=this.UPFile ();
				if(strFileName=="false")
					strFileName="";
			}
			else
				strFileName=FileName .Text .Trim ();
			
			if(strFileName=="TooBig,,,,,,,,,,,,,,,,,,")
			{
				Page.RegisterStartupScript ("","<script>alert(\"文件太大，上传文件不能超过 8M ！\")</script>");
				return;
			}
			
			string [] strHanders=HandersID.Value .Trim ().Split (new char[]{','});
			string [] strSqlAl=new string [strHanders.Length ];
			string [] strSqlMess=new string [strHanders.Length ];
			
			
//			INSERT INTO datumPersonSend(Title,UserID,SendDate,ExigenceDegreeID,Content,datumPersonSend.FileName)
//			VALUES('dd',43,'2003-2-1',2,'ddas','dd')
			string strSqlDoc="INSERT INTO datumPersonSend(Title,UserID,SendDate,ExigenceDegreeID,Content,datumPersonSend.FileName)"+
				"VALUES('"+strTitle+"','"+Session["UserId"].ToString ()+"','"+System.DateTime .Now +"','"+ExigenceDegree.SelectedValue +"','"+
				strContent+"','"+strFileName+"')";
			dc=new OI.DatabaseOper.DatabaseConnect ();
			dc.addData (strSqlDoc);
			string strSql="select top 1 DatumID from dbo.datumPersonSend ORDER BY DatumID DESC";
			ArrayList al=dc.getData (strSql);
			int nDatum=0;
			if(al.Count >0)
				nDatum=Convert.ToInt32 (al[0].ToString ());
			for(int i=0;i<strHanders.Length ;i++)
			{
				string sql="insert into datumPersonAccept(DatumID,UserID)"+
						"values('"+nDatum+"','"+strHanders[i]+"')select @@identity ";
				//strSqlMess[i]="INSERT INTO message(SendUserId, ReceiveUserId, DocumentId,FileTable,MessageContent) "+
				//	"VALUES('"+Session["userid"].ToString ()+"','"+strHanders[i]+"','"+nDatum+"','datumPersonAccept','"
				//	+"资料《"+TextBoxTitle.Text+"》需要处理！')";
           
				object o=dc.GetObjectBySql (sql);
     
      
				OI.cs.Message  message=new OI.cs.Message ();
				message.MessageContent ="资料《"+TextBoxTitle.Text+"》需要处理！";
				message.SendUserID =int.Parse (Session["userid"].ToString ());
				message.ReceiveUserID=int.Parse (strHanders[i].ToString ());
				message.ModeName ="接收资料";
				message.ID=int.Parse (o.ToString ()); 
                message.Title =TextBoxTitle.Text;
				message.SendTime=System.DateTime .Now ;
				message.DocumentPath="../PersonSend/RecorderFile.aspx";
				message.ADD ();
			}
			//dc.ExcuteSqls (strSqlAl);
			//dc.ExcuteSqls (strSqlMess);	
			Response.Redirect ("Sent.aspx");
		}
		private string UPFile()
		{
			string strFileNameT=UpFile.Value ;
			if(strFileNameT.Trim ()=="")
			{
				return "";
			}
			HttpPostedFile upfiles=UpFile.PostedFile ;	
			if(upfiles.ContentLength >8388608)//上传文件8M限制
				return "TooBig,,,,,,,,,,,,,,,,,,";
			if (upfiles.ContentLength >0)
			{
				string fileName;
				string path =Server.MapPath(OI.Modules.Config.GetSetting("documents")); //reportAccessories
				try
				{
					
					fileName=OI.Modules.FileName.NewFileName(upfiles.FileName);
					upfiles.SaveAs (path+"\\"+fileName) ;
				}
				catch
				{
					fileName="false";
					//throw new AppException("路径错误:"+path, e);
					
				}
				return fileName;
			}
			else
			{
				return "";
			}
		}

		private void ImageButtonOpen_Click(object sender, System.Web.UI.ImageClickEventArgs e)
		{
			if(FileName.Text .Trim()=="" )
			{
				//ImageButtonOpen.EnableViewState =false;
				return;
			}
			else
			{
				string strURL=OI.Modules .Config .GetSetting ("ReadDocuments").ToString ()+"/"+FileName.Text .Trim ();
				string strScript="<script>"+		
							"window.open ("+strURL+
					",'fj',\"top=100,left=100,toolbar=0,,status=1,menubar=0,scrollbars=1,resizable=1,width=500,height=300\")"+
					"</script>";
				Page.RegisterStartupScript ("",strScript);
			}
		}
	}
}