微信公众平台-授权验证返回的个人信息类

using Microsoft.VisualBasic;
using System.Data.SqlClient;

public class WxUser
{
    public WxUser()
    {
        // VBConversions Note: Non-static class variable initialization is below.  Class variables cannot be initially assigned non-static values in C#.
        tableName = System.Convert.ToString(conn.key("user"));
        
    }
    Config conn = new Config();
    string tableName; // VBConversions Note: Initial value cannot be assigned here since it is non-static.  Assignment has been moved to the class constructors.
    
    private string _openid;
    /// <summary>
    ///
    /// </summary>
    /// <value></value>
    /// <returns></returns>
    /// <remarks></remarks>
public string openid
    {
        get
        {
            return _openid;
        }
        set
        {
            _openid = value;
        }
    }
    
    private string _nickname;
    /// <summary>
    ///
    /// </summary>
    /// <value></value>
    /// <returns></returns>
    /// <remarks></remarks>
public string nickname
    {
        get
        {
            return _nickname;
        }
        set
        {
            _nickname = value;
        }
    }
    private string _country;
    /// <summary>
    ///
    /// </summary>
    /// <value></value>
    /// <returns></returns>
    /// <remarks></remarks>
public string country
    {
        get
        {
            return _country;
        }
        set
        {
            _country = value;
        }
    }
    
    private string _city;
    /// <summary>
    ///
    /// </summary>
    /// <value></value>
    /// <returns></returns>
    /// <remarks></remarks>
public string city
    {
        get
        {
            return _city;
        }
        set
        {
            _city = value;
        }
    }
    private int _province;
    /// <summary>
    ///
    /// </summary>
    /// <value></value>
    /// <returns></returns>
    /// <remarks></remarks>
public string province
    {
        get
        {
            return System.Convert.ToString( _province);
        }
        set
        {
            _province = (int) value;
        }
    }
    
    private int _sex;
    /// <summary>
    ///
    /// </summary>
    /// <value></value>
    /// <returns></returns>
    /// <remarks></remarks>
public int sex
    {
        get
        {
            return _sex;
        }
        set
        {
            _sex = value;
        }
    }
    private string _headimgurl;
    /// <summary>
    ///
    /// </summary>
    /// <value></value>
    /// <returns></returns>
    /// <remarks></remarks>
public string headimgurl
    {
        get
        {
            return _headimgurl;
        }
        set
        {
            _headimgurl = value;
        }
    }
    private int _privilege;
    /// <summary>
    ///
    /// </summary>
    /// <value></value>
    /// <returns></returns>
    /// <remarks></remarks>
public int privilege
    {
        get
        {
            return _privilege;
        }
        set
        {
            _privilege = value;
        }
    }
    /// <summary>
    /// 插入
    /// </summary>
    /// <param name="adminid"></param>
    /// <returns></returns>
    /// <remarks></remarks>
    public int Insert(string[] adminid)
    {
        int returnValue = 0;
        if (SelectO(adminid[0]) > 0)
        {
            return 2;
        }
        Data.SqlClient.SqlConnection sqlconn = default(Data.SqlClient.SqlConnection);
        sqlconn = new Data.SqlClient.SqlConnection(conn.Conn());
        string strwhere = "insert into " + tableName + " values(@openid,@nickname,@sex,@province,@city,@country,@headimgurl,@privilege,@time)";
        Data.SqlClient.SqlCommand sqlcmd = new Data.SqlClient.SqlCommand(strwhere, sqlconn);

        sqlcmd.Parameters.Clear();

        sqlcmd.Parameters.Add("@openid", Data.SqlDbType.NVarChar).Value = adminid[0];
        sqlcmd.Parameters.Add("@nickname", Data.SqlDbType.NVarChar).Value = adminid[1];
        sqlcmd.Parameters.Add("@sex", Data.SqlDbType.Int).Value = adminid[2];
        sqlcmd.Parameters.Add("@province", Data.SqlDbType.NVarChar).Value = adminid[3];
        sqlcmd.Parameters.Add("@city", Data.SqlDbType.NVarChar).Value = adminid[4];
        sqlcmd.Parameters.Add("@country", Data.SqlDbType.NVarChar).Value = adminid[5];
        sqlcmd.Parameters.Add("@headimgurl", Data.SqlDbType.NVarChar).Value = adminid[6];
        sqlcmd.Parameters.Add("@privilege", Data.SqlDbType.NVarChar).Value = adminid[7];
        sqlcmd.Parameters.Add("@time", Data.SqlDbType.DateTime).Value = DateTime.Now;
        sqlconn.Open();
        try
        {
            sqlcmd.ExecuteNonQuery();
            returnValue = 1;
        }
        catch (Exception)
        {
            returnValue = 0;
        }
        finally
        {
            sqlconn.Close();
            sqlconn.Dispose();
        }
        return returnValue;
    }
    /// <summary>
    /// 根据编号查询一条信息
    /// </summary>
    /// <param name="number"></param>
    /// <returns></returns>
    /// <remarks></remarks>
    public int SelectO(string number)
    {
        int returnValue = 0;
        SqlConnection sqlconn = default(SqlConnection);
        sqlconn = new SqlConnection(conn.Conn);
        //查询信息
        SqlCommand sqlselcmd = new SqlCommand("select * from " + tableName + " where w_openid=@openid", sqlconn);
        sqlselcmd.Parameters.Add("@openid", Data.SqlDbType.NVarChar).Value = number;
        sqlconn.Open();
        CarID car = new CarID();
        try
        {
            SqlDataAdapter sqlda = new SqlDataAdapter(sqlselcmd);
            Data.DataTable sqltable = new Data.DataTable();
            sqlda.Fill(sqltable);
            returnValue = System.Convert.ToInt32(sqltable.Rows.Count);
        }
        catch (Exception)
        {
            returnValue = 0;
        }
        finally
        {
            sqlconn.Close();
            sqlconn.Dispose();
        }
        return returnValue;
    }
    /// <summary>
    /// 根据编号查询一条信息
    /// </summary>
    /// <param name="number"></param>
    /// <returns></returns>
    /// <remarks></remarks>
    public string SelectOne(string openid)
    {
        string returnValue = "";
        SqlConnection sqlconn = default(SqlConnection);
        sqlconn = new SqlConnection(conn.Conn);
        //查询信息
        SqlCommand sqlselcmd = new SqlCommand("select * from " + tableName + " where w_openid=@openid", sqlconn);
        sqlselcmd.Parameters.Add("@openid", Data.SqlDbType.NVarChar).Value = openid;
        sqlconn.Open();
        CarID car = new CarID();
        try
        {
            SqlDataAdapter sqlda = new SqlDataAdapter(sqlselcmd);
            Data.DataTable data = new Data.DataTable();
            sqlda.Fill(data);
            returnValue = "{\'openid\':" + data.Rows(0)[1] + ",\'nickname\':" + data.Rows(0)[2] + ",\'sex\':" + data.Rows(0)[3] + ",\'province\':" + data.Rows(0)[4] + ",\'city\':" + data.Rows(0)[5] + ",\'country\':" + data.Rows(0)[6] + ",\'headimgurl\':" + data.Rows(0)[7] + ",\'privilege\':" + data.Rows(0)[8] + "}";
        }
        catch (Exception)
        {
            returnValue = string.Empty;
        }
        finally
        {
            sqlconn.Close();
            sqlconn.Dispose();
        }
        return returnValue;
    }
}