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';">&nbsp;&nbsp;&nbsp;&nbsp;涓�銆佺敳鏂硅嚜鎰垮弬鍔犱箼鏂逛妇鍔炵殑鈥淍(Model.Peixunbanci)鈥濄�傜彮绾э細@(Model.Kechengleixing)锛涘煿璁垂鐢細@(Model.Xuefei.Value.ToString("0.##"))鍏冦��</td>
+                            </tr>
+                            <tr>
+                                <td colspan="2" align="left" style="font-family:'SimHei';">&nbsp;&nbsp;&nbsp;&nbsp;浜屻�佺敳鏂圭殑涔夊姟锛�</td>
+                            </tr>
+                            <tr>
+                                <td colspan="2" align="left">&nbsp;&nbsp;&nbsp;&nbsp;1銆佹姤鍚嶆椂锛屼竴娆℃�у悜涔欐柟鏀粯鍏ㄩ儴鍩硅璐圭敤锛�</td>
+                            </tr>
+                            <tr>
+
+                                <td colspan="2" align="left">&nbsp;&nbsp;&nbsp;&nbsp;2銆佷氦璐瑰悗涓嶅緱浠ヤ换浣曠悊鐢辩敵璇烽��璐广��</td>
+                            </tr>
+
+                            <tr>
+                                <td colspan="2" style="font-family:'SimHei';">&nbsp;&nbsp;&nbsp;&nbsp;涓夈�佷箼鏂圭殑涔夊姟锛�</td>
+                            </tr>
+                            <tr>
+                                <td colspan="2" align="left">&nbsp;&nbsp;&nbsp;&nbsp;1.缁勭粐鐢叉柟鍙傚姞鐩稿叧鐝骇鐨勫煿璁��</td>
+                            </tr>
+
+                            <tr>
+                                <td colspan="2" align="left">&nbsp;&nbsp;&nbsp;&nbsp;2.涓虹敳鏂规彁渚涙姤鍚嶇畝浠嬩腑鎵胯鐨勬湇鍔°��</td>
+                            </tr>
+                            <tr>
+                                <td colspan="2" align="left">&nbsp;&nbsp;&nbsp;&nbsp;3.涓虹敳鏂瑰紑鍏峰煿璁垂鍙戠エ銆�</td>
+                            </tr>
+
+                            <tr>
+                                <td colspan="2" style="font-family:'SimHei';">&nbsp;&nbsp;&nbsp;&nbsp;鍥涖�佸煿璁垂鏀粯鏂瑰紡</td>
+                            </tr>
+
+                            <tr>
+                                <td align="left" colspan="2">&nbsp;&nbsp;&nbsp;&nbsp;1.绾夸笂鏀粯鎴栬�呯嚎涓嬭浆璐︽敮浠樺潎鍙��</td>
+                            </tr>
+                            <tr>
+                                <td align="left" colspan="2">&nbsp;&nbsp;&nbsp;&nbsp;2.绾夸笅杞处鏀粯鏀舵璐﹀彿锛�</td>
+                            </tr>
+                            <tr>
+                                <td align="left" colspan="2">&nbsp;&nbsp;&nbsp;&nbsp;寮�鎴疯锛氬叴涓氶摱琛屾垚閮藉垎琛�</td>
+                            </tr>
+                            <tr>
+                                <td align="left" colspan="2">&nbsp;&nbsp;&nbsp;&nbsp;鎴峰悕锛氬洓宸濇斂閲囨嫑鎶曟爣鍜ㄨ鏈夐檺鍏徃</td>
+                            </tr>
+                            <tr>
+                                <td align="left" colspan="2">&nbsp;&nbsp;&nbsp;&nbsp;璐﹀彿锛�431020100101111420</td>
+                            </tr>
+                            <tr>
+                                <td colspan="2" style="font-family:'SimHei';">&nbsp;&nbsp;&nbsp;&nbsp;浜斻�佸煿璁椂闂�</td>
+                            </tr>
+                            <tr>
+                                <td align="left" colspan="2">&nbsp;&nbsp;&nbsp;&nbsp;浠�2022骞�3鏈堣捣鑷�2022骞村害鍥涘窛鐪佽瘎瀹′笓瀹惰�冭瘯涔嬫棩姝€��</td>
+                            </tr>
+
+                            <tr>
+                                <td colspan="2" style="font-family:'SimHei';">&nbsp;&nbsp;&nbsp;&nbsp;鍏�佸叾浠�</td>
+                            </tr>
+                            <tr>
+                                <td colspan="2" align="left">&nbsp;&nbsp;&nbsp;&nbsp;1.鏈崗璁嚜鐢叉柟鏀粯璐圭敤璧风敓鏁堛��</td>
+                            </tr>
+                            <tr>
+                                <td colspan="2" style="height:15px">&nbsp;&nbsp;&nbsp;&nbsp;2.鏈崗璁饱琛屼腑濡傚彂鐢熺籂绾凤紝鍙屾柟搴斿敖閲忓崗鍟嗚В鍐炽�傚崗鍟嗕笉鎴愶紝鍚戞垚閮藉競浠茶濮斿憳浼氱敵璇蜂徊瑁併��</td>
+                            </tr>
+                            <tr>
+                                <td colspan="2" style="height:15px">&nbsp;&nbsp;&nbsp;&nbsp;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>&nbsp;&nbsp;<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