09. december 2004 - 21:23
Der er
2 kommentarer og
1 løsning
Overførsel af data fra et Javascript til et andet
Hejsa
Jeg vil gerne have overført et tal fra en JavaScript kode til et andet på samme side, for at der ikke skal opstå forvirring om hvad det er jeg søger, er her en lille forklaring:
Aller først skal man på siden vælge et vare nr, hvorefter beskrivelse og Pris bliver smidt ud i 2 text form felter! I samme hug vil jeg gerne have prisen smidt ind i følgende kode hvor der står 1.60:
onkeyup="calc('total<%=trim(linenr2rs("linenr"))%>', antal<%=trim(linenr2rs("linenr"))%>.value, '1.60')">
Den totale kode er som følger:
########################################################
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Holmberg Consult - Ordre Seddel</title>
<link rel="STYLESHEET" type="text/css" href="../../../frame/holmbergcss.css">
<script language="javascript"><!--
function ciffer2(total) {
if ((i = total.indexOf('.')) > -1) {
tmpstr = total.substring(++i);
total = total.substr(0, i);
if (tmpstr.length < 2) {
resstr = tmpstr;
for (c = tmpstr.length; c < 2; c++)
resstr += '0';
} else {
resstr = tmpstr.substr(0, 2);
}
total += resstr;
} else {
total += '.00';
}
return total;
}
function calc(dest, _amount, _price) {
amount = parseInt(_amount);
if (!isNaN(amount)) { //is amount a number
total = String(amount * parseFloat(_price));
eval('document.forms[0].'+dest).value = ciffer2(total);
} else {
eval('document.forms[0].'+dest).value = '0.00';
}
calcTotal();
}
function calcTotal() {
e = document.forms[0].elements;
total = 0.0;
for (i=0; i < e.length; i++) {
if (e[i].name.indexOf('total')>-1) {
total += parseFloat(e[i].value);
}
}
document.forms[0].formtot.value = ciffer2(String(total));
}
//-->
</script>
<%
'####### Order Line ############
'## Create db objects and SQL
set linenrConn = Server.CreateObject("ADODB.Connection")
linenrConn.Open Application("ConnectString")
Set linenrrs = Server.CreateObject("ADODB.Recordset")
linenrSql = "SELECT * FROM orderlinecounter;"
Set linenrrs = linenrConn.Execute(linenrSql)
Do while not linenrrs.EOF
%>
<script type="text/javascript">
var values<%=trim(linenrrs("linenr"))%>=new Array();
<%
'####### prod price ############
'## Create db objects and SQL
set prodpriceConn = Server.CreateObject("ADODB.Connection")
prodpriceConn.Open Application("ConnectString")
Set prodpricers = Server.CreateObject("ADODB.Recordset")
prodpriceSql = "SELECT id,prodheadline,price FROM product;"
Set prodpricers = prodpriceConn.Execute(prodpriceSql)
Do while not prodpricers.EOF
%>
values<%=trim(linenrrs("linenr"))%>[<%=prodpricers("id")%>] = new Array('<%=prodpricers("prodheadline")%>', '<%=prodpricers("price")%>');
<%
prodpricers.MoveNext
Loop
%>
function populate<%=trim(linenrrs("linenr"))%>(num){
document.getElementById('field<%=trim(linenrrs("linenr"))%>one').value = values<%=trim(linenrrs("linenr"))%>[num][0];
document.getElementById('field<%=trim(linenrrs("linenr"))%>two').value = values<%=trim(linenrrs("linenr"))%>[num][1];
}
</script>
<%
linenrrs.MoveNext
Loop
%>
</head>
<body>
<center>
<form method="post" action="ordreseddel.asp" name="orderlines">
<table cellspacing="0" cellpadding="0" border="0" style="width: 666px" class="inputbox">
<tr>
<td valign="top" align="left" style="width: 666px">
<table border="0" cellpadding="0" cellspacing="0">
<tr>
<td bgcolor="#333366"><font size="1" face="Verdana" color="FFFFFF"><b>Vare Nr.</b></font></td>
<td bgcolor="#333366"><font size="1" face="Verdana" color="FFFFFF"><b>Vare beskrivelse</b></font></td>
<td bgcolor="#333366"><font size="1" face="Verdana" color="FFFFFF"><b>Pris</b></font></td>
<td bgcolor="#333366"><font size="1" face="Verdana" color="FFFFFF"><b>Stk</b></font></td>
<td bgcolor="#333366"><font size="1" face="Verdana" color="FFFFFF"><b>Pris Ialt</b></font></td>
</tr>
<%
'####### Order Line 2 ############
'## Create db objects and SQL
set linenr2Conn = Server.CreateObject("ADODB.Connection")
linenr2Conn.Open Application("ConnectString")
Set linenr2rs = Server.CreateObject("ADODB.Recordset")
linenr2Sql = "SELECT * FROM orderlinecounter;"
Set linenr2rs = linenr2Conn.Execute(linenr2Sql)
Do while not linenr2rs.EOF
%>
<tr>
<td bgcolor="#333366">
<select style="width: 95px" class="inputbox" name="select" onchange="populate<%=trim(linenr2rs("linenr"))%>(this.options[selectedIndex].value)">
<option value="choose" SELECTED>Vælg</option>
<%
'####### prod ############
'## Create db objects and SQL
set prodConn = Server.CreateObject("ADODB.Connection")
prodConn.Open Application("ConnectString")
Set prodrs = Server.CreateObject("ADODB.Recordset")
prodSql = "SELECT id,varenr FROM product;"
Set prodrs = prodConn.Execute(prodSql)
Do while not prodrs.EOF
%>
<option value="<%=trim(prodrs("id"))%>"><%=trim(prodrs("varenr"))%></option>
<%
prodrs.MoveNext
Loop
%>
</select>
</td>
<td bgcolor="#333366"><input style="width: 300px" class="inputbox" name="field<%=trim(linenr2rs("linenr"))%>one" type="text" id="field<%=trim(linenr2rs("linenr"))%>one"></td>
<td bgcolor="#333366"><input style="width: 90px;" class="inputboxright" name="field<%=trim(linenr2rs("linenr"))%>two" type="text" id="field<%=trim(linenr2rs("linenr"))%>two"></td>
<td bgcolor="#333366"><input style="width: 90px;" class="inputboxright" type="text" name="antal<%=trim(linenr2rs("linenr"))%>" id="antal<%=trim(linenr2rs("linenr"))%>" onkeyup="calc('total<%=trim(linenr2rs("linenr"))%>', antal<%=trim(linenr2rs("linenr"))%>.value, '1.60')"></td>
<td bgcolor="#333366"><input style="width: 90px;" class="inputboxright" type="text" name="total<%=trim(linenr2rs("linenr"))%>" value="0.00"></td>
<%
linenr2rs.MoveNext
Loop
%>
</tr>
</table>
</td>
</tr>
</table>
<input type="text" name="formtot" value="0.00" style="width: 80px" readonly>
</form>
</center>
</body>
</html>
########################################################
Er der nogen som kan hjælpe mig???
PFT
Stig :-)
10. december 2004 - 07:09
#2
Hej Ole
Her er den så *S
#########################################################
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Holmberg Consult - Ordre Seddel</title>
<link rel="STYLESHEET" type="text/css" href="../../../frame/holmbergcss.css">
<script language="javascript"><!--
function ciffer2(total) {
if ((i = total.indexOf('.')) > -1) {
tmpstr = total.substring(++i);
total = total.substr(0, i);
if (tmpstr.length < 2) {
resstr = tmpstr;
for (c = tmpstr.length; c < 2; c++)
resstr += '0';
} else {
resstr = tmpstr.substr(0, 2);
}
total += resstr;
} else {
total += '.00';
}
return total;
}
function calc(dest, _amount, _price) {
amount = parseInt(_amount);
if (!isNaN(amount)) { //is amount a number
total = String(amount * parseFloat(_price));
eval('document.forms[0].'+dest).value = ciffer2(total);
} else {
eval('document.forms[0].'+dest).value = '0.00';
}
calcTotal();
}
function calcTotal() {
e = document.forms[0].elements;
total = 0.0;
for (i=0; i < e.length; i++) {
if (e[i].name.indexOf('total')>-1) {
total += parseFloat(e[i].value);
}
}
document.forms[0].formtot.value = ciffer2(String(total));
}
//-->
</script>
<script type="text/javascript">
var values1=new Array();
values1[1] = new Array('test test test test test test test test test test ', '909000');
values1[2] = new Array('Overskrift', '22990');
values1[3] = new Array('Overskrift', '22990');
values1[8] = new Array('kljkj', '909');
values1[10] = new Array('1', '8989');
values1[11] = new Array('kljkl j', '90909');
values1[12] = new Array('kljlk lkj', '990');
values1[18] = new Array('kljlk lkj', '990');
values1[19] = new Array('kljlk lkj', '990');
values1[20] = new Array('kljlk lkj', '990');
values1[21] = new Array('kljlk lkj', '990');
values1[22] = new Array('1', '8989');
values1[23] = new Array('kljkl j', '90909');
values1[24] = new Array('kljlk lkj', '990');
values1[25] = new Array('kljlk lkj', '990');
values1[26] = new Array('kljlk lkj', '990');
values1[27] = new Array('kljlk lkj', '990');
values1[28] = new Array('kljlk lkj', '990');
function populate1(num){
document.getElementById('field1one').value = values1[num][0];
document.getElementById('field1two').value = values1[num][1];
}
</script>
<script type="text/javascript">
var values2=new Array();
values2[1] = new Array('test test test test test test test test test test ', '909000');
values2[2] = new Array('Overskrift', '22990');
values2[3] = new Array('Overskrift', '22990');
values2[8] = new Array('kljkj', '909');
values2[10] = new Array('1', '8989');
values2[11] = new Array('kljkl j', '90909');
values2[12] = new Array('kljlk lkj', '990');
values2[18] = new Array('kljlk lkj', '990');
values2[19] = new Array('kljlk lkj', '990');
values2[20] = new Array('kljlk lkj', '990');
values2[21] = new Array('kljlk lkj', '990');
values2[22] = new Array('1', '8989');
values2[23] = new Array('kljkl j', '90909');
values2[24] = new Array('kljlk lkj', '990');
values2[25] = new Array('kljlk lkj', '990');
values2[26] = new Array('kljlk lkj', '990');
values2[27] = new Array('kljlk lkj', '990');
values2[28] = new Array('kljlk lkj', '990');
function populate2(num){
document.getElementById('field2one').value = values2[num][0];
document.getElementById('field2two').value = values2[num][1];
}
</script>
<script type="text/javascript">
var values3=new Array();
values3[1] = new Array('test test test test test test test test test test ', '909000');
values3[2] = new Array('Overskrift', '22990');
values3[3] = new Array('Overskrift', '22990');
values3[8] = new Array('kljkj', '909');
values3[10] = new Array('1', '8989');
values3[11] = new Array('kljkl j', '90909');
values3[12] = new Array('kljlk lkj', '990');
values3[18] = new Array('kljlk lkj', '990');
values3[19] = new Array('kljlk lkj', '990');
values3[20] = new Array('kljlk lkj', '990');
values3[21] = new Array('kljlk lkj', '990');
values3[22] = new Array('1', '8989');
values3[23] = new Array('kljkl j', '90909');
values3[24] = new Array('kljlk lkj', '990');
values3[25] = new Array('kljlk lkj', '990');
values3[26] = new Array('kljlk lkj', '990');
values3[27] = new Array('kljlk lkj', '990');
values3[28] = new Array('kljlk lkj', '990');
function populate3(num){
document.getElementById('field3one').value = values3[num][0];
document.getElementById('field3two').value = values3[num][1];
}
</script>
<script type="text/javascript">
var values4=new Array();
values4[1] = new Array('test test test test test test test test test test ', '909000');
values4[2] = new Array('Overskrift', '22990');
values4[3] = new Array('Overskrift', '22990');
values4[8] = new Array('kljkj', '909');
values4[10] = new Array('1', '8989');
values4[11] = new Array('kljkl j', '90909');
values4[12] = new Array('kljlk lkj', '990');
values4[18] = new Array('kljlk lkj', '990');
values4[19] = new Array('kljlk lkj', '990');
values4[20] = new Array('kljlk lkj', '990');
values4[21] = new Array('kljlk lkj', '990');
values4[22] = new Array('1', '8989');
values4[23] = new Array('kljkl j', '90909');
values4[24] = new Array('kljlk lkj', '990');
values4[25] = new Array('kljlk lkj', '990');
values4[26] = new Array('kljlk lkj', '990');
values4[27] = new Array('kljlk lkj', '990');
values4[28] = new Array('kljlk lkj', '990');
function populate4(num){
document.getElementById('field4one').value = values4[num][0];
document.getElementById('field4two').value = values4[num][1];
}
</script>
</head>
<body>
<center>
<form method="post" action="ordreseddel.asp" name="orderlines">
<table cellspacing="0" cellpadding="0" border="0" style="width: 666px" class="inputbox">
<tr>
<td valign="top" align="left" style="width: 666px">
<table border="0" cellpadding="0" cellspacing="0">
<tr>
<td bgcolor="#333366"><font size="1" face="Verdana" color="FFFFFF"><b>Vare Nr.</b></font></td>
<td bgcolor="#333366"><font size="1" face="Verdana" color="FFFFFF"><b>Vare beskrivelse</b></font></td>
<td bgcolor="#333366"><font size="1" face="Verdana" color="FFFFFF"><b>Pris</b></font></td>
<td bgcolor="#333366"><font size="1" face="Verdana" color="FFFFFF"><b>Stk</b></font></td>
<td bgcolor="#333366"><font size="1" face="Verdana" color="FFFFFF"><b>Pris Ialt</b></font></td>
</tr>
<tr>
<td bgcolor="#333366">
<select style="width: 95px" class="inputbox" name="select" onchange="populate1(this.options[selectedIndex].value)">
<option value="choose" SELECTED>Vælg</option>
<option value="1">89899999</option>
<option value="2">090990</option>
<option value="3">090991</option>
<option value="8">8888</option>
<option value="10">9999999</option>
<option value="11">00000000</option>
<option value="12">89898</option>
<option value="18">89898</option>
<option value="19">89898</option>
<option value="20">89898</option>
<option value="21">89898</option>
<option value="22">9999999</option>
<option value="23">00000000</option>
<option value="24">89898</option>
<option value="25">89898</option>
<option value="26">89898</option>
<option value="27">89898</option>
<option value="28">89898</option>
</select>
</td>
<td bgcolor="#333366"><input style="width: 300px" class="inputbox" name="field1one" type="text" id="field1one"></td>
<td bgcolor="#333366"><input style="width: 90px;" class="inputboxright" name="field1two" type="text" id="field1two"></td>
<td bgcolor="#333366"><input style="width: 90px;" class="inputboxright" type="text" name="antal1" id="antal1" onkeyup="calc('total1', antal1.value, '1.60')"></td>
<td bgcolor="#333366"><input style="width: 90px;" class="inputboxright" type="text" name="total1" value="0.00" readonly></td>
<tr>
<td bgcolor="#333366">
<select style="width: 95px" class="inputbox" name="select" onchange="populate2(this.options[selectedIndex].value)">
<option value="choose" SELECTED>Vælg</option>
<option value="1">89899999</option>
<option value="2">090990</option>
<option value="3">090991</option>
<option value="8">8888</option>
<option value="10">9999999</option>
<option value="11">00000000</option>
<option value="12">89898</option>
<option value="18">89898</option>
<option value="19">89898</option>
<option value="20">89898</option>
<option value="21">89898</option>
<option value="22">9999999</option>
<option value="23">00000000</option>
<option value="24">89898</option>
<option value="25">89898</option>
<option value="26">89898</option>
<option value="27">89898</option>
<option value="28">89898</option>
</select>
</td>
<td bgcolor="#333366"><input style="width: 300px" class="inputbox" name="field2one" type="text" id="field2one"></td>
<td bgcolor="#333366"><input style="width: 90px;" class="inputboxright" name="field2two" type="text" id="field2two"></td>
<td bgcolor="#333366"><input style="width: 90px;" class="inputboxright" type="text" name="antal2" id="antal2" onkeyup="calc('total2', antal2.value, '1.60')"></td>
<td bgcolor="#333366"><input style="width: 90px;" class="inputboxright" type="text" name="total2" value="0.00" readonly></td>
<tr>
<td bgcolor="#333366">
<select style="width: 95px" class="inputbox" name="select" onchange="populate3(this.options[selectedIndex].value)">
<option value="choose" SELECTED>Vælg</option>
<option value="1">89899999</option>
<option value="2">090990</option>
<option value="3">090991</option>
<option value="8">8888</option>
<option value="10">9999999</option>
<option value="11">00000000</option>
<option value="12">89898</option>
<option value="18">89898</option>
<option value="19">89898</option>
<option value="20">89898</option>
<option value="21">89898</option>
<option value="22">9999999</option>
<option value="23">00000000</option>
<option value="24">89898</option>
<option value="25">89898</option>
<option value="26">89898</option>
<option value="27">89898</option>
<option value="28">89898</option>
</select>
</td>
<td bgcolor="#333366"><input style="width: 300px" class="inputbox" name="field3one" type="text" id="field3one"></td>
<td bgcolor="#333366"><input style="width: 90px;" class="inputboxright" name="field3two" type="text" id="field3two"></td>
<td bgcolor="#333366"><input style="width: 90px;" class="inputboxright" type="text" name="antal3" id="antal3" onkeyup="calc('total3', antal3.value, '1.60')"></td>
<td bgcolor="#333366"><input style="width: 90px;" class="inputboxright" type="text" name="total3" value="0.00" readonly></td>
<tr>
<td bgcolor="#333366">
<select style="width: 95px" class="inputbox" name="select" onchange="populate4(this.options[selectedIndex].value)">
<option value="choose" SELECTED>Vælg</option>
<option value="1">89899999</option>
<option value="2">090990</option>
<option value="3">090991</option>
<option value="8">8888</option>
<option value="10">9999999</option>
<option value="11">00000000</option>
<option value="12">89898</option>
<option value="18">89898</option>
<option value="19">89898</option>
<option value="20">89898</option>
<option value="21">89898</option>
<option value="22">9999999</option>
<option value="23">00000000</option>
<option value="24">89898</option>
<option value="25">89898</option>
<option value="26">89898</option>
<option value="27">89898</option>
<option value="28">89898</option>
</select>
</td>
<td bgcolor="#333366"><input style="width: 300px" class="inputbox" name="field4one" type="text" id="field4one"></td>
<td bgcolor="#333366"><input style="width: 90px;" class="inputboxright" name="field4two" type="text" id="field4two"></td>
<td bgcolor="#333366"><input style="width: 90px;" class="inputboxright" type="text" name="antal4" id="antal4" onkeyup="calc('total4', antal4.value, '1.60')"></td>
<td bgcolor="#333366"><input style="width: 90px;" class="inputboxright" type="text" name="total4" value="0.00" readonly></td>
</tr>
</table>
</td>
</tr>
</table>
<input type="text" name="formtot" value="0.00" style="width: 80px" readonly>
</form>
</center>
</body>
</html>