public CStatus GetPlaceHolderDI(long lPlaceHolderID, out CPlaceHolderDataItem di)
{
//initialize parameters
di = null;
//create a status object and check for valid dbconnection
CStatus status = DBConnValid();
if (!status.Status)
{
return(status);
}
//load the paramaters list
CParameterList pList = new CParameterList(SessionID, ClientIP, UserID);
pList.AddInputParameter("pi_nPlaceHolderID", lPlaceHolderID);
//get the dataset
CDataSet cds = new CDataSet();
DataSet ds = null;
status = cds.GetOracleDataSet(DBConn,
"PCK_PLACE_HOLDER.GetPlaceHolderDI",
pList,
out ds);
if (!status.Status)
{
return(status);
}
di = new CPlaceHolderDataItem(ds);
return(status);
}
/// <summary>
/// method
/// US:874 US:902
/// gets the syntax for the static place holder
/// </summary>
/// <returns></returns>
protected string GetStaticSyntax()
{
if (lbStaticSpecifier.SelectedIndex < 0)
{
return(string.Empty);
}
string strSyntax = string.Empty;
CPlaceHolderData PHData = new CPlaceHolderData(BaseMstr.BaseData);
CPlaceHolderDataItem di = null;
CStatus status = PHData.GetPlaceHolderDI(Convert.ToInt64(lbStatic.SelectedValue), out di);
if (di == null)
{
return(string.Empty);
}
strSyntax = di.PlaceHolderSyntax;
status = PHData.GetPlaceHolderDI(Convert.ToInt64(lbStaticSpecifier.SelectedValue), out di);
if (di == null)
{
return(string.Empty);
}
strSyntax += CExpression.SpecifierTkn + di.PlaceHolderSyntax;
return(CExpression.BeginPHTkn + strSyntax + CExpression.EndPHTkn);
}
/// <summary>
/// method
/// US:874 US:902
/// gets the syntax for the item place holder
/// </summary>
/// <returns></returns>
protected string GetItemSyntax()
{
CPlaceHolderData PHData = new CPlaceHolderData(BaseMstr.BaseData);
CPlaceHolderDataItem di = null;
CStatus status = new CStatus();
string strSyntax = string.Empty;
if (lbItemPH.SelectedIndex >= 0 && lbItem.SelectedIndex >= 0)
{
status = PHData.GetPlaceHolderDI(Convert.ToInt64(lbItemPH.SelectedValue), out di);
if (di == null)
{
return(string.Empty);
}
strSyntax = lbItem.SelectedItem.Text + CExpression.SpecifierTkn + di.PlaceHolderSyntax;
strSyntax = CExpression.BeginPHTkn + strSyntax + CExpression.EndPHTkn;
}
else if (lbItemCompPH.SelectedIndex >= 0 &&
lbItemComponent.SelectedIndex >= 0 &&
lbItem.SelectedIndex >= 0)
{
status = PHData.GetPlaceHolderDI(Convert.ToInt64(lbItemCompPH.SelectedValue), out di);
if (di == null)
{
return(string.Empty);
}
strSyntax = lbItem.SelectedItem.Text + CExpression.SpecifierTkn + lbItemComponent.SelectedItem.Text + CExpression.SpecifierTkn + di.PlaceHolderSyntax;
strSyntax = CExpression.BeginPHTkn + strSyntax + CExpression.EndPHTkn;
}
return(strSyntax);
}
/// <summary>
/// method
/// US:874 US:902
/// gets the syntax for the operator place holder
/// </summary>
/// <returns></returns>
protected string GetOperatorSyntax()
{
CPlaceHolderData PHData = new CPlaceHolderData(BaseMstr.BaseData);
CPlaceHolderDataItem di = null;
string strSyntax = string.Empty;
if (lbOperatorSubGroup.SelectedIndex >= 0)
{
PHData.GetPlaceHolderDI(Convert.ToInt64(lbOperatorSubGroup.SelectedValue), out di);
if (di == null)
{
return(string.Empty);
}
strSyntax = di.PlaceHolderSyntax;
}
else if (lbOperator.SelectedIndex >= 0 &&
Convert.ToInt32(lbOperator.SelectedValue) != k_BOOLEAN &&
Convert.ToInt32(lbOperator.SelectedValue) != k_ARITHMETIC)
{
PHData.GetPlaceHolderDI(Convert.ToInt64(lbOperator.SelectedValue), out di);
if (di == null)
{
return(string.Empty);
}
strSyntax = di.PlaceHolderSyntax;
}
return(strSyntax);
}
/// <summary>
/// method
/// US:874 US:902
/// gets the syntax for the action place holder
/// </summary>
/// <returns></returns>
protected string GetActionSyntax()
{
CPlaceHolderData PHData = new CPlaceHolderData(BaseMstr.BaseData);
CPlaceHolderDataItem di = null;
string strSyntax = string.Empty;
if (lbActionValue.SelectedIndex >= 0 &&
lbActionSpecifier.SelectedIndex >= 0 &&
lbAction.SelectedIndex >= 0)
{
PHData.GetPlaceHolderDI(Convert.ToInt64(lbActionSpecifier.SelectedValue), out di);
if (di == null)
{
return(string.Empty);
}
strSyntax = di.PlaceHolderSyntax;
PHData.GetPlaceHolderDI(Convert.ToInt64(lbAction.SelectedValue), out di);
if (di == null)
{
return(string.Empty);
}
strSyntax += CExpression.SpecifierTkn + di.PlaceHolderSyntax;
strSyntax += CExpression.ParamStartTkn + lbActionValue.SelectedItem.Text + CExpression.ParamEndTkn;
}
else if (lbActionSpecifier.SelectedIndex >= 0 &&
Convert.ToInt32(lbActionSpecifier.SelectedValue) != k_TEMPORAL_STATE &&
Convert.ToInt32(lbActionSpecifier.SelectedValue) != k_OUTCOME_STATE &&
Convert.ToInt32(lbActionSpecifier.SelectedValue) != k_DECISION_STATE &&
lbAction.SelectedIndex >= 0)
{
PHData.GetPlaceHolderDI(Convert.ToInt64(lbActionSpecifier.SelectedValue), out di);
if (di == null)
{
return(string.Empty);
}
strSyntax = di.PlaceHolderSyntax;
PHData.GetPlaceHolderDI(Convert.ToInt64(lbAction.SelectedValue), out di);
if (di == null)
{
return(string.Empty);
}
strSyntax += CExpression.SpecifierTkn + di.PlaceHolderSyntax + CExpression.ParamStartTkn + CExpression.ParamEndTkn;
}
return(strSyntax);
}
