From 6131316db2e61c717a6fbd1db774b41b60c933e9 Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期三, 21 九月 2022 09:45:32 +0800
Subject: [PATCH] 优化查询
---
zhengcaioa/zhengcaioa/Views/Project/Select.cshtml | 22 ++++++++++++++++++++--
1 files changed, 20 insertions(+), 2 deletions(-)
diff --git a/zhengcaioa/zhengcaioa/Views/Project/Select.cshtml b/zhengcaioa/zhengcaioa/Views/Project/Select.cshtml
index aff4513..48f9f0a 100644
--- a/zhengcaioa/zhengcaioa/Views/Project/Select.cshtml
+++ b/zhengcaioa/zhengcaioa/Views/Project/Select.cshtml
@@ -14,7 +14,8 @@
var Creater = '@Html.Raw(Newtonsoft.Json.JsonConvert.SerializeObject(ViewBag.Creater))';
var flbx = '@Html.Raw(Newtonsoft.Json.JsonConvert.SerializeObject(ViewBag.flbx))';
var ShiFouyReasonname = '@Html.Raw(Newtonsoft.Json.JsonConvert.SerializeObject(ViewBag.ShiFouyReasonname))';
-
+ var Baomingtimebegin = '@Html.Raw(ViewBag.Baomingtimebegin)';
+ var Baomingtimeend = '@Html.Raw(ViewBag.Baomingtimeend)';
loseherght = 110;
dataCol = [
@@ -94,7 +95,7 @@
{ label: '搴熸爣娆℃暟', name: 'Feibiaocishu', labtype: 'txt', hidden: true },
{ label: '涓爣閲戦', name: 'Zhongbiaojine', labtype: 'txt', hidden: true }
];
- dataUrl = "/Project/GetLiaotianList"+"@(string.IsNullOrEmpty(Creater11) ?"":"?Creater="+ Creater11)";
+ dataUrl = "/Project/GetLiaotianList?StartTimestar=" + Baomingtimebegin + "|" + Baomingtimeend +"@(string.IsNullOrEmpty(Creater11) ?"":"&Creater="+ Creater11)";
searchCol = [
//{ label: '鍏憡鏃堕棿', name: 'StartTimestar', labtype: 'date', hidden: false },
//{ label: '--', name: 'StartTimeend', labtype: 'date', hidden: false, cwidth: '1%', cccwidth: '15%' },
@@ -129,6 +130,18 @@
];
var _pageAdd = function () {
OpenWindow("鏂板椤圭洰", "98%", "90%", "/Project/Add/");
+ }
+
+ var _pageSearch = function () {
+ $("#jqGrid").jqGrid('setGridParam', {
+ url: dataUrl = "/Project/GetLiaotianList"+"@(string.IsNullOrEmpty(Creater11) ?"":"?Creater="+ Creater11)", postData: jsons, page: 1
+ }); //閲嶆柊杞藉叆
+ var jsons = GetSearchEnd();
+ if (jsons == false) {
+ msg.info("璇峰綍鍏ユ煡璇㈡潯浠�");
+ return false;
+ }
+ LoadGrid(jsons);
}
var _afterSave = function (result) {
@@ -259,6 +272,11 @@
$("#PBSCreater").parent().next().remove();
$("#PBSFenchadayu").parent().after("<br>");
+
+ $("#PBSStartTimestarend").val(Baomingtimeend);
+
+ $("#PBSStartTimestarstart").val(Baomingtimebegin);
+
});
</script>
--
Gitblit v1.9.1