public void add(string schoolNo, string dName) { SqlConnection cn = null; SqlTransaction tc = null; try { cn = DbHelperSQL.getConnection(); tc = DbHelperSQL.startTransaction(cn); IList<QueryModel> qmList = new List<QueryModel>(); qmList.Add(MakeUtil.getQueryModel("SchoolNo", "'", SqlWhere.WhereOperator.Equal, schoolNo)); qmList.Add(MakeUtil.getQueryModel("D_Name", "'", SqlWhere.WhereOperator.Equal, dName)); qmList.Add(MakeUtil.getQueryModel("1", "", SqlWhere.WhereOperator.Equal, "1 AND DateDiff(dd, HappenDate,getdate())=0")); if (!teacherdaychecksubmitrecordDal.getModelList(cn, tc, qmList, -1).Any()) { var teacherdaychecksubmitrecord = new TeacherDayCheckSubmitRecordModel { D_Name = dName, SchoolNo = schoolNo, IsSubmit = true }; //执行新增写进数据库 teacherdaychecksubmitrecordDal.add(cn, tc, teacherdaychecksubmitrecord); } DbHelperSQL.commitTransaction(tc); } catch (Exception dalEx) { DbHelperSQL.rollBackTransaction(tc); throw new MakeException(ExpSort.数据库, dalEx.Message); } finally { DbHelperSQL.closeConnection(cn); } }
public void add(TeacherDayCheckSubmitRecordModel teacherdaychecksubmitrecord) { SqlConnection cn = null; SqlTransaction tc = null; try { cn = DbHelperSQL.getConnection(); tc = DbHelperSQL.startTransaction(cn); //执行新增写进数据库 teacherdaychecksubmitrecordDal.add(cn, tc, teacherdaychecksubmitrecord); DbHelperSQL.commitTransaction(tc); } catch (Exception dalEx) { DbHelperSQL.rollBackTransaction(tc); throw new MakeException(ExpSort.数据库, dalEx.Message); } finally { DbHelperSQL.closeConnection(cn); } }
public bool update(SqlConnection cn, SqlTransaction tc, TeacherDayCheckSubmitRecordModel model) { return DbHelperSQL.updateModel<TeacherDayCheckSubmitRecordModel>(model, "TeacherDayCheckSubmitRecord", "Evenid", model.Evenid.ToString(), "'", cn, tc); }
public bool add(SqlConnection cn, SqlTransaction tc, TeacherDayCheckSubmitRecordModel model) { return DbHelperSQL.insertModel<TeacherDayCheckSubmitRecordModel>(model, "TeacherDayCheckSubmitRecord", cn, tc); }