advisorinfo.jsp

这是一个法律事务所系统源码

			if(itemName == null) itemName = "";
			beginTime = rs1.getString("begin_time");
			if(beginTime == null) beginTime = "";			//判断空值，不显示为NULL
			else beginTime = beginTime.substring(0,10);		//时间格式转换			
			spendTime = rs1.getString("spend_time");
			if(spendTime == null) spendTime = "";
			itemResult = rs1.getString("item_result");
			if(itemResult == null) itemResult = "";
	/**/	
    	
    %>
    
    <tr class="tr_bg1"> 
      <td width="43%" ><%=itemName%></td>
      <td width="14%" align="center" ><%=beginTime%></td>
      <td width="11%" align="right" ><%=spendTime%></td>
      <td width="32%" ><%=itemResult%></td>
    </tr>
    
    <%    
    if (!rs1.next())
    	   break;
    }
    %>
    
  </table>
  <table align="center" class="page_bg" width="100%">
    <tr> 
      <td width="48%" align="left">共<span class="font1"> <%=recordCount%></span> 条记录 
        </td>
      <td align="right" width="52%"><a href="#"><img src="../images/01.gif" border="0" align="absmiddle" alt="首页" width="25" height="20"></a> 
        <a href="#"><img src="../images/02.gif" border="0" align="absmiddle" alt="前页" width="25" height="20"></a> 
        <a href="#"><img src="../images/03.gif" border="0" align="absmiddle" alt="下页" width="25" height="20"></a> 
        <a href="#"><img src="../images/04.gif" border="0" align="absmiddle" alt="尾页" width="25" height="20"></a> 
        跳至 
        <input type="text" name="textfield" size="3" readOnly class="input" maxlength="4">
        <a href="#"><img src="../images/go.gif" width="24" height="18" align="absmiddle" border="0"></a> 
      </td>
    </tr>
  </table>
</div>
<div id="Layer3" style="Position:absolute; top:70px; width:98%; height:161px; z-index:2; visibility: hidden"> 
  <table width="100%" cellpadding="0" cellspacing="0" border="0">
    <tr> 
      <td> 
        <table border="0" cellspacing="0" cellpadding="0" height="25" >
          <tr class="tr_bg1" align="center"> 
            <td  class="table_bg"  colspan="11" height="1" ></td>
          </tr>
          <tr class="tr_bg1" align="center"> 
            <td class="table_bg" width="1" ></td>
            <td onClick="MM_showHideLayers('Layer1','','show','Layer2','','hide','Layer3','','hide','Layer4','','hide','Layer5','','hide')" style="cursor:hand"  width="80" >顾问事务信息</td>
            <td class="table_bg" width="1"></td>
            <td  onClick="MM_showHideLayers('Layer1','','hide','Layer2','','show','Layer3','','hide','Layer4','','hide','Layer5','','hide')"  style="cursor:hand" width="80">顾问办理事务</td>
            <td  class="table_bg" width="1"></td>
            <td  onClick="MM_showHideLayers('Layer1','','hide','Layer2','','hide','Layer3','','show','Layer4','','hide','Layer5','','hide')"  style="cursor:hand" class="tr_bg2"  width="60">合同费用</td>
            <td  class="table_bg" width="1"></td>
            <td  onClick="MM_showHideLayers('Layer1','','hide','Layer2','','hide','Layer3','','hide','Layer4','','show','Layer5','','hide')"  style="cursor:hand" width="80">其他费用列表</td>
            <td  class="table_bg" width="1"></td>
            <td  onClick="MM_showHideLayers('Layer1','','hide','Layer2','','hide','Layer3','','hide','Layer4','','hide','Layer5','','show')"  style="cursor:hand" width="70">委托人信息</td>
            <td  class="table_bg" width="1"></td>
          </tr>
        </table>
      </td>
    </tr>
  </table>
  <table width="100%" cellspacing="1" cellpadding="5" border="0" align="center" class="table_bg">
    <tr> 
    <td width="152"  align="right" class="title_bg"> 费用编号： </td>
    <td width="197" class="tr_bg1"><%=charge_id%></td>
    <td width="150"  align="right" class="title_bg"> 费用金额[元]： </td>
    <td width="245" class="tr_bg1">
    <%=charge_sum %>
    </td>
  </tr>
  <tr>
    <td align=right width=152 class="title_bg"> 收费人： </td>
    <td width=197 class="tr_bg1">
    <%      
      if (charge_person != null) {
        sql = "select employee_name from t_employee where";
        sql = sql + " employee_id='" + charge_person + "'";
        rs = db.executeQuery(sql);
        if (rs.next())
          out.print(rs.getString("employee_name"));
        else
          out.print("");
      }
    %>
    </td>
    <td align="right" width="150" class="title_bg"> 标的额[元]：</td>
    <td width=245 class="tr_bg1">
    <%=case_object%>
     </td>
  </tr>
  <tr>
    <td align=right width=152 class="title_bg"> 支付期限： </td>
    <td width=197 class="tr_bg1">
    <%=time_limit%>
    </td>
    <td align="right" width="150" class="title_bg"> 支付方式： </td>
    <td width=245 class="tr_bg1">
    <%
      if (payment_method != null)
        if (payment_method.equals("xj"))
          out.print("现金");
        else if (payment_method.equals("zz"))
          out.print("转账");
    %>
    </td>
  </tr>
  <tr>
    <td align=right width=152 class="title_bg"> 收费日期： </td>
    <td width=197 class="tr_bg1">
    <%=receive_time%>
    </td>
    <td align=right width=150 class="title_bg"> 收费标准： </td>
    <td width=245 class="tr_bg1" >
    <%=charge_standard%>
    </td>
  </tr>
  <tr>
    <td align=right width=152 class="title_bg"> 折扣比例： </td>
    <td width=197 class="tr_bg1">
    <%=discount%> %
    </td>
    <td align=right width=150 class="title_bg"> 折扣审批人： </td>
    <td width=245 class="tr_bg1" >   
    <%
      if (discount_person != null) {
        sql = "select employee_name from t_employee where";
        sql = sql + " employee_id='" + discount_person + "'";
        rs = db.executeQuery(sql);
        if (rs.next())
          discount_person = rs.getString("employee_name");
        else
          discount_person = "";	
      }
    %>
    <%=discount_person%>
    </td>
  </tr>
  <tr>    
    <td align="right" width="152" class="title_bg"> 律师分配比例：</td>
    <td width="197" class="tr_bg1">
    <%=part_proportion%> %
    </td>
    <td align=right width=150 class="title_bg"> 币种： </td>
    <td width=245 class="tr_bg1" >
    <%
      if (currency_kind != null)   
      {
        if (currency_kind.equals("rmb"))
          out.print("人民币");
        else if(currency_kind.equals("dollar"))
          out.print("美金");       
        else if(currency_kind.equals("hk"))
          out.print("港币");
       }
    %>
    </td>
  </tr>
  <tr>
    <td align=right width=152 class="title_bg"> 备注：</td>
    <td class="tr_bg1" width="592" colspan="3">
    <%=comment%>
    </td>
  </tr>
  </table>
</div>
<div id="Layer4" style="Position:absolute; top:70px; width:98%; height:70px; z-index:3; visibility: hidden"> 
  <table border="0" cellspacing="0" cellpadding="0" height="25" >
    <tr class="tr_bg1" align="center"> 
      <td  class="table_bg"  colspan="11" height="1" ></td>
    </tr>
    <tr class="tr_bg1" align="center"> 
      <td class="table_bg" width="1" ></td>
      <td onClick="MM_showHideLayers('Layer1','','show','Layer2','','hide','Layer3','','hide','Layer4','','hide','Layer5','','hide')" style="cursor:hand"   width="80" >顾问事务信息</td>
      <td class="table_bg" width="1"></td>
      <td  onClick="MM_showHideLayers('Layer1','','hide','Layer2','','show','Layer3','','hide','Layer4','','hide','Layer5','','hide')"  style="cursor:hand" width="80">顾问办理事务</td>
      <td  class="table_bg" width="1"></td>
      <td  onClick="MM_showHideLayers('Layer1','','hide','Layer2','','hide','Layer3','','show','Layer4','','hide','Layer5','','hide')"  style="cursor:hand" width="60">合同费用</td>
      <td  class="table_bg" width="1"></td>
      <td  onClick="MM_showHideLayers('Layer1','','hide','Layer2','','hide','Layer3','','hide','Layer4','','show','Layer5','','hide')"  style="cursor:hand" class="tr_bg2" width="80">其他费用列表</td>
      <td  class="table_bg" width="1"></td>
      <td  onClick="MM_showHideLayers('Layer1','','hide','Layer2','','hide','Layer3','','hide','Layer4','','hide','Layer5','','show')"  style="cursor:hand" width="70">委托人信息</td>
      <td  class="table_bg" width="1"></td>
    </tr>
  </table>
  <table align="center" border="0" cellspacing="1" cellpadding="5" class="table_bg" width="100%">
    <tr class="title_bg" align="center"> 
      <td width="11%" > 费用编号</td>
      <td width="25%"> 费用名称</td>
      <td width="12%" > 费用金额</td>
      <td width="13%" > 收取时间</td>
      <td width="12%" >支付方式</td>
      <td width="9%" >收费人</td>
      <td width="8%" >币种</td>
    </tr>            
    <%    
    String 	chargeID="",
    		chargeName="", 
    		chargeSum="", 
    		paymentMethod="", 
    		receiveTime="", 
    		chargePerson="", 
    		currencyKind ="";
    		
	int recordCount2 = 0;
	if(rs2 != null) 
	{
		rs2.last();
		recordCount2 = rs2.getRow();
		rs2.first();
	}
	
    for (int i=1; i <= recordCount2;i++) 
    {
    	chargeID=rs2.getString("charge_id");
    	chargeName=rs2.getString("charge_name");      
    	if(chargeName == null) chargeName = "";
    	chargeSum=rs2.getString("charge_sum"); 
    	if(chargeSum == null) chargeSum= "";
    	paymentMethod=rs2.getString("payment_method"); 
    	if(paymentMethod == null) paymentMethod = "";
    	receiveTime=rs2.getString("receive_time");
    	if(receiveTime == null) receiveTime = "";   
    	else receiveTime = receiveTime.substring(0,10);
    	chargePerson=rs2.getString("charge_person");     	
    	if(chargePerson == null) chargePerson = "";
    	currencyKind =rs2.getString("currency_kind");  
    	
    	paymentMethod = paymentMethod.trim();
    	if(paymentMethod == null) paymentMethod = ""; 
    	else if(paymentMethod.equals("xj")) paymentMethod = "现金"; 
    	else if(paymentMethod.equals("zz")) paymentMethod = "转帐"; 
    	if(currencyKind == null) currencyKind = "";
    	else if(currencyKind.equals("rmb")) currencyKind = "人民币";
    	else if(currencyKind.equals("dollar")) currencyKind = "美圆";	    	
    	else if(currencyKind.equals("hk")) currencyKind = "港币";      
    	//
    	ResultSet rs4 = db.executeQuery("select employee_name from t_employee ");
    	
    %>
    <tr class="tr_bg1" align="center"> 
      <td width="11%" > <%=chargeID%></td>
      <td width="25%"> <%=chargeName%></td>
      <td width="12%" > <%=chargeSum%></td>
      <td width="13%" > <%=receiveTime%></td>
      <td width="12%" > <%=paymentMethod%></td>
      <td width="9%" > <%=chargePerson%></td>
      <td width="8%" > <%=currencyKind%></td>
    </tr>    
    <%    
    if (!rs2.next())
    	   break;
    }
    %>
  </table>
  <table align="center" class="page_bg" width="100%">
    <tr> 
      <td align="left"> 共<span class="font1"> <%=recordCount2%></span> 条记录 </td>
    </tr>
  </table>
</div>
<div id="Layer5" style="Position:absolute; top:70px; width:98%; height:161px; z-index:4; visibility: hidden"> 
  <table border="0" cellspacing="0" cellpadding="0" height="25" >
    <tr class="tr_bg1" align="center"> 
      <td  class="table_bg"  colspan="11" height="1" ></td>
    </tr>
    <tr class="tr_bg1" align="center"> 
      <td class="table_bg" width="1" ></td>
      <td onClick="MM_showHideLayers('Layer1','','show','Layer2','','hide','Layer3','','hide','Layer4','','hide','Layer5','','hide')" style="cursor:hand"  width="80" >顾问事务信息</td>
      <td class="table_bg" width="1"></td>
      <td  onClick="MM_showHideLayers('Layer1','','hide','Layer2','','show','Layer3','','hide','Layer4','','hide','Layer5','','hide')"  style="cursor:hand" width="80">顾问办理事务</td>
      <td  class="table_bg" width="1"></td>
      <td  onClick="MM_showHideLayers('Layer1','','hide','Layer2','','hide','Layer3','','show','Layer4','','hide','Layer5','','hide')"  style="cursor:hand" width="60">合同费用</td>
      <td  class="table_bg" width="1"></td>
      <td  onClick="MM_showHideLayers('Layer1','','hide','Layer2','','hide','Layer3','','hide','Layer4','','show','Layer5','','hide')"  style="cursor:hand" width="80">其他费用列表</td>
      <td  class="table_bg" width="1"></td>
      <td  onClick="MM_showHideLayers('Layer1','','hide','Layer2','','hide','Layer3','','hide','Layer4','','hide','Layer5','','show')"  style="cursor:hand" class="tr_bg2"  width="70">委托人信息</td>
      <td  class="table_bg" width="1"></td>
    </tr>
  </table>
  <table width="100%" align="center" border="0" cellspacing="1" cellpadding="5" class="table_bg">
    <tr> 
      <td width="152"  align="right" class="title_bg"> 客户编号： </td>
      <td width="197" class="tr_bg1"> <%=customer_id%></td>
      <td width="150"  align="right" class="title_bg"> 客户名称： </td>
      <td width="245" class="tr_bg1"> <%=customer_name%></td>
    </tr>
    <tr> 
      <td align="right" width="152" class="title_bg"> 地址： </td>
      <td colspan="3" class="tr_bg1"> <%=address%> </td>
    </tr>
    <tr> 
      <td align=right width=152 class="title_bg"> 联系人： </td>
      <td width=197 class="tr_bg1"><%=link_man%></td>
      <td align="right" width="150" class="title_bg"> 客户类别： </td>
      <td width=245 class="tr_bg1"><%=customer_type%> </td>
    </tr>
    <tr> 
      <td align=right width=152 class="title_bg"> 电话： </td>
      <td width=197 class="tr_bg1"><%=telephone%></td>
      <td align=right width=150 class="title_bg"> 传真： </td>
      <td width=245 class="tr_bg1" ><%=fax%></td>
    </tr>
    <tr> 
      <td align=right width=152 class="title_bg"> 手机： </td>
      <td width=197 class="tr_bg1"> <%=mobile_telephone%></td>
      <td align=right width=150 class="title_bg"> E-Mail： </td>
      <td width=245 class="tr_bg1" > <a href=<%=email%>><%=email%></a></td>
    </tr>
    <tr> 
      <td align=right width=152 class="title_bg"> 客户简介： </td>
      <td width=592 class="tr_bg1" colspan="3"><%=customer_introduce%> </td>
    </tr>
  </table>
</div>
<table width="98%" align="center" cellspacing="1">
  <tr> 
    <td width="86%"><a href="Advisor.jsp"><img src="../images/all.gif" height="22" border="0" alt="显示所有内容"></a><a href="AdvisorAdd.jsp"><img src="../images/add.gif" alt="增加内容" width="79" height="22" border="0"></a><img src="../images/delete.gif" alt="删除选中的内容" onClick="return Del();" style="cursor:hand" width="79" height="22"><a href="AdvisorSearch.jsp"><img src="../images/query.gif" alt="查询内容"   width="79" height="22" border="0"></a><img src="../images/archive.gif" width="79" height="22"></td>
    <td align="right" width="14%"><img src="../images/back.gif" width="50" height="22" onclick="window.history.back()" style="cursor:hand" alt="返回"></td>
  </tr>
</table>
<table width="98%" background="../images/line.gif" border="0" cellspacing="0" cellpadding="0" height="12" align="center">
  <tr> 
    <td>&nbsp;</td>
  </tr>
</table>
<!--显示工具条结束-->
<table width="98%" align="center" border="0" cellspacing="0">
  <tr> 
    <td> 
      <div align="right"><a href="#"><img src="../images/prethread.gif" width="48" height="12" border="0"></a> 
        <a href="#"><img src="../images/nextthread.gif" width="48" height="12" border="0"></a> 
      </div>
    </td>
  </tr>
</table>
</body>
</html>