コード例 #1
0
        public static SqlCommand parse_parameters(this SqlCommand command, SQLEntity source)
        {
            var command_parameters = command.Parameters;

            var properties  = source.GetType().GetProperties(BindingFlags.DeclaredOnly | BindingFlags.Public | BindingFlags.Instance);
            var source_type = source.GetType();
            var build       = new SQLBuilder();

            // The entity's unique identifier is added here because the previous flags only detect the declared properties
            // and we dont want to be declaring the guid on every entity
            command_parameters.Add(build.Parameter("@id", source.Id));

            foreach (var property in properties)
            {
                var property_type = property.PropertyType;
                var property_name = property.Name;

                var property_info  = source_type.GetProperty(property.Name);
                var property_value = property_info.GetValue(source, null);

                var value = Convert.ChangeType(property_value, Nullable.GetUnderlyingType(property_type) ?? property_type);

                if (value == null)
                {
                    continue;
                }

                command_parameters.Add(build.Parameter("@" + property_name, value));
            }

            return(command);
        }
コード例 #2
0
 /// <summary>
 /// SQLEntity转换
 /// </summary>
 /// <param name="entity"></param>
 /// <returns></returns>
 private Task SQLEntityToSingle(SQLEntity entity)
 {
     //判断搜索结果是否为空
     if (entity == null)
     {
         return(null);
     }
     else
     {
         // 主表
         Task task = entity.Task;
         // 接待人
         task.Reception = entity.Reception ?? null;
         // 客户
         task.Customer = entity.Customer ?? null;
         // 场地
         task.Site = entity.Site ?? null;
         // 场馆
         task.Venue = entity.Venue ?? null;
         // 状态
         task.Status = entity.Status ?? null;
         // 返回
         return(task);
     }
 }
コード例 #3
0
 /// <summary>
 /// SQLEntity转换
 /// </summary>
 /// <param name="entity"></param>
 /// <returns></returns>
 private Status SQLEntityToSingle(SQLEntity entity)
 {
     //判断搜索结果是否为空
     if (entity == null)
     {
         return(null);
     }
     else
     {
         // 主表
         Status status = entity.Status;
         // 返回
         return(status);
     }
 }
コード例 #4
0
 /// <summary>
 /// SQLEntity转换
 /// </summary>
 /// <param name="entity"></param>
 /// <returns></returns>
 private Venue SQLEntityToSingle(SQLEntity entity)
 {
     //判断搜索结果是否为空
     if (entity == null)
     {
         return(null);
     }
     else
     {
         // 主表
         Venue venue = entity.Venue;
         // 状态
         venue.Status = entity.Status ?? null;
         // 返回
         return(venue);
     }
 }
コード例 #5
0
 /// <summary>
 /// SQLEntity转换
 /// </summary>
 /// <param name="entity"></param>
 /// <returns></returns>
 private Customer SQLEntityToSingle(SQLEntity entity)
 {
     //判断搜索结果是否为空
     if (entity == null)
     {
         return(null);
     }
     else
     {
         // 主表
         Customer customer = entity.Customer;
         // 状态
         customer.Status = entity.Status ?? null;
         // 返回
         return(customer);
     }
 }
コード例 #6
0
 /// <summary>
 /// SQLEntity转换
 /// </summary>
 /// <param name="entity"></param>
 /// <returns></returns>
 private Site SQLEntityToSingle(SQLEntity entity)
 {
     //判断搜索结果是否为空
     if (entity == null)
     {
         return(null);
     }
     else
     {
         // 主表
         Site site = entity.Site;
         // 状态
         site.Status = entity.Status ?? null;
         // 返回
         return(site);
     }
 }
コード例 #7
0
ファイル: RegionService.cs プロジェクト: runsparrow/VMIS-back
 /// <summary>
 /// SQLEntity转换
 /// </summary>
 /// <param name="entity"></param>
 /// <returns></returns>
 private Region SQLEntityToSingle(SQLEntity entity)
 {
     //判断搜索结果是否为空
     if (entity == null)
     {
         return(null);
     }
     else
     {
         // 主表
         Region region = entity.Region;
         // 状态
         region.Status = entity.Status ?? null;
         // 返回
         return(region);
     }
 }
コード例 #8
0
 /// <summary>
 /// SQLEntity转换
 /// </summary>
 /// <param name="entity"></param>
 /// <returns></returns>
 private Dictionary SQLEntityToSingle(SQLEntity entity)
 {
     //判断搜索结果是否为空
     if (entity == null)
     {
         return(null);
     }
     else
     {
         // 主表
         Dictionary dictionary = entity.Dictionary;
         // 状态
         dictionary.Status = entity.Status ?? null;
         // 返回
         return(dictionary);
     }
 }
コード例 #9
0
 /// <summary>
 /// SQLEntity转换
 /// </summary>
 /// <param name="entity"></param>
 /// <returns></returns>
 private Registry SQLEntityToSingle(SQLEntity entity)
 {
     //判断搜索结果是否为空
     if (entity == null)
     {
         return(null);
     }
     else
     {
         // 主表
         Registry registry = entity.Registry;
         // 状态
         registry.Status = entity.Status ?? null;
         // 返回
         return(registry);
     }
 }
コード例 #10
0
ファイル: UserService.cs プロジェクト: runsparrow/VMIS-back
 /// <summary>
 /// SQLEntity转换
 /// </summary>
 /// <param name="entity"></param>
 /// <returns></returns>
 private User SQLEntityToSingle(SQLEntity entity)
 {
     //判断搜索结果是否为空
     if (entity == null)
     {
         return(null);
     }
     else
     {
         // 主表
         User user = entity.User;
         // 状态
         user.Status = entity.Status ?? null;
         // 返回
         return(user);
     }
 }
コード例 #11
0
 /// <summary>
 /// SQLEntity转换
 /// </summary>
 /// <param name="entity"></param>
 /// <returns></returns>
 private Role SQLEntityToSingle(SQLEntity entity)
 {
     //判断搜索结果是否为空
     if (entity == null)
     {
         return(null);
     }
     else
     {
         // 主表
         Role role = entity.Role;
         // 状态
         role.Status = entity.Status ?? null;
         // 返回
         return(role);
     }
 }
コード例 #12
0
 /// <summary>
 /// SQLEntity转换
 /// </summary>
 /// <param name="entity"></param>
 /// <returns></returns>
 private UserPower SQLEntityToSingle(SQLEntity entity)
 {
     //判断搜索结果是否为空
     if (entity == null)
     {
         return(null);
     }
     else
     {
         // 主表
         UserPower userPower = entity.UserPower;
         //// 人员
         //userPower.Employee = entity.Employee == null ? null : ToBase<HRMEmployeeMap, HRMEmployee>(entity.Employee);
         //// 状态
         //userPower.Status = entity.Status == null ? null : ToBase<StatusMap, Status>(entity.Status);
         // 返回
         return(userPower);
     }
 }
コード例 #13
0
 /// <summary>
 /// SQLEntity转换
 /// </summary>
 /// <param name="entity"></param>
 /// <returns></returns>
 private RERoleRegistry SQLEntityToSingle(SQLEntity entity)
 {
     //判断搜索结果是否为空
     if (entity == null)
     {
         return(null);
     }
     else
     {
         // 主表
         RERoleRegistry reRoleRegistry = entity.RERoleRegistry;
         // 功能
         reRoleRegistry.Registry = entity.Registry ?? null;
         // 角色
         reRoleRegistry.Role = entity.Role ?? null;
         // 返回
         return(reRoleRegistry);
     }
 }
コード例 #14
0
 /// <summary>
 /// SQLEntity转换
 /// </summary>
 /// <param name="entity"></param>
 /// <returns></returns>
 private REUserRegistry SQLEntityToSingle(SQLEntity entity)
 {
     //判断搜索结果是否为空
     if (entity == null)
     {
         return(null);
     }
     else
     {
         // 主表
         REUserRegistry reUserRegistry = entity.REUserRegistry;
         // 功能
         reUserRegistry.Registry = entity.Registry ?? null;
         // 用户
         reUserRegistry.User = entity.User ?? null;
         // 返回
         return(reUserRegistry);
     }
 }
コード例 #15
0
 /// <summary>
 /// SQLEntity转换
 /// </summary>
 /// <param name="entity"></param>
 /// <returns></returns>
 private RERoleUser SQLEntityToSingle(SQLEntity entity)
 {
     //判断搜索结果是否为空
     if (entity == null)
     {
         return(null);
     }
     else
     {
         // 主表
         RERoleUser reRoleUser = entity.RERoleUser;
         // 用户
         reRoleUser.User = entity.User ?? null;
         // 角色
         reRoleUser.Role = entity.Role ?? null;
         // 返回
         return(reRoleUser);
     }
 }
コード例 #16
0
        public override int DoInBackGround(int param)
        {
            try
            {
                UpdateProgress("Criando sua base de dados...");
                Thread.Sleep(5000);
                varejo_config db = new varejo_config();
                db.Database.Create();

                UpdateProgress("Estamos configurando algumas coisas para você...");

                SQLEntityDecompiler decompiler = new SQLEntityDecompiler();
                SQLEntity           entity     = decompiler.Decompile(Directory.GetCurrentDirectory() + @"\setup.csql");

                string[] commands = entity.FullSQLCommand.Split(';');

                db.Database.BeginTransaction(System.Data.IsolationLevel.ReadUncommitted);

                foreach (string cmd in commands)
                {
                    if (!string.IsNullOrWhiteSpace(cmd))
                    {
                        db.Database.ExecuteSqlCommand(cmd);
                        Thread.Sleep(3000);
                    }
                }

                UpdateProgress("Estamos quase terminando...");
                Thread.Sleep(5000);
                db.Database.CurrentTransaction.Commit();

                UpdateProgress("Vamos começar");
                Thread.Sleep(20000);
                return(1);
            }
            catch (Exception ex)
            {
                return(0);
            }
        }
コード例 #17
0
        public SQLEntity Decompile(string scriptFile)
        {
            FileStream fs = null;

            try
            {
                fs = new FileStream(scriptFile, FileMode.Open);
                BinaryFormatter formatter = new BinaryFormatter();
                SQLEntity       entity    = (SQLEntity)formatter.Deserialize(fs);

                fs.Close();

                return(entity);
            }
            catch
            {
                if (fs != null)
                {
                    fs.Close();
                }

                throw;
            }
        }
コード例 #18
0
        static public void Apply()
        {
            SettingsMap arrGPP = SettingsMap.GetArray(), arrGridTabs = SettingsMap.GetArray(), arrRPP = SettingsMap.GetArray(), dIndex = null, detailsParam = SettingsMap.GetArray(), edata = SettingsMap.GetArray(), eventsData = SettingsMap.GetArray(), fdata = SettingsMap.GetArray(), fieldLabelsArray = new XVar(), fieldToolTipsArray = new XVar(), hours = null, intervalData = SettingsMap.GetArray(), masterParams = SettingsMap.GetArray(), pageTitlesArray = new XVar(), placeHoldersArray = new XVar(), popupPagesLayoutNames = SettingsMap.GetArray(), query = null, queryData_Array = new XVar(), reportGroupFields = SettingsMap.GetArray(), rgroupField = SettingsMap.GetArray(), strOriginalDetailsTable = null, table = null, tableKeysArray = new XVar(), tdataArray = new XVar(), tstrOrderBy = null, vdata = SettingsMap.GetArray();

            tdataArray["dbo_Preferencias"] = SettingsMap.GetArray();
            tdataArray["dbo_Preferencias"][".searchableFields"] = SettingsMap.GetArray();
            tdataArray["dbo_Preferencias"][".truncateText"]     = true;
            tdataArray["dbo_Preferencias"][".NumberOfChars"]    = 80;
            tdataArray["dbo_Preferencias"][".ShortName"]        = "dbo_Preferencias";
            tdataArray["dbo_Preferencias"][".OwnerID"]          = "";
            tdataArray["dbo_Preferencias"][".OriginalTable"]    = "dbo.Preferencias";
            GlobalVars.defaultPages = MVCFunctions.my_json_decode(new XVar("{\"edit\":\"edit\",\"list\":\"list\",\"search\":\"search\"}"));
            tdataArray["dbo_Preferencias"][".pages"]        = CommonFunctions.types2pages(MVCFunctions.my_json_decode(new XVar("{\"edit\":[\"edit\"],\"list\":[\"list\"],\"search\":[\"search\"]}")));
            tdataArray["dbo_Preferencias"][".defaultPages"] = GlobalVars.defaultPages;
            fieldLabelsArray["dbo_Preferencias"]            = SettingsMap.GetArray();
            fieldToolTipsArray["dbo_Preferencias"]          = SettingsMap.GetArray();
            pageTitlesArray["dbo_Preferencias"]             = SettingsMap.GetArray();
            placeHoldersArray["dbo_Preferencias"]           = SettingsMap.GetArray();
            if (CommonFunctions.mlang_getcurrentlang() == "Spanish")
            {
                fieldLabelsArray["dbo_Preferencias"]["Spanish"]                  = SettingsMap.GetArray();
                fieldToolTipsArray["dbo_Preferencias"]["Spanish"]                = SettingsMap.GetArray();
                placeHoldersArray["dbo_Preferencias"]["Spanish"]                 = SettingsMap.GetArray();
                pageTitlesArray["dbo_Preferencias"]["Spanish"]                   = SettingsMap.GetArray();
                fieldLabelsArray["dbo_Preferencias"]["Spanish"]["ID"]            = "ID";
                fieldToolTipsArray["dbo_Preferencias"]["Spanish"]["ID"]          = "";
                placeHoldersArray["dbo_Preferencias"]["Spanish"]["ID"]           = "";
                fieldLabelsArray["dbo_Preferencias"]["Spanish"]["nombre_jefe"]   = "Nombre Jefe";
                fieldToolTipsArray["dbo_Preferencias"]["Spanish"]["nombre_jefe"] = "";
                placeHoldersArray["dbo_Preferencias"]["Spanish"]["nombre_jefe"]  = "";
                fieldLabelsArray["dbo_Preferencias"]["Spanish"]["division"]      = "Division";
                fieldToolTipsArray["dbo_Preferencias"]["Spanish"]["division"]    = "";
                placeHoldersArray["dbo_Preferencias"]["Spanish"]["division"]     = "";
                if (XVar.Pack(MVCFunctions.count(fieldToolTipsArray["dbo_Preferencias"]["Spanish"])))
                {
                    tdataArray["dbo_Preferencias"][".isUseToolTips"] = true;
                }
            }
            tdataArray["dbo_Preferencias"][".NCSearch"]             = true;
            tdataArray["dbo_Preferencias"][".shortTableName"]       = "dbo_Preferencias";
            tdataArray["dbo_Preferencias"][".nSecOptions"]          = 0;
            tdataArray["dbo_Preferencias"][".mainTableOwnerID"]     = "";
            tdataArray["dbo_Preferencias"][".entityType"]           = 0;
            tdataArray["dbo_Preferencias"][".strOriginalTableName"] = "dbo.Preferencias";
            tdataArray["dbo_Preferencias"][".showAddInPopup"]       = false;
            tdataArray["dbo_Preferencias"][".showEditInPopup"]      = false;
            tdataArray["dbo_Preferencias"][".showViewInPopup"]      = false;
            popupPagesLayoutNames = SettingsMap.GetArray();
            tdataArray["dbo_Preferencias"][".popupPagesLayoutNames"] = popupPagesLayoutNames;
            tdataArray["dbo_Preferencias"][".listAjax"] = false;
            tdataArray["dbo_Preferencias"][".listAjax"] = false;
            tdataArray["dbo_Preferencias"][".audit"]    = true;
            tdataArray["dbo_Preferencias"][".locking"]  = false;
            GlobalVars.pages = tdataArray["dbo_Preferencias"][".pages"];
            if (XVar.Pack(GlobalVars.pages[Constants.PAGE_EDIT]))
            {
                tdataArray["dbo_Preferencias"][".edit"]                    = true;
                tdataArray["dbo_Preferencias"][".afterEditAction"]         = 1;
                tdataArray["dbo_Preferencias"][".closePopupAfterEdit"]     = 1;
                tdataArray["dbo_Preferencias"][".afterEditActionDetTable"] = "";
            }
            if (XVar.Pack(GlobalVars.pages[Constants.PAGE_ADD]))
            {
                tdataArray["dbo_Preferencias"][".add"]                    = true;
                tdataArray["dbo_Preferencias"][".afterAddAction"]         = 1;
                tdataArray["dbo_Preferencias"][".closePopupAfterAdd"]     = 1;
                tdataArray["dbo_Preferencias"][".afterAddActionDetTable"] = "";
            }
            if (XVar.Pack(GlobalVars.pages[Constants.PAGE_LIST]))
            {
                tdataArray["dbo_Preferencias"][".list"] = true;
            }
            tdataArray["dbo_Preferencias"][".strSortControlSettingsJSON"] = "";
            if (XVar.Pack(GlobalVars.pages[Constants.PAGE_VIEW]))
            {
                tdataArray["dbo_Preferencias"][".view"] = true;
            }
            if (XVar.Pack(GlobalVars.pages[Constants.PAGE_IMPORT]))
            {
                tdataArray["dbo_Preferencias"][".import"] = true;
            }
            if (XVar.Pack(GlobalVars.pages[Constants.PAGE_EXPORT]))
            {
                tdataArray["dbo_Preferencias"][".exportTo"] = true;
            }
            if (XVar.Pack(GlobalVars.pages[Constants.PAGE_PRINT]))
            {
                tdataArray["dbo_Preferencias"][".printFriendly"] = true;
            }
            tdataArray["dbo_Preferencias"][".showSimpleSearchOptions"] = true;
            tdataArray["dbo_Preferencias"][".allowShowHideFields"]     = true;
            tdataArray["dbo_Preferencias"][".allowFieldsReordering"]   = true;
            tdataArray["dbo_Preferencias"][".isUseAjaxSuggest"]        = true;
            tdataArray["dbo_Preferencias"][".rowHighlite"]             = true;


            tdataArray["dbo_Preferencias"][".ajaxCodeSnippetAdded"]    = false;
            tdataArray["dbo_Preferencias"][".buttonsAdded"]            = false;
            tdataArray["dbo_Preferencias"][".addPageEvents"]           = false;
            tdataArray["dbo_Preferencias"][".isUseTimeForSearch"]      = false;
            tdataArray["dbo_Preferencias"][".badgeColor"]              = "D2691E";
            tdataArray["dbo_Preferencias"][".allSearchFields"]         = SettingsMap.GetArray();
            tdataArray["dbo_Preferencias"][".filterFields"]            = SettingsMap.GetArray();
            tdataArray["dbo_Preferencias"][".requiredSearchFields"]    = SettingsMap.GetArray();
            tdataArray["dbo_Preferencias"][".tableType"]               = "list";
            tdataArray["dbo_Preferencias"][".printerPageOrientation"]  = 0;
            tdataArray["dbo_Preferencias"][".nPrinterPageScale"]       = 100;
            tdataArray["dbo_Preferencias"][".nPrinterSplitRecords"]    = 40;
            tdataArray["dbo_Preferencias"][".nPrinterPDFSplitRecords"] = 40;
            tdataArray["dbo_Preferencias"][".geocodingEnabled"]        = false;
            tdataArray["dbo_Preferencias"][".pageSize"]         = 20;
            tdataArray["dbo_Preferencias"][".warnLeavingPages"] = true;
            tstrOrderBy = "";
            if (MVCFunctions.strlen(tstrOrderBy) && MVCFunctions.strtolower(MVCFunctions.substr(tstrOrderBy, new XVar(0), new XVar(8))) != "order by")
            {
                tstrOrderBy = MVCFunctions.Concat("order by ", tstrOrderBy);
            }
            tdataArray["dbo_Preferencias"][".strOrderBy"]   = tstrOrderBy;
            tdataArray["dbo_Preferencias"][".orderindexes"] = SettingsMap.GetArray();
            tdataArray["dbo_Preferencias"][".sqlHead"]      = "SELECT ID,  	nombre_jefe,  	division";
            tdataArray["dbo_Preferencias"][".sqlFrom"]      = "FROM dbo.Preferencias";
            tdataArray["dbo_Preferencias"][".sqlWhereExpr"] = "";
            tdataArray["dbo_Preferencias"][".sqlTail"]      = "";
            arrRPP = SettingsMap.GetArray();
            arrRPP.Add(10);
            arrRPP.Add(20);
            arrRPP.Add(30);
            arrRPP.Add(50);
            arrRPP.Add(100);
            arrRPP.Add(500);
            arrRPP.Add(-1);
            tdataArray["dbo_Preferencias"][".arrRecsPerPage"] = arrRPP;
            arrGPP = SettingsMap.GetArray();
            arrGPP.Add(1);
            arrGPP.Add(3);
            arrGPP.Add(5);
            arrGPP.Add(10);
            arrGPP.Add(50);
            arrGPP.Add(100);
            arrGPP.Add(-1);
            tdataArray["dbo_Preferencias"][".arrGroupsPerPage"]       = arrGPP;
            tdataArray["dbo_Preferencias"][".highlightSearchResults"] = true;
            tableKeysArray["dbo_Preferencias"] = SettingsMap.GetArray();
            tableKeysArray["dbo_Preferencias"].Add("ID");
            tdataArray["dbo_Preferencias"][".Keys"]           = tableKeysArray["dbo_Preferencias"];
            tdataArray["dbo_Preferencias"][".hideMobileList"] = SettingsMap.GetArray();
            fdata                                 = SettingsMap.GetArray();
            fdata["Index"]                        = 1;
            fdata["strName"]                      = "ID";
            fdata["GoodName"]                     = "ID";
            fdata["ownerTable"]                   = "dbo.Preferencias";
            fdata["Label"]                        = CommonFunctions.GetFieldLabel("dbo_Preferencias", "ID");
            fdata["FieldType"]                    = 3;
            fdata["AutoInc"]                      = true;
            fdata["strField"]                     = "ID";
            fdata["isSQLExpression"]              = true;
            fdata["FullName"]                     = "ID";
            fdata["UploadFolder"]                 = "files";
            fdata["ViewFormats"]                  = SettingsMap.GetArray();
            vdata                                 = new XVar("ViewFormat", "");
            vdata["NeedEncode"]                   = true;
            fdata["ViewFormats"]["view"]          = vdata;
            fdata["EditFormats"]                  = SettingsMap.GetArray();
            edata                                 = new XVar("EditFormat", "Text field");
            edata["IsRequired"]                   = true;
            edata["acceptFileTypes"]              = ".+$";
            edata["maxNumberOfFiles"]             = 1;
            edata["HTML5InuptType"]               = "text";
            edata["EditParams"]                   = "";
            edata["controlWidth"]                 = 200;
            edata["validateAs"]                   = SettingsMap.GetArray();
            edata["validateAs"]["basicValidate"]  = SettingsMap.GetArray();
            edata["validateAs"]["customMessages"] = SettingsMap.GetArray();
            edata["validateAs"]["basicValidate"].Add(CommonFunctions.getJsValidatorName(new XVar("Number")));
            edata["validateAs"]["basicValidate"].Add("IsRequired");
            fdata["EditFormats"]["edit"]         = edata;
            fdata["isSeparate"]                  = false;
            fdata["defaultSearchOption"]         = "Contains";
            fdata["searchOptionsList"]           = new XVar(0, "Contains", 1, "Equals", 2, "Starts with", 3, "More than", 4, "Less than", 5, "Between", 6, "Empty", 7, Constants.NOT_EMPTY);
            fdata["filterTotals"]                = 0;
            fdata["filterMultiSelect"]           = 0;
            fdata["filterFormat"]                = "Values list";
            fdata["showCollapsed"]               = false;
            fdata["sortValueType"]               = 0;
            fdata["numberOfVisibleItems"]        = 10;
            tdataArray["dbo_Preferencias"]["ID"] = fdata;
            tdataArray["dbo_Preferencias"][".searchableFields"].Add("ID");
            fdata                                         = SettingsMap.GetArray();
            fdata["Index"]                                = 2;
            fdata["strName"]                              = "nombre_jefe";
            fdata["GoodName"]                             = "nombre_jefe";
            fdata["ownerTable"]                           = "dbo.Preferencias";
            fdata["Label"]                                = CommonFunctions.GetFieldLabel("dbo_Preferencias", "nombre_jefe");
            fdata["FieldType"]                            = 200;
            fdata["strField"]                             = "nombre_jefe";
            fdata["isSQLExpression"]                      = true;
            fdata["FullName"]                             = "nombre_jefe";
            fdata["UploadFolder"]                         = "files";
            fdata["ViewFormats"]                          = SettingsMap.GetArray();
            vdata                                         = new XVar("ViewFormat", "");
            vdata["NeedEncode"]                           = true;
            fdata["ViewFormats"]["view"]                  = vdata;
            fdata["EditFormats"]                          = SettingsMap.GetArray();
            edata                                         = new XVar("EditFormat", "Text field");
            edata["acceptFileTypes"]                      = ".+$";
            edata["maxNumberOfFiles"]                     = 1;
            edata["HTML5InuptType"]                       = "text";
            edata["EditParams"]                           = "";
            edata["EditParams"]                           = MVCFunctions.Concat(edata["EditParams"], " maxlength=50");
            edata["controlWidth"]                         = 200;
            edata["validateAs"]                           = SettingsMap.GetArray();
            edata["validateAs"]["basicValidate"]          = SettingsMap.GetArray();
            edata["validateAs"]["customMessages"]         = SettingsMap.GetArray();
            fdata["EditFormats"]["edit"]                  = edata;
            fdata["isSeparate"]                           = false;
            fdata["defaultSearchOption"]                  = "Contains";
            fdata["searchOptionsList"]                    = new XVar(0, "Contains", 1, "Equals", 2, "Starts with", 3, "More than", 4, "Less than", 5, "Between", 6, "Empty", 7, Constants.NOT_EMPTY);
            fdata["filterTotals"]                         = 0;
            fdata["filterMultiSelect"]                    = 0;
            fdata["filterFormat"]                         = "Values list";
            fdata["showCollapsed"]                        = false;
            fdata["sortValueType"]                        = 0;
            fdata["numberOfVisibleItems"]                 = 10;
            tdataArray["dbo_Preferencias"]["nombre_jefe"] = fdata;
            tdataArray["dbo_Preferencias"][".searchableFields"].Add("nombre_jefe");
            fdata                                      = SettingsMap.GetArray();
            fdata["Index"]                             = 3;
            fdata["strName"]                           = "division";
            fdata["GoodName"]                          = "division";
            fdata["ownerTable"]                        = "dbo.Preferencias";
            fdata["Label"]                             = CommonFunctions.GetFieldLabel("dbo_Preferencias", "division");
            fdata["FieldType"]                         = 200;
            fdata["strField"]                          = "division";
            fdata["isSQLExpression"]                   = true;
            fdata["FullName"]                          = "division";
            fdata["UploadFolder"]                      = "files";
            fdata["ViewFormats"]                       = SettingsMap.GetArray();
            vdata                                      = new XVar("ViewFormat", "");
            vdata["NeedEncode"]                        = true;
            fdata["ViewFormats"]["view"]               = vdata;
            fdata["EditFormats"]                       = SettingsMap.GetArray();
            edata                                      = new XVar("EditFormat", "Text field");
            edata["acceptFileTypes"]                   = ".+$";
            edata["maxNumberOfFiles"]                  = 1;
            edata["HTML5InuptType"]                    = "text";
            edata["EditParams"]                        = "";
            edata["EditParams"]                        = MVCFunctions.Concat(edata["EditParams"], " maxlength=100");
            edata["controlWidth"]                      = 200;
            edata["validateAs"]                        = SettingsMap.GetArray();
            edata["validateAs"]["basicValidate"]       = SettingsMap.GetArray();
            edata["validateAs"]["customMessages"]      = SettingsMap.GetArray();
            fdata["EditFormats"]["edit"]               = edata;
            fdata["isSeparate"]                        = false;
            fdata["defaultSearchOption"]               = "Contains";
            fdata["searchOptionsList"]                 = new XVar(0, "Contains", 1, "Equals", 2, "Starts with", 3, "More than", 4, "Less than", 5, "Between", 6, "Empty", 7, Constants.NOT_EMPTY);
            fdata["filterTotals"]                      = 0;
            fdata["filterMultiSelect"]                 = 0;
            fdata["filterFormat"]                      = "Values list";
            fdata["showCollapsed"]                     = false;
            fdata["sortValueType"]                     = 0;
            fdata["numberOfVisibleItems"]              = 10;
            tdataArray["dbo_Preferencias"]["division"] = fdata;
            tdataArray["dbo_Preferencias"][".searchableFields"].Add("division");
            GlobalVars.tables_data["dbo.Preferencias"]       = tdataArray["dbo_Preferencias"];
            GlobalVars.field_labels["dbo_Preferencias"]      = fieldLabelsArray["dbo_Preferencias"];
            GlobalVars.fieldToolTips["dbo_Preferencias"]     = fieldToolTipsArray["dbo_Preferencias"];
            GlobalVars.placeHolders["dbo_Preferencias"]      = placeHoldersArray["dbo_Preferencias"];
            GlobalVars.page_titles["dbo_Preferencias"]       = pageTitlesArray["dbo_Preferencias"];
            GlobalVars.detailsTablesData["dbo.Preferencias"] = SettingsMap.GetArray();
            GlobalVars.masterTablesData["dbo.Preferencias"]  = SettingsMap.GetArray();

            SQLEntity obj        = null;
            var       protoArray = SettingsMap.GetArray();

            protoArray["0"] = SettingsMap.GetArray();
            protoArray["0"]["m_strHead"]      = "SELECT";
            protoArray["0"]["m_strFieldList"] = "ID,  	nombre_jefe,  	division";
            protoArray["0"]["m_strFrom"]      = "FROM dbo.Preferencias";
            protoArray["0"]["m_strWhere"]     = "";
            protoArray["0"]["m_strOrderBy"]   = "";


            protoArray["0"]["cipherer"]    = null;
            protoArray["2"]                = SettingsMap.GetArray();
            protoArray["2"]["m_sql"]       = "";
            protoArray["2"]["m_uniontype"] = "SQLL_UNKNOWN";
            obj = new SQLNonParsed(new XVar("m_sql", ""));

            protoArray["2"]["m_column"]     = obj;
            protoArray["2"]["m_contained"]  = SettingsMap.GetArray();
            protoArray["2"]["m_strCase"]    = "";
            protoArray["2"]["m_havingmode"] = false;
            protoArray["2"]["m_inBrackets"] = false;
            protoArray["2"]["m_useAlias"]   = false;
            obj = new SQLLogicalExpr(protoArray["2"]);

            protoArray["0"]["m_where"]     = obj;
            protoArray["4"]                = SettingsMap.GetArray();
            protoArray["4"]["m_sql"]       = "";
            protoArray["4"]["m_uniontype"] = "SQLL_UNKNOWN";
            obj = new SQLNonParsed(new XVar("m_sql", ""));

            protoArray["4"]["m_column"]     = obj;
            protoArray["4"]["m_contained"]  = SettingsMap.GetArray();
            protoArray["4"]["m_strCase"]    = "";
            protoArray["4"]["m_havingmode"] = false;
            protoArray["4"]["m_inBrackets"] = false;
            protoArray["4"]["m_useAlias"]   = false;
            obj = new SQLLogicalExpr(protoArray["4"]);

            protoArray["0"]["m_having"]    = obj;
            protoArray["0"]["m_fieldlist"] = SettingsMap.GetArray();
            protoArray["6"] = SettingsMap.GetArray();
            obj             = new SQLField(new XVar("m_strName", "ID", "m_strTable", "dbo.Preferencias", "m_srcTableName", "dbo.Preferencias"));

            protoArray["6"]["m_sql"]          = "ID";
            protoArray["6"]["m_srcTableName"] = "dbo.Preferencias";
            protoArray["6"]["m_expr"]         = obj;
            protoArray["6"]["m_alias"]        = "";
            obj = new SQLFieldListItem(protoArray["6"]);

            protoArray["0"]["m_fieldlist"].Add(obj);
            protoArray["8"] = SettingsMap.GetArray();
            obj             = new SQLField(new XVar("m_strName", "nombre_jefe", "m_strTable", "dbo.Preferencias", "m_srcTableName", "dbo.Preferencias"));

            protoArray["8"]["m_sql"]          = "nombre_jefe";
            protoArray["8"]["m_srcTableName"] = "dbo.Preferencias";
            protoArray["8"]["m_expr"]         = obj;
            protoArray["8"]["m_alias"]        = "";
            obj = new SQLFieldListItem(protoArray["8"]);

            protoArray["0"]["m_fieldlist"].Add(obj);
            protoArray["10"] = SettingsMap.GetArray();
            obj = new SQLField(new XVar("m_strName", "division", "m_strTable", "dbo.Preferencias", "m_srcTableName", "dbo.Preferencias"));

            protoArray["10"]["m_sql"]          = "division";
            protoArray["10"]["m_srcTableName"] = "dbo.Preferencias";
            protoArray["10"]["m_expr"]         = obj;
            protoArray["10"]["m_alias"]        = "";
            obj = new SQLFieldListItem(protoArray["10"]);

            protoArray["0"]["m_fieldlist"].Add(obj);
            protoArray["0"]["m_fromlist"] = SettingsMap.GetArray();
            protoArray["12"]                   = SettingsMap.GetArray();
            protoArray["12"]["m_link"]         = "SQLL_MAIN";
            protoArray["13"]                   = SettingsMap.GetArray();
            protoArray["13"]["m_strName"]      = "dbo.Preferencias";
            protoArray["13"]["m_srcTableName"] = "dbo.Preferencias";
            protoArray["13"]["m_columns"]      = SettingsMap.GetArray();
            protoArray["13"]["m_columns"].Add("nombre_jefe");
            protoArray["13"]["m_columns"].Add("division");
            protoArray["13"]["m_columns"].Add("ID");
            obj = new SQLTable(protoArray["13"]);

            protoArray["12"]["m_table"]        = obj;
            protoArray["12"]["m_sql"]          = "dbo.Preferencias";
            protoArray["12"]["m_alias"]        = "";
            protoArray["12"]["m_srcTableName"] = "dbo.Preferencias";
            protoArray["14"]                = SettingsMap.GetArray();
            protoArray["14"]["m_sql"]       = "";
            protoArray["14"]["m_uniontype"] = "SQLL_UNKNOWN";
            obj = new SQLNonParsed(new XVar("m_sql", ""));

            protoArray["14"]["m_column"]     = obj;
            protoArray["14"]["m_contained"]  = SettingsMap.GetArray();
            protoArray["14"]["m_strCase"]    = "";
            protoArray["14"]["m_havingmode"] = false;
            protoArray["14"]["m_inBrackets"] = false;
            protoArray["14"]["m_useAlias"]   = false;
            obj = new SQLLogicalExpr(protoArray["14"]);

            protoArray["12"]["m_joinon"] = obj;
            obj = new SQLFromListItem(protoArray["12"]);

            protoArray["0"]["m_fromlist"].Add(obj);
            protoArray["0"]["m_groupby"]      = SettingsMap.GetArray();
            protoArray["0"]["m_orderby"]      = SettingsMap.GetArray();
            protoArray["0"]["m_srcTableName"] = "dbo.Preferencias";
            obj = new SQLQuery(protoArray["0"]);

            queryData_Array["dbo_Preferencias"] = obj;



            tdataArray["dbo_Preferencias"][".sqlquery"]  = queryData_Array["dbo_Preferencias"];
            GlobalVars.tableEvents["dbo.Preferencias"]   = new eventsBase();
            tdataArray["dbo_Preferencias"][".hasEvents"] = false;
            GlobalVars.tables_data["dbo_Preferencias"]   = tdataArray["dbo_Preferencias"];
        }
コード例 #19
0
        public void Compile(string scriptFile, string compiledFilePath)
        {
            StreamReader reader = null;
            FileStream   fs     = null;

            string filePath = compiledFilePath + $@"Output {DateTime.Now.ToString("yyyy-MM-dd HH-mm-ss")}.csql";

            try
            {
                SQLEntity entity = new SQLEntity();
                entity.Create();

                reader = new StreamReader(scriptFile);

                string line = "";
                while ((line = reader.ReadLine()) != null)
                {
                    if (string.IsNullOrEmpty(line))
                    {
                        continue;
                    }
                    //field nome text required Nome do produto
                    if (line.StartsWith("field"))
                    {
                        string[] parts = line.Split(' ');

                        SQLField field = new SQLField();
                        field.Name     = parts[1];
                        field.Type     = parts[2];
                        field.Required = (parts[3] == "true");

                        for (int i = 4; i < parts.Length; i++)
                        {
                            field.Description += parts[i] + " ";
                        }

                        entity.Fields.Add(field);
                        continue;
                    }

                    entity.FullSQLCommand += line + "\n";
                }

                fs = new FileStream(filePath, FileMode.Create);
                BinaryFormatter formatter = new BinaryFormatter();
                formatter.Serialize(fs, entity);
                fs.Close();

                Console.WriteLine("Compilação bem sucedida. \nCaminho do arquivo: " + filePath);
                Console.WriteLine("");
                Class1.Run();
            }
            catch
            {
                if (reader != null)
                {
                    reader.Close();
                }

                if (fs != null)
                {
                    fs.Close();
                }

                throw;
            }
        }
コード例 #20
0
 internal void SetSqlEntity(SQLEntity sqlEntity)
 {
     SQLEntity = sqlEntity;
 }
コード例 #21
0
        static public void Apply()
        {
            SettingsMap arrAddTabs = SettingsMap.GetArray(), arrEditTabs = SettingsMap.GetArray(), arrGPP = SettingsMap.GetArray(), arrGridTabs = SettingsMap.GetArray(), arrRPP = SettingsMap.GetArray(), arrRegisterTabs = SettingsMap.GetArray(), arrViewTabs = SettingsMap.GetArray(), dIndex = null, detailsParam = SettingsMap.GetArray(), edata = SettingsMap.GetArray(), eventsData = SettingsMap.GetArray(), fdata = SettingsMap.GetArray(), fieldLabelsArray = new XVar(), fieldToolTipsArray = new XVar(), hours = null, intervalData = SettingsMap.GetArray(), masterParams = SettingsMap.GetArray(), pageTitlesArray = new XVar(), placeHoldersArray = new XVar(), popupPagesLayoutNames = SettingsMap.GetArray(), query = null, queryData_Array = new XVar(), reportGroupFields = SettingsMap.GetArray(), rgroupField = SettingsMap.GetArray(), strOriginalDetailsTable = null, tabFields = SettingsMap.GetArray(), table = null, tableKeysArray = new XVar(), tdataArray = new XVar(), tstrOrderBy = null, vdata = SettingsMap.GetArray();

            tdataArray["dbo__ABCSecurity"] = SettingsMap.GetArray();
            tdataArray["dbo__ABCSecurity"][".truncateText"]  = true;
            tdataArray["dbo__ABCSecurity"][".NumberOfChars"] = 80;
            tdataArray["dbo__ABCSecurity"][".ShortName"]     = "dbo__ABCSecurity";
            tdataArray["dbo__ABCSecurity"][".OwnerID"]       = "";
            tdataArray["dbo__ABCSecurity"][".OriginalTable"] = "dbo._ABCSecurity";
            fieldLabelsArray["dbo__ABCSecurity"]             = SettingsMap.GetArray();
            fieldToolTipsArray["dbo__ABCSecurity"]           = SettingsMap.GetArray();
            pageTitlesArray["dbo__ABCSecurity"]   = SettingsMap.GetArray();
            placeHoldersArray["dbo__ABCSecurity"] = SettingsMap.GetArray();
            if (CommonFunctions.mlang_getcurrentlang() == "English")
            {
                fieldLabelsArray["dbo__ABCSecurity"]["English"]               = SettingsMap.GetArray();
                fieldToolTipsArray["dbo__ABCSecurity"]["English"]             = SettingsMap.GetArray();
                placeHoldersArray["dbo__ABCSecurity"]["English"]              = SettingsMap.GetArray();
                pageTitlesArray["dbo__ABCSecurity"]["English"]                = SettingsMap.GetArray();
                fieldLabelsArray["dbo__ABCSecurity"]["English"]["ID"]         = "ID";
                fieldToolTipsArray["dbo__ABCSecurity"]["English"]["ID"]       = "";
                placeHoldersArray["dbo__ABCSecurity"]["English"]["ID"]        = "";
                fieldLabelsArray["dbo__ABCSecurity"]["English"]["username"]   = "******";
                fieldToolTipsArray["dbo__ABCSecurity"]["English"]["username"] = "";
                placeHoldersArray["dbo__ABCSecurity"]["English"]["username"]  = "";
                fieldLabelsArray["dbo__ABCSecurity"]["English"]["password"]   = "******";
                fieldToolTipsArray["dbo__ABCSecurity"]["English"]["password"] = "";
                placeHoldersArray["dbo__ABCSecurity"]["English"]["password"]  = "";
                fieldLabelsArray["dbo__ABCSecurity"]["English"]["admin"]      = "Admin";
                fieldToolTipsArray["dbo__ABCSecurity"]["English"]["admin"]    = "";
                placeHoldersArray["dbo__ABCSecurity"]["English"]["admin"]     = "";
                fieldLabelsArray["dbo__ABCSecurity"]["English"]["byear"]      = "Begin Term";
                fieldToolTipsArray["dbo__ABCSecurity"]["English"]["byear"]    = "";
                placeHoldersArray["dbo__ABCSecurity"]["English"]["byear"]     = "";
                fieldLabelsArray["dbo__ABCSecurity"]["English"]["eyear"]      = "End Term";
                fieldToolTipsArray["dbo__ABCSecurity"]["English"]["eyear"]    = "";
                placeHoldersArray["dbo__ABCSecurity"]["English"]["eyear"]     = "";
                fieldLabelsArray["dbo__ABCSecurity"]["English"]["role"]       = "Role";
                fieldToolTipsArray["dbo__ABCSecurity"]["English"]["role"]     = "";
                placeHoldersArray["dbo__ABCSecurity"]["English"]["role"]      = "";
                if (XVar.Pack(MVCFunctions.count(fieldToolTipsArray["dbo__ABCSecurity"]["English"])))
                {
                    tdataArray["dbo__ABCSecurity"][".isUseToolTips"] = true;
                }
            }
            if (CommonFunctions.mlang_getcurrentlang() == "")
            {
                fieldLabelsArray["dbo__ABCSecurity"][""]   = SettingsMap.GetArray();
                fieldToolTipsArray["dbo__ABCSecurity"][""] = SettingsMap.GetArray();
                placeHoldersArray["dbo__ABCSecurity"][""]  = SettingsMap.GetArray();
                pageTitlesArray["dbo__ABCSecurity"][""]    = SettingsMap.GetArray();
                if (XVar.Pack(MVCFunctions.count(fieldToolTipsArray["dbo__ABCSecurity"][""])))
                {
                    tdataArray["dbo__ABCSecurity"][".isUseToolTips"] = true;
                }
            }
            tdataArray["dbo__ABCSecurity"][".NCSearch"]             = true;
            tdataArray["dbo__ABCSecurity"][".shortTableName"]       = "dbo__ABCSecurity";
            tdataArray["dbo__ABCSecurity"][".nSecOptions"]          = 0;
            tdataArray["dbo__ABCSecurity"][".recsPerRowPrint"]      = 1;
            tdataArray["dbo__ABCSecurity"][".mainTableOwnerID"]     = "";
            tdataArray["dbo__ABCSecurity"][".moveNext"]             = 1;
            tdataArray["dbo__ABCSecurity"][".entityType"]           = 0;
            tdataArray["dbo__ABCSecurity"][".strOriginalTableName"] = "dbo._ABCSecurity";
            tdataArray["dbo__ABCSecurity"][".showAddInPopup"]       = false;
            tdataArray["dbo__ABCSecurity"][".showEditInPopup"]      = false;
            tdataArray["dbo__ABCSecurity"][".showViewInPopup"]      = false;
            popupPagesLayoutNames = SettingsMap.GetArray();
            tdataArray["dbo__ABCSecurity"][".popupPagesLayoutNames"] = popupPagesLayoutNames;
            tdataArray["dbo__ABCSecurity"][".fieldsForRegister"]     = SettingsMap.GetArray();
            tdataArray["dbo__ABCSecurity"][".listAjax"]                = false;
            tdataArray["dbo__ABCSecurity"][".audit"]                   = false;
            tdataArray["dbo__ABCSecurity"][".locking"]                 = false;
            tdataArray["dbo__ABCSecurity"][".edit"]                    = true;
            tdataArray["dbo__ABCSecurity"][".afterEditAction"]         = 1;
            tdataArray["dbo__ABCSecurity"][".closePopupAfterEdit"]     = 1;
            tdataArray["dbo__ABCSecurity"][".afterEditActionDetTable"] = "";
            tdataArray["dbo__ABCSecurity"][".add"]                     = true;
            tdataArray["dbo__ABCSecurity"][".afterAddAction"]          = 1;
            tdataArray["dbo__ABCSecurity"][".closePopupAfterAdd"]      = 1;
            tdataArray["dbo__ABCSecurity"][".afterAddActionDetTable"]  = "";
            tdataArray["dbo__ABCSecurity"][".list"]                    = true;
            tdataArray["dbo__ABCSecurity"][".inlineEdit"]              = true;
            tdataArray["dbo__ABCSecurity"][".reorderRecordsByHeader"]  = true;
            tdataArray["dbo__ABCSecurity"][".exportFormatting"]        = 2;
            tdataArray["dbo__ABCSecurity"][".exportDelimiter"]         = ",";
            tdataArray["dbo__ABCSecurity"][".inlineAdd"]               = true;
            tdataArray["dbo__ABCSecurity"][".view"]                    = true;
            tdataArray["dbo__ABCSecurity"][".import"]                  = true;
            tdataArray["dbo__ABCSecurity"][".exportTo"]                = true;
            tdataArray["dbo__ABCSecurity"][".printFriendly"]           = true;
            tdataArray["dbo__ABCSecurity"][".delete"]                  = true;
            tdataArray["dbo__ABCSecurity"][".showSimpleSearchOptions"] = false;
            tdataArray["dbo__ABCSecurity"][".allowShowHideFields"]     = false;
            tdataArray["dbo__ABCSecurity"][".allowFieldsReordering"]   = false;
            tdataArray["dbo__ABCSecurity"][".searchSaving"]            = false;
            tdataArray["dbo__ABCSecurity"][".showSearchPanel"]         = true;
            tdataArray["dbo__ABCSecurity"][".flexibleSearch"]          = true;
            tdataArray["dbo__ABCSecurity"][".isUseAjaxSuggest"]        = true;
            tdataArray["dbo__ABCSecurity"][".rowHighlite"]             = true;


            tdataArray["dbo__ABCSecurity"][".ajaxCodeSnippetAdded"] = false;
            tdataArray["dbo__ABCSecurity"][".buttonsAdded"]         = false;
            tdataArray["dbo__ABCSecurity"][".addPageEvents"]        = false;
            tdataArray["dbo__ABCSecurity"][".isUseTimeForSearch"]   = false;
            tdataArray["dbo__ABCSecurity"][".badgeColor"]           = "5F9EA0";
            tdataArray["dbo__ABCSecurity"][".allSearchFields"]      = SettingsMap.GetArray();
            tdataArray["dbo__ABCSecurity"][".filterFields"]         = SettingsMap.GetArray();
            tdataArray["dbo__ABCSecurity"][".requiredSearchFields"] = SettingsMap.GetArray();
            tdataArray["dbo__ABCSecurity"][".allSearchFields"].Add("username");
            tdataArray["dbo__ABCSecurity"][".allSearchFields"].Add("password");
            tdataArray["dbo__ABCSecurity"][".allSearchFields"].Add("byear");
            tdataArray["dbo__ABCSecurity"][".allSearchFields"].Add("eyear");
            tdataArray["dbo__ABCSecurity"][".allSearchFields"].Add("role");
            tdataArray["dbo__ABCSecurity"][".googleLikeFields"] = SettingsMap.GetArray();
            tdataArray["dbo__ABCSecurity"][".googleLikeFields"].Add("ID");
            tdataArray["dbo__ABCSecurity"][".googleLikeFields"].Add("username");
            tdataArray["dbo__ABCSecurity"][".googleLikeFields"].Add("password");
            tdataArray["dbo__ABCSecurity"][".googleLikeFields"].Add("admin");
            tdataArray["dbo__ABCSecurity"][".googleLikeFields"].Add("byear");
            tdataArray["dbo__ABCSecurity"][".googleLikeFields"].Add("eyear");
            tdataArray["dbo__ABCSecurity"][".googleLikeFields"].Add("role");
            tdataArray["dbo__ABCSecurity"][".advSearchFields"] = SettingsMap.GetArray();
            tdataArray["dbo__ABCSecurity"][".advSearchFields"].Add("username");
            tdataArray["dbo__ABCSecurity"][".advSearchFields"].Add("password");
            tdataArray["dbo__ABCSecurity"][".advSearchFields"].Add("byear");
            tdataArray["dbo__ABCSecurity"][".advSearchFields"].Add("eyear");
            tdataArray["dbo__ABCSecurity"][".advSearchFields"].Add("role");
            tdataArray["dbo__ABCSecurity"][".tableType"] = "list";
            tdataArray["dbo__ABCSecurity"][".printerPageOrientation"]  = 0;
            tdataArray["dbo__ABCSecurity"][".nPrinterPageScale"]       = 100;
            tdataArray["dbo__ABCSecurity"][".nPrinterSplitRecords"]    = 40;
            tdataArray["dbo__ABCSecurity"][".nPrinterPDFSplitRecords"] = 40;
            tdataArray["dbo__ABCSecurity"][".geocodingEnabled"]        = false;
            tdataArray["dbo__ABCSecurity"][".listGridLayout"]          = 3;
            tdataArray["dbo__ABCSecurity"][".pageSize"]         = 20;
            tdataArray["dbo__ABCSecurity"][".warnLeavingPages"] = true;
            tstrOrderBy = "";
            if (MVCFunctions.strlen(tstrOrderBy) && MVCFunctions.strtolower(MVCFunctions.substr(tstrOrderBy, new XVar(0), new XVar(8))) != "order by")
            {
                tstrOrderBy = MVCFunctions.Concat("order by ", tstrOrderBy);
            }
            tdataArray["dbo__ABCSecurity"][".strOrderBy"]   = tstrOrderBy;
            tdataArray["dbo__ABCSecurity"][".orderindexes"] = SettingsMap.GetArray();
            tdataArray["dbo__ABCSecurity"][".sqlHead"]      = "SELECT ID,  	username,  	password,  	[admin],  	byear,  	eyear,  	[role]";
            tdataArray["dbo__ABCSecurity"][".sqlFrom"]      = "FROM dbo.[_ABCSecurity]";
            tdataArray["dbo__ABCSecurity"][".sqlWhereExpr"] = "";
            tdataArray["dbo__ABCSecurity"][".sqlTail"]      = "";
            arrRPP = SettingsMap.GetArray();
            arrRPP.Add(10);
            arrRPP.Add(20);
            arrRPP.Add(30);
            arrRPP.Add(50);
            arrRPP.Add(100);
            arrRPP.Add(500);
            arrRPP.Add(-1);
            tdataArray["dbo__ABCSecurity"][".arrRecsPerPage"] = arrRPP;
            arrGPP = SettingsMap.GetArray();
            arrGPP.Add(1);
            arrGPP.Add(3);
            arrGPP.Add(5);
            arrGPP.Add(10);
            arrGPP.Add(50);
            arrGPP.Add(100);
            arrGPP.Add(-1);
            tdataArray["dbo__ABCSecurity"][".arrGroupsPerPage"]       = arrGPP;
            tdataArray["dbo__ABCSecurity"][".highlightSearchResults"] = true;
            tableKeysArray["dbo__ABCSecurity"] = SettingsMap.GetArray();
            tableKeysArray["dbo__ABCSecurity"].Add("ID");
            tdataArray["dbo__ABCSecurity"][".Keys"]       = tableKeysArray["dbo__ABCSecurity"];
            tdataArray["dbo__ABCSecurity"][".listFields"] = SettingsMap.GetArray();
            tdataArray["dbo__ABCSecurity"][".listFields"].Add("username");
            tdataArray["dbo__ABCSecurity"][".listFields"].Add("password");
            tdataArray["dbo__ABCSecurity"][".listFields"].Add("byear");
            tdataArray["dbo__ABCSecurity"][".listFields"].Add("eyear");
            tdataArray["dbo__ABCSecurity"][".listFields"].Add("role");
            tdataArray["dbo__ABCSecurity"][".hideMobileList"] = SettingsMap.GetArray();
            tdataArray["dbo__ABCSecurity"][".viewFields"]     = SettingsMap.GetArray();
            tdataArray["dbo__ABCSecurity"][".viewFields"].Add("username");
            tdataArray["dbo__ABCSecurity"][".viewFields"].Add("password");
            tdataArray["dbo__ABCSecurity"][".viewFields"].Add("byear");
            tdataArray["dbo__ABCSecurity"][".viewFields"].Add("eyear");
            tdataArray["dbo__ABCSecurity"][".viewFields"].Add("role");
            tdataArray["dbo__ABCSecurity"][".addFields"] = SettingsMap.GetArray();
            tdataArray["dbo__ABCSecurity"][".addFields"].Add("byear");
            tdataArray["dbo__ABCSecurity"][".addFields"].Add("eyear");
            tdataArray["dbo__ABCSecurity"][".addFields"].Add("username");
            tdataArray["dbo__ABCSecurity"][".addFields"].Add("password");
            tdataArray["dbo__ABCSecurity"][".addFields"].Add("role");
            tdataArray["dbo__ABCSecurity"][".masterListFields"] = SettingsMap.GetArray();
            tdataArray["dbo__ABCSecurity"][".masterListFields"].Add("ID");
            tdataArray["dbo__ABCSecurity"][".masterListFields"].Add("username");
            tdataArray["dbo__ABCSecurity"][".masterListFields"].Add("password");
            tdataArray["dbo__ABCSecurity"][".masterListFields"].Add("admin");
            tdataArray["dbo__ABCSecurity"][".masterListFields"].Add("byear");
            tdataArray["dbo__ABCSecurity"][".masterListFields"].Add("eyear");
            tdataArray["dbo__ABCSecurity"][".masterListFields"].Add("role");
            tdataArray["dbo__ABCSecurity"][".inlineAddFields"] = SettingsMap.GetArray();
            tdataArray["dbo__ABCSecurity"][".inlineAddFields"].Add("username");
            tdataArray["dbo__ABCSecurity"][".inlineAddFields"].Add("password");
            tdataArray["dbo__ABCSecurity"][".inlineAddFields"].Add("byear");
            tdataArray["dbo__ABCSecurity"][".inlineAddFields"].Add("eyear");
            tdataArray["dbo__ABCSecurity"][".inlineAddFields"].Add("role");
            tdataArray["dbo__ABCSecurity"][".editFields"] = SettingsMap.GetArray();
            tdataArray["dbo__ABCSecurity"][".editFields"].Add("username");
            tdataArray["dbo__ABCSecurity"][".editFields"].Add("password");
            tdataArray["dbo__ABCSecurity"][".editFields"].Add("byear");
            tdataArray["dbo__ABCSecurity"][".editFields"].Add("eyear");
            tdataArray["dbo__ABCSecurity"][".editFields"].Add("role");
            tdataArray["dbo__ABCSecurity"][".inlineEditFields"] = SettingsMap.GetArray();
            tdataArray["dbo__ABCSecurity"][".inlineEditFields"].Add("username");
            tdataArray["dbo__ABCSecurity"][".inlineEditFields"].Add("password");
            tdataArray["dbo__ABCSecurity"][".inlineEditFields"].Add("byear");
            tdataArray["dbo__ABCSecurity"][".inlineEditFields"].Add("eyear");
            tdataArray["dbo__ABCSecurity"][".inlineEditFields"].Add("role");
            tdataArray["dbo__ABCSecurity"][".updateSelectedFields"] = SettingsMap.GetArray();
            tdataArray["dbo__ABCSecurity"][".updateSelectedFields"].Add("username");
            tdataArray["dbo__ABCSecurity"][".updateSelectedFields"].Add("password");
            tdataArray["dbo__ABCSecurity"][".updateSelectedFields"].Add("byear");
            tdataArray["dbo__ABCSecurity"][".updateSelectedFields"].Add("eyear");
            tdataArray["dbo__ABCSecurity"][".updateSelectedFields"].Add("role");
            tdataArray["dbo__ABCSecurity"][".exportFields"] = SettingsMap.GetArray();
            tdataArray["dbo__ABCSecurity"][".exportFields"].Add("username");
            tdataArray["dbo__ABCSecurity"][".exportFields"].Add("password");
            tdataArray["dbo__ABCSecurity"][".exportFields"].Add("byear");
            tdataArray["dbo__ABCSecurity"][".exportFields"].Add("eyear");
            tdataArray["dbo__ABCSecurity"][".exportFields"].Add("role");
            tdataArray["dbo__ABCSecurity"][".importFields"] = SettingsMap.GetArray();
            tdataArray["dbo__ABCSecurity"][".importFields"].Add("username");
            tdataArray["dbo__ABCSecurity"][".importFields"].Add("password");
            tdataArray["dbo__ABCSecurity"][".importFields"].Add("byear");
            tdataArray["dbo__ABCSecurity"][".importFields"].Add("eyear");
            tdataArray["dbo__ABCSecurity"][".importFields"].Add("role");
            tdataArray["dbo__ABCSecurity"][".printFields"] = SettingsMap.GetArray();
            tdataArray["dbo__ABCSecurity"][".printFields"].Add("username");
            tdataArray["dbo__ABCSecurity"][".printFields"].Add("password");
            tdataArray["dbo__ABCSecurity"][".printFields"].Add("byear");
            tdataArray["dbo__ABCSecurity"][".printFields"].Add("eyear");
            tdataArray["dbo__ABCSecurity"][".printFields"].Add("role");
            fdata                                 = SettingsMap.GetArray();
            fdata["Index"]                        = 1;
            fdata["strName"]                      = "ID";
            fdata["GoodName"]                     = "ID";
            fdata["ownerTable"]                   = "dbo._ABCSecurity";
            fdata["Label"]                        = CommonFunctions.GetFieldLabel("dbo__ABCSecurity", "ID");
            fdata["FieldType"]                    = 3;
            fdata["strField"]                     = "ID";
            fdata["isSQLExpression"]              = true;
            fdata["FullName"]                     = "ID";
            fdata["UploadFolder"]                 = "files";
            fdata["ViewFormats"]                  = SettingsMap.GetArray();
            vdata                                 = new XVar("ViewFormat", "");
            vdata["NeedEncode"]                   = true;
            fdata["ViewFormats"]["view"]          = vdata;
            fdata["EditFormats"]                  = SettingsMap.GetArray();
            edata                                 = new XVar("EditFormat", "Text field");
            edata["IsRequired"]                   = true;
            edata["acceptFileTypes"]              = ".+$";
            edata["maxNumberOfFiles"]             = 1;
            edata["HTML5InuptType"]               = "number";
            edata["EditParams"]                   = "";
            edata["controlWidth"]                 = 200;
            edata["validateAs"]                   = SettingsMap.GetArray();
            edata["validateAs"]["basicValidate"]  = SettingsMap.GetArray();
            edata["validateAs"]["customMessages"] = SettingsMap.GetArray();
            edata["validateAs"]["basicValidate"].Add(CommonFunctions.getJsValidatorName(new XVar("Number")));
            edata["validateAs"]["basicValidate"].Add("IsRequired");
            fdata["EditFormats"]["edit"]         = edata;
            fdata["isSeparate"]                  = false;
            tdataArray["dbo__ABCSecurity"]["ID"] = fdata;
            fdata                                      = SettingsMap.GetArray();
            fdata["Index"]                             = 2;
            fdata["strName"]                           = "username";
            fdata["GoodName"]                          = "username";
            fdata["ownerTable"]                        = "dbo._ABCSecurity";
            fdata["Label"]                             = CommonFunctions.GetFieldLabel("dbo__ABCSecurity", "username");
            fdata["FieldType"]                         = 202;
            fdata["bListPage"]                         = true;
            fdata["bAddPage"]                          = true;
            fdata["bInlineAdd"]                        = true;
            fdata["bEditPage"]                         = true;
            fdata["bInlineEdit"]                       = true;
            fdata["bUpdateSelected"]                   = true;
            fdata["bViewPage"]                         = true;
            fdata["bAdvancedSearch"]                   = true;
            fdata["bPrinterPage"]                      = true;
            fdata["bExportPage"]                       = true;
            fdata["strField"]                          = "username";
            fdata["isSQLExpression"]                   = true;
            fdata["FullName"]                          = "username";
            fdata["FieldPermissions"]                  = true;
            fdata["UploadFolder"]                      = "files";
            fdata["ViewFormats"]                       = SettingsMap.GetArray();
            vdata                                      = new XVar("ViewFormat", "");
            vdata["NeedEncode"]                        = true;
            fdata["ViewFormats"]["view"]               = vdata;
            fdata["EditFormats"]                       = SettingsMap.GetArray();
            edata                                      = new XVar("EditFormat", "Text field");
            edata["acceptFileTypes"]                   = ".+$";
            edata["maxNumberOfFiles"]                  = 1;
            edata["HTML5InuptType"]                    = "text";
            edata["EditParams"]                        = "";
            edata["EditParams"]                        = MVCFunctions.Concat(edata["EditParams"], " maxlength=255");
            edata["controlWidth"]                      = 200;
            edata["validateAs"]                        = SettingsMap.GetArray();
            edata["validateAs"]["basicValidate"]       = SettingsMap.GetArray();
            edata["validateAs"]["customMessages"]      = SettingsMap.GetArray();
            fdata["EditFormats"]["edit"]               = edata;
            fdata["isSeparate"]                        = false;
            fdata["searchOptionsList"]                 = new XVar(0, "Contains", 1, "Equals", 2, "Starts with", 3, "More than", 4, "Less than", 5, "Between", 6, "Empty", 7, Constants.NOT_EMPTY);
            tdataArray["dbo__ABCSecurity"]["username"] = fdata;
            fdata                                      = SettingsMap.GetArray();
            fdata["Index"]                             = 3;
            fdata["strName"]                           = "password";
            fdata["GoodName"]                          = "password";
            fdata["ownerTable"]                        = "dbo._ABCSecurity";
            fdata["Label"]                             = CommonFunctions.GetFieldLabel("dbo__ABCSecurity", "password");
            fdata["FieldType"]                         = 202;
            fdata["bListPage"]                         = true;
            fdata["bAddPage"]                          = true;
            fdata["bInlineAdd"]                        = true;
            fdata["bEditPage"]                         = true;
            fdata["bInlineEdit"]                       = true;
            fdata["bUpdateSelected"]                   = true;
            fdata["bViewPage"]                         = true;
            fdata["bAdvancedSearch"]                   = true;
            fdata["bPrinterPage"]                      = true;
            fdata["bExportPage"]                       = true;
            fdata["strField"]                          = "password";
            fdata["isSQLExpression"]                   = true;
            fdata["FullName"]                          = "password";
            fdata["FieldPermissions"]                  = true;
            fdata["UploadFolder"]                      = "files";
            fdata["ViewFormats"]                       = SettingsMap.GetArray();
            vdata                                      = new XVar("ViewFormat", "");
            vdata["NeedEncode"]                        = true;
            fdata["ViewFormats"]["view"]               = vdata;
            fdata["EditFormats"]                       = SettingsMap.GetArray();
            edata                                      = new XVar("EditFormat", "Text field");
            edata["acceptFileTypes"]                   = ".+$";
            edata["maxNumberOfFiles"]                  = 1;
            edata["HTML5InuptType"]                    = "text";
            edata["EditParams"]                        = "";
            edata["EditParams"]                        = MVCFunctions.Concat(edata["EditParams"], " maxlength=255");
            edata["controlWidth"]                      = 200;
            edata["validateAs"]                        = SettingsMap.GetArray();
            edata["validateAs"]["basicValidate"]       = SettingsMap.GetArray();
            edata["validateAs"]["customMessages"]      = SettingsMap.GetArray();
            fdata["EditFormats"]["edit"]               = edata;
            fdata["isSeparate"]                        = false;
            fdata["searchOptionsList"]                 = new XVar(0, "Contains", 1, "Equals", 2, "Starts with", 3, "More than", 4, "Less than", 5, "Between", 6, "Empty", 7, Constants.NOT_EMPTY);
            tdataArray["dbo__ABCSecurity"]["password"] = fdata;
            fdata                                      = SettingsMap.GetArray();
            fdata["Index"]                             = 4;
            fdata["strName"]                           = "admin";
            fdata["GoodName"]                          = "admin";
            fdata["ownerTable"]                        = "dbo._ABCSecurity";
            fdata["Label"]                             = CommonFunctions.GetFieldLabel("dbo__ABCSecurity", "admin");
            fdata["FieldType"]                         = 11;
            fdata["strField"]                          = "admin";
            fdata["isSQLExpression"]                   = true;
            fdata["FullName"]                          = "[admin]";
            fdata["UploadFolder"]                      = "files";
            fdata["ViewFormats"]                       = SettingsMap.GetArray();
            vdata                                      = new XVar("ViewFormat", "Checkbox");
            fdata["ViewFormats"]["view"]               = vdata;
            fdata["EditFormats"]                       = SettingsMap.GetArray();
            edata                                      = new XVar("EditFormat", "Checkbox");
            edata["acceptFileTypes"]                   = ".+$";
            edata["maxNumberOfFiles"]                  = 1;
            edata["controlWidth"]                      = 200;
            edata["validateAs"]                        = SettingsMap.GetArray();
            edata["validateAs"]["basicValidate"]       = SettingsMap.GetArray();
            edata["validateAs"]["customMessages"]      = SettingsMap.GetArray();
            fdata["EditFormats"]["edit"]               = edata;
            fdata["isSeparate"]                        = false;
            tdataArray["dbo__ABCSecurity"]["admin"]    = fdata;
            fdata                                      = SettingsMap.GetArray();
            fdata["Index"]                             = 5;
            fdata["strName"]                           = "byear";
            fdata["GoodName"]                          = "byear";
            fdata["ownerTable"]                        = "dbo._ABCSecurity";
            fdata["Label"]                             = CommonFunctions.GetFieldLabel("dbo__ABCSecurity", "byear");
            fdata["FieldType"]                         = 3;
            fdata["bListPage"]                         = true;
            fdata["bAddPage"]                          = true;
            fdata["bInlineAdd"]                        = true;
            fdata["bEditPage"]                         = true;
            fdata["bInlineEdit"]                       = true;
            fdata["bUpdateSelected"]                   = true;
            fdata["bViewPage"]                         = true;
            fdata["bAdvancedSearch"]                   = true;
            fdata["bPrinterPage"]                      = true;
            fdata["bExportPage"]                       = true;
            fdata["strField"]                          = "byear";
            fdata["isSQLExpression"]                   = true;
            fdata["FullName"]                          = "byear";
            fdata["FieldPermissions"]                  = true;
            fdata["UploadFolder"]                      = "files";
            fdata["ViewFormats"]                       = SettingsMap.GetArray();
            vdata                                      = new XVar("ViewFormat", "");
            vdata["NeedEncode"]                        = true;
            fdata["ViewFormats"]["view"]               = vdata;
            fdata["EditFormats"]                       = SettingsMap.GetArray();
            edata                                      = new XVar("EditFormat", "Text field");
            edata["acceptFileTypes"]                   = ".+$";
            edata["maxNumberOfFiles"]                  = 1;
            edata["HTML5InuptType"]                    = "number";
            edata["EditParams"]                        = "";
            edata["controlWidth"]                      = 50;
            edata["validateAs"]                        = SettingsMap.GetArray();
            edata["validateAs"]["basicValidate"]       = SettingsMap.GetArray();
            edata["validateAs"]["customMessages"]      = SettingsMap.GetArray();
            edata["validateAs"]["basicValidate"].Add(CommonFunctions.getJsValidatorName(new XVar("Number")));
            fdata["EditFormats"]["edit"]            = edata;
            fdata["isSeparate"]                     = false;
            fdata["searchOptionsList"]              = new XVar(0, "Contains", 1, "Equals", 2, "Starts with", 3, "More than", 4, "Less than", 5, "Between", 6, "Empty", 7, Constants.NOT_EMPTY);
            tdataArray["dbo__ABCSecurity"]["byear"] = fdata;
            fdata                                 = SettingsMap.GetArray();
            fdata["Index"]                        = 6;
            fdata["strName"]                      = "eyear";
            fdata["GoodName"]                     = "eyear";
            fdata["ownerTable"]                   = "dbo._ABCSecurity";
            fdata["Label"]                        = CommonFunctions.GetFieldLabel("dbo__ABCSecurity", "eyear");
            fdata["FieldType"]                    = 3;
            fdata["bListPage"]                    = true;
            fdata["bAddPage"]                     = true;
            fdata["bInlineAdd"]                   = true;
            fdata["bEditPage"]                    = true;
            fdata["bInlineEdit"]                  = true;
            fdata["bUpdateSelected"]              = true;
            fdata["bViewPage"]                    = true;
            fdata["bAdvancedSearch"]              = true;
            fdata["bPrinterPage"]                 = true;
            fdata["bExportPage"]                  = true;
            fdata["strField"]                     = "eyear";
            fdata["isSQLExpression"]              = true;
            fdata["FullName"]                     = "eyear";
            fdata["FieldPermissions"]             = true;
            fdata["UploadFolder"]                 = "files";
            fdata["ViewFormats"]                  = SettingsMap.GetArray();
            vdata                                 = new XVar("ViewFormat", "");
            vdata["NeedEncode"]                   = true;
            fdata["ViewFormats"]["view"]          = vdata;
            fdata["EditFormats"]                  = SettingsMap.GetArray();
            edata                                 = new XVar("EditFormat", "Text field");
            edata["acceptFileTypes"]              = ".+$";
            edata["maxNumberOfFiles"]             = 1;
            edata["HTML5InuptType"]               = "number";
            edata["EditParams"]                   = "";
            edata["controlWidth"]                 = 50;
            edata["validateAs"]                   = SettingsMap.GetArray();
            edata["validateAs"]["basicValidate"]  = SettingsMap.GetArray();
            edata["validateAs"]["customMessages"] = SettingsMap.GetArray();
            edata["validateAs"]["basicValidate"].Add(CommonFunctions.getJsValidatorName(new XVar("Number")));
            fdata["EditFormats"]["edit"]            = edata;
            fdata["isSeparate"]                     = false;
            fdata["searchOptionsList"]              = new XVar(0, "Contains", 1, "Equals", 2, "Starts with", 3, "More than", 4, "Less than", 5, "Between", 6, "Empty", 7, Constants.NOT_EMPTY);
            tdataArray["dbo__ABCSecurity"]["eyear"] = fdata;
            fdata                             = SettingsMap.GetArray();
            fdata["Index"]                    = 7;
            fdata["strName"]                  = "role";
            fdata["GoodName"]                 = "role";
            fdata["ownerTable"]               = "dbo._ABCSecurity";
            fdata["Label"]                    = CommonFunctions.GetFieldLabel("dbo__ABCSecurity", "role");
            fdata["FieldType"]                = 202;
            fdata["bListPage"]                = true;
            fdata["bAddPage"]                 = true;
            fdata["bInlineAdd"]               = true;
            fdata["bEditPage"]                = true;
            fdata["bInlineEdit"]              = true;
            fdata["bUpdateSelected"]          = true;
            fdata["bViewPage"]                = true;
            fdata["bAdvancedSearch"]          = true;
            fdata["bPrinterPage"]             = true;
            fdata["bExportPage"]              = true;
            fdata["strField"]                 = "role";
            fdata["isSQLExpression"]          = true;
            fdata["FullName"]                 = "[role]";
            fdata["FieldPermissions"]         = true;
            fdata["UploadFolder"]             = "files";
            fdata["ViewFormats"]              = SettingsMap.GetArray();
            vdata                             = new XVar("ViewFormat", "");
            vdata["NeedEncode"]               = true;
            fdata["ViewFormats"]["view"]      = vdata;
            fdata["EditFormats"]              = SettingsMap.GetArray();
            edata                             = new XVar("EditFormat", "Lookup wizard");
            edata["LookupType"]               = 0;
            edata["autoCompleteFieldsOnEdit"] = 0;
            edata["autoCompleteFields"]       = SettingsMap.GetArray();
            edata["LCType"]                   = 0;
            edata["LookupValues"]             = SettingsMap.GetArray();
            edata["LookupValues"].Add("admin");
            edata["LookupValues"].Add("readonly");
            edata["LookupValues"].Add("member");
            edata["SelectSize"]                              = 1;
            edata["acceptFileTypes"]                         = ".+$";
            edata["maxNumberOfFiles"]                        = 1;
            edata["controlWidth"]                            = 200;
            edata["validateAs"]                              = SettingsMap.GetArray();
            edata["validateAs"]["basicValidate"]             = SettingsMap.GetArray();
            edata["validateAs"]["customMessages"]            = SettingsMap.GetArray();
            fdata["EditFormats"]["edit"]                     = edata;
            fdata["isSeparate"]                              = false;
            fdata["defaultSearchOption"]                     = "Equals";
            fdata["searchOptionsList"]                       = new XVar(0, "Contains", 1, "Equals", 2, "Starts with", 3, "More than", 4, "Less than", 5, "Between", 6, "Empty", 7, Constants.NOT_EMPTY);
            tdataArray["dbo__ABCSecurity"]["role"]           = fdata;
            GlobalVars.tables_data["dbo._ABCSecurity"]       = tdataArray["dbo__ABCSecurity"];
            GlobalVars.field_labels["dbo__ABCSecurity"]      = fieldLabelsArray["dbo__ABCSecurity"];
            GlobalVars.fieldToolTips["dbo__ABCSecurity"]     = fieldToolTipsArray["dbo__ABCSecurity"];
            GlobalVars.placeHolders["dbo__ABCSecurity"]      = placeHoldersArray["dbo__ABCSecurity"];
            GlobalVars.page_titles["dbo__ABCSecurity"]       = pageTitlesArray["dbo__ABCSecurity"];
            GlobalVars.detailsTablesData["dbo._ABCSecurity"] = SettingsMap.GetArray();
            GlobalVars.masterTablesData["dbo._ABCSecurity"]  = SettingsMap.GetArray();


            strOriginalDetailsTable          = "dbo._ABCVotes";
            masterParams                     = SettingsMap.GetArray();
            masterParams["mDataSourceTable"] = "dbo._ABCVotes";
            masterParams["mOriginalTable"]   = strOriginalDetailsTable;
            masterParams["mShortTable"]      = "dbo__ABCVotes";
            masterParams["masterKeys"]       = SettingsMap.GetArray();
            masterParams["detailKeys"]       = SettingsMap.GetArray();
            masterParams["dispChildCount"]   = 0;
            masterParams["hideChild"]        = 0;
            masterParams["dispMasterInfo"]   = SettingsMap.GetArray();
            masterParams["previewOnList"]    = 2;
            masterParams["previewOnAdd"]     = 0;
            masterParams["previewOnEdit"]    = 0;
            masterParams["previewOnView"]    = 0;
            masterParams["proceedLink"]      = 1;
            masterParams["type"]             = Constants.PAGE_LIST;
            GlobalVars.masterTablesData["dbo._ABCSecurity"][0] = masterParams;
            GlobalVars.masterTablesData["dbo._ABCSecurity"][0]["masterKeys"] = SettingsMap.GetArray();
            GlobalVars.masterTablesData["dbo._ABCSecurity"][0]["masterKeys"].Add("committee_member");
            GlobalVars.masterTablesData["dbo._ABCSecurity"][0]["detailKeys"] = SettingsMap.GetArray();
            GlobalVars.masterTablesData["dbo._ABCSecurity"][0]["detailKeys"].Add("username");

            SQLEntity obj        = null;
            var       protoArray = SettingsMap.GetArray();

            protoArray["0"] = SettingsMap.GetArray();
            protoArray["0"]["m_strHead"]      = "SELECT";
            protoArray["0"]["m_strFieldList"] = "ID,  	username,  	password,  	[admin],  	byear,  	eyear,  	[role]";
            protoArray["0"]["m_strFrom"]      = "FROM dbo.[_ABCSecurity]";
            protoArray["0"]["m_strWhere"]     = "";
            protoArray["0"]["m_strOrderBy"]   = "";


            protoArray["0"]["cipherer"]    = null;
            protoArray["2"]                = SettingsMap.GetArray();
            protoArray["2"]["m_sql"]       = "";
            protoArray["2"]["m_uniontype"] = "SQLL_UNKNOWN";
            obj = new SQLNonParsed(new XVar("m_sql", ""));

            protoArray["2"]["m_column"]     = obj;
            protoArray["2"]["m_contained"]  = SettingsMap.GetArray();
            protoArray["2"]["m_strCase"]    = "";
            protoArray["2"]["m_havingmode"] = false;
            protoArray["2"]["m_inBrackets"] = false;
            protoArray["2"]["m_useAlias"]   = false;
            obj = new SQLLogicalExpr(protoArray["2"]);

            protoArray["0"]["m_where"]     = obj;
            protoArray["4"]                = SettingsMap.GetArray();
            protoArray["4"]["m_sql"]       = "";
            protoArray["4"]["m_uniontype"] = "SQLL_UNKNOWN";
            obj = new SQLNonParsed(new XVar("m_sql", ""));

            protoArray["4"]["m_column"]     = obj;
            protoArray["4"]["m_contained"]  = SettingsMap.GetArray();
            protoArray["4"]["m_strCase"]    = "";
            protoArray["4"]["m_havingmode"] = false;
            protoArray["4"]["m_inBrackets"] = false;
            protoArray["4"]["m_useAlias"]   = false;
            obj = new SQLLogicalExpr(protoArray["4"]);

            protoArray["0"]["m_having"]    = obj;
            protoArray["0"]["m_fieldlist"] = SettingsMap.GetArray();
            protoArray["6"] = SettingsMap.GetArray();
            obj             = new SQLField(new XVar("m_strName", "ID", "m_strTable", "dbo._ABCSecurity", "m_srcTableName", "dbo._ABCSecurity"));

            protoArray["6"]["m_sql"]          = "ID";
            protoArray["6"]["m_srcTableName"] = "dbo._ABCSecurity";
            protoArray["6"]["m_expr"]         = obj;
            protoArray["6"]["m_alias"]        = "";
            obj = new SQLFieldListItem(protoArray["6"]);

            protoArray["0"]["m_fieldlist"].Add(obj);
            protoArray["8"] = SettingsMap.GetArray();
            obj             = new SQLField(new XVar("m_strName", "username", "m_strTable", "dbo._ABCSecurity", "m_srcTableName", "dbo._ABCSecurity"));

            protoArray["8"]["m_sql"]          = "username";
            protoArray["8"]["m_srcTableName"] = "dbo._ABCSecurity";
            protoArray["8"]["m_expr"]         = obj;
            protoArray["8"]["m_alias"]        = "";
            obj = new SQLFieldListItem(protoArray["8"]);

            protoArray["0"]["m_fieldlist"].Add(obj);
            protoArray["10"] = SettingsMap.GetArray();
            obj = new SQLField(new XVar("m_strName", "password", "m_strTable", "dbo._ABCSecurity", "m_srcTableName", "dbo._ABCSecurity"));

            protoArray["10"]["m_sql"]          = "password";
            protoArray["10"]["m_srcTableName"] = "dbo._ABCSecurity";
            protoArray["10"]["m_expr"]         = obj;
            protoArray["10"]["m_alias"]        = "";
            obj = new SQLFieldListItem(protoArray["10"]);

            protoArray["0"]["m_fieldlist"].Add(obj);
            protoArray["12"] = SettingsMap.GetArray();
            obj = new SQLField(new XVar("m_strName", "admin", "m_strTable", "dbo._ABCSecurity", "m_srcTableName", "dbo._ABCSecurity"));

            protoArray["12"]["m_sql"]          = "[admin]";
            protoArray["12"]["m_srcTableName"] = "dbo._ABCSecurity";
            protoArray["12"]["m_expr"]         = obj;
            protoArray["12"]["m_alias"]        = "";
            obj = new SQLFieldListItem(protoArray["12"]);

            protoArray["0"]["m_fieldlist"].Add(obj);
            protoArray["14"] = SettingsMap.GetArray();
            obj = new SQLField(new XVar("m_strName", "byear", "m_strTable", "dbo._ABCSecurity", "m_srcTableName", "dbo._ABCSecurity"));

            protoArray["14"]["m_sql"]          = "byear";
            protoArray["14"]["m_srcTableName"] = "dbo._ABCSecurity";
            protoArray["14"]["m_expr"]         = obj;
            protoArray["14"]["m_alias"]        = "";
            obj = new SQLFieldListItem(protoArray["14"]);

            protoArray["0"]["m_fieldlist"].Add(obj);
            protoArray["16"] = SettingsMap.GetArray();
            obj = new SQLField(new XVar("m_strName", "eyear", "m_strTable", "dbo._ABCSecurity", "m_srcTableName", "dbo._ABCSecurity"));

            protoArray["16"]["m_sql"]          = "eyear";
            protoArray["16"]["m_srcTableName"] = "dbo._ABCSecurity";
            protoArray["16"]["m_expr"]         = obj;
            protoArray["16"]["m_alias"]        = "";
            obj = new SQLFieldListItem(protoArray["16"]);

            protoArray["0"]["m_fieldlist"].Add(obj);
            protoArray["18"] = SettingsMap.GetArray();
            obj = new SQLField(new XVar("m_strName", "role", "m_strTable", "dbo._ABCSecurity", "m_srcTableName", "dbo._ABCSecurity"));

            protoArray["18"]["m_sql"]          = "[role]";
            protoArray["18"]["m_srcTableName"] = "dbo._ABCSecurity";
            protoArray["18"]["m_expr"]         = obj;
            protoArray["18"]["m_alias"]        = "";
            obj = new SQLFieldListItem(protoArray["18"]);

            protoArray["0"]["m_fieldlist"].Add(obj);
            protoArray["0"]["m_fromlist"] = SettingsMap.GetArray();
            protoArray["20"]                   = SettingsMap.GetArray();
            protoArray["20"]["m_link"]         = "SQLL_MAIN";
            protoArray["21"]                   = SettingsMap.GetArray();
            protoArray["21"]["m_strName"]      = "dbo._ABCSecurity";
            protoArray["21"]["m_srcTableName"] = "dbo._ABCSecurity";
            protoArray["21"]["m_columns"]      = SettingsMap.GetArray();
            protoArray["21"]["m_columns"].Add("ID");
            protoArray["21"]["m_columns"].Add("username");
            protoArray["21"]["m_columns"].Add("password");
            protoArray["21"]["m_columns"].Add("admin");
            protoArray["21"]["m_columns"].Add("byear");
            protoArray["21"]["m_columns"].Add("eyear");
            protoArray["21"]["m_columns"].Add("role");
            obj = new SQLTable(protoArray["21"]);

            protoArray["20"]["m_table"]        = obj;
            protoArray["20"]["m_sql"]          = "dbo.[_ABCSecurity]";
            protoArray["20"]["m_alias"]        = "";
            protoArray["20"]["m_srcTableName"] = "dbo._ABCSecurity";
            protoArray["22"]                = SettingsMap.GetArray();
            protoArray["22"]["m_sql"]       = "";
            protoArray["22"]["m_uniontype"] = "SQLL_UNKNOWN";
            obj = new SQLNonParsed(new XVar("m_sql", ""));

            protoArray["22"]["m_column"]     = obj;
            protoArray["22"]["m_contained"]  = SettingsMap.GetArray();
            protoArray["22"]["m_strCase"]    = "";
            protoArray["22"]["m_havingmode"] = false;
            protoArray["22"]["m_inBrackets"] = false;
            protoArray["22"]["m_useAlias"]   = false;
            obj = new SQLLogicalExpr(protoArray["22"]);

            protoArray["20"]["m_joinon"] = obj;
            obj = new SQLFromListItem(protoArray["20"]);

            protoArray["0"]["m_fromlist"].Add(obj);
            protoArray["0"]["m_groupby"]      = SettingsMap.GetArray();
            protoArray["0"]["m_orderby"]      = SettingsMap.GetArray();
            protoArray["0"]["m_srcTableName"] = "dbo._ABCSecurity";
            obj = new SQLQuery(protoArray["0"]);

            queryData_Array["dbo__ABCSecurity"] = obj;



            tdataArray["dbo__ABCSecurity"][".sqlquery"]  = queryData_Array["dbo__ABCSecurity"];
            GlobalVars.tableEvents["dbo._ABCSecurity"]   = new eventsBase();
            tdataArray["dbo__ABCSecurity"][".hasEvents"] = false;
            GlobalVars.tables_data["dbo__ABCSecurity"]   = tdataArray["dbo__ABCSecurity"];
        }