检测人员档案信息的全部显示。
这里分析科长的框架结构是 V控制器 跳转到页面 有一个API接口处理数据交互,前段cshtml写查询窗口以及table-list,又通过js 接收I控制器返回的一个table
==================
前端Index.cshtml
@{
ViewBag.Title = "检测人员档案管理";
}
<div class="row layout-list">
<div class="col-lg-12 col-md-12">
<div id="table-list">
<div class="table-search">
<form fm-search>
<table>
<tr>
<td><label>所属机构:</label></td>
<td>
<input type="text" name="name" />
</td>
</tr>
<tr>
<td><label>身份证:</label></td>
<td>
<input type="text" name="name" />
</td>
</tr>
<tr>
<td><label>姓名:</label></td>
<td>
<input type="text" name="name" />
</td>
</tr>
</table>
</form>
</div>
</div>
</div>
</div>
@section Scripts{
<script src="~/Scripts/business/TestersArchives.js"></script>
<script type="text/javascript">
//其他操作
</script>
}
========================
I控制器
public class ITestersArchivesController : BaseController
{
// GET: ITestersArchives
public ActionResult Index(int index, int size)
{
int count = 0;
string where = "";
var list = SqlDBHelper.Query(index, size, "*", "t_hr_people_sl", where, "Selfnum desc", out count);
return Table(list, count);
}
public ActionResult Get(string id)
{
string sql = "select *from t_hr_people_sl where id=@id";
SqlParameter[] paras = new SqlParameter[] { new SqlParameter("@id", id) };
DataTable bo = SqlDBHelper.Query(sql, paras);
var js = JsonConvert.SerializeObject(bo); //这里转成了json 字符串,需要在到js里面转成json
return JsonData(new { Comp = js });
}
}
=====================
js
$(document).ready(function () {
var table = $("#table-list").uTable({
url: "ITestersArchives",
page: {
pageSize: 20,
reqindex: "index",
reqsize: "size"
},
heads: [{ key: "username", name: "姓名" },
{ key: "unitname", name: "所属机构名称" },
{ key: "selfnum", name: "身份证号码" },
{ key: "sex", name: "性别" },
{ key: "phone", name: "手机号码" },
{ html: '<a href="javascript:" class="read EQ-btn" data-id="{{ID}}" >查看</a> <a href="javascript:" ', name: "操作" }
/// { html: '<a href="javascript:" class="read EQ-btn" data-id="{{ID}}" >查看</a> <a href="javascript:" class="edit" data-id="{{ID}}" >修改</a> <a href="javascript:" class="view" data-id="{{ID}}" >见证</a> <a href="javascript:" class="completed" data-id="{{ID}}" >竣工</a>', name: "操作" }
]
});
//只读查看
$("#table-list").on("click", ".read", function () {
var id = $(this).attr("data-id");
$.layout.detail("VTestersArchives/Detail", function () {
$.get("ITestersArchives/Get", { id: id }, function (d) {
var jsond = stringToJSON(d.Comp);
$("#edit-form").Form({
data: jsond[0],
disabled: true
});
});
});
});
});
=============
V控制器
public class VTestersArchivesController : Controller
{
// GET: VTestersArchives
public ActionResult Index()
{
return View();
}
}