/// <summary>
/// 删除场地
/// </summary>
/// <param name="Ids"></param>
/// <returns></returns>
public JsonResult Delete(string[] Ids)
{
int result = new BLL.T_Base_MajorClass().Delete(Ids);
if (result <= 0)
{
return(Json("删除失败"));
}
else
{
return(Json("删除" + result + "记录"));
}
}
/// <summary>
/// 保存添加的专业班级信息
/// </summary>
/// <param name="AddMajorClassName"></param>
/// <param name="AddArchitectureId"></param>
/// <returns></returns>
public JsonResult AddSaveMajorClass(string AddMajorClassName, int AddArchitectureId)
{
Model.T_Base_MajorClass majorClass = new Model.T_Base_MajorClass();
majorClass.MajorClassName = AddMajorClassName;
majorClass.ArchitectureId = AddArchitectureId;
int result = new BLL.T_Base_MajorClass().AddSaveMajorClass(majorClass);
if (result == 1)
{
return(Json("添加成功"));
}
else
{
return(Json("添加失败"));
}
}
/// <summary>
/// 统计班级下学生参加讲座总分导出Excel
/// </summary>
/// <param name="MajorClassId"></param>
/// <returns></returns>
public FileResult SaveMajorClassExcel(int MajorClassId)
{
List <Model.T_Base_User> list = new BLL.T_Base_MajorClass().GetAllUser(MajorClassId);
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.MajorClassName + "参加讲座情况.xls"));
}
/// <summary>
/// 保存修改后的信息
/// </summary>
/// <param name="AddMajorClassName"></param>
/// <param name="AddPeopleNum"></param>
/// <param name="AddArchitectureId"></param>
/// <returns></returns>
public JsonResult EditSaveMajorClass(int EditId, string EditMajorClassName, int EditArchitectureId)
{
Model.T_Base_MajorClass majorClass = new Model.T_Base_MajorClass();
majorClass.Id = EditId;
majorClass.MajorClassName = EditMajorClassName;
majorClass.ArchitectureId = EditArchitectureId;
majorClass.ArchitectureId = EditArchitectureId;
int result = new BLL.T_Base_MajorClass().EditSaveMajorClass(majorClass);
if (result == 1)
{
return(Json("修改成功"));
}
else
{
return(Json("修改失败"));
}
}