⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 ckpd_tp1.jsp

📁 web版的进销存系统
💻 JSP
字号:
<%@page contentType="text/html; charset=GBK" language="java"  errorPage=""%>
<jsp:useBean id="list1" scope="page" class="jxc.web.Lists"/>
<jsp:include page="../other/Function.jsp" flush="false"/>
<html>
<head>
<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()
{
 if (isEmpty(form1.wpbh.value))
	{
	alert('请选择商品');
	return false;
	}
 if (!isNumber(form1.xNum.value)) 
{	
    alert('数量输入错误');
	return false;
 }
 document.form1.submit();
}
function chk1()
{
 if (!isNumber(form2.xNum.value)) 
{	
    alert('数量输入错误');
	return false;
}
 document.form2.submit();
}

function chk3()
{
 
 document.form3.submit();
}

</SCRIPT>
<meta http-equiv="Content-Type" content="text/html; charset=GBK">
<title></title>
<link rel="stylesheet" href="../other/customer.css">
<style>
@media print {
   .notprint {
           display:none;
           }
}

@media screen {
   .notprint {
           display:inline;
           cursor:hand;
           }
}
</style>
</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">商 品 调 平 信 息&nbsp;--<font size="2">&nbsp;调平理由</font></font> 
                  </p>
                </td>
              </tr> 
            </table> 
          </td> 
        </tr> 
      </table> 
    </td> 
  </tr> 
</table> 
<% 
 String bh=request.getParameter("id");
 String id=request.getParameter("id");
 String Page=request.getParameter("page");
 String ckid="0";
 String ckname="0";
 String tply="0";
 String str="SELECT * From ckpdlist WHERE id ="+bh;
 list1.setShowAll();
 list1.setStrSql(str);
 if (list1.excute()){
 ckid=list1.getString("ckbh");
 ckname=list1.getString("ckname");
 tply=list1.getString("tply");
%>
<table width="20%" >
<tr>
<td><a href="ckpd.jsp"><img border="0" src="../images/return.jpg" ></a></td>
</tr>
</Table>
      <table width="600" cellspacing="1" align="center">
        <tr> 
          <td height="100%" colspan="2"> 
		     <table width="100%" cellspacing="1" bgcolor="#86c2fe"> 
              <tr  bgcolor="#D8EBF5" class="big_b"> 
                       <td  colspan="5"><div align="center"><b><font size="2">商品调平详细资料</font></b></div></td>
                     <tr> 
                      <td  width="15%" class='small' bgcolor="#D8EBF5"><div align="center">单据编号:</div></td>
                      <td  width="35%" class='small' bgcolor="#D8EBF5"><%=list1.getString("djbh")%></td>
                      <td width="15%"  class='small' bgcolor="#D8EBF5"><div align="center">员工名称:</div></td>
                      <td class='small' bgcolor="#D8EBF5"><%=list1.getString("name")%></td>
                    </tr>
                    <tr> 
                      <td width="15%" class='small' bgcolor="#D8EBF5"><div align="center">仓库名称:</div></td>
                      <td width="35%" class='small' bgcolor="#D8EBF5"><%=list1.getString("ckname")%></td>
                      <td width="15%" class='small' bgcolor="#D8EBF5"><div align="center">填单人:</div></td>
                      <td class='small' bgcolor="#D8EBF5"><%=list1.getString("tdr")%></td>
                    </tr>
                    <tr> 
                      <td width="15%" class='small' bgcolor="#D8EBF5"><div align="center">日    期:</div></td>
                      <td width="35%" class='small' bgcolor="#D8EBF5"><%=list1.getString("Tdate").substring(0,10)%></td>
                      <td width="15%" class='small' bgcolor="#D8EBF5"><div align="center">备  注:</div></td>
                      <td class='small' bgcolor="#D8EBF5"><%=list1.getString("bz")%></td>
                    </tr>
</table></td>
        </tr>
        <tr> 
          <td class="small" width="100%" >
                <table width="600" align="center" cellspacing="0" >
        <tr> 
          <td height="100%" colspan="2"> 
		     <table width="100%" cellspacing="1" bgcolor="#86c2fe"> 
              <tr class='small' bgcolor="#D8EBF5" class="big_b">
                <td width="20%"> <div align="center">物品编号</div></td>
                <td width="20%"> <div align="center">物品名称</div></td>
                <td width="20%"> <div align="center">账面数量</div></td>
                <td width="20%"> <div align="center">实际数量</div></td>
                <td width="20%"> <div align="center">盈亏数额</div></td>
              </tr>
<%
str="SELECT * From ckpdmxlist WHERE djid ="+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";
				  list1.setRow(i);
						  if (i % 2==0)
							Color="#F6f6f6";
					Num=Num+Integer.parseInt(list1.getString("Num"));
                 String wpid=list1.getString("id");//得到明细表的ID
					 %>
              <tr bgcolor=<%=Color%> > 
                <td class='small' ><%=list1.getString("wpbh")%></td>
                <td class='small' ><%=list1.getString("wpname")%></td>
                <td class='small' align=center><%=list1.getString("yNum")%></td>
                <td class='small' align=center><%=list1.getString("xNum")%></td>
				<td class='small' align=center>
				<%if(Integer.parseInt(list1.getString("pdNum"))<=0){%>
				<font color="red"><%=list1.getString("pdNum")%></font>
				<%}else{%>
				<font color="green">+<%=list1.getString("pdNum")%></font>
				<%}%>
				</td>
				</tr>							
								
	  <%}}%>
			  
		 </table> 
          </td>
        </tr>
      </table>
      
<%}%>		  
<form method="POST" action="ckpd_tp1ok.jsp?id=<%=bh%>">
      <table width="600" align="center" cellspacing="1" bgcolor="#86c2fe">
      	<tr bgcolor=#F6f6f6 class="big_b">
      		<td class='small' height="100%" align="center">
      			调平人:
      		</td>
      		<td class='small' height="100%">
      			<%= session.getAttribute("usname")%>
      		</td>
      	</tr>
      	
        <tr bgcolor=#F6f6f6 class="big_b"> 
          <td class='small' height="100%" align="center">
          请输入调平的理由:
          </td>
          <td class='small'>
			<textarea rows="5" cols="70" name="tply"><%=tply%></textarea>			  
		 </td>
		 </tr>
		 <tr bgcolor=#F6f6f6>
		 <td>
		 </td>
		 <td align=center>
		 <input class='inBtn' type="submit" value="确认">&nbsp;<input class='inBtn' type="reset" value="重置">
		 </td>
		 </tr>
        </table>

</body></html>        
 

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -