void btn_Update_Click(object sender, EventArgs e) { //首先检查Email是否有重复 if (sm.Email != this.txtEmail.Text) { //检查除了自己本身之外是否重复 if (MemberManage.ExistsEmailExceptUser(this.txtEmail.Text, sm.UserId)) { this.ltMsg.Text = "Email重复!"; return; } sm.Email = this.txtEmail.Text; } sm.Company = this.txtCompany.Text; sm.Fax = this.txtFax.Text; sm.InterestProduct = this.txtInterestProduct.Text; sm.IsReceiveNewProductEmail = this.cbResive.Checked; sm.Phone = this.txtPhone.Text; sm.RealName = this.txtRealName.Text; sm.Update(); this.ltMsg.Text = "更新成功!"; }
public ActionResult Register(MemberDTO member) { if (CheckEmailHasBeUsed(member.Email)) { ModelState.AddModelError(string.Empty, "You input email has registed by other people."); } if (member.Password.Length < 8) { ModelState.AddModelError(string.Empty, "Password must be longer than 8 chars."); } if (ModelState.IsValid) { try { //Encrypt Password member.Password = Utils.Md5Hash(salt + member.Password); member.ConfirmPassword = member.Password; MemberManage.Create(member); return(RedirectToAction("Login", "Member")); } catch (Exception ex) { ModelState.AddModelError(string.Empty, ex); } } return(View()); }
/// <summary> /// 构造方法 /// </summary> public MemberAppService(IRepository <Member, int> memberRepository, MemberManage memberManage ) { _memberRepository = memberRepository; _memberManage = memberManage; }
public SiteMember(int userId) { DataRow dr = MemberManage.GetUserInfo(userId); if (dr != null) { FillHelper.Fill(dr, this); } }
private bool IsValid(string email, string password) { bool IsValid = false; Member m = MemberManage.Get(email); if (m != null && Utils.Md5Hash(salt + password) == m.Password) { IsValid = true; } return(IsValid); }
public int UpdateMember(MemberManage member) { string sql = "UPDATE [dbo].[T_MemberManage] SET [Remark]=@Remark,[QQ]=@QQ,[SortLevel]=@SortLevel WHERE [Id]=@Id"; using (var dbOperator = new DbOperator(Provider, ConnectionString)) { dbOperator.AddParameter("Remark", member.Remark); dbOperator.AddParameter("QQ", member.QQ.Join(",")); dbOperator.AddParameter("Id", member.Id); dbOperator.AddParameter("SortLevel", member.SortLevel); return(dbOperator.ExecuteNonQuery(sql)); } }
/// <summary> /// Upgrade member to premium, if they have consumed over than $1000.00 /// </summary> /// <param name="member"></param> private void CheckAndUpgradeMember(Member member) { if (member.Role == Role.Basic) { double?total = (from order in db.Orders where order.Member.Id == member.Id select order.TotalPrice).Sum(); if (total >= 1000.0) { MemberManage.UpgradePremium(member); } } }
public int InsertMember(Guid divideGroup, MemberManage member) { string sql = "INSERT INTO [dbo].[T_MemberManage]([Id],[Remark],[QQ],[DivideGroupId],[SortLevel]) VALUES(@Id,@Remark,@QQ,@DivideGroup,@SortLevel)"; using (var dbOperator = new DbOperator(Provider, ConnectionString)) { dbOperator.AddParameter("Id", member.Id); dbOperator.AddParameter("Remark", member.Remark); dbOperator.AddParameter("QQ", member.QQ.Join(",")); dbOperator.AddParameter("DivideGroup", divideGroup); dbOperator.AddParameter("SortLevel", member.SortLevel); return(dbOperator.ExecuteNonQuery(sql)); } }
public SiteMember(string userName) { if (string.IsNullOrEmpty(userName) == true) { throw new ArgumentException("loginName is null or empty"); } DataRow dr = MemberManage.GetUserInfo(userName); if (dr != null) { FillHelper.Fill(dr, this); } }
/// <summary> /// 插入或编辑 /// </summary> /// <param name="model"></param> /// <returns></returns> public static MemberInfo Create(MemberInfo model) { if (model.Id == 0) { int id = MemberManage.Insert(model); model.Id = id; } else { MemberManage.Update(model); } return(model); }/// <summary>
public int Update() { if (this.UserId == 0) { //Add this.UserId = MemberManage.Add(this); } else { //Update MemberManage.Update(this); } return(this.UserId); }
void btnSave_Click(object sender, EventArgs e) { SiteMember sm = new SiteMember(userId); sm.IsPass = cbIsPass.Checked; sm.Update(); DataRow dr = MemberManage.GetUserInfo(userId); if (cbIsPass.Checked) { Roles.AddUsersToRoles(new string[] { dr["UserName"].ToString() }, new string[] { "Admin" }); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string memberId = Request.QueryString["memberId"]; if (!string.IsNullOrWhiteSpace(memberId)) { this.lblAddOrUpdate.Text = "修改"; MemberManage view = OnLineCustomerService.QueryMember(Guid.Parse(memberId)); this.txtMemberExplain.InnerText = view.Remark; this.hfdQQ.Value = view.QQ.Join(","); this.txtSortLevel.Text = view.SortLevel.ToString(); } } }
/// <summary> /// 插入成员管理 /// </summary> /// <param name="divideGroup">分组信息Id</param> /// <param name="view">成员管理信息</param> /// <param name="operatorAccount">操作员帐号</param> public static void InsertMember(Guid divideGroup, MemberView view, PublishRoles role, string operatorAccount) { var model = new MemberManage(view.Id); model.Remark = view.Remark; model.QQ = view.QQ; model.SortLevel = view.SortLevel; var reposity = Factory.CreateOnLineCustomerRepository(); reposity.InsertMember(divideGroup, model); // 记录日志 OperatorRole operatorRole = getOperatorRole(role); string content = string.Format("分组Id:{0},成员说明:{1},成员QQ:{2}", divideGroup, view.Remark, view.QQ.Join(",")); saveAddLog("成员信息", content, operatorRole, view.Id.ToString(), operatorAccount); }
/// <summary> /// 更新成员管理信息 /// </summary> /// <param name="member">成员管理Id</param> /// <param name="view">成员管理Id</param> /// <param name="operatorAccount"></param> public static void UpdateMember(MemberView view, PublishRoles role, string operatorAccount) { var member = OnLineCustomerService.QueryMember(view.Id); var model = new MemberManage(view.Id); model.QQ = view.QQ; model.Remark = view.Remark; model.SortLevel = view.SortLevel; var reposity = Factory.CreateOnLineCustomerRepository(); reposity.UpdateMember(model); // 记录日志 OperatorRole operatorRole = getOperatorRole(role); string originalContent = string.Format("成员说明:{0},成员QQ:{1}", member.Remark, member.QQ.Join(",")); string newContent = string.Format("成员说明:{0},成员QQ:{1}", view.Remark, view.QQ.Join(",")); saveUpdateLog("成员信息", originalContent, newContent, operatorRole, view.Id.ToString(), operatorAccount); }
void btn_Login_Click(object sender, EventArgs e) { if (MemberManage.Validator(this.txtUserName.Text, this.txtPwd.Text)) { //管理员不能在这登录 bool isInAdmin = Roles.IsUserInRole(this.txtUserName.Text, "Admin"); if (isInAdmin) { this.ltMsg.Text = "用户名或密码错误!"; return; } Login(this.txtUserName.Text, this.txtPwd.Text); Response.Redirect("/"); } else { this.ltMsg.Text = "用户名或密码错误!"; } }
public MemberManage QueryMember(Guid member) { MemberManage view = null; string sql = "SELECT [Remark],[QQ],[SortLevel] FROM [dbo].[T_MemberManage] WHERE [Id]=@Id"; using (var dbOperator = new DbOperator(Provider, ConnectionString)) { dbOperator.AddParameter("Id", member); using (var reader = dbOperator.ExecuteReader(sql)) { while (reader.Read()) { view = new MemberManage(member); view.Remark = reader.GetString(0); view.QQ = reader.GetString(1).Split(new char[] { ',' }); view.SortLevel = reader.GetInt32(2); } } } return(view); }
void btnRegister_Click(object sender, EventArgs e) { if (MemberManage.Exists(this.txtUserName.Text, this.txtUserEmail.Text)) { this.ltMsg.Text = "用户名或Email已存在"; return; } SiteMember sm = new SiteMember(); sm.Email = this.txtUserEmail.Text; sm.UserName = this.txtUserName.Text; sm.UserPwd = this.txtConfirmUserPwd.Text; int i = sm.Update(); if (i > 0) { this.ltMsg.Text = "用户已经创建,请等待审核!"; } }
public IEnumerable <MemberManage> QueryMembers(Guid divideGroup) { var result = new List <MemberManage>(); string sql = "SELECT [Id],[Remark],[QQ] FROM [dbo].[T_MemberManage] WHERE [DivideGroupId]=@DivideGroup ORDER BY SortLevel"; using (var dbOperator = new DbOperator(Provider, ConnectionString)) { dbOperator.AddParameter("DivideGroup", divideGroup); using (var reader = dbOperator.ExecuteReader(sql)) { while (reader.Read()) { MemberManage member = new MemberManage(reader.GetGuid(0)); member.Remark = reader.IsDBNull(1) ? string.Empty : reader.GetString(1); member.QQ = reader.GetString(2).Split(new char[] { ',' }); result.Add(member); } } } return(result); }
void btnLogin_Click(object sender, EventArgs e) { if (MemberManage.Validator(this.txtUserName.Text, this.txtUserPwd.Text)) { SiteMember sm = new SiteMember(this.txtUserName.Text); if (!sm.IsPass) { this.ltMsg.Text = "您还没有通过审核或帐号已禁用"; } else { Login(this.txtUserName.Text, this.txtUserPwd.Text); Response.Redirect(string.Format("{0}pagesadmin/index.aspx", ResolveUrl("~"))); } } else { this.ltMsg.Text = "用户名或密码错误!"; } }
void btn_Ok_Click(object sender, EventArgs e) { //-1,说明没有此用户名名 //0,说明有此用户名,但是Email错误 //1,说明正确 int i = MemberManage.FindPwd(this.txtUserName.Text, this.txtEmail.Text); if (i == -1) { this.ltMsg.Text = "用户名不存在!"; return; } if (i == 0) { this.ltMsg.Text = "Email不正确!"; return; } SiteMember sm = new SiteMember(this.txtUserName.Text); this.ltMsg.Text = string.Format("请牢记您的密码:{0},并尽快更新!", sm.UserPwd); }
/// <summary> /// Email是否存在 /// </summary> /// <param name="email"></param> /// <returns></returns> public static bool EmailExists(string email) { return(MemberManage.EmailExists(email, 0)); }
/// <summary> /// Email是否存在 /// </summary> /// <param name="email"></param> /// <param name="userId"></param> /// <returns></returns> public static bool EmailExists(string email, int userId) { return(MemberManage.EmailExists(email, userId)); }
/// <summary> /// 根据用户ID获取用户基本信息 /// </summary> /// <param name="userId"></param> /// <returns></returns> public static MemberInfo Get(int userId) { return(MemberManage.Get(userId)); }
/// <summary> /// 根据用户名获取用户基本信息 /// </summary> /// <param name="userName"></param> /// <returns></returns> public static MemberInfo Get(string userName) { return(MemberManage.Get(userName)); }
/// <summary> /// 更新用户基本信息 /// </summary> /// <param name="model"></param> /// <returns></returns> public static int Update(MemberInfo model) { return(MemberManage.Update(model)); }
/// <summary> /// 添加公司信息 /// </summary> /// <param name="model"></param> /// <returns></returns> public static int InsertCompany(CompanyInfo model) { //取消密码MD5 //model.Password = Controleng.Common.Utils.MD5(model.Password); return(MemberManage.InsertCompany(model)); }
/// <summary> /// 下载用户基本信息 /// 2012-12-17 /// </summary> /// <param name="ids"></param> /// <returns></returns> public static DataTable DownloadBaseInfo(int[] ids, DateTime startDate, DateTime endDate) { return(MemberManage.DownloadBaseInfo(ids, startDate, endDate)); }
/// <summary> /// 查询,右LIKE /// </summary> /// <param name="userName"></param> /// <returns></returns> public static List <string> AdminSearchList(string userName) { return(MemberManage.AdminSearchList(userName)); }
/// <summary> /// 管理员列表 /// </summary> /// <returns></returns> public static List <string> AdminMemberList() { return(MemberManage.AdminMemberList()); }