<% member_id=request.form("hid_id") 'usercode=request.form("txt_username") 'password=request.form("txt_userpass") XingMing=request.form("txt_xingming") firstXingMing=request.form("txt_firstxingming") middleXingMing=request.form("txt_middlexingming") 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_food3=request.form("chk_food3") txt_session=request.form("sel_session") txt_item=request.form("txt_item") 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_room=request.form("rad_room") txt_need=request.form("txt_bark") txt_need2=request.form("txt_bark2") 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") txt_cwbark3=request.form("txt_cwbark3") txt_cwbark4=request.form("txt_cwbark4") txt_cwbark5=request.form("txt_cwbark5") dim db Set db=new Connections select case request("Action") case "add" add_sql="insert into Member_Info (M_NAME,M_firstNAME,M_middleNAME,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,ROOM_TYPE,TICKETS_TYPE,M_SESSION,M_NEEDS,M_NEEDS2,TOTAL_PAY,TOur_price,CARD_TYPE,CARD_NUMBER,EXPRI_DATE,CARD_HOLDER,SECURITY_CODE,ADMIN_USER) values ('"& XingMing &"','"& firstXingMing &"','"& middleXingMing &"','"& 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_room &"','"& txt_ticket &"','"& txt_session &"','"& txt_need &"','"& txt_need2 &"','"& 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_firstNAME='"& firstXingMing &"',M_middleNAME='"& middleXingMing &"',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 &"',ROOM_TYPE='"& txt_room &"',TICKETS_TYPE='"& txt_ticket &"',M_SESSION='"& txt_session &"',M_NEEDS='"& txt_need &"',M_NEEDS2='"& txt_need2 &"',TOTAL_PAY='"& txt_payment &"',PAY_ALL="& pay_all &",PAY_SHIFU="& txt_shifu &",ADMIN_USER='"& admin_user &"',CW_BARK='"& txt_cwbark &"',CW_BARK2='"& txt_cwbark2 &"',CW_BARK3='"& txt_cwbark3 &"',CW_BARK4='"& txt_cwbark4 &"',CW_BARK5='"& txt_cwbark5 &"',UPD_DATE=#"& now() &"# where MEMBER_ID=" & member_id else add_sql="update Member_Info set M_NAME='"& XingMing &"',M_firstNAME='"& firstXingMing &"',M_middleNAME='"& middleXingMing &"',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 &"',ROOM_TYPE='"& txt_room &"',TICKETS_TYPE='"& txt_ticket &"',M_SESSION='"& txt_session &"',M_NEEDS='"& txt_need &"',M_NEEDS2='"& txt_need2 &"',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 &"',CW_BARK3='"& txt_cwbark3 &"',CW_BARK4='"& txt_cwbark4 &"',CW_BARK5='"& txt_cwbark5 &"',UPD_DATE=#"& now() &"# where MEMBER_ID=" & member_id end if end select db.Query add_sql,0 response.write "" %>