protected void Page_Load(object sender, EventArgs e)
{
XabaraCom xc = new XabaraCom();
xc.CheckAdminLogin("");
dbDataFunction db = new dbDataFunction();
Response.Write("自动清除淘画报，如出现死机或出错，重新点击自动更新即可；<br /><br />");
Response.Flush();
//清除低佣金的画报
db.exeSql("delete from taobaoKe where commission<5 and classID=0 and postDate<'" + DateTime.Now.AddDays(-15).ToString() + "'");
//清除无佣金商品
db.exeSql("delete from taobaoKe where isBad=0 and poster_id>0 and classID=0");
DataTable dt = db.getDataTable("select id,title from posterChannelTitle order by tID DESC");
for (int i = 0; i < dt.Rows.Count; i++)
{
string idTemp = dt.Rows[i]["id"].ToString().Trim();
string strSql = "select title from taobaoKe left join posterTkID on taobaoKe.num_iid=posterTkID.tK_num_iid where taobaoKe.isBad>0 and posterTkID.title_id=" + idTemp.ToString() + " order by commission DESC,volume DESC";
DataTable ifDt = db.getDataTable(strSql);
if (ifDt.Rows.Count < 10)
{
db.DelDB("posterChannelTitle", "id", idTemp.ToString(), "", false, "");
db.DelDB("posterTkID", "title_id", idTemp.ToString(), "", false, "");
Response.Write("自动清除 " + dt.Rows[i]["title"].ToString().Trim() + " 成功!<br />");
Response.Flush();
}
ifDt.Dispose();
}
dt.Dispose();
Response.Write("自动清除淘画报完成！<br /><br />");
Response.Flush();
}
protected void Page_Load(object sender, EventArgs e)
{
XabaraCom xc = new XabaraCom();
xc.CheckAdminLogin("");
dbDataFunction db = new dbDataFunction();
Response.Write("自动清除淘画报，如出现死机或出错，重新点击自动更新即可；<br /><br />");
Response.Flush();
//清除低佣金的画报
db.exeSql("delete from taobaoKe where commission<5 and classID=0 and postDate<'" + DateTime.Now.AddDays(-15).ToString() + "'");
//清除无佣金商品
db.exeSql("delete from taobaoKe where isBad=0 and poster_id>0 and classID=0");
DataTable dt = db.getDataTable("select id,title from posterChannelTitle order by tID DESC");
for (int i = 0; i < dt.Rows.Count; i++)
{
string idTemp = dt.Rows[i]["id"].ToString().Trim();
string strSql = "select title from taobaoKe left join posterTkID on taobaoKe.num_iid=posterTkID.tK_num_iid where taobaoKe.isBad>0 and posterTkID.title_id=" + idTemp.ToString() + " order by commission DESC,volume DESC";
DataTable ifDt = db.getDataTable(strSql);
if (ifDt.Rows.Count < 10)
{
db.DelDB("posterChannelTitle", "id", idTemp.ToString(), "", false, "");
db.DelDB("posterTkID", "title_id", idTemp.ToString(), "", false, "");
Response.Write("自动清除 " + dt.Rows[i]["title"].ToString().Trim() + " 成功!<br />");
Response.Flush();
}
ifDt.Dispose();
}
dt.Dispose();
Response.Write("自动清除淘画报完成！<br /><br />");
Response.Flush();
}
protected void clearData_Click(object sender, EventArgs e)
{
string strSql;
long cid = xc.SafeNum(classID.Text);
if (cid > 0)
{
strSql = "delete from taobaoKe where classID=" + classID.Text;
}
else
{
strSql = "delete from taobaoKe where isBad=0";
}
db.exeSql(strSql);
Response.Redirect("?cid=" + classID.Text, true);
}
