addeditt.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;

namespace OI.PersonSend
{
	/// <summary>
	/// addeditT 的摘要说明。
	/// </summary>
	public class addeditT : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.Label DispTitle;
		protected System.Web.UI.WebControls.TextBox TextBoxTitle;
		protected System.Web.UI.WebControls.DropDownList ExigenceDegree;
		protected System.Web.UI.WebControls.TextBox TextBoxContent;
		protected System.Web.UI.WebControls.ImageButton ImageButtonSend;
		protected System.Web.UI.WebControls.TextBox TextBoxID;
		protected System.Web.UI.HtmlControls.HtmlInputText Handers;
		protected System.Web.UI.HtmlControls.HtmlInputHidden HandersID;
        private OI.DatabaseOper .DatabaseConnect dc;
		private void InitializeComponent()
		{
			this.ImageButtonSend.Click += new System.Web.UI.ImageClickEventHandler(this.ImageButtonSend_Click);
			this.Load += new System.EventHandler(this.Page_Load);

		}

		private void ImageButtonSend_Click(object sender, System.Web.UI.ImageClickEventArgs e)
		{
			try
			{
				string strTitle=TextBoxTitle.Text .Trim ().Replace ("'","’");
				string strContent=TextBoxContent.Text.Replace ("'","’");
				string strFileName="";
				personDatum per=new personDatum ();
				strFileName=per.GetSavePathByID (int.Parse (ViewState["id"].ToString ())) ;
                  
				if(strTitle=="")
				{
					Page.RegisterStartupScript ("","<script>alert(\"标题不能为空\")</script>");
					return;
				}
				if(HandersID.Value .Trim ().Length ==0)
				{
					Page.RegisterStartupScript ("","<script>alert(\"接收人不能为空\")</script>");
					return;
				}
				string [] strHanders=HandersID.Value .Trim ().Split (new char[]{','});
				string [] strSqlAl=new string [strHanders.Length ];
				string [] strSqlMess=new string [strHanders.Length ];
			
	
				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 ";
			
           
					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");
			}
			catch(Exception er)
			{
				Response.Write (er.Message );
			}


		}
	
		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 (!Page.IsPostBack )
			{
				try
				{
					int id=int.Parse (Request.Params ["id"].ToString ());
					ViewState["id"]=id.ToString ();
				}
				catch
				{
					return ;
				}
				BindExigence();
				CreateDataSource();
			}
		}
		private void CreateDataSource()
		{
			personDatum dt=new personDatum ();
			DataRow dr=dt.GetRowSaveDataByID (int.Parse (ViewState["id"].ToString ()));
			TextBoxTitle.Text =dr["title"].ToString ();
			
			TextBoxContent.Text =dr["content"].ToString ();
		
		}
		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>
		
		#endregion
	}
}