Exemplo n.º 1
0
        public static User SelectById(int id)
        {
            User          us  = null;
            string        sql = "select * from user_tab where id=" + id;
            SqlDataReader rs  = DBHelper.SearchSql(sql);

            if (rs.Read())
            {
                us            = new User();
                us.Id         = rs.GetInt32(0);
                us.Name       = rs.GetString(1);
                us.Address    = rs.GetString(2);
                us.Tel        = rs.GetString(3);
                us.Email      = rs.GetString(4);
                us.User_state = UserStateDAL.SelectById(rs.GetInt32(5));
            }
            rs.Close();
            return(us);
        }
Exemplo n.º 2
0
        public static List <User> SelectByOther(string other)
        {
            List <User>   list = new List <User>();
            string        sql  = "select * from user_tab where 1=1 " + other;
            SqlDataReader rs   = DBHelper.SearchSql(sql);

            while (rs.Read())
            {
                User us = new User();
                us.Id         = rs.GetInt32(0);
                us.Name       = rs.GetString(1);
                us.Address    = rs.GetString(2);
                us.Tel        = rs.GetString(3);
                us.Email      = rs.GetString(4);
                us.User_state = UserStateDAL.SelectById(rs.GetInt32(5));
                list.Add(us);
            }
            rs.Close();
            return(list);
        }