companyrellist.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.CompanyInfo
{
	/// <summary>
	/// CompanyRelList 的摘要说明。
	/// </summary>
	public class CompanyRelList :HTMS.Web.CompanySysMange.BasePage
	{
		protected System.Web.UI.WebControls.DropDownList companyclass;
		protected System.Web.UI.WebControls.DataGrid DataGrid1;
		protected System.Web.UI.WebControls.Label Label1;
		protected HTMS.Web.AspNetPager.AspNetPager AspNetPager1;
		protected System.Web.UI.HtmlControls.HtmlInputText name;
		protected System.Web.UI.HtmlControls.HtmlInputText startdate;
		protected System.Web.UI.HtmlControls.HtmlInputText enddate;
		protected System.Web.UI.HtmlControls.HtmlInputText companydes;
		protected System.Web.UI.HtmlControls.HtmlInputButton Submit2;
		protected System.Web.UI.HtmlControls.HtmlInputButton Submit1;
	
		private string CompanyID
		{
			get {return Convert.ToString(this.ViewState["CompanyID"]);}
			set{this.ViewState["CompanyID"]=value;}
		}

		private void Page_Load(object sender, System.EventArgs e)
		{
			this.ClearCache();
			if(!Page.IsPostBack)
			{
				if(!base.CheckUser())
				{
					return ;
				}
				else
				{
					CompanyID=Convert.ToString(this.Session["CompanyID"]);
					this.ShowClass();
				}
			}
		}
		
		protected void ClearCache()
		{
			this.Response.Expires=-1;
			this.Response.ExpiresAbsolute=DateTime.Now.AddSeconds(-1);
			this.Response.CacheControl="no-cache";
		}

		private void ShowClass()
		{
			System.Data.DataTable mytable=HTMS.SQLServerDAL.DAL.DAI.RunProcTable("CompanyRelClass_GetIDNameByCompanyID",this.CompanyID);
			if(mytable!=null || mytable.Rows.Count<=0)
			{return;}
			else
			{
				this.companyclass.DataTextField="RelClassName";
				this.companyclass.DataValueField="RelClassID";
				this.companyclass.DataSource=mytable;
				this.companyclass.DataBind();
				this.companyclass.Items.Insert(0,new System.Web.UI.WebControls.ListItem("未选择","-1"));
			}
		}
		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.AspNetPager1.PageChanged += new HTMS.Web.AspNetPager.PageChangedEventHandler(this.AspNetPager1_PageChanged);
			this.Submit2.ServerClick += new System.EventHandler(this.Submit2_ServerClick);
			this.Submit1.ServerClick += new System.EventHandler(this.Submit1_ServerClick);
			this.DataGrid1.ItemCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid1_ItemCommand);
			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.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

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

		private void DataGrid1_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
		{
			if(e.Item.ItemType==System.Web.UI.WebControls.ListItemType.Item)
			{
				System.Web.UI.WebControls.LinkButton temp=((System.Web.UI.WebControls.LinkButton)e.Item.Cells[6].Controls[0]);
				temp.Attributes.Add("onclick","return window.confirm('你确定要删除吗?');");
			}
		}

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

		private void ShowData()
		{
			string wherestring=this.GetWhereString();
			this.AspNetPager1.RecordCount=Common.DataPager.GetPageCount("CompanyInfo",wherestring);
			System.Data.DataTable mytable=Common.DataPager.GetPageData("CompanyInfo","CompanyID,CompanyName,Web,Mail,TelPhone","CompanyID",this.AspNetPager1.PageSize,this.AspNetPager1.CurrentPageIndex,0,wherestring);
			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>";
		}	
		private string GetWhereString()
		{
			System.Text.StringBuilder mybuilder=new System.Text.StringBuilder();
			if(this.name.Value.Trim()!="")
			{
				mybuilder.Append(" CompanyName like '%"+name.Value.Replace(" ","%")+"%' and ");
			}
			if(this.companyclass.SelectedValue!="-1")
			{
				mybuilder.Append(" CompanyClassRelID = '"+this.companyclass.SelectedValue+"' and ");
			}
			if(this.startdate.Value!="" && this.enddate.Value!="")
			{
				mybuilder.Append(" RegDate between '"+this.startdate.Value+"' and '"+this.enddate.Value+"' and ");
			}
			if(this.companydes.Value!="")
			{
				mybuilder.Append(" DesText like '%"+this.companydes.Value.Replace(" ","%")+"%' and ");
			}
			mybuilder.Append("FatherCompanyID = '"+this.CompanyID+"'");
			return mybuilder.ToString();
		}
		private void DataGrid1_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			string myid=e.Item.Cells[0].Text;
			HTMS.SQLServerDAL.DAL.DAI.RunProcNonQuery("CompanyInfo_DeleteByIDS",myid,this.CompanyID);
		}

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

		private void Submit2_ServerClick(object sender, System.EventArgs e)
		{
			this.Response.Redirect("CompanyInfo.aspx");
		}
	}
}