<% 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=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=request.form("txt_address") txt_peitong=request.form("txt_peitong") txt_research=request.form("txt_research") txt_comment=request.form("txt_comment") txt_come=request.form("txt_come") txt_leave=request.form("txt_leave") txt_food=request.form("chk_food") txt_room=request.form("rad_room") txt_bed=request.form("txt_extra") txt_session=request.form("sel_session") txt_item=request.form("txt_item") txt_other=request.form("txt_other") txt_ticket=request.form("rad_ticket") txt_need=request.form("txt_bark") txt_payment=request.form("txt_payment") 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") 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_ROOM,EXTRA_BED,COME_TIME,LEAVE_TIME,MEET_ITEM,OTHER,TICKETS_TYPE,M_SESSION,M_NEEDS,TOTAL_PAY,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_room &"','"& txt_bed &"','"& txt_come &"','"& txt_leave &"','"& txt_item &"','"& txt_other &"','"& txt_ticket &"','"& txt_session &"','"& txt_need &"','"& txt_payment &"','"& 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 &"',M_COMMENT='" & txt_comment & "',CHECK_FOOD='"& txt_food &"',CHECK_ROOM='"& txt_room &"',EXTRA_BED='"& txt_bed &"',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 &"',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_ROOM='"& txt_room &"',EXTRA_BED='"& txt_bed &"',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 &"',UPD_DATE=#"& now() &"# where MEMBER_ID=" & member_id end if end select db.Query add_sql,0 response.write "" %>