companymanages.aspx.cs

很不错的公文流转系统

/**************************************************************************************
作者：Created By zhouzheng. 
创建日期：2002-11－11
修改者：廖鹤翔
修改日期：
修改部分：
类功能：企业信息显示表
****************************/
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 OI.DatabaseOper ;
using System.Diagnostics ;
using ZHENGYI;

namespace OI.Manage
{
	/// <summary>
	/// CompanyManages 的摘要说明。
	/// </summary>
	public class CompanyManages :OI.PageBase
	{
		protected System.Web.UI.WebControls.DataGrid DataGridCompanyManage;
		protected System.Web.UI.WebControls.TextBox TextBoxSelect;
		protected System.Web.UI.WebControls.Label LabelWarning;
		protected System.Web.UI.WebControls.DropDownList DropDownListSelect;		
	    protected DatabaseConnect dc=new DatabaseConnect() ;
		protected System.Web.UI.WebControls.HyperLink HyperLinkAdd;
		protected System.Web.UI.WebControls.ImageButton ImageButtonDelete;
		protected DatabaseConnect Dbc=new DatabaseConnect();
		protected System.Web.UI.WebControls.ImageButton ImageButton1;
		protected  ZHENGYI.DataGridNavigation divepage;

		
		
		private void Page_Load(object sender, System.EventArgs e)
		{
			
			// 在此处放置用户代码以初始化页面
			if (Session["userid"]==null)
			{
				Response.Write ("<script>alert('超时,请重新登录');top.location.href='../userpass.aspx';</script>");
				return ;
			}
			SetDivePage();
			ImageButtonDelete.Attributes["onclick"]= "return confirm('你是否确定要删除')"; 
			if(!Page.IsPostBack)
			{
				Bind();
			}
			
		}
		
		
		
		
	
	/// <summary>
		/// 设置分页
	/// </summary>
		private void SetDivePage()
		{
			DataGridCompanyManage.AllowPaging =true; 
			DataGridCompanyManage.PageSize =10; 
		
			ZHENGYI.BindDataDelegate f =new ZHENGYI.BindDataDelegate(Bind);//修改这个dataBind,让f 指向你的方法。 
			divepage.SetTarget(DataGridCompanyManage,f,10);
		}

		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.ImageButton1.Click += new System.Web.UI.ImageClickEventHandler(this.ImageButton1_Click);
			this.ImageButtonDelete.Click += new System.Web.UI.ImageClickEventHandler(this.ImageButtonDelete_Click);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion
		/// <summary>
		/// 清空输入框,将各项的值设为默认值
		/// </summary>
		private void CleanUp()
		{
			this.TextBoxSelect.Text="";
			this.LabelWarning.Text="";
		}

		/// <summary>
		/// 绑定
		/// </summary>
		 private void  Bind()
		{
			 //判断查询条件
			 string conn=null;
			 if(DropDownListSelect.SelectedValue .Trim ()=="请选择")
				 conn=null;
			 else if(DropDownListSelect.SelectedValue .Trim ()=="企业名称")
				 conn=" where CompanyName LIKE '%"+TextBoxSelect.Text .Trim ()+"%'";
			 else if(DropDownListSelect.SelectedValue .Trim ()=="法人代表")
				 conn=" where FictitiousPerson LIKE '%"+TextBoxSelect.Text .Trim ()+"%'";
			 else if(DropDownListSelect.SelectedValue .Trim ()=="企业性质")
				 conn="  where Biznature LIKE '%"+TextBoxSelect.Text .Trim ()+"%'";
			 else if(DropDownListSelect.SelectedValue .Trim ()=="企业资产")
				 conn="where Assets="+TextBoxSelect.Text .Trim ();
			 else if(DropDownListSelect.SelectedValue .Trim ()=="注册时间")
				 conn="where RegDate="+TextBoxSelect.Text .Trim ();
			
			 string sql1="select CompanyID,CompanyName,FictitiousPerson,Biznature,cast(Assets as int) as Assets,RegDate,  "+
				 "case when "+
				 "len(Convert(nchar(15),Range))>10 "+
				 "then SUBSTRING(Range,0,11)+'...' "+
				 "else Range "+
				 "end "+
				 "AS Range "+
				 "FROM CompanyManage "+conn;
			DataSet ds=dc.getBinding(sql1,"CompanyManage");
			DataGridCompanyManage.DataSource =ds.Tables ["CompanyManage"].DefaultView ;
			DataGridCompanyManage.DataBind();
		}
		/// <summary>
		/// 删除企业信息
		/// </summary>
		/// <param name="sender"></param>
		/// <param name="e"></param>
		protected  void ImageButtonDelete_Click(object sender, System.Web.UI.ImageClickEventArgs e)
		{
				
			//ViewState["CurrentPageIndex"]=DataGridCompanyManage.CurrentPageIndex;
			System.Collections.ArrayList Sql=new ArrayList();
			foreach (DataGridItem I in DataGridCompanyManage.Items )
			{
				
				CheckBox ckBox=(CheckBox) I.FindControl("CheckBoxDel");
				//CheckBox ckBox=(CheckBox)I.Cells[7].Controls[0];
				if (ckBox.Checked )
				{
					Sql.Add("DELETE FROM CompanyManage WHERE CompanyID="+Convert.ToInt32(I.Cells[0].Text));
				}
			}
			if(dc.ExecuteTransaction(Sql))
			{
				string Sql1="SELECT COUNT(*) AS itemCount FROM  CompanyManage ";
				int itemCount=Convert.ToInt32(dc.GetObjectBySql(Sql1));
				if(itemCount % DataGridCompanyManage.PageSize==0)
				{
//					if(Convert.ToInt32(ViewState["CurrentPageIndex"])==DataGridCompanyManage.PageCount-1)
//					{
//						DataGridCompanyManage.CurrentPageIndex=Convert.ToInt32(ViewState["CurrentPageIndex"])-1;
//					}
					DataGridCompanyManage.CurrentPageIndex=DataGridCompanyManage.CurrentPageIndex-1;
					
				}
				
			
			}
			
				
			else
			{
				Page.RegisterStartupScript("","<script language=javasript>alert('操作没有完成');</script)>");
			}
				
			Bind();
		}

		/// <summary>
		/// 实现模糊查询的功能
		/// </summary>
		/// <param name="sender"></param>
		/// <param name="e"></param>
		private void ImageButton1_Click(object sender, System.Web.UI.ImageClickEventArgs e)
		{
			if (DropDownListSelect.SelectedValue.Trim()=="请选择" )
			{
				Page.RegisterStartupScript("","<script>alert('请选择查询项');</script>"); 
				return;
			}
			//根据企业注销标识进行判断查询条件
			
			
		   
			
			this.Bind();
		}
	}
}