private void CreateGrid()
        {
            var modelName = _modelType.Name.Replace("Model", "");
            GridSetupAttribute gridSetupAttribute = _modelType.GetCustomAttribute <GridSetupAttribute>();

            _builder.Name("ReportListGrid");

            AjaxDataSourceBuilder <T> dataSourceBuilder = null;

            _builder.DataSource(ds =>
            {
                dataSourceBuilder = ds.Ajax();
                dataSourceBuilder.Model(model => { model.Id(o => o.GetDatabaseBindings().KeyFieldName); });
                dataSourceBuilder.ServerOperation(true);
                dataSourceBuilder.Read(r => r.Action("Read", modelName).Type(HttpVerbs.Get));
                dataSourceBuilder.Create(c => c.Action("Create", modelName).Type(HttpVerbs.Post));
                dataSourceBuilder.Update(u => u.Action("Update", modelName).Type(HttpVerbs.Post));
                dataSourceBuilder.Destroy(d => d.Action("Destroy", modelName).Type(HttpVerbs.Post));
            });

            _builder.Columns(c =>
            {
                dataSourceBuilder.Aggregates(a =>
                {
                    dataSourceBuilder.Model(m =>
                    {
                        PropertyInfo[] modelProperties = _modelType.GetProperties(); //Incase we want to go with model attributes
                        foreach (var p in modelProperties)
                        {
                            var columnAttributes = p.GetCustomAttribute <IrisGridColumnAttribute>() ?? IrisGridColumnAttribute.Default;

                            if (p.Name.EndsWith("User_Key", StringComparison.InvariantCultureIgnoreCase)) //Give it a fake ID
                            {
                                m.Id(p.Name);
                            }
                            else
                            {
                                DataSourceModelFieldDescriptorBuilder <object> fieldBuilder = m.Field(p.Name, p.PropertyType);

                                if (p.Name.EndsWith("User_Key", StringComparison.InvariantCultureIgnoreCase))
                                {
                                    fieldBuilder.DefaultValue(columnAttributes.GetDefaultValue()); //changed for now
                                }
                                else if (columnAttributes.DefaultValue != null)
                                {
                                    fieldBuilder.DefaultValue(columnAttributes.GetDefaultValue());
                                }

                                if (columnAttributes.ReadOnly)
                                {
                                    fieldBuilder.Editable(false);
                                }
                            }

                            GridBoundColumnBuilder <T> column = null;

                            if (p.Name == "Favorite")
                            {
                                column = c.Bound(p.Name).ClientTemplate("<input type='checkbox' #=" + p.Name + " ? checked='checked' : '' # class='fav'></input>");
                            }
                            else if (p.Name == "CustomReport")
                            {
                                column = c.Bound(p.Name).ClientTemplate("#=" + p.Name + " ? 'CR' : '' #").Editable("false");
                            }
                            else
                            {
                                column = c.Bound(p.Name).Editable("false");
                            }

                            column.Width(columnAttributes.Width);
                            column.Hidden(columnAttributes.Hidden);

                            if (p.GetCustomAttribute <DisplayFormatAttribute>() != null)
                            {
                                column.Format(p.GetCustomAttribute <DisplayFormatAttribute>().DataFormatString);
                            }
                        }
                    });
                });
            });

            _builder.Selectable(s => { s.Type(GridSelectionType.Row); });
            _builder.Mobile();
            _builder.Navigatable();
            _builder.HtmlAttributes(new { style = "height: 700px; width: 350px" });
            _builder.Scrollable(a => a.Height("100%"));
            _builder.Events(x => { x.DataBound("ReportListDataBound"); });
            _builder.Editable(e => e.Mode(GridEditMode.InLine).Enabled(true));
        }
        public IrisGridBuilder(HtmlHelper helper)
        {
            Type modelType = typeof(T);
            IrisGridAttribute gridAttribute = modelType.GetCustomAttribute <IrisGridAttribute>();

            if (gridAttribute == null)
            {
                throw new InvalidOperationException("You cannot create a grid control with an object that does not have the IrisGridAttribute.");
            }

            DatabaseModelBindings bindings = modelType.GetDatabaseBindings();

            PropertyInfo[]            modelProperties   = modelType.GetProperties();
            AjaxDataSourceBuilder <T> dataSourceBuilder = null;
            UserService userService = new UserService();

            using (SecurityUserService securityUserService = new SecurityUserService())
            {
                WidgetFactory factory = new WidgetFactory(helper);
                builder = factory.Grid <T>();

                builder.DataSource(ds =>
                {
                    dataSourceBuilder = ds.Ajax();
                    //    .Aggregates(a =>
                    //    {
                    //        a.Add(p => p.Labor_Quantity).Sum();
                    //        a.Add(p => p.Equipment_Quantity).Sum();
                    //        a.Add(p => p.Material_Quantity).Sum();
                    //        a.Add(p => p.OutSideService_Quantity).Sum();
                    //    })
                    //dataSourceBuilder.Events(e =>
                    //{
                    //    e.Error("error");
                    //    e.Change("onChange");
                    //});
                    dataSourceBuilder.PageSize(100);
                    dataSourceBuilder.ServerOperation(true);
                    dataSourceBuilder.Read(r => r.Url(GetAbsoluteUrl(gridAttribute.ReadPath)).Type(HttpVerbs.Get));
                    dataSourceBuilder.Create(c => c.Url(GetAbsoluteUrl(gridAttribute.CreatePath)).Type(HttpVerbs.Post));
                    dataSourceBuilder.Update(u => u.Url(GetAbsoluteUrl(gridAttribute.UpdatePath)).Type(HttpVerbs.Post));
                    dataSourceBuilder.Destroy(d => d.Url(GetAbsoluteUrl(gridAttribute.DestroyPath)).Type(HttpVerbs.Post));
                });

                builder.Name("grid");
                builder.Columns(c =>
                {
                    // Create our command column for this object
                    c.Command(command =>
                    {
                        command.Destroy();
                        command.Edit();
                    }).Lockable(true).Locked(false).Width(180).Visible(userService.ValidateSecurityLevel(bindings.TableName, 3));

                    //.Model(model =>
                    //    {
                    //        model.Id(m => m.Timecard_Key);
                    //        model.Field(m => m.Equipment_Unit_Cost).Editable(true);
                    //        model.Field(m => m.FuelImport).Editable(false);
                    //        model.Field(m => m.DateStamp).Editable(false);
                    //        model.Field(m => m.SecurityUser_Key).Editable(false);
                    //        model.Field(m => m.Timecard_Key).DefaultValue("1600000000");
                    //        model.Field(m => m.SecurityUser_Key).DefaultValue(ViewData["CurrentSecurityUser"]);
                    //        model.Field(m => m.CreatedBySecurityUser_Key).DefaultValue(ViewData["CurrentSecurityUser"]);
                    //        model.Field(m => m.DateStamp).DefaultValue(DateTime.Now);
                    //    })

                    dataSourceBuilder.Aggregates(a =>
                    {
                        dataSourceBuilder.Model(model =>
                        {
                            // Setup the columns from our model properties
                            foreach (PropertyInfo p in modelProperties)
                            {
                                // Get our column settings from the property attribute or use a default one
                                IrisGridColumnAttribute columnAttributes = p.GetCustomAttribute <IrisGridColumnAttribute>();
                                if (columnAttributes == null)
                                {
                                    columnAttributes = IrisGridColumnAttribute.Default;
                                }


                                switch (columnAttributes.Aggregate)
                                {
                                case AggregateMode.Sum:
                                    a.Add(p.Name, p.PropertyType).Sum();
                                    break;

                                case AggregateMode.Min:
                                    a.Add(p.Name, p.PropertyType).Min();
                                    break;

                                case AggregateMode.Max:
                                    a.Add(p.Name, p.PropertyType).Max();
                                    break;

                                case AggregateMode.Average:
                                    a.Add(p.Name, p.PropertyType).Average();
                                    break;
                                }

                                if (p.Name == bindings.KeyFieldName)
                                {
                                    model.Id(p.Name);
                                }
                                else
                                {
                                    DataSourceModelFieldDescriptorBuilder <object> fieldBuilder = model.Field(p.Name, p.PropertyType);
                                    if (p.Name.EndsWith("User_Key", StringComparison.InvariantCultureIgnoreCase))
                                    {
                                        fieldBuilder.DefaultValue(securityUserService.CurrentSecurityUser());
                                    }
                                }

                                GridBoundColumnBuilder <T> column = c.Bound(p.Name);
                                column.Lockable(true).Locked(false);

                                // Setup our formatting for this column
                                if (string.IsNullOrEmpty(columnAttributes.Format) == false)
                                {
                                    column.Format(columnAttributes.Format);
                                }

                                // Setup our custom editor templates if they are needed
                                if (p.PropertyType == typeDate)
                                {
                                    column.EditorTemplateName("IRISDate");
                                }

                                // Setup custom attributes
                                if (p.GetCustomAttribute <RequiredAttribute>() != null)
                                {
                                    column.HeaderHtmlAttributes(new { @Class = "required-field" });
                                }

                                column.Width(columnAttributes.Width);
                            }
                        });
                    });
                });

                // Setup our column menus for filtering and sorting
                builder.ColumnMenu(m =>
                {
                    m.Enabled(true);
                    m.Filterable(true);
                    m.Sortable(true);
                    m.Columns(true);
                });

                // Setup our editable configuration
                builder.Editable(e =>
                {
                    e.Mode(GridEditMode.InLine);
                    e.CreateAt(GridInsertRowPosition.Top);
                    e.DisplayDeleteConfirmation(false);
                });

                builder.Events(e =>
                {
                    //    e.Edit("onGridEdit");
                    //    e.Save("ValidateRow");              // Used for Update button
                    //    e.SaveChanges("ValidateRow");       // Used for Alt + s
                    //    e.DataBound("SelectFirstRow");
                });


                //.Excel(excel => excel
                //    .FileName("Timecard.xlsx")
                //    .Filterable(true)
                //    .ProxyURL(Url.Action("Excel_Export_Save", "Grid"))
                //)
                //.Pdf(pdf => pdf
                //    .FileName("Timecard.pdf")
                //    .ProxyURL(Url.Action("Pdf_Export_Save", "Grid"))
                //    .AllPages()
                //)

                builder.Filterable();
                builder.Navigatable(setting => setting.Enabled(true));
                builder.Pageable(p => p.Refresh(true).PageSizes(true).ButtonCount(5));
                builder.Scrollable(a => a.Height(500));
                builder.Resizable(resize => resize.Columns(true));
                builder.Reorderable(reorder => reorder.Columns(true));
                builder.Sortable();
                builder.Selectable();
                //.ToolBar(toolBar =>
                //{
                //    toolBar.Create();
                //    toolBar.Excel();
                //    toolBar.Pdf();
                //})

                //.DataSource(ds => ds
                //    .Ajax()

                //
                //    .Sort(s => s.Add(t => t.Task_Date))



                //.Columns(c =>
                //{
                //    c.Command(command => { command.Destroy(); command.Edit(); }).Lockable(true).Locked(false).Width(180).Visible(AuthHelper.ValidateSecurityLevel("Timecard", 3));
                //    c.Bound(p => p.Task_Date).Width(180).Lockable(true).Locked(false).EditorTemplateName("IRISDate").HeaderHtmlAttributes(new { @Class = "required-field" });
                //    c.ForeignKey(p => p.Activity_Key, (System.Collections.IEnumerable)ViewData["Activities"], "Field1", "Field2").Width(350).Lockable(true).HeaderHtmlAttributes(new { @Class = "required-field" }).EditorTemplateName("IRISGridForeignKeyWithFilter");
                //    c.ForeignKey(p => p.Project_Key, (System.Collections.IEnumerable)ViewData["Projects"], "Field1", "Field2").Width(350).EditorTemplateName("IRISGridForeignKey");
                //    c.ForeignKey(p => p.ProjectSub_Key, (System.Collections.IEnumerable)ViewData["ProjectSubs"], "ProjectSub_Key", "NameDesc").EditorTemplateName("ProjectSub").Width(200);
                //    c.Bound(p => p.Crew_Num).Width(120);
                //    c.ForeignKey(p => p.Employee_Key, (System.Collections.IEnumerable)ViewData["Employees"], "Field1", "Field2").Width(350).EditorTemplateName("IRISGridForeignKey");
                //    c.Bound(p => p.Labor_Quantity).HtmlAttributes(new { style = "text-align: right" }).Width(150).ClientGroupFooterTemplate("Sum: #= kendo.format('{0:n}', sum)#").ClientFooterTemplate("Sum: #= kendo.format('{0:n}', sum)#");
                //    c.ForeignKey(p => p.Pay_Type_Key, (System.Collections.IEnumerable)ViewData["Pay_Types"], "Field1", "Field2").Width(150).EditorTemplateName("IRISGridForeignKey");
                //    c.ForeignKey(p => p.Premium_Key, (System.Collections.IEnumerable)ViewData["Premiums"], "Field1", "Field2").Width(150).EditorTemplateName("IRISGridForeignKey");
                //    c.Bound(p => p.Override_Labor_Rate).Format("{0:c}").HtmlAttributes(new { style = "text-align: right" }).Width(200);
                //    c.Bound(p => p.Production).HtmlAttributes(new { style = "text-align: right" }).Width(130).ClientGroupFooterTemplate("Sum: #= kendo.format('{0:n}', sum)#").ClientFooterTemplate("Sum: #= kendo.format('{0:n}', sum)#");
                //    c.Bound(p => p.Equipment_Quantity).HtmlAttributes(new { style = "text-align: right" }).Width(200).ClientGroupFooterTemplate("Sum: #= kendo.format('{0:n}', sum)#").ClientFooterTemplate("Sum: #= kendo.format('{0:n}', sum)#");
                //    c.ForeignKey(p => p.Equipment_Key, (System.Collections.IEnumerable)ViewData["Equipments"], "Field1", "Field2").Width(350).EditorTemplateName("IRISGridForeignKey");
                //    c.Bound(p => p.Equipment_Unit_Cost).Format("{0:c}").HtmlAttributes(new { style = "text-align: right" }).Width(120);
                //    c.Bound(p => p.Material_Quantity).HtmlAttributes(new { style = "text-align: right" }).Width(120).ClientGroupFooterTemplate("Sum: #= kendo.format('{0:n}', sum)#").ClientFooterTemplate("Sum: #= kendo.format('{0:n}', sum)#");
                //    c.ForeignKey(p => p.Inventory_Location_Key, (System.Collections.IEnumerable)ViewData["Inventory_Locations"], "Inventory_Location_Key", "NameDesc").Width(350).EditorTemplateName("IRISGridForeignKey");
                //    c.Bound(p => p.UOMName).Width(100);
                //    c.Bound(p => p.Material_Description).Width(120);
                //    c.Bound(p => p.Material_Unit_Cost).Format("{0:c}").HtmlAttributes(new { style = "text-align: right" }).Width(150);
                //    c.ForeignKey(p => p.ResourceClass_Key, (System.Collections.IEnumerable)ViewData["ResourceClasss"], "Field1", "Field2").Width(350).EditorTemplateName("IRISGridForeignKey");
                //    c.Bound(p => p.OutSideServiceDescription).Width(120);
                //    c.Bound(p => p.OutSideService_Quantity).HtmlAttributes(new { style = "text-align: right" }).Width(100);
                //    c.Bound(p => p.OutSideServiceCost).Format("{0:c}").HtmlAttributes(new { style = "text-align: right" }).Width(120);
                //    c.ForeignKey(p => p.Mgt_Unit_Key, (System.Collections.IEnumerable)ViewData["Mgt_Units"], "Field1", "Field2").Width(350).EditorTemplateName("IRISGridForeignKey");
                //    c.ForeignKey(p => p.Program_Key, (System.Collections.IEnumerable)ViewData["Programs"], "Field1", "Field2").Width(350).EditorTemplateName("IRISGridForeignKey");
                //    c.ForeignKey(p => p.Zone_Key, (System.Collections.IEnumerable)ViewData["Zones"], "Field1", "Field2").Width(350).EditorTemplateName("IRISGridForeignKey");
                //    c.ForeignKey(p => p.RBF_Key, (System.Collections.IEnumerable)ViewData["RBFs"], "Field1", "Field2").Width(200).EditorTemplateName("IRISGridForeignKey");
                //    c.ForeignKey(p => p.Road_Key, (System.Collections.IEnumerable)ViewData["Roads"], "Field1", "Field2").Width(200).EditorTemplateName("IRISGridForeignKey");
                //    c.ForeignKey(p => p.RoadName_Key, (System.Collections.IEnumerable)ViewData["RoadNames"], "Field1", "Field2").Width(200).EditorTemplateName("IRISGridForeignKey");
                //    c.Bound(p => p.Beg_Point).Width(120);
                //    c.Bound(p => p.End_Point).Width(120);
                //    c.Bound(p => p.FromLocation).Width(180);
                //    c.Bound(p => p.ToLocation).Width(180);
                //    c.ForeignKey(p => p.Reason_Key, (System.Collections.IEnumerable)ViewData["Reasons"], "Field1", "Field2").Width(200).EditorTemplateName("IRISGridForeignKey");
                //    c.Bound(p => p.Comments).Width(280);
                //    c.Bound(p => p.EquipmentMiles).HtmlAttributes(new { style = "text-align: right" }).Width(250);
                //    c.Bound(p => p.EquipmentHours).HtmlAttributes(new { style = "text-align: right" }).Width(250);

                //    // User defined fields
                //    string title;
                //    string userType;


                //    //ViewBag.UserDefinedFields.User1
                //    for (int i = 0; i < ViewBag.UserDefinedFields.Count; i++ )

                //    {
                //        title = ViewBag.UserDefinedFields[i].Title;
                //        userType = ViewBag.UserDefinedFields[i].Type;


                //        switch (userType)
                //        {
                //            case "String":
                //                c.Bound(ViewBag.UserDefinedFields[i].Field).Title(title).Width(120);
                //                break;
                //            case "Date":
                //                c.Bound(ViewBag.UserDefinedFields[i].Field).Title(title).EditorTemplateName("Date").Width(150);
                //                break;
                //            case "Numeric":
                //                c.Bound(ViewBag.UserDefinedFields[i].Field).Title(title).EditorTemplateName("Number").HtmlAttributes(new { style = "text-align: right" }).Width(120);
                //                break;
                //            case "Checkbox":
                //                c.Bound(ViewBag.UserDefinedFields[i].Field).Title(title).HtmlAttributes(new { style = "text-align: center" }).ClientTemplate("<input type='checkbox' #=" + ViewBag.UserDefinedFields[i].Field + " ? checked='checked' : '' # class='chkbx' disabled='disabled'></input>").Width(120);
                //                break;
                //            case "Lookup":
                //                c.ForeignKey(ViewBag.UserDefinedFields[i].Field, (System.Collections.IEnumerable)ViewData["LookupUser" + (i + 1).ToString()], "Field1", "Field2").Width(350).EditorTemplateName("IRISGridForeignKey");
                //                break;
                //        }

                //    }

                //    c.Bound(p => p.FuelImport).HtmlAttributes(new { style = "text-align: center" }).ClientTemplate("<input type='checkbox' #=FuelImport ? checked='checked' : '' # class='chkbx' disabled='disabled' readonly='readonly'></input>").Width(200);
                //    c.Bound(p => p.Error_Message).Width(220);
                //    c.Bound(p => p.DateStamp).Format("{0: MM/d/yyyy hh:mm:ss}").Width(175);
                //    c.ForeignKey(p => p.SecurityUser_Key, (System.Collections.IEnumerable)ViewData["SecurityUsers"], "SecurityUser_Key", "UserName").Width(140);
                //})
                //)
            }
        }
Пример #3
0
        public static GridBuilder <T> VnrGrid <T>(this HtmlHelper helper,
                                                  GridBuilderInfo builderInfo) where T : class
        {
            #region PageableBuilder

            Action <PageableBuilder> pageable = new Action <PageableBuilder>(d => d.PageSizes(builderInfo.ShowPageSize).Input(builderInfo.ShowInputPageNumber).PreviousNext(builderInfo.ShowNextPrevious).Numeric(builderInfo.ShowPageNumber).Refresh(true).ButtonCount(5));
            builderInfo.ObjectType = builderInfo.ObjectType != null ? builderInfo.ObjectType : typeof(T);

            Action <GridSelectionSettingsBuilder> selection = new Action <GridSelectionSettingsBuilder>(d =>
                                                                                                        d.Mode(builderInfo.SelectionMode).Type(builderInfo.SelectionType));

            Action <GridToolBarCommandFactory <T> > toolBar = new Action <GridToolBarCommandFactory <T> >(d =>
            {
                if (builderInfo.ShowCreateButton && !string.IsNullOrWhiteSpace(builderInfo.CreateActionUrl))
                {
                    d.Create().Text(DefaultConstants.Create.TranslateString());
                }
                if (builderInfo.ShowSaveButton && !string.IsNullOrWhiteSpace(builderInfo.EditActionUrl))
                {
                    d.Save().Text(DefaultConstants.Create.TranslateString());
                }
                if (builderInfo.ShowCustomCreate && !string.IsNullOrWhiteSpace(builderInfo.EventCustomAdd))
                {
                    d.Custom().Text(DefaultConstants.Create.TranslateString()).Url("#").HtmlAttributes(new { onclick = builderInfo.EventCustomAdd });
                }

                if (builderInfo.ShowCustomSaveChanges && !string.IsNullOrWhiteSpace(builderInfo.EventCustomSaveChanges) && !string.IsNullOrWhiteSpace(builderInfo.EventCustomCancelChanges))
                {
                    d.Custom().Text(builderInfo.CustomSaveChangesText).Url("#").HtmlAttributes(new { onclick = builderInfo.EventCustomSaveChanges });
                    d.Custom().Text(builderInfo.CustomCancelChangesText).Url("#").HtmlAttributes(new { onclick = builderInfo.EventCustomCancelChanges });
                }
            });

            Action <GridEditingSettingsBuilder <T> > editing = new Action <GridEditingSettingsBuilder <T> >(d =>
            {
                d.Mode(builderInfo.EditMode);
                if (!string.IsNullOrWhiteSpace(builderInfo.EditTemplate))
                {
                    d.TemplateName(builderInfo.EditTemplate);
                }
            });

            Action <GridEventBuilder> events = new Action <GridEventBuilder>(d =>
            {
                //if (builderInfo.ForeignKey.Count>0)
                //    d.Save("onSave");
                if (!string.IsNullOrWhiteSpace(builderInfo.SelectionHandler))
                {
                    d.Change(builderInfo.SelectionHandler);
                }
                if (!string.IsNullOrWhiteSpace(builderInfo.EventSaveChanges))
                {
                    d.SaveChanges(builderInfo.EventSaveChanges);
                }
                if (!string.IsNullOrWhiteSpace(builderInfo.EventDataBound))
                {
                    d.DataBound(builderInfo.EventDataBound);
                }
                else
                {
                    //[Tung.Ly 20140908 ] : dùng mặc định (viết ở _layout.cshtml ở main)
                    d.DataBound("dataBound");
                }
                if (!string.IsNullOrWhiteSpace(builderInfo.EvenEdit))
                {
                    d.Edit(builderInfo.EvenEdit);
                }
            });

            #endregion

            #region GridColumnFactory


            var lockedCol = false;
            if (builderInfo.LockedFields != null && builderInfo.LockedFields.Any())
            {
                lockedCol = true;
            }

            Action <GridColumnFactory <T> > columns = new Action <GridColumnFactory <T> >(column =>
            {
                if (builderInfo.ValueFields != null)
                {
                    column.AutoGenerate(builderInfo.ValueFields.Count() == 0);

                    if (builderInfo.ShowCheckbox)
                    {
                        if (builderInfo.ShowCheckAll)
                        {
                            column.Bound("").Title("").HeaderTemplate("<input type='checkbox' id='mastercheckbox' /><div style='border: solid 1px #c5c5c5; margin-top: -3px; border-radius: initial; display: none; width: 60px; position: fixed; z-index: 99; background-color: #F8F8F8; ' class='hrm_treeview' id='MultipleSelectForPage'> <label><input type='radio' value='0' name='selectOnePageOrAllPage' checked /> Page</label><br /> <label><input value='1' type='radio' name='selectOnePageOrAllPage' /> All</label></div>").ClientTemplate("<input type='checkbox' value='#=ID#' class='checkboxGroups'/>").Width(25).Locked(lockedCol).Sortable(false);
                        }
                        else
                        {
                            column.Bound("").Title("").ClientTemplate("<input type='checkbox' value='#=ID#' class='checkboxGroups'/>").Width(25).Locked(lockedCol).Sortable(false);
                        }
                    }
                    if (builderInfo.ShowEditIcon)
                    {
                        column.Bound("").Title("").ClientTemplate("<img src='/Content/images/icons/edit-file-icon.png' title='Edit' alt='Edit' name='gridEditImgButton' class='gridEditImgButton' />").Width(30).Locked(lockedCol).Sortable(false);
                    }
                    if (builderInfo.ShowCommand)
                    {
                        column.Command(d =>
                        {
                            if (builderInfo.ShowEditButton && !string.IsNullOrWhiteSpace(builderInfo.EditActionUrl))
                            {
                                d.Edit()
                                .Text(string.Empty)
                                .UpdateText(DefaultConstants.Save.TranslateString())
                                .CancelText(string.Empty);
                                // d.Edit().HtmlAttributes(new{@class="abdd"})
                            }

                            if (builderInfo.ShowDeleteButton &&
                                !string.IsNullOrWhiteSpace(builderInfo.DeleteActionUrl))
                            {
                                d.Destroy().Text(DefaultConstants.Delete.TranslateString());
                            }
                            if (builderInfo.ShowCustomEdit && !string.IsNullOrWhiteSpace(builderInfo.EventCustomEdit))
                            {
                                d.Custom(builderInfo.EditText).HtmlAttributes(new { @class = "k-icon k-i-pencil" }).Click(builderInfo.EventCustomEdit);
                            }
                        }).Width(170);
                    }


                    foreach (var valueField in builderInfo.ValueFields)
                    {
                        var locked = false;
                        if (builderInfo.LockedFields != null)
                        {
                            if (builderInfo.LockedFields.Contains(valueField))
                            {
                                locked = true;
                            }
                        }
                        GridBoundColumnBuilder <T> bound = null;

                        string displayField = string.Empty, formatField = string.Empty, hyperlinkField = string.Empty, template = string.Empty;
                        bool filterable     = false;
                        Type fieldValueType = GetFieldValueType(builderInfo, valueField);
                        if (fieldValueType != null)
                        {
                            //Biến phân biệt đã add foreignKey hay chưa
                            bool _tmp = false;

                            foreach (var foreignKey in builderInfo.ForeignKey)
                            {
                                if (foreignKey.Key.ToString() == valueField)
                                {
                                    if (foreignKey.Key != null && foreignKey.Value != null && foreignKey.Value.Count() > 3)
                                    {
                                        IList lstFk = (IList)foreignKey.Value[2];
                                        if (lstFk != null)
                                        {
                                            if (foreignKey.Value[4].ToString() != string.Empty)
                                            {
                                                bound = column.ForeignKey(foreignKey.Key.ToString(), lstFk, foreignKey.Value[0].ToString(), foreignKey.Value[1].ToString()).Width(150).Title(foreignKey.Value[3].ToString().TranslateString()).EditorTemplateName(foreignKey.Value[4].ToString());
                                            }
                                            else
                                            {
                                                bound = column.ForeignKey(foreignKey.Key.ToString(), lstFk, foreignKey.Value[0].ToString(), foreignKey.Value[1].ToString()).Width(150).Title(foreignKey.Value[3].ToString().TranslateString());
                                            }
                                        }
                                        _tmp = true;
                                        break;
                                    }
                                }
                            }
                            if (!_tmp)
                            {
                                bound = column.Bound(fieldValueType, valueField).Locked(locked);
                                if (fieldValueType.IsBoolean())
                                {
                                    bound.ClientTemplate("<input type='checkbox' disabled='" + builderInfo.DisabledCheckbox + "' #= " + valueField + " ? 'checked=checked':'' # class='chkbx' />");
                                }
                                else if (fieldValueType.IsDateTime() || fieldValueType.IsFloat() || fieldValueType.IsNumeric() || fieldValueType.IsDouble() || fieldValueType.IsInteger() || fieldValueType.IsDecimal())
                                {
                                    bound.HtmlAttributes(new { style = "text-align:right" });
                                }
                                if (fieldValueType.IsDouble())
                                {
                                    bound.EditorTemplateName("Number");
                                }
                                if (fieldValueType.IsFloat())
                                {
                                    bound.EditorTemplateName("Percent");
                                }
                            }
                        }
                        else
                        {
                            bound = column.Bound(valueField).Locked(locked);
                        }

                        if (builderInfo.HasDisplayFields())
                        {
                            displayField = builderInfo.DisplayFields.Where(d => d.Key
                                                                           == valueField).Select(d => d.Value).FirstOrDefault();
                        }

                        if (string.IsNullOrWhiteSpace(displayField))
                        {
                            displayField = valueField;
                        }
                        bound.Title(displayField.TranslateString());
                        #region Format Column
                        if (builderInfo.HasFormatFields())
                        {
                            formatField = builderInfo.FormatFields.Where(d => d.Key
                                                                         == valueField).Select(d => d.Value).FirstOrDefault();
                        }

                        if (builderInfo.HasHyperlink())
                        {
                            hyperlinkField = builderInfo.HyperlinkFields.Where(d => d.Key
                                                                               == valueField).Select(d => d.Value).FirstOrDefault();
                        }
                        if (builderInfo.HasFilterable())
                        {
                            filterable = builderInfo.Filterable.Where(d => d.Key
                                                                      == valueField).Select(d => d.Value).FirstOrDefault();
                        }

                        //bound.Filterable(filterable);
                        bound.Filterable(filterable).Filterable(_filterable => _filterable
                                                                .Extra(false)
                                                                .Operators(ops =>
                                                                           ops.ForString(str => str.Clear()
                                                                                         .Contains("Contains")
                                                                                         .StartsWith("Starts with")
                                                                                         .EndsWith("Ends with")
                                                                                         .IsEqualTo("Is equal to"))
                                                                           ));

                        if (builderInfo.HasTemplate())
                        {
                            template = builderInfo.Template.Where(d => d.Key
                                                                  == valueField).Select(d => d.Value).FirstOrDefault();
                        }

                        if (builderInfo.HasSizeFields())
                        {
                            int fieldWidth = builderInfo.SizeFields.Where(d => d.Key
                                                                          == valueField).Select(d => d.Value).FirstOrDefault();

                            if (fieldWidth >= 10)
                            {
                                bound.Width(fieldWidth);
                            }
                        }

                        if (string.IsNullOrWhiteSpace(formatField))
                        {
                            formatField = GetDefaultFormat(fieldValueType);
                        }

                        if (!string.IsNullOrWhiteSpace(hyperlinkField))
                        {
                            var itemHyperlink = hyperlinkField.Split(',');
                            if (itemHyperlink.Count() > 1)
                            {
                                bound.ClientTemplate("<a onClick=\"" + itemHyperlink[0] + "('#=" + itemHyperlink[1] + "#')\">#=" + valueField + "#</a>");
                            }
                            else
                            {
                                bound.ClientTemplate("<a onClick=\"" + hyperlinkField + "('#=ID#')\">#=" + valueField + "#</a>");
                            }
                        }
                        if (builderInfo.SumFields != null && builderInfo.SumFields.Any())
                        {
                            foreach (var field in builderInfo.SumFields)
                            {
                                if (field == valueField)
                                {
                                    var str = "#=sum#";
                                    if (!string.IsNullOrEmpty(builderInfo.FormatSum))
                                    {
                                        str = "#=kendo.toString(sum,'" + builderInfo.FormatSum + "')#";
                                    }
                                    bound.ClientFooterTemplate(str);
                                    break;
                                }
                            }
                        }

                        if (builderInfo.GroupHeaderTemplate != null && builderInfo.GroupFields != null && builderInfo.GroupFields.Any())
                        {
                            var header = builderInfo.GroupHeaderTemplate;
                            foreach (var field in builderInfo.GroupFields)
                            {
                                if (header.ContainsKey(field) && !string.IsNullOrEmpty(header[field].ToString()))
                                {
                                    bound.ClientGroupHeaderTemplate(header[field]);
                                    break;
                                }
                            }
                        }

                        if (!string.IsNullOrWhiteSpace(formatField))
                        {
                            if (!formatField.Contains("{") || !formatField.Contains("}"))
                            {
                                formatField = "{0:" + formatField + "}";
                            }

                            bound.Format(formatField);
                        }

                        if (builderInfo.HiddenFields != null && builderInfo.HiddenFields.Contains(valueField))
                        {
                            bound.Hidden(true);
                        }


                        #endregion
                    }

                    //foreach (var foreignKey in builderInfo.ForeignKey)
                    //{
                    //    if (foreignKey.Key != null && foreignKey.Value != null && foreignKey.Value.Count() > 3)
                    //    {
                    //        IList lstFk = (IList)foreignKey.Value[2];
                    //        if (lstFk != null)
                    //        {
                    //            if (foreignKey.Value[4].ToString() != string.Empty)
                    //            {
                    //                column.ForeignKey(foreignKey.Key.ToString(), lstFk, foreignKey.Value[0].ToString(), foreignKey.Value[1].ToString()).Width(150).Title(foreignKey.Value[3].ToString().TranslateString()).EditorTemplateName(foreignKey.Value[4].ToString());
                    //            }
                    //            else
                    //            {
                    //                column.ForeignKey(foreignKey.Key.ToString(), lstFk, foreignKey.Value[0].ToString(), foreignKey.Value[1].ToString()).Width(150).Title(foreignKey.Value[3].ToString().TranslateString());
                    //            }
                    //        }
                    //    }
                    //}
                    //column.Bound("").Title("").Sortable(false).Filterable(false).CompareByOperator(;
                    column.Bound("").Title("").Sortable(false).Filterable(filterable => filterable
                                                                          .Extra(false)
                                                                          .Operators(ops =>
                                                                                     ops.ForString(str => str.Clear()
                                                                                                   .Contains("Contains")
                                                                                                   .StartsWith("Starts with")
                                                                                                   .EndsWith("Ends with")
                                                                                                   .IsEqualTo("Is equal to"))
                                                                                     ));
                }
            });

            #endregion

            #region DataSourceBuilder
            Action <DataSourceBuilder <T> > dataSource = new Action <DataSourceBuilder <T> >(data =>
            {
                AjaxDataSourceBuilder <T> ajaxDataSource = data.Ajax();
                ajaxDataSource.Events(e => e.Error("ErrorHandler"));
                ajaxDataSource.Batch(builderInfo.Batch);

                int pos = Array.IndexOf(builderInfo.ValueFields, builderInfo.DefaultSortField);
                if (pos > -1)
                {
                    ajaxDataSource.Sort(sort => sort.Add(builderInfo.DefaultSortField).Descending());
                }

                if (!string.IsNullOrWhiteSpace(builderInfo.EventError))
                {
                    ajaxDataSource.Events(e => e.Error(builderInfo.EventError));
                }

                if (builderInfo.GroupFields != null && builderInfo.GroupFields.Count() > 0)
                {
                    foreach (var groupField in builderInfo.GroupFields)
                    {
                        if (!string.IsNullOrWhiteSpace(groupField))
                        {
                            ajaxDataSource.Group(group =>
                            {
                                group.Add(groupField, GetFieldValueType(builderInfo, groupField));
                            });
                        }
                    }
                }

                if (builderInfo.SumFields != null && builderInfo.SumFields.Count() > 0)
                {
                    ajaxDataSource.Aggregates(agg =>
                    {
                        foreach (var sumField in builderInfo.SumFields)
                        {
                            if (!string.IsNullOrWhiteSpace(sumField))
                            {
                                agg.Add(sumField, GetFieldValueType(builderInfo, sumField)).Sum();
                            }
                        }
                    });
                }

                if (builderInfo.PageSize > 0)
                {
                    ajaxDataSource.PageSize(builderInfo.PageSize);
                }
                if (!builderInfo.ServerOperation)
                {
                    ajaxDataSource.ServerOperation(builderInfo.ServerOperation);
                }

                ajaxDataSource.Model(model =>
                {
                    if (!string.IsNullOrWhiteSpace(builderInfo.IdPropertyName))
                    {
                        model.Id(builderInfo.IdPropertyName);
                    }

                    foreach (var valueField in builderInfo.ValueFields)
                    {
                        Type fieldValueType = GetFieldValueType(builderInfo, valueField);
                        bool editable       = true;

                        if (builderInfo.DisableFields != null)
                        {
                            editable = !builderInfo.DisableFields.Contains(valueField);
                        }

                        if (fieldValueType != null)
                        {
                            model.Field(valueField, fieldValueType).Editable(editable);
                        }
                        else
                        {
                            model.Field(valueField, typeof(string)).Editable(editable);
                        }
                    }
                });

                if (!string.IsNullOrWhiteSpace(builderInfo.ReadActionUrl))
                {
                    if (builderInfo.ReadActionUrl.Contains("/"))
                    {
                        if (!string.IsNullOrWhiteSpace(builderInfo.ReadData))
                        {
                            //ajaxDataSource.Read(action => action.Url(builderInfo.ReadActionUrl).Data("OverWriteReadDataOnGrid(" + builderInfo.ReadData + ")"));
                            ajaxDataSource.Read(action => action.Url(builderInfo.ReadActionUrl).Data(builderInfo.ReadData));
                        }
                        else
                        {
                            //Trường hợp ReadActionUrl là một đường dẫn url
                            ajaxDataSource.Read(action => action.Url(builderInfo.ReadActionUrl));
                        }
                    }
                    else
                    {
                        //Trường hợp ReadActionUrl là một action name trong một controller
                        if (builderInfo.ReadParameter != null)
                        {
                            ajaxDataSource.Read(builderInfo.ReadActionUrl, builderInfo.Controller, builderInfo.ReadParameter);
                        }
                        if (!string.IsNullOrWhiteSpace(builderInfo.ReadData))
                        {
                            ajaxDataSource.Read(r => r.Action(builderInfo.ReadActionUrl, builderInfo.Controller).Data(builderInfo.ReadData));
                        }
                        //ajaxDataSource.Read(builderInfo.ReadActionUrl, builderInfo.Controller);
                    }
                }

                if (!string.IsNullOrWhiteSpace(builderInfo.CreateActionUrl))
                {
                    if (builderInfo.CreateActionUrl.Contains("/"))
                    {
                        //Trường hợp ReadActionUrl là một đường dẫn url
                        ajaxDataSource.Create(action => action.Url(builderInfo.CreateActionUrl));
                    }
                    else
                    {
                        //Trường hợp ReadActionUrl là một action name trong một controller
                        ajaxDataSource.Create(builderInfo.CreateActionUrl, builderInfo.Controller);
                    }
                }

                if (!string.IsNullOrWhiteSpace(builderInfo.EditActionUrl))
                {
                    if (builderInfo.EditActionUrl.Contains("/"))
                    {
                        //Trường hợp ReadActionUrl là một đường dẫn url
                        ajaxDataSource.Update(action => action.Url(builderInfo.EditActionUrl));
                    }
                    else
                    {
                        //Trường hợp ReadActionUrl là một action name trong một controller
                        ajaxDataSource.Update(builderInfo.EditActionUrl, builderInfo.Controller);
                    }
                }

                if (!string.IsNullOrWhiteSpace(builderInfo.DeleteActionUrl))
                {
                    if (builderInfo.DeleteActionUrl.Contains("/"))
                    {
                        //Trường hợp ReadActionUrl là một đường dẫn url
                        ajaxDataSource.Destroy(action => action.Url(builderInfo.DeleteActionUrl));
                    }
                    else
                    {
                        //Trường hợp ReadActionUrl là một action name trong một controller
                        ajaxDataSource.Destroy(builderInfo.DeleteActionUrl, builderInfo.Controller);
                    }
                }
            });

            #endregion

            #region GridBuilder

            var gridbuilder = helper.Kendo().Grid <T>()
                              .Name(builderInfo.Name)
                              .Groupable(d => d.Enabled(builderInfo.ShowGroupPanel))
                              .AutoBind(builderInfo.AutoBind)
                              .Resizable(d => d.Columns(true))
                              .Reorderable(d => d.Columns(true))
                              .Sortable(d => d.SortMode(GridSortMode.MultipleColumn))
                              .ToolBar(toolBar)
                              .Selectable(selection)
                              .Pageable(pageable)
                              .Columns(columns)
                              .ColumnMenu()
                              .Filterable()
                              .Editable(editing)
                              .DataSource(dataSource)
                              .Events(events)
                              //.ToolBar(tb =>
                              //{
                              //    tb.Custom().Name("ChangeColumnMode").Text("<img alt='icon' class='k-image' src='../Content/images/icons/submenu/menu/Sys_table_edit.png'>ChangeColumnMode").Url("#").HtmlAttributes(new { onclick = "ClickButtonChangeColum2('" + builderInfo.ObjectType.Name + "')" });
                              //    tb.Custom().Name("update-inventory").Text("Update Inventory").HtmlAttributes(
                              //        new {onclick = "onUpdateInventory()", title = "Update the system inventory from the OMS", @class="k-refresh"});
                              //} )
            ;

            if (!string.IsNullOrEmpty(builderInfo.ClientDetailTemplateId))
            {
                gridbuilder.ClientDetailTemplateId(builderInfo.ClientDetailTemplateId);
            }
            IDictionary <string, object> attributes = new Dictionary <string, object>();
            var strStyle = string.Empty;
            if (builderInfo.GridHeight > 0)
            {
                strStyle += "height:" + builderInfo.GridHeight + "px; ";
            }
            if (builderInfo.GridWidth > 0)
            {
                strStyle += "width:" + builderInfo.GridWidth + "px; ";
            }
            if (!string.IsNullOrEmpty(strStyle))
            {
                attributes.Add("style", strStyle);
            }
            if (attributes.Any())
            {
                gridbuilder.HtmlAttributes(attributes);
            }
            if (builderInfo.ColumnFilterable)
            {
                gridbuilder.Filterable();
            }

            if (builderInfo.ColumnMenu)
            {
                gridbuilder.ColumnMenu();
            }
            if (builderInfo.Scrollable)
            {
                if (builderInfo.ScrollableHeight > 0)
                {
                    gridbuilder.Scrollable(s => s.Height("auto"));
                }
                else
                {
                    gridbuilder.Scrollable();
                }
            }
            if (builderInfo.Navigatable)
            {
                gridbuilder.Navigatable();
            }
            if (builderInfo.ToClientTemplate)
            {
                gridbuilder.ToClientTemplate();
            }
            return(gridbuilder);

            #endregion
        }