TEAMModelOS/TEAMModelOS/Controllers/Both/CourseController.cs

using Microsoft.Azure.Cosmos;
using Microsoft.AspNetCore.Http;
using Microsoft.AspNetCore.Mvc;
using Microsoft.Extensions.Options;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text.Json;
using System.Threading.Tasks;
using TEAMModelOS.Models;
using TEAMModelOS.SDK.Models;
using TEAMModelOS.SDK;
using TEAMModelOS.SDK.DI;
using TEAMModelOS.SDK.Extension;
using TEAMModelOS.SDK.Helper.Common.StringHelper;
using System.Dynamic;
using Azure;
using TEAMModelOS.SDK.Models.Cosmos.Common;
using Azure.Messaging.ServiceBus;
using Microsoft.Extensions.Configuration;
using TEAMModelOS.Filter;
using Azure.Storage.Blobs.Models;
using Microsoft.AspNetCore.Authorization;

namespace TEAMModelOS.Controllers
{
    [ProducesResponseType(StatusCodes.Status200OK)]
    [ProducesResponseType(StatusCodes.Status400BadRequest)]
    
    [Route("school/course")]
    [ApiController]
    public class CourseController : ControllerBase
    {
        private AzureCosmosFactory _azureCosmos;
        private readonly DingDing _dingDing;
        private readonly Option _option;
        private readonly AzureServiceBusFactory _serviceBus;
        private readonly AzureStorageFactory _azureStorage;
        public IConfiguration _configuration { get; set; }
        public CourseController(AzureCosmosFactory azureCosmos, DingDing dingDing, IOptionsSnapshot<Option> option, AzureServiceBusFactory serviceBus, AzureStorageFactory azureStorage, IConfiguration configuration)
        {
            _azureCosmos = azureCosmos;
            _dingDing = dingDing;
            _option = option?.Value;
            _serviceBus = serviceBus;
            _configuration = configuration;
            _azureStorage = azureStorage;
        }


      
        
        /// <summary>
        /// 更新保存课程
        /// </summary>
        /// <param name="request"></param>
        /// <returns></returns>
        [ProducesDefaultResponseType]
        [HttpPost("upsert")]
        [AuthToken(Roles = "teacher,admin")]
        
#if !DEBUG
        [Authorize(Roles = "IES")]
        #endif

        public async Task<IActionResult> upsert(JsonElement request)
        {
            try
            {
                (string id, _, _, string school) = HttpContext.GetAuthTokenInfo();
                if (!request.TryGetProperty("option", out JsonElement option)) return BadRequest();
                if (!request.TryGetProperty("scope", out JsonElement scope)) return BadRequest();
                Course course = null; 
                var client = _azureCosmos.GetCosmosClient();
                if (request.TryGetProperty("course", out JsonElement _course)) {
                    course = _course.ToObject<Course>();

                    course.pk = typeof(Course).Name;
                    if (course.scope.Equals("school", StringComparison.OrdinalIgnoreCase))
                    {
                        course.school = school;
                        course.creatorId = id;
                        course.code = $"Course-{school}";
                    }
                    else
                    {
                        course.creatorId = id;
                        course.code = $"Course-{id}";
                    }
                }
                if (option.ToString().Equals("insert") && course != null)
                {
                    if ($"{scope}".Equals("school", StringComparison.OrdinalIgnoreCase))
                    {
                        var response = await client.GetContainer(Constant.TEAMModelOS, "School").ReadItemStreamAsync(course.id, new PartitionKey(course.code));
                        if (response.StatusCode==System.Net.HttpStatusCode.OK)
                        {
                            return Ok(new { error = ResponseCode.DATA_EXIST, V = "课程编码已经存在！" });
                        }
                        else
                        {
                            CourseChange courseChange = new CourseChange { id = course.id, code = course.code, name = course.name, scope = course.scope, school = course.school, creatorId = course.creatorId };
                            courseChange.addClass = course.schedule.Select(x => x.classId).ToList();
                            courseChange.addList = course.schedule.Select(x => x.stulist).ToList();
                            var messageBlob = new ServiceBusMessage(courseChange.ToJsonString()); ;
                            messageBlob.ApplicationProperties.Add("name", "Course");
                            var ActiveTask = _configuration.GetValue<string>("Azure:ServiceBus:ActiveTask");
                            await _serviceBus.GetServiceBusClient().SendMessageAsync(ActiveTask, messageBlob);
                            course = await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "School").CreateItemAsync(course, new PartitionKey(course.code));
                        }
                    }
                    else
                    {
                        var response = await client.GetContainer(Constant.TEAMModelOS, "Teacher").ReadItemStreamAsync(course.id, new PartitionKey(course.code));
                        if (response.StatusCode==System.Net.HttpStatusCode.OK)
                        {
                            return Ok(new { error = ResponseCode.DATA_EXIST, V = "课程编码已经存在！" });
                        }
                        else
                        {
                            CourseChange courseChange = new CourseChange { id = course.id, code = course.code, name = course.name, scope = course.scope, school = course.school, creatorId = course.creatorId };
                            courseChange.addClass = course.schedule.Select(x => x.classId).ToList();
                            courseChange.addList = course.schedule.Select(x => x.stulist).ToList();
                            var messageBlob = new ServiceBusMessage(courseChange.ToJsonString()); ;
                            messageBlob.ApplicationProperties.Add("name", "Course");
                            var ActiveTask = _configuration.GetValue<string>("Azure:ServiceBus:ActiveTask");
                            await _serviceBus.GetServiceBusClient().SendMessageAsync(ActiveTask, messageBlob);
                            course = await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "Teacher").CreateItemAsync(course, new PartitionKey(course.code));
                        }
                    }
                    return Ok(new { course });
                }
                
                else if ($"{option}".Equals("import") && $"{scope}".Equals("school", StringComparison.OrdinalIgnoreCase))
                {
                    if (!request.TryGetProperty("courses", out JsonElement _courses)) return BadRequest();
                    School schoolObj = await client.GetContainer(Constant.TEAMModelOS, Constant.School).ReadItemAsync<School>(school, new PartitionKey("Base"));
                    List<Course> courses = _courses.ToObject<List<Course>>();
                    if (courses.IsNotEmpty())
                    {
                        foreach (var cos in courses)
                        {

                            cos.pk = "Course";
                            cos.scope = "school";
                            cos.school = school;
                            cos.creatorId = id;
                            cos.code = $"Course-{school}";

                            if (cos.scope.Equals("school") && !string.IsNullOrWhiteSpace(cos.period?.id))
                            {
                                if (string.IsNullOrWhiteSpace(cos.subject?.id) && !string.IsNullOrWhiteSpace(cos.subject?.name))
                                {
                                    var sub = schoolObj.period.Where(z => z.id.Equals(cos.period.id)).FirstOrDefault()?.subjects.Where(s => s.name.Equals(cos.subject?.name));
                                    if (sub.Any())
                                    {
                                        cos.subject.id = sub.First().id;
                                    }
                                }
                                if (!string.IsNullOrWhiteSpace(cos.subject?.id))
                                {
                                    string sql = $"select top 1  value c from c where c.name ='{cos.name}' and c.period.id='{cos.period.id}' and c.subject.id='{cos.subject.id}'  ";
                                    Course courseDb = null;
                                    await foreach (var item in _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School)
                                        .GetItemQueryIteratorSql<Course>(queryText: sql, requestOptions: new QueryRequestOptions { PartitionKey = new PartitionKey(cos.code) }))
                                    {
                                        courseDb = item;
                                        break;
                                    }
                                    if (courseDb != null)
                                    {
                                        CourseChange courseChange = new CourseChange { id = courseDb.id, code = courseDb.code, name = courseDb.name, scope = courseDb.scope, school = courseDb.school, creatorId = courseDb.creatorId };
                                        cos.schedule.ForEach(x =>
                                        {
                                            if (!string.IsNullOrWhiteSpace(x.teacherId))
                                            {
                                                if (!string.IsNullOrWhiteSpace(x.stulist))
                                                {
                                                    var stulist = courseDb.schedule.FindAll(z => !string.IsNullOrWhiteSpace(z.stulist) && !string.IsNullOrWhiteSpace(z.teacherId) && z.stulist.Equals(x.stulist) && z.teacherId.Equals(x.teacherId));
                                                    if (!stulist.IsNotEmpty())
                                                    {
                                                        courseDb.schedule.Add(x);
                                                        courseChange.addList.Add(x.stulist);
                                                    }
                                                }
                                                if (!string.IsNullOrWhiteSpace(x.classId))
                                                {
                                                    var classId = courseDb.schedule.FindAll(z => !string.IsNullOrWhiteSpace(z.classId) && !string.IsNullOrWhiteSpace(z.teacherId) && z.classId.Equals(x.classId) && z.teacherId.Equals(x.teacherId));
                                                    if (!classId.IsNotEmpty())
                                                    {
                                                        courseDb.schedule.Add(x);
                                                        courseChange.addClass.Add(x.classId);
                                                    }
                                                }
                                            }
                                        });
                                        var messageBlob = new ServiceBusMessage(courseChange.ToJsonString()); ;
                                        messageBlob.ApplicationProperties.Add("name", "Course");
                                        var ActiveTask = _configuration.GetValue<string>("Azure:ServiceBus:ActiveTask");
                                        await _serviceBus.GetServiceBusClient().SendMessageAsync(ActiveTask, messageBlob);
                                        courseDb = await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "School").ReplaceItemAsync(courseDb, courseDb.id, new PartitionKey(courseDb.code));
                                    }
                                    else
                                    {
                                        cos.id = Guid.NewGuid().ToString();
                                        CourseChange courseChange = new CourseChange { id = cos.id, code = cos.code, name = cos.name, scope = cos.scope, school = cos.school, creatorId = cos.creatorId };
                                        courseChange.addClass = cos.schedule.Select(x => x.classId).ToList();
                                        courseChange.addList = cos.schedule.Select(x => x.stulist).ToList();
                                        var messageBlob = new ServiceBusMessage(courseChange.ToJsonString()); ;
                                        messageBlob.ApplicationProperties.Add("name", "Course");
                                        var ActiveTask = _configuration.GetValue<string>("Azure:ServiceBus:ActiveTask");
                                        await _serviceBus.GetServiceBusClient().SendMessageAsync(ActiveTask, messageBlob);
                                        await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "School").CreateItemAsync(cos, new PartitionKey(cos.code));
                                    }
                                }


                            }
                        }
                        return Ok();
                    }
                    else
                    {
                        return BadRequest();
                    }
                }
                else
                {
                    if (course != null)
                    {
                        if (scope.ToString().Equals("school", StringComparison.OrdinalIgnoreCase))
                        {

                            Course odlCourse = await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "School").ReadItemAsync<Course>(course.id, new PartitionKey(course.code));
                            CourseChange courseChange = new CourseChange { id = course.id, code = course.code, name = course.name, scope = course.scope, school = course.school, creatorId = course.creatorId };
                            var oldCls = odlCourse.schedule.Select(x => x.classId).ToList();
                            var oldLst = odlCourse.schedule.Select(x => x.stulist).ToList();
                            var newCls = course.schedule.Select(x => x.classId).ToList();
                            var newLst = course.schedule.Select(x => x.stulist).ToList();
                            List<string> addCls = new List<string>();
                            List<string> addLst = new List<string>();
                            List<string> delCls = new List<string>();
                            List<string> delLst = new List<string>();
                            oldCls.ForEach(x =>
                            {
                                if (!newCls.Contains(x))
                                {
                                    delCls.Add(x);
                                }
                            });
                            newCls.ForEach(x =>
                            {
                                if (!oldCls.Contains(x))
                                {
                                    addCls.Add(x);
                                }
                            });
                            oldLst.ForEach(x =>
                            {
                                if (!newLst.Contains(x))
                                {
                                    delLst.Add(x);
                                }
                            });
                            newLst.ForEach(x =>
                            {
                                if (!oldLst.Contains(x))
                                {
                                    addLst.Add(x);
                                }
                            });
                            courseChange.addClass = addCls;
                            courseChange.addList = addLst;
                            courseChange.delClass = delCls;
                            courseChange.delList = delLst;
                            course = await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "School").ReplaceItemAsync(course, course.id, new PartitionKey(course.code));
                            var messageBlob = new ServiceBusMessage(courseChange.ToJsonString()); ;
                            messageBlob.ApplicationProperties.Add("name", "Course");
                            var ActiveTask = _configuration.GetValue<string>("Azure:ServiceBus:ActiveTask");
                            await _serviceBus.GetServiceBusClient().SendMessageAsync(ActiveTask, messageBlob);
                        }
                        else
                        {
                            Course odlCourse = await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "Teacher").ReadItemAsync<Course>(course.id, new PartitionKey(course.code));
                            CourseChange courseChange = new CourseChange { id = course.id, code = course.code, name = course.name, scope = course.scope, creatorId = course.creatorId };
                            var oldCls = odlCourse.schedule.Select(x => x.classId).ToList();
                            var oldLst = odlCourse.schedule.Select(x => x.stulist).ToList();
                            var newCls = course.schedule.Select(x => x.classId).ToList();
                            var newLst = course.schedule.Select(x => x.stulist).ToList();
                            List<string> addCls = new List<string>();
                            List<string> addLst = new List<string>();
                            List<string> delCls = new List<string>();
                            List<string> delLst = new List<string>();
                            oldCls.ForEach(x =>
                            {
                                if (!newCls.Contains(x))
                                {
                                    delCls.Add(x);
                                }
                            });
                            newCls.ForEach(x =>
                            {
                                if (!oldCls.Contains(x))
                                {
                                    addCls.Add(x);
                                }
                            });
                            oldLst.ForEach(x =>
                            {
                                if (!newLst.Contains(x))
                                {
                                    delLst.Add(x);
                                }
                            });
                            newLst.ForEach(x =>
                            {
                                if (!oldLst.Contains(x))
                                {
                                    addLst.Add(x);
                                }
                            });
                            courseChange.addClass = addCls;
                            courseChange.addList = addLst;
                            courseChange.delClass = delCls;
                            courseChange.delList = delLst;
                            course = await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "Teacher").ReplaceItemAsync(course, course.id, new PartitionKey(course.code));
                            var messageBlob = new ServiceBusMessage(courseChange.ToJsonString()); ;
                            messageBlob.ApplicationProperties.Add("name", "Course");
                            var ActiveTask = _configuration.GetValue<string>("Azure:ServiceBus:ActiveTask");
                            await _serviceBus.GetServiceBusClient().SendMessageAsync(ActiveTask, messageBlob);
                        }
                    }
                    return Ok(new { course });
                }
               
            }
            catch (Exception ex)
            {
                await _dingDing.SendBotMsg($"OS，{_option.Location}，course/upsert()\n{ex.Message}\n{ex.StackTrace}\n{request.ToJsonString()}", GroupNames.醍摩豆服務運維群組);
                return BadRequest();
            }

        }


        [ProducesDefaultResponseType]
        [HttpPost("check")]
        [AuthToken(Roles = "teacher,admin,student")]

#if !DEBUG
        [Authorize(Roles = "IES")]
#endif
        public async Task<IActionResult> check(JsonElement json)
        {
            try
            {
                if (!json.TryGetProperty("tId", out JsonElement tId)) return BadRequest();
                if (!json.TryGetProperty("timeId", out JsonElement timeId)) return BadRequest();
                if (!json.TryGetProperty("code", out JsonElement code)) return BadRequest();
                if (!json.TryGetProperty("week", out JsonElement week)) return BadRequest();
                if (!json.TryGetProperty("cId", out JsonElement cId)) return BadRequest();
                var client = _azureCosmos.GetCosmosClient();
                var query = $"SELECT A0.room,A0.classId,A0.teacherId,A0.stulist,A0.time FROM c join A0 in c.schedule join A1 in A0.time where A0.teacherId = '{tId}'and A1.id = '{timeId}' and A1.week = '{week}' ";
                List<Schedule> teachers = new();
                await foreach (var item in client.GetContainer(Constant.TEAMModelOS, "School").GetItemQueryStreamIteratorSql(queryText: query, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Course-{code}") }))
                {
                    using var jsonCheck = await JsonDocument.ParseAsync(item.Content);
                    if (jsonCheck.RootElement.TryGetProperty("_count", out JsonElement count) && count.GetUInt16() > 0)
                    {
                        foreach (var obj in jsonCheck.RootElement.GetProperty("Documents").EnumerateArray())
                        {
                            teachers.Add(obj.ToObject<Schedule>());
                        }
                    }
                }
                if (teachers.Count > 0)
                {
                    return Ok(new { msg = "该教师已有课程安排", code = 1 });
                }
                else
                {
                    var queryClass = $"SELECT A0.room,A0.classId,A0.teacherId,A0.stulist,A0.time FROM c join A0 in c.schedule join A1 in A0.time where A1.id = '{timeId}' and A1.week = '{week}' and (A0.classId = '{cId}' or A0.stulist = '{cId}')";
                    List<Schedule> courses = new();
                    await foreach (var item in client.GetContainer(Constant.TEAMModelOS, "School").GetItemQueryStreamIteratorSql(queryText: queryClass, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Course-{code}") }))
                    {
                        using var jsonCheck = await JsonDocument.ParseAsync(item.Content);
                        if (jsonCheck.RootElement.TryGetProperty("_count", out JsonElement count) && count.GetUInt16() > 0)
                        {
                            foreach (var obj in jsonCheck.RootElement.GetProperty("Documents").EnumerateArray())
                            {
                                courses.Add(obj.ToObject<Schedule>());
                            }
                        }
                    }
                    if (courses.Count > 0)
                    {
                        return Ok(new { msg = "该名单已有课程安排", code = 2 });
                    }
                }
                return Ok(new { code = 0 });
            }
            catch (Exception ex)
            {
                await _dingDing.SendBotMsg($"OS，{_option.Location}，course/check()\n{ex.Message}\n{ex.StackTrace}\n", GroupNames.醍摩豆服務運維群組);
                return BadRequest();
            }
        }
        
        /// <summary>
        /// 查询课程
        /// </summary>
        /// <param name="request"></param>
        /// <returns></returns>
        [ProducesDefaultResponseType]
        //[AuthToken(Roles = "teacher")]
        [HttpPost("find")]
        [AuthToken(Roles = "teacher,admin,student")]

#if !DEBUG
        [Authorize(Roles = "IES")]
#endif
        public async Task<IActionResult> Find(JsonElement request)
        {
            if (!request.TryGetProperty("code", out JsonElement code)) return BadRequest();
            if (!request.TryGetProperty("scope", out JsonElement scope)) return BadRequest();
            request.TryGetProperty("period", out JsonElement _period) ;
            try
            {
                var client = _azureCosmos.GetCosmosClient();
                List<object> courses = new List<object>();

                /*string continuationToken = string.Empty;
                string token = default;
                //是否需要进行分页查询，默认不分页
                //bool iscontinuation = false;
                if (request.TryGetProperty("token", out JsonElement token_1))
                {
                    token = token_1.GetString();
                    //iscontinuation = true;
                };
                //默认不指定返回大小
                int? topcout = null;
                if (request.TryGetProperty("count", out JsonElement jcount))
                {
                    if (!jcount.ValueKind.Equals(JsonValueKind.Undefined) && !jcount.ValueKind.Equals(JsonValueKind.Null) && jcount.TryGetInt32(out int data))
                    {
                        topcout = data;
                    }
                }*/
                var query = $"select c.code,c.id,c.no,c.name,c.period,c.subject,c.scope from c";
                if (scope.ToString().Equals("school", StringComparison.OrdinalIgnoreCase))
                {
                    string sql = query;
                    if (!string.IsNullOrWhiteSpace($"{_period}")) {
                        sql = $"{sql} where c.period.id ='{_period}'";
                    }

                    await foreach (var item in client.GetContainer(Constant.TEAMModelOS, "School").GetItemQueryStreamIteratorSql(queryText: sql, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Course-{code.GetString()}") }))
                    {
                        //continuationToken = item.GetContinuationToken();
                        using var json = await JsonDocument.ParseAsync(item.Content);
                        if (json.RootElement.TryGetProperty("_count", out JsonElement count) && count.GetUInt16() > 0)
                        {
                            foreach (var obj in json.RootElement.GetProperty("Documents").EnumerateArray())
                            {
                                courses.Add(obj.ToObject<object>());
                            }
                        }
                        //break;
                    }
                }
                else
                {

                    await foreach (var item in client.GetContainer(Constant.TEAMModelOS, "Teacher").GetItemQueryStreamIteratorSql(queryText: query, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Course-{code.GetString()}") }))
                    {
                        //continuationToken = item.GetContinuationToken();
                        using var json = await JsonDocument.ParseAsync(item.Content);
                        if (json.RootElement.TryGetProperty("_count", out JsonElement count) && count.GetUInt16() > 0)
                        {
                            foreach (var obj in json.RootElement.GetProperty("Documents").EnumerateArray())
                            {
                                courses.Add(obj.ToObject<object>());
                            }
                        }
                        //break;
                    }
                    if (request.TryGetProperty("schoolId", out JsonElement schoolId))
                    {
                        var querySchool = $"select distinct c.code,c.id,c.no,c.name,c.period,c.subject,c.scope from c join A0 in c.schedule where A0.teacherId = '{code}'";
                         
                        if (!string.IsNullOrWhiteSpace($"{_period}"))
                        {
                            querySchool = $"{querySchool}  and  c.period.id ='{_period}'";
                        }
                        await foreach (var item in client.GetContainer(Constant.TEAMModelOS, "School").GetItemQueryStreamIteratorSql(queryText: querySchool, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Course-{schoolId.GetString()}") }))
                        {
                            //continuationToken = item.GetContinuationToken();
                            using var json = await JsonDocument.ParseAsync(item.Content);
                            if (json.RootElement.TryGetProperty("_count", out JsonElement count) && count.GetUInt16() > 0)
                            {
                                foreach (var obj in json.RootElement.GetProperty("Documents").EnumerateArray())
                                {
                                    courses.Add(obj.ToObject<object>());
                                }
                            }
                            //break;
                        }
                    };
                }
                return Ok(new { courses, courses.Count });
            }
            catch (Exception ex)
            {
                await _dingDing.SendBotMsg($"OS，{_option.Location}，course/find()\n{ex.Message}\n{ex.StackTrace}\n", GroupNames.醍摩豆服務運維群組);
                return BadRequest();
            }


            /* List<Course> data = new List<Course>();
             if (StringHelper.getKeyCount(request) > 0) {
                 data = await _azureCosmos.FindByDict<Course>(request);
             }
             return builder.Data(data).Extend(new Dictionary<string, object> { { "count", data.Count } }).build();*/
        }


        /// <summary>
        /// 查询课程
        /// </summary>
        /// <param name="request"></param>
        /// <returns></returns>
        [ProducesDefaultResponseType]
        //[AuthToken(Roles = "teacher")]
        [HttpPost("find-all-by-teacher")]
        [AuthToken(Roles = "teacher,admin,student")]

#if !DEBUG
        [Authorize(Roles = "IES")]
#endif
        public async Task<IActionResult> FindByTeacher(JsonElement request)
        {
            if (!request.TryGetProperty("code", out JsonElement code)) return BadRequest();
            //if (!request.TryGetProperty("tId", out JsonElement tId)) return BadRequest();
            //if (!request.TryGetProperty("scope", out JsonElement scope)) return BadRequest();

            try
            {
                var client = _azureCosmos.GetCosmosClient();
                List<object> courses = new List<object>();
                List<(string id, string name, string scope)> teacherCourse = new();
                List<(string id, string name, string scope)> tcCourse = new();
                List<(string id, string name, string scope, List<(string id, string name, string type)> stuName)> ps = new();
                var query = $"select c.id,c.name,c.scope from c";

                await foreach (var item in client.GetContainer(Constant.TEAMModelOS, "Teacher").GetItemQueryStreamIteratorSql(queryText: query, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Course-{code.GetString()}") }))
                {
                    using var json = await JsonDocument.ParseAsync(item.Content);
                    if (json.RootElement.TryGetProperty("_count", out JsonElement count) && count.GetUInt16() > 0)
                    {
                        var accounts = json.RootElement.GetProperty("Documents").EnumerateArray();
                        while (accounts.MoveNext())
                        {
                            JsonElement account = accounts.Current;
                            teacherCourse.Add((account.GetProperty("id").GetString(), account.GetProperty("name").GetString(), account.GetProperty("scope").GetString()));
                        }
                    }
                }
                foreach ((string s, string n, string sc) in teacherCourse)
                {
                    List<(string id, string name, string type)> sName = new();
                    List<Schedule> schedules = new List<Schedule>();
                    var querySc = $"SELECT A0.room,A0.classId,A0.teacherId,A0.stulist,A0.time FROM c join A0 in c.schedule where c.id = '{s}'";
                    await foreach (var item in client.GetContainer(Constant.TEAMModelOS, "Teacher").GetItemQueryIteratorSql<Schedule>(queryText: querySc, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Course-{code.GetString()}") }))
                    {
                        schedules.Add(item);
                    }
                    if (schedules.Count > 0)
                    {
                        var queryInfo = $"select c.id ,c.name from c where c.id in ({string.Join(",", schedules.Select(o => $"'{o.stulist}'"))})";
                        await foreach (var item in client.GetContainer(Constant.TEAMModelOS, "Teacher").GetItemQueryIteratorSql<GroupList>(queryText: queryInfo, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"GroupList") }))
                        {
                            sName.Add((item.id, item.name, "stuList"));
                        }
                    }
                    ps.Add((s, n, sc, sName));
                }
                if (request.TryGetProperty("schoolId", out JsonElement schoolId))
                {
                    var querySchool = $"select distinct c.code,c.id,c.no,c.name,c.scope from c join A0 in c.schedule where A0.teacherId = '{code}'";
                    await foreach (var item in client.GetContainer(Constant.TEAMModelOS, "School").GetItemQueryStreamIteratorSql(queryText: querySchool, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Course-{schoolId.GetString()}") }))
                    {
                        using var json = await JsonDocument.ParseAsync(item.Content);
                        if (json.RootElement.TryGetProperty("_count", out JsonElement count) && count.GetUInt16() > 0)
                        {
                            var accounts = json.RootElement.GetProperty("Documents").EnumerateArray();
                            while (accounts.MoveNext())
                            {
                                JsonElement account = accounts.Current;
                                tcCourse.Add((account.GetProperty("id").GetString(), account.GetProperty("name").GetString(), account.GetProperty("scope").GetString()));
                            }
                        }
                    }
                    foreach ((string s, string n, string sc) in tcCourse)
                    {
                        List<Schedule> schedules = new List<Schedule>();
                        var querySc = $"SELECT A0.room,A0.classId,A0.teacherId,A0.stulist,A0.time FROM c join A0 in c.schedule where c.id = '{s}' and A0.teacherId = '{code}'";
                        await foreach (var item in client.GetContainer(Constant.TEAMModelOS, "School").GetItemQueryIteratorSql<Schedule>(queryText: querySc, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Course-{schoolId.GetString()}") }))
                        {
                            schedules.Add(item);
                        }
                        List<(string id, string name, string type)> sName = new();
                        if (schedules.Count > 0)
                        {
                            var queryInfo = $"select c.id ,c.name from c where c.id in ({string.Join(",", schedules.Select(o => $"'{o.stulist}'"))})";
                            await foreach (var item in client.GetContainer(Constant.TEAMModelOS, "School").GetItemQueryIteratorSql<GroupList>(queryText: queryInfo, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"GroupList-{schoolId.GetString()}") }))
                            {
                                sName.Add((item.id, item.name, "stuList"));
                            }
                            var queryClass = $"select c.id ,c.name from c where c.id in ({string.Join(",", schedules.Select(o => $"'{o.classId}'"))})";
                            await foreach (var item in client.GetContainer(Constant.TEAMModelOS, "School").GetItemQueryStreamIteratorSql(queryText: queryClass, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Class-{schoolId.GetString()}") }))
                            {
                                using var json = await JsonDocument.ParseAsync(item.Content);
                                if (json.RootElement.TryGetProperty("_count", out JsonElement count) && count.GetUInt16() > 0)
                                {
                                    var accounts = json.RootElement.GetProperty("Documents").EnumerateArray();
                                    while (accounts.MoveNext())
                                    {
                                        JsonElement account = accounts.Current;
                                        sName.Add((account.GetProperty("id").GetString(), account.GetProperty("name").GetString(), "class"));
                                    }
                                }
                            }
                        }
                        ps.Add((s, n, sc, sName));
                    }
                }



                var obj = ps.Select(p => new
                {
                    p.id,
                    p.name,
                    p.scope,
                    classes = p.stuName.Select(s => new { s.id, s.name, s.type })
                });


                return Ok(new { obj });
            }
            catch (Exception ex)
            {
                await _dingDing.SendBotMsg($"OS，{_option.Location}，course/find-all-by-teacher()\n{ex.Message}\n{ex.StackTrace}\n", GroupNames.醍摩豆服務運維群組);
                return BadRequest();
            }
        }

        /// <summary>
        /// 删除名单同时从关联的课程移除名单 ，只针对个人名单 个人课程、
        /// </summary>
        /// <param name="request"></param>
        /// <returns></returns>
        [ProducesDefaultResponseType]
        //[AuthToken(Roles = "teacher")]
        [HttpPost("del-stulist-rmv-rel-course")]
        [AuthToken(Roles = "teacher,admin")]

#if !DEBUG
        [Authorize(Roles = "IES")]
#endif
        public async Task<IActionResult> DelStulistRmvRelCourse(JsonElement request) {
            //教师编码
            if (!request.TryGetProperty("code", out JsonElement code)) return BadRequest();
            //课程id 
            if (!request.TryGetProperty("id", out JsonElement id)) return BadRequest();
            //名单id 
            if (!request.TryGetProperty("stulist", out JsonElement stulist)) return BadRequest();
            try {
                var client = _azureCosmos.GetCosmosClient();
                List<Course> courses = new List<Course>();
                Course cs = await client.GetContainer(Constant.TEAMModelOS, Constant.Teacher).ReadItemAsync<Course>($"{id}", new PartitionKey($"Course-{code}"));
                courses.Add(cs);
                string sql = $"SELECT distinct value(c)  FROM c  join s in c.schedule where c.pk='Course' and s.stulist='{stulist}' and c.id<>'{cs.id}' ";
                await foreach (var item in client.GetContainer(Constant.TEAMModelOS, "Teacher").GetItemQueryIteratorSql<Course>(queryText: sql, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Course-{code}") }))
                {
                    courses.Add(item);
                }
                List<Task<ItemResponse<Course>>> responses = new List<Task<ItemResponse<Course>>>();
                courses.ForEach(course => {
                    course.schedule.RemoveAll(x => string.IsNullOrWhiteSpace(x.classId) && !string.IsNullOrWhiteSpace(x.stulist) && x.stulist.Equals($"{stulist}"));
                    //如果两个名单都存在值，则把stulist 置为null.
                    course.schedule.Where(x => !string.IsNullOrWhiteSpace(x.classId) && !string.IsNullOrWhiteSpace(x.stulist) && x.stulist.Equals($"{stulist}")).Select(m => m.stulist = null);
                    responses.Add(client.GetContainer(Constant.TEAMModelOS, Constant.Teacher).ReplaceItemAsync(course, course.id, new PartitionKey(course.code)));
                });
                await  Task.WhenAll(responses);

                try
                {
                    await GroupListService.DeleteGrouplistEvent($"{stulist}", "GroupList", Constant.Teacher, client, _configuration, _serviceBus,"web");
                }
                catch (Exception ex) {  }
               
            } catch (Exception ex) { 
            }
            return Ok();
        }

        /// <summary>
        /// 查询课程详情
        /// </summary>
        /// <param name="request"></param>
        /// <returns></returns>
        [ProducesDefaultResponseType]
        //[AuthToken(Roles = "teacher")]
        [HttpPost("find-summary")]
        [AuthToken(Roles = "teacher,admin,student")]

#if !DEBUG
        [Authorize(Roles = "IES")]
#endif
        public async Task<IActionResult> FindSummary(JsonElement request)
        {

            if (!request.TryGetProperty("code", out JsonElement code)) return BadRequest();
            if (!request.TryGetProperty("scope", out JsonElement scope)) return BadRequest();
            if (!request.TryGetProperty("id", out JsonElement id)) return BadRequest();
            try
            {
                var client = _azureCosmos.GetCosmosClient();
                List<object> courses = new List<object>();
                List<Course> courseList = new List<Course>();
                var query = $"select value(c) from c where c.id = '{id}'";
                //List<(string id, string code, string name)> listCourse = new List<(string id, string code, string name)>();
                if (scope.ToString().Equals("school", StringComparison.OrdinalIgnoreCase))
                {
                    await foreach (var item in client.GetContainer(Constant.TEAMModelOS, "School").GetItemQueryIteratorSql<Course>(queryText: query, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Course-{code}") }))
                    {
                        courseList.Add(item);
                    }
                }
                else
                {
                    await foreach (var item in client.GetContainer(Constant.TEAMModelOS, "Teacher").GetItemQueryIteratorSql<Course>(queryText: query, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Course-{code}") }))
                    {
                        courseList.Add(item);
                    }
                }
                List<IdCode> privateCourseStulist = new List<IdCode>();
                //检查个人课程的个人名单关联情况，以便于删除管理名单。
                if (!$"{scope}".Equals("school")) {
                    var stulists =courseList.SelectMany(x => x.schedule).Select(z => z.stulist).Where(y => !string.IsNullOrWhiteSpace(y));
                    if (stulists.Any()) {
                        string sql = $"SELECT distinct c.id,s.stulist as code  FROM c  join s in c.schedule where c.pk='Course' and s.stulist in ({string.Join(",", stulists.Select(x=>$"'{x}'"))}) ";
                        await foreach (var item in client.GetContainer(Constant.TEAMModelOS, "Teacher").GetItemQueryIteratorSql<IdCode>(queryText: sql, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Course-{code}") }))
                        {
                            privateCourseStulist.Add(item);
                        }
                    }
                }
                foreach (Course course in courseList)
                {
                    dynamic courseExtobj = new ExpandoObject();
                    courseExtobj.id = course.id;
                    courseExtobj.name = course.name;
                    courseExtobj.id = course.id;
                    courseExtobj.subject = course.subject;
                    courseExtobj.desc = course.desc;
                    courseExtobj.period = course.period;
                    courseExtobj.scope = course.scope;
                    courseExtobj.no = course.no;
                    courseExtobj.code = course.code;
                    List<object> scheList = new List<object>();
                    foreach (Schedule schedule in course.schedule)
                    {
                        dynamic scheduleExtobj = new ExpandoObject();
                        scheduleExtobj.classId = schedule.classId;
                        scheduleExtobj.teacherId = schedule.teacherId;
                        if (!string.IsNullOrEmpty(schedule.teacherId))
                        {
                            var response = await client.GetContainer(Constant.TEAMModelOS, "Teacher").ReadItemStreamAsync(schedule.teacherId, new PartitionKey("Base"));
                            if (response.StatusCode==System.Net.HttpStatusCode.OK)
                            {
                                using var json = await JsonDocument.ParseAsync(response.Content);
                                Teacher teacher = json.ToObject<Teacher>();
                                scheduleExtobj.teacherName = teacher.name;
                            }
                        }
                        if (!$"{scope}".Equals("school")) {
                            if (!string.IsNullOrWhiteSpace(schedule.stulist))
                            {
                                var list = privateCourseStulist.FindAll(x => x.code.Equals(schedule.stulist));
                                if (list.Any())
                                {
                                    scheduleExtobj.stulistRel = list.Count;
                                }
                                else { scheduleExtobj.stulistRel = 1; }
                            }
                            else { scheduleExtobj.stulistRel = 1; }
                        }//stulistRel  只针对个人课程，学校课程 -1 .
                        else { scheduleExtobj.stulistRel =-1  ; }
                        scheduleExtobj.stulist = schedule.stulist;
                        scheduleExtobj.time = schedule.time;
                        scheduleExtobj.room = schedule.room;
                        scheList.Add(scheduleExtobj);
                    }
                    courseExtobj.schedule = scheList;
                    courses.Add(courseExtobj);
                }

                return Ok(new { courses, courses.Count });
            }
            catch (Exception ex)
            {
                await _dingDing.SendBotMsg($"IES,{_option.Location}，course/find-summary()\n{ex.Message}\n{ex.StackTrace}\n", GroupNames.醍摩豆服務運維群組);
                return BadRequest();
            }


            /* List<Course> data = new List<Course>();
             if (StringHelper.getKeyCount(request) > 0) {
                 data = await _azureCosmos.FindByDict<Course>(request);
             }
             return builder.Data(data).Extend(new Dictionary<string, object> { { "count", data.Count } }).build();*/
        }
        /// <summary>
        /// 删除课程
        /// </summary>
        /// <param name="request"></param>
        /// <returns></returns>
        [ProducesDefaultResponseType]
        //[AuthToken(Roles = "teacher")]
        [HttpPost("delete")]
        [AuthToken(Roles = "teacher,admin")]

#if !DEBUG
        [Authorize(Roles = "IES")]
#endif
        public async Task<IActionResult> Delete(JsonElement request)
        {
            try
            {
                if (!request.TryGetProperty("id", out JsonElement id)) return BadRequest();
                if (!request.TryGetProperty("code", out JsonElement code)) return BadRequest();
                if (!request.TryGetProperty("scope", out JsonElement scope)) return BadRequest();
              
                var client = _azureCosmos.GetCosmosClient();
                if (scope.ToString().Equals("school"))
                {
                    Course course = await client.GetContainer(Constant.TEAMModelOS, "School").ReadItemAsync<Course>(id.ToString(), new PartitionKey($"Course-{code}"));
                    CourseChange courseChange = new CourseChange { id = course.id, code = course.code, name = course.name, scope = course.scope, school = course.school, creatorId = course.creatorId };
                    courseChange.delClass = course.schedule.Where(z => !string.IsNullOrWhiteSpace(z.classId)).Select(x => x.classId).ToList();
                    courseChange.delList = course.schedule.Where(z => !string.IsNullOrWhiteSpace(z.stulist)).Select(x => x.stulist).ToList();
                    var messageBlob = new ServiceBusMessage(courseChange.ToJsonString()); ;
                    messageBlob.ApplicationProperties.Add("name", "Course");
                    var ActiveTask = _configuration.GetValue<string>("Azure:ServiceBus:ActiveTask");
                    await _serviceBus.GetServiceBusClient().SendMessageAsync(ActiveTask, messageBlob);
                    await client.GetContainer(Constant.TEAMModelOS, "School").DeleteItemStreamAsync(id.ToString(), new PartitionKey($"Course-{code}"));
                }
                else
                {
                    Course course = await client.GetContainer(Constant.TEAMModelOS, "Teacher").ReadItemAsync<Course>(id.ToString(), new PartitionKey($"Course-{code}"));
                    CourseChange courseChange = new CourseChange { id = course.id, code = course.code, name = course.name, scope = course.scope, school = course.school, creatorId = course.creatorId };
                    courseChange.delClass = course.schedule.Where(z => !string.IsNullOrWhiteSpace(z.classId)).Select(x => x.classId).ToList();
                    courseChange.delList = course.schedule.Where(z => !string.IsNullOrWhiteSpace(z.stulist)).Select(x => x.stulist).ToList();
                    if (courseChange.delClass.Any() || courseChange.delList.Any()) {
                        var messageBlob = new ServiceBusMessage(courseChange.ToJsonString()); ;
                        messageBlob.ApplicationProperties.Add("name", "Course");
                        var ActiveTask = _configuration.GetValue<string>("Azure:ServiceBus:ActiveTask");
                        await _serviceBus.GetServiceBusClient().SendMessageAsync(ActiveTask, messageBlob);
                    }
                    await client.GetContainer(Constant.TEAMModelOS, "Teacher").DeleteItemStreamAsync(id.ToString(), new PartitionKey($"Course-{code}"));

                    request.TryGetProperty("deleteStulist", out JsonElement deleteStulist);

                    List<Course> courses = new List<Course>();
                    //先检查名单有没有多个关联
                    if (courseChange.delList.Any()) {
                        string sql = $"SELECT distinct value(c)   FROM c  join s in c.schedule where c.pk='Course' and s.stulist in ({string.Join(",", courseChange.delList.Select(x => $"'{x}'"))})   ";
                        await foreach (var item in client.GetContainer(Constant.TEAMModelOS, "Teacher").GetItemQueryIteratorSql<Course>(queryText: sql, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Course-{code}") }))
                        {
                            courses.Add(item);
                        }
                    }
                    if (deleteStulist.ValueKind.Equals(JsonValueKind.Number) && $"{deleteStulist}".Equals("1") && courseChange.delList.Any())
                    {
                        List<Task<ItemResponse<Course>>> responses = new List<Task<ItemResponse<Course>>>();
                        foreach(var courseRel in courses)
                        {

                            CourseChange courseChangeRel = new CourseChange { id = courseRel.id, code = courseRel.code, name = courseRel.name, scope = courseRel.scope, school = courseRel.school, creatorId = courseRel.creatorId };
                            courseChangeRel.delList = courseRel.schedule.Where(z => !string.IsNullOrWhiteSpace(z.stulist) && courseChange.delList.Contains(z.stulist)).Select(x => x.stulist).ToList();
                            var messageBlobRel = new ServiceBusMessage(courseChangeRel.ToJsonString()); ;
                            messageBlobRel.ApplicationProperties.Add("name", "Course");
                            var ActiveTaskRel = _configuration.GetValue<string>("Azure:ServiceBus:ActiveTask");
                            await _serviceBus.GetServiceBusClient().SendMessageAsync(ActiveTaskRel, messageBlobRel);
                            courseRel.schedule.RemoveAll(x => string.IsNullOrWhiteSpace(x.classId) && !string.IsNullOrWhiteSpace(x.stulist) && courseChange.delList.Contains(x.stulist));
                            //如果两个名单都存在值，则把stulist 置为null.
                            courseRel.schedule.Where(x => !string.IsNullOrWhiteSpace(x.classId) && !string.IsNullOrWhiteSpace(x.stulist) && courseChange.delList.Contains(x.stulist)).Select(m=>m.stulist=null);
                            responses.Add(client.GetContainer(Constant.TEAMModelOS, Constant.Teacher).ReplaceItemAsync(courseRel, courseRel.id, new PartitionKey(courseRel.code)));
                        };
                        await Task.WhenAll(responses);
                        //deleteStulist==1 强制删除关联的名单，则需要处理当前课程的所有delList
                        foreach (var listid in courseChange.delList) {
                            try
                            {
                                await GroupListService.DeleteGrouplistEvent(listid, "GroupList", Constant.Teacher, client, _configuration, _serviceBus, "web");
                            }
                            catch (Exception ex) { continue; }
                        }
                    }
                    else {
                        //deleteStulist !=1 没有强制移除关联课程的名单时， 删除课程时，自动删除只有当前课程唯一对应的名单。
                        var exlists = courseChange.delList.Except(courses.SelectMany(x => x.schedule).Select(y => y.stulist));
                        if (exlists.Any()) {
                            foreach (var listid in exlists) {
                                try {
                                    await  GroupListService.DeleteGrouplistEvent(listid, "GroupList", Constant.Teacher, client, _configuration, _serviceBus, "web");
                                } catch (Exception ex) { continue; }
                            }
                        }
                    }
                }
                return Ok(new { id });
            }
            catch (Exception ex)
            {
                await _dingDing.SendBotMsg($"CN，{_option.Location}，course/delete()\n{ex.Message}\n{ex.StackTrace}", GroupNames.醍摩豆服務運維群組);
                return BadRequest();
            }

        }
        /// <summary>
        /// 删除课程
        /// </summary>
        /// <param name="request"></param>
        /// <returns></returns>
        //[ProducesDefaultResponseType]
        //[AuthToken(Roles = "teacher")]
        //[HttpPost("delete-all")]//不要了

       // [Authorize(Roles = "IES")]
        public async Task<IActionResult> DeleteAll(BatchOption request)
        {
            try
            {
                /*                if (!request.TryGetProperty("id", out JsonElement id)) return BadRequest();
                                if (!request.TryGetProperty("code", out JsonElement code)) return BadRequest();*/
                var client = _azureCosmos.GetCosmosClient();
                if (request == null) return BadRequest();

                string school_code = request.code;

                if (request.scope.Equals("school", StringComparison.OrdinalIgnoreCase))
                {
                    var  res = await client.GetContainer(Constant.TEAMModelOS, "School").DeleteItemsStreamAsync(request.ids, $"Course-{school_code}");
                }
                else
                {
                   var res = await client.GetContainer(Constant.TEAMModelOS, "Teacher").DeleteItemsStreamAsync(request.ids, $"Course-{school_code}");
                }

                return Ok(new { ids = request.ids });
            }
            catch (Exception ex)
            {
                await _dingDing.SendBotMsg($"CN，{_option.Location}，course/delete()\n{ex.Message}\n{ex.StackTrace}", GroupNames.醍摩豆服務運維群組);
                return BadRequest();
            }
        }

        /// <summary>
        /// 更新保存排课管理
        /// </summary>
        /// <param name="request"></param>
        /// <returns></returns>
        //[ProducesDefaultResponseType]
        ////[AuthToken(Roles = "Teacher")]
        //[HttpPost("upsert-management")]
        //public async Task<IActionResult> upsertCourseManagement(CourseManagement request)
        //{
        //    try
        //    {
        //        CourseManagement course = new CourseManagement();
        //        //course = room.ToObject<CourseManagement>();
        //        var client = _azureCosmos.GetCosmosClient();
        //        string code = request.code;
        //        request.code = "CourseManagement-" + request.code;
        //        /*                if (request.scope.Equals) { 

        //                        }*/
        //        var response = await client.GetContainer(Constant.TEAMModelOS, "School").ReadItemStreamAsync(request.id, new PartitionKey($"CourseManagement-{code}"));
        //        if (response.StatusCode==System.Net.HttpStatusCode.OK)
        //        {
        //            course = await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "School").ReplaceItemAsync(request, request.id, new PartitionKey($"CourseManagement-{code}"));
        //        }
        //        else
        //        {
        //            course = await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "School").CreateItemAsync(request, new PartitionKey($"CourseManagement-{code}"));
        //        }
        //        return Ok(new { course });
        //    }
        //    catch (Exception ex)
        //    {
        //        await _dingDing.SendBotMsg($"CoreAPI2，{_option.Location}，management/upsert()\n{ex.Message}\n{ex.StackTrace}", GroupNames.醍摩豆服務運維群組);
        //        return BadRequest();
        //    }

        //}

        /// <summary>
        /// 查询排课管理
        /// </summary>
        /// <param name="request"></param>
        /// <returns></returns>
        //[ProducesDefaultResponseType]
        ////[AuthToken(Roles = "Teacher")]
        //[HttpPost("find-management")]
        //public async Task<IActionResult> FindManagement(JsonElement request)
        //{
        //    //if (!request.TryGetProperty("id", out JsonElement id)) return BadRequest();
        //    if (!request.TryGetProperty("code", out JsonElement code)) return BadRequest();
        //    var client = _azureCosmos.GetCosmosClient();
        //    List<object> courses = new List<object>();
        //    StringBuilder sql = new StringBuilder();
        //    sql.Append("select c.code,c.id,c.name,c.courses,c.scope,c.teacher from c ");
        //    Dictionary<string, object> dict = new Dictionary<string, object>();
        //    var emobj = request.EnumerateObject();
        //    while (emobj.MoveNext())
        //    {
        //        dict[emobj.Current.Name] = emobj.Current.Value;
        //    }
        //    //处理code
        //    if (dict.TryGetValue("code", out object _))
        //    {
        //        dict.Remove("code");
        //    }
        //    AzureCosmosQuery cosmosDbQuery = SQLHelper.GetSQL(dict, sql);
        //    await foreach (var item in client.GetContainer(Constant.TEAMModelOS, "School").GetItemQueryStreamIteratorSql(queryDefinition: cosmosDbQuery.CosmosQueryDefinition, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"CourseManagement-{code}") }))
        //    {
        //        using var json = await JsonDocument.ParseAsync(item.Content);
        //        if (json.RootElement.TryGetProperty("_count", out JsonElement count) && count.GetUInt16() > 0)
        //        {
        //            foreach (var obj in json.RootElement.GetProperty("Documents").EnumerateArray())
        //            {
        //                courses.Add(obj.ToObject<object>());
        //            }
        //        }
        //    }
        //    return Ok(new { courses });
        //}
        //[ProducesDefaultResponseType]
        ////[AuthToken(Roles = "Teacher")]
        //[HttpPost("find-course")]
        //public async Task<IActionResult> FindCourse(JsonElement request)
        //{
        //    if (!request.TryGetProperty("id", out JsonElement id)) return BadRequest();
        //    if (!request.TryGetProperty("code", out JsonElement code)) return BadRequest();
        //    var client = _azureCosmos.GetCosmosClient();
        //    List<object> courses = new List<object>();
        //    var query = $"select c.code,c.id,c.name,A0.course.id courseId,A0.course.name courseName ,A0.course.notice notice ,A1,c.scope,c.teacher from c  join A0  in c.courses join A1  in A0.teachers where A1.id = '{id}' ";
        //    await foreach (var item in client.GetContainer(Constant.TEAMModelOS, "School").GetItemQueryStreamIteratorSql(queryText: query, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"CourseManagement-{code}") }))
        //    {
        //        using var json = await JsonDocument.ParseAsync(item.Content);
        //        if (json.RootElement.TryGetProperty("_count", out JsonElement count) && count.GetUInt16() > 0)
        //        {
        //            foreach (var obj in json.RootElement.GetProperty("Documents").EnumerateArray())
        //            {
        //                courses.Add(obj.ToObject<object>());
        //            }
        //        }
        //    }
        //    return Ok(new { courses });
        //}
        [ProducesDefaultResponseType]
        //[AuthToken(Roles = "teacher")]
        [HttpPost("find-course-by-room")]
        [AuthToken(Roles = "teacher,admin,student")]

#if !DEBUG
        [Authorize(Roles = "IES")]
#endif
        public async Task<IActionResult> FindCourseByRoom(JsonElement request)
        {
            if (!request.TryGetProperty("id", out JsonElement id)) return BadRequest();
            if (!request.TryGetProperty("code", out JsonElement code)) return BadRequest();
            if (!request.TryGetProperty("scope", out JsonElement scope)) return BadRequest();
            var client = _azureCosmos.GetCosmosClient();
            HashSet<Course> courseList = new HashSet<Course>();
            List<object> courses = new List<object>();
            //var query = $"select c.code,c.id,c.name from c join A0 in c.schedule where A0.classId = '{id}'";
            //此处存在不同老师在同一间教室上相同的课程
            if (scope.ToString().Equals("school", StringComparison.OrdinalIgnoreCase))
            {
                var query = $"select distinct value(c) from c join A0 in c.schedule where A0.room = '{id}'";
                await foreach (var item in client.GetContainer(Constant.TEAMModelOS, "School").GetItemQueryIteratorSql<Course>(queryText: query, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Course-{code}") }))
                {
                    courseList.Add(item);
                }
            }
            else
            {
                var query = $"select distinct value(c) from c join A0 in c.schedule where A0.room = '{id}'";
                await foreach (var item in client.GetContainer(Constant.TEAMModelOS, "Teacher").GetItemQueryIteratorSql<Course>(queryText: query, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Course-{code}") }))
                {
                    courseList.Add(item);
                }
            }
            HashSet<string> teacherIds = new HashSet<string>();
            foreach (Course course in courseList)
            {
                foreach (Schedule schedule in course.schedule)
                {
                    teacherIds.Add(schedule.teacherId);
                }
            }
            List<(string id, string name)> teachers = new List<(string id, string name)>();
            if (teacherIds.Count > 0)
            {
                await foreach (var item in client.GetContainer(Constant.TEAMModelOS, "Teacher").GetItemQueryStreamIteratorSql(
                                    queryText: $"select c.id,c.name from c where c.id in ({ string.Join(",", teacherIds.Select(o => $"'{o}'"))})", requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey("Base") }))
                {
                    using var json = await JsonDocument.ParseAsync(item.Content);
                    if (json.RootElement.TryGetProperty("_count", out JsonElement count) && count.GetUInt16() > 0)
                    {
                        var accounts = json.RootElement.GetProperty("Documents").EnumerateArray();
                        while (accounts.MoveNext())
                        {
                            JsonElement account = accounts.Current;
                            teachers.Add((account.GetProperty("id").GetString(), account.GetProperty("name").GetString()));
                        }
                    }
                }
            }
            foreach (Course course in courseList)
            {
                dynamic courseExtobj = new ExpandoObject();
                courseExtobj.id = course.id;
                courseExtobj.name = course.name;
                courseExtobj.subject = course.subject;
                courseExtobj.desc = course.desc;
                courseExtobj.period = course.period;
                courseExtobj.scope = course.scope;
                courseExtobj.no = course.no;
                courseExtobj.code = course.code;
                courseExtobj.pk = course.pk;
                List<object> scheList = new List<object>();
                foreach (Schedule schedule in course.schedule)
                {
                    dynamic scheduleExtobj = new ExpandoObject();
                    scheduleExtobj.classId = schedule.classId;
                    scheduleExtobj.teacherId = schedule.teacherId;
                    if (!string.IsNullOrEmpty(schedule.teacherId))
                    {
                        scheduleExtobj.teacherName = teachers.FirstOrDefault(c => c.id == schedule.teacherId).name;
                    }
                    scheduleExtobj.stulist = schedule.stulist;
                    scheduleExtobj.time = schedule.time;
                    scheduleExtobj.room = schedule.room;
                    scheList.Add(scheduleExtobj);
                }
                courseExtobj.schedule = scheList;
                courses.Add(courseExtobj);
            }
            return Ok(new { courses });
        }

        //[ProducesDefaultResponseType]
        ////[AuthToken(Roles = "Teacher")]
        //[HttpPost("upsert-notice")]
        //public async Task<IActionResult> upsertNotice(JsonElement request)
        //{
        //    if (!request.TryGetProperty("courseId", out JsonElement courseId)) return BadRequest();
        //    if (!request.TryGetProperty("code", out JsonElement code)) return BadRequest();
        //    if (!request.TryGetProperty("id", out JsonElement id)) return BadRequest();
        //    if (!request.TryGetProperty("notice", out JsonElement notice)) return BadRequest();
        //    if (!request.TryGetProperty("A1", out JsonElement teacherInfo)) return BadRequest();
        //    Teachers teachers = teacherInfo.ToObject<Teachers>();
        //    var client = _azureCosmos.GetCosmosClient();
        //    List<CourseManagement> courseManagements = new List<CourseManagement>();

        //    StringBuilder sql = new StringBuilder();
        //    sql.Append("select value(c) from c");
        //    Dictionary<string, object> dict = new Dictionary<string, object>();
        //    //dict.Add("id", id);
        //    dict.Add("courses[*].course.id", courseId);
        //    dict.Add("courses[*].teachers[*].id", teachers.id);
        //    //dict.Add("id", classroom.id);
        //    AzureCosmosQuery cosmosDbQuery = SQLHelper.GetSQL(dict, sql);
        //    await foreach (var item in client.GetContainer(Constant.TEAMModelOS, "School").GetItemQueryStreamIteratorSql(queryDefinition: cosmosDbQuery.CosmosQueryDefinition, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"CourseManagement-{code}") }))
        //    {
        //        using var json = await JsonDocument.ParseAsync(item.Content);
        //        if (json.RootElement.TryGetProperty("_count", out JsonElement count) && count.GetUInt16() > 0)
        //        {
        //            foreach (var obj in json.RootElement.GetProperty("Documents").EnumerateArray())
        //            {
        //                courseManagements.Add(obj.ToObject<CourseManagement>());
        //            }
        //        }
        //    }
        //    for (int i = 0; i < courseManagements.Count; i++)
        //    {
        //        for (int j = 0; j < courseManagements[i].courses.Count; j++)
        //        {
        //            if (courseManagements[i].courses[j].course.id.Equals(courseId.ToString()))
        //            {
        //                courseManagements[i].courses[j].course.notice = notice.ToString();
        //                await client.GetContainer(Constant.TEAMModelOS, "School").ReplaceItemAsync(courseManagements[i], courseManagements[i].id, new PartitionKey($"{courseManagements[i].code}"));
        //                break;
        //            }
        //        }
        //    }
        //    return Ok(new { id });
        //}




        [ProducesDefaultResponseType]
        //[AuthToken(Roles = "teacher")]
        [HttpPost("upsert-teacher-course")]
        [AuthToken(Roles = "teacher,admin")]

#if !DEBUG
        [Authorize(Roles = "IES")]
#endif
        public async Task<IActionResult> upsertCourse(JsonElement request)
        {
            try
            {
                TeacherCourse course = new TeacherCourse();
                if (!request.TryGetProperty("course", out JsonElement room)) return BadRequest();
                if (!request.TryGetProperty("option", out JsonElement option)) return BadRequest();
                course = room.ToObject<TeacherCourse>();
                var client = _azureCosmos.GetCosmosClient();
                course.pk = typeof(Course).Name;
                string code = course.code;
                course.code = typeof(Course).Name + "-" + course.code;
                if (option.ToString().Equals("insert"))
                {
                    var response = await client.GetContainer(Constant.TEAMModelOS, "Teacher").ReadItemStreamAsync(course.id, new PartitionKey($"Course-{code}"));
                    if (response.StatusCode==System.Net.HttpStatusCode.OK)
                    {
                        return Ok(new { error = ResponseCode.DATA_EXIST, V = "课程编码已经存在！" });
                    }
                    else
                    {
                        course = await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "Teacher").CreateItemAsync(course, new PartitionKey($"Course-{code}"));

                    }
                }
                else
                {
                    if (course.classes.Count > 0)
                    {
                        //TODO 教师创建的个人的校本班级待处理冗余数据
                        foreach (ClassSimple classSimple in course.classes)
                        {
                            if (classSimple.scope.Equals("private", StringComparison.OrdinalIgnoreCase))
                            {
                                Class cla = new Class();
                                cla.id = classSimple.id;
                                cla.code = cla.pk + "-" + code;
                                cla.name = classSimple.name;
                                //cla.scope = classSimple.scope;
                                cla.teacher.id = classSimple.teacher.id;
                                cla.teacher.name = classSimple.teacher.name;
                                await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "Teacher").UpsertItemAsync(cla, new PartitionKey($"Class-{code}"));
                            }
                            else
                            {

                                var response = await client.GetContainer(Constant.TEAMModelOS, "School").ReadItemStreamAsync(classSimple.id, new PartitionKey($"Class-{classSimple.code}"));
                                if (response.StatusCode==System.Net.HttpStatusCode.OK)
                                {
                                    using var json = await JsonDocument.ParseAsync(response.Content);
                                    Class cla = json.ToObject<Class>();
                                    Class newCla = new Class();
                                    newCla.id = cla.id;
                                    newCla.code = cla.pk + "-" + code;
                                    newCla.name = classSimple.name;
                                    // newCla.scope = classSimple.scope;
                                    /*foreach (StudentSimple student in cla.students)
                                    {
                                        StudentSimple studentSimple = new StudentSimple();
                                        studentSimple.id = student.id;
                                        studentSimple.name = student.name;
                                        studentSimple.no = student.no;
                                        newCla.students.Add(studentSimple);
                                    }*/
                                    newCla.teacher.id = classSimple.teacher.id;
                                    newCla.teacher.name = classSimple.teacher.name;
                                    await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "Teacher").UpsertItemAsync(newCla, new PartitionKey($"Class-{code}"));
                                    classSimple.code = code;
                                }
                                else
                                {
                                    Class cla = await client.GetContainer(Constant.TEAMModelOS, "Teacher").ReadItemAsync<Class>(classSimple.id, new PartitionKey($"Class-{classSimple.code}"));
                                    Class newCla = new Class();
                                    newCla.id = cla.id;
                                    newCla.code = cla.pk + "-" + code;
                                    newCla.name = classSimple.name;
                                    //newCla.scope = classSimple.scope;

                                    //newCla.students = cla.students;
                                    newCla.teacher.id = classSimple.teacher.id;
                                    newCla.teacher.name = classSimple.teacher.name;
                                    await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "Teacher").UpsertItemAsync(newCla, new PartitionKey($"Class-{code}"));
                                }
                            }
                        }
                    }
                    course = await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "Teacher").ReplaceItemAsync(course, course.id, new PartitionKey($"Course-{code}"));
                }
                return Ok(new { course });
            }
            catch (Exception ex)
            {
                await _dingDing.SendBotMsg($"CoreAPI2，{_option.Location}，teacherCourse/upsert()\n{ex.Message}\n{ex.StackTrace}", GroupNames.醍摩豆服務運維群組);
                return BadRequest();
            }
        }
        [ProducesDefaultResponseType]
        //[AuthToken(Roles = "teacher")]
        [HttpPost("find-teacher-course")]
        [AuthToken(Roles = "teacher,admin,student")]

#if !DEBUG
        [Authorize(Roles = "IES")]
#endif
        public async Task<IActionResult> FindTeacherCourse(JsonElement request)
        {
            if (!request.TryGetProperty("id", out JsonElement id)) return BadRequest();
            //if (!request.TryGetProperty("code", out JsonElement code)) return BadRequest();
            var client = _azureCosmos.GetCosmosClient();
            List<object> courses = new List<object>();
            var query = $"select c.code,c.id,c.name,c.subjectId,c.periodId,c.scope,c.notice,c.classes from c ";
            await foreach (var item in client.GetContainer(Constant.TEAMModelOS, "Teacher").GetItemQueryStreamIteratorSql(queryText: query, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Course-{id}") }))
            {
                using var json = await JsonDocument.ParseAsync(item.Content);
                if (json.RootElement.TryGetProperty("_count", out JsonElement count) && count.GetUInt16() > 0)
                {
                    foreach (var obj in json.RootElement.GetProperty("Documents").EnumerateArray())
                    {
                        courses.Add(obj.ToObject<object>());
                    }
                }
            }
            return Ok(new { courses });
        }

        /// <summary>
        /// 查询执教助教的课程班级
        /// </summary>
        /// <param name="request"></param>
        /// <returns></returns>
        [ProducesDefaultResponseType]
        //[AuthToken(Roles = "teacher")]
        [HttpPost("find-teach-class")]
        [AuthToken(Roles = "teacher,admin,student")]

#if !DEBUG
        [Authorize(Roles = "IES")]
#endif
        public async Task<IActionResult> FindPlanClass(JsonElement request)
        {

            HashSet<string> data = new HashSet<string>();
            if (!request.TryGetProperty("id", out JsonElement id)) return BadRequest();
            if (!request.TryGetProperty("code", out JsonElement code)) return BadRequest();
            var client = _azureCosmos.GetCosmosClient();
            //List<object> courses = new List<object>();
            List<string> classIds = new List<string>();
            List<(string id, string scope)> listClassInfo = new List<(string id, string scope)>();
            var query = $"select distinct c.scope,A0.stulist id from c join A0 in c.schedule where A0.teacherId = '{id}'";
            await foreach (var item in client.GetContainer(Constant.TEAMModelOS, "Teacher").GetItemQueryStreamIteratorSql(queryText: query, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Course-{id}") }))
            {
                using var json = await JsonDocument.ParseAsync(item.Content);
                if (json.RootElement.TryGetProperty("_count", out JsonElement count) && count.GetUInt16() > 0)
                {
                    var accounts = json.RootElement.GetProperty("Documents").EnumerateArray();
                    while (accounts.MoveNext())
                    {
                        JsonElement account = accounts.Current;
                        if (string.IsNullOrEmpty(account.GetProperty("id").GetString()))
                        {
                            continue;
                        }
                        classIds.Add(account.GetProperty("id").GetString());
                        listClassInfo.Add((account.GetProperty("id").GetString(), account.GetProperty("scope").GetString()));
                    }
                }
            }
            var querySchool = $"select distinct c.scope,A0.classId id from c join A0 in c.schedule where A0.teacherId = '{id}'";
            await foreach (var item in client.GetContainer(Constant.TEAMModelOS, "Teacher").GetItemQueryStreamIteratorSql(queryText: querySchool, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Course-{id}") }))
            {
                using var json = await JsonDocument.ParseAsync(item.Content);
                if (json.RootElement.TryGetProperty("_count", out JsonElement count) && count.GetUInt16() > 0)
                {
                    var accounts = json.RootElement.GetProperty("Documents").EnumerateArray();
                    while (accounts.MoveNext())
                    {
                        JsonElement account = accounts.Current;
                        if (string.IsNullOrEmpty(account.GetProperty("id").GetString()))
                        {
                            continue;
                        }
                        classIds.Add(account.GetProperty("id").GetString());
                        listClassInfo.Add((account.GetProperty("id").GetString(), account.GetProperty("scope").GetString()));
                    }
                }
            }
            //List<object> coursesBySchool = new List<object>();
            //var queryBySchool = $"select distinct c.id,c.name,c.scope from c  join A0  in c.courses join A1  in A0.teachers where A1.id = '{id}' ";
            await foreach (var item in client.GetContainer(Constant.TEAMModelOS, "School").GetItemQueryStreamIteratorSql(queryText: query, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Course-{code}") }))
            {
                using var json = await JsonDocument.ParseAsync(item.Content);
                if (json.RootElement.TryGetProperty("_count", out JsonElement count) && count.GetUInt16() > 0)
                {
                    var accounts = json.RootElement.GetProperty("Documents").EnumerateArray();
                    while (accounts.MoveNext())
                    {
                        JsonElement account = accounts.Current;
                        if (string.IsNullOrEmpty(account.GetProperty("id").GetString()))
                        {
                            continue;
                        }
                        classIds.Add(account.GetProperty("id").GetString());
                        listClassInfo.Add((account.GetProperty("id").GetString(), account.GetProperty("scope").GetString()));
                    }
                }
            }
            await foreach (var item in client.GetContainer(Constant.TEAMModelOS, "School").GetItemQueryStreamIteratorSql(queryText: querySchool, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Course-{code}") }))
            {
                using var json = await JsonDocument.ParseAsync(item.Content);
                if (json.RootElement.TryGetProperty("_count", out JsonElement count) && count.GetUInt16() > 0)
                {
                    var accounts = json.RootElement.GetProperty("Documents").EnumerateArray();
                    while (accounts.MoveNext())
                    {
                        JsonElement account = accounts.Current;
                        if (string.IsNullOrEmpty(account.GetProperty("id").GetString()))
                        {
                            continue;
                        }
                        classIds.Add(account.GetProperty("id").GetString());
                        listClassInfo.Add((account.GetProperty("id").GetString(), account.GetProperty("scope").GetString()));
                    }
                }
            }
            List<(string id, string name)> listClassList = new List<(string id, string name)>();
            if (classIds.Count > 0)
            {
                //List<(string id, string name)> listClassList = new List<(string id, string name)>();
                await foreach (var item in client.GetContainer(Constant.TEAMModelOS, "School").GetItemQueryStreamIteratorSql(
                                    queryText: $"select c.id,c.name from c where c.id in ({string.Join(",", classIds.Select(o => $"'{o}'"))})", requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Class-{code}") }))
                {
                    using var json = await JsonDocument.ParseAsync(item.Content);
                    if (json.RootElement.TryGetProperty("_count", out JsonElement count) && count.GetUInt16() > 0)
                    {
                        var accounts = json.RootElement.GetProperty("Documents").EnumerateArray();
                        while (accounts.MoveNext())
                        {
                            JsonElement account = accounts.Current;
                            listClassList.Add((account.GetProperty("id").GetString(), account.GetProperty("name").GetString()));
                        }
                    }
                }

                await foreach (var item in client.GetContainer(Constant.TEAMModelOS, "School").GetItemQueryIteratorSql<GroupList>(
                                    queryText: $"select c.id,c.name from c where c.id in ({string.Join(",", classIds.Select(o => $"'{o}'"))})", requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"GroupList-{code}") }))
                {
                    listClassList.Add((item.id, item.name));
                }

                await foreach (var item in client.GetContainer(Constant.TEAMModelOS, "Teacher").GetItemQueryIteratorSql<GroupList>(
                                    queryText: $"select c.id,c.name from c where c.id in ({string.Join(",", classIds.Select(o => $"'{o}'"))})", requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"GroupList") }))
                {
                    listClassList.Add((item.id, item.name));
                }
            }


            var courses = listClassInfo.Select(o =>
                                    new
                                    {
                                        o.id,
                                        o.scope,
                                        name = listClassList.FirstOrDefault(c => c.id == o.id).name,
                                    }
               );
            return Ok(new { courses });
        }


        public class StudentCompare
        {
            public string id { get; set; }
            public string name { get; set; }
            public string scope { get; set; }
        }

        public class ListDistinct : IEqualityComparer<StudentCompare>
        {
            public bool Equals(StudentCompare s1, StudentCompare s2)
            {
                return (s1.id == s2.id);
            }

            public int GetHashCode(StudentCompare s)
            {
                return s == null ? 0 : s.ToString().GetHashCode();
            }
        }
    }
    public class BatchOption
    {
        public List<string> ids { get; set; }
        public string code { get; set; }
        public string scope { get; set; }
    }
}