view.asp

功能齐全的oa系统

<% option explicit%>
<!-- #include virtual="include/DataEnvi.asp" -->
<!-- #include virtual="include/Page.asp" -->
<!-- #include virtual="Include/SelectValue.asp" -->

<%
	Dim ObjDB
	Dim C
	Dim IntID
	Dim ObjRS
	
	IntID = Request.QueryString("ID")
	
	Set ObjDB = Server.CreateObject("ADODB.Connection")
	OpenDBH ObjDB

	Set C = Server.CreateObject ("CMS2003.DBhandle")
	C.Init(ObjDB)


	If Request.Form.Count > 0 Then
		IntID = Request.Form("ID")
		Call C.Edit(IntID,"_","T_Hrms_Employees_Train_Record")
	    ObjDB.Close
     	Set ObjDB = Nothing
     	 Response.Redirect "list.asp"   
	End If
   
	Set ObjRS = C.View("Select * From T_Hrms_Employees_Train_Record Where  ID = " & IntID)
		
	

	
%>



<%'==================================================================%>
<%Sub Main%>
<%'------------------------------------------------------------------%>

	
	<form action="" method="post" onsubmit="return(CheckForm(this))" id=form1 name=form1>
	<input type=hidden name=ID value="<%=Request.QueryString("ID")%>">
	
<table class=Ltable cellspacing=1 cellpadding=3>
    <tr class=LHtr align="middle">
    <td width="15%">查看培训纪录</td>
    <td width="85%"> </td>
  </tr>
 <tr class=Ltr>
      <td align="center">课程代号</td>
    <td><input type="text" class=Input Check=0  name="_LesCode" value="<%=SelectValueView(ObjDB,"Select ID,LesCode from T_Hrms_Employees_Train_Lesson",CStr(ObjRS("LesCode")))%>">
        &nbsp; </td>
  </tr>
  <tr class=Ltr>
      <td align="center">姓名</td>
	  <td><input type="text" class=Input Check=0  name="_LesName" value="<%=SelectValueView(ObjDB,"Select ID,Name from t_Hrms_Employees_UsersBasic",CStr(ObjRS("LesName")))%>">

  </tr>
  <tr class=Ltr>
      <td align="center">培训时限</td>
    <td><input type="text" class=Input Check=0  name="_LesTime" value="<%=ObjRS("LesTime")%>">
        天</td>
  </tr>
  <tr class=Ltr>
      <td align="center">开始时间</td>
    <td><input type="text" class=Input Check=0  name="_BeginTime" value="<%=ObjRS("BeginTime")%>"></td>
  </tr>
  <tr class=Ltr>
      <td align="center">结束时间</td>
    <td><input type="text" class=Input Check=0  name="_EndTime" value="<%=ObjRS("EndTime")%>"></td>
  </tr>
  <tr class=Ltr>
      <td align="center">成绩</td>
    <td><input type="text" class=Input Check=0  name="_Score" value="<%=ObjRS("Score")%>">
        分</td>
  </tr>
  <tr class=Ltr>
      <td align="center">测试</td>
    <td><input type="text" class=Input Check=0  name="_TestResult" value="<%Select Case CSTR(ObjRS("TestResult"))
Case "0"
response.write "优"
Case "1"
response.write "良"
Case "2"
response.write "及格"
Case Else 
response.write "差"
End Select
	%>">
      </td>
  </tr>
  <tr class=Ltr>
      <td align="center">费用</td>
    <td><input type="text" class=Input Check=0  name="_Fee" value="<%=ObjRS("Fee")%>">
        元 </td>
  </tr>
  
  </table>
	<table cellspacing=1 cellpadding=3>
	<tr>
		<td>
		<input type="button" class=Button value="取 消" onclick="doList()" id=button1 name=button1></td>
		<td></td>
	</tr>
	</table>
	</FORM>
	


<%'------------------------------------------------------------------%>
<%End Sub%>
<%'==================================================================%>

<!-- #include virtual="Templet/Templet.asp" -->