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; }
|
}
|
}
|
