示例#1
0
文件: Main.cs 项目: Kiira02/test
        public AuthorizationAuto AutoLogin(string iDuser)
        {
            var connectionString   = GetDatabaseConnection(ConnectionName);
            AuthorizationAuto data = new AuthorizationAuto();

            using (var conn = new SqlConnection(connectionString))
                using (var command = new SqlCommand("AutoLogin", conn)
                {
                    CommandType = CommandType.StoredProcedure
                })
                {
                    command.Parameters.AddWithValue("@ID", Convert.ToInt32(iDuser));
                    conn.Open();
                    SqlDataReader reader = command.ExecuteReader();

                    int    id   = -1;
                    string name = "";

                    while (reader.Read())
                    {
                        id   = reader.GetInt32(0);
                        name = reader.GetString(1);
                    }
                    conn.Close();

                    data.UserName = name;
                    data.UserId   = id;
                }
            return(data);
        }
示例#2
0
文件: Main.cs 项目: Kiira02/test
        public AuthorizationAuto AutoLogin(string iDuser)
        {
            var connectionString = GetDatabaseConnection(ConnectionName);
            AuthorizationAuto data = new AuthorizationAuto();

            using (var conn = new SqlConnection(connectionString))
            using (var command = new SqlCommand("AutoLogin", conn)
            {
                CommandType = CommandType.StoredProcedure
            })
            {
                command.Parameters.AddWithValue("@ID", Convert.ToInt32(iDuser));
                conn.Open();
                SqlDataReader reader = command.ExecuteReader();

                int id = -1;
                string name = "";

                while (reader.Read())
                {
                    id = reader.GetInt32(0);
                    name = reader.GetString(1);
                }
                conn.Close();

                data.UserName = name;
                data.UserId = id;
            }
            return data;
        }