排序

wx

2022-12-30 0c188ee217146c88ca96d99b5795d1883b733840

排序

 GasolineBlend.Entity/SysIpcClass.cs

@@ -21,6 +21,14 @@
        /// 父code
        /// </summary>
        public string ParentCode { get; set; }
        /// <summary>
        /// 排序码1
        /// </summary>
        public int Sort1 { get; set; }
        /// <summary>
        /// 排序码1
        /// </summary>
        public string Sort2 { get; set; }
    }


@@ -39,6 +47,14 @@
        /// 父code
        /// </summary>
        public string ParentCode { get; set; }
        /// <summary>
        /// 排序码1
        /// </summary>
        public int Sort1 { get; set; }
        /// <summary>
        /// 排序码1
        /// </summary>
        public string Sort2 { get; set; }
    }


@@ -57,5 +73,13 @@
        /// 父code
        /// </summary>
        public string ParentCode { get; set; }
        /// <summary>
        /// 排序码1
        /// </summary>
        public int Sort1 { get; set; }
        /// <summary>
        /// 排序码1
        /// </summary>
        public string Sort2 { get; set; }
    }
}

 Pissa.Service/DbService/SysService.cs

@@ -37,7 +37,7 @@
            var res = Context.Queryable<SysIpcClass>()
                .Where(a => a.Year == year)
                .Where(a => a.ParentCode == parentCode)
                .OrderBy(a => a.Code)
                .OrderBy(a => a.Sort1).OrderBy(a => a.Sort2)
                .ToList();
            return res;
        }
@@ -52,7 +52,7 @@
            var res = Context.Queryable<SysCpcClass>()
                .Where(a => a.ParentCode == parentCode)
                .WhereIF(parentCode.IsNullOrEmpty(), a=>a.Code.Length ==1)
                .OrderBy(a=>a.Code)
                .OrderBy(a=>a.Sort1).OrderBy(a => a.Sort2)
                .ToList();
            return res;
        }
@@ -122,7 +122,7 @@
        /// <returns></returns>
        public List<IviewTree> GetLoccn()
        {
            var data = Context.Queryable<SysLoccn>().OrderBy(a => a.Code).ToList();
            var data = Context.Queryable<SysLoccn>().OrderBy(a => a.Sort1).OrderBy(a=>a.Sort2).ToList();
            var tree = TreeHelper.GenerateIviewTree(data, a => a.Code,
                a => a.ParentCode,
                a => a.Code,