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

📄 cglist_bh1.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.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();
}

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">
</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> 
<%
  list1.setSql("cglist");
  if (list1.excute()){
  String bh=list1.getString("id");
 String id=request.getParameter("id");
 String Page=request.getParameter("page");
 String ckid="0";
 String str="SELECT * From cglist WHERE id ="+bh;
 list1.setShowAll();
 list1.setStrSql(str);
 if (list1.excute()){
 ckid=list1.getString("ckbh");

%>
<table width="20%" >
<tr>
<td><a href="cglist.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("csname")%></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("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("fkfsname")%></td>
                      <td width="15%" class='small' bgcolor="#D8EBF5"><div align="center">付款情况:</div></td>
                      <td class='small' bgcolor="#D8EBF5"><%=list1.getString("fkname")%></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("tdr")%></td>
                    </tr>
                    <tr> 
                      <td width="15%" class='small' bgcolor="#D8EBF5"><div align="center">备  注:</div></td>
                      <td colspan="3" class='small' bgcolor="#D8EBF5"><%=list1.getString("bz")%></td>
                    </tr>
</table></td>
        </tr>
        <tr> 
          <td class="small" width="23%" > 
          </td>
        </tr>
      </table>
      
<%
 }
%>		  
      <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="10%"> <div align="center">物品编号</div></td>
                <td width="18%"> <div align="center">物品名称</div></td>
                <td width="18%"> <div align="center">物品分类</div></td>
                <td width="10%"> <div align="center">数量</div></td>
				<td width="10%"> <div align="center">单价</div></td>
				<td width="14%"> <div align="center">金额</div></td>
				<td width="10%"> <div align="center">修改</div></td>
				<td width="10%"> <div align="center">取消</div></td>
              </tr>
<%
str="SELECT * From cgmxlist 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"));
					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="cgmxlist_ed.jsp?id=<%=wpid%>&djbh=<%=bh%>&page=<%=Page%>&ckid=<%=ckid%>&wpbh=<%=list1.getString("wpid")%>">   	 
                <td class='small' ><%=list1.getString("wpbh")%></td>
                <td class='small' ><%=list1.getString("wpname")%></td>
                <td class='small' ><%=list1.getString("wptypename")%></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="<%=Float.parseFloat(list1.getString("dj"))%>" ></td>
				<td class='small' ><%=Float.parseFloat(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="cglist_bh1.jsp?id=<%=bh%>&page=<%=Page%>"><div align="center"> 取消 </div></a></td>
				
	 </tr>  
<% }else{ %>
              <tr bgcolor=<%=Color%> > 
                <td class='small' ><%=list1.getString("wpbh")%></td>
                <td class='small' ><%=list1.getString("wpname")%></td>
                <td class='small' ><%=list1.getString("wptypename")%></td>
                <td class='small' ><div align="right"><%=list1.getString("Num")%></div></td>
				<td class='small' ><div align="right">¥<%=(list1.getString("dj"))%></div></td>
				<td class='small' ><div align="right">¥<%=(list1.getString("je"))%></div></td>
				<td class='small'><a href="cglist_bh1.jsp?id=<%=bh%>&page=<%=Page%>&ckid=<%=ckid%>&edit=<%=wpid%>"><div align="center">修改</div></a></td>
				<td class='small'><a href="cgmxlist_del.jsp?id=<%=bh%>&page=<%=Page%>&ckid=<%=ckid%>&del=<%=wpid%>" onclick="return window.confirm('你确实要删除【<%=list1.getString("wpname")%>】吗?');" ><div align="center">删除</div></td>
 
              </tr>  
 <% } } 
 String add=request.getParameter("add");
 if (add!=null) { %>
 <tr bgcolor=#F6f6f6 > 
<form method="POST" name="form1" action="cgmxlist_add.jsp?djbh=<%=bh%>&page=<%=Page%>&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);&#13;showx = (window.screen.width - 500)/2 ; // + deltaX;&#13;showy = (window.screen.height - 255)/2 ; // + deltaY;&#13;&#13;window.open(pathname.substring(0,(pathname.lastIndexOf('.nsf')))+'spxx1.jsp','SetStartDate',&#13;'status=yes,resizable=no,scrollbars=yes,'+'top='+showy+',left='+showx+',width=500,height=265');&#13;&#13;return false;"     
            href="spxx1.jsp"><IMG height=16    src="../Pic/add.bmp" width=16     
            border=0>
	         </A></td>
                <td class='small' ><input type="text" name="wpname" size="10" class='inEdit'></td>
                <td class='small' ><input type="text" name="wptypename" 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="cglist_bh1.jsp?id=<%=bh%>&page=<%=Page%>"><div align="center"> 取消</div></a> </td>
					<input type=hidden name=wpbh >
		
	 </tr>  
<% }%>

  <tr bgcolor=#F6f6f6 > 
    <form method="POST" name="form3" action="cgmxlist_edit.jsp?djbh=<%=bh%>&id=<%=id%>&je=<%=Sum%>">    	
                <td ><a href="cglist_bh1.jsp?id=<%=bh%>&page=<%=Page%>&add=1"><img border="0" src="../images/add.jpg"></a></td>
                <td class='small' >合计</td>
                <td class='small' ></td>
                <td class='small' ><div align="right"><%=Num%></div></td>
				<td class='small' ></td>
				<td class='small' ><div align="right"><input type="text" name="je" value="<%=Sum%>" size="10"  class='inEdit'></div></td>
				<td class='small'><input class='inBtn' onClick="chk3()" type="button" value="保存" name="B2" align="center" ></td>
				<td class='small'></td>
	
              </tr>  
	  <%}}%>
			  
		 </table></td></tr>
        </table>
</body></html>        
 

⌨️ 快捷键说明

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