public ActionResult ShowCourse(int ID, int?pagenum, int?pagesize) { BLL.JiaoXueJiHuaBiaoBLL jiaoXueJiHuaBiaoBLL = new BLL.JiaoXueJiHuaBiaoBLL(); int PageIndex = pagenum ?? 1; int PageSize = pagesize ?? 10; List <StageCourse> lists = jiaoXueJiHuaBiaoBLL.StageCoursesList(ID, PageIndex, PageSize, out int Total); var JsonDdata = new { errorNo = "0", errorInfo = "查询数据成功", results = new { data = new { total = Total, list = lists, } } }; return(Json(JsonDdata, JsonRequestBehavior.AllowGet)); }
/// <summary> /// Add教学计划 /// </summary> /// <param name="jiHuaBiao">计划表</param> /// <param name="JiaoXueJieDuan">阶段ID</param> /// <param name="filePath">文件</param> /// <returns></returns> public ActionResult AddAction(JiaoXueJiHuaBiao jiHuaBiao, int JiaoXueJieDuan, string filePath) { if (!string.IsNullOrEmpty(filePath)) { try { string path = AppDomain.CurrentDomain.BaseDirectory + @"/upload"; //保存文件的真实文件名,和全路径; string savepath = Server.MapPath("~/upload/" + filePath);//上传后的文件名 //判断是否存在此路径 if (!Directory.Exists(path)) { //创建文件夹 Directory.CreateDirectory(path); } //创建一个WorkBook对象; HSSFWorkbook hSSFWorkbook; using (FileStream filel = new FileStream(savepath, FileMode.Open, FileAccess.Read)) { hSSFWorkbook = new HSSFWorkbook(filel); } //获取工作簿的第一个工作表 var sheep = hSSFWorkbook.GetSheetAt(0); //获取所有的行 System.Collections.IEnumerator rows = sheep.GetRowEnumerator(); //获取标题行 var headerRow = sheep.GetRow(0); int cellCount = headerRow.LastCellNum; List <Excele> exceles = new List <Excele>(); for (int i = (sheep.FirstRowNum + 2); i < sheep.LastRowNum; i++) { var row = sheep.GetRow(i); Excele excele2 = new Excele { //第一行下标为1 KCM = (row.GetCell(0).ToString()), //第二列下标为1 KCID = row.GetCell(1).ToString(), ZJID = row.GetCell(2).ToString(), ZJM = row.GetCell(3).ToString(), Count = Convert.ToInt32(row.GetCell(4).ToString()), KCXH = i - 1 }; //把对象加入到集合 exceles.Add(excele2); } jiHuaBiao.JiHuaBianHaoJiBanBen = jiHuaBiao.JiHuaBianHaoJiBanBen + "_" + JiaoXueJieDuan; jiHuaBiao.ShenHeRen = jiHuaBiao.ShenHeRen + "_" + filePath; BLL.JiaoXueJiHuaBiaoBLL jiaoXueJi = new BLL.JiaoXueJiHuaBiaoBLL(); bool error = jiaoXueJi.AddJiaoXueJihua(exceles, jiHuaBiao, JiaoXueJieDuan); if (error) { return(Json(new { errorNo = "0", errorInfo = "导入教学计划成功" })); } else { return(Json(new { errorNo = "1", errorInfo = "导入教学计划失败" })); } } catch (Exception ex) { return(Json(new { errorNo = "1", errorInfo = ex.Message })); throw ex; } } else { return(Json(new { errorNo = "1", errorInfo = "无上传文件,操作错误" }, JsonRequestBehavior.AllowGet)); } }