public FileResult SignUpBankExcel(string ExamType, string ExamSubject, string ExamMajor, string ExamLevel, string ExamContent)
{
var model = new ExamBankModel();
if (ExamType == "undefined")
{
ExamType = "";
}
if (ExamSubject == "undefined")
{
ExamSubject = "";
}
if (ExamMajor == "undefined")
{
ExamMajor = "";
}
if (ExamLevel == "undefined")
{
ExamLevel = "";
}
if (ExamContent == "undefined")
{
ExamContent = "";
}
var ms = model.SignUpBank(ExamType, ExamSubject, ExamMajor, ExamLevel, ExamContent);
return(File(ms, "application/vnd.ms-excel", ExamType + ExamSubject + "题库" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls"));
}
//Excel上传题库
public JsonResult Upload_TEL_MASTER(HttpPostedFileBase file)
{
string filepath = "";
var LBank = new List <ExamBank>();
if (file != null)
{
string path = Server.MapPath(_AttachmentUploadDirectory_temp);//设定上传的文件路径
if (!Directory.Exists(path))
{
Directory.CreateDirectory(path);
}
String gcode = System.Guid.NewGuid().ToString("N");
string filenName = '\\' + gcode + file.FileName;
filepath = path + filenName;
file.SaveAs(filepath);//上传路径
}
var model = new ExamBankModel();
model.UploadBank(filepath);
return(Json(new { Result = model.Result, model.LExamBank }, JsonRequestBehavior.AllowGet));
}
public ActionResult SaveBankInfo(ExamBankModel model)
{
var username = this.UserNameContext;
model.SaveBankInfo(username);
return(Json(new { model.LExamBank }, JsonRequestBehavior.AllowGet));
}
public ActionResult GetTopic(int ID)
{
var model = new ExamBankModel();
model.GetTopic(ID);
return(Json(new { VExamBank = model.VExamBank }, JsonRequestBehavior.AllowGet));
}
public ActionResult GetBankInfo(SearchBnakData VSearchBnakData)
{
var model = new ExamBankModel();
model.GetBankInfo(VSearchBnakData);
return(Json(new { LExamBank = model.LExamBank, LExamType = model.LExamType, BankRemark = model.BankRemark }, JsonRequestBehavior.AllowGet));
}
public ActionResult DeleteBankInfo(SearchBnakData VSearchBnakData)
{
var model = new ExamBankModel();
var count = model.DeleteBankInfo(VSearchBnakData);
var result = count + " ";
return(Json(new { Result = result, LExamBank = model.LExamBank, BankRemark = model.BankRemark }));
}
public ActionResult MaintainExamBank()
{
var model = new ExamBankModel();
return(View());
}
