Example #1
0
 /// <summary>
 /// 增加一条数据
 /// </summary>
 public int Add(User model)
 {
     var id= dal.Add(model);
     if (id>0)
     {
         SetModelCache(id);
     }
     return id;
 }
Example #2
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(User model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("insert into UserInfo(");
            strSql.Append("UserName,ShowName,PassWord,Sex,PhoneNum,Email,Age,ImgUrl,IsEnable,CreateTime,UpdateTime)");
            strSql.Append(" values (");
            strSql.Append("@UserName,@ShowName,@PassWord,@Sex,@PhoneNum,@Email,@Age,@ImgUrl,@IsEnable,@CreateTime,@UpdateTime)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                    new SqlParameter("@UserName", SqlDbType.VarChar,100),
                    new SqlParameter("@ShowName", SqlDbType.VarChar,100),
                    new SqlParameter("@PassWord", SqlDbType.VarChar,20),
                    new SqlParameter("@Sex", SqlDbType.Bit,1),
                    new SqlParameter("@PhoneNum", SqlDbType.VarChar,20),
                    new SqlParameter("@Email", SqlDbType.VarChar,50),
                    new SqlParameter("@Age", SqlDbType.Int,4),
                    new SqlParameter("@ImgUrl", SqlDbType.VarChar,-1),
                    new SqlParameter("@IsEnable", SqlDbType.Bit,1),
                    new SqlParameter("@CreateTime", SqlDbType.DateTime),
                    new SqlParameter("@UpdateTime", SqlDbType.DateTime)};
            parameters[0].Value = model.UserName;
            parameters[1].Value = model.ShowName;
            parameters[2].Value = model.PassWord;
            parameters[3].Value = model.Sex;
            parameters[4].Value = model.PhoneNum;
            parameters[5].Value = model.Email;
            parameters[6].Value = model.Age;
            parameters[7].Value = model.ImgUrl;
            parameters[8].Value = model.IsEnable;
            parameters[9].Value = model.CreateTime;
            parameters[10].Value = model.UpdateTime;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
            if (obj == null)
            {
                return 0;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }
Example #3
0
 public string RegistIn(FormCollection collection)
 {
     var userName = collection.Get("username");
     var password = collection.Get("password");
     var email = collection.Get("email");
     var phone = collection.Get("phone");
     if (string.IsNullOrEmpty(userName) || string.IsNullOrEmpty(password))
     {
         return HttpRequestResult.StateNotNull;
     }
     var user = new User
     {
         UserName = userName,
         PassWord = password,
         Email = email,
         PhoneNum = phone,
         IsEnable = true,
         CreateTime = DateTime.Now,
         UpdateTime = DateTime.Now
     };
     if (_userBll.Exists(user.UserName))
     {
         return HttpRequestResult.StateExisted;
     }
     var flag = _userBll.Add(user);
     if (flag > 0)
     {
         return HttpRequestResult.StateOk;
     }
     return HttpRequestResult.StateError;
 }
Example #4
0
 /// <summary>
 /// 得到一个对象实体
 /// </summary>
 public User DataRowToModel(DataRow row)
 {
     User model = new User();
     if (row != null)
     {
         if (row["Id"] != null && row["Id"].ToString() != "")
         {
             model.Id = int.Parse(row["Id"].ToString());
         }
         if (row["UserName"] != null)
         {
             model.UserName = row["UserName"].ToString();
         }
         if (row["ShowName"] != null)
         {
             model.ShowName = row["ShowName"].ToString();
         }
         if (row["PassWord"] != null)
         {
             model.PassWord = row["PassWord"].ToString();
         }
         if (row["Sex"] != null && row["Sex"].ToString() != "")
         {
             if ((row["Sex"].ToString() == "1") || (row["Sex"].ToString().ToLower() == "true"))
             {
                 model.Sex = true;
             }
             else
             {
                 model.Sex = false;
             }
         }
         if (row["PhoneNum"] != null)
         {
             model.PhoneNum = row["PhoneNum"].ToString();
         }
         if (row["Email"] != null)
         {
             model.Email = row["Email"].ToString();
         }
         if (row["Age"] != null && row["Age"].ToString() != "")
         {
             model.Age = int.Parse(row["Age"].ToString());
         }
         if (row["ImgUrl"] != null)
         {
             model.ImgUrl = row["ImgUrl"].ToString();
         }
         if (row["IsEnable"] != null && row["IsEnable"].ToString() != "")
         {
             if ((row["IsEnable"].ToString() == "1") || (row["IsEnable"].ToString().ToLower() == "true"))
             {
                 model.IsEnable = true;
             }
             else
             {
                 model.IsEnable = false;
             }
         }
         if (row["CreateTime"] != null && row["CreateTime"].ToString() != "")
         {
             model.CreateTime = DateTime.Parse(row["CreateTime"].ToString());
         }
         if (row["UpdateTime"] != null && row["UpdateTime"].ToString() != "")
         {
             model.UpdateTime = DateTime.Parse(row["UpdateTime"].ToString());
         }
     }
     return model;
 }
Example #5
0
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public bool Update(User model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("update UserInfo set ");
            strSql.Append("UserName=@UserName,");
            strSql.Append("ShowName=@ShowName,");
            strSql.Append("PassWord=@PassWord,");
            strSql.Append("Sex=@Sex,");
            strSql.Append("PhoneNum=@PhoneNum,");
            strSql.Append("Email=@Email,");
            strSql.Append("Age=@Age,");
            strSql.Append("ImgUrl=@ImgUrl,");
            strSql.Append("IsEnable=@IsEnable,");
            strSql.Append("CreateTime=@CreateTime,");
            strSql.Append("UpdateTime=@UpdateTime");
            strSql.Append(" where Id=@Id");
            SqlParameter[] parameters = {
                    new SqlParameter("@UserName", SqlDbType.VarChar,100),
                    new SqlParameter("@ShowName", SqlDbType.VarChar,100),
                    new SqlParameter("@PassWord", SqlDbType.VarChar,20),
                    new SqlParameter("@Sex", SqlDbType.Bit,1),
                    new SqlParameter("@PhoneNum", SqlDbType.VarChar,20),
                    new SqlParameter("@Email", SqlDbType.VarChar,50),
                    new SqlParameter("@Age", SqlDbType.Int,4),
                    new SqlParameter("@ImgUrl", SqlDbType.VarChar,-1),
                    new SqlParameter("@IsEnable", SqlDbType.Bit,1),
                    new SqlParameter("@CreateTime", SqlDbType.DateTime),
                    new SqlParameter("@UpdateTime", SqlDbType.DateTime),
                    new SqlParameter("@Id", SqlDbType.Int,4)};
            parameters[0].Value = model.UserName;
            parameters[1].Value = model.ShowName;
            parameters[2].Value = model.PassWord;
            parameters[3].Value = model.Sex;
            parameters[4].Value = model.PhoneNum;
            parameters[5].Value = model.Email;
            parameters[6].Value = model.Age;
            parameters[7].Value = model.ImgUrl;
            parameters[8].Value = model.IsEnable;
            parameters[9].Value = model.CreateTime;
            parameters[10].Value = model.UpdateTime;
            parameters[11].Value = model.Id;

            int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
            if (rows > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
Example #6
0
 public bool SetUserDetail(User user)
 {
     var strSql = new StringBuilder();
     strSql.Append("update UserInfo set ");
     strSql.Append("ShowName=@ShowName,");
     strSql.Append("Sex=@Sex,");
     strSql.Append("PhoneNum=@PhoneNum,");
     strSql.Append("Email=@Email,");
     strSql.Append("Age=@Age,");
     strSql.Append("UpdateTime=@UpdateTime");
     strSql.Append(" where Id=@Id");
     SqlParameter[] para =
     {
         new SqlParameter("@ShowName",SqlDbType.VarChar){Value = user.ShowName},
         new SqlParameter("@Sex",SqlDbType.Bit){Value = user.Sex},
         new SqlParameter("@PhoneNum",SqlDbType.VarChar){Value = user.PhoneNum},
         new SqlParameter("@Email",SqlDbType.VarChar){Value = user.Email},
         new SqlParameter("@Age",SqlDbType.Int){Value = user.Age},
         new SqlParameter("@UpdateTime",SqlDbType.DateTime){Value = DateTime.Now},
         new SqlParameter("@Id",SqlDbType.Int){Value = user.Id}
     };
     int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), para);
     return rows > 0;
 }
Example #7
0
        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public User GetModel(int Id)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select  top 1 Id,UserName,ShowName,PassWord,Sex,PhoneNum,Email,Age,ImgUrl,IsEnable,CreateTime,UpdateTime from UserInfo ");
            strSql.Append(" where Id=@Id");
            SqlParameter[] parameters = {
                    new SqlParameter("@Id", SqlDbType.Int,4)
            };
            parameters[0].Value = Id;

            User model = new User();
            DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
            if (ds.Tables[0].Rows.Count > 0)
            {
                return DataRowToModel(ds.Tables[0].Rows[0]);
            }
            else
            {
                return null;
            }
        }
Example #8
0
 /// <summary>
 /// 更新一条数据
 /// </summary>
 public bool Update(User model)
 {
     var flag= dal.Update(model);
     if (true)
     {
         SetModelCache(model.Id);
     }
     return flag;
 }
Example #9
0
 public bool SetUserDetail(User user)
 {
     var flag = dal.SetUserDetail(user);
     if (flag)
     {
         SetModelCache(user.Id);
     }
     return flag;
 }
Example #10
0
 public string Regist(string userName, string passWord)
 {
     if (string.IsNullOrEmpty(userName) || string.IsNullOrEmpty(passWord))
     {
         return "用户名不能为空";
     }
     var exist = _userBll.Exists(userName);
     if (exist)
     {
         return "用户名已存在";
     }
     var model = new User
     {
         UserName = userName,
         PassWord = passWord,
         IsEnable = true,
         CreateTime = DateTime.Now,
         UpdateTime = DateTime.Now
     };
     var result = _userBll.Add(model);
     if (result>0)
     {
         Session.Add("user",model);
         return HttpRequestResult.StateOk;
     }
     return HttpRequestResult.StateError;
 }
Example #11
0
 public string SetUserDetail(FormCollection collection)
 {
     var userId = collection.Get("userid");
     var showName = collection.Get("showname");
     var email = collection.Get("email");
     var phone = collection.Get("phone");
     var sex = collection.Get("sex");
     var user = new User()
     {
         Id = Int32.Parse(userId),
         ShowName = showName,
         Email = email,
         PhoneNum = phone,
         Sex = Int32.Parse(sex) > 0,
         UpdateTime = DateTime.Now
     };
     var flag = _userBll.SetUserDetail(user);
     if (flag)
     {
         return HttpRequestResult.StateOk;
     }
     else
     {
         return HttpRequestResult.StateError;
     }
 }