qxclass.aspx.cs

用vs2005写的一个生产任务管理系统。数据的统计和综合查询是主要功能

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 RWSB.Manage
{
	/// <summary>
	/// FileSort 的摘要说明。
	/// </summary>
	public partial class qxclass : RWSB.PageBase
	{
		protected RWSB.DatabaseOper.DatabaseConnect dc=new RWSB.DatabaseOper.DatabaseConnect();
	
		protected void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
            if (Session["UserGrade"].ToString().Trim() != "管理员")
            {
                Response.Write("<script>alert('对不起，您不具有权限');</script>");
                Response.End();
                 
            }
			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);

		}
		#endregion

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


			if(Page.IsValid)
			{
				
                string sql1 = "select * from roles where  rolename=" + "'" + TextBoxFileSort.Text.Trim() + "'";
				int countt=Convert.ToInt32(dc.GetValueBySql(sql1));
				if (countt==0)
				{
                    string sql = "insert into roles(rolename) values('" + TextBoxFileSort.Text + "')";
					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 roles order by roleid asc";
			DataSet ds=new DataSet();
            ds = dc.getBinding(strCom, "roles");
            this.DataGridJobLevel.DataSource = ds.Tables["roles"].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 roles where roleid=" + 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 roles set rolename='" + Description + "'where roleid=" + ID + "";
			dc.ExecuteSQL(sql);
			DataGridJobLevel.EditItemIndex=-1;
			Bind();
		}

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