sent.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;
using System.IO ;

namespace OI.PersonSend
{
	/// <summary>
	/// Sent 的摘要说明。
	/// </summary>
	public class Sent : System.Web .UI .Page 
	{
		protected System.Web.UI.WebControls.TextBox TextBoxTitle;
		protected System.Web.UI.WebControls.ImageButton ImageButton2;
		protected System.Web.UI.WebControls.DataGrid dg;
		protected System.Web.UI.WebControls.ImageButton ImageButtonADD;
		protected System.Web.UI.WebControls.ImageButton ImageButtonDel;
		private OI.DatabaseOper .DatabaseConnect dc;
		protected System.Web.UI.WebControls.ImageButton ImageButtonSelectAll;
		protected ZHENGYI.DataGridNavigation divepage;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			if (Session["userid"]==null)
			{
				Response.Write ("<script>alert('超时,请重新登录');top.location.href='../userpass.aspx';</script>");
				return ;
			}
			SetDivePage();
			if(!this.IsPostBack )
			{
				this.DataBindNew ();
			}
		}
		private void SetDivePage()
		{
			dg.AllowPaging =true; 
			dg.PageSize =15; 
			
			ZHENGYI.BindDataDelegate f =new ZHENGYI.BindDataDelegate (DataBindNew);//修改这个dataBind,让f 指向你的方法。 
			divepage.SetTarget(dg,f,15);
		}
		private void DataBindNew()
		{
			if(Session["userID"]==null||Session["userID"].ToString ()=="")
			{
				Page.RegisterStartupScript ("","<script>alert(\"连接超时，请重新登录！\")</script>");
				return;
			}
			dc=new OI.DatabaseOper.DatabaseConnect ();
			string sql="SELECT DPA.DatumID,DPA.Title,DPA.SendDate,ED.ExigenceDegreeName,DPA.FileName FROM datumPersonSend AS DPA,ExigenceDegree AS ED "+
				"WHERE DPA.ExigenceDegreeID=ED.ExigenceDegreeID and DPA.isdel=0 AND UserID='"+Session["userID"].ToString ()+"' "+
				"ORDER BY DPA.SendDate DESC";
			DataSet ds=dc.getBinding (sql,"tableAA");
			
			dg.DataSource =ds.Tables ["tableAA"].DefaultView ;
			dg.DataBind ();
		}


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

		}
		#endregion

		private void dg_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
		{
			if(e.Item .ItemType !=ListItemType.Footer && e.Item .ItemType !=ListItemType.Header )
			{//	e.Item .Cells [5].Text ="<a href=\"DoStatus.aspx?id="+e.Item.Cells[0].Text+"\"><img src=\"../images/yi.gif.gif\" border=\"0\" alt=\"处理情况\"></a>";
				dc=new OI.DatabaseOper.DatabaseConnect ();
			
				string sql="SELECT  count(*) FROM dbo.datumPersonAccept WHERE IsAccept=0 and DatumID="+e.Item .Cells [0].Text ; 				
				int number =int.Parse (dc.GetValueBySql (sql));

				if(number <1 )
				{
					e.Item .Cells [5].Text ="<a href=\"DoStatus.aspx?id="+e.Item.Cells[0].Text+"\"><img src=\"../images/yi.gif.gif\" border=\"0\" alt=\"已签收完毕\"></a>";
				}
				else
					e.Item .Cells [5].Text ="<a href=\"DoStatus.aspx?id="+e.Item.Cells[0].Text+"\"><img src=\"../images/wei.gif.gif\" border=\"0\" alt=\"还未全部签收\"></a>";
			}
		}
		private void ImageButtonDel_Click(object sender, System.Web.UI.ImageClickEventArgs e)
		{
			string id=""; 
			int i=0;
			ArrayList alFile=new ArrayList ();
			foreach(DataGridItem  li in this.dg.Items) 
			{				
				if(((CheckBox)li.FindControl("CheckBoxId")).Checked) 
				{
					i++;
					if(i==1)
						id+=" DatumID="+li.Cells[0].Text.ToString();//
					if(i>1)
						id+=" OR DatumID="+li.Cells[0].Text.ToString();
					string strTemp=li.Cells [6].Text.Trim ();
					if(strTemp!=""&&strTemp!="&nbsp;")
					{
						alFile.Add (strTemp);
					}
				}
			}
			if(i==0)
				return;
			else 
			{	
				string strURL=Server.MapPath (OI.Modules .Config .GetSetting ("documents").ToString ())+"\\";
				dc=new OI.DatabaseOper.DatabaseConnect ();
			    string sql=" select id from  datumPersonAccept where "+id;
				ArrayList alid=dc.getData (sql);
				for ( int ii=0; ii<alid.Count ;ii++)
				{
				  cs.Message message=new OI.cs.Message ();
					try
					{
						message.deleteMessage (int.Parse (Session["userid"].ToString ()),int.Parse (alid[ii].ToString ()),"接收资料");
					}
					catch (Exception er)
					{
						Response.Write (er.Message );
					}
				}
			     
				 sql="DELETE FROM datumPersonAccept WHERE "+id;
			 
				dc.deleteData (sql);
				sql="DELETE FROM datumPersonSend WHERE "+id;
				dc.deleteData (sql);
				dg.CurrentPageIndex =0;
				DataBindNew();
				for(i=0;i<alFile.Count ;i++)
				{
					string strFile=strURL+alFile[i].ToString ();
					if(File.Exists (strFile))
					{
						try
						{
							File.Delete (strFile);
						}
						catch
						{
						}
					}
				}
			} 

			this.DataBindNew ();
		}

		private void ImageButtonADD_Click(object sender, System.Web.UI.ImageClickEventArgs e)
		{
			Response.Redirect ("AddEdit.aspx?id=-1");
		}

		private void ImageButtonSelectAll_Click(object sender, System.Web.UI.ImageClickEventArgs e)
		{
			foreach (TableRow tr in dg.Items )
			{
				CheckBox CheckBoxId=(CheckBox)tr.FindControl ("CheckBoxId");
				if (CheckBoxId !=null)
				{
					CheckBoxId.Checked =true;
				}
			}
		}
		

	
	}
}