listview.aspx.cs

除了具有传统OA的邮件、工作流、文档等功能外

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.Data.OleDb;
using UDS.Components;
using System.Data.SqlClient;

namespace UDS.SubModule.Query
{
	/// <summary>
	/// Listview 的摘要说明。
	/// </summary>
	public partial class Listview : System.Web.UI.Page
	{
		protected string keyString;
		protected int Range;
		protected int SearchType;
		protected string UserName;
		protected void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			keyString	 = (Request.QueryString["key"]!=null)?Request.QueryString["key"].ToString():"";			
			UserName	 = Request.Cookies["Username"].Value.ToString();
			Range		 = Int32.Parse((Request.QueryString["Range"]!=null)?Request.QueryString["Range"].ToString():"0");			
			SearchType   = Int32.Parse((Request.QueryString["SearchType"]!=null)?Request.QueryString["SearchType"].ToString():"0");			
			if(!IsPostBack)
			{	
				BindGrid();				
			}

		}
		#region 数据绑定至DataGrid
		/// <summary>
		/// 将某用户的邮件取出绑定至DataGrid
		/// </summary>
		protected void BindGrid() 
		{   
			Database mySQL = new Database();	
			/*
			 *=========================================			  
			 *				处理文档			 
			 *========================================= 			 
			 */
			
			if((SearchType & 0x01)==0x01)
			{
				dgDocList.Visible = true;
				if((Range & 0x08) ==0x08)
				{
					FileSearch("UDS_Doc");			
				}
			
					
				SqlParameter[] parameters = {
												mySQL.MakeInParam("@UserName",SqlDbType.VarChar,300,UserName),
												mySQL.MakeInParam("@KeyString",SqlDbType.VarChar,300,keyString),
												mySQL.MakeInParam("@SearchRange",SqlDbType.Int, 4,Range),
												mySQL.MakeInParam("@ViewDocRightCode",SqlDbType.Int, 4,10),
												mySQL.MakeInParam("@Inherit",SqlDbType.Bit ,1,0)
											};
				SqlDataReader dr; //存放人物的数据	
				mySQL.RunProc("sp_FindDoc",parameters,out dr);
				
				DataTable dt =Tools.ConvertDataReaderToDataTable(dr);
				dr.Close();


				dgDocList.DataSource = dt.DefaultView;
				dgDocList.DataBind();

			}
			else
			{
				dgDocList.Visible	= false;
				tabDoc.Visible		= false;
			}

			/*
			 *=========================================			  
			 *				处理邮件			 
			 *========================================= 
			 */
			if((SearchType & 0x02)==0x02)
			{
				dgMailList.Visible = true;									
				if((Range & 0x08) ==0x08)
				{
					FileSearch("UDS_Mail");			
				}			
					
				SqlParameter[] parameters = {
												mySQL.MakeInParam("@UserName",SqlDbType.VarChar,300,UserName),
												mySQL.MakeInParam("@KeyString",SqlDbType.VarChar,300,keyString),
												mySQL.MakeInParam("@SearchRange",SqlDbType.Int, 4,Range)
											};
				SqlDataReader dr; //存放人物的数据					
				mySQL.RunProc("sp_FindMail",parameters,out dr);
				
				DataTable dt = Tools.ConvertDataReaderToDataTable(dr);
				dr.Close();


				dgMailList.DataSource = dt.DefaultView;
				dgMailList.DataBind();
			
			}
			else
			{
				tabMail.Visible		= false;
				dgMailList.Visible	= false;
			}

		} 
		
		#endregion
		private void FileSearch(string catalog)
		{
			Database mySQL				= new Database();	
			DataSet ds					= new DataSet();			
			String myConnStr			= "Provider=MSIDXS; Data Source=" + catalog+ ";";
			String mySql				= "SELECT FileName, Path, Characterization, Rank, Create, Size FROM SCOPE() WHERE CONTAINS ('" + keyString + "')> 0";
			OleDbConnection myConn		= new OleDbConnection(myConnStr);

			OleDbDataAdapter myAdapter	= new OleDbDataAdapter(mySql,myConn);
			try
			{
				myAdapter.Fill(ds,"Search");
			}
			catch (Exception ex)
			{
				UDS.Components.Error.Log(ex.ToString());
				Server.Transfer("../Error.aspx");
			}
			finally
			{
				myAdapter =null;
				myConn.Close();
				myConn = null;
			}			
				
			
			for(int i=0;i<ds.Tables["Search"].Rows.Count;i++)
			{
				DataRow myDr;
				myDr = ds.Tables["Search"].Rows[i];

				SqlParameter[] pparameters = {												
													mySQL.MakeInParam("@FileName",SqlDbType.VarChar,300,myDr["FileName"]),
													mySQL.MakeInParam("@Path",SqlDbType.VarChar,300,myDr["Path"].ToString().Replace(Server.MapPath("..\\UnitiveDocument\\Document").Replace("/","\\").ToLower()  ,"") ),
													mySQL.MakeInParam("@Characterization",SqlDbType.NText ,10000,myDr["Characterization"] ),
													mySQL.MakeInParam("@Rank",SqlDbType.VarChar,300,myDr["Rank"]),
													mySQL.MakeInParam("@Create",SqlDbType.DateTime ,10,myDr["Create"]),
													mySQL.MakeInParam("@Size",SqlDbType.Int,4,myDr["Size"])
												};
				mySQL.RunProc("sp_AddScope",pparameters);
			}


		}

		#region 翻页事件
		public void DataGrid_PageChanged(object sender,DataGridPageChangedEventArgs e)
		{
			dgDocList.CurrentPageIndex = e.NewPageIndex;
			BindGrid();
		}
		#endregion

		public string GetUserRealName(string UserStr)
		{
			return UDS.Components.Staff.GetRealNameStrByUsernameStr(UserStr,1);
		}

		#region Web Form Designer generated code
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN：该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    

		}
		#endregion
	}
}