quarters.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;
using gwpj.DataAccess;
namespace gwpj
{
	/// <summary>
	/// WebForm1 的摘要说明。
	/// </summary>
	public class quarters : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.DataGrid DataGrid1;
		protected System.Web.UI.WebControls.Label lblPageCount;
		protected System.Web.UI.WebControls.Label lblCurrentIndex;
		protected System.Web.UI.WebControls.LinkButton btnFirst;
		protected System.Web.UI.WebControls.LinkButton btnPrev;
		protected System.Web.UI.WebControls.LinkButton btnNext;
		protected System.Web.UI.WebControls.LinkButton btnLast;

		MyDB mydb = new MyDB();
		protected System.Web.UI.WebControls.Button Button1;
		protected System.Web.UI.WebControls.TextBox TxtDep;
		protected System.Web.UI.WebControls.TextBox TexQuarters;
		DataGrid_Page page=new DataGrid_Page();
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			btnFirst.Text = "最首页";
			btnPrev.Text = "前一页";
			btnNext.Text = "下一页";
			btnLast.Text = "最后页";
			if(!Page.IsPostBack)
			{
				DataBind_DG();
				page.ShowStats(lblCurrentIndex,lblPageCount,DataGrid1);
			}
		}

		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.Button1.Click += new System.EventHandler(this.Button1_Click);
			this.DataGrid1.CancelCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid1_CancelCommand);
			this.DataGrid1.EditCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid1_EditCommand);
			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.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion


		/// <summary>
		/// 设置DataGrid的数据
		/// </summary>
		private void DataBind_DG()
		{
			string sqlstr = "select role_id,dept_name,evaluated_role from role_evaluate..evaluated_role";
			DataSet ds = mydb.retDs(sqlstr);
			DataGrid1.DataSource = ds.Tables[0].DefaultView;
			DataGrid1.DataBind();
		}

		public void PagerButtonClick(object sender, EventArgs e)
		{
			//获取页面按钮参数
			string arg = ((LinkButton)sender).CommandArgument.ToString();
			//设置页面分页数，总页数，当前页
			page.SetPage(arg,DataGrid1);
			//绑定DataGrid
			DataBind_DG();
			page.ShowStats(lblCurrentIndex,lblPageCount,DataGrid1);
		}

		/// <summary>
		/// 分页
		/// </summary>
		/// <param name="sender"></param>
		/// <param name="e"></param>
		public void MyDataGrid_Page(object sender, DataGridPageChangedEventArgs e)
		{
			int startIndex ;
			startIndex = DataGrid1.CurrentPageIndex * DataGrid1.PageSize;
			DataGrid1.CurrentPageIndex = e.NewPageIndex;
			DataBind_DG();
			page.ShowStats(lblCurrentIndex,lblPageCount,DataGrid1);
		}

		private void Button1_Click(object sender, System.EventArgs e)
		{
			if(TxtDep.Text!=""&&TexQuarters.Text!="")
			{
				string sqlstr = "insert into role_evaluate..evaluated_role(dept_name,evaluated_role) values('"+TxtDep.Text+"','"+TexQuarters.Text+"')";
				if(mydb.ExecuteSql(sqlstr)=="1")
				{
					Response.Write("<script>alert('部门岗位添加成功！')</script>");
				}
				else
				{
					Response.Write("<script>alert('"+mydb.ExecuteSql(sqlstr).ToString()+"！')</script>");
				}
			}
			else
			{
				Response.Write("<script>alert('请输入部门与岗位名称！')</script>");
			}
		}

		private void DataGrid1_EditCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			DataGrid1.EditItemIndex = e.Item.ItemIndex;
			DataBind_DG();
		}

		private void DataGrid1_CancelCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			DataGrid1.EditItemIndex = -1;
			DataBind_DG();
		}

		private void DataGrid1_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			string[] arg = new string[3];
			arg[0] = e.Item.Cells[0].Text.ToString();
			arg[1] = ((TextBox)e.Item.Cells[1].Controls[0]).Text;
			arg[2] = ((TextBox)e.Item.Cells[2].Controls[0]).Text;
			string sqlstr = "update role_evaluate..evaluated_role set dept_name = '"+arg[1].ToString()+"',evaluated_role = '"+arg[2].ToString()+"' where role_id = "+arg[0].ToString()+"";
			mydb.ExecuteSql(sqlstr);
			DataGrid1.EditItemIndex = -1;
			DataBind_DG();
		}

		private void DataGrid1_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			string sqlstr = "delete from role_evaluate..evaluated_role where role_id = "+e.Item.Cells[0].Text+"";
			mydb.ExecuteSql(sqlstr);
			DataBind_DG();
		}

		private void DataGrid1_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
		{
			if(e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
			{
				e.Item.Cells[4].Attributes.Add("onclick","javascript:return confirm('确定删除吗？')");
			}
		}
	}
}