using System;
using System.Data;
using System.Web;
using Newtonsoft.Json;

/// <summary>
/// 会员相关操作
/// </summary>
public class Member {
  //private static HttpContext context = HttpContext.Current;

  /// <summary>
  /// 判断是否登陆过，如果没有登录将转向登录页，默认登录页网址
  /// </summary>
  public static void CheckLogined(MemberEntity m) {
    if (m.Id == 0) {
      string url = HttpUtility.UrlEncode(HttpContext.Current.Request.Url.ToString());
      HttpContext.Current.Response.Redirect("/vue/#/member/login?redirect=" + url);
    }
  }

  /// <summary>
  /// 判断是否登陆过，如果没有登录将转向登录页，传入登录页地址
  /// </summary>
  public static void CheckLogined(MemberEntity m, string url) {
    if (m.Id == 0) {
      //context.Response.Write(url);
      //context.Response.End();
      string redirect = HttpContext.Current.Request.Url.ToString();
      url += "?redirect=" + redirect;
      HttpContext.Current.Response.Redirect(url);
      /*try { context.Response.Redirect(url); }
      catch {
        HttpContext.Current.Response.Write("URL:" + url);
        HttpContext.Current.Response.End();
        //context.Response.End();
      }*/
    }
  }

  /// <summary>
  /// 检查是否有指定的权限，num可以取多个权限（用逗号隔开的字符串），满足其中一个即可
  /// </summary>
  public static void CheckRight(MemberEntity m, string num) {
    CheckLogined(m);
    if (!GetRight(m, num)) {
      HttpContext.Current.Response.Cookies["Message"].Value = HttpUtility.UrlEncode("权限被禁止，请与系统管理员联系！");
      HttpContext.Current.Response.Cookies["Message"].HttpOnly = true;
      HttpContext.Current.Response.Redirect("/inc/showmessage.aspx");
    }
  }

  /// <summary>
  /// 获取指定的权限，num可以取多个权限（用逗号隔开的字符串），其中一个为真全为真
  /// </summary>
  public static bool GetRight(MemberEntity m, string num) {
    string[] tmparr = num.Split(',');
    for (int i = 0; i < tmparr.Length; i++) {
      if (m.Right.Substring(int.Parse(tmparr[i]) - 1, 1) == "1") { return true; }
    }
    return false;
  }

  /// <summary>
  /// 清空会员信息，只在该类中使用
  /// </summary>
  private static void ClearMemberCookie() {
    HttpContext.Current.Response.Cookies["PSYMEMBER"].Value = string.Empty;
  }

  /// <summary>
  /// 通过ID获取会员信息，没有获取到返回null
  /// </summary>
  /// <returns></returns>
  public static MemberEntity GetMember(int id) {
    DataRow row = SqlHelper.ExecuteDataRow("select top 1 * from v_member where id=" + id);
    if (row == null) { return null; }
    else {
      MemberEntity m = new MemberEntity();
      m.Id = (int)row["id"];
      m.Number = row["number"].ToString();
      m.Username = row["username"].ToString();
      m.Password = (string)row["password"];
      m.Nickname = row["nickname"].ToString();
      m.Realname = row["realname"].ToString();
      m.Sex = (bool)row["sex"];
      m.Sexname = (string)row["sexname"];
      m.Birthday = (DateTime)row["birthday"];
      m.Age = (int)row["age"];
      m.Balance = Convert.IsDBNull(row["balance"]) ? (decimal)0 : (decimal)row["balance"];
      m.Type = (int)row["type"];
      m.Right = row["right"].ToString();
      m.Province = row["province"].ToString();
      m.City = row["city"].ToString();
      m.District = row["district"].ToString();
      m.Grade = (int)(Convert.IsDBNull(row["grade"]) ? 0 : row["grade"]);
      m.IsParent = row["isparent"].ToString() == "True";
      m.IsStudent = row["isstudent"].ToString() == "True";
      m.IsSchoolAdmin = row["isschooladmin"].ToString() == "True";
      m.Mobile = row["mobile"].ToString();
      m.Face = row["face"].ToString();
      m.Marriage = Convert.IsDBNull(row["marriage"]) ? (byte)0 : (byte)row["marriage"];
      m.Education = Convert.IsDBNull(row["education"]) ? (byte)0 : (byte)row["education"];
      m.Md5 = row["md5"].ToString();
      return m;
    }
  }

  /// <summary>
  /// 通过Cookie获取会员信息，Cookie不存在或者验证信息不正确，将清空Cookie并返回member.id=0
  /// </summary>
  /// <returns></returns>
  public static MemberEntity GetMember() {
    MemberEntity m = new MemberEntity();
    if (HttpContext.Current.Request.Cookies["PSYMEMBER"] == null) {
      ClearMemberCookie();
      m.Id = 0;
    }
    else {
      string cookie = HttpContext.Current.Request.Cookies["PSYMEMBER"].Value.ToString();
      if (string.IsNullOrEmpty(cookie)) {
        ClearMemberCookie();
        m.Id = 0;
      }
      else {
        cookie = cookie.Replace("%2E",".");
        string id = cookie.Split('.')[0];
        string password = cookie.Split('.')[1];
        if (!Common.IsInteger(id) || !Common.IsMD5(password)) {
          ClearMemberCookie();
          m.Id = 0;
        }
        else {
          string sql = "select top 1 * from v_member where id=" + id + " and password='" + password + "'";
          DataRow row = SqlHelper.ExecuteDataRow(sql);
          if (row == null) {
            ClearMemberCookie();
            m.Id = 0;
          }
          else {
            m.Id = (int)row["id"];
            m.Number = row["number"].ToString();
            m.Username = row["username"].ToString();
            m.Password = (string)row["password"];
            m.Nickname = row["nickname"].ToString();
            m.Realname = row["realname"].ToString();
            m.Sex = (bool)row["sex"];
            m.Sexname = (string)row["sexname"];
            m.Birthday = (DateTime)row["birthday"];
            m.Age = (int)row["age"];
            m.Balance = Convert.IsDBNull(row["balance"]) ? (decimal)0 : (decimal)row["balance"];
            m.Type = (int)row["type"];
            m.Right = row["right"].ToString();
            m.Province = row["province"].ToString();
            m.City = row["city"].ToString();
            m.District = row["district"].ToString();
            m.Grade = (int)(Convert.IsDBNull(row["grade"]) ? 0 : row["grade"]);
            m.IsParent = row["isparent"].ToString() == "True";
            m.IsStudent = row["isstudent"].ToString() == "True";
            m.IsSchoolAdmin = row["isschooladmin"].ToString() == "True";
            m.Mobile = row["mobile"].ToString();
            m.Face = row["face"].ToString();
            m.Marriage = Convert.IsDBNull(row["marriage"]) ? (byte)0 : (byte)row["marriage"];
            m.Education = Convert.IsDBNull(row["education"]) ? (byte)0 : (byte)row["education"];
            m.Md5 = row["md5"].ToString();
          }
        }
      }
    }
    return m;
  }

  public Member() { }
}

#region 会员实体
public class MemberEntity {
  /// <summary>
  /// 会员ID
  /// </summary>
  [JsonProperty("id")]
  public int Id { get; set; }

  /// <summary>
  /// 学号
  /// </summary>
  [JsonProperty("number")]
  public string Number { get; set; }

  /// <summary>
  /// 登录用户名
  /// </summary>
  [JsonProperty("username")]
  public string Username { get; set; }

  /// <summary>
  /// MD5密码
  /// </summary>
  [JsonProperty("password")]
  public string Password { get; set; }

  /// <summary>
  /// 会员昵称
  /// </summary>
  [JsonProperty("nickname")]
  public string Nickname { get; set; }

  /// <summary>
  /// 真实姓名
  /// </summary>
  [JsonProperty("realname")]
  public string Realname { get; set; }

  /// <summary>
  /// 性别，男true，女false
  /// </summary>
  [JsonProperty("sex")]
  public bool Sex { get; set; }

  /// <summary>
  /// 性别名称：汉字男或女
  /// </summary>
  [JsonProperty("sexname")]
  public string Sexname { get; set; }

  /// <summary>
  /// 出生日期
  /// </summary>
  [JsonProperty("birthday")]
  public DateTime Birthday { get; set; }

  /// <summary>
  /// 年龄数字
  /// </summary>
  [JsonProperty("age")]
  public int Age { get; set; }

  /// <summary>
  /// 账户余额
  /// </summary>
  [JsonProperty("balance")]
  public decimal Balance { get; set; }

  /// <summary>
  /// 会员类型
  /// </summary>
  [JsonProperty("type")]
  public int Type { get; set; }

  /// <summary>
  /// 会员权限
  /// </summary>
  [JsonProperty("right")]
  public string Right { get; set; }

  /// <summary>
  /// 省份名称
  /// </summary>
  [JsonProperty("province")]
  public string Province { get; set; }

  /// <summary>
  /// 城市名称
  /// </summary>
  [JsonProperty("city")]
  public string City { get; set; }

  /// <summary>
  /// 区县名称
  /// </summary>
  [JsonProperty("district")]
  public string District { get; set; }

  /// <summary>
  /// 年级（smallint-short）
  /// </summary>
  [JsonProperty("grade")]
  public int Grade { get; set; }

  /// <summary>
  /// 是否家长
  /// </summary>
  [JsonProperty("isparent")]
  public bool IsParent { get; set; }

  /// <summary>
  /// 是否学生
  /// </summary>
  [JsonProperty("isstudent")]
  public bool IsStudent { get; set; }

  /// <summary>
  /// 是否学校管理员
  /// </summary>
  [JsonProperty("isschooladmin")]
  public bool IsSchoolAdmin { get; set; }

  /// <summary>
  /// 手机号码
  /// </summary>
  [JsonProperty("mobile")]
  public string Mobile { get; set; }

  /// <summary>
  /// 头像网址
  /// </summary>
  [JsonProperty("face")]
  public string Face { get; set; }

  /// <summary>
  /// 婚姻状况：0保密，1单身，2恋爱，3订婚，4已婚，5离异，6丧偶
  /// </summary>
  [JsonProperty("marriage")]
  public byte Marriage { get; set; }

  /// <summary>
  /// 受教育程度：0初中及以下，1高中，2大专，3本科，4硕士，5博士
  /// </summary>
  [JsonProperty("education")]
  public byte Education { get; set; }

  /// <summary>
  /// 会员MD5信息
  /// </summary>
  [JsonProperty("md5")]
  public string Md5 { get; set; }
}
#endregion