fetchkey.cs

跨平台跨服务器跨网站SSO（单点登录）的方案

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Runtime.Serialization.Formatters.Binary;
using System.IO;


namespace LoginInfo
{
    public class FetchKey
    {
        public string Fetch(long uid)
        {
            string key;
            using (SqlConnection con = new SqlConnection("server=srv-devdbhost;uid=sa;pwd=Abcd1234;database=test;"))
            {
                SqlCommand cmd = new SqlCommand("GetNewID", con);
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.Add("@uid", SqlDbType.BigInt);
                cmd.Parameters["@uid"].Value = uid;
                cmd.Parameters.Add("@newID", SqlDbType.VarChar, 50);
                cmd.Parameters["@newID"].Direction = ParameterDirection.Output;
                cmd.Parameters.Add("@username", SqlDbType.VarChar, 50);
                cmd.Parameters["@username"].Direction = ParameterDirection.Output;
                con.Open();
                cmd.ExecuteNonQuery();
                string newID = cmd.Parameters["@newID"].Value as string;
                string username = cmd.Parameters["@username"].Value as string;
                LoginInfo.Info info = new LoginInfo.Info();
                info.Key = newID;
                info.UserName = username;
                byte[] bytes = this.DataSerialize(info);
                key = System.Convert.ToBase64String(bytes);
            }
            return key;
        }

        private byte[] DataSerialize(LoginInfo.Info info)
        {
            BinaryFormatter formatter = new BinaryFormatter();
            MemoryStream ms = new MemoryStream();
            formatter.Serialize(ms, info);
            ms.Position = 0;
            byte[] bytes = new byte[ms.Length];
            ms.Read(bytes, 0, Convert.ToInt32(ms.Length));
            return bytes;
        }
    }
}