addbargainfiles.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 HTMS.Web.CompanySysMange.Bargain
{
	/// <summary>
	/// AddBargainFiles 的摘要说明。
	/// </summary>
	public class AddBargainFiles :HTMS.Web.CompanySysMange.BasePage
	{
		protected System.Web.UI.WebControls.DataGrid DataGrid1;
		protected HTMS.Web.AspNetPager.AspNetPager AspNetPager1;
		protected System.Web.UI.WebControls.Label Label2;
		protected System.Web.UI.HtmlControls.HtmlInputButton btAdd;
		protected System.Web.UI.WebControls.TextBox title;
		protected System.Web.UI.HtmlControls.HtmlInputText des;
		protected System.Web.UI.HtmlControls.HtmlGenericControl myfile;
		protected System.Web.UI.HtmlControls.HtmlInputButton Button1;
		protected System.Web.UI.HtmlControls.HtmlInputHidden myid;
	
		private string CompanyID 
		{
			get{return Convert.ToString(this.ViewState["CompanyID"]);}
			set{this.ViewState["CompanyID"]=value;}
		}

		private void Page_Load(object sender, System.EventArgs e)
		{
			if(!Page.IsPostBack)
			{
				if(!base.CheckUser())
				{return ;}
				this.CompanyID=Convert.ToString(this.Session["CompanyID"]);
				this.ShowData();
			}
		}

		private void ShowData()
		{
			this.AspNetPager1.RecordCount=Common.DataPager.GetPageCount("CompanyFiles",this.GetWhereString());
			System.Data.DataTable mytable=Common.DataPager.GetPageData("CompanyFiles","*","FileID",this.AspNetPager1.PageSize,this.AspNetPager1.CurrentPageIndex,0,this.GetWhereString());
			if(mytable==null || mytable.Rows.Count<0)  //如果这里用了== 0那么不能够 改变ViewState 里面的 
			{return;}
			this.DataGrid1.DataSource=mytable;
			this.DataGrid1.DataBind();
			AspNetPager1.CustomInfoText = "记录总数：<font color=\"blue\"><b>" + AspNetPager1.RecordCount.ToString() + "</b></font>";
			AspNetPager1.CustomInfoText += " 总页数：<font color=\"blue\"><b>" + AspNetPager1.PageCount.ToString() + "</b></font>";
			AspNetPager1.CustomInfoText += " 当前页：<font color=\"red\"><b>" + AspNetPager1.CurrentPageIndex.ToString() + "</b></font>";
			this.SetClear();
		}

		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.DataGrid1.ItemCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid1_ItemCommand);
			this.DataGrid1.UpdateCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid1_UpdateCommand);
			this.DataGrid1.DeleteCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid1_DeleteCommand);
			this.DataGrid1.ItemDataBound += new System.Web.UI.WebControls.DataGridItemEventHandler(this.DataGrid1_ItemDataBound);
			this.DataGrid1.SelectedIndexChanged += new System.EventHandler(this.DataGrid1_SelectedIndexChanged);
			this.AspNetPager1.PageChanged += new HTMS.Web.AspNetPager.PageChangedEventHandler(this.AspNetPager1_PageChanged);
			this.btAdd.ServerClick += new System.EventHandler(this.btAdd_ServerClick);
			this.Button1.ServerClick += new System.EventHandler(this.Button1_ServerClick);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void AspNetPager1_PageChanged(object src, HTMS.Web.AspNetPager.PageChangedEventArgs e)
		{
			this.AspNetPager1.CurrentPageIndex=e.NewPageIndex;
			this.AspNetPager1.PageSize=e.NewPageSize;
		}

		private void SetClear()
		{
			this.title.Text="";
			this.des.Value="";
		}
		private void DataGrid1_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
		{
			if(e.Item.ItemType == System.Web.UI.WebControls.ListItemType.Item)
			{
				if(System.Web.HttpUtility.HtmlDecode(e.Item.Cells[3].Text).Trim()=="")
					e.Item.Cells[3].Text="没有文件";
			}
		}

		private void DataGrid1_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			string sqlstring="delete CompanyFiles where FileID = '"+e.Item.Cells[0].Text+"'";
			this.showMessage(HTMS.SQLServerDAL.DAL.DAI.RunSqlNonQuery(sqlstring));
			this.ShowData();
		}

		private void DataGrid1_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			
		}

		private void DataGrid1_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			this.des.Value=this.DataGrid1.SelectedItem.Cells[3].Text;
			this.title.Text=this.DataGrid1.SelectedItem.Cells[2].Text;			
		}

		private void DataGrid1_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			
		}

		private void btAdd_ServerClick(object sender, System.EventArgs e)
		{

			//string myvalue="../../Data/Files/"+Common.Common.GetFiles(this.Server.MapPath("../../Data/Files/"),this.title.Text+".zip");
			//this.myfile.InnerHtml=myvlaue;
			string myvalue=Common.Common.GetFiles(this.Server.MapPath("../../Data/Files/"),this.title.Text+".zip");
			this.showMessage(HTMS.SQLServerDAL.DAL.DAI.RunProcNonQuery("CompanyFilesAdd",Common.GetNextId.getNextID("CompanyFiles","FileID"),this.title.Text,myvalue,this.des.Value,this.CompanyID));            
			this.ShowData();
		}

		private void Button1_ServerClick(object sender, System.EventArgs e)
		{
			//string sqlstring="select * from CompanyFiles where FileName like '%"+this.title.Text.Replace(" ","%")+"%' and FileDes like '%"+this.des.Value.Replace(" ","%")+"%' and CompanyID = '"+this.CompanyID+"'";
			this.ShowData();
		}

		private string GetWhereString()
		{
			System.Text.StringBuilder mybuilder=new System.Text.StringBuilder();
			if(this.title.Text!="")
			{
				mybuilder.Append(" FileName like '%"+this.title.Text.Replace(" ","%")+"%' and ");
			}
			if(this.des.Value!="")
			{
				mybuilder.Append(" FileDes like '%"+this.des.Value.Replace(" ","%")+"%' and ");
			}
			mybuilder.Append(" CompanyID = '"+this.CompanyID+"' ");
			return mybuilder.ToString();
		}
	}
}