public Searching(JQGrid grid, string searchColumn, string searchString, string searchOperation) { this._grid = grid; this._searchColunm = searchColumn; this._searchString = searchString; this._searchOperation = searchOperation; }
internal static List<string> GetListOfColumns(JQGrid grid) { List<string> result = new List<string>(); grid.Columns.AsList().FindAll((JQGridColumn c) => c.EditType == EditType.DatePicker || c.EditType == EditType.AutoComplete).ForEach(delegate(JQGridColumn c) { Guard.IsNullOrEmpty(c.EditorControlID, "JQGridColumn.EditorControlID", "must be set to the ID of the editing control control if EditType = DatePicker or EditType = AutoComplete"); result.Add(c.EditType.ToString().ToLower() + ":" + c.DataField); }); return result; }
internal static List<string> GetListOfSearchEditors(JQGrid grid) { List<string> result = new List<string>(); grid.Columns.AsList().FindAll((JQGridColumn c) => c.SearchType == SearchType.DatePicker || c.SearchType == SearchType.AutoComplete).ForEach(delegate(JQGridColumn c) { Guard.IsNullOrEmpty(c.SearchControlID, "JQGridColumn.SearchControlID", "must be set to the ID of the searching control control if SearchType = DatePicker or SearchType = AutoComplete"); result.Add(c.SearchControlID); }); return result; }
public static int GetPrimaryKeyIndex(JQGrid grid) { foreach (JQGridColumn jQGridColumn in grid.Columns) { if (jQGridColumn.PrimaryKey) { return grid.Columns.IndexOf(jQGridColumn); } } return 0; }
public static Hashtable GetFooterInfo(JQGrid grid) { Hashtable hashtable = new Hashtable(); if (grid.AppearanceSettings.ShowFooter) { foreach (JQGridColumn jQGridColumn in grid.Columns) { hashtable[jQGridColumn.DataField] = jQGridColumn.FooterValue; } } return hashtable; }
internal static string ConvertToJson(JsonResponse response, JQGrid grid, DataTable dt) { object obj; if (response.records == 0) { obj = new object[0]; } else { obj = Util.PrepareJsonResponse(response, grid, dt); } return new JavaScriptSerializer().Serialize(obj); }
public static DataTable ToDataTable(this IEnumerable en, JQGrid grid) { DataTable result = new DataTable(); DataView dataView = en as DataView; if (dataView != null) { result = dataView.ToTable(); } else { if (en != null) { result = IEnumerableExtensions.ObtainDataTableFromIEnumerable(en, grid); } } return result; }
public static string GetWhereClause(JQGrid grid) { string text = " && "; string text2 = ""; new Hashtable(); foreach (JQGridColumn jQGridColumn in grid.Columns) { string text3 = HttpContext.Current.Request[jQGridColumn.DataField]; if (!string.IsNullOrEmpty(text3)) { Util.SearchArguments args = new Util.SearchArguments { SearchColumn = jQGridColumn.DataField, SearchString = text3, SearchOperation = jQGridColumn.SearchToolBarOperation }; string str = (text2.Length > 0) ? text : ""; string str2 = Util.ConstructLinqFilterExpression(args); text2 = text2 + str + str2; } } return text2; }
public JsonSearchToolBar(JQGrid grid) { this._jsonValues = new Hashtable(); this._grid = grid; }
internal static JsonResponse PrepareJsonResponse(JsonResponse response, JQGrid grid, DataTable dt) { for (int i = 0; i < dt.Rows.Count; i++) { string[] array = new string[grid.Columns.Count]; for (int j = 0; j < grid.Columns.Count; j++) { JQGridColumn jQGridColumn = grid.Columns[j]; string text = ""; if (!string.IsNullOrEmpty(jQGridColumn.DataField)) { Guard.IsNull(dt.Columns[jQGridColumn.DataField], "The column with DataField=" + jQGridColumn.DataField + " does not exist in the datasource."); int ordinal = dt.Columns[jQGridColumn.DataField].Ordinal; text = (string.IsNullOrEmpty(jQGridColumn.DataFormatString) ? dt.Rows[i].ItemArray[ordinal].ToString() : jQGridColumn.FormatDataValue(dt.Rows[i].ItemArray[ordinal], jQGridColumn.HtmlEncode)); } array[j] = text; } string text2 = array[Util.GetPrimaryKeyIndex(grid)]; for (int k = 0; k < grid.Columns.Count; k++) { JQGridCellBindEventArgs jQGridCellBindEventArgs = new JQGridCellBindEventArgs(array[k], k, i, text2, dt.Rows[i].ItemArray); grid.OnCellBinding(jQGridCellBindEventArgs); array[k] = jQGridCellBindEventArgs.CellHtml; grid.OnCellBound(jQGridCellBindEventArgs); } JsonRow jsonRow = new JsonRow(); jsonRow.id = text2; jsonRow.cell = array; response.rows[i] = jsonRow; } return response; }
internal static string ConvertToTreeJson(JsonTreeResponse response, JQGrid grid, DataTable dt) { object obj = Util.PrepareJsonTreeResponse(response, grid, dt); return new JavaScriptSerializer().Serialize(obj); }
public JsonColModel(JQGrid grid) { this._jsonValues = new Hashtable(); this._grid = grid; }
public JQGridRenderer(JQGrid grid) { this._grid = grid; }
public JsonDelDialog(JQGrid grid) { this._jsonValues = new Hashtable(); this._grid = grid; }
public MultipleSearching(JQGrid grid, string searchFilters) : base(grid) { this._grid = grid; this._searchFilters = searchFilters; }
private static DataTable ObtainDataTableFromIEnumerable(IEnumerable ien, JQGrid grid) { DataTable dataTable = new DataTable(); foreach (object current in ien) { if (current is DbDataRecord) { DbDataRecord dbDataRecord = current as DbDataRecord; if (dataTable.Columns.Count == 0) { foreach (JQGridColumn jQGridColumn in grid.Columns) { dataTable.Columns.Add(jQGridColumn.DataField); } } DataRow dataRow = dataTable.NewRow(); foreach (JQGridColumn jQGridColumn2 in grid.Columns) { dataRow[jQGridColumn2.DataField] = dbDataRecord[jQGridColumn2.DataField]; } dataTable.Rows.Add(dataRow); } else { if (current is DataRow) { DataRow dataRow2 = current as DataRow; if (dataTable.Columns.Count == 0) { foreach (JQGridColumn jQGridColumn3 in grid.Columns) { dataTable.Columns.Add(jQGridColumn3.DataField); } } DataRow dataRow3 = dataTable.NewRow(); foreach (JQGridColumn jQGridColumn4 in grid.Columns) { dataRow3[jQGridColumn4.DataField] = dataRow2[jQGridColumn4.DataField]; } dataTable.Rows.Add(dataRow3); } else { Type type = current.GetType(); PropertyInfo[] properties = type.GetProperties(); if (dataTable.Columns.Count == 0) { PropertyInfo[] array = properties; for (int i = 0; i < array.Length; i++) { PropertyInfo propertyInfo = array[i]; Type type2 = propertyInfo.PropertyType; if (type2.IsGenericType && type2.GetGenericTypeDefinition() == typeof(Nullable<>)) { type2 = Nullable.GetUnderlyingType(type2); } dataTable.Columns.Add(propertyInfo.Name, type2); } } DataRow dataRow4 = dataTable.NewRow(); PropertyInfo[] array2 = properties; for (int j = 0; j < array2.Length; j++) { PropertyInfo propertyInfo2 = array2[j]; object value = propertyInfo2.GetValue(current, null); if (value != null) { dataRow4[propertyInfo2.Name] = value; } else { dataRow4[propertyInfo2.Name] = DBNull.Value; } } dataTable.Rows.Add(dataRow4); } } } return dataTable; }
public JsonColModel(JQGridColumn column, JQGrid grid) : this(grid) { this.FromColumn(column); }
public static string RemoveQuotesForJavaScriptMethods(string input, JQGrid grid) { string text = input; foreach (JQGridColumn jQGridColumn in grid.Columns) { if (jQGridColumn.Formatter != null && jQGridColumn.Formatter.Count > 0 && jQGridColumn.Formatter[0] != null) { JQGridColumnFormatter jQGridColumnFormatter = jQGridColumn.Formatter[0]; if (jQGridColumnFormatter is CustomFormatter) { CustomFormatter customFormatter = (CustomFormatter)jQGridColumnFormatter; string oldValue = string.Format("\"formatter\":\"{0}\"", customFormatter.FormatFunction); string newValue = string.Format("\"formatter\":{0}", customFormatter.FormatFunction); text = text.Replace(oldValue, newValue); oldValue = string.Format("\"unformat\":\"{0}\"", customFormatter.UnFormatFunction); newValue = string.Format("\"unformat\":{0}", customFormatter.UnFormatFunction); text = text.Replace(oldValue, newValue); } } foreach (JQGridEditClientSideValidator jQGridEditClientSideValidator in jQGridColumn.EditClientSideValidators) { if (jQGridEditClientSideValidator is CustomValidator) { CustomValidator customValidator = (CustomValidator)jQGridEditClientSideValidator; string oldValue2 = string.Format("\"custom_func\":\"{0}\"", customValidator.ValidationFunction); string newValue2 = string.Format("\"custom_func\":{0}", customValidator.ValidationFunction); text = text.Replace(oldValue2, newValue2); } } if (jQGridColumn.EditType == EditType.Custom) { string oldValue3 = string.Format("\"custom_element\":\"{0}\"", jQGridColumn.EditTypeCustomCreateElement); string newValue3 = string.Format("\"custom_element\":{0}", jQGridColumn.EditTypeCustomCreateElement); text = text.Replace(oldValue3, newValue3); oldValue3 = string.Format("\"custom_value\":\"{0}\"", jQGridColumn.EditTypeCustomGetValue); newValue3 = string.Format("\"custom_value\":{0}", jQGridColumn.EditTypeCustomGetValue); text = text.Replace(oldValue3, newValue3); } if ((jQGridColumn.Editable && jQGridColumn.EditType == EditType.DatePicker) || jQGridColumn.EditType == EditType.AutoComplete) { string attachEditorsFunction = GridUtil.GetAttachEditorsFunction(grid, jQGridColumn.EditType.ToString().ToLower(), jQGridColumn.EditorControlID); text = text.Replace(string.Concat(new object[] { '"', "attachEditControlsScript", jQGridColumn.DataField, '"' }), attachEditorsFunction); text = text.Replace('"' + "dataInit" + '"', "dataInit"); } if ((jQGridColumn.Searchable && jQGridColumn.SearchType == SearchType.DatePicker) || jQGridColumn.SearchType == SearchType.AutoComplete) { string attachEditorsFunction2 = GridUtil.GetAttachEditorsFunction(grid, jQGridColumn.SearchType.ToString().ToLower(), jQGridColumn.SearchControlID); text = text.Replace(string.Concat(new object[] { '"', "attachSearchControlsScript", jQGridColumn.DataField, '"' }), attachEditorsFunction2); text = text.Replace('"' + "dataInit" + '"', "dataInit"); } } return text; }
public ToolBarSearching(JQGrid grid) : base(grid) { this._grid = grid; }
internal static JsonTreeResponse PrepareJsonTreeResponse(JsonTreeResponse response, JQGrid grid, DataTable dt) { for (int i = 0; i < dt.Rows.Count; i++) { response.rows[i] = new Hashtable(); for (int j = 0; j < grid.Columns.Count; j++) { JQGridColumn jQGridColumn = grid.Columns[j]; string value = ""; if (!string.IsNullOrEmpty(jQGridColumn.DataField)) { Guard.IsNull(dt.Columns[jQGridColumn.DataField], "The column with DataField=" + jQGridColumn.DataField + " does not exist in the datasource."); int ordinal = dt.Columns[jQGridColumn.DataField].Ordinal; value = (string.IsNullOrEmpty(jQGridColumn.DataFormatString) ? dt.Rows[i].ItemArray[ordinal].ToString() : jQGridColumn.FormatDataValue(dt.Rows[i].ItemArray[ordinal], jQGridColumn.HtmlEncode)); } response.rows[i].Add(jQGridColumn.DataField, value); } try { response.rows[i].Add("tree_level", dt.Rows[i]["tree_level"] as int?); } catch { } try { response.rows[i].Add("tree_parent", Convert.ToString(dt.Rows[i]["tree_parent"])); } catch { } try { response.rows[i].Add("tree_leaf", Convert.ToBoolean(dt.Rows[i]["tree_leaf"])); } catch { } try { response.rows[i].Add("tree_expanded", Convert.ToBoolean(dt.Rows[i]["tree_expanded"])); } catch { } try { response.rows[i].Add("tree_loaded", Convert.ToBoolean(dt.Rows[i]["tree_loaded"])); } catch { } try { response.rows[i].Add("tree_icon", Convert.ToString(dt.Rows[i]["tree_icon"])); } catch { } } return response; }
private string GetFirstVisibleDataField(JQGrid grid) { foreach (JQGridColumn jQGridColumn in grid.Columns) { if (jQGridColumn.Visible) { return jQGridColumn.DataField; } } return grid.Columns[0].DataField; }
public static string GetPrimaryKeyField(JQGrid grid) { int primaryKeyIndex = Util.GetPrimaryKeyIndex(grid); return grid.Columns[primaryKeyIndex].DataField; }
public JsonViewRowDetailsDialog(JQGrid grid) { this._jsonValues = new Hashtable(); this._grid = grid; }
public BaseSearching(JQGrid grid) { this._grid = grid; }
internal static string GetAttachEditorsFunction(JQGrid grid, string editorType, string editorControlID) { new JavaScriptSerializer(); GridUtil.GetListOfColumns(grid); GridUtil.GetListOfEditors(grid); StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append("function(el) {"); stringBuilder.Append("setTimeout(function() {"); stringBuilder.AppendFormat("var ec = '{0}';", editorControlID); if (editorType == "datepicker") { stringBuilder.Append("if (typeof(jQuery(el).datepicker) !== 'function')"); stringBuilder.Append("alert('JQDatePicker javascript not present on the page. Please, include jquery.jqDatePicker.min.js');"); stringBuilder.Append("jQuery(el).datepicker( eval(ec + '_dpid') );"); } if (editorType == "autocomplete") { stringBuilder.Append("if (typeof(jQuery(el).autocomplete) !== 'function')"); stringBuilder.Append("alert('JQAutoComplete javascript not present on the page. Please, include jquery.jqAutoComplete.min.js');"); stringBuilder.Append("jQuery(el).autocomplete( eval(ec + '_acid') );"); } stringBuilder.Append("},200);"); stringBuilder.Append("}"); return stringBuilder.ToString(); }