594 lines
16 KiB
C#
594 lines
16 KiB
C#
using Learn.Archives.Core.Model.Enum;
|
||
using MiniExcelLibs.Attributes;
|
||
using SqlSugar;
|
||
using System;
|
||
using System.Collections.Generic;
|
||
using System.Linq;
|
||
using System.Text;
|
||
using System.Threading.Tasks;
|
||
using UserCenter.Model;
|
||
|
||
namespace Learn.Archives.Core.Model.Dto
|
||
{
|
||
|
||
|
||
public class PositionIdsReq
|
||
{
|
||
/// <summary>
|
||
/// 学校编号
|
||
/// </summary>
|
||
public long SchoolId { get; set; }
|
||
/// <summary>
|
||
/// 年级
|
||
/// </summary>
|
||
public string GradeLevel { get; set; }
|
||
/// <summary>
|
||
/// 毕业届
|
||
/// </summary>
|
||
public int GraduationYear { get; set; }
|
||
|
||
/// <summary>
|
||
/// 班级编号
|
||
/// </summary>
|
||
public long? ClassId { get; set; }
|
||
|
||
/// <summary>
|
||
/// 职级
|
||
/// </summary>
|
||
public int PositionLevel { get; set; }
|
||
public int? PositionType { get; set; } = 2;
|
||
/// <summary>
|
||
/// 科目
|
||
/// </summary>
|
||
public int? SubjectId { get; set; }
|
||
}
|
||
public class TeacherInfoImportError : TeacherInfoImport
|
||
{
|
||
/// <summary>
|
||
/// 导入失败原因
|
||
/// </summary>
|
||
[ExcelColumn(Name = "导入失败原因", Width = 50)]
|
||
public string ErrorMsg { get; set; }
|
||
}
|
||
public class TeacherInfoImport
|
||
{
|
||
/// <summary>
|
||
/// 姓名
|
||
/// </summary>
|
||
[ExcelColumn(Name = "姓名", Width = 20)]
|
||
public string RealName { get; set; }
|
||
/// <summary>
|
||
/// 联系电话
|
||
/// </summary>
|
||
[ExcelColumn(Name = "联系电话", Width = 18)]
|
||
public string Phone { get; set; }
|
||
|
||
/// <summary>
|
||
/// 任教类型
|
||
/// </summary>
|
||
[ExcelColumn(Name = "任教类型", Width = 20)]
|
||
public string UserType { get; set; }
|
||
/// <summary>
|
||
/// 学校
|
||
/// </summary>
|
||
[ExcelColumn(Name = "学校", Width = 20)]
|
||
public string School { get; set; }
|
||
/// <summary>
|
||
/// 年级
|
||
/// </summary>
|
||
[ExcelColumn(Name = "年级", Width = 10)]
|
||
public string Grade { get; set; }
|
||
/// <summary>
|
||
/// 班级
|
||
/// </summary>
|
||
[ExcelColumn(Name = "班级", Width = 15)]
|
||
public string Class { get; set; }
|
||
|
||
/// <summary>
|
||
/// 科目
|
||
/// </summary>
|
||
[ExcelColumn(Name = "科目", Width = 20)]
|
||
public string Subject { get; set; }
|
||
|
||
|
||
/// <summary>
|
||
/// 职务
|
||
/// </summary>
|
||
[ExcelColumn(Name = "职务", Width = 20)]
|
||
public string ExamNo { get; set; }
|
||
|
||
}
|
||
|
||
public class UserImportInsertUser
|
||
{
|
||
//
|
||
// 摘要:
|
||
// 账号
|
||
public string Account { get; set; }
|
||
public long Id { get; set; }
|
||
}
|
||
public class UserImportRes
|
||
{
|
||
/// <summary>
|
||
/// 错误数据
|
||
/// </summary>
|
||
public IEnumerable<UserExcelExportData> ErrorExcelExport { get; set; }
|
||
/// <summary>
|
||
/// 入库的用户
|
||
/// </summary>
|
||
public IEnumerable<UserImportInsertUser> InsertUsers { get; set; }
|
||
}
|
||
|
||
|
||
|
||
public class StudentInfoImportError : StudentInfoImport
|
||
{
|
||
/// <summary>
|
||
/// 导入失败原因
|
||
/// </summary>
|
||
[ExcelColumn(Name = "导入失败原因", Width = 50)]
|
||
public string ErrorMsg { get; set; }
|
||
}
|
||
public class StudentInfoImport
|
||
{
|
||
/// <summary>
|
||
/// 姓名
|
||
/// </summary>
|
||
[ExcelColumn(Name="姓名", Width = 28)]
|
||
public string RealName { get; set; }
|
||
/// <summary>
|
||
/// 家长电话
|
||
/// </summary>
|
||
[ExcelColumn(Name="家长电话", Width = 20)]
|
||
public string Phone { get; set; }
|
||
/// <summary>
|
||
/// 学校
|
||
/// </summary>
|
||
[ExcelColumn(Name="学校", Width = 20)]
|
||
public string School { get; set; }
|
||
/// <summary>
|
||
/// 年级
|
||
/// </summary>
|
||
[ExcelColumn(Name="年级", Width = 20)]
|
||
public string Grade { get; set; }
|
||
/// <summary>
|
||
/// 班级
|
||
/// </summary>
|
||
[ExcelColumn(Name="班级", Width = 15)]
|
||
public string Class { get; set; }
|
||
|
||
/// <summary>
|
||
/// 减免金额
|
||
/// </summary>
|
||
[ExcelColumn(Name = "减免金额")]
|
||
public string AmountRelief { get; set; }
|
||
|
||
|
||
/// <summary>
|
||
/// 减免是否申请
|
||
/// </summary>
|
||
[ExcelColumn(Name = "减免是否申请", Width = 15)]
|
||
public string ReliefApplication { get; set; }
|
||
/// <summary>
|
||
/// 减免申请类型
|
||
/// </summary>
|
||
[ExcelColumn(Name = "减免申请类型", Width = 10)]
|
||
public string? ReliefType { get; set; }
|
||
/// <summary>
|
||
/// 减免申请时间
|
||
/// </summary>
|
||
[ExcelColumn(Name = "减免申请时间", Width = 10)]
|
||
public DateTime? ReliefSubTime { get; set; }
|
||
|
||
|
||
|
||
|
||
|
||
|
||
/// <summary>
|
||
/// 学生类型
|
||
/// </summary>
|
||
[ExcelColumn(Name = "学生类型", Width = 20)]
|
||
public string StudentType { get; set; }
|
||
/// <summary>
|
||
/// 学生状态[就读/退出]
|
||
/// </summary>
|
||
[ExcelColumn(Name = "学生状态")]
|
||
public string Status { get; set; }
|
||
|
||
/// <summary>
|
||
/// 入班时间
|
||
/// </summary>
|
||
[ExcelColumn(Name = "入班时间")]
|
||
public DateTime? JoinTime { get; set; }
|
||
/// <summary>
|
||
/// 退出时间
|
||
/// </summary>
|
||
[ExcelColumn(Name = "退出时间")]
|
||
public DateTime? ExitTime { get; set; }
|
||
|
||
/// <summary>
|
||
/// 备注
|
||
/// <para></para>
|
||
/// </summary>
|
||
[ExcelColumn(Name = "备注",Width =50)]
|
||
public string? Remark { get; set; }
|
||
|
||
/// <summary>
|
||
/// 高考选科
|
||
/// <para></para>
|
||
/// </summary>
|
||
[ExcelColumn(Name = "高考选科", Width = 20)]
|
||
public string? 高考选科 { get; set; }
|
||
/// <summary>
|
||
/// id
|
||
/// </summary>
|
||
///
|
||
[ExcelColumn(Ignore = true)]
|
||
public long Id { get; set; } = Yitter.IdGenerator.YitIdHelper.NextId();
|
||
|
||
|
||
}
|
||
|
||
/// <summary>
|
||
/// 用户中心 Excel用户导入
|
||
/// </summary>
|
||
public class UserExcelExportData
|
||
{
|
||
/// <summary>
|
||
/// 用户类型 （校长、年级主任、班主任、教师、学生）
|
||
/// </summary>
|
||
[ExcelColumn(Name="用户类型")]
|
||
public string UserType { get; set; }
|
||
/// <summary>
|
||
/// 第三方id
|
||
/// </summary>
|
||
[ExcelColumn(Name="第三方id")]
|
||
public string ThirdPartyId { get; set; }
|
||
/// <summary>
|
||
/// 点阵笔SN
|
||
/// </summary>
|
||
[ExcelColumn(Name="点阵笔SN")]
|
||
public string PointPenSN { get; set; }
|
||
/// <summary>
|
||
/// 姓名
|
||
/// </summary>
|
||
[ExcelColumn(Name="姓名")]
|
||
public string RealName { get; set; }
|
||
/// <summary>
|
||
/// 学籍号/账号
|
||
/// </summary>
|
||
[ExcelColumn(Name="账号")]
|
||
public string Account { get; set; }
|
||
/// <summary>
|
||
/// 电话号码
|
||
/// </summary>
|
||
[ExcelColumn(Name="手机号")]
|
||
public string Phone { get; set; }
|
||
/// <summary>
|
||
/// 学籍号/账号
|
||
/// </summary>
|
||
[ExcelColumn(Name="考号")]
|
||
public string ExamNo { get; set; }
|
||
/// <summary>
|
||
/// 身份证
|
||
/// </summary>
|
||
[ExcelColumn(Name="身份证")]
|
||
public string IdCard { get; set; }
|
||
/// <summary>
|
||
/// 学校
|
||
/// </summary>
|
||
[ExcelColumn(Name="学校")]
|
||
public string School { get; set; }
|
||
/// <summary>
|
||
/// 年级
|
||
/// </summary>
|
||
[ExcelColumn(Name="年级")]
|
||
public string Grade { get; set; }
|
||
/// <summary>
|
||
/// 班级
|
||
/// </summary>
|
||
[ExcelColumn(Name="班级")]
|
||
public string Class { get; set; }
|
||
/// <summary>
|
||
/// 科目
|
||
/// </summary>
|
||
[ExcelColumn(Name="科目")]
|
||
public string Subject { get; set; }
|
||
/// <summary>
|
||
/// 所属云校
|
||
/// </summary>
|
||
[ExcelColumn(Name="所属云校")]
|
||
public string? CloudSchool { get; set; }
|
||
/// <summary>
|
||
/// 导入失败原因
|
||
/// </summary>
|
||
[ExcelColumn(Name = "导入失败原因", Width = 50)]
|
||
public string ErrorMsg { get; set; }
|
||
|
||
|
||
/// <summary>
|
||
/// 账号密码
|
||
/// </summary>
|
||
[ExcelColumn(Name="账号密码")]
|
||
public string Password { get; set; }
|
||
/// <summary>
|
||
/// 学段
|
||
/// </summary>
|
||
[ExcelColumn(Name="学段")]
|
||
public string? Stages { get; set; }
|
||
/// <summary>
|
||
/// 选修方向
|
||
/// </summary>
|
||
[ExcelColumnName("选修方向")]
|
||
public string? GKSubject { get; set; }
|
||
|
||
}
|
||
|
||
public class StudentInfoRes :UserInfoResponceDto
|
||
{
|
||
|
||
/// <summary>
|
||
/// 减免金额
|
||
/// </summary>
|
||
public decimal? AmountRelief { get; set; }
|
||
|
||
/// <summary>
|
||
/// 学生状态
|
||
/// </summary>
|
||
public UserStatusEnum Status { get; set; }
|
||
/// <summary>
|
||
/// 学生类型
|
||
/// </summary>
|
||
public string? StudentType { get; set; }
|
||
|
||
/// <summary>
|
||
/// 备注
|
||
/// <para></para>
|
||
/// </summary>
|
||
public string? Remark { get; set; }
|
||
|
||
/// <summary>
|
||
/// 退出时间
|
||
/// </summary>
|
||
public string? ExitTime { get; set; }
|
||
|
||
/// <summary>
|
||
/// 退出时间
|
||
/// </summary>
|
||
public string? JoinTime { get; set; }
|
||
|
||
/// <summary>
|
||
/// 减免是否申请
|
||
/// </summary>
|
||
public bool ReliefApplication { get; set; }
|
||
/// <summary>
|
||
/// 减免申请类型
|
||
/// </summary>
|
||
public string? ReliefType { get; set; }
|
||
/// <summary>
|
||
/// 减免申请时间
|
||
/// </summary>
|
||
public string ReliefSubTime { get; set; }
|
||
}
|
||
|
||
/// <summary>
|
||
/// 用户信息
|
||
/// </summary>
|
||
public class UserInfoResponceDto
|
||
{
|
||
/// <summary>
|
||
///
|
||
/// <summary>
|
||
public long Id { get; set; }
|
||
/// <summary>
|
||
/// 模板编号
|
||
/// </summary>
|
||
public long TemplateId { get; set; }
|
||
/// <summary>
|
||
/// 电话号码
|
||
/// </summary>
|
||
public string Phone { get; set; }
|
||
/// <summary>
|
||
/// 信息模板是否编辑过
|
||
/// </summary>
|
||
public bool Edited { get; set; }
|
||
|
||
/// <summary>
|
||
/// 用户类型 1：学生 2：校职工
|
||
/// <summary>
|
||
public int UserType { get; set; }
|
||
/// <summary>
|
||
/// 云校id
|
||
/// </summary>
|
||
public long CloudSchoolId { get; set; }
|
||
|
||
/// <summary>
|
||
/// 账号
|
||
/// <summary>
|
||
public string Account { get; set; }
|
||
|
||
/// <summary>
|
||
/// 学号
|
||
/// <summary>
|
||
public string StudentId { get; set; }
|
||
|
||
/// <summary>
|
||
/// 姓名
|
||
/// <summary>
|
||
public string RealName { get; set; }
|
||
|
||
/// <summary>
|
||
/// 性别 0=男 1=女
|
||
/// <summary>
|
||
public int Sex { get; set; }
|
||
/// <summary>
|
||
/// 学科级别
|
||
/// </summary>
|
||
public UserSubjectLevel SubjectLevel { get; set; }
|
||
|
||
/// <summary>
|
||
/// 出生日期
|
||
/// <summary>
|
||
public string? BirthDate { get; set; }
|
||
|
||
/// <summary>
|
||
/// 家庭户口
|
||
/// <summary>
|
||
public string Residence { get; set; }
|
||
|
||
/// <summary>
|
||
/// 民族
|
||
/// <summary>
|
||
public string National { get; set; }
|
||
|
||
/// <summary>
|
||
/// 头像
|
||
/// <summary>
|
||
public string HeadImage { get; set; }
|
||
public string IdCard { get; set; }
|
||
|
||
/// <summary>
|
||
/// 省Id
|
||
/// <summary>
|
||
public int Pid { get; set; }
|
||
|
||
/// <summary>
|
||
///
|
||
/// <summary>
|
||
public string Pname { get; set; }
|
||
|
||
/// <summary>
|
||
/// 市Id
|
||
/// <summary>
|
||
public int Cid { get; set; }
|
||
|
||
/// <summary>
|
||
///
|
||
/// <summary>
|
||
public string Cname { get; set; }
|
||
|
||
/// <summary>
|
||
/// 区Id
|
||
/// <summary>
|
||
public int Rid { get; set; }
|
||
|
||
/// <summary>
|
||
///
|
||
/// <summary>
|
||
public string Rname { get; set; }
|
||
|
||
/// <summary>
|
||
/// 微信号
|
||
/// <summary>
|
||
public string Wx { get; set; }
|
||
|
||
/// <summary>
|
||
/// 是否完善信息 0:否 1:是
|
||
/// <summary>
|
||
public int IsPerfectInfo { get; set; }
|
||
|
||
/// <summary>
|
||
/// 用户层次
|
||
/// <summary>
|
||
public int Level { get; set; }
|
||
|
||
/// <summary>
|
||
/// 账户状态 0禁用 1正常
|
||
/// <summary>
|
||
public int State { get; set; }
|
||
|
||
/// <summary>
|
||
/// 会议系统账号
|
||
/// <summary>
|
||
public string MeetingAccount { get; set; }
|
||
public string GKSubject { get; set; }
|
||
public int? GLSubject { get; set; }
|
||
public int? GSubject1 { get; set; }
|
||
public int? GSubject2 { get; set; }
|
||
/// <summary>
|
||
/// 第三方id
|
||
/// </summary>
|
||
public string ThirdPartyId { get; set; }
|
||
|
||
/// <summary>
|
||
/// 点阵笔SN
|
||
/// </summary>
|
||
public string PointPenSN { get; set; }
|
||
|
||
/// <summary>
|
||
/// 职位
|
||
/// </summary>
|
||
public List<PositionsResponeDto> Positions { get; set; }
|
||
}
|
||
|
||
public class PositionsResponeDto
|
||
{
|
||
/// <summary>
|
||
/// 用户Id
|
||
/// </summary>
|
||
public long UserId { get; set; }
|
||
/// <summary>
|
||
/// 职位编号
|
||
/// </summary>
|
||
public long Id { get; set; }
|
||
/// <summary>
|
||
/// 职位名称
|
||
/// </summary>
|
||
public string Name { get; set; }
|
||
/// <summary>
|
||
/// 学校编号
|
||
/// </summary>
|
||
public long SchoolId { get; set; }
|
||
public bool Enable { get; set; }
|
||
//public DateTime? EndTime { get; set; }
|
||
|
||
/// <summary>
|
||
/// 学校名称
|
||
/// </summary>
|
||
public string SchoolName { get; set; }
|
||
/// <summary>
|
||
/// 级别(初/高)
|
||
/// </summary>
|
||
public string GradeLevel { get; set; }
|
||
/// <summary>
|
||
/// 所属届
|
||
/// </summary>
|
||
public int GraduationYear { get; set; }
|
||
/// <summary>
|
||
/// 年级
|
||
/// </summary>
|
||
public string Grade { get; set; }
|
||
/// <summary>
|
||
/// 班级编号
|
||
/// </summary>
|
||
public long ClassId { get; set; }
|
||
/// <summary>
|
||
/// 班级名称
|
||
/// </summary>
|
||
public string ClassName { get; set; }
|
||
/// <summary>
|
||
/// 科目编号
|
||
/// </summary>
|
||
public int SubjectId { get; set; }
|
||
/// <summary>
|
||
/// 科目名称
|
||
/// </summary>
|
||
public string SubjectName { get; set; }
|
||
/// <summary>
|
||
/// 职位类型1：学生 2：校职工
|
||
/// </summary>
|
||
public int PositionType { get; set; }
|
||
|
||
/// <summary>
|
||
/// 职级1：校级 2：年级 3：班级
|
||
/// </summary>
|
||
public int PositionLevel { get; set; }
|
||
|
||
/// <summary>
|
||
/// 职位状态
|
||
/// </summary>
|
||
public object Status { get; set; }
|
||
}
|
||
}
|