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)); } }