<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="IsAllowDelivery.aspx.cs" Inherits="ERP.Web.Finance.Agent.IsAllowDelivery" %> <%@ Register assembly="DevExpress.Web.v12.2, Version=12.2.8.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Data.Linq" tagprefix="dx" %> <!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <script type="text/javascript"> </script> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/> <title></title> </head> <body> <form id="form1" runat="server"> <div> <dx:ASPxButton ID="ASPxButton1" runat="server" OnClick="ASPxButton1_Click" Text="保存"> </dx:ASPxButton> </div> <div> <dx:ASPxGridView ID="ASPxGridView1" runat="server" AutoGenerateColumns="False" ClientInstanceName="grid1" DataSourceID="SqlDataSource1" KeyFieldName="代码" Width="266px" OnRowUpdating="ASPxGridView1_RowUpdating"> <clientsideevents rowclick="function(s, e) { grid1.StartEditRow(e.visibleIndex); }" /> <Columns> <dx:GridViewDataTextColumn FieldName="代码" ReadOnly="True" VisibleIndex="0" Width="80px"> <editcellstyle horizontalalign="Center"> </editcellstyle> <DataItemTemplate> <asp:Label id="Label4" runat="server" Text='<%# Eval("代码") %>' Width="50px" /> </DataItemTemplate> <EditItemTemplate> <asp:Label id="Label1" runat="server" Text='<%# Eval("代码") %>' Width="50px" /> </EditItemTemplate> <cellstyle horizontalalign="Center"> </cellstyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn FieldName="名称" ReadOnly="True" VisibleIndex="1" Width="80px"> <editcellstyle horizontalalign="Center"> </editcellstyle> <DataItemTemplate> <asp:Label id="Label2" runat="server" Text='<%# Eval("名称") %>' /> </DataItemTemplate> <EditItemTemplate> <asp:Label id="Label3" runat="server" Text='<%# Eval("名称") %>' /> </EditItemTemplate> <cellstyle horizontalalign="Center"> </cellstyle> </dx:GridViewDataTextColumn> <dx:GridViewDataCheckColumn FieldName="是否允许发货" VisibleIndex="2" Width="50px"> <editcellstyle horizontalalign="Center" verticalalign="Middle" wrap="True"> </editcellstyle> <editformcaptionstyle horizontalalign="Center"> </editformcaptionstyle> <EditItemTemplate> <dx:ASPxCheckBox ID="edits" runat="server" ClientInstanceName="edit" Checked='<%# Eval("是否允许发货") %>' > <clientsideevents checkedchanged="function(s, e) { grid1.UpdateEdit(); }" /> /dx:ASPxCheckBox> </EditItemTemplate> <cellstyle horizontalalign="Center" verticalalign="Middle" wrap="True"> </cellstyle> </dx:GridViewDataCheckColumn> </Columns> <settingsbehavior allowselectbyrowclick="True" /> <settingspager pagesize="20"> </settingspager> <settingsediting mode="Inline" /> </dx:ASPxGridView> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:cobosdConnectionString %>" DeleteCommand="DELETE FROM [xs_办事处档案] WHERE [代码] = @original_代码" InsertCommand="INSERT INTO [xs_办事处档案] ([代码], [名称], [是否允许发货]) VALUES (@代码, @名称, @是否允许发货)" OldValuesParameterFormatString="original_{0}" SelectCommand="SELECT [代码], [名称], [是否允许发货] FROM [xs_办事处档案]" UpdateCommand="UPDATE [xs_办事处档案] SET [名称] = @名称, [是否允许发货] = @是否允许发货 WHERE [代码] = @original_代码"> <DeleteParameters> <asp:Parameter Name="original_代码" Type="String" /> </DeleteParameters> <InsertParameters> <asp:Parameter Name="代码" Type="String" /> <asp:Parameter Name="名称" Type="String" /> <asp:Parameter Name="是否允许发货" Type="Boolean" /> </InsertParameters> <UpdateParameters> <asp:Parameter Name="名称" Type="String" /> <asp:Parameter Name="是否允许发货" Type="Boolean" /> <asp:Parameter Name="original_代码" Type="String" /> </UpdateParameters> </asp:SqlDataSource> </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 DevExpress.Web.ASPxEditors; using DevExpress.Web.ASPxGridView; namespace ERP.Web.Finance.Agent { public partial class IsAllowDelivery : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { } protected void ASPxButton1_Click(object sender, EventArgs e) { ASPxGridView1.UpdateEdit(); } protected void CheckBox1_CheckedChanged(object sender, EventArgs e) { ASPxGridView1.UpdateEdit(); } protected void edit_CheckedChanged(object sender, EventArgs e) { } protected void ASPxGridView1_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e) { ASPxCheckBox ck = (ASPxCheckBox)ASPxGridView1.FindEditRowCellTemplateControl((GridViewDataColumn)ASPxGridView1.Columns["是否允许发货"], "edits"); e.NewValues["是否允许发货"] = ck.Checked; } } }