MVC DateTable 直接显示在页面上
来源:互联网 发布:斗牛seo官网 编辑:程序博客网 时间:2024/06/06 01:03
@using System.Data;
@{
Layout = null;
}
<!DOCTYPE html>
<html>
<head>
<meta name="viewport" content="width=device-width" />
<title>Index</title>
@*<script src="~/Scripts/jquery-1.8.2.min.js"></script>*@
<script src="~/Scripts/jquery-1.10.2.js"></script>
<script src="~/Scripts/bootstrap.min.js"></script>
<link href="~/Content/bootstrap.css" rel="stylesheet" />
<style type="text/css">
.det {
display: flex;
padding-left: 50px;
}
.det > div {
flex:1;
}
</style>
</head>
<body>
<div class="container-fluid" style="margin-top:30px">
<div class="row">
<div class="col-md-12">
<form class="form-inline" action="/MCWeb5/AppUse" role="form">
<div class="row">
<div class="col-md-3">
<input type="text" style="width:300px" class="form-control" value="@ViewBag.address" name="address" id="address" placeholder="地区 (例如:'甘肃')">
</div>
<div class="col-md-3">
<input type="text" style="width:300px" class="form-control" value="@ViewBag.starttime" name="starttime" id="starttime" placeholder="开始时间 (例如:2012-06-15 14:45)">
</div>
<div class="col-md-3">
<input type="text" style="width:300px" class="form-control" value="@ViewBag.endtime" name="endtime" id="endtime" placeholder="结束时间 (例如:2012-06-15 14:45)">
</div>
<div class="col-md-1">
查看详细:<input type="checkbox" style="width:80px" class="form-control" value="checked" checked="@ViewBag.detail" name="detail" id="detail" placeholder="结束时间 (例如:2012-06-15 14:45)">
</div>
<div class="col-md-2">
<button type="submit" class="btn btn-default">查看</button>
</div>
</div>
@*<input size="16" type="text" name="starttime" value=" @ViewBag.starttime" readonly class=" form_datetime">
<input size="16" type="text" name="endtime" value="@ViewBag.endtime" readonly class="form_datetime">*@
</form>
@Model.Rows.Count 条数据
@ViewBag.detail
<table class="table table-hover">
<tr>
@foreach (DataColumn dc in Model.Columns)
{
<th>
@dc.ColumnName
@if (dc.ColumnName.Equals("登陆次数"))
{
<span>[</span>
@Model.Compute("sum(登陆次数)", "").ToString();
<span>人次]</span>
}
</th>
}
</tr>
<tbody>
@foreach (DataRow ro in Model.Rows)
{
<tr onclick="loadDetail(this)">
@foreach (DataColumn dc1 in Model.Columns)
{
<td class="success">
@ro[dc1.ColumnName]
</td>
}
</tr>
@*<tr class="detail">
<td colspan="@Model.Columns.Count">
<div class="det">
<div>张三</div>
<div>100</div>
</div>
</td>
</tr>*@
}
<tr class="danger">
<td> 对外低管道登陆成功次数:
@ViewBag.wainum
</td>
</tr>
</tbody>
</table>
</div>
</div>
<div class="sq" style="display:none">
@ViewBag.sql
</div>
</div>
<script type="text/javascript">
$(function () {
$(".detail").hide();
});
function loadDetail(tr) {
if (!$("#detail")[0].checked && $("#address").val=="")
{
return;
}
var text = $.trim(tr.children[1].innerHTML);
var url = "/MCWeb5/AppUse/AppUseDetail";
var sfForm = document.createElement("form");
document.body.appendChild(sfForm);
createInput(sfForm, "text", "name", text);
createInput(sfForm, "text", "sql", $(".sq")[0].innerHTML.trim());
sfForm.method = "post";
sfForm.action = url;
sfForm.hidden = "true";
sfForm.submit();
}
function createInput(sfForm, type, name, value) {
var tmpInput = document.createElement("input");
tmpInput.type = type;
tmpInput.name = name;
if (value != undefined) {
if (value == "") {
tmpInput.value = "";
} else if (value.startsWith("{") && value.endsWith("}")) {
tmpInput.value = encodeURIComponent(value);
}
else {
tmpInput.value = value;
}
} else {
tmpInput.value = "";
}
sfForm.appendChild(tmpInput);
}
</script>
</body>
</html>
@{
Layout = null;
}
<!DOCTYPE html>
<html>
<head>
<meta name="viewport" content="width=device-width" />
<title>Index</title>
@*<script src="~/Scripts/jquery-1.8.2.min.js"></script>*@
<script src="~/Scripts/jquery-1.10.2.js"></script>
<script src="~/Scripts/bootstrap.min.js"></script>
<link href="~/Content/bootstrap.css" rel="stylesheet" />
<style type="text/css">
.det {
display: flex;
padding-left: 50px;
}
.det > div {
flex:1;
}
</style>
</head>
<body>
<div class="container-fluid" style="margin-top:30px">
<div class="row">
<div class="col-md-12">
<form class="form-inline" action="/MCWeb5/AppUse" role="form">
<div class="row">
<div class="col-md-3">
<input type="text" style="width:300px" class="form-control" value="@ViewBag.address" name="address" id="address" placeholder="地区 (例如:'甘肃')">
</div>
<div class="col-md-3">
<input type="text" style="width:300px" class="form-control" value="@ViewBag.starttime" name="starttime" id="starttime" placeholder="开始时间 (例如:2012-06-15 14:45)">
</div>
<div class="col-md-3">
<input type="text" style="width:300px" class="form-control" value="@ViewBag.endtime" name="endtime" id="endtime" placeholder="结束时间 (例如:2012-06-15 14:45)">
</div>
<div class="col-md-1">
查看详细:<input type="checkbox" style="width:80px" class="form-control" value="checked" checked="@ViewBag.detail" name="detail" id="detail" placeholder="结束时间 (例如:2012-06-15 14:45)">
</div>
<div class="col-md-2">
<button type="submit" class="btn btn-default">查看</button>
</div>
</div>
@*<input size="16" type="text" name="starttime" value=" @ViewBag.starttime" readonly class=" form_datetime">
<input size="16" type="text" name="endtime" value="@ViewBag.endtime" readonly class="form_datetime">*@
</form>
@Model.Rows.Count 条数据
@ViewBag.detail
<table class="table table-hover">
<tr>
@foreach (DataColumn dc in Model.Columns)
{
<th>
@dc.ColumnName
@if (dc.ColumnName.Equals("登陆次数"))
{
<span>[</span>
@Model.Compute("sum(登陆次数)", "").ToString();
<span>人次]</span>
}
</th>
}
</tr>
<tbody>
@foreach (DataRow ro in Model.Rows)
{
<tr onclick="loadDetail(this)">
@foreach (DataColumn dc1 in Model.Columns)
{
<td class="success">
@ro[dc1.ColumnName]
</td>
}
</tr>
@*<tr class="detail">
<td colspan="@Model.Columns.Count">
<div class="det">
<div>张三</div>
<div>100</div>
</div>
</td>
</tr>*@
}
<tr class="danger">
<td> 对外低管道登陆成功次数:
@ViewBag.wainum
</td>
</tr>
</tbody>
</table>
</div>
</div>
<div class="sq" style="display:none">
@ViewBag.sql
</div>
</div>
<script type="text/javascript">
$(function () {
$(".detail").hide();
});
function loadDetail(tr) {
if (!$("#detail")[0].checked && $("#address").val=="")
{
return;
}
var text = $.trim(tr.children[1].innerHTML);
var url = "/MCWeb5/AppUse/AppUseDetail";
var sfForm = document.createElement("form");
document.body.appendChild(sfForm);
createInput(sfForm, "text", "name", text);
createInput(sfForm, "text", "sql", $(".sq")[0].innerHTML.trim());
sfForm.method = "post";
sfForm.action = url;
sfForm.hidden = "true";
sfForm.submit();
}
function createInput(sfForm, type, name, value) {
var tmpInput = document.createElement("input");
tmpInput.type = type;
tmpInput.name = name;
if (value != undefined) {
if (value == "") {
tmpInput.value = "";
} else if (value.startsWith("{") && value.endsWith("}")) {
tmpInput.value = encodeURIComponent(value);
}
else {
tmpInput.value = value;
}
} else {
tmpInput.value = "";
}
sfForm.appendChild(tmpInput);
}
</script>
</body>
</html>
0 0
- MVC DateTable 直接显示在页面上
- mvc在页面上显示PDF
- 直接在页面上显示Extjs日期空间
- Spring MVC访问页面直接显示源码
- PHP: WordPress 之 在注册界面 实现 注册后密码直接显示在页面上
- jsp图片上传到数据库里面之后,不能直接在页面上显示,而是提示下载
- 读取数据库中数据,在页面上直接显示图片(点击该图片变大)
- js的直接显示在页面
- 上传控件图片直接在页面显示
- 在页面上显示音标
- 在页面上显示倒计时
- Github上显示出demo,直接显示html页面
- 直接在网页上显示word2007文档
- 一维码,直接显示在网页上不直接写图片
- 在WEB页面上显示进度条
- JAVA流在页面上显示图片
- 在页面上显示系统时间
- JavaScript在页面上显示时间钟表
- 【转】H5页面的测试点总结
- 1039. 到底买不买(20)
- Corpora and Vector Spaces
- 多行文本溢出显示省略号(…)全攻略
- Android .9.png图片的制作与使用
- MVC DateTable 直接显示在页面上
- maven的配置for Windows
- android中的文件操作详解以及内部存储和外部存储
- Android 自定义视图总结
- 在二叉查找树中插入节点
- centos 下 mariadb 表不区分大小写
- 安装PlistBuddy
- 我写过代码
- Excel 生成随机数,随机日期,随机字符串