将TRUE FALSE转换为YES NO [英] Converting TRUE FALSE to YES NO

问题描述

我从SQL服务器ISApproved字段中选择BIT字段，该字段存储0,1，但是当我在C＃中选择它时，它在列中显示为TRUE FALSE但是我想要YES NO而不是它。

i am picking BIT field from SQL server ISApproved field which stores 0 , 1 but when i pick it in my C# then it shows TRUE FALSE in column but i want YES NO instead of it.

CODE:

public ActionResult ShowHrEmployeeRec(int? EmplID = null)
        {
            if (!String.IsNullOrEmpty(Session["Admin"] as string))
            {

                IEnumerable<GetHrEmployeeResult> HrEmployee = DataContext.GetHrEmployee(EmplID).ToList();
                ViewBag.Month = Request.QueryString["Month"];
                return View(HrEmployee);
            }
            else
            {
                return RedirectToAction("IsAuth_Page", "Home");
            }
VIEW:

 @{
 
     var grid = new WebGrid(ViewData.Model, defaultSort: "EmplID", rowsPerPage: 1);
    
  }

  @if (Model.Count > 0)
  {
      <div id="AllEmpGrid_ByName">
       @grid.GetHtml(columns: grid.Columns(
                                            grid.Column("EmplID", "Employee ID"),
                                            grid.Column("EmplName", "Employee Name"),
                                            grid.Column("DeptName", "Department"),
                                            grid.Column("ShiftName", "Shift"),
                                            grid.Column("EntryDate", "Entry Date"),
                                            grid.Column("BasicSalary", "Basic Salary"),
                                            grid.Column("EmailAdd", "Email"),
                                            grid.Column("OvertimeApproved", "Overtime Approval")
                                           ))
     </div>
  }

推荐答案

最简单的方法是在数据库端。

The easiest way to do this is on the database side.

SELECT IIF(IsApproved, "YES", "NO") AS OvertimeApproved

使用案例 [ ^ ]声明在你的SQL查询中。



例如

Use the CASE[^] statement in your SQL query.

e.g.

select col1, col2 = case when IsApproved != 0 then "yes" else "no" end, col 3 from mytable

你可以做到像这样的MVC WEB GRID。

you can do it in MVC WEB GRID like this.

grid.Column("OvertimeApproved", header: "Overtime Approval",
                     format:
                    @<text> 
                            @if(item.IsApproved)
                            {
                                <span>Yes</span>
                            }
                            else
                            {
                                <span>No</span>
                            }
                    </text>
                    )

这篇关于将TRUE FALSE转换为YES NO的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！