public StuVisitInfoRule()
{
//
// TODO: 在此处添加构造函数逻辑
//
stuVisit = new StuVisit();
}
public void DoAbsenceInfoDelete(StuVisit stuVisit)
{
doAbsenceInfoDeleteCommand = "DeleteAbsenceInfo";
dbCommandWrapper = dbVisit.GetStoredProcCommandWrapper(doAbsenceInfoDeleteCommand);
dbCommandWrapper.AddInParameter("@stuNumber", DbType.Int16, stuVisit.StuNumber);
dbCommandWrapper.AddInParameter("@absReason", DbType.String, stuVisit.GetAbsReason);
dbCommandWrapper.AddInParameter("@visitMode", DbType.String, stuVisit.GetVisitMode);
dbCommandWrapper.AddInParameter("@visitDate", DbType.DateTime, stuVisit.GetVisitDate);
// dbCommandWrapper.AddInParameter("@visitTeaSign",DbType.String,stuVisit.GetVisitTeaSign);
// dbCommandWrapper.AddInParameter("@absRemark",DbType.String,stuVisit.GetAbsRemark);
dbVisit.ExecuteNonQuery(dbCommandWrapper);
}
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")));
}
