view.asp

功能齐全的oa系统

<%option explicit%>
<!-- #include virtual="include/DataEnvi.asp" -->
<!-- #include virtual="include/Page.asp" -->
<!-- #include virtual="include/String.asp" -->
<!-- #include virtual="include/SelectValue.asp" -->
<!-- #include virtual="include/GetRoleName.asp" -->
<%
Dim ObjDB,ObjRS,StrSQL
Dim C,IntAccountID
Dim StrRoleName, ObjRS1

IntAccountID = Request.QueryString("ID")

Set ObjDB = Server.CreateObject("Adodb.Connection")
OpenDB ObjDB

Set C = Server.CreateObject("CMS2003.DBHandle")
C.Init(ObjDB)
Set ObjRS = C.View("Select * From v_OA_SYS_Account Where ID = " & FixSQL(IntAccountID) )
StrRoleName = GetRoleName(ObjDB,ObjRS("RoleIDs"))

Set ObjRS1 = C.View("Select SubRoleName From t_OA_Sub_SubRoles Where SubRoleID = " & Cint(ObjRS("SubRoles")))
Sub Main
%>
<script language=javascript>
  function SelectRoleIDs(IDs)
  {
    window.open("SelectRole.asp?IDs="+IDs,"RoleWin","width=200,height=300,scrollbars=yes")
  }

  function ChangeRole(IDs,Names)
  {
    document.forms[0].A_RoleIDs.value = IDs
    document.forms[0].RoleName.value = Names
    window.focus()
  }
</script>
  <table class=Ltable cellspacing=1 cellpadding=3>
  <tr class=LHtr>
    <td width="15%">ID</td>
    <td width="85%"><%=ObjRS("ID")%></td>
  </tr>
  <tr class=Ltr>
    <td>登录名</td>
    <td><input type="text" class=Input Check=1 Show="登录名" readonly name="A_AccountName" value="<%=ObjRS("AccountName")%>"></td>
  </tr>
  <tr class=Ltr>
    <td>真实姓名</td>
    <td><input type="text" class=Input Check=1 Show="真实姓名" readonly name="C_TrueName" value="<%=ObjRS("TrueName")%>"></td>
  </tr>
  <tr class=Ltr>
    <td></td>
  </tr>
  </table>
  <table id=MoreInfo class=Ltable cellspacing=1 cellpadding=3 style="display=''">
  <tr class=LStr>
    <td width="15%">详细信息</td>
    <td width="85%" colspan=3> </td>
  </tr>
  <tr class=Ltr>
    <td>性别</td>
    <td><input type="radio" name="C_Gender" value="1" <%If ObjRS("Gender")=1 Then Response.Write " checked"%>>男 <input type="radio" name="C_Gender" value="2" <%If ObjRS("Gender")=2 Then Response.Write " checked"%>>女</td>
    <td rowspan=3>系统角色</td>
    <td rowspan=3>
    <textarea class=Textarea2 rows=4 name="RoleName" readonly><%=StrRoleName%></textarea>
    </td>
  </tr>
  <tr class=Ltr>
    <td>婚姻状况</td>
    <td><input type="radio" name="C_IsMarriage" value="1" <%If ObjRS("IsMarriage") Then Response.Write " checked"%>>已婚 <input type="radio" name="C_IsMarriage" value="0" <%If Not ObjRS("IsMarriage") Then Response.Write " checked"%>>未婚</td>
  </tr>
  <tr class=Ltr>
    <td>生日</td>
    <td><input type="text" class=Input2 name="C_Birthday" value="<%=ObjRS("Birthday")%>"></td>
  </tr>
  <tr class=Ltr>
    <td>学历</td>
    <td><input type="text" class=Input2 name="C_Education" value="<%=ObjRS("Education")%>"></td>
    <td>职称</td>
    <td><input type="text" class=Input2 name="C_Title" value="<%=ObjRS("Title")%>"></td>
  </tr>
  <tr class=Ltr>
    <td>国籍</td>
    <td><input type="text" class=Input2 name="C_Nation" value="<%=ObjRS("Nation")%>"></td>
    <td>籍贯</td>
    <td><input type="text" class=Input2 name="C_NativePlace" value="<%=ObjRS("NativePlace")%>"></td>
  </tr>
  <tr class=Ltr>
    <td>工作电话</td>
    <td><input type="text" class=Input2 name="C_Tel" value="<%=ObjRS("Tel")%>"></td>
    <td>Email</td>
    <td><input type="text" class=Input2 name="C_Email" value="<%=ObjRS("Email")%>"></td>
  </tr>
  <tr class=Ltr>
    <td>家庭电话</td>
    <td><input type="text" class=Input2 name="C_HomeTel" value="<%=ObjRS("HomeTel")%>"></td>
    <td>手机</td>
    <td><input type="text" class=Input2 name="C_Mob" value="<%=ObjRS("Mob")%>"></td>
  </tr>
  <tr class=Ltr>
    <td>住址</td>
    <td><input type="text" class=Input name="C_Address" value="<%=ObjRS("Address")%>"></td>
    <td>子系统角色</td>
    <td><input type="text" class=Input readonly name="C_Address" value="<%=ObjRS1("SubRoleName")%>"></td>
  </tr>
  <tr class=Ltr>
    <td>备注</td>
    <td colspan=3><textarea class=Textarea name="C_Des"><%=FixStr(ObjRS("Des"))%></textarea></td>
  </tr>
  </table>
  <table cellspacing=1 cellpadding=3>
  <tr>
    <td>
    <input type="button" class=Button value="返 回" onclick="doList()"></td>
    <td></td>
  </tr>
  </table>
  </form>
<%
End Sub
%>
<!-- #include virtual="Templet/Templet.asp" -->