joblevels.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 OI.DatabaseOper ;
using System.Diagnostics;

namespace OI.Manage
{
	/// <summary>
	/// JobLevels 的摘要说明。
	/// </summary>
	public class JobLevels : OI.PageBase
	{
		protected System.Web.UI.WebControls.DataGrid DataGridJobLevel;
		protected System.Web.UI.WebControls.Panel PanelAdd;
		protected System.Web.UI.WebControls.Panel PanelAdd1;
		protected System.Web.UI.WebControls.TextBox TextBoxAdd;
		protected System.Web.UI.WebControls.ImageButton ImageButtonSave;
		protected System.Web.UI.WebControls.ImageButton ImageButtonAdd;
		protected System.Web.UI.WebControls.ImageButton ImageButtonCancel;
		protected DatabaseOper.DatabaseConnect dc=new DatabaseConnect();
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			if (Session["userid"]==null)
			{
				Response.Write ("<script>alert('超时,请重新登录');top.location.href='../userpass.aspx';</script>");
				return ;
			}
			if (!Page.IsPostBack)
			{
				this.Bind ();
				PanelAdd.Visible=true;
				PanelAdd1.Visible=false;
			
			} 
		}
		private void Bind()
		{
			
			string strCom= "SELECT * FROM JobLevels  order by joblevelid desc";
			DataSet ds=new DataSet();
			ds=dc.getBinding(strCom,"JobLevels");
			this.DataGridJobLevel.DataSource =ds.Tables ["JobLevels"].DefaultView;
			this.DataGridJobLevel.DataBind ();
			//绑定数据库表
		}
		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		
		
		

		private void InitializeComponent()
		{
			this.DataGridJobLevel.CancelCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.Cancel_Click);
			this.DataGridJobLevel.EditCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.Edit_click);
			this.DataGridJobLevel.UpdateCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.Update_Click);
			this.DataGridJobLevel.DeleteCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.Delete_Click);
			this.ImageButtonAdd.Click += new System.Web.UI.ImageClickEventHandler(this.ImageButtonAdd_Click);
			this.ImageButtonSave.Click += new System.Web.UI.ImageClickEventHandler(this.ImageButtonSave_Click);
			this.ImageButtonCancel.Click += new System.Web.UI.ImageClickEventHandler(this.ImageButtonCancel_Click);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void Cancel_Click(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			PanelAdd.Visible=true;
			PanelAdd1.Visible=false;
			DataGridJobLevel.EditItemIndex=-1;
			Bind();
		}

		private void Delete_Click(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			PanelAdd.Visible=true;
			PanelAdd1.Visible=false;
			int ID=Convert.ToInt32(e.Item.Cells[0].Text);
			string sql="delete from JobLevels where joblevelid="+ID+" ";
			dc.ExecuteSQL(sql);
			Bind();
		
		}

		private void Edit_click(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			PanelAdd.Visible=true;
			PanelAdd1.Visible=false;
			DataGridJobLevel.EditItemIndex=e.Item.ItemIndex;
			Bind();
		
		}

		private void Update_Click(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			PanelAdd.Visible=true;
			PanelAdd1.Visible=false;
			int ID= Convert.ToInt32(e.Item.Cells[0].Text);
			string Description=((TextBox)e.Item.Cells[1].Controls[0]).Text;
			string sql="update JobLevels set description='"+Description+"'where joblevelid="+ID+"";
			dc.ExecuteSQL(sql);
			DataGridJobLevel.EditItemIndex=-1;
			Bind();
		
		}

		private void ImageButtonAdd_Click(object sender, System.Web.UI.ImageClickEventArgs e)
		{
			PanelAdd.Visible=false;
			PanelAdd1.Visible=true;
		}

		private void ImageButtonSave_Click(object sender, System.Web.UI.ImageClickEventArgs e)
		{
			if(Page.IsValid)
			{
				
				string sql1="select * from JobLevels where  description="+"'"+TextBoxAdd.Text.Trim()+"'";
				int countt=Convert.ToInt32(dc.GetValueBySql(sql1));
				if (countt==0)
				{
					string Description=TextBoxAdd.Text;
					string sql="insert into JobLevels(description,ispublic) values('"+Description+"',1)";
					dc.ExecuteSQL(sql);
					Bind();
					PanelAdd.Visible=true;
					PanelAdd1.Visible=false;
					TextBoxAdd.Text="";
				}
				else
				{
					Page.RegisterStartupScript("","<script>alert('你不能增加同名的职称名称！');</script>");
					return;
				}
			}


	
		}

		private void ImageButtonCancel_Click(object sender, System.Web.UI.ImageClickEventArgs e)
		{   TextBoxAdd.Text="";
			PanelAdd.Visible=true;
			PanelAdd1.Visible=false;
		}

		

	}
}