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) }