Beispiel #1
0
        /// <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);
        }
Beispiel #2
0
        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);
        }
Beispiel #3
0
        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);
        }
Beispiel #4
0
        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;
            }
        }
Beispiel #5
0
        //发送手机短信
        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())));
            }
        }
Beispiel #6
0
 /// <summary>
 /// 增加一条数据
 /// </summary>
 public int Add(Model.users.users model)
 {
     return(dal.Add(model));
 }
Beispiel #7
0
 /// <summary>
 /// 更新一条数据
 /// </summary>
 public bool Update(Model.users.users model)
 {
     return(dal.Update(model));
 }
Beispiel #8
0
        /// <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;
            }
        }
Beispiel #9
0
        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;
        }
Beispiel #10
0
        /// <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);
            }
        }
Beispiel #11
0
        /// <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);
            }
        }