public List <Sobiens.Connectors.Entities.Folder> GetFolders(ISiteSetting siteSetting, Sobiens.Connectors.Entities.Folder parentFolder, int[] includedFolderTypes) { List <Sobiens.Connectors.Entities.Folder> subFolders = new List <Sobiens.Connectors.Entities.Folder>(); if (parentFolder as Sobiens.Connectors.Entities.SQLServer.SQLServer != null) { Sobiens.Connectors.Entities.SQLServer.SQLServer sqlServer = (Sobiens.Connectors.Entities.SQLServer.SQLServer)parentFolder; try { using (SqlConnection con = new SqlConnection(this.GetConnectionString(siteSetting, string.Empty))) { con.Open(); // Set up a command with the given query and associate // this with the current connection. using (SqlCommand cmd = new SqlCommand("SELECT name from sys.databases", con)) { using (IDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { string dbName = dr[0].ToString(); if (dbName.Equals("master", StringComparison.InvariantCultureIgnoreCase) == false && dbName.Equals("model", StringComparison.InvariantCultureIgnoreCase) == false && dbName.Equals("tempdb", StringComparison.InvariantCultureIgnoreCase) == false && dbName.Equals("msdb", StringComparison.InvariantCultureIgnoreCase) == false ) { SQLDB list = new SQLDB(dbName, siteSetting.ID, dbName); subFolders.Add(list); } } } } } } catch (Exception ex) { string message = string.Format("SharePointService GetWebs method returned error:{0}", ex.Message); Logger.Error(message, "Service"); } } else if (parentFolder as SQLDB != null) { using (SqlConnection connection = new SqlConnection(this.GetConnectionString(siteSetting, parentFolder.Title))) { connection.Open(); DataTable schema = connection.GetSchema("Tables"); foreach (DataRow row in schema.Rows) { string tableName = row[2].ToString(); SQLTable table = new SQLTable(tableName, siteSetting.ID, tableName, parentFolder.Title); //table.ListName = parentFolder.Title; subFolders.Add(table); } } } return(subFolders); }
public SelectView_Form(Form xParentForm, SQLTable xTbl, TableDockingFormXml xTableDockingFormXml, ViewXml CurrentViewXml, xml myXml,FormMode mode) { m_mode = mode; m_ParentForm = xParentForm; this.Owner = xParentForm; this.Icon = CodeTables.Properties.Resources.SelectViewIcon; m_xml = myXml; m_CurrentViewXml = CurrentViewXml; m_tbl = xTbl; m_TableDockingFormXml = xTableDockingFormXml; InitializeComponent(); if (m_mode == FormMode.SELECT) { this.Text = lngRPM.s_SelectViewForTable.s + m_tbl.lngTableName.s; chkBoxSetAsDefault.Visible = true; this.btn_Select.Text = lngRPM.s_Select.s; this.btn_Cancel.Text = lngRPM.s_Cancel.s; } else { this.Text = lngRPM.s_DeleteViewForTable.s + m_tbl.lngTableName.s; chkBoxSetAsDefault.Visible = false; this.btn_Select.Text = lngRPM.s_Delete.s; this.btn_Cancel.Text = lngRPM.s_Close.s; } this.chkBoxSetAsDefault.Text = lngRPM.s_SelectAsDefaultView.s; lnlViewName.Text = lngRPM.s_SelectedView.s; foreach (ViewXml xViewXml in m_TableDockingFormXml.m_ViewXml) { this.rdblist_Views.Items.Add(xViewXml); } }
// constructor; public void Define_SQL_Database_Tables(DBTableControl m_DBTables, DBSettings_TableClass.SQL_Database_Tables_Definition mt) { /* 1 */ t_DBSettings = new SQLTable((Object)new DBSettings(), Column.Flags.FILTER_AND_UNIQUE, lngTName.lngt_DBSettings); t_DBSettings.AddColumn((Object)mt.m_DBSettings.ID, Column.nullTYPE.NOT_NULL, Column.Flags.UNIQUE, Column.eStyle.none, new string[] { "ID", "ID" }); t_DBSettings.AddColumn((Object)mt.m_DBSettings.Name, Column.nullTYPE.NOT_NULL, Column.Flags.FILTER_AND_UNIQUE, Column.eStyle.TextBox_ReadOnly, new string[] { "Name", "Ime nastavitve" }); t_DBSettings.AddColumn((Object)mt.m_DBSettings.TextValue, Column.nullTYPE.NOT_NULL, Column.Flags.FILTER_AND_UNIQUE, Column.eStyle.TextBox, new string[] { "Text value", "Vrednost" }); m_DBTables.items.Add(t_DBSettings); }
public bool CreateTable(SQLTable data) { try { StringBuilder tableQuery = new StringBuilder(); tableQuery.AppendFormat("CREATE TABLE {0} (", data.TableName); if (data.Columns.Count == 0) { return(false); } else { int i = 0; foreach (var column in data.Columns) { i++; if (i == data.Columns.Count) { tableQuery.Append(column.Key + " " + column.Value + ");"); } else { tableQuery.Append(column.Key + " " + column.Value + ","); } } } //open connection if (this.OpenConnection() == true) { //create command and assign the query and connection from the constructor MySqlCommand cmd = new MySqlCommand(tableQuery.ToString(), _connection); //Execute command cmd.ExecuteNonQuery(); //close connection this.CloseConnection(); return(true); } return(false); } catch (MySqlException mex) { this.CloseConnection(); throw mex; } catch (Exception ex) { throw ex; } }
/// <summary> /// Realiza una consulta en una tabla de la base de datos /// y la devuelve en forma de tabla de tipo DataTable /// </summary> /// <param name="Table">Nombre de la tabla a consultar</param> /// <param name="ListFields">Lista de parámetros a consultar</param> /// <param name="Filter">Filtro de la búsqueda</param> /// <param name="OrderBy">Si es verdadero y la búsqueda no devuelve /// ningún resultado, se cargan todos los datos de los parámetros asignados /// aunque no coincidan con la búsqueda</param> /// <returns></returns> protected static DataTable GetDataTable(SQLTable Table, List <TEnum> ListFields, DataFieldTemplate Filter, bool UnconditionalReturnsAll, TEnum OrderBy) { Select <TEnum> S = new Select <TEnum>(ListFields, Table) { Conditional = Filter, OrderByField = OrderBy }; return(!UnconditionalReturnsAll && !S.IsConditionable ? null : S.ExecuteSelect()); }
private void Application_Startup(object sender, StartupEventArgs e) { SQLRandomTableContent randomContent = new SQLRandomTableContent("Random", "random"); ITable originalTable = new SQLTable(randomContent, randomContent.Numbers); SQLSortedTableContent sortedContent = new SQLSortedTableContent("Sorted", "sorted"); ITable sortedTable = new SQLTable(sortedContent, sortedContent.Numbers); INumbers originalNnumbers = new Numbers(originalTable); INumbers sortedNnumbers = new Numbers(sortedTable); ISorting sorting = new CountingSorting(); ICore core = new Core(sorting, originalNnumbers, sortedNnumbers); MainWindow window = new MainWindow(core); window.Show(); }
public Select(TField Field, SQLTable Table) { this.Field = Field; this.Table = Table; }
public Select(List <TField> Fields, SQLTable Table) { this.Fields = Fields; this.Table = Table; }
protected static DataTable GetDataTable(SQLTable Table, List <TEnum> ListFields) { return(GetDataTable(Table, ListFields, null, false)); }
protected static DataTable GetDataTable(SQLTable Table, List <TEnum> ListFields, DataFieldTemplate Filter, bool UnconditionalReturnsAll) { return(GetDataTable(Table, ListFields, Filter, UnconditionalReturnsAll, ListFields[0])); }
public TableView_Form(int iIndex, DBTableControl dbTables, SQLTable tbl, TableDockingForm dtF, ViewXml xViewXml) { m_Index = iIndex; m_DBTables = dbTables; m_tbl = tbl; m_TableDockingForm = dtF; m_ViewXml = xViewXml; m_pTableDockingFormXml = m_DBTables.m_xml.GetTableDockingFormXml(m_tbl.TableName); if (m_pTableDockingFormXml.m_TableViewFormXml[iIndex] == null) { m_pTableDockingFormXml.m_TableViewFormXml[iIndex] = new TableViewFormXml(); } m_pTableDockingFormXml.m_TableViewFormXml[iIndex].m_DefaultViewXml = xViewXml; InitializeComponent(); dataGridView_Table.ReadOnly = true; tsmi_Select_View.Text = lngRPM.s_SelectView.s; this.Text = lngRPM.s_View.s + " " + m_Index.ToString() + " " + m_tbl.lngTableName.s; // this.Text = m_tbl.lngTableName.s + " " + lngRPM.s_View.s + ":" + m_ViewXml.Name; string csError = ""; this.label_PrimaryView.Text = lngRPM.s_PrimaryView.s; this.label_ViewName.Text = lngRPM.s_View.s; chkBox_BindWith_EditTable_Form.Text = lngRPM.s_ConnectWithEditTableForm.s; FillDataTable(ref csError); }
public static void InitSidang() { dTables = new List<SQLTable>(); dTables.Clear(); List<string> tempItems1 = new List<string>(); List<string> tempItems2 = new List<string>(); List<string> tempItems3 = new List<string>(); List<string> tempItems4 = new List<string>(); List<string> tempItems5 = new List<string>(); List<bool> tempKeys1 = new List<bool>(); List<bool> tempKeys2 = new List<bool>(); List<bool> tempKeys3 = new List<bool>(); List<bool> tempKeys4 = new List<bool>(); List<bool> tempKeys5 = new List<bool>(); SQLTable tempTable1 = new SQLTable(); SQLTable tempTable2 = new SQLTable(); SQLTable tempTable3 = new SQLTable(); SQLTable tempTable4 = new SQLTable(); SQLTable tempTable5 = new SQLTable(); //Mahasiswa tempItems1.Add("Mahasiswa"); tempItems1.Add("NIM"); tempItems1.Add("Nama"); tempItems1.Add("Judul"); tempItems1.Add("Bidang"); tempItems1.Add("Pembimbing1"); tempItems1.Add("Pembimbing2"); tempTable1.items = tempItems1; tempKeys1.Add(true); tempKeys1.Add(false); tempKeys1.Add(false); tempKeys1.Add(false); tempKeys1.Add(true); tempKeys1.Add(true); tempTable1.keys = tempKeys1; dTables.Add(tempTable1); //Penguji1 tempItems2.Add("Penguji1"); tempItems2.Add("Penguji1"); tempItems2.Add("Bidang11"); tempItems2.Add("Bidang12"); tempTable2.items = tempItems2; tempKeys2.Add(true); tempKeys2.Add(false); tempKeys2.Add(false); tempTable2.keys = tempKeys2; dTables.Add(tempTable2); //Penguji2 tempItems3.Add("Penguji2"); tempItems3.Add("Penguji2"); tempItems3.Add("Bidang21"); tempItems3.Add("Bidang22"); tempTable3.items = tempItems3; tempKeys3.Add(true); tempKeys3.Add(false); tempKeys3.Add(false); tempTable3.keys = tempKeys3; dTables.Add(tempTable3); //Tempat tempItems4.Add("Tempat"); tempItems4.Add("Ruangan"); tempTable4.items = tempItems4; tempKeys4.Add(true); tempTable4.keys = tempKeys4; dTables.Add(tempTable4); //Waktu tempItems5.Add("Waktu"); tempItems5.Add("Hari"); tempItems5.Add("Jam"); tempTable5.items = tempItems5; tempKeys5.Add(false); tempKeys5.Add(false); tempTable5.keys = tempKeys5; dTables.Add(tempTable5); }
public static void InitSeminarII() { dTables = new List<SQLTable>(); dTables.Clear(); List<string> tempItems1 = new List<string>(); List<string> tempItems2 = new List<string>(); List<string> tempItems3 = new List<string>(); List<bool> tempKeys1 = new List<bool>(); List<bool> tempKeys2 = new List<bool>(); List<bool> tempKeys3 = new List<bool>(); SQLTable tempTable1 = new SQLTable(); SQLTable tempTable2 = new SQLTable(); SQLTable tempTable3 = new SQLTable(); //kuliah tempItems1.Add("Mahasiswa"); tempItems1.Add("NIM"); tempItems1.Add("Nama"); tempItems1.Add("Judul"); tempItems1.Add("Bidang"); tempItems1.Add("Pembimbing1"); tempItems1.Add("Pembimbing2"); tempTable1.items = tempItems1; tempKeys1.Add(true); tempKeys1.Add(false); tempKeys1.Add(false); tempKeys1.Add(false); tempKeys1.Add(true); tempKeys1.Add(true); tempTable1.keys = tempKeys1; dTables.Add(tempTable1); //Tempat tempItems2.Add("Tempat"); tempItems2.Add("Ruangan"); tempTable2.items = tempItems2; tempKeys2.Add(true); tempTable2.keys = tempKeys2; dTables.Add(tempTable2); //Waktu tempItems3.Add("Waktu"); tempItems3.Add("Hari"); tempItems3.Add("Jam"); tempTable3.items = tempItems3; tempKeys3.Add(false); tempKeys3.Add(false); tempTable3.keys = tempKeys3; dTables.Add(tempTable3); }
public static void InitMahasiswa() { dTables = new List<SQLTable>(); dTables.Clear(); List<string> tempItems1 = new List<string>(); List<string> tempItems2 = new List<string>(); List<string> tempItems3 = new List<string>(); List<bool> tempKeys1 = new List<bool>(); List<bool> tempKeys2 = new List<bool>(); List<bool> tempKeys3 = new List<bool>(); SQLTable tempTable1 = new SQLTable(); SQLTable tempTable2 = new SQLTable(); SQLTable tempTable3 = new SQLTable(); //kuliah tempItems1.Add("Kuliah"); tempItems1.Add("Kode"); tempItems1.Add("Tingkat"); tempItems1.Add("Kelas"); tempItems1.Add("Pengajar"); tempItems1.Add("Bagian"); tempItems1.Add("Lama"); tempItems1.Add("Mahasiswa"); tempTable1.items = tempItems1; tempKeys1.Add(true); tempKeys1.Add(false); tempKeys1.Add(false); tempKeys1.Add(true); tempKeys1.Add(false); tempKeys1.Add(false); tempKeys1.Add(false); tempTable1.keys = tempKeys1; dTables.Add(tempTable1); //Tempat tempItems2.Add("Tempat"); tempItems2.Add("Ruangan"); tempItems2.Add("Kapasitas"); tempTable2.items = tempItems2; tempKeys2.Add(true); tempKeys2.Add(false); tempTable2.keys = tempKeys2; dTables.Add(tempTable2); //Waktu tempItems3.Add("Waktu"); tempItems3.Add("Hari"); tempItems3.Add("Jam1"); tempItems3.Add("Jam2"); tempItems3.Add("Keterangan"); tempItems3.Add("Slot"); tempTable3.items = tempItems3; tempKeys3.Add(false); tempKeys3.Add(false); tempKeys3.Add(false); tempKeys3.Add(false); tempKeys3.Add(false); tempTable3.keys = tempKeys3; dTables.Add(tempTable3); }
public static void InitJadwal2() { dTables = new List<SQLTable>(); dTables.Clear(); List<string> tempItems1 = new List<string>(); //List<string> tempItems2 = new List<string>(); List<string> tempItems3 = new List<string>(); List<string> tempItems4 = new List<string>(); List<bool> tempKeys1 = new List<bool>(); //List<bool> tempKeys2 = new List<bool>(); List<bool> tempKeys3 = new List<bool>(); List<bool> tempKeys4 = new List<bool>(); SQLTable tempTable1 = new SQLTable(); //SQLTable tempTable2 = new SQLTable(); SQLTable tempTable3 = new SQLTable(); SQLTable tempTable4 = new SQLTable(); //Mahasiswa tempItems1.Add("Mahasiswa"); tempItems1.Add("NIM"); tempItems1.Add("Nama"); tempItems1.Add("Judul"); tempItems1.Add("Bidang"); tempItems1.Add("Pembimbing1"); tempItems1.Add("Pembimbing2"); tempTable1.items = tempItems1; tempKeys1.Add(true); tempKeys1.Add(false); tempKeys1.Add(false); tempKeys1.Add(false); tempKeys1.Add(false); tempKeys1.Add(false); tempTable1.keys = tempKeys1; dTables.Add(tempTable1); //Dosen // tempItems2.Add("Dosen"); // tempItems2.Add("Penguji"); // tempItems2.Add("Bidang1"); // tempItems2.Add("Bidang2"); // tempTable2.items = tempItems2; // tempKeys2.Add(false); // tempKeys2.Add(false); // tempKeys2.Add(false); // tempTable2.keys = tempKeys2; // dTables.Add(tempTable2); //Tempat tempItems3.Add("Tempat"); tempItems3.Add("Ruangan"); tempTable3.items = tempItems3; tempKeys3.Add(true); tempTable3.keys = tempKeys3; dTables.Add(tempTable3); //Waktu tempItems4.Add("Waktu"); tempItems4.Add("Kode Waktu"); tempItems4.Add("Hari"); tempItems4.Add("Jam"); tempItems4.Add("Hasil"); tempTable4.items = tempItems4; tempKeys4.Add(true); tempKeys4.Add(false); tempKeys4.Add(false); tempKeys4.Add(false); tempTable4.keys = tempKeys4; dTables.Add(tempTable4); }
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"]; }
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"]; }
public void SQLiteDB_BeginTransaction_RollBack_void_ret_void() { #region Prepara EntityDemo entity1 = new EntityDemo { Clave1 = "Key1Get01", Clave2 = "Key1Get02", Campo1 = "Field1Get01", Campo2 = "Field1Get02", Campo3 = "Field1Get03" }; EntityDemo entity2 = new EntityDemo { Clave1 = "Key2Get01", Clave2 = "Key2Get02", Campo1 = "Field2Get01", Campo2 = "Field2Get02", Campo3 = "Field2Get03" }; EntityDemo entity3 = new EntityDemo { Clave1 = "Key3Get01", Clave2 = "Key3Get02", Campo1 = "Field3Get01", Campo2 = "Field3Get02", Campo3 = "Field3Get03" }; IDataBase db = null; try { db = new SQLiteDB("TestDB"); db.Open(); SQLTable <EntityDemo> table = new SQLTable <EntityDemo> { DB = db }; table.DeleteAll(); } catch (Exception) { } finally { db.Close(); } #endregion // Ejecuta IDataBase dbTran = new SQLiteDB("TestDB"); dbTran.Open(); SQLTable <EntityDemo> tableTran = new SQLTable <EntityDemo> { DB = dbTran }; tableTran.Insert(entity1); tableTran.Insert(entity2); dbTran.BeginTransaction(); tableTran.Insert(entity3); dbTran.RollBack(); dbTran.Close(); // Comprueba dbTran.Open(); EntityDemo[] entityGets = tableTran.GetAll(); dbTran.Close(); Assert.IsNotNull(entityGets); Assert.AreEqual(2, entityGets.Length); Assert.AreEqual("Key1Get01", entityGets[0].Clave1); Assert.AreEqual("Key1Get02", entityGets[0].Clave2); Assert.AreEqual("Field1Get01", entityGets[0].Campo1); Assert.AreEqual("Field1Get02", entityGets[0].Campo2); Assert.AreEqual("Field1Get03", entityGets[0].Campo3); Assert.AreEqual("Key2Get01", entityGets[1].Clave1); Assert.AreEqual("Key2Get02", entityGets[1].Clave2); Assert.AreEqual("Field2Get01", entityGets[1].Campo1); Assert.AreEqual("Field2Get02", entityGets[1].Campo2); Assert.AreEqual("Field2Get03", entityGets[1].Campo3); }