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