<%@ Page CodeBehind="admin_clean.aspx.cs" Language="c#" AutoEventWireup="True" Inherits="Typhoto.admin_clean" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
  <HEAD>
		<title>数据清理</title>
		<script type="text/javascript" src="../js/calendar.js"></script>
		<script language="javascript">
   var CalendarWebControl = new atCalendarControl();
		</script>
		<link href="img/main.css" rel="stylesheet" type="text/css">
			<style type="text/css">
		.style4 { COLOR: #ff0000 }
		.style5 { FONT-WEIGHT: bold; COLOR: #ffffff }
		</style>
</HEAD>
	<body>
		<form name="Form1" method="post" id="Form1" runat="server">
			<table border="0" cellspacing="1" cellpadding="3" align="center" width="100%">
				<tr>
					<td colSpan="3" class="td_title">数据清理</td>
				</tr>
				<tr class="tableHeadLeft">
					<td align="right" bgColor="#d3ebf5"><div align="left">1.清理多余的图片文件<span class="forumrow"><span class="px14">（数据库不存在此图片，但硬盘上由于意外原因多余生成或未删除的图片文件）</span>
							</span></div>					</td>
				</tr>
				<tr class="tableTd">
					<td align="right"><DIV align="left">要清理的时间段（如果数据较大，建议分段检查）：
							<asp:TextBox id="date1" runat="server" CssClass="tableTdtext" Columns="10"></asp:TextBox>
							—
							<asp:TextBox id="date2" runat="server" CssClass="tableTdtext" Columns="10"></asp:TextBox>
							<asp:Button ID="Clean1" runat="server" Width="100px" class="formbutton" Text="清  理" onclick="Clean1_Click"></asp:Button>
						</DIV>					</td>
				</tr>
				<tr class="tableHeadLeft">
					<td align="right" bgColor="#d3ebf5"><div align="left">2.重计用户相册数和照片数</div>					</td>
				</tr>
				<tr class="tableTd">
					<td align="right"><DIV align="left">当前最大ID：
							<asp:Label id="maxid1" runat="server"></asp:Label>
							，要统计的ID段（如果数据较大，建议分段检查）：
							<asp:TextBox id="id1" runat="server" CssClass="tableTdtext" Columns="10" Text='1'></asp:TextBox>
							—
							<asp:TextBox id="id2" runat="server" CssClass="tableTdtext" Columns="10" Text='1000'></asp:TextBox>
							<asp:Button ID="Clean2" runat="server" Width="100px" class="formbutton" Text="统  计" onclick="Clean2_Click"></asp:Button>
						</DIV>					</td>
				</tr>
				<tr class="tableHeadLeft">
					<td align="right" bgColor="#d3ebf5"><div align="left">3.重计每个相册下的照片数</div>					</td>
				</tr>
				<tr class="tableTd">
					<td align="right"><div align="left">当前最大ID：
							<asp:Label id="maxid2" runat="server"></asp:Label>
							，要统计的ID段（如果数据较大，建议分段检查）：
							<asp:TextBox id="id3" runat="server" CssClass="tableTdtext" Columns="10" Text='1'></asp:TextBox>
							—
							<asp:TextBox id="id4" runat="server" CssClass="tableTdtext" Columns="10" Text='1000'></asp:TextBox>
							<asp:Button ID="Clean3" runat="server" Width="100px" class="formbutton" Text="统  计" onclick="Clean3_Click"></asp:Button>
						</div>
						<span class="forumrow">
							<span class="px14">
								<div align="left"></div>
							</span>						</span>					</td>
				</tr>
				<TR class="tableTd">
				  <TD align="left">4.重计每个照片下的评论数</TD>
			  </TR>
				<TR class="tableTd">
				  <TD align="left">当前最大ID：
                    <asp:Label id="maxid4" runat="server"></asp:Label>
，要统计的ID段（如果数据较大，建议分段检查）：
<asp:TextBox id="id7" runat="server" CssClass="tableTdtext" Columns="10" Text='1'></asp:TextBox>
—
<asp:TextBox id="id8" runat="server" CssClass="tableTdtext" Columns="10" Text='1000'></asp:TextBox>
<asp:Button ID="Clean6" runat="server" Width="100px" class="formbutton" Text="统  计" onclick="Clean6_Click"></asp:Button></TD>
			  </TR>
				<TR class="tableTd">
				  <TD align="left">5.重计标签关联的个数，删除空标签</TD>
			  </TR>
				<TR class="tableTd">
				  <TD align="left">当前最大ID：
                    <asp:Label id="maxid3" runat="server"></asp:Label>
，要统计的ID段（如果数据较大，建议分段检查）：
<asp:TextBox id="id5" runat="server" CssClass="tableTdtext" Columns="10" Text='1'></asp:TextBox>
—
<asp:TextBox id="id6" runat="server" CssClass="tableTdtext" Columns="10" Text='1000'></asp:TextBox>
<asp:Button ID="Clean5" runat="server" Width="100px" class="formbutton" Text="统  计" onclick="Clean5_Click"></asp:Button></TD>
			  </TR>
				<TR class="tableTd">
					<TD align="left">
						6.临时压缩包清理					</TD>
				</TR>
				<TR class="tableTd">
					<TD align="left">
						清理：
						<select name="select" id="zipdate" runat="server">
							<option value="0" selected>全部</option>
							<option value="1">1天前</option>
							<option value="3">3天前</option>
							<option value="10">10天前</option>
							<option value="30">1月前</option>
							<option value="90">3月前</option>
						</select>
						<asp:Button ID="Clean4" runat="server" Width="100px" class="formbutton" Text="清理" onclick="Clean4_Click"></asp:Button>					</TD>
				</TR>
			</table>
	</form>
	</body>
</HTML>
