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 DocAdmin.BLL ;
using DocAdmin.COMMON ;
using DocAdmin.DAL ;

namespace DocAdmin.USL
{
	/// <summary>
	/// FileSearch 的摘要說明。
	/// </summary>
	public class FileSearch : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.TextBox tb_FileName;
		protected System.Web.UI.WebControls.TextBox tb_Keyword;
		protected System.Web.UI.WebControls.DropDownList ddl_type;
		protected System.Web.UI.WebControls.Label Label1;
		protected System.Web.UI.WebControls.Label Label2;
		protected System.Web.UI.HtmlControls.HtmlImage Img1;
		protected System.Web.UI.WebControls.TextBox tb_USER;
		protected System.Web.UI.WebControls.TextBox tb_DTFROM;
		protected System.Web.UI.WebControls.TextBox tb_DTTO;
		protected System.Web.UI.HtmlControls.HtmlImage Img2;
		protected System.Web.UI.WebControls.TextBox tb_Content;
		protected System.Web.UI.WebControls.DataGrid dgResult;
		protected System.Web.UI.WebControls.Button b_Search;
		private DataTable dtResult = null ;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			dtResult = (DataTable)Session["dtResult"] ;
			if(dtResult == null)
			{
				dtResult = new DataTable() ;
			}
		
			if(!IsPostBack)
			{
				//初始化文件類型下拉框
				CommHandler.DDL_Init(this.ddl_type,"Doc_FileType_GetForDDL",null,true) ;
			}
			CommHandler.BindGrid(this.dgResult,this.dtResult) ;
		}

		#region Web 窗體設計器生成的代碼
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 該調用是 ASP.NET Web 窗體設計器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 設計器支持所需的方法 - 不要使用代碼編輯器修改
		/// 此方法的內(nèi)容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.b_Search.Click += new System.EventHandler(this.b_Search_Click);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void b_Search_Click(object sender, System.EventArgs e)
		{
			//檢索條件
			string fileName = this.tb_FileName.Text.Trim() ;
			string keyword = this.tb_Keyword.Text.Trim() ;
			string content = this.tb_Content.Text.Trim() ;
			string type = this.ddl_type.SelectedValue ;
			string crusr = this.tb_USER.Text.Trim() ;
			string dtFrom = this.tb_DTFROM.Text;
			string dtTo = this.tb_DTTO.Text ;
			//如果輸入全部為空
			if(fileName=="" && keyword=="" && content=="" && type=="" && crusr=="" && dtFrom=="" && dtTo=="")
			{
				CommHandler.Alert(Page,"請輸入搜索條件！") ;
			}

			//拼寫搜索文件的SQL文
			string sql = "SELECT F.FileName,D.FolderName,T.FTYPE_Ch FILETYPE,"
				+ " CONVERT(VARCHAR(11),F.CRDT,120) CRDT,U.USERName "
				+ " FROM Doc_FileInfo F,Doc_FolderInfo D,Doc_FileType T,Doc_User U "
				+ " WHERE F.FolderID = D.FolderID "
				+ " AND F.Type = T.TypeID "
				+ " AND F.UserID = U.UserID " ;

			//文件名條件非空
			if(fileName != "")
			{
				sql += "AND F.FileName LIKE '%" + fileName + "%' " ;
			}
			//關鍵字條件非空
			if(keyword != "")
			{
				sql += " AND F.Keyword LIKE '%" + keyword + "%' " ;
			}
			//文檔內(nèi)容條件非空，注意噪聲詞
			if(content != "")
			{
				sql += " AND F.FileID IN "
					+ " (SELECT FileID FROM Doc_FileAtt,FREETEXTTABLE(Doc_FileAtt,Content,'" + content + "')"
					+ " SearchTable WHERE [KEY]=Doc_FileAtt.AttFileID AND F.FileID=Doc_FileAtt.FileID ) " ;
			}
			//文件類型非空
			if(type != "")
			{
				sql += " AND F.Type='" + type + "' " ;
			}
			//創(chuàng)建者非空
			if(crusr != "")
			{
				sql += " AND U.UserName like '%" + crusr + "%'" ;
			}
			//時間條件
			if(dtFrom != "")
			{
				sql += " AND CONVERT(VARCHAR(11),F.CRDT,120)>='" + dtFrom + "'" ;
			}
			if(dtTo != "")
			{
				sql += " AND CONVERT(VARCHAR(11),F.CRDT,120)>='" + dtTo + "'" ;
			}

			//直接調用數(shù)據(jù)訪問層的方法
			dtResult = DataAccess.ExecuteDataTable_Sql(sql) ;
			Session["dtResult"] = dtResult ;
			//綁定表格數(shù)據(jù)
			CommHandler.BindGrid(this.dgResult,this.dtResult) ;
			
		}
	}
}