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