?? adminsimplelist.aspx.cs
字號:
using System;
using System.IO;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
namespace _211
{
/// <summary>
/// AdminSimpleList 的摘要說明。
/// </summary>
public partial class AdminSimpleList : System.Web.UI.Page
{
private int pagesize=10;
protected void Page_Load(object sender, System.EventArgs e)
{
if(Session["name"]==null)
{
Response.Write("<script>top.location='AdminLogin.aspx'</script>");
return;
}
if(!Page.IsPostBack)
{
BindItem();
BindPage();
BindArt();
}
Button1.Attributes["onclick"]="return confirm('你確定要刪除它們??')";
}
private void BindItem()
{
i.DataSource=TableQuery.ItemQuery("0");
i.DataTextField="ItemName";
i.DataValueField="ItemId";
i.DataBind();
}
private void BindPage()
{
if(i.SelectedItem==null)return;
int pagecount=0;
int temp=(int)DBQuery.ExecuteScalar("select count(ArticleId) from [Article] where Article.ItemId="+i.SelectedValue);
if(temp%pagesize==0)pagecount=temp/pagesize-1;
else pagecount=temp/pagesize;
p.Items.Clear();
for(int ii=0;ii<=pagecount;ii++)
{
p.Items.Add(new ListItem("第"+(ii+1)+"頁",ii.ToString()));
}
}
private void BindArt()
{
int page;
if(p.SelectedItem!=null)page=Convert.ToInt32(p.SelectedValue);
else page=0;
art.DataSource=TableQuery.ArticleSimpleQuery(pagesize,page,i.SelectedValue);
art.DataBind();
}
#region Web 窗體設計器生成的代碼
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 該調用是 ASP.NET Web 窗體設計器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 設計器支持所需的方法 - 不要使用代碼編輯器修改
/// 此方法的內容。
/// </summary>
{
}
#endregion
protected void i_SelectedIndexChanged(object sender, System.EventArgs e)
{
BindPage();
BindArt();
}
protected void p_SelectedIndexChanged(object sender, System.EventArgs e)
{
BindArt();
}
protected void Button1_Click(object sender, System.EventArgs e)
{
int page=Convert.ToInt32(p.SelectedValue);
int pc=p.Items.Count;
CheckBox cb;
for(int i=0;i<art.Items.Count;i++)
{
cb=(CheckBox)art.Items[i].FindControl("CheckBox1");
if(cb.Checked)
{
try
{
FileInfo fi=new FileInfo(Request.ServerVariables["APPL_PHYSICAL_PATH"].ToString()+art.DataKeys[i].ToString()+".htm");
if(fi.Exists)fi.Delete();
DBQuery.ExceuteNonQuery("delete from [Article] where ArticleId="+art.DataKeys[i].ToString());
}
catch(Exception ex)
{
Response.Write("<script>alert(\""+ex.Message.ToString()+"\");</script>");
}
}
}
BindPage();
using(CreateItem ci=new CreateItem(Convert.ToInt32(i.SelectedValue)))
{
ci.Add();
}
if(pc!=p.Items.Count)
{
FileInfo fi=new FileInfo(Request.ServerVariables["APPL_PHYSICAL_PATH"].ToString()+"Item_"+i.SelectedValue+"_"+(pc-1)+".htm");
if(fi.Exists)fi.Delete();
}
using(CreateIndexPage cip=new CreateIndexPage())
{
cip.Add();
}
if((p.Items.Count-1)<page)
{
p.SelectedValue=Convert.ToString(page-1);
}
else p.SelectedValue=page.ToString();
BindArt();
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -