companylist.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.SysManage.CompanyManage
{
	/// <summary>
	/// CompanyList 的摘要说明。
	/// </summary>
	public class CompanyList : HTMS.Web.CompanySysMange.BasePage
	{
		protected HTMS.Web.AspNetPager.AspNetPager AspNetPager1;
		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.HtmlInputText name;
		protected System.Web.UI.HtmlControls.HtmlInputButton Submit1;
		protected System.Web.UI.WebControls.Label Label1;
		protected System.Web.UI.HtmlControls.HtmlInputText Text1;
		protected System.Web.UI.WebControls.DataGrid DataGrid1;
		protected System.Web.UI.HtmlControls.HtmlInputButton Submit3;
		protected System.Web.UI.WebControls.DropDownList state;
		protected System.Web.UI.WebControls.DropDownList companyclass;
		protected System.Web.UI.HtmlControls.HtmlInputButton Submit2;
	
		private string WhereString
		{
			get{return Convert.ToString(this.ViewState["WhereString"]);}
			set{this.ViewState["WhereString"]=value;}
		}
		private string CompanyID
		{
			get{return Convert.ToString(this.ViewState["CompanyID"]);}
			set{this.ViewState["CompanyID"]=value;}
		}
		private void Page_Load(object sender, System.EventArgs e)
		{
			ClearCache();	
			if(!base.UserPageCheck())
			{return;}
			if(!Page.IsPostBack)
			{
				if(!base.UserPageCheck())
				{
					return;
				}
				else
				{
					this.CompanyID=this.Session["CompanyID"].ToString();
					this.ShowCompanyClass();
					this.ShowData();				
				}
			}
		}
		protected void ClearCache()
		{
			this.Response.Expires=-1;
			this.Response.ExpiresAbsolute=DateTime.Now.AddSeconds(-1);
			this.Response.CacheControl="no-cache";
		}

		private void ShowCompanyClass()
		{
			System.Data.DataTable mytable=HTMS.SQLServerDAL.DAL.DAI.RunProcTable("CompanyClass_GetClassIDName");
			if(mytable==null || mytable.Rows.Count<=0)
				return;
			this.companyclass.DataTextField="CompanyClassName";
			this.companyclass.DataValueField="CompanyClassID";
			this.companyclass.DataSource=mytable;
			this.companyclass.DataBind();
			this.companyclass.Items.Insert(0,new System.Web.UI.WebControls.ListItem("为选择","-1"));
			this.companyclass.SelectedIndex=-1;
		}

		private void ShowData()
		{
			this.AspNetPager1.RecordCount=Common.DataPager.GetPageCount("CompanyInfo",this.GetWhereString());
			System.Data.DataTable mytable=Common.DataPager.GetPageData("CompanyInfo","CompanyID,CompanyName,IsFreeze,Web,Mail,TelPhone","CompanyID",this.AspNetPager1.PageSize,this.AspNetPager1.CurrentPageIndex,0,this.GetWhereString());
			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>";
		}

		#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_1);
			this.DataGrid1.DeleteCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid1_DeleteCommand);
			this.DataGrid1.ItemDataBound += new System.Web.UI.WebControls.DataGridItemEventHandler(this.DataGrid1_ItemDataBound_1);
			this.AspNetPager1.PageChanged += new HTMS.Web.AspNetPager.PageChangedEventHandler(this.AspNetPager1_PageChanged);
			this.Submit3.ServerClick += new System.EventHandler(this.Submit3_ServerClick);
			this.Submit1.ServerClick += new System.EventHandler(this.Submit1_ServerClick);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void DataGrid1_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			string sqlstring="update CompanyInfo Set Param='0' where CompanyID = '"+e.Item.Cells[0].Text+"'";
			this.ShowMessage(HTMS.SQLServerDAL.DAL.DAI.RunSqlNonQuery(sqlstring));
			this.ShowData();
		}
		private void ShowMessage(int count)
		{
			if(count<=0)
			{
				Common.Common.ShowMessageBox("操作失败");
			}
			else
				Common.Common.ShowMessageBox("操作成功");
		}

		private void DataGrid1_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
		{
			
		}

		private string GetWhereString()
		{
			string flag=" and ";
			System.Text.StringBuilder mybuilder=new System.Text.StringBuilder();

			if(this.name.Value.Trim()!="" )
			{
				mybuilder.Append("CompanyName like '%"+this.name.Value.Replace(' ','%')+"%' and ");				
				//flag=" and ";
			}
			if(this.state.SelectedValue!="-1")
			{
				 mybuilder.Append("IsFreeze = '"+this.state.SelectedValue+"' "+flag);
				//flag=" and ";
			}
			if(this.companyclass.SelectedValue!="-1")
			{
				mybuilder.Append("CompanyClassID like '%"+this.companyclass.SelectedValue.Replace(' ','%')+"%'"+flag);
				//flag=" and ";
			}
			if(this.startdate.Value.Trim()!="" && enddate.Value.Trim()!="")
			{
				mybuilder.Append("RegDate between '"+this.startdate.Value+"' and '"+this.enddate.Value+"' "+flag);
				//flag=" and ";
			}
			else
			{
				if(this.startdate.Value.Trim()!="")
				{
					mybuilder.Append("RegDate > '"+this.startdate.Value+"' "+flag);
					//flag=" and ";
				}
				if(this.enddate.Value.Trim()!="")
				{
					mybuilder.Append("RegDate < '"+this.enddate.Value+"' "+flag);
					//flag=" and ";
				}
			}
			if(this.companydes.Value.Trim()!="")
			{
				mybuilder.Append("DesText like '%"+this.companydes.Value.Replace(' ','%')+"%' "+flag);
				//flag=" and ";
			}
			mybuilder.Append(" Param = '1' and FatherCompanyID='"+this.CompanyID+"' ");
			this.Label1.Text=mybuilder.ToString();
			return mybuilder.ToString();
		}

		private void Submit1_ServerClick(object sender, System.EventArgs e)
		{
			//this.Response.Write("<font color=red>"+this.GetWhereString()+"</font>");
			this.Label1.Text=this.GetWhereString();;
			//this.WhereString=this.GetWhereString();
			this.ShowData();
		}

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

		private void DataGrid1_ItemCommand_1(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
		
			if(e.CommandName=="freeze")
			{
				System.Web.UI.WebControls.LinkButton temp=(System.Web.UI.WebControls.LinkButton)e.CommandSource;
				string isFreeze="";
				string text=temp.Text.Trim();
				if(temp.Text.Trim()=="点击冻结")
				{
					isFreeze="1";
					temp.Text="点击解冻";
				}
				else
				{
					isFreeze="0";
					temp.Text="点击冻结";
				}
				string sqlstring="update CompanyInfo set IsFreeze='"+isFreeze+"' where CompanyID='"+e.Item.Cells[0].Text.Trim()+"'";	
				int count=HTMS.SQLServerDAL.DAL.DAI.RunSqlNonQuery(sqlstring);
				if(count<=0)
				{
					Common.ShowMessageBox.ShowMessage("操作错误!");
					temp.Text=text;
				}
				else
				{
					//Common.ShowMessageBox.ShowMessage("操作成功!");
				}
			}
			if(e.CommandName =="name")
			{
				string url="CompanyInfo_main.aspx?CompanyID="+e.Item.Cells[0].Text;
				Common.Windows.OpenWindow(this,url,500,500,400,500,"yes");
			}
		}

		private void DataGrid1_ItemDataBound_1(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[7].Controls[0]);
				temp.Attributes.Add("onclick","return window.confirm('你确定要删除吗?');");
			}
		}

		private void showMessage(int count)
		{
			if(count<=0)
			{
				Common.Common.ShowMessageBox("操作失败");
			}
			else
			{
				Common.Common.ShowMessageBox("操作成功");
			}
		}

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