private void UserId(string UserCode)
{
using (var db = new XkSystem.Models.DbContext())
{
var user = (from p in db.TableRoot <Areas.Sys.Entity.tbSysUser>()
where p.tbTenant.IsDeleted == false &&
p.UserCode == UserCode
select new { Id = p.Id, UserName = p.UserName, UserType = p.UserType, TenantId = p.tbTenant.Id, AppTitle = p.tbTenant.Title }).FirstOrDefault();
if (user != null)
{
Code.Common.UserId = user.Id;
Code.Common.UserName = user.UserName;
Code.Common.UserType = user.UserType;
Code.Common.TenantId = user.TenantId;
Code.Common.AppTitle = user.AppTitle;
}
}
}
public static string InsertDefault(XkSystem.Models.DbContext db, int electiveId)
{
var tb = new Entity.tbElectiveSection();
tb.No = 1;
tb.tbElective = db.Set <Entity.tbElective>().Find(electiveId);
tb.ElectiveSectionName = "默认分段";
tb.MaxElective = 99;
tb.MinElective = 0;
db.Set <Entity.tbElectiveSection>().Add(tb);
if (db.SaveChanges() > 0)
{
XkSystem.Areas.Sys.Controllers.SysUserLogController.Insert("添加了选课时段");
}
return(string.Empty);
}
public ActionResult Delete(List <int> ids)
{
using (var db = new XkSystem.Models.DbContext())
{
var tb = (from p in db.Table <Disk.Entity.tbDiskPower>()
where ids.Contains(p.Id)
select p).ToList();
foreach (var t in tb)
{
t.IsDeleted = true;
}
db.SaveChanges();
return(Code.MvcHelper.Post());
}
}
public ActionResult List()
{
var vm = new Models.DormOption.List();
using (var db = new XkSystem.Models.DbContext())
{
var tb = db.Table <Dorm.Entity.tbDormOption>();
if (!string.IsNullOrEmpty(vm.SearchText))
{
tb = tb.Where(d => d.DormOptionName.Contains(vm.SearchText));
}
vm.DormOptionList = (from p in tb
orderby p.No
select p).ToPageList(vm.Page);
}
return(View(vm));
}
public static List <Dto.DiskFolder.ReportUser> SelectReportUserList(int parentId)
{
using (var db = new XkSystem.Models.DbContext())
{
var tb = (from t in db.Table <Disk.Entity.tbDiskPower>()
where t.tbDiskFolder.tbDiskFolderParent.Id == parentId &&
t.tbDiskFolder.IsDeleted == false
select new Dto.DiskFolder.ReportUser
{
FolderId = t.tbDiskFolder.Id,
UserId = t.tbSysUser.Id,
UserCode = t.tbSysUser.UserCode,
UserName = t.tbSysUser.UserName
}).Distinct().ToList();
return(tb);
}
}
public JsonResult UpdateCommit()
{
var id = Request["Id"].ConvertToInt();
var comment = Request["Comment"];
using (var db = new XkSystem.Models.DbContext())
{
var tbMoralData = db.Set <Entity.tbMoralData>().Find(id);
if (tbMoralData != null)
{
tbMoralData.Comment = comment;
tbMoralData.UpdateTime = DateTime.Now;
}
db.SaveChanges();
}
return(Json(null));
}
public ActionResult SetOpen(int id)
{
using (var db = new XkSystem.Models.DbContext())
{
var tb = db.Set <Entity.tbSurvey>().Find(id);
if (tb != null)
{
tb.IsOpen = !tb.IsOpen;
if (db.SaveChanges() > 0)
{
XkSystem.Areas.Sys.Controllers.SysUserLogController.Insert("修改教师评价");
}
}
return(Code.MvcHelper.Post(null, Url.Action("List")));
}
}
public static List <Dto.DiskFile.List> SelectByPublic(Code.EnumHelper.DiskType enumDiskType, int diskTypeId = 0)
{
using (var db = new XkSystem.Models.DbContext())
{
var tb = (from t in db.Table <Disk.Entity.tbDiskFolder>()
where t.tbDiskType.DiskType == enumDiskType &&
t.DiskPermit == Code.EnumHelper.DiskPermit.Public
select new Dto.DiskFile.List
{
UserId = t.tbSysUser.Id,
FileType = "Folder",
DiskTypeId = diskTypeId == 0 ? t.tbDiskType.Id : diskTypeId,
FileTitle = t.tbSysUser.UserName
}).Distinct().ToList();
return(tb);
}
}
public static List <System.Web.Mvc.SelectListItem> SelectList(int id = 0, int buildId = 0, bool isShowGroup = false)
{
using (var db = new XkSystem.Models.DbContext())
{
var tb = from p in db.Table <Basis.Entity.tbRoom>()
select p;
var list = (from p in tb
orderby p.RoomName
select new System.Web.Mvc.SelectListItem
{
Text = ((isShowGroup && p.tbBuild != null) ? ("[" + p.tbBuild.BuildName + "]") : string.Empty) + p.RoomName,
Value = p.Id.ToString(),
Selected = p.Id == id
}).ToList();
return(list);
}
}
public ActionResult SetDisable(int id)
{
using (var db = new XkSystem.Models.DbContext())
{
var tb = db.Set <Sys.Entity.tbSysUser>().Find(id);
if (tb != null)
{
tb.IsDisable = !tb.IsDisable;
if (db.SaveChanges() > 0)
{
XkSystem.Areas.Sys.Controllers.SysUserLogController.Insert("设置用户禁用");
}
}
return(Code.MvcHelper.Post(null, Url.Action("List")));
}
}
public ActionResult UserRoleList(int UserId)
{
using (var db = new XkSystem.Models.DbContext())
{
var vm = new Models.SysUser.UserRoleList();
vm.DataList = (from p in db.Table <Sys.Entity.tbSysUserRole>()
where p.tbSysUser.Id == UserId
select new Dto.SysUser.UserRoleList()
{
Id = p.Id,
No = p.No,
RoleName = p.tbSysRole.RoleName
}).ToList();
return(View(vm));
}
}
public static List <XkSystem.Areas.Basis.Dto.Period.List> SelectListForColor()
{
var list = new List <XkSystem.Areas.Basis.Dto.Period.List>();
using (var db = new XkSystem.Models.DbContext())
{
list = (from p in db.Table <Basis.Entity.tbPeriod>()
orderby p.No
select new Dto.Period.List()
{
Id = p.Id,
No = p.No,
Color = p.tbPeriodType.Color,
PeriodName = p.PeriodName
}).ToList();
}
return(list);
}
public ActionResult SetDisable(int id)
{
using (var db = new XkSystem.Models.DbContext())
{
var tb = db.Set <Entity.tbSmsConfig>().Find(id);
if (tb != null)
{
tb.Status = !tb.Status;
if (db.SaveChanges() > 0)
{
XkSystem.Areas.Sys.Controllers.SysUserLogController.Insert("修改了短信服务配置字段【Status】");
}
}
return(Code.MvcHelper.Post(null, Url.Action("List")));
}
}
public ActionResult Edit(Models.ElectiveData.Edit vm)
{
using (var db = new XkSystem.Models.DbContext())
{
var error = new List <string>();
if (error.Count == decimal.Zero)
{
if (vm.ElectiveDataEdit.Id == 0)
{
var tb = new Entity.tbElectiveData()
{
IsFixed = vm.ElectiveDataEdit.IsFixed,
IsPreElective = vm.ElectiveDataEdit.IsPreElective,
tbElectiveOrg = db.Set <Entity.tbElectiveOrg>().Find(vm.ElectiveDataEdit.ElectiveOrgId),
tbStudent = db.Set <Student.Entity.tbStudent>().Find(Code.Common.UserId),
};
db.Set <Entity.tbElectiveData>().Add(tb);
if (db.SaveChanges() > 0)
{
XkSystem.Areas.Sys.Controllers.SysUserLogController.Insert("添加了选课数据");
}
}
else
{
//var tb = (from p in db.Table<Entity.tbElectiveData>()
// where p.Id == vm.ElectiveDataEdit.Id
// select p).FirstOrDefault();
//if (tb != null)
//{
// if (db.SaveChanges() > 0)
// {
// XkSystem.Areas.Sys.Controllers.SysUserLogController.Insert("修改了选课数据");
// }
//}
//else
//{
// error.AddError(Resources.LocalizedText.MsgNotFound);
//}
}
}
return(Code.MvcHelper.Post(error));
}
}
public bool SaveQualityOption(XkSystem.Models.DbContext db, Quality.Entity.tbQualityItem qualityItem, HttpRequestBase request)
{
var txtId = request["txtId"].Split(',');
var txtNo = request["txtNo"].Split(',');
var txtName = request["txtName"].Split(',');
var txtValue = request["txtValue"].Split(',');
var list = (from p in db.Table <Quality.Entity.tbQualityOption>()
where p.tbQualityItem.Id == qualityItem.Id
select p).ToList();
foreach (var a in list.Where(d => txtId.Contains(d.Id.ToString()) == false))
{
a.IsDeleted = true;
}
for (var i = 0; i < txtId.Count(); i++)
{
//输入内容不为空，判断是否存在id并执行对应的操作
if (string.IsNullOrEmpty(txtId[i]) == false)
{
//如果有id的，执行更新操作
var tb = list.Where(d => d.Id == txtId[i].ConvertToInt()).FirstOrDefault();
XkSystem.Areas.Sys.Controllers.SysUserLogController.Insert("修改评价选项");
tb.No = txtNo[i].ConvertToInt();
tb.OptionName = txtName[i];
tb.tbQualityItem = qualityItem;
tb.OptionValue = txtValue[i].ConvertToDecimal();
}
else
{
//没有id的，执行插入操作
var tb = new Quality.Entity.tbQualityOption();
tb.No = txtNo[i].ConvertToInt();
tb.OptionName = txtName[i];
tb.tbQualityItem = qualityItem;
tb.OptionValue = txtValue[i].ConvertToDecimal();
db.Set <Quality.Entity.tbQualityOption>().Add(tb);
XkSystem.Areas.Sys.Controllers.SysUserLogController.Insert("添加评价内容");
}
}
return(true);
}
public ActionResult DownloadFolder(int id)
{
using (var db = new XkSystem.Models.DbContext())
{
var tb = (from t in db.Table <Disk.Entity.tbDiskFolder>()
where t.Id == id && t.tbSysUser.Id == Code.Common.UserId
select t).FirstOrDefault();
if (tb != null)
{
List <int> ids = new List <int>();
ids.Add(tb.Id);
List <Dto.DiskFolder.Info> folderDescendants = DiskFolderController.SelectDescendants(ids);
string strTempPathName = Path.GetTempPath() + Guid.NewGuid().ToString();
string strTempPath = strTempPathName + "/";
string zipFileName = strTempPathName + ".zip";
foreach (var folder in folderDescendants)
{
if (!Directory.Exists(strTempPath + folder.FolderPath))
{
Directory.CreateDirectory(strTempPath + folder.FolderPath);
}
}
List <Dto.DiskFile.Info> diskFileDescendants = DiskFileController.SelectDescendantsByFolder(ids);
string strFilesDiskPath = Server.MapPath("~/Files/Disk/");
foreach (var diskFile in diskFileDescendants)
{
FileInfo file = new FileInfo(strFilesDiskPath + diskFile.FileName);
file.CopyTo(strTempPath + diskFile.FolderPath + diskFile.FileTitle);
}
Code.ZipHelper.CreateZip(zipFileName, strTempPath + tb.DiskFolderName + "/");
Code.FileHelper.DeleteDirectory(strTempPath);
return(File(zipFileName, Code.Common.DownloadType, tb.DiskFolderName + ".zip"));
}
return(RedirectToAction("List"));
}
}
public ActionResult InputMultipleEdit(int id = 0)
{
using (var db = new XkSystem.Models.DbContext())
{
var vm = new Models.PerformDataDay.InputMultipleEdit();
var tbPerformItem = (from p in db.Table <Entity.tbPerformItem>()
where p.Id == vm.PerformItemId &&
p.IsSelect && p.IsMany
select p).FirstOrDefault();
if (tbPerformItem == null)
{
}
else
{
vm.PerformOptionList = PerformOptionController.SelectList(vm.PerformItemId);
}
if (id != 0)
{
var tb = (from p in db.Table <Entity.tbPerformData>()
where p.Id == id
select new Dto.PerformDataDay.InputMultipleEdit
{
Id = p.Id,
PerformItemName = p.tbPerformItem.PerformItemName,
StudentCode = p.tbStudent.StudentCode,
StudentName = p.tbStudent.StudentName,
Score = p.Score,
PerformOptionId = p.tbPerformOption == null ? 0 : p.tbPerformOption.Id
}).FirstOrDefault();
if (tb != null)
{
vm.PerformInputMultipleEdit = tb;
}
}
else
{
vm.PerformInputMultipleEdit.PerformItemName = db.Set <Entity.tbPerformItem>().Find(vm.PerformItemId).PerformItemName;
vm.PerformInputMultipleEdit.StudentName = db.Set <Student.Entity.tbStudent>().Find(vm.StudentId).StudentName;
}
return(View(vm));
}
}
public ActionResult Export(string fromDate, string toDate, string searchText = "")
{
using (var db = new XkSystem.Models.DbContext())
{
var file = System.IO.Path.GetTempFileName();
var fromTime = DateTime.Parse(fromDate);
var toTime = DateTime.Parse(toDate).AddDays(1);
var tb = (from p in db.Table <Sys.Entity.tbSysUserLog>()
.Include(d => d.tbSysUser)
where (p.ActionContent.Contains(searchText) || p.tbSysUser.UserCode.Contains(searchText) || p.tbSysUser.UserName.Contains(searchText)) &&
p.ActionDate >= fromTime &&
p.ActionDate < toTime
orderby p.ActionDate descending
select p).ToList();
var dt = new System.Data.DataTable();
dt.Columns.AddRange(new System.Data.DataColumn[]
{
new System.Data.DataColumn("操作内容"),
new System.Data.DataColumn("操作人员"),
new System.Data.DataColumn("操作Ip"),
new System.Data.DataColumn("操作时间")
});
foreach (var a in tb)
{
var dr = dt.NewRow();
dr["操作内容"] = a.ActionContent;
dr["操作人员"] = a.tbSysUser.UserName;
dr["操作Ip"] = a.ActionIp;
dr["操作时间"] = a.ActionDate.ToString(Code.Common.StringToDateTime);
dt.Rows.Add(dr);
}
Code.NpoiHelper.DataTableToExcel(file, dt);
if (string.IsNullOrEmpty(file) == false)
{
return(File(file, Code.Common.DownloadType, Code.Common.ExportByExcel));
}
else
{
return(View());
}
}
}
public ActionResult Info(Models.StudyApply.Info vm)
{
using (var db = new XkSystem.Models.DbContext())
{
var error = new List <string>();
if (error.Count == decimal.Zero)
{
if (vm.StudyApplyInfo.Id == 0)
{
var tb = new Study.Entity.tbStudyApply();
tb.Remark = vm.StudyApplyInfo.Remark;
tb.tbStudy = db.Set <Study.Entity.tbStudy>().Find(vm.StudyId);
tb.tbStudent = db.Table <Student.Entity.tbStudent>().Where(d => d.tbSysUser.Id == Code.Common.UserId).FirstOrDefault();
tb.InputDate = DateTime.Now;
db.Set <Study.Entity.tbStudyApply>().Add(tb);
if (db.SaveChanges() > 0)
{
XkSystem.Areas.Sys.Controllers.SysUserLogController.Insert("添加晚自习申请");
}
}
else
{
var tb = (from p in db.Table <Study.Entity.tbStudyApply>()
where p.Id == vm.StudyApplyInfo.Id
select p).FirstOrDefault();
if (tb != null)
{
tb.Remark = vm.StudyApplyInfo.Remark;
tb.tbStudy = db.Set <Study.Entity.tbStudy>().Find(vm.StudyId);
tb.tbStudent = db.Table <Student.Entity.tbStudent>().Where(d => d.tbSysUser.Id == Code.Common.UserId).FirstOrDefault();
if (db.SaveChanges() > 0)
{
XkSystem.Areas.Sys.Controllers.SysUserLogController.Insert("修改晚自习申请");
}
}
else
{
error.AddError(Resources.LocalizedText.MsgNotFound);
}
}
}
return(Code.MvcHelper.Post(error, Url.Action("List")));
}
}
public ActionResult List()
{
using (var db = new XkSystem.Models.DbContext())
{
var vm = new Models.ExamChange.List();
var tbStudent = from p in db.Table <Student.Entity.tbStudent>()
select p;
var student = (from p in tbStudent
where (p.StudentCode == vm.SearchText || p.StudentName == vm.SearchText)
select new
{
p.Id,
p.StudentCode,
p.StudentName
}).FirstOrDefault();
if (student != null)
{
vm.StudentId = student.Id;
var tb = from p in db.Table <Exam.Entity.tbExamMark>()
where p.tbExamCourse.IsDeleted == false && p.tbExamCourse.tbCourse.IsDeleted == false &&
p.tbStudent.Id == student.Id &&
p.tbExamCourse.tbExam.IsDeleted == false
select p;
vm.ExamMarkList = (from p in tb
select new Dto.ExamChange.List
{
Id = p.Id,
CourseId = p.tbExamCourse.tbCourse.Id,
StudentId = p.tbStudent.Id,
StudentCode = p.tbStudent.StudentCode,
StudentName = p.tbStudent.StudentName,
ExamName = p.tbExamCourse.tbExam.ExamName,
CourseName = p.tbExamCourse.tbCourse.CourseName,
AppraiseMark = p.AppraiseMark,
SegmentMark = p.SegmentMark,
TotalMark = p.TotalMark,
ExamLevelName = p.tbExamLevel.ExamLevelName,
}).ToList();
}
return(View(vm));
}
}
public ActionResult Edit(Models.ExamStatus.Edit vm)
{
using (var db = new XkSystem.Models.DbContext())
{
var error = new List <string>();
if (error.Count == decimal.Zero)
{
if (vm.ExamStatusEdit.Id == 0)
{
var tb = new Exam.Entity.tbExamStatus();
tb.No = vm.ExamStatusEdit.No == null?db.Table <Exam.Entity.tbExamStatus>().Select(d => d.No).DefaultIfEmpty(0).Max() + 1 : (int)vm.ExamStatusEdit.No;
tb.ExamStatusName = vm.ExamStatusEdit.ExamStatusName;
db.Set <Exam.Entity.tbExamStatus>().Add(tb);
if (db.SaveChanges() > 0)
{
XkSystem.Areas.Sys.Controllers.SysUserLogController.Insert("添加考生状态");
}
}
else
{
var tb = (from p in db.Table <Exam.Entity.tbExamStatus>()
where p.Id == vm.ExamStatusEdit.Id
select p).FirstOrDefault();
if (tb != null)
{
tb.No = vm.ExamStatusEdit.No == null?db.Table <Exam.Entity.tbExamStatus>().Select(d => d.No).DefaultIfEmpty(0).Max() + 1 : (int)vm.ExamStatusEdit.No;
tb.ExamStatusName = vm.ExamStatusEdit.ExamStatusName;
if (db.SaveChanges() > 0)
{
XkSystem.Areas.Sys.Controllers.SysUserLogController.Insert("修改考生状态");
}
}
else
{
error.AddError(Resources.LocalizedText.MsgNotFound);
}
}
}
return(Code.MvcHelper.Post(error));
}
}
public bool EditOrgSchedule(XkSystem.Models.DbContext db, Course.Entity.tbOrg Org, string orgSchedule)
{
//删除之前的数据
var delList = (from p in db.Table <Course.Entity.tbOrgSchedule>()
where p.tbOrg.Id == Org.Id
select p).ToList();
foreach (var a in delList)
{
a.IsDeleted = true;
}
var arr = orgSchedule.Split(new char[] { ',', '，' });
foreach (var v in arr)
{
var tb = new Course.Entity.tbOrgSchedule();
if (v.Contains("["))
{
var arr1 = v.Split(new char[] { '[', ']' });
var temp = arr1[0];
tb = new Course.Entity.tbOrgSchedule()
{
tbOrg = Org,
tbWeek = db.Table <Basis.Entity.tbWeek>().Where(d => temp.Contains(d.WeekName)).FirstOrDefault(),
tbPeriod = db.Table <Basis.Entity.tbPeriod>().Where(d => temp.Contains(d.PeriodName)).FirstOrDefault(),
ScheduleType = arr1[1].Contains("单") ? Code.EnumHelper.CourseScheduleType.Odd : Code.EnumHelper.CourseScheduleType.Dual
};
}
else
{
tb = new Course.Entity.tbOrgSchedule()
{
tbOrg = Org,
tbWeek = db.Table <Basis.Entity.tbWeek>().Where(d => v.Contains(d.WeekName)).FirstOrDefault(),
tbPeriod = db.Table <Basis.Entity.tbPeriod>().Where(d => v.Contains(d.PeriodName)).FirstOrDefault(),
ScheduleType = Code.EnumHelper.CourseScheduleType.All
};
}
db.Set <Course.Entity.tbOrgSchedule>().Add(tb);
}
return(true);
}
public static List <System.Web.Mvc.SelectListItem> GetOrgListByOrgTeacher()
{
using (var db = new XkSystem.Models.DbContext())
{
var tb = (from p in db.Table <Course.Entity.tbOrgTeacher>()
where p.tbOrg.IsDeleted == false &&
p.tbOrg.tbYear.IsDefault &&
p.tbOrg.tbCourse.IsDeleted == false &&
p.tbOrg.tbCourse.tbSubject.IsDeleted == false &&
p.tbTeacher.tbSysUser.Id == Code.Common.UserId
orderby p.tbOrg.No
select new System.Web.Mvc.SelectListItem
{
Text = p.tbOrg.OrgName,
Value = p.tbOrg.Id.ToString()
}).ToList();
return(tb);
}
}
public ActionResult Edit(Models.CourseGroup.Edit vm)
{
using (var db = new XkSystem.Models.DbContext())
{
var error = new List <string>();
if (error.Count == decimal.Zero)
{
if (db.Table <Course.Entity.tbCourseGroup>().Where(d => d.CourseGroupName == vm.CourseGroupEdit.CourseGroupName && d.Id != vm.CourseGroupEdit.Id).Any())
{
error.AddError("该课程分组已存在!");
}
else
{
if (vm.CourseGroupEdit.Id == 0)
{
var tb = new Course.Entity.tbCourseGroup();
tb.No = vm.CourseGroupEdit.No == null?db.Table <Course.Entity.tbCourseGroup>().Select(d => d.No).DefaultIfEmpty(0).Max() + 1 : (int)vm.CourseGroupEdit.No;
tb.CourseGroupName = vm.CourseGroupEdit.CourseGroupName;
db.Set <Course.Entity.tbCourseGroup>().Add(tb);
if (db.SaveChanges() > 0)
{
XkSystem.Areas.Sys.Controllers.SysUserLogController.Insert("添加了课程分组");
}
}
else
{
var tb = db.Set <Course.Entity.tbCourseGroup>().Find(vm.CourseGroupEdit.Id);
tb.No = vm.CourseGroupEdit.No == null?db.Table <Course.Entity.tbCourseGroup>().Select(d => d.No).DefaultIfEmpty(0).Max() + 1 : (int)vm.CourseGroupEdit.No;
tb.CourseGroupName = vm.CourseGroupEdit.CourseGroupName;
if (db.SaveChanges() > 0)
{
XkSystem.Areas.Sys.Controllers.SysUserLogController.Insert("修改了课程分组");
}
}
}
}
return(Code.MvcHelper.Post());
}
}
public ActionResult List()
{
using (var db = new XkSystem.Models.DbContext())
{
var vm = new Models.CourseGroup.List();
var tb = db.Table <Course.Entity.tbCourseGroup>();
if (!string.IsNullOrEmpty(vm.SearchText))
{
tb = tb.Where(d => d.CourseGroupName.Contains(vm.SearchText));
}
vm.CourseGroupList = (from p in tb
orderby p.No
select p).ToList();
return(View(vm));
}
}
public ActionResult Edit(Models.SysShortcut.Edit vm)
{
using (var db = new XkSystem.Models.DbContext())
{
var error = new List <string>();
var power = (from p in db.Table <Sys.Entity.tbSysShortcut>()
where p.tbSysUser.Id == Code.Common.UserId
select p).ToList();
foreach (var a in power)
{
a.IsDeleted = true;
}
if (!String.IsNullOrEmpty(vm.Power))
{
var menuIds = vm.Power.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries).Select(d => d.ConvertToInt());
var tbMenuList = (from p in db.Table <Sys.Entity.tbSysMenu>()
where menuIds.Contains(p.Id) &&
string.IsNullOrEmpty(p.MenuUrl) == false
select p).ToList();
if (tbMenuList.Count() > 8)
{
error.AddError("常用功能不能超过8项！");
}
else
{
foreach (var menu in tbMenuList)
{
var temp = new Sys.Entity.tbSysShortcut();
temp.tbSysMenu = menu;
temp.tbSysUser = db.Set <Sys.Entity.tbSysUser>().Find(Code.Common.UserId);
db.Set <Sys.Entity.tbSysShortcut>().Add(temp);
}
}
}
if (db.SaveChanges() > 0)
{
XkSystem.Areas.Sys.Controllers.SysUserLogController.Insert("添加常用功能");
}
return(Code.MvcHelper.Post(error, "", "保存成功!"));
}
}
public ActionResult List()
{
using (var db = new XkSystem.Models.DbContext())
{
var vm = new Models.ExamStatus.List();
var tb = from p in db.Table <Exam.Entity.tbExamStatus>()
select p;
if (string.IsNullOrEmpty(vm.SearchText) == false)
{
tb = tb.Where(d => d.ExamStatusName.Contains(vm.SearchText));
}
vm.ExamStatusList = (from p in tb
orderby p.No
select p).ToList();
return(View(vm));
}
}
public static Models.PaperSize.Edit Edit(int id = 0)
{
using (var db = new XkSystem.Models.DbContext())
{
var vm = new Models.PaperSize.Edit();
if (id != 0)
{
var tb = (from p in db.Table <Dict.Entity.tbDictPaperSize>()
where p.Id == id
select p).FirstOrDefault();
if (tb != null)
{
vm.PaperSizeEdit = tb;
}
}
return(vm);
}
}
public static List <Dto.OrgSchedule.Info> GetAll(string teacherId, int yearId)
{
using (var db = new XkSystem.Models.DbContext())
{
var orgTeacher = db.Table <Course.Entity.tbOrgTeacher>().Where(d => d.tbTeacher.TeacherCode == teacherId).Include(d => d.tbOrg).FirstOrDefault();
var tb = (from p in db.Table <Course.Entity.tbOrgSchedule>()
where p.tbOrg.tbYear.Id == yearId &&
p.tbOrg.IsDeleted == false
select new Dto.OrgSchedule.Info
{
RoomId = p.tbOrg.tbRoom != null ? p.tbOrg.tbRoom.Id : 0,
WeekId = p.tbWeek.Id,
ClassId = (p.tbOrg.IsClass && p.tbOrg.tbClass != null) ? p.tbOrg.tbClass.Id : 0,
PeriodId = p.tbPeriod.Id,
Subject = p.tbOrg.tbCourse.tbSubject.SubjectName
}).ToList();
return(tb);
}
}
public ActionResult Info(int id)
{
using (var db = new XkSystem.Models.DbContext())
{
var vm = new Models.PerformComment.Info();
vm.PerformCommentInfo = (from p in db.Table <Perform.Entity.tbPerformComment>()
where p.Id == id
select new Dto.PerformComment.Info
{
Id = p.Id,
StudentCode = p.tbStudent.StudentCode,
StudentName = p.tbStudent.StudentName,
Comment = p.Comment,
TeacherName = p.tbSysUser.UserName,
InputDate = p.InputDate
}).FirstOrDefault();
return(View(vm));
}
}
