public void BindData() { #region //if (!Context.User.Identity.IsAuthenticated) //{ // return; //} //AccountsPrincipal user = new AccountsPrincipal(Context.User.Identity.Name); //if (user.HasPermissionID(PermId_Modify)) //{ // gridView.Columns[6].Visible = true; //} #endregion DataSet ds = new DataSet(); StringBuilder strWhere = new StringBuilder(); if (txtKeyword.Text.Trim() != "") { strWhere.AppendFormat("MembName like '%{0}%' and Status = '6' ", txtKeyword.Text.Trim()); } else { strWhere.AppendFormat(" Status = '6' "); } ds = bll.GetList(strWhere.ToString()); gridView.DataSource = ds; gridView.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { Cultural.BLL.Member staffService = new Cultural.BLL.Member(); string loginuser = this.Request["u"].Trim(); string password = this.Request["p"].Trim(); String where = " LoginID='{0}' and Password='******'"; where = string.Format(where, loginuser, password); DataSet StaffData = staffService.GetList(where); if (StaffData != null && StaffData.Tables[0].Rows.Count > 0) { Cultural.Model.Member staff = new Cultural.Model.Member(); Session.Add("MemberID", StaffData.Tables[0].Rows[0]["MemberID"].ToString().Trim()); Session.Add("LoginID", StaffData.Tables[0].Rows[0]["LoginID"].ToString().Trim()); Session.Add("MembName", StaffData.Tables[0].Rows[0]["MembName"].ToString().Trim()); Session.Add("Status", StaffData.Tables[0].Rows[0]["Status"].ToString().Trim()); Response.Redirect("Main.aspx"); } else { //this.Response.Write("用户名或密码错误!登陆失败"); Response.Redirect("login.aspx?fg=0"); } }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; string name = context.Request["MemName"]; Cultural.BLL.Member bll = new Cultural.BLL.Member(); if (name.Trim().Length < 3 || name.Trim().Length > 20 || bll.GetList(string.Format(" LoginID = '{0}' ", name)).Tables[0].Rows.Count > 0) { context.Response.Write("Exist"); } else { context.Response.Write("None"); } }
protected void btnSave_Click(object sender, EventArgs e) { Cultural.BLL.Member bll = new Cultural.BLL.Member(); string strErr = ""; if (this.txtStaffName.Text.Trim().Length == 0) { strErr += "姓名不能为空!\\n"; } if (this.txtLoginID.Text.Trim().Length == 0) { strErr += "注册名不能为空!\\n"; } if (this.txtPassword.Text.Trim().Length == 0) { strErr += "密码不能为空!\\n"; } if (this.txtPassConfirm.Text.Trim().Length == 0) { strErr += "必须确认密码!\\n"; } if (this.txtPassConfirm.Text.Trim() != this.txtPassword.Text.Trim()) { strErr += "两次密码不同!\\n"; } if (bll.GetList(string.Format(" LoginID = '{0}' ", txtLoginID.Text.Trim())).Tables[0].Rows.Count > 0) { strErr += "登录名已被使用!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } string LoginID = this.txtLoginID.Text; string Password = this.txtPassword.Text; string StaffName = this.txtStaffName.Text; string Gender = ddlGender.SelectedItem.Text.Trim(); string Phone = this.txtPhone.Text; string Email = this.txtEmail.Text; string Address = this.txtAddress.Text; string Job = this.txtJob.Text; string resume = this.txtResume.Text.Trim(); Cultural.BLL.Department dbll = new Cultural.BLL.Department(); Cultural.Model.Department depart = new Cultural.Model.Department(); List <Cultural.Model.Department> departList = dbll.GetModelList(string.Format(" DepartName = '{0}'", txtDepartID.Text.Trim())); depart = departList.Count > 0 ? departList[0] : null; int departID = 0; if (depart == null) { depart = new Cultural.Model.Department(); depart.DepartName = txtDepartID.Text.Trim(); dbll.Add(depart); departID = dbll.GetMaxId() - 1; } else { departID = depart.DepartID; } Cultural.Model.Member member = new Cultural.Model.Member(); member.LoginID = LoginID; member.Password = Password; member.MembName = StaffName; member.Gender = Gender; member.Phone = Phone; member.Email = Email; member.Address = Address; member.JobName = Job; member.DepartID = departID; member.RegTime = string.Format("{0}-{1}-{2}", DateTime.Now.Year, DateTime.Now.Month.ToString().PadLeft(2, '0'), DateTime.Now.Day.ToString().PadLeft(2, '0')); member.Status = "6"; member.PhotoURL = ""; member.Resume = resume; bll.Add(member); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "注册成功,请等待管理员审核!", "../login.aspx"); }