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.SQLDAL;
using System.Data.SqlClient;

namespace CY.WebForm.Pages.business
{
    //吴辉
    //合作客户管理
    public partial class CorporateClientsList : 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_OrderBasicDAL bll_eC_OrderBasicDAL = null;
        //初始化
        public CorporateClientsList()
        {
            _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();
            bll_eC_OrderBasicDAL = new EC_OrderBasicDAL();
        }

        //页面加载
        protected void Page_Load(object sender, EventArgs e)
        {
            UCPager1.AspNetPager.PageChanged += AspNetPager1_PageChanged;
            if (!IsPostBack)
            {
                BindProvince();
                InitialSelectData();
                BindList();
                //InitialSelectData();
            }
           

            if (!string.IsNullOrEmpty(Request["delete"]))
            {
                OA_CorporateClients model = bll_OA_CorporateClientsBLL.GetModel(Request["delete"].ToGuid2());
                if (model != null && model.Keyid != null)
                {
                    if (bll_OA_CorporateClientsBLL.DeleteModel(model))
                        Response.Redirect("/Pages/business/CorporateClientsList.aspx");
                    else
                        JavaScript.MessageBox("删除失败", this);
                }
                else
                    JavaScript.MessageBox("删除失败", this);
            }

        }

        //加载查询条件
        protected void InitialSelectData()
        {
            this.selSourcesInfoId.DataSource = _Sys_DictionaryBLL.GetDataByType("客户来源");
            this.selSourcesInfoId.DataBind();
            this.selSourcesInfoId.Items.Insert(0, new ListItem("全部", ""));

            this.selCustomerIndustriesId.DataSource = _Sys_DictionaryBLL.GetDataByType("客户所属行业");
            this.selCustomerIndustriesId.DataBind();
            this.selCustomerIndustriesId.Items.Insert(0, new ListItem("全部", ""));

            this.selCustomerTypeId.DataSource = _Sys_DictionaryBLL.GetDataByType("客户类型");
            this.selCustomerTypeId.DataBind();
            this.selCustomerTypeId.Items.Insert(0, new ListItem("全部", ""));

            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.selAccountManagerId.DataSource = bll_OA_StaffBLL.SelectListByFirmId(CurrentUser.MemberId, false, true);
            this.selAccountManagerId.DataTextField = "Name";
            this.selAccountManagerId.DataValueField = "Keyid";
            this.selAccountManagerId.DataBind();
            this.selAccountManagerId.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.SelectedIndex=1;


        }

        //绑定列表
        private void BindList()
        {
            DateTime? beginTime = null;
            DateTime? endTime = null;
            Pagination pa = new Pagination();
            pa.PageSize = UCPager1.AspNetPager.PageSize;
            pa.PageIndex = UCPager1.AspNetPager.CurrentPageIndex;
            this.RepClientList.DataSource = bll_OA_CorporateClientsBLL.GetModelPageList(pa,
                CurrentUser.MemberId,
                this.txtquery_userName.Value,
                string.IsNullOrEmpty(this.txtRegTimeStart.Value) ? beginTime : Convert.ToDateTime(this.txtRegTimeStart.Value),
                string.IsNullOrEmpty(this.txtRegTimeEnd.Value) ? endTime : Convert.ToDateTime(this.txtRegTimeEnd.Value),
                this.selAccountManagerId.Value,
                this.selBusinessManagerId.Value,
                this.selCustomerIndustriesId.Value,
                this.selCustomerTypeId.Value,
                this.selDegreeImportanId.Value,
                this.selLastOrderTime.Value,
                this.selOrderCount.Value,
                this.selOrderMoney.Value,
                this.selSourcesInfoId.Value,
                this.selTurnoverIntentionId.Value,
                this.txtOrderCount.Value,
                this.txtOrderMoney.Value,
                this.txtUserNum.Value,
                this.txtLastOrderTime.Value,
                this.selectProvince.SelectedItem.Text.Replace("全部", ""), 
                this.selectCity.SelectedItem.Text.Replace("全部", ""), 
                this.selectCounty.SelectedItem.Text.Replace("全部", ""),
                (CurrentUser.TrueType == "员工"),
                CurrentUser.TrueMemberId,
                CurrentUser.StaffId,
                this.selShifouwanjie.Value,null,null, this.selHetongshangchuan.Value);
            foreach (var item in this.RepClientList.DataSource as IEnumerable<OA_CorporateClients>)
            {
                item.LessOrderMoneyProperty = item.Contractmoney-item.OrderMoney;
                var ssss = bll_eC_OrderBasicDAL.GetOrderById(item.Keyid, -1, CurrentUser.MemberId);
                item.NoOverOderCount = ssss.Count;
                if (ssss.Count > 0)
                {
                    string ids = "";

                    foreach(var c_OrderBasic in ssss)
                    {
                        ids += c_OrderBasic.Keyid + ",";
                    }
                    ids = ids.Trim(',');
                    var eC_OrderBasics = bll_eC_OrderBasicDAL.GetOrderByIds(ids);


                    item.Weishoukuanjine = eC_OrderBasics.Sum(x => x.UnPayedMoney);


                    var sssssss = item.Paytime;
                    var Paydays = item.Paydays.HasValue? item.Paydays.Value:0;
                    var Shifouwanjie = item.Shifouwanjie.HasValue ? item.Shifouwanjie.Value : 2;
                    item.Yuqijine = 0;
                    foreach (var eC_OrderBasic in eC_OrderBasics)
                    {
                        //判断订单是否逾期
                        var yuqi = false;
                        var ssdfsdf = eC_OrderBasic.CreateTime.Value.Date;

                        if(sssssss == 1)
                        {
                            // 步骤1：获取当前时间的“本月第一天”
                            DateTime currentMonthFirstDay = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1);

                           if(ssdfsdf < currentMonthFirstDay)
                            {
                                yuqi = true;
                            }
                        }
                        else if (sssssss == 2)
                        {
                            // 步骤1：提取日期的年份和月份（忽略时分秒）
                            int year = DateTime.Now.Year;
                            int month = DateTime.Now.Month;

                            // 步骤2：计算当前月份所属季度的起始月份（核心公式）
                            // 逻辑：(月份-1)/3 得到季度索引（0=Q1,1=Q2,2=Q3,3=Q4），再×3+1得到起始月
                            int quarterStartMonth = ((month - 1) / 3) * 3 + 1;

                            // 步骤3：组合成本季度第一天（仅日期，时分秒为00:00:00）
                            DateTime quarterFirstDay = new DateTime(year, quarterStartMonth, 1);
                            if (ssdfsdf < quarterFirstDay)
                            {
                                yuqi = true;
                            }
                        }
                        else if (sssssss == 3)
                        {
                            // 步骤1：提取日期的年份和月份（忽略时分秒）
                            int year = DateTime.Now.Year;
                            int month = DateTime.Now.Month;

                            // 判断所属半年，确定起始月份
                            int halfYearStartMonth = month <= 6 ? 1 : 7;

                            // 组合成本半年第一天（时分秒默认00:00:00）
                            DateTime halfYearFirstDay = new DateTime(year, halfYearStartMonth, 1);
                            if (ssdfsdf < halfYearFirstDay)
                            {
                                yuqi = true;
                            }
                        }
                        else if (sssssss == 4)
                        {
                            // 步骤1：提取日期的年份和月份（忽略时分秒）
                            int year = DateTime.Now.Year;
                            int month = DateTime.Now.Month;

                            // 核心逻辑：提取年份，直接构造1月1日
                            DateTime yearFirstDay = new DateTime(year, 1, 1);

                            if (ssdfsdf < yearFirstDay)
                            {
                                yuqi = true;
                            }
                        }
                        else if (sssssss == 5)
                        {
                            // 步骤1：提取日期的年份和月份（忽略时分秒）
                            int year = DateTime.Now.Year;
                            int month = DateTime.Now.Month;

                            DateTime semesterFirstDay;
                            if (month >= 3 && month <= 8)
                            {
                                // 3-8月：当年第一学期，首日=当年3月1日
                                semesterFirstDay = new DateTime(year, 3, 1);
                            }
                            else if (month >= 9 && month <= 12)
                            {
                                // 9-12月：当年第二学期，首日=当年9月1日
                                semesterFirstDay = new DateTime(year, 9, 1);
                            }
                            else // 1-2月
                            {
                                // 1-2月：上一年第二学期，首日=上一年9月1日
                                semesterFirstDay = new DateTime(year - 1, 9, 1);
                            }

                            if (ssdfsdf < semesterFirstDay)
                            {
                                yuqi = true;
                            }
                        }
                        else if (sssssss == 6)
                        {
                            if (Shifouwanjie == 1)
                            {
                                yuqi = true;
                            }
                        }
                        else if (sssssss == 7)
                        {
                            // 第二步：计算时间差，取Days属性（已取整），绝对值保证结果为正
                            TimeSpan timeSpan = DateTime.Now.Date.Subtract(ssdfsdf);

                            var  sss = Math.Abs(timeSpan.Days);

                            if (sss > Paydays)
                            {
                                yuqi = true;
                            }
                        }




                        if (yuqi)
                        {
                            if (eC_OrderBasic.UnPayedMoney >= 0)
                            {
                                item.Yuqijine += eC_OrderBasic.UnPayedMoney;
                            }
                        }  
                    }
                }
                

                

                

                Database DC = new Database();
                try
                {
                  
                    string sqlStr = string.Format("select  count(*) from [dbo].[OA_CorporateClientContract] where CorporateClientsid='{0}'", item.Keyid);
                    SqlCommand myCmd = new SqlCommand(sqlStr, DC.Connection);
                    item.ContractCount = (int)myCmd.ExecuteScalar();
                }
                catch (Exception)
                {

                    item.ContractCount = 0;
                }
                finally
                {
                    if (DC.Connection.State != System.Data.ConnectionState.Closed)
                        DC.Connection.Close();
                }
                item.Yanse = "";
               

                //if (item.Keyid == item.MemberId)
                //{
                //    item.Yanse = "green";
                //}
                //有到期时间的，到期前3个月变成红色（像人事管理那样）；
                if (item.Expiretype.HasValue && item.Expiretype == 1)
                {
                    if (item.ExpireTime.HasValue)
                    {
                        if (item.ExpireTime.Value < DateTime.Now.AddMonths(3))
                        {
                            item.Yanse = "red";
                        }
                    }

                }
               
                if (item.CreateTime.HasValue)
                {
                    //没有到期时间的，从建档时间起算，9个月后变成红色。
                    if (item.CreateTime.Value < DateTime.Now.AddMonths(-9))
                    {
                        item.Yanse = "red";
                    }
                    //建档后1个月没有下单，变成血红色。
                    if (item.CreateTime.Value < DateTime.Now.AddMonths(-1))
                    {
                        if (!item.OrderCount.HasValue || item.OrderCount.Value <= 0)
                        {
                            item.Yanse = "maroon";
                        }
                    }



                   
                }

            }
            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("全部", ""));
        }
    }
}