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

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

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

using System;
using System.Collections.Generic;
using System.Text;
using Zephyr.Core;
using System.ComponentModel.DataAnnotations;
using Newtonsoft.Json.Linq;

namespace Zephyr.Models
{
    public class sys_organizeService : ServiceBase<sys_organize>
    {
        public void RecursionDelete(string id)
        {
            var pQuery = ParamQuery.Instance().AndWhere("ParentCode", id);
            var list = base.BuilderParse(pQuery).QueryManyDynamic();
            foreach (var item in list)
                RecursionDelete(item.OrganizeCode);
            var pDelete = ParamDelete.Instance().AndWhere("OrganizeCode", id);
            base.BuilderParse(pDelete).Execute();
        }

        public dynamic GetOrganizeRole(string organize)
        {
            var sql = String.Format(@"
select distinct A.RoleCode,A.RoleName
,(case when B.RoleCode is null then 'false' else 'true' end) as Checked
from sys_role A
left join sys_organizeRoleMap B on B.RoleCode = A.RoleCode and B.OrganizeCode = '{0}'", organize);
            return db.Sql(sql).QueryMany<dynamic>();
        }

        public void SaveOrganizeRoles(string OrganizeCode, JToken RoleList)
        {
            db.UseTransaction(true);
            Logger("设置机构角色", () =>
            {
                db.Delete("sys_organizeRoleMap").Where("OrganizeCode", OrganizeCode).Execute();
                foreach (JToken item in RoleList.Children())
                {
                    var RoleCode = item["RoleCode"].ToString();
                    db.Insert("sys_organizeRoleMap").Column("OrganizeCode", OrganizeCode).Column("RoleCode", RoleCode).Execute();
                }
                db.Commit();
            }, e => db.Rollback());
        }
    }
    
    public class sys_organize : ModelBase
    {

        [PrimaryKey]
        public string OrganizeCode
        {
            get;
            set;
        }

        public string ParentCode
        {
            get;