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"?"正常":"关账";
|
}
|
}
|
}
|
}
|
