<%
member_id=request.form("hid_id")
'usercode=request.form("txt_username")
'password=request.form("txt_userpass")
XingMing=request.form("txt_xingming")
txt_sex=request.form("rad_sex")
txt_title=request.form("txt_title")
txt_guojia=request.form("txt_guojia")
txt_huzhao=request.form("txt_huzhao")
txt_jigou=HTMLEncode(request.form("txt_jigou"))
txt_youbian=request.form("txt_post")
txt_zhuce=date()
txt_mail=request.form("txt_mail")
txt_tel=request.form("txt_tel")
txt_fax=request.form("txt_fax")
txt_dizhi=HTMLEncode(request.form("txt_address"))
txt_peitong=request.form("txt_peitong")
txt_research=request.form("txt_research")
txt_come=request.form("txt_come")
txt_leave=request.form("txt_leave")
txt_food=request.form("chk_food")
txt_session=request.form("sel_session")
txt_item=request.form("txt_item")
txt_food3=request.form("chk_food3")
if instr(txt_item,"演讲")>0 then
if txt_session="" then
response.write ""
response.end
end if
end if
txt_other=request.form("txt_other")
txt_ticket=request.form("rad_ticket")
txt_need=request.form("txt_bark")
txt_payment=request.form("txt_payment")
txt_payment2=request.form("txt_payment2")
if request.form("txt_shifu")="" then
txt_shifu=0
else
txt_shifu=request.form("txt_shifu")
end if
payment_type=request.form("Payment")
card_number=request.form("txt_cardnumber")
expiration_date=request.form("sel_year")& "-" & request.form("sel_month")
card_holder=request.form("card_holder")
security_cod=request.form("security_cod")
if request.form("chk_pay")="" then
pay_all=0
else
pay_all=request.form("chk_pay")
end if
admin_user=request.form("txt_admin")
txt_cwbark=request.form("txt_cwbark")
txt_cwbark2=request.form("txt_cwbark2")
dim db
Set db=new Connections
select case request("Action")
case "add"
add_sql="insert into Member_Info (M_NAME,M_SEX,M_TITLE,M_AGENCIES,M_COUNTRY,REG_TIME,M_PASSPORT,M_MAIL,M_ZIP,M_ADDRESS,M_TEL,M_FAX,M_ACCOMPANYING,M_RESEARCH,CHECK_FOOD,CHECK_FOOD3,COME_TIME,LEAVE_TIME,MEET_ITEM,OTHER,TICKETS_TYPE,M_SESSION,M_NEEDS,TOTAL_PAY,tour_price,CARD_TYPE,CARD_NUMBER,EXPRI_DATE,CARD_HOLDER,SECURITY_CODE,ADMIN_USER) values ('"& XingMing &"','"& txt_sex &"','"& txt_title &"','"& txt_jigou &"','"& txt_guojia &"',#"& txt_zhuce &"#,'"& txt_huzhao &"','"& txt_mail &"','"& txt_youbian &"','"& txt_dizhi &"','"& txt_tel &"','"& txt_fax &"','"& txt_peitong &"','"& txt_research &"','"& txt_food &"','"& txt_food3 &"','"& txt_come &"','"& txt_leave &"','"& txt_item &"','"& txt_other &"','"& txt_ticket &"','"& txt_session &"','"& txt_need &"','"& txt_payment &"',"& txt_payment2 &",'"& payment_type &"','"& card_number &"','"& expiration_date &"','"& card_holder &"','"& security_cod &"','"& admin_user &"')"
case "upd"
if session("U_Type")<>"finance" then
add_sql="update Member_Info set M_NAME='"& XingMing &"',M_SEX='"& txt_sex &"',M_TITLE='"& txt_title &"',M_AGENCIES='"& txt_jigou &"',M_COUNTRY='"& txt_guojia &"',M_PASSPORT='"& txt_huzhao &"',M_MAIL='"& txt_mail &"',M_ZIP='"& txt_youbian &"',M_ADDRESS='"& txt_dizhi &"',M_TEL='"& txt_tel &"',M_FAX='"& txt_fax &"',M_ACCOMPANYING='"& txt_peitong &"',M_RESEARCH='"& txt_research &"',CHECK_FOOD='"& txt_food &"',CHECK_FOOD3='"& txt_food3 &"',COME_TIME='"& txt_come &"',LEAVE_TIME='"& txt_leave &"',MEET_ITEM='"& txt_item &"',OTHER='"& txt_other &"',TICKETS_TYPE='"& txt_ticket &"',M_SESSION='"& txt_session &"',M_NEEDS='"& txt_need &"',TOTAL_PAY='"& txt_payment &"',PAY_ALL="& pay_all &",PAY_SHIFU="& txt_shifu &",ADMIN_USER='"& admin_user &"',CW_BARK='"& txt_cwbark &"',CW_BARK2='"& txt_cwbark2 &"',UPD_DATE=#"& now() &"# where MEMBER_ID=" & member_id
else
add_sql="update Member_Info set M_NAME='"& XingMing &"',M_SEX='"& txt_sex &"',M_TITLE='"& txt_title &"',M_AGENCIES='"& txt_jigou &"',M_COUNTRY='"& txt_guojia &"',M_PASSPORT='"& txt_huzhao &"',M_MAIL='"& txt_mail &"',M_ZIP='"& txt_youbian &"',M_ADDRESS='"& txt_dizhi &"',M_TEL='"& txt_tel &"',M_FAX='"& txt_fax &"',M_ACCOMPANYING='"& txt_peitong &"',M_RESEARCH='"& txt_research &"',CHECK_FOOD='"& txt_food &"',CHECK_FOOD3='"& txt_food3 &"',COME_TIME='"& txt_come &"',LEAVE_TIME='"& txt_leave &"',MEET_ITEM='"& txt_item &"',OTHER='"& txt_other &"',TICKETS_TYPE='"& txt_ticket &"',M_SESSION='"& txt_session &"',M_NEEDS='"& txt_need &"',TOTAL_PAY='"& txt_payment &"',CARD_TYPE='"& payment_type &"',CARD_NUMBER='"& card_number &"',EXPRI_DATE='"& expiration_date &"',CARD_HOLDER='"& card_holder &"',SECURITY_CODE='"& security_cod &"',PAY_ALL="& pay_all &",PAY_SHIFU="& txt_shifu &",ADMIN_USER='"& admin_user &"',CW_BARK='"& txt_cwbark &"',CW_BARK2='"& txt_cwbark2 &"',UPD_DATE=#"& now() &"# where MEMBER_ID=" & member_id
end if
end select
db.Query add_sql,0
response.write ""
%>