当前位置:编程学习 > C#/ASP.NET >>

添加文件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
CopyRight © 2012 站长网 编程知识问答 www.zzzyk.com All Rights Reserved
部份技术文章来自网络,