recorderfile.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>
	/// RecorderFile 的摘要说明。
	/// </summary>
	public class RecorderFile : OI.PageBase 
	{
		protected System.Web.UI.WebControls.DataGrid dg;
		protected System.Web.UI.WebControls.ImageButton ImageButtonDel;
		private OI.DatabaseOper .DatabaseConnect dc;
		protected System.Web.UI.WebControls.ImageButton ImageButtonDO;
		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 ;
			}
			ImageButtonDel.Attributes["onclick"]="return confirm('你是否确定拒签?');";
			this.SetDivePage ();
			if(!this.IsPostBack )
			{
				this.BindDataNew ();
			}
		}
		private void BindDataNew()
		{
			if (Session["userid"]==null)
			{
				Response.Write  ("<script>top.location.href='../userpass.aspx'</script>");
				return;
			}					
			string sql="SELECT datumPersonAccept.ID,datumPersonAccept.DatumID,dbo.datumPersonSend.Title, dbo.datumPersonSend.SendDate, "+
						"dbo.Accounts_Users.UserName, dbo.ExigenceDegree.ExigenceDegreeName "+
						"FROM dbo.datumPersonAccept,dbo.datumPersonSend,dbo.Accounts_Users,dbo.ExigenceDegree  "+
						"WHERE dbo.datumPersonAccept.DatumID = dbo.datumPersonSend.DatumID and "+
						"dbo.datumPersonSend.UserID = dbo.Accounts_Users.UserID and "+
						"dbo.datumPersonSend.ExigenceDegreeID = dbo.ExigenceDegree.ExigenceDegreeID and "+	
						"dbo.datumPersonAccept.isAccept=0 and "+	
						"dbo.datumPersonAccept.UserID='"+Session["userid"].ToString ()+"' "+
						"ORDER BY dbo.datumPersonSend.SendDate DESC";
			dc=new OI.DatabaseOper.DatabaseConnect ();
			DataSet ds=dc.getBinding (sql,"t1");
			dg.DataSource =ds.Tables ["t1"].DefaultView ;
			dg.DataBind ();
		}
		private void SetDivePage()
		{
			dg.AllowPaging =true; 
			dg.PageSize =15; 
			
			ZHENGYI.BindDataDelegate f =new ZHENGYI.BindDataDelegate (BindDataNew);//修改这个dataBind,让f 指向你的方法。 
			divepage.SetTarget(dg,f,15);
		}

		#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.ImageButtonDO.Click += new System.Web.UI.ImageClickEventHandler(this.ImageButtonDO_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 [1].Text ="<a href=\"OneFile.aspx?id="+e.Item .Cells [7].Text +"\">"+e.Item .Cells[1].Text +"</a>"; 
					e.Item .Cells [5].Text ="<a href=\"addEdit.aspx?id="+e.Item .Cells [7].Text +"\"><img src=\"../images/zhuanfa.gif\" border=\"0\"></a>";
			}
		}

		private void ImageButtonDO_Click(object sender, System.Web.UI.ImageClickEventArgs e)
		{			
			ArrayList alWhere=new ArrayList ();
			foreach(DataGridItem  li in this.dg.Items) 
			{				
				if(((CheckBox)li.FindControl("CheckBoxId")).Checked) 
				{
					alWhere.Add (li.Cells[0].Text.ToString());									
				}
			}
			string []sql=new string [alWhere.Count];
			for(int i=0;i<alWhere.Count ;i++)
			{
				sql[i]="update datumPersonAccept set isaccept=1,acceptdate='"+System.DateTime .Now +"' where id="+alWhere[i].ToString ().Trim ();
		    	cs.Message message=new OI.cs.Message ();
			    message.finishOprate (int.Parse (Session["userid"].ToString ()),int.Parse (alWhere[i].ToString ().Trim ()),"接收资料");

			}
			dc=new OI.DatabaseOper.DatabaseConnect ();
			dc.ExcuteSqls (sql);
			this.BindDataNew ();
			Response.Redirect("OutDoneFile.aspx",true);
		
			
			
		}

		private void ImageButtonDel_Click(object sender, System.Web.UI.ImageClickEventArgs e)
		{
			dc=new OI.DatabaseOper.DatabaseConnect ();
			string username=dc.GetValueBySql ("select username from accounts_users where userid="+Session["userid"]);
			ArrayList alWhere=new ArrayList ();
			foreach(DataGridItem  li in this.dg.Items) 
			{				
				if(((CheckBox)li.FindControl("CheckBoxId")).Checked) 
				{
					alWhere.Add (li.Cells[0].Text.ToString());									
				}
			}
			string []sqls=new string [alWhere.Count];
			for(int i=0;i<alWhere.Count ;i++)
			{
				string sql=" select userid,Title from datumpersonsend ds where datumid=(select datumid from datumpersonaccept da where id="+alWhere[i].ToString ()+" )";
				DataSet dss=new DataSet ();
				
				dss=dc.getBinding (sql,"t");
				sqls[i]="update datumPersonAccept set isaccept=1,disalow=1, acceptdate='"+System.DateTime .Now +"' where id="+alWhere[i].ToString ().Trim ();
				if (dss.Tables[0].Rows .Count >0)
				{
					DataRow dr=dss.Tables[0].Rows[0];
//					sqls[i,1]="INSERT INTO message(SendUserId, ReceiveUserId, FileTable,MessageContent) "+
//						"VALUES("+Session["userid"].ToString ()+","+dr["userid"].ToString ()+",'datumPersonAccept','"
//						+"资料《"+dr["Title"].ToString ()+"》己被 "+username +" 拒签！')";
                    cs.Message message=new OI.cs.Message ();
				    message.finishOprate (int.Parse (Session["userid"].ToString ()),int.Parse (alWhere[i].ToString ().Trim ()),"接收资料");
					message.ID =int.Parse (alWhere[i].ToString ().Trim ());
					message.Title =dr["Title"].ToString ();
					message.MessageContent ="资料《"+dr["Title"].ToString ()+"》己被 "+username +" 拒签！";
					message.ModeName ="发送资料";
					message.messageType =cs.Message .MessageType .MessageOnly ;
					message.SendUserID =int.Parse (Session["userid"].ToString ());
					message.ReceiveUserID =int.Parse (dr["userid"].ToString ());
					message.SendTime =System.DateTime .Now ;
					message.AddMessageOnly  ();


				}
				dss=null;
			   	
			}
		//	dc=new OI.DatabaseOper.DatabaseConnect ();
			dc.ExcuteSqls (sqls);
			this.BindDataNew ();
		}

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