TEAMModelOS/TEAMModelBI/Controllers/BISchool/BatchSchoolController.cs

using Azure.Cosmos;
using HTEXLib.COMM.Helpers;
using Microsoft.AspNetCore.Http;
using Microsoft.AspNetCore.Mvc;
using Microsoft.Extensions.Options;
using System;
using System.Collections.Generic;
using System.Dynamic;
using System.Linq;
using System.Text;
using System.Text.Json;
using System.Threading.Tasks;
using TEAMModelOS.Models;
using TEAMModelOS.SDK.DI;
using TEAMModelOS.SDK.Extension;
using TEAMModelOS.SDK.Models;
using TEAMModelOS.SDK.Models.Cosmos.BI;
using Microsoft.AspNetCore.Hosting;  //引用读取文件
using TEAMModelOS.SDK.Models.Service;
using System.IO;
using System.Net.Http;
using Microsoft.Extensions.Configuration;
using System.Net.Http.Json;
using System.Net;
using TEAMModeBI.Filter;

namespace TEAMModeBI.Controllers.BISchool
{
    [Route("batchschool")]
    [ApiController]
    public class BatchSchoolController : ControllerBase
    {
        private readonly AzureCosmosFactory _azureCosmos;
        private readonly DingDing _dingDing;
        private readonly Option _option;
        private readonly AzureStorageFactory _azureStorage;
        private readonly IWebHostEnvironment _environment; //读取文件
        private readonly IHttpClientFactory _http;
        //读取配置信息
        private readonly IConfiguration _configuration;
        public readonly string mobel = "学校";

        public BatchSchoolController(AzureCosmosFactory azureCosmos, DingDing dingDing, AzureStorageFactory azureStorage, IOptionsSnapshot<Option> option, IWebHostEnvironment hostingEnvironment, IConfiguration configuration, IHttpClientFactory http)
        {
            _azureCosmos = azureCosmos;
            _dingDing = dingDing;
            _azureStorage = azureStorage;
            _option = option?.Value;
            _environment = hostingEnvironment;
            _configuration = configuration;
            _http = http;
        }

        /// <summary>
        /// 获取BI权限列表
        /// </summary>
        /// <returns></returns>
        [ProducesDefaultResponseType]
        [HttpPost("get-teacher-authoritybilist")]
        public async Task<IActionResult> GetAuthorityBIList()
        {
            Dictionary<string, object> dic = new Dictionary<string, object> { { "PartitionKey", "authority-bi" } };
            List<Authority> authorityBIList = await _azureStorage.FindListByDict<Authority>(dic);

            return Ok(new { authorityBIList });
        }

        /// <summary>
        /// 通过教师的id和学校的code查询权限
        /// </summary>
        /// <param name="jsonElement"></param>
        /// <returns></returns>
        [ProducesDefaultResponseType]
        [HttpPost("get-teacherroles")]
        public async Task<IActionResult> GetTeacherRoles(JsonElement jsonElement)
        {
            try
            {
                if (!jsonElement.TryGetProperty("id", out JsonElement id)) return Ok(new { state = 1, message = "参数错误！" });
                if (!jsonElement.TryGetProperty("schoolcode", out JsonElement schoolcode)) return Ok(new { state = 1, message = "参数错误！" });

                var client = _azureCosmos.GetCosmosClient();
                string sqltxt = $"select * from c where c.id='{id}'";

                List<string> roles = new List<string>();//角色列表
                List<string> permissions = new List<string>();//权限列表

                var schoolRoles = await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "School").ReadItemStreamAsync($"{id}", new PartitionKey($"Teacher-{schoolcode}"));
                if (schoolRoles.Status == 200)
                {
                    using var json = await JsonDocument.ParseAsync(schoolRoles.ContentStream);
                    if (json.RootElement.TryGetProperty("roles", out JsonElement _roles) && _roles.ValueKind != JsonValueKind.Null)
                    {
                        foreach (var obj in _roles.EnumerateArray())
                        {
                            roles.Add(obj.GetString());
                        }
                    }
                    if (json.RootElement.TryGetProperty("permissions", out JsonElement _permissions) && _permissions.ValueKind != JsonValueKind.Null)
                    {
                        foreach (var obj in _permissions.EnumerateArray())
                        {
                            permissions.Add(obj.GetString());
                        }
                    }
                }

                return Ok(new { state = 200, roles = roles, permissions = permissions });
            }
            catch (Exception ex)
            {
                await _dingDing.SendBotMsg($"BI，{_option.Location},  /batchschool/get-teacherroles \n{ex.Message}{ex.StackTrace}", GroupNames.成都开发測試群組);
                return BadRequest();

            }
        }

        /// <summary>
        /// 依据传输的数据更新和删除权限
        /// </summary>
        /// <param name="jsonElement"></param>
        /// <returns></returns>
        [ProducesDefaultResponseType]
        [AuthToken(Roles = "assist")]
        [HttpPost("upd-permissions")]
        public async Task<IActionResult> SetSchoolPermissions(JsonElement jsonElement)
        {
            try
            {
                if (!jsonElement.TryGetProperty("ids", out JsonElement ids)) return Ok(new { state = 1, message = "ids参数错误！" });
                if (!jsonElement.TryGetProperty("school_code", out JsonElement school_code)) return Ok(new { state = 1, message = "school_code参数错误！" });
                if (!jsonElement.TryGetProperty("mode", out JsonElement mode)) return Ok(new { state = 1, message = "mode参数错误！" });     //del删除权限  up更新权限
                if (!jsonElement.TryGetProperty("paramPower", out JsonElement paramPower)) return Ok(new { state = 1, message = "paramPower参数错误！" });
                if (!jsonElement.TryGetProperty("tmdId", out JsonElement _tmdId)) return BadRequest();
                if (!jsonElement.TryGetProperty("tmdName", out JsonElement _tmdName)) return BadRequest();
                List<Exist> havepower = new List<Exist>(); //已存在的
                var client = _azureCosmos.GetCosmosClient();

                StringBuilder stringBuilder = new StringBuilder($"{_tmdName}【{_tmdId}】账户操作：");
                //更新权限
                foreach (var id in ids.EnumerateArray())
                {
                    SchoolTeacher st = await client.GetContainer(Constant.TEAMModelOS, "School").ReadItemAsync<SchoolTeacher>($"{id}", new PartitionKey($"Teacher-{school_code}"));

                    if (mode.GetString().Equals("del"))
                    {
                        stringBuilder.Append($"{st.name}【{st.id}】的权限，删除权限有：");
                        foreach (var pm in paramPower.EnumerateArray())
                        {
                            var bools = st.permissions.Find(x => x.Equals($"{pm}"));
                            if (!string.IsNullOrEmpty($"{bools}"))
                            {
                                st.permissions.RemoveAll(x => x.Equals($"{bools}"));
                                stringBuilder.Append(pm);
                            }
                        }
                    }
                    else if (mode.GetString().Equals("up"))
                    {
                        stringBuilder.Append($"{st.name}【{st.id}】的权限，更新权限有：");
                        var stes = st.roles.Find(x => x.Equals("assistant"));
                        if (string.IsNullOrEmpty($"{stes}"))
                        {
                            st.roles.Add("assistant");
                        }
                        foreach (var pm in paramPower.EnumerateArray())
                        {
                            var bools = st.permissions.Find(x => x.Equals($"{pm}"));
                            if (!string.IsNullOrEmpty($"{bools}"))
                            {
                                havepower.Add(new Exist { ID = id.GetString(), name = bools });
                            }
                            else
                            {
                                st.permissions.Add(pm.GetString());
                                stringBuilder.Append(pm);
                            }
                        }
                        if (havepower.Count > 0)
                        {
                            stringBuilder.Append($"；已存在的权限:{havepower}");
                        }
                    }
                    else { return Ok(new { state = 1, message = "mode参数错误！" }); }
                    await client.GetContainer(Constant.TEAMModelOS, "School").ReplaceItemAsync<SchoolTeacher>(st, id.GetString(), new PartitionKey($"Teacher-{school_code}"));
                }

                //保存操作记录
                await _azureStorage.SaveLog("school-update", stringBuilder?.ToString(), _dingDing, httpContext: HttpContext);

                return Ok(new { state = 200, havepower = havepower });
            }
            catch (Exception ex)
            {
                await _dingDing.SendBotMsg($"BI，{_option.Location}, /batchschool/upd-permissions \n{ex.Message}{ex.StackTrace}", GroupNames.成都开发測試群組);
                return BadRequest();
            }
        }

        /// <summary>
        /// 批量创校
        /// </summary>
        /// <param name="school"></param>
        /// <returns></returns>
        [ProducesDefaultResponseType]
        [AuthToken(Roles = "assist")]
        [HttpPost("batch-school")]
        public async Task<IActionResult> BatchCreateSchool(FoundSchools foundSchools)
        {
            try
            {
                List<BISchool> schools = new List<BISchool>();

                StringBuilder stringBuilder = new StringBuilder($"{foundSchools.tmdName}【{foundSchools.tmdId}】使用批量创校功能：");

                if (foundSchools.biSchools.Count > 0)
                {
                    var cosmosClient = _azureCosmos.GetCosmosClient();
                    foreach (BISchool bischool in foundSchools.biSchools)
                    {
                        string tempTmdId = null;
                        HttpClient httpClient = _http.CreateClient();
                        string url = _configuration.GetValue<string>("HaBookAuth:CoreId:userinfo");
                        List<string> mobile = new List<string>() { bischool.admin };
                        HttpResponseMessage responseMessage = await httpClient.PostAsJsonAsync(url, mobile);
                        if (responseMessage.StatusCode == HttpStatusCode.OK)
                        {
                            string temp = responseMessage.Content.ReadAsStringAsync().Result;
                            List<JsonElement> json_id = temp.ToObject<List<JsonElement>>();
                            foreach (var item in json_id)
                            {
                                tempTmdId = item.GetProperty("id").ToString();
                            }
                        }

                        string tmdId = !string.IsNullOrEmpty(tempTmdId) ? tempTmdId : bischool.admin;

                        CreateSchoolInfo createSchoolInfo = new CreateSchoolInfo()
                        {
                            province = bischool.province,
                            id = "",
                            name = bischool.name,
                            city = bischool.city,
                            aname = "",
                            createCount = 0,
                        };

                        //生成学校ID
                        bool tempStaus = true;
                        do
                        {
                            createSchoolInfo = await SchoolCode.GenerateSchoolCode(createSchoolInfo, _dingDing, _environment);
                            var schoolStatu = await cosmosClient.GetContainer(Constant.TEAMModelOS, "School").ReadItemStreamAsync($"{createSchoolInfo.id}", new PartitionKey($"Base"));
                            if (schoolStatu.Status != 200) tempStaus = false;
                            else createSchoolInfo.createCount = createSchoolInfo.createCount >= 3 ? createSchoolInfo.createCount = 3 : createSchoolInfo.createCount += 1;
                        } while (tempStaus);

                        if (createSchoolInfo.id != null)
                        {
                            string campusId = Guid.NewGuid().ToString();
                            School upSchool = new School
                            {
                                id = createSchoolInfo.id,
                                name = bischool.name,
                                size = bischool.size,
                                code = "Base",
                                campuses = new List<Campus> { new Campus { name = bischool.name, id = campusId } },
                                region = bischool.region,
                                province = bischool.province,
                                city = bischool.city,
                                dist = bischool.dist,
                                address = bischool.address,
                                picture = "https://teammodelstorage.blob.core.chinacloudapi.cn/0-public/school/bbf54fb3-3fc8-43ae-a358-107281c174cc.png",
                                timeZone = new TEAMModelOS.SDK.Models.TimeZone { label = "(UTC+08:00) 北京，重庆，香港特别行政区，乌鲁木齐", value = "+08:00" },
                                type = 1,
                                pk = "School",
                                ttl = -1,
                                schoolCode = createSchoolInfo.id,
                                period = PresetSchoolPeriod(bischool.period,foundSchools.lang,campusId)
                            };
                            stringBuilder.Append($"创建学校：{upSchool.name}【{upSchool.id}】");
                            //创建学校
                            await cosmosClient.GetContainer(Constant.TEAMModelOS, "School").CreateItemAsync<School>(upSchool, new PartitionKey(upSchool.code));
                            Teacher teacher = null;
                            try
                            {
                                //查询该教师是否存在
                                teacher = await cosmosClient.GetContainer(Constant.TEAMModelOS, "Teacher").ReadItemAsync<Teacher>($"{tmdId}", new PartitionKey("Base"));
                            }
                            catch
                            {
                            }
                            if (teacher != null)
                            {
                                //教师存在，在该教师信息中添加要管理的学校信息
                                teacher.schools.Add(new Teacher.TeacherSchool { schoolId = createSchoolInfo.id, name = bischool.name, status = "join", time = DateTimeOffset.UtcNow.ToUnixTimeMilliseconds() });
                                //await cosmosClient.GetContainer(Constant.TEAMModelOS, "Teacher").ReplaceItemAsync<Teacher>(teacher, tmdId, new PartitionKey("Base"));
                                SchoolTeacher schoolTeacher = new SchoolTeacher
                                {
                                    id = tmdId,
                                    code = $"Teacher-{createSchoolInfo.id}",
                                    roles = new List<string> { "admin", "teacher" },
                                    job = "管理员",
                                    name = teacher.name,
                                    picture = teacher.picture,
                                    status = "join",
                                    createTime = DateTimeOffset.UtcNow.ToUnixTimeSeconds(),
                                    pk = "Teacher",
                                    ttl = -1
                                };

                                stringBuilder.Append($"教师信息：{schoolTeacher.name}【{schoolTeacher.id}】，教师权限：{string.Join(",", schoolTeacher.roles)}");
                                await cosmosClient.GetContainer(Constant.TEAMModelOS, "Teacher").ReplaceItemAsync<Teacher>(teacher, teacher.id, new PartitionKey(teacher.code));
                                await cosmosClient.GetContainer(Constant.TEAMModelOS, "School").CreateItemAsync<SchoolTeacher>(schoolTeacher, new PartitionKey(schoolTeacher.code));
                            }
                            else
                            {
                                //不存在 新建教师和新建要管理的学校信息
                                Teacher addteacher = new Teacher
                                {
                                    id = tmdId,
                                    pk = "Base",
                                    code = "Base",
                                    name = $"{bischool.name}-管理员"?.ToString(),
                                    picture = "",
                                    //创建账号并第一次登录IES5则默认赠送1G
                                    size = 1,
                                    defaultSchool = createSchoolInfo.id,
                                    schools = new List<Teacher.TeacherSchool>() { new Teacher.TeacherSchool { schoolId = createSchoolInfo.id, name = bischool.name, status = "join", time = DateTimeOffset.UtcNow.ToUnixTimeMilliseconds() } }
                                };

                                stringBuilder.Append($"没有该教师信息创建的教师信息：{addteacher.name}【{addteacher.id}】");
                                await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "Teacher").CreateItemAsync<Teacher>(addteacher, new PartitionKey("Base"));
                                SchoolTeacher schoolTeacher = new SchoolTeacher
                                {
                                    id = tmdId,
                                    code = $"Teacher-{createSchoolInfo.id}",
                                    roles = new List<string> { "admin", "teacher" },
                                    job = "管理员",
                                    name = $"{tmdId}-管理员",
                                    picture = "",
                                    status = "join",
                                    createTime = DateTimeOffset.UtcNow.ToUnixTimeSeconds(),
                                    pk = "Teacher",
                                    ttl = -1
                                };

                                stringBuilder.Append($"教师权限：{string.Join(",", schoolTeacher.roles)}");
                                await cosmosClient.GetContainer(Constant.TEAMModelOS, "School").CreateItemAsync<SchoolTeacher>(schoolTeacher, new PartitionKey(schoolTeacher.code));
                            }
                        }
                    }
                }
                else return Ok(new { state = 1, message = "创校信息为空" });

                //保存操作记录
                await _azureStorage.SaveLog("school-batchAdd", stringBuilder?.ToString(), _dingDing, httpContext: HttpContext);

                if (schools.Count > 0)
                    return Ok(new { state = 201, message = "已有部分学校批量创建成功；学校编号已经重复！请检查学校编号！", schools = schools });
                else
                    return Ok(new { state = 200, message = "批量创校已全部完成" });
            }
            catch (Exception ex)
            {
                await _dingDing.SendBotMsg($"BI，{_option.Location} /batchschool/batch-school \n {ex.Message}{ex.StackTrace}", GroupNames.成都开发測試群組);
                return BadRequest();
            }
        }

        /// <summary>
        /// 依据学校编号查询学校信息；若是没有传学校编号，则查询所有学校信息
        /// </summary>
        /// <param name="jsonElement"></param>
        /// <returns></returns>
        [ProducesDefaultResponseType]
        [HttpPost("get-schoolsinfo")]
        public async Task<IActionResult> GetSchoolsInfo(JsonElement jsonElement)
        {
            try
            {
                jsonElement.TryGetProperty("schoolCode", out JsonElement _schoolCode);
                var cosmosClient = _azureCosmos.GetCosmosClient();
                List<School> schools = new List<School>();
                List<SchoolAssist> schoolAssists = new List<SchoolAssist>();
                StringBuilder stringBuilder = new StringBuilder("select value(c) from c");

                if (!string.IsNullOrEmpty($"{_schoolCode}"))
                {
                    stringBuilder.Append($" where c.id='{_schoolCode}'");
                }

                await foreach (var itemSchool in cosmosClient.GetContainer(Constant.TEAMModelOS, "School").GetItemQueryIterator<School>(queryText: stringBuilder.ToString(), requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey("Base") }))
                {
                    SchoolAssist schoolAssist = new SchoolAssist();
                    schoolAssist.id = itemSchool.id;
                    schoolAssist.code = itemSchool.code;
                    schoolAssist.pk = itemSchool.pk;
                    schoolAssist.ttl = itemSchool.ttl;
                    schoolAssist.schoolCode = itemSchool.schoolCode;
                    schoolAssist.name = itemSchool.name;
                    schoolAssist.period = itemSchool.period;
                    schoolAssist.campuses = itemSchool.campuses;
                    schoolAssist.region = itemSchool.region;
                    schoolAssist.province = itemSchool.province;
                    schoolAssist.city = itemSchool.city;
                    schoolAssist.dist = itemSchool.dist;
                    schoolAssist.areaId = itemSchool.areaId;
                    schoolAssist.size = itemSchool.size;
                    schoolAssist.address = itemSchool.address;
                    schoolAssist.picture = itemSchool.picture;
                    schoolAssist.timeZone = itemSchool.timeZone;
                    schoolAssist.type = itemSchool.type;
                    schoolAssist.standard = itemSchool.standard;
                    schoolAssist.hpappraise = itemSchool.hpappraise;
                    schoolAssist.standard = itemSchool.standard;
                    schoolAssist.areaId = itemSchool.areaId;

                    List<Assist> assists = new List<Assist>();
                    //查询学校的顾问
                    string managerSql = $"SELECT DISTINCT REPLACE(c.code, 'Teacher-', '') AS schoolId, c.id, c.name FROM c WHERE ARRAY_CONTAINS(c.roles, 'assist', true) AND c.pk = 'Teacher' AND c.status = 'join' AND c.code = 'Teacher-{itemSchool.id}'";
                    var cosmosClent = _azureCosmos.GetCosmosClient();
                    await foreach (var item in cosmosClent.GetContainer(Constant.TEAMModelOS, "School").GetItemQueryStreamIterator(queryText: managerSql, requestOptions: new QueryRequestOptions() { }))
                    {
                        using var json = await JsonDocument.ParseAsync(item.ContentStream);
                        foreach (var obj in json.RootElement.GetProperty("Documents").EnumerateArray())
                        {
                            Assist assist = new Assist
                            {
                                tmdId = obj.GetProperty("id").GetString(),
                                tmdName = obj.GetProperty("name").GetString()
                            };

                            assists.Add(assist);
                        }
                    }
                    schoolAssist.assists = assists;
                    schoolAssists.Add(schoolAssist);
                }

                return Ok(new { state = 200, schoolAssists });
            }
            catch (Exception ex)
            {
                await _dingDing.SendBotMsg($"BI,{_option.Location}  /batchschool/get-schoolsinfo  \n {ex.Message}{ex.StackTrace}", GroupNames.成都开发測試群組);
                return BadRequest();
            }
        }

        /// <summary>
        /// 取得学校所有顾问列表
        /// </summary>
        /// <returns></returns>
        [ProducesDefaultResponseType]
        [HttpPost("get-schoolassist")]
        public async Task<IActionResult> GetSchoolAssist(JsonElement jsonElement)
        {
            try
            {
                string schoolId = (jsonElement.TryGetProperty("schoolId", out JsonElement _schoolId)) ? _schoolId.GetString() : string.Empty;

                Dictionary<string, List<Dictionary<string, string>>> haveSchoolManger = new Dictionary<string, List<Dictionary<string, string>>>();

                string managerWhereOption = (!string.IsNullOrWhiteSpace(schoolId)) ? $" AND c.code = 'Teacher-{schoolId}'" : string.Empty;
                //查询学校的顾问
                string managerSql = $"SELECT DISTINCT REPLACE(c.code, 'Teacher-', '') AS schoolId, c.id, c.name FROM c WHERE ARRAY_CONTAINS(c.roles, 'assist', true) AND c.pk = 'Teacher' AND c.status = 'join'{managerWhereOption}";
                var cosmosClent = _azureCosmos.GetCosmosClient();
                await foreach (var item in cosmosClent.GetContainer(Constant.TEAMModelOS, "School").GetItemQueryStreamIterator(queryText: managerSql, requestOptions: new QueryRequestOptions() { }))
                {
                    using var json = await JsonDocument.ParseAsync(item.ContentStream);
                    foreach (var obj in json.RootElement.GetProperty("Documents").EnumerateArray())
                    {
                        string id = obj.GetProperty("id").GetString(); //管理员ID
                        string name = obj.GetProperty("name").GetString(); //管理员姓名
                        string tempSchoolId = obj.GetProperty("schoolId").GetString(); //学校ID
                        Dictionary<string, string> managerDic = new Dictionary<string, string>();
                        managerDic.Add("id", id);
                        managerDic.Add("name", name);
                        if (haveSchoolManger.ContainsKey(tempSchoolId))
                        {
                            haveSchoolManger[tempSchoolId].Add(managerDic);
                        }
                        else
                        {
                            List<Dictionary<string, string>> managerList = new List<Dictionary<string, string>>();
                            managerList.Add(managerDic);
                            haveSchoolManger.Add(tempSchoolId, managerList);
                        }
                    }
                }

                //管理模组学校
                List<string> baseModuleSchoos = new List<string>();
                string baseWhereOption = (!string.IsNullOrEmpty(schoolId)) ? $" and c.id='{schoolId}'" : string.Empty;
                await foreach (var item in cosmosClent.GetContainer(Constant.TEAMModelOS, "School").GetItemQueryStreamIterator(queryText: $"select c.id from c join serviceProduct in c.service.product where serviceProduct.prodCode = 'IPDYZYLC' {baseWhereOption}", requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey("Product") }))
                {
                    using var json = await JsonDocument.ParseAsync(item.ContentStream);
                    foreach (var obj in json.RootElement.GetProperty("Documents").EnumerateArray())
                    {
                        string tempSchoolId = obj.GetProperty("id").GetString();  //学校ID
                        baseModuleSchoos.Add(tempSchoolId);
                    }
                }

                //学校信息
                List<object> schools = new List<object>();
                string schoolWhereOption = (!string.IsNullOrEmpty(schoolId)) ? $" where c.id='{schoolId}'" : string.Empty;
                await foreach (var item in cosmosClent.GetContainer(Constant.TEAMModelOS, "School").GetItemQueryStreamIterator(queryText: $"select c.id,c.name,c.period,c.schoolCode,c.region,c.province,c.city,c.picture from c {schoolWhereOption}", requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey("Base") }))
                {
                    using var json = await JsonDocument.ParseAsync(item.ContentStream);
                    foreach (var obj in json.RootElement.GetProperty("Documents").EnumerateArray())
                    {
                        dynamic schoolExpando = new ExpandoObject();
                        schoolExpando.id = obj.GetProperty("id").GetString();
                        schoolExpando.name = obj.GetProperty("name").GetString();
                        //schoolExpando.period = obj.GetProperty("period");
                        schoolExpando.schoolCode = obj.GetProperty("schoolCode").GetString();
                        schoolExpando.region = obj.GetProperty("region").GetString();
                        schoolExpando.province = obj.GetProperty("province").GetString();
                        schoolExpando.city = obj.GetProperty("city").GetString();
                        schoolExpando.picture = obj.GetProperty("picture").GetString();
                        if (haveSchoolManger.ContainsKey(schoolExpando.id))
                        {
                            schoolExpando.hasMarger = true;
                            schoolExpando.managers = haveSchoolManger[schoolExpando.id];
                        }
                        else
                        {
                            schoolExpando.hasMarger = false;
                            schoolExpando.managers = new List<object>();
                        }
                        schoolExpando.hasBaseModule = (baseModuleSchoos.Contains(schoolExpando.id)) ? true : false;
                        schools.Add(schoolExpando);
                    }
                }

                return Ok(new { state = 200, schools });
            }
            catch (Exception ex)
            {
                await _dingDing.SendBotMsg($"BI,{_option.Location}  /batchschool/get-schools \n {ex.Message}{ex.StackTrace}", GroupNames.成都开发測試群組);
                return BadRequest();
            }
        }

        /// <summary>
        /// 修改学校信息和顾问信息
        /// </summary>
        /// <param name="jsonElement"></param>
        /// <returns></returns>
        [ProducesDefaultResponseType]
        [AuthToken(Roles = "assist")]
        [HttpPost("upd-schoolassist")]
        public async Task<IActionResult> UpdSchoolAssist(JsonElement jsonElement)
        {
            try
            {
                if (!jsonElement.TryGetProperty("schoolId", out JsonElement _schoolId)) return BadRequest();
                if (!jsonElement.TryGetProperty("period", out JsonElement period)) return BadRequest();
                if (!jsonElement.TryGetProperty("picture", out JsonElement picture)) return BadRequest();
                if (!jsonElement.TryGetProperty("size", out JsonElement size)) return BadRequest();
                if (!jsonElement.TryGetProperty("assistId", out JsonElement _assistId)) return BadRequest();
                if (!jsonElement.TryGetProperty("tmdId", out JsonElement _tmdId)) return BadRequest();
                if (!jsonElement.TryGetProperty("tmdName", out JsonElement _tmdName)) return BadRequest();

                List<string> assistId = _assistId.ToObject<List<string>>();
                List<string> periodS = period.ToObject<List<string>>();

                SchoolAssist schoolAssist = new();
                Dictionary<string, List<Dictionary<string, string>>> haveSchoolManger = new Dictionary<string, List<Dictionary<string, string>>>();

                //操作记录
                string blobOrTable = DateTimeOffset.UtcNow.ToUnixTimeMilliseconds().ToString();


                var cosmosClient = _azureCosmos.GetCosmosClient();
                School tempShool = await cosmosClient.GetContainer(Constant.TEAMModelOS, "School").ReadItemAsync<School>($"{_schoolId}", new PartitionKey("Base"));
                if (tempShool != null)
                {
                    List<Period> periods = new List<Period>();
                    string campusId = Guid.NewGuid().ToString();
                    periodS.ForEach(x =>
                    {
                        periods.Add(new Period { id = Guid.NewGuid().ToString(), name = x.ToString(), campusId = campusId });
                    });

                    tempShool.period = periods;
                    tempShool.size = !string.IsNullOrEmpty($"{size}") ? int.Parse($"{size}") : tempShool.size;
                    tempShool.picture = $"{picture}";
                    //修改学校
                    await cosmosClient.GetContainer(Constant.TEAMModelOS, "School").ReplaceItemAsync<School>(tempShool, tempShool.id, new PartitionKey("Base"));

                    if (assistId.Count > 0)
                    {
                        foreach (var itemTeacher in assistId)
                        {
                            Teacher tempTeacher = await cosmosClient.GetContainer(Constant.TEAMModelOS, "Teacher").ReadItemAsync<Teacher>($"{itemTeacher}", new PartitionKey("Base"));
                            if (tempTeacher != null)
                            {
                                var haveTeacher = tempTeacher.schools.Find(x => x.schoolId.Equals($"{_schoolId}"));
                                if (haveTeacher != null)
                                {
                                    //查询该教师是否存在该校
                                    SchoolTeacher schoolTeacher = await cosmosClient.GetContainer(Constant.TEAMModelOS, "School").ReadItemAsync<SchoolTeacher>($"{itemTeacher}", new PartitionKey($"Teacher-{tempShool.id}"));
                                    if (schoolTeacher != null)
                                    {
                                        if (!schoolTeacher.roles.Contains("assist"))
                                        {
                                            schoolTeacher.roles.Add("assist");
                                            //添加顾问权限
                                            await cosmosClient.GetContainer(Constant.TEAMModelOS, "School").ReplaceItemAsync<SchoolTeacher>(schoolTeacher, schoolTeacher.id, new PartitionKey($"Teacher-{tempShool.id}"));
                                        }
                                    }
                                    else
                                    {
                                        SchoolTeacher addSchoolTeacher = new SchoolTeacher
                                        {
                                            id = itemTeacher,
                                            code = $"Teacher-{tempShool.id}",
                                            pk = "Teacher",
                                            status = "join",
                                            roles = new List<string>() { "assist" },
                                            name = tempTeacher.name,
                                            job = $"{tempShool.name}-顾问",
                                            size = 0,
                                            createTime = DateTimeOffset.UtcNow.ToUnixTimeSeconds()
                                        };
                                        //添加学校顾问
                                        await cosmosClient.GetContainer(Constant.TEAMModelOS, "School").CreateItemAsync<SchoolTeacher>(schoolTeacher, new PartitionKey($"Teacher-{tempShool.id}"));
                                    }
                                }
                                else
                                {
                                    Teacher.TeacherSchool teacherSchool = new Teacher.TeacherSchool
                                    {
                                        schoolId = tempShool.id,
                                        name = tempShool.name,
                                        status = "join",
                                        time = DateTimeOffset.UtcNow.ToUnixTimeSeconds(),
                                        picture = tempShool.picture,
                                        areaId = tempShool.areaId
                                    };
                                    tempTeacher.schools.Add(teacherSchool);
                                    //给醍摩豆顾问添加学校
                                    await cosmosClient.GetContainer(Constant.TEAMModelOS, "Teacher").ReplaceItemAsync<Teacher>(tempTeacher, tempTeacher.id, new PartitionKey($"Base"));

                                    //不存在则在原来的基础上添加顾问角色
                                    SchoolTeacher addSchoolTeacher = new SchoolTeacher
                                    {
                                        id = itemTeacher,
                                        code = $"Teacher-{tempShool.id}",
                                        pk = "Teacher",
                                        status = "join",
                                        roles = new List<string>() { "assist" },
                                        name = tempTeacher.name,
                                        job = $"{tempShool.name}-顾问",
                                        size = 0,
                                        createTime = DateTimeOffset.UtcNow.ToUnixTimeSeconds()
                                    };
                                    //添加学校学校顾问
                                    await cosmosClient.GetContainer(Constant.TEAMModelOS, "School").CreateItemAsync<SchoolTeacher>(addSchoolTeacher, new PartitionKey($"Teacher-{tempShool.id}"));
                                }
                            }
                        }
                    }

                    schoolAssist.id = tempShool.id;
                    schoolAssist.code = tempShool.code;
                    schoolAssist.pk = tempShool.pk;
                    schoolAssist.ttl = tempShool.ttl;
                    schoolAssist.schoolCode = tempShool.schoolCode;
                    schoolAssist.name = tempShool.name;
                    schoolAssist.period = tempShool.period;
                    schoolAssist.campuses = tempShool.campuses;
                    schoolAssist.region = tempShool.region;
                    schoolAssist.province = tempShool.province;
                    schoolAssist.city = tempShool.city;
                    schoolAssist.dist = tempShool.dist;
                    schoolAssist.areaId = tempShool.areaId;
                    schoolAssist.size = tempShool.size;
                    schoolAssist.address = tempShool.address;
                    schoolAssist.picture = tempShool.picture;
                    schoolAssist.timeZone = tempShool.timeZone;
                    schoolAssist.type = tempShool.type;
                    schoolAssist.standard = tempShool.standard;
                    schoolAssist.hpappraise = tempShool.hpappraise;

                    List<Assist> assists = new List<Assist>();
                    //查询学校的顾问
                    string managerSql = $"SELECT DISTINCT REPLACE(c.code, 'Teacher-', '') AS schoolId, c.id, c.name FROM c WHERE ARRAY_CONTAINS(c.roles, 'assist', true) AND c.pk = 'Teacher' AND c.status = 'join' AND c.code = 'Teacher-{tempShool.id}'";
                    var cosmosClent = _azureCosmos.GetCosmosClient();
                    await foreach (var item in cosmosClent.GetContainer(Constant.TEAMModelOS, "School").GetItemQueryStreamIterator(queryText: managerSql, requestOptions: new QueryRequestOptions() { }))
                    {
                        using var json = await JsonDocument.ParseAsync(item.ContentStream);
                        foreach (var obj in json.RootElement.GetProperty("Documents").EnumerateArray())
                        {
                            Assist assist = new Assist
                            {
                                tmdId = obj.GetProperty("id").GetString(),
                                tmdName = obj.GetProperty("name").GetString()
                            };
                            assists.Add(assist);
                        }
                    }

                    schoolAssist.assists = assists;
                }

                //保存操作记录
                await _azureStorage.SaveLog("TeacherRoles-update", $"{_tmdName}【{_tmdId}】修改学校功能，修改的学校:{_schoolId},{string.Join("|", periodS.ToArray())},{picture},{size},{string.Join("|", assistId.ToArray())}", _dingDing, httpContext: HttpContext);


                return Ok(new { state = 200, schoolAssist });
            }
            catch (Exception ex)
            {
                await _dingDing.SendBotMsg($"BI,  {_option.Location}   /batchschool/upd-schoolassist   \n  {ex.Message}{ex.StackTrace}", GroupNames.成都开发測試群組);
                return BadRequest();
            }
        }

        /// <summary>
        /// 增加学段
        /// </summary>
        /// <returns></returns>
        [ProducesDefaultResponseType]
        [AuthToken(Roles = "assist")]
        [HttpPost("upd-schoolperiod")]
        public async Task<IActionResult> UpdSchoolPeriod(JsonElement jsonElement)
        {
            try
            {
                if (!jsonElement.TryGetProperty("schooId", out JsonElement _schoolCode)) return BadRequest();   //学校编号
                jsonElement.TryGetProperty("campusId", out JsonElement _campusId);      //校区ID  新增时
                jsonElement.TryGetProperty("campusName", out JsonElement _campusName);        //校区   新增时
                if (!jsonElement.TryGetProperty("periodName", out JsonElement _periodName)) return BadRequest();    //新增学段名称
                if (!jsonElement.TryGetProperty("tmdId", out JsonElement _tmdId)) return BadRequest();   //醍摩豆账户
                if (!jsonElement.TryGetProperty("tmdName", out JsonElement _tmdName)) return BadRequest(); //醍摩豆账号名称
         
                StringBuilder stringBuilder = new StringBuilder($"{_tmdId}【{_tmdName}】新增学校的学段，");
                School school = new();

                var cosmosClient = _azureCosmos.GetCosmosClient();
                try
                {
                    school = await cosmosClient.GetContainer(Constant.TEAMModelOS, "School").ReadItemAsync<School>($"{_schoolCode}", new PartitionKey("Base"));
                }
                catch (Exception) { }

                if (school != null)
                {
                    if (!string.IsNullOrEmpty($"{_campusId}"))
                    {
                        school.period.Add(new Period { id = Guid.NewGuid().ToString(), name = $"{_periodName}", campusId = $"{_campusId}" });
                        stringBuilder.Append($"在原有校区中添加学段：学段ID：{_campusId}学段名称：{_periodName}");
                    }
                    else
                    {
                        string campusId = Guid.NewGuid().ToString();
                        school.period.Add(new Period { id = Guid.NewGuid().ToString(), name = $"{_periodName}", campusId = campusId });
                        school.campuses.Add(new Campus { id = campusId, name = $"{_campusName}" });
                        stringBuilder.Append($"新建校区中在添加学段：学段ID：{_campusId}学段名称：{_periodName}");
                    }

                    await cosmosClient.GetContainer(Constant.TEAMModelOS, "School").ReplaceItemAsync<School>(school, school.id, new PartitionKey("Base"));

                    //保存操作记录
                    await _azureStorage.SaveLog("schoolperiod-add", stringBuilder?.ToString(), _dingDing, httpContext: HttpContext);

                    return Ok(new { state = 200, school });
                }
                else return Ok(new { state = 400, school });

            }
            catch (Exception ex)
            {
                await _dingDing.SendBotMsg($"BI,{_option.Location}  /batchschool/upd-schoolperiod   \n {ex.Message}{ex.StackTrace}", GroupNames.成都开发測試群組);
                return BadRequest();
            }
        }

        /// <summary>
        /// 修改学校学段信息
        /// </summary>
        /// <param name="jsonElement"></param>
        /// <returns></returns>
        [ProducesDefaultResponseType]
        [AuthToken(Roles = "assist")]
        [HttpPost("set-schoolperiod")]
        public async Task<IActionResult> SetSchoolPeriod(JsonElement jsonElement)
        {
            try
            {
                if (!jsonElement.TryGetProperty("tmdId", out JsonElement _tmdId)) return BadRequest();   //醍摩豆账户
                if (!jsonElement.TryGetProperty("tmdName", out JsonElement _tmdName)) return BadRequest(); //醍摩豆账号名称
                if (!jsonElement.TryGetProperty("schooId", out JsonElement _schoolCode)) return BadRequest();   //学校编号
                if (!jsonElement.TryGetProperty("setId", out JsonElement _setId)) return BadRequest();          //修改学段的ID
                if (!jsonElement.TryGetProperty("setName", out JsonElement _setName)) return BadRequest();           //修改学段的名称

                var cosmosClient = _azureCosmos.GetCosmosClient();
                School school = new();
                try
                {
                    school = await cosmosClient.GetContainer(Constant.TEAMModelOS, "School").ReadItemAsync<School>($"{_schoolCode}", new PartitionKey("Base"));
                }
                catch (Exception) { }

                if (school != null)
                {
                    school.period.Find(x => x.id.Equals($"{_setId}")).name = $"{_setName}";

                    await cosmosClient.GetContainer(Constant.TEAMModelOS, "School").ReplaceItemAsync<School>(school, school.id, new PartitionKey("Base"));

                    //保存操作记录
                    await _azureStorage.SaveLog("schoolperiod-update", $"{_tmdId}【{_tmdName}】修改学校学段信息，修改ID和名称:{_setId}{_setName}", _dingDing, httpContext: HttpContext);

                    return Ok(new { state = 200, school });
                }
                else return Ok(new { state = 400, school });
            }
            catch (Exception ex)
            {
                await _dingDing.SendBotMsg($"BI,{_option.Location}  /batchschool/set-schoolperiod   \n {ex.Message}{ex.StackTrace} ", GroupNames.成都开发測試群組);
                return BadRequest();
            }
        }

        /// <summary>
        /// 删除学校学段
        /// </summary>
        /// <param name="jsonElement"></param>
        /// <returns></returns>
        [ProducesDefaultResponseType]
        [AuthToken(Roles = "assist")]
        [HttpPost("del-schoolperiod")]
        public async Task<IActionResult> DelSchoolPeriod(JsonElement jsonElement)
        {
            try
            {
                if (!jsonElement.TryGetProperty("tmdId", out JsonElement _tmdId)) return BadRequest();   //醍摩豆账户
                if (!jsonElement.TryGetProperty("tmdName", out JsonElement _tmdName)) return BadRequest(); //醍摩豆账号名称
                if (!jsonElement.TryGetProperty("schooId", out JsonElement _schoolCode)) return BadRequest();   //学校编号
                if (!jsonElement.TryGetProperty("delId", out JsonElement _delId)) return BadRequest();               //删除学段的ID

                var cosmosClient = _azureCosmos.GetCosmosClient();
                School school = new();
                try
                {
                    school = await cosmosClient.GetContainer(Constant.TEAMModelOS, "School").ReadItemAsync<School>($"{_schoolCode}", new PartitionKey("Base"));
                }
                catch (Exception) { }

                if (school != null)
                {
                    school.period.Remove(school.period.Find(x => x.id.Equals($"{_delId}")));
                    await cosmosClient.GetContainer(Constant.TEAMModelOS, "School").ReplaceItemAsync<School>(school, school.id, new PartitionKey("Base"));

                    //保存操作记录
                    await _azureStorage.SaveLog("ability-update", $"{_tmdId}【{_tmdName}】删除学校的学段", _dingDing, httpContext: HttpContext);

                    return Ok(new { state = 200, school });
                }
                else return Ok(new { state = 400, school });
            }
            catch (Exception ex)
            {
                await _dingDing.SendBotMsg($"BI,{_option.Location}  /batchschool/del-schoolperiod \n {ex.Message}{ex.StackTrace}", GroupNames.成都开发測試群組);
                return BadRequest();
            }
        }

        /// <summary>
        /// 增加、修改、删除学段信息
        /// </summary>
        /// <param name="jsonElement"></param>
        /// <returns></returns>
        [ProducesDefaultResponseType]
        [AuthToken(Roles = "assist")]
        [HttpPost("set-schoolperiodinfo")]
        public async Task<IActionResult> SetSchoolPeriodInfo(JsonElement jsonElement)
        {
            try
            {
                if (!jsonElement.TryGetProperty("tmdId", out JsonElement _tmdId)) return BadRequest();   //醍摩豆账户
                if (!jsonElement.TryGetProperty("tmdName", out JsonElement _tmdName)) return BadRequest(); //醍摩豆账号名称
                if (!jsonElement.TryGetProperty("schooId", out JsonElement _schoolCode)) return BadRequest();   //学校编号
                if (!jsonElement.TryGetProperty("mode", out JsonElement _mode)) return BadRequest();   //执行方式 upd 新增学段   set 修改学段  del删除学段
                jsonElement.TryGetProperty("campusId", out JsonElement _campusId);            //校区ID  新增学段
                jsonElement.TryGetProperty("campusName", out JsonElement _campusName);        //校区    新增学段
                jsonElement.TryGetProperty("periodName", out JsonElement _periodName);        //新增学段名称
                jsonElement.TryGetProperty("setId", out JsonElement _setId);                  //修改学段的ID
                jsonElement.TryGetProperty("setName", out JsonElement _setName);              //修改学段的名称
                jsonElement.TryGetProperty("delId", out JsonElement _delId);                  //删除学段的ID

                StringBuilder stringBuilder = new StringBuilder($"{_tmdId}【{_tmdName}】");
                string tempType = null;
                var cosmosClient = _azureCosmos.GetCosmosClient();

                School school = new();
                try
                {
                    school = await cosmosClient.GetContainer(Constant.TEAMModelOS, "School").ReadItemAsync<School>($"{_schoolCode}", new PartitionKey("Base"));
                }
                catch (Exception) { }

                if (school != null)
                {
                    switch ($"{_mode}")
                    {
                        //新增学段
                        case "upd":

                            if (string.IsNullOrEmpty($"{_periodName}")) return Ok(new { state = 1 });
                            if (!string.IsNullOrEmpty($"{_campusId}"))
                            {
                                school.period.Add(new Period { id = Guid.NewGuid().ToString(), name = $"{_periodName}", campusId = $"{_campusId}" });
                                stringBuilder.Append($"新增学校学段,在原有校区中添加学段：学段ID：{_campusId}学段名称：{_periodName}");

                            }
                            else
                            {
                                string campusId = Guid.NewGuid().ToString();
                                school.period.Add(new Period { id = Guid.NewGuid().ToString(), name = $"{_periodName}", campusId = campusId });
                                school.campuses.Add(new Campus { id = campusId, name = $"{_campusName}" });

                                stringBuilder.Append($"新增学校学段,新建校区中在添加学段：学段ID：{_campusId}学段名称：{_periodName}");
                            }
                            tempType = "schoolperiod-add";
                            break;
                        //修改学段
                        case "set":
                            school.period.Find(x => x.id.Equals($"{_setId}")).name = $"{_setName}";
                            stringBuilder.Append($"修改学校学段，修改ID和名称:{_setId}{_setName}");
                            tempType = "schoolperiod-set";
                            break;

                        //删除学段
                        case "del":
                            school.period.Remove(school.period.Find(x => x.id.Equals($"{_delId}")));
                            stringBuilder.Append($"删除学校的学段，删除学段ID和名称:{_delId}");
                            tempType = "schoolperiod-del";
                            break;
                        default:
                            return Ok(new { state = 1, message = "mode参数错误" });
                    }

                    //保存操作记录
                    await _azureStorage.SaveLog(tempType?.ToString(), stringBuilder?.ToString(), _dingDing, httpContext: HttpContext);

                    await cosmosClient.GetContainer(Constant.TEAMModelOS, "School").ReplaceItemAsync<School>(school, school.id, new PartitionKey("Base"));

                    return Ok(new { state = 200, school });
                }
                else return Ok(new { state = 400, school });

            }
            catch (Exception ex)
            {
                await _dingDing.SendBotMsg($"BI,{_option.Location}  /batchschool/set-schoolperiodinfo   \n {ex.Message}{ex.StackTrace}", GroupNames.成都开发測試群組);
                return BadRequest();
            }
        }

        /// <summary>
        /// 查询区域的学校
        /// </summary>
        /// <param name="jsonElement"></param>
        /// <returns></returns>
        [ProducesDefaultResponseType]
        [HttpPost("get-schooldist")]
        public async Task<IActionResult> GetSchoolDist(JsonElement jsonElement)
        {
            try
            {
                if (!jsonElement.TryGetProperty("dist", out JsonElement _dist)) return BadRequest();

                var cosmosClient = _azureCosmos.GetCosmosClient();
                string sqltxt = $"SELECT * FROM c where c.dist='{_dist}'";

                List<School> schools = new List<School>();

                await foreach (var item in cosmosClient.GetContainer(Constant.TEAMModelOS, "School").GetItemQueryIterator<School>(queryText: sqltxt, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey("Base") }))
                {
                    schools.Add(item);
                }

                return Ok(new { state = 200, schools });
            }
            catch (Exception ex)
            {
                await _dingDing.SendBotMsg($"BI,{_option.Location}   /batchschool/get-schooldist  \n  {ex.Message}{ex.StackTrace}", GroupNames.成都开发測試群組);
                return BadRequest();
            }
        }


        #region   预设学校基础信息 多语言
        /// <summary>
        /// 预设学校基础信息 多语言
        /// </summary>
        /// <param name="period"></param>
        /// <param name="Language"></param>
        /// <param name="campusId"></param>
        /// <returns></returns>
        public List<Period> PresetSchoolPeriod(List<string> period, string Language, string campusId)
        {
            var builder = $"{_environment.ContentRootPath}/JsonFile/Preset/LangSchoolConfig.json";
            StreamReader streamReader = new StreamReader(new FileStream(builder, FileMode.Open, FileAccess.Read, FileShare.ReadWrite), Encoding.UTF8);
            StringBuilder stringBuilder = new StringBuilder();
            string text;
            while ((text = streamReader.ReadLine()) != null)
            {
                stringBuilder.Append(text.ToString());
            }
            streamReader.Close();
            string input = stringBuilder.ToString();
            List<SchoolConfig> schoolConfigs = input.ToObject<List<SchoolConfig>>();
            SchoolConfig schoolConfig = schoolConfigs.Find(x => x.Lang.Contains($"{Language}"));
           
            if (schoolConfig == null)
            {
                if (Language.Contains("en"))
                    schoolConfig = schoolConfigs.Find(x => x.Lang.Contains("en-US"));
                else
                    schoolConfig = schoolConfigs.Find(x => x.Lang.Contains("zh-CN"));
            }

            List<Period> periods = new List<Period>();
            period.ForEach(x =>
            {
                periods.Add(new Period
                {
                    id = Guid.NewGuid().ToString(),
                    name = x,
                    campusId = campusId,
                    semesters = new List<Semester>() { new Semester { name = schoolConfig.semester[0].term, start = schoolConfig.semester[0].start, month = schoolConfig.semester[0].month, day = schoolConfig.semester[0].day, id = Guid.NewGuid().ToString() },
                        new Semester { name = schoolConfig.semester[1].term, start = schoolConfig.semester[1].start, month = schoolConfig.semester[1].month, day = schoolConfig.semester[1].day, id = Guid.NewGuid().ToString() } },
                    subjects = new List<Subject>() {
                        new Subject { id=Guid.NewGuid().ToString(),name=schoolConfig.PresetSubject[0].name,type=schoolConfig.PresetSubject[0].type },
                        new Subject { id=Guid.NewGuid().ToString(),name=schoolConfig.PresetSubject[1].name,type=schoolConfig.PresetSubject[1].type },
                        new Subject { id=Guid.NewGuid().ToString(),name=schoolConfig.PresetSubject[2].name,type=schoolConfig.PresetSubject[2].type }
                    },
                    grades = schoolConfig.grades,
                    analysis = new Analysis()
                    {
                        type = new List<ExamSimple>() { new ExamSimple { id = Guid.NewGuid().ToString(), name = schoolConfig.PresetExam[0].type[0].name },
                        new ExamSimple { id = Guid.NewGuid().ToString(), name =  schoolConfig.PresetExam[0].type[1].name },
                        new ExamSimple { id = Guid.NewGuid().ToString(), name =  schoolConfig.PresetExam[0].type[2].name },
                        new ExamSimple { id = Guid.NewGuid().ToString(), name =  schoolConfig.PresetExam[0].type[3].name } },
                        income = schoolConfig.PresetExam[0].income,
                        eugenics = schoolConfig.PresetExam[0].eugenics,
                        touch = schoolConfig.PresetExam[0].touch
                    }
                });
            });

            return periods;
        }


        public record SchoolConfig
        {
            public string Lang { get; set; }
            public List<semester> semester { get; set; }
            public List<string> grades { get; set; }
            public List<PresetSubject> PresetSubject { get; set; }
            public List<PresetExam> PresetExam { get; set; }
        }

        public record semester
        {
            public string id { get; set; } = Guid.NewGuid().ToString();
            public string term { get; set; }
            public int start { get; set; }
            public int month { get; set; }
            public int day { get; set; }
        }

        public record PresetSubject
        {
            public string id { get; set; } = Guid.NewGuid().ToString();
            public string name { get; set; }

            public int type { get; set; }
        }

        public record PresetExam
        {
            public List<StudyType> type { get; set; }

            public int income { get; set; }

            public int eugenics { get; set; }

            public int touch { get; set; }
        }

        public record StudyType
        {
            public string id { get; set; } = Guid.NewGuid().ToString();
            public string name { get; set; }
        }

        #endregion



        public class SchoolAssist : School
        {
            public List<Assist> assists { get; set; }

        }
        public class Assist
        {
            public string tmdId { get; set; }
            public string tmdName { get; set; }
        }


        /// <summary>
        /// 创建多个学校实体
        /// </summary>
        public record FoundSchools()
        {
            /// <summary>
            ///醍摩豆账户ID
            /// </summary>
            public string tmdId { get; set; }

            /// <summary>
            /// 醍摩豆账户名称
            /// </summary>
            public string tmdName { get; set; }

            /// <summary>
            /// 语系
            /// </summary>
            public string lang { get; set; }

            /// <summary>
            /// 批量创校的数据结构
            /// </summary>
            public List<BISchool> biSchools { get; set; } = new List<BISchool>();
        }

        /// <summary>
        /// 批量创校的数据结构
        /// </summary>
        public record BISchool()
        {
            /// <summary>
            /// 学校名称
            /// </summary>
            public string name { get; set; }
            /// <summary>
            /// 学校管理员
            /// </summary>
            public string admin { get; set; }
            /// <summary>
            /// 学校的学段
            /// </summary>
            public List<string> period { get; set; }
            /// <summary>
            /// 学校空间大小
            /// </summary>
            public int size { get; set; }
            /// <summary>
            /// 地区
            /// </summary>
            public string region { get; set; }
            /// <summary>
            /// 省份
            /// </summary>
            public string province { get; set; }
            /// <summary>
            /// 城市
            /// </summary>
            public string city { get; set; }
            /// <summary>
            /// 县，区，郡
            /// </summary>
            public string dist { get; set; }

            /// <summary>
            /// 学校详细地址
            /// </summary>
            public string address { get; set; }
        }

        public record Exist()
        {
            public string ID { get; set; }
            public string name { get; set; }
        }

    }
}