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"?"未核准":"已核准";
            }
        }
    }

    [Table("v_sim_costyear")]
    public class SimCostYearView
    {
        /// <summary>
        /// 卡号
        /// </summary>
        [Key]
        public string sim_id { get; set; }

        /// <summary>
        /// 年
        /// </summary>
        public int bill_year { get; set; }

        /// <summary>
        /// 1月
        /// </summary>
        public decimal Jan { get; set; }

        /// <summary>
        /// 2月
        /// </summary>
        public decimal Feb { get; set; }

        /// <summary>
        /// 3月
        /// </summary>
        public decimal Mar { get; set; }

        /// <summary>
        /// 4月
        /// </summary>
        public decimal Apr { get; set; }

        /// <summary>
        /// 5月
        /// </summary>
        public decimal May { get; set; }

        /// <summary>
        /// 6月
        /// </summary>
        public decimal Jun { get; set; }

        /// <summary>
        /// 7月
        /// </summary>
        public decimal Jul { get; set; }

        /// <summary>
        /// 8月
        /// </summary>
        public decimal Aug { get; set; }

        /// <summary>
        /// 9月
        /// </summary>
        public decimal Sept { get; set; }

        /// <summary>
        /// 10月
        /// </summary>
        public decimal Oct { get; set; }

        /// <summary>
        /// 11月
        /// </summary>
        public decimal Nov { get; set; }

        /// <summary>
        /// 12月
        /// </summary>
        public decimal Dece { get; set; }

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

        /// <summary>
        /// 检查编辑月
        /// </summary>
        [NotMapped]
        public int month { get; set; }
    }
}