filesort.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 OI.Manage
{
	/// <summary>
	/// FileSort 的摘要说明。
	/// </summary>
	public class FileSort : OI.PageBase
	{
		protected System.Web.UI.WebControls.ImageButton ImageButtonSave;
		protected System.Web.UI.WebControls.Panel PanelAdd1;
		protected System.Web.UI.WebControls.ImageButton ImageButtonAdd;
		protected System.Web.UI.WebControls.Panel PanelAdd;
		protected System.Web.UI.WebControls.DataGrid DataGridJobLevel;
		protected System.Web.UI.WebControls.TextBox TextBoxFileSort;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator1;
		protected OI.DatabaseOper.DatabaseConnect dc=new OI.DatabaseOper.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)
			{
				PanelAdd.Visible=true;
				PanelAdd1.Visible=false;
				Bind();
			}
		}

		#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.DataGridJobLevel_CancelCommand);
			this.DataGridJobLevel.EditCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGridJobLevel_EditCommand);
			this.DataGridJobLevel.UpdateCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGridJobLevel_UpdateCommand);
			this.DataGridJobLevel.DeleteCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGridJobLevel_DeleteCommand);
			this.ImageButtonAdd.Click += new System.Web.UI.ImageClickEventHandler(this.ImageButtonAdd_Click);
			this.ImageButtonSave.Click += new System.Web.UI.ImageClickEventHandler(this.ImageButtonSave_Click);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		 
		private void ImageButtonSave_Click(object sender, System.Web.UI.ImageClickEventArgs e)
		{


			if(Page.IsValid)
			{
				
				string sql1="select * from FileSort where  filesortname="+"'"+TextBoxFileSort.Text.Trim()+"' and departmentid=0 ";
				int countt=Convert.ToInt32(dc.GetValueBySql(sql1));
				if (countt==0)
				{
					string sql="insert into FileSort(filesortname,departmentid) values('"+TextBoxFileSort.Text+"',0)";
					dc.addData(sql);
					Bind();
				}
				else
				{
					Page.RegisterStartupScript("","<script>alert('你不能增加同名的文种名称！');</script>");
					return;
				}
			}
		}

		private void ImageButtonAdd_Click(object sender, System.Web.UI.ImageClickEventArgs e)
		{
			PanelAdd.Visible=false;
			PanelAdd1.Visible=true;
		}
		private void Bind()
		{			
			string strCom= "SELECT * FROM FileSort order by filesortid desc";
			DataSet ds=new DataSet();
			ds=dc.getBinding(strCom,"FileSort");
			this.DataGridJobLevel.DataSource =ds.Tables ["FileSort"].DefaultView;
			this.DataGridJobLevel.DataBind ();
			//绑定数据库表
		}

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

		private void DataGridJobLevel_DeleteCommand(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 FileSort where filesortid="+ID+" ";
			dc.ExecuteSQL(sql);
			Bind();
		}

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

		private void DataGridJobLevel_UpdateCommand(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 FileSort set FileSortName='"+Description+"'where filesortid="+ID+"";
			dc.ExecuteSQL(sql);
			DataGridJobLevel.EditItemIndex=-1;
			Bind();
		}

		private void ImageButtonCancel_Click(object sender, System.Web.UI.ImageClickEventArgs e)
		{
		
		}
	}
}