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); }