用例注册

username@email.com

2021-09-15 8599ec3bfa6d2fc9768403f59a0e7102758bc14d

用例注册

业务管理--订单管理--批量操作--打印送货单--case_ToBatchPrintAwbOrder

菜单管理
销售绩效--销售绩效--业务报表--/Pages/business/xiaoshouyejiReportList.aspx

[RoleName] = 88b49967-d590-452c-93c6-0049a75fa5ff

 [RoleId] ='27'

 CY_ECommercePlatform/CY.BLL/EC/EC_OrderBLL.cs

@@ -339,5 +339,15 @@
        {
            return _iEC_OrderDAL.GetxiaoshouyejiList(pagination, FirmId, BusinessManagerId, chaxuntime);
        }


        /// <summary>
        /// 获取业绩查询
        /// </summary>
        /// <returns></returns>
        public IEnumerable<OA_DeliverPlan> GetyewurenportList(Infrastructure.Query.Pagination pagination, Guid FirmId, string BusinessManagerId, string chaxuntimestart, string chaxuntimeend)
        {
            return _iEC_OrderDAL.GetyewurenportList(pagination, FirmId, BusinessManagerId, chaxuntimestart, chaxuntimeend);
        }
    }
}

 CY_ECommercePlatform/CY.IDAL/EC/IEC_OrderDAL.cs

@@ -178,5 +178,7 @@


        IEnumerable<OA_DeliverPlan> GetxiaoshouyejiList(Infrastructure.Query.Pagination pagination, Guid FirmId, string BusinessManagerId, string chaxuntime);

        IEnumerable<OA_DeliverPlan> GetyewurenportList(Infrastructure.Query.Pagination pagination, Guid FirmId, string BusinessManagerId, string chaxuntimestart, string chaxuntimeend);
    }
}

 CY_ECommercePlatform/CY.Model/OA/OA_DeliverPlan.cs

@@ -271,6 +271,42 @@
        }

        /// <summary>
        /// 修改时间
        /// </summary>
        public DateTime? chaxuntimestart
        {
            get;
            set;
        }

        /// <summary>
        /// 修改时间
        /// </summary>
        public DateTime? chaxuntimeend
        {
            get;
            set;
        }

        /// <summary>
        /// 回款客户
        /// </summary>
        public decimal? huikuankehu
        {
            get;
            set;
        }

        /// <summary>
        /// 未回款客户
        /// </summary>
        public decimal? weihuikuankehu
        {
            get;
            set;
        }

        /// <summary>
        /// 未付款
        /// </summary>
        public decimal UnPayedMoney
@@ -654,9 +690,27 @@
                this.chaxuntime = isChange ? MyConvert.ConvertToDateTime(value) : chaxuntime;
                theValue = this.chaxuntime;
            }
            else if ("chaxuntimestart".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 49)
            {
                this.chaxuntimestart = isChange ? MyConvert.ConvertToDateTime(value) : chaxuntimestart;
                theValue = this.chaxuntimestart;
            }
            else if ("chaxuntimeend".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 50)
            {
                this.chaxuntimeend = isChange ? MyConvert.ConvertToDateTime(value) : chaxuntimeend;
                theValue = this.chaxuntimeend;
            }
            else if ("huikuankehu".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 51)
            {
                this.huikuankehu = isChange ? MyConvert.ConvertToDecimal(value) : huikuankehu;
                theValue = this.huikuankehu;
            }
            else if ("weihuikuankehu".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 52)
            {
                this.weihuikuankehu = isChange ? MyConvert.ConvertToDecimal(value) : weihuikuankehu;
                theValue = this.weihuikuankehu;
            }


            




 CY_ECommercePlatform/CY.SQLDAL/EC/EC_OrderDAL.cs

@@ -1369,5 +1369,75 @@
            return null == result ? null : result;//返回结果
        }



        /// <summary>
        /// 获取业务经理业绩
        /// </summary>
        /// <returns></returns>

        public IEnumerable<OA_DeliverPlan> GetyewurenportList(Infrastructure.Query.Pagination pagination, Guid FirmId, string BusinessManagerId,  string chaxuntimestart, string chaxuntimeend)
        {
            string selectTarget = " t.* ";
            string where = " and  os.[FirmId] ='" + FirmId + "'";

            if (!string.IsNullOrEmpty(BusinessManagerId))
            {
                where += " and os.Keyid='" + BusinessManagerId + "'";
            }

            string fromSouce = "(  ";

            fromSouce += "   select os.DepartmentId,os.[Name] as BusinessManager ,os.[Keyid] as BusinessManagerId, os.FirmId,gendan.gendanshuliang,xinzeng.xinzengshuliang,wanjie.wanjieshuliang,xiadan.xiadanshuliang,ob.shuliang,ob.SumPrice,ob.PayedMoney,eob.kaipiaojine,huifang.huifangshuliang ,'" + chaxuntimestart + "' as chaxuntimestart  ,'" + chaxuntimeend + "' as chaxuntimeend ,obhuikuan.huikuankehu,obweihuikuan.weihuikuankehu ";
            fromSouce += "  from [OA_Staff] os    ";
            fromSouce += "  left join  (  select  COUNT(*) gendanshuliang ,oc.BusinessManagerId from OA_CorporateClients oc   where ( oc.Shifouwanjie is null or oc.Shifouwanjie=2  ) and     DATEDIFF(DAY,oc.CreateTime,'" + chaxuntimestart + "') <=0 and     DATEDIFF(DAY,oc.CreateTime,'" + chaxuntimeend + "') >=0  group by oc.BusinessManagerId   ) gendan on gendan.BusinessManagerId = os.Keyid  ";
            fromSouce += "    left join  (  select  COUNT(*) xinzengshuliang ,oc.BusinessManagerId from OA_CorporateClients oc where  DATEDIFF(DAY,oc.CreateTime,'" + chaxuntimestart + "') <=0 and  DATEDIFF(DAY,oc.CreateTime,'" + chaxuntimeend + "') >=0 group by oc.BusinessManagerId   ) xinzeng on xinzeng.BusinessManagerId = os.Keyid ";
            fromSouce += "    left join  (  select  COUNT(*) wanjieshuliang ,oc.BusinessManagerId from OA_CorporateClients oc where  oc.Shifouwanjie=1 and   DATEDIFF(DAY,oc.[LastUpdateTime],'" + chaxuntimestart + "') <=0 and   DATEDIFF(DAY,oc.[LastUpdateTime],'" + chaxuntimeend + "') >=0  group by oc.BusinessManagerId   ) wanjie on wanjie.BusinessManagerId = os.Keyid  ";
            fromSouce += "   left join  (  select COUNT( distinct oc.Keyid)  xiadanshuliang ,oc.BusinessManagerId from OA_CorporateClients oc  Inner Join EC_OrderBasic ob On oc.Keyid=ob.[BuyerId]  where DATEDIFF(DAY,ob.CreateTime,'" + chaxuntimestart + "') <=0 and  DATEDIFF(DAY,ob.CreateTime,'" + chaxuntimeend + "') >=0   group by oc.BusinessManagerId   ) xiadan on xiadan.BusinessManagerId = os.Keyid  ";
            fromSouce += "   left join ( select  COUNT(*)  huifangshuliang,occ.Creater as BusinessManagerId  from  OA_CorporateClientsVisit occ   where DATEDIFF(DAY,occ.[VisitTime],'" + chaxuntimestart + "') <=0 and DATEDIFF(DAY,occ.[VisitTime],'" + chaxuntimeend + "') >=0  group by occ.Creater  ) huifang on huifang.BusinessManagerId = os.MemberId ";
            fromSouce += "  left join ( select  oc.BusinessManagerId,sum(ob.SumPrice) SumPrice,sum(ts.PayedMoney)  PayedMoney ,COUNT(*) as shuliang  ";
            fromSouce += "  from EC_OrderBasic ob   ";
            fromSouce += "  Inner Join EC_OrderExtend as oe On(ob.Keyid=oe.Keyid)   ";
            fromSouce += "  Inner Join Pay_TradingSingle as ts On(ob.Keyid = ts.OrderId)  ";
            fromSouce += "  Inner Join OA_CorporateClients as oc On(ob.BuyerId = oc.Keyid)  ";
            fromSouce += "  left join EC_AwbInfo ea  on ob.Keyid = ea.Keyid    where DATEDIFF(DAY,ob.CreateTime,'" + chaxuntimestart + "') <=0  and  DATEDIFF(DAY,ob.CreateTime,'" + chaxuntimeend + "') >=0  ";
            fromSouce += "  group by  oc.BusinessManagerId ) ob  on os.Keyid = ob.BusinessManagerId  ";

            fromSouce += "  left join ( select  oc.BusinessManagerId ,COUNT( distinct ob.BuyerId ) as huikuankehu  ";
            fromSouce += "  from EC_OrderBasic ob   ";
            fromSouce += "  Inner Join EC_OrderExtend as oe On(ob.Keyid=oe.Keyid)   ";
            fromSouce += "  Inner Join Pay_TradingSingle as ts On(ob.Keyid = ts.OrderId)  ";
            fromSouce += "  Inner Join OA_CorporateClients as oc On(ob.BuyerId = oc.Keyid)  ";
            fromSouce += "  left join EC_AwbInfo ea  on ob.Keyid = ea.Keyid    where DATEDIFF(DAY,ob.CreateTime,'" + chaxuntimestart + "') <=0  and  DATEDIFF(DAY,ob.CreateTime,'" + chaxuntimeend + "') >=0   and ob.PayState = -1 ";
            fromSouce += "  group by  oc.BusinessManagerId ) obhuikuan  on os.Keyid = ob.BusinessManagerId  ";


            fromSouce += "  left join ( select  oc.BusinessManagerId ,COUNT( distinct ob.BuyerId ) as weihuikuankehu  ";
            fromSouce += "  from EC_OrderBasic ob   ";
            fromSouce += "  Inner Join EC_OrderExtend as oe On(ob.Keyid=oe.Keyid)   ";
            fromSouce += "  Inner Join Pay_TradingSingle as ts On(ob.Keyid = ts.OrderId)  ";
            fromSouce += "  Inner Join OA_CorporateClients as oc On(ob.BuyerId = oc.Keyid)  ";
            fromSouce += "  left join EC_AwbInfo ea  on ob.Keyid = ea.Keyid    where DATEDIFF(DAY,ob.CreateTime,'" + chaxuntimestart + "') <=0  and  DATEDIFF(DAY,ob.CreateTime,'" + chaxuntimeend + "') >=0   and ob.PayState != -1 ";
            fromSouce += "  group by  oc.BusinessManagerId ) obweihuikuan  on os.Keyid = ob.BusinessManagerId  ";


            fromSouce += " left join ( select  oc.BusinessManagerId,sum(ob.SumPrice) kaipiaojine    ";
            fromSouce += "  from EC_OrderBasic ob   ";
            fromSouce += "   Inner Join EC_OrderExtend as oe On(ob.Keyid=oe.Keyid)   ";
            fromSouce += "  Inner Join OA_CorporateClients as oc On(ob.BuyerId = oc.Keyid)  ";
            fromSouce += "  left join EC_AwbInfo ea  on ob.Keyid = ea.Keyid  ";
            fromSouce += "  left join OA_Kaipiaoshenqing  ks  on ks.Keyid = oe.KaipiaoshenqingId  ";
            fromSouce += " where ks.Kaipiaoshenqing = 3   and DATEDIFF(DAY,ob.CreateTime,'" + chaxuntimestart + "') <=0   and DATEDIFF(DAY,ob.CreateTime,'" + chaxuntimeend + "') >=0  ";
            fromSouce += "  group by  oc.BusinessManagerId ) eob  on os.Keyid = eob.BusinessManagerId ";
            fromSouce += "   where os.Status='在职'  And IsBusinessManager='true'       " + where;


            fromSouce += " )as t   ";

            var result = _dataBase.SelectModelPage<Model.OA_DeliverPlan>(pagination, selectTarget, fromSouce, "  DepartmentId ASC");//执行查询
            return null == result ? null : result;//返回结果
        }
        

    }
}

 CY_ECommercePlatform/CY.WebForm/CY.WebForm.csproj

@@ -1973,6 +1973,9 @@
    <Content Include="Pages\business\xiaoshouyejiKehu.aspx" />
    <Content Include="Pages\business\xiaoshouyejiList.aspx" />
    <Content Include="Pages\business\xiaoshouyejiPrint.aspx" />
    <Content Include="Pages\business\xiaoshouyejiReportList.aspx" />
    <Content Include="Pages\business\xiaoshouyejiReportPrint.aspx" />
    <Content Include="Pages\business\xiaoshouyejiReprotKehu.aspx" />
    <Content Include="Pages\business\xiaoshouyejiVisit.aspx" />
    <Content Include="Pages\business\YujihuikuanTimeEdit.aspx" />
    <Content Include="Pages\common\CMSMergerOrder.ascx" />
@@ -4082,6 +4085,27 @@
    <Compile Include="Pages\business\xiaoshouyejiPrint.aspx.designer.cs">
      <DependentUpon>xiaoshouyejiPrint.aspx</DependentUpon>
    </Compile>
    <Compile Include="Pages\business\xiaoshouyejiReportList.aspx.cs">
      <DependentUpon>xiaoshouyejiReportList.aspx</DependentUpon>
      <SubType>ASPXCodeBehind</SubType>
    </Compile>
    <Compile Include="Pages\business\xiaoshouyejiReportList.aspx.designer.cs">
      <DependentUpon>xiaoshouyejiReportList.aspx</DependentUpon>
    </Compile>
    <Compile Include="Pages\business\xiaoshouyejiReportPrint.aspx.cs">
      <DependentUpon>xiaoshouyejiReportPrint.aspx</DependentUpon>
      <SubType>ASPXCodeBehind</SubType>
    </Compile>
    <Compile Include="Pages\business\xiaoshouyejiReportPrint.aspx.designer.cs">
      <DependentUpon>xiaoshouyejiReportPrint.aspx</DependentUpon>
    </Compile>
    <Compile Include="Pages\business\xiaoshouyejiReprotKehu.aspx.cs">
      <DependentUpon>xiaoshouyejiReprotKehu.aspx</DependentUpon>
      <SubType>ASPXCodeBehind</SubType>
    </Compile>
    <Compile Include="Pages\business\xiaoshouyejiReprotKehu.aspx.designer.cs">
      <DependentUpon>xiaoshouyejiReprotKehu.aspx</DependentUpon>
    </Compile>
    <Compile Include="Pages\business\xiaoshouyejiVisit.aspx.cs">
      <DependentUpon>xiaoshouyejiVisit.aspx</DependentUpon>
      <SubType>ASPXCodeBehind</SubType>

 CY_ECommercePlatform/CY.WebForm/Pages/business/xiaoshouyejiReportList.aspx

New file
@@ -0,0 +1,238 @@
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="xiaoshouyejiReportList.aspx.cs" Inherits="CY.WebForm.Pages.business.xiaoshouyejiReportList" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>销售绩效查询</title>
    <uc:CMSHead ID="CMSHead1" runat="server" />
    <style type="text/css">
        .tableStyle th { padding: 1px; }
        .tableStyle td { padding: 1px; }
    </style>
    <script type="text/javascript">
        /*
打印送货单
*/
        function ToPrintdelev() {

             

            var txtDeliveryTime = $("#txtDeliveryTime").val();
            var selBusinessManagerId = $("#selBusinessManagerId").val();
            

            // OpenWindowByUrl();
            window.open('/Pages/business/xiaoshouyejiReportPrint.aspx?txtDeliveryTime=' + txtDeliveryTime + '&selBusinessManagerId=' + selBusinessManagerId, '', '');
        }

        //查看
        function onViewWeihu(BusinessManagerId, chaxuntime) {
            top.Dialog.open({ URL: "/Pages/business/xiaoshouyejiVisit.aspx?BusinessManagerId=" + BusinessManagerId + "&chaxuntime=" + chaxuntime, Title: "查看客户回访记录", Width: 900, Height: 750 });
        }

        //查看
        function onViewgendankehu(BusinessManagerId, chaxuntime) {
           
            top.Dialog.open({ URL: "/Pages/business/xiaoshouyejiKehu.aspx?BusinessManagerId=" + BusinessManagerId + "&chaxuntime=" + chaxuntime + "&leixing=gendan" , Title: "查看跟单客户", Width: 1200, Height: 900 });
        }

        //查看
        function onViewxinzengkehu(BusinessManagerId, chaxuntimestart, chaxuntimeend, leixing) {
            top.Dialog.open({ URL: "/Pages/business/xiaoshouyejiReprotKehu.aspx?BusinessManagerId=" + BusinessManagerId + "&chaxuntimestart=" + chaxuntimestart + "&chaxuntimeend=" + chaxuntimeend + "&leixing=" + leixing, Title: "查看新增客户", Width: 1200, Height: 900 });
        }

    </script>
    <script type="text/javascript">
        $(function () {
            $("#selOrderMoney").change(function () {
                $("#txtOrderMoney").val("");
            });
            $("#selLastOrderTime").change(function () {
                $("#txtLastOrderTime").val("");
            });
        });
    </script>
</head>
<body>
    <form id="form1" runat="server" class="form">
    <div id="scrollContent">
        <div class="box1" paneltitle="功能面板" roller="false">
            <table class="TableNewStyle" width="100%">
                <tr>

                      <td colspan="6"> 
                      <%--  <select keepdefaultstyle='true' id='selDeliveryTime' runat="server" datatextfield="Name" datavaluefield="MeanValue">
                             <option value ="">全部</option>
                            <option value ="明天" selected="selected"> </option>
                             <option value ="后天"> </option>
                             <option value ="3天"> </option>
                             <option value ="4天"> </option>
                             <option value ="5天"> </option>
                             <option value ="6天"> </option>
                             <option value ="7天"> </option>
                            <option value ="一周后"> </option>
                        </select>--%>
                          <asp:button id="Button0" text="本周业绩" runat="server"  padding="0px" OnClick="btn_Search_Click0" />&nbsp;&nbsp;
                          <asp:button id="Button1" text="上周业绩" runat="server"  padding="0px" OnClick="btn_Search_Click1" />&nbsp;&nbsp;
                        <asp:button id="Button2" text="本月业绩" runat="server"  padding="0px" OnClick="btn_Search_Click2" />&nbsp;&nbsp;
                        <asp:button id="Button3" text="上月业绩" runat="server"  padding="0px" OnClick="btn_Search_Click3" />&nbsp;&nbsp;
                        <asp:button id="Button4" text="本年业绩" runat="server"  padding="0px" OnClick="btn_Search_Click4" />&nbsp;&nbsp;
                        <asp:button id="Button5" text="上年业绩" runat="server"  padding="0px" OnClick="btn_Search_Click5" />&nbsp;&nbsp;
                        <input type="hidden" runat="server" id="txtDeliveryTime"  />
                    </td>

                     
                     <td class="ali03 ">
                        业务经理：
                    </td>
                    <td>
                        <select id="selBusinessManagerId" runat="server" keepdefaultstyle='true'>
                            <option value="">全部</option>
                        </select>
                    </td>
                     <td>
                        <asp:Button CssClass="button" ID="btn_Search" Text="查询" runat="server" padding="0px" OnClick="btn_Search_Click" />
                         &nbsp;<input type="button" value='重置' onclick='document.body.innerHTML="";window.location=window.location;' />
                         &nbsp;<input type="button" value='打印' onclick='ToPrintdelev();' />
                    </td>
                </tr>
                
                
                
            </table>
        </div>
       
        <div>
            <asp:Repeater ID="RepClientList" runat="server">
                <HeaderTemplate>
                    <table class="tableStyle" useclick="false" usecheckbox="true" sortmode="true" style="text-align: center;">
                        <tr>
                           
                            <th style="text-align: center;">
                                序号
                            </th>
                             
                            <th style="text-align: center;">
                                业务经理
                            </th>
                              <th style="text-align: center;">
                                新增订单
                            </th>
                              <th style="text-align: center;">
                                产值
                            </th>
                              <th style="text-align: center;">
                               新增客户
                            </th>
                              <th style="text-align: center;">
                                完结客户
                            </th>
                           
                             <th style="text-align: center;">
                                应收款客户
                            </th>
                             <th style="text-align: center;">
                                应收款金额
                            </th>
                           <%-- <th style="text-align: center;">
                                跟单客户
                            </th>
                            --%>
                           
                            <%-- <th style="text-align: center;">
                               客户回访
                            </th>--%>
                            <%-- <th style="text-align: center;">
                                下单客户
                            </th>--%>
                          
                            
                           <%-- <th style="text-align: center;">
                                开票金额
                            </th>--%>
                             <th style="text-align: center;">
                                回款客户
                            </th>
                             <th style="text-align: center;">
                                回款金额
                            </th>
                             <th style="text-align: center;">
                                未回款客户
                            </th>
                             <th style="text-align: center;">
                                未收款金额
                            </th>
                            
                           
                           
                           
                           
                           
                        </tr>
                </HeaderTemplate>
                <ItemTemplate>
                    <tr>
                         
                        <td>
                            <%#Container.ItemIndex + (UCPager1.PageSize *( UCPager1.PageIndex-1)+1)%>
                        </td>
                         <td>
                              
                            <%#Eval("BusinessManager")%>
                        </td>
                        <td>
                            <%#Eval("shuliang")%>
                        </td>
                         <td>
                            <%#Eval("SumPrice", "{0:F2}")%>
                        </td>
                        <td>
                                  <a  href='javascript:void(0)'  onclick="onViewxinzengkehu('<%#Eval("BusinessManagerId")%>','<%#Eval("chaxuntimestart")%>','<%#Eval("chaxuntimeend")%>','xinzeng')"><%#Eval("xinzengshuliang")%></a>
                          
                        </td>
                         <td>
                            <%#Eval("wanjieshuliang")%>
                        </td>
                          <td>
                                  <a  href='javascript:void(0)'  onclick="onViewxinzengkehu('<%#Eval("BusinessManagerId")%>','<%#Eval("chaxuntimestart")%>','<%#Eval("chaxuntimeend")%>','yingshoukuan')">
                                       <%#Eval("xiadanshuliang")%>
                                  </a>
                          
                        </td>
                          <td>
                             <%#Eval("SumPrice", "{0:F2}")%>
                        </td>
                        

 
                         <td>
                              <a  href='javascript:void(0)'  onclick="onViewxinzengkehu('<%#Eval("BusinessManagerId")%>','<%#Eval("chaxuntimestart")%>','<%#Eval("chaxuntimeend")%>','yishoukuan')">
                                       <%#Eval("huikuankehu")%>
                                  </a>
                              </td>
                         <td>
                            <%#Eval("PayedMoney", "{0:F2}")%>
                        </td>
                         <td>
                             <a  href='javascript:void(0)'  onclick="onViewxinzengkehu('<%#Eval("BusinessManagerId")%>','<%#Eval("chaxuntimestart")%>','<%#Eval("chaxuntimeend")%>','weishoukuan')">
                                       <%#Eval("weihuikuankehu")%>
                                  </a>
                        
                              </td>
                         <td>
                            <%#Eval("UnPayedMoney", "{0:F2}")%>
                        </td>
                    </tr>
                </ItemTemplate>
                <FooterTemplate>
                    </table>
                </FooterTemplate>
            </asp:Repeater>
            <div id="page">
                <uc:UCPager ID="UCPager1" runat="server" />
            </div>
        </div>
    </div>
    </form>
</body>
</html>

 CY_ECommercePlatform/CY.WebForm/Pages/business/xiaoshouyejiReportList.aspx.cs

New file
@@ -0,0 +1,294 @@
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using CY.BLL;
using CY.Model;
using CY.Infrastructure.Query;
using CY.Infrastructure.Common;
using CY.BLL.Sys;
using CY.BLL.OA;
using CY.BLL.EC;
using System.Drawing;

namespace CY.WebForm.Pages.business
{
    public partial class xiaoshouyejiReportList : BasePage
    {

        EC_OrderBLL bll_EC_OrderBLL = null;

        OA_StaffBLL bll_OA_StaffBLL = null;


        //初始化
        public xiaoshouyejiReportList()
        {

            bll_EC_OrderBLL = new EC_OrderBLL();
            bll_OA_StaffBLL = new OA_StaffBLL();

        }

        protected void Page_Load(object sender, EventArgs e)
        {
            UCPager1.AspNetPager.PageChanged += AspNetPager1_PageChanged;
            if (!IsPostBack)
            {
                InitialSelectData();
                BindList();

            }
        }

        //加载查询条件
        protected void InitialSelectData()
        {
            if (this.txtDeliveryTime.Value == "")
            {
                this.txtDeliveryTime.Value = "本周业绩";
            }

            //业务经理  
            this.selBusinessManagerId.DataSource = bll_OA_StaffBLL.SelectListByFirmId(CurrentUser.MemberId, true, false);
            this.selBusinessManagerId.DataTextField = "Name";
            this.selBusinessManagerId.DataValueField = "Keyid";
            this.selBusinessManagerId.DataBind();
            this.selBusinessManagerId.Items.Insert(0, new ListItem("全部", ""));




        }

        //绑定列表
        private void BindList()
        {
            if (this.txtDeliveryTime.Value == "")
            {
                this.txtDeliveryTime.Value = this.Button0.Text;
            }

            if (this.txtDeliveryTime.Value == this.Button0.Text)
            {
                this.Button0.BorderColor = Color.Black;
                this.Button1.BorderColor = Color.LightBlue;
                this.Button2.BorderColor = Color.LightBlue;
                this.Button3.BorderColor = Color.LightBlue;
                this.Button4.BorderColor = Color.LightBlue;
                this.Button5.BorderColor = Color.LightBlue;
                
                
            }
            else if (this.txtDeliveryTime.Value == this.Button1.Text)
            {
                this.Button1.BorderColor = Color.Black;
                this.Button2.BorderColor = Color.LightBlue;
                this.Button3.BorderColor = Color.LightBlue;
                this.Button4.BorderColor = Color.LightBlue;
                this.Button5.BorderColor = Color.LightBlue;
                this.Button0.BorderColor = Color.LightBlue;
            }
            else if (this.txtDeliveryTime.Value == this.Button2.Text)
            {
                this.Button2.BorderColor = Color.Black;
                this.Button3.BorderColor = Color.LightBlue;
                this.Button4.BorderColor = Color.LightBlue;
                this.Button5.BorderColor = Color.LightBlue;
                this.Button0.BorderColor = Color.LightBlue;
                this.Button1.BorderColor = Color.LightBlue;
            }
            else if (this.txtDeliveryTime.Value == this.Button3.Text)
            {
                this.Button3.BorderColor = Color.Black;
                this.Button4.BorderColor = Color.LightBlue;
                this.Button5.BorderColor = Color.LightBlue;
                this.Button0.BorderColor = Color.LightBlue;
                this.Button1.BorderColor = Color.LightBlue;
                this.Button2.BorderColor = Color.LightBlue;
            }
            else if (this.txtDeliveryTime.Value == this.Button4.Text)
            {
                this.Button4.BorderColor = Color.Black;
                this.Button5.BorderColor = Color.LightBlue;
                this.Button0.BorderColor = Color.LightBlue;
                this.Button1.BorderColor = Color.LightBlue;
                this.Button2.BorderColor = Color.LightBlue;
                this.Button3.BorderColor = Color.LightBlue;
            }
            else if (this.txtDeliveryTime.Value == this.Button5.Text)
            {
                this.Button5.BorderColor = Color.Black;
                this.Button0.BorderColor = Color.LightBlue;
                this.Button1.BorderColor = Color.LightBlue;
                this.Button2.BorderColor = Color.LightBlue;
                this.Button3.BorderColor = Color.LightBlue;
                this.Button4.BorderColor = Color.LightBlue;
            }
            string chaxuntimestart = "";
            string chaxuntimeend = "";

            if (this.txtDeliveryTime.Value== "本周业绩")
            {
                DateTime nowTime = DateTime.Now;
                #region 获取本周第一天
                //星期一为第一天  
                int weeknow = Convert.ToInt32(nowTime.DayOfWeek);

                //因为是以星期一为第一天，所以要判断weeknow等于0时，要向前推6天。  
                weeknow = (weeknow == 0 ? (7 - 1) : (weeknow - 1));
                int daydiff = (-1) * weeknow;

                //本周第一天  
                DateTime FirstDay = nowTime.AddDays(daydiff);
                #endregion

                #region 获取本周最后一天
                //星期天为最后一天  
                int lastWeekDay = Convert.ToInt32(nowTime.DayOfWeek);
                lastWeekDay = lastWeekDay == 0 ? (7 - lastWeekDay) : lastWeekDay;
                int lastWeekDiff = (7 - lastWeekDay);

                //本周最后一天  
                DateTime LastDay = nowTime.AddDays(lastWeekDiff);

                #endregion
                chaxuntimestart = FirstDay.ToString("yyyy-MM-dd");
                chaxuntimeend = LastDay.ToString("yyyy-MM-dd");

            }
            else if(this.txtDeliveryTime.Value == "上周业绩")
            {
                DateTime nowTime = DateTime.Now.AddDays(-7);
                #region 获取本周第一天
                //星期一为第一天  
                int weeknow = Convert.ToInt32(nowTime.DayOfWeek);

                //因为是以星期一为第一天，所以要判断weeknow等于0时，要向前推6天。  
                weeknow = (weeknow == 0 ? (7 - 1) : (weeknow - 1));
                int daydiff = (-1) * weeknow;

                //本周第一天  
                DateTime FirstDay = nowTime.AddDays(daydiff);
                #endregion

                #region 获取本周最后一天
                //星期天为最后一天  
                int lastWeekDay = Convert.ToInt32(nowTime.DayOfWeek);
                lastWeekDay = lastWeekDay == 0 ? (7 - lastWeekDay) : lastWeekDay;
                int lastWeekDiff = (7 - lastWeekDay);

                //本周最后一天  
                DateTime LastDay = nowTime.AddDays(lastWeekDiff);

                #endregion
                chaxuntimestart = FirstDay.ToString("yyyy-MM-dd");
                chaxuntimeend = LastDay.ToString("yyyy-MM-dd");
            }
            else if (this.txtDeliveryTime.Value == "本月业绩")
            {
                chaxuntimestart = DateTime.Now.AddDays(1 - DateTime.Now.Day).Date.ToString("yyyy-MM-dd"); 

                chaxuntimeend = DateTime.Now.AddDays(1 - DateTime.Now.Day).Date.AddMonths(1).AddSeconds(-1).ToString("yyyy-MM-dd"); 

            }
            else if (this.txtDeliveryTime.Value == "上月业绩")
            {
                chaxuntimestart = DateTime.Now.AddMonths(-1).AddDays(1 - DateTime.Now.Day).Date.ToString("yyyy-MM-dd"); 

                chaxuntimeend = DateTime.Now.AddMonths(-1).AddDays(1 - DateTime.Now.Day).Date.AddMonths(1).AddSeconds(-1).ToString("yyyy-MM-dd"); 
            }
            else if (this.txtDeliveryTime.Value == "本年业绩")
            {
                DateTime dt = DateTime.Now;
                //本年第一天  
                chaxuntimestart  = new DateTime(dt.Year,1,1).ToString("yyyy-MM-dd");
                chaxuntimeend = new DateTime(dt.Year, 12, 31).ToString("yyyy-MM-dd");
            }
            else if (this.txtDeliveryTime.Value == "上年业绩")
            {
                DateTime dt = DateTime.Now.AddYears(-1);
                //本年第一天  
                chaxuntimestart = new DateTime(dt.Year, 1, 1).ToString("yyyy-MM-dd");
                chaxuntimeend = new DateTime(dt.Year, 12, 31).ToString("yyyy-MM-dd");
            }





            Pagination pa = new Pagination();
            pa.PageSize = UCPager1.AspNetPager.PageSize;
            pa.PageIndex = UCPager1.AspNetPager.CurrentPageIndex;
            this.RepClientList.DataSource = bll_EC_OrderBLL.GetyewurenportList(pa,
                CurrentUser.MemberId,

                this.selBusinessManagerId.Value,
                chaxuntimestart,
                chaxuntimeend

               );
            this.RepClientList.DataBind();
            UCPager1.AspNetPager.RecordCount = pa.RecordCount;
        }

        //分页事件
        protected void AspNetPager1_PageChanged(object src, EventArgs e)
        {
            BindList();
        }

        //查询事件
        protected void btn_Search_Click(object sender, EventArgs e)
        {
            BindList();
        }

        protected void btn_Search_Click0(object sender, EventArgs e)
        {

            this.txtDeliveryTime.Value = this.Button0.Text;

            BindList();
        }
        protected void btn_Search_Click1(object sender, EventArgs e)
        {

            this.txtDeliveryTime.Value = this.Button1.Text;

            BindList();
        }

        protected void btn_Search_Click2(object sender, EventArgs e)
        {

            this.txtDeliveryTime.Value = this.Button2.Text;

            BindList();
        }
        protected void btn_Search_Click3(object sender, EventArgs e)
        {

            this.txtDeliveryTime.Value = this.Button3.Text;

            BindList();
        }
        protected void btn_Search_Click4(object sender, EventArgs e)
        {

            this.txtDeliveryTime.Value = this.Button4.Text;

            BindList();
        }
        protected void btn_Search_Click5(object sender, EventArgs e)
        {

            this.txtDeliveryTime.Value = this.Button5.Text;

            BindList();
        }

    }
}

 CY_ECommercePlatform/CY.WebForm/Pages/business/xiaoshouyejiReportList.aspx.designer.cs

New file
@@ -0,0 +1,134 @@
//------------------------------------------------------------------------------
// <自动生成>
//     此代码由工具生成。
//
//     对此文件的更改可能导致不正确的行为，如果
//     重新生成代码，则所做更改将丢失。
// </自动生成>
//------------------------------------------------------------------------------

namespace CY.WebForm.Pages.business
{


    public partial class xiaoshouyejiReportList
    {

        /// <summary>
        /// CMSHead1 控件。
        /// </summary>
        /// <remarks>
        /// 自动生成的字段。
        /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::CY.WebForm.Pages.common.CMSHead CMSHead1;

        /// <summary>
        /// form1 控件。
        /// </summary>
        /// <remarks>
        /// 自动生成的字段。
        /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::System.Web.UI.HtmlControls.HtmlForm form1;

        /// <summary>
        /// Button0 控件。
        /// </summary>
        /// <remarks>
        /// 自动生成的字段。
        /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::System.Web.UI.WebControls.Button Button0;

        /// <summary>
        /// Button1 控件。
        /// </summary>
        /// <remarks>
        /// 自动生成的字段。
        /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::System.Web.UI.WebControls.Button Button1;

        /// <summary>
        /// Button2 控件。
        /// </summary>
        /// <remarks>
        /// 自动生成的字段。
        /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::System.Web.UI.WebControls.Button Button2;

        /// <summary>
        /// Button3 控件。
        /// </summary>
        /// <remarks>
        /// 自动生成的字段。
        /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::System.Web.UI.WebControls.Button Button3;

        /// <summary>
        /// Button4 控件。
        /// </summary>
        /// <remarks>
        /// 自动生成的字段。
        /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::System.Web.UI.WebControls.Button Button4;

        /// <summary>
        /// Button5 控件。
        /// </summary>
        /// <remarks>
        /// 自动生成的字段。
        /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::System.Web.UI.WebControls.Button Button5;

        /// <summary>
        /// txtDeliveryTime 控件。
        /// </summary>
        /// <remarks>
        /// 自动生成的字段。
        /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::System.Web.UI.HtmlControls.HtmlInputHidden txtDeliveryTime;

        /// <summary>
        /// selBusinessManagerId 控件。
        /// </summary>
        /// <remarks>
        /// 自动生成的字段。
        /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::System.Web.UI.HtmlControls.HtmlSelect selBusinessManagerId;

        /// <summary>
        /// btn_Search 控件。
        /// </summary>
        /// <remarks>
        /// 自动生成的字段。
        /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::System.Web.UI.WebControls.Button btn_Search;

        /// <summary>
        /// RepClientList 控件。
        /// </summary>
        /// <remarks>
        /// 自动生成的字段。
        /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::System.Web.UI.WebControls.Repeater RepClientList;

        /// <summary>
        /// UCPager1 控件。
        /// </summary>
        /// <remarks>
        /// 自动生成的字段。
        /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::CY.WebForm.Pages.common.UCPager UCPager1;
    }
}

 CY_ECommercePlatform/CY.WebForm/Pages/business/xiaoshouyejiReportPrint.aspx

New file
@@ -0,0 +1,158 @@
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="xiaoshouyejiReportPrint.aspx.cs" Inherits="CY.WebForm.Pages.business.xiaoshouyejiReportPrint" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
    <title>销售业绩打印</title>
    <script src="../../js/utils/jquery-1.5.1.min.js" type="text/javascript"></script>
    <script src="../../js/common/util.js" type="text/javascript"></script>
    <script src="../../js/common/KeyBehaviorHook.js" type="text/javascript"></script>
    <script src="../../js/common/Printter.js?v=14" type="text/javascript"></script>
    <script src="../../js/common/LodopFuncs.js" type="text/javascript"></script>
    <link href="../../Styles/ParticularWQJ.css" rel="stylesheet" type="text/css" />
    <!--前台页面start-->
    <style type="text/css">
        .dbody { margin: 0; margin-left: auto; margin-right: auto; }
        .dtitle { text-align: center; font-size: 19px; font-weight: bold; margin-top: 10px; margin-bottom: 10px; }
        .dbody table { width: 100%; border: 1px solid #dddddd; font-size: 12px; margin-top: 5px; border-top: 1px #999999 solid;}
        .dbody table th, .dbody table td { font-weight: normal; height: 20px; line-height: 20px; vertical-align: middle; border: 1px solid #999999; border-top: 0; }
        .dbody table th { background-color: #E0EDF6; font-weight: bold; }
        .dbody table td { border-left: 0; padding-left:2px; }
        .left {text-align: right; }
        #div_tool { text-align: center; }
    </style>
    <script type="text/javascript">
        window.printBeginCallBack = function () {
            document.getElementById('fram_operate').style.display = 'none';
        };
        window.printOverCallBack = function () {
            document.getElementById('fram_operate').style.display = '';
        };

       
    </script>
</head>
<body style='padding: 0; margin: 0;' onbeforeprint="OnPrint()" onafterprint="OnPrintOver()">
    <form id="form1" runat="server">
    <input type="hidden" runat="server" id="hideOrderId" />
    <div class='dbody'>
        <object id="LODOP_OB" classid="clsid:2105C259-1E0C-4534-8141-A753534CB4CA" width="0" height="0">
            <embed id="LODOP_EM" type="application/x-print-lodop" width="0" height="0" pluginspage="/Pages/common/install_lodop32.exe"></embed>
        </object>
        <div id='div_tool' >
        </div>
           <table border="1" cellpadding="0" cellspacing="0" style="border: 0;margin-bottom:10px;margin-top:10px;">
               <tr>
                   <td>  <label id="labchaxuntime" runat="server"></label> </td>
                   </tr>
  </table>
               
            
       
           
                     <table border="1" cellpadding="0" cellspacing="0" style="border: 0;margin-bottom:10px;margin-top:10px;">
                     <thead>
                    <tr>
                         
                      
                            <th style="text-align: center;">
                                序号
                            </th>
                             
                            <th style="text-align: center;">
                                业务经理
                            </th>
                              <th style="text-align: center;">
                                新增订单
                            </th>
                              <th style="text-align: center;">
                                产值
                            </th>
                              <th style="text-align: center;">
                               新增客户
                            </th>
                              <th style="text-align: center;">
                                完结客户
                            </th>
                           
                             <th style="text-align: center;">
                                应收款客户
                            </th>
                             <th style="text-align: center;">
                                应收款金额
                            </th>
                            
                             <th style="text-align: center;">
                                回款客户
                            </th>
                             <th style="text-align: center;">
                                回款金额
                            </th>
                             <th style="text-align: center;">
                                未回款客户
                            </th>
                             <th style="text-align: center;">
                                未收款金额
                            </th>
                            
                           
                         
                    </tr>
                </thead>
                <tbody>
                  <asp:Repeater runat="server" ID='rptOrder'>
                <ItemTemplate>
                             <tr>
                     <td>
                            <%#Container.ItemIndex +1%>
                        </td>
                         <td>
                            <%#Eval("BusinessManager")%>
                        </td>
                         <td>
                            <%#Eval("shuliang")%>
                        </td>
                           <td>
                            <%#Eval("SumPrice", "{0:F2}")%>
                        </td>
                         <td>
                            <%#Eval("xinzengshuliang")%>
                        </td>
                        <td>
                            <%#Eval("wanjieshuliang")%>
                        </td>
                        <td>
                            <%#Eval("xiadanshuliang")%>
                        </td>
                           <td>
                             <%#Eval("SumPrice", "{0:F2}")%>
                        </td>
                        
 
                         <td>
                         <%#Eval("huikuankehu")%>
                              </td>
                         <td>
                            <%#Eval("PayedMoney", "{0:F2}")%>
                        </td>
                         <td>
                         <%#Eval("weihuikuankehu")%>
                              </td>
                         <td>
                            <%#Eval("UnPayedMoney", "{0:F2}")%>
                        </td>
                    </tr>
                        </itemtemplate>
                    </asp:repeater>
                </tbody>
                          </table>
               
          
             
           
       
       
    </div>
    </form>
</body>
</html>

 CY_ECommercePlatform/CY.WebForm/Pages/business/xiaoshouyejiReportPrint.aspx.cs

New file
@@ -0,0 +1,199 @@
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using CY.BLL.EC;
using CY.Infrastructure.Common;
using CY.Model;
using CY.BLL;
using CY.Model.Inquiry;
using CY.BLL.Sys;
using CY.Infrastructure.Query;

namespace CY.WebForm.Pages.business
{
    public partial class xiaoshouyejiReportPrint : BasePage
    {
        EC_OrderBLL bll_EC_OrderBLL = new EC_OrderBLL();

        string txtDeliveryTime = "";
        /// <summary>
        /// 页面加载事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void Page_Load(object sender, EventArgs e)
        {
            try
            {
                switch (Request["Target"])
                {
                    case "GetCommunication":
                        break;
                    case "print":
                        break;
                    default:
                        Page_Load_Default();
                        return;
                }
            }
            catch (Exception ex)
            {
                PAGEHandleException(ex);
                Response.Clear();
                Response.Write("-1");
            }
            Response.End();
        }


        /// <summary>
        /// 默认加载事件方法
        /// </summary>
        private void Page_Load_Default()
        {
            
            if (string.IsNullOrEmpty(Request["txtDeliveryTime"]))
            {
                JavaScript.MessageBox("必须填写查询时间", this);
                return;
            }

            LoadOrderInfo();
        }

        /// <summary>
        /// 加载订单信息
        /// </summary>
        private bool LoadOrderInfo()
        {



            txtDeliveryTime = Request["txtDeliveryTime"] == null ? "" : Request["txtDeliveryTime"];



            string selBusinessManagerId = Request["selBusinessManagerId"] == null ? "" : Request["selBusinessManagerId"];


            string chaxuntimestart = "";
            string chaxuntimeend = "";

            if (this.txtDeliveryTime == "本周业绩")
            {
                DateTime nowTime = DateTime.Now;
                #region 获取本周第一天
                //星期一为第一天  
                int weeknow = Convert.ToInt32(nowTime.DayOfWeek);

                //因为是以星期一为第一天，所以要判断weeknow等于0时，要向前推6天。  
                weeknow = (weeknow == 0 ? (7 - 1) : (weeknow - 1));
                int daydiff = (-1) * weeknow;

                //本周第一天  
                DateTime FirstDay = nowTime.AddDays(daydiff);
                #endregion

                #region 获取本周最后一天
                //星期天为最后一天  
                int lastWeekDay = Convert.ToInt32(nowTime.DayOfWeek);
                lastWeekDay = lastWeekDay == 0 ? (7 - lastWeekDay) : lastWeekDay;
                int lastWeekDiff = (7 - lastWeekDay);

                //本周最后一天  
                DateTime LastDay = nowTime.AddDays(lastWeekDiff);

                #endregion
                chaxuntimestart = FirstDay.ToString("yyyy-MM-dd");
                chaxuntimeend = LastDay.ToString("yyyy-MM-dd");

            }
            else if (this.txtDeliveryTime == "上周业绩")
            {
                DateTime nowTime = DateTime.Now.AddDays(-7);
                #region 获取本周第一天
                //星期一为第一天  
                int weeknow = Convert.ToInt32(nowTime.DayOfWeek);

                //因为是以星期一为第一天，所以要判断weeknow等于0时，要向前推6天。  
                weeknow = (weeknow == 0 ? (7 - 1) : (weeknow - 1));
                int daydiff = (-1) * weeknow;

                //本周第一天  
                DateTime FirstDay = nowTime.AddDays(daydiff);
                #endregion

                #region 获取本周最后一天
                //星期天为最后一天  
                int lastWeekDay = Convert.ToInt32(nowTime.DayOfWeek);
                lastWeekDay = lastWeekDay == 0 ? (7 - lastWeekDay) : lastWeekDay;
                int lastWeekDiff = (7 - lastWeekDay);

                //本周最后一天  
                DateTime LastDay = nowTime.AddDays(lastWeekDiff);

                #endregion
                chaxuntimestart = FirstDay.ToString("yyyy-MM-dd");
                chaxuntimeend = LastDay.ToString("yyyy-MM-dd");
            }
            else if (this.txtDeliveryTime == "本月业绩")
            {
                chaxuntimestart = DateTime.Now.AddDays(1 - DateTime.Now.Day).Date.ToString("yyyy-MM-dd");

                chaxuntimeend = DateTime.Now.AddDays(1 - DateTime.Now.Day).Date.AddMonths(1).AddSeconds(-1).ToString("yyyy-MM-dd");

            }
            else if (this.txtDeliveryTime == "上月业绩")
            {
                chaxuntimestart = DateTime.Now.AddMonths(-1).AddDays(1 - DateTime.Now.Day).Date.ToString("yyyy-MM-dd");

                chaxuntimeend = DateTime.Now.AddMonths(-1).AddDays(1 - DateTime.Now.Day).Date.AddMonths(1).AddSeconds(-1).ToString("yyyy-MM-dd");
            }
            else if (this.txtDeliveryTime == "本年业绩")
            {
                DateTime dt = DateTime.Now;
                //本年第一天  
                chaxuntimestart = new DateTime(dt.Year, 1, 1).ToString("yyyy-MM-dd");
                chaxuntimeend = new DateTime(dt.Year, 12, 31).ToString("yyyy-MM-dd");
            }
            else if (this.txtDeliveryTime == "上年业绩")
            {
                DateTime dt = DateTime.Now.AddYears(-1);
                //本年第一天  
                chaxuntimestart = new DateTime(dt.Year, 1, 1).ToString("yyyy-MM-dd");
                chaxuntimeend = new DateTime(dt.Year, 12, 31).ToString("yyyy-MM-dd");
            }





            Infrastructure.Query.Pagination pagination = new Infrastructure.Query.Pagination()
            {
                PageSize = 1000,
                PageIndex = 1
            };



            this.rptOrder.DataSource = bll_EC_OrderBLL.GetyewurenportList(pagination,
               CurrentUser.MemberId,

               selBusinessManagerId,
               chaxuntimestart,
               chaxuntimeend
              );
            this.rptOrder.DataBind();






            return true;
        }
    }
}

 CY_ECommercePlatform/CY.WebForm/Pages/business/xiaoshouyejiReportPrint.aspx.designer.cs

New file
@@ -0,0 +1,62 @@
//------------------------------------------------------------------------------
// <自动生成>
//     此代码由工具生成。
//
//     对此文件的更改可能导致不正确的行为，如果
//     重新生成代码，则所做更改将丢失。
// </自动生成>
//------------------------------------------------------------------------------

namespace CY.WebForm.Pages.business
{


    public partial class xiaoshouyejiReportPrint
    {

        /// <summary>
        /// Head1 控件。
        /// </summary>
        /// <remarks>
        /// 自动生成的字段。
        /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::System.Web.UI.HtmlControls.HtmlHead Head1;

        /// <summary>
        /// form1 控件。
        /// </summary>
        /// <remarks>
        /// 自动生成的字段。
        /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::System.Web.UI.HtmlControls.HtmlForm form1;

        /// <summary>
        /// hideOrderId 控件。
        /// </summary>
        /// <remarks>
        /// 自动生成的字段。
        /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::System.Web.UI.HtmlControls.HtmlInputHidden hideOrderId;

        /// <summary>
        /// labchaxuntime 控件。
        /// </summary>
        /// <remarks>
        /// 自动生成的字段。
        /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::System.Web.UI.HtmlControls.HtmlGenericControl labchaxuntime;

        /// <summary>
        /// rptOrder 控件。
        /// </summary>
        /// <remarks>
        /// 自动生成的字段。
        /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::System.Web.UI.WebControls.Repeater rptOrder;
    }
}

 CY_ECommercePlatform/CY.WebForm/Pages/business/xiaoshouyejiReprotKehu.aspx

New file
@@ -0,0 +1,204 @@
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="xiaoshouyejiReprotKehu.aspx.cs" Inherits="CY.WebForm.Pages.business.xiaoshouyejiReprotKehu" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>销售业绩客户</title>
    <uc:CMSHead ID="CMSHead1" runat="server" />
    <style type="text/css">
        .tableStyle th { padding: 1px; }
        .tableStyle td { padding: 1px; }
    </style>
    <script type="text/javascript">
        ///添加
        function addModel() {
            top.Dialog.open({ URL: "/Pages/business/CorporateClientsEdit.aspx", Title: "新增客户", Width: 900, Height: 750 });
        }

        //查看
        function onView(keyid) {
            top.Dialog.open({ URL: "/Pages/business/CorporateClientsDetail.aspx?Keyid=" + keyid, Title: "查看客户", Width: 900, Height: 750 });
        }
        //查看
        function onViewWeihu(keyid) {
            top.Dialog.open({ URL: "/Pages/business/CorporateClientsVisit.aspx?Keyid=" + keyid, Title: "查看客户维护记录", Width: 900, Height: 750 });
        }
        
        //修改
        function onEdit(keyid) {
            top.Dialog.open({ URL: "/Pages/business/CorporateClientsEdit.aspx?Keyid=" + keyid, Title: "修改客户", Width: 900, Height: 750 });
        }

        //删除
        function onDelete(keyid) {
            top.Dialog.confirm("确定要删除该客户吗？", function () {
                window.location = "/Pages/business/CorporateClientsList.aspx?delete=" + keyid;
            });
        }

        //订单关联
        function onChange(keyid) {
            top.Dialog.confirm("确认向此客户开通订单关联吗？", function () {
                $.ajax({
                    url: "/Pages/common/CommonAjax.aspx?data=" + (new Date()).valueOf(),
                    type: "POST",
                    dataType: "html",
                    data: { customchangetype: "customchangetype", keyid: keyid },
                    global: false,
                    cache: false,
                    async: false,
                    success: function (data) {
                        alertMsg(data);
                        window.location = "/Pages/business/CorporateClientsList.aspx";
                    }
                });
            });
        }

        //设置询价参数
        function SetInquiryPar(keyid) {
            window.location.href = "/Pages/sysInquiry/InquiryParameterList.aspx?CustomerId=" + keyid;
        }

        //合并客户
        function mergerModel() {
            var keyid = "";
            var num = 0;
            $(".SelectCheck:checked").each(function (ii, vv) {
                keyid = keyid + "|" + $(vv).attr("value_kid");
                num++;
            });
            if (num == 0)
                alertMsg("未选中任何客户");
            else if (num != 2)
                alertMsg("单次合并只能选择两个客户");
            else
                top.Dialog.open({ URL: "/Pages/business/CorporateClientsMerger.aspx?Keyid=" + keyid, Title: "合并客户", Width: 500, Height: 300, Modal: false });
        }
    </script>
    <script type="text/javascript">
        $(function () {
            $("#selOrderMoney").change(function () {
                $("#txtOrderMoney").val("");
            });
            $("#selLastOrderTime").change(function () {
                $("#txtLastOrderTime").val("");
            });
        });
    </script>
</head>
<body>
    <form id="form1" runat="server" class="form">
    <div id="scrollContent">
 
       
        <div>
            <asp:Repeater ID="RepClientList" runat="server">
                <HeaderTemplate>
                    <table class="tableStyle" useclick="false" usecheckbox="true" sortmode="true" style="text-align: center;">
                        <tr>
                            
                            <th style="text-align: center;">
                                编号
                            </th>
                            <th style="text-align: center;">
                                建档时间
                            </th>
                            <th style="text-align: center;">
                                所在区域
                            </th>
                            <th style="text-align: center;">
                                名称
                            </th>
                            <th style="text-align: center;">
                                信誉
                            </th>
                            <th style="text-align: center;">
                                联系人
                            </th>
                            <th style="text-align: center;">
                                联系手机
                            </th>
                            <th style="text-align: center;" class="case_email">
                                电子邮箱
                            </th>
                            <th style="text-align: center;">
                                客户级别
                            </th>
                            <th style="text-align: center;">
                                预付款余额
                            </th>
                            <th style="text-align: center;">
                                授信额度
                            </th>
                            <th style="text-align: center;">
                                下单数量
                            </th>
                            <th style="text-align: center;">
                                下单产值
                            </th>
                             <th style="text-align: center;">
                                完结状态
                            </th>
                             
                        </tr>
                </HeaderTemplate>
                <ItemTemplate>
                    <tr>
                       
                        <td>
                            <%#Eval("CustomerId")%>
                        </td>
                        <td>
                            <%#Eval("CreateTime", "{0:yyyy-MM-dd}")%>
                        </td>
                        <td>
                            <%#Eval("City").ToString().IndexOf("其他") >= 0 ? Eval("Province") : Eval("City")%><%#Eval("County")%>
                        </td>
                        <td>
                            <a class="a_under" style="color: <%#Eval("Keyid").ToString() == Eval("MemberId").ToString() ? "" : "green"%>;" href="/Pages/financial/OrderFinancial.aspx?customeid=<%#Eval("MemberId")%>" title="点击查看订单记录">
                                <%#Eval("CompanyName")%></a>
                        </td>
                        <td>
                            <%#Eval("CreditIdName")%>
                        </td>
                        <td>
                            <%#Eval("BusinessManagers")%>
                        </td>
                        <td>
                            <%#Eval("Mobile")%>
                        </td>
                        <td class="case_email">
                            <%#Eval("Email")%>
                        </td>
                        <td>
                            <%#Eval("DegreeImportanIdName")%>
                        </td>
                        <td class="green">
                            <%#Eval("Prepayments", "{0:F2}")%>
                        </td>
                        <td>
                            <%#Eval("Credit", "{0:F2}")%>
                        </td>
                        <td>
                            <%#Eval("OrderCount")%>
                        </td>
                        <td>
                            <%#Eval("OrderMoney", "{0:F2}")%>
                        </td>
                        <td>
                            <%#Eval("ShifouwanjieName")%>
                        </td>
                      
                    </tr>
                </ItemTemplate>
                <FooterTemplate>
                    </table>
                </FooterTemplate>
            </asp:Repeater>
            
        </div>
    </div>
    </form>
</body>
</html>

 CY_ECommercePlatform/CY.WebForm/Pages/business/xiaoshouyejiReprotKehu.aspx.cs

New file
@@ -0,0 +1,306 @@
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using CY.BLL;
using CY.Model;
using CY.Infrastructure.Query;
using CY.Infrastructure.Common;
using CY.BLL.Sys;
using CY.BLL.OA;
using CY.BLL.EC;

namespace CY.WebForm.Pages.business
{
    public partial class xiaoshouyejiReprotKehu : BasePage
    {
        OA_CorporateClientsBLL bll_OA_CorporateClientsBLL = null;
        Sys_DictionaryBLL _Sys_DictionaryBLL = null;
        OA_StaffBLL bll_OA_StaffBLL = null;
        OA_CustomerApplyBLL bll_OA_CustomerApplyBLL = null;
        EC_MemberBasicBLL bll_EC_MemberBasicBLL = null;
        Sys_CitySiteBLL bll_Sys_CitySiteBLL = null;
        EC_OrderBasicBLL _eC_OrderBasicBLL = null;

        //初始化
        public xiaoshouyejiReprotKehu()
        {
            _Sys_DictionaryBLL = new Sys_DictionaryBLL();
            bll_OA_CorporateClientsBLL = new OA_CorporateClientsBLL();
            bll_OA_StaffBLL = new OA_StaffBLL();
            bll_OA_CustomerApplyBLL = new OA_CustomerApplyBLL();
            bll_EC_MemberBasicBLL = new EC_MemberBasicBLL();
            bll_Sys_CitySiteBLL = new Sys_CitySiteBLL();
            _eC_OrderBasicBLL = new EC_OrderBasicBLL();
        }


        //页面加载
        protected void Page_Load(object sender, EventArgs e)
        {

            if (!IsPostBack)
            {

                BindList();

            }


        }


        //绑定列表
        private void BindList()
        {


            string BusinessManagerId = Request["BusinessManagerId"];

            string chaxuntimestart = Request["chaxuntimestart"];
            string chaxuntimeend = Request["chaxuntimeend"];

            string leixing = Request["leixing"];

            DateTime datebegin = DateTime.Parse(chaxuntimestart);
            DateTime dateend = DateTime.Parse(chaxuntimeend).AddDays(1);
            Pagination pa = new Pagination();
            pa.PageSize = 10000;
            pa.PageIndex = 1;

            if (leixing == "yingshoukuan")
            {

                Dictionary<int, object> searchParam = new Dictionary<int, object>();

                SetParamValue(searchParam, 1, CurrentUser.MemberId);
                SetParamValue(searchParam, 2, "");
                SetParamValue(searchParam, 3, "");
                SetParamValue(searchParam, 4, chaxuntimestart);
                SetParamValue(searchParam, 5, dateend.ToString("yyyy-MM-dd"));
                SetParamValue(searchParam, 6, "");
                SetParamValue(searchParam, 7, "");
                SetParamValue(searchParam, 8, "");
                SetParamValue(searchParam, 9, "");//付款状态  -1
                SetParamValue(searchParam, 10, "");
                SetParamValue(searchParam, 11, "");
                SetParamValue(searchParam, 12, "");
                SetParamValue(searchParam, 13, BusinessManagerId);
                SetParamValue(searchParam, 14, "");
                SetParamValue(searchParam, 15, "");
                SetParamValue(searchParam, 16, "");
                SetParamValue(searchParam, 18, 0);
                SetParamValue(searchParam, 19, "");
                SetParamValue(searchParam, 20, "");
                SetParamValue(searchParam, 21, "");
                List<Guid> result = _eC_OrderBasicBLL.SelectModelPage_Seller(pa, searchParam).Select(x=>x.BuyerId).ToList();




                this.RepClientList.DataSource = bll_OA_CorporateClientsBLL.GetModelPageList(pa,
               CurrentUser.MemberId,
              "",
               null,
               null,
               "",
               BusinessManagerId,
               "",
               "",
               "",
               "",
               "",
               "",
               "",
               "",
               "",
               "",
               "",
               "",
               "",
               "",
               "",
               false,
               CurrentUser.TrueMemberId,
               CurrentUser.StaffId,
               "").Where(x => result.Contains(x.Keyid));
                this.RepClientList.DataBind();
            }
            else if (leixing == "xinzeng")
            {

                this.RepClientList.DataSource = bll_OA_CorporateClientsBLL.GetModelPageList(pa,
              CurrentUser.MemberId,
             "",
              null,
              null,
              "",
              BusinessManagerId,
              "",
              "",
              "",
              "",
              "",
              "",
              "",
              "",
              "",
              "",
              "",
              "",
              "",
              "",
              "",
              false,
              CurrentUser.TrueMemberId,
              CurrentUser.StaffId,
              "").Where(x => x.CreateTime >= datebegin && x.CreateTime < dateend);
                this.RepClientList.DataBind();
            }else if (leixing == "yishoukuan")
            {

                Dictionary<int, object> searchParam = new Dictionary<int, object>();

                SetParamValue(searchParam, 1, CurrentUser.MemberId);
                SetParamValue(searchParam, 2, "");
                SetParamValue(searchParam, 3, "");
                SetParamValue(searchParam, 4, chaxuntimestart);
                SetParamValue(searchParam, 5, dateend.ToString("yyyy-MM-dd"));
                SetParamValue(searchParam, 6, "");
                SetParamValue(searchParam, 7, "");
                SetParamValue(searchParam, 8, "");
                SetParamValue(searchParam, 9, "-1");//付款状态  
                SetParamValue(searchParam, 10, "");
                SetParamValue(searchParam, 11, "");
                SetParamValue(searchParam, 12, "");
                SetParamValue(searchParam, 13, BusinessManagerId);
                SetParamValue(searchParam, 14, "");
                SetParamValue(searchParam, 15, "");
                SetParamValue(searchParam, 16, "");
                SetParamValue(searchParam, 18, 0);
                SetParamValue(searchParam, 19, "");
                SetParamValue(searchParam, 20, "");
                SetParamValue(searchParam, 21, "");
                List<Guid> result = _eC_OrderBasicBLL.SelectModelPage_Seller(pa, searchParam).Select(x => x.BuyerId).ToList();




                this.RepClientList.DataSource = bll_OA_CorporateClientsBLL.GetModelPageList(pa,
               CurrentUser.MemberId,
              "",
               null,
               null,
               "",
               BusinessManagerId,
               "",
               "",
               "",
               "",
               "",
               "",
               "",
               "",
               "",
               "",
               "",
               "",
               "",
               "",
               "",
               false,
               CurrentUser.TrueMemberId,
               CurrentUser.StaffId,
               "").Where(x => result.Contains(x.Keyid));
                this.RepClientList.DataBind();
            }
            else if (leixing == "weishoukuan")
            {

                Dictionary<int, object> searchParam = new Dictionary<int, object>();

                SetParamValue(searchParam, 1, CurrentUser.MemberId);
                SetParamValue(searchParam, 2, "");
                SetParamValue(searchParam, 3, "");
                SetParamValue(searchParam, 4, chaxuntimestart);
                SetParamValue(searchParam, 5, dateend.ToString("yyyy-MM-dd"));
                SetParamValue(searchParam, 6, "");
                SetParamValue(searchParam, 7, "");
                SetParamValue(searchParam, 8, "");
                SetParamValue(searchParam, 9, "");//付款状态  
                SetParamValue(searchParam, 10, "");
                SetParamValue(searchParam, 11, "");
                SetParamValue(searchParam, 12, "");
                SetParamValue(searchParam, 13, BusinessManagerId);
                SetParamValue(searchParam, 14, "");
                SetParamValue(searchParam, 15, "");
                SetParamValue(searchParam, 16, "");
                SetParamValue(searchParam, 18, 0);
                SetParamValue(searchParam, 19, "");
                SetParamValue(searchParam, 20, "");
                SetParamValue(searchParam, 21, "");
                List<Guid> result = _eC_OrderBasicBLL.SelectModelPage_Seller(pa, searchParam).Where(x=>x.PayState!=-1).Select(x => x.BuyerId).ToList();




                this.RepClientList.DataSource = bll_OA_CorporateClientsBLL.GetModelPageList(pa,
               CurrentUser.MemberId,
              "",
               null,
               null,
               "",
               BusinessManagerId,
               "",
               "",
               "",
               "",
               "",
               "",
               "",
               "",
               "",
               "",
               "",
               "",
               "",
               "",
               "",
               false,
               CurrentUser.TrueMemberId,
               CurrentUser.StaffId,
               "").Where(x => result.Contains(x.Keyid));
                this.RepClientList.DataBind();
            }


        }


        /// <summary>
        /// 设置查询参数方法
        /// </summary>
        /// <param name="target">设置目标</param>
        /// <param name="key">键</param>
        /// <param name="value">值</param>
        private static void SetParamValue(Dictionary<int, object> target, int key, object value)
        {
            if (string.IsNullOrEmpty(string.Format("{0}", value)))
                return;
            else
            {
            }

            if (target.ContainsKey(key))
            {
                target[key] = value;
            }
            else
            {
                target.Add(key, value);
            }
        }
    }
}

 CY_ECommercePlatform/CY.WebForm/Pages/business/xiaoshouyejiReprotKehu.aspx.designer.cs

New file
@@ -0,0 +1,44 @@
//------------------------------------------------------------------------------
// <自动生成>
//     此代码由工具生成。
//
//     对此文件的更改可能导致不正确的行为，如果
//     重新生成代码，则所做更改将丢失。
// </自动生成>
//------------------------------------------------------------------------------

namespace CY.WebForm.Pages.business
{


    public partial class xiaoshouyejiReprotKehu
    {

        /// <summary>
        /// CMSHead1 控件。
        /// </summary>
        /// <remarks>
        /// 自动生成的字段。
        /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::CY.WebForm.Pages.common.CMSHead CMSHead1;

        /// <summary>
        /// form1 控件。
        /// </summary>
        /// <remarks>
        /// 自动生成的字段。
        /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::System.Web.UI.HtmlControls.HtmlForm form1;

        /// <summary>
        /// RepClientList 控件。
        /// </summary>
        /// <remarks>
        /// 自动生成的字段。
        /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::System.Web.UI.WebControls.Repeater RepClientList;
    }
}