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

📄 neworder.asp

📁 1 除掉了 时间 限制 2 除掉了 人数 限制 改为 500人 原为5人 3 发现一点小缺陷 增加人员的时候没有判断 登陆名是否重复! 自己写吧~~~:) 4 又 是一点缺陷
💻 ASP
📖 第 1 页 / 共 2 页
字号:
<!--#include file="../config.ini" -->
<!--#include file="../commfunction.inc" -->
<%
	Dim objcheck
	Set objcheck=Server.CreateObject("SmartSales.CheckFunction")

'取参数
dim connpara
set connpara=server.CreateObject("adodb.connection")
connpara.Open connstring
set rspara=connpara.Execute("select * from parameter where type='order'")

if request("id")<>"" then
	set rsq=connpara.Execute("select deliveryid from delivery where orderid="&request("id"))
	if not rsq.EOF then
	response.write "<SCRIPT language=javascript>window.resizeTo(300,200);window.focus()</SCRIPT>"
	response.write "<title>合同编辑提醒!</title>"
	response.write "<LINK href="&"../global.css"&" rel=stylesheet type=text/css>"
	response.write "<br>"
	response.write "<p align=center><font color=red size=2><b>"&"<img src=../images/jg.gif>&nbsp;已经生成发货单的合同不能修改,请删除发货单再修改!"&"</b></font><br>"
	response.write "<br>"
	response.write "<p align=center><input type=button value="&"关闭窗口"&" onclick="&"javascript:window.close();"&"></p>"
	Response.End 
	end if
	
	set rsq=connpara.Execute("select * from V_order where orderid='"&Request("id")&"' and confirmed='已审核'")
	if not rsq.EOF then
	response.write "<SCRIPT language=javascript>window.resizeTo(300,200);window.focus()</SCRIPT>"
	response.write "<title>合同编辑提醒!</title>"
	response.write "<LINK href="&"../global.css"&" rel=stylesheet type=text/css>"
	response.write "<br>"
	response.write "<p align=center><font color=red size=2><b>"&"<img src=../images/jg.gif>&nbsp;已通过审核的合同是不能编辑的,请先撤消审核后再编辑!"&"</b></font><br>"
	response.write "<br>"
	response.write "<p align=center><input type=button value="&"关闭窗口"&" onclick="&"javascript:window.close();"&"></p>"
	Response.End 
	end if
else
	objcheck.CheckUserFunction "order","add"
end if

if request("id")<>"" then
	dim connq
	dim rsq
	set connq=server.CreateObject("adodb.connection")
	set rsq=server.CreateObject("adodb.recordset")
	connq.Open connstring
	rsq.Open "select * from [order] where orderid="&request("id"),connq,2,3,1
	strordernum=rsq("ordernum")
	straccount=rsq("accountid")
	straccountname=getfieldvalue("account","accountid",rsq("accountid"),"account")
	strstatus=rsq("status")
	strContact=rsq("Contactid")
	strcontactname=getfieldvalue("contact","contactid",rsq("contactid"),"contact")
	strdeal=rsq("dealid")
	strdealname=getfieldvalue("deal","dealid",rsq("dealid"),"deal")
	strTerm=rsq("Term")
	strShipVia=rsq("ShipVia")
	strCurrencyCode=rsq("CurrencyCode")
	strshipdate=rsq("shipdate")
	strsignedDate=rsq("signeddate")
	strOwner=rsq("Owner")
	strOwnername=getfieldvalue("usertable","loginid",rsq("owner"),"username")
	strcustomerpo=rsq("customerpo")
	strTotalAmount=rsq("TotalAmount")
	strdescription=rsq("description")
	strtermline=rsq("termline")
	rsq.Close
	set rsq=nothing
	connq.Close
	set connq=nothing
else
	strordernum="自动生成"
	strcontact=-1
	straccount=-1
	strdeal=-1
	strowner=session("loginid")
	strownername=session("username")
	strsigneddate=date()
	strshipdate=date()+10
	if Request.QueryString("dealid")<>"" then
		strdeal=Request.QueryString("dealid")
		strdealname=Request.QueryString("dealname")
	end if
	if Request.QueryString("accountid")<>"" then
		straccount=Request.QueryString("accountid")
		straccountname=Request.QueryString("accountname")
	end if
	'取标准条款
	set rsterm=connpara.execute("select * from userdefine where definetype='合同条款'")
	m=3
	do while not rsterm.eof
		
		strtermline=strtermline&m&"、"&replace(rsterm("description"),chr(10),"")&chr(10)
	m=m+1
	rsterm.movenext
	loop
	'response.write strtermline
end if

if request("ordernum")<>"" then
	Dim objorder
	Set objorder=Server.CreateObject("SmartSales.Order")
	objorder.SaveOrder
	set objorder=nothing
%>
<script language=javascript>
	window.opener.location.reload();
	window.close();
</script>
<%
end if
%>
<HTML><HEAD><TITLE>合同</TITLE>
<LINK href="../global.css" rel=STYLESHEET type=text/css>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<script language=javascript src="../tools/newcalendar.js"></script>
<script language=javascript src="../tools/calendar.js"></script>
<div id="overDiv" style="position:absolute; visibility:hidden; z-index:1000;"></div>
<script language="javascript">
function save(){
	if (form1.ordernum.value==''){
		alert('请输入合同单号');
		form1.ordernum.focus();
		return;
	}
	if (form1.account.value==-1){
		alert('请选择客户');
		form1.account.focus();
		return;
	}
	for(x=1;x<=form1.linecount.value;x++){
		var code='code'+x;
		var discountprice="discountprice"+x;
		var price="price"+x;
		var amount="amount"+x;
		var qty="qty"+x;
		if(form1.item(code).value!=''){
			if(form1.item(price).value==''){
				alert('请输入价格');
				form1.item(price).focus();
				return;
			}
			if (isNaN(form1.item(price).value)){
				alert('请输入数字');
				form1.item(price).focus();
				return;
			}
			
			if(form1.item(qty).value==''){
				alert('请输入数量');
				form1.item(qty).focus();
				return;
			}
			if (isNaN(form1.item(qty).value)){
				alert('请输入数字');
				form1.item(qty).focus();
				return;
			}
			
			if(form1.item(discountprice).value==''){
				alert('请输入折扣价');
				form1.item(discountprice).focus();
				return;
			}
			if (isNaN(form1.item(discountprice).value)){
				alert('请输入数字');
				form1.item(discountprice).focus();
				return;
			}
			
			if(form1.item(amount).value==''){
				alert('请输入金额');
				form1.item(amount).focus();
				return;
			}
			if (isNaN(form1.item(amount).value)){
				alert('请输入数字');
				form1.item(amount).focus();
				return;
			}		
		}
	}
form1.submit();
}
</script>
<script language="JavaScript">
function window_onload()
{
window.moveTo(-2,-2);
window.resizeTo(screen.availWidth, screen.availHeight);
}
</script>
<body bgcolor="#ffffff" onload="window_onload()">
 <form name=form1  method="post"  id=form1>
     <table width="100%" height="20" border="0" cellpadding="0" cellspacing="0">
   <tr> 
      <td width="35%" height="25"><strong><font size="2" class=title><b> 
        <%if request("id")="" then%>
        新建合同 
        <%else%>
        编辑合同 
        <%end if%>
        </b></font></strong></td>
      <td><div align="left" style="cursor:hand"> <a onclick="save();"><img src="../images/button_save.gif"></a>&nbsp;&nbsp; 
          <a onClick="window.close();"><img src="../images/button_cancel.gif"></a>&nbsp;&nbsp;<%if request("id")<>"" then%><a href="confirm.asp?orderid=<%=request("id")%>"><img src="../images/button_orderapprove.gif" width="39" height="19" border="0"></a><%end if%></div></td>
    </tr>
    <tr > 
      <td height="16" colspan="2" background="../images/title.gif">&nbsp;</td>
    </tr>
    <tr>
      <td height=4></td>
    </tr>
 </table>
  <table width="100%" cellpadding="2" cellspacing="1" bgcolor="#FFFFFF">
    <tr bgcolor="white"> 
      <td width="10%" bgcolor="DEDFDE"> <div align="center">合同号</div></td>
      <td width="15%" bgcolor="EFEFEF" > <input name=ordernum type=text value="<%=strordernum%>" size="20" readonly> 
      </td>
      <td width="10%" bgcolor="DEDFDE" ><div align="center">签订日期</div></td>
      <td width="15%" bgcolor="EFEFEF"> <input type="text" name="signeddate<%=k%>" size="12" language=javascript id="dupdatetime" value="<%=strsigneddate%>" readonly> 
        <% call AddImg("date")%>
        <input type = hidden name=clicksource> <input type = hidden name=clickresult > 
      </td>
      <td width="10%" bgcolor="DEDFDE"><div align="center">发货日期</div></td>
      <td width="15%" bgcolor="EFEFEF"> <input type="text" name="shipdate<%=k%>" size="12" language=javascript id="dupdatetimeship" value="<%=strshipdate%>" readonly> 
        <% call AddImg("dateship")%>
      </td>
      <td width="10%" bgcolor="DEDFDE"><div align="center">所有者</div></td>
      <td width="15%" bgcolor="EFEFEF"><input name="owner" type="hidden" size="8" value="<%=strowner%>"> 
        <input name="ownername" type="text" size="8" value="<%=strownername%>" readonly> 
        <input type="button" name="bnowner" onClick="JavaScript:opensubwin2('form1','owner')"    value=...  class=black></td>
    </tr>
    <tr  bgcolor="white"> 
      <td nowrap bgcolor="DEDFDE"><div align="center">客户</div></td>
      <td colspan="5" bgcolor="EFEFEF"><input name="account" type="hidden" size="8" value="<%=straccount%>"> 
        <input name="accountname" type="text" size="35" value="<%=straccountname%>" readonly> 
        <input type="button" name="bnaccount" onClick="JavaScript:opensubwin2('form1','account')"    value=...  class=black <%if request("id")<>"" and objcheck.CheckUserFunction2("order","edit")=false then response.Write("disabled") %>> 
        <input type=button name=cancelaccount onClick="javascript:form1.account.value=-1;form1.accountname.value='';" value="C"  class=black <%if request("id")<>"" and objcheck.CheckUserFunction2("order","edit")=false then response.Write("disabled") %>> 
      </td>
      <td bgcolor="DEDFDE"><div align="center">联系人</div></td>
      <td bgcolor="EFEFEF"><input name="contact" type="hidden" size="8" value="<%=strcontact%>"> 
        <input name="contactname" type="text" size="8" value="<%=strcontactname%>" readonly> 
        <input type="button" name="bncontact" onClick="JavaScript:if(form1.account.value!=-1){opensubwinwithsearch('../contact/SelectAccountContact.asp','form1','contact','accountid',form1.account.value)}else{alert('请先选择客户')}"    value=...  class=black></td>
    </tr>
    <tr  bgcolor="white"> 
      <td nowrap bgcolor="DEDFDE"><div align="center">销售机会</div></td>
      <td colspan="5" bgcolor="EFEFEF"><input name="deal" type="hidden" size="8" value="<%=strdeal%>"> 
        <input name="dealname" type="text" size="35" value="<%=strdealname%>" readonly> 
        <input type="button" name="bndeal" onClick="JavaScript:opensubwin2('form1','deal',form1.account.value)"    value=...  class=black>
        审核 </td>
      <td bgcolor="DEDFDE"><div align="center"></div></td>
      <td bgcolor="EFEFEF">&nbsp;</td>
    </tr>
    <tr  bgcolor="white"> 
      <td width="10%" bgcolor="DEDFDE" > <div align="center">运货方式</div></td>
      <td width="15%" bgcolor="EFEFEF"> <select name=shipvia size=0 <%if request("id")<>"" and objcheck.CheckUserFunction2("order","edit")=false then response.Write("readonly") %>>
          <option value=-1></option>
          <%getdefine "运货方式",strshipvia%>
        </select></td>
      <td width="10%" bgcolor="DEDFDE"><div align="center">货币</div></td>
      <td width="15%" bgcolor="EFEFEF"><select name=currencycode>
          <option value=-1></option>
          <%getdefine "货币",strcurrencycode%>
        </select></td>
      <td width="10%" bgcolor="DEDFDE"><div align="center">付款方式</div></td>
      <td width="15%" bgcolor="EFEFEF"><select name=term>
          <option value=-1></option>
          <%getdefine "付款方式",strterm%>
        </select></td>
      <td width="10%" bgcolor="DEDFDE"><div align="center">金额</div></td>
      <td width="15%" bgcolor="EFEFEF"><%=strTotalAmount%></td>
    </tr>
    <tr  bgcolor="white"> 
      <td height="29" bgcolor="DEDFDE" > <div align="center">客户采购单号</div></td>
      <td bgcolor="EFEFEF"><input name=customerPo type=text value="<%=strcustomerPo%>" size="20"></td>
      <td bgcolor="DEDFDE">&nbsp;</td>
      <td bgcolor="EFEFEF">&nbsp;</td>
      <td bgcolor="DEDFDE">&nbsp;</td>
      <td bgcolor="EFEFEF">&nbsp;</td>
      <td bgcolor="DEDFDE">&nbsp;</td>
      <td bgcolor="EFEFEF">&nbsp;</td>
    </tr>

⌨️ 快捷键说明

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