本文整理汇总了C#中Framework.Runtime.DBTypes.DBString.ToString方法的典型用法代码示例。如果您正苦于以下问题：C# DBString.ToString方法的具体用法？C# DBString.ToString怎么用？C# DBString.ToString使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Framework.Runtime.DBTypes.DBString的用法示例。
在下文中一共展示了DBString.ToString方法的15个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: ndihdQualificationUpdate
public void ndihdQualificationUpdate(DBString cID,
DBString cName,
bool bIsActive,
DBInt nOrder,
out int retVal)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdQualificationUpdate]");
SqlParameter returnValue = sqlComm.Parameters.Add("@RETURNVALUE", SqlDbType.Int);
returnValue.Direction = ParameterDirection.ReturnValue;
SqlParameter p1 = sqlComm.Parameters.Add("@cID", SqlDbType.Char, 10);
p1.Value = cID.Value;
SqlParameter p2 = sqlComm.Parameters.Add("@cName", SqlDbType.VarChar, 250);
p2.Value = cName.Value;
SqlParameter p3 = sqlComm.Parameters.Add("@bIsActive", SqlDbType.Bit);
p3.Value = bIsActive;
SqlParameter p4 = sqlComm.Parameters.Add("@nOrder", SqlDbType.Int);
p4.Value = nOrder.Value;
TraceDbCommandEvent.Raise(sqlComm);
try
{
sqlComm.ExecuteNonQuery();
TraceCallReturnEvent.Raise();
}
catch (SqlException e)
{
TraceCallReturnEvent.Raise(false);
SqlErrorHandler.Handle(e, cID.ToString());
}
finally
{
FinishSPCall();
}
retVal = (int)returnValue.Value;
TraceInfoEvent.Raise("RetVal: {0}", retVal);
}示例2: ndihdJobOfferSelectBySubscriber
public DataSet ndihdJobOfferSelectBySubscriber(DBString cLogin,
DBString cType)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdJobOfferSelectBySubscriber]");
SqlParameter p1 = sqlComm.Parameters.Add("@cLogin", SqlDbType.VarChar, 500);
p1.Value = cLogin.Value;
SqlParameter p2 = sqlComm.Parameters.Add("@cType", SqlDbType.Char, 3);
p2.Value = cType.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, cLogin.ToString());
}
finally
{
FinishSPCall();
}
return Result;
}示例3: ndihdOrganisationFormSelect
public DataSet ndihdOrganisationFormSelect(DBString cID)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdOrganisationFormSelect]");
SqlParameter p1 = sqlComm.Parameters.Add("@cID", SqlDbType.Char, 10);
p1.Value = cID.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, cID.ToString());
}
finally
{
FinishSPCall();
}
return Result;
}示例4: ndihdOrganisationFormDelete
public void ndihdOrganisationFormDelete(DBString cID)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdOrganisationFormDelete]");
SqlParameter p1 = sqlComm.Parameters.Add("@cID", SqlDbType.Char, 10);
p1.Value = cID.Value;
TraceDbCommandEvent.Raise(sqlComm);
try
{
sqlComm.ExecuteNonQuery();
TraceCallReturnEvent.Raise();
}
catch (SqlException e)
{
TraceCallReturnEvent.Raise(false);
SqlErrorHandler.Handle(e, cID.ToString());
}
finally
{
FinishSPCall();
}
}示例5: ndihdOrganisationSelectFilteredForCsv
public void ndihdOrganisationSelectFilteredForCsv(DBString cName,
DBString cRegionRef,
DBString cOrganisationFormRef,
DBInt bActivityPrevention,
DBInt bActivityResearch,
DBInt bActivityRehabilitation,
DBInt bActivityOther,
DBInt bIsActive,
DBInt bIsKef,
DBString cValidationState)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdOrganisationSelectFilteredForCsv]");
SqlParameter p1 = sqlComm.Parameters.Add("@cName", SqlDbType.VarChar, 250);
p1.Value = cName.Value;
SqlParameter p2 = sqlComm.Parameters.Add("@cRegionRef", SqlDbType.Char, 10);
p2.Value = cRegionRef.Value;
SqlParameter p3 = sqlComm.Parameters.Add("@cOrganisationFormRef", SqlDbType.Char, 10);
p3.Value = cOrganisationFormRef.Value;
SqlParameter p4 = sqlComm.Parameters.Add("@bActivityPrevention", SqlDbType.Int);
p4.Value = bActivityPrevention.Value;
SqlParameter p5 = sqlComm.Parameters.Add("@bActivityResearch", SqlDbType.Int);
p5.Value = bActivityResearch.Value;
SqlParameter p6 = sqlComm.Parameters.Add("@bActivityRehabilitation", SqlDbType.Int);
p6.Value = bActivityRehabilitation.Value;
SqlParameter p7 = sqlComm.Parameters.Add("@bActivityOther", SqlDbType.Int);
p7.Value = bActivityOther.Value;
SqlParameter p8 = sqlComm.Parameters.Add("@bIsActive", SqlDbType.Int);
p8.Value = bIsActive.Value;
SqlParameter p9 = sqlComm.Parameters.Add("@bIsKef", SqlDbType.Int);
p9.Value = bIsKef.Value;
SqlParameter p10 = sqlComm.Parameters.Add("@cValidationState", SqlDbType.NVarChar, 50);
p10.Value = cValidationState.Value;
TraceDbCommandEvent.Raise(sqlComm);
try
{
sqlComm.ExecuteNonQuery();
TraceCallReturnEvent.Raise();
}
catch (SqlException e)
{
TraceCallReturnEvent.Raise(false);
SqlErrorHandler.Handle(e, cName.ToString());
}
finally
{
FinishSPCall();
}
}示例6: ndihdOrganisationQuestionFormUpdate
public DataSet ndihdOrganisationQuestionFormUpdate(DBString cProgramCategoryRef,
DBGuid uOrganisationRef,
DBGuid uQuestionFormRef,
bool bIsActual,
DBDateTime dLastModifiedByUser,
DBDateTime dLastValidationDate)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdOrganisationQuestionFormUpdate]");
SqlParameter p1 = sqlComm.Parameters.Add("@cProgramCategoryRef", SqlDbType.Char, 3);
p1.Value = cProgramCategoryRef.Value;
SqlParameter p2 = sqlComm.Parameters.Add("@uOrganisationRef", SqlDbType.UniqueIdentifier);
p2.Value = uOrganisationRef.Value;
SqlParameter p3 = sqlComm.Parameters.Add("@uQuestionFormRef", SqlDbType.UniqueIdentifier);
p3.Value = uQuestionFormRef.Value;
SqlParameter p4 = sqlComm.Parameters.Add("@bIsActual", SqlDbType.Bit);
p4.Value = bIsActual;
SqlParameter p5 = sqlComm.Parameters.Add("@dLastModifiedByUser", SqlDbType.DateTime);
p5.Value = dLastModifiedByUser.Value;
SqlParameter p6 = sqlComm.Parameters.Add("@dLastValidationDate", SqlDbType.DateTime);
p6.Value = dLastValidationDate.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, cProgramCategoryRef.ToString());
}
finally
{
FinishSPCall();
}
return Result;
}示例7: ndihdOrganisationQuestionFormInsert
public void ndihdOrganisationQuestionFormInsert(DBString cProgramCategoryRef,
DBGuid uOrganisationRef,
DBGuid uQuestionFormRef)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdOrganisationQuestionFormInsert]");
SqlParameter p1 = sqlComm.Parameters.Add("@cProgramCategoryRef", SqlDbType.Char, 3);
p1.Value = cProgramCategoryRef.Value;
SqlParameter p2 = sqlComm.Parameters.Add("@uOrganisationRef", SqlDbType.UniqueIdentifier);
p2.Value = uOrganisationRef.Value;
SqlParameter p3 = sqlComm.Parameters.Add("@uQuestionFormRef", SqlDbType.UniqueIdentifier);
p3.Value = uQuestionFormRef.Value;
TraceDbCommandEvent.Raise(sqlComm);
try
{
sqlComm.ExecuteNonQuery();
TraceCallReturnEvent.Raise();
}
catch (SqlException e)
{
TraceCallReturnEvent.Raise(false);
SqlErrorHandler.Handle(e, cProgramCategoryRef.ToString());
}
finally
{
FinishSPCall();
}
}示例8: ndihdProgramKeywordSelect
public DataSet ndihdProgramKeywordSelect(DBString cKeywordRef,
DBGuid uProgramRef)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdProgramKeywordSelect]");
SqlParameter p1 = sqlComm.Parameters.Add("@cKeywordRef", SqlDbType.VarChar, 100);
p1.Value = cKeywordRef.Value;
SqlParameter p2 = sqlComm.Parameters.Add("@uProgramRef", SqlDbType.UniqueIdentifier);
p2.Value = uProgramRef.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, cKeywordRef.ToString());
}
finally
{
FinishSPCall();
}
return Result;
}示例9: ndihdProgramKeywordInsert
public void ndihdProgramKeywordInsert(DBString cKeywordRef,
DBGuid uProgramRef)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdProgramKeywordInsert]");
SqlParameter p1 = sqlComm.Parameters.Add("@cKeywordRef", SqlDbType.VarChar, 100);
p1.Value = cKeywordRef.Value;
SqlParameter p2 = sqlComm.Parameters.Add("@uProgramRef", SqlDbType.UniqueIdentifier);
p2.Value = uProgramRef.Value;
TraceDbCommandEvent.Raise(sqlComm);
try
{
sqlComm.ExecuteNonQuery();
TraceCallReturnEvent.Raise();
}
catch (SqlException e)
{
TraceCallReturnEvent.Raise(false);
SqlErrorHandler.Handle(e, cKeywordRef.ToString());
}
finally
{
FinishSPCall();
}
}示例10: ndihdProgramCategoryUpdate
public void ndihdProgramCategoryUpdate(DBString cId,
DBString cName,
DBString cDescription,
DBString cTypeOfEntity)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdProgramCategoryUpdate]");
SqlParameter p1 = sqlComm.Parameters.Add("@cId", SqlDbType.Char, 3);
p1.Value = cId.Value;
SqlParameter p2 = sqlComm.Parameters.Add("@cName", SqlDbType.VarChar, 50);
p2.Value = cName.Value;
SqlParameter p3 = sqlComm.Parameters.Add("@cDescription", SqlDbType.VarChar, 500);
p3.Value = cDescription.Value;
SqlParameter p4 = sqlComm.Parameters.Add("@cTypeOfEntity", SqlDbType.Char, 1);
p4.Value = cTypeOfEntity.Value;
TraceDbCommandEvent.Raise(sqlComm);
try
{
sqlComm.ExecuteNonQuery();
TraceCallReturnEvent.Raise();
}
catch (SqlException e)
{
TraceCallReturnEvent.Raise(false);
SqlErrorHandler.Handle(e, cId.ToString());
}
finally
{
FinishSPCall();
}
}示例11: ndihdProgramCategoryInsert
public void ndihdProgramCategoryInsert(DBString cId,
DBString cName,
DBString cDescription,
DBString cTypeOfEntity,
out int retVal)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdProgramCategoryInsert]");
SqlParameter returnValue = sqlComm.Parameters.Add("@RETURNVALUE", SqlDbType.Int);
returnValue.Direction = ParameterDirection.ReturnValue;
SqlParameter p1 = sqlComm.Parameters.Add("@cId", SqlDbType.Char, 3);
p1.Value = cId.Value;
SqlParameter p2 = sqlComm.Parameters.Add("@cName", SqlDbType.VarChar, 50);
p2.Value = cName.Value;
SqlParameter p3 = sqlComm.Parameters.Add("@cDescription", SqlDbType.VarChar, 500);
p3.Value = cDescription.Value;
SqlParameter p4 = sqlComm.Parameters.Add("@cTypeOfEntity", SqlDbType.Char, 1);
p4.Value = cTypeOfEntity.Value;
TraceDbCommandEvent.Raise(sqlComm);
try
{
sqlComm.ExecuteNonQuery();
TraceCallReturnEvent.Raise();
}
catch (SqlException e)
{
TraceCallReturnEvent.Raise(false);
SqlErrorHandler.Handle(e, cId.ToString());
}
finally
{
FinishSPCall();
}
retVal = (int)returnValue.Value;
TraceInfoEvent.Raise("RetVal: {0}", retVal);
}示例12: ndihdKefContactTypeUpdate
public void ndihdKefContactTypeUpdate(DBString cID,
DBString cName,
bool bMultiple,
DBInt nRank)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdKefContactTypeUpdate]");
SqlParameter p1 = sqlComm.Parameters.Add("@cID", SqlDbType.Char, 10);
p1.Value = cID.Value;
SqlParameter p2 = sqlComm.Parameters.Add("@cName", SqlDbType.VarChar, 250);
p2.Value = cName.Value;
SqlParameter p3 = sqlComm.Parameters.Add("@bMultiple", SqlDbType.Bit);
p3.Value = bMultiple;
SqlParameter p4 = sqlComm.Parameters.Add("@nRank", SqlDbType.Int);
p4.Value = nRank.Value;
TraceDbCommandEvent.Raise(sqlComm);
try
{
sqlComm.ExecuteNonQuery();
TraceCallReturnEvent.Raise();
}
catch (SqlException e)
{
TraceCallReturnEvent.Raise(false);
SqlErrorHandler.Handle(e, cID.ToString());
}
finally
{
FinishSPCall();
}
}示例13: ndihdKefContactTypeOfMembers
public DataSet ndihdKefContactTypeOfMembers(DBString cKefContactTypeRef,
DBGuid uOrganisationKefRef,
out int retVal)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdKefContactTypeOfMembers]");
SqlParameter returnValue = sqlComm.Parameters.Add("@RETURNVALUE", SqlDbType.Int);
returnValue.Direction = ParameterDirection.ReturnValue;
SqlParameter p1 = sqlComm.Parameters.Add("@cKefContactTypeRef", SqlDbType.Char, 10);
p1.Value = cKefContactTypeRef.Value;
SqlParameter p2 = sqlComm.Parameters.Add("@uOrganisationKefRef", SqlDbType.UniqueIdentifier);
p2.Value = uOrganisationKefRef.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, cKefContactTypeRef.ToString());
}
finally
{
FinishSPCall();
}
retVal = (int)returnValue.Value;
TraceInfoEvent.Raise("RetVal: {0}", retVal);
return Result;
}示例14: ndihdKefCategoryOfKefWebDataSelectByIsActive
public DataSet ndihdKefCategoryOfKefWebDataSelectByIsActive(DBString cKefCategoryRef,
DBInt bIsActive)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdKefCategoryOfKefWebDataSelectByIsActive]");
SqlParameter p1 = sqlComm.Parameters.Add("@cKefCategoryRef", SqlDbType.Char, 10);
p1.Value = cKefCategoryRef.Value;
SqlParameter p2 = sqlComm.Parameters.Add("@bIsActive", SqlDbType.Int);
p2.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, cKefCategoryRef.ToString());
}
finally
{
FinishSPCall();
}
return Result;
}示例15: ndihdQualificationOfUserDeleteBy
public void ndihdQualificationOfUserDeleteBy(DBString cQualificationRef)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdQualificationOfUserDeleteBy]");
SqlParameter p1 = sqlComm.Parameters.Add("@cQualificationRef", SqlDbType.Char, 10);
p1.Value = cQualificationRef.Value;
TraceDbCommandEvent.Raise(sqlComm);
try
{
sqlComm.ExecuteNonQuery();
TraceCallReturnEvent.Raise();
}
catch (SqlException e)
{
TraceCallReturnEvent.Raise(false);
SqlErrorHandler.Handle(e, cQualificationRef.ToString());
}
finally
{
FinishSPCall();
}
}