<!-- ==================== 主表单结构 ==================== -->
<table align="center" border="0" cellpadding="0" cellspacing="0" class="tableForm" style="table-layout: fixed;">
<colgroup>
<col width="80" />
<col /><!--hide4phone.start-->
<col width="80" />
<col width="380" /><!--hide4phone.end-->
</colgroup>
<tbody>
<tr>
<td style="text-align: right;">
<span style="color: red;">*</span>Subject:</td>
<td dbf.type="required" id="dbf.subject">
</td>
<!--show4phone.start-->
</tr>
<tr><!--show4phone.end-->
<td style="text-align: right;">
Status:</td>
<td><span id="mapping.dbf.procXSource">
</span>
Responsor: <span id="mapping.dbf.responsorSource">
</span>
Participants: <span id="mapping.dbf.participantsSource">
</span></td>
</tr>
</tbody>
</table>
<div>
</div>
<!-- ==================== 页面标题 ==================== -->
<div style="text-align: center;">
<h1><img src="../common/logo.png" /> [报价历史查询内勤用]</h1>
</div>
<div>[Design form here, based on the template below, or customized by yourself after the template removed]</div>
<!-- ==================== 查询输入区域 ==================== -->
<table align="center" border="0" cellpadding="0" cellspacing="0" class="tableListBorder" style="table-layout: fixed; width: 928px;">
<colgroup>
<col width="130" />
<col /><!--hide4phone.start-->
<col width="130" />
<col width="330" /><!--hide4phone.end-->
</colgroup>
<tbody>
<tr>
<td colspan="4" style="background-color: lightyellow;">
</td>
</tr>
<tr>
<td class="fieldLabel" style="text-align: center; width: 147px;"><span style="color: red;">*</span>
username</td>
<td id="username" style="width: 210px;">
</td>
<!--show4phone.start-->
</tr>
<tr><!--show4phone.end-->
<td class="fieldLabel" style="text-align: center; width: 63px;"><span style="color: red;">*</span>
id</td>
<td id="ID" style="width: 254px;">
</td>
</tr>
<tr>
<td class="fieldLabel" style="text-align: center;">项目名称</td>
<td id="项目名称" style="width: 210px;">
</td>
<td class="fieldLabel" style="text-align: center;">装置名称</td>
<td id="装置名称" style="width: 254px;">
</td>
</tr>
<tr>
<td class="fieldLabel" style="text-align: center;">Customer Name</td>
<td id="CustomerName" style="width: 210px;">
</td>
<td class="fieldLabel" style="text-align: center;">E-NO/序列号</td>
<td id="ENO" style="width: 254px;">
</td>
</tr>
<tr>
<td class="fieldLabel" style="text-align: center;">产品描述</td>
<td id="产品描述" style="width: 210px;">
</td>
<td class="fieldLabel" style="text-align: center;">Remark</td>
<td id="Remark" style="width: 254px;">
</td>
</tr>
</tbody>
</table>
<!-- ==================== 查询结果表格容器 ==================== -->
<div id="resultTableContainer" style="margin-top: 20px; padding: 0 10px;"><!-- 动态表格将插入到这里 --></div>
<!-- ==================== 手机适配区域（可选）==================== -->
<div class="slide4phone">
<table align="center" border="0" cellpadding="0" cellspacing="0" class="tableListBorder2" style="table-layout: fixed;">
<colgroup>
<col width="460" />
<col width="140" />
<col />
</colgroup>
</table>
</div>
<!-- ==================== 查询按钮 ==================== -->
<div style="text-align: center; margin: 20px 0;">
<input id="idslist" name="idslist" type="hidden" />
<strong> <input id="check" name="check" onclick="clickData()" type="button" value="check个人记录" /> </strong></div>
<!-- ==================== 移动端表格占位 ==================== -->
<div class="slide4phone2" id="reptable">
<table align="center" border="0" cellpadding="0" cellspacing="0" class="tableListBorder2" style="width: 1300px;">
</table>
</div>
<script language="javascript">
function clickData(){
var aa='%'+$("username").value().trim()+'%';
var 项目name= '%'+$("项目名称").value().trim()+'%';
var 装置name= '%'+$("装置名称").value().trim()+'%';
var CustomerName= '%'+$("CustomerName").value().trim()+'%';
var ENO= '%'+$("ENO").value().trim()+'%';
var Remark= '%'+$("Remark").value().trim()+'%'
var Product描述 = '%'+$("产品描述").value().trim()+'%'
// var sqlQuery2 = "SELECT Subject,Status,申请人,申请日期,产品类别,其他,type,内勤,系统,customer,ProjectName,DeviceName,新产品,[E-NO/序列号],目标价,数量,产地,含税报价,HandlerRemark,Remark FROM X_BPM_DWH_819 "
var sqlQuery2 = "SELECT Subject,Status,申请人,申请日期,产品类别,其他,type,内勤,系统,customer,ProjectName,DeviceName,新产品,[E-NO/序列号],目标价,数量,产地,含税报价,HandlerRemark,Remark,描述 FROM X_BPM_DWH_819 where ProjectName like '" +项目name+ "' and DeviceName like '"+ 装置name + "' and customer like '"+CustomerName+ "' and [E-NO/序列号] like '"+ENO+ "' and Remark like '"+Remark+ "' and 描述 like '"+Product描述+"'"
eval("var arr="+service("common.
js","getDbsRecords",sqlQuery2,"array"));
alert(arr) 修改页面让 arr结果动态在页面上显示结果
本文详细介绍了JavaScript中的主要数据类型：字符串、数字、布尔值、数组、对象、空及未定义等，为读者提供了全面的基础知识。
扫一扫
1117
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
