public void SetCurrentPagelist()
{
//This is the total page count;
//pagetotal;
//This is the current page;
//pageindex;
if (pageindex > pagetotal || pageindex <= 0)
{
pageindex = 1;
}
int startindex = (pageindex - 1) * 10;
int endindex = startindex;
if (pageindex == pagetotal)
{
endindex = pagesintotal;
}
else endindex = startindex + 10;
DataTable dt = new DataTable();
dt.Columns.Add("pageid", Type.GetType("System.Int32"));
dt.Columns.Add("id", Type.GetType("System.String"));
dt.Columns.Add("title", Type.GetType("System.String"));
dt.Columns.Add("text", Type.GetType("System.String"));
dt.Columns.Add("time", Type.GetType("System.String"));
for (int i = 0; i < endindex - startindex; i++)
{
dt.Rows.Add();
try
{
DataRow dr = new DocsManage().QueryDocs(tableindex).Rows[startindex + i];
dt.Rows[i]["pageid"] = dr["pageid"];
dt.Rows[i]["id"] = dr["id"];
dt.Rows[i]["title"] = dr["title"];
dt.Rows[i]["text"] = dr["text"];
dt.Rows[i]["time"] = dr["time"];
}
catch (Exception)
{
dt.Rows[0]["pageid"] = "1";
dt.Rows[0]["id"] = "-1";
dt.Rows[i]["title"] = "Empty";
dt.Rows[i]["text"] = "Empty";
dt.Rows[i]["time"] = "1970/1/1 00:00:01";
break;
}
}
TablePagesRep.DataSource = dt;
TablePagesRep.DataBind();
}
private void RefreshEvent_Handler()
{
if (docdpl.Visible == true)
{
docdpl.Items.Clear();
DataTable dt = new DocsManage().QueryDocss(pageid);
int i = dt.Rows.Count;
if (i > 0)
{
for (int j = 0; j < i; j++)
{
docdpl.Items.Add(new ListItem(dt.Rows[j]["id"].ToString(), dt.Rows[j]["id"].ToString()));
}
docid = docdpl.SelectedValue;
DataTable ndt = new DocsManage().QueryDoc(docid);
TitleBox.Text = ndt.Rows[0]["title"].ToString();
tbContent.Text = ndt.Rows[0]["text"].ToString();
Docdl.SelectedIndex = (ndt.Rows[0]["actived"].ToString() == "True") ? 0 : 1;
}
}
if (picnewsdpl.Visible == true)
{
picnewsdpl.Items.Clear();
DataTable picnewsdt = new PicNewsManage().QueryAllPicNews();
int indexlength = picnewsdt.Rows.Count;
if (indexlength > 0)
{
for (int i = 0; i < indexlength; i++)
{
picnewsdpl.Items.Add(new ListItem(picnewsdt.Rows[i]["id"].ToString(), picnewsdt.Rows[i]["id"].ToString()));
}
TitleBox.Visible = true;
TitleBox.Text = "123";
TitleBox.Text = (new PicNewsManage().QueryPicNews(picnewsdpl.SelectedValue)).Rows[0]["title"].ToString();
tbContent.Text = (new PicNewsManage().QueryPicNews(picnewsdpl.SelectedValue)).Rows[0]["details"].ToString();
OntopDpl.SelectedIndex = ((new PicNewsManage().QueryPicNews(picnewsdpl.SelectedValue)).Rows[0]["ontop"].ToString() == "True") ? 0 : 1;
}
}
if (Functions.Text == "科院相册")
{
defaultuploadpath = "~/images/";
}
if (FileDpl.Visible == true)
{
FileDpl.Items.Clear();
DataTable fdt = new FilesManage().QueryFileName();
int count = fdt.Rows.Count;
if (count > 0)
{
for (int i = 0; i < count; i++)
{
FileDpl.Items.Add(new ListItem(fdt.Rows[i]["filename"].ToString(), fdt.Rows[i]["filename"].ToString()));
}
MessageLbl.Text = "";
}
}
if (ConfirmReplace1.Visible == true)
{
imgb1.ImageUrl = "~/img/show1.png";
imgb2.ImageUrl = "~/img/show2.png";
imgb3.ImageUrl = "~/img/show3.png";
MessageLbl.Text = "";
}
if (QA_Ignore.Visible == true)
{
DataTable dt = new QAManage().QueryComments();
QAText.Text = dt.Rows[QADpl.SelectedIndex]["question"].ToString();
}
}
protected void zszc_Click(object sender, EventArgs e)
{
pageid = "1";
InitializePage();
RefreshButton.Visible = true;
CleartbContent();
SuperDelete.Visible = true;
Functions.Visible = true;
Functions.Text = "招生政策";
Instructions = "这里，您可以通过非常直观的方式对科院今年的招生政策进行规范的修改。";
TitlePlace.Visible = true;
TitlePlace.Text = "页面标题";
TitleBox.Visible = true;
TextPlace.Visible = true;
TextPlace.Text = "页面正文";
tbContent.Visible = true;
docdpl.Visible = true;
Docdl.Visible = true;
submit_CreateDoc.Visible = true;
submit_EditDoc.Visible = true;
docdpl.Items.Clear();
DataTable dt = new DocsManage().QueryDocss("1");
int i = dt.Rows.Count;
for (int j = 0; j < i; j++)
{
docdpl.Items.Add(new ListItem(dt.Rows[j]["id"].ToString(), dt.Rows[j]["id"].ToString()));
}
if (!Page.IsPostBack)
{
docdpl.SelectedIndex = 0;
}
}
protected void zsxx_Click(object sender, EventArgs e)
{
pageid = "3";
InitializePage();
SuperDelete.Visible = true;
RefreshButton.Visible = true;
Functions.Visible = true;
Functions.Text = "录取分数";
Instructions = "录取分数，您可以随时修改。(请注意，如果您想要插入Excel或者Word当中的表格，请先插入表格，然后点击编辑器左上角的“源码”，将正文最前方的“border=“0”改成1，再次点击“源码”返回，即可继续添加文本，只有这样，添加的表格才能显示出边框。”)";
TitlePlace.Visible = true;
TitlePlace.Text = "页面标题";
TitleBox.Visible = true;
TextPlace.Visible = true;
TextPlace.Text = "页面正文";
tbContent.Visible = true;
docdpl.Visible = true;
Docdl.Visible = true;
submit_CreateDoc.Visible = true;
submit_EditDoc.Visible = true;
docdpl.Items.Clear();
DataTable dt = new DocsManage().QueryDocss("3");
int i = dt.Rows.Count;
for (int j = 0; j < i; j++)
{
docdpl.Items.Add(new ListItem(dt.Rows[j]["id"].ToString(), dt.Rows[j]["id"].ToString()));
}
if (!Page.IsPostBack)
{
docdpl.SelectedIndex = 0;
}
}
protected void zsjh_Click(object sender, EventArgs e)
{
pageid = "2";
InitializePage();
RefreshButton.Visible = true;
SuperDelete.Visible = true;
Functions.Visible = true;
Functions.Text = "招生计划";
Instructions = "您在这里对招生计划的每一处修改，都将完整呈现给每一位访客。";
TitlePlace.Visible = true;
TitlePlace.Text = "页面标题";
TitleBox.Visible = true;
TextPlace.Visible = true;
TextPlace.Text = "页面正文";
tbContent.Visible = true;
docdpl.Visible = true;
Docdl.Visible = true;
submit_CreateDoc.Visible = true;
submit_EditDoc.Visible = true;
docdpl.Items.Clear();
DataTable dt = new DocsManage().QueryDocss("2");
int i = dt.Rows.Count;
for (int j = 0; j < i; j++)
{
docdpl.Items.Add(new ListItem(dt.Rows[j]["id"].ToString(), dt.Rows[j]["id"].ToString()));
}
if (!Page.IsPostBack)
{
docdpl.SelectedIndex = 0;
}
}
protected void rxzn_Click(object sender, EventArgs e)
{
pageid = "4";
InitializePage();
SuperDelete.Visible = true;
RefreshButton.Visible = true;
Functions.Visible = true;
Functions.Text = "入学指南";
Instructions = "此处，您对新同学的每一句关切的问候，都能展现的淋漓尽致。";
TitlePlace.Visible = true;
TitlePlace.Text = "页面标题";
TitleBox.Visible = true;
TextPlace.Visible = true;
TextPlace.Text = "页面正文";
tbContent.Visible = true;
docdpl.Visible = true;
Docdl.Visible = true;
submit_CreateDoc.Visible = true;
submit_EditDoc.Visible = true;
docdpl.Items.Clear();
DataTable dt = new DocsManage().QueryDocss("4");
int i = dt.Rows.Count;
for (int j = 0; j < i; j++)
{
docdpl.Items.Add(new ListItem(dt.Rows[j]["id"].ToString(), dt.Rows[j]["id"].ToString()));
}
if (!Page.IsPostBack)
{
docdpl.SelectedIndex = 0;
}
}
protected void docdpl_SelectedIndexChanged(object sender, EventArgs e)
{
docid = docdpl.SelectedValue;
DataTable dt = new DocsManage().QueryDoc(docid);
TitleBox.Text = dt.Rows[0]["title"].ToString();
tbContent.Text = dt.Rows[0]["text"].ToString();
Docdl.SelectedIndex = (dt.Rows[0]["actived"].ToString() == "True") ? 0 : 1;
}
protected void Page_Load(object sender, EventArgs e)
{
pageindex = Convert.ToInt32(Request.QueryString["pageid"]);
tableindex = Request.QueryString["tid"];
pageid = Request.QueryString["pid"];
if (tableindex == null || pageid == "-1")
{
Response.Redirect("Default.aspx");
}
if (pageid != null)
{
try
{
DataTable pagedt = new DocsManage().QueryDoc(pageid);
MainText = pagedt.Rows[0]["text"].ToString();
sTitle = pagedt.Rows[0]["title"].ToString();
}
catch (Exception)
{
throw;
}
paginator.Visible = false;
conter_title.Visible = false;
conter_nav.Visible = false;
}
else
{
paginator.Visible = true;
conter_title.Visible = true;
conter_nav.Visible = true;
conter_text.Visible = false;
conter_texttitle.Visible = false;
DataTable pagedt = new DocsManage().QueryDocs(tableindex);
TablePagesRep.DataSource = pagedt;
TablePagesRep.DataBind();
MainText = null;
sTitle = null;
}
pagesintotal = (new DocsManage().QueryDocs(tableindex)).Rows.Count;
pagetotal = pagesintotal / 10;
if (pagesintotal % 10 != 0)
pagetotal += 1;
DataTable sl = new DataTable();
sl.Columns.Add("pageid", Type.GetType("System.Int32"));
for (int i = 0; i < pagetotal; i++)
{
sl.Rows.Add();
sl.Rows[i]["pageid"] = i + 1;
}
PageSelector.DataSource = sl;
PageSelector.DataBind();
SetCurrentPagelist();
}
