当前位置: 首页>>代码示例>>C#>>正文

C# DBCommandWrapper.AddOutParameter方法代码示例

本文整理汇总了C#中Microsoft.Practices.EnterpriseLibrary.Data.DBCommandWrapper.AddOutParameter方法的典型用法代码示例。如果您正苦于以下问题：C# DBCommandWrapper.AddOutParameter方法的具体用法？C# DBCommandWrapper.AddOutParameter怎么用？C# DBCommandWrapper.AddOutParameter使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Microsoft.Practices.EnterpriseLibrary.Data.DBCommandWrapper的用法示例。


在下文中一共展示了DBCommandWrapper.AddOutParameter方法的15个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。

示例1: GetRealtimeBackInfo_Graphic

		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"));
		}
开发者ID:zesus19，项目名称:c4.v2.T，代码行数:16，代码来源:RealtimeInfoDataAccess.cs

示例2: DoAttendCalcForClass

		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"));
		}
开发者ID:zesus19，项目名称:c4.v2.T，代码行数:18，代码来源:StudentAttendCalcDataAccess.cs

示例3: FillTeaNumbers

		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"));
		}
开发者ID:zesus19，项目名称:c4.v2.T，代码行数:11，代码来源:RealtimeInfo_TeacherDataAccess.cs

示例4: FillAbsentDaysInMonth

		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;
		}
开发者ID:zesus19，项目名称:c4.v2.T，代码行数:11，代码来源:StuVisitInfoDataAccess.cs

示例5: GetRealtimeMorningInfo_Graphic

		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"));
		}
开发者ID:zesus19，项目名称:c4.v2.T，代码行数:21，代码来源:RealtimeInfoDataAccess.cs

示例6: InsertMachine

		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"));
		}
开发者ID:zesus19，项目名称:c4.v2.T，代码行数:11，代码来源:OptionDataAccess.cs

示例7: InsertNewAddCardInfo

		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"));
		}
开发者ID:zesus19，项目名称:c4.v2.T，代码行数:12，代码来源:OptionDataAccess.cs

示例8: DeleteMachineInfo

		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"));
		}
开发者ID:zesus19，项目名称:c4.v2.T，代码行数:10，代码来源:OptionDataAccess.cs

示例9: InsertStuInfo

		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"));
		}
开发者ID:zesus19，项目名称:c4.v2.T，代码行数:24，代码来源:OptionDataAccess.cs

示例10: UpdateMed

		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"));
		}
开发者ID:zesus19，项目名称:c4.v2.T，代码行数:13，代码来源:HealthManagementDataAccess.cs

示例11: SaveMorningWatch

		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"));												  
		}
开发者ID:zesus19，项目名称:c4.v2.T，代码行数:30，代码来源:HealthManagementDataAccess.cs

示例12: DeleteClassInfo

		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"));
		}
开发者ID:zesus19，项目名称:c4.v2.T，代码行数:10，代码来源:OptionDataAccess.cs

示例13: InternalInsertNewStudentForGradeChange

		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"));
		}
开发者ID:zesus19，项目名称:c4.v2.T，代码行数:13，代码来源:OptionDataAccess.cs

示例14: FillDiagResult

		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"));
		}
开发者ID:zesus19，项目名称:c4.v2.T，代码行数:21，代码来源:HealthManagementDataAccess.cs

示例15: UpdateGradeInfo

		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"));
		}
开发者ID:zesus19，项目名称:c4.v2.T，代码行数:12，代码来源:OptionDataAccess.cs


注：本文中的Microsoft.Practices.EnterpriseLibrary.Data.DBCommandWrapper.AddOutParameter方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。