<%@ 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>