From 0879713a184c48a0306a771a1e151387d5a9cf4c Mon Sep 17 00:00:00 2001
From: LR-20210131IOQH\Administrator <jackcold@163.com>
Date: 星期一, 28 六月 2021 12:40:37 +0800
Subject: [PATCH] 电话费用录入修改

---
 zhengcaioa/Model/Sim.cs |   88 +++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 87 insertions(+), 1 deletions(-)

diff --git a/zhengcaioa/Model/Sim.cs b/zhengcaioa/Model/Sim.cs
index 7b98670..1528968 100644
--- a/zhengcaioa/Model/Sim.cs
+++ b/zhengcaioa/Model/Sim.cs
@@ -147,8 +147,94 @@
         {
             get
             {
-                return status=="0"?"姝e父":"鍏宠处";
+                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; }
+    }
 }

--
Gitblit v1.9.1