Example #1
0
        /// <summary>
        /// 查询用户信息
        /// </summary>
        /// <returns>用户信息集合</returns>
        public List <Model.User> GetUser()
        {
            List <Model.User> user = new List <Model.User>();

            if (DbHelpe.OpenConnection())
            {
                SqlDataReader dr = DbHelpe.ExecReader("select * from User");
                if (dr != null)
                {
                    while (dr.Read())
                    {
                        user.Add(new Model.User(
                                     (int)dr["UserID"],
                                     dr["UName"] as string,
                                     dr["LoginInfio"] as string,
                                     dr["pwd"] as string,
                                     dr["Gender"] as string,
                                     dr["Nation"] as string,
                                     dr["Phone"] as string,
                                     dr["Email"] as string,
                                     dr["Identity"] as string,
                                     dr["Address"] as string,
                                     dr["LanguageID"] as string,
                                     (DateTime)dr["LastLogDate"],
                                     dr["State"] as string
                                     ));
                    }
                }
                DbHelpe.CloseConnection();    //关闭数据库连接
            }
            return(user);
        }
Example #2
0
        /// <summary>
        /// 更新用户信息
        /// </summary>
        /// <param name="user">用户对象</param>
        /// <returns>更新结果</returns>
        public int UpdateUser(Model.User user)
        {
            string sql = "Update [User] set[State]=0";

            if (!string.IsNullOrEmpty(user.UName))
            {
                sql += ",[UName]='" + user.UName + "'";
            }

            if (!string.IsNullOrEmpty(user.LoginInfo))
            {
                sql += ",[LoginInfo]='" + user.LoginInfo + "'";
            }

            if (!string.IsNullOrEmpty(user.pwd))
            {
                sql += ",[pwd]='" + user.pwd + "'";
            }

            if (!string.IsNullOrEmpty(user.Nation))
            {
                sql += ",[Nation]='" + user.Nation + "'";
            }

            if (!string.IsNullOrEmpty(user.Phone))
            {
                sql += ",[Phone]='" + user.Phone + "'";
            }

            if (!string.IsNullOrEmpty(user.Email))
            {
                sql += ",[Email]='" + user.Email + "'";
            }

            if (!string.IsNullOrEmpty(user.Identity))
            {
                sql += ",[Identity]='" + user.Identity + "'";
            }

            if (!string.IsNullOrEmpty(user.Address))
            {
                sql += ",[Address]='" + user.Address + "'";
            }

            if (!string.IsNullOrEmpty(user.LanguageID))
            {
                sql += ",[LanguageID]='" + user.LanguageID + "'";
            }

            if (user.LastLogDate.Year > 1)
            {
                sql += ",[LastLogDate]='" + user.LastLogDate + "'";
            }

            if (!string.IsNullOrEmpty(user.State))
            {
                sql += ",[State]='" + user.State + "'";
            }

            sql += " where [UserID]='" + user.UserID + "'";
            return(DbHelpe.ExecQuery(sql));
        }
Example #3
0
 /// <summary>
 /// 添加用户信息
 /// </summary>
 /// <param name="user">用户对象</param>
 /// <returns>添加结果</returns>
 public int IsertUser(Model.User user)
 {
     return(DbHelpe.ExecQuery(
                "Insert into [User]" +
                "(UserID,[UName],[LoginInfio],[pwd],[Genter],[Nation],[Phone],[Email],[Identity],[Address],[LanguageID],[LastLogDate],[State]) values ('" + user.UserID + "','" + user.UName + "','" + user.LoginInfo + "','" + user.pwd + "','" + user.Gender + "','" + user.Nation + "','" + user.Phone + "','" + user.Email + "','" + user.Identity + "','" + user.Address + "','" + user.LanguageID + "','" + user.LastLogDate + "','" + user.State + "',)"));
 }
Example #4
0
 public int GetSeleceUser()
 {
     return((int)DbHelpe.ExecQuery("select * from User"));
 }
Example #5
0
 /// <summary>
 /// 删除用户信息
 /// </summary>
 /// <param name="id">用户编号</param>
 /// <returns>删除结果</returns>
 public int DeleteUser(string id)
 {
     return(DbHelpe.ExecQuery("update [User] set [State]=1 where [UserID] in(" + id + ")"));
 }