BN089-BS开发框架MVC4版/source20131023/Zephyr.Web/Areas/Sys/Models/sys_code.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Text;
using Zephyr.Core;
using System.ComponentModel.DataAnnotations;

namespace Zephyr.Models
{
    public class sys_codeService : ServiceBase<sys_code>
    {
        public List<dynamic> GetValueTextListByType(string codeType)
        {
            var pQuery = ParamQuery.Instance()
                .Select("Code as value,Text as text")
                .AndWhere("CodeType", codeType);

            return base.GetDynamicList(pQuery);
        }

        public List<dynamic> GetMeasureUnitListByType()
        {
            var pQuery = ParamQuery.Instance()
                .Select("Text as value,Text as text")
                .AndWhere("CodeType", "MeasureUnit");

            return base.GetDynamicList(pQuery);
        }

        public List<dynamic> GetYearItems() {
            var result = new List<dynamic>();
            var startYear = DateTime.Now.Year - 10;
            for (var y = startYear; y < startYear + 20; y++)
                result.Add(new {value=y,text=y });
            
            return result;
        }

        public List<dynamic> GetMonthItems()
        {
            var result = new List<dynamic>();
            var startMonth = 1;
            for (var m = startMonth; m < startMonth + 12; m++)
                result.Add(new { value = m, text = m });
            
            return result;
        }

        public string GetDefaultCode(string sType)
        {
            var pQuery = ParamQuery.Instance().Select("top 1 Code")
                .AndWhere("CodeType", sType)
                .AndWhere("IsEnable",true)
                .AndWhere("IsDefault",true);

            return base.GetField<string>(pQuery);
        }
    }
    
    public class sys_code : ModelBase
    {