예제 #1
0
        public OrdersJqGridModel()
        {
            OrdersGrid = new JQGrid
            {
                Columns = new List<JQGridColumn>()
                                 {
                                     new JQGridColumn { DataField = "OrderID",
                                                        // always set PrimaryKey for Add,Edit,Delete operations
                                                        // if not set, the first column will be assumed as primary key
                                                        PrimaryKey = true,
                                                        Editable = false,
                                                        Width = 50 },
                                     new JQGridColumn { DataField = "OrderDate",
                                                        Editable = true,
                                                        Width = 100,
                                                        DataFormatString = "{0:d}" },
                                     new JQGridColumn { DataField = "CustomerID",
                                                        Editable = true,
                                                        Width = 100 },
                                     new JQGridColumn { DataField = "Freight",
                                                        Editable = true,
                                                        Width = 75 },
                                     new JQGridColumn { DataField = "ShipName",
                                                        Editable =  true
                                                      }
                                 },
                Width = Unit.Pixel(640)
            };

            OrdersGrid.ToolBarSettings.ShowRefreshButton = true;
        }
        public RentrakJqGridModel()
        {
            RentrakGrid = new JQGrid
            {
                Columns = new List<JQGridColumn>()
                                 {
                                     new JQGridColumn { DataField = "ID",
                                                        // always set PrimaryKey for Add,Edit,Delete operations
                                                        // if not set, the first column will be assumed as primary key
                                                        PrimaryKey = true,
                                                        Editable = false,
                                                        Width = 50 },
                                     new JQGridColumn { DataField = "Market",
                                                        Editable = true,
                                                        Width = 200},
                                     new JQGridColumn { DataField = "Episode",
                                                        Editable = true,
                                                        Width = 200 },
                                     new JQGridColumn { DataField = "Series",
                                                        Editable = true,
                                                        Width = 200 },
                                     new JQGridColumn { DataField = "Station",
                                                        Editable =  true,
                                                        Width = 200
                                                      }
                                 },
                Width = Unit.Pixel(850)
            };

            RentrakGrid.ToolBarSettings.ShowRefreshButton = true;
        }
예제 #3
0
        /// <summary>
        /// Initializes a new instance of the <see cref="EmployeeJqGridViewData"/> class.
        /// </summary>
        public EmployeeJqGridViewData()
        {
            EmployeeGrid = new JQGrid
            {
                Columns = new List<JQGridColumn>()
                                 {
                                     new JQGridColumn { DataField = "EmployeeID",
                                                        // always set PrimaryKey for Add,Edit,Delete operations
                                                        // if not set, the first column will be assumed as primary key
                                                        PrimaryKey = true,
                                                        Editable = false,
                                                        Width = 100 },
                                     new JQGridColumn { DataField = "NationalIDNumber",
                                                        Editable = false
                                                        },
                                     new JQGridColumn { DataField = "Title",
                                                        Editable = false,
                                                        Width = 200 },
                                     new JQGridColumn { DataField = "BirthDate",
                                                        Editable = false,
                                                        DataFormatString = "{0:d}" }
                                 },
                Width = Unit.Pixel(650),
                Height = Unit.Pixel(250)
            };

            EmployeeGrid.ToolBarSettings.ShowRefreshButton = true;
        }
예제 #4
0
 internal static string GetAttachEditorsFunction(JQGrid grid, string editorType, string editorControlID)
 {
     new JavaScriptSerializer();
     GetListOfColumns(grid);
     GetListOfEditors(grid);
     StringBuilder builder = new StringBuilder();
     builder.Append("function(el) {");
     builder.Append("setTimeout(function() {");
     builder.AppendFormat("var ec = '{0}';", editorControlID);
     if (editorType == "datepicker")
     {
         builder.Append("if (typeof(jQuery(el).datepicker) !== 'function')");
         builder.Append("alert('JQDatePicker javascript not present on the page. Please, include jquery.jqDatePicker.min.js');");
         builder.Append("jQuery(el).datepicker( eval(ec + '_dpid') );");
     }
     if (editorType == "autocomplete")
     {
         builder.Append("if (typeof(jQuery(el).autocomplete) !== 'function')");
         builder.Append("alert('JQAutoComplete javascript not present on the page. Please, include jquery.jqAutoComplete.min.js');");
         builder.Append("jQuery(el).autocomplete( eval(ec + '_acid') );");
     }
     builder.Append("},200);");
     builder.Append("}");
     return builder.ToString();
 }
예제 #5
0
        public JQGridModel()
        {
            RetailDataGrid = new JQGrid
            {
                    Columns = new List<JQGridColumn>()
                    {
                        new JQGridColumn {
                                        DataField = "UserId",
                                        Visible = false,
                                        PrimaryKey = true
                                        },
                        new JQGridColumn { DataField = "UserName", Visible = false, },
                        new JQGridColumn { DataField = "UserEmail", Visible = false, },
                        new JQGridColumn { DataField = "UserRole", Visible = false, },
                        new JQGridColumn { DataField = General.GetString("VIEW"), Visible = false, Formatter = new CustomFormatter{ FormatFunction = "formatEditLink",}},
                        new JQGridColumn { DataField = General.GetString("DELETE"), Visible = false, Formatter = new CustomFormatter{ FormatFunction = "formatDeletLink",}},

                    },
                    Width = Unit.Pixel(600),
                    Height = Unit.Percentage(300),
                    SortSettings = new SortSettings
                                       {
                                           InitialSortColumn = "Position",
                                       },
                    TreeGridSettings = new TreeGridSettings
                    {
                        Enabled = true
                    }
               };
        }
 public static DataTable ToDataTable(this IEnumerable en, JQAutoComplete autoComplete)
 {
     JQGrid grid = new JQGrid {
         Columns = { new JQGridColumn { DataField = autoComplete.DataField } }
     };
     return en.ToDataTable(grid);
 }
예제 #7
0
        public ModeracionCategorias()
        {
            CategoriasGrid = new JQGrid
            {
                Columns = new List<JQGridColumn>()
                {
                    new JQGridColumn {
                        DataField = "Id",
                        PrimaryKey = true,
                        Editable = false,
                        Width = 50
                    },

                    new JQGridColumn {
                        DataField = "Descripcion",
                        Editable = true,
                        Width = 200
                    },

                    new JQGridColumn {
                        DataField = "Estado",
                        Editable = true,
                        Width = 100
                    }
                },
                Width = Unit.Pixel(600)
            };

            CategoriasGrid.ToolBarSettings.ShowRefreshButton = true;
            //CategoriasGrid.ToolBarSettings.ShowViewRowDetailsButton = true;
            CategoriasGrid.PagerSettings.PageSize = 6;
            //CategoriasGrid.PagerSettings.
        }
예제 #8
0
 public OEMModel()
 {
     OEMGrid = new JQGrid
     {
         Columns = new List<JQGridColumn>()
         {
             new JQGridColumn { DataField = "process", HeaderText="PROCESS",
                             Editable = true,
                             Width = 100 },
             new JQGridColumn { DataField = "trandate", HeaderText="DUE DATE",
                             Editable = true,
                             Width = 100 },
             new JQGridColumn { DataField = "type", HeaderText="TYPE",
                             Editable = true,
                             Width = 100 },
             new JQGridColumn { DataField = "tagno", HeaderText="TAGNO",
                             Editable = true,
                             Width = 100 },
             new JQGridColumn { DataField = "item", HeaderText="ITEM",
                             Editable = true,
                             Width = 100 },
             new JQGridColumn { DataField = "qty", HeaderText="ORDER QTY",
                             Editable = true,
                             Width = 100 },
             new JQGridColumn { DataField = "custno", HeaderText="CUST NO",
                             Editable = true,
                             Width = 100 },
             new JQGridColumn { DataField = "custname", HeaderText="CUST NAME",
                             Editable = true,
                             Width = 100 },
             //new JQGridColumn { DataField = "shipto", HeaderText="SHIP TO",
             //                Editable = true,
             //                Width = 100 },
             //new JQGridColumn { DataField = "cycle", HeaderText="CYCLE NO",
             //                Editable = true,
             //                Width = 100 },
             //new JQGridColumn { DataField = "zone", HeaderText="ZONE",
             //                Editable = true,
             //                Width = 100 },
             new JQGridColumn { DataField = "status", HeaderText="STATUS",
                             Editable = true,
                             Width = 100 },
             //new JQGridColumn { DataField = "shipvia", HeaderText="SHIP VIA",
             //                Editable = true,
             //                Width = 100 },
             new JQGridColumn { DataField = "finish", HeaderText="FINISHED TIME",
                             Editable =  true,
                             Width = 100 }
             //new JQGridColumn { DataField = "takeout_time",
             //                Editable =  true,
             //                Width = 100},
             //new JQGridColumn { DataField = "takeout_user",
             //                Editable =  true,
             //                Width = 100},
             //new JQGridColumn { DataField = "job_order_no", PrimaryKey = true,
             //                Width = 100 }
         }
     };
 }
예제 #9
0
        public DictionaryJqGridModel()
        {
            DictionaryGrid=new JQGrid()
            {
                Columns = new List<JQGridColumn>()
                                             {
                                                 new JQGridColumn
                                                     {
                                                         DataField = "Id",
                                                         PrimaryKey = true,
                                                         Editable = false,
                                                         Searchable = false,
                                                         HeaderText = "Идентификатор",
                                                         TextAlign = TextAlign.Left,
                                                         Visible = false,
                                                     },
                                                     new JQGridColumn
                                                     {
                                                         DataField = "Name",
                                                         Editable = true,
                                                         DataType = typeof (string),
                                                         TextAlign = TextAlign.Left,
                                                         HeaderText = "Название справочника",
                                                         Width = 40
                                                     },

                                                 new JQGridColumn
                                                     {
                                                         Searchable = false,
                                                         TextAlign = TextAlign.Center,
                                                         HeaderText = "",
                                                         Width = 10,
                                                         Formatter = new CustomFormatter
                                                                         {
                                                                             FormatFunction = "FormatDetails"
                                                                         }
                                                     }
                                             },
                AutoWidth = true,
                Height = Unit.Percentage(100),
                //PagerSettings = new PagerSettings() { PageSizeOptions = "[5,10,15,25,30]" },
                SearchDialogSettings = { MultipleSearch = true, Width = 800 },
                SortSettings = new SortSettings()
                {
                    InitialSortColumn = "Id",
                    InitialSortDirection = Trirand.Web.Mvc.SortDirection.Asc
                },
                ToolBarSettings =
                {
                    ShowSearchButton = true,
                    ShowRefreshButton = true,
                    ShowEditButton = false,
                    ShowAddButton = false,
                    ShowDeleteButton = false
                },

            };
        }
예제 #10
0
 private void setproperties(JQGrid gr)
 {
     gr.Height = Unit.Pixel(200);
     gr.DataUrl = Url.Action("cargardatos");
     gr.EditUrl = Url.Action("editardatos");
     gr.ToolBarSettings.ShowAddButton = true;
     gr.ToolBarSettings.ShowEditButton = true;
     gr.ToolBarSettings.ShowEditButton = true;
 }
예제 #11
0
 public static DataTable ToDataTable(this IEnumerable en, JQAutoComplete autoComplete)
 {
     JQGrid grid = new JQGrid();
     JQGridColumn item = new JQGridColumn {
         DataField = autoComplete.DataField
     };
     grid.Columns.Add(item);
     return en.ToDataTable(grid);
 }
예제 #12
0
 private string GetColNames(JQGrid grid)
 {
     string[] strArray = new string[grid.Columns.Count];
     for (int i = 0; i < grid.Columns.Count; i++)
     {
         JQGridColumn column = grid.Columns[i];
         strArray[i] = string.IsNullOrEmpty(column.HeaderText) ? column.DataField : column.HeaderText;
     }
     return new JavaScriptSerializer().Serialize(strArray);
 }
예제 #13
0
 public void SetUpGrid(Trirand.Web.Mvc.JQGrid ordersGrid)
 {
     // Customize/change some of the default settings for this model
     // ID is a mandatory field. Must by unique if you have several grids on one page.
     ordersGrid.ID = "BillingGrid";
     // Setting the DataUrl to an action (method) in the controller is required.
     // This action will return the data needed by the grid
     ordersGrid.DataUrl = Url.Action("DataRequested");
     ordersGrid.EditUrl = Url.Action("EditRows");
 }
예제 #14
0
 private string GetColModel(JQGrid grid)
 {
     Hashtable[] hashtableArray = new Hashtable[grid.Columns.Count];
     for (int i = 0; i < grid.Columns.Count; i++)
     {
         JsonColModel model = new JsonColModel(grid.Columns[i], grid);
         hashtableArray[i] = model.JsonValues;
     }
     return JsonColModel.RemoveQuotesForJavaScriptMethods(new JavaScriptSerializer().Serialize(hashtableArray), grid);
 }
예제 #15
0
파일: Util.cs 프로젝트: gerasyana/Academy
 public static int GetPrimaryKeyIndex(JQGrid grid)
 {
     foreach (JQGridColumn column in grid.Columns)
     {
         if (column.PrimaryKey)
         {
             return grid.Columns.IndexOf(column);
         }
     }
     return 0;
 }
예제 #16
0
 private string GetChildSubGridJavaScript(JQGrid grid)
 {
     StringBuilder builder = new StringBuilder();
     builder.Append("<script type='text/javascript'>\n");
     builder.AppendFormat("function showSubGrid_{0}(subgrid_id, row_id, message, suffix) {{", grid.ID);
     builder.Append("var subgrid_table_id, pager_id;\r\n\t\t                subgrid_table_id = subgrid_id+'_t';\r\n\t\t                pager_id = 'p_'+ subgrid_table_id;\r\n                        if (suffix) { subgrid_table_id += suffix; pager_id += suffix;  }\r\n                        if (message) jQuery('#'+subgrid_id).append(message);                        \r\n\t\t                jQuery('#'+subgrid_id).append('<table id=' + subgrid_table_id + ' class=scroll></table><div id=' + pager_id + ' class=scroll></div>');\r\n                ");
     builder.Append(this.GetStartupOptions(grid, true));
     builder.Append("}");
     builder.Append("</script>");
     return builder.ToString();
 }
예제 #17
0
파일: Util.cs 프로젝트: gerasyana/Academy
 public static Hashtable GetFooterInfo(JQGrid grid)
 {
     Hashtable hashtable = new Hashtable();
     if (grid.AppearanceSettings.ShowFooter)
     {
         foreach (JQGridColumn column in grid.Columns)
         {
             hashtable[column.DataField] = column.FooterValue;
         }
     }
     return hashtable;
 }
예제 #18
0
 public static string RemoveQuotesForJavaScriptMethods(string input, JQGrid grid)
 {
     string str = input;
     foreach (JQGridColumn column in grid.Columns)
     {
         if (column.Formatter != null)
         {
             JQGridColumnFormatter formatter = column.Formatter;
             if (formatter is CustomFormatter)
             {
                 CustomFormatter formatter2 = (CustomFormatter) formatter;
                 string oldValue = string.Format("\"formatter\":\"{0}\"", formatter2.FormatFunction);
                 string newValue = string.Format("\"formatter\":{0}", formatter2.FormatFunction);
                 str = str.Replace(oldValue, newValue);
                 oldValue = string.Format("\"unformat\":\"{0}\"", formatter2.UnFormatFunction);
                 newValue = string.Format("\"unformat\":{0}", formatter2.UnFormatFunction);
                 str = str.Replace(oldValue, newValue);
             }
         }
         foreach (JQGridEditClientSideValidator validator in column.EditClientSideValidators)
         {
             if (validator is CustomValidator)
             {
                 CustomValidator validator2 = (CustomValidator) validator;
                 string str4 = string.Format("\"custom_func\":\"{0}\"", validator2.ValidationFunction);
                 string str5 = string.Format("\"custom_func\":{0}", validator2.ValidationFunction);
                 str = str.Replace(str4, str5);
             }
         }
         if (column.EditType == EditType.Custom)
         {
             string str6 = string.Format("\"custom_element\":\"{0}\"", column.EditTypeCustomCreateElement);
             string str7 = string.Format("\"custom_element\":{0}", column.EditTypeCustomCreateElement);
             str = str.Replace(str6, str7);
             str6 = string.Format("\"custom_value\":\"{0}\"", column.EditTypeCustomGetValue);
             str7 = string.Format("\"custom_value\":{0}", column.EditTypeCustomGetValue);
             str = str.Replace(str6, str7);
         }
         if ((column.Editable && (column.EditType == EditType.DatePicker)) || (column.EditType == EditType.AutoComplete))
         {
             string str8 = GridUtil.GetAttachEditorsFunction(grid, column.EditType.ToString().ToLower(), column.EditorControlID);
             str = str.Replace(string.Concat(new object[] { '"', "attachEditControlsScript", column.DataField, '"' }), str8);
             str = str.Replace('"' + "dataInit" + '"', "dataInit");
         }
         if ((column.Searchable && (column.SearchType == SearchType.DatePicker)) || (column.SearchType == SearchType.AutoComplete))
         {
             string str9 = GridUtil.GetAttachEditorsFunction(grid, column.SearchType.ToString().ToLower(), column.SearchControlID);
             str = str.Replace(string.Concat(new object[] { '"', "attachSearchControlsScript", column.DataField, '"' }), str9);
             str = str.Replace('"' + "dataInit" + '"', "dataInit");
         }
     }
     return str;
 }
 public static DataTable ToDataTable(this IEnumerable en, JQGrid grid)
 {
     DataTable table = new DataTable();
     DataView view = en as DataView;
     if (view != null)
     {
         return view.ToTable();
     }
     if (en != null)
     {
         table = ObtainDataTableFromIEnumerable(en, grid);
     }
     return table;
 }
 public BooksJqGridModel()
 {
     BooksGrid = new JQGrid
     {
       Columns = new List<JQGridColumn>
     {
       new JQGridColumn {DataField = "Id", PrimaryKey = true, Visible = false, Searchable = false},
       new JQGridColumn {DataField = "Title", Editable = true},
       new JQGridColumn {DataField = "Author", Editable = true},
       new JQGridColumn {DataField = "Description", Editable = true},
     },
       ToolBarSettings = {ShowRefreshButton = true, ShowAddButton = true}
     };
 }
예제 #21
0
파일: Util.cs 프로젝트: gerasyana/Academy
 public static string GetWhereClause(JQGrid grid, string searchField, string searchString, string searchOper)
 {
     string str = " && ";
     string str2 = "";
     new Hashtable();
     SearchArguments args = new SearchArguments {
         SearchColumn = searchField,
         SearchString = searchString,
         SearchOperation = GetSearchOperationFromString(searchOper)
     };
     string str3 = (str2.Length > 0) ? str : "";
     string str4 = ConstructLinqFilterExpression(grid, args);
     return (str2 + str3 + str4);
 }
예제 #22
0
 internal static List<string> GetListOfColumns(JQGrid grid)
 {
     List<string> result = new List<string>();
     grid.Columns.FindAll(delegate (JQGridColumn c) {
         if (c.EditType != EditType.DatePicker)
         {
             return c.EditType == EditType.AutoComplete;
         }
         return true;
     }).ForEach(delegate (JQGridColumn c) {
         Guard.IsNotNullOrEmpty(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;
 }
예제 #23
0
 internal static List<string> GetListOfSearchEditors(JQGrid grid)
 {
     List<string> result = new List<string>();
     grid.Columns.FindAll(delegate (JQGridColumn c) {
         if (c.SearchType != SearchType.DatePicker)
         {
             return c.SearchType == SearchType.AutoComplete;
         }
         return true;
     }).ForEach(delegate (JQGridColumn c) {
         Guard.IsNotNullOrEmpty(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;
 }
예제 #24
0
 public OrdersJqGridModelNG()
 {
     OrdersGrid = new JQGrid
     {
         Columns = new List<JQGridColumn>()
             {
                 new JQGridColumn { DataField = "result_date", 
                                 Editable = true,
                                 //DataFormatString = "{0:dd/MM/yyyy}",
                                 Width = 100 },          
             new JQGridColumn { DataField = "result_time", 
                                 Editable = true,
                                 DataFormatString = "'{0}",
                                 Width = 100 },   
                 new JQGridColumn { DataField = "wc", 
                                 Editable = true,
                                 Width = 100 },
                 new JQGridColumn { DataField = "finished_goods_code",                                                         
                                 Editable = true,
                                 Width = 100 },
             new JQGridColumn { DataField = "parent_job_order_no", 
                                 // always set PrimaryKey for Add,Edit,Delete operations
                                 // if not set, the first column will be assumed as primary key
                                 PrimaryKey = true,                
                                 Editable = true,
                                 Width = 100 },
             new JQGridColumn { DataField = "part_code",                                                         
                                 Editable = true,
                                 Width = 100 },
                 new JQGridColumn { DataField = "part_job_order_no", 
                                 Editable = true,
                                 Width = 100 },
                 new JQGridColumn { DataField = "qty",
                                 DataFormatString = "{0:N0}",
                                 Editable =  true,
                                 Width = 100 },
                 new JQGridColumn { DataField = "weight", 
                                 Editable = true,
                                 Width = 100 },
                 new JQGridColumn { DataField = "totalweight", 
                                 Editable = true,
                                 Width = 100 },
                 new JQGridColumn { DataField = "entry_user", 
                                 Editable = true,
                                 Width = 100 }
             }
     };
 }
예제 #25
0
파일: Util.cs 프로젝트: gerasyana/Academy
 public static string GetWhereClause(JQGrid grid, string filters)
 {
     JsonMultipleSearch search = new JavaScriptSerializer().Deserialize<JsonMultipleSearch>(filters);
     string str = "";
     foreach (MultipleSearchRule rule in search.rules)
     {
         SearchArguments args = new SearchArguments {
             SearchColumn = rule.field,
             SearchString = rule.data,
             SearchOperation = GetSearchOperationFromString(rule.op)
         };
         string str2 = (str.Length > 0) ? (" " + search.groupOp + " ") : "";
         str = str + str2 + ConstructLinqFilterExpression(grid, args);
     }
     return str;
 }
예제 #26
0
        public LogJqGridModel()
        {
            LogGrid = new JQGrid
            {
                Columns = new List<JQGridColumn>()
                {
                    new JQGridColumn {
                        DataField = "Id",
                        PrimaryKey = true,
                        DataType = typeof(int),
                        Editable = false,
                        Visible = false,
                    },

                    new JQGridColumn {
                        DataField = "Date",
                        HeaderText = "Дата",
                        DataType = typeof(DateTime),
                        Width = 140,
                        Searchable = true,
                        SearchToolBarOperation = SearchOperation.IsLessThan,
                        SearchType = SearchType.DatePicker,
                        SearchControlID = "LogCreatedPicker",
                        // dataEvents: [type: 'change', fn: function(e) { $("#elem")[0].triggerToolbar() }]
                        //DataFormatString = "{0:dd.MM.yyyy}"
                    },

                    new JQGridColumn {
                        DataField = "Message",
                        HeaderText = "Сообщение",
                        DataType = typeof(string),
                        Editable = true,
                        Width = 500,
                        Searchable = true,
                    },
                }
            };
            //LogGrid.ClientSideEvents.AfterAjaxRequest = "OrderByDateCreated";
            LogGrid.SortSettings = new SortSettings() { InitialSortColumn = "Date",
                InitialSortDirection = Trirand.Web.Mvc.SortDirection.Desc };
            LogGrid.ToolBarSettings.ShowRefreshButton = true;
            LogGrid.ToolBarSettings.ToolBarPosition = ToolBarPosition.Top;
            //LogGrid.Width = 650;
            LogGrid.AutoWidth = false;
            LogGrid.Height = Unit.Pixel(200);
            LogGrid.ToolBarSettings.ShowSearchToolBar = true;
        }
 public TimeChartExportModel()
 {
     TimeChartGrid = new JQGrid
     {
         Columns = new List<JQGridColumn>()
         {
             new JQGridColumn { DataField = "cust_no", HeaderText="CUST NO",
                             Editable = true,
                             Width = 100 },
             new JQGridColumn { DataField = "process_no", HeaderText="PROCESS NO",
                             Editable = true,
                             Width = 100 },
             new JQGridColumn { DataField = "start_time", HeaderText="START TIME",
                             Editable = true,
                             Width = 100 },
             new JQGridColumn { DataField = "finished_time", HeaderText="FINISHED TIME",
                             Editable = true,
                             Width = 100 },
             new JQGridColumn { DataField = "cycle_no", HeaderText="CYCLE NO",
                             Editable = true,
                             Width = 100 },
             new JQGridColumn { DataField = "prepare_n_date", HeaderText="PREPARE DATE",
                             Editable = true,
                             Width = 100 },
             new JQGridColumn { DataField = "shipto", HeaderText="SHIP TO",
                             Editable = true,
                             Width = 100 },
             new JQGridColumn { DataField = "username_id", HeaderText="UPDATE BY",
                             Editable =  true,
                             Width = 100 },
             new JQGridColumn { DataField = "update_date", HeaderText="UPDATE DATE",
                             Editable =  true,
                             Width = 100},
             new JQGridColumn { DataField = "update_time", HeaderText="UPDATE TIME",
                             Editable =  true,
                             Width = 100},
             new JQGridColumn { DataField = "cust_type", HeaderText="CUST TYPE",
                             Editable = true,
                             Width = 100 }
             //new JQGridColumn { DataField = "job_order_no", PrimaryKey = true,
             //                Width = 100 }
         }
     };
 }
예제 #28
0
파일: Util.cs 프로젝트: gerasyana/Academy
 public static string GetWhereClause(JQGrid grid, NameValueCollection queryString)
 {
     string str = " && ";
     string str2 = "";
     new Hashtable();
     foreach (JQGridColumn column in grid.Columns)
     {
         string str3 = queryString[column.DataField];
         if (!string.IsNullOrEmpty(str3))
         {
             SearchArguments args = new SearchArguments {
                 SearchColumn = column.DataField,
                 SearchString = str3,
                 SearchOperation = column.SearchToolBarOperation
             };
             string str4 = (str2.Length > 0) ? str : "";
             string str5 = ConstructLinqFilterExpression(grid, args);
             str2 = str2 + str4 + str5;
         }
     }
     return str2;
 }
예제 #29
0
 public string RenderHtml(JQGrid grid)
 {
     string format = "<table id='{0}'></table>";
     if (grid.ToolBarSettings.ToolBarPosition != ToolBarPosition.Hidden)
     {
         format = format + "<div id='{0}_pager'></div>";
     }
     if (DateTime.Now > CompiledOn.CompilationDate.AddDays(45.0))
     {
         return "This is a trial version of jqGrid for ASP.NET MVC which has expired.<br> Please, contact [email protected] for purchasing the product or for trial extension.";
     }
     if (string.IsNullOrEmpty(grid.ID))
     {
         throw new Exception("You need to set ID for this grid.");
     }
     format = string.Format(format, grid.ID);
     if ((grid.HierarchySettings.HierarchyMode == HierarchyMode.Child) || (grid.HierarchySettings.HierarchyMode == HierarchyMode.ParentAndChild))
     {
         return (format + this.GetChildSubGridJavaScript(grid));
     }
     return (format + this.GetStartupJavascript(grid, false));
 }
예제 #30
0
        public GridDemo()
        {
            grid = new JQGrid()
            {
                Columns = new List<JQGridColumn>()
                {
                    new JQGridColumn()
                    {
                        DataField="idPerfil",
                        PrimaryKey=true,
                        Editable=false,
                        Width=(100)
                    },
                    new JQGridColumn()
                    {
                        DataField="infraccion",
                        Editable=true,
                        Width=150
                    },
                    new JQGridColumn()
                    {
                        DataField="karma",
                        Editable=true,
                        Width=150
                    },
                    new JQGridColumn()
                    {
                        DataField="beneado",
                        Editable=true,
                        Width=150
                    }

                },
                Width=Unit.Pixel(600)
            };
            grid.ToolBarSettings.ShowRefreshButton = true;
        }
예제 #31
0
        private string GetStartupOptions(JQGrid grid, bool subGrid)
        {
            StringBuilder builder         = new StringBuilder();
            string        str             = subGrid ? "jQuery('#' + subgrid_table_id)" : string.Format("jQuery('#{0}')", grid.ID);
            string        str2            = subGrid ? "jQuery('#' + pager_id)" : string.Format("jQuery('#{0}')", grid.ID + "_pager");
            string        pagerSelectorID = subGrid ? "'#' + pager_id" : string.Format("'#{0}'", grid.ID + "_pager");
            string        str4            = subGrid ? "&parentRowID=' + row_id + '" : string.Empty;
            string        str5            = (grid.DataUrl.IndexOf("?") > 0) ? "&" : "?";
            string        str6            = (grid.EditUrl.IndexOf("?") > 0) ? "&" : "?";
            string        str7            = string.Format("{0}{1}jqGridID={2}{3}", new object[] { grid.DataUrl, str5, grid.ID, str4 });
            string        str8            = string.Format("{0}{1}jqGridID={2}&editMode=1{3}", new object[] { grid.EditUrl, str6, grid.ID, str4 });


            builder.AppendFormat("{0}.jqGrid({{", str);
            //tree
            if (grid.TreeGrid)
            {
                string str9 = grid.TreeGrid ? "true" : "false";
                builder.AppendFormat("treeGrid:{0},treedatatype:'json',", str9);
                if (grid.TreeGridModel == TreeGridModel.adjacency)
                {
                    builder.Append("treeGridModel: 'adjacency',");
                }
                builder.AppendFormat("ExpandColumn: '{0}',", grid.ExpandColumn);
                builder.Append("ExpandColClick: 'true',");
                //,level_field:'level',leaf_field:'isLeaf',expanded_field:'expanded'
                //builder.Append("treeReader:{parent_id_field:'" + grid.ParentIdField + "'},");
                builder.Append("treeReader:{level_field:'level',parent_id_field:'parent_id','leaf_field':'isLeaf',expanded_field:'expanded'},");
            }
            //end tree
            builder.AppendFormat("url: '{0}'", str7);
            builder.AppendFormat(",editurl: '{0}'", str8);
            if (grid.TreeGrid)
            {
                builder.AppendFormat(",mtype: 'POST'", new object[0]);
            }
            else
            {
                builder.AppendFormat(",mtype: 'GET'", new object[0]);
            }
            builder.AppendFormat(",datatype: 'json'", new object[0]);
            builder.AppendFormat(",page: {0}", grid.PagerSettings.CurrentPage);
            builder.AppendFormat(",colNames: {0}", this.GetColNames(grid));
            builder.AppendFormat(",colModel: {0}", this.GetColModel(grid));
            builder.AppendFormat(",viewrecords: true", new object[0]);
            builder.AppendFormat(",scrollrows: true", new object[0]);
            builder.AppendFormat(",prmNames: {{ id: \"{0}\" }}", Util.GetPrimaryKeyField(grid));
            if (grid.AppearanceSettings.ShowFooter)
            {
                builder.Append(",footerrow: true");
                builder.Append(",userDataOnFooter: true");
            }
            if (!grid.AppearanceSettings.ShrinkToFit)
            {
                builder.Append(",shrinkToFit: false");
            }
            if (grid.ColumnReordering)
            {
                builder.Append(",sortable: true");
            }
            if (grid.AppearanceSettings.ScrollBarOffset != 0x12)
            {
                builder.AppendFormat(",scrollOffset: {0}", grid.AppearanceSettings.ScrollBarOffset);
            }
            if (grid.AppearanceSettings.RightToLeft)
            {
                builder.Append(",direction: 'rtl'");
            }
            if (grid.AutoWidth)
            {
                builder.Append(",autowidth: true");
            }
            if (!grid.ShrinkToFit)
            {
                builder.Append(",shrinkToFit: false");
            }
            if ((grid.ToolBarSettings.ToolBarPosition == ToolBarPosition.Bottom) || (grid.ToolBarSettings.ToolBarPosition == ToolBarPosition.TopAndBottom))
            {
                builder.AppendFormat(",pager: {0}", str2);
            }
            if ((grid.ToolBarSettings.ToolBarPosition == ToolBarPosition.Top) || (grid.ToolBarSettings.ToolBarPosition == ToolBarPosition.TopAndBottom))
            {
                builder.Append(",toppager: true");
            }
            if (grid.RenderingMode == RenderingMode.Optimized)
            {
                if (grid.HierarchySettings.HierarchyMode != HierarchyMode.None)
                {
                    throw new Exception("Optimized rendering is not compatible with hierarchy.");
                }
                builder.Append(",gridview: true");
            }
            if ((grid.HierarchySettings.HierarchyMode == HierarchyMode.Parent) || (grid.HierarchySettings.HierarchyMode == HierarchyMode.ParentAndChild))
            {
                builder.Append(",subGrid: true");
            }
            if (!string.IsNullOrEmpty(grid.ClientSideEvents.SubGridRowExpanded))
            {
                builder.AppendFormat(",subGridRowExpanded: {0}", grid.ClientSideEvents.SubGridRowExpanded);
            }
            if (!string.IsNullOrEmpty(grid.ClientSideEvents.ServerError))
            {
                builder.AppendFormat(",errorCell: {0}", grid.ClientSideEvents.ServerError);
            }
            if (!string.IsNullOrEmpty(grid.ClientSideEvents.RowSelect))
            {
                builder.AppendFormat(",onSelectRow: {0}", grid.ClientSideEvents.RowSelect);
            }
            if (!string.IsNullOrEmpty(grid.ClientSideEvents.ColumnSort))
            {
                builder.AppendFormat(",onSortCol: {0}", grid.ClientSideEvents.ColumnSort);
            }
            if (!string.IsNullOrEmpty(grid.ClientSideEvents.RowDoubleClick))
            {
                builder.AppendFormat(",ondblClickRow: {0}", grid.ClientSideEvents.RowDoubleClick);
            }
            if (!string.IsNullOrEmpty(grid.ClientSideEvents.RowRightClick))
            {
                builder.AppendFormat(",onRightClickRow: {0}", grid.ClientSideEvents.RowRightClick);
            }
            if (!string.IsNullOrEmpty(grid.ClientSideEvents.LoadDataError))
            {
                builder.AppendFormat(",loadError: {0}", grid.ClientSideEvents.LoadDataError);
            }
            else
            {
                builder.AppendFormat(",loadError: {0}", "jqGrid_aspnet_loadErrorHandler");
            }
            if (!string.IsNullOrEmpty(grid.ClientSideEvents.GridInitialized))
            {
                builder.AppendFormat(",gridComplete: {0}", grid.ClientSideEvents.GridInitialized);
            }
            if (!string.IsNullOrEmpty(grid.ClientSideEvents.BeforeAjaxRequest))
            {
                builder.AppendFormat(",gridComplete: {0}", grid.ClientSideEvents.BeforeAjaxRequest);
            }
            if (!grid.AppearanceSettings.HighlightRowsOnHover)
            {
                builder.Append(",hoverrows: false");
            }
            if (grid.AppearanceSettings.AlternateRowBackground)
            {
                builder.Append(",altRows: true");
            }
            if (grid.AppearanceSettings.ShowRowNumbers)
            {
                builder.Append(",rownumbers: true");
            }
            if (grid.AppearanceSettings.RowNumbersColumnWidth != 0x19)
            {
                builder.AppendFormat(",rownumWidth: {0}", grid.AppearanceSettings.RowNumbersColumnWidth.ToString());
            }
            if (grid.PagerSettings.ScrollBarPaging)
            {
                builder.AppendFormat(",scroll: 1", new object[0]);
            }
            if (!grid.TreeGrid)
            {
                builder.AppendFormat(",rowNum: {0}", grid.PagerSettings.PageSize.ToString());
                builder.AppendFormat(",rowList: {0}", grid.PagerSettings.PageSizeOptions.ToString());
            }
            if (!string.IsNullOrEmpty(grid.PagerSettings.NoRowsMessage))
            {
                builder.AppendFormat(",emptyrecords: '{0}'", grid.PagerSettings.NoRowsMessage.ToString());
            }
            builder.AppendFormat(",editDialogOptions: {0}", this.GetEditOptions(grid));
            builder.AppendFormat(",addDialogOptions: {0}", this.GetAddOptions(grid));
            builder.AppendFormat(",delDialogOptions: {0}", this.GetDelOptions(grid));
            builder.AppendFormat(",searchDialogOptions: {0}", this.GetSearchOptions(grid));
            builder.AppendFormat(",jsonreader: {{ id: \"{0}\" }}", grid.Columns[Util.GetPrimaryKeyIndex(grid)].DataField);
            if (!string.IsNullOrEmpty(grid.SortSettings.InitialSortColumn))
            {
                builder.AppendFormat(",sortname: '{0}'", grid.SortSettings.InitialSortColumn);
            }
            builder.AppendFormat(",sortorder: '{0}'", grid.SortSettings.InitialSortDirection.ToString().ToLower());
            if (grid.MultiSelect)
            {
                builder.Append(",multiselect: true");
                if (grid.MultiSelectMode == MultiSelectMode.SelectOnCheckBoxClickOnly)
                {
                    builder.AppendFormat(",multiboxonly: true", grid.MultiSelect.ToString().ToLower());
                }
                if (grid.MultiSelectKey != MultiSelectKey.None)
                {
                    builder.AppendFormat(",multikey: '{0}'", this.GetMultiKeyString(grid.MultiSelectKey));
                }
            }
            if (!string.IsNullOrEmpty(grid.AppearanceSettings.Caption))
            {
                builder.AppendFormat(",caption: '{0}'", grid.AppearanceSettings.Caption);
            }
            if (!grid.Width.IsEmpty)
            {
                builder.AppendFormat(",width: '{0}'", grid.Width.ToString().Replace("px", ""));
            }
            if (!grid.Height.IsEmpty)
            {
                builder.AppendFormat(",height: '{0}'", grid.Height.ToString().Replace("px", ""));
            }
            if (grid.GroupSettings.GroupFields.Count > 0)
            {
                builder.Append(",grouping:true");
                builder.Append(",groupingView: {");
                builder.AppendFormat("groupField: ['{0}']", grid.GroupSettings.GroupFields[0].DataField);
                builder.AppendFormat(",groupColumnShow: [{0}]", grid.GroupSettings.GroupFields[0].ShowGroupColumn.ToString().ToLower());
                builder.AppendFormat(",groupText: ['{0}']", grid.GroupSettings.GroupFields[0].HeaderText);
                builder.AppendFormat(",groupOrder: ['{0}']", grid.GroupSettings.GroupFields[0].GroupSortDirection.ToString().ToLower());
                builder.AppendFormat(",groupSummary: [{0}]", grid.GroupSettings.GroupFields[0].ShowGroupSummary.ToString().ToLower());
                builder.AppendFormat(",groupCollapse: {0}", grid.GroupSettings.CollapseGroups.ToString().ToLower());
                builder.AppendFormat(",groupDataSorted: true", new object[0]);
                builder.Append("}");
            }
            builder.AppendFormat(",viewsortcols: [{0},'{1}',{2}]", "false", grid.SortSettings.SortIconsPosition.ToString().ToLower(), (grid.SortSettings.SortAction == SortAction.ClickOnHeader) ? "true" : "false");
            builder.AppendFormat("}})\r", new object[0]);
            builder.Append(this.GetToolBarOptions(grid, subGrid, pagerSelectorID));
            builder.Append(this.GetLoadErrorHandler());
            if (grid.ToolBarSettings.ShowSearchToolBar)
            {
                builder.AppendFormat("{0}.filterToolbar();", str);
            }
            //builder.AppendFormat("{0}.jqGrid('bindKeys');", str);
            return(builder.ToString());
        }
예제 #32
0
 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))
             {
                 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", dt.Rows[i]["tree_leaf"] as bool?);
         }
         catch
         {
         }
         try
         {
             response.rows[i].Add("tree_expanded", dt.Rows[i]["tree_expanded"] as bool?);
         }
         catch
         {
         }
         try
         {
             response.rows[i].Add("tree_loaded", dt.Rows[i]["tree_loaded"] as bool?);
         }
         catch
         {
         }
         try
         {
             response.rows[i].Add("tree_icon", dt.Rows[i]["tree_icon"] as string);
         }
         catch
         {
         }
     }
     return(response);
 }
 private static DataTable ObtainDataTableFromIEnumerable(IEnumerable ien, JQGrid grid)
 {
     DataTable table = new DataTable();
     foreach (object obj2 in ien)
     {
         if (obj2 is DbDataRecord)
         {
             DbDataRecord record = obj2 as DbDataRecord;
             if (table.Columns.Count == 0)
             {
                 foreach (JQGridColumn column in grid.Columns)
                 {
                     table.Columns.Add(column.DataField);
                 }
             }
             DataRow row = table.NewRow();
             foreach (JQGridColumn column2 in grid.Columns)
             {
                 row[column2.DataField] = record[column2.DataField];
             }
             table.Rows.Add(row);
             continue;
         }
         if (obj2 is DataRow)
         {
             DataRow row2 = obj2 as DataRow;
             if (table.Columns.Count == 0)
             {
                 foreach (JQGridColumn column3 in grid.Columns)
                 {
                     table.Columns.Add(column3.DataField);
                 }
             }
             DataRow row3 = table.NewRow();
             foreach (JQGridColumn column4 in grid.Columns)
             {
                 row3[column4.DataField] = row2[column4.DataField];
             }
             table.Rows.Add(row3);
             continue;
         }
         PropertyInfo[] properties = obj2.GetType().GetProperties();
         if (table.Columns.Count == 0)
         {
             foreach (PropertyInfo info in properties)
             {
                 Type propertyType = info.PropertyType;
                 if (propertyType.IsGenericType && (propertyType.GetGenericTypeDefinition() == typeof(Nullable<>)))
                 {
                     propertyType = Nullable.GetUnderlyingType(propertyType);
                 }
                 table.Columns.Add(info.Name, propertyType);
             }
         }
         DataRow row4 = table.NewRow();
         foreach (PropertyInfo info2 in properties)
         {
             object obj3 = info2.GetValue(obj2, null);
             if (obj3 != null)
             {
                 row4[info2.Name] = obj3;
             }
             else
             {
                 row4[info2.Name] = DBNull.Value;
             }
         }
         table.Rows.Add(row4);
     }
     return table;
 }
예제 #34
0
 public JsonAddDialog(JQGrid grid)
 {
     this._jsonValues = new Hashtable();
     this._grid       = grid;
 }
예제 #35
0
        public static string GetPrimaryKeyField(JQGrid grid)
        {
            int primaryKeyIndex = Util.GetPrimaryKeyIndex(grid);

            return(grid.Columns[primaryKeyIndex].DataField);
        }
예제 #36
0
 public JsonEditDialog(JQGrid grid)
 {
     this._json       = new JavaScriptSerializer();
     this._jsonValues = new Hashtable();
     this._grid       = grid;
 }
예제 #37
0
 public JsonSearchToolBar(JQGrid grid)
 {
     this._jsonValues = new Hashtable();
     this._grid       = grid;
 }
예제 #38
0
        private string GetDelOptions(JQGrid grid)
        {
            JsonDelDialog jsonDelDialog = new JsonDelDialog(grid);

            return(jsonDelDialog.Process());
        }
예제 #39
0
        private string GetSearchOptions(JQGrid grid)
        {
            JsonSearchDialog jsonSearchDialog = new JsonSearchDialog(grid);

            return(jsonSearchDialog.Process());
        }
예제 #40
0
        private string GetStartupOptions(JQGrid grid, bool subGrid)
        {
            StringBuilder stringBuilder   = new StringBuilder();
            string        arg             = subGrid ? "jQuery('#' + subgrid_table_id)" : string.Format("jQuery('#{0}')", grid.ID);
            string        arg2            = subGrid ? "jQuery('#' + pager_id)" : string.Format("jQuery('#{0}')", grid.ID + "_pager");
            string        pagerSelectorID = subGrid ? "'#' + pager_id" : string.Format("'#{0}'", grid.ID + "_pager");
            string        text            = subGrid ? "&parentRowID=' + row_id + '" : string.Empty;
            string        text2           = (grid.DataUrl.IndexOf("?") > 0) ? "&" : "?";
            string        text3           = (grid.EditUrl.IndexOf("?") > 0) ? "&" : "?";
            string        arg3            = string.Format("{0}{1}jqGridID={2}{3}", new object[]
            {
                grid.DataUrl,
                text2,
                grid.ID,
                text
            });
            string arg4 = string.Format("{0}{1}jqGridID={2}&editMode=1{3}", new object[]
            {
                grid.EditUrl,
                text3,
                grid.ID,
                text
            });

            if (grid.Columns.Count > 0 && grid.Columns[0].Frozen)
            {
                grid.AppearanceSettings.ShrinkToFit = false;
            }
            stringBuilder.AppendFormat("{0}.jqGrid({{", arg);
            stringBuilder.AppendFormat("url: '{0}'", arg3);
            stringBuilder.AppendFormat(",loadui: '{0}'", grid.LoadUI);
            stringBuilder.AppendFormat(",editurl: '{0}'", arg4);
            stringBuilder.AppendFormat(",mtype: 'GET'", new object[0]);
            stringBuilder.AppendFormat(",datatype: '{0}'", grid.DataType);
            stringBuilder.AppendFormat(",page: {0}", grid.PagerSettings.CurrentPage);
            stringBuilder.AppendFormat(",colNames: {0}", this.GetColNames(grid));
            stringBuilder.AppendFormat(",colModel: {0}", this.GetColModel(grid));
            stringBuilder.AppendFormat(",viewrecords: true", new object[0]);
            stringBuilder.AppendFormat(",scrollrows: false", new object[0]);
            stringBuilder.AppendFormat(",prmNames: {{ id: \"{0}\" }}", Util.GetPrimaryKeyField(grid));
            if (grid.AppearanceSettings.ShowFooter)
            {
                stringBuilder.Append(",footerrow: true");
                stringBuilder.Append(",userDataOnFooter: true");
            }
            if (!grid.AppearanceSettings.ShrinkToFit)
            {
                stringBuilder.Append(",shrinkToFit: false");
            }
            if (grid.ColumnReordering)
            {
                stringBuilder.Append(",sortable: true");
            }
            if (grid.AppearanceSettings.ScrollBarOffset != 18)
            {
                stringBuilder.AppendFormat(",scrollOffset: {0}", grid.AppearanceSettings.ScrollBarOffset);
            }
            if (grid.AppearanceSettings.RightToLeft)
            {
                stringBuilder.Append(",direction: 'rtl'");
            }
            if (grid.AutoWidth)
            {
                stringBuilder.Append(",autowidth: true");
            }
            if (!grid.ShrinkToFit)
            {
                stringBuilder.Append(",shrinkToFit: false");
            }
            if (grid.ToolBarSettings.ToolBarPosition == ToolBarPosition.Bottom || grid.ToolBarSettings.ToolBarPosition == ToolBarPosition.TopAndBottom)
            {
                stringBuilder.AppendFormat(",pager: {0}", arg2);
            }
            if (grid.ToolBarSettings.ToolBarPosition == ToolBarPosition.Top || grid.ToolBarSettings.ToolBarPosition == ToolBarPosition.TopAndBottom)
            {
                stringBuilder.Append(",toppager: true");
            }
            if (grid.RenderingMode == RenderingMode.Optimized)
            {
                if (grid.HierarchySettings.HierarchyMode != HierarchyMode.None)
                {
                    throw new Exception("Optimized rendering is not compatible with hierarchy.");
                }
                stringBuilder.Append(",gridview: true");
            }
            if (grid.HierarchySettings.HierarchyMode == HierarchyMode.Parent || grid.HierarchySettings.HierarchyMode == HierarchyMode.ParentAndChild)
            {
                stringBuilder.Append(",subGrid: true");
                stringBuilder.AppendFormat(",subGridOptions: {0}", grid.HierarchySettings.ToJSON());
            }
            if (!string.IsNullOrEmpty(grid.ClientSideEvents.SubGridRowExpanded))
            {
                stringBuilder.AppendFormat(",subGridRowExpanded: {0}", grid.ClientSideEvents.SubGridRowExpanded);
            }
            if (!string.IsNullOrEmpty(grid.ClientSideEvents.ServerError))
            {
                stringBuilder.AppendFormat(",errorCell: {0}", grid.ClientSideEvents.ServerError);
            }
            if (!string.IsNullOrEmpty(grid.ClientSideEvents.RowSelect))
            {
                stringBuilder.AppendFormat(",onSelectRow: {0}", grid.ClientSideEvents.RowSelect);
            }
            if (!string.IsNullOrEmpty(grid.ClientSideEvents.ColumnSort))
            {
                stringBuilder.AppendFormat(",onSortCol: {0}", grid.ClientSideEvents.ColumnSort);
            }
            if (!string.IsNullOrEmpty(grid.ClientSideEvents.RowDoubleClick))
            {
                stringBuilder.AppendFormat(",ondblClickRow: {0}", grid.ClientSideEvents.RowDoubleClick);
            }
            if (!string.IsNullOrEmpty(grid.ClientSideEvents.RowRightClick))
            {
                stringBuilder.AppendFormat(",onRightClickRow: {0}", grid.ClientSideEvents.RowRightClick);
            }
            if (!string.IsNullOrEmpty(grid.ClientSideEvents.LoadDataError))
            {
                stringBuilder.AppendFormat(",loadError: {0}", grid.ClientSideEvents.LoadDataError);
            }
            else
            {
                stringBuilder.AppendFormat(",loadError: {0}", "jqGrid_aspnet_loadErrorHandler");
            }
            if (!string.IsNullOrEmpty(grid.ClientSideEvents.GridInitialized))
            {
                stringBuilder.AppendFormat(",gridComplete: {0}", grid.ClientSideEvents.GridInitialized);
            }
            if (!string.IsNullOrEmpty(grid.ClientSideEvents.BeforeAjaxRequest))
            {
                stringBuilder.AppendFormat(",beforeRequest: {0}", grid.ClientSideEvents.BeforeAjaxRequest);
            }
            if (!string.IsNullOrEmpty(grid.ClientSideEvents.AfterAjaxRequest))
            {
                stringBuilder.AppendFormat(",loadComplete: {0}", grid.ClientSideEvents.AfterAjaxRequest);
            }
            if (!string.IsNullOrEmpty(grid.ClientSideEvents.SerializeGridData))
            {
                stringBuilder.AppendFormat(",serializeGridData:{0}", grid.ClientSideEvents.SerializeGridData);
            }
            if (!string.IsNullOrEmpty(grid.ClientSideEvents.SerializeRowData))
            {
                stringBuilder.AppendFormat(",serializeRowData:{0}", grid.ClientSideEvents.SerializeRowData);
            }
            if (grid.TreeGridSettings.Enabled)
            {
                stringBuilder.AppendFormat(",treeGrid: true", new object[0]);
                stringBuilder.AppendFormat(",treedatatype: 'json'", new object[0]);
                stringBuilder.AppendFormat(",treeGridModel: 'adjacency'", new object[0]);
                string arg5 = "{ level_field: 'tree_level', parent_id_field: 'tree_parent', leaf_field: 'tree_leaf', expanded_field: 'tree_expanded', loaded: 'tree_loaded', icon_field: 'tree_icon' }";
                stringBuilder.AppendFormat(",treeReader: {0}", arg5);
                stringBuilder.AppendFormat(",ExpandColumn: '{0}'", this.GetFirstVisibleDataField(grid));
                Hashtable hashtable = new Hashtable();
                if (!string.IsNullOrEmpty(grid.TreeGridSettings.CollapsedIcon))
                {
                    hashtable.Add("plus", grid.TreeGridSettings.CollapsedIcon);
                }
                if (!string.IsNullOrEmpty(grid.TreeGridSettings.ExpandedIcon))
                {
                    hashtable.Add("minus", grid.TreeGridSettings.ExpandedIcon);
                }
                if (!string.IsNullOrEmpty(grid.TreeGridSettings.LeafIcon))
                {
                    hashtable.Add("leaf", grid.TreeGridSettings.LeafIcon);
                }
                if (hashtable.Count > 0)
                {
                    stringBuilder.AppendFormat(",treeIcons: {0}", new JavaScriptSerializer().Serialize(hashtable));
                }
            }
            if (!grid.AppearanceSettings.HighlightRowsOnHover)
            {
                stringBuilder.Append(",hoverrows: false");
            }
            if (grid.AppearanceSettings.AlternateRowBackground)
            {
                stringBuilder.Append(",altRows: true");
            }
            if (grid.AppearanceSettings.ShowRowNumbers)
            {
                stringBuilder.Append(",rownumbers: true");
            }
            if (grid.AppearanceSettings.RowNumbersColumnWidth != 25)
            {
                stringBuilder.AppendFormat(",rownumWidth: {0}", grid.AppearanceSettings.RowNumbersColumnWidth.ToString());
            }
            if (grid.PagerSettings.ScrollBarPaging)
            {
                stringBuilder.AppendFormat(",scroll: 1", new object[0]);
            }
            stringBuilder.AppendFormat(",rowNum: {0}", grid.PagerSettings.PageSize.ToString());
            stringBuilder.AppendFormat(",rowList: {0}", grid.PagerSettings.PageSizeOptions.ToString());
            //stringBuilder.Append(",recordpos:left");
            if (!string.IsNullOrEmpty(grid.PagerSettings.NoRowsMessage))
            {
                stringBuilder.AppendFormat(",emptyrecords: '{0}'", grid.PagerSettings.NoRowsMessage.ToString());
            }
            stringBuilder.AppendFormat(",editDialogOptions: {0}", this.GetEditOptions(grid));
            stringBuilder.AppendFormat(",addDialogOptions: {0}", this.GetAddOptions(grid));
            stringBuilder.AppendFormat(",delDialogOptions: {0}", this.GetDelOptions(grid));
            stringBuilder.AppendFormat(",searchDialogOptions: {0}", this.GetSearchOptions(grid));
            string format;

            if (grid.TreeGridSettings.Enabled)
            {
                format = ",jsonReader: {{ id: \"{0}\", repeatitems:false,subgrid:{{repeatitems:false}} }}";
            }
            else
            {
                format = ",jsonReader: {{ id: \"{0}\" }}";
            }
            stringBuilder.AppendFormat(format, grid.Columns[Util.GetPrimaryKeyIndex(grid)].DataField);
            if (!string.IsNullOrEmpty(grid.SortSettings.InitialSortColumn))
            {
                stringBuilder.AppendFormat(",sortname: '{0}'", grid.SortSettings.InitialSortColumn);
            }
            stringBuilder.AppendFormat(",sortorder: '{0}'", grid.SortSettings.InitialSortDirection.ToString().ToLower());
            if (grid.MultiSelect)
            {
                stringBuilder.Append(",multiselect: true");
                if (grid.MultiSelectMode == MultiSelectMode.SelectOnCheckBoxClickOnly)
                {
                    stringBuilder.AppendFormat(",multiboxonly: true", grid.MultiSelect.ToString().ToLower());
                }
                if (grid.MultiSelectKey != MultiSelectKey.None)
                {
                    stringBuilder.AppendFormat(",multikey: '{0}'", this.GetMultiKeyString(grid.MultiSelectKey));
                }
            }
            if (!string.IsNullOrEmpty(grid.AppearanceSettings.Caption))
            {
                stringBuilder.AppendFormat(",caption: '{0}'", grid.AppearanceSettings.Caption);
            }
            if (!grid.Width.IsEmpty)
            {
                stringBuilder.AppendFormat(",width: '{0}'", grid.Width.ToString().Replace("px", ""));
            }
            if (!grid.Height.IsEmpty)
            {
                stringBuilder.AppendFormat(",height: '{0}'", grid.Height.ToString().Replace("px", ""));
            }
            if (grid.GroupSettings.GroupFields.Count > 0)
            {
                stringBuilder.Append(",grouping:true");
                stringBuilder.Append(",groupingView: {");
                stringBuilder.AppendFormat("groupField: ['{0}']", grid.GroupSettings.GroupFields[0].DataField);
                stringBuilder.AppendFormat(",groupColumnShow: [{0}]", grid.GroupSettings.GroupFields[0].ShowGroupColumn.ToString().ToLower());
                stringBuilder.AppendFormat(",groupText: ['{0}']", grid.GroupSettings.GroupFields[0].HeaderText);
                stringBuilder.AppendFormat(",groupOrder: ['{0}']", grid.GroupSettings.GroupFields[0].GroupSortDirection.ToString().ToLower());
                stringBuilder.AppendFormat(",groupSummary: [{0}]", grid.GroupSettings.GroupFields[0].ShowGroupSummary.ToString().ToLower());
                stringBuilder.AppendFormat(",groupCollapse: {0}", grid.GroupSettings.CollapseGroups.ToString().ToLower());
                stringBuilder.AppendFormat(",groupDataSorted: true", new object[0]);
                stringBuilder.Append("}");
            }
            stringBuilder.AppendFormat(",viewsortcols: [{0},'{1}',{2}]", "false", grid.SortSettings.SortIconsPosition.ToString().ToLower(), (grid.SortSettings.SortAction == SortAction.ClickOnHeader) ? "true" : "false");

            stringBuilder.AppendFormat("}})\r", new object[0]);
            stringBuilder.Append(this.GetToolBarOptions(grid, subGrid, pagerSelectorID));
            if (!grid.PagerSettings.ScrollBarPaging)
            {
                stringBuilder.AppendFormat(".bindKeys()", new object[0]);
            }
            if (grid.Columns.Count > 0 && grid.Columns[0].Frozen)
            {
                stringBuilder.AppendFormat(".setFrozenColumns()", new object[0]);
            }
            stringBuilder.Append(";");
            stringBuilder.Append(this.GetLoadErrorHandler());
            stringBuilder.Append(";");
            if (grid.HeaderGroups.Count > 0)
            {
                List <Hashtable> list = new List <Hashtable>();
                foreach (JQGridHeaderGroup current in grid.HeaderGroups)
                {
                    list.Add(current.ToHashtable());
                }
                stringBuilder.AppendFormat("{0}.setGroupHeaders( {{ useColSpanStyle:true,groupHeaders:{1} }});", arg, new JavaScriptSerializer().Serialize(list));
            }
            if (grid.ToolBarSettings.ShowSearchToolBar)
            {
                stringBuilder.AppendFormat("{0}.filterToolbar({1});", arg, new JsonSearchToolBar(grid).Process());
            }
            return(stringBuilder.ToString());
        }
예제 #41
0
        private string GetEditOptions(JQGrid grid)
        {
            JsonEditDialog jsonEditDialog = new JsonEditDialog(grid);

            return(jsonEditDialog.Process());
        }
예제 #42
0
        public static string RemoveQuotesForJavaScriptMethods(string input, JQGrid grid)
        {
            string text = input;

            foreach (JQGridColumn current in grid.Columns)
            {
                if (current.Formatter != null)
                {
                    JQGridColumnFormatter formatter = current.Formatter;
                    if (formatter is CustomFormatter)
                    {
                        CustomFormatter customFormatter = (CustomFormatter)formatter;
                        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 current2 in current.EditClientSideValidators)
                {
                    if (current2 is CustomValidator)
                    {
                        CustomValidator customValidator = (CustomValidator)current2;
                        string          oldValue2       = string.Format("\"custom_func\":\"{0}\"", customValidator.ValidationFunction);
                        string          newValue2       = string.Format("\"custom_func\":{0}", customValidator.ValidationFunction);
                        text = text.Replace(oldValue2, newValue2);
                    }
                }
                if (current.EditType == EditType.Custom)
                {
                    string oldValue3 = string.Format("\"custom_element\":\"{0}\"", current.EditTypeCustomCreateElement);
                    string newValue3 = string.Format("\"custom_element\":{0}", current.EditTypeCustomCreateElement);
                    text      = text.Replace(oldValue3, newValue3);
                    oldValue3 = string.Format("\"custom_value\":\"{0}\"", current.EditTypeCustomGetValue);
                    newValue3 = string.Format("\"custom_value\":{0}", current.EditTypeCustomGetValue);
                    text      = text.Replace(oldValue3, newValue3);
                }
                if (current.Editable && (
                        current.EditType == EditType.DatePicker ||
                        current.EditType == EditType.DateTimePicker ||
                        current.EditType == EditType.TimePicker ||
                        current.EditType == EditType.AutoComplete ||
                        current.EditType == EditType.Chosen))
                {
                    string attachEditorsFunction = GridUtil.GetAttachEditorsFunction(grid, current.EditType.ToString().ToLower(), current.EditorControlID);
                    text = text.Replace(string.Concat(new object[]
                    {
                        '"',
                        "attachEditControlsScript",
                        current.DataField,
                        '"'
                    }), attachEditorsFunction);
                }
                if (current.Searchable && (current.SearchType == SearchType.DatePicker ||
                                           current.SearchType == SearchType.AutoComplete ||
                                           current.SearchType == SearchType.DateTimePicker ||
                                           current.SearchType == SearchType.TimePicker))
                {
                    string attachEditorsFunction2 = GridUtil.GetAttachEditorsFunction(grid, current.SearchType.ToString().ToLower(), current.SearchControlID);
                    text = text.Replace(string.Concat(new object[]
                    {
                        '"',
                        "attachSearchControlsScript",
                        current.DataField,
                        '"'
                    }), attachEditorsFunction2);
                }
                if (current.DataEvents.Count > 0)
                {
                    List <DataEvent> lde = current.DataEvents.FindAll(f => f.Type != DataEventType.No);
                    if (lde.Count > 0)
                    {
                        foreach (DataEvent de in lde)
                        {
                            string oldValue = string.Format("\"fn\":\"{0}\"", de.Function);
                            string newValue = string.Format("\"fn\":{0}", de.Function);
                            text = text.Replace(oldValue, newValue);
                        }
                    }
                }
                if (!string.IsNullOrEmpty(current.DataUrl))
                {
                    string oldValue = string.Format("\"dataUrl\":\"{0}\"", current.DataUrl);
                    string newValue = string.Format("\"dataUrl\":{0}", current.DataUrl);
                    text = text.Replace(oldValue, newValue);
                }
                if (!string.IsNullOrEmpty(current.BuildSelect))
                {
                    string oldValue = string.Format("\"buildSelect\":\"{0}\"", current.BuildSelect);
                    string newValue = string.Format("\"buildSelect\":{0}", current.BuildSelect);
                    text = text.Replace(oldValue, newValue);
                }
                if (!string.IsNullOrEmpty(current.SerializeColumnData))
                {
                    string oldValue = string.Format("\"postData\":\"{0}\"", current.SerializeColumnData);
                    string newValue = string.Format("\"postData\":{0}", current.SerializeColumnData);
                    text = text.Replace(oldValue, newValue);
                }
                if (!string.IsNullOrEmpty(current.DataInit))
                {
                    string oldValue = string.Format("\"dataInit\":\"{0}\"", current.DataInit);
                    string newValue = string.Format("\"dataInit\":{0}", current.DataInit);
                    text = text.Replace(oldValue, newValue);
                }
                //if (!string.IsNullOrEmpty(current.Complete))
                //{
                //    string oldValue = string.Format("\"complete\":\"{0}\"", current.Complete);
                //    string newValue = string.Format("\"complete\":{0}", current.Complete);
                //    text = text.Replace(oldValue, newValue);
                //}
                if (current.EditActionIconsColumn)
                {
                    if (current.EditActionIconsSettings.ShowEditIcon && !string.IsNullOrEmpty(current.EditActionIconsSettings.onEdit))
                    {
                        string oldValue = string.Format("\"onEdit\":\"{0}\"", current.EditActionIconsSettings.onEdit);
                        string newValue = string.Format("\"onEdit\":{0}", current.EditActionIconsSettings.onEdit);
                        text = text.Replace(oldValue, newValue);
                    }
                    if (current.EditActionIconsSettings.ShowDeleteIcon)
                    {
                        if (!string.IsNullOrEmpty(current.EditActionIconsSettings.DelErrorTextFormat))
                        {
                            string oldValue = string.Format("\"errorTextFormat\":\"{0}\"", current.EditActionIconsSettings.DelErrorTextFormat);
                            string newValue = string.Format("\"errorTextFormat\":{0}", current.EditActionIconsSettings.DelErrorTextFormat);
                            text = text.Replace(oldValue, newValue);
                        }
                        if (!string.IsNullOrEmpty(grid.ClientSideEvents.SerializeDelData))
                        {
                            string oldValue = string.Format("\"serializeDelData\":\"{0}\"", grid.ClientSideEvents.SerializeDelData);
                            string newValue = string.Format("\"serializeDelData\":{0}", grid.ClientSideEvents.SerializeDelData);
                            text = text.Replace(oldValue, newValue);
                        }
                    }
                }
            }
            text = text.Replace('"' + "dataInit" + '"', "dataInit");
            return(text);
        }
예제 #43
0
 public JsonColModel(JQGridColumn column, JQGrid grid) : this(grid)
 {
     this.FromColumn(column);
 }
예제 #44
0
 public JsonColModel(JQGrid grid)
 {
     this._jsonValues = new Hashtable();
     this._grid       = grid;
 }
예제 #45
0
        private string GetAddOptions(JQGrid grid)
        {
            JsonAddDialog dialog = new JsonAddDialog(grid);

            return(dialog.Process());
        }
예제 #46
0
        private string GetExcelExportOptions(JQGrid grid)
        {
            JsonExcelExport jsonGridExport = new JsonExcelExport(grid);

            return(jsonGridExport.Process());
        }
예제 #47
0
 public JsonAddDialog(JQGrid grid)
 {
     this._grid = grid;
 }
예제 #48
0
 public JsonEditDialog(JQGrid grid)
 {
     this._grid = grid;
 }
예제 #49
0
 public JsonDelDialog(JQGrid grid)
 {
     this._grid = grid;
 }
 public JQGridDataResolvedEventArgs(JQGrid gridModel, IQueryable currentData, IQueryable allData)
 {
     this._currentData = currentData;
     this._allData     = allData;
     this._gridModel   = gridModel;
 }
예제 #51
0
 internal static string ConvertToJsonString(JsonResponse response, JQGrid grid, DataTable dt)
 {
     return(new JavaScriptSerializer().Serialize(PrepareJsonResponse(response, grid, dt)));
 }
예제 #52
0
        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 current2 in grid.Columns)
                        {
                            dataTable.Columns.Add(current2.DataField);
                        }
                    }
                    DataRow dataRow = dataTable.NewRow();
                    foreach (JQGridColumn current3 in grid.Columns)
                    {
                        dataRow[current3.DataField] = dbDataRecord[current3.DataField];
                    }
                    dataTable.Rows.Add(dataRow);
                }
                else
                {
                    if (current is DataRow)
                    {
                        DataRow dataRow2 = current as DataRow;
                        if (dataTable.Columns.Count == 0)
                        {
                            foreach (JQGridColumn current4 in grid.Columns)
                            {
                                dataTable.Columns.Add(current4.DataField);
                            }
                        }
                        DataRow dataRow3 = dataTable.NewRow();
                        foreach (JQGridColumn current5 in grid.Columns)
                        {
                            dataRow3[current5.DataField] = dataRow2[current5.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);
        }
예제 #53
0
 public JsonSearchDialog(JQGrid grid)
 {
     this._grid = grid;
 }
예제 #54
0
 public JsonExcelExport(JQGrid grid)
 {
     this._jsonValues = new Hashtable();
     this._grid       = grid;
 }