aspxgridview 新增 修改 删除

<%@ Page Title="销售机会看板--公司销售机会看板" Language="C#" MasterPageFile="~/MasterPage.master"
    AutoEventWireup="true" CodeFile="IntentionBoardForCompany.aspx.cs" Inherits="WorkReport_IntentionBoardForCompany" %>

<%@ Register Assembly="DevExpress.Web.v10.2, Version=10.2.8.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a"
    Namespace="DevExpress.Web.ASPxCallbackPanel" TagPrefix="dx" %>
<%@ Register Assembly="DevExpress.Web.ASPxGridView.v10.2, Version=10.2.8.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a"
    Namespace="DevExpress.Web.ASPxGridView" TagPrefix="dx" %>
<%@ Register Assembly="DevExpress.Web.ASPxEditors.v10.2, Version=10.2.8.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a"
    Namespace="DevExpress.Web.ASPxEditors" TagPrefix="dx" %>
<%@ Register Assembly="DevExpress.Web.v10.2, Version=10.2.8.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a"
    Namespace="DevExpress.Web.ASPxMenu" TagPrefix="dx" %>
<%@ Register Assembly="DevExpress.Web.ASPxGridView.v10.2.Export, Version=10.2.8.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a"
    Namespace="DevExpress.Web.ASPxGridView.Export" TagPrefix="dx" %>
<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="Server">
    <link rel="stylesheet" type="text/css" href="../Css/moban_1column.css" />
    <script type="text/javascript">
        function CustomButtonConfirm(e) {
            if (e.buttonID == 'buttonZJGX') {
                if (confirm('确定要执行该操作吗?')) {
                    e.processOnServer = true;
                }
            }
            else {
                e.processOnServer = true;
            }
        }
    </script>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="Server">
    <!--mainbox-->
    <div id="mainbox">
        <div id="mainbox_t">
            <span>销售机会</span></div>
        <!--mainbox_c-->
        <div id="mainbox_c">
            <!--columntit-->
            <div id="columntit">
                <span>公司销售机会看板</span>
            </div>
            <!--columntit end-->
            <!--search-->
            <!--search end-->
            <div class="cl">
            </div>
            <!--column-->
            <div class="column">
                <!--columntit2-->
                <table cellpadding="0" cellspacing="0" class="columntable">
                    <tr>
                        <th width="100%">
                            未处理意向总数
                        </th>
                    </tr>
                    <tr>
                        <td>
                            <span>
                                <asp:HyperLink ID="HyperLinkDTX" Target="_self" runat="server" NavigateUrl="~/WorkReport/IntentionBoardForPersonalDelete.aspx">0</asp:HyperLink></span>
                            <asp:Button ID="ButtonDTXexcel" CssClass="excel" runat="server" Text="" BorderStyle="None"
                                OnClick="ButtonDTXexcel_Click" />
                        </td>
                    </tr>
                </table>
                <div class="columntit2">
                    <span>本次购机意向 </span>
                </div>
                <asp:UpdatePanel ID="UpdatePanelSelect" runat="server">
                    <ContentTemplate>
                        <dx:ASPxGridViewExporter ID="ASPxGridViewExporter1" GridViewID="ASPxGridViewIntentionInfo"
                            runat="server">
                        </dx:ASPxGridViewExporter>
                        <div style="overflow: auto; width: 100%;">
                            <dx:ASPxGridView ID="ASPxGridViewIntentionInfo" DataSourceID="SqlDataSourceIntentionInfo"
                                runat="server" KeyFieldName="XH" AutoGenerateColumns="False" CssFilePath="~/App_Themes/Aqua/{0}/styles.css"
                                CssPostfix="Aqua" Width="100%" ClientIDMode="AutoID">
                                <Columns>
                                    <dx:GridViewDataTextColumn Caption="序号" FieldName="XH" VisibleIndex="0">
                                    </dx:GridViewDataTextColumn>
                                    <dx:GridViewDataTextColumn Caption="客户名称" FieldName="KHXM" VisibleIndex="1">
                                        <Settings AllowSort="True" FilterMode="DisplayText" SortMode="DisplayText" />
                                        <EditFormSettings Visible="False" />
                                        <EditFormSettings Visible="False" />
                                    </dx:GridViewDataTextColumn>
                                    <dx:GridViewDataTextColumn Caption="所属销售单位" FieldName="SSGSMC" VisibleIndex="1">
                                        <Settings AllowSort="True" FilterMode="DisplayText" SortMode="DisplayText" />
                                        <EditFormSettings Visible="False" />
                                        <EditFormSettings Visible="False" />
                                    </dx:GridViewDataTextColumn>
                                    <dx:GridViewDataTextColumn Caption="所属用户" FieldName="SSYHMC" VisibleIndex="1">
                                        <Settings AllowSort="True" FilterMode="DisplayText" SortMode="DisplayText" />
                                        <EditFormSettings Visible="False" />
                                    </dx:GridViewDataTextColumn>
                                    <dx:GridViewDataComboBoxColumn Caption="产品名称" UnboundExpression="产品名称" FieldName="CPMCBH"
                                        VisibleIndex="1">
                                        <PropertiesComboBox DataSourceID="SqlDataSourceCPMCInfo" TextField="NODENAME" ValueField="NODEID"
                                            ValueType="System.String" Width="180px">
                                            <ValidationSettings>
                                                <RequiredField IsRequired="True" />
                                            </ValidationSettings>
                                        </PropertiesComboBox>
                                    </dx:GridViewDataComboBoxColumn>
                                    <dx:GridViewDataComboBoxColumn Caption="产品品牌" UnboundExpression="产品品牌" FieldName="CPPPBH"
                                        VisibleIndex="2">
                                        <PropertiesComboBox DataSourceID="SqlDataSourceCPPPInfo" TextField="NODENAME" ValueField="NODEID"
                                            ValueType="System.String" Width="180px">
                                            <ValidationSettings>
                                                <RequiredField IsRequired="True" />
                                            </ValidationSettings>
                                        </PropertiesComboBox>
                                    </dx:GridViewDataComboBoxColumn>
                                    <dx:GridViewDataComboBoxColumn Caption="产品型号" UnboundExpression="产品型号" FieldName="CPXHBH"
                                        VisibleIndex="3">
                                        <PropertiesComboBox DataSourceID="SqlDataSourceCPXHInfo" TextField="NODENAME" ValueField="NODEID"
                                            ValueType="System.String" Width="180px">
                                            <ValidationSettings>
                                                <RequiredField IsRequired="True" />
                                            </ValidationSettings>
                                        </PropertiesComboBox>
                                    </dx:GridViewDataComboBoxColumn>
                                    <dx:GridViewDataComboBoxColumn Caption="产品类型" UnboundExpression="产品类型" FieldName="CPLXBH"
                                        VisibleIndex="3">
                                        <PropertiesComboBox DataSourceID="SqlDataSourceCPLXInfo" TextField="NODENAME" ValueField="NODEID"
                                            ValueType="System.String" Width="180px">
                                            <ValidationSettings>
                                                <RequiredField IsRequired="True" />
                                            </ValidationSettings>
                                        </PropertiesComboBox>
                                    </dx:GridViewDataComboBoxColumn>
                                    <dx:GridViewDataComboBoxColumn Caption="竞品品牌" UnboundExpression="JPPPMC" FieldName="JPPPBH"
                                        VisibleIndex="4">
                                        <PropertiesComboBox DataSourceID="SqlDataSourceJPPPInfo" TextField="NODENAME" ValueField="NODEID"
                                            ValueType="System.String" Width="180px">
                                        </PropertiesComboBox>
                                    </dx:GridViewDataComboBoxColumn>
                                    <dx:GridViewDataComboBoxColumn Caption="竟品名称" UnboundExpression="竟品名称" FieldName="JPMCBH"
                                        VisibleIndex="4">
                                        <PropertiesComboBox DataSourceID="SqlDataSourceJPMCInfo" TextField="NODENAME" ValueField="NODEID"
                                            ValueType="System.String" Width="180px">
                                        </PropertiesComboBox>
                                    </dx:GridViewDataComboBoxColumn>
                                    <dx:GridViewDataTextColumn Caption="销售难点" FieldName="ND" VisibleIndex="4">
                                    </dx:GridViewDataTextColumn>
                                    <dx:GridViewDataComboBoxColumn Caption="意向状态" FieldName="YXZT" VisibleIndex="5">
                                        <PropertiesComboBox ValueType="System.String" Width="180px">
                                            <Items>
                                                <dx:ListEditItem Text="分析需求" Value="01" />
                                                <dx:ListEditItem Text="方案报价" Value="02" />
                                                <dx:ListEditItem Text="谈判" Value="03" />
                                                <dx:ListEditItem Text="承诺" Value="04" />
                                                <dx:ListEditItem Text="结束" Value="05" />
                                            </Items>
                                            <ValidationSettings>
                                                <RequiredField IsRequired="True" />
                                            </ValidationSettings>
                                        </PropertiesComboBox>
                                    </dx:GridViewDataComboBoxColumn>
                                    <dx:GridViewDataTextColumn Caption="产品单价" FieldName="CPDJ" VisibleIndex="6">
                                    </dx:GridViewDataTextColumn>
                                    <dx:GridViewDataTextColumn Caption="购买方式" FieldName="GMFS" VisibleIndex="6">
                                    </dx:GridViewDataTextColumn>
                                    <dx:GridViewDataTextColumn Caption="购买数量" FieldName="GMSL" VisibleIndex="9">
                                    </dx:GridViewDataTextColumn>
                                    <dx:GridViewDataTextColumn Caption="总价" FieldName="CPZJ" VisibleIndex="9" ReadOnly="True">
                                        <EditFormSettings Visible="False" />
                                    </dx:GridViewDataTextColumn>
                                    <dx:GridViewDataDateColumn Caption="预计购买日期" FieldName="YJGMSJ" ShowInCustomizationForm="True"
                                        VisibleIndex="10">
                                        <PropertiesDateEdit DisplayFormatString="{0:d}">
                                            <ValidationSettings>
                                                <RequiredField IsRequired="True" />
                                            </ValidationSettings>
                                        </PropertiesDateEdit>
                                    </dx:GridViewDataDateColumn>
                                    <dx:GridViewDataTextColumn Caption="更新时间" FieldName="GXSJ" VisibleIndex="12">
                                        <EditFormSettings Visible="False"></EditFormSettings>
                                    </dx:GridViewDataTextColumn>
                                    <dx:GridViewCommandColumn Caption="操作" VisibleIndex="13">
                                        <EditButton Text="编辑" Visible="True">
                                        </EditButton>
                                        <NewButton Text="新建">
                                        </NewButton>
                                        <DeleteButton Text="删除">
                                        </DeleteButton>
                                        <CancelButton Text="取消">
                                        </CancelButton>
                                        <UpdateButton Text="提交">
                                        </UpdateButton>
                                    </dx:GridViewCommandColumn>
                                </Columns>
                                <SettingsBehavior AllowDragDrop="False" AllowSort="False" ConfirmDelete="True"></SettingsBehavior>
                                <SettingsPager PageSize="15">
                                </SettingsPager>
                                <Settings ShowHorizontalScrollBar="True" />
                                <SettingsText ConfirmDelete="确定要删除吗?"></SettingsText>
                                <SettingsLoadingPanel ImagePosition="Top"></SettingsLoadingPanel>
                                <Images SpriteCssFilePath="~/App_Themes/Aqua/{0}/sprite.css">
                                    <LoadingPanelOnStatusBar Url="~/App_Themes/Aqua/GridView/gvLoadingOnStatusBar.gif">
                                    </LoadingPanelOnStatusBar>
                                    <LoadingPanel Url="~/App_Themes/Aqua/GridView/Loading.gif">
                                    </LoadingPanel>
                                </Images>
                                <ImagesEditors>
                                    <DropDownEditDropDown>
                                        <SpriteProperties HottrackedCssClass="dxEditors_edtDropDownHover_Aqua" PressedCssClass="dxEditors_edtDropDownPressed_Aqua">
                                        </SpriteProperties>
                                    </DropDownEditDropDown>
                                    <SpinEditIncrement>
                                        <SpriteProperties HottrackedCssClass="dxEditors_edtSpinEditIncrementImageHover_Aqua"
                                            PressedCssClass="dxEditors_edtSpinEditIncrementImagePressed_Aqua"></SpriteProperties>
                                    </SpinEditIncrement>
                                    <SpinEditDecrement>
                                        <SpriteProperties HottrackedCssClass="dxEditors_edtSpinEditDecrementImageHover_Aqua"
                                            PressedCssClass="dxEditors_edtSpinEditDecrementImagePressed_Aqua"></SpriteProperties>
                                    </SpinEditDecrement>
                                    <SpinEditLargeIncrement>
                                        <SpriteProperties HottrackedCssClass="dxEditors_edtSpinEditLargeIncImageHover_Aqua"
                                            PressedCssClass="dxEditors_edtSpinEditLargeIncImagePressed_Aqua"></SpriteProperties>
                                    </SpinEditLargeIncrement>
                                    <SpinEditLargeDecrement>
                                        <SpriteProperties HottrackedCssClass="dxEditors_edtSpinEditLargeDecImageHover_Aqua"
                                            PressedCssClass="dxEditors_edtSpinEditLargeDecImagePressed_Aqua"></SpriteProperties>
                                    </SpinEditLargeDecrement>
                                </ImagesEditors>
                                <ImagesFilterControl>
                                    <LoadingPanel Url="~/App_Themes/Aqua/Editors/Loading.gif">
                                    </LoadingPanel>
                                </ImagesFilterControl>
                                <Styles CssFilePath="~/App_Themes/Aqua/{0}/styles.css" CssPostfix="Aqua">
                                    <Header HorizontalAlign="Center">
                                    </Header>
                                    <Cell HorizontalAlign="Center">
                                    </Cell>
                                    <LoadingPanel ImageSpacing="8px">
                                    </LoadingPanel>
                                </Styles>
                                <StylesEditors>
                                    <CalendarHeader Spacing="1px">
                                    </CalendarHeader>
                                    <ProgressBar Height="25px">
                                    </ProgressBar>
                                </StylesEditors>
                            </dx:ASPxGridView>
                            <asp:SqlDataSource ID="SqlDataSourceIntentionInfo" runat="server" ConnectionString="<%$ ConnectionStrings:CMSPMSDBConnectionString %>"
                                ProviderName="<%$ ConnectionStrings:CMSPMSDBConnectionString.ProviderName %>"
                                SelectCommand="PKG_CustomerInfo.P_QueryCustomerIntentionList" SelectCommandType="StoredProcedure"
                                OnSelecting="SqlDataSourceIntentionInfo_Selecting" UpdateCommand="PKG_CustomerInfo.P_EditCustomerIntentionInfo"
                                UpdateCommandType="StoredProcedure" OnUpdating="SqlDataSourceIntentionInfo_Updating"
                                DeleteCommand="PKG_CustomerInfo.P_DelCustomerIntentionInfo" DeleteCommandType="StoredProcedure"
                                OnDeleting="SqlDataSourceIntentionInfo_Deleting">
                                <SelectParameters>
                                    <asp:Parameter Name="v_yhbh" />
                                    <asp:Parameter Name="v_khxm" />
                                    <asp:Parameter Name="v_ssgsbh" />
                                    <asp:Parameter Name="v_cpmcbh" />
                                    <asp:Parameter Name="v_cpppbh" />
                                    <asp:Parameter Name="v_cplxbh" />
                                    <asp:Parameter Name="v_cpxhbh" />
                                    <asp:Parameter Name="v_jpppbh" />
                                    <asp:Parameter Name="v_jpmcbh" />
                                    <asp:Parameter Name="v_yxzt" />
                                    <asp:Parameter Name="v_cxlx" />
                                </SelectParameters>
                                <UpdateParameters>
                                    <asp:Parameter Name="v_xh" />
                                    <asp:Parameter Name="v_khbh" />
                                    <asp:Parameter Name="CPMCBH" />
                                    <asp:Parameter Name="CPPPBH" />
                                    <asp:Parameter Name="CPLXBH" />
                                    <asp:Parameter Name="CPXHBH" />
                                    <asp:Parameter Name="JPPPBH" />
                                    <asp:Parameter Name="JPMCBH" />
                                    <asp:Parameter Name="ND" />
                                    <asp:Parameter Name="YXZT" />
                                    <asp:Parameter Name="CPDJ" />
                                    <asp:Parameter Name="GMFS" />
                                    <asp:Parameter Name="GMSL" />
                                    <asp:Parameter Name="CPZJ" />
                                    <asp:Parameter Name="YJGMSJ" />
                                    <asp:Parameter Name="v_czr" />
                                </UpdateParameters>
                                <DeleteParameters>
                                    <asp:Parameter Name="v_xh" />
                                    <asp:Parameter Name="v_khbh" />
                                    <asp:Parameter Name="v_czr" />
                                </DeleteParameters>
                            </asp:SqlDataSource>
                            <asp:SqlDataSource ID="SqlDataSourceCPMCInfo" runat="server" ConnectionString="<%$ ConnectionStrings:CMSPMSDBConnectionString %>"
                                ProviderName="<%$ ConnectionStrings:CMSPMSDBConnectionString.ProviderName %>"
                                SelectCommand="PKG_MenuHelper.P_QueryTreeInfo" SelectCommandType="StoredProcedure"
                                OnSelecting="SqlDataSourceCPMCInfo_Selecting">
                                <SelectParameters>
                                    <asp:Parameter Name="v_gsbh" />
                                    <asp:Parameter Name="v_tablename" />
                                </SelectParameters>
                            </asp:SqlDataSource>
                            <asp:SqlDataSource ID="SqlDataSourceCPPPInfo" runat="server" ConnectionString="<%$ ConnectionStrings:CMSPMSDBConnectionString %>"
                                ProviderName="<%$ ConnectionStrings:CMSPMSDBConnectionString.ProviderName %>"
                                SelectCommand="PKG_MenuHelper.P_QueryTreeInfo" SelectCommandType="StoredProcedure"
                                OnSelecting="SqlDataSourceCPPPInfo_Selecting">
                                <SelectParameters>
                                    <asp:Parameter Name="v_gsbh" />
                                    <asp:Parameter Name="v_tablename" />
                                </SelectParameters>
                            </asp:SqlDataSource>
                            <asp:SqlDataSource ID="SqlDataSourceCPLXInfo" runat="server" ConnectionString="<%$ ConnectionStrings:CMSPMSDBConnectionString %>"
                                ProviderName="<%$ ConnectionStrings:CMSPMSDBConnectionString.ProviderName %>"
                                SelectCommand="PKG_MenuHelper.P_QueryTreeInfo" SelectCommandType="StoredProcedure"
                                OnSelecting="SqlDataSourceCPLXInfo_Selecting">
                                <SelectParameters>
                                    <asp:Parameter Name="v_gsbh" />
                                    <asp:Parameter Name="v_tablename" />
                                </SelectParameters>
                            </asp:SqlDataSource>
                            <asp:SqlDataSource ID="SqlDataSourceCPXHInfo" runat="server" ConnectionString="<%$ ConnectionStrings:CMSPMSDBConnectionString %>"
                                ProviderName="<%$ ConnectionStrings:CMSPMSDBConnectionString.ProviderName %>"
                                SelectCommand="PKG_MenuHelper.P_QueryTreeInfo" SelectCommandType="StoredProcedure"
                                OnSelecting="SqlDataSourceCPXHInfo_Selecting">
                                <SelectParameters>
                                    <asp:Parameter Name="v_gsbh" />
                                    <asp:Parameter Name="v_tablename" />
                                </SelectParameters>
                            </asp:SqlDataSource>
                            <asp:SqlDataSource ID="SqlDataSourceJPPPInfo" runat="server" ConnectionString="<%$ ConnectionStrings:CMSPMSDBConnectionString %>"
                                ProviderName="<%$ ConnectionStrings:CMSPMSDBConnectionString.ProviderName %>"
                                SelectCommand="PKG_MenuHelper.P_QueryTreeInfo" SelectCommandType="StoredProcedure"
                                OnSelecting="SqlDataSourceJPPPInfo_Selecting">
                                <SelectParameters>
                                    <asp:Parameter Name="v_gsbh" />
                                    <asp:Parameter Name="v_tablename" />
                                </SelectParameters>
                            </asp:SqlDataSource>
                            <asp:SqlDataSource ID="SqlDataSourceJPMCInfo" runat="server" ConnectionString="<%$ ConnectionStrings:CMSPMSDBConnectionString %>"
                                ProviderName="<%$ ConnectionStrings:CMSPMSDBConnectionString.ProviderName %>"
                                SelectCommand="PKG_MenuHelper.P_QueryTreeInfo" SelectCommandType="StoredProcedure"
                                OnSelecting="SqlDataSourceJPMCInfo_Selecting">
                                <SelectParameters>
                                    <asp:Parameter Name="v_gsbh" />
                                    <asp:Parameter Name="v_tablename" />
                                </SelectParameters>
                            </asp:SqlDataSource>
                        </div>
                        <asp:UpdateProgress ID="UpdateProgress1" runat="server" DisplayAfter="0">
                            <ProgressTemplate>
                                <asp:Image ID="UpdateProgressImage" runat="server" ImageUrl="~/images/loading.gif"
                                    Style="position: absolute; left: 50%; top: 80%;" />
                            </ProgressTemplate>
                        </asp:UpdateProgress>
                    </ContentTemplate>
                    <Triggers>
                    </Triggers>
                </asp:UpdatePanel>
                <!--columntable end-->
            </div>
            <!--column end-->
        </div>
        <!--mainbox_c end-->
    </div>
    <!--mainbox end-->
</asp:Content>