rs_edit_input.asp

oa办公系统asp程序

<!--#include file="../title.asp"-->
<%
'订单信息
dim ref,buyer,style_no
dim pattern,order_qty,merchand
dim mo,buyer_po,fabric_po
dim thread_po,lc,clr_swatch
dim pattn_paper,appv_sample,shpt_sample
dim username

ref=request("ref")
buyer=request("buyer")
style_no=request("style_no")
pattern=request("pattern")
order_qty=request("order_qty")
merchand=request("merchand")
mo=request("mo")
buyer_po=request("buyer_po")
fabric_po=request("fabric_po")
thread_po=request("thread_po")
lc=request("lc")
clr_swatch=request("clr_swatch")
pattn_paper=request("pattn_paper")
appv_sample=request("appv_sample")
shpt_sample=request("shpt_sample")
username=session("admin")
date_now=date
'订单布料
dim fabric_1,fabric_2
dim color_1_1,color_1_2,color_1_3,color_1_4,color_1_5
dim color_2_1,color_2_2,color_2_3,color_2_4,color_2_5
dim color_1_6,color_1_7,color_1_8,color_1_9,color_1_10
dim color_2_6,color_2_7,color_2_8,color_2_9,color_2_10
dim order_kg_1_1,order_kg_1_2,order_kg_1_3,order_kg_1_4,order_kg_1_5
dim order_kg_2_1,order_kg_2_2,order_kg_2_3,order_kg_2_4,order_kg_2_5
dim order_kg_1_6,order_kg_1_7,order_kg_1_8,order_kg_1_9,order_kg_1_10
dim order_kg_2_6,order_kg_2_7,order_kg_2_8,order_kg_2_9,order_kg_2_10
dim order_yd_1_1,order_yd_1_2,order_yd_1_3,order_yd_1_4,order_yd_1_5
dim order_yd_2_1,order_yd_2_2,order_yd_2_3,order_yd_2_4,order_yd_2_5
dim order_yd_1_6,order_yd_1_7,order_yd_1_8,order_yd_1_9,order_yd_1_10
dim order_yd_2_6,order_yd_2_7,order_yd_2_8,order_yd_2_9,order_yd_2_10
dim malaysia_kg_1_1,malaysia_kg_1_2,malaysia_kg_1_3,malaysia_kg_1_4,malaysia_kg_1_5
dim malaysia_kg_2_1,malaysia_kg_2_2,malaysia_kg_2_3,malaysia_kg_2_4,malaysia_kg_2_5
dim malaysia_kg_1_6,malaysia_kg_1_7,malaysia_kg_1_8,malaysia_kg_1_9,malaysia_kg_1_10
dim malaysia_kg_2_6,malaysia_kg_2_7,malaysia_kg_2_8,malaysia_kg_2_9,malaysia_kg_2_10
dim malaysia_yd_1_1,malaysia_yd_1_2,malaysia_yd_1_3,malaysia_yd_1_4,malaysia_yd_1_5
dim malaysia_yd_2_1,malaysia_yd_2_2,malaysia_yd_2_3,malaysia_yd_2_4,malaysia_yd_2_5
dim malaysia_yd_1_6,malaysia_yd_1_7,malaysia_yd_1_8,malaysia_yd_1_9,malaysia_yd_1_10
dim malaysia_yd_2_6,malaysia_yd_2_7,malaysia_yd_2_8,malaysia_yd_2_9,malaysia_yd_2_10

dim shanghai_kg_1_1,shanghai_kg_1_2,shanghai_kg_1_3,shanghai_kg_1_4,shanghai_kg_1_5
dim shanghai_kg_2_1,shanghai_kg_2_2,shanghai_kg_2_3,shanghai_kg_2_4,shanghai_kg_2_5
dim shanghai_kg_1_6,shanghai_kg_1_7,shanghai_kg_1_8,shanghai_kg_1_9,shanghai_kg_1_10
dim shanghai_kg_2_6,shanghai_kg_2_7,shanghai_kg_2_8,shanghai_kg_2_9,shanghai_kg_2_10
dim shanghai_yd_1_1,shanghai_yd_1_2,shanghai_yd_1_3,shanghai_yd_1_4,shanghai_yd_1_5
dim shanghai_yd_2_1,shanghai_yd_2_2,shanghai_yd_2_3,shanghai_yd_2_4,shanghai_yd_2_5
dim shanghai_yd_1_6,shanghai_yd_1_7,shanghai_yd_1_8,shanghai_yd_1_9,shanghai_yd_1_10
dim shanghai_yd_2_6,shanghai_yd_2_7,shanghai_yd_2_8,shanghai_yd_2_9,shanghai_yd_2_10
dim etd_date_1_1,etd_date_1_2,etd_date_1_3,etd_date_1_4,etd_date_1_5
dim etd_date_2_1,etd_date_2_2,etd_date_2_3,etd_date_2_4,etd_date_2_5
dim etd_date_1_6,etd_date_1_7,etd_date_1_8,etd_date_1_9,etd_date_1_10
dim etd_date_2_6,etd_date_2_7,etd_date_2_8,etd_date_2_9,etd_date_2_10
dim finish_1_1,finish_1_2,finish_1_3,finish_1_4,finish_1_5
dim finish_2_1,finish_2_2,finish_2_3,finish_2_4,finish_2_5
dim finish_1_6,finish_1_7,finish_1_8,finish_1_9,finish_1_10
dim finish_2_6,finish_2_7,finish_2_8,finish_2_9,finish_2_10
dim thread_1_1,thread_1_2,thread_1_3,thread_1_4,thread_1_5
dim thread_2_1,thread_2_2,thread_2_3,thread_2_4,thread_2_5
dim thread_1_6,thread_1_7,thread_1_8,thread_1_9,thread_1_10
dim thread_2_6,thread_2_7,thread_2_8,thread_2_9,thread_2_10

fabric_1=request("fabric_1")
fabric_2=request("fabric_2")
color_1_1=request("color_1_1")
color_1_2=request("color_1_2")
color_1_3=request("color_1_3")
color_1_4=request("color_1_4")
color_1_5=request("color_1_5")
color_1_6=request("color_1_6")
color_1_7=request("color_1_7")
color_1_8=request("color_1_8")
color_1_9=request("color_1_9")
color_1_10=request("color_1_10")
color_2_1=request("color_2_1")
color_2_2=request("color_2_2")
color_2_3=request("color_2_3")
color_2_4=request("color_2_4")
color_2_5=request("color_2_5")
color_2_6=request("color_2_6")
color_2_7=request("color_2_7")
color_2_8=request("color_2_8")
color_2_9=request("color_2_9")
color_2_10=request("color_2_10")

order_kg_1_1=request("order_kg_1_1")
order_kg_1_2=request("order_kg_1_2")
order_kg_1_3=request("order_kg_1_3")
order_kg_1_4=request("order_kg_1_4")
order_kg_1_5=request("order_kg_1_5")
order_kg_1_6=request("order_kg_1_6")
order_kg_1_7=request("order_kg_1_7")
order_kg_1_8=request("order_kg_1_8")
order_kg_1_9=request("order_kg_1_9")
order_kg_1_10=request("order_kg_1_10")
order_kg_2_1=request("order_kg_2_1")
order_kg_2_2=request("order_kg_2_2")
order_kg_2_3=request("order_kg_2_3")
order_kg_2_4=request("order_kg_2_4")
order_kg_2_5=request("order_kg_2_5")
order_kg_2_6=request("order_kg_2_6")
order_kg_2_7=request("order_kg_2_7")
order_kg_2_8=request("order_kg_2_8")
order_kg_2_9=request("order_kg_2_9")
order_kg_2_10=request("order_kg_2_10")

order_yd_1_1=request("order_yd_1_1")
order_yd_1_2=request("order_yd_1_2")
order_yd_1_3=request("order_yd_1_3")
order_yd_1_4=request("order_yd_1_4")
order_yd_1_5=request("order_yd_1_5")
order_yd_1_6=request("order_yd_1_6")
order_yd_1_7=request("order_yd_1_7")
order_yd_1_8=request("order_yd_1_8")
order_yd_1_9=request("order_yd_1_9")
order_yd_1_10=request("order_yd_1_10")
order_yd_2_1=request("order_yd_2_1")
order_yd_2_2=request("order_yd_2_2")
order_yd_2_3=request("order_yd_2_3")
order_yd_2_4=request("order_yd_2_4")
order_yd_2_5=request("order_yd_2_5")
order_yd_2_6=request("order_yd_2_6")
order_yd_2_7=request("order_yd_2_7")
order_yd_2_8=request("order_yd_2_8")
order_yd_2_9=request("order_yd_2_9")
order_yd_2_10=request("order_yd_2_10")
malaysia_kg_1_1=request("malaysia_kg_1_1")
malaysia_kg_1_2=request("malaysia_kg_1_2")
malaysia_kg_1_3=request("malaysia_kg_1_3")
malaysia_kg_1_4=request("malaysia_kg_1_4")
malaysia_kg_1_5=request("malaysia_kg_1_5")
malaysia_kg_1_6=request("malaysia_kg_1_6")
malaysia_kg_1_7=request("malaysia_kg_1_7")
malaysia_kg_1_8=request("malaysia_kg_1_8")
malaysia_kg_1_9=request("malaysia_kg_1_9")
malaysia_kg_1_10=request("malaysia_kg_1_10")
malaysia_kg_2_1=request("malaysia_kg_2_1")
malaysia_kg_2_2=request("malaysia_kg_2_2")
malaysia_kg_2_3=request("malaysia_kg_2_3")
malaysia_kg_2_4=request("malaysia_kg_2_4")
malaysia_kg_2_5=request("malaysia_kg_2_5")
malaysia_kg_2_6=request("malaysia_kg_2_6")
malaysia_kg_2_7=request("malaysia_kg_2_7")
malaysia_kg_2_8=request("malaysia_kg_2_8")
malaysia_kg_2_9=request("malaysia_kg_2_9")
malaysia_kg_2_10=request("malaysia_kg_2_10")
malaysia_yd_1_1=request("malaysia_yd_1_1")
malaysia_yd_1_2=request("malaysia_yd_1_2")
malaysia_yd_1_3=request("malaysia_yd_1_3")
malaysia_yd_1_4=request("malaysia_yd_1_4")
malaysia_yd_1_5=request("malaysia_yd_1_5")
malaysia_yd_1_6=request("malaysia_yd_1_6")
malaysia_yd_1_7=request("malaysia_yd_1_7")
malaysia_yd_1_8=request("malaysia_yd_1_8")
malaysia_yd_1_9=request("malaysia_yd_1_9")
malaysia_yd_1_10=request("malaysia_yd_1_10")
malaysia_yd_2_1=request("malaysia_yd_2_1")
malaysia_yd_2_2=request("malaysia_yd_2_2")
malaysia_yd_2_3=request("malaysia_yd_2_3")
malaysia_yd_2_4=request("malaysia_yd_2_4")
malaysia_yd_2_5=request("malaysia_yd_2_5")
malaysia_yd_2_6=request("malaysia_yd_2_6")
malaysia_yd_2_7=request("malaysia_yd_2_7")
malaysia_yd_2_8=request("malaysia_yd_2_8")
malaysia_yd_2_9=request("malaysia_yd_2_9")
malaysia_yd_2_10=request("malaysia_yd_2_10")
shanghai_kg_1_1=request("shanghai_kg_1_1")
shanghai_kg_1_2=request("shanghai_kg_1_2")
shanghai_kg_1_3=request("shanghai_kg_1_3")
shanghai_kg_1_4=request("shanghai_kg_1_4")
shanghai_kg_1_5=request("shanghai_kg_1_5")
shanghai_kg_1_6=request("shanghai_kg_1_6")
shanghai_kg_1_7=request("shanghai_kg_1_7")
shanghai_kg_1_8=request("shanghai_kg_1_8")
shanghai_kg_1_9=request("shanghai_kg_1_9")
shanghai_kg_1_10=request("shanghai_kg_1_10")
shanghai_kg_2_1=request("shanghai_kg_2_1")
shanghai_kg_2_2=request("shanghai_kg_2_2")
shanghai_kg_2_3=request("shanghai_kg_2_3")
shanghai_kg_2_4=request("shanghai_kg_2_4")
shanghai_kg_2_5=request("shanghai_kg_2_5")
shanghai_kg_2_6=request("shanghai_kg_2_6")
shanghai_kg_2_7=request("shanghai_kg_2_7")
shanghai_kg_2_8=request("shanghai_kg_2_8")
shanghai_kg_2_9=request("shanghai_kg_2_9")
shanghai_kg_2_10=request("shanghai_kg_2_10")

shanghai_yd_1_1=request("shanghai_yd_1_1")
shanghai_yd_1_2=request("shanghai_yd_1_2")
shanghai_yd_1_3=request("shanghai_yd_1_3")
shanghai_yd_1_4=request("shanghai_yd_1_4")
shanghai_yd_1_5=request("shanghai_yd_1_5")
shanghai_yd_1_6=request("shanghai_yd_1_6")
shanghai_yd_1_7=request("shanghai_yd_1_7")
shanghai_yd_1_8=request("shanghai_yd_1_8")
shanghai_yd_1_9=request("shanghai_yd_1_9")
shanghai_yd_1_10=request("shanghai_yd_1_10")
shanghai_yd_2_1=request("shanghai_yd_2_1")
shanghai_yd_2_2=request("shanghai_yd_2_2")
shanghai_yd_2_3=request("shanghai_yd_2_3")
shanghai_yd_2_4=request("shanghai_yd_2_4")
shanghai_yd_2_5=request("shanghai_yd_2_5")
shanghai_yd_2_6=request("shanghai_yd_2_6")
shanghai_yd_2_7=request("shanghai_yd_2_7")
shanghai_yd_2_8=request("shanghai_yd_2_8")
shanghai_yd_2_9=request("shanghai_yd_2_9")
shanghai_yd_2_10=request("shanghai_yd_2_10")

etd_date_1_1=request("etd_date_1_1")
etd_date_1_2=request("etd_date_1_2")
etd_date_1_3=request("etd_date_1_3")
etd_date_1_4=request("etd_date_1_4")
etd_date_1_5=request("etd_date_1_5")
etd_date_1_6=request("etd_date_1_6")
etd_date_1_7=request("etd_date_1_7")
etd_date_1_8=request("etd_date_1_8")
etd_date_1_9=request("etd_date_1_9")
etd_date_1_10=request("etd_date_1_10")
etd_date_2_1=request("etd_date_2_1")
etd_date_2_2=request("etd_date_2_2")
etd_date_2_3=request("etd_date_2_3")
etd_date_2_4=request("etd_date_2_4")
etd_date_2_5=request("etd_date_2_5")
etd_date_2_6=request("etd_date_2_6")
etd_date_2_7=request("etd_date_2_7")
etd_date_2_8=request("etd_date_2_8")
etd_date_2_9=request("etd_date_2_9")
etd_date_2_10=request("etd_date_2_10")

thread_1_1=request("thread_1_1")
thread_1_2=request("thread_1_2")
thread_1_3=request("thread_1_3")
thread_1_4=request("thread_1_4")
thread_1_5=request("thread_1_5")
thread_1_6=request("thread_1_6")
thread_1_7=request("thread_1_7")
thread_1_8=request("thread_1_8")
thread_1_9=request("thread_1_9")
thread_1_10=request("thread_1_10")
thread_2_1=request("thread_2_1")
thread_2_2=request("thread_2_2")
thread_2_3=request("thread_2_3")
thread_2_4=request("thread_2_4")
thread_2_5=request("thread_2_5")
thread_2_6=request("thread_2_6")
thread_2_7=request("thread_2_7")
thread_2_8=request("thread_2_8")
thread_2_9=request("thread_2_9")
thread_2_10=request("thread_2_10")

'辅料信息
dim yes_1,yes_2,yes_3,yes_4,yes_5,yes_6,yes_7,yes_8,yes_9,yes_10,yes_11,yes_12,yes_13
dim yes_14,yes_15,yes_16,yes_17,yes_18,yes_19,yes_20,yes_21,yes_22,yes_23
dim thetd_date_1,thetd_date_2,thetd_date_3,thetd_date_4,thetd_date_5,thetd_date_6,thetd_date_7,thetd_date_8,thETD_DATE_9
dim thetd_date_10,thetd_date_11,thetd_date_12,thetd_date_13,thetd_date_14,thetd_date_15,thetd_date_16,thetd_date_17,thetd_date_18
dim thetd_date_19,thetd_date_20,thetd_date_21,thetd_date_22,thetd_date_23,thetd_date_24
yes_1=request("yes_1")
yes_2=request("yes_2")
yes_3=request("yes_3")
yes_4=request("yes_4")
yes_5=request("yes_5")
yes_6=request("yes_6")
yes_7=request("yes_7")
yes_8=request("yes_8")
yes_9=request("yes_9")
yes_10=request("yes_10")
yes_11=request("yes_11")
yes_12=request("yes_12")
yes_13=request("yes_13")
yes_14=request("yes_14")
yes_15=request("yes_15")
yes_16=request("yes_16")
yes_17=request("yes_17")
yes_18=request("yes_18")
yes_19=request("yes_19")
yes_20=request("yes_20")
yes_21=request("yes_21")
yes_22=request("yes_22")
yes_23=request("yes_23")
etd_date_1=request("thetd_date_1")
etd_date_2=request("thetd_date_2")
etd_date_3=request("thetd_date_3")
etd_date_4=request("thetd_date_4")
etd_date_5=request("thetd_date_5")
etd_date_6=request("thetd_date_6")
etd_date_7=request("thetd_date_7")
etd_date_8=request("thetd_date_8")
etd_date_9=request("thetd_date_9")
etd_date_10=request("thetd_date_10")
etd_date_11=request("thetd_date_11")
etd_date_12=request("thetd_date_12")
etd_date_13=request("thetd_date_13")
etd_date_14=request("thetd_date_14")
etd_date_15=request("thetd_date_15")
etd_date_16=request("thetd_date_16")
etd_date_17=request("thetd_date_17")
etd_date_18=request("thetd_date_18")
etd_date_19=request("thetd_date_19")
etd_date_20=request("thetd_date_20")
etd_date_21=request("thetd_date_21")
etd_date_22=request("thetd_date_22")
etd_date_23=request("thetd_date_23")
founderr=false
'输入订单信息
if ref<>"" then
	sql="select * from cloth_info where ref_no = '"&ref&"' "
	rs.open sql,conn,3,1
	if rs.RecordCount = 0 then
 		founderr=true
 	 	response.write "<br>"
  		errmsg=errmsg+"<li>	REF NO 不存在！如需要增加订单，请进入相应的模块！</li>"
	end if
else
 		founderr=true
  		errmsg=errmsg+"<li>	REF NO不允许输入空值！</li>"
end if
rs.close
if order_qty<>"" then
	if isnumber(order_qty) =  false then
 		founderr=true
  		errmsg=errmsg+"<li>	订单数量格式有问题！</li>"
	end if
else
 		founderr=true
  		errmsg=errmsg+"<li>	订单数量不允许输入空值！</li>"
end if
if mo<>"" then
	if isdate(mo)= false then
 		founderr=true
  		errmsg=errmsg+"<li>	MO格式有问题！请使用“月/日/年”的格式输入!</li>"
	end if
else
 		founderr=true
  		errmsg=errmsg+"<li>	MO不允许输入空值！</li>"
end if
if buyer_po<>"" then
	if isdate(buyer_po)=false then
 		founderr=true
  		errmsg=errmsg+"<li>	BUYER P/O请使用“月/日/年”的格式输入!</li>"
	end if
else
 		founderr=true
  		errmsg=errmsg+"<li>	BUYER P/O不允许输入空值！</li>"
end if
if fabric_po<>"" then
	if isdate(fabric_po)=false then
 		founderr=true
  		errmsg=errmsg+"<li>FABRIC P/O格式有问题！请使用“月/日/年”的格式输入!</li>"
	end if
else
 		founderr=true
  		errmsg=errmsg+"<li>FABRIC P/O不允许输入空值！</li>"
end if
if thread_po <> "" then
	if isdate(thread_po)=false then
 		founderr=true
  		errmsg=errmsg+"<li>THREAD P/O格式有问题！请使用“月/日/年”的格式输入!</li>"
	end if
else
 		founderr=true
  		errmsg=errmsg+"<li>THREAD P/O不允许输入空值！</li>"
end if
if lc<>"" then
	if isdate(LC)=false then
 		founderr=true
  		errmsg=errmsg+"<li>L/C格式有问题！请使用“月/日/年”的格式输入!</li>"
	end if
else
 		founderr=true
  		errmsg=errmsg+"<li>LC不允许输入空值！</li>"
end if
if clr_swatch <> "" then
	if isdate(clr_swatch)=false then
 		founderr=true
  		errmsg=errmsg+"<li>CLR　SWATCH格式有问题！请使用“月/日/年”的格式输入!</li>"
	end if
else
 		founderr=true
  		errmsg=errmsg+"<li>CLR SWATCH不允许输入空值！</li>"
end if
if pattn_paper <> "" then
	if isdate(pattn_paper)=false then	
 		founderr=true
  		errmsg=errmsg+"<li>PATTN PAPER数量格式有问题！请使用“月/日/年”的格式输入!</li>"
	end if
else
 		founderr=true
  		errmsg=errmsg+"<li>PATTN PAPER不允许输入空值！</li>"
end if
if appv_sample <> "" then
	if isdate(appv_sample)=false then	
 		founderr=true