页面数据赋值转换

将取值的数字改为对应状态

当前页面代码

@(Html.Kendo().Grid<CallRepair>
                ()
                .Name("grid")
                .Columns(columns =>
                {
                    columns.Bound(c => c.Id)
                    .ClientTemplate("<input type='checkbox' value='#=Id#' class='checkboxGroups' name='selectedIds' />")
                    .HeaderTemplate(" <input id='mastercheckbox' type='checkbox' /> ")
                    .Filterable(false)
                    .Sortable(false)
                    .Width(30);
                    columns.Bound(c => c.Call_Repair_No).ClientTemplate("<a href='" + Url.Action("Review") + "/#=Id#'>#=Call_Repair_No#</a>").Filterable(true).Width(150);
                    columns.Bound(c => c.Repair_Type).Filterable(false).Sortable(false).Width(110);
                    columns.Bound(c => c.Status).Filterable(false).Sortable(false).Width(60);
                    columns.Bound(c => c.Line_Id).Filterable(false).Sortable(false).Width(80);
                    columns.Bound(c => c.Call_Location).Filterable(false).Sortable(false).Width(100);
                    columns.Bound(c => c.Call_By).Filterable(false).Sortable(false).Width(80);
                    columns.Bound(c => c.Machine_Id).Filterable(false).Sortable(false).Width(110);                      
                    columns.Bound(c => c.Call_Time).Format("{0: yyyy/MM/dd HH:mm:ss}").Filterable(false).Sortable(false).Width(130);
                    columns.Bound(c => c.Close_Time).Format("{0: yyyy/MM/dd HH:mm:ss}").Filterable(false).Sortable(false).Width(130);
                    columns.Bound(c => c.Spend_Times).Format("{0: yyyy/MM/dd HH:mm:ss}").Filterable(false).Sortable(false).Width(130);
                    columns.Bound(c => c.Update_Time).Format("{0: yyyy/MM/dd HH:mm:ss}").Filterable(false).Sortable(false).Width(130);
                    columns.Bound(c => c.Update_By).Sortable(false).Width(80);
                })
                    .DefaultOptions()
                    .Filterable(f => f.Enabled(true))
                    .Events(e => e.DataBound("boundGridMaintainStatus"))
                    .DataSource(dataSource => dataSource
                    .Ajax()
                    .Batch(true)
                    .Read(read => read.Action("CallRepairList", Html.ControllerName()))
                    .ServerOperation(true)
                    .Model(m =>
                    {
                        m.Id(c => c.Id);

                    }).PageSize(10)))

控制器代码

 [UserAuthorize(FuncID.Repair_View)]
    public ActionResult CallRepairList([DataSourceRequest] DataSourceRequest request)
    {
        using (var handlerSupervisor = new LinesupervisoridHandler())
        using (var handlerMachine = new MachineHandler())
        using (var handler = new RepairHandler())
        {
            var user = UserSession.Account.Id;
        

            var list = handler.GetCallRepairList(UserSession.Plant.Id);
            return Json(list.ToDataSourceResult(request));
        }
    }

数据处理GetCallRepairList方法

增加StatusName然后赋值
StatusName = x.STATUS == 0 ? “已处理” : ( “叫修”),
再将页面代码字段
columns.Bound(c => c.Status).Filterable(false).Sortable(false).Width(60);
改为
columns.Bound(c => c.StatusName).Filterable(false).Sortable(false).Width(60);

然后实现后如图效果

ID取值从其他表取对应的数据
Defect_Id = x.DEFECT_ID
改为
Defect_Id = x.DEFECT_ID
Defect_Type = db.TROUBLES.Where(t=>t.ID==x.DEFECT_ID).Select(t=>t.NAME).FirstOrDefault(),
界面取值为
columns.Bound(c => c.Defect_Type);

赋值转换多状态

        // 临时叫修看板获取数据
        public List<TempCall> GetTempcallRepairList(decimal? plantId = null)
        {
            var handlerFile = new FileHandler();

            var getList = GetTemporaryRepair(plantId).ToList().Select(x => new TempCall()
            {
                Id = (int)x.ID,
                Tempcall_No = x.TEMPCALL_NO,
                Machine_Id = x.MACHINE_ID,
                Pdline_Id = x.PDLINE_ID,
                Process_Id = x.PROCESS_ID,
                Terminal_Id = x.TERMINAL_ID,
                Defect_Type = x.DEFECT_TYPE,
                Defect_Desc = x.DEFECT_DESC,
                Defect_Time = x.DEFECT_TIME,
                Confirm_Info = x.CONFIRM_INFO,
                Confirm_By = x.CONFIRM_BY,
                Confirm_Time = x.CONFIRM_TIME,
                Call_Repair_No = x.CALL_REPAIR_NO,
                Deleteflag = x.DELETEFLAG,
                Status = x.STATUS,
                StatusName = x.STATUS == 0 ? "未处理" : (x.STATUS == 1 ? "EMS叫修" : "NDF"),
                PlantId = x.PLANTID
            }).OrderByDescending(x => x.Defect_Time).ToList();
            return getList;
        }

Status=Convert.ToString(x.Status == 0 ? “待保养” : (x.Status == 2 ? “保养中”: (x.Status == 3 ? “保养完”:“未知状态”)))

实现效果