private DataSet FillGradeData(string gradeName,string gradeNumber)
{
getGradeInfoCommand = "GetGradeList";
dbCommandWrapper = dbAccess.GetStoredProcCommandWrapper(getGradeInfoCommand);
dbCommandWrapper.AddInParameter("@GradeName",DbType.String,gradeName);
dbCommandWrapper.AddInParameter("@GradeNumber",DbType.String,gradeNumber);
return dbAccess.ExecuteDataSet(dbCommandWrapper);
}
private DataSet Fill2DaysAbs(string getGrade,string getClass,DateTime getDate)
{
get2DaysAbsCommand = "Get2DaysAbsence";
dbCommandWrapper = dbVisit.GetStoredProcCommandWrapper(get2DaysAbsCommand);
dbCommandWrapper.AddInParameter("@stuGrade",DbType.String,getGrade);
dbCommandWrapper.AddInParameter("@stuClass",DbType.String,getClass);
dbCommandWrapper.AddInParameter("@getDate",DbType.DateTime,getDate);
return dbVisit.ExecuteDataSet(dbCommandWrapper);
}
private DataSet FillFinanStuInfo(string getGrade,string getClass,string getName,string getNumber)
{
getFinanStuInfoCommand = "GetFinanStuInfo";
dbCommandWrapper = dbContiAbs.GetStoredProcCommandWrapper(getFinanStuInfoCommand);
dbCommandWrapper.AddInParameter("@stuGrade",DbType.String,getGrade);
dbCommandWrapper.AddInParameter("@stuClass",DbType.String,getClass);
dbCommandWrapper.AddInParameter("@stuName",DbType.String,getName);
dbCommandWrapper.AddInParameter("@stuNumber",DbType.String,getNumber);
return dbContiAbs.ExecuteDataSet(dbCommandWrapper);
}
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;
}
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 FillStuInfoData(string stuGrade,string stuClass,
string stuName,string stuNumber)
{
getStuInfoCommand = "GetStudentInfo";
dbCommandWrapper = dbAccess.GetStoredProcCommandWrapper(getStuInfoCommand);
dbCommandWrapper.AddInParameter("@StuGrade",DbType.String,stuGrade);
dbCommandWrapper.AddInParameter("@StuClass",DbType.String,stuClass);
dbCommandWrapper.AddInParameter("@StuName",DbType.String,stuName);
dbCommandWrapper.AddInParameter("@StuNumber",DbType.String,stuNumber);
return dbAccess.ExecuteDataSet(dbCommandWrapper);
}
private void FillTeacherRealTimeInfoWithNoDuty(string dept,string getWeekDay, ref int total, ref int attend, ref int leave)
{
string getRealTimeInfoWithNoDuty = "GetTeacher_RealTimeInfo_WithNoDuty";
dbCommandWrapper = dbRealtimeInfo.GetStoredProcCommandWrapper(getRealTimeInfoWithNoDuty);
dbCommandWrapper.AddInParameter("@getDayOfWeek", DbType.String, getWeekDay);
dbCommandWrapper.AddInParameter("@getDept", DbType.String, dept);
DataSet dsInfo = dbRealtimeInfo.ExecuteDataSet(dbCommandWrapper);
total = Convert.ToInt32(dsInfo.Tables[0].Rows[0][0]);
attend = Convert.ToInt32(dsInfo.Tables[1].Rows[0][0]);
leave = Convert.ToInt32(dsInfo.Tables[2].Rows[0][0]);
}
private DataSet FillRealtime(DateTime getDate,string getGrade,string getClass,int getState,int needSum)
{
getRealtimeInfoCommand = "GetRealTimeInfo";
dbCommandWrapper = dbRealtime.GetStoredProcCommandWrapper(getRealtimeInfoCommand);
dbCommandWrapper.AddInParameter("@getDate",DbType.String,getDate.Date.ToString("yyyy-MM-dd"));
dbCommandWrapper.AddInParameter("@getGrade",DbType.String,getGrade);
dbCommandWrapper.AddInParameter("@getClass",DbType.String,getClass);
dbCommandWrapper.AddInParameter("@getState",DbType.Int32,getState);
dbCommandWrapper.AddInParameter("@needSum",DbType.Int32,needSum);
return dbRealtime.ExecuteDataSet(dbCommandWrapper);
}
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"));
}
private DataSet FillRolesDuty(int getTeaNumber)
{
getRolseDutyCommand = "GetRolesDuty";
dbCommandWrapper = dbRoles.GetStoredProcCommandWrapper(getRolseDutyCommand);
dbCommandWrapper.AddInParameter("@getTeaNumber",DbType.Int32,getTeaNumber);
return dbRoles.ExecuteDataSet(dbCommandWrapper);
}
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"));
}
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"));
}
private DataSet FillContiAbsForMess(bool getState,string getGrade,string getClass,string getName,
string getNumber,DateTime balanceMonth,int getNeedRestoreDays)
{
getContiAbsForMessCommand = "GetMessRestoreDays";
dbCommandWrapper = dbContiAbs.GetStoredProcCommandWrapper(getContiAbsForMessCommand);
dbCommandWrapper.AddInParameter("@getState",DbType.Boolean,getState);
dbCommandWrapper.AddInParameter("@stuGrade",DbType.String,getGrade);
dbCommandWrapper.AddInParameter("@stuClass",DbType.String,getClass);
dbCommandWrapper.AddInParameter("@stuName",DbType.String,getName);
dbCommandWrapper.AddInParameter("@stuNumber",DbType.String,getNumber);
dbCommandWrapper.AddInParameter("@balanceMonth",DbType.DateTime,balanceMonth);
dbCommandWrapper.AddInParameter("@getNeedRestoreDays",DbType.Int16,getNeedRestoreDays);
return dbContiAbs.ExecuteDataSet(dbCommandWrapper);
}
private DataSet FillMorningCheckInfoStat(DateTime getBegDate,DateTime getEndDate,string getGrade,
string getClass,int getState,int needSum)
{
getMorningCheckInfoCommand = "GetInfoStat";
dbCommandWrapper = dbInfoStat.GetStoredProcCommandWrapper(getMorningCheckInfoCommand);
dbCommandWrapper.AddInParameter("@getBegDate",DbType.DateTime,getBegDate);
dbCommandWrapper.AddInParameter("@getEndDate",DbType.DateTime,getEndDate);
dbCommandWrapper.AddInParameter("@getGrade",DbType.String,getGrade);
dbCommandWrapper.AddInParameter("@getClass",DbType.String,getClass);
dbCommandWrapper.AddInParameter("@getState",DbType.Int32,getState);
dbCommandWrapper.AddInParameter("@needSum",DbType.Int32,needSum);
return dbInfoStat.ExecuteDataSet(dbCommandWrapper);
}
private DataSet FillMorningCheckInfo(string getStuGrade,string getStuClass,string getStuName,string getStuNumber,
string getBegDate,string getEndDate,string getState)
{
getMorningCheckInfoCommand = "GetStuMorningCheckInfo";
dbCommandWrapper = dbCheckInfo.GetStoredProcCommandWrapper(getMorningCheckInfoCommand);
dbCommandWrapper.AddInParameter("@getStuGrade",DbType.String,getStuGrade);
dbCommandWrapper.AddInParameter("@getStuClass",DbType.String,getStuClass);
dbCommandWrapper.AddInParameter("@getStuName",DbType.String,getStuName);
dbCommandWrapper.AddInParameter("@getStuNumber",DbType.String,getStuNumber);
dbCommandWrapper.AddInParameter("@getBegDate",DbType.String,getBegDate);
dbCommandWrapper.AddInParameter("@getEndDate",DbType.String,getEndDate);
dbCommandWrapper.AddInParameter("@getState",DbType.String,getState);
DataSet morningCheckInfoDS = dbCheckInfo.ExecuteDataSet(dbCommandWrapper);
DataColumn orderNumberColumn = new DataColumn("info_stuOrderNumber");
orderNumberColumn.DataType = System.Type.GetType("System.Int32");
morningCheckInfoDS.Tables[0].Columns.Add(orderNumberColumn);
for(int i=0;i<morningCheckInfoDS.Tables[0].Rows.Count;i++)
morningCheckInfoDS.Tables[0].Rows[i][7] = i+1;
return morningCheckInfoDS;
}
private DataSet FillAbsenceDetail(string getGrade,string getClass,string getName,string getNumber,
DateTime getBegDate,DateTime getEndDate)
{
getAbsenceDetailCommand = "GetAbsenceDetail";
dbCommandWrapper = dbVisit.GetStoredProcCommandWrapper(getAbsenceDetailCommand);
dbCommandWrapper.AddInParameter("@stuGrade",DbType.String,getGrade);
dbCommandWrapper.AddInParameter("@stuClass",DbType.String,getClass);
dbCommandWrapper.AddInParameter("@stuName",DbType.String,getName);
dbCommandWrapper.AddInParameter("@stuNumber",DbType.String,getNumber);
dbCommandWrapper.AddInParameter("@getBegDate",DbType.DateTime,getBegDate);
dbCommandWrapper.AddInParameter("@getEndDate",DbType.DateTime,getEndDate);
DataSet dsAbsenceDetail = dbVisit.ExecuteDataSet(dbCommandWrapper);
DataColumn orderNumberColumn = new DataColumn("info_stuOrderNumber");
orderNumberColumn.DataType = System.Type.GetType("System.Int32");
dsAbsenceDetail.Tables[0].Columns.Add(orderNumberColumn);
for(int i=0;i<dsAbsenceDetail.Tables[0].Rows.Count;i++)
dsAbsenceDetail.Tables[0].Rows[i][8] = i+1;
return dsAbsenceDetail;
}
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 DataSet FillExportData(string gradeNumber,string classNumber,string stuNumber,string stuName)
{
getExportDataCommand = "si_getstuexportdata";
dbCommandWrapper = dbAccess.GetStoredProcCommandWrapper(getExportDataCommand);
dbCommandWrapper.AddInParameter("@grade",DbType.String,gradeNumber);
dbCommandWrapper.AddInParameter("@class",DbType.String,classNumber);
dbCommandWrapper.AddInParameter("@number",DbType.String,stuNumber);
dbCommandWrapper.AddInParameter("@name",DbType.String,stuName);
return dbAccess.ExecuteDataSet(dbCommandWrapper);
}
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 void DeleteStuParentInfo(Students students)
{
deleteStuParentInfoCommand = "DeleteStudent_ParentInfo";
dbCommandWrapper = dbAccess.GetStoredProcCommandWrapper(deleteStuParentInfoCommand);
dbCommandWrapper.AddInParameter("@info_stuBasicID",DbType.String,students.StuGuid);
dbAccess.ExecuteNonQuery(dbCommandWrapper);
}
public void UpdateStuParentInfo(Students students)
{
updateStuParentInfoCommand = "UpdateStudent_ParentInfo";
dbCommandWrapper = dbAccess.GetStoredProcCommandWrapper(updateStuParentInfoCommand);
dbCommandWrapper.AddInParameter("@info_stuBasicID",DbType.String,students.StuGuid);
dbCommandWrapper.AddInParameter("@info_stuFatherName",DbType.String,students.FatherName);
dbCommandWrapper.AddInParameter("@info_stuFatherLinkPhone",DbType.String,students.FatherPhone);
dbCommandWrapper.AddInParameter("@info_stuFatherWorkPlace",DbType.String,students.FatherWorkPlace);
dbCommandWrapper.AddInParameter("@info_stuMotherName",DbType.String,students.MotherName);
dbCommandWrapper.AddInParameter("@info_stuMotherLinkPhone",DbType.String,students.MotherPhone);
dbCommandWrapper.AddInParameter("@info_stuMotherWorkPlace",DbType.String,students.MotherWorkPlace);
dbAccess.ExecuteNonQuery(dbCommandWrapper);
}
public void UpdateStuDetailInfo(Students students)
{
updateStuDetailInfoCommand = "UpdateStudent_DetailInfo";
dbCommandWrapper = dbAccess.GetStoredProcCommandWrapper(updateStuDetailInfoCommand);
dbCommandWrapper.AddInParameter("@info_stuBasicID",DbType.String,students.StuGuid);
dbCommandWrapper.AddInParameter("@info_stuRegNote",DbType.String,students.RegNote);
dbCommandWrapper.AddInParameter("@info_stuOrigin",DbType.String,students.Origin);
dbCommandWrapper.AddInParameter("@info_stuNationality",DbType.String,students.Nationality);
dbCommandWrapper.AddInParameter("@info_stuNative",DbType.String,students.Native);
dbCommandWrapper.AddInParameter("@info_stuJieDao",DbType.String,students.JieDao);
dbCommandWrapper.AddInParameter("@info_stuLiWei",DbType.String,students.LiWei);
dbCommandWrapper.AddInParameter("@info_stuFamilyAddr",DbType.String,students.FamilyAddr);
dbCommandWrapper.AddInParameter("@info_stuHuKouAddr",DbType.String,students.HuKouAddr);
dbCommandWrapper.AddInParameter("@info_stuZipCode",DbType.String,students.ZipCode);
dbCommandWrapper.AddInParameter("@info_stuSickHistory",DbType.String,students.SickHistory);
dbCommandWrapper.AddInParameter("@info_stuEMailAddr",DbType.String,students.EMail);
dbCommandWrapper.AddInParameter("@info_stuBankID",DbType.String,students.BankID);
dbCommandWrapper.AddInParameter("@info_stuGraphLocation",DbType.Binary,students.GraphLocation);
dbAccess.ExecuteNonQuery(dbCommandWrapper);
}
public void DeleteFinanInfo(DateTime getDate)
{
deleteFinanInfoCommand = "DeleteFinanInfo";
dbCommandWrapper = dbContiAbs.GetStoredProcCommandWrapper(deleteFinanInfoCommand);
dbCommandWrapper.AddInParameter("@searchMonth",DbType.DateTime,getDate);
dbContiAbs.ExecuteNonQuery(dbCommandWrapper);
}
public void InsertFinanInfo(DataRow finanInfoRow,DateTime getDate,int getMessRestoreDays,int getAdmRestoreDays)
{
insertFinanInfoCommand = "InsertFinanInfo";
dbCommandWrapper = dbContiAbs.GetStoredProcCommandWrapper(insertFinanInfoCommand);
dbCommandWrapper.AddInParameter("@stuNumber",DbType.Int32,Convert.ToInt32(finanInfoRow[0]));
dbCommandWrapper.AddInParameter("@balanceDate",DbType.DateTime,getDate);
dbCommandWrapper.AddInParameter("@needHandDays",DbType.Int32,Convert.ToInt32(finanInfoRow[3]));
dbCommandWrapper.AddInParameter("@messStopDays",DbType.Int32,Convert.ToInt32(finanInfoRow[4]));
dbCommandWrapper.AddInParameter("@admCharge",DbType.String,finanInfoRow[5].ToString());
dbCommandWrapper.AddInParameter("@messCharge",DbType.String,finanInfoRow[6].ToString());
dbCommandWrapper.AddInParameter("@nightCharge",DbType.String,finanInfoRow[7].ToString());
dbCommandWrapper.AddInParameter("@commCharge",DbType.String,finanInfoRow[8].ToString());
dbCommandWrapper.AddInParameter("@milkCharge",DbType.String,finanInfoRow[9].ToString());
dbCommandWrapper.AddInParameter("@extraCharge",DbType.String,finanInfoRow[10].ToString());
dbCommandWrapper.AddInParameter("@admRestoreCharge",DbType.String,finanInfoRow[11].ToString());
dbCommandWrapper.AddInParameter("@messRestoreCharge",DbType.String,finanInfoRow[12].ToString());
dbCommandWrapper.AddInParameter("@currency",DbType.String,finanInfoRow[13].ToString());
dbCommandWrapper.AddInParameter("@remark",DbType.String,finanInfoRow[14].ToString());
dbCommandWrapper.AddInParameter("@messRestoreDays",DbType.Int32,getMessRestoreDays);
dbCommandWrapper.AddInParameter("@admRestoreDays",DbType.Int32,getAdmRestoreDays);
dbContiAbs.ExecuteNonQuery(dbCommandWrapper);
}
private DataSet FillStuAmount(string getMachineAddr,DateTime getEndDate)
{
getStuAmountCommand = "GetStuAmount";
dbCommandWrapper = dbRealtime.GetStoredProcCommandWrapper(getStuAmountCommand);
dbCommandWrapper.AddInParameter("@machineAddr",DbType.String,getMachineAddr);
dbCommandWrapper.AddInParameter("@getEndDate",DbType.DateTime,getEndDate);
return dbRealtime.ExecuteDataSet(dbCommandWrapper);
}
private DataSet FillGetTeaDeptInfo(string getDept)
{
getTeaDeptInfoCommand = "GetTeaDeptInfo";
dbCommandWrapper = dbRealtimeInfo.GetStoredProcCommandWrapper(getTeaDeptInfoCommand);
dbCommandWrapper.AddInParameter("@getDept",DbType.String,getDept);
return dbRealtimeInfo.ExecuteDataSet(dbCommandWrapper);
}
private DataSet FillClassList(string getClassName,string getClassNumber,string getGradeNumber)
{
getClassListCommand = "GetClassList";
dbCommandWrapper = dbRealtime.GetStoredProcCommandWrapper(getClassListCommand);
dbCommandWrapper.AddInParameter("@ClassName",DbType.String,getClassName);
dbCommandWrapper.AddInParameter("@ClassNumber",DbType.String,getClassNumber);
dbCommandWrapper.AddInParameter("@GradeNumber",DbType.String,getGradeNumber);
return dbRealtime.ExecuteDataSet(dbCommandWrapper);
}
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 void InsertStuBasicInfo(Students students)
{
insertStuBasicInfoCommand = "InsertStuBasicInfo";
dbCommandWrapper = dbAccess.GetStoredProcCommandWrapper(insertStuBasicInfoCommand);
dbCommandWrapper.AddInParameter("@info_stuID",DbType.String,students.StuGuid);
dbCommandWrapper.AddInParameter("@info_stuName",DbType.String,students.Name);
dbCommandWrapper.AddInParameter("@info_stuGrade",DbType.String,students.Grade);
dbCommandWrapper.AddInParameter("@info_stuClass",DbType.String,students.Class);
dbCommandWrapper.AddInParameter("@info_stuNumber",DbType.String,students.Number);
dbCommandWrapper.AddInParameter("@info_stuGender",DbType.String,students.Gender);
dbCommandWrapper.AddInParameter("@info_stuBirthday",DbType.DateTime,students.Birthday);
dbCommandWrapper.AddInParameter("@info_stuEntryStatus",DbType.String,students.EntryStatus);
dbCommandWrapper.AddInParameter("@info_stuEntryDate",DbType.DateTime,students.EntryDate);
dbAccess.ExecuteNonQuery(dbCommandWrapper);
}
private DataSet FillDutyID(string getTime)
{
getDutyIDCommand = "GetDutyID_InTime";
dbCommandWrapper = dbRealtimeInfo.GetStoredProcCommandWrapper(getDutyIDCommand);
dbCommandWrapper.AddInParameter("@getTime",DbType.String,getTime);
return dbRealtimeInfo.ExecuteDataSet(dbCommandWrapper);
}