private DataSet FillRolesDuty(int getTeaNumber) { getRolseDutyCommand = "GetRolesDuty"; dbCommandWrapper = dbRoles.GetStoredProcCommandWrapper(getRolseDutyCommand); dbCommandWrapper.AddInParameter("@getTeaNumber",DbType.Int32,getTeaNumber); return dbRoles.ExecuteDataSet(dbCommandWrapper); }
private void CheckTeaDuty() { checkTeaDutyCommand = "RecTeacherWorkingDaysPerWeek"; dbCommandWrapper = dbPrepareForCheck.GetStoredProcCommandWrapper(checkTeaDutyCommand); dbCommandWrapper.CommandTimeout = 180; dbPrepareForCheck.ExecuteNonQuery(dbCommandWrapper); }
private void SaveTeaAlternate() { saveAlternateCommand = "SaveAlternate"; dbCommandWrapper = dbPrepareForCheck.GetStoredProcCommandWrapper(saveAlternateCommand); dbCommandWrapper.CommandTimeout = 180; dbPrepareForCheck.ExecuteNonQuery(dbCommandWrapper); }
private void CheckAbsDoneYesterday() { checkAbsDoneYesterdayCommand = "CheckAbsDoneYesterday"; dbCommandWrapper = dbPrepareForCheck.GetStoredProcCommandWrapper(checkAbsDoneYesterdayCommand); dbCommandWrapper.CommandTimeout = 600; dbPrepareForCheck.ExecuteNonQuery(dbCommandWrapper); }
private void FillAbsentStudent() { fillAbsentStudentCommand = "FillAbsentStudent"; dbCommandWrapper = dbPrepareForCheck.GetStoredProcCommandWrapper(fillAbsentStudentCommand); dbCommandWrapper.CommandTimeout = 180; dbPrepareForCheck.ExecuteNonQuery(dbCommandWrapper); }
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); }
/// <summary> /// <para>Adds parameters to a command using the cache</para> /// </summary> /// <param name="command"> /// <para>The command to add the parameters.</para> /// </param> protected virtual void AddParametersFromCache(DBCommandWrapper command) { IDataParameter[] parameters = this.cache.GetCachedParameterSet(command.Command); foreach (IDataParameter p in parameters) { command.Command.Parameters.Add(p); } }
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 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 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 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); }
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 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); }
public int InsertNutrition(FoodMgmt foodMgmt) { insertNutritionCommand = "InsertNutrition"; dbCommandWrapper = dbFoodMgmt.GetStoredProcCommandWrapper(insertNutritionCommand); dbCommandWrapper.AddInParameter("@foodCateName",DbType.String,foodMgmt.FoodCategory); dbCommandWrapper.AddInParameter("@foodName",DbType.String,foodMgmt.FoodName); dbCommandWrapper.AddInParameter("@foodProtein",DbType.Double,foodMgmt.Protein); dbCommandWrapper.AddInParameter("@foodFat",DbType.Double,foodMgmt.Fat); dbCommandWrapper.AddInParameter("@foodCarbohydrate",DbType.Double,foodMgmt.Carbohydrate); dbCommandWrapper.AddInParameter("@foodEnergy",DbType.Double,foodMgmt.Energy); dbCommandWrapper.AddInParameter("@foodRemark",DbType.String,foodMgmt.FoodRemark); dbCommandWrapper.AddOutParameter("@rowsAffected",DbType.Int16,16); dbFoodMgmt.ExecuteNonQuery(dbCommandWrapper); return Convert.ToInt32(dbCommandWrapper.GetParameterValue("@rowsAffected")); }
/// <summary> /// <para> /// Populates the parameter collection for a command wrapper from the cache /// or performs a round-trip to the database to query the parameters /// </para> /// </summary> /// <param name="command"> /// <para>The command to add the parameters.</para> /// </param> /// <param name="parameterToken"> /// <para>The token used to delimit parameters.</para> /// </param> public void FillParameters(DBCommandWrapper command, char parameterToken) { if (AlreadyCached(command)) { AddParametersFromCache(command); } else { command.DiscoverParameters(parameterToken); IDataParameter[] copyOfParameters = CreateParameterCopy(command); this.cache.AddParameterSetToCache(command.Command, copyOfParameters); } command.AssignParameterValues(); }
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 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; }
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; }
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 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); }
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); }
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); }