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 XiaoshoujixiaoList : BasePage { EC_OrderBLL bll_EC_OrderBLL = 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; public string hetongjine = ""; public string xiadanjine = ""; public string weixiadanjine = ""; public string huikuanjine = ""; public string weishoukuanjine = ""; public string hetongjineheji = ""; public string xiadanjineheji = ""; public string weixiadanjineheji = ""; public string huikuanjineheji = ""; public string weishoukuanjineheji = ""; //初始化 public XiaoshoujixiaoList() { _Sys_DictionaryBLL = new Sys_DictionaryBLL(); bll_EC_OrderBLL = new EC_OrderBLL(); bll_OA_StaffBLL = new OA_StaffBLL(); bll_OA_CustomerApplyBLL = new OA_CustomerApplyBLL(); bll_EC_MemberBasicBLL = new EC_MemberBasicBLL(); bll_Sys_CitySiteBLL = new Sys_CitySiteBLL(); } //页面加载 protected void Page_Load(object sender, EventArgs e) { UCPager1.AspNetPager.PageChanged += AspNetPager1_PageChanged; if (!IsPostBack) { BindProvince(); InitialSelectData(); BindList(); } } //加载查询条件 protected void InitialSelectData() { this.selDegreeImportanId.DataSource = _Sys_DictionaryBLL.GetDataByType("客户重要程度"); this.selDegreeImportanId.DataBind(); this.selDegreeImportanId.Items.Insert(0, new ListItem("全部", "")); this.selTurnoverIntentionId.DataSource = _Sys_DictionaryBLL.GetDataByType("客户信誉"); this.selTurnoverIntentionId.DataBind(); this.selTurnoverIntentionId.Items.Insert(0, new ListItem("全部", "")); //业务经理 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("全部", "")); //完结状态 this.selShifouwanjie.DataSource = _Sys_DictionaryBLL.GetDataByType("客户完结状态").OrderByDescending(x => x.MeanValue); this.selShifouwanjie.DataTextField = "Name"; this.selShifouwanjie.DataValueField = "MeanValue"; this.selShifouwanjie.DataBind(); this.selShifouwanjie.Items.Insert(0, new ListItem("全部", "")); this.selShifouwanjie.Value = "2"; } //绑定列表 private void BindList() { Pagination pa = new Pagination(); pa.PageSize = UCPager1.AspNetPager.PageSize; pa.PageIndex = UCPager1.AspNetPager.CurrentPageIndex; var oA_DeliverPlans = bll_EC_OrderBLL.GetxiaoshouchaxunList(pa, CurrentUser.MemberId, this.selectProvince.SelectedItem.Text.Replace("全部", ""), this.selectCity.SelectedItem.Text.Replace("全部", ""), this.selectCounty.SelectedItem.Text.Replace("全部", ""), this.selDegreeImportanId.Value, this.txtquery_userName.Value, this.selBusinessManagerId.Value, this.selTurnoverIntentionId.Value, this.selShifouwanjie.Value, this.selLastOrderTime.Value, this.selOrderCount.Value, this.selOrderMoney.Value, this.txtOrderCount.Value, this.txtOrderMoney.Value, this.txtLastOrderTime.Value ); var hetongjinedecimal = oA_DeliverPlans.Sum(x => x.Contractmoney) ?? 0; var xiadanjinedecimal = oA_DeliverPlans.Sum(x => x.SumPrice) ?? 0; var weixiadanjinedecimal = oA_DeliverPlans.Sum(x => x.UnorderMoney) ?? 0; var huikuanjinedecimal = oA_DeliverPlans.Sum(x => x.PayedMoney) ?? 0; hetongjine = hetongjinedecimal.ToString("F2"); xiadanjine = xiadanjinedecimal.ToString("F2"); weixiadanjine = weixiadanjinedecimal.ToString("F2"); huikuanjine = huikuanjinedecimal.ToString("F2"); weishoukuanjine = oA_DeliverPlans.Sum(x => x.UnPayedMoney).ToString("F2"); hetongjineheji = pa.heji1.Value.ToString("0.00"); ; xiadanjineheji = pa.heji2.Value.ToString("0.00"); ; weixiadanjineheji = pa.heji3.Value.ToString("0.00"); ; huikuanjineheji = pa.heji4.Value.ToString("0.00"); ; weishoukuanjineheji = (pa.heji5.HasValue ? pa.heji5.Value.ToString("0.00"):"0.00"); foreach ( var oA_DeliverPlan in oA_DeliverPlans) { if(oA_DeliverPlan.ExpiretypeName == "日期") { oA_DeliverPlan.ExpiretypeName = oA_DeliverPlan.ExpireTime.HasValue ? oA_DeliverPlan.ExpireTime.Value.ToString("yyyy-MM-dd") : ""; } if(oA_DeliverPlan.ContracttypeName == "金额") { oA_DeliverPlan.ContracttypeName = oA_DeliverPlan.Contractmoney.HasValue ? oA_DeliverPlan.Contractmoney.Value.ToString("F2") : "0.00"; } } this.RepClientList.DataSource = oA_DeliverPlans; 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 BindProvince() { this.selectProvince.Items.Clear(); if (CurrentUser.TrueType == "员工") this.selectProvince.DataSource = bll_Sys_CitySiteBLL.SelectStaffManageProvinceList(CurrentUser.TrueMemberId); else this.selectProvince.DataSource = bll_Sys_CitySiteBLL.SelectAllNextModel(0, 0, 1); this.selectProvince.DataTextField = "Name"; this.selectProvince.DataValueField = "Keyid"; this.selectProvince.DataBind(); this.selectProvince.Items.Insert(0, new ListItem("全部", "")); this.selectCity.Items.Insert(0, new ListItem("全部", "")); this.selectCounty.Items.Insert(0, new ListItem("全部", "")); } //改变省绑定市 protected void ChangeProvince(object sender, EventArgs e) { this.selectCity.Items.Clear(); this.selectCounty.Items.Clear(); Sys_CitySite m_Sys_CitySite = bll_Sys_CitySiteBLL.GetModelByKeyid(this.selectProvince.SelectedValue.ToInt32() ?? 0); if (m_Sys_CitySite != null) { if (CurrentUser.TrueType == "员工") this.selectCity.DataSource = bll_Sys_CitySiteBLL.SelectStaffManageCityList(m_Sys_CitySite.Keyid, CurrentUser.TrueMemberId); else this.selectCity.DataSource = bll_Sys_CitySiteBLL.SelectAllNextModel(m_Sys_CitySite.Keyid, 0, 2); this.selectCity.DataTextField = "Name"; this.selectCity.DataValueField = "Keyid"; this.selectCity.DataBind(); } this.selectCity.Items.Insert(0, new ListItem("全部", "")); this.selectCounty.Items.Insert(0, new ListItem("全部", "")); } //改变市绑定区 protected void ChangeCity(object sender, EventArgs e) { this.selectCounty.Items.Clear(); Sys_CitySite m_Sys_CitySite = bll_Sys_CitySiteBLL.GetModelByKeyid(this.selectCity.SelectedValue.ToInt32() ?? 0); if (m_Sys_CitySite != null) { if (CurrentUser.TrueType == "员工") this.selectCounty.DataSource = bll_Sys_CitySiteBLL.SelectStaffManageCountryList(m_Sys_CitySite.ProvinceId, m_Sys_CitySite.Keyid, CurrentUser.TrueMemberId); else this.selectCounty.DataSource = bll_Sys_CitySiteBLL.SelectProxyNextModel(m_Sys_CitySite.ProvinceId, m_Sys_CitySite.Keyid, 3); this.selectCounty.DataTextField = "Name"; this.selectCounty.DataValueField = "Keyid"; this.selectCounty.DataBind(); } this.selectCounty.Items.Insert(0, new ListItem("全部", "")); } } }