【正文】 /script/asp:Contentasp:Content ID=Content1 ContentPlaceHolderID=ContentPlaceHolder_Bar runat=server 管理首頁amp。nbsp。amp。gt。amp。nbsp。房源信息列表/asp:Contentasp:Content ID=Content ContentPlaceHolderID=ContentPlaceHolder_Content runat=server div style=height: 10px。 /div table cellpadding=2 cellspacing=1 class=border tr td b關(guān)鍵字：/b /td td asp:TextBox ID=txtTitle runat=server MaxLength=25/asp:TextBox /td td b審核狀態(tài)：/b /td td asp:DropDownList ID=ddlFlag runat=server asp:ListItem Value=全部/asp:ListItem asp:ListItem Value=通過通過/asp:ListItem asp:ListItem Value=不通過不通過/asp:ListItem /asp:DropDownList /td td asp:Button ID=btnSearch runat=server Text=查詢 OnClick=btnSearch_Click/asp:Buttonamp。nbsp。amp。nbsp。amp。nbsp。amp。nbsp。amp。nbsp。amp。nbsp。 asp:Button ID=btnDelete runat=server Text=刪除 OnClick=btnDelete_Click /amp。nbsp。amp。nbsp。amp。nbsp。amp。nbsp。amp。nbsp。amp。nbsp。 input id=btnAdd runat=server type=button value=發(fā)布房源 onclick=btnAdd_Click()。 / /td td class=tdbg /td /tr /table div style=height: 10px。 /div asp:GridView ID=gridView runat=server AllowPaging=True CssClass=GridViewStyle HeaderStyleHeight=30 Width=100% CellPadding=3 OnPageIndexChanging=gridView_PageIndexChanging BorderWidth=1px DataKeyNames=ID OnRowDataBound=gridView_RowDataBound AutoGenerateColumns=false PageSize=10 RowStyleHorizontalAlign=Center OnRowCreated=gridView_OnRowCreated Columns asp:TemplateField ControlStyleWidth=30 HeaderText=選擇 ItemTemplate asp:CheckBox ID=DeleteThis runat=server / /ItemTemplate /asp:TemplateField asp:BoundField DataField=Title HeaderText=標題 SortExpression=Title ItemStyleHorizontalAlign=Center / asp:BoundField DataField=Region HeaderText=地區(qū) SortExpression=Region ItemStyleHorizontalAlign=Center / asp:BoundField DataField=LeaseType HeaderText=租賃方式 SortExpression=LeaseType ItemStyleHorizontalAlign=Center / asp:BoundField DataField=Zhuangxiu HeaderText=裝修 SortExpression=Zhuangxiu ItemStyleHorizontalAlign=Center / asp:BoundField DataField=CreateTime HeaderText=發(fā)布時間 SortExpression=CreateTime ItemStyleHorizontalAlign=Center DataFormatString={0:yyyyMMdd} / asp:BoundField DataField=Price HeaderText=價格 SortExpression=Price ItemStyleHorizontalAlign=Center / asp:BoundField DataField=HouseType HeaderText=房屋類型 SortExpression=HouseType ItemStyleHorizontalAlign=Center / asp:BoundField DataField=Floor HeaderText=樓層 SortExpression=Floor ItemStyleHorizontalAlign=Center / asp:BoundField DataField=XiaoquName HeaderText=小區(qū)名稱 SortExpression=XiaoquName ItemStyleHorizontalAlign=Center / asp:BoundField DataField=Address HeaderText=小區(qū)地址 SortExpression=Address ItemStyleHorizontalAlign=Center / asp:BoundField DataField=Status HeaderText=狀態(tài) SortExpression=Status ItemStyleHorizontalAlign=Center / asp:BoundField DataField=Flag HeaderText=審核 SortExpression=Flag ItemStyleHorizontalAlign=Center / asp:HyperLinkField HeaderText=編輯 ControlStyleWidth=50 DataNavigateUrlFields=ID DataNavigateUrlFormatString=?id={0} Text=編輯 / asp:TemplateField ControlStyleWidth=50 HeaderText=刪除 Visible=false ItemTemplate asp:LinkButton ID=LinkButton1 runat=server CausesValidation=False CommandName=Delete Text=刪除/asp:LinkButton /ItemTemplate /asp:TemplateField /Columns /asp:GridView div style=height: 10px。 /div/asp:Content數(shù)據(jù)庫操作部分代碼如下。using System。using 。using 。using 。using DataBase。using Entity。using 。using 。namespace DAO{ /// summary /// 數(shù)據(jù)訪問類:AttachmentDAO /// /summary public partial class AttachmentDAO { public AttachmentDAO() { } region Method /// summary /// 得到最大ID /// /summary public int GetMaxId() { return (ID, Attachment)。 } /// summary /// 是否存在該記錄 /// /summary public bool Exists(int ID) { StringBuilder strSql = new StringBuilder()。 (select count(1) from Attachment)。 ( where ID=@ID)。 SqlParameter[] parameters = { new SqlParameter(@ID, ,4)}。 parameters[0].Value = ID。 return ((), parameters)。 } /// summary /// 增加一條數(shù)據(jù) /// /summary public int Add(Attachment model) { StringBuilder strSql = new StringBuilder()。 (insert into Attachment()。 (ReftableName,ReftableID,FileType,FileSize,FilePath,FileName))。 ( values ()。 (@ReftableName,@ReftableID,@FileType,@FileSize,@FilePath,@FileName))。 (。select @@IDENTITY)。 SqlParameter[] parameters = {