public JsonResult Add(tbl_paper paper)
{
OperateResultModel orm = new OperateResultModel();
orm.message = ValidInput(paper);
if (string.IsNullOrEmpty(orm.message))
{
UserModel um = SessionUser;
DateTime dtnow = DateTime.Now;
paper.createdate = dtnow;
paper.creater = um.UserNo;
paper.editdate = dtnow;
paper.editer = um.UserNo;
Bank bank = new Bank();
paper.paperid = bank.GetNewPaperId();
orm = bank.InsertPaper(paper);
orm.rows = paper;
}
else
{
orm.success = false;
}
return(JsonResultHelper.ConvertToJsonResult(orm));
}
/// <summary>
/// 验证输入的试卷信息是否正常
/// </summary>
/// <param name="paper">实体</param>
/// <returns></returns>
private string ValidInput(tbl_paper paper)
{
string msg = string.Empty;
if (string.IsNullOrEmpty(paper.papername))
{
msg += "请输入试卷名称";
}
return(msg);
}
public PartialViewResult Edit(int?paperid)
{
tbl_paper paper = null;
if (paperid != null)
{
Bank bank = new Bank();
paper = bank.QueryPaper(paperid.Value);
}
return(PartialView(paper));
}
public JsonResult Update(tbl_paper paper)
{
OperateResultModel orm = new OperateResultModel();
orm.message = ValidInput(paper);
if (string.IsNullOrEmpty(orm.message))
{
paper.editdate = DateTime.Now;
paper.editer = SessionUser.UserNo;
Bank bank = new Bank();
orm = bank.UpdatePaper(paper);
orm.rows = paper;
}
else
{
orm.success = false;
}
return(JsonResultHelper.ConvertToJsonResult(orm));
}
/// <summary>
/// 更新试卷信息
/// </summary>
/// <param name="paper">试卷实体</param>
/// <returns></returns>
public OperateResultModel UpdatePaper(tbl_paper paper)
{
TblPaperDal dal = new TblPaperDal();
return(dal.Update(paper));
}
/// <summary>
/// 插入试卷信息
/// </summary>
/// <param name="paper">试卷实体</param>
/// <returns></returns>
public OperateResultModel InsertPaper(tbl_paper paper)
{
TblPaperDal dal = new TblPaperDal();
return(dal.Insert(paper));
}
/// <summary>
/// 获得练习内容
/// </summary>
/// <param name="type">类型</param>
/// <param name="xueyh">学员号</param>
/// <param name="xingming">姓名</param>
/// <param name="source">
/// 来源
/// 1：网页
/// 2：APP
/// 3：小程序
/// </param>
/// <param name="kemu">
/// 科目
/// KM1：科目一
/// KM4：科目四
/// KMA：客车
/// KMB：货车
/// </param>
/// <returns></returns>
public JsonResult bank(string type, string xueyh, string xingming, string source, string kemu, string paperid)
{
try
{
JiaxInfo jiax = new JiaxInfo();
tbl_xueyuan xueyuan = jiax.QueryXueyuan(xueyh);
if (xueyuan != null)
{
xingming = xueyuan.xingming;
}
Bank bll = new Bank();
OperateResultModel orm = null;
string papername = "";
type = Server.UrlDecode(type);
switch (type)
{
case "顺序练习":
case "1-1": //所有数据-顺序
papername = "顺序练习";
orm = bll.QueryBanks(null, null, null, null, true, kemu, null);
break;
case "随机练习":
case "1-2": //所有数据-随机
papername = "随机练习";
orm = bll.QueryBanks(null, null, null, null, false, kemu, null);
break;
case "判断题":
case "1-3": //判断题-顺序
papername = "判断题";
orm = bll.QueryBanks(null, "判断题", null, null, true, kemu, null);
break;
case "1-4": //判断题-随机
orm = bll.QueryBanks(null, "判断题", null, null, false, kemu, null);
break;
case "单选题":
case "1-5": //单选题-顺序
papername = "单选题";
orm = bll.QueryBanks(null, "单选题", null, null, true, kemu, null);
break;
case "1-6": //单选题-随机
orm = bll.QueryBanks(null, "单选题", null, null, false, kemu, null);
break;
case "多选题":
case "1-7": //多选题-顺序
papername = "多选题";
orm = bll.QueryBanks(null, "多选题", null, null, true, kemu, null);
break;
case "1-8": //多选题-随机
orm = bll.QueryBanks(null, "多选题", null, null, false, kemu, null);
break;
case "图片题":
case "1-9": //图片题-顺序
papername = "图片题";
orm = bll.QueryBanks(null, null, true, null, true, kemu, null);
break;
case "1-10": //图片题-随机
orm = bll.QueryBanks(null, null, true, null, false, kemu, null);
break;
case "动画题":
case "1-11": //动画题-顺序
papername = "动画题";
orm = bll.QueryBanks(null, null, null, true, true, kemu, null);
break;
case "1-12": //动画题-随机
orm = bll.QueryBanks(null, null, null, true, false, kemu, null);
break;
case "未做题练习":
case "1-13": //未做题练习
papername = "未做题练习";
orm = bll.QueryBanksForNotStudy(xueyh);
break;
case "模拟考试":
case "随机试卷":
case "2-1":
orm = bll.QueryRandomPaper(kemu);
papername = "随机试卷";
break;
case "重点试卷":
case "2-2":
orm = bll.QueryBanksOfPaper(Convert.ToInt32(paperid));
tbl_paper papermodel = bll.QueryPaper(Convert.ToInt32(paperid));
papername = papermodel == null ? "重点试卷" : papermodel.papername;
break;
default:
throw new Exception("题目类型选择错误");
}
CommonBll commonbll = new CommonBll();
string testno = commonbll.GetSerialNo("Record", "");
bool istest = type.IndexOf("考试") > 0 || type.IndexOf("试卷") > 0;
//把查询到的记录插入用户练习记录
tbl_test_records record = new tbl_test_records()
{
createdate = DateTime.Now,
creater = xueyh,
xingming = xingming,
oknum = 0,
source = source,
kemu = kemu,
testno = testno,
projecttype = papername,
testtype = istest ? "考试" : "练习",
totalnum = orm.total,
xueyh = xueyh
};
Study study = new Study();
var tblist = (List <tbl_bank>)orm.rows;
OperateResultModel ormtest = new OperateResultModel();
ormtest.success = true;
if (tblist != null && tblist.Count() != 0)
{
ormtest = study.InsertTestRecord(record);
}
if (ormtest.success)
{
orm.message = testno;
return(JsonResultHelper.ConvertToJsonResult(orm));
}
else
{
return(JsonResultHelper.ConvertToJsonResult(ormtest));
}
}
catch (Exception ex)
{
return(Json(new
{
success = false,
message = ex.Message,
total = 0
}));
}
}
