bmclass.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 bmclass : RWSB.PageBase
	{
		protected RWSB.DatabaseOper.DatabaseConnect dc=new RWSB.DatabaseOper.DatabaseConnect();
	
		protected 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);

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

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