m_team.asp

电子备课系统

            		str="<span style=""color:#f60;font-weight:600;"">待审</span>"
            	case 2
            		str="<span style=""color:#f00;font-weight:600;"">锁定</span>"
            	case 3
            		str="<span style=""color:#090;font-weight:600;"">审核</span>"
            end select
            Response.write str
            %>

            <%select case cint(rs("istate"))
            	case 1%>
            	<a href="m_team.asp?action=modifystate&s1=1&teamid=<%=rs("teamid")%>" onClick="return confirm('确定要批准通过此<%=oblog.CacheConfig(69)%>吗？');">通过</a>
            	<%case 2%>
            	<a href="m_team.asp?action=modifystate&s1=3&teamid=<%=rs("teamid")%>" onClick="return confirm('确定要解锁此<%=oblog.CacheConfig(69)%>吗？');">解锁</a>
            	<%case 3%>
            	<a href="m_team.asp?action=modifystate&s1=2&teamid=<%=rs("teamid")%>" onClick="return confirm('确定要锁定此<%=oblog.CacheConfig(69)%>吗？');">锁定</a>
            <%end select%>
            </td>
			<td align="center"><a href="?action=modify&teamid=<%=rs("teamid")%>">修改</a>&nbsp;&nbsp;<a href="m_team.asp?action=delteam&teamid=<%=rs("teamid")%>" onClick="return confirm('确定要删除此<%=oblog.CacheConfig(69)%>吗？');">删除</a></td>
          </tr>
          <%
	i=i+1
	if i>=G_P_PerMax then exit do
	rs.movenext

Loop
Response.write "</table>"%>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
  <tr>
    <td width="140" height="30"><input name="chkAll" type="checkbox" id="chkAll" onclick=CheckAll(this.form) value="checkbox">
              选中本页所有内容</td>
            <td> <strong>操作：</strong>
              <input name="action" type="radio" value="delteam">
              删除&nbsp;&nbsp;
              &nbsp;&nbsp;
              <input name="action" type="radio" value="pass0">
              锁定&nbsp;&nbsp;
              &nbsp;&nbsp;
              <input name="action" type="radio" value="pass1">
              审核&nbsp;&nbsp;
              &nbsp;&nbsp;
              <input type="submit" name="Submit" value="执行"> </td>
  </tr>
</table>
</form>
<%
end Sub
Sub modify()
	set rs=oblog.execute("select * from oblog_team where teamid="&teamid&"")
	ReCountTeamInfo(teamid)
%>
<div id="main_body">
	<ul class="main_top">
		<li class="main_top_left left">修改<%=oblog.CacheConfig(69)%>信息</li>
		<li class="main_top_right right"> </li>
	</ul>
	<div class="main_content_rightbg">
		<div class="main_content_leftbg">

<table width="98%" border="0" align="center" cellpadding="2" cellspacing="1" Class="border" id="table1">
  <form name="oblogform" method="post" action="?action=modifyteaminfo&teamid=<%=teamid%>">
    <tr class="tdbg">
      <td width="100"><%=oblog.CacheConfig(69)%>创建者：</td>
      <td><input type="text" name="creatername" size="30" value="<%=rs("creatername")%>" /></td>
    </tr>
    <tr class="tdbg">
      <td><%=oblog.CacheConfig(69)%>管理员：</td>
      <td><input type="text" name="managername" size="30" value="<%=rs("managername")%>" /></td>
    </tr>
    <tr class="tdbg">
      <td><%=oblog.CacheConfig(69)%>名称：</td>
      <td><input type="text" name="t_name" size="30" value="<%=rs("t_name")%>" /></td>
    </tr>
	  <%If oblog.CacheConfig(5)="1" And oblog.CacheConfig(75) <> "" Then%>
    <tr class="tdbg">
      <td><%=oblog.CacheConfig(69)%>域名：</td>
      <td><input name="team_domain" type="text" value="<%=rs("t_domain")%>" size=10 maxlength=20 /> <select name="team_domainroot" ><%=oblog.type_domainroot(rs("t_domainroot"),1)%></select></td>
    </tr>
	  <%End if%>
    <tr class="tdbg">
      <td><%=oblog.CacheConfig(69)%>标记图片<br />(120*90)</td>
      <td><div class="user_face"><img id="imgIcon" width=120 height=90 src="<%=oblog.filt_html(ProIco(rs("t_ico"),3))%>">
		<p><iframe id="d_file" frameborder="0" src="../upload.asp?tMode=8&re=&teamid=<%=teamId%>" width="300" height="80" scrolling="no"></iframe>
			<br/>只支持jpg,gif,png,小于200k,默认尺寸为120*90<br/>
			图片地址：<input name="ico"  type="text" value="<%=oblog.filt_html(rs("t_ico"))%>" size="70" maxlength="200" / >
			<br/>你可以直接输入一个有效的图片地址,也可以在这里直接选择一个系统可用的图片</p></div></td>
    </tr>
    <tr class="tdbg">
      <td><%=oblog.CacheConfig(69)%>类别：</td>
      <td><select name="classid" id="classid" ><%=oblog.show_class("log",rs("classid"),2)%></select></td>
    </tr>
    <tr class="tdbg">
      <td><%=oblog.CacheConfig(69)%>标签：</td>
      <td><input type="text" name="tags" size="50" value="<%=rs("t_tags")%>">(最多支持5个，以逗号间隔)</td>
    </tr>
    <tr class="tdbg">
      <td><%=oblog.CacheConfig(69)%>加入条件：</td>
      <td>
			<input type="radio" name="t1" value="-1" <%If rs("joinlimit")=-1 Then Response.Write " checked" End If%>>任意加入
			<input type="radio" name="t1" value="0" <%If rs("joinlimit")=0 Then Response.Write " checked" End If%>>申请加入
			<input type="radio" name="t1" value="1" <%If rs("joinlimit")=1 Then Response.Write " checked" End If%>>仅可邀请<br/>
			<input type="radio" name="t1" value="2"  <%If rs("joinlimit")=2 Then Response.Write " checked" End If%>>积分限制，需大于<input type=text name="t2" size=5 maxlength=8 value="<%=rs("joinscores")%>">积分才能申请
		</td>
    </tr>
    <tr class="tdbg">
      <td><%=oblog.CacheConfig(69)%>访问权限：</td>
      <td>
			<input type="radio" name="t4" value="-1" <%If rs("viewlimit")=-1 Then Response.Write " checked" End If%>>无限制
			<input type="radio" name="t4" value="0" <%If rs("viewlimit")=0 Then Response.Write " checked" End If%>>会员可见 <br/>
			<input type="radio" name="t4" value="1" <%If rs("viewlimit")=1 Then Response.Write " checked" End If%>>凭密码访问，密码<input type=text name="t5" size=20 maxlength=20 value="">（不修改请留空）
		</td>
    </tr>
    <tr class="tdbg">
      <td><%=oblog.CacheConfig(69)%>申请说明/简介：</td>
      <td><textarea rows="5" name="intro" cols="45"><%=rs("intro")%></textarea></td>
    </tr>
    <tr class="tdbg">
      <td><%=oblog.CacheConfig(69)%>状态：</td>
      <td>
			<input type="hidden" name="istate_0" id="istate_0" value = "<%=rs("istate")%>" />
			<input type="radio" name="istate" value="1" <%If rs("istate")=1 Then Response.Write " checked" End If%>>待审
			<input type="radio" name="istate" value="2" <%If rs("istate")=2 Then Response.Write " checked" End If%>>锁定
			<input type="radio" name="istate" value="3" <%If rs("istate")=3 Then Response.Write " checked" End If%>>审核
		</td>
    </tr>
    <tr class="tdbg">
      <td>是否为推荐<%=oblog.CacheConfig(69)%>：</td>
      <td>
			<input type="radio" name="isbest" value="1" <%If rs("isbest")=1 Then Response.Write " checked" End If%>>推荐
			<input type="radio" name="isbest" value="0" <%If rs("isbest")=0 Then Response.Write " checked" End If%>>不推荐
		</td>
    </tr>
    <tr class="tdbg">
      <td colspan="2" align="center">
			<input type="submit" value=" 提交 " name="B1">
			<input type="reset" value=" 重置 " name="B2">
		</td>
    </tr>


  </form>
</table>
		</div>
	</div>
<%End Sub
Sub ReCountTeamInfo(teamid)
	Dim rst,c1,c2,c3,c4
	Set rst=oblog.execute("select Count(userid) From oblog_teamusers Where teamid=" & teamid)
	If not rs.Eof Then
		c1=OB_IIf(rst(0),0)
	Else
		c1=0
	End If
	Set rst=oblog.execute("select Count(postid) From oblog_teampost Where idepth=0 And teamid=" & teamid)
	If not rs.Eof Then
		c2=OB_IIf(rst(0),0)
	Else
		c2=0
	End If
	Set rst=oblog.execute("select Count(postid) From oblog_teampost Where idepth>0 And teamid=" & teamid)
	If not rs.Eof Then
		c3=OB_IIf(rst(0),0)
	Else
		c3=0
	End If
	oblog.execute "Update oblog_team Set iCount0=" & c1 & ",iCount1=" & c2 & ",iCount2=" & c3 & " Where teamid=" & teamid
	Set rst=Nothing
End Sub
sub modifyteaminfo()
	Dim name, rs, intro, sql, str,ico,tags,t1,t2,t3,t4,t5,team_domain,team_domainroot
	Dim CreaterName,ManagerMame,t_Name,ClassID,CreaterID,ManagerID,istate,isbest,istate_0
	Dim trs
    intro = Trim(Request.Form("intro"))
	ico = Trim(Request.Form("ico"))
    t1 = Trim(Request.Form("t1"))
    t2 = Trim(Request.Form("t2"))
    t3 = Trim(Request.Form("t3"))
    t4 = Trim(Request.Form("t4"))
    t5 = Trim(Request.Form("t5"))
    tags = Trim(Request.Form("tags"))
    team_domain = Trim(Request.Form("team_domain"))
    team_domainroot = Trim(Request.Form("team_domainroot"))
    CreaterName = Trim(Request.Form("creatername"))
    ManagerMame = Trim(Request.Form("managername"))
    t_Name = Trim(Request.Form("t_name"))
    ClassID = Int(Trim(Request.Form("ClassID")))
    istate = Int(Trim(Request.Form("istate")))
    istate_0 = Int(Trim(Request.Form("istate_0")))
    isbest = Trim(Request.Form("isbest"))
	If CreaterName = "" Or ManagerMame = "" Then
     	oblog.ShowMsg ("创建者或者管理员不能为空！"),""
        Exit Sub
	Else
		Set trs = oblog.Execute ("select userid FROM oblog_user WHERE username='"&CreaterName&"'")
		If trs.EOF Then
	     	oblog.ShowMsg ("创建者不存在！"),""
			Exit Sub
		Else
			CreaterID = trs(0)
		End If
		trs.Close
		Set trs = oblog.Execute ("select userid FROM oblog_user WHERE username='"&ManagerMame&"'")
		If trs.EOF Then
	     	oblog.ShowMsg ("创建者不存在！"),""
			Exit Sub
		Else
			ManagerID = trs(0)
		End If
		trs.Close
		Set trs = Nothing
	End If
	If t_Name = "" Then
     	oblog.ShowMsg ("名称不能为空！"),""
        Exit Sub
	Else
		t_Name=Left(t_Name,25)
	End if
	If t1="2"  Then
		If  t2="" Or Not isNumeric(t2) Then
			oblog.ShowMsg ("请输入加入时的积分限制"),""
	        Exit Sub
	     Else
	     	t2=Int(t2)
	     End If
	Else
		t2=0
	End If
	Set rs=Server.CreateObject("Adodb.Recordset")
    rs.Open "select * from oblog_team where teamid=" & teamid,conn,1,3
    If Not rs.EOF Then
		rs("t_Name") = t_Name
    	rs("t_ico")=ico
    	rs("joinlimit")=t1
    	rs("joinscores")=t2
		rs("viewlimit") = OB_IIF(t4,"-1")
		If t4 = "1" And t5<>"" Then rs("viewpassword")=MD5(t5)
    	rs("intro")=intro
    	rs("createrid")=CreaterID
    	rs("creatername")=CreaterName
    	rs("managerid")=ManagerID
    	rs("managername")=ManagerMame
		rs("classid")=classid
		rs("t_tags") = tags
		rs("istate") = istate
		rs("isbest") = OB_IIF(isbest,"0")
		If oblog.CacheConfig(5)="1" And oblog.CacheConfig(75) <> "" Then
			rs("t_domain")=team_domain
			rs("t_domainroot")=team_domainroot
		End if
    	rs.Update
    	str = "" & oblog.CacheConfig(69) & "信息修改完成"
    Else
    	str = "" & oblog.CacheConfig(69) & "信息不存在"
    End If
	'积分操作
	TeamScore teamid,istate_0
    rs.Close
    Set rs=Nothing
	WriteSysLog "进行了修改"&oblog.CacheConfig(69)&"操作，目标"&oblog.CacheConfig(69)&"ID："&teamid&"",oblog.NowUrl&"?"&Request.QueryString
    oblog.ShowMsg str, ""
End Sub
Set oblog = Nothing
%>
	<ul class="main_end">
		<li class="main_end_left left"></li>
		<li class="main_end_right right"></li>
	</ul>
</div>
</body>
</html>
<script language="javascript">
function getImg(){
	if (document.oblogform.ico.value!=""){
		document.oblogform.imgIcon.src='<%=blogdir%>'+document.oblogform.ico.value;
	}
}
</script>