Exemplo n.º 1
0
        public XVar report_error(XVar _param_message)
        {
            XVar message = _param_message.Clone();

            MVCFunctions.EchoToOutput(message);
            return(null);
        }
Exemplo n.º 2
0
        public static XVar getValues()
        {
            dynamic ctx = null;

            ctx = XVar.Clone(current());
            return(ctx.getValues());
        }
Exemplo n.º 3
0
        private void buildRiskMasterPaymentErrorList(dynamic record, string errorMessage)
        {
            XVar insertErrorRow = buildPfImportRecordPrimaryKeyClause(record);

            insertErrorRow.SetArrayItem("ERROR_DESCR", errorMessage);
            insertErrorList.Add(insertErrorRow);
        }
Exemplo n.º 4
0
        public virtual XVar getSecCtrlParamsArr(dynamic _param_fName, dynamic _param_recId, dynamic _param_fieldNum, dynamic _param_value, dynamic _param_opt, dynamic _param_renderHidden = null, dynamic _param_isCached = null)
        {
            #region default values
            if (_param_renderHidden as Object == null)
            {
                _param_renderHidden = new XVar(false);
            }
            if (_param_isCached as Object == null)
            {
                _param_isCached = new XVar(true);
            }
            #endregion

            #region pass-by-value parameters
            dynamic fName        = XVar.Clone(_param_fName);
            dynamic recId        = XVar.Clone(_param_recId);
            dynamic fieldNum     = XVar.Clone(_param_fieldNum);
            dynamic value        = XVar.Clone(_param_value);
            dynamic opt          = XVar.Clone(_param_opt);
            dynamic renderHidden = XVar.Clone(_param_renderHidden);
            dynamic isCached     = XVar.Clone(_param_isCached);
            #endregion

            dynamic fType = null;
            fType = XVar.Clone(this.pSet.getEditFormat((XVar)(fName)));
            if (XVar.Pack(isNeedSecondCtrl((XVar)(fName))))
            {
                return(getCtrlParamsArr((XVar)(fName), (XVar)(recId), (XVar)(fieldNum + 1), (XVar)(value), (XVar)(opt), (XVar)(renderHidden), (XVar)(isCached)));
            }
            return(false);
        }
Exemplo n.º 5
0
        public virtual XVar getCtrlParamsArr(dynamic _param_fName, dynamic _param_recId, dynamic _param_fieldNum, dynamic _param_value, dynamic _param_opt, dynamic _param_renderHidden = null, dynamic _param_isCached = null)
        {
            #region default values
            if (_param_renderHidden as Object == null)
            {
                _param_renderHidden = new XVar(false);
            }
            if (_param_isCached as Object == null)
            {
                _param_isCached = new XVar(true);
            }
            #endregion

            #region pass-by-value parameters
            dynamic fName        = XVar.Clone(_param_fName);
            dynamic recId        = XVar.Clone(_param_recId);
            dynamic fieldNum     = XVar.Clone(_param_fieldNum);
            dynamic value        = XVar.Clone(_param_value);
            dynamic opt          = XVar.Clone(_param_opt);
            dynamic renderHidden = XVar.Clone(_param_renderHidden);
            dynamic isCached     = XVar.Clone(_param_isCached);
            #endregion

            dynamic parameters = null;
            parameters = XVar.Clone(buildCtrlParamsArr((XVar)(fName), (XVar)(recId), (XVar)(fieldNum), (XVar)(value), (XVar)(opt), (XVar)(renderHidden), (XVar)(isCached)));
            return(XTempl.create_function_assignment(new XVar("xt_buildeditcontrol"), (XVar)(parameters)));
        }
Exemplo n.º 6
0
        public virtual XVar loadLookupContent(dynamic _param_parentValuesData, dynamic _param_childVal = null, dynamic _param_doCategoryFilter = null, dynamic _param_initialLoad = null)
        {
            #region default values
            if (_param_childVal as Object == null)
            {
                _param_childVal = new XVar("");
            }
            if (_param_doCategoryFilter as Object == null)
            {
                _param_doCategoryFilter = new XVar(true);
            }
            if (_param_initialLoad as Object == null)
            {
                _param_initialLoad = new XVar(true);
            }
            #endregion

            #region pass-by-value parameters
            dynamic parentValuesData = XVar.Clone(_param_parentValuesData);
            dynamic childVal         = XVar.Clone(_param_childVal);
            dynamic doCategoryFilter = XVar.Clone(_param_doCategoryFilter);
            dynamic initialLoad      = XVar.Clone(_param_initialLoad);
            #endregion

            return("");
        }
Exemplo n.º 7
0
        protected override XVar getSubsetSQLComponents()
        {
            dynamic selectedRecords = XVar.Array(), sql = XVar.Array();

            sql             = XVar.Clone(XVar.Array());
            selectedRecords = XVar.Clone(getSelectedRecords());
            if (!XVar.Equals(XVar.Pack(selectedRecords), XVar.Pack(null)))
            {
                dynamic selectedWhereParts = XVar.Array();
                sql.InitAndSetArrayItem(this.gQuery.getSqlComponents(), "sqlParts");
                selectedWhereParts = XVar.Clone(XVar.Array());
                foreach (KeyValuePair <XVar, dynamic> keys in selectedRecords.GetEnumerator())
                {
                    selectedWhereParts.InitAndSetArrayItem(CommonFunctions.KeyWhere((XVar)(keys.Value)), null);
                }
                sql.InitAndSetArrayItem(MVCFunctions.implode(new XVar(" or "), (XVar)(selectedWhereParts)), "mandatoryWhere", null);
                if (0 == MVCFunctions.count(selectedRecords))
                {
                    sql.InitAndSetArrayItem("1=0", "mandatoryWhere", null);
                }
            }
            else
            {
                sql = XVar.Clone(base.getSubsetSQLComponents());
            }
            if (this.connection.dbType == Constants.nDATABASE_DB2)
            {
                sql["sqlParts"]["head"] = MVCFunctions.Concat(sql["sqlParts"]["head"], ", ROW_NUMBER() over () as DB2_ROW_NUMBER ");
            }
            sql.InitAndSetArrayItem(SecuritySQL(new XVar("Export"), (XVar)(this.tName)), "mandatoryWhere", null);
            return(sql);
        }
Exemplo n.º 8
0
        public virtual XVar getFullUrl()
        {
            dynamic https = null;

            https = XVar.Clone((XVar)(MVCFunctions.strlen((XVar)(MVCFunctions.GetServerVariable("HTTPS"))) != 0) && (XVar)(!XVar.Equals(XVar.Pack(MVCFunctions.GetServerVariable("HTTPS")), XVar.Pack("off"))));
            return(MVCFunctions.Concat((XVar.Pack(https) ? XVar.Pack("https://") : XVar.Pack("http://")), (XVar.Pack(MVCFunctions.strlen((XVar)(MVCFunctions.GetRemoteUser())) != 0) ? XVar.Pack(MVCFunctions.Concat(MVCFunctions.GetRemoteUser(), "@")) : XVar.Pack("")), (XVar.Pack(MVCFunctions.SERVERKeyExists("HTTP_HOST")) ? XVar.Pack(MVCFunctions.GetServerVariable("HTTP_HOST")) : XVar.Pack(MVCFunctions.Concat(MVCFunctions.GetServerName(), (XVar.Pack((XVar)((XVar)(https) && (XVar)(XVar.Equals(XVar.Pack(MVCFunctions.GetServerPort()), XVar.Pack(443)))) || (XVar)(XVar.Equals(XVar.Pack(MVCFunctions.GetServerPort()), XVar.Pack(80)))) ? XVar.Pack("") : XVar.Pack(MVCFunctions.Concat(":", MVCFunctions.GetServerPort())))))), MVCFunctions.substr((XVar)(MVCFunctions.GetScriptName()), new XVar(0), (XVar)(MVCFunctions.strrpos((XVar)(MVCFunctions.GetScriptName()), new XVar("/"))))));
        }
Exemplo n.º 9
0
        public override XVar addSpansForGridCells(dynamic _param_type, dynamic record, dynamic _param_data = null)
        {
            #region default values
            if (_param_data as Object == null)
            {
                _param_data = new XVar();
            }
            #endregion

            #region pass-by-value parameters
            dynamic var_type = XVar.Clone(_param_type);
            dynamic data     = XVar.Clone(_param_data);
            #endregion

            if (var_type == "add")
            {
                base.addSpansForGridCells((XVar)(var_type), (XVar)(record), (XVar)(data));
                return(null);
            }
            if (XVar.Pack(!(XVar)(data == null)))
            {
                dynamic dispVal = null;
                if (XVar.Pack(this.dispFieldAlias))
                {
                    dispVal = XVar.Clone(data[this.dispFieldAlias]);
                }
                else
                {
                    dispVal = XVar.Clone(data[this.dispField]);
                }
                this.lookupValuesArr.InitAndSetArrayItem(new XVar("linkVal", data[this.linkField], "dispVal", dispVal), null);
            }
            return(null);
        }
Exemplo n.º 10
0
        public override XVar xt_doevent(dynamic _param_params)
        {
            XVar var_params = _param_params.Clone();
            XVar eventName, eventObj;

            if (this.xt_events.KeyExists(var_params["custom1"]))
            {
                XVar eventArr;
                eventArr = this.xt_events[var_params["custom1"]];
                if (eventArr.KeyExists("method"))
                {
                    XVar method;
                    var_params = new XVar();
                    if (eventArr.KeyExists("params"))
                    {
                        var_params = eventArr["params"];
                    }
                    method = eventArr["method"];
                    return(eventArr["object"].Invoke(method, var_params));
                }
            }

            eventObj = GlobalVars.globalEvents;
            if (!eventObj)
            {
                return(null);
            }
            eventName = var_params["custom1"];
            if (!eventObj.Invoke("exists", eventName))
            {
                return(null);
            }
            return(eventObj.Invoke("event_" + MVCFunctions.GoodFieldName(eventName).ToString(), var_params));
        }
Exemplo n.º 11
0
        public virtual XVar buildUserFile(dynamic _param_file)
        {
            #region pass-by-value parameters
            dynamic file = XVar.Clone(_param_file);
            #endregion

            dynamic hasThumbnail = null, userFile = XVar.Array();
            userFile = XVar.Clone(XVar.Array());
            userFile.InitAndSetArrayItem(file["usrName"], "name");
            userFile.InitAndSetArrayItem(file["size"], "size");
            userFile.InitAndSetArrayItem(file["type"], "type");
            userFile.InitAndSetArrayItem(CommonFunctions.CheckImageExtension((XVar)(file["name"])) != false, "isImg");
            if (XVar.Pack(file["error"]))
            {
                userFile.InitAndSetArrayItem(file["error"], "error");
            }
            hasThumbnail = XVar.Clone(file["thumbnail"] != "");
            userFile.InitAndSetArrayItem(MVCFunctions.GetTableLink(new XVar("mfhandler"), new XVar(""), (XVar)(MVCFunctions.Concat("file=", MVCFunctions.RawUrlEncode((XVar)(userFile["name"])), "&table=", MVCFunctions.RawUrlEncode((XVar)(this.table)), "&field=", MVCFunctions.RawUrlEncode((XVar)(this.field)), "&pageType=", MVCFunctions.RawUrlEncode((XVar)(this.pageType)), (XVar.Pack(this.tkeys != "") ? XVar.Pack(this.tkeys) : XVar.Pack(MVCFunctions.Concat("&fkey=", this.formStamp)))))), "url");
            if (XVar.Pack(hasThumbnail))
            {
                userFile.InitAndSetArrayItem(MVCFunctions.Concat(userFile["url"], "&thumbnail=1"), "thumbnail_url");
            }
            else
            {
                userFile.InitAndSetArrayItem("", "thumbnail_url");
            }
            return(userFile);
        }
Exemplo n.º 12
0
        public static XVar create_method_assignment(XVar method, object var_object, XVar _params = null)
        {
            var ret = XVar.Array();

            ret["method"] = (XVar)MVCFunctions.AssignMethod(method, var_object, _params);
            return(ret);
        }
Exemplo n.º 13
0
        public static XVar create_function_assignment(XVar func, XVar _params, XVar obj = null)
        {
            var ret = XVar.Array();

            ret["func"] = (XVar)MVCFunctions.AssignFunction(func, _params, obj);
            return(ret);
        }
Exemplo n.º 14
0
        private void WriteToPage(object page, XVar objectToWrite)
        {
            if (objectToWrite.IsArray())
            {
                if (objectToWrite.KeyExists("method"))
                {
                    XVar             parameters    = objectToWrite.KeyExists("params") ? objectToWrite["params"] : new XVar();
                    xtMethodDelegate invokedMethod = (xtMethodDelegate)objectToWrite["method"].Value;

                    MVCFunctions.ob_start();
                    var result    = invokedMethod.Invoke(parameters);
                    var resultStr = result as object == null ? "" : result.ToString();


                    MvcHtmlString textToWrite = MvcHtmlString.Create(MVCFunctions.ob_get_contents() + resultStr);
                    MVCFunctions.ob_end_clean();

                    page.GetType().GetMethod("Write", new Type[] { typeof(MvcHtmlString) }).Invoke(page, new object[] { textToWrite });
                }
            }
            else
            {
                page.GetType().GetMethod("Write", new Type[] { typeof(MvcHtmlString) }).Invoke(page, new object[] { MvcHtmlString.Create(objectToWrite.ToString()) });
            }
        }
Exemplo n.º 15
0
        public override XVar getFieldValueCopy(dynamic _param_fieldValue)
        {
            #region pass-by-value parameters
            dynamic fieldValue = XVar.Clone(_param_fieldValue);
            #endregion

            dynamic absoluteUploadDirPath = null, filesData = XVar.Array(), uploadFolder = null;
            initUploadHandler();
            uploadFolder          = XVar.Clone(this.pageObject.pSetEdit.getUploadFolder((XVar)(this.field)));
            absoluteUploadDirPath = XVar.Clone(this.pageObject.pSetEdit.getFinalUploadFolder((XVar)(this.field)));
            filesData             = XVar.Clone(MVCFunctions.my_json_decode((XVar)(fieldValue)));
            if ((XVar)(!(XVar)(MVCFunctions.is_array((XVar)(filesData)))) || (XVar)(MVCFunctions.count(filesData) == 0))
            {
                return(fieldValue);
            }
            foreach (KeyValuePair <XVar, dynamic> fileData in filesData.GetEnumerator())
            {
                dynamic info = XVar.Array(), newFieldName = null;
                info         = XVar.Clone(this.upload_handler.pathinfo_local((XVar)(fileData.Value["usrName"])));
                newFieldName = XVar.Clone(this.upload_handler.tempnam_sfx((XVar)(absoluteUploadDirPath), (XVar)(info["filename"]), (XVar)(info["extension"])));
                MVCFunctions.runner_copy_file((XVar)(MVCFunctions.getabspath((XVar)(fileData.Value["name"]))), (XVar)(MVCFunctions.Concat(absoluteUploadDirPath, newFieldName)));
                filesData.InitAndSetArrayItem(MVCFunctions.Concat(uploadFolder, newFieldName), fileData.Key, "name");
                if (XVar.Pack(this.pageObject.pSetEdit.getCreateThumbnail((XVar)(this.field))))
                {
                    dynamic newThumbName = null, thumbnailPrefix = null;
                    thumbnailPrefix = XVar.Clone(this.pageObject.pSetEdit.getStrThumbnail((XVar)(this.field)));
                    newThumbName    = XVar.Clone(this.upload_handler.tempnam_sfx((XVar)(absoluteUploadDirPath), (XVar)(MVCFunctions.Concat(thumbnailPrefix, info["filename"])), (XVar)(info["extension"])));
                    MVCFunctions.runner_copy_file((XVar)(MVCFunctions.getabspath((XVar)(fileData.Value["thumbnail"]))), (XVar)(MVCFunctions.Concat(absoluteUploadDirPath, newThumbName)));
                    filesData.InitAndSetArrayItem(MVCFunctions.Concat(uploadFolder, newThumbName), fileData.Key, "thumbnail");
                }
            }
            return(MVCFunctions.my_json_encode((XVar)(filesData)));
        }
Exemplo n.º 16
0
        public override XVar showPage()
        {
            dynamic bricksExcept = XVar.Array();

            BeforeShowList();
            if (XVar.Pack(mobileTemplateMode()))
            {
                this.xt.assign(new XVar("cancelbutton_block"), new XVar(true));
                this.xt.assign(new XVar("searchform_block"), new XVar(true));
                this.xt.assign(new XVar("searchform_showall"), new XVar(true));
                bricksExcept = XVar.Clone(new XVar(0, "grid_mobile", 1, "message", 2, "pagination", 3, "vmsearch2", 4, "cancelbutton_mobile"));
            }
            else
            {
                bricksExcept = XVar.Clone(new XVar(0, "grid", 1, "message", 2, "pagination", 3, "vsearch1", 4, "vsearch2", 5, "search", 6, "recordcontrols_new", 7, "bsgrid_tabs"));
                if (getLayoutVersion() == Constants.BOOTSTRAP_LAYOUT)
                {
                    bricksExcept.InitAndSetArrayItem("add", null);
                    bricksExcept.InitAndSetArrayItem("reorder_records", null);
                }
            }
            this.xt.hideAllBricksExcept((XVar)(bricksExcept));
            this.xt.prepare_template((XVar)(this.templatefile));
            showPageAjax();
            return(null);
        }
Exemplo n.º 17
0
        public virtual XVar updateUserGroups(dynamic _param_user, dynamic _param_groups)
        {
            #region pass-by-value parameters
            dynamic user   = XVar.Clone(_param_user);
            dynamic groups = XVar.Clone(_param_groups);
            #endregion

            dynamic grConnection = null, groupIdWFieldName = null, membersWTableName = null, userNameWFieldName = null;
            grConnection       = XVar.Clone(GlobalVars.cman.getForUserGroups());
            membersWTableName  = XVar.Clone(grConnection.addTableWrappers(new XVar("dbo.acceso_ugmembers")));
            userNameWFieldName = XVar.Clone(grConnection.addFieldWrappers(new XVar("UserName")));
            groupIdWFieldName  = XVar.Clone(grConnection.addFieldWrappers(new XVar("GroupID")));
            foreach (KeyValuePair <XVar, dynamic> state in groups.GetEnumerator())
            {
                dynamic sql = null;
                if (state.Value == 1)
                {
                    sql = XVar.Clone(MVCFunctions.Concat("insert into ", membersWTableName, " (", userNameWFieldName, ", ", groupIdWFieldName, ") values (", grConnection.prepareString((XVar)(user)), ",", state.Key, ")"));
                }
                else
                {
                    sql = XVar.Clone(MVCFunctions.Concat("delete from ", membersWTableName, " where ", userNameWFieldName, "=", grConnection.prepareString((XVar)(user)), " and ", groupIdWFieldName, "=", state.Key));
                }
                grConnection.exec((XVar)(sql));
            }
            return(null);
        }
Exemplo n.º 18
0
        public override XVar SecuritySQL(dynamic _param_strAction, dynamic _param_table = null)
        {
            #region default values
            if (_param_table as Object == null)
            {
                _param_table = new XVar("");
            }
            #endregion

            #region pass-by-value parameters
            dynamic strAction = XVar.Clone(_param_strAction);
            dynamic table     = XVar.Clone(_param_table);
            #endregion

            dynamic strPerm = null;
            if (XVar.Pack(!(XVar)(MVCFunctions.strlen((XVar)(table)))))
            {
                table = XVar.Clone(GlobalVars.strTableName);
            }
            strPerm = XVar.Clone(CommonFunctions.GetUserPermissions((XVar)(table)));
            if (XVar.Equals(XVar.Pack(MVCFunctions.strpos((XVar)(strPerm), new XVar("S"))), XVar.Pack(false)))
            {
                strPerm = MVCFunctions.Concat(strPerm, "S");
            }
            return(CommonFunctions.SecuritySQL((XVar)(strAction), (XVar)(table), (XVar)(strPerm)));
        }
Exemplo n.º 19
0
        public virtual XVar exportTo(dynamic _param_type, dynamic _param_rs, dynamic _param_nPageSize)
        {
            #region pass-by-value parameters
            dynamic var_type  = XVar.Clone(_param_type);
            dynamic rs        = XVar.Clone(_param_rs);
            dynamic nPageSize = XVar.Clone(_param_nPageSize);
            #endregion

            if (MVCFunctions.substr((XVar)(var_type), new XVar(0), new XVar(5)) == "excel")
            {
                GlobalVars.locale_info.InitAndSetArrayItem("0", "LOCALE_SGROUPING");
                GlobalVars.locale_info.InitAndSetArrayItem("0", "LOCALE_SMONGROUPING");
                CommonFunctions.ExportToExcel((XVar)(rs), (XVar)(nPageSize), (XVar)(this.eventsObject), (XVar)(this.cipherer), this);
                return(null);
            }
            if (var_type == "word")
            {
                ExportToWord((XVar)(rs), (XVar)(nPageSize));
                return(null);
            }
            if (var_type == "xml")
            {
                ExportToXML((XVar)(rs), (XVar)(nPageSize));
                return(null);
            }
            if (var_type == "csv")
            {
                GlobalVars.locale_info.InitAndSetArrayItem("0", "LOCALE_SGROUPING");
                GlobalVars.locale_info.InitAndSetArrayItem(".", "LOCALE_SDECIMAL");
                GlobalVars.locale_info.InitAndSetArrayItem("0", "LOCALE_SMONGROUPING");
                GlobalVars.locale_info.InitAndSetArrayItem(".", "LOCALE_SMONDECIMALSEP");
                ExportToCSV((XVar)(rs), (XVar)(nPageSize));
            }
            return(null);
        }
Exemplo n.º 20
0
 public virtual XVar initLookupParams()
 {
     if ((XVar)(this.mainPageType != Constants.PAGE_ADD) && (XVar)(this.mainPageType != Constants.PAGE_EDIT))
     {
         this.mainPageType = new XVar(Constants.PAGE_SEARCH);
     }
     this.mainPSet  = XVar.Clone(new ProjectSettings((XVar)(this.mainTable), (XVar)(this.mainPageType)));
     this.linkField = XVar.Clone(this.mainPSet.getLinkField((XVar)(this.mainField)));
     this.dispField = XVar.Clone(this.mainPSet.getDisplayField((XVar)(this.mainField)));
     if (XVar.Pack(this.mainPSet.getCustomDisplay((XVar)(this.mainField))))
     {
         this.dispFieldAlias = XVar.Clone(CommonFunctions.GetGlobalData(new XVar("dispFieldAlias"), new XVar("rrdf1")));
         this.customField    = XVar.Clone(this.linkField);
     }
     outputFieldValue((XVar)(this.linkField), new XVar(2));
     outputFieldValue((XVar)(this.dispField), new XVar(2));
     if ((XVar)(this.dispFieldAlias) && (XVar)(this.pSet.appearOnListPage((XVar)(this.dispField))))
     {
         this.lookupSelectField = XVar.Clone(this.dispField);
     }
     else
     {
         if (XVar.Pack(this.pSet.appearOnListPage((XVar)(this.dispField))))
         {
             this.lookupSelectField = XVar.Clone(this.dispField);
         }
         else
         {
             this.lookupSelectField = XVar.Clone(this.listFields[0]["fName"]);
         }
     }
     this.mainContext = XVar.Clone(getMainContext());
     return(null);
 }
Exemplo n.º 21
0
        protected virtual XVar getControlMap(dynamic _param_fName, dynamic _param_format, dynamic _param_recId, dynamic _param_fieldNum, dynamic _param_hidden, dynamic _param_value)
        {
            #region pass-by-value parameters
            dynamic fName    = XVar.Clone(_param_fName);
            dynamic format   = XVar.Clone(_param_format);
            dynamic recId    = XVar.Clone(_param_recId);
            dynamic fieldNum = XVar.Clone(_param_fieldNum);
            dynamic hidden   = XVar.Clone(_param_hidden);
            dynamic value    = XVar.Clone(_param_value);
            #endregion

            dynamic ctrlsMap = XVar.Array(), preload = null;
            ctrlsMap = XVar.Clone(new XVar("controls", XVar.Array()));
            ctrlsMap.InitAndSetArrayItem(fName, "controls", "fieldName");
            ctrlsMap.InitAndSetArrayItem(Constants.MODE_SEARCH, "controls", "mode");
            ctrlsMap.InitAndSetArrayItem(format, "controls", "editFormat");
            ctrlsMap.InitAndSetArrayItem(recId, "controls", "id");
            ctrlsMap.InitAndSetArrayItem(fieldNum, "controls", "ctrlInd");
            ctrlsMap.InitAndSetArrayItem(hidden, "controls", "hidden");
            ctrlsMap.InitAndSetArrayItem(this.tName, "controls", "table");
            preload = XVar.Clone(this.pageObj.fillPreload((XVar)(fName), (XVar)(new XVar(0, fName)), (XVar)(new XVar(fName, value)), (XVar)(this.controlsContainer)));
            if (!XVar.Equals(XVar.Pack(preload), XVar.Pack(false)))
            {
                ctrlsMap.InitAndSetArrayItem(preload, "controls", "preloadData");
            }
            return(ctrlsMap);
        }
Exemplo n.º 22
0
        public override XVar SQLWhere(dynamic _param_SearchFor, dynamic _param_strSearchOption, dynamic _param_SearchFor2, dynamic _param_etype, dynamic _param_isSuggest)
        {
            #region pass-by-value parameters
            dynamic SearchFor       = XVar.Clone(_param_SearchFor);
            dynamic strSearchOption = XVar.Clone(_param_strSearchOption);
            dynamic SearchFor2      = XVar.Clone(_param_SearchFor2);
            dynamic etype           = XVar.Clone(_param_etype);
            dynamic isSuggest       = XVar.Clone(_param_isSuggest);
            #endregion

            dynamic baseResult = null, gstrField = null;
            baseResult = XVar.Clone(baseSQLWhere((XVar)(strSearchOption)));
            if (XVar.Equals(XVar.Pack(baseResult), XVar.Pack(false)))
            {
                return("");
            }
            if (baseResult != XVar.Pack(""))
            {
                return(baseResult);
            }
            if (XVar.Pack(CommonFunctions.IsCharType((XVar)(this.var_type))))
            {
                gstrField = XVar.Clone(getFieldSQLDecrypt());
                if ((XVar)((XVar)(!(XVar)(this.btexttype)) && (XVar)(!(XVar)(this.pageObject.cipherer.isFieldPHPEncrypted((XVar)(this.field))))) && (XVar)(this.pageObject.pSetEdit.getNCSearch()))
                {
                    gstrField = XVar.Clone(this.connection.upper((XVar)(gstrField)));
                }
            }
            else
            {
                if ((XVar)(strSearchOption == "Contains") || (XVar)(strSearchOption == "Starts with"))
                {
                    gstrField = XVar.Clone(this.connection.field2char((XVar)(getFieldSQLDecrypt()), (XVar)(this.var_type)));
                }
                else
                {
                    gstrField = XVar.Clone(getFieldSQLDecrypt());
                }
            }
            if ((XVar)(strSearchOption == "Contains") || (XVar)(strSearchOption == "Starts with"))
            {
                SearchFor = XVar.Clone(this.connection.escapeLIKEpattern((XVar)(SearchFor)));
            }
            if (strSearchOption == "Contains")
            {
                SearchFor = XVar.Clone(MVCFunctions.Concat("%", SearchFor, "%"));
            }
            else
            {
                if (strSearchOption == "Starts with")
                {
                    SearchFor = XVar.Clone(MVCFunctions.Concat(SearchFor, "%"));
                }
            }
            if ((XVar)((XVar)(strSearchOption == "Contains") || (XVar)(strSearchOption == "Starts with")) || (XVar)(strSearchOption == "Equals"))
            {
                return(buildWhere((XVar)(gstrField), (XVar)(SearchFor), (XVar)(strSearchOption == "Equals")));
            }
            return("");
        }
Exemplo n.º 23
0
        public virtual XVar getSearchRadio()
        {
            dynamic id508l = null, id508n = null, resArr = XVar.Array();

            resArr = XVar.Clone(XVar.Array());
            resArr.InitAndSetArrayItem(new XVar(0, "", 1, ""), "all_checkbox_label");
            resArr.InitAndSetArrayItem(new XVar(0, "", 1, ""), "any_checkbox_label");
            if (XVar.Pack(CommonFunctions.isEnableSection508()))
            {
                resArr.InitAndSetArrayItem(new XVar(0, "<label for=\"all_checkbox\">", 1, "</label>"), "all_checkbox_label");
                resArr.InitAndSetArrayItem(new XVar(0, "<label for=\"any_checkbox\">", 1, "</label>"), "any_checkbox_label");
            }
            id508l = new XVar("id=\"all_checkbox\" ");
            id508n = new XVar("id=\"any_checkbox\" ");
            resArr.InitAndSetArrayItem(id508l, "all_checkbox");
            resArr.InitAndSetArrayItem(id508n, "any_checkbox");
            resArr["all_checkbox"] = MVCFunctions.Concat(resArr["all_checkbox"], "value=\"and\" ");
            resArr["any_checkbox"] = MVCFunctions.Concat(resArr["any_checkbox"], "value=\"or\" ");
            if ((XVar)(this.globSrchParams.KeyExists("srchTypeRadio")) && (XVar)(this.globSrchParams["srchTypeRadio"] == "or"))
            {
                resArr["any_checkbox"] = MVCFunctions.Concat(resArr["any_checkbox"], " checked");
            }
            else
            {
                resArr["all_checkbox"] = MVCFunctions.Concat(resArr["all_checkbox"], " checked");
            }
            return(resArr);
        }
Exemplo n.º 24
0
        public virtual XVar buildWhere(dynamic _param_gstrField, dynamic _param_value, dynamic _param_equals = null)
        {
            #region default values
            if (_param_equals as Object == null)
            {
                _param_equals = new XVar(false);
            }
            #endregion

            #region pass-by-value parameters
            dynamic gstrField = XVar.Clone(_param_gstrField);
            dynamic value     = XVar.Clone(_param_value);
            dynamic equals    = XVar.Clone(_param_equals);
            #endregion

            dynamic likeVal = null, notLikeVal = null, testSymbols = null;
            likeVal    = XVar.Clone(this.connection.prepareString((XVar)(MVCFunctions.Concat("%searchStr\":\"", value, ":sStrEnd\"%"))));
            notLikeVal = XVar.Clone(this.connection.prepareString((XVar)(value)));
            if ((XVar)((XVar)(!(XVar)(this.btexttype)) && (XVar)(CommonFunctions.IsCharType((XVar)(this.var_type)))) && (XVar)(this.pageObject.pSetEdit.getNCSearch()))
            {
                likeVal    = XVar.Clone(this.connection.upper((XVar)(likeVal)));
                notLikeVal = XVar.Clone(this.connection.upper((XVar)(notLikeVal)));
            }
            if (this.connection.dbType == Constants.nDATABASE_Access)
            {
                testSymbols = new XVar("'_{%}_'");
            }
            else
            {
                testSymbols = new XVar("'[{%'");
            }
            return(MVCFunctions.Concat("((", gstrField, " ", this.var_like, " ", testSymbols, " and ", gstrField, " ", this.var_like, " ", likeVal, ") or (", gstrField, " not ", this.var_like, " ", testSymbols, " and ", gstrField, " ", (XVar.Pack(equals) ? XVar.Pack("=") : XVar.Pack(this.var_like)), " ", notLikeVal, "))"));
        }
Exemplo n.º 25
0
        public RunnerContext()
        {
            dynamic context = null;

            context = XVar.Clone(new RunnerContextItem(new XVar(Constants.CONTEXT_GLOBAL), (XVar)(XVar.Array())));
            this.stack.InitAndSetArrayItem(context, MVCFunctions.count(this.stack));
        }
Exemplo n.º 26
0
        public override XVar getSearchOptions(dynamic _param_selOpt, dynamic _param_not, dynamic _param_both)
        {
            #region pass-by-value parameters
            dynamic selOpt  = XVar.Clone(_param_selOpt);
            dynamic var_not = XVar.Clone(_param_not);
            dynamic both    = XVar.Clone(_param_both);
            #endregion

            dynamic isPHPEncripted = null, optionsArray = XVar.Array();
            optionsArray   = XVar.Clone(XVar.Array());
            isPHPEncripted = XVar.Clone(this.pageObject.cipherer.isFieldPHPEncrypted((XVar)(this.field)));
            if (XVar.Pack(!(XVar)(isPHPEncripted)))
            {
                optionsArray.InitAndSetArrayItem(Constants.CONTAINS, null);
                optionsArray.InitAndSetArrayItem(Constants.EQUALS, null);
            }
            optionsArray.InitAndSetArrayItem(Constants.EMPTY_SEARCH, null);
            if (XVar.Pack(both))
            {
                if (XVar.Pack(!(XVar)(isPHPEncripted)))
                {
                    optionsArray.InitAndSetArrayItem(Constants.NOT_CONTAINS, null);
                    optionsArray.InitAndSetArrayItem(Constants.NOT_EQUALS, null);
                }
                optionsArray.InitAndSetArrayItem(Constants.NOT_EMPTY, null);
            }
            return(buildSearchOptions((XVar)(optionsArray), (XVar)(selOpt), (XVar)(var_not), (XVar)(both)));
        }
Exemplo n.º 27
0
        private void updateCokRiskmasterPfImportRecord(XVar recordWhereClause, string isValid)
        {
            XVar setIsValidColumn = new XVar();

            setIsValidColumn.SetArrayItem("IS_VALID", isValid);
            oracleDBFacade.Update("xxcok.xxcok_rm_import_pf", setIsValidColumn, recordWhereClause);
        }
Exemplo n.º 28
0
 public override XVar afterSuccessfulSave()
 {
     if (0 < MVCFunctions.count(XSession.Session[MVCFunctions.Concat("mupload_", this.formStamp)]))
     {
         foreach (KeyValuePair <XVar, dynamic> fileArray in XSession.Session[MVCFunctions.Concat("mupload_", this.formStamp)].GetEnumerator())
         {
             if (XVar.Equals(XVar.Pack(fileArray.Value["deleted"]), XVar.Pack(true)))
             {
                 dynamic file_path = null;
                 file_path = XVar.Clone(fileArray.Value["file"]["name"]);
                 if (XVar.Pack(MVCFunctions.file_exists(file_path)))
                 {
                     MVCFunctions.unlink((XVar)(file_path));
                 }
                 if (fileArray.Value["file"]["thumbnail"] != "")
                 {
                     file_path = XVar.Clone(fileArray.Value["file"]["thumbnail"]);
                     if (XVar.Pack(MVCFunctions.file_exists(file_path)))
                     {
                         MVCFunctions.unlink((XVar)(file_path));
                     }
                 }
             }
         }
     }
     XSession.Session.Remove(MVCFunctions.Concat("mupload_", this.formStamp));
     return(null);
 }
Exemplo n.º 29
0
        private void countValidRiskMasterPayments()
        {
            string  selectValidRecordsStatement = @"select count(*) as COUNT
                                    FROM XXCOK.XXCOK_RM_IMPORT_PF PF inner join
                                        (select
                                        IMPORT_ID,
                                        IMPORT_DATE,
                                        PAYMENT_ID,
                                        nvl(max(INVOICE_NUMBER), '0') as INVOICE_NUMBER
                                        from XXCOK.XXCOK_RM_IMPORT_PD
                                        group by IMPORT_ID, IMPORT_DATE, PAYMENT_ID) PD
                                    on PF.IMPORT_ID = PD.IMPORT_ID and
                                    PF.IMPORT_DATE = PD.IMPORT_DATE and
                                    PF.PAYMENT_ID = PD.PAYMENT_ID
                                    where PF.IS_VALID = 1
                                    AND IS_PROCESSED = 0";
            dynamic qresult = oracleDBFacade.Query(selectValidRecordsStatement);

            XVar recordXVar = qresult.fetchAssoc();

            if (recordXVar != null && recordXVar.Count() > 0)
            {
                dynamic record = recordXVar.Value;
                XVar    value;
                if (record.TryGetValue("COUNT", out value))
                {
                    if (value != null && value.IsNumeric())
                    {
                        int count = int.Parse(value);
                        this.TotalRecordsValidated = this.TotalRecordsValidated + count;
                    }
                }
            }
        }
Exemplo n.º 30
0
        public ViewControlsContainer(dynamic _param_pSet_packed, dynamic _param_pageType, dynamic _param_pageObject = null)
        {
            #region packeted values
            ProjectSettings _param_pSet = XVar.UnPackProjectSettings(_param_pSet_packed);
            #endregion

            #region default values
            if (_param_pageObject as Object == null)
            {
                _param_pageObject = new XVar();
            }
            #endregion

            #region pass-by-value parameters
            ProjectSettings pSet       = XVar.Clone(_param_pSet);
            dynamic         pageType   = XVar.Clone(_param_pageType);
            dynamic         pageObject = XVar.Clone(_param_pageObject);
            #endregion

            this.pSet       = XVar.UnPackProjectSettings(pSet);
            this.pageType   = XVar.Clone(pageType);
            this.pageObject = XVar.Clone(pageObject);
            this.tName      = XVar.Clone(pSet.getTableName());
            if (XVar.Pack(pageObject))
            {
                this.pSet.setPageMode((XVar)(pageObject.mode));
            }
            this.searchHighlight = XVar.Clone(highlightSearchResults());
        }