//---------------------------------------------------------------------------------------------------- public void Instantiate_Sub() { this.jRoot = J("<tr class='RowUI jRoot'>"); this.jRoot.append(this.GetHtmlRoot()); if (this.IsOdd) { this.jRoot.addClass("RowUI_Alt"); } for (int i = 0; i < this.Model.Values.Length; i++) { string value = this.Model.Values[i]; if (this.ViewModel.TableType == GridRequest.TableTypes.View) { if (value.Length > 100) { value = st.New(value).TruncateRight(value.Length - 99).TheString + "..."; } } this.jRoot.append(JsStr.StrFormat1("<td>{0}</td>", value)); } if (this.ViewModel.TableType == GridRequest.TableTypes.Table) { jF(".Bttn_Open").attr("href", "#00-Record-" + this.Model.UniqueKey); } else { jF(".Bttn_Open").hide(); jF(".Bttn_Open2").show(); } var thisObj = this; var jRootObj = this.jRoot; eval(@" jRootObj.find('td').click(function() { thisObj.Td_Clicked(this); }); jRootObj.find('td').dblclick(function() { thisObj.Td_DoubleClicked(this); }); "); }
//------------------------------------------------------------------------------------------ Events -- public void GetInfo_ForCreateNew_Return(ASPdb.Ajax.AjaxResponse ajaxResponse) { if (UI.Errors.ExceptionHandler.Check(ajaxResponse)) { return; } var response = ajaxResponse.ReturnObj.As <TableDesignResponse>(); this.ViewModel.Set(response); this.ViewModel.IsCreateNew = true; this.Model = new TableStructure(); this.Model.ConnectionId = this.ViewModel.ConnectionId; this.ColumnsPanel.Model = this.Model; this.ViewModel.TableStructure = this.Model; jF2(".TopSection_CreateTable").show(); jF2(".Label1_ConnectionName").html(response.ConnectionName); jF2(".Txt_TableName").focus().val(""); jF2(".Tab_ForCreate").show(); jF2(".PanelsHolder").show(); var select_Schema = jF2(".Select_Schema"); select_Schema.html(""); for (int i = 0; i < response.Schemas.Length; i++) { if (JsStr.S(response.Schemas[i]).ToLower().String == "dbo") { select_Schema.append("<option selected='selected'>" + response.Schemas[i] + "</option>"); } else { select_Schema.append("<option>" + response.Schemas[i] + "</option>"); } } this.TabClick_Columns(); ASPdatabaseNET.UI.PagesFramework.BasePage.WindowResized(); }
//---------------------------------------------------------------------------------------------------- public void Instantiate_Sub() { jRoot = J("<div class='SectionBox jRoot'>"); jRoot.append(this.GetHtmlRoot()); if (this.Model != null && this.Model.IsOpen) { jF2(".SectionLinks").show(); } var holder = jF2(".SectionLinks").html(""); if (this.Model != null && this.Model.Items != null) { string previousSchema = ""; int schemasCount = 0; for (int i = 0; i < this.Model.Items.Length; i++) { if (previousSchema != this.Model.Items[i].Schema) { previousSchema = this.Model.Items[i].Schema; schemasCount++; } } previousSchema = ""; for (int i = 0; i < this.Model.Items.Length; i++) { var itemInfo = this.Model.Items[i]; if (schemasCount > 1) { if (previousSchema != itemInfo.Schema) { holder.append("<div class='Schema' title='Schema: [" + itemInfo.Schema + "]'>" + itemInfo.Schema + "</div>"); } } previousSchema = itemInfo.Schema; holder.append(JsStr.StrFormat2("<a href='{0}'>{1}</a>", itemInfo.URL, itemInfo.Name)); } } this.BindUI(); }
//---------------------------------------------------------------------------------------------------- private void Populate_SelectOptions(jQuery jSelectElement, string listPropertiesSetting, object[] optionsObjects, ModelListCommand cmd) { jSelectElement.html(""); for (int i = 0; i < optionsObjects.Length; i++) { var optionsObj = JsObj.O(optionsObjects[i]); string value = optionsObj.Property2(cmd.Item_Value, ""); string text = optionsObj.Property2(cmd.Item_Text, ""); string style = optionsObj.Property2(cmd.Item_Style, ""); string styleAttribute = ""; if (style.Length > 0) { styleAttribute = "style='" + style + "'"; } jSelectElement.append(JsStr.StrFormat3("<option value='{0}' {1} >{2}</option>", value, styleAttribute, text)); } }
//---------------------------------------------------------------------------------------------------- public void Open_Sub() { this.jRoot.html(""); if (this.ViewModel == null || this.ViewModel.List == null || this.ViewModel.List.Length < 1) { return; } for (int i = 0; i < this.ViewModel.List.Length; i++) { var item = this.ViewModel.List[i]; string indexClass = "ItemIndex_" + i; string html = JsStr.StrFormat4(@" <div class='Item {0}'> <input type='radio' name='{1}' value='{2}' /> {3} </div>", indexClass, this.RadioGroupName, item.Value, item.Text); this.jRoot.append(html); Evt.Attach_Click(this, indexClass, "Div_Click", i); } this.UpdateUI(); }
//---------------------------------------------------------------------------------------------------- public void Instantiate_Sub() { this.jRoot = J("<tr class='FieldUI jRoot'>"); this.jRoot.append(this.GetHtmlRoot()); this.EditModel = new FieldValue(); this.EditModel.Index = this.Model.Index; this.EditModel.Value = this.Model.Value; this.EditModel.IsNull = this.Model.IsNull; this.Column = this.ViewModel.RecordInfo.Columns[this.Model.Index]; this.InputType = InputTypes.SingleLine; bool isFixedText = false; switch (this.Column.DataType_Name.As <JsString>().toLowerCase()) { case "bit": this.InputType = InputTypes.TrueFalse; break; case "ntext": this.InputType = InputTypes.MultiLineBig; break; case "text": this.InputType = InputTypes.MultiLineBig; break; case "image": this.InputType = InputTypes.MultiLineBig; break; case "xml": this.InputType = InputTypes.MultiLineBig; break; //case "nvarchar": this.InputType = InputTypes.MultiLineSmall; break; //case "nchar": this.InputType = InputTypes.MultiLineSmall; break; //case "char": this.InputType = InputTypes.MultiLineSmall; break; //case "varbinary": this.InputType = InputTypes.MultiLineSmall; break; //case "varchar": this.InputType = InputTypes.MultiLineSmall; break; case "nvarchar": this.InputType = InputTypes.SingleLine; break; case "nchar": this.InputType = InputTypes.SingleLine; break; case "char": this.InputType = InputTypes.SingleLine; break; case "varbinary": this.InputType = InputTypes.SingleLine; break; case "varchar": this.InputType = InputTypes.SingleLine; break; } if (isFixedText) { if (this.Column.MaxLength > 99) { this.InputType = InputTypes.MultiLineSmall; } } jF(".NameDiv").html(this.Column.ColumnName); jF(".ValueDiv").text(this.Model.Value); string value = jF(".ValueDiv").html(); value = JsStr.S(value).Replace1("\n", "<br />"); jF(".ValueDiv").html(value); if (this.Column.IsPrimaryKey) { jF(".NameDiv").addClass("PrimaryKeyDiv"); } if (!this.Column.AllowNulls) { jF(".NullHolder").hide(); } else if (this.EditModel.IsNull) { this.EditModel.IsNull = false; // used because of toggle in next line this.Null_Click(); } var thisObj = this; var jRootObj = this.jRoot; eval("jRootObj.find('.TextInput').keyup(function(event) { thisObj.Input_Changed(event, true) });"); }
public void GetGrid_Return(ASPdb.Ajax.AjaxResponse response) { if (UI.Errors.ExceptionHandler.Check(response)) { if (response.Error.Message == "Invalid FilterField." && !this.LastAttemptWas_InvalidFilterField) { this.LastAttemptWas_InvalidFilterField = true; this.ViewModel.FilterAndSort = new FilterAndSort(); this.ViewModel.FilterAndSort.FilterFields = new ViewOptions_FilterField[0]; this.ViewModel.FilterAndSort.SortFields = new ViewOptions_SortField[0]; this.ViewOptions.BttnClick_ApplyAndRefresh(); } else { return; } } this.LastAttemptWas_InvalidFilterField = false; if (this.RecordViewerUI != null) { this.RecordViewerUI = null; } this.Model = response.ReturnObj.As <GridResponse>(); document.title = "[" + this.Model.TableName + "] - ASPdatabase.NET"; if (this.ViewModel.FilterAndSort.FilterFields != null && this.ViewModel.FilterAndSort.FilterFields.Length > 0) { this.GridToolBar.SetFilterCount(this.ViewModel.FilterAndSort.FilterFields.Length); } else if (this.ViewModel.FilterAndSort.SortFields != null && this.ViewModel.FilterAndSort.SortFields.Length > 0) { this.GridToolBar.SetFilterCount(0); } else { this.GridToolBar.SetFilterCount(-1); } this.ViewModel.SelectionCount = 0; this.ViewModel.AllColumnNames = new string[0]; for (int i = 0; i < this.Model.HeaderItems.Length; i++) { this.ViewModel.AllColumnNames[i] = this.Model.HeaderItems[i].FieldName; } this.BindUI(); this.GridToolBar.Model = this.Model; this.GridToolBar.Open(); var tableGridTable = jF(".TableGridTable").html(""); string headerHTML = "<tr>" + "<th class='SelectAllBox' title='Select/Deselect All'><span></span></th>" + "<th></th>"; for (int i = 0; i < this.Model.HeaderItems.Length; i++) { headerHTML += JsStr.StrFormat1("<th>{0}</th>", this.Model.HeaderItems[i].FieldName); } headerHTML += "</tr>"; tableGridTable.html(headerHTML); var thisObj = this; var jRootObj = this.jRoot; eval("jRootObj.find('.SelectAllBox').click(function(){ thisObj.SelectAllBox_Click(); });"); this.RowUIs = new RowUI[0]; for (int i = 0; i < this.Model.Rows.Length; i++) { this.RowUIs[i] = new RowUI(); this.RowUIs[i].IsOdd = (i % 2 == 1); this.RowUIs[i].ViewModel = this.ViewModel; this.RowUIs[i].Model = this.Model.Rows[i]; this.RowUIs[i].Model.DisplayIndex = i; this.RowUIs[i].OnSelection.After.AddHandler(this, "RowUI_OnSelection", 0); this.RowUIs[i].OnOpenViewer.After.AddHandler(this, "RowUI_OnOpenViewer", 1); this.RowUIs[i].Instantiate(); tableGridTable.append(this.RowUIs[i].jRoot); } UI.PagesFramework.BasePage.WindowResized(); }