using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using System.Text;

namespace zhengcaioa.Models
{   
    [Table("t_sim_bind")]
    public class SimBind
    {
        [Key]
        public int id { get; set; }

        /// <summary>
        /// 卡号
        /// </summary>
        public string sim_id { get; set; }

        /// <summary>
        /// 用户
        /// </summary>
        public string user_id { get; set; }

        /// <summary>
        /// 属性
        /// </summary>
        public string cardpro { get; set; }

        public DateTime up_time { get; set; }

        public string up_user { get; set; }
    }

    [Table("v_sim_bind")]
    public class SimBindView
    {
        [Key]
        public string Id { get; set; }

        public string simcard { get; set; }

        public string simstatus { get; set; }

        public string userid { get; set; }

        public string username { get; set; }

        public string cardpro { get; set; }

        [NotMapped]
        public string cardproChs { get; set; } 

        public DateTime? up_time { get; set; }
    }

    [Table("t_sim_cost")]
    public class SimCost
    {
        [Key]
        public int id { get; set; }

        public string user_id { get; set; }
        public string sim_id { get; set; }

        public int bill_year { get; set; }
        public int bill_month { get; set; }

        /// <summary>
        /// 可报金额
        /// </summary>
        public decimal allow_amount { get; set; }
        /// <summary>
        /// 账单金额
        /// </summary>
        public decimal bill_amount { get; set; }
        /// <summary>
        /// 差异金额
        /// </summary>
        public decimal amount { get; set; }
        /// <summary>
        /// 记账日期
        /// </summary>
        public DateTime accounted_time { get; set; }
        /// <summary>
        /// 状态
        /// </summary>
        public string status { get; set; }

        public string sub_userid { get; set; }
        public DateTime up_time { get; set; }
        public string audit_userid { get; set; }
        public DateTime? audit_time { get; set; }
    }

    [Table("v_sim_cost")]
    public class SimCostView
    {
        [Key]
        public int id { get; set; }

        public string user_id { get; set; }

        public string username { get; set; }

        public string sim_id { get; set; }

        public string simcard { get; set; }

        public int bill_year { get; set; }
        public int bill_month { get; set; }

        /// <summary>
        /// 可报金额
        /// </summary>
        public decimal allow_amount { get; set; }

        /// <summary>
        /// 账单金额
        /// </summary>
        public decimal bill_amount { get; set; }

        public decimal amount { get; set; }

        /// <summary>
        /// 记账日期
        /// </summary>
        public DateTime accounted_time { get; set; }

        /// <summary>
        /// 状态
        /// </summary>
        public string status { get; set; }

        public DateTime up_time { get; set; }

        [NotMapped]
        public string accountMonth {
            get
            {
                return bill_year + "-" + bill_month.ToString().PadLeft(2,'0');
            }
        }

        [NotMapped]
        public string statusChs
        {
            get
            {
                return status=="0"?"正常":"关账";
            }
        }
    }
}