accounts_useredit.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;
using OI.DatabaseOper ;
using System.IO ;
using System.Data .SqlClient ;
namespace OI.Manage
{
	/// <summary>
	/// Accounts_UserEdit 的摘要说明。
	/// </summary>
	public class Accounts_UserEdit : OI.PageBase
	{
		protected System.Web.UI.WebControls.TextBox TextBoxUserName;
		protected System.Web.UI.WebControls.DropDownList DropDownListJobLevelID;
		protected System.Web.UI.WebControls.DropDownList DropDownListSex;
	
		protected System.Web.UI.WebControls.TextBox TextBoxSchool;
		protected System.Web.UI.WebControls.TextBox TextBoxSpeciality;
		protected System.Web.UI.WebControls.DropDownList DropDownListIsMarried;
		protected System.Web.UI.WebControls.TextBox TextBoxNationality;
		protected System.Web.UI.WebControls.TextBox TextBoxNativePlace;
		protected System.Web.UI.WebControls.DropDownList DropDownListPoliticalFeature;
		protected System.Web.UI.WebControls.TextBox TextBoxIDCard;
		protected System.Web.UI.WebControls.TextBox TextBoxTelephone;
		protected System.Web.UI.WebControls.TextBox TextBoxMobile;
		protected System.Web.UI.WebControls.TextBox TextBoxEmail;
		protected System.Web.UI.WebControls.TextBox TextBoxZipCode;
		protected System.Web.UI.WebControls.DropDownList DropDownListState;
		protected System.Web.UI.WebControls.TextBox TextBoxContent;
		
		protected System.Web.UI.WebControls.DropDownList DropDownListBirthdayY;
		protected System.Web.UI.WebControls.DropDownList DropDownListBirthdayM;
		protected System.Web.UI.WebControls.DropDownList DropDownListBirthdayD;
		protected System.Web.UI.WebControls.DropDownList DropDownListContractDateY;
		protected System.Web.UI.WebControls.DropDownList DropDownListContractDateM;
		protected System.Web.UI.WebControls.DropDownList DropDownListContractDateD;
		protected System.Web.UI.WebControls.DropDownList DropDownListContractEndDateY;
		protected System.Web.UI.WebControls.DropDownList DropDownListContractEndDateM;
		protected System.Web.UI.WebControls.DropDownList DropDownListContractEndDateD;
		protected System.Web.UI.WebControls.DropDownList DropDownListJoinDateD;
		protected System.Web.UI.WebControls.DropDownList DropDownListJoinDateM;
		protected System.Web.UI.WebControls.DropDownList DropDownListJoinDateY;
		protected System.Web.UI.WebControls.DropDownList DropDownListProfessionalLevelID;
		private int[] daysCommon={31,28,31,30,31,30,31,31,30,31,30,31};
		private int[] daysLeap={31,29,31,30,31,30,31,31,30,31,30,31};
		protected System.Web.UI.HtmlControls.HtmlForm Form1;
		private DatabaseOper.DatabaseConnect dc = new DatabaseOper.DatabaseConnect();
		protected System.Web.UI.WebControls.Label Label1;
      	protected System.Web.UI.HtmlControls.HtmlInputButton Button1;
		protected System.Web.UI.WebControls.TextBox TextBoxAddress;
		protected System.Web.UI.WebControls.ImageButton ImageButtonSave;
		protected System.Web.UI.WebControls.ImageButton ImageButtonCancel;
		protected System.Web.UI.WebControls.TextBox UnitID;
		protected System.Web.UI.HtmlControls.HtmlInputHidden DeptID;
		protected System.Web.UI.HtmlControls.HtmlInputText DeptName;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator1;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator2;
	
	    protected string intUserID;
		protected byte[] bytes;
		protected int upfileLength;
		protected System.Web.UI.WebControls.ImageButton imgbtn_sign;
		public string displaySign;
		private void Page_Load(object sender, System.EventArgs e)
		{
			if (Session["userid"]==null)
			{
				Response.Write ("<script>alert('超时,请重新登录');top.location.href='../userpass.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";
			}
			// 在此处放置用户代码以初始化页面
			Displayimg();
			
			if (!IsPostBack)
			{
				//intUserID=Request.QueryString ["UserID"].ToString ();
				ViewState["intUserID"]=intUserID;
			    
				this.Bind ();
		
				this.initDate();
				this.select();
			}
			else
			{
				//intUserID=ViewState["intUserID"].ToString ();
			}
			if (ViewState["modify"].ToString ()=="0")
			{
				imgbtn_sign.Visible =false;
			}
			else
			{
				peronalSign(ViewState["intUserID"].ToString ());
			}
				
			
		}
		private void peronalSign(string userid)
		{
			string str="select count(*) from personalsign where userid="+userid;
			try
			{ 
				int i=int.Parse (dc.GetValueBySql (str));
				if( i>0)
				{
					imgbtn_sign.Attributes["onclick"]="return open_win('personalSignmodify.aspx?userid="+userid+"');";
				}
				else
				{
					imgbtn_sign.Attributes["onclick"]="return open_win('personalSign.aspx?userid="+userid+"');";
				}
			}
			catch(Exception er)
			{
				Response.Write (er.Message );
				Response.End ();
			}

			
		}
		private void select()
		{
		
			
			string sql="SELECT * FROM Accounts_Users WHERE userID='"+intUserID+"'";
			
			DataSet ds=dc.getBinding (sql,"Accounts_Users");
            TextBoxUserName.Text =ds.Tables[0].Rows[0]["UserName"].ToString (); 
			TextBoxNationality.Text=ds.Tables[0].Rows[0]["Nationality"].ToString (); 
			TextBoxNativePlace.Text=ds.Tables[0].Rows[0]["NativePlace"].ToString (); 
			TextBoxSchool.Text=ds.Tables[0].Rows[0]["School"].ToString (); 
			TextBoxSpeciality.Text=ds.Tables[0].Rows[0]["Speciality"].ToString ();
			TextBoxIDCard.Text=ds.Tables[0].Rows[0]["IDCard"].ToString ();
			TextBoxTelephone.Text=ds.Tables[0].Rows[0]["Telephone"].ToString ();
			TextBoxMobile.Text=ds.Tables[0].Rows[0]["Mobile"].ToString ();
			TextBoxEmail.Text=ds.Tables[0].Rows[0]["Email"].ToString ();
			TextBoxZipCode.Text=ds.Tables[0].Rows[0]["ZipCode"].ToString ();
			TextBoxAddress.Text=ds.Tables[0].Rows[0]["Address"].ToString ();
			TextBoxContent.Text=ds.Tables[0].Rows[0]["Content"].ToString ();
			
			//选择单位
//			try
//			{
//				this.UnitID.SelectedValue=ds.Tables[0].Rows[0]["UnitID"].ToString ();
//			}
//			catch
//			{
//			}
			if (ds.Tables[0].Rows[0]["Sex"].ToString ()=="True")
			{
				DropDownListSex.Items.FindByValue("1").Selected =true;
			}
			else
			{
				DropDownListSex.Items.FindByValue("0").Selected =true;
			}
			if (ds.Tables[0].Rows[0]["IsMarried"].ToString ()=="True") 
			{
				DropDownListIsMarried.Items.FindByValue("1").Selected =true;
			}
			else
			{
				DropDownListIsMarried.Items.FindByValue("0").Selected =true;
			}
			if (ds.Tables[0].Rows[0]["State"].ToString ()=="True") 
			{
				DropDownListState.Items.FindByValue("1").Selected =true;
			}
			else
			{
				DropDownListState.Items.FindByValue("0").Selected =true;
			}
			DropDownListPoliticalFeature.Items.FindByValue(ds.Tables[0].Rows[0]["PoliticalFeature"].ToString()).Selected=true;
			System.DateTime Birthday=System.DateTime.Parse (ds.Tables[0].Rows[0]["Birthday"] .ToString());
			string year,month,day;
			year=Birthday.Year.ToString ();
			month=Birthday.Month.ToString () ;
			day=Birthday.Day .ToString ();
			try
			{
				DropDownListBirthdayY.Items.FindByValue(DropDownListBirthdayY.SelectedValue).Selected =false; 
			}
			catch
			{
			}

			try
			{
				DropDownListBirthdayY.Items.FindByValue(year).Selected=true;
			}
			catch
			{}
			DropDownListBirthdayM.Items.FindByValue(DropDownListBirthdayM.SelectedValue).Selected =false; 
		    DropDownListBirthdayM.Items.FindByValue(month).Selected=true;   //pf
			DropDownListBirthdayD.Items.FindByValue(DropDownListBirthdayD.SelectedValue).Selected =false; 
			DropDownListBirthdayD.Items.FindByValue(day).Selected=true;
			//DropDownListDepartmentID.Items.FindByValue(ds.Tables[0].Rows[0]["DepartmentID"].ToString()).Selected=true;
			
			UnitID.Text =ds.Tables[0].Rows[0]["UnitID"].ToString();
			string strModiSql="SELECT DepartmentName FROM departments WHERE DepartmentID='"+ds.Tables[0].Rows[0]["DepartmentID"].ToString()+"'";
			ArrayList al=dc.getData (strModiSql);
			if(al.Count >0)
				DeptName.Value =al[0].ToString ();
			DeptID.Value =ds.Tables [0].Rows [0]["DepartmentID"].ToString ();//Modifier:wu Date:2004-1-31

			DropDownListProfessionalLevelID.Items.FindByValue(ds.Tables[0].Rows[0]["ProfessionalLevelID"].ToString()).Selected=true;
			DropDownListJobLevelID.Items.FindByValue(ds.Tables[0].Rows[0]["JobLevelID"].ToString()).Selected=true;

		}

		#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);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion
    
		/// <summary>
		/// 清空各输入框,将各项的值设为默认值
		/// </summary>
		/// <param name="e"></param>
		private void CleanUp()
		{
			this.TextBoxUserName.Text="";
			this.TextBoxNationality.Text="";
			this.TextBoxZipCode.Text="";
			this.TextBoxTelephone.Text="";
			this.TextBoxSpeciality.Text="";
			this.TextBoxSchool.Text="";
			this.TextBoxNativePlace.Text="";
			this.TextBoxMobile.Text="";
			this.TextBoxIDCard.Text="";
			this.TextBoxEmail.Text="";
			this.TextBoxContent.Text="";
			this.TextBoxAddress.Text="";
			this.DropDownListSex.SelectedIndex=0;
			this.DropDownListIsMarried.SelectedIndex=0;
			this.DropDownListPoliticalFeature.SelectedIndex=0;
			this.DropDownListJobLevelID.SelectedIndex=0;