From bd48f9e9e9176ea5d098415fab572b34166aec26 Mon Sep 17 00:00:00 2001 From: username@email.com <yzy2002yzy@163.com> Date: 星期二, 18 一月 2022 10:26:09 +0800 Subject: [PATCH] 专家培训合同打印 --- zhengcaioa/zhengcaioa/Views/OrderBanciOrder/Indexzhuanjia.cshtml | 12 + zhengcaioa/zhengcaioa/Controllers/BusinessOrder/OrderBanciOrderController.cs | 28 ++++ zhengcaioa/Model/zcUserInfoN_db/FrameworkUser.cs | 31 +++++ zhengcaioa/zhengcaioa/Views/OrderBanciOrder/Printhetong.cshtml | 230 ++++++++++++++++++++++++++++++++++++++ zhengcaioa/IServices/ICooperOrderService.cs | 3 zhengcaioa/Model/zcUserInfoN_db/zcUserInfoN_dbContext.cs | 37 ++++++ zhengcaioa/Services/CooperOrderService.cs | 13 ++ 7 files changed, 350 insertions(+), 4 deletions(-) diff --git a/zhengcaioa/IServices/ICooperOrderService.cs b/zhengcaioa/IServices/ICooperOrderService.cs index 75d2cf0..62931ab 100644 --- a/zhengcaioa/IServices/ICooperOrderService.cs +++ b/zhengcaioa/IServices/ICooperOrderService.cs @@ -90,5 +90,8 @@ //鑾峰彇璐ㄧ枒鎶曡瘔鐨勬鏁� List<CooperOrderDTO> GetListComplaintsDisputeCount(string huiyuanid); + //鑾峰彇浼氬憳淇℃伅 + FrameworkUser GetFrameworkUsers(string ID); + } } diff --git a/zhengcaioa/Model/zcUserInfoN_db/FrameworkUser.cs b/zhengcaioa/Model/zcUserInfoN_db/FrameworkUser.cs new file mode 100644 index 0000000..9fcb2d5 --- /dev/null +++ b/zhengcaioa/Model/zcUserInfoN_db/FrameworkUser.cs @@ -0,0 +1,31 @@ +锘縰sing System; +using System.Collections.Generic; + +#nullable disable + +namespace zhengcaioa.Models +{ + public partial class FrameworkUser + { + public Guid Id { get; set; } + public string Email { get; set; } + public int? Gender { get; set; } + public string CellPhone { get; set; } + public string HomePhone { get; set; } + public string Address { get; set; } + public string ZipCode { get; set; } + public int IsIndividual { get; set; } + public DateTime? CreateTime { get; set; } + public string CreateBy { get; set; } + public DateTime? UpdateTime { get; set; } + public string UpdateBy { get; set; } + public string Itcode { get; set; } + public string Password { get; set; } + public string Name { get; set; } + public bool IsValid { get; set; } + public Guid? PhotoId { get; set; } + public string TenantCode { get; set; } + public string WxOpenid { get; set; } + public int? Agent { get; set; } + } +} diff --git a/zhengcaioa/Model/zcUserInfoN_db/zcUserInfoN_dbContext.cs b/zhengcaioa/Model/zcUserInfoN_db/zcUserInfoN_dbContext.cs index 598d78e..7f01ea7 100644 --- a/zhengcaioa/Model/zcUserInfoN_db/zcUserInfoN_dbContext.cs +++ b/zhengcaioa/Model/zcUserInfoN_db/zcUserInfoN_dbContext.cs @@ -19,6 +19,7 @@ public virtual DbSet<GadeRole> GadeRoles { get; set; } public virtual DbSet<UsergGadeRole> UsergGadeRoles { get; set; } + public virtual DbSet<FrameworkUser> FrameworkUsers { get; set; } protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) { @@ -85,6 +86,42 @@ .HasForeignKey(d => d.UserGadeRolesId); }); + modelBuilder.Entity<FrameworkUser>(entity => + { + entity.HasIndex(e => e.PhotoId, "IX_FrameworkUsers_PhotoId"); + + entity.Property(e => e.Id) + .ValueGeneratedNever() + .HasColumnName("ID"); + + entity.Property(e => e.Address).HasMaxLength(200); + + entity.Property(e => e.Agent).HasComment("鏄惁鏃朵唬鐞嗗晢?0 涓烘櫘閫氬鎴� 1涓轰唬鐞嗗晢"); + + entity.Property(e => e.CreateBy).HasMaxLength(50); + + entity.Property(e => e.Email).HasMaxLength(50); + + entity.Property(e => e.HomePhone).HasMaxLength(30); + + entity.Property(e => e.Itcode) + .IsRequired() + .HasMaxLength(50) + .HasColumnName("ITCode"); + + entity.Property(e => e.Name) + .IsRequired() + .HasMaxLength(50); + + entity.Property(e => e.Password) + .IsRequired() + .HasMaxLength(32); + + entity.Property(e => e.UpdateBy).HasMaxLength(50); + + entity.Property(e => e.WxOpenid).HasMaxLength(50); + }); + OnModelCreatingPartial(modelBuilder); } diff --git a/zhengcaioa/Services/CooperOrderService.cs b/zhengcaioa/Services/CooperOrderService.cs index 834cf60..99e418d 100644 --- a/zhengcaioa/Services/CooperOrderService.cs +++ b/zhengcaioa/Services/CooperOrderService.cs @@ -1972,5 +1972,18 @@ return query; } + + + public FrameworkUser GetFrameworkUsers(string ID) + { + + + + var entity = _zcUserInfoN_dbContext.FrameworkUsers.Find(new Guid(ID)); + + + + return entity; + } } } diff --git a/zhengcaioa/zhengcaioa/Controllers/BusinessOrder/OrderBanciOrderController.cs b/zhengcaioa/zhengcaioa/Controllers/BusinessOrder/OrderBanciOrderController.cs index 0a68126..ad1521f 100644 --- a/zhengcaioa/zhengcaioa/Controllers/BusinessOrder/OrderBanciOrderController.cs +++ b/zhengcaioa/zhengcaioa/Controllers/BusinessOrder/OrderBanciOrderController.cs @@ -29,10 +29,12 @@ private readonly IOrderBanciDtlService _orderBanciDtlService; private readonly IOrderBanciOrderService _orderBanciOrderService; private readonly IFiOrderrecievemoneyService _fiOrderrecievemoneyService; + private readonly ICooperOrderService _cooperOrderService; public OrderBanciOrderController(ILogger<OrderBanciOrderController> logger, ILiaotianService liaotianService, IOrderBanciService orderBanciService, IOrderBanciDtlService orderBanciDtlService ,IOrderBanciOrderService orderBanciOrderService - , IFiOrderrecievemoneyService fiOrderrecievemoneyService) + , IFiOrderrecievemoneyService fiOrderrecievemoneyService + , ICooperOrderService cooperOrderService) { _logger = logger; _liaotianService = liaotianService; @@ -40,6 +42,7 @@ _orderBanciDtlService = orderBanciDtlService; _fiOrderrecievemoneyService = fiOrderrecievemoneyService; _orderBanciOrderService = orderBanciOrderService; + _cooperOrderService = cooperOrderService; } [CheckLogin] @@ -145,6 +148,29 @@ } [CheckLogin] + public IActionResult Printhetong(string id = null) + { + var curentuser = JsonConvert.DeserializeObject<PltUser>(HttpContext.Session.GetString("User")); + ViewData["curentuser"] = curentuser; + + //鎶曡瘔涔� + var orderBanciOrderDTO = _orderBanciOrderService.Get(id); + + + var frameworkUser = _cooperOrderService.GetFrameworkUsers(orderBanciOrderDTO.PersonId); + if (frameworkUser != null) + { + orderBanciOrderDTO.Xingming = frameworkUser.Name; + orderBanciOrderDTO.Lianxidianhua = frameworkUser.Itcode; + } + + + + ViewData.Model = orderBanciOrderDTO; + return View(); + } + + [CheckLogin] public IActionResult print(OrderBanciOrderDTOSearch search) { //JsonResult jsonResult = new JsonResult(_liaotianService.SearchByPaging(search), new Newtonsoft.Json.Serialization.DefaultContractResolver()); diff --git a/zhengcaioa/zhengcaioa/Views/OrderBanciOrder/Indexzhuanjia.cshtml b/zhengcaioa/zhengcaioa/Views/OrderBanciOrder/Indexzhuanjia.cshtml index d951b06..eec413e 100644 --- a/zhengcaioa/zhengcaioa/Views/OrderBanciOrder/Indexzhuanjia.cshtml +++ b/zhengcaioa/zhengcaioa/Views/OrderBanciOrder/Indexzhuanjia.cshtml @@ -27,10 +27,16 @@ { label: '瀛﹁垂', name: 'Xuefei', labtype: 'txt', hidden: false, width: 70 }, { label: '鎶ュ悕浜烘暟', name: 'Baomingrenshu', labtype: 'txt', hidden: false, width: 50 }, //{ label: '閲戦', name: 'Jine', labtype: 'txt', hidden: false, width: 100 }, - + { + label: '鎵撳嵃鍚堝悓', name: 'dayin', labtype: 'txt', hidden: false, width: 70 + , + formatter: function (cellvalue, options, rowObject) { + return "<a onclick=\"OpenWindow('鎵撳嵃鍚堝悓','100%','100%', '/OrderBanciOrder/Printhetong?id=" + rowObject.Id + "')\" >鎵撳嵃鍚堝悓</a>"; + } + }, ]; - dataUrl = "/OrderBanciOrder/GetList?Kechengleixings=0,1,2&Baomingtime=" + Baomingtimebegin + "|" + Baomingtimeend; + dataUrl = "/OrderBanciOrder/GetList?Kechengleixings=0,1,2,4,5,6&Baomingtime=" + Baomingtimebegin + "|" + Baomingtimeend; searchCol = [ { label: '鎶ュ悕鏃堕棿', name: 'Baomingtime', labtype: 'datearea', hidden: false }, { label: '鍩硅鐝', name: 'Peixunbanci', labtype: 'txt', hidden: false }, @@ -49,7 +55,7 @@ //} var _pageSearch = function () { $("#jqGrid").jqGrid('setGridParam', { - url: '/OrderBanciOrder/GetList?Kechengleixings=0,1,2', postData: jsons, page: 1 + url: '/OrderBanciOrder/GetList?Kechengleixings=0,1,2,4,5,6', postData: jsons, page: 1 }); //閲嶆柊杞藉叆 var jsons = GetSearchEnd(); if (jsons == false) { diff --git a/zhengcaioa/zhengcaioa/Views/OrderBanciOrder/Printhetong.cshtml b/zhengcaioa/zhengcaioa/Views/OrderBanciOrder/Printhetong.cshtml new file mode 100644 index 0000000..35a6112 --- /dev/null +++ b/zhengcaioa/zhengcaioa/Views/OrderBanciOrder/Printhetong.cshtml @@ -0,0 +1,230 @@ +锘緻model DTO.OrderBanciOrderDTO +@using DTO; +@using zhengcaioa.Models; +@{ + + + + +} +@{ + Layout = null; +} + +<!DOCTYPE html> +<html> +<head> + <meta charset="utf-8"> + <meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0"> + <meta name="description" content=""> + <meta name="author" content="ThemeBucket"> + <title>@(SiteConfig.SiteName)</title> + <link href="~/css/bootstrap.min.css" rel="stylesheet"> + <link href="~/css/font-awesome.min.css" rel="stylesheet"> + <link href="~/css/animate.min.css" rel="stylesheet"> + + @*<link href="~/css/plugins/iCheck/custom.css" rel="stylesheet">*@ + <link href="~/css/style.min.css" rel="stylesheet"> + <link href="~/css/plugins/chosen/chosen.css" rel="stylesheet"> + @*<link href="~/js/plugins/layer/skin/layer.css" rel="stylesheet">*@ + @*<link href="~/css/plugins/datapicker/datepicker3.css" rel="stylesheet">*@ + <link href="~/css/style.min.css" rel="stylesheet"> + <link href="~/css/plugins/toastr/toastr.min.css" rel="stylesheet" /> + <link href="~/css/plugins/webuploader/webuploader.css" rel="stylesheet" /> + + + + <!-- jqgrid--> + @*<link href="~/css/plugins/jqgrid/ui.jqgrid.css" rel="stylesheet">*@ + <script language="javascript" src="~/js/jquery.min.js" type="text/javascript"></script> + <script src="~/js/bootstrap.min.js"></script> + @*<script src="~/js/plugins/bootstro/bootstro.js"></script>*@ + + <!--瀹瑰櫒--> + @*<script language="javascript" src="~/js/datehelper.js" type="text/javascript"></script>*@ + @*<script language="javascript" src="~/js/plugins/query/jquery.query-object.js" type="text/javascript"></script>*@ + @*<script language="javascript" src="~/js/plugins/iCheck/icheck.min.js" type="text/javascript"></script>*@ + <script language="javascript" src="~/js/plugins/chosen/chosen.jquery.js" type="text/javascript"></script> + @*<script language="javascript" src="~/js/plugins/datapicker/bootstrap-datepicker.js" type="text/javascript"></script>*@ + <script language="javascript" src="~/js/plugins/layer/layer.js" type="text/javascript"></script> + @*<script src="~/js/plugins/jqgrid/jquery.jqGrid.min.js" type="text/javascript"></script>*@ + @*<script src="~/js/plugins/jqgrid/i18n/grid.locale-cn.js" type="text/javascript"></script>*@ + <script src="~/js/plugins/toastr/toastr.min.js" type="text/javascript"></script> + <script src="~/js/plugins/webuploader/webuploader.min.js"></script> + + <script language="javascript" src="~/js/common-layout.js" type="text/javascript"></script> + <script src="~/js/plugins/layer/laydate/laydate.js" type="text/javascript"></script> + @*<script src="~/js/plugins/iTexbox/itextbox.js" type="text/javascript"></script>*@ + @*<script src="~/js/plugins/iuploader/iuploader.js"></script>*@ + <script src="~/js/TUJS.js"></script> +</head> +<body class="gray-bg" style="overflow:auto"> + <form id="formtest"> + <div class="wrapper wrapper-content" id="ibox-content" style="padding:15px;"> + <div class="row"> + <div id="content" style="overflow-y:auto;height:100%;background: #fff;width:850px; margin: 0 auto;"> + <div id="page1" style="page-break-after:always;"> + <table border="0" align="center" cellpadding="3" cellspacing="0"> + <tr> + <td colspan="2" style="font-family: 'SimHei';font-size: 29.3px; text-align: center">璇勫涓撳鑰冭瘯鍩硅鍗忚涔�</td> + </tr> + <tr> + <td colspan="2" align="left">鐢叉柟濮撳悕锛欯Model.Xingming</td> + </tr> + <tr> + <td colspan="2" align="left">绯荤粺鐧昏鎵嬫満鍙凤細@(Model.Lianxidianhua)</td> + </tr> + <tr> + <td colspan="2" align="left">涔欐柟锛氬洓宸濇斂閲囨嫑鎶曟爣鍜ㄨ鏈夐檺鍏徃</td> + </tr> + <tr> + <td colspan="2" align="left">鐢蹭箼鍙屾柟鐜板氨鏈夊叧涓撳鑰冭瘯鍩硅浜嬪疁杈炬垚鍗忚濡備笅锛�</td> + </tr> + <tr> + <td colspan="2" style="height:15px"></td> + </tr> + <tr> + <td colspan="2" style="font-family:'SimHei';"> 涓�銆佺敳鏂硅嚜鎰垮弬鍔犱箼鏂逛妇鍔炵殑鈥淍(Model.Peixunbanci)鈥濄�傜彮绾э細@(Model.Kechengleixing)锛涘煿璁垂鐢細@(Model.Xuefei.Value.ToString("0.##"))鍏冦��</td> + </tr> + <tr> + <td colspan="2" align="left" style="font-family:'SimHei';"> 浜屻�佺敳鏂圭殑涔夊姟锛�</td> + </tr> + <tr> + <td colspan="2" align="left"> 1銆佹姤鍚嶆椂锛屼竴娆℃�у悜涔欐柟鏀粯鍏ㄩ儴鍩硅璐圭敤锛�</td> + </tr> + <tr> + + <td colspan="2" align="left"> 2銆佷氦璐瑰悗涓嶅緱浠ヤ换浣曠悊鐢辩敵璇烽��璐广��</td> + </tr> + + <tr> + <td colspan="2" style="font-family:'SimHei';"> 涓夈�佷箼鏂圭殑涔夊姟锛�</td> + </tr> + <tr> + <td colspan="2" align="left"> 1.缁勭粐鐢叉柟鍙傚姞鐩稿叧鐝骇鐨勫煿璁��</td> + </tr> + + <tr> + <td colspan="2" align="left"> 2.涓虹敳鏂规彁渚涙姤鍚嶇畝浠嬩腑鎵胯鐨勬湇鍔°��</td> + </tr> + <tr> + <td colspan="2" align="left"> 3.涓虹敳鏂瑰紑鍏峰煿璁垂鍙戠エ銆�</td> + </tr> + + <tr> + <td colspan="2" style="font-family:'SimHei';"> 鍥涖�佸煿璁垂鏀粯鏂瑰紡</td> + </tr> + + <tr> + <td align="left" colspan="2"> 1.绾夸笂鏀粯鎴栬�呯嚎涓嬭浆璐︽敮浠樺潎鍙��</td> + </tr> + <tr> + <td align="left" colspan="2"> 2.绾夸笅杞处鏀粯鏀舵璐﹀彿锛�</td> + </tr> + <tr> + <td align="left" colspan="2"> 寮�鎴疯锛氬叴涓氶摱琛屾垚閮藉垎琛�</td> + </tr> + <tr> + <td align="left" colspan="2"> 鎴峰悕锛氬洓宸濇斂閲囨嫑鎶曟爣鍜ㄨ鏈夐檺鍏徃</td> + </tr> + <tr> + <td align="left" colspan="2"> 璐﹀彿锛�431020100101111420</td> + </tr> + <tr> + <td colspan="2" style="font-family:'SimHei';"> 浜斻�佸煿璁椂闂�</td> + </tr> + <tr> + <td align="left" colspan="2"> 浠�2022骞�3鏈堣捣鑷�2022骞村害鍥涘窛鐪佽瘎瀹′笓瀹惰�冭瘯涔嬫棩姝€��</td> + </tr> + + <tr> + <td colspan="2" style="font-family:'SimHei';"> 鍏�佸叾浠�</td> + </tr> + <tr> + <td colspan="2" align="left"> 1.鏈崗璁嚜鐢叉柟鏀粯璐圭敤璧风敓鏁堛��</td> + </tr> + <tr> + <td colspan="2" style="height:15px"> 2.鏈崗璁饱琛屼腑濡傚彂鐢熺籂绾凤紝鍙屾柟搴斿敖閲忓崗鍟嗚В鍐炽�傚崗鍟嗕笉鎴愶紝鍚戞垚閮藉競浠茶濮斿憳浼氱敵璇蜂徊瑁併��</td> + </tr> + <tr> + <td colspan="2" style="height:15px"> 3.鏈崗璁负鐢靛瓙鍚堝悓锛屽弻鏂归』璁ょ湡閬靛畧銆�</td> + </tr> + <tr> + <td colspan="2" style="height:15px"></td> + </tr> + + <tr> + <td colspan="2" align="right">绛捐鏃堕棿锛欯(Model.Baomingtime.ToString("yyyy骞碝M鏈坉d鏃�"))</td> + </tr> + </table> + </div> + + + <style type="text/css"> + table { + width: 595px; + font-size: 16pt; + font-family: 'FangSong'; + background: #fff; + line-height: 2.0; + } + + span { + font-size: 15pt; + display: inline; + border-bottom: 1px dashed #111; + } + + s22pan:after { + content: ''; + display: inline; + width: 100%; + margin-top: -5px; + border-bottom: 1px dashed #111; + } + </style> + </div> + </div> + + </div> + <div class="wrapper wrapper-content" style="margin-top:0px"></div> + <div class="ibox-content" id="top" style="z-index:100; position:fixed; height:50px; width:100%;bottom:0; text-align: right; padding-top:8px "> + <div class="" style="float:right;" data-bootstro-width="500px" data-bootstro-content="鍔熻兘鎸夐挳锛氣�滀繚瀛樷�濓紝鈥滃垹闄も��"> + + + <a class="btn btn-success" href="javascript:void(0)" onclick="printWin();" style="margin-left:4px; border-radius:4px;"> + <i class="glyphicon glyphicon-ok"></i> <span class="bold">鎵撳嵃</span> + </a> + </div> + </div> + + + + </form> + <script type="text/javascript"> + + + + function printWin() { + var oWin = window.open("", "_blank"); + var pt = document.getElementById("content").innerHTML; + + oWin.document.write(pt); + oWin.focus(); + oWin.document.close(); + oWin.print(); + oWin.close(); + return false; + } + + + + + + + + + + </script> +</body> +</html> \ No newline at end of file -- Gitblit v1.9.1