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