?? qydb_bh.jsp
字號:
<%@page contentType="text/html; charset=gb2312" language="java" errorPage="" %>
<jsp:useBean id="list1" scope="page" class="JXC.web.Lists" />
<jsp:include page="../other/Function.jsp" flush="false"/>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title></title>
<link rel="stylesheet" href="../global.css">
<SCRIPT LANGUAGE="JavaScript">
function openFrameless()
{
NFW =window.open("../jcsz/spxx.jsp","","fullscreen");//打開一個窗口為滿屏顯示
NFW.resizeTo(620,450);//改變窗口大小
NFW.moveTo(screen.width/2-310,screen.height/2-225);//移動窗口
}
function chk()
{
//OK= checkNumber(form1.count.value,'數量輸入錯誤');
if (isEmpty(form1.wpbh.value))
{
alert('請選擇商品');
return false;
}
if (!isNumber(form1.num.value))
{
alert('數量輸入錯誤');
return false;
}
if (!isDouble(form1.dj.value))
{ alert('單價輸入錯誤');
return false;
}
document.form1.submit();
}
function chk1()
{
if (!isNumber(form2.num.value))
{
alert('數量輸入錯誤');
return false;
}
if (!isDouble(form2.dj.value))
{ alert('單價輸入錯誤');
return false;
}
document.form2.submit();
}
</SCRIPT>
<%
String selfweb="qydb";
String selfmxweb="qydbmxlist";
String bh=request.getParameter("id");
String Page=request.getParameter("page");
String str="SELECT * From qydblist WHERE id ="+bh;
String ckid="0";
String ckid2="0";
list1.setShowAll();
list1.setStrSql(str);
if (list1.excute()){
ckid=list1.getString("yck");
ckid2=list1.getString("mck");
%>
<link rel="stylesheet" href="../other/customer.css">
</head><body>
<table width="100%" border="1" cellspacing="0" cellpadding="0" bordercolor="#FFFFFF">
<tr>
<td bordercolor="#86c2fe">
<table width="100%" border="0" cellspacing="0" cellpadding="0" bordercolor="#86c2fe">
<tr>
<td bgcolor="#4180BE">
<table width="100%" height="44" border="0" cellspacing="0" cellpadding="0" align="left">
<tr>
<td width="100%">
<p align="center">
<font color="#FFFFFF">企 業 調 撥 --<font size="2"> 詳細資料</font></font>
</p>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
<table width="20%" >
<td ><a href="<%=selfweb%>.jsp?page=<%=Page%>"><img border="0" src="../images/return.jpg" ></a></td>
<td >
<a href="<%=selfweb%>_bh.jsp?id=<%=bh%>&page=<%=Page%>&add=1"><img border="0" src="../images/add.jpg"></a></td>
</Table>
<table width="600" cellspacing="1" align="center">
<tr>
<td height="100%" colspan="2">
<table width="100%" cellspacing="1" bgcolor="#86c2fe">
<tr>
<td class='small' width="15%" bgcolor="#D8EBF5">
<div align="center">單據編號：</div>
</td>
<td class='small' width="35%" bgcolor="#D8EBF5"><%=list1.getString("djbh")%></td>
<td class='small' width="15%" bgcolor="#D8EBF5">
<div align="center">源倉庫名稱：</div>
</td>
<td class='small' bgcolor="#D8EBF5"><%=list1.getString("yckname")%></td>
</tr>
<tr>
<td class='small' width="15%" bgcolor="#D8EBF5">
<div align="center">目的倉庫名稱：</div>
</td>
<td class='small' width="35%" bgcolor="#D8EBF5"><%=list1.getString("ckname")%></td>
<td class='small' width="15%" bgcolor="#D8EBF5">
<div align="center">業務員：</div>
</td>
<td class='small' bgcolor="#D8EBF5"><%=list1.getString("name")%></td>
</tr>
<tr>
<td class='small' width="15%" bgcolor="#D8EBF5">
<div align="center">日 期：</div>
</td>
<td class='small' width="35%" bgcolor="#D8EBF5"><%=list1.getString("Fdate").substring(0,10)%></td>
<td class='small' width="15%" bgcolor="#D8EBF5">
<div align="center"></div>
</td>
<td class='small' bgcolor="#D8EBF5"></td>
</tr>
<tr>
<td class='small' width="15%" bgcolor="#D8EBF5">
<div align="center">備 注：</div>
</td>
<td class='small' colspan="3" bgcolor="#D8EBF5"><%=list1.getString("memo")%></td>
</tr>
</table></td>
</tr>
<tr>
<td class="small" width="23%" >
</td>
</td>
</tr>
</table>
<%
}
%>
<link rel="stylesheet" href="../other/customer.css">
<table width="600" align="center" cellspacing="1" >
<tr>
<td height="100%" colspan="2">
<table width="100%" cellspacing="1" bgcolor="#86c2fe">
<tr class='small' bgcolor="#D8EBF5" class="big_b">
<td width="11%"> <div align="center">物品編號</div></td>
<td width="25%"> <div align="center">物品名稱</div></td>
<td width="20%"> <div align="center">數量</div></td>
<td width="10%"> <div align="center">單價</div></td>
<td width="10%"> <div align="center">金額</div></td>
<td width="8%"> <div align="center">修改</div></td>
<td width="8%"> <div align="center">刪除</div></td>
</tr>
<%
str="SELECT * From qydbmxlist WHERE djbh ="+bh;
list1.setStrSql(str);
if (list1.excute()) {
int count=list1.getListCount();
int Num=0;
float Sum=0;
for (int i=0;i<count;i++){
String Color="#Ffffff";//"#F4F4E0";
list1.setRow(i);
if (i % 2==0)
Color="#F6f6f6";
Num=Num+Integer.parseInt(list1.getString("Num"));
Sum=Sum+Float.parseFloat(list1.getString("je"));
String wpid=list1.getString("id");
String edit=request.getParameter("edit");
if ((edit!=null)&&(edit.equals(wpid))){
%>
<tr bgcolor=#F6f6f6 >
<form method="POST" name="form2" action="<%=selfmxweb%>_ed.jsp?id=<%=wpid%>&djbh=<%=bh%>&page=<%=Page%>&ckid=<%=ckid%>&ckid2=<%=ckid2%>&wpbh=<%=list1.getString("wpid")%>">
<td class='small' ><%=list1.getString("wpbh")%>
</td>
<td class='small' ><%=list1.getString("name")%></td>
<td class='small' ><input type="text" name="num" size="10" value="<%=list1.getString("Num")%>" class='inEdit'></td>
<td class='small' ><input type="text" name="dj" size="10" class='inEdit' value="<%=list1.getString("dj")%>" ></td>
<td class='small' ><%=list1.getString("je")%></td>
<td class='small'><input class='inBtn' onClick="chk1()" type="button" value="保存" name="B1" align="center" ></td>
<td class='small'><a href="<%=selfweb%>_bh.jsp?id=<%=bh%>&page=<%=Page%>"><div align="center"> 取消 </td>
</form>
</tr>
<% }else{
%>
<tr bgcolor=<%=Color%> >
<td class='small' ><%=list1.getString("wpbh")%></a></td>
<td class='small' ><%=list1.getString("name")%></td>
<td class='small' ><%=list1.getString("Num")%></td>
<td class='small' >￥<%=list1.getString("dj")%></td>
<td class='small' >￥<%=list1.getString("je")%></td>
<td class='small'><a href="<%=selfweb%>_bh.jsp?id=<%=bh%>&page=<%=Page%>&ckid2=<%=ckid2%>&ckid=<%=ckid%>&edit=<%=wpid%>"><div align="center">修改</div></td>
<td class='small'><a href="<%=selfmxweb%>_Del.jsp?id=<%=bh%>&page=<%=Page%>&ckid2=<%=ckid2%>&ckid=<%=ckid%>&del=<%=wpid%>" onclick="return window.confirm('你確實要刪除【<%=list1.getString("name")%>】嗎？');"><div align="center">刪除</div></td>
</tr>
<% } }
String add=request.getParameter("add");
if (add!=null) { %>
<tr bgcolor=#F6f6f6 >
<form method="POST" name="form1" action="<%=selfmxweb%>_add.jsp?djbh=<%=bh%>&page=<%=Page%>&ckid2=<%=ckid2%>&ckid=<%=ckid%>">
<td class='small' ><input type="text" name="wpbh1" size="10" class='inEdit' onkeypress="javascript:if (event.keyCode == 13){form1.a8.focus();{return false;}}"><A
onclick="var pathname = (window.location.pathname); showx = (window.screen.width - 500)/2 ; // + deltaX; showy = (window.screen.height - 255)/2 ; // + deltaY; window.open(pathname.substring(0,(pathname.lastIndexOf('.nsf')))+'spxx.jsp?name=<%=ckid%>','SetStartDate', 'status=yes,resizable=no,scrollbars=yes,'+'top='+showy+',left='+showx+',width=500,height=265'); return false;"
href="spxx.jsp?name=<%=ckid%>"><IMG height=16
src="../Pic/add.bmp" width=16
border=0>
</td>
<td class='small' ><input type="text" name="name" size="10" class='inEdit'></td>
<td class='small' ><input type="text" name="num" size="10" class='inEdit'></td>
<td class='small' ><input type="text" name="dj" size="10" class='inEdit'></td>
<td class='small' ></td>
<td class='small'><input class='inBtn' onClick="chk()" type="button" value="保存" name="B1" align="center" ></td>
<td class='small'><a href="<%=selfweb%>_bh.jsp?id=<%=bh%>&page=<%=Page%>"><div align="center"> 取消 </td>
<input type=hidden name=wpbh >
</form>
</tr>
<% }
%>
<tr bgcolor=#F6f6f6 >
<td class='small' >合計</td>
<td class='small' ></td>
<td class='small' ><%=Num%></td>
<td class='small' ></td>
<td class='small' >￥<%=Sum%></td>
<td class='small'></td>
<td class='small'></td>
</tr>
<%} %>
</table></td>
</tr>
</table>
</body></html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -