Example #1
0
        public virtual XVar searchAssign()
        {
            dynamic searchPerm = XVar.Array(), showallbutton_attrs = null, srchButtTitle = null;

            this.xt.assign(new XVar("asearch_link"), (XVar)(this.searchPerm));
            if ((XVar)(CommonFunctions.isEnableSection508()) && (XVar)(this.searchPerm))
            {
                searchPerm = XVar.Clone(XVar.Array());
                searchPerm.InitAndSetArrayItem("<a name=\"skipsearch\"></a>", "begin");
            }
            else
            {
                searchPerm = XVar.Clone(this.searchPerm);
            }
            this.xt.assign(new XVar("searchform_block"), (XVar)(searchPerm));
            if (XVar.Pack(this.pageObj.mobileTemplateMode()))
            {
                this.xt.assign(new XVar("searchformmobile_block"), (XVar)(searchPerm));
            }
            this.xt.assign(new XVar("searchformbuttons_block"), (XVar)(searchPerm));
            this.xt.assign(new XVar("searchform_text"), new XVar(true));
            this.xt.assign(new XVar("searchform_search"), new XVar(true));
            srchButtTitle = new XVar("Buscar");
            this.xt.assign(new XVar("searchbutton_attrs"), (XVar)(MVCFunctions.Concat("id=\"searchButtTop", this.id, "\" title=\"", srchButtTitle, "\"")));
            this.xt.assign(new XVar("clear_searchbutton_attrs"), (XVar)(MVCFunctions.Concat("id=\"clearSearch", this.id, "\"")));
            if (XVar.Pack(this.pageObj.mobileTemplateMode()))
            {
                this.xt.assign(new XVar("searchform_showall_mobile"), new XVar(true));
                this.xt.assign(new XVar("searchform_clear_search_mobile"), new XVar(true));
            }
            else
            {
                if (XVar.Pack(!(XVar)(this.pSet.noRecordsOnFirstPage())))
                {
                    this.xt.assign(new XVar("searchform_showall"), new XVar(true));
                    this.xt.assign(new XVar("searchform_clear_search"), new XVar(true));
                }
            }
            showallbutton_attrs = XVar.Clone(MVCFunctions.Concat("id=\"showAll", this.id, "\""));
            if (XVar.Pack(!(XVar)(this.searchClauseObj.isShowAll())))
            {
                showallbutton_attrs = MVCFunctions.Concat(showallbutton_attrs, " ", this.dispNoneStyle);
                this.xt.assign(new XVar("showAllCont_attrs"), (XVar)(this.dispNoneStyle));
                this.xt.assign(new XVar("clearSearchCont_attrs"), (XVar)(this.dispNoneStyle));
            }
            this.xt.assign(new XVar("showallbutton_attrs"), (XVar)(showallbutton_attrs));
            return(null);
        }
Example #2
0
        public virtual XVar buildControl(dynamic _param_value, dynamic _param_mode, dynamic _param_fieldNum, dynamic _param_validate, dynamic _param_additionalCtrlParams, dynamic _param_data)
        {
            #region pass-by-value parameters
            dynamic value                = XVar.Clone(_param_value);
            dynamic mode                 = XVar.Clone(_param_mode);
            dynamic fieldNum             = XVar.Clone(_param_fieldNum);
            dynamic validate             = XVar.Clone(_param_validate);
            dynamic additionalCtrlParams = XVar.Clone(_param_additionalCtrlParams);
            dynamic data                 = XVar.Clone(_param_data);
            #endregion

            dynamic additionalClass = null, arrKeys = XVar.Array(), isHidden = null, j = null;
            this.searchPanelControl = XVar.Clone(isSearchPanelControl((XVar)(mode), (XVar)(additionalCtrlParams)));
            this.inputStyle         = XVar.Clone(getInputStyle((XVar)(mode)));
            if (XVar.Pack(fieldNum))
            {
                this.cfield = XVar.Clone(MVCFunctions.Concat("value", fieldNum, "_", this.goodFieldName, "_", this.id));
                this.ctype  = XVar.Clone(MVCFunctions.Concat("type", fieldNum, "_", this.goodFieldName, "_", this.id));
            }
            this.iquery = XVar.Clone(MVCFunctions.Concat("field=", MVCFunctions.RawUrlEncode((XVar)(this.field))));
            arrKeys     = XVar.Clone(this.pageObject.pSetEdit.getTableKeys());
            j           = new XVar(0);
            for (; j < MVCFunctions.count(arrKeys); j++)
            {
                this.keylink = MVCFunctions.Concat(this.keylink, "&key", j + 1, "=", MVCFunctions.RawUrlEncode((XVar)(data[arrKeys[j]])));
            }
            this.iquery     = MVCFunctions.Concat(this.iquery, this.keylink);
            isHidden        = XVar.Clone((XVar)(additionalCtrlParams.KeyExists("hidden")) && (XVar)(additionalCtrlParams["hidden"]));
            additionalClass = new XVar("");
            if (this.pageObject.getLayoutVersion() == Constants.BOOTSTRAP_LAYOUT)
            {
                additionalClass = MVCFunctions.Concat(additionalClass, "bs-ctrlspan rnr-nowrap ");
                if (this.format == Constants.EDIT_FORMAT_READONLY)
                {
                    additionalClass = MVCFunctions.Concat(additionalClass, "form-control-static ");
                }
                if ((XVar)(MVCFunctions.count(validate["basicValidate"])) && (XVar)(!XVar.Equals(XVar.Pack(MVCFunctions.array_search(new XVar("IsRequired"), (XVar)(validate["basicValidate"]))), XVar.Pack(false))))
                {
                    additionalClass = MVCFunctions.Concat(additionalClass, "bs-inlinerequired");
                }
            }
            else
            {
                additionalClass = MVCFunctions.Concat(additionalClass, "rnr-nowrap ");
            }
            MVCFunctions.Echo(MVCFunctions.Concat("<span id=\"edit", this.id, "_", this.goodFieldName, "_", fieldNum, "\" class=\"", additionalClass, "\"", (XVar.Pack(isHidden) ? XVar.Pack(" style=\"display:none\"") : XVar.Pack("")), ">"));
            return(null);
        }
Example #3
0
        public override XVar addCSSFiles()
        {
            dynamic dateEditType = null;

            dateEditType = XVar.Clone(getDateEditType());
            if ((XVar)(dateEditType == Constants.EDIT_DATE_SIMPLE_INLINE) || (XVar)(dateEditType == Constants.EDIT_DATE_DD_INLINE))
            {
                this.pageObject.AddCSSFile(new XVar("include/jquery-ui/smoothness/jquery-ui.min.css"));
                this.pageObject.AddCSSFile(new XVar("include/jquery-ui/smoothness/jquery-ui.theme.min.css"));
            }
            if (this.pageObject.getLayoutVersion() == Constants.BOOTSTRAP_LAYOUT)
            {
                this.pageObject.AddCSSFile(new XVar("include/bootstrap/css/bootstrap-datetimepicker.min.css"));
            }
            return(null);
        }
Example #4
0
        public virtual XVar getNotBox(dynamic _param_fName, dynamic _param_recId, dynamic _param_not)
        {
            #region pass-by-value parameters
            dynamic fName   = XVar.Clone(_param_fName);
            dynamic recId   = XVar.Clone(_param_recId);
            dynamic var_not = XVar.Clone(_param_not);
            #endregion

            dynamic notbox = null;
            notbox = XVar.Clone(MVCFunctions.Concat("id=\"not_", recId, "_", MVCFunctions.GoodFieldName((XVar)(fName)), "\""));
            if (XVar.Pack(var_not))
            {
                notbox = MVCFunctions.Concat(notbox, " checked");
            }
            return(notbox);
        }
Example #5
0
        public SearchControl(dynamic _param_id, dynamic _param_tName, dynamic searchClauseObj, dynamic pageObj)
        {
            #region pass-by-value parameters
            dynamic id    = XVar.Clone(_param_id);
            dynamic tName = XVar.Clone(_param_tName);
            #endregion

            this.tName             = XVar.Clone(tName);
            this.searchClauseObj   = XVar.Clone(searchClauseObj);
            this.getSrchPanelAttrs = XVar.Clone(this.searchClauseObj.getSrchPanelAttrs());
            this.globSrchParams    = XVar.Clone(this.searchClauseObj.getSearchGlobalParams());
            this.id                = XVar.Clone(id);
            this.pageObj           = pageObj;
            this.pSet              = XVar.UnPackProjectSettings((XVar.Pack(this.pageObj.pageType != Constants.PAGE_SEARCH) ? XVar.Pack(new ProjectSettings((XVar)(tName), new XVar(Constants.PAGE_SEARCH))) : XVar.Pack(this.pageObj.pSetSearch)));
            this.controlsContainer = XVar.Clone(new EditControlsContainer((XVar)(this.pageObj), (XVar)(this.pSet), new XVar(Constants.PAGE_SEARCH), (XVar)(this.pageObj.cipherer)));
        }
Example #6
0
        public override XVar showPage()
        {
            dynamic var_response = XVar.Array();

            fillSetCntrlMaps();
            var_response = XVar.Clone(XVar.Array());
            var_response.InitAndSetArrayItem(GlobalVars.pagesData, "pagesData");
            var_response.InitAndSetArrayItem(this.jsSettings, "settings");
            var_response.InitAndSetArrayItem(this.controlsHTMLMap, "controlsMap");
            var_response.InitAndSetArrayItem(getMapDiv(), "html");
            var_response.InitAndSetArrayItem(true, "success");
            var_response.InitAndSetArrayItem(this.id, "id");
            var_response.InitAndSetArrayItem(grabAllJsFiles(), "additionalJS");
            MVCFunctions.Echo(CommonFunctions.printJSON((XVar)(var_response)));
            return(null);
        }
Example #7
0
        public override XVar showDBValue(dynamic data, dynamic _param_keylink, dynamic _param_html = null)
        {
            #region default values
            if (_param_html as Object == null)
            {
                _param_html = new XVar(true);
            }
            #endregion

            #region pass-by-value parameters
            dynamic keylink = XVar.Clone(_param_keylink);
            dynamic html    = XVar.Clone(_param_html);
            #endregion

            return(getTextValue((XVar)(data)));
        }
Example #8
0
        protected virtual XVar isParentsValuesDataTheSame(dynamic _param_parentFiltersData, dynamic _param_parentValues)
        {
            #region pass-by-value parameters
            dynamic parentFiltersData = XVar.Clone(_param_parentFiltersData);
            dynamic parentValues      = XVar.Clone(_param_parentValues);
            #endregion

            foreach (KeyValuePair <XVar, dynamic> pName in this.parentFiltersNames.GetEnumerator())
            {
                if (parentFiltersData[pName.Value] != parentValues[pName.Key])
                {
                    return(false);
                }
            }
            return(true);
        }
Example #9
0
        protected virtual XVar getLookupParams()
        {
            dynamic lookupParams = XVar.Array();

            lookupParams = XVar.Clone(XVar.Array());
            if (XVar.Pack(this.isFieldLookup))
            {
                ProjectSettings pSet;
                pSet = XVar.UnPackProjectSettings(this.container.pSet);
                lookupParams.InitAndSetArrayItem(pSet.multiSelect((XVar)(this.field)), "multiselect");
                lookupParams.InitAndSetArrayItem(this.needLookupValueProcessing, "needLookupProcessing");
                lookupParams.InitAndSetArrayItem(this.container.linkFieldValues[this.field], "linkFieldValue");
                lookupParams.InitAndSetArrayItem(this.container.originlinkValues[this.field], "originLinkValue");
            }
            return(lookupParams);
        }
Example #10
0
        protected override XVar getBaseContolsMapParams()
        {
            dynamic ctrlsMap = XVar.Array();

            ctrlsMap = XVar.Clone(XVar.Array());
            ctrlsMap.InitAndSetArrayItem(this.fName, "fieldName");
            ctrlsMap.InitAndSetArrayItem(this.gfName, "gfieldName");
            ctrlsMap.InitAndSetArrayItem(this.filterFormat, "filterFormat");
            ctrlsMap.InitAndSetArrayItem(this.filtered, "filtered");
            ctrlsMap.InitAndSetArrayItem(this.separator, "separator");
            ctrlsMap.InitAndSetArrayItem(this.knobsType, "knobsType");
            ctrlsMap.InitAndSetArrayItem(this.useApllyBtn, "useApllyBtn");
            ctrlsMap.InitAndSetArrayItem(getStepValue(), "step");
            ctrlsMap.InitAndSetArrayItem(this.showCollapsed, "collapsed");
            return(ctrlsMap);
        }
Example #11
0
        public virtual XVar showButtonsDp(dynamic _param_params = null)
        {
            #region default values
            if (_param_params as Object == null)
            {
                _param_params = new XVar("");
            }
            #endregion

            #region pass-by-value parameters
            dynamic var_params = XVar.Clone(_param_params);
            #endregion

            MVCFunctions.Echo(this.renderedButtons);
            return(null);
        }
Example #12
0
        protected virtual XVar numericToAssoc(dynamic _param_data)
        {
            #region pass-by-value parameters
            dynamic data = XVar.Clone(_param_data);
            #endregion

            dynamic i = null, nFields = null, ret = XVar.Array();
            ret     = XVar.Clone(XVar.Array());
            nFields = XVar.Clone(numFields());
            i       = new XVar(0);
            for (; i < nFields; ++(i))
            {
                ret.InitAndSetArrayItem(data[i], this.fieldNames[i]);
            }
            return(ret);
        }
Example #13
0
        public virtual XVar CheckPermissions(dynamic _param_table, dynamic _param_permis)
        {
            #region pass-by-value parameters
            dynamic table  = XVar.Clone(_param_table);
            dynamic permis = XVar.Clone(_param_permis);
            #endregion

            foreach (KeyValuePair <XVar, dynamic> val in getPermissionType((XVar)(permis)).GetEnumerator())
            {
                if (XVar.Pack(CommonFunctions.CheckTablePermissions((XVar)(table), (XVar)(val.Value))))
                {
                    return(true);
                }
            }
            return(false);
        }
Example #14
0
        protected virtual XVar readData()
        {
            dynamic data = XVar.Array(), qResult = null;

            qResult = XVar.Clone(queryData());
            if (XVar.Pack(!(XVar)(qResult)))
            {
                return("");
            }
            data = XVar.Clone(qResult.fetchAssoc());
            if (XVar.Pack(!(XVar)(data.KeyExists("SEARCH"))))
            {
                return(false);
            }
            return(data["SEARCH"]);
        }
Example #15
0
        public virtual XVar fillGroupsArr()
        {
            dynamic grConnection = null, qResult = null, sql = null, tdata = XVar.Array();

            grConnection = XVar.Clone(GlobalVars.cman.getForUserGroups());
            this.groups.InitAndSetArrayItem(MVCFunctions.Concat("<", "Admin", ">"), -1);
            this.groups.InitAndSetArrayItem(MVCFunctions.Concat("<", "Default", ">"), -2);
            this.groups.InitAndSetArrayItem(MVCFunctions.Concat("<", "Guest", ">"), -3);
            sql     = XVar.Clone(MVCFunctions.Concat("select ", grConnection.addFieldWrappers(new XVar("")), ", ", grConnection.addFieldWrappers(new XVar("")), " from ", grConnection.addTableWrappers(new XVar("uggroups")), " order by ", grConnection.addFieldWrappers(new XVar(""))));
            qResult = XVar.Clone(grConnection.query((XVar)(sql)));
            while (XVar.Pack(tdata = XVar.Clone(qResult.fetchNumeric())))
            {
                this.groups.InitAndSetArrayItem(tdata[1], tdata[0]);
            }
            return(null);
        }
Example #16
0
        public static XVar create_method_assignment(dynamic _param_method, dynamic var_object, dynamic _param_params = null)
        {
            #region default values
            if (_param_params as Object == null)
            {
                _param_params = new XVar();
            }
            #endregion

            #region pass-by-value parameters
            dynamic method     = XVar.Clone(_param_method);
            dynamic var_params = XVar.Clone(_param_params);
            #endregion

            return(new XVar("method", method, "params", var_params, "object", var_object));
        }
Example #17
0
        public virtual XVar hideField(dynamic _param_fieldName)
        {
            #region pass-by-value parameters
            dynamic fieldName = XVar.Clone(_param_fieldName);
            #endregion

            if (this.layout.version == 1)
            {
                assign((XVar)(MVCFunctions.Concat("fielddispclass_", MVCFunctions.GoodFieldName((XVar)(fieldName)))), new XVar("runner-hiddenfield"));
            }
            else
            {
                assign((XVar)(MVCFunctions.Concat("fielddispclass_", MVCFunctions.GoodFieldName((XVar)(fieldName)))), new XVar("rnr-hiddenfield"));
            }
            return(null);
        }
Example #18
0
        protected virtual XVar getNewRecordCopy(dynamic _param_newRecordData)
        {
            #region pass-by-value parameters
            dynamic newRecordData = XVar.Clone(_param_newRecordData);
            #endregion

            dynamic newRecordCopy = XVar.Array();
            newRecordCopy = XVar.Clone(XVar.Array());
            foreach (KeyValuePair <XVar, dynamic> data in newRecordData.GetEnumerator())
            {
                newRecordCopy.InitAndSetArrayItem(data.Value, data.Key);
            }
            return(newRecordCopy);

            return(null);
        }
Example #19
0
        protected virtual XVar setIntervalData(dynamic _param_key, dynamic _param_intervalData, dynamic _param_caseCondition)
        {
            #region pass-by-value parameters
            dynamic key           = XVar.Clone(_param_key);
            dynamic intervalData  = XVar.Clone(_param_intervalData);
            dynamic caseCondition = XVar.Clone(_param_caseCondition);
            #endregion

            dynamic message = null, var_type = null;
            var_type = XVar.Clone(intervalData["intervalLabelNameType"]);
            message  = XVar.Clone(intervalData["intervalLabelText"]);
            this.intervalsData.InitAndSetArrayItem(getLabel((XVar)(var_type), (XVar)(message)), key, "label");
            this.intervalsData.InitAndSetArrayItem(caseCondition, key, "where");
            this.intervalsData.InitAndSetArrayItem(intervalData["index"], key, "index");
            return(null);
        }
Example #20
0
        public virtual XVar isSystemControl(dynamic _param_className)
        {
            #region pass-by-value parameters
            dynamic className = XVar.Clone(_param_className);
            #endregion

            if ((XVar)(this.pageType == Constants.PAGE_SEARCH) || (XVar)(this.pageType == Constants.PAGE_LIST))
            {
                return(this.classNamesForSearch.KeyExists(className));
            }
            else
            {
                return(this.classNamesForEdit.KeyExists(className));
            }
            return(null);
        }
Example #21
0
        protected override XVar sortFilterBlocks(ref dynamic filterCtrlBlocks)
        {
            dynamic compareFunction = null;

            if (this.sortingType != Constants.SORT_BY_DISP_VALUE)
            {
                return(null);
            }
            compareFunction = XVar.Clone((XVar.Pack(CommonFunctions.IsNumberType((XVar)(this.fieldType))) ? XVar.Pack("compareBlocksByNumericValues") : XVar.Pack("compareBlocksByStringValues")));
            MVCFunctions.usort((XVar)(filterCtrlBlocks), (XVar)(new XVar(0, "FilterControl", 1, compareFunction)));
            if (XVar.Pack(this.isDescendingSortOrder))
            {
                filterCtrlBlocks = XVar.Clone(MVCFunctions.array_reverse((XVar)(filterCtrlBlocks)));
            }
            return(null);
        }
Example #22
0
 public oLocking()
 {
     this.ConfirmAdmin = new XVar("Administrador %s canceló su sesión de edición");
     this.ConfirmUser  = new XVar("Su sesión de edición ha sobrepasado el tiempo límite");
     this.LockAdmin    = new XVar("El registro está editado por %s durante %s minutos");
     this.LockUser     = new XVar("El registro está siendo editado por otro usuario");
     this.connection   = XVar.Clone(GlobalVars.cman.getForLocking());
     if ((XVar)(XSession.Session.KeyExists("UserID")) && (XVar)(!(XVar)(XSession.Session["UserID"] == null)))
     {
         this.UserID = XVar.Clone(XSession.Session["UserID"]);
     }
     else
     {
         this.UserID = new XVar("Guest");
     }
 }
 public static void Apply()
 {
     GlobalVars.strTableName         = new XVar("ABC_Voting_My_Voting");
     XSession.Session["OwnerID"]     = XSession.Session[MVCFunctions.Concat("_", GlobalVars.strTableName, "_OwnerID")];
     GlobalVars.strOriginalTableName = new XVar("dbo._ABCReports");
     GlobalVars.gstrOrderBy          = new XVar("");
     if ((XVar)(MVCFunctions.strlen((XVar)(GlobalVars.gstrOrderBy))) && (XVar)(MVCFunctions.strtolower((XVar)(MVCFunctions.substr((XVar)(GlobalVars.gstrOrderBy), new XVar(0), new XVar(8)))) != "order by"))
     {
         GlobalVars.gstrOrderBy = XVar.Clone(MVCFunctions.Concat("order by ", GlobalVars.gstrOrderBy));
     }
     GlobalVars.gSettings = XVar.Clone(new ProjectSettings(new XVar("ABC_Voting_My_Voting")));
     GlobalVars.gQuery    = XVar.Clone(GlobalVars.gSettings.getSQLQuery());
     GlobalVars.eventObj  = GlobalVars.tableEvents["ABC_Voting_My_Voting"];
     GlobalVars.reportCaseSensitiveGroupFields = new XVar(false);
     GlobalVars.gstrSQL = XVar.Clone(GlobalVars.gQuery.gSQLWhere(new XVar("")));
 }
Example #24
0
        protected virtual XVar insert(dynamic _param_table, dynamic _param_startdatetime, dynamic _param_confirmdatetime, dynamic _param_keys, dynamic _param_sessionid, dynamic _param_userid, dynamic _param_action)
        {
            #region pass-by-value parameters
            dynamic table           = XVar.Clone(_param_table);
            dynamic startdatetime   = XVar.Clone(_param_startdatetime);
            dynamic confirmdatetime = XVar.Clone(_param_confirmdatetime);
            dynamic keys            = XVar.Clone(_param_keys);
            dynamic sessionid       = XVar.Clone(_param_sessionid);
            dynamic userid          = XVar.Clone(_param_userid);
            dynamic action          = XVar.Clone(_param_action);
            #endregion

            dynamic sql = null;
            sql = XVar.Clone(MVCFunctions.Concat("INSERT INTO ", this.connection.addTableWrappers((XVar)(this.lockTableName)), " (", this.connection.addFieldWrappers(new XVar("table")), ",", this.connection.addFieldWrappers(new XVar("startdatetime")), ",", this.connection.addFieldWrappers(new XVar("confirmdatetime")), ",", this.connection.addFieldWrappers(new XVar("keys")), ",", this.connection.addFieldWrappers(new XVar("sessionid")), ",", this.connection.addFieldWrappers(new XVar("userid")), ",", this.connection.addFieldWrappers(new XVar("action")), ") VALUES (", this.connection.prepareString((XVar)(table)), ",", this.connection.addDateQuotes((XVar)(startdatetime)), ",", this.connection.addDateQuotes((XVar)(confirmdatetime)), ",", this.connection.prepareString((XVar)(keys)), ",", this.connection.prepareString((XVar)(sessionid)), ",", this.connection.prepareString((XVar)(this.UserID)), ",", action, ")"));
            return(this.connection.exec((XVar)(sql)));
        }
Example #25
0
        public virtual XVar fillGroups()
        {
            dynamic grConnection = null, qResult = null, sql = null, tdata = XVar.Array();

            grConnection = XVar.Clone(GlobalVars.cman.getForUserGroups());
            this.groups.InitAndSetArrayItem(new XVar(0, -1, 1, MVCFunctions.Concat("<", "Administrador", ">")), null);
            this.groupFullChecked.InitAndSetArrayItem(true, null);
            sql     = XVar.Clone(MVCFunctions.Concat("select ", grConnection.addFieldWrappers(new XVar("GroupID")), ", ", grConnection.addFieldWrappers(new XVar("Label")), " from ", grConnection.addTableWrappers(new XVar("dbo.acceso_uggroups")), " order by ", grConnection.addFieldWrappers(new XVar("Label"))));
            qResult = XVar.Clone(grConnection.query((XVar)(sql)));
            while (XVar.Pack(tdata = XVar.Clone(qResult.fetchNumeric())))
            {
                this.groups.InitAndSetArrayItem(new XVar(0, tdata[0], 1, tdata[1]), null);
                this.groupFullChecked.InitAndSetArrayItem(true, null);
            }
            return(null);
        }
Example #26
0
        protected virtual XVar update(dynamic _param_values, dynamic _param_where)
        {
            #region pass-by-value parameters
            dynamic values = XVar.Clone(_param_values);
            dynamic where = XVar.Clone(_param_where);
            #endregion

            dynamic sql = null;
            if ((XVar)(!(XVar)(where)) || (XVar)(!(XVar)(values)))
            {
                return(null);
            }
            sql = XVar.Clone(MVCFunctions.Concat("UPDATE ", this.connection.addTableWrappers((XVar)(this.lockTableName)), " SET ", values, " WHERE ", where));
            this.connection.exec((XVar)(sql));
            return(null);
        }
Example #27
0
        public virtual XVar getSimpleSearchTypeCombo(dynamic _param_selOpt, dynamic _param_not)
        {
            #region pass-by-value parameters
            dynamic selOpt  = XVar.Clone(_param_selOpt);
            dynamic var_not = XVar.Clone(_param_not);
            #endregion

            dynamic options = null;
            options = XVar.Clone(MVCFunctions.Concat("<option value=\"Contains\" ", (XVar.Pack((XVar)(selOpt == "Contains") && (XVar)(!(XVar)(var_not))) ? XVar.Pack("selected") : XVar.Pack("")), ">", "Contains", "</option>"));
            options = MVCFunctions.Concat(options, "<option value=\"Equals\" ", (XVar.Pack((XVar)(selOpt == "Equals") && (XVar)(!(XVar)(var_not))) ? XVar.Pack("selected") : XVar.Pack("")), ">", "Equals", "</option>");
            options = MVCFunctions.Concat(options, "<option value=\"Starts with\" ", (XVar.Pack((XVar)(selOpt == "Starts with") && (XVar)(!(XVar)(var_not))) ? XVar.Pack("selected") : XVar.Pack("")), ">", "Starts with", "</option>");
            options = MVCFunctions.Concat(options, "<option value=\"More than\" ", (XVar.Pack((XVar)(selOpt == "More than") && (XVar)(!(XVar)(var_not))) ? XVar.Pack("selected") : XVar.Pack("")), ">", "More than", "</option>");
            options = MVCFunctions.Concat(options, "<option value=\"Less than\" ", (XVar.Pack((XVar)(selOpt == "Less than") && (XVar)(!(XVar)(var_not))) ? XVar.Pack("selected") : XVar.Pack("")), ">", "Less than", "</option>");
            options = MVCFunctions.Concat(options, "<option value=\"Empty\" ", (XVar.Pack((XVar)(selOpt == "Empty") && (XVar)(!(XVar)(var_not))) ? XVar.Pack("selected") : XVar.Pack("")), ">", "Empty", "</option>");
            return(options);
        }
Example #28
0
 public static void Apply()
 {
     GlobalVars.strTableName         = new XVar("APROBACION_COMPESADOS_JEFEDEPARTAMENTO");
     XSession.Session["OwnerID"]     = XSession.Session[MVCFunctions.Concat("_", GlobalVars.strTableName, "_OwnerID")];
     GlobalVars.strOriginalTableName = new XVar("dbo.REGISTRO_HORAS_COMPESADAS");
     GlobalVars.gstrOrderBy          = new XVar("");
     if ((XVar)(MVCFunctions.strlen((XVar)(GlobalVars.gstrOrderBy))) && (XVar)(MVCFunctions.strtolower((XVar)(MVCFunctions.substr((XVar)(GlobalVars.gstrOrderBy), new XVar(0), new XVar(8)))) != "order by"))
     {
         GlobalVars.gstrOrderBy = XVar.Clone(MVCFunctions.Concat("order by ", GlobalVars.gstrOrderBy));
     }
     GlobalVars.gSettings = XVar.Clone(new ProjectSettings(new XVar("APROBACION_COMPESADOS_JEFEDEPARTAMENTO")));
     GlobalVars.gQuery    = XVar.Clone(GlobalVars.gSettings.getSQLQuery());
     GlobalVars.eventObj  = GlobalVars.tableEvents["APROBACION_COMPESADOS_JEFEDEPARTAMENTO"];
     GlobalVars.reportCaseSensitiveGroupFields = new XVar(false);
     GlobalVars.gstrSQL = XVar.Clone(GlobalVars.gQuery.gSQLWhere(new XVar("")));
 }
Example #29
0
        public override XVar addSpanVal(dynamic _param_fName, dynamic data)
        {
            #region pass-by-value parameters
            dynamic fName = XVar.Clone(_param_fName);
            #endregion

            if ((XVar)(this.dispFieldAlias) && (XVar)(this.arrFieldSpanVal[fName] == 2))
            {
                return(MVCFunctions.Concat("val=\"", MVCFunctions.runner_htmlspecialchars((XVar)(data[this.dispFieldAlias])), "\" "));
            }
            else
            {
                return(base.addSpanVal((XVar)(fName), (XVar)(data)));
            }
            return(null);
        }
Example #30
0
        public static XVar getProjectLogo(dynamic _param_lng = null)
        {
            #region default values
            if (_param_lng as Object == null)
            {
                _param_lng = new XVar("");
            }
            #endregion

            #region pass-by-value parameters
            dynamic lng = XVar.Clone(_param_lng);
            #endregion

            lng = XVar.Clone(findLanguage((XVar)(lng)));
            return(GlobalVars.globalSettings["ProjectLogo"][lng]);
        }