public int 题_判断_修改(byte[] 题, byte[] 答案)
{
var question = new db.题.题(题);
var answer = new db.题.题_判断_答案(答案);
using (var tran = SqlHelper.NewTransaction())
{
try
{
// 预处理
question.更新时间 = DateTime.Now;
// 更新 题
var affected = question.Update();
if (affected < 1)
{
tran.Rollback();
return(-1);
}
// 预处理
answer.题编号 = question.题编号;
// 更新 答案
affected = answer.Update();
if (affected < 1)
{
tran.Rollback();
return(-1);
}
tran.Commit();
return(1);
}
catch (Exception ex)
{
tran.Rollback();
return(-1);
}
}
}
public int 题_判断_插入(byte[] 题, byte[] 答案)
{
var question = new db.题.题(题);
var answer = new db.题.题_判断_答案(答案);
using (var tran = SqlHelper.NewTransaction())
{
try
{
// 预处理
question.更新时间 = DateTime.Now;
// 插入 题
var affected = question.Insert(fillCols: o => o.题编号);
if (affected < 1)
{
tran.Rollback();
return(-1);
}
// 预处理
answer.题编号 = question.题编号;
// 插入答案
affected = answer.Insert(isFillAfterInsert: false);
if (affected < 1)
{
tran.Rollback();
return(-1);
}
tran.Commit();
return(1);
}
catch (Exception ex)
{
tran.Rollback();
return(-1);
}
}
}
