accounts_useredit.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;
using RWSB.DatabaseOper ;
using System.IO ;
using System.Data .SqlClient ;
namespace RWSB.Manage
{
	/// <summary>
	/// Accounts_UserEdit 的摘要说明。
	/// </summary>

	public partial class Accounts_UserEdit : RWSB.PageBase
	{
	
		private DatabaseOper.DatabaseConnect dc = new DatabaseOper.DatabaseConnect();
		protected System.Web.UI.WebControls.Label Label1;
      	protected System.Web.UI.HtmlControls.HtmlInputButton Button1;
	
	    protected string intUserID;
		protected byte[] bytes;

		//protected int upfileLength;
		//public string displaySign;

		protected void Page_Load(object sender, System.EventArgs e)
		{
			/*if (Session["userid"]==null)
			{
				Response.Write ("<script>alert('超时,请重新登录');top.location.href='login.aspx';</script>");
				return ;
			}*/
			//ImageButtonSave.Attributes["onclick"] =" return check(); ";
		
			try
			{
				intUserID =Request.QueryString ["UserID"].ToString ();
				ViewState["modify"]="0";
			}
			catch
			{
				intUserID=Session["userid"].ToString ();
				ViewState["modify"]="1";
			}
			// 在此处放置用户代码以初始化页面
			
			
			if (!IsPostBack)
			{
				
				ViewState["intUserID"]=intUserID;
			    
				this.Bind ();
		
				//this.initDate();
				this.select();
			}
			else
			{
				
			}
			
			
		}
		
		private void select()
		{
		
			
			string sql="SELECT * FROM Users WHERE id='"+intUserID+"'";
			
			DataSet ds=dc.getBinding (sql,"Users");
            TextBoxUserName.Text =ds.Tables[0].Rows[0]["username"].ToString (); 

			string qxmc =ds.Tables[0].Rows[0]["qxmc"].ToString();
            UintID.Text = qxmc.Trim();

            string strModiSql = "SELECT bmname FROM ExigenceDegree WHERE id='" + ds.Tables[0].Rows[0]["cjsn"].ToString() + "'";
			ArrayList al=dc.getData (strModiSql);
			if(al.Count > 0)
				DeptName.Text =al[0].ToString ();

		}

		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.ImageButtonSave.Click += new System.Web.UI.ImageClickEventHandler(this.ImageButtonSave_Click);
			this.ImageButtonCancel.Click += new System.Web.UI.ImageClickEventHandler(this.ImageButtonCancel_Click);

		}
		#endregion
    
		/// <summary>
		/// 清空各输入框,将各项的值设为默认值
		/// </summary>
		/// <param name="e"></param>
		private void CleanUp()
		{
			this.TextBoxUserName.Text="";
            
			this.DeptName.SelectedIndex=0;

            this.UintID.SelectedIndex = 0;
	
		}
		/// <summary>
		/// 激活保存按钮及各输入框
		/// </summary>
		private void Stimulate()
		{   this.TextBoxUserName.ReadOnly=false;
            
            this.DeptName.Enabled=true;
            this.UintID.Enabled = true;

		}
	

		private void Bind()
		{
		
            string strCom3= "SELECT id,bmname FROM ExigenceDegree order by id asc";
            DataSet ds3=dc.getBinding(strCom3,"ExigenceDegree");
            this.DeptName.DataSource = ds3.Tables["ExigenceDegree"];
			DeptName.DataTextField=ds3.Tables[0].Columns["bmname"].ToString ();
			DeptName.DataValueField= ds3.Tables[0].Columns["id"].ToString ();
			this.DeptName.DataBind ();

            string strCom4 = "SELECT RoleID,RoleName FROM Roles";
            DataSet ds4 = dc.getBinding(strCom4, "Roles");
            this.UintID.DataSource = ds4.Tables["Roles"];
            UintID.DataTextField = ds4.Tables[0].Columns["RoleName"].ToString(); ;
            UintID.DataValueField = ds4.Tables[0].Columns["RoleID"].ToString(); ;
            this.UintID.DataBind();

		
		}
		
	
		
		/// <summary>
		/// 修改人员信息
		/// </summary>
		/// <param name="sender"></param>
		/// <param name="e"></param>
		private void ImageButtonSave_Click(object sender, System.Web.UI.ImageClickEventArgs e)
		{
			if(Page.IsValid)
			{
			
				dc=new DatabaseConnect ();
				string texUserName=this.TextBoxUserName.Text.Trim().Replace ("'","''");

                int intDepartmentID=Convert.ToInt32 (DeptName.SelectedItem.Value);
                string txtdepname = DeptName.SelectedItem.Text.Trim();

                int intqx = Convert.ToInt32(UintID.SelectedItem.Value);
                string txtqx = UintID.SelectedItem.Text.Trim();
                

				//获取各项的值
				if (texUserName=="")//检查姓名项是否为空
				{
					this.RegisterClientScriptBlock("","<script>alert(\"请输入姓名\");</script>");
					return;
				
				}
				else
				{
					RWSB.Manage.checkUser cu=new checkUser ();
					if (cu.ExistUser( texUserName,int.Parse (intUserID)))
					{
						Page.RegisterStartupScript ("","<script>alert('"+texUserName+"己经存在!');Form1.TextBoxUserName.focus();</script>");
						return;
					}

                    string sql = "update Users set cjsn='" + intDepartmentID + "',cjmc='" + txtdepname + "',UserName='" + texUserName + "',qxid='" + intqx + "',qxmc='" + txtqx + "'where id='" + intUserID + "'";
					//Upfile();
					System.Data.SqlClient.SqlConnection  cn=dc.GetConn();
					System.Data .SqlClient .SqlTransaction trans=cn.BeginTransaction ();
					System.Data.SqlClient .SqlCommand command=new System.Data.SqlClient.SqlCommand ();
					command.Connection=cn;
					command.Transaction =trans;
					command.CommandText =sql;
					command.ExecuteNonQuery ();

					try
					{
						trans.Commit ();
					}
					catch(Exception er)
					{
						Response.Write (er.Message );
						Response.End ();

					}
					cn.Close ();
                    			
					if (ViewState["modify"].ToString ()=="1")
					{
						Response.Redirect ("Accounts_UserEdit.aspx");
					}
					else
					{
						Response.Redirect("Accounts_Users.aspx",true);
					}		
					
				}
			}
		}


			
		/// <summary>
		/// 清空文本框中的内容
		/// </summary>
		/// <param name="sender"></param>
		/// <param name="e"></param>
		private void ImageButtonCancel_Click(object sender, System.Web.UI.ImageClickEventArgs e)
	
		{
			if (ViewState["modify"].ToString ()=="1")
			{
				Response.Redirect ("Accounts_UserEdit.aspx");
			}
			else
			{
				Response.Redirect("Accounts_UserEdit.aspx?UserID="+intUserID+"");
			}		
		}


        
}
}