professionallevel1.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 ;


namespace OI.Manage
{
	/// <summary>
	/// TitleWebForm 的摘要说明。
	/// </summary>
	public class ProfessionalLevel1 :OI.PageBase
	{ 
		//此下数行为界面控件列表
		
		protected System.Web.UI.WebControls.DataGrid DataGridProfessionalLevel;
		protected System.Web.UI.WebControls.Panel Panel1;
		protected System.Web.UI.WebControls.Panel Panel2;
		protected System.Web.UI.WebControls.TextBox TextBoxProfessionLevelName;
		protected System.Web.UI.WebControls.DropDownList DropDownListIsPublic;
		protected System.Web.UI.WebControls.TextBox TextBoxDescription;
		protected System.Web.UI.WebControls.ImageButton ImageButtonAdd;
		protected System.Web.UI.WebControls.ImageButton ImageButtonSave;
		protected System.Web.UI.WebControls.ImageButton ImageButtonCancel;
		private 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 ();
				
			} 
		}
		private void Bind()
		{
			
			string strCom= "SELECT ProfessionalLevelID,ProfessionalLevelName,[Description], case IsPublic when  '0' then '否' when  '1' then '是' end  as  IsPublic  FROM  ProfessionalLevel";
			DataSet ds=dc.getBinding(strCom,"ProfessionalLevel");
			this.DataGridProfessionalLevel.DataSource =ds.Tables ["ProfessionalLevel"].DefaultView;
			this.DataGridProfessionalLevel.DataBind ();
			
			//绑定数据库表
		}
		#region Web Form Designer generated code
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN：该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.DataGridProfessionalLevel.ItemCreated += new System.Web.UI.WebControls.DataGridItemEventHandler(this.DataGridProfessionalLevel_ItemCreated);
			this.DataGridProfessionalLevel.CancelCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.Cancel_Click);
			this.DataGridProfessionalLevel.EditCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.Edit_Click);
			this.DataGridProfessionalLevel.UpdateCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.Save_Click);
			//this.DataGridProfessionalLevel.DeleteCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.Delete_Click);
			this.DataGridProfessionalLevel.SelectedIndexChanged += new System.EventHandler(this.DataGridProfessionalLevel_SelectedIndexChanged);
			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)
		{
			DataGridProfessionalLevel.EditItemIndex=-1;
			
			Bind();
		}
		//private void 

//		private void Delete_Click(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
//		{
//			int levelID=Convert.ToInt32(e.Item.Cells[0].Text);
//			string sql="delete from ProfessionalLevel where  ProfessionalLevelID="+levelID+"";
//			dc.ExecuteSQL(sql);
//			Bind();
//		}

		private void Edit_Click(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			DataGridProfessionalLevel.EditItemIndex=e.Item.ItemIndex;
			
//			DropDownList dropedit=(DropDownList)e.Item.Cells[3].FindControl("DropDownListEdit");
//			Label label=((Label)e.Item.Cells[3].FindControl("Label1"));
//			if(label!=null)
//			{
//				if(label.Text=="True")
//					dropedit.SelectedValue="1";
//				else
//					dropedit.SelectedValue="0";
//			}

			Bind();
		
			Panel1.Visible=true;
			Panel2.Visible=false;
			
		}

		private void Save_Click(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			int levelID=Convert.ToInt32(e.Item.Cells[0].Text);
			string levelName=((TextBox)e.Item.Cells[1].Controls[0]).Text;
			string description=((TextBox)e.Item.Cells[2].Controls[0]).Text;
			DropDownList dropedit=(DropDownList)e.Item.FindControl("DropDownListEdit");
			string isPublic= dropedit.SelectedItem.Value;
	
			
			string sql="update ProfessionalLevel set ProfessionalLevelName='"+levelName+"',Description='"+description+"',IsPublic ='"+isPublic+" ' where ProfessionalLevelID="+levelID+"";
			dc.ExecuteSQL(sql);
			DataGridProfessionalLevel.EditItemIndex=-1;
			
			Bind();
		}

		private void ImageButtonAdd_Click(object sender, System.Web.UI.ImageClickEventArgs e)
		{
			Panel1.Visible=false;
			Panel2.Visible=true;
			DataGridProfessionalLevel.EditItemIndex=-1;
			TextBoxProfessionLevelName.Text="";
			TextBoxDescription.Text="";
			Bind();
		}

		private void ImageButtonSave_Click(object sender, System.Web.UI.ImageClickEventArgs e)
		{
		     string levelName=TextBoxProfessionLevelName.Text.Trim().Replace ("'","''") ;
			//string isPublic=DropDownListIsPublic.SelectedItem.Value.ToString();
			string isPublic="1";
			string description=TextBoxDescription.Text;
			if (checkExistName(levelName))
			{
				string sql="insert into ProfessionalLevel (ProfessionalLevelName,Description,IsPublic) values('"+ levelName+"','"+description+"','"+isPublic+"')";
				dc.ExecuteSQL(sql);
				Bind();
				TextBoxProfessionLevelName.Text="";
				TextBoxDescription.Text="";
				Panel1.Visible=true;
				Panel2.Visible=false;
			}
			else
			{
				Page.RegisterStartupScript ("","<script>alert('"+levelName+"己经存在!');</script>");
			}
		}
		private bool checkExistName(string name)
		{
			string sql=" select count(*) from ProfessionalLevel where ProfessionalLevelName='"+name+"'";
			try
			{
				int number= int.Parse (dc.GetValueBySql (sql));
				if (number >0)
				{
					return false;
				}
				else
				{
					return true;
				}
			}
			catch(Exception er)
			{
				Response.Write (er.Message );
				Response.End ();
			}
            return false;
		}

		private void ImageButtonCancel_Click(object sender, System.Web.UI.ImageClickEventArgs e)
		{
			Panel1.Visible=true;
			Panel2.Visible=false;
			DataGridProfessionalLevel.EditItemIndex=-1;
			Bind();
			TextBoxProfessionLevelName.Text="";
			TextBoxDescription.Text="";
		}

		private void DataGridProfessionalLevel_SelectedIndexChanged(object sender, System.EventArgs e) 
		{
		
		}
		private void LinkBtnDel_Click(object sender ,EventArgs e)
		{
			LinkButton LinkBtnDel =(LinkButton) sender;
			if (LinkBtnDel !=null )
			{
				TableRow tr=(TableRow)LinkBtnDel.Parent .Parent ;
				string str =" select count(*) from accounts_users where ProfessionalLevelID="+tr.Cells[0].Text ;
				int i =int.Parse (dc.GetValueBySql (str));
				if (i <1)
				{
					 str =" delete from ProfessionalLevel where  ProfessionalLevelID="+tr.Cells[0].Text ;
					try
					{
						dc.ExecuteSQL (str);
					}
					catch 

					{  
										
					}
				}
				else
				{
					Page.RegisterStartupScript ("","<script>alert('此职称正在使用,不能删除')</script>");
					
				}
			}
		}

		private void DataGridProfessionalLevel_ItemCreated(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
		{
			LinkButton LinkBtnDel =(LinkButton) e.Item .FindControl ("LinkBtnDel");
			if (LinkBtnDel != null)
			{
				LinkBtnDel.Attributes ["onclick"]="return confirm('你是否确定要删除?')";
				LinkBtnDel.Click +=new EventHandler(LinkBtnDel_Click);
			}
		}

		
	}
}