%@ LANGUAGE = VBSCRIPT %>
<% OPTION EXPLICIT %>
<%
'*************************************************************
'PageName: zjjsxx.asp
'Version: VER 1.0
'Author: AspMaker 3.0
'Create Date: 2007/02/26 09:31:37
'Description: 专家详细
'*************************************************************
%>
<%
'================================================================================
' 1. Initial Workspace
'================================================================================
Const GCSTR_MENU_NAME = "网上报名"
Call InitialWorkspace("..", PAGE_WSBM_WSBM, True, False)
'================================================================================
' 2. Define All Variable
'================================================================================
Dim strSgnCod
Dim strSgnNam
Dim strSgnSex
Dim strBthDat
Dim strSchAge
Dim strHedShp
Dim strUniNam
Dim strOffNam
Dim strPosCde
Dim strLnkTel
Dim strComSet
Dim strLnkFax
Dim strEmlAdd
Dim strArvDat
Dim strLevDat
Dim strResFlg
Dim strRemArk
Dim strSgnFlg
Dim strSigFlg
'================================================================================
' 3. Get Current Data From PrePage
'================================================================================
Call GetCurrentData()
'================================================================================
' 4. Export Current HTML View for Head Part
'================================================================================
Call ExportHTMLHeader("欢迎访问第三届左主干暨冠状动脉分叉病变峰会")
'================================================================================
' 5. Do Processing and Redirect to Other Page
'================================================================================
Call DoProcessing()
'================================================================================
' 6. Display Current Page or Redirect to Other Page
'================================================================================
If Need2Redirect() = True Then
Call Redirect()
Else
Call SetCurrentData()
Call ExportHTMLBody()
End If
'================================================================================
' 7. Export Current HTML View for Foot Part
'================================================================================
Call ExportHTMLTail()
'================================================================================
' 8. Release Workspace
'================================================================================
Call ReleaseWorkspace()
%>
<%
'================================================================================
' 9. Data Process Functions
'================================================================================
Function GetCurrentData()
strSgnNam = Trim(GetFieldValue("idSgnNam"))
strSgnSex = Trim(GetFieldValue("idSgnSex"))
strBthDat = Trim(GetFieldValue("idBthDat"))
strSchAge = Trim(GetFieldValue("idSchAge"))
strHedShp = Trim(GetFieldValue("idHedShp"))
strUniNam = Trim(GetFieldValue("idUniNam"))
strOffNam = Trim(GetFieldValue("idOffNam"))
strPosCde = Trim(GetFieldValue("idPosCde"))
strLnkTel = Trim(GetFieldValue("idLnkTel"))
strComSet = Trim(GetFieldValue("idComSet"))
strLnkFax = Trim(GetFieldValue("idLnkFax"))
strEmlAdd = Trim(GetFieldValue("idEmlAdd"))
strArvDat = Trim(GetFieldValue("idArvDat"))
strLevDat = Trim(GetFieldValue("idLevDat"))
strResFlg = Trim(GetFieldValue("idResFlg"))
strRemArk = Trim(GetFieldValue("idRemArk"))
Dim staDat
Dim endDat
staDat = GetSetInfo("STADAT")
endDat = GetSetInfo("ENDDAT")
If doCheckValue(staDat) and doCheckValue(endDat) Then
If staDat <= GetCurrentDate() and endDat >= GetCurrentDate() Then
strSigFlg = True
End If
End If
End Function
Function SetCurrentData()
End Function
Function DoProcessing()
Select Case GetCommand()
Case WSBM_WSBM_WSBM_WSBM_OK:
Call DoOkProcessing()
Case ERROR_CURRENT_RETURN:
Call DoErrorReturn()
Case Else:
Call SetRedirectInfo("", "")
End Select
End Function
Function DoOkProcessing()
' 1. Check从画面获取的数据
Call AddCheckElement("姓名", strSgnNam, True, True, 1, 32, False, CHECK_TYPE_NONE)
Call AddCheckElement("性别", strSgnSex, True, True, 1, 32, False, CHECK_TYPE_NONE)
Call AddCheckElement("出生年月", strBthDat, True, False, -1, -1, False, CHECK_TYPE_NONE)
Call AddCheckElement("学历", strSchAge, True, True, 1, 64, False, CHECK_TYPE_NONE)
Call AddCheckElement("职称/职务", strHedShp, True, True, 1, 64, False, CHECK_TYPE_NONE)
Call AddCheckElement("单位地址及全称", strUniNam, True, True, 1, 128, False, CHECK_TYPE_NONE)
Call AddCheckElement("科室/病区", strOffNam, True, True, 1, 128, False, CHECK_TYPE_NONE)
Call AddCheckElement("邮编", strPosCde, True, True, 1, 6, False, CHECK_TYPE_NONE)
Call AddCheckElement("电话", strLnkTel, True, True, 1, 64, False, CHECK_TYPE_NONE)
Call AddCheckElement("手机", strComSet, True, True, 1, 64, False, CHECK_TYPE_NONE)
Call AddCheckElement("传真", strLnkFax, False, True, 1, 64, False, CHECK_TYPE_NONE)
Call AddCheckElement("电子邮件", strEmlAdd, True, True, 1, 64, False, CHECK_TYPE_NONE)
Call AddCheckElement("到达日期", strArvDat, True, False, -1, -1, False, CHECK_TYPE_NONE)
Call AddCheckElement("离开日期", strLevDat, True, False, -1, -1, False, CHECK_TYPE_NONE)
Call AddCheckElement("是否住宿", strResFlg, True, False, -1, -1, False, CHECK_TYPE_NONE)
Call AddCheckElement("备注/留言", strRemArk, False, True, 1, 255, False, CHECK_TYPE_NONE)
If DoCheck() = False Then
Call SetErrorMsgs(GetCheckErrMsg())
Call SetRedirectInfo(PAGE_ERROR_ERROR, "")
Exit Function
End If
' 2. 保存数据到数据库
Dim strSQL
' 插入数据
strSQL = "INSERT INTO SGNINF(SGNNAM, SGNSEX, BTHDAT, SCHAGE, HEDSHP, UNINAM, OFFNAM, POSCDE, LNKTEL, COMSET, LNKFAX, EMLADD, ARVDAT, LEVDAT, RESFLG, REMARK) VALUES(" & _
"'" & FilterSQL(strSgnNam) & "', " & _
"'" & FilterSQL(strSgnSex) & "', " & _
"'" & FilterSQL(strBthDat) & "', " & _
"'" & FilterSQL(strSchAge) & "', " & _
"'" & FilterSQL(strHedShp) & "', " & _
"'" & FilterSQL(strUniNam) & "', " & _
"'" & FilterSQL(strOffNam) & "', " & _
"'" & FilterSQL(strPosCde) & "', " & _
"'" & FilterSQL(strLnkTel) & "', " & _
"'" & FilterSQL(strComSet) & "', " & _
"'" & FilterSQL(strLnkFax) & "', " & _
"'" & FilterSQL(strEmlAdd) & "', " & _
"'" & FilterSQL(strArvDat) & "', " & _
"'" & FilterSQL(strLevDat) & "', " & _
"'" & FilterSQL(strResFlg) & "', " & _
"'" & FilterSQL(strRemArk) & "') "
If ExecuteUpdateSQL(strSQL) = False Then
Call SetErrorMsg(ERR_MSG_COM_001)
Call SetRedirectInfo(PAGE_ERROR_ERROR, "")
Exit Function
End If
Call SetRedirectInfo("wsbm/wsbmts.asp", "")
End Function
Function DoErrorReturn()
End Function
%>
<%
'================================================================================
' 10. HTML View Functions
'================================================================================
%>
<%Function ExportMeta()%>
<%End Function%>
<%Function ExportScriptBody()%>
<%End Function%>
<%Function ExportStyleBody()%>
<%End Function%>
<%Function ExportBodyHead()%>
<%End Function%>
<%Function ExportHTMLBody()%>
<% 'HTML BLOCK BEGIN %>
<% If strSigFlg Then %>
<% Else %>
<% End If %>
|
<% 'HTML BLOCK END %>
<%End Function%>
<%Function ExportTailScriptBody()%>
<%End Function%>