public void GetRealtimeBackInfo_Graphic(string getGrade,string getClass,DateTime getDate,ref int getHasGone,ref int getHasnotGone,ref int getStuNumbers)
{
getRealtimeBackInfo_GraphicCommand = "GetRealtimeBackStat_Graphic";
dbCommandWrapper = dbRealtime.GetStoredProcCommandWrapper(getRealtimeBackInfo_GraphicCommand);
dbCommandWrapper.AddInParameter("@getGrade",DbType.String,getGrade);
dbCommandWrapper.AddInParameter("@getClass",DbType.String,getClass);
dbCommandWrapper.AddInParameter("@getDate",DbType.DateTime,getDate);
dbCommandWrapper.AddOutParameter("@getHasGone",DbType.Int32,4);
dbCommandWrapper.AddOutParameter("@getHasnotGone",DbType.Int32,4);
dbCommandWrapper.AddOutParameter("@getStuNumbers",DbType.Int32,4);
dbRealtime.ExecuteNonQuery(dbCommandWrapper);
getHasGone = Convert.ToInt32(dbCommandWrapper.GetParameterValue("@getHasGone"));
getHasnotGone = Convert.ToInt32(dbCommandWrapper.GetParameterValue("@getHasnotGone"));
getStuNumbers = Convert.ToInt32(dbCommandWrapper.GetParameterValue("@getStuNumbers"));
}
public void DoAttendCalcForClass(string getGrade,string getClass,string getBegTime,
string getEndTime,string getState)
{
doStuAttendCalcForClassCommand = "Student_AttendCalcForClass";
dbCommandWrapper = dbAttendCalc.GetStoredProcCommandWrapper(doStuAttendCalcForClassCommand);
dbCommandWrapper.AddInParameter("@setGrade",DbType.String,getGrade);
dbCommandWrapper.AddInParameter("@setClass",DbType.String,getClass);
dbCommandWrapper.AddInParameter("@setBegTime",DbType.String,getBegTime);
dbCommandWrapper.AddInParameter("@setEndTime",DbType.String,getEndTime);
dbCommandWrapper.AddInParameter("@setState",DbType.String,getState);
dbCommandWrapper.AddOutParameter("@getStateAmount",DbType.Int32,4);
dbCommandWrapper.AddOutParameter("@getAllStateAmount",DbType.Int32,4);
dbCommandWrapper.AddOutParameter("@getStuAmount",DbType.Int32,4);
dbAttendCalc.ExecuteDataSet(dbCommandWrapper);
StateAmount = Convert.ToInt32(dbCommandWrapper.GetParameterValue("@getStateAmount"));
StuAmount = Convert.ToInt32(dbCommandWrapper.GetParameterValue("@getStuAmount"));
AllStateAmount = Convert.ToInt32(dbCommandWrapper.GetParameterValue("@getAllStateAmount"));
}
private int FillTeaNumbers(string getWeekDay,string getDutyID,string getDept)
{
getTeaNumbersCommand = "GetTeaNumberInDuty";
dbCommandWrapper = dbRealtimeInfo.GetStoredProcCommandWrapper(getTeaNumbersCommand);
dbCommandWrapper.AddInParameter("@getDept",DbType.String,getDept);
dbCommandWrapper.AddInParameter("@getWeekDay",DbType.String,getWeekDay);
dbCommandWrapper.AddInParameter("@getDutyID",DbType.String,getDutyID);
dbCommandWrapper.AddOutParameter("@getTeaNumbers",DbType.Int32,4);
dbRealtimeInfo.ExecuteNonQuery(dbCommandWrapper);
return Convert.ToInt32(dbCommandWrapper.GetParameterValue("@getTeaNumbers"));
}
private DataSet FillAbsentDaysInMonth(int getNumber,DateTime getDate)
{
getAbsentDaysInMonthCommand = "GetAbsentDaysInMonth";
dbCommandWrapper = dbVisit.GetStoredProcCommandWrapper(getAbsentDaysInMonthCommand);
dbCommandWrapper.AddInParameter("@getStuNumber",DbType.Int16,getNumber);
dbCommandWrapper.AddInParameter("@getDate",DbType.DateTime,getDate);
dbCommandWrapper.AddOutParameter("getAbsSum",DbType.Int32,4);
DataSet dsAbsentDaysInMonth = dbVisit.ExecuteDataSet(dbCommandWrapper);
GetAbsSum = Convert.ToInt32(dbCommandWrapper.GetParameterValue("@getAbsSum"));
return dsAbsentDaysInMonth;
}
public void GetRealtimeMorningInfo_Graphic(string getGrade,string getClass,DateTime getDate,ref int getHealth,
ref int getWatch,ref int getSick,ref int getAbsence,ref int getStuNumbers)
{
getRealtimeMorningInfo_GraphicCommand = "GetRealtimeMorningStat_Graphic";
dbCommandWrapper = dbRealtime.GetStoredProcCommandWrapper(getRealtimeMorningInfo_GraphicCommand);
dbCommandWrapper.AddInParameter("@getGrade",DbType.String,getGrade);
dbCommandWrapper.AddInParameter("@getClass",DbType.String,getClass);
dbCommandWrapper.AddInParameter("@getDate",DbType.DateTime,getDate);
dbCommandWrapper.AddOutParameter("@getHealth",DbType.Int32,4);
dbCommandWrapper.AddOutParameter("@getWatch",DbType.Int32,4);
dbCommandWrapper.AddOutParameter("@getSick",DbType.Int32,4);
dbCommandWrapper.AddOutParameter("@getAbsence",DbType.Int32,4);
dbCommandWrapper.AddOutParameter("@getStuNumbers",DbType.Int32,4);
dbRealtime.ExecuteNonQuery(dbCommandWrapper);
getHealth = Convert.ToInt32(dbCommandWrapper.GetParameterValue("@getHealth"));
getWatch = Convert.ToInt32(dbCommandWrapper.GetParameterValue("@getWatch"));
getSick = Convert.ToInt32(dbCommandWrapper.GetParameterValue("@getSick"));
getAbsence = Convert.ToInt32(dbCommandWrapper.GetParameterValue("@getAbsence"));
getStuNumbers = Convert.ToInt32(dbCommandWrapper.GetParameterValue("@getStuNumbers"));
}
public int InsertMachine(string getAddr,string getType,string getVol)
{
insertMachineCommand = "InsertMachine_ForAdmin";
dbCommandWrapper = dbForBatchCreate.GetStoredProcCommandWrapper(insertMachineCommand);
dbCommandWrapper.AddInParameter("@getAddr",DbType.Int32,Convert.ToInt32(getAddr));
dbCommandWrapper.AddInParameter("@getType",DbType.Int32,Convert.ToInt32(getType));
dbCommandWrapper.AddInParameter("@getVol",DbType.Int32,Convert.ToInt32(getVol));
dbCommandWrapper.AddOutParameter("@rowsAffected",DbType.Int32,4);
dbForBatchCreate.ExecuteNonQuery(dbCommandWrapper);
return Convert.ToInt32(dbCommandWrapper.GetParameterValue("@rowsAffected"));
}
public int InsertNewAddCardInfo(string getNumber,string getCardNumber,string getHolder,DateTime getSendDate)
{
insertNewAddCardInfoCommand = "InsertNewAddCard_BatchCreate";
dbCommandWrapper = dbForBatchCreate.GetStoredProcCommandWrapper(insertNewAddCardInfoCommand);
dbCommandWrapper.AddInParameter("@getNumber",DbType.String,getNumber);
dbCommandWrapper.AddInParameter("@getCardNumber",DbType.String,getCardNumber);
dbCommandWrapper.AddInParameter("@getHolder",DbType.String,getHolder);
dbCommandWrapper.AddInParameter("@getSendDate",DbType.DateTime,getSendDate);
dbCommandWrapper.AddOutParameter("@rowsAffected",DbType.Int32,4);
dbForBatchCreate.ExecuteNonQuery(dbCommandWrapper);
return Convert.ToInt32(dbCommandWrapper.GetParameterValue("@rowsAffected"));
}
public int DeleteMachineInfo(int getMachineAddr,int getMachineType)
{
deleteMachineInfoCommand = "DeleteMachineInfo_BatchCreate";
dbCommandWrapper = dbForBatchCreate.GetStoredProcCommandWrapper(deleteMachineInfoCommand);
dbCommandWrapper.AddInParameter("@getMachineAddr",DbType.Int32,getMachineAddr);
dbCommandWrapper.AddInParameter("@getMachineType",DbType.Int32,getMachineType);
dbCommandWrapper.AddOutParameter("@rowsAffected",DbType.Int32,4);
dbForBatchCreate.ExecuteNonQuery(dbCommandWrapper);
return Convert.ToInt32(dbCommandWrapper.GetParameterValue("@rowsAffected"));
}
public int InsertStuInfo(Option option)
{
insertStuInfoCommand = "InsertStuInfo_BatchCreate";
dbCommandWrapper = dbForBatchCreate.GetStoredProcCommandWrapper(insertStuInfoCommand);
dbCommandWrapper.AddInParameter("@getID",DbType.String,option.StuID);
dbCommandWrapper.AddInParameter("@getGrade",DbType.String,option.StuGrade);
dbCommandWrapper.AddInParameter("@getGradeName",DbType.String,option.GradeName);
dbCommandWrapper.AddInParameter("@getGradeRemark",DbType.String,option.GradeRemark);
dbCommandWrapper.AddInParameter("@getClass",DbType.String,option.StuClass);
dbCommandWrapper.AddInParameter("@getClassName",DbType.String,option.ClassName);
dbCommandWrapper.AddInParameter("@getName",DbType.String,option.StuName);
dbCommandWrapper.AddInParameter("@getNumber",DbType.String,option.StuNumber);
dbCommandWrapper.AddInParameter("@getBirthday",DbType.DateTime,option.StuBirthday);
dbCommandWrapper.AddInParameter("@getGender",DbType.String,option.StuGender);
dbCommandWrapper.AddInParameter("@getType",DbType.String,option.StuEntryStatus);
dbCommandWrapper.AddInParameter("@getEmail",DbType.String,option.StuEmail);
dbCommandWrapper.AddInParameter("@getPhone",DbType.String,option.StuPhone);
dbCommandWrapper.AddInParameter("@getAddr",DbType.String,option.StuFamilyAddr);
dbCommandWrapper.AddInParameter("@getZipCode",DbType.String,option.StuZipCode);
dbCommandWrapper.AddInParameter("@getEnterDate",DbType.DateTime,option.StuEnterDate);
dbCommandWrapper.AddOutParameter("@rowsAffected",DbType.Int32,4);
dbForBatchCreate.ExecuteNonQuery(dbCommandWrapper);
return Convert.ToInt32(dbCommandWrapper.GetParameterValue("@rowsAffected"));
}
public int UpdateMed(HealthMgmt healthMgmt)
{
updateMedCommand = "UpdateMed";
dbCommandWrapper = dbHealth.GetStoredProcCommandWrapper(updateMedCommand);
dbCommandWrapper.AddInParameter("@getMedName",DbType.String,healthMgmt.MedName);
dbCommandWrapper.AddInParameter("@getMedType",DbType.String,healthMgmt.MedType);
dbCommandWrapper.AddInParameter("@getMedTake",DbType.String,healthMgmt.MedTake);
dbCommandWrapper.AddInParameter("@getTaketimes",DbType.Int32,healthMgmt.Taketimes);
dbCommandWrapper.AddInParameter("@getMedModifyID",DbType.Int32,healthMgmt.MedModifyID);
dbCommandWrapper.AddOutParameter("@rowsAffected",DbType.Int32,32);
dbHealth.ExecuteNonQuery(dbCommandWrapper);
return Convert.ToInt32(dbCommandWrapper.GetParameterValue("@rowsAffected"));
}
public int SaveMorningWatch(HealthMgmt healthMgmt,bool isWatchState )
{
saveMorningWatchCommand = "SaveMorningWatch";
dbCommandWrapper = dbHealth.GetStoredProcCommandWrapper(saveMorningWatchCommand);
dbCommandWrapper.AddInParameter("@getNumber",DbType.String,healthMgmt.WatchNumber);
dbCommandWrapper.AddInParameter("@getName",DbType.String,healthMgmt.WatchName);
dbCommandWrapper.AddInParameter("@getHeat",DbType.String,healthMgmt.WatchHeat);
dbCommandWrapper.AddInParameter("@getSpirit",DbType.String,healthMgmt.WatchSpirit);
dbCommandWrapper.AddInParameter("@getMouth",DbType.String,healthMgmt.WatchMouth);
dbCommandWrapper.AddInParameter("@getSkin",DbType.String,healthMgmt.WatchSkin);
dbCommandWrapper.AddInParameter("@getOState",DbType.String,healthMgmt.WatchOState);
dbCommandWrapper.AddInParameter("@getTreat",DbType.String,healthMgmt.WatchTreat);
dbCommandWrapper.AddInParameter("@getDate",DbType.String,healthMgmt.WatchDate);
dbCommandWrapper.AddInParameter("@getDailyMovement",DbType.String,healthMgmt.DailyMovement);
dbCommandWrapper.AddInParameter("@getDailySpirit",DbType.String,healthMgmt.DailySpirit);
dbCommandWrapper.AddInParameter("@getDailyAppetite",DbType.String,healthMgmt.DailyAppetite);
dbCommandWrapper.AddInParameter("@getDailySleep",DbType.String,healthMgmt.DailySleep);
dbCommandWrapper.AddInParameter("@getDailyStool",DbType.String,healthMgmt.DailyStool);
dbCommandWrapper.AddInParameter("@getDailyCough",DbType.String,healthMgmt.DailyCough);
dbCommandWrapper.AddInParameter("@getDailyElse",DbType.String,healthMgmt.DailyElse);
dbCommandWrapper.AddInParameter("@getDailyCtrlAct",DbType.Boolean,healthMgmt.DailyCtrlAct);
dbCommandWrapper.AddInParameter("@getDailyLife",DbType.Boolean,healthMgmt.DailyLife);
dbCommandWrapper.AddInParameter("@getDailySeafood",DbType.Boolean,healthMgmt.DailySeafood);
dbCommandWrapper.AddInParameter("@getDailyHeat",DbType.Boolean,healthMgmt.DailyHeat);
dbCommandWrapper.AddInParameter("@getTeacherSign",DbType.String,healthMgmt.TeacherSign);
dbCommandWrapper.AddInParameter("@isWatchState",DbType.Boolean,isWatchState);
dbCommandWrapper.AddOutParameter("@rowsAffected",DbType.Int32,32);
dbHealth.ExecuteNonQuery(dbCommandWrapper);
return Convert.ToInt32(dbCommandWrapper.GetParameterValue("@rowsAffected"));
}
public int DeleteClassInfo(string getOriClassNumber,string getOriGradeNumber)
{
deleteClassInfoCommand = "DeleteClassInfo_BatchCreate";
dbCommandWrapper = dbForBatchCreate.GetStoredProcCommandWrapper(deleteClassInfoCommand);
dbCommandWrapper.AddInParameter("@getOriClassNumber",DbType.String,getOriClassNumber);
dbCommandWrapper.AddInParameter("@getOriGradeNumber",DbType.String,getOriGradeNumber);
dbCommandWrapper.AddOutParameter("@rowsAffected",DbType.Int32,4);
dbForBatchCreate.ExecuteNonQuery(dbCommandWrapper);
return Convert.ToInt32(dbCommandWrapper.GetParameterValue("@rowsAffected"));
}
private int InternalInsertNewStudentForGradeChange(string stuName,int stuGrade,int stuClass,string stuType)
{
insertNewStudentForGradeChangeCommand = "InsertNewStudentForGradeChange";
dbCommandWrapper = dbForBatchCreate.GetStoredProcCommandWrapper(insertNewStudentForGradeChangeCommand);
dbCommandWrapper.AddInParameter("@stuId",DbType.String,Guid.NewGuid().ToString());
dbCommandWrapper.AddInParameter("@stuName",DbType.String,stuName);
dbCommandWrapper.AddInParameter("@stuGrade",DbType.Int32,stuGrade);
dbCommandWrapper.AddInParameter("@stuClass",DbType.Int32,stuClass);
dbCommandWrapper.AddInParameter("@stuType",DbType.String,stuType);
dbCommandWrapper.AddOutParameter("@rowsAffected",DbType.Int32,4);
dbForBatchCreate.ExecuteNonQuery(dbCommandWrapper);
return Convert.ToInt32(dbCommandWrapper.GetParameterValue("@rowsAffected"));
}
private int FillDiagResult(HealthMgmt healthMgmt)
{
saveDiagResultCommand = "SaveDiagResult";
dbCommandWrapper = dbHealth.GetStoredProcCommandWrapper(saveDiagResultCommand);
dbCommandWrapper.AddInParameter("@getNumber",DbType.String,healthMgmt.StuNumber);
dbCommandWrapper.AddInParameter("@getDiagInfo",DbType.String,healthMgmt.DiagInfo);
dbCommandWrapper.AddInParameter("@getUpperSym",DbType.String,healthMgmt.UpperSym);
dbCommandWrapper.AddInParameter("@getLungSym",DbType.String,healthMgmt.LungSym);
dbCommandWrapper.AddInParameter("@getThroatSym",DbType.String,healthMgmt.ThroatSym);
dbCommandWrapper.AddInParameter("@getEnteronSym",DbType.String,healthMgmt.EnteronSym);
dbCommandWrapper.AddInParameter("@getAbdomenSym",DbType.String,healthMgmt.AbdomenSym);
dbCommandWrapper.AddInParameter("@getSkinSym",DbType.String,healthMgmt.SkinSym);
dbCommandWrapper.AddInParameter("@getFacialSym",DbType.String,healthMgmt.FacialSym);
dbCommandWrapper.AddInParameter("@getElse",DbType.String,healthMgmt.Else);
dbCommandWrapper.AddInParameter("@getMedInfo",DbType.String,healthMgmt.MedInfo);
dbCommandWrapper.AddInParameter("@getTeaSign",DbType.String,healthMgmt.TeacherSign);
dbCommandWrapper.AddInParameter("@getDate",DbType.DateTime,healthMgmt.RegisterDate);
dbCommandWrapper.AddOutParameter("@rowsAffected",DbType.Int32,32);
dbHealth.ExecuteNonQuery(dbCommandWrapper);
return Convert.ToInt32(dbCommandWrapper.GetParameterValue("@rowsAffected"));
}
public int UpdateGradeInfo(string getOriNumber,string getChNumber,string getChName,string getChRemark)
{
updateGradeInfoCommand = "UpdateGradeInfo_BatchCreate";
dbCommandWrapper = dbForBatchCreate.GetStoredProcCommandWrapper(updateGradeInfoCommand);
dbCommandWrapper.AddInParameter("@getOriNumber",DbType.String,getOriNumber);
dbCommandWrapper.AddInParameter("@getChName",DbType.String,getChName);
dbCommandWrapper.AddInParameter("@getChNumber",DbType.String,getChNumber);
dbCommandWrapper.AddInParameter("@getChRemark",DbType.String,getChRemark);
dbCommandWrapper.AddOutParameter("@rowsAffected",DbType.Int32,4);
dbForBatchCreate.ExecuteNonQuery(dbCommandWrapper);
return Convert.ToInt32(dbCommandWrapper.GetParameterValue("@rowsAffected"));
}
public int DeleteDoseRec(int getRecID,string teaSign)
{
deleteDoseRecCommand = "DeleteDoseRec";
dbCommandWrapper = dbHealth.GetStoredProcCommandWrapper(deleteDoseRecCommand);
dbCommandWrapper.AddInParameter("@getRecID",DbType.Int32,getRecID);
dbCommandWrapper.AddInParameter("@teaSign",DbType.String,teaSign);
dbCommandWrapper.AddOutParameter("@rowsAffected",DbType.Int32,32);
dbHealth.ExecuteNonQuery(dbCommandWrapper);
return Convert.ToInt32(dbCommandWrapper.GetParameterValue("@rowsAffected"));
}
public int insertDoseRec(int getDiaID,string getMedName,string getMedTake,string takeDate,string medRule,string teaSign)
{
insertDoseRecCommad = "InsertDoseRec";
dbCommandWrapper = dbHealth.GetStoredProcCommandWrapper(insertDoseRecCommad);
dbCommandWrapper.AddInParameter("@getDiaID",DbType.Int32,getDiaID);
dbCommandWrapper.AddInParameter("@medName",DbType.String,getMedName);
dbCommandWrapper.AddInParameter("@medTake",DbType.String,getMedTake);
dbCommandWrapper.AddInParameter("@takeDate",DbType.String,takeDate);
dbCommandWrapper.AddInParameter("@medRule",DbType.String,medRule);
dbCommandWrapper.AddInParameter("@teaSign",DbType.String,teaSign);
dbCommandWrapper.AddOutParameter("@rowsAffected",DbType.Int32,32);
dbHealth.ExecuteNonQuery(dbCommandWrapper);
return Convert.ToInt32(dbCommandWrapper.GetParameterValue("@rowsAffected"));
}
public int DeleteMed(string getMedName,string getMedCategory)
{
deleteMedCommand = "DeleteMed";
dbCommandWrapper = dbHealth.GetStoredProcCommandWrapper(deleteMedCommand);
dbCommandWrapper.AddInParameter("@getMedName",DbType.String,getMedName);
dbCommandWrapper.AddInParameter("@getMedCategory",DbType.String,getMedCategory);
dbCommandWrapper.AddOutParameter("@rowsAffected",DbType.Int32,32);
dbHealth.ExecuteNonQuery(dbCommandWrapper);
return Convert.ToInt32(dbCommandWrapper.GetParameterValue("@rowsAffected"));
}
private int InternalUpdateClassNameByNumber(string getGradeNumber,string getClassNumber,string getClassName)
{
updateClassNameByNumberCommand = "UpdateClassNameByNumber";
dbCommandWrapper = dbForBatchCreate.GetStoredProcCommandWrapper(updateClassNameByNumberCommand);
dbCommandWrapper.AddInParameter("@gradeNumber",DbType.String,getGradeNumber);
dbCommandWrapper.AddInParameter("@classNumber",DbType.String,getClassNumber);
dbCommandWrapper.AddInParameter("@className",DbType.String,getClassName);
dbCommandWrapper.AddOutParameter("@rowsAffected",DbType.Int32,4);
dbForBatchCreate.ExecuteNonQuery(dbCommandWrapper);
return Convert.ToInt32(dbCommandWrapper.GetParameterValue("@rowsAffected"));
}
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"));
}
private int InternalUpdateStudentForGradeChange(string stuName,int stuGrade,int stuClass,string type)
{
updateStudentForGradeChangeCommand = "UpdateStudentForGradeChange";
dbCommandWrapper = dbForBatchCreate.GetStoredProcCommandWrapper(updateStudentForGradeChangeCommand);
dbCommandWrapper.AddInParameter("@stuName",DbType.String,stuName);
dbCommandWrapper.AddInParameter("@gradeNumber",DbType.Int32,stuGrade);
dbCommandWrapper.AddInParameter("@classNumber",DbType.Int32,stuClass);
dbCommandWrapper.AddInParameter("@type",DbType.String,type);
dbCommandWrapper.AddOutParameter("@rowsAffected",DbType.Int32,4);
dbForBatchCreate.ExecuteNonQuery(dbCommandWrapper);
return Convert.ToInt32(dbCommandWrapper.GetParameterValue("@rowsAffected"));
}
public int UpdateHealthAnaly(HealthMgmt healthMgmt)
{
updateHealthAnalyCommand = "UpdateHealthAnaly";
dbCommandWrapper = dbHealth.GetStoredProcCommandWrapper(updateHealthAnalyCommand);
dbCommandWrapper.AddInParameter("@getStuID",DbType.String,healthMgmt.StuID);
dbCommandWrapper.AddInParameter("@getDate",DbType.String,healthMgmt.Date);
dbCommandWrapper.AddInParameter("@getAge",DbType.String,healthMgmt.Age);
dbCommandWrapper.AddInParameter("@getHeight",DbType.Double,healthMgmt.Height);
dbCommandWrapper.AddInParameter("@getHeightAnaly",DbType.String,healthMgmt.HeightAnaly.Trim());
dbCommandWrapper.AddInParameter("@getWeight",DbType.Double,healthMgmt.Weight);
dbCommandWrapper.AddInParameter("@getWeightAnaly",DbType.String,healthMgmt.WeightAnaly.Trim());
dbCommandWrapper.AddInParameter("@getWHO",DbType.String,healthMgmt.WHO.Trim());
dbCommandWrapper.AddInParameter("@getNut",DbType.String,healthMgmt.Nut.Trim());
dbCommandWrapper.AddInParameter("@getRemark",DbType.String,healthMgmt.Remark);
dbCommandWrapper.AddInParameter("@getX", DbType.String, healthMgmt.X);
dbCommandWrapper.AddInParameter("@getStd",DbType.Boolean,healthMgmt.Std);
dbCommandWrapper.AddOutParameter("@rowsAffected",DbType.Int32,16);
dbHealth.ExecuteNonQuery(dbCommandWrapper);
return Convert.ToInt32(dbCommandWrapper.GetParameterValue("@rowsAffected"));
}
public int UpdateTeaInfo(string getID,string getName,string getNumber,string getDept,string getDuty,string getGender)
{
updateTeaInfoCommand = "UpdateTeaInfo_BatchCreate";
dbCommandWrapper = dbForBatchCreate.GetStoredProcCommandWrapper(updateTeaInfoCommand);
dbCommandWrapper.AddInParameter("@getID",DbType.String,getID);
dbCommandWrapper.AddInParameter("@getNumber",DbType.String,getNumber);
dbCommandWrapper.AddInParameter("@getName",DbType.String,getName);
dbCommandWrapper.AddInParameter("@getDept",DbType.String,getDept);
dbCommandWrapper.AddInParameter("@getDuty",DbType.String,@getDuty);
dbCommandWrapper.AddInParameter("@getGender",DbType.String,@getGender);
dbCommandWrapper.AddOutParameter("@rowsAffected",DbType.Int32,4);
dbForBatchCreate.ExecuteNonQuery(dbCommandWrapper);
return Convert.ToInt32(dbCommandWrapper.GetParameterValue("@rowsAffected"));
}
public int DeleteWholeDayWatch(string getNumber,string getDate)
{
deleteWholeDayWatchCommand = "DeleteWholeDayWatch";
dbCommandWrapper = dbHealth.GetStoredProcCommandWrapper(deleteWholeDayWatchCommand);
dbCommandWrapper.AddInParameter("@getNumber",DbType.String,getNumber);
dbCommandWrapper.AddInParameter("@getDate",DbType.String,getDate);
dbCommandWrapper.AddOutParameter("@rowsAffected",DbType.Int32,32);
dbHealth.ExecuteNonQuery(dbCommandWrapper);
return Convert.ToInt32(dbCommandWrapper.GetParameterValue("@rowsAffected"));
}
private void FillTeaWorkingNumbers(string getDutyID,ref int getTeaWorkingOnTime,ref int getTeaWorkingnotOnTime,string getDept,DateTime getDate)
{
getTeaWorkingNumbersCommand = "GetTeaWorkingNumbers";
dbCommandWrapper = dbRealtimeInfo.GetStoredProcCommandWrapper(getTeaWorkingNumbersCommand);
dbCommandWrapper.AddInParameter("@getDept",DbType.String,getDept);
dbCommandWrapper.AddInParameter("@getDutyID",DbType.String,getDutyID);
dbCommandWrapper.AddInParameter("@getDate",DbType.DateTime,getDate);
dbCommandWrapper.AddOutParameter("@getTeaWorkingOnTime",DbType.Int32,4);
dbCommandWrapper.AddOutParameter("@getTeaWorkingnotOnTime",DbType.Int32,4);
dbRealtimeInfo.ExecuteNonQuery(dbCommandWrapper);
getTeaWorkingOnTime += Convert.ToInt32(dbCommandWrapper.GetParameterValue("@getTeaWorkingOnTime"));
getTeaWorkingnotOnTime += Convert.ToInt32(dbCommandWrapper.GetParameterValue("@getTeaWorkingnotOnTime"));
}
public int UpdateNchsHealthAnalysis(HealthMgmt healthMgmt)
{
updateNchsHealthAnalysisCommand = "hm_nchs_updateHealthAnalysis";
dbCommandWrapper = dbHealth.GetStoredProcCommandWrapper(updateNchsHealthAnalysisCommand);
dbCommandWrapper.AddInParameter("@getStuID",DbType.String,healthMgmt.StuID);
dbCommandWrapper.AddInParameter("@getDate",DbType.String,healthMgmt.Date);
dbCommandWrapper.AddInParameter("@getAge",DbType.String,healthMgmt.Age);
dbCommandWrapper.AddInParameter("@getHeight",DbType.Double,healthMgmt.Height);
dbCommandWrapper.AddInParameter("@getNchsHeight",DbType.String,healthMgmt.HeightAnaly.Trim());
dbCommandWrapper.AddInParameter("@getWeight",DbType.Double,healthMgmt.Weight);
dbCommandWrapper.AddInParameter("@getNchsWeight",DbType.String,healthMgmt.WeightAnaly.Trim());
dbCommandWrapper.AddInParameter("@getNchsObesity",DbType.String,healthMgmt.WHO.Trim());
dbCommandWrapper.AddInParameter("@getNchsNut",DbType.String,healthMgmt.Nut.Trim());
dbCommandWrapper.AddInParameter("@getNchsUnderWeight",DbType.String,healthMgmt.NchsUnderWeight.Trim());
dbCommandWrapper.AddInParameter("@getNchsStunting",DbType.String,healthMgmt.NchsStunting.Trim());
dbCommandWrapper.AddInParameter("@getNchsWasting",DbType.String,healthMgmt.NchsWasting.Trim());
dbCommandWrapper.AddInParameter("@getRemark",DbType.String,healthMgmt.Remark);
dbCommandWrapper.AddOutParameter("@rowsAffected",DbType.Int32,16);
dbHealth.ExecuteNonQuery(dbCommandWrapper);
return Convert.ToInt32(dbCommandWrapper.GetParameterValue("@rowsAffected"));
}
public int UpdateTeaCardInfo(string getID,string getNumber,int getSeq,DateTime getDate)
{
updateTeaCardInfoCommand = "UpdateTeaCardInfo_BatchCreate";
dbCommandWrapper = dbForBatchCreate.GetStoredProcCommandWrapper(updateTeaCardInfoCommand);
dbCommandWrapper.AddInParameter("@getID",DbType.String,getID);
dbCommandWrapper.AddInParameter("@getNumber",DbType.String,getNumber);
dbCommandWrapper.AddInParameter("@getSeq",DbType.Int32,getSeq);
dbCommandWrapper.AddInParameter("@getDate",DbType.DateTime,getDate);
dbCommandWrapper.AddOutParameter("@rowsAffected",DbType.Int32,4);
dbForBatchCreate.ExecuteNonQuery(dbCommandWrapper);
return Convert.ToInt32(dbCommandWrapper.GetParameterValue("@rowsAffected"));
}
public int DeleteHealthAnaly(HealthMgmt healthMgmt)
{
deleteHealthAnalyCommand = "DeleteHealthAnaly";
dbCommandWrapper = dbHealth.GetStoredProcCommandWrapper(deleteHealthAnalyCommand);
dbCommandWrapper.AddInParameter("@getStuID",DbType.String,healthMgmt.StuID);
dbCommandWrapper.AddInParameter("@getDate",DbType.String,healthMgmt.Date);
dbCommandWrapper.AddOutParameter("@rowsAffected",DbType.Int32,16);
dbHealth.ExecuteNonQuery(dbCommandWrapper);
return Convert.ToInt32(dbCommandWrapper.GetParameterValue("@rowsAffected"));
}
public bool HasCard(string stuID,string stuNumber)
{
hasCardCommand = "HasCard_Student";
dbCommandWrapper = dbAccess.GetStoredProcCommandWrapper(hasCardCommand);
dbCommandWrapper.AddInParameter("@stuID",DbType.String,stuID);
dbCommandWrapper.AddInParameter("@stuNumber",DbType.String,stuNumber);
dbCommandWrapper.AddOutParameter("@hasCard",DbType.Boolean,1);
dbAccess.ExecuteNonQuery(dbCommandWrapper);
return Convert.ToBoolean(dbCommandWrapper.GetParameterValue("@hasCard"));
}
public int DeleteTeaCardInfo(string getID,int getSeq)
{
deleteTeaCardInfoCommand = "DeleteTeaCardInfo_BatchCreate";
dbCommandWrapper = dbForBatchCreate.GetStoredProcCommandWrapper(deleteTeaCardInfoCommand);
dbCommandWrapper.AddInParameter("@getID",DbType.String,getID);
dbCommandWrapper.AddInParameter("@getSeq",DbType.Int32,getSeq);
dbCommandWrapper.AddOutParameter("@rowsAffected",DbType.Int32,4);
dbForBatchCreate.ExecuteNonQuery(dbCommandWrapper);
return Convert.ToInt32(dbCommandWrapper.GetParameterValue("@rowsAffected"));
}