ASP.NET notes on publishing management of small system cases
- 2020-06-01 09:35:19
- OfStack
Master page: SiteFont.Master
Master page CSS file: main.css
Main page: News_admin.aspx
Article list page: News_list.aspx
Add/modify the article page: News_add.aspx
Add/modify the article background code: News_add.aspx.cs
Article details page: News_detail.aspx
Background code for article details: News_detail.aspx.cs
Load the data dynamically using Repeater in the ascx file: News_Tablist.ascx
News_Tablist.ascx.cs
Attachment upload page: Pic_load.aspx
Attached upload background code: Pic_load.aspx.cs
<%@ Master Language="C#" AutoEventWireup="true" CodeBehind="SiteFont.master.cs" Inherits=" Collaborative enterprise management system .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> My home page |</li>
<li> About us |</li>
<li> Download resources |</li>
<li> My collection |</li>
<li> The article dynamic |</li>
<li> About us </li>
</ul>
</div>
<br class="clear"/>
<asp:ContentPlaceHolder ID="ContentPlaceHolder1" runat="server">
</asp:ContentPlaceHolder>
<div id="footer">
<br class="clear"/>
<hr />
<center>
Copyright © 2014-2015 all rights reserved 2013-2013 guangdong A
</center>
</div>
</div>
</form>
</body>
</html>
Master page CSS file: main.css
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;
}
Main page: News_admin.aspx
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="News_admin.aspx.cs" Inherits=" Collaborative enterprise management system .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=" Collaborative enterprise management system .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"> Published articles </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>
No article for now </td>
</tr>
</table>
</EmptyDataTemplate>
<ItemTemplate>
<tr style="background-color: #FFFBD6;color: #333333;">
<td>
<asp:Button ID="DeleteButton" runat="server" CommandName="Delete" Text=" delete " />
<a href='News_add.aspx?flag=edit&id=<%# Eval ("ID") %>' > Modify the </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>
Article list page: News_list.aspx
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="News_list.aspx.cs" Inherits=" Collaborative enterprise management system .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=" Collaborative enterprise management system .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>
No article for now
</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 Number of pages parameter name --%>
<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>
Add/modify the article page: News_add.aspx
<%@ Page Language="C#" AutoEventWireup="true"ValidateRequest="false" CodeBehind="News_add.aspx.cs" Inherits=" Collaborative enterprise management system .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=" The title ">
</asp:Label><asp:TextBox ID="txtTitle"
runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td>
<asp:Label ID="Label2" runat="server" Text=" The body of the "></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=" save " onclick="btnSave_Click" />
</td>
</tr>
</table>
</div>
</form>
</body>
</html>
Add/modify the article background code: News_add.aspx.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using Collaborative enterprise management system .DAL.DataSetNewsTableAdapters;
namespace Collaborative enterprise management system .admin
{
public partial class News_add : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack) {
// Incoming parameters
var flag = Request["flag"];
if (flag == "add") { }
// If it is the parameter that represents the modification , Depending on the ID Get the data in the database
// Display on the modification page
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(" Parameter passed in incorrectly "); }
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (!IsValid) {
return;
}
// save
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"," There is no ");
}
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");
}
}
}
Article details page: News_detail.aspx
<%@ Page Title="" Language="C#" MasterPageFile="~/SiteFont.Master" AutoEventWireup="true" CodeBehind="News_detail.aspx.cs" Inherits=" Collaborative enterprise management system .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"> The author: <asp:Literal ID="Literal2" runat="server"></asp:Literal>
Post date: <asp:Literal ID="Literal3" runat="server"></asp:Literal></p>
<br class="clear" />
<p><asp:Literal ID="Literal4" runat="server"></asp:Literal></p>
</asp:Content>
Background code for article details: News_detail.aspx.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using Collaborative enterprise management system .DAL.DataSetNewsTableAdapters;
namespace Collaborative enterprise management system .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 = " The specified news could not be found. Please view other news. ";
}
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;
}
}
}
}
}
Load the data dynamically using Repeater in the ascx file: News_Tablist.ascx
<%@ Control Language="C#" AutoEventWireup="true" CodeBehind="News_Tablist.ascx.cs" Inherits=" Collaborative enterprise management system .admin.News_Tablist" %>
<asp:Repeater ID="Repeater1" runat="server" >
<HeaderTemplate><ul></HeaderTemplate>
<ItemTemplate><li> Title: <%# Eval("sTitle")%></li></ItemTemplate>
<FooterTemplate></u1></FooterTemplate>
</asp:Repeater>
News_Tablist.ascx.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using Collaborative enterprise management system .DAL.DataSetNewsTableAdapters;
namespace Collaborative enterprise management system .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;
}
}
}
Attachment upload page: Pic_load.aspx
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;
}
Attached upload background code: Pic_load.aspx.cs
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 Collaborative enterprise management system .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) {
// Verify file type
string ext = Path.GetExtension(fileload.FileName).ToLower();
Response.Write(ext);
if (ext == ".jpg" || ext == ".jpeg" || ext == ".gif" || ext == ".png")
{
Response.Write("sucess");
// The full path. The root directory
fileload.SaveAs(Server.MapPath("~/image/" + fileload.FileName));
}
else
{
ClientScript.RegisterStartupScript(GetType(), "alert", "alert(' Upload only allowed jpg/jpeg/gif/png file ');", true);
return;
}
}
}
}
}