customermanage.ascx

CRM管理系统 CRM管理系统

<%@ Control Language="C#" AutoEventWireup="true" CodeFile="CustomerManage.ascx.cs" Inherits="CustomerManage_Ctrls_CustomerManage"%>
<%@ Register Assembly="AspNetPager" Namespace="Wuqi.Webdiyer" TagPrefix="webdiyer" %>
<table border="0" cellpadding="0" cellspacing="0" width="100%">
    <tr>
        <td align="left" style="width: 12%; color: blue">
            客户名称：</td>
        <td style="width: 8%">
            <asp:TextBox ID="txtComName" runat="server"></asp:TextBox></td>
        <td align="left" style="width: 12%; color: blue">
            关系程度：</td>
        <td style="width: 8%">
            <asp:DropDownList ID="ddlRelation" runat="server">
            </asp:DropDownList></td>
        <td align="left" style="width: 12%; color: blue">
            客户类型：</td>
        <td style="width: 8%">
            <asp:DropDownList ID="ddlComType" runat="server">
            </asp:DropDownList></td>
        <td align="left" style="width: 12%; color: blue">
            销售人员：</td>
        <td style="width: 8%">
            <asp:DropDownList ID="ddlTrack" runat="server">
            </asp:DropDownList></td>
        <td style="width: 20%">
            <asp:Button ID="ntnSelect" runat="server" OnClick="ntnSelect_Click" Text="查询" />
            <asp:Button ID="btnClear" runat="server" OnClick="btnClear_Click" Text="条件清空" Width="62px" /></td>
    </tr>
    <tr>
        <td colspan="9" style="height: 5px">
        </td>
    </tr>
    <tr>
        <td align="left" colspan="9" style="width: 99%" valign="top">
            <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True"
                AutoGenerateColumns="False" BackColor="White" BorderColor="#E7E7FF" BorderWidth="1px"
                CellPadding="3" DataKeyNames="code" OnPageIndexChanging="GridView1_PageIndexChanging"
                OnRowCommand="GridView1_RowCommand" OnRowDataBound="GridView1_RowDataBound" PageSize="15"
                Width="100%">
                <FooterStyle BackColor="#B5C7DE" ForeColor="#4A3C8C" />
                <RowStyle BackColor="#E7E7FF" Font-Size="12px" ForeColor="#4A3C8C" />
                <SelectedRowStyle BackColor="#E0E0E0" Font-Bold="True" ForeColor="Black" />
                <HeaderStyle BackColor="#4A3C8C" Font-Bold="True" ForeColor="#F7F7F7" Height="22px"
                    HorizontalAlign="Center" />
                <AlternatingRowStyle BackColor="#F7F7F7" />
                <Columns>
                    <asp:TemplateField HeaderText="客户编号" Visible="False">
                        <ItemStyle HorizontalAlign="Center" />
                        <HeaderStyle HorizontalAlign="Center" />
                        <ItemTemplate>
                            <asp:LinkButton ID="lbtnCode" runat="server" CommandName="lbtnCode" Text='<%# Bind("code") %>'></asp:LinkButton>
                        </ItemTemplate>
                    </asp:TemplateField>
                    <asp:TemplateField HeaderText="客户名称/联系人数量">
                        <ItemStyle HorizontalAlign="Left" />
                        <HeaderStyle HorizontalAlign="Left" />
                        <ItemTemplate>
                            <asp:LinkButton ID="lbtnName" runat="server" CommandName="lbtnName" Text='<%# Query1(Eval("name"),15) %>'></asp:LinkButton>
                            <asp:Label ID="lblPersonSum" runat="server" Text="(0)"></asp:Label>
                        </ItemTemplate>
                    </asp:TemplateField>
                    <asp:TemplateField HeaderText="关系程度">
                        <ItemStyle HorizontalAlign="Center" />
                        <HeaderStyle HorizontalAlign="Center" />
                        <ItemTemplate>
                            <asp:Label ID="lblRelation" runat="server" Text='<%# GetName(DataBinder.Eval(Container.DataItem, "relation")) %>'></asp:Label>
                        </ItemTemplate>
                    </asp:TemplateField>
                    <asp:TemplateField HeaderText="销售人员">
                        <ItemStyle HorizontalAlign="Center" />
                        <HeaderStyle HorizontalAlign="Center" />
                        <ItemTemplate>
                            <asp:Label ID="lblTrack" runat="server" Text='<%# GetUserName(DataBinder.Eval(Container.DataItem, "tracking_persen")) %>'></asp:Label>
                        </ItemTemplate>
                    </asp:TemplateField>
                    <asp:TemplateField HeaderText="客户类型">
                        <ItemStyle HorizontalAlign="Center" />
                        <HeaderStyle HorizontalAlign="Center" />
                        <ItemTemplate>
                            <asp:Label ID="lblComType" runat="server" Text='<%# GetName(DataBinder.Eval(Container.DataItem, "type")) %>'></asp:Label>
                        </ItemTemplate>
                    </asp:TemplateField>
                    <asp:BoundField DataField="tel" HeaderText="公司电话">
                        <ItemStyle HorizontalAlign="Center" />
                        <HeaderStyle HorizontalAlign="Center" />
                    </asp:BoundField>
                    <asp:BoundField DataField="email" HeaderText="邮件地址">
                        <ItemStyle HorizontalAlign="Center" />
                        <HeaderStyle HorizontalAlign="Center" />
                    </asp:BoundField>
                    <asp:TemplateField HeaderText="操作">
                        <ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" />
                        <ItemTemplate>
                            <asp:LinkButton ID="lbtnPersen" runat="server" CommandName="lbtnPersen">联系人</asp:LinkButton>
                            <asp:Label ID="Label2" runat="server" Text="|"></asp:Label>
                            <asp:LinkButton ID="lbtnEdit" runat="server" CommandName="lbtnEdit">编辑</asp:LinkButton>
                            <asp:Label ID="Label1" runat="server" Text="|"></asp:Label>
                            <asp:LinkButton ID="lbtnDelete" runat="server" CommandName="lbtnDelete">删除</asp:LinkButton>
                        </ItemTemplate>
                    </asp:TemplateField>
                </Columns>
                <PagerSettings Visible="False" />
            </asp:GridView>
        </td>
    </tr>
    <tr>
        <td align="center" colspan="9" style="width: 100%; height: 8px">
            <webdiyer:AspNetPager ID="pager" runat="server" BackColor="#F7F7F7" OnPageChanging="pager_PageChanging">
            </webdiyer:AspNetPager>
        </td>
    </tr>
    <tr>
        <td colspan="9" style="width: 100%; height: 2px">
        </td>
    </tr>
    <tr>
        <td align="center" colspan="9">
            <asp:Button ID="btnCsv" runat="server" OnClick="btnCsv_Click" Text="导出到EXCEL" Width="95px" />
            <asp:Button ID="btnAdd" runat="server" OnClick="btnAdd_Click" Text="增　加" Width="95px" /></td>
    </tr>
</table>