From 0c7b13e91cd472e21e4a620355e6fcabc11f695a Mon Sep 17 00:00:00 2001 From: username@email.com <yzy2002yzy@163.com> Date: 星期二, 04 一月 2022 13:56:24 +0800 Subject: [PATCH] 计件登记,汇总,打印 --- zhengcaioa/zhengcaioa/Views/SalaryCheck/Employee.cshtml | 4 + zhengcaioa/zhengcaioa/Views/AdmAttendance/Index.cshtml | 4 + zhengcaioa/Services/AdmPieceCheckService.cs | 4 + zhengcaioa/zhengcaioa/Views/SalaryCheck/Index.cshtml | 4 + zhengcaioa/zhengcaioa/Views/AdmPieceCheck/printList.cshtml | 128 ++++++++++++++++++++++++++++++++ zhengcaioa/zhengcaioa/Controllers/admin/AdmPieceCheckController.cs | 27 ++++++ zhengcaioa/zhengcaioa/Views/AdmPieceCheck/Index.cshtml | 27 ++++++ 7 files changed, 197 insertions(+), 1 deletions(-) diff --git a/zhengcaioa/Services/AdmPieceCheckService.cs b/zhengcaioa/Services/AdmPieceCheckService.cs index 3f3b384..1696c5d 100644 --- a/zhengcaioa/Services/AdmPieceCheckService.cs +++ b/zhengcaioa/Services/AdmPieceCheckService.cs @@ -199,7 +199,11 @@ //if (searchEntity.totalrows == 0) searchEntity.totalrows = query.Count(); + data.Heji1 = Math.Round(query.Sum(x => x.Gongzi) ?? 0, 2); + data.Heji2 = Math.Round(query.Sum(x => x.Shuliang ?? 0), 2); var lianlist = query.Skip((searchEntity.page - 1) * searchEntity.rows).Take(searchEntity.rows).ToList(); + data.DangyeHeji1 = Math.Round(lianlist.Sum(x => x.Gongzi) ?? 0, 2); + data.DangyeHeji2 = Math.Round(lianlist.Sum(x => x.Shuliang ?? 0), 2); data.LoadData(searchEntity, lianlist); return data; } diff --git a/zhengcaioa/zhengcaioa/Controllers/admin/AdmPieceCheckController.cs b/zhengcaioa/zhengcaioa/Controllers/admin/AdmPieceCheckController.cs index a6f34b5..d682322 100644 --- a/zhengcaioa/zhengcaioa/Controllers/admin/AdmPieceCheckController.cs +++ b/zhengcaioa/zhengcaioa/Controllers/admin/AdmPieceCheckController.cs @@ -59,6 +59,15 @@ actionEntity1.PageIco = "fa fa-plus"; actionEntity1.ActionName = "鏂板"; actionlist.Add(actionEntity1); + + ActionEntity actionEntity3 = new ActionEntity(); + actionEntity3.OpenType = 0; + actionEntity3.ActionUrl = ""; + actionEntity3.ActionFun = "Print"; + actionEntity3.PageIco = "fa fa-print"; + actionEntity3.ActionName = "鎵撳嵃"; + actionlist.Add(actionEntity3); + ViewData["ActionInfo"] = actionlist; @@ -70,13 +79,29 @@ return View(); } - public IActionResult GetList(AdmPieceCheckDTOSearch search) { //JsonResult jsonResult = new JsonResult(_liaotianService.SearchByPaging(search), new Newtonsoft.Json.Serialization.DefaultContractResolver()); return new JsonResult(_admPieceCheckService.SearchByPaging(search)); } + + public IActionResult printList(AdmPieceCheckDTOSearch search) + { + //JsonResult jsonResult = new JsonResult(_liaotianService.SearchByPaging(search), new Newtonsoft.Json.Serialization.DefaultContractResolver()); + search.rows = 1000; + search.page = 1; + var resultDataEntity = _admPieceCheckService.SearchByPaging(search); + ViewBag.ListCooperOrderDTO = resultDataEntity.DataList as List<AdmPieceCheckDTO>; + ViewBag.Heji1 = resultDataEntity.Heji1; + ViewBag.Heji2 = resultDataEntity.Heji2; + + return View(); + } + + + + public IActionResult Edit(string id = null) { var curentuser = JsonConvert.DeserializeObject<PltUser>(HttpContext.Session.GetString("User")); diff --git a/zhengcaioa/zhengcaioa/Views/AdmAttendance/Index.cshtml b/zhengcaioa/zhengcaioa/Views/AdmAttendance/Index.cshtml index 5d69671..35e46fa 100644 --- a/zhengcaioa/zhengcaioa/Views/AdmAttendance/Index.cshtml +++ b/zhengcaioa/zhengcaioa/Views/AdmAttendance/Index.cshtml @@ -94,6 +94,10 @@ var year = date.getFullYear(); var month = date.getMonth(); var strDate = date.getDate(); + if (month == 0) { + year = year - 1; + month = 12; + } if (month >= 1 && month <= 9) { month = "0" + month; } diff --git a/zhengcaioa/zhengcaioa/Views/AdmPieceCheck/Index.cshtml b/zhengcaioa/zhengcaioa/Views/AdmPieceCheck/Index.cshtml index 64c4f05..ca019c9 100644 --- a/zhengcaioa/zhengcaioa/Views/AdmPieceCheck/Index.cshtml +++ b/zhengcaioa/zhengcaioa/Views/AdmPieceCheck/Index.cshtml @@ -48,7 +48,34 @@ OpenWindow("鏂板璁′欢鐧昏", "98%", "90%", "/AdmPieceCheck/Edit/"); } + var _afterLoadDataload = function (xhr) { + //var rows = jQuery("#jqGrid").jqGrid("getRowData"), total_shouru = 0, total_zhuchu = 0, total_yue = 0; + //for (var i = 0, l = rows.length; i < l; i++) { + // total_shouru += (rows[i].AllIncome - 0); + // total_zhuchu += (rows[i].AllExpenses - 0); + // total_yue += (rows[i].Balance - 0); + //} + + jQuery("#jqGrid").jqGrid("footerData", "set", { Remark: "<font color='darkgoldenrod'>--褰撻〉鍚堣--</font> </br> <font color='darkgoldenrod'>--鍚堣--</font>", Gongzi: "<font color='darkgoldenrod'>" + xhr.DangyeHeji1 + "</font></br><font color='darkgoldenrod'>" + xhr.Heji1 + "</font>", Shuliang: "<font color='darkgoldenrod'>" + xhr.DangyeHeji2 + "</font></br><font color='darkgoldenrod'>" + xhr.Heji2 + "</font>"}); + + + + }; + + var _pagePrint = function () { + + var WorkTime = $("#PBSWorkTimestart").val() + '|' + $("#PBSWorkTimeend").val(); + var DeptId = $("#PBSDeptId").val(); + var UserName = $("#PBSUserName").val(); + + + + var url = "/AdmPieceCheck/printList?WorkTime=" + WorkTime + "&DeptId=" + DeptId + "&UserName=" + UserName; + var me = window.open(url, "鎵撳嵃"); //鎵撳紑鏂扮獥鍙� + + + } var _afterSave = function (result) { diff --git a/zhengcaioa/zhengcaioa/Views/AdmPieceCheck/printList.cshtml b/zhengcaioa/zhengcaioa/Views/AdmPieceCheck/printList.cshtml new file mode 100644 index 0000000..e1c1bb4 --- /dev/null +++ b/zhengcaioa/zhengcaioa/Views/AdmPieceCheck/printList.cshtml @@ -0,0 +1,128 @@ +锘緻model DTO.AdmPieceCheckDTO +@using DTO; +@{ + ViewBag.Title = "CooperOrder"; + Layout = null; + List<AdmPieceCheckDTO> ListCooperOrderDTO = ViewBag.ListCooperOrderDTO as List<AdmPieceCheckDTO>; //闂绫诲瀷 + //string Heji1 = ViewBag.Heji1; + //string Heji2 = ViewBag.Heji2; +} + +<!DOCTYPE html> +<html> +<head> + <meta charset="utf-8"> + <meta http-equiv="X-UA-Compatible" content="IE=edge"> + <meta http-equiv="Pragma" content="no-cache"> + <meta http-equiv="Cache-Control" content="no-siteapp" /> + <meta http-equiv="Cache-Control" content="no-cache"> + <meta http-equiv="Expires" content="0"> + <meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0"> + <meta name="renderer" content="webkit"> + <title>@SiteConfig.SiteName</title> + <meta name="keywords" content="@SiteConfig.Keywords"> + <meta name="description" content="@SiteConfig.Description"> + <meta name="author" content="@SiteConfig.Author"> + <link rel="icon" type="image/x-icon" href="@SiteConfig.ShortcutIcon"> + <!-- uc寮哄埗绔栧睆 --> + <meta name="screen-orientation" content="portrait"> + <!-- QQ寮哄埗绔栧睆 --> + <meta name="x5-orientation" content="portrait"> + <!-- UC寮哄埗鍏ㄥ睆 --> + <meta name="full-screen" content="yes"> + <!-- QQ寮哄埗鍏ㄥ睆 --> + <meta name="x5-fullscreen" content="true"> + <!--[if lt IE 9]> + <meta http-equiv="refresh" content="0;ie.html" /> + <![endif]--> + <script src="~/js/jquery.min.js"></script> + <style type="text/css"> + body { + text-align: left; + font-size: 12px; + } + + table { + border-collapse: collapse; + border: none; + width: 900px; + margin-left: 0px; + text-align: center; + } + + td { + border: solid #000000 1px; + } + </style> +</head> +<body> + <button type="button" onclick="onprint()">鎵撳嵃</button> + <div id="printArea"> + @if (ListCooperOrderDTO != null && ListCooperOrderDTO.Count > 0) + {<table> + @{ + int i = 1; + } + <tr> + <td style="width:4%;"> 缂栧彿</td> + <td style="width:12%;"> 宸ヤ綔鏃堕棿</td> + <td style="width:12%;"> 閮ㄩ棬</td> + <td style="width:12%;"> 鍛樺伐濮撳悕</td> + <td style="width:12%;"> 璁′欢绫诲埆</td> + <td style="width:12%;"> 璁′欢椤圭洰</td> + <td style="width:12%;"> 宸ヤ綔鍐呭</td> + <td style="width:12%;"> 缁╂晥鎻愭垚锛堝厓锛�</td> + <td style="width:12%;"> 鏁伴噺</td> + + + </tr> + @foreach (var CooperOrderDTO in ListCooperOrderDTO) + { + + <tr> + <td> @i</td> + <td> @CooperOrderDTO.WorkTimeName</td> + <td> @CooperOrderDTO.DeptName</td> + <td> @CooperOrderDTO.UserName</td> + <td> @CooperOrderDTO.PayTypeName</td> + <td> @CooperOrderDTO.WorkProName</td> + <td> @CooperOrderDTO.Remark</td> + <td> @CooperOrderDTO.Gongzi.Value.ToString("F2")</td> + <td> @CooperOrderDTO.Shuliang.Value.ToString("F2")</td> + </tr> + + i++; + } + + <tr> + <td> </td> + <td> </td> + <td> </td> + <td> </td> + <td> </td> + <td> </td> + <td>--鍚堣--</td> + <td> @ViewBag.Heji1</td> + <td> @ViewBag.Heji2</td> + </tr> + + + +</table> + } + </div> +</body> +<script type="text/javascript"> + + function printHtml(html) { + var bodyHtml = document.body.innerHTML; + document.body.innerHTML = html; + window.print(); + document.body.innerHTML = bodyHtml; + } + function onprint() { + var html = $("#printArea").html(); + printHtml(html); + } +</script> +</html> diff --git a/zhengcaioa/zhengcaioa/Views/SalaryCheck/Employee.cshtml b/zhengcaioa/zhengcaioa/Views/SalaryCheck/Employee.cshtml index 7bd71bb..0e2f3c5 100644 --- a/zhengcaioa/zhengcaioa/Views/SalaryCheck/Employee.cshtml +++ b/zhengcaioa/zhengcaioa/Views/SalaryCheck/Employee.cshtml @@ -130,6 +130,10 @@ var year = date.getFullYear(); var month = date.getMonth(); var strDate = date.getDate(); + if (month == 0) { + year = year - 1; + month = 12; + } if (month >= 1 && month <= 9) { month = "0" + month; } diff --git a/zhengcaioa/zhengcaioa/Views/SalaryCheck/Index.cshtml b/zhengcaioa/zhengcaioa/Views/SalaryCheck/Index.cshtml index e3dbedc..4950b16 100644 --- a/zhengcaioa/zhengcaioa/Views/SalaryCheck/Index.cshtml +++ b/zhengcaioa/zhengcaioa/Views/SalaryCheck/Index.cshtml @@ -123,6 +123,10 @@ var seperator1 = "-"; var year = date.getFullYear(); var month = date.getMonth(); + if (month == 0) { + year = year - 1; + month = 12; + } var strDate = date.getDate(); if (month >= 1 && month <= 9) { month = "0" + month; -- Gitblit v1.9.1