public StuVisitInfoRule() { // // TODO: 在此处添加构造函数逻辑 // stuVisit = new StuVisit(); }
public int DoAbsenceInfoInsert(StuVisit stuVisit) { doAbsenceInfoInsertCommand = "InsertAbsenceInfo"; dbCommandWrapper = dbVisit.GetStoredProcCommandWrapper(doAbsenceInfoInsertCommand); dbCommandWrapper.AddInParameter("@stuNumber",DbType.Int16,stuVisit.StuNumber); dbCommandWrapper.AddInParameter("@absReason",DbType.String,stuVisit.AbsReason); dbCommandWrapper.AddInParameter("@visitMode",DbType.String,stuVisit.VisitMode); dbCommandWrapper.AddInParameter("@visitDate",DbType.DateTime,stuVisit.VisitDate); dbCommandWrapper.AddInParameter("@visitTeaSign",DbType.String,stuVisit.VisitTeaSign); dbCommandWrapper.AddInParameter("@absRemark",DbType.String,stuVisit.AbsRemark); dbCommandWrapper.AddOutParameter("@rtnState",DbType.Int16,1); dbVisit.ExecuteNonQuery(dbCommandWrapper); return Convert.ToInt16(dbCommandWrapper.GetParameterValue("@rtnState")); }
public void DoAbsenceInfoUpdate(StuVisit stuVisit) { doAbsenceInfoUpdateCommand = "UpdateAbsenceInfo"; dbCommandWrapper = dbVisit.GetStoredProcCommandWrapper(doAbsenceInfoUpdateCommand); dbCommandWrapper.AddInParameter("@stuNumber",DbType.Int16,stuVisit.StuNumber); dbCommandWrapper.AddInParameter("@absReason",DbType.String,stuVisit.AbsReason); dbCommandWrapper.AddInParameter("@visitMode",DbType.String,stuVisit.VisitMode); dbCommandWrapper.AddInParameter("@visitDate",DbType.DateTime,stuVisit.VisitDate); dbCommandWrapper.AddInParameter("@visitTeaSign",DbType.String,stuVisit.VisitTeaSign); dbCommandWrapper.AddInParameter("@absRemark",DbType.String,stuVisit.AbsRemark); dbCommandWrapper.AddInParameter("@getAbsReason",DbType.String,stuVisit.GetAbsReason); dbCommandWrapper.AddInParameter("@getVisitMode",DbType.String,stuVisit.GetVisitMode); dbCommandWrapper.AddInParameter("@getVisitDate",DbType.DateTime,stuVisit.GetVisitDate); dbCommandWrapper.AddInParameter("@getVisitTeaSign",DbType.String,stuVisit.GetVisitTeaSign); // dbCommandWrapper.AddInParameter("@getAbsRemark",DbType.String,stuVisit.GetAbsRemark); dbVisit.ExecuteNonQuery(dbCommandWrapper); }