addnew.asp

功能齐全的oa系统

<% option explicit%>
<!-- #include virtual="include/DataEnvi.asp" -->
<!-- #include virtual="include/Page.asp" -->
<%
If Request.Form.Count > 0 Then
	Dim ObjDBH,ObjRs,StrSQL
	Dim C
	Dim IntID
	
	Set ObjDBH = Server.CreateObject("ADODB.Connection")
	OpenDBH ObjDBH
	
	Set ObjRS = Server.CreateObject("Adodb.Recordset")
	StrSQL = "Select * From t_Hrms_PersonSave"
	ObjRS.Open StrSQL,ObjDBH,1,3
	ObjRS.AddNew
	ObjRS("Name")= Request("_Name")
	ObjRS("Sex")			= Request("_Sex")
	ObjRS.Fields("Birth")= Request("_Birth")
	ObjRS("EducationStyle")			= Request("_EducationStyle")
	ObjRS("GraduateSchool")			= Request("_GraduateSchool")
	ObjRS.Fields("GraduateTime")=Request("_GraduateTime")
	ObjRS.Fields("Speciality")	= Request("_Speciality")
	ObjRS("Document")=Request("_Document")
	ObjRS.Fields("SaveTime")	= Request("_SaveTime")
	ObjRS("Des")				= Request("_Des")
	ObjRS.Update
	IntID = ObjRS("ID")
	ObjRS.Close
	Set ObjRS = Nothing
	
	'Set C = Server.CreateObject("CMS2003.DBHandle")
	'C.Init(ObjDBH)
	'IntID = C.AddNew("_","t_Hrms_PersonSave")          
	
	ObjDBH.Close
	Set ObjDBH = Nothing
	Response.Redirect "List.asp"
End If

Sub Main
%>
<!-- <script language=javascript>
	function GetHTML()
	{
		var tmpHTML = frameBody.getHTML()
		document.forms[0]._Body.value = tmpHTML;
	}
</script> -->
	<form action="" method="post" onsubmit="GetHTML();return(CheckForm(this))"  name=form1>
	<input type=hidden name="_Body" value="">
  <table class=Ltable cellspacing=1 cellpadding=3 height=100%>
    <tr class=LHtr> 
      <td width="15%">新增详细员工信息</td>
      <td width="85%"> </td>
    </tr>
    <tr class=Ltr> 
      <td>姓名</td>
      <td><input type="text" class=Input Check=1 Show="姓名" name="_Name" value=""></td>
    </tr>
    <tr class=Ltr> 
      <td>性别</td>
      <td><input type="text" class=Input Check=1 Show="性别" name="_Sex" value=""></td>
    </tr>
    <tr class=Ltr> 
      <td>出生日期</td>
      <td><input type="text" class=Input Check=1 Show="出生日期" readonly name="_Birth" onclick="InputDate(this)" value="<%=Date()%>"></td>
    </tr>
    <tr class=Ltr> 
      <td>教育类型</td>
      <td><input type="text" class=Input Check=1 Show="教育类型" name="_EducationStyle" value=""> 
      </td>
    </tr>
    <tr class=Ltr> 
      <td>最终毕业学校</td>
      <td><input type="text" class=Input Check=1 Show="最终毕业学校" name="_GraduateSchool" value=""></td>
    </tr>
    <tr class=Ltr> 
      <td>所学专业</td>
      <td><input type="text" class=Input Check=1 Show="所学专业" name="_Speciality" value=""></td>
    </tr>
    <tr class=Ltr> 
      <td>毕业时间</td>
      <td><input type="text" class=Input Check=1 Show="毕业时间" name="_GraduateTime" onclick="InputDate(this)" value="<%=Date()%>"></td>
	</tr>
    <tr class=Ltr> 
      <td>电子文档</td>
      <td><input type="text" class=Input Check=1 Show="电子文档" name="_Document" value=""></td>
    </tr>
    <tr class=Ltr> 
      <td>入库时间</td>
      <td>
	  <input type="text" class=Input Check=1 Show="入库时间" name="_SaveTime" onclick="InputDate(this)" value="<%=Date()%>"></td>
    </tr>
    <tr class=Ltr> 
      <td>备注</td>
      <td><textArea  cols=30 rows=10 class=Textarea Show="备注" name="_Des"></textarea></td>
    </tr>
    <tr class=Ltr height=100%> 
      <td colspan=2 align="left" valign="top"><input type="submit"  name="Submit" class=Button value="提 交"><input type="button" class=Button value="取 消" onclick="history.go(-1)" id=button1 name=button1></td>
    </tr>
  </table>
</form>
<%
End Sub
%>
<!-- #include file="Templet.asp" -->