/// <summary> /// 用户升级 /// </summary> public bool Upgrade(int id) { if (!Exists(id)) { return(false); } Model.users.users model = GetModel(id); Model.users.user_groups groupModel = new user_groups().GetUpgrade(model.group_id, model.exp); if (groupModel == null) { return(false); } int result = UpdateField(id, "group_id=" + groupModel.id); if (result > 0) { //增加积分 if (groupModel.point > 0) { new BLL.users.user_point_log().Add(model.id, model.user_name, groupModel.point, "升级获得积分", true); } //增加金额 if (groupModel.amount > 0) { new BLL.users.user_amount_log().Add(model.id, model.user_name, OSEnums.AmountTypeEnum.SysGive.ToString(), groupModel.amount, "升级赠送金额", 1); } } return(true); }
private bool DoAdd() { bool result = false; Model.users.users model = new Model.users.users(); BLL.users.users bll = new BLL.users.users(); model.group_id = int.Parse(ddlGroupId.SelectedValue); model.status = int.Parse(rblStatus.SelectedValue); //检测用户名是否重复 if (bll.Exists(txtUserName.Text.Trim())) { return(false); } //model.user_name = Utils.DropHTML(txtUserName.Text.Trim()); model.user_name = Utils.GetUserNumber(model.group_id.ToString()); //检测用户名是否重复 if (bll.Exists(model.user_name.Trim())) { model.user_name = Utils.GetUserNumber(model.group_id.ToString()); } //获得6位的salt加密字符串 model.salt = Utils.GetCheckCode(6); //以随机生成的6位字符串做为密钥加密 model.password = DESEncrypt.Encrypt(txtPassword.Text.Trim(), model.salt); model.email = Utils.DropHTML(txtEmail.Text); model.nick_name = Utils.DropHTML(txtNickName.Text); model.avatar = Utils.DropHTML(txtAvatar.Text); model.sex = rblSex.SelectedValue; DateTime _birthday; if (DateTime.TryParse(txtBirthday.Text.Trim(), out _birthday)) { model.birthday = _birthday; } model.telphone = Utils.DropHTML(txtTelphone.Text.Trim()); model.mobile = Utils.DropHTML(txtMobile.Text.Trim()); model.universities = txtUniversities.Text; model.professional = txtProfessional.Text; model.goodat = txtGoodat.Text; model.workat = txtWorkat.Text; model.industry = txtIndustry.Text; model.qq = Utils.DropHTML(txtQQ.Text); model.address = Utils.DropHTML(txtAddress.Text.Trim()); model.amount = decimal.Parse(txtAmount.Text.Trim()); model.point = int.Parse(txtPoint.Text.Trim()); model.exp = int.Parse(txtExp.Text.Trim()); model.reg_time = DateTime.Now; model.reg_ip = OSRequest.GetIP(); if (bll.Add(model) > 0) { AddAdminLog(OSEnums.ActionEnum.Add.ToString(), "添加用户:" + model.user_name); //记录日志 result = true; } return(result); }
private bool DoEdit(int _id) { bool result = false; BLL.users.users bll = new BLL.users.users(); Model.users.users model = bll.GetModel(_id); if (model.status != int.Parse(rblStatus.SelectedValue) && int.Parse(rblStatus.SelectedValue) == 0) { flag = 1; } model.group_id = int.Parse(ddlGroupId.SelectedValue); model.status = int.Parse(rblStatus.SelectedValue); //判断密码是否更改 if (txtPassword.Text.Trim() != defaultpassword) { //获取用户已生成的salt作为密钥加密 model.password = DESEncrypt.Encrypt(txtPassword.Text.Trim(), model.salt); } model.email = Utils.DropHTML(txtEmail.Text); model.nick_name = Utils.DropHTML(txtNickName.Text); model.avatar = Utils.DropHTML(txtAvatar.Text); model.sex = rblSex.SelectedValue; DateTime _birthday; if (DateTime.TryParse(txtBirthday.Text.Trim(), out _birthday)) { model.birthday = _birthday; } model.universities = txtUniversities.Text; model.professional = txtProfessional.Text; model.goodat = txtGoodat.Text; model.workat = txtWorkat.Text; model.industry = txtIndustry.Text; model.telphone = Utils.DropHTML(txtTelphone.Text.Trim()); model.mobile = Utils.DropHTML(txtMobile.Text.Trim()); model.qq = Utils.DropHTML(txtQQ.Text); model.address = Utils.DropHTML(txtAddress.Text.Trim()); model.amount = Utils.StrToDecimal(txtAmount.Text.Trim(), 0); model.point = Utils.StrToInt(txtPoint.Text.Trim(), 0); model.exp = Utils.StrToInt(txtExp.Text.Trim(), 0); if (bll.Update(model)) { AddAdminLog(OSEnums.ActionEnum.Edit.ToString(), "修改用户信息:" + model.user_name); //记录日志 result = true; } return(result); }
private void ShowInfo(int _id) { BLL.users.users bll = new BLL.users.users(); Model.users.users model = bll.GetModel(_id); ddlGroupId.SelectedValue = model.group_id.ToString(); rblStatus.SelectedValue = model.status.ToString(); txtUserName.Text = model.user_name; txtUserName.ReadOnly = true; txtUserName.Attributes.Remove("ajaxurl"); if (!string.IsNullOrEmpty(model.password)) { txtPassword.Attributes["value"] = txtPassword1.Attributes["value"] = defaultpassword; } txtEmail.Text = model.email; txtNickName.Text = model.nick_name; txtAvatar.Text = model.avatar; rblSex.SelectedValue = model.sex; if (model.birthday != null) { txtBirthday.Text = model.birthday.GetValueOrDefault().ToString("yyyy-MM-dd"); } txtTelphone.Text = model.telphone; txtMobile.Text = model.mobile; txtQQ.Text = model.qq; txtAddress.Text = model.address; txtAmount.Text = model.amount.ToString(); txtPoint.Text = model.point.ToString(); txtExp.Text = model.exp.ToString(); lblRegTime.Text = model.reg_time.ToString(); lblRegIP.Text = model.reg_ip.ToString(); txtUniversities.Text = model.universities; txtProfessional.Text = model.professional; txtGoodat.Text = model.goodat; txtWorkat.Text = model.workat; txtIndustry.Text = model.industry; //查找最近登录信息 Model.users.user_login_log logModel = new BLL.users.user_login_log().GetLastModel(model.user_name); if (logModel != null) { lblLastTime.Text = logModel.login_time.ToString(); lblLastIP.Text = logModel.login_ip; } }
//发送手机短信 protected void btnSmsPost_Click(object sender, EventArgs e) { BLL.users.users bll = new BLL.users.users(); StringBuilder str = new StringBuilder(); for (int i = 0; i < rptList.Items.Count; i++) { int id = Convert.ToInt32(((HiddenField)rptList.Items[i].FindControl("hidId")).Value); CheckBox cb = (CheckBox)rptList.Items[i].FindControl("chkId"); if (cb.Checked) { Model.users.users model = bll.GetModel(id); if (model != null && !string.IsNullOrEmpty(model.mobile)) { str.Append(model.mobile + ","); } } } if (!string.IsNullOrEmpty(str.ToString())) { Response.Redirect("user_sms.aspx?mobiles=" + Utils.UrlEncode(Utils.DelLastComma(str.ToString()))); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.users.users model) { return(dal.Add(model)); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.users.users model) { return(dal.Update(model)); }
/// <summary> /// �õ�һ������ʵ�� /// </summary> public Model.users.users GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,group_id,user_name,password,salt,email,universities,professional,membershipdues,goodat,workat,industry ,nick_name,avatar,sex,birthday,telphone,mobile,qq,address,safe_question,safe_answer,amount,point,exp,status,reg_time,reg_ip from " + databaseprefix + "users "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int,4)}; parameters[0].Value = id; Model.users.users model = new Model.users.users(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["id"].ToString() != "") { model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString()); } if (ds.Tables[0].Rows[0]["group_id"].ToString() != "") { model.group_id = int.Parse(ds.Tables[0].Rows[0]["group_id"].ToString()); } model.user_name = ds.Tables[0].Rows[0]["user_name"].ToString(); model.password = ds.Tables[0].Rows[0]["password"].ToString(); model.salt = ds.Tables[0].Rows[0]["salt"].ToString(); model.email = ds.Tables[0].Rows[0]["email"].ToString(); model.nick_name = ds.Tables[0].Rows[0]["nick_name"].ToString(); model.avatar = ds.Tables[0].Rows[0]["avatar"].ToString(); model.sex = ds.Tables[0].Rows[0]["sex"].ToString(); if (ds.Tables[0].Rows[0]["birthday"].ToString() != "") { model.birthday = DateTime.Parse(ds.Tables[0].Rows[0]["birthday"].ToString()); } model.telphone = ds.Tables[0].Rows[0]["telphone"].ToString(); model.mobile = ds.Tables[0].Rows[0]["mobile"].ToString(); model.qq = ds.Tables[0].Rows[0]["qq"].ToString(); model.address = ds.Tables[0].Rows[0]["address"].ToString(); model.safe_question = ds.Tables[0].Rows[0]["safe_question"].ToString(); model.safe_answer = ds.Tables[0].Rows[0]["safe_answer"].ToString(); if (ds.Tables[0].Rows[0]["amount"].ToString() != "") { model.amount = decimal.Parse(ds.Tables[0].Rows[0]["amount"].ToString()); } if (ds.Tables[0].Rows[0]["point"].ToString() != "") { model.point = int.Parse(ds.Tables[0].Rows[0]["point"].ToString()); } if (ds.Tables[0].Rows[0]["exp"].ToString() != "") { model.exp = int.Parse(ds.Tables[0].Rows[0]["exp"].ToString()); } if (ds.Tables[0].Rows[0]["status"].ToString() != "") { model.status = int.Parse(ds.Tables[0].Rows[0]["status"].ToString()); } if (ds.Tables[0].Rows[0]["reg_time"].ToString() != "") { model.reg_time = DateTime.Parse(ds.Tables[0].Rows[0]["reg_time"].ToString()); } if (ds.Tables[0].Rows[0]["universities"] != null) { model.universities = ds.Tables[0].Rows[0]["universities"].ToString(); } if (ds.Tables[0].Rows[0]["professional"] != null) { model.professional = ds.Tables[0].Rows[0]["professional"].ToString(); } if (ds.Tables[0].Rows[0]["membershipdues"] != null) { model.membershipdues = ds.Tables[0].Rows[0]["membershipdues"].ToString(); } if (ds.Tables[0].Rows[0]["goodat"] != null) { model.goodat = ds.Tables[0].Rows[0]["goodat"].ToString(); } if (ds.Tables[0].Rows[0]["workat"] != null) { model.workat = ds.Tables[0].Rows[0]["workat"].ToString(); } if (ds.Tables[0].Rows[0]["industry"] != null) { model.industry = ds.Tables[0].Rows[0]["industry"].ToString(); } model.reg_ip = ds.Tables[0].Rows[0]["reg_ip"].ToString(); return model; } else { return null; } }
private bool DoAdd() { bool result = false; Model.users.users model = new Model.users.users(); BLL.users.users bll = new BLL.users.users(); model.group_id = int.Parse(ddlGroupId.SelectedValue); model.status = int.Parse(rblStatus.SelectedValue); //检测用户名是否重复 if (bll.Exists(txtUserName.Text.Trim())) { return false; } //model.user_name = Utils.DropHTML(txtUserName.Text.Trim()); model.user_name = Utils.GetUserNumber(model.group_id.ToString()); //检测用户名是否重复 if (bll.Exists(model.user_name.Trim())) { model.user_name = Utils.GetUserNumber(model.group_id.ToString()); } //获得6位的salt加密字符串 model.salt = Utils.GetCheckCode(6); //以随机生成的6位字符串做为密钥加密 model.password = DESEncrypt.Encrypt(txtPassword.Text.Trim(), model.salt); model.email = Utils.DropHTML(txtEmail.Text); model.nick_name = Utils.DropHTML(txtNickName.Text); model.avatar = Utils.DropHTML(txtAvatar.Text); model.sex = rblSex.SelectedValue; DateTime _birthday; if (DateTime.TryParse(txtBirthday.Text.Trim(), out _birthday)) { model.birthday = _birthday; } model.telphone = Utils.DropHTML(txtTelphone.Text.Trim()); model.mobile = Utils.DropHTML(txtMobile.Text.Trim()); model.universities = txtUniversities.Text; model.professional = txtProfessional.Text; model.goodat = txtGoodat.Text; model.workat = txtWorkat.Text; model.industry = txtIndustry.Text; model.qq = Utils.DropHTML(txtQQ.Text); model.address = Utils.DropHTML(txtAddress.Text.Trim()); model.amount = decimal.Parse(txtAmount.Text.Trim()); model.point = int.Parse(txtPoint.Text.Trim()); model.exp = int.Parse(txtExp.Text.Trim()); model.reg_time = DateTime.Now; model.reg_ip = OSRequest.GetIP(); if (bll.Add(model) > 0) { AddAdminLog(OSEnums.ActionEnum.Add.ToString(), "添加用户:" + model.user_name); //记录日志 result = true; } return result; }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.users.users GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,group_id,user_name,password,salt,email,universities,professional,membershipdues,goodat,workat,industry ,nick_name,avatar,sex,birthday,telphone,mobile,qq,address,safe_question,safe_answer,amount,point,exp,status,reg_time,reg_ip from " + databaseprefix + "users "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; Model.users.users model = new Model.users.users(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["id"].ToString() != "") { model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString()); } if (ds.Tables[0].Rows[0]["group_id"].ToString() != "") { model.group_id = int.Parse(ds.Tables[0].Rows[0]["group_id"].ToString()); } model.user_name = ds.Tables[0].Rows[0]["user_name"].ToString(); model.password = ds.Tables[0].Rows[0]["password"].ToString(); model.salt = ds.Tables[0].Rows[0]["salt"].ToString(); model.email = ds.Tables[0].Rows[0]["email"].ToString(); model.nick_name = ds.Tables[0].Rows[0]["nick_name"].ToString(); model.avatar = ds.Tables[0].Rows[0]["avatar"].ToString(); model.sex = ds.Tables[0].Rows[0]["sex"].ToString(); if (ds.Tables[0].Rows[0]["birthday"].ToString() != "") { model.birthday = DateTime.Parse(ds.Tables[0].Rows[0]["birthday"].ToString()); } model.telphone = ds.Tables[0].Rows[0]["telphone"].ToString(); model.mobile = ds.Tables[0].Rows[0]["mobile"].ToString(); model.qq = ds.Tables[0].Rows[0]["qq"].ToString(); model.address = ds.Tables[0].Rows[0]["address"].ToString(); model.safe_question = ds.Tables[0].Rows[0]["safe_question"].ToString(); model.safe_answer = ds.Tables[0].Rows[0]["safe_answer"].ToString(); if (ds.Tables[0].Rows[0]["amount"].ToString() != "") { model.amount = decimal.Parse(ds.Tables[0].Rows[0]["amount"].ToString()); } if (ds.Tables[0].Rows[0]["point"].ToString() != "") { model.point = int.Parse(ds.Tables[0].Rows[0]["point"].ToString()); } if (ds.Tables[0].Rows[0]["exp"].ToString() != "") { model.exp = int.Parse(ds.Tables[0].Rows[0]["exp"].ToString()); } if (ds.Tables[0].Rows[0]["status"].ToString() != "") { model.status = int.Parse(ds.Tables[0].Rows[0]["status"].ToString()); } if (ds.Tables[0].Rows[0]["reg_time"].ToString() != "") { model.reg_time = DateTime.Parse(ds.Tables[0].Rows[0]["reg_time"].ToString()); } if (ds.Tables[0].Rows[0]["universities"] != null) { model.universities = ds.Tables[0].Rows[0]["universities"].ToString(); } if (ds.Tables[0].Rows[0]["professional"] != null) { model.professional = ds.Tables[0].Rows[0]["professional"].ToString(); } if (ds.Tables[0].Rows[0]["membershipdues"] != null) { model.membershipdues = ds.Tables[0].Rows[0]["membershipdues"].ToString(); } if (ds.Tables[0].Rows[0]["goodat"] != null) { model.goodat = ds.Tables[0].Rows[0]["goodat"].ToString(); } if (ds.Tables[0].Rows[0]["workat"] != null) { model.workat = ds.Tables[0].Rows[0]["workat"].ToString(); } if (ds.Tables[0].Rows[0]["industry"] != null) { model.industry = ds.Tables[0].Rows[0]["industry"].ToString(); } model.reg_ip = ds.Tables[0].Rows[0]["reg_ip"].ToString(); return(model); } else { return(null); } }
/// <summary> /// 删除一条数据 /// </summary> public bool Delete(int id) { //获取用户旧数据 Model.users.users model = GetModel(id); if (model == null) { return(false); } List <CommandInfo> sqllist = new List <CommandInfo>(); ////删除积分记录 //StringBuilder strSql1 = new StringBuilder(); //strSql1.Append("delete from " + databaseprefix + "user_point_log "); //strSql1.Append(" where user_id=@id"); //SqlParameter[] parameters1 = { // new SqlParameter("@id", SqlDbType.Int,4)}; //parameters1[0].Value = id; //CommandInfo cmd = new CommandInfo(strSql1.ToString(), parameters1); //sqllist.Add(cmd); ////删除金额记录 //StringBuilder strSql2 = new StringBuilder(); //strSql2.Append("delete from " + databaseprefix + "user_amount_log "); //strSql2.Append(" where user_id=@id"); //SqlParameter[] parameters2 = { // new SqlParameter("@id", SqlDbType.Int,4)}; //parameters2[0].Value = id; //cmd = new CommandInfo(strSql2.ToString(), parameters2); //sqllist.Add(cmd); ////删除短消息 //StringBuilder strSql3 = new StringBuilder(); //strSql3.Append("delete from " + databaseprefix + "user_message "); //strSql3.Append(" where post_user_name=@post_user_name or accept_user_name=@accept_user_name"); //SqlParameter[] parameters3 = { // new SqlParameter("@post_user_name", SqlDbType.NVarChar,100), // new SqlParameter("@accept_user_name", SqlDbType.NVarChar,100)}; //parameters3[0].Value = model.user_name; //parameters3[1].Value = model.user_name; //cmd = new CommandInfo(strSql3.ToString(), parameters3); //sqllist.Add(cmd); //删除申请码 StringBuilder strSql4 = new StringBuilder(); strSql4.Append("delete from " + databaseprefix + "user_code "); strSql4.Append(" where user_id=@id"); SqlParameter[] parameters4 = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters4[0].Value = id; CommandInfo cmd = new CommandInfo(strSql4.ToString(), parameters4); sqllist.Add(cmd); ////删除登录日志 //StringBuilder strSql5 = new StringBuilder(); //strSql5.Append("delete from " + databaseprefix + "user_login_log "); //strSql5.Append(" where user_id=@id"); //SqlParameter[] parameters5 = { // new SqlParameter("@id", SqlDbType.Int,4)}; //parameters5[0].Value = id; //cmd = new CommandInfo(strSql5.ToString(), parameters5); //sqllist.Add(cmd); //删除用户记录 StringBuilder strSql = new StringBuilder(); strSql.Append("delete from " + databaseprefix + "users "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; cmd = new CommandInfo(strSql.ToString(), parameters); sqllist.Add(cmd); int rowsAffected = DbHelperSQL.ExecuteSqlTran(sqllist); if (rowsAffected > 0) { return(true); } else { return(false); } }