public DataTable MakeTable(string startindex, string endindex)
{
int sindex = Convert.ToInt32(startindex);
int eindex = Convert.ToInt32(endindex);
DataTable newdt = new DataTable();
newdt.Columns.Add("picurl");
newdt.Columns.Add("id");
DataTable ori = new PicturesManage().QueryPictures();
if (eindex + 1 > ori.Rows.Count)
{
eindex = ori.Rows.Count - 1;
}
for (; sindex <= eindex; sindex++)
{
if (sindex < 0)
break;
if (ori.Rows[sindex] == null)
break;
int tempi = sindex;
DataRow dtrow = newdt.NewRow();
dtrow["picurl"] = ori.Rows[sindex]["picurl"].ToString();
dtrow["id"] = ori.Rows[sindex]["id"].ToString();
newdt.Rows.Add(dtrow);
sindex = tempi;
}
return newdt;
}
protected void Delete_Command(object sender, CommandEventArgs e)
{
bool i = new PicturesManage().Delete(e.CommandArgument.ToString());
if (i)
{
orisrc = new PicturesManage().Get(e.CommandArgument.ToString());
string str = Server.MapPath(orisrc);
System.IO.File.Delete(str);
Response.Write("<script language=javascipt>alert('成功删除')</script>");
}
else
Response.Write("<script language=javascipt>alert('删除失败')</script>");
}
protected void Create_Click(object sender, EventArgs e)
{
// string iss = FileUpload.FileName;
// Response.Write("<script language=javascript>alert('" + iss + "')</script>");
if (IsPostBack)
{
Boolean fileOK = false;
String path = Server.MapPath("../images_index/");
if (FileUpload.HasFile)
{
String fileExtension =
System.IO.Path.GetExtension(FileUpload.FileName).ToLower();
String[] allowedExtensions = { ".gif", ".png", ".jpeg", ".jpg" };
for (int i = 0; i < allowedExtensions.Length; i++)
{
if (fileExtension == allowedExtensions[i])
{
fileOK = true;
}
}
}
if (fileOK)
{
try
{
bool i = new PicturesManage().CreateIndex("../images_index/" + FileUpload.FileName);
if (i)
{
FileUpload.PostedFile.SaveAs(path + FileUpload.FileName);
Response.Write("<script language=javascript>alert('图片上传成功!点击左侧相册管理返回！')</script>");
}
}
catch (Exception ex)
{
Response.Write("<script language=javascript>alert('图片上传失败'" + ex.Message + ")</script>");
}
}
else
{
Response.Write("<script language=javascript>alert('不接受的文件类型！')</script>");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
string username = Session["admin"].ToString();
//bool i = new AdminsManage().CheckLevel(username);
//if (i != false)
// form1.Visible = false;
//else
// form1.Visible = true;
}
catch
{
Response.Redirect("Login.aspx");
}
picid = Request.QueryString["picid"];
orisrc = new PicturesManage().Get(picid);
if (picid == null)
Replace.Visible = false;
else Replace.Visible = true;
}
protected void Page_Load(object sender, EventArgs e)
{
pageindex = Request.QueryString["pageindex"];
if (pageindex == null)
pageindex = "1";
DataTable dt = new PicturesManage().Query();
WallRepeater.DataSource = new PicturesManage().FormRepeater(dt, Int32.Parse(pageindex), 20);
WallRepeater.DataBind();
int num = new PicturesManage().Query().Rows.Count;
int pagecount = 0;
if (num % 20 == 0)
pagecount = num / 20;
else pagecount = num / 20 + 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();
}
protected void PicturesDelete_Click(object sender, EventArgs e)
{
int itemtodelete = Convert.ToInt32(PicturesSelector.SelectedValue);
bool i = new PicturesManage().Delete(itemtodelete.ToString());
int index = Convert.ToInt32(PicturesSelector.SelectedValue.ToString());
string file = index.ToString() + ".jpg";
string path = System.AppDomain.CurrentDomain.BaseDirectory + "images\\";
File.Delete(path + file);
string scriptstring="";
if (i == true)
{
scriptstring = "alert('删除成功!');";
}
else
Response.Write("<script lang=javascript>alert('删除失败!')</script>");
InitializePictures();
Page.ClientScript.RegisterStartupScript(this.GetType(), "", scriptstring, true);
RefreshEvent_Handler();
}
public void InitializePictures()
{
DataTable dt = new PicturesManage().QueryPictures();
int count = dt.Rows.Count;
PicturesSelector.Items.Clear();
for (int i = 0; i < count; i++)
{
PicturesSelector.Items.Add(new ListItem(dt.Rows[i]["picurl"].ToString(), dt.Rows[i]["id"].ToString()));
}
}
protected void PicturesDelete_Click(object sender, EventArgs e)
{
int itemtodelete = Convert.ToInt32(PicturesSelector.SelectedValue);
bool i = new PicturesManage().Delete(itemtodelete.ToString());
int index = Convert.ToInt32(PicturesSelector.SelectedValue.ToString());
string file = index.ToString() + ".jpg";
string path = System.AppDomain.CurrentDomain.BaseDirectory + "images\\";
File.Delete(path + file);
if (i == true)
{
Response.Write("<script lang=javascript>alert('删除成功！')</script>");
}
else
Response.Write("<script lang=javascript>alert('删除失败！')</script>");
InitializePictures();
}
