添加文件ManageFile代码示例
添加文件ManageFile代码示例<%@ Page Language="C#" AutoEventWireup="true" CodeFile="ManageFile.aspx.cs" ValidateRequest="false" enableEventValidation="false" Inherits="Manage_ManageFile" %>
<%@ Register Assembly="DotNetTextBox" Namespace="DotNetTextBox" TagPrefix="DNTB" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>无标题页</title>
<link href="../CSS/ManageStyleSheet.css" rel="stylesheet" type="text/css" />
</head>
<body>
<form id="form1" runat="server">
<div>
<table cellspacing="0" width="98%" >
<tr>
<td style="width: 675px" valign="top">
<table border="0" width="100%" style="height: 25px">
<tr>
<td align="left" style="height: 40px">
<asp:Label ID="TitleLB" runat="server" CssClass="TitleLB"></asp:Label></td>
<td>
<asp:Button ID="AddBtn" runat="server" Text="添加" CssClass="BlueBtn" OnClick="AddBtn_Click" />
</td>
<td >
<asp:Button ID="DelAllBtn" runat="server" Text="删除全部" CssClass="BlueBtn" OnClick="DelAllBtn_Click" OnClientClick="return confirm('你确定删除全部吗?')"/>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td align="right">
<asp:Button ID="Button3" runat="server" Text="在线咨询" Visible="false" OnClick="Button3_Click" /></td>
</tr>
<tr>
<td valign="top">
<asp:Panel ID="InfoPanel" runat="server" Width="100%">
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" Width="100%" AllowPaging="True" ShowHeader="false" OnSelectedIndexChanging="GridView1_SelectedIndexChanging" OnRowDataBound="GridView1_RowDataBound" OnPageIndexChanging="GridView1_PageIndexChanging" PageSize="13">
<Columns>
<asp:TemplateField>
<ItemTemplate>
<table width="100%">
<tr>
<td width="50px" >
<img src="../images/Button1.jpg" alt=""/></td>
<td align="left">
<asp:HyperLink ID="TitleHL" runat="server" CssClass="MyTitle" Text='<%#DataBinder.Eval(Container.DataItem,"title" )%>' NavigateUrl='<%#Eval("id","See.aspx?id={0}" )%>' Target="_blank">
</asp:HyperLink></td>
<td width="100px">
<asp:Label ID="TypeLB" runat="server" CssClass="MyTitle" Text='<%#DataBinder.Eval(Container.DataItem,"state" )%>'></asp:Label></td>
<td width="100px">
<asp:Label ID="Label2" runat="server" CssClass="MyTitle" Text='<%#Eval("time","{0:yyyy-MM-dd}") %>'></asp:Label></td>
<td width="50px" >
<asp:Button ID="EditBtn" runat="server" Text="编辑" CssClass="BlueBtn" CommandArgument='<% #DataBinder.Eval(Container.DataItem,"id")%>' OnClick="EditBtn_Click"/></td>
<td width="50px" >
<asp:Button ID="UpBtn" runat="server" Text="置顶" CssClass="BlueBtn" CommandArgument='<% #DataBinder.Eval(Container.DataItem,"id")%>' OnClick="UpBtn_Click"/></td>
<td width="50px">
<asp:Button ID="DeleteBtn" runat="server" Text="删除" CssClass="BlueBtn" CommandArgument='<%# DataBinder.Eval(Container.DataItem,"id") %>' OnClick="DeleteBtn_Click" OnClientClick="return confirm('你确定删除吗?')" /></td>
</tr>
</table>
</ItemTemplate>
</asp:TemplateField>
</Columns>
<PagerSettings FirstPageText="首页" LastPageText="尾页" Mode="NextPreviousFirstLast"
NextPageText="下一页" PreviousPageText="上一页" />
</asp:GridView>
</asp:Panel>
</td>
</tr>
<tr>
<td style="" valign="top">
<asp:Panel ID="AddPanel" runat="server" Visible="false" Width="100%">
<table style="width:100%; text-align:left; font-size:12px; vertical-align:middle;" >
<tr>
<td style="width:71px;">标题/名字:</td>
<td align="left">
<asp:TextBox ID="TitleTB" runat="server" Width="438px"></asp:TextBox>
<asp:Panel ID="TltlePanel" runat="server" Visible="false" Width="100%">
<asp:CheckBox ID="RedCB" runat="server" />加红
<asp:CheckBox ID="ThickCB" runat="server" />加粗
<asp:CheckBox ID="ImportCB" runat="server" />首页显示
</asp:Panel>
</td>
</tr>
<tr>
<td colspan="2">
<asp:Panel ID="ReferPanel" runat="server" Visible="false" Width="100%">
<table border="0" cellpadding="0" cellspacing="0">
<tr>
<td style="width:71px;">引用:</td>
<td ><asp:TextBox ID="RenferLB" runat="server" Width="438px"></asp:TextBox>
</td>
</tr>
</table>
</asp:Panel>
</td>
</tr>
<tr>
<td colspan="2">
<asp:Panel ID="TimePanel" runat="server" Width="100%" Visible="false">
<table border="0" cellpadding="0" cellspacing="0" >
<tr>
<td >
发表时间: <asp:TextBox ID="Time1TB" runat="server"></asp:TextBox>
排序时间: <asp:TextBox ID="Time2TB" runat="server"></asp:TextBox>
</td>
</tr>
</table>
</asp:Panel>
</td>
</tr>
<tr>
<td colspan="2">
<asp:Panel ID="FileUpPanel" runat="server" Visible="false" Width="100%">
<table border="0" cellpadding="0" cellspacing="0">
<tr>
<td style="width:71px;">图片\文件:</td>
<td >
<asp:FileUpload ID="FileUpload" runat="server" Width="445px" />
<asp:Label ID="PictureLB" runat="server"></asp:Label>
<asp:Label ID="Label1" runat="server" Visible="false">请上传长宽比为4:3的图片</asp:Label>
</td>
</tr>
</table>
</asp:Panel>
</td>
</tr>
<tr>
<td colspan="2">
<asp:Panel ID="ContentPanel" runat="server" >
<DNTB:WebEditor ID="FileContentWB" Width="100%" runat="server" />
</asp:Panel>
</td>
</tr>
<tr>
<td align="right" colspan="2" >
<asp:Button ID="DeliverBtn" runat="server" Text="提交" OnClick="DeliverBtn_Click" />
<asp:Button ID="UpdateBtn" runat="server" Text="更新" Visible="false" OnClick="UpdateBtn_Click"/>
<asp:Button ID="CancelBtn" runat="server" Text="取消" OnClick="CancelBtn_Click" />
</td>
</tr>
</table>
</asp:Panel>
</td>
</tr>
</table>
</div>
</form>
</body>
</html>
--------------------编程问答-------------------- using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using DB;
public partial class Manage_ManageFile : System.Web.UI.Page
{
private static int list_id, import = 0, id,list_type;
private int state;
private DataAccess da = new DataAccess();
private DataTable dt = new DataTable();
private static string url, surl, name;
private string title, referurl, script, content;
static private DateTime time1 = DateTime.Now;
static private DateTime time2 = DateTime.Now;
protected void Page_Load(object sender, EventArgs e)
{
list_id = int.Parse(Request.QueryString["list_id"].ToString());
list_type=Request.QueryString["type"]!=null?int.Parse(Request.QueryString["type"].ToString()):0;
Getshow();
GetTitle();
GetSource();
}
protected void Getshow()
{
if(list_type==2||list_id==21)
{
//有上传
if (list_id == 17)
{
ContentPanel.Visible = false;
Label1.Visible = true;
}
FileUpPanel.Visible=true;
}
else
{
FileUpPanel.Visible=false;
}
}
protected void GetTitle()
{
dt = da.GetTable("select * from list where list_id=" + list_id);
title = dt.Rows[0]["listname"].ToString();
TitleLB.Text = title;
}
protected void GetSource()
{
dt = da.GetTable("select * from content where list_id=" + list_id + "order by ordertime desc");
GridView1.DataSource = dt;
ViewState["sourse"] = dt;
GridView1.DataBind();
}
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
int ispicture, import, state;
string TypeText, images;
object dateItem = e.Row.DataItem;
try
{
if (DataBinder.Eval(dateItem, "import") != null)
{
import = System.Convert.ToInt32(DataBinder.Eval(dateItem, "import"));
}
else
{
import = 0;
}
if (DataBinder.Eval(dateItem, "images") != null)
{
ispicture = 1;
}
else
{
ispicture = 0;
}
if (e.Row.RowType == DataControlRowType.DataRow)
{
HyperLink temp = e.Row.Cells[0].FindControl("TitleHL") as HyperLink;
if (temp != null)
{
title = temp.Text.Length > 42 ? temp.Text.Substring(0, 40) + "..." : temp.Text;
if (ispicture == 1)
{
title += "【图】";
}
if (import == 1)
{
title += "[首页显示]";
}
temp.Text = title;
}
dt = ViewState["sourse"] as DataTable;
Label temp2 = e.Row.Cells[0].FindControl("TypeLB") as Label;
if (temp2 != null)
{
state = int.Parse(temp2.Text.ToString());
switch (state)
{
case 0:
TypeText = "未审核";
break;
case 1:
TypeText = "未通过";
break;
case 2:
TypeText = "通过";
break;
default:
TypeText = "";
break;
}
temp2.Text = TypeText;
}
dt = ViewState["sourse"] as DataTable;
}
}
catch (Exception)
{ }
}
protected void GetPath()
{
Boolean fileOk = false;
string path = Server.MapPath("../Upload");
string filename = FileUpload.FileName;
if (FileUpload.HasFile)
{
//取得文件的扩展名,并转换成小写
string fileExtension = System.IO.Path.GetExtension(FileUpload.FileName).ToLower();
//对上传文件的大小进行检测,限定文件最大不超过10M
if (FileUpload.PostedFile.ContentLength > 10240000)
{
fileOk = false;
string key = "Mc";
string script = "<script>alert('上传文件过大!');</script>";
RegisterClientScriptBlock(key, script);
return;
}
else
{
fileOk = true;
}
if (fileOk)
{
url = filename;
FileUpload.PostedFile.SaveAs(path + "\\" + filename);
}
else
{
url = "";
}
}
}
protected void AddBtn_Click(object sender, EventArgs e)
{
TitleLB.Visible = true;
AddPanel.Visible = true;
InfoPanel.Visible = false;
UpdateBtn.Visible = false;
DeliverBtn.Visible = true;
TitleTB.Text = "";
FileContentWB.Text = "";
RenferLB.Text = "";
AddBtn.Visible = false;
DelAllBtn.Visible = false;
ImportCB.Checked = false;
Time1TB.Text = time1.ToString();
Time2TB.Text = time2.ToString();
}
protected void EditBtn_Click(object sender, EventArgs e)
{
AddBtn.Visible = false;
DelAllBtn.Visible = false;
AddPanel.Visible = true;
UpdateBtn.Visible = true;
DeliverBtn.Visible = false;
InfoPanel.Visible = false;
Button EditBtn = sender as Button;
id = int.Parse(EditBtn.CommandArgument);
dt = da.GetTable("select * from content where id=" + id);
try
{
TitleTB.Text = dt.Rows[0]["title"].ToString();
FileContentWB.Text = Server.HtmlDecode(dt.Rows[0]["content"].ToString());
referurl = dt.Rows[0]["referurl"].ToString();
url = dt.Rows[0]["image"].ToString();
import = int.Parse(dt.Rows[0]["import"].ToString());
Time1TB.Text = dt.Rows[0]["time"].ToString();
Time2TB.Text = dt.Rows[0]["ordertime"].ToString();
if (import == 1)
{
ImportCB.Checked = true;
}
if (referurl != "")
{
RenferLB.Visible = true;
RenferLB.Text = referurl;
}
if (url != "")
{
FileUpload.Visible = true;
PictureLB.Text = " 原文件为: " + url;
}
}
catch (Exception)
{
}
}
--------------------编程问答-------------------- protected void UpBtn_Click(object sender, EventArgs e)
{
Button UpBtn = sender as Button;
id = int.Parse(UpBtn.CommandArgument);
try
{
da.GetDs("Update content set ordertime=getdate() where id=" + id + "");
script = "<script>alert('置顶成功!');</script>";
RegisterClientScriptBlock("m", script);
}
catch (Exception)
{ }
GetSource();
}
protected void DeleteBtn_Click(object sender, EventArgs e)
{
Button DelBtn = sender as Button;
id = int.Parse(DelBtn.CommandArgument);
try
{
da.GetDs("delete from content where id=" + id + "");
script = "<script>alert('删除成功!');</script>";
RegisterClientScriptBlock("m", script);
}
catch (Exception)
{ }
GetSource();
}
protected void DeliverBtn_Click(object sender, EventArgs e)
{
GetPath();
title = TitleTB.Text.Replace("'", "''");
referurl = RenferLB.Text.Trim();
time1 = DateTime.Parse(Time1TB.Text.ToString());
time2 = DateTime.Parse(Time2TB.Text.ToString());
content = Server.HtmlEncode(FileContentWB.Text.Replace("'", "''"));
if (ImportCB.Checked == true)
{
import = 1;
}
else
{
import = 0;
}
da.RunSql("insert into content(title,content,list_id,referurl,import,time,ordertime,image)values('" + title + "','" + content + "'," + list_id + ",'" + referurl + "'," + import + ",'" + time1 + "','" + time2 + "','" + url + "') ");
script = "<script>alert('添加成功!');</script>";
RegisterClientScriptBlock("m", script);
AddBtn.Visible = true;
DelAllBtn.Visible = true;
AddPanel.Visible = false;
InfoPanel.Visible = true;
GetSource();
url = "";
time1 = DateTime.Now;
time2 = DateTime.Now;
}
protected void UpdateBtn_Click(object sender, EventArgs e)
{
title = TitleTB.Text.Replace("'", "''");
content = Server.HtmlEncode(FileContentWB.Text.Replace("'", "''"));
GetPath();
referurl = RenferLB.Text.Trim();
time1 = DateTime.Parse(Time1TB.Text.ToString());
time2 = DateTime.Parse(Time2TB.Text.ToString());
if (ImportCB.Checked == true)
{
import = 1;
}
else
{
import = 0;
}
if (url == "")
{
url = surl;
}
try
{
da.RunSql("update content set title='" + title + "',content='" + content + "' ,referurl='" + referurl + "',import=" + import + ",time='" + time1 + "',ordertime='" + time2 + "',image='" + url + "' where id=" + id + "");
script = "<script>alert('更新成功!');</script>";
RegisterClientScriptBlock("m", script);
}
catch (Exception)
{ }
AddBtn.Visible = true;
DelAllBtn.Visible = true;
AddPanel.Visible = false;
InfoPanel.Visible = true;
GetSource();
time1 = DateTime.Now;
time2 = DateTime.Now;
}
protected void CancelBtn_Click(object sender, EventArgs e)
{
TitleLB.Text = "";
FileContentWB.Text = "";
}
protected void GridView1_SelectedIndexChanging(object sender, GridViewSelectEventArgs e)
{
GridView1.PageIndex = e.NewSelectedIndex;
if (ViewState["source"] != null)
{
GridView1.DataSource = ViewState["source"] as DataSet;
GridView1.DataBind();
}
}
protected void DelAllBtn_Click(object sender, EventArgs e)
{
try
{
da.RunSql("delete from content where list_id=" + list_id + "");
script = "<script>alert('删除全部成功!');</script>";
RegisterClientScriptBlock("m", script);
}
catch
{ }
GetSource();
}
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridView1.PageIndex = e.NewPageIndex;
GetSource();
//if (ViewState["source"] != null)
//{
// GridView1.DataSource = ViewState["source"] as DataSet;
// GridView1.DataBind();
//}
}
protected void Button3_Click(object sender, EventArgs e)
{
Response.Redirect("ManageLeaverword.aspx");
}
}
--------------------编程问答--------------------
补充:.NET技术 , ASP.NET