基于Grove的在GridView上的增删改查

来源：互联网发布：淘宝头像图片大全编辑：程序博客网时间：2024/05/26 22:57

前台页面

<%@ 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"); }}