From dd9145bbd9e2e7ba27324250dd16abfa6af41d08 Mon Sep 17 00:00:00 2001
From: yusijie <ysj@hz-kingdee.com>
Date: 星期三, 18 九月 2024 18:56:10 +0800
Subject: [PATCH] 1
---
WebTM/views/设备管理/设备报表/Sb_EquipMentCollectionTechParam_Temp.html | 16 +++++++++++++---
1 files changed, 13 insertions(+), 3 deletions(-)
diff --git "a/WebTM/views/\350\256\276\345\244\207\347\256\241\347\220\206/\350\256\276\345\244\207\346\212\245\350\241\250/Sb_EquipMentCollectionTechParam_Temp.html" "b/WebTM/views/\350\256\276\345\244\207\347\256\241\347\220\206/\350\256\276\345\244\207\346\212\245\350\241\250/Sb_EquipMentCollectionTechParam_Temp.html"
index 6f76b1c..9a45206 100644
--- "a/WebTM/views/\350\256\276\345\244\207\347\256\241\347\220\206/\350\256\276\345\244\207\346\212\245\350\241\250/Sb_EquipMentCollectionTechParam_Temp.html"
+++ "b/WebTM/views/\350\256\276\345\244\207\347\256\241\347\220\206/\350\256\276\345\244\207\346\212\245\350\241\250/Sb_EquipMentCollectionTechParam_Temp.html"
@@ -393,7 +393,8 @@
$.ajax({
url: GetWEBURL() + 'EquipMentCollectionTemp/list',
type: "GET",
- data: { "sWhere": sWhere , "user": sessionStorage["HUserName"]},
+ async: false,
+ data: { "sWhere": sWhere, "user": sessionStorage["HUserName"] },
success: function (data1) {
if (data1.count == 1) {
var data = [];
@@ -500,7 +501,9 @@
//蹇�熻繃婊�
function get_FastQuery(table, option,number) {
var HSourceCode = $("#HSourceCode").val();//璁惧缂栫爜
- var HTechParamName = $("#HTechParamName").val();//缁撴潫鏃ユ湡
+ var HBeginDate = $("#HBeginDate").val(); //寮�濮嬫棩鏈�
+ var HEndDate = $("#HEndDate").val(); //缁撴潫鏃ユ湡
+ var HTechParamName = $("#HTechParamName").val(); //宸ヨ壓鍙傛暟鍚嶇О
//浠绘剰瀛楁杩囨护
var ColName = $("#ColName").val();//澶嶉�夋
var Comparator = $("#Comparator").val()
@@ -583,7 +586,12 @@
if (HTechParamName) {
sWhere += " and 宸ヨ壓鍙傛暟鍚嶇О like '%" + HTechParamName + "%'";
}
-
+ if (HBeginDate) {
+ sWhere += " and CONVERT(varchar(100),鏃ユ湡, 23) >= '" + HBeginDate + "'";
+ }
+ if (HEndDate) {
+ sWhere += " and CONVERT(varchar(100),鏃ユ湡, 23) <= '" + HEndDate + "'";
+ }
sWhere += addSWhereByOpenType();
//娣诲姞鏌ヨ鏉′欢锛屾牴鎹綋鍓嶇櫥褰曠敤鎴峰叧鑱旇亴鍛樿繑鍥炴暟鎹�
//sWhere += " and HUserID =" + sessionStorage["Czybm"]
@@ -597,6 +605,8 @@
function set_ClearQuery() {
$("#HSourceCode").val("");
$("#HTechParamName ").val("");
+ $("#HBeginDate").val("");
+ $("#HEndDate").val("");
$("#ColContent").val("");
$("#ColName").val("0");
$("#Comparator").val("0");
--
Gitblit v1.9.1