📄 negotiationamend.jsp
字号:
<%--
模块名称：参与谈判
模块功能：修改
版 本：V1.0
著 作 人：SIMM
著作日期：2001-10-31
该模块所需的文件：
使用说明：
主要技术说明：
参考文献：法律事务设计书
修改历史：= = = = = = = = = = = = = = = = = = = = = = = = = =
修改日期：
修 改 人：
修改理由：
修改出处：
= = = = = = = = = = = = = = = = = = = = = = = = = =
--%>
<%@ page language="java" import="java.util.Date,java.util.Locale,java.text.DateFormat"%>
<%@ page import="java.io.*,java.sql.*" contentType= "text/html; charset=gb2312" %>
<jsp:useBean id="db" class="dbconnection.DbConnection" scope="page" />
<%@ page import="system.*" %>
<%
Security auth = new Security();
String scu_employee_id = (String)session.getAttribute("employee_id");
if(scu_employee_id == null || scu_employee_id.equals(""))
{
response.sendRedirect(response.encodeRedirectURL("../Error/nonlogin.htm"));
}
String modelid = "Law023"; // 案件管理/顾问管理修改
int authflag = auth.popedom(scu_employee_id, modelid);
if(authflag == 0 || authflag == 2 || authflag == -1)
{%>
<jsp:forward page="../inc/noauth.jsp" >
</jsp:forward>
<%}%>
<%
//---------------------------------------
//BEGIN----信息处理部分
//-----------------------------------------
String caseID = "", //案件编码
caseReason = "", //案由
beginDate = "", //时间
mainContent = "", //内容
referForeign = "", //涉外信息
charged = "", //是否收费
noPayReason = "", //免费事由
lawyer = "", //承办律师
customer = "",
customerID = "";
caseID = request.getParameter("caseID");
String sql = "select CASE_REASON,BEGIN_DATE" +
", main_content, refer_foreign" +
", charged, no_pay_reason, EMPLOYEE_name " +
", customer_name, customer_id" +
" from v_nonsueinfo where CASE_ID = '" + caseID + "'"; //查询记录
ResultSet rs = db.executeQuery(sql);
if (!rs.next())
{
return;
}
else
{
caseReason = rs.getString("case_reason");
beginDate = rs.getString("begin_date"); //时间
if(beginDate == null) beginDate = ""; //判断空值，不显示为NULL
else beginDate = beginDate.substring(0,10); //时间格式转换
mainContent = rs.getString("main_content"); //内容
if(mainContent == null) mainContent = "";
referForeign = rs.getString("refer_foreign"); //涉外信息
charged = rs.getString("charged"); //是否收费
noPayReason = rs.getString("no_pay_reason"); //免费事由
if(noPayReason == null) noPayReason = "";
lawyer = rs.getString("employee_name"); //承办律师
if(lawyer == null) lawyer = "";
customer = rs.getString("customer_name");
if(customer == null) customer = "";
customerID = rs.getString("customer_id");
}
//---------------------------------------
//END---案件信息处理部分
//-----------------------------------------
//-----------------------------------------
//BEGIN---费用信息部分--------------------
String charge_id = "",
charge_sum = "",
case_id = "",
case_reason = "",
part_proportion = "",
case_object = "",
time_limit = "";
String payment_method = "",
receive_time = "",
charge_standard = "",
discount = "",
discount_person = "",
charge_person = "",
currency_kind = "",
comment = "";
sql = "select a.charge_id, a.charge_sum, a.case_id, a.part_proportion,";
sql = sql + "a.case_object, a.time_limit, a.payment_method, a.receive_time,";
sql = sql + "a.charge_standard, a.discount, a.discount_person,";
sql = sql + " a.charge_person, a.currency_kind, a.comment";
sql = sql + " from t_charge a where";
sql = sql + " a.case_id = '" + caseID + "'";
sql = sql + " and a.charge_type = 'ht'";
rs = db.executeQuery(sql);
if (rs.next()) {
charge_id = rs.getString("charge_id");
charge_sum = rs.getString("charge_sum");
if ((charge_sum.indexOf(".")) >= 0) {
charge_sum=charge_sum + "00";
charge_sum=charge_sum.substring(0,charge_sum.indexOf(".")+3);
}
part_proportion = rs.getString("part_proportion");
if(part_proportion == null) part_proportion = "";
case_object = rs.getString("case_object");
if(case_object == null) case_object = "";
time_limit = rs.getString("time_limit");
payment_method = rs.getString("payment_method");
receive_time = rs.getString("receive_time");
charge_standard = rs.getString("charge_standard");
if(charge_standard == null) charge_standard = "";
discount = rs.getString("discount");
if(discount == null) discount = "";
discount_person = rs.getString("discount_person");
if(discount_person == null) discount_person = "";
charge_person = rs.getString("charge_person");
if(charge_person == null) charge_person = "";
currency_kind = rs.getString("currency_kind");
comment = rs.getString("comment");
if(comment == null) comment = "";
if(time_limit != null) time_limit = time_limit.substring(0,10);
else time_limit = "";
if(receive_time != null) receive_time = receive_time.substring(0,10);
else receive_time = "";
}
//END---------------------------------------------
//-------------------------------------------
//BEGIN 其他费用列表显示
sql = "select charge_id, charge_name, charge_sum,";
sql = sql + " payment_method, receive_time,";
sql = sql + " charge_person, currency_kind";
sql = sql + " from t_charge where";
sql = sql + " case_id = '" + caseID + "'";
sql = sql + " and charge_type = 'qt'";
ResultSet rs2 = db.executeQuery(sql);
//END---------------------------------------------
//-------------------------------------------
//BEGIN--客户信息处理---c
String cLinkMan = "",
cCustomerID = "",
cCustomerName = "",
cTelephone = "",
cMobile = "",
cFax = "",
cEmail = "",
cCustomerType = "",
engCustomerType = "", //拼音代号
cAddress = "",
cCustomerIntroduce = "";
sql = "select link_man, customer_name, telephone,";
sql = sql + "mobile_telephone, fax, email, customer_type, address,";
sql = sql + "customer_introduce from t_customer where customer_id='";
sql = sql + customerID + "'";
rs = db.executeQuery(sql);
if (rs.next()) {
cLinkMan = rs.getString("link_man");
if(cLinkMan == null) cLinkMan = "";
cCustomerID = customerID;
cCustomerName = rs.getString("customer_name");
if(cCustomerName == null) cCustomerName = "";
cTelephone = rs.getString("telephone");
if(cTelephone == null) cTelephone = "";
cMobile = rs.getString("mobile_telephone");
if(cMobile == null) cMobile = "";
cFax = rs.getString("fax");
if(cFax == null) cFax = "";
cEmail = rs.getString("email");
if(cEmail == null) cEmail = "";
cCustomerType = rs.getString("customer_type");
cAddress = rs.getString("address");
if(cAddress == null) cAddress = "";
cCustomerIntroduce = rs.getString("customer_introduce");
if(cCustomerIntroduce == null) cCustomerIntroduce = "";
if(cCustomerType != null) engCustomerType = cCustomerType;
if(cCustomerType == null) cCustomerType = "";
else if(cCustomerType.equals("zf")) cCustomerType = "政府";
else if(cCustomerType.equals("gq")) cCustomerType = "国企";
else if(cCustomerType.equals("sz")) cCustomerType = "三资";
else if(cCustomerType.equals("my")) cCustomerType = "民营";
else if(cCustomerType.equals("gr")) cCustomerType = "个人";
else if(cCustomerType.equals("qt")) cCustomerType = "其他";
}
//END---------------------------------------------
%>
<html>
<head>
<title>参与谈判修改</title>
<%@ include file="../inc/config.jsp" %>
<script language="javascript">
//检查输入的合法性
function checkForm()
{
if (document.myForm.txtCaseID.value=="")
{
MM_showHideLayers('Layer1','','show','Layer2','','hide','Layer3','','hide','Layer4','','hide')
alert("请输入编码！");
document.myForm.txtCaseID.focus();
return false;
}
if (document.myForm.txtLawyer.value=="")
{
MM_showHideLayers('Layer1','','show','Layer2','','hide','Layer3','','hide','Layer4','','hide')
alert("请输入承办律师！");
document.myForm.txtLawyer.focus();
return false;
}
if (document.myForm.txtCaseReason.value=="")
{
MM_showHideLayers('Layer1','','show','Layer2','','hide','Layer3','','hide','Layer4','','hide')
alert("请输入案由内容！");
document.myForm.txtCaseReason.focus();
return false;
}
if (document.myForm.txtBeginDate.value=="")
{
MM_showHideLayers('Layer1','','show','Layer2','','hide','Layer3','','hide','Layer4','','hide')
alert("请输入开始时间！");
document.myForm.txtBeginDate.focus();
return false;
}
if ((document.myForm.txtCharged.value=="1") &&
(document.myForm.txtNoPayReason.value!=""))
{
MM_showHideLayers('Layer1','','show','Layer2','','hide','Layer3','','hide','Layer4','','hide')
alert("收费时不应该有免费原由！");
document.myForm.txtNoPayReason.focus();
return false;
}
if (document.myForm.txtMainContent.value.length>400)
{
alert("谈判内容长度不能超过400个字！");
document.myForm.txtMainContent.focus();
return false;
}
return true;
}
</script>
</head>
<body class="page">
<!--显示工具条-->
<form name="myForm" METHOD="post" action="NegotiationAmendRun.jsp">
<div id="Layer1" style="Position:absolute; top:70px; width:98%; height:236px; z-index:1; visibility: visible">
<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')" style="cursor:hand" class="tr_bg2" width="70" >案件信息</td>
<td class="table_bg" width="1"></td>
<td onClick="MM_showHideLayers('Layer1','','hide','Layer2','','show','Layer3','','hide','Layer4','','hide')" style="cursor:hand" width="70">费用信息</td>
<td class="table_bg" width="1"></td>
<td onClick="MM_showHideLayers('Layer1','','hide','Layer2','','hide','Layer3','','show','Layer4','','hide')" style="cursor:hand" width="90">其他费用列表</td>
<td class="table_bg" width="1"></td>
<td onClick="MM_showHideLayers('Layer1','','hide','Layer2','','hide','Layer3','','hide','Layer4','','show')" style="cursor:hand" width="80">委托人信息</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>
<td width="18%" align="right" class="title_bg"> 编 码:</td>
<td width="28%" class="tr_bg1">
<input name="txtCaseID" size="12" class="input" readOnly value=<%=caseID%>>
<font color="#FF0000">* </font>
</td>
<td width="18%" class="title_bg" align="right"> 客户名称：</td>
<td width="35%" class="tr_bg1">
<select name="txtCustomer" class="select">
<option value=""> </option>
<%
rs = db.executeQuery("select customer_id, customer_name from t_customer");
String customer_id="",customer_name="";
while (rs.next())
{
customer_id = rs.getString("customer_id");
customer_name = rs.getString("customer_name");
customer_name = customer_name.trim();
customer = customer.trim();
%>
<option value=<%=customer_id%> <%if(customer_name.equals(customer)){%> selected<%}%>><%=customer_name%></option>
<%
} %>
<option value=""> _______________________ </option>
</select>
</td>
</tr>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -