publicparm.jsp

价值几千的通达ea2008组件版 破解补丁 绝对可用

<%@ include file="/module/header/index.jsp" %>
<%@ page import="com.sysparm.*" %>
<%@ page import="java.sql.*"    %>
<jsp:useBean id="Messjdbc"   scope="page" class="jdbcconn.grpJdbcOracleTrue"/>
<jsp:useBean id="TDEAJdbcOA" scope="page" class="jdbcconn.TDEAJdbcOA"/>
<script language=javascript>
	function sendForm() {
		if (document.all.form1.UnitName.value == null || document.all.form1.UnitName.value == "") {
			alert("请输入系统使用单位");
			return(false);
		}
		if (document.all.form1.PageSize.value == null || document.all.form1.PageSize.value == "") {
			alert("请输入每页显示行数");
			return(false);
		}
		
		var userIdStr=form1.TO_ID.value;
		var userNum=form1.TO_Num.value;
		var userNum=10000;//9:32 2008-9-5 Germ
		var arr_id=userIdStr.split(","); 
		var thisNum=arr_id.length-1;		
		form1.flag.value = "update";
		form1.submit();
	}
	function LoadWindow()
{
  URL="/module/user_select";
  loc_x=document.body.scrollLeft+event.clientX-event.offsetX-100;
  loc_y=document.body.scrollTop+event.clientY-event.offsetY+170;
  window.showModalDialog(URL,self,"edge:raised;scroll:0;status:0;help:0;resizable:1;dialogWidth:350px;dialogHeight:350px;dialogTop:"+loc_y+"px;dialogLeft:"+loc_x+"px");
//  window.open(URL,null,"height=400,width=550,status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left=100,resizable=yes");
}
</script>

<%
	Connection conn = null;
	ResultSet  rs   = null;
	Statement  stmt = null;
	request.setCharacterEncoding("gb2312");
	String flag=request.getParameter("flag");
	flag=flag==null? "":flag;
    String EAVersion="";
    EAVersion=request.getParameter("EAVersion");//
    EAVersion=EAVersion==null?"":EAVersion;
	String UnitName=request.getParameter("UnitName");//
	UnitName=UnitName==null?"":UnitName;
	String PageSize=request.getParameter("PageSize");//
	PageSize=PageSize==null?"":PageSize;
	String StockIsNeg=request.getParameter("StockIsNeg");//
	StockIsNeg=StockIsNeg==null?"":StockIsNeg;
	String ExchRate=request.getParameter("ExchRate");//
	ExchRate=ExchRate==null?"":ExchRate;	

	String  ProductScope=request.getParameter("ProductScope");//商品权限
	ProductScope=ProductScope==null?"":ProductScope;
	String  StockScope=request.getParameter("StockScope");//库存权限
	StockScope=StockScope==null?"":StockScope;

	String BuyTaxRate=request.getParameter("BuyTaxRate");//采购税率
    BuyTaxRate=BuyTaxRate==null?"":BuyTaxRate;
	String SellTaxRate=request.getParameter("SellTaxRate");//销售税率
	SellTaxRate=SellTaxRate==null?"":SellTaxRate;
	String dataTimeScope=request.getParameter("dataTimeScope");//日期范围
	dataTimeScope=dataTimeScope==null?"":dataTimeScope;

	String amtDot=request.getParameter("amtDot");//金额的显示位数
	amtDot=amtDot==null?"":amtDot; 
  String numDot=request.getParameter("numDot");//数量的显示位数
	numDot=numDot==null?"":numDot;   
	
	String incost=request.getParameter("incost");//入库成本
	incost=incost==null?"":incost; 
	
	String outrate=request.getParameter("outrate");//出库利润
	outrate=outrate==null?"":outrate; 
	
	
	 String userIdStr=request.getParameter("TO_ID");//用户
	userIdStr=userIdStr==null?"":userIdStr;
	//userIdStr = new String(userIdStr.getBytes("ISO8859_1"), "gb2312");
  String userNameStr=request.getParameter("TO_NAME");//用户
	userNameStr=userNameStr==null?"":userNameStr;
	//userNameStr = new String(userNameStr.getBytes("ISO8859_1"), "gb2312");
	String userIdNum=request.getParameter("TO_Num");//用户
	userIdNum=userIdNum==null?"":userIdNum;
	
	
	String updateSql = "";
	String selectSql = "";
	String oldAmtDot = "";
  String oldNumDot = "";
	if (flag.equals("update")) {
		try {
			conn = Messjdbc.connDbms();	
			stmt = conn.createStatement();
			
			if (!userIdStr.equals("")){
			updateSql = "update sysparam set para_value='" + userIdStr + "' where para_no='P76'";
			updateSql = new String(updateSql.getBytes("gb2312"), "ISO8859_1");
			rs = stmt.executeQuery(updateSql);
			rs.close();
			}
			
			updateSql = "update sysparam set para_value='" + UnitName + "' where para_no='P01'";
			updateSql = new String(updateSql.getBytes("gb2312"), "ISO8859_1");
			rs = stmt.executeQuery(updateSql);
			rs.close();

			updateSql = "update sysparam set para_value='" + PageSize + "' where para_no='P02'";
			updateSql = new String(updateSql.getBytes("gb2312"), "ISO8859_1");
			rs = stmt.executeQuery(updateSql);
			rs.close();

			updateSql = "update sysparam set para_value='" + StockIsNeg + "' where para_no='P17'";
			updateSql = new String(updateSql.getBytes("gb2312"), "ISO8859_1");
			rs = stmt.executeQuery(updateSql);
			rs.close();

			updateSql = "update sysparam set para_value='" + ExchRate + "' where para_no='P18'";
			updateSql = new String(updateSql.getBytes("gb2312"), "ISO8859_1");
			rs = stmt.executeQuery(updateSql);
			rs.close();

			selectSql = "select para_value from sysparam  where para_no='P65'";
			rs = stmt.executeQuery(selectSql);
			while (rs.next()) {
				oldAmtDot = rs.getString(1);
				oldAmtDot = oldAmtDot==null?"":oldAmtDot;
			}   
			if (!oldAmtDot.equals(amtDot)) {//基本参数改变的情况下，改动数据库结构
			   updateSql = "update sysparam set para_value='"+amtDot+"' where para_no='P65'";
			   updateSql = new String(updateSql.getBytes("gb2312"),"ISO8859_1"); 
			   rs = stmt.executeQuery(updateSql);
			   //采购计划单
			   rs = stmt.executeQuery("ALTER TABLE "+(String)session.getAttribute("User_Account")+".requireplanmain MODIFY  amt DECIMAL(20,"+amtDot+") default '0',"
			   + "MODIFY  payamt DECIMAL(20,"+amtDot+") default '0',MODIFY  factpayamt DECIMAL(20,"+amtDot+") default '0';");
			   rs = stmt.executeQuery("ALTER TABLE "+(String)session.getAttribute("User_Account")+".requireplandetail MODIFY  price DECIMAL(20,"+amtDot+") default '0',"
			   + "MODIFY  money DECIMAL(20,"+amtDot+") default '0',MODIFY  faxprice DECIMAL(20,"+amtDot+") default '0',MODIFY  faxamt DECIMAL(20,"+amtDot+") default '0';");
			   //采购定单
			   rs = stmt.executeQuery("ALTER TABLE "+(String)session.getAttribute("User_Account")+".buyplanmain MODIFY  amt DECIMAL(20,"+amtDot+") default '0',"
			   + "MODIFY  payamt DECIMAL(20,"+amtDot+") default '0',MODIFY  factpayamt DECIMAL(20,"+amtDot+") default '0';");
			   rs = stmt.executeQuery("ALTER TABLE "+(String)session.getAttribute("User_Account")+".buyplandetail MODIFY  price DECIMAL(20,"+amtDot+") default '0',"
			   +" MODIFY  money DECIMAL(20,"+amtDot+") default '0',MODIFY  faxprice DECIMAL(20,"+amtDot+") default '0',MODIFY  faxamt DECIMAL(20,"+amtDot+") default '0';");
			   //采购入库单
			   rs = stmt.executeQuery("ALTER TABLE "+(String)session.getAttribute("User_Account")+".stockinmain MODIFY  amt DECIMAL(20,"+amtDot+") default '0',"
			   + "MODIFY  payamt DECIMAL(20,"+amtDot+") default '0',MODIFY  factpayamt DECIMAL(20,"+amtDot+") default '0'"
			   + ",MODIFY  sendAmt DECIMAL(20,"+amtDot+") default '0',MODIFY  noFaxAmt DECIMAL(20,"+amtDot+") default '0';");
			   rs = stmt.executeQuery("ALTER TABLE "+(String)session.getAttribute("User_Account")+".stockindetail MODIFY  price DECIMAL(20,"+amtDot+") default '0',"
			   + "MODIFY  money DECIMAL(20,"+amtDot+") default '0',MODIFY  faxprice DECIMAL(20,"+amtDot+") default '0',MODIFY  faxamt DECIMAL(20,"+amtDot+") default '0';");
			   //销售计划单
			   rs = stmt.executeQuery("ALTER TABLE "+(String)session.getAttribute("User_Account")+".sellplanmain MODIFY  amt DECIMAL(20,"+amtDot+") default '0',"
			   + "MODIFY  payamt DECIMAL(20,"+amtDot+") default '0',MODIFY  factpayamt DECIMAL(20,"+amtDot+") default '0';");
			   rs = stmt.executeQuery("ALTER TABLE "+(String)session.getAttribute("User_Account")+".sellplandetail MODIFY  price DECIMAL(20,"+amtDot+") default '0',"
			   + "MODIFY  money DECIMAL(20,"+amtDot+") default '0',MODIFY  faxprice DECIMAL(20,"+amtDot+") default '0',MODIFY  faxamt DECIMAL(20,"+amtDot+") default '0';");
			   //销售出库单
			   rs = stmt.executeQuery("ALTER TABLE "+(String)session.getAttribute("User_Account")+".stockoutmain MODIFY  amt DECIMAL(20,"+amtDot+") default '0',"
			   + "MODIFY  payamt DECIMAL(20,"+amtDot+") default '0',MODIFY  factpayamt DECIMAL(20,"+amtDot+") default '0'"
			   + ",MODIFY  sendAmt DECIMAL(20,"+amtDot+") default '0',MODIFY  noFaxAmt DECIMAL(20,"+amtDot+") default '0';");
			   rs = stmt.executeQuery("ALTER TABLE "+(String)session.getAttribute("User_Account")+".stockoutdetail MODIFY  price DECIMAL(20,"+amtDot+") default '0',"
			   + "MODIFY  money DECIMAL(20,"+amtDot+") default '0'"
			   +",MODIFY  profitmoney DECIMAL(20,"+amtDot+") default '0',MODIFY  costmoney DECIMAL(20,"+amtDot+") default '0',MODIFY  faxprice DECIMAL(20,"+amtDot+") default '0',MODIFY  faxamt DECIMAL(20,"+amtDot+") default '0';");
			   //销售送货单
			   rs = stmt.executeQuery("ALTER TABLE "+(String)session.getAttribute("User_Account")+".sendmain MODIFY  amt DECIMAL(20,"+amtDot+") default '0',"
			   + "MODIFY  payamt DECIMAL(20,"+amtDot+") default '0',MODIFY  factpayamt DECIMAL(20,"+amtDot+") default '0'"
			   + ",MODIFY  sendAmt DECIMAL(20,"+amtDot+") default '0',MODIFY  noFaxAmt DECIMAL(20,"+amtDot+") default '0';");
			   rs = stmt.executeQuery("ALTER TABLE "+(String)session.getAttribute("User_Account")+".senddetail MODIFY  price DECIMAL(20,"+amtDot+") default '0',"
			   + "MODIFY  money DECIMAL(20,"+amtDot+") default '0',MODIFY  faxprice DECIMAL(20,"+amtDot+") default '0',MODIFY  faxamt DECIMAL(20,"+amtDot+") default '0'"
			   +";");
			   //库存总账
			   rs = stmt.executeQuery("ALTER TABLE "+(String)session.getAttribute("User_Account")+".store MODIFY  price DECIMAL(20,"+amtDot+") default '0',"
			   + "MODIFY  amt DECIMAL(20,"+amtDot+") default '0';");
			   //库存明细帐
			   rs = stmt.executeQuery("ALTER TABLE "+(String)session.getAttribute("User_Account")+".storedetail MODIFY  stockinfactprice DECIMAL(20,"+amtDot+") default '0',"
			   + "MODIFY  storeamt DECIMAL(20,"+amtDot+") default '0';");
			   //商品属性
			   rs = stmt.executeQuery("ALTER TABLE "+(String)session.getAttribute("User_Account")+".product MODIFY  sellprice DECIMAL(20,"+amtDot+") default '0',"
			   + "MODIFY  buyprice DECIMAL(20,"+amtDot+") default '0',MODIFY  sellprice2 DECIMAL(20,"+amtDot+") default '0',"
			   + "MODIFY  sellprice3 DECIMAL(20,"+amtDot+") default '0',MODIFY  sellprice4 DECIMAL(20,"+amtDot+") default '0',"
			   + "MODIFY  sellprice5 DECIMAL(20,"+amtDot+") default '0';");
			   //商品明细帐
			   rs = stmt.executeQuery("ALTER TABLE "+(String)session.getAttribute("User_Account")+".storeflowdetail MODIFY  fromprice DECIMAL(20,"+amtDot+") default '0',"
			   + "MODIFY  frommoney DECIMAL(20,"+amtDot+") default '0',MODIFY  inprice DECIMAL(20,"+amtDot+") default '0',"
			   + "MODIFY  inmoney DECIMAL(20,"+amtDot+") default '0',MODIFY  outprice DECIMAL(20,"+amtDot+") default '0',"
			   + "MODIFY  outmoney DECIMAL(20,"+amtDot+") default '0',MODIFY  endprice DECIMAL(20,"+amtDot+") default '0',"
			   + "MODIFY  endmoney DECIMAL(20,"+amtDot+") default '0';");
			   //生产计划单
			   rs = stmt.executeQuery("ALTER TABLE "+(String)session.getAttribute("User_Account")+".manuplanmain MODIFY  amt DECIMAL(20,"+amtDot+") default '0',"
			   + "MODIFY  payamt DECIMAL(20,"+amtDot+") default '0',MODIFY  factpayamt DECIMAL(20,"+amtDot+") default '0'"
			   +",MODIFY  noFaxAmt DECIMAL(20,"+amtDot+") default '0',MODIFY  sendAmt DECIMAL(20,"+amtDot+") default '0';");
			   rs = stmt.executeQuery("ALTER TABLE "+(String)session.getAttribute("User_Account")+".manuplandetail MODIFY  price DECIMAL(20,"+amtDot+") default '0',"
			   + "MODIFY  money DECIMAL(20,"+amtDot+") default '0'"
			   +",MODIFY  profitmoney DECIMAL(20,"+amtDot+") default '0',MODIFY  costmoney DECIMAL(20,"+amtDot+") default '0';");
			   //生产任务单
			   rs = stmt.executeQuery("ALTER TABLE "+(String)session.getAttribute("User_Account")+".manuprodmain MODIFY  amt DECIMAL(20,"+amtDot+") default '0',"
			   + "MODIFY  payamt DECIMAL(20,"+amtDot+") default '0',MODIFY  factpayamt DECIMAL(20,"+amtDot+") default '0'"
			   +",MODIFY  noFaxAmt DECIMAL(20,"+amtDot+") default '0',MODIFY  sendAmt DECIMAL(20,"+amtDot+") default '0';");
			   rs = stmt.executeQuery("ALTER TABLE "+(String)session.getAttribute("User_Account")+".manuproddetail MODIFY  price DECIMAL(20,"+amtDot+") default '0',"
			   + "MODIFY  money DECIMAL(20,"+amtDot+") default '0'"
			   +",MODIFY  profitmoney DECIMAL(20,"+amtDot+") default '0',MODIFY  costmoney DECIMAL(20,"+amtDot+") default '0';");
			}
			rs.close();

			selectSql = "select para_value from sysparam  where para_no='P72'";
			rs = stmt.executeQuery(selectSql);
			while (rs.next()) {
				oldNumDot = rs.getString(1);
				oldNumDot = oldNumDot==null?"":oldNumDot;
			}