@page
@model xxtsoft.Web.Entry.Pages.sysadmins.mb.mbModel
@{
Layout = "_LayoutAdmin";
ViewData["Title"] = "日目标管理";
}
<div class="layui-fluid">
<blockquote class="layui-elem-quote">
如当天不需要上报计划目标，空着即可。
</blockquote>
</div>
<form class="layui-form layui-form-pane" method="post" name="form1" >
<div class="layui-fluid paneltop20">
<div class="layui-form-item">
<div class="layui-inline">
<label class="layui-form-label layui-form-label-greenbg">月份</label>
<div class="layui-input-inline layui-input-wrap">
<div class="layui-input-prefix">
<i class="layui-icon layui-icon-date"></i>
</div>
<input type="text" name="rq" id="rq" value="@Model.yf" autocomplete="off" lay-affix="clear" class="layui-input" placeholder="yyyy-MM">
</div>
</div>
<div class="layui-inline">
<input type="hidden" name="fst" id="fst" value="@Request.Query["fst"]" class="layui-input">
<button class="layui-btn layuiadmin-btn-list btn-block" type="submit" asp-page-handler="sear">
搜索
</button>
<button type="button" class="layui-btn layui-btn-primary btn-block1" onclick="javascript:location.href='mb?fst=@Request.Query["fst"]';return false;">
重置
</button>
</div>
</div>
</div>
<div class="layui-fluid paneltop35">
<div class="layui-panel layui-padding-3">
<style>
/* 表格容器固定高度，启用滚动 */
.table-container {
max-height: 550px; /* 设置容器最大高度 */
overflow-y: auto; /* 垂直滚动 */
}
/* 表头固定样式 */
table {
border-collapse: collapse;
width: 100%;
}
thead tr {
position: sticky;
top: 0;
background: #f2f2f2; /* 表头背景色 */
z-index: 10; /* 确保表头在内容上方 */
}
th, td {
padding: 8px 12px;
border: 1px solid #ddd;
text-align: left;
}
</style>
<div class="table-container">
<table id="xxt-tbl" lay-filter="xxt-tbl" class="layui-table" lay-even>
<tr class="layui-bg-green">
<td>日期</td>
<td>有效拜访次数</td>
<td>未合作学校有效拜访次数</td>
<td>请客吃饭次数</td>
<td>教育主管部门拜访次数</td>
<td>领导交谈次数</td>
<td>班主任演示次数</td>
<td>项目复盘表完成个数</td>
</tr>
@Html.Raw(Model.sb.ToString())
</table>
</div>
<br />
<input type="hidden" name="fst" id="fst" value="@Request.Query["fst"]" class="layui-input">
<input type="hidden" name="usrid" id="usrid" value="@Model.loginSid" class="layui-input">
<button type="submit" class="layui-btn layui-btn-lg" asp-page-handler="mb" lay-submit lay-filter="form1">提交</button>
</div>
</div>
</form>
<script>
layui.config({
base: '/layui/' // 静态资源所在路径
}).extend({
index: 'lib/index' //主入口模块
}).use(function () {
var table = layui.table;
var layer = layui.layer;
var $ = layui.jquery;
var form = layui.form;
var laydate = layui.laydate;
laydate.render({
elem: '#rq',
type: 'month'
});
});
</script>using AngleSharp.Dom;
using Furion.DistributedIDGenerator;
using Microsoft.AspNetCore.Authorization;
using Microsoft.AspNetCore.Mvc;
using Microsoft.AspNetCore.Mvc.RazorPages;
using OfficeOpenXml.FormulaParsing.Excel.Functions.DateTime;
using System;
using System.Collections.Specialized;
using System.Security.Claims;
using System.Text;
using xxtsoft.Application;
using xxtsoft.Application.Zjxq;
using xxtsoft.Common;
namespace xxtsoft.Web.Entry.Pages.sysadmins.mb
{ //登录判断
[Authorize]
public class mbModel : PageModel
{
public string loginxm = "";//登录用户名
public string loginRole = "";//登录角色
public string loginSid = "";//登录id
public StringBuilder sb = new StringBuilder();
public string yf;
private readonly SqlSugar.ISqlSugarClient _db;
private readonly MbExtService _MbExtService;
public mbModel(MbExtService MbExtService, SqlSugar.ISqlSugarClient db)
{
this._db = db;
//_db.ChangeDatabase("1");
_MbExtService = MbExtService;
}
public void OnGet()
{
#region 登录信息
loginxm = User.Identity.Name;
loginRole = User.Claims.FirstOrDefault(c => c.Type == ClaimTypes.Role)?.Value;
loginSid = User.Claims.FirstOrDefault(c => c.Type == ClaimTypes.Sid)?.Value;
#endregion
#region 绑定界面
yf = Request.Query["rq"];
if (string.IsNullOrEmpty(yf))
{
yf = DateTime.Now.ToString("yyyy-MM");
}
DateTime _yf = DateTime.Parse(yf);
int daysInMonth = DateTime.DaysInMonth(_yf.Year, _yf.Month);
for (int i = 1; i <= daysInMonth; i++)
{
string _rq = _yf.Year + "-" + _yf.Month + "-" + i.ToString();
sb.AppendLine("<tr>");
sb.AppendLine(" <td>" + _yf.Month + "-" + i.ToString() + "<input name=\"rq1\" type=\"hidden\" value=\"" + _rq + "\" /></td>");
sb.AppendLine(" <td><input type=\"text\" name=\"yxbfcs\" value=\"" + _MbExtService.ReadFld(loginSid, _rq, "yxbfcs") + "\" placeholder=\"请输入\" class=\"layui-input\" lay-verify=\"number\"></td>");
sb.AppendLine(" <td><input type=\"text\" name=\"whzxxbfcs\" value=\"" + _MbExtService.ReadFld(loginSid, _rq, "whzxxbfcs") + "\" placeholder=\"请输入\" class=\"layui-input\" lay-verify=\"number\"></td>");
sb.AppendLine(" <td><input type=\"text\" name=\"qkcfcs\" value=\"" + _MbExtService.ReadFld(loginSid, _rq, "qkcfcs") + "\" placeholder=\"请输入\" class=\"layui-input\" lay-verify=\"number\"></td>");
sb.AppendLine(" <td><input type=\"text\" name=\"jyzgbmbfcs\" value=\"" + _MbExtService.ReadFld(loginSid, _rq, "jyzgbmbfcs") + "\" placeholder=\"请输入\" class=\"layui-input\" lay-verify=\"number\"></td>");
sb.AppendLine(" <td><input type=\"text\" name=\"ldjtcs\" value=\"" + _MbExtService.ReadFld(loginSid, _rq, "ldjtcs") + "\" placeholder=\"请输入\" class=\"layui-input\" lay-verify=\"number\"></td>");
sb.AppendLine(" <td><input type=\"text\" name=\"bzryscs\" value=\"" + _MbExtService.ReadFld(loginSid, _rq, "bzryscs") + "\" placeholder=\"请输入\" class=\"layui-input\" lay-verify=\"number\"></td>");
sb.AppendLine(" <td><input type=\"text\" name=\"xmfbwcgs\" value=\"" + _MbExtService.ReadFld(loginSid, _rq, "xmfbwcgs") + "\" placeholder=\"请输入\" class=\"layui-input\" lay-verify=\"number\"></td>");
sb.AppendLine("</tr>");
}
#endregion
}
public IActionResult OnPostSear()
{
#region 搜索
string yf = Request.Form["rq"];
if (string.IsNullOrEmpty(yf))
{
MessageHelper.ShowLocation("请输入月份");
}
Response.Redirect("mb?rq=" + yf + "&fst=" + Request.Query["fst"]);
#endregion
return Page();
}
public IActionResult OnPostMb()
{
string usrid = Request.Form["usrid"];
string rq = Request.Form["rq1"];
var yxbfcs = Request.Form["yxbfcs"];
var whzxxbfcs = Request.Form["whzxxbfcs"];
var qkcfcs = Request.Form["qkcfcs"];
var jyzgbmbfcs = Request.Form["jyzgbmbfcs"];
var ldjtcs = Request.Form["ldjtcs"];
var bzryscs = Request.Form["bzryscs"];
var xmfbwcgs = Request.Form["xmfbwcgs"];
var _yxbfcs = string.Join(",", yxbfcs);
var _whzxxbfcs = string.Join(",", whzxxbfcs);
var _qkcfcs = string.Join(",", qkcfcs);
var _jyzgbmbfcs = string.Join(",", jyzgbmbfcs);
var _ldjtcs = string.Join(",", ldjtcs);
var _bzryscs = string.Join(",", bzryscs);
var _xmfbwcgs = string.Join(",", xmfbwcgs);
//return Content(rq + "<br>" + _yxbfcs + "<br>" + _whzxxbfcs + "<br>" + _qkcfcs + "<br>" + _qkcfcs + "<br>" + _jyzgbmbfcs + "<br>" + _ldjtcs + "<br>" + _bzryscs + "<br>" + _xmfbwcgs);
string[] _rq1 = FunHelper.splitstr(rq, ",");
string[] _yxbfcs1 = FunHelper.splitstr(_yxbfcs, ",");
string[] _whzxxbfcs1 = FunHelper.splitstr(_whzxxbfcs, ",");
string[] _qkcfcs1 = FunHelper.splitstr(_qkcfcs, ",");
string[] _jyzgbmbfcs1 = FunHelper.splitstr(_jyzgbmbfcs, ",");
string[] _ldjtcs1 = FunHelper.splitstr(_ldjtcs, ",");
string[] _bzryscs1 = FunHelper.splitstr(_bzryscs, ",");
string[] _xmfbwcgs1 = FunHelper.splitstr(_xmfbwcgs, ",");
for (int i = 0; i < _rq1.Length; i++)
{
string _rq2 = "";
string _yxbfcs2 = "";
string _whzxxbfcs2 = "";
string _qkcfcs2 = "";
string _jyzgbmbfcs2 = "";
string _ldjtcs2 = "";
string _bzryscs2 = "";
string _xmfbwcgs2 = "";
_rq2 = _rq1[i];
try
{
_yxbfcs2 = _yxbfcs1[i];
_MbExtService.AddFld(usrid, _rq2, "yxbfcs", _yxbfcs2);
}
catch { }
try
{
_whzxxbfcs2 = _whzxxbfcs1[i];
_MbExtService.AddFld(usrid, _rq2, "whzxxbfcs", _whzxxbfcs2);
}
catch { }
try
{
_qkcfcs2 = _qkcfcs1[i];
_MbExtService.AddFld(usrid, _rq2, "qkcfcs", _qkcfcs2);
}
catch { }
try
{
_jyzgbmbfcs2 = _jyzgbmbfcs1[i];
_MbExtService.AddFld(usrid, _rq2, "jyzgbmbfcs", _jyzgbmbfcs2);
}
catch { }
try
{
_ldjtcs2 = _ldjtcs1[i];
_MbExtService.AddFld(usrid, _rq2, "ldjtcs", _ldjtcs2);
}
catch { }
try
{
_bzryscs2 = _bzryscs1[i];
_MbExtService.AddFld(usrid, _rq2, "bzryscs", _bzryscs2);
}
catch { }
try
{
_xmfbwcgs2 = _xmfbwcgs1[i];
_MbExtService.AddFld(usrid, _rq2, "xmfbwcgs", _xmfbwcgs2);
}
catch { }
}
MessageHelper.ShowLocation("提交成功");
return Page();
}
}
}
