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

C# DBCommandWrapper.AddInParameter方法代码示例

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


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

示例1: FillGradeData

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

示例2: Fill2DaysAbs

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

示例3: FillFinanStuInfo

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

示例6: FillStuInfoData

		//查询学生信息表，返回数据集
		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);
		}
开发者ID:zesus19，项目名称:c4.v2.T，代码行数:12，代码来源:StuInfoDataAccess.cs

示例7: FillTeacherRealTimeInfoWithNoDuty

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

示例8: FillRealtime

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

示例9: 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

示例10: FillRolesDuty

		private DataSet FillRolesDuty(int getTeaNumber)
		{
			getRolseDutyCommand = "GetRolesDuty";
			dbCommandWrapper = dbRoles.GetStoredProcCommandWrapper(getRolseDutyCommand);
			dbCommandWrapper.AddInParameter("@getTeaNumber",DbType.Int32,getTeaNumber);
			return dbRoles.ExecuteDataSet(dbCommandWrapper);
		}
开发者ID:zesus19，项目名称:c4.v2.T，代码行数:7，代码来源:RolesDataAccess.cs

示例11: 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

示例12: 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

示例13: FillContiAbsForMess

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

示例14: FillMorningCheckInfoStat

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

示例15: FillMorningCheckInfo

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


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