protected void Page_Load(object sender, EventArgs e)
{
tid = Request.QueryString["tid"];
pix = Request.QueryString["pix"];
if (pix == null)
{
pix = "1";
}
TableTitle = CheckTableTitle(tid);
ListRepeater.DataSource = new ArticlesManage().FormRepeater(new ArticlesManage().QueryTableArticles(tid), Int32.Parse(pix), 10);
ListRepeater.DataBind();
int num = new ArticlesManage().QueryTableArticles(tid).Rows.Count;
int pagecount = 0;
if (num % 10 == 0)
pagecount = num / 10;
else pagecount = num / 10 + 1;
pageIndicator.Columns.Add("pageIndex");
for (int i = 0; i < pagecount; i++)
{
pageIndicator.Rows.Add();
pageIndicator.Rows[i]["pageIndex"] = (i + 1).ToString();
}
PageIndicatorRepeater.DataSource = pageIndicator;
PageIndicatorRepeater.DataBind();
}
public void SetData()
{
DataTable dt = new ArticlesManage().QueryOneArticle(aid);
MyTitle = dt.Rows[0]["Article_Title"].ToString();
MyText = dt.Rows[0]["Article_Text"].ToString();
tbContent.Text = MyText;
Title.Text = MyTitle;
}
protected void DeleteLB_Command(object sender, CommandEventArgs e)
{
bool res = new ArticlesManage().Delete(e.CommandArgument.ToString());
if (res == true)
Response.Write("<script language=javascript>alert('删除成功')</script>");
else
Response.Write("<script language=javascript>alert('删除失败')</script>");
ArticleRepeater.DataSource = new ArticlesManage().QueryTableArticles(tid);
ArticleRepeater.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
aid = Request.QueryString["aid"];
if (aid == null)
Response.Redirect("Default.aspx");
DataTable articleDT = new ArticlesManage().QueryOneArticle(aid);
if (articleDT.Rows.Count > 0)
{
ArticleRepeater.DataSource = articleDT;
ArticleRepeater.DataBind();
}
}
protected void Confirm_Click(object sender, EventArgs e)
{
string newTitle = Title.Text.Trim();
string newText = tbContent.Text.Trim();
Article art = new Article();
art.Article_SetUpdate(newTitle, newText, aid);
bool i = new ArticlesManage().Edit(art);
if (i == true)
Response.Write("<script language=javascript>alert('修改成功！')</script>");
else
Response.Write("<script language=javascript>alert('修改失败！')</script>");
SetData();
}
protected void Confirm_Click(object sender, EventArgs e)
{
string newTitle = Title.Text.Trim();
string newText = Text.Text.Trim();
Article art = new Article();
art.Article_SetNew(newTitle, newText, tid);
bool i = false;
if (newTitle != null && newText != null && newTitle != "" && newText != "")
i = new ArticlesManage().Create(art);
if (i == true)
Response.Write("<script language=javascript>alert('创建成功！点击左侧列表查看')</script>");
else
Response.Write("<script language=javascript>alert('创建失败！请检查后重试')</script>");
}
