IRapperStatis----i控制器---IRapperStatis----i控制器------IRapperStatis----i控制器------IRapperStatis----i控制器------IRapperStatis----i控制器------IRapperStatis----i控制器------
using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using System.Web;
using System.Web.Mvc;
using NNCQ.Domain;
using NNCQ.IBLL;
using NNCQ.SqlService;
namespace NNCQ.Web.Controllers.Api
{
public class IRapperStatisController : BaseController
{
// GET: IRapperStatis
private readonly IDBHelper<CertificateInfo> _GIService;
private readonly IDBHelper<WitnPerson> _WPService;
private readonly IDBHelper<ProRPerson> _PRPService;
public IRapperStatisController(IDBHelper<CertificateInfo> GIService,
IDBHelper<WitnPerson> WPService,
IDBHelper<ProRPerson> PRPService)
{
_GIService = GIService;
_WPService = WPService;
_PRPService = PRPService;
}
public ActionResult Index(int index, int size, string name, string idcard, string company)
{
var n = name.Trim();
var idc = idcard.Trim();
var c = company.Trim();
int count = 0;
var wherestr = new StringBuilder();
if (!string.IsNullOrEmpty(n))
wherestr.AppendFormat(" and Name like'%{0}%'", n);
if (!string.IsNullOrEmpty(idc))
{
wherestr.AppendFormat(" and IDCard like'%{0}%' ", idc);
}
if (!string.IsNullOrEmpty(c))
{
wherestr.AppendFormat(" and CorpName like '%{0}%' ", c);
}
var list = SqlDBHelper.Query(index, size, "*", "view_Company_WitnPerson_SysCity", wherestr.ToString(), "SortCode DESC", out count);
return Table(list, count);
}
/// <summary>
/// 获取证书信息
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ActionResult GetZhengshu(int index, int size, string id)
{
int count = 0;
var wherestr = new StringBuilder();
if (!string.IsNullOrEmpty(id))
{
wherestr.AppendFormat(" and PersonID ='{0}' ", id);
}
var list = SqlDBHelper.Query(index, size, "*", "nncq_ZhengshuInfo", wherestr.ToString(), "SortCode desc", out count);
return Table(list, count);
}
/// <summary>
/// 获取培训列表
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ActionResult TrianList(int index, int size, string id)
{
int count = 0;
var wherestr = new StringBuilder();
if (!string.IsNullOrEmpty(id))
{
wherestr.AppendFormat(" and PersonID ='{0}' ", id);
}
var list = SqlDBHelper.Query(index, size, "*", "nncq_TrainCourse", wherestr.ToString(), "SortCode desc", out count);
return Table(list, count);
}
/// <summary>
/// 见证工程列表
/// </summary>
/// <param name="index"></param>
/// <param name="size"></param>
/// <param name="id"></param>
/// <returns></returns>
public ActionResult ProjectList(int index, int size, string id)
{
int count = 0;
var wherestr = new StringBuilder();
if (!string.IsNullOrEmpty(id))
{
wherestr.AppendFormat(" and ID in (select POID from nncq_ProRPerson where PSID= '{0}') ", id);
}
var list = SqlDBHelper.Query(index, size, "*", "nncq_Project", wherestr.ToString(), "SortCode desc", out count);
return Table(list, count);
}
}
}
---------------index--------------------------------index--------------------------------index--------------------------------index--------------------------------index--------------------------------index--------
@{
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>
<select name="cityID">
<option>南宁</option>
</select>
</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="idcard" />
</td>
</tr>
<tr>
<td><label>所属机构:</label></td>
<td>
<input type="text" name="company" />
</td>
</tr>
</table>
</form>
</div>
</div>
</div>
</div>
@section Scripts{
<script src="~/Scripts/business/RapperStatis.js"></script>
<script type="text/javascript">
//其他操作
</script>
}
-------detail-------detail-------detail-------detail-------detail-------detail-------detail-------detail-------detail-------detail-------detail-------detail-------detail
<div>
<fieldset>
<legend>个人信息</legend>
<table id="personinfo" class="table" style="background:rgba(255,255,255,.15);">
<tr>
<td><label name="PersonType" fm-conver="converType"></label></td>
<td><span name="Name"></span></td>
<td><label>所属机构:</label></td>
<td><span name="CorpName"></span></td>
</tr>
</table>
@*<label id="rs_peopletype">见证员:</label><span name="Name"></span><label>所属机构:</label><span name="CorpName"></span>*@
</fieldset>
</div>
<div class="fm-tab" id="RStatisTab">
<div class="tab-content">
<div data-name="发证情况分析">
<div id="table-Issuing-list"></div>
</div>
<div data-name="培训情况分析">
<div id="table-Train-list"></div>
</div>
<div data-name="见证工程分析">
<div id="table-Project-list"></div>
</div>
</div>
</div>
<script>
function converType(d) {
if (d == 0) {
return "见证员:";
}
else if(d==1){
return "取样员:";
}
}
</script>
-----js-------js-------js-------js-------js-------js-------js-------js-------js-------js-------js-------js-------js-------js-------js-------js-------js-------js-------js-------js--
$(document).ready(function () {
var personrow;
var table = $("#table-list").uTable({
url: "IRapperStatis",
click: function (r) {
personrow = r;
},
heads: [{ num: true, name: "序号" },
{ key: "CityName", name: "地区" },
{ key: "Name", name: "姓名" },
{ key: "CorpName", name: "所属机构名称" },
{ key: "IDCard", name: "身份证号" },
{ key: "Duties", name: "职务" },
{ key: "JobTitle", name: "职称" },
{ html: '<a href="javascript:" class="read" data-id="{{ID}}" >查看</a>', name: "操作" }
]
});
//查看
$("#table-list").on("click", ".read", function () {
var uid = $(this).attr("data-id");
$.layout.detail("VRapperStatis/Detail", function () {
$("#personinfo").detail({
data: personrow
});
$("#RStatisTab").utab({
click: function (i) {
switch (i) {
case 1:
TrainList();
break;
case 2:
ProjectList();
break;
default:
}
}
});
var zstable = $("#table-Issuing-list").uTable({
url: "IRapperStatis/GetZhengshu?id=" + uid,
heads: [{ num: true, name: "序号" },
{ key: "ZhengTyPe", name: "证书类别" },
{ key: "ZhengNum", name: "证书编号" },
{ key: "ZhengName", name: "证书名称" },
{ key: "FazhOrganiza", name: "颁发机构" },
{ key: "FaZhengDate", conver: "converTime", name: "颁发时间" },
{ key: "ZhengEndDate",conver: "converTime",name: "证书有效期" },//格式 2014-1-1~2016-1-1
{ html: '<a href="javascript:" class="fujian_show" data-aid="{{ZhengAtta}}" ><i class="icon-search"></i></a>', name: "证书附件" }//弹出附件列表框
]
});
///培训列表
function TrainList()
{
var zstable = $("#table-Train-list").uTable({
url: "IRapperStatis/TrianList?id=" + uid,
heads: [
{ key: "TrainStartDate", conver: "converTime", name: "培训时间" },
{ key: "TrainOrg", name: "主办单位" },
{ key: "TrainContent", name: "培训内容" },
{ key: "TrainHour", name: "培训课时" },
{ key: "TrainWay", name: "培训方法" },
{ key: "TrainAim", name: "培训目标" }
]
});
}
///见证工程列表
function ProjectList() {
var zstable = $("#table-Project-list").uTable({
url: "IRapperStatis/ProjectList?id=" + uid,
heads: [
{ key: "Name", name: "工程名称" },
{ key: "Address", name: "工程地址" },
{ key: "EngineeringType", name: "工程类型" },
{ key: "BuildGeneral", name: "施工单位" },
{ key: "StartTime", conver: "converTime", name: "开工时间" },
{ html: '<a href="javascript:" class="read" data-id="{{ID}}" >查看</a>', name: "试验记录" }//弹出列表框
]
});
}
});
});
// 查看附件
$("body").on("click", ".fujian_show", function () {
var id = $(this).attr("data-aid");
_showAccessories(id);
})
});
//截取时间
function converTime(d) {
return d.substring(0, 10)
}