ASP.NET筆記之文章發(fā)布管理小系統(tǒng)案例

%@ Master Language="C#" AutoEventWireup="true" CodeBehind="SiteFont.master.cs" Inherits="協(xié)同企業(yè)管理系統(tǒng).SiteFont" %>

 !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/main.css" rel="stylesheet" type="text/css" />
     script src="Scripts/jquery-1.4.1.js" type="text/javascript">/script>
     script type="text/javascript">
 //        $(function () {
 //            $("#nav li").mouseenter(function () {
 //                $(this).addClass("active").siblings().removeClass("active")
 //            });
 //        });
     /script>
     asp:ContentPlaceHolder ID="head" runat="server">
     /asp:ContentPlaceHolder>
 /head>
 body>
     form id="form1" runat="server">
     div id="mainBox">
         div id="header">
             img src="~/image/banner.jpg" runat="server" alt=""/>
             ul id="nav">
                 li>我的首頁(yè) |/li>
                 li>關(guān)于我們 |/li>
                 li>資源下載 |/li>
                 li>我的收藏 |/li>
                 li>文章動(dòng)態(tài) |/li>
                 li>關(guān)于我們/li>
             /ul>

         /div>
         br class="clear"/>
         asp:ContentPlaceHolder ID="ContentPlaceHolder1" runat="server">

         /asp:ContentPlaceHolder>
         div id="footer">
            br class="clear"/>
            hr />
             center>
                智慧協(xié)同版權(quán)所有 2013-2013 粵A
             /center>
         /div>
     /div>
     /form>
 /body>
 /html>

body {
 }
 .clear
 {
     clear:both;}

 #mainBox
 {
     width:950px;
     margin-left:auto;
     margin-right:auto;}
 #nav
 {
     list-style-type:none;
     background-color:inherit;
     }
 #nav LI
 {
     float:left;
     margin-right:20px;
     font-size:large;
 }
 #nav .active
 {
     background-color:Red;
     }

%@ Page Language="C#" AutoEventWireup="true" CodeBehind="News_admin.aspx.cs" Inherits="協(xié)同企業(yè)管理系統(tǒng).admin.News_admin" %>

 !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>
 /head>
 body>
     form id="form1" runat="server">

    
     asp:ObjectDataSource ID="obdNews" runat="server" DeleteMethod="Delete"
         InsertMethod="Insert" OldValuesParameterFormatString="original_{0}"
         SelectMethod="GetData"
         TypeName="協(xié)同企業(yè)管理系統(tǒng).DAL.DataSetNewsTableAdapters.T_NewsTableAdapter"
         UpdateMethod="Update">
         DeleteParameters>
             asp:Parameter Name="Original_ID" Type="Int64" />
         /DeleteParameters>
         InsertParameters>
             asp:Parameter Name="ID" Type="Int64" />
             asp:Parameter Name="sTitle" Type="String" />
             asp:Parameter Name="sContent" Type="String" />
             asp:Parameter Name="SbuildDate" Type="String" />
             asp:Parameter Name="iType" Type="Int32" />
             asp:Parameter Name="sUser" Type="String" />
             asp:Parameter Name="sNote" Type="String" />
         /InsertParameters>
         UpdateParameters>
             asp:Parameter Name="sTitle" Type="String" />
             asp:Parameter Name="sContent" Type="String" />
             asp:Parameter Name="SbuildDate" Type="String" />
             asp:Parameter Name="iType" Type="Int32" />
             asp:Parameter Name="sUser" Type="String" />
             asp:Parameter Name="sNote" Type="String" />
             asp:Parameter Name="Original_ID" Type="Int64" />
         /UpdateParameters>
     /asp:ObjectDataSource>
     a href="News_add.aspx?flag=add">發(fā)布文章/a>

     asp:ListView ID="ListView1" runat="server" DataKeyNames="ID"
         DataSourceID="obdNews">
         EmptyDataTemplate>
             table runat="server"
                 style="background-color: #FFFFFF;border-collapse: collapse;border-color: #999999;border-style:none;border-width:1px;">
                 tr>
                     td>
                         暫時(shí)沒(méi)有文章/td>
                 /tr>
             /table>
         /EmptyDataTemplate>
         ItemTemplate>
             tr style="background-color: #FFFBD6;color: #333333;">
                 td>
                     asp:Button ID="DeleteButton" runat="server" CommandName="Delete" Text="刪除" />
                     a href='News_add.aspx?flag=editid=%# Eval ("ID") %>' >修改/a>
                 /td>
                 td>
                     asp:Label ID="sTitleLabel" runat="server" Text='%# Eval("sTitle") %>' />
                 /td>
                 td>
                     asp:Label ID="SbuildDateLabel" runat="server"
                         Text='%# Eval("SbuildDate") %>' />
                 /td>
                 td>
                     asp:Label ID="iTypeLabel" runat="server" Text='%# Eval("iType") %>' />
                 /td>
                 td>
                     asp:Label ID="sUserLabel" runat="server" Text='%# Eval("sUser") %>' />
                 /td>
             /tr>
         /ItemTemplate>
         LayoutTemplate>
             table runat="server">
                 tr runat="server">
                     td runat="server">
                         table ID="itemPlaceholderContainer" runat="server" border="1"
                             style="background-color: #FFFFFF;border-collapse: collapse;border-color: #999999;border-style:none;border-width:1px;font-family: Verdana, Arial, Helvetica, sans-serif;">
                             tr runat="server" style="background-color: #FFFBD6;color: #333333;">
                                 th runat="server">
                                 /th>
                                 th runat="server">
                                     sTitle/th>
                                 th runat="server">
                                     SbuildDate/th>
                                 th runat="server">
                                     iType/th>
                                 th runat="server">
                                     sUser/th>
                             /tr>
                             tr ID="itemPlaceholder" runat="server">
                             /tr>
                         /table>
                     /td>
                 /tr>
                 tr runat="server">
                     td runat="server"
                         style="text-align: center;background-color: #FFCC66;font-family: Verdana, Arial, Helvetica, sans-serif;color: #333333;">
                     /td>
                 /tr>
             /table>
         /LayoutTemplate>
     /asp:ListView>

    
     /form>
 /body>
 /html>

%@ Page Language="C#" AutoEventWireup="true" CodeBehind="News_list.aspx.cs" Inherits="協(xié)同企業(yè)管理系統(tǒng).admin.News_list" %>

 !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>
 /head>
 body>
     form id="form1" runat="server">
     div>

         asp:ObjectDataSource ID="obdNewslist" runat="server" DeleteMethod="Delete"
             InsertMethod="Insert" OldValuesParameterFormatString="original_{0}"
             SelectMethod="GetDataPage" SelectCountMethod="NewsQuery"
             TypeName="協(xié)同企業(yè)管理系統(tǒng).DAL.DataSetNewsTableAdapters.T_NewsTableAdapter"
             UpdateMethod="Update" EnablePaging="True">
             DeleteParameters>
                 asp:Parameter Name="Original_ID" Type="Int64" />
             /DeleteParameters>
             InsertParameters>
                 asp:Parameter Name="sTitle" Type="String" />
                 asp:Parameter Name="sContent" Type="String" />
                 asp:Parameter Name="SbuildDate" Type="String" />
                 asp:Parameter Name="iType" Type="Int32" />
                 asp:Parameter Name="sUser" Type="String" />
                 asp:Parameter Name="sNote" Type="String" />
             /InsertParameters>
             UpdateParameters>
                 asp:Parameter Name="sTitle" Type="String" />
                 asp:Parameter Name="sContent" Type="String" />
                 asp:Parameter Name="SbuildDate" Type="String" />
                 asp:Parameter Name="iType" Type="Int32" />
                 asp:Parameter Name="sUser" Type="String" />
                 asp:Parameter Name="sNote" Type="String" />
                 asp:Parameter Name="Original_ID" Type="Int64" />
             /UpdateParameters>
         /asp:ObjectDataSource>

     /div>
     asp:ListView ID="ListView1" runat="server" DataKeyNames="ID"
         DataSourceID="obdNewslist">

         EmptyDataTemplate>
            暫時(shí)沒(méi)有文章
         /EmptyDataTemplate>
         ItemTemplate>
            li>a href='News_detail.aspx?ID=%#Eval("ID")%>'>%#Eval ("sTitle") %>/a>/li>
         /ItemTemplate>
         LayoutTemplate>
             ul>
                asp:PlaceHolder ID="itemPlaceholder" runat="server">/asp:PlaceHolder>
             /ul>
            %-- QueryStringField 傳頁(yè)數(shù)參數(shù)名字--%>
           asp:DataPager ID="DataPager1" runat="server" PageSize="5" QueryStringField="pageName">
                             Fields>
                                 asp:NextPreviousPagerField ButtonType="Link" ShowFirstPageButton="True"
                                     ShowLastPageButton="false" ShowNextPageButton="false"
                                     ShowPreviousPageButton="true"/>
                                     asp:NumericPagerField>/asp:NumericPagerField>
                                 asp:NextPreviousPagerField ButtonType="Link" ShowFirstPageButton="false"
                                 ShowLastPageButton="True" ShowPreviousPageButton="false" ShowNextPageButton="true" />
                             /Fields>
           /asp:DataPager>
         /LayoutTemplate>
     /asp:ListView>
     /form>
 /body>
 /html>

%@ Page Language="C#" AutoEventWireup="true"ValidateRequest="false" CodeBehind="News_add.aspx.cs" Inherits="協(xié)同企業(yè)管理系統(tǒng).admin.News_add" %>

 !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">

     script src="js/ckeditor/ckeditor.js" type="text/javascript">/script>
     title>/title>
 /head>
 body>
     form id="form1" runat="server">
     div>
         table border="0" cellpadding="0" cellspacing="0">
             tr>
                 td>
                     asp:Label ID="Label1" runat="server" Text="標(biāo)題">
                     /asp:Label>asp:TextBox ID="txtTitle"
                         runat="server">/asp:TextBox>
                 /td>
             /tr>
             tr>
                 td>
                     asp:Label ID="Label2" runat="server" Text="正文">/asp:Label>
                     asp:TextBox ID="txtContent" CssClass="ckeditor"
                         runat="server" TextMode="MultiLine">/asp:TextBox>
                 /td>
             /tr>
             tr>
                td>
                    asp:Button ID="btnSave" runat="server" Text="保存" onclick="btnSave_Click" />
                /td>
             /tr>
         /table>
     /div>
     /form>
 /body>
 /html>

using System;
 using System.Collections.Generic;
 using System.Linq;
 using System.Web;
 using System.Web.UI;
 using System.Web.UI.WebControls;
 using 協(xié)同企業(yè)管理系統(tǒng).DAL.DataSetNewsTableAdapters;

 namespace 協(xié)同企業(yè)管理系統(tǒng).admin
 {
     public partial class News_add : System.Web.UI.Page
     {
         protected void Page_Load(object sender, EventArgs e)
         {
             if (!IsPostBack) {
                 //傳入?yún)?shù)
                 var flag = Request["flag"];
                 if (flag == "add") { }
                 //如果是表示修改的參數(shù),則根據(jù)ID獲取數(shù)據(jù)庫(kù)中的數(shù)據(jù)
                 //顯示在修改頁(yè)面上
                 else if (flag == "edit") {
                     int ID = Convert.ToInt32(Request["ID"]);
                     var NewsRow = new T_NewsTableAdapter().GetDataById(ID).Single();
                     txtContent.Text = NewsRow.sContent;
                     txtTitle.Text = NewsRow.sTitle;
                 }
                 else { throw new Exception("參數(shù)傳入有誤"); }
             }
         }

         protected void btnSave_Click(object sender, EventArgs e)
         {
             if (!IsValid) {
                 return;
             }
             //保存
             string flag = Request["flag"];
             if (flag == "add") {
                 string nowTime=System.DateTime.Now.ToString("G");
                 new T_NewsTableAdapter().Insert(txtTitle.Text, txtContent.Text, nowTime,1,"admin","無(wú)");
             }
             else if(flag=="edit"){
                 int ID=Convert.ToInt32(Request["ID"]);
                 var newsRow=new T_NewsTableAdapter().GetDataById(ID).Single();
                 newsRow.sContent=txtContent.Text;
                 newsRow.sTitle=txtTitle.Text;
                 new T_NewsTableAdapter().Update(newsRow);
             }
             Response.Redirect("News_admin.aspx");
         }
     }
 }

%@ Page Title="" Language="C#" MasterPageFile="~/SiteFont.Master" AutoEventWireup="true" CodeBehind="News_detail.aspx.cs" Inherits="協(xié)同企業(yè)管理系統(tǒng).admin.News_detail" %>
  asp:Content ID="Content1" ContentPlaceHolderID="head" runat="server">
  /asp:Content>
  asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
     center>h2>asp:Literal ID="Literal1" runat="server" >/asp:Literal>/h2>/center>
     p style="float:right">作者：asp:Literal ID="Literal2" runat="server">/asp:Literal>
      發(fā)布日期：asp:Literal ID="Literal3" runat="server">/asp:Literal>/p>
      br class="clear" />
      p>asp:Literal ID="Literal4" runat="server">/asp:Literal>/p>
  /asp:Content>

using System;
 using System.Collections.Generic;
 using System.Linq;
 using System.Web;
 using System.Web.UI;
 using System.Web.UI.WebControls;
 using 協(xié)同企業(yè)管理系統(tǒng).DAL.DataSetNewsTableAdapters;

 namespace 協(xié)同企業(yè)管理系統(tǒng).admin
 {
     public partial class News_detail : System.Web.UI.Page
     {
         protected void Page_Load(object sender, EventArgs e)
         {
             if (!IsPostBack) {
                 int ID = Convert.ToInt32(Request["ID"]);
                 var NewsTable = new T_NewsTableAdapter().GetDataById(ID);
                 if (NewsTable.Count = 0)
                 {
                     Literal1.Visible = false;
                     Literal2.Visible = false;
                     Literal3.Visible = false;
                     Literal4.Text = "找不到指定新聞，請(qǐng)查看其它新聞。";
                 }
                 else if(NewsTable.Count>0) {
                     var NewsRows = NewsTable.Single();
                     Literal1.Text=NewsRows.sTitle;
                     Literal2.Text = NewsRows.sUser;
                     Literal3.Text = NewsRows.SbuildDate;
                     Literal4.Text = NewsRows.sContent;
                 }
             }
         }
     }
 }

%@ Control Language="C#" AutoEventWireup="true" CodeBehind="News_Tablist.ascx.cs" Inherits="協(xié)同企業(yè)管理系統(tǒng).admin.News_Tablist" %>
 asp:Repeater ID="Repeater1" runat="server" >
     HeaderTemplate>ul>/HeaderTemplate>
     ItemTemplate>li>標(biāo)題：%# Eval("sTitle")%>/li>/ItemTemplate>
     FooterTemplate>/u1>/FooterTemplate>
 /asp:Repeater>

using System;
 using System.Collections.Generic;
 using System.Linq;
 using System.Web;
 using System.Web.UI;
 using System.Web.UI.WebControls;
 using 協(xié)同企業(yè)管理系統(tǒng).DAL.DataSetNewsTableAdapters;

 namespace 協(xié)同企業(yè)管理系統(tǒng).admin
 {
     public partial class News_Tablist : System.Web.UI.UserControl
     {
         protected void Page_Load(object sender, EventArgs e)
         {
             if (!IsPostBack) {
                 Response.Write("3333");
                 var data = new T_NewsTableAdapter().GetDataByiType(iType);
                 Repeater1.DataSource = data;
                 Repeater1.DataBind();
             }
         }

         public int iType
         {
             get;
             set;
         }
     }
 }

%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Pic_load.aspx.cs" Inherits="協(xié)同企業(yè)管理系統(tǒng).admin.Pic_load" %>

 !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>
 /head>
 body>
     form id="form1" runat="server">
     div>
         asp:FileUpload ID="FileUpload1" runat="server" />
         asp:Button ID="Button1" runat="server" Text="Button" onclick="Button1_Click" />
     /div>
     /form>
 /body>
 /html>

using System;
 using System.Collections.Generic;
 using System.Linq;
 using System.Web;
 using System.Web.UI;
 using System.Web.UI.WebControls;
 using System.IO;

 namespace 協(xié)同企業(yè)管理系統(tǒng).admin
 {
     public partial class Pic_load : System.Web.UI.Page
     {
         protected void Page_Load(object sender, EventArgs e)
         {

         }

         protected void Button1_Click(object sender, EventArgs e)
         {
             FileUpload fileload = (FileUpload)form1.FindControl("FileUpload1");
             if (fileload.HasFile) {
                 //校驗(yàn)文件類型
                 string ext = Path.GetExtension(fileload.FileName).ToLower();
                 Response.Write(ext);
                 if (ext == ".jpg" || ext == ".jpeg" || ext == ".gif" || ext == ".png")
                 {
                     Response.Write("sucess");
                     //全路徑。根目錄
                     fileload.SaveAs(Server.MapPath("~/image/" + fileload.FileName));
                 }
                 else
                 {
                     ClientScript.RegisterStartupScript(GetType(), "alert", "alert('只允許上傳jpg/jpeg/gif/png文件');", true);

                     return;
                 }
             }
         }
     }
 }