accounts_useradd.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;

namespace RWSB.Manage
{
	/// <summary>
	/// Accounts_User 的摘要说明。
	/// </summary>
	public partial class Accounts_UserAdd : RWSB.PageBase
	{
		
		private DatabaseOper.DatabaseConnect dc = new DatabaseOper.DatabaseConnect();
		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();";
			
			if (!IsPostBack)
			{
				this.Bind();
				//this.initDate ();

			} 
		}
		/// <summary>
		/// 绑定部门、职务、职称下拉列表框，单位
		/// </summary>
		private void Bind()
		{
			
            string strCom3 = "SELECT id,bmname FROM ExigenceDegree order by showorder 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="e"></param>
		private void CleanUp()
		{
			this.TextBoxUserName.Text="";
            this.DeptName.SelectedIndex=0;
            this.UintID.SelectedIndex = 0;
			
		}
	

		#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="sender"></param>
		/// <param name="e"></param>
		private void ImageButtonCancel_Click(object sender, System.Web.UI.ImageClickEventArgs e)
		{
			this.CleanUp();
			
		}
		private bool Check()
		{
			dc=new DatabaseConnect();
			string sql="select count(*) as count from users";
			int count=Convert.ToInt32(dc.GetObjectBySql(sql));
			if(count>=1000)
			{
				return false;
			}
			else
			{
				return true;
			}
		}
		
        	
		/// <summary>
		/// 保存人员信息
		/// </summary>
		/// <param name="sender"></param>
		/// <param name="e"></param>
	
		private void ImageButtonSave_Click(object sender, System.Web.UI.ImageClickEventArgs e)
		{
			if(Page.IsValid)
			{
				if(Check())
				{
					dc=new DatabaseConnect ();
				    
					string texUserName=this.TextBoxUserName.Text.Trim().Replace ("'","''");
					checkUser cu=new checkUser ();
					if (cu.ExistUser(texUserName)) 
					{
						Page.RegisterStartupScript ("","<script>alert('"+texUserName+"己经存在!');Form1.TextBoxUserName.focus();</script>");
						return;
					}
					
                    //获取部门id和名称
                    int intDepartmentID = Convert.ToInt32(DeptName.SelectedItem.Value);
					string textbmmc = this.DeptName.SelectedItem.Text.Trim();

                    //获取权限id和名称
                    int intqxID = Convert.ToInt32(UintID.SelectedItem.Value);
                    string textUintID = this.UintID.SelectedItem.Text.Trim();
                    
					
					if (texUserName!="")//检查姓名项是否为空
					{
				       object o=dc.GetObjectBySql ("select max(DisplayOrder) from Users");
						int DisplayOrder=int.Parse(o.ToString())+1;
				
						string sql="insert into Users(cjsn,cjmc,UserName,Password,qxmc,qxid,DisplayOrder)"+
                            "values('" + intDepartmentID + "','" + textbmmc + "','" + texUserName + "','1111','" + textUintID + "','" + intqxID + "'," + DisplayOrder.ToString() + ")"; 
						dc.addData (sql);

						sql ="select id from users where username='"+texUserName+"'";
						o= dc.GetObjectBySql (sql);
						if (o!=null)
						{
							RWSB.cs.createDefaultPower cp=new RWSB.cs.createDefaultPower ();
							cp.createUserRole(o.ToString (),"个人管理") ;
						}
						Response.Redirect("accounts_users.aspx");
				
				
					}
				}
				else
				{
					Page.RegisterStartupScript("","<script>alert('');</script>");
					return;
				}
			}
			

		}

	}
	/// <summary>
	/// checkUser :检验用户。
	/// 
	/// </summary>

}