badgelist.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>
	/// BadgeList 的摘要说明。
	/// </summary>
	public class BadgeList : HTMS.Web.CompanySysMange.BasePage
	{
		protected System.Web.UI.WebControls.Label Label2;
		protected System.Web.UI.WebControls.DataGrid DataGrid1;
		protected HTMS.Web.AspNetPager.AspNetPager AspNetPager1;
		protected System.Web.UI.HtmlControls.HtmlInputButton Button1;
		protected System.Web.UI.HtmlControls.HtmlInputButton Button2;
		protected System.Web.UI.HtmlControls.HtmlInputText myvalue;
		private string CompanyID
		{
			get{return Convert.ToString(this.ViewState["CompanyID"]);}
			set{this.ViewState["CompanyID"]=value;}
		}
		
		private void Page_Load(object sender, System.EventArgs e)
		{			
			base.ClearCache();
			if(!this.Page.IsPostBack)
			{
				if(!base.CheckUser())
					return;
				this.CompanyID=Convert.ToString(this.Request.QueryString["CompanyID"]);
				if(this.CompanyID=="")
					return;
				this.ShowData();
			}
		}

		private void ShowData()
		{
			this.AspNetPager1.RecordCount=Common.DataPager.GetPageCount("CompanyBadge","IsFreeze = '0'");
			System.Data.DataTable mytable=Common.DataPager.GetPageData("CompanyBadge","*","CompanyBadgeID",this.AspNetPager1.PageSize,this.AspNetPager1.CurrentPageIndex,1,"IsFreeze = '0'");
			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);
			this.DataGrid1.SortCommand += new System.Web.UI.WebControls.DataGridSortCommandEventHandler(this.DataGrid1_SortCommand);
			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.Button1.ServerClick += new System.EventHandler(this.Button1_ServerClick);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void DataGrid1_SelectedIndexChanged(object sender, System.EventArgs e)
		{			
			//System.Web.UI.WebControls.TextBox mybox1=(System.Web.UI.WebControls.TextBox)this.DataGrid1.SelectedItem.Cells[5].Controls[3];
			//Common.Common.ShowMessageBox(((System.Web.UI.WebControls.TextBox)this.DataGrid1.SelectedItem.Cells[5].Controls[3]).Text);
			//Common.Common.ShowMessageBox(((System.Web.UI.WebControls.TextBox)this.DataGrid1.SelectedItem.FindControl("Textbox1")).ID);
		}

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

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

		private bool CheckPassword(string password,string BadgeID)
		{
			string sqlstring="select CompanyBadgeID from CompanyBadge  where CompanyBadgeID = '"+BadgeID+"' and BadgePassword ='"+password+"'";
			System.Data.DataTable mytable=HTMS.SQLServerDAL.DAL.DAI.RunSqlTable(sqlstring);
			if(mytable==null || mytable.Rows.Count<=0)
			{
				return false;
			}
			else
				return true;
		}

		private void DataGrid1_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			//Common.Common.ShowMessageBox(((System.Web.UI.WebControls.TextBox)e.Item.Cells[5].Controls[3]).Text);
			if(e.CommandName=="select")
			{				
				System.Web.UI.WebControls.TextBox mybox=(System.Web.UI.WebControls.TextBox)e.Item.Cells[5].Controls[1];
				
				if(mybox.Text=="")
				{
					Common.Common.ShowMessageBox("请输入密码再进行选择!");
				}
				else
				{
					if(!this.CheckPassword(mybox.Text,e.Item.Cells[0].Text))
					{
						Common.Common.ShowMessageBox("密码不正确");
					}
					else
					{
						this.myvalue.Value=e.Item.Cells[0].Text+"_"+e.Item.Cells[2].Text;				
					}
				}
			}
			if(e.CommandName=="look")
			{
				Common.Windows.OpenModalWindow(this,"../CompanyInfo/ShowBadge_main.aspx?BadgeID="+e.Item.Cells[0].Text,500,500);
			}
		}

		private void DataGrid1_SortCommand(object source, System.Web.UI.WebControls.DataGridSortCommandEventArgs e)
		{
		
		}

		private void DataGrid1_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
		{
			//((System.Web.UI.WebControls.LinkButton)e.Item.Cells[7].FindControl("LinkButton1")).Attributes.Add("onclick","//."
			//((System.Web.UI.WebControls.TextBox)e.Item.Cells[5].FindControl("Textbox1")).Attributes.Add("onclick","document.getElementById('mypassword').value=e.");
		}
	}
}