/// <summary> /// 删除场地 /// </summary> /// <param name="Ids"></param> /// <returns></returns> public JsonResult Delete(string[] Ids) { int result = new BLL.T_Base_Architecture().Delete(Ids); if (result <= 0) { return(Json("删除失败")); } else { return(Json("删除" + result + "记录")); } }
/// <summary> /// 保存新增建筑信息 /// </summary> /// <param name="Architecture"></param> /// <returns></returns> public JsonResult AddSaveArchitecture(string AddArchitectureName, int AddIsCollege) { Model.T_Base_Architecture architecture = new Model.T_Base_Architecture(); architecture.ArchitectureName = AddArchitectureName; architecture.IsCollege = AddIsCollege; int result = new BLL.T_Base_Architecture().AddSaveArchitecture(architecture); if (result == 1) { return(Json("添加成功")); } else { return(Json("添加失败")); } }
/// <summary> /// 统计学院下学生参加讲座总分导出Excel /// </summary> /// <param name="ArchitectureId"></param> /// <returns></returns> public FileResult SaveArchitectureExcel(int ArchitectureId) { List <Model.T_Base_User> list = new BLL.T_Base_Architecture().GetAllUser(ArchitectureId); HSSFWorkbook book = new HSSFWorkbook(); //创建Excel文件对象 ISheet sheet = book.CreateSheet(); //创建一个sheet页 IRow row1 = sheet.CreateRow(0); row1.CreateCell(0).SetCellValue("学号"); row1.CreateCell(1).SetCellValue("姓名"); row1.CreateCell(2).SetCellValue("性别"); row1.CreateCell(3).SetCellValue("联系方式"); row1.CreateCell(4).SetCellValue("讲座总分"); row1.CreateCell(5).SetCellValue("班级"); row1.CreateCell(6).SetCellValue("学院"); for (int i = 0; i < list.Count; i++) { IRow row = sheet.CreateRow(i + 1); row.CreateCell(0).SetCellValue(list[i].Num); row.CreateCell(1).SetCellValue(list[i].Name); if (list[i].Sex == 0) { row.CreateCell(2).SetCellValue("女"); } else if (list[i].Sex == 1) { row.CreateCell(2).SetCellValue("男"); } row.CreateCell(3).SetCellValue(list[i].PhoneNum); row.CreateCell(4).SetCellValue(new BLL.Statistic().GetScore(list[i].Num)); row.CreateCell(5).SetCellValue(list[i].MajorClass.MajorClassName); row.CreateCell(6).SetCellValue(list[i].MajorClass.Architecture.ArchitectureName); } sheet.SetColumnWidth(0, 15 * 256); sheet.SetColumnWidth(1, 15 * 256); sheet.SetColumnWidth(2, 8 * 256); sheet.SetColumnWidth(3, 15 * 256); sheet.SetColumnWidth(4, 8 * 256); sheet.SetColumnWidth(5, 20 * 256); sheet.SetColumnWidth(6, 30 * 256); MemoryStream ms = new MemoryStream(); book.Write(ms); ms.Seek(0, SeekOrigin.Begin); return(File(ms, "application/vnd.ms-excel", list[0].MajorClass.Architecture.ArchitectureName + "参加讲座情况.xls")); }
/// <summary> /// 保存修改后建筑的信息 /// </summary> /// <returns></returns> public JsonResult EditSaveArchitecture(int EditId, string EditArchitectureName, int EditIsCollege) { Model.T_Base_Architecture architecture = new Model.T_Base_Architecture(); architecture.Id = EditId; architecture.ArchitectureName = EditArchitectureName; architecture.IsCollege = EditIsCollege; int result = new BLL.T_Base_Architecture().EditSaveArchitecture(architecture); if (result == 1) { return(Json("修改成功")); } else { return(Json("修改失败")); } }