mvc 页面上循环datatable
@using System.Data;
@{
Layout = null;
}
@{
DataTable DataServiceStaff = ViewBag.ServiceStaff as DataTable;
}
<!DOCTYPE html>
<html>
<head>
<meta name="viewport" content="width=device-width" />
<title>首页</title>
<script src="@Url.Content("~/Contents/Jquery.js")" type="text/javascript"></script>
<script src="@Url.Content("~/Contents/highcharts/js/highcharts.js")" type="text/javascript"></script>
<script src="@Url.Content("~/Contents/highcharts/js/modules/exporting.js")" type="text/javascript"></script>
<link href="@Url.Content("~/Contents/Common/css/style.css")" rel="stylesheet" type="text/css" />
</head>
<body>
<div class="center">
<div id="staffDiv" class="leftcontainer">
<h6>
<img src="@Url.Content("~/Contents/Common/images/user_t.png")" />人员列表</h6>
<div class="a dumascroll ">
@* <p id="staffli"></p>*@
@if (DataServiceStaff.Rows.Count > 0)
{
foreach (DataRow row in DataServiceStaff.Rows)
{
var lastTime = DateTime.Parse(row["VC_DATATIME"].ToString()).AddMinutes(30);
if (lastTime >= DateTime.Now)
{
<p><img src="@Url.Content("~/Contents/Common/images/user.png")" />
@row["SS_REALNAME"].ToString()</p>
}
else
{
<p> <img src="@Url.Content("~/Contents/Common/images/user_h.png")" />
@row["SS_REALNAME"].ToString()</p>
}
}
}
@* <p>
<img src="@Url.Content("~/Contents/Common/images/photo.png")" />
王师傅</p>
<p>
<img src="@Url.Content("~/Contents/Common/images/photo.png")" />
王师傅</p>
<p>
<img src="@Url.Content("~/Contents/Common/images/photo.png")" />
王师傅</p>
<p>
<img src="@Url.Content("~/Contents/Common/images/photo.png")" />
王师傅</p>
*@
</div>
</div>
</div>
</body>
</html>
/// <summary>
/// 首页
/// </summary>
/// <returns></returns>
[HttpGet]
public ActionResult OverView()
{
ViewBag.ServiceStaff = bsStaff.GetTableBServiceStaff();
return View();
}
/// <summary>
/// 获取人员列表 2013-11-19
/// </summary>
/// <returns></returns>
public DataTable GetTableBServiceStaff()
{
string sql = string.Format(@"SELECT distinct * FROM
(SELECT B.SS_ID,B.SS_NAME,B.SS_REALNAME,
NVL(C.VC_DATATIME,TO_DATE('1990-1-1', 'YYYY-MM-DD')) VC_DATATIME
FROM B_SERVICE_STAFF B
LEFT JOIN RE_SERVICE_IMEI R ON B.SS_NAME=R.SS_NAME
LEFT JOIN B_VEH_SERVICE S ON R.VS_IMEI=S.VS_IMEI
LEFT JOIN B_VS_CURPOS C ON S.VS_IMEI=C.VS_IMEI )");
DataTable dt = DbAccessor.Query(sql).Tables[0];
return dt;
}
