本文整理汇总了C#中Framework.Runtime.DBTypes.DBInt.ToString方法的典型用法代码示例。如果您正苦于以下问题:C# DBInt.ToString方法的具体用法?C# DBInt.ToString怎么用?C# DBInt.ToString使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Framework.Runtime.DBTypes.DBInt
的用法示例。
在下文中一共展示了DBInt.ToString方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: ndihdNewsSelectDispsetFiltered
public DataSet ndihdNewsSelectDispsetFiltered(DBInt bVisibleForVisitor,
DBInt bVisibleForRegistered,
DBInt bIsActive)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdNewsSelectDispsetFiltered]");
SqlParameter p1 = sqlComm.Parameters.Add("@bVisibleForVisitor", SqlDbType.Int);
p1.Value = bVisibleForVisitor.Value;
SqlParameter p2 = sqlComm.Parameters.Add("@bVisibleForRegistered", SqlDbType.Int);
p2.Value = bVisibleForRegistered.Value;
SqlParameter p3 = sqlComm.Parameters.Add("@bIsActive", SqlDbType.Int);
p3.Value = bIsActive.Value;
TraceDbCommandEvent.Raise(sqlComm);
DataSet Result = new DataSet();
try
{
SqlDataAdapter sqlAdapt = new SqlDataAdapter(sqlComm);
sqlAdapt.Fill(Result);
TraceCallReturnEvent.Raise();
}
catch (SqlException e)
{
TraceCallReturnEvent.Raise(false);
SqlErrorHandler.Handle(e, bVisibleForVisitor.ToString());
}
finally
{
FinishSPCall();
}
return Result;
}
示例2: ndihdKefEventSelectFiltered
public DataSet ndihdKefEventSelectFiltered(DBInt bIsActive,
DBGuid uOrganisationRef)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdKefEventSelectFiltered]");
SqlParameter p1 = sqlComm.Parameters.Add("@bIsActive", SqlDbType.Int);
p1.Value = bIsActive.Value;
SqlParameter p2 = sqlComm.Parameters.Add("@uOrganisationRef", SqlDbType.UniqueIdentifier);
p2.Value = uOrganisationRef.Value;
TraceDbCommandEvent.Raise(sqlComm);
DataSet Result = new DataSet();
try
{
SqlDataAdapter sqlAdapt = new SqlDataAdapter(sqlComm);
sqlAdapt.Fill(Result);
TraceCallReturnEvent.Raise();
}
catch (SqlException e)
{
TraceCallReturnEvent.Raise(false);
SqlErrorHandler.Handle(e, bIsActive.ToString());
}
finally
{
FinishSPCall();
}
return Result;
}
示例3: ndihdKefWebDataSelectByRank
public DataSet ndihdKefWebDataSelectByRank(DBInt nLinkRank,
DBString cKefCategoryRef)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdKefWebDataSelectByRank]");
SqlParameter p1 = sqlComm.Parameters.Add("@nLinkRank", SqlDbType.Int);
p1.Value = nLinkRank.Value;
SqlParameter p2 = sqlComm.Parameters.Add("@cKefCategoryRef", SqlDbType.Char, 10);
p2.Value = cKefCategoryRef.Value;
TraceDbCommandEvent.Raise(sqlComm);
DataSet Result = new DataSet();
try
{
SqlDataAdapter sqlAdapt = new SqlDataAdapter(sqlComm);
sqlAdapt.Fill(Result);
TraceCallReturnEvent.Raise();
}
catch (SqlException e)
{
TraceCallReturnEvent.Raise(false);
SqlErrorHandler.Handle(e, nLinkRank.ToString());
}
finally
{
FinishSPCall();
}
return Result;
}
示例4: ndihdCounterUpdate
public void ndihdCounterUpdate(DBInt nID,
DBInt nCount)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdCounterUpdate]");
SqlParameter p1 = sqlComm.Parameters.Add("@nID", SqlDbType.Int);
p1.Value = nID.Value;
SqlParameter p2 = sqlComm.Parameters.Add("@nCount", SqlDbType.Int);
p2.Value = nCount.Value;
TraceDbCommandEvent.Raise(sqlComm);
try
{
sqlComm.ExecuteNonQuery();
TraceCallReturnEvent.Raise();
}
catch (SqlException e)
{
TraceCallReturnEvent.Raise(false);
SqlErrorHandler.Handle(e, nID.ToString());
}
finally
{
FinishSPCall();
}
}
示例5: ndihdForumGroupSelectFiltered
public DataSet ndihdForumGroupSelectFiltered(DBInt bVisibleForVisitor,
DBInt bVisibleForRegistered,
DBInt bIsActive,
out int retVal)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdForumGroupSelectFiltered]");
SqlParameter returnValue = sqlComm.Parameters.Add("@RETURNVALUE", SqlDbType.Int);
returnValue.Direction = ParameterDirection.ReturnValue;
SqlParameter p1 = sqlComm.Parameters.Add("@bVisibleForVisitor", SqlDbType.Int);
p1.Value = bVisibleForVisitor.Value;
SqlParameter p2 = sqlComm.Parameters.Add("@bVisibleForRegistered", SqlDbType.Int);
p2.Value = bVisibleForRegistered.Value;
SqlParameter p3 = sqlComm.Parameters.Add("@bIsActive", SqlDbType.Int);
p3.Value = bIsActive.Value;
TraceDbCommandEvent.Raise(sqlComm);
DataSet Result = new DataSet();
try
{
SqlDataAdapter sqlAdapt = new SqlDataAdapter(sqlComm);
sqlAdapt.Fill(Result);
TraceCallReturnEvent.Raise();
}
catch (SqlException e)
{
TraceCallReturnEvent.Raise(false);
SqlErrorHandler.Handle(e, bVisibleForVisitor.ToString());
}
finally
{
FinishSPCall();
}
retVal = (int)returnValue.Value;
TraceInfoEvent.Raise("RetVal: {0}", retVal);
return Result;
}
示例6: ndihdDistrictSearchCodeOfOrganisationDeleteBy
public void ndihdDistrictSearchCodeOfOrganisationDeleteBy(DBInt nDistrictSearchCodeRef)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdDistrictSearchCodeOfOrganisationDeleteBy]");
SqlParameter p1 = sqlComm.Parameters.Add("@nDistrictSearchCodeRef", SqlDbType.Int);
p1.Value = nDistrictSearchCodeRef.Value;
TraceDbCommandEvent.Raise(sqlComm);
try
{
sqlComm.ExecuteNonQuery();
TraceCallReturnEvent.Raise();
}
catch (SqlException e)
{
TraceCallReturnEvent.Raise(false);
SqlErrorHandler.Handle(e, nDistrictSearchCodeRef.ToString());
}
finally
{
FinishSPCall();
}
}
示例7: ndihdEventSelect
public DataSet ndihdEventSelect(DBInt nID,
out int retVal)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdEventSelect]");
SqlParameter returnValue = sqlComm.Parameters.Add("@RETURNVALUE", SqlDbType.Int);
returnValue.Direction = ParameterDirection.ReturnValue;
SqlParameter p1 = sqlComm.Parameters.Add("@nID", SqlDbType.Int);
p1.Value = nID.Value;
TraceDbCommandEvent.Raise(sqlComm);
DataSet Result = new DataSet();
try
{
SqlDataAdapter sqlAdapt = new SqlDataAdapter(sqlComm);
sqlAdapt.Fill(Result);
TraceCallReturnEvent.Raise();
}
catch (SqlException e)
{
TraceCallReturnEvent.Raise(false);
SqlErrorHandler.Handle(e, nID.ToString());
}
finally
{
FinishSPCall();
}
retVal = (int)returnValue.Value;
TraceInfoEvent.Raise("RetVal: {0}", retVal);
return Result;
}
示例8: ndihdEventUpdate
public void ndihdEventUpdate(DBInt nID,
DBDateTime dTimeStamp,
DBString cSeverity,
DBString cSource,
DBString cMethod,
DBString cThreadInfo,
DBString cWindowsIdentity,
DBString cPrincipalName,
DBString cMessage)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdEventUpdate]");
SqlParameter p1 = sqlComm.Parameters.Add("@nID", SqlDbType.Int);
p1.Value = nID.Value;
SqlParameter p2 = sqlComm.Parameters.Add("@dTimeStamp", SqlDbType.DateTime);
p2.Value = dTimeStamp.Value;
SqlParameter p3 = sqlComm.Parameters.Add("@cSeverity", SqlDbType.VarChar, 32);
p3.Value = cSeverity.Value;
SqlParameter p4 = sqlComm.Parameters.Add("@cSource", SqlDbType.VarChar, 128);
p4.Value = cSource.Value;
SqlParameter p5 = sqlComm.Parameters.Add("@cMethod", SqlDbType.VarChar, 128);
p5.Value = cMethod.Value;
SqlParameter p6 = sqlComm.Parameters.Add("@cThreadInfo", SqlDbType.VarChar, 128);
p6.Value = cThreadInfo.Value;
SqlParameter p7 = sqlComm.Parameters.Add("@cWindowsIdentity", SqlDbType.VarChar, 64);
p7.Value = cWindowsIdentity.Value;
SqlParameter p8 = sqlComm.Parameters.Add("@cPrincipalName", SqlDbType.VarChar, 64);
p8.Value = cPrincipalName.Value;
SqlParameter p9 = sqlComm.Parameters.Add("@cMessage", SqlDbType.VarChar, 512);
p9.Value = cMessage.Value;
TraceDbCommandEvent.Raise(sqlComm);
try
{
sqlComm.ExecuteNonQuery();
TraceCallReturnEvent.Raise();
}
catch (SqlException e)
{
TraceCallReturnEvent.Raise(false);
SqlErrorHandler.Handle(e, nID.ToString());
}
finally
{
FinishSPCall();
}
}
示例9: ndihdEventPropertyInsert
public void ndihdEventPropertyInsert(DBInt nEventID,
DBString cName,
DBString cValue,
out int retVal)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdEventPropertyInsert]");
SqlParameter returnValue = sqlComm.Parameters.Add("@RETURNVALUE", SqlDbType.Int);
returnValue.Direction = ParameterDirection.ReturnValue;
SqlParameter p1 = sqlComm.Parameters.Add("@nEventID", SqlDbType.Int);
p1.Value = nEventID.Value;
SqlParameter p2 = sqlComm.Parameters.Add("@cName", SqlDbType.VarChar, 50);
p2.Value = cName.Value;
SqlParameter p3 = sqlComm.Parameters.Add("@cValue", SqlDbType.VarChar, 4000);
p3.Value = cValue.Value;
TraceDbCommandEvent.Raise(sqlComm);
try
{
sqlComm.ExecuteNonQuery();
TraceCallReturnEvent.Raise();
}
catch (SqlException e)
{
TraceCallReturnEvent.Raise(false);
SqlErrorHandler.Handle(e, nEventID.ToString());
}
finally
{
FinishSPCall();
}
retVal = (int)returnValue.Value;
TraceInfoEvent.Raise("RetVal: {0}", retVal);
}
示例10: ndihdEventPropertyUpdate
public void ndihdEventPropertyUpdate(DBInt nEventID,
DBString cName,
DBString cValue)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdEventPropertyUpdate]");
SqlParameter p1 = sqlComm.Parameters.Add("@nEventID", SqlDbType.Int);
p1.Value = nEventID.Value;
SqlParameter p2 = sqlComm.Parameters.Add("@cName", SqlDbType.VarChar, 50);
p2.Value = cName.Value;
SqlParameter p3 = sqlComm.Parameters.Add("@cValue", SqlDbType.VarChar, 4000);
p3.Value = cValue.Value;
TraceDbCommandEvent.Raise(sqlComm);
try
{
sqlComm.ExecuteNonQuery();
TraceCallReturnEvent.Raise();
}
catch (SqlException e)
{
TraceCallReturnEvent.Raise(false);
SqlErrorHandler.Handle(e, nEventID.ToString());
}
finally
{
FinishSPCall();
}
}
示例11: ndihdEventPropertyDeleteBy
public void ndihdEventPropertyDeleteBy(DBInt nEventID)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdEventPropertyDeleteBy]");
SqlParameter p1 = sqlComm.Parameters.Add("@nEventID", SqlDbType.Int);
p1.Value = nEventID.Value;
TraceDbCommandEvent.Raise(sqlComm);
try
{
sqlComm.ExecuteNonQuery();
TraceCallReturnEvent.Raise();
}
catch (SqlException e)
{
TraceCallReturnEvent.Raise(false);
SqlErrorHandler.Handle(e, nEventID.ToString());
}
finally
{
FinishSPCall();
}
}
示例12: ndihdDistrictSearchUpdate
public void ndihdDistrictSearchUpdate(DBInt nDistrictSearchCode,
DBString cDistrictDescription)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdDistrictSearchUpdate]");
SqlParameter p1 = sqlComm.Parameters.Add("@nDistrictSearchCode", SqlDbType.Int);
p1.Value = nDistrictSearchCode.Value;
SqlParameter p2 = sqlComm.Parameters.Add("@cDistrictDescription", SqlDbType.VarChar, 50);
p2.Value = cDistrictDescription.Value;
TraceDbCommandEvent.Raise(sqlComm);
try
{
sqlComm.ExecuteNonQuery();
TraceCallReturnEvent.Raise();
}
catch (SqlException e)
{
TraceCallReturnEvent.Raise(false);
SqlErrorHandler.Handle(e, nDistrictSearchCode.ToString());
}
finally
{
FinishSPCall();
}
}
示例13: ndihdDistrictSearchInsert
public void ndihdDistrictSearchInsert(DBInt nDistrictSearchCode,
DBString cDistrictDescription,
out int retVal)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdDistrictSearchInsert]");
SqlParameter returnValue = sqlComm.Parameters.Add("@RETURNVALUE", SqlDbType.Int);
returnValue.Direction = ParameterDirection.ReturnValue;
SqlParameter p1 = sqlComm.Parameters.Add("@nDistrictSearchCode", SqlDbType.Int);
p1.Value = nDistrictSearchCode.Value;
SqlParameter p2 = sqlComm.Parameters.Add("@cDistrictDescription", SqlDbType.VarChar, 50);
p2.Value = cDistrictDescription.Value;
TraceDbCommandEvent.Raise(sqlComm);
try
{
sqlComm.ExecuteNonQuery();
TraceCallReturnEvent.Raise();
}
catch (SqlException e)
{
TraceCallReturnEvent.Raise(false);
SqlErrorHandler.Handle(e, nDistrictSearchCode.ToString());
}
finally
{
FinishSPCall();
}
retVal = (int)returnValue.Value;
TraceInfoEvent.Raise("RetVal: {0}", retVal);
}
示例14: ndihdJobOfferSelectFiltered
public DataSet ndihdJobOfferSelectFiltered(DBInt nRefId,
DBGuid uID,
DBString cLogin,
DBString cDescription,
DBString cMessage,
DBString cRequirements,
DBString cCity,
DBString cRegionRef,
DBString cQualificationMinRef,
DBString cStatus,
DBInt bActivityPrevention,
DBInt bActivityResearch,
DBInt bActivityRehabilitation,
DBInt bActivityOther,
DBInt bNoticationSend,
DBDateTime dExpireDate,
DBDateTime dNotificationDate,
DBDateTime dExpireDateExpired)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdJobOfferSelectFiltered]");
SqlParameter p1 = sqlComm.Parameters.Add("@nRefId", SqlDbType.Int);
p1.Value = nRefId.Value;
SqlParameter p2 = sqlComm.Parameters.Add("@uID", SqlDbType.UniqueIdentifier);
p2.Value = uID.Value;
SqlParameter p3 = sqlComm.Parameters.Add("@cLogin", SqlDbType.VarChar, 500);
p3.Value = cLogin.Value;
SqlParameter p4 = sqlComm.Parameters.Add("@cDescription", SqlDbType.VarChar, 100);
p4.Value = cDescription.Value;
SqlParameter p5 = sqlComm.Parameters.Add("@cMessage", SqlDbType.VarChar, 100);
p5.Value = cMessage.Value;
SqlParameter p6 = sqlComm.Parameters.Add("@cRequirements", SqlDbType.VarChar, 100);
p6.Value = cRequirements.Value;
SqlParameter p7 = sqlComm.Parameters.Add("@cCity", SqlDbType.VarChar, 100);
p7.Value = cCity.Value;
SqlParameter p8 = sqlComm.Parameters.Add("@cRegionRef", SqlDbType.Char, 10);
p8.Value = cRegionRef.Value;
SqlParameter p9 = sqlComm.Parameters.Add("@cQualificationMinRef", SqlDbType.Char, 10);
p9.Value = cQualificationMinRef.Value;
SqlParameter p10 = sqlComm.Parameters.Add("@cStatus", SqlDbType.Char, 3);
p10.Value = cStatus.Value;
SqlParameter p11 = sqlComm.Parameters.Add("@bActivityPrevention", SqlDbType.Int);
p11.Value = bActivityPrevention.Value;
SqlParameter p12 = sqlComm.Parameters.Add("@bActivityResearch", SqlDbType.Int);
p12.Value = bActivityResearch.Value;
SqlParameter p13 = sqlComm.Parameters.Add("@bActivityRehabilitation", SqlDbType.Int);
p13.Value = bActivityRehabilitation.Value;
SqlParameter p14 = sqlComm.Parameters.Add("@bActivityOther", SqlDbType.Int);
p14.Value = bActivityOther.Value;
SqlParameter p15 = sqlComm.Parameters.Add("@bNoticationSend", SqlDbType.Int);
p15.Value = bNoticationSend.Value;
SqlParameter p16 = sqlComm.Parameters.Add("@dExpireDate", SqlDbType.DateTime);
p16.Value = dExpireDate.Value;
SqlParameter p17 = sqlComm.Parameters.Add("@dNotificationDate", SqlDbType.DateTime);
p17.Value = dNotificationDate.Value;
SqlParameter p18 = sqlComm.Parameters.Add("@dExpireDateExpired", SqlDbType.DateTime);
p18.Value = dExpireDateExpired.Value;
TraceDbCommandEvent.Raise(sqlComm);
DataSet Result = new DataSet();
try
{
SqlDataAdapter sqlAdapt = new SqlDataAdapter(sqlComm);
sqlAdapt.Fill(Result);
TraceCallReturnEvent.Raise();
}
catch (SqlException e)
{
TraceCallReturnEvent.Raise(false);
SqlErrorHandler.Handle(e, nRefId.ToString());
}
finally
{
FinishSPCall();
}
return Result;
}
示例15: ndihdCounterSelect
public DataSet ndihdCounterSelect(DBInt nID)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdCounterSelect]");
SqlParameter p1 = sqlComm.Parameters.Add("@nID", SqlDbType.Int);
p1.Value = nID.Value;
TraceDbCommandEvent.Raise(sqlComm);
DataSet Result = new DataSet();
try
{
SqlDataAdapter sqlAdapt = new SqlDataAdapter(sqlComm);
sqlAdapt.Fill(Result);
TraceCallReturnEvent.Raise();
}
catch (SqlException e)
{
TraceCallReturnEvent.Raise(false);
SqlErrorHandler.Handle(e, nID.ToString());
}
finally
{
FinishSPCall();
}
return Result;
}