wf_manager.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 WebApplication1 //HNtest1_main1
{
	/// <summary>
	/// WFapp 的摘要说明。
	/// </summary>
	public class WF_manager : System.Web.UI.Page
	{
		protected System.Data.DataView dataView1;
		protected System.Data.Odbc.OdbcConnection odbcConnection1;
		protected System.Data.Odbc.OdbcCommand odbcSelectCommand1;
		internal System.Data.Odbc.OdbcCommand odbcInsertCommand1;
		protected System.Data.Odbc.OdbcCommand odbcUpdateCommand1;
		protected System.Data.Odbc.OdbcCommand odbcDeleteCommand1;
		protected System.Data.Odbc.OdbcDataAdapter odbcDataAdapter1;
		protected System.Web.UI.WebControls.TextBox TextBox4;
		protected System.Web.UI.WebControls.TextBox TextBox3;
		protected System.Web.UI.WebControls.TextBox TextBox2;
		protected System.Web.UI.WebControls.DataGrid DataGrid1;
		protected System.Web.UI.WebControls.Label Label2;
		protected System.Data.DataSet dataSet1;
		protected System.Data.Odbc.OdbcCommand odbcCommand1;
		protected System.Web.UI.WebControls.DropDownList DropDownList3;
		protected System.Web.UI.WebControls.TextBox TextBox1;
		protected System.Web.UI.WebControls.Button Button5;
		protected System.Web.UI.WebControls.Button Button2;
		protected System.Web.UI.WebControls.Button Button1;
		protected System.Web.UI.WebControls.TextBox TextBox5;
		protected System.Web.UI.WebControls.CompareValidator CompareValidator1;
		protected System.Web.UI.WebControls.RangeValidator valPrice;

		protected System.Web.UI.WebControls.TextBox TextBox6;
		protected System.Web.UI.WebControls.Label Label3;
		protected System.Web.UI.WebControls.DropDownList DropDownList2;
		protected System.Web.UI.WebControls.TextBox TextBox7;
		private string Insertstr;
		private string strUser ;    
		private string strUserName; 
		private string strDept;
		protected System.Web.UI.WebControls.Label Label10;
		protected System.Web.UI.WebControls.Label Label4;
		protected System.Web.UI.WebControls.Label Label5;
		protected System.Web.UI.WebControls.Label Label6;
		protected System.Web.UI.WebControls.TextBox TextBox8;
		protected System.Web.UI.WebControls.Label Label7;
		protected System.Web.UI.WebControls.Label lblMessage;     
		private string strDeptName; 

		private void Page_Load(object sender, System.EventArgs e)
		{

			
			strUser = (string)Session["strUser"];          
			strUserName = (string)Session["strUserName"];  
			strDept = (string)Session["strDept"];          
			strDeptName = (string)Session["strDeptName"];
			// 在此处放置用户代码以初始化页面
			if (!IsPostBack)
			{

				if (!Global.CheckUserValidation((string)Session["strRole"], Global.MENU_MANAGER))
				{
					Response.Redirect("err_session.htm", true);
				}
				DataGrid1.CurrentPageIndex=0;
				DataGrid1.PageSize = Convert.ToInt32 (TextBox5.Text );
				select();
		//		Global.WriteLog(ref odbcConnection1, strUser, Global.MENU_MANAGER,Global.ACTION_OTHER,"登陆");
			}

		}

		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.dataView1 = new System.Data.DataView();
			this.odbcConnection1 = new System.Data.Odbc.OdbcConnection();
			this.odbcSelectCommand1 = new System.Data.Odbc.OdbcCommand();
			this.odbcInsertCommand1 = new System.Data.Odbc.OdbcCommand();
			this.odbcUpdateCommand1 = new System.Data.Odbc.OdbcCommand();
			this.odbcDeleteCommand1 = new System.Data.Odbc.OdbcCommand();
			this.odbcDataAdapter1 = new System.Data.Odbc.OdbcDataAdapter();
			this.dataSet1 = new System.Data.DataSet();
			this.odbcCommand1 = new System.Data.Odbc.OdbcCommand();
			((System.ComponentModel.ISupportInitialize)(this.dataView1)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.dataSet1)).BeginInit();
			this.Button5.Click += new System.EventHandler(this.Button5_Click);
			this.Button2.Click += new System.EventHandler(this.Button2_Click);
			this.Button1.Click += new System.EventHandler(this.Button1_Click);
			this.DataGrid1.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.DataGrid1_PageIndexChanged_1);
			this.DataGrid1.SelectedIndexChanged += new System.EventHandler(this.DataGrid1_SelectedIndexChanged);
			// 
			// odbcDataAdapter1
			// 
			this.odbcDataAdapter1.DeleteCommand = this.odbcDeleteCommand1;
			this.odbcDataAdapter1.InsertCommand = this.odbcInsertCommand1;
			this.odbcDataAdapter1.SelectCommand = this.odbcSelectCommand1;
			this.odbcDataAdapter1.UpdateCommand = this.odbcUpdateCommand1;
			// 
			// dataSet1
			// 
			this.dataSet1.DataSetName = "NewDataSet";
			this.dataSet1.Locale = new System.Globalization.CultureInfo("zh-CN");
			this.Load += new System.EventHandler(this.Page_Load);
			((System.ComponentModel.ISupportInitialize)(this.dataView1)).EndInit();
			((System.ComponentModel.ISupportInitialize)(this.dataSet1)).EndInit();

		}
		#endregion
		private void connectionDB()
		{
			Global.OpenConnection(ref odbcConnection1);		
		}	
		private void closeDB()
		{
			odbcConnection1.Close();	
		}	

		private void select()
		{
			DataGrid1.CurrentPageIndex=0;
			DataGrid1.PageSize = Convert.ToInt32 (TextBox5.Text );
			dataSet1 =new DataSet();
			selectdata();
			PageIndexNbr();
		}
		private void selectdata()
		{
			connectionDB();
	//		odbcDataAdapter1 =new System.Data.Odbc.OdbcDataAdapter ("select Manager_id as '管理员帐号',Name as '管理员名称',Passwd as '密码',Department_id as	'部门ID',"+
	//			           "Department	as	'所在部门',Role_Id	as '角色(权限)',Effect as '是否有效'from T_manager order by Manager_id desc" ,odbcConnection1 ) ;
	     odbcDataAdapter1 =new System.Data.Odbc.OdbcDataAdapter ("select Manager_id ,Name ,Passwd ,Department_id ,"+
	 			           "Department,Role_Id,Effect from T_manager order by Manager_id desc" ,odbcConnection1 ) ;
		
			
			//dataSet1 =new DataSet();
			odbcDataAdapter1.Fill ( dataSet1 , "T_manager" ) ;
			DataView dataView1 = dataSet1.Tables [ "T_manager" ].DefaultView ;
			DataGrid1.DataSource = dataView1 ;
			DataGrid1.DataBind() ;
			DataGrid1.HeaderStyle.Height=30;
			closeDB();	
		}	

		private void PageIndexNbr()
		{
			Label2.Text = "第 " + (DataGrid1.CurrentPageIndex + 1).ToString() + " 页／共 " + DataGrid1.PageCount.ToString() + " 页"; 
		}
		private void DataGrid1_PageIndexChanged_1(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
		{
			 DataGrid1.CurrentPageIndex=e.NewPageIndex;
			 selectdata();
			 PageIndexNbr();
		}

		private bool ErrInfo()
		{
			if(TextBox1.Text=="")
			{
				Page.RegisterStartupScript("alert", @"<script language=""javascript"">window.alert(""错误：管理员帐号不能为空！"")</script>");
				return false;
			}
			if(TextBox2.Text=="")
			{
				Page.RegisterStartupScript("alert", @"<script language=""javascript"">window.alert(""错误：管理员名称不能为空！"")</script>");
				return false;
			
			}
			if((TextBox3.Text=="")||(TextBox4.Text==""))
			{
				Page.RegisterStartupScript("alert", @"<script language=""javascript"">window.alert(""错误：管理员密码不能为空！"")</script>");
				return false;
			}
			if(TextBox3.Text!=TextBox4.Text)
			{
				Page.RegisterStartupScript("alert", @"<script language=""javascript"">window.alert(""错误：输入两次密码不同！"")</script>");
				return false;
			}

			return true;

		}

		private void Button5_Click(object sender, System.EventArgs e)
		{

         string str1;
			lblMessage.Text = "";
			if (!ErrInfo())
			{
          return ;
			}

			/*if (!valPrice.IsValid)
			{
			//	TextBox9.Text="sfgsdfgsdfg";
				lblMessage.Text += "管理员帐号：必须为不重复的值";
				return;
			}*/
			str1= TextBox6.Text;
		   str1="'"+TextBox1.Text+"','"+TextBox2.Text+"','"+TextBox3.Text+"','"+TextBox6.Text/*DropDownList1.SelectedItem.Value*/+"','"+TextBox7.Text/*DropDownList1.SelectedItem.Text*/+"','"+ DropDownList2.SelectedItem.Value +"','"+ DropDownList3.SelectedItem.Value+"'";
    	   Insertstr="INSERT INTO T_manager(`Manager_id` ,`name` ,`Passwd`,`Department_id`,`Department` ,`Role_id`,`Effect`) VALUES ( "+str1+")";
			insertdata();
			Global.WriteLog(ref odbcConnection1, strUser, Global.MENU_MANAGER, Global.ACTION_ADD,Insertstr);
		   select();
		}
		private void insertdata()
		{
			int i;
			connectionDB();
			odbcInsertCommand1 = new System.Data.Odbc.OdbcCommand(Insertstr,odbcConnection1);
			i = odbcInsertCommand1.ExecuteNonQuery ();
			if (i != 1)
			{
				Page.RegisterStartupScript("alert", @"<script language=""javascript"">window.alert(""发生错误。增加数据错误！"")</script>");

				lblMessage.Text = "发生错误。增加数据错误！";
			}
			closeDB();	
		}
		private void Button1_Click(object sender, System.EventArgs e)
		{
			DropDownList3.SelectedIndex=0;
			TextBox6.Text="";
			TextBox7.Text="";
			TextBox2.Text="";
			TextBox3.Text="";
			TextBox4.Text="";
			TextBox1.Text="";
			DropDownList2.SelectedIndex=1;
			Insertstr="";
			select();
		}

		private void Button2_Click(object sender, System.EventArgs e)
		{
			string psswordstr="";
			string str1= TextBox6.Text;//DropDownList1.SelectedItem.Value;
			string strUpdate;
			int iUpdateRowCount;
			if (DataGrid1.SelectedIndex < 0) 
			{
				Page.RegisterStartupScript("alert", @"<script language=""javascript"">window.alert(""错误：未选择记录！请先选择记录，以对其进行修改！"")</script>");
				return;
			}			
			

			connectionDB();

			lblMessage.Text = "";
			if ((TextBox3.Text ==TextBox4.Text)&&(TextBox3.Text!=""))
			{
				psswordstr =TextBox3.Text;
			}
			else
			{
			   psswordstr =Label7.Text;
				TextBox3.Text = Label7.Text;
				TextBox4.Text = Label7.Text;
			}
			if (!ErrInfo())
			{
				return ;
			}

			strUpdate = "UPDATE T_manager set " +

				"Manager_id  = '" +TextBox1.Text + "', " +
				"name  = '" +TextBox2.Text + "', " +
				"Passwd  = '" +psswordstr + "', " +
				"Department_id  = '" +TextBox6.Text/*DropDownList1.SelectedItem.Value*/ + "', " +
				"Department = '" +TextBox7.Text/*DropDownList1.SelectedItem.Text*/ + "', " +
				"Role_Id  = '" +DropDownList2.SelectedItem.Value + "', " +
				"effect  = '" +DropDownList3.SelectedItem.Value + "' " +
				"where Manager_id = ";


				strUpdate +="'"+ DataGrid1.SelectedItem .Cells [1].Text+"'";

			System.Data.Odbc.OdbcCommand cmdUpdate = new System.Data.Odbc.OdbcCommand (strUpdate, odbcConnection1);
			iUpdateRowCount = cmdUpdate.ExecuteNonQuery ();
			if (iUpdateRowCount != 1)
			{
				Page.RegisterStartupScript("alert", @"<script language=""javascript"">window.alert(""错误：未能更改数据！"")</script>");
	//			lblMessage.Text = "发生错误。未能更改数据！";
			}
			else
			{
				DataGrid1.SelectedIndex = -1;
				Global.WriteLog(ref odbcConnection1,strUser,Global.MENU_MANAGER,Global.ACTION_UPDATE,strUpdate);

				select();
			}
	        closeDB();
		}

		private void DataGrid1_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			//  Insertstr="INSERT INTO T_manager(`Manager_id` ,`name` ,`Passwd`,`Department_id`,`Department` ,`Role`,`Effect`) VALUES ( "+str1+")";

			TextBox1.Text = DataGrid1.SelectedItem.Cells[1].Text ;  //Manager_id
			TextBox2.Text = DataGrid1.SelectedItem.Cells[2].Text ;  //name
			TextBox3.Text = DataGrid1.SelectedItem.Cells[3].Text ;  //Passwd
			TextBox4.Text = DataGrid1.SelectedItem.Cells[3].Text ;  //Passwd
			TextBox6.Text=  DataGrid1.SelectedItem.Cells[4].Text; //Department_id;
			TextBox7.Text=DataGrid1.SelectedItem.Cells [5].Text; //Department_NAME;
			DropDownList2.SelectedValue = ((DropDownList)DataGrid1.SelectedItem.Cells[6].Controls [1]).SelectedValue ; //Role
			DropDownList3.SelectedValue =((DropDownList) DataGrid1.SelectedItem.Cells[7].Controls [1]).SelectedValue; //effect


			Label7.Text= DataGrid1.SelectedItem.Cells[3].Text ;
		}

		private void Button3_Click(object sender, System.EventArgs e)
		{
	

		}

	}
}