基于Grove的在GridView上的增删改查_c#的gridview的curd-优快云博客

本文链接：https://blog.youkuaiyun.com/zhangchuccc/article/details/5808754

本文介绍了一个用于管理仓库信息的ASP.NET应用程序，包括仓库的增删改查等功能。系统通过GridView展示仓库列表，并提供添加、修改和删除操作。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

前台页面

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="LspWareHouse.aspx.cs" Inherits="Sys_LspWareHouse" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <%@ Register Src="~/UserControls/PageControl.ascx" TagName="PageControl" TagPrefix="uc1" %> <html xmlns="http://www.w3.org/1999/xhtml"> <head id="Head1" runat="server"> <title>仓库管理</title> <link href="../style/GridView.css" mce_href="style/GridView.css" rel="stylesheet" type="text/css" /> <link href="../style/layout.css" mce_href="style/layout.css" rel="stylesheet" type="text/css" /> <mce:style type="text/css"></mce:style><style type="text/css" mce_bogus="1"> .style1 { width: 320px; } </style> </head> <body> <form id="form1" runat="server"> <asp:ScriptManager ID="ScriptManager1" runat="server"> </asp:ScriptManager> <div id="incontent-wel"> <input id="hide_Type" type="hidden" runat="server" /> <table style="width:100%"> <tr> <td> <div class="left_list"> <div class="inwelcome"> 仓库管理</div> </div> </td> </tr> <tr> <td style="text-align: left" mce_style="text-align: left"> <table> <tr><td> </td> <td> <asp:ImageButton ID="Image_add" ImageUrl="~/images/button_add.gif" runat="server" Style="cursor: hand;" mce_Style="cursor: hand;" onclick="Image_add_Click" Width="50px" /> </td> <td class="style1"> </td> <td width="100" align="right"> </td> <td > </td> <td width="100" align="right"> </td> <td style="height: 58px; text-align: left;"> </td> <td style="height: 58px; text-align: left;"> </td> <td style="height: 58px"> </td> </tr> </table> </td> </tr> <tr> <td> <asp:UpdatePanel ID="UpdatePanel1" runat="server" UpdateMode="Conditional"> <ContentTemplate> <table border="0" cellspacing="0" cellpadding="0" width="100%"> <tr> <td> <asp:GridView ID="gv_ordlist" runat="server" Width="100%" CellPadding="2" CssClass="gridview_title" AutoGenerateColumns="False" OnRowDataBound="gv_ordlist_RowDataBound" OnRowCommand="gv_ordlist_RowCommand"> <Columns> <asp:BoundField DataField="WAREHOUSE_NO" HeaderText="编号" /> <asp:BoundField DataField="WAREHOUSE_NAME" HeaderText="名称" /> <asp:TemplateField HeaderText="类型"> <ItemTemplate> <%# showType(int.Parse(Eval("TYPE").ToString()))%> </ItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="操作"> <ItemTemplate> <asp:LinkButton ID="lbUpdate" runat="server" CausesValidation="False" CommandArgument='<%# Eval("WAREHOUSE_NO") %>' CommandName="Up" meta:resourcekey="lbUpdateResource1" Text="<img src=../images/alter_button.gif border=0 alt=修改 "></asp:LinkButton> <asp:LinkButton ID="lbDelete" runat="server" CausesValidation="False" CommandArgument='<%# Eval("WAREHOUSE_NO") %>' CommandName="Del" meta:resourcekey="lbDeleteResource1" Text="<img src=../images/delete.gif border=0 alt=删除 onclick="JavaScript:return confirm('确认删除吗?')"/>"></asp:LinkButton> </ItemTemplate> </asp:TemplateField> </Columns> <HeaderStyle CssClass="gridview_header" /> <FooterStyle CssClass="gridview_footer" /> <RowStyle CssClass="gridview_row" /> <SelectedRowStyle CssClass="gridview_selectrow" /> <PagerStyle CssClass="gridview_page" /> <AlternatingRowStyle CssClass="gridview_alternatingrow" /> </asp:GridView> </td> </tr> <tr> <td align="center"> <uc1:PageControl ID="PageControl1" OnPagingIndexChange="PageControl1_PagingIndexChange" runat="server" PageSize="10" /> </td> </tr> </table> </ContentTemplate> </asp:UpdatePanel> </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 SH.Business; using SH.DataAccess.Table; using SH.Business.UI; using YG.DB; /// <summary> /// ZH 2010-8-12 18:04:06 /// /// </summary> public partial class Sys_LspWareHouse : System.Web.UI.Page { LspHouseCurd curd = new LspHouseCurd(); protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (!WEB.Login.isLogin(Page)) return; BingGrid();//绑定人员信息 } } private void BingGrid() { string filter = "1=1 order by WAREHOUSE_NO asc"; PageControl1.DataCount = curd.GetLspHouseInfoCount(filter); gv_ordlist.DataSource = curd.GetLspHouseInfoPage(filter, 0, PageControl1.PageSize); gv_ordlist.DataBind(); } protected void PageControl1_PagingIndexChange(object sender, PagingEventArgs e) { string filter = "1=1 order by WAREHOUSE_NO asc"; IList<LSP_WAREHOUSE> list = curd.GetLspHouseInfoPage(filter, e.StartRecord, e.EndRecord); gv_ordlist.DataSource = list; gv_ordlist.DataBind(); UpdatePanel1.Update(); } protected void gv_ordlist_RowDataBound(object sender, GridViewRowEventArgs e) { try { if (e.Row.RowType == DataControlRowType.Header) { e.Row.Attributes.Add("style", "background-image:url('../images/grid3-hrow.gif')"); } //首先判断是否是数据行 if (e.Row.RowType == DataControlRowType.DataRow) { //当鼠标停留时更改背景色 e.Row.Attributes.Add("onmouseover", "c=this.style.backgroundColor;this.style.backgroundColor='#F4FBFF'"); //当鼠标移开时还原背景色 e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=c"); e.Row.Attributes.Add("onclick", "this.style.backgroundColor='#e2eaf1'"); } } catch (Exception ex) { } } /// <summary> /// 前台显示仓库类型 /// </summary> /// <param name="id"></param> /// <returns></returns> protected string showType(int id) { string type = null; switch (id) { //0=非果蔬库，1=果蔬库 case 0: type = "非果蔬库"; break; case 1: type = "果蔬库"; break; default: break; } return type; } protected void gv_ordlist_RowCommand(object sender, GridViewCommandEventArgs e) { //删除 if (e.CommandName == "Del") { string filter = "WAREHOUSE_NO=" + e.CommandArgument.ToString(); bool result = curd.DeleteLspHouseInfo(filter); if (result) { BingGrid(); UpdatePanel1.Update(); ScriptManager.RegisterStartupScript(this, GetType(), "", "alert('删除成功');", true); } } //修改 if (e.CommandName == "Up") { Response.Redirect("LspHouseEdit.aspx?id=" + e.CommandArgument.ToString()); } } //搜索 protected void image_find_Click(object sender, ImageClickEventArgs e) { BingGrid(); UpdatePanel1.Update(); } //增加 protected void Image_add_Click(object sender, ImageClickEventArgs e) { Response.Redirect("LspHouseAdd.aspx"); } }