/// <summary>
/// 根据id返填题
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public QuestionBankinherit UpdateById(int id)
{
SqlSugarClient sugarClient = Educationcontext.GetClient();
QuestionBankinherit questionBankinherit = sugarClient.SqlQueryable <QuestionBankinherit>("select q.*,o.AnswerA,o.AnswerB,o.AnswerC,o.AnswerD,o.AnswerE,t.ExamType from QuestionBank q join `Option` o on q.Id = o.QuestionBankId join TextType t on q.TypeOfExam = t.ID where q.Id = " + id).First();
return(questionBankinherit);
}
/// <summary>
/// 单条添加题
/// </summary>
/// <param name="questionBank"></param>
/// <returns></returns>
public int ADD(QuestionBankinherit questionBankinherit)
{
try
{
//添加到题库
QuestionBank questionBank = new QuestionBank();
questionBank.Subject = questionBankinherit.Subject;
questionBank.Answer = questionBankinherit.Answer;
questionBank.Photo = questionBankinherit.Photo;
questionBank.TypeOfExam = questionBankinherit.TypeOfExam;
questionBank.Enable = questionBankinherit.Enable;
SqlSugarClient sugarClient = Educationcontext.GetClient();
var resultquestionBank = QuestionBankDB.Insert(questionBank);
//获取最后一个Id
questionBank = sugarClient.SqlQueryable <QuestionBank>("select id from QuestionBank order by id DESC limit 1").First();
var resultQuestionBankId = questionBank.Id;
//添加到选项
Option option = new Option();
option.QuestionBankId = resultQuestionBankId;
option.AnswerA = questionBankinherit.AnswerA;
option.AnswerB = questionBankinherit.AnswerB;
option.AnswerC = questionBankinherit.AnswerC;
option.AnswerD = questionBankinherit.AnswerD;
option.AnswerE = questionBankinherit.AnswerE;
var resultoption = OptionDB.Insert(option);
return(1);
}
catch (Exception ex)
{
//return ex.Message;
return(0);
}
}
/// <summary>
/// 修改题库的题
/// </summary>
/// <param name="questionBank"></param>
/// <returns></returns>
public int Update(QuestionBankinherit questionBankinherit)
{
SqlSugarClient sugarClient = Educationcontext.GetClient();
//修改题库
QuestionBank questionBank = new QuestionBank();
questionBank.Subject = questionBankinherit.Subject;
questionBank.Answer = questionBankinherit.Answer;
questionBank.Photo = questionBankinherit.Photo;
questionBank.TypeOfExam = questionBankinherit.TypeOfExam;
questionBank.Enable = questionBankinherit.Enable;
questionBank.Id = questionBankinherit.Id;
var questionBankId = questionBankinherit.Id;
var resultquestionBank = sugarClient.Updateable <QuestionBank>(questionBank).ExecuteCommand();
if (resultquestionBank != 0)
{
//修改选项
Option option = sugarClient.SqlQueryable <Option>("select * from `Option` where QuestionBankId = " + questionBankinherit.Id).First();
option.AnswerA = questionBankinherit.AnswerA;
option.AnswerB = questionBankinherit.AnswerB;
option.AnswerC = questionBankinherit.AnswerC;
option.AnswerD = questionBankinherit.AnswerD;
option.AnswerE = questionBankinherit.AnswerE;
var resultoption = sugarClient.Updateable <Option>(option).ExecuteCommand();
if (resultoption != 0)
{
return(1);
}
}
return(0);
}
/// <summary>
/// 添加数据
/// </summary>
/// <param name="questionBank"></param>
/// <returns></returns>
public IActionResult ADDQuestionBank(QuestionBankinherit questionBankinherit)
{
#region
long size = 0;
var files = Request.Form.Files;
foreach (var file in files)
{
var fileName = ContentDispositionHeaderValue
.Parse(file.ContentDisposition)
.FileName
.Trim('"');
fileName = _hostingEnvironment.WebRootPath + $@"\{fileName}";
size += file.Length;
using (FileStream fs = System.IO.File.Create(fileName))
{
file.CopyTo(fs);
fs.Flush();
}
questionBankinherit.Photo = fileName;
}
#endregion
var result = WebApiHelper.GetApiResult("post", "QuestionBank", "ADD", questionBankinherit);
BadRequest("添加成功!");
return(Redirect("/QuestionBank/QuestionsManagement"));
}
/// <summary>
/// 批量添加题库
/// </summary>
/// <param name="file"></param>
public IActionResult ADDQuestionBankList(IFormFile formFile)
{
#region 导入
string sWebRootFolder = _hostingEnvironment.WebRootPath;
string sFileName = $"{Guid.NewGuid()}.xlsx";
FileInfo file = new FileInfo(Path.Combine(sWebRootFolder, sFileName));
try
{
using (FileStream fs = new FileStream(file.ToString(), FileMode.Create))
{
formFile.CopyTo(fs);
fs.Flush();
}
using (ExcelPackage package = new ExcelPackage(file))
{
var questionBankinherits = new List <QuestionBankinherit>();
ExcelWorksheet worksheet = package.Workbook.Worksheets[1];
int rowCount = worksheet.Dimension.Rows;
int ColCount = worksheet.Dimension.Columns;
for (int row = 1 + 1; row <= rowCount; row++)
{
QuestionBankinherit questionBankinherit = new QuestionBankinherit();
questionBankinherit.Subject = worksheet.Cells[row, 1].Value.ToString();
questionBankinherit.TypeOfExam = Convert.ToInt32(worksheet.Cells[row, 2].Value);
questionBankinherit.AnswerA = worksheet.Cells[row, 3].Value.ToString();
questionBankinherit.AnswerB = worksheet.Cells[row, 4].Value.ToString();
var AnswerC = worksheet.Cells[row, 5].Value;
if (AnswerC == null)
{
AnswerC = "";
}
questionBankinherit.AnswerC = AnswerC.ToString();
var AnswerD = worksheet.Cells[row, 6].Value;
if (AnswerD == null)
{
AnswerD = "";
}
questionBankinherit.AnswerD = AnswerD.ToString();
var AnswerE = worksheet.Cells[row, 7].Value;
if (AnswerE == null)
{
AnswerE = "";
}
questionBankinherit.AnswerE = AnswerE.ToString();
questionBankinherit.Answer = worksheet.Cells[row, 8].Value.ToString();
questionBankinherit.Enable = Convert.ToInt32(worksheet.Cells[row, 9].Value.ToString());
questionBankinherits.Add(questionBankinherit);
}
var result = WebApiHelper.GetApiResult("post", "QuestionBank", "ADDList", questionBankinherits);
return(Redirect("/QuestionBank/QuestionsManagement"));
}
}
catch (Exception ex)
{
return(Redirect("/QuestionBank/QuestionsManagement"));
}
#endregion
}
public int Update(QuestionBankinherit questionBankinherit)
{
var result = _questionBankServices.Update(questionBankinherit);
return(result);
}
public int ADD(QuestionBankinherit questionBankinherit)
{
var result = _questionBankServices.ADD(questionBankinherit);
return(result);
}
