lyfz_repos/铂金版源码/LYFZ.Software.MainBusiness/SMSManagement/ShortSmsMessage/FrmHigehrSelect.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace LYFZ.Software.MainBusiness.SMSManagement.ShortSmsMessage
{
    public partial class FrmHigehrSelect : LYFZ.Software.UI.SMSManagement.ShortSmsMessage.FrmHigehrSelect
    {
        public FrmHigehrSelect()
        {
            this.Shown += FrmHigehrSelect_Shown;
            this.btnOk.Click += btnOk_Click;
            this.btnCanle.Click += btnCanle_Click;

            this.rdoAll.Click += rdoAll_Click;
            this.rdoHunsa.Click += rdoHunsa_Click;
            this.rdoErtong.Click += rdoErtong_Click;
            this.rdoXiezheng.Click += rdoXiezheng_Click;
            this.rdoqita.Click += rdoqita_Click;
            BindCategory();
            SetGrpEnabled(-1);
            this.rdoanshenri.Click += rdoanshenri_Click;
            this.rdoanhungqi.Click += rdoanhungqi_Click;
            CurrentBusinessType = LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.GetBusinessType();
            SetShowSmsTpye();
        }

        /// <summary>
        /// 当前软件业务类型
        /// </summary>
        LYFZ.Software.MainBusiness.EnumPermissions.BusinessType CurrentBusinessType = EnumPermissions.BusinessType.旗舰版;
        /// <summary>
        /// 根据软件业务版本设置显示客户类型
        /// </summary>
        void SetShowSmsTpye()
        {
            switch (CurrentBusinessType)
            {
                case EnumPermissions.BusinessType.婚纱版:
                    this.rdoErtong.Visible = false;
                    break;
                case EnumPermissions.BusinessType.儿童版:
                    this.rdoHunsa.Visible = false;
                    break;
            }
        }

        void rdoanhungqi_Click(object sender, EventArgs e)
        {
            this.grpNianLing.Enabled = false;
             this.numShuiA.Value=0;
            this.numShuiZ.Value=0;
            this.numTianA.Value = 0;
            this.numTianZ.Value = 0;
        }

        void rdoanshenri_Click(object sender, EventArgs e)
        {
            this.grpNianLing.Enabled = true;
        }
        SQueryObject currentQueryObject = new SQueryObject();
        /// <summary>
        /// 当前查询对象
        /// </summary>
        public SQueryObject CurrentQueryObject
        {
            get { return currentQueryObject; }
            set { currentQueryObject = value; }
        }

        void rdoqita_Click(object sender, EventArgs e)
        {
            SetGrpEnabled(Convert.ToInt32(rdoqita.Tag));
        }
        void rdoXiezheng_Click(object sender, EventArgs e)
        {
            SetGrpEnabled(Convert.ToInt32(rdoXiezheng.Tag));
        }

        void rdoErtong_Click(object sender, EventArgs e)
        {
            SetGrpEnabled(Convert.ToInt32(rdoErtong.Tag));
        }

        void rdoHunsa_Click(object sender, EventArgs e)
        {
            SetGrpEnabled(Convert.ToInt32(rdoHunsa.Tag));
        }

        void rdoAll_Click(object sender, EventArgs e)
        {
            SetGrpEnabled(Convert.ToInt32(rdoAll.Tag));
        }
        void SetGrpEnabled(int type) {
            if (type < 0)
            {
                this.grpJilianri.Enabled = false;
                this.grpNianLing.Enabled = false;
                this.rdoanhungqi.Visible = false;
                this.cmbAnhungqi.Visible = false;
                this.numShuiA.Value = 0;
                this.numShuiZ.Value = 0;
                this.numTianA.Value = 0;
                this.numTianZ.Value = 0;
                this.cmbAnshenri.SelectedItem = PressMemorialDay.不限.ToString();
                this.cmbAnhungqi.SelectedItem = PressMemorialDay.不限.ToString();
            }
            else {
                this.grpJilianri.Enabled = true;
                this.grpNianLing.Enabled = true;
                if (type == 0)
                {
                    this.rdoanhungqi.Visible = true;
                    this.cmbAnhungqi.Visible = true;
                }
                else {
                    this.rdoanhungqi.Visible = false;
                    this.cmbAnhungqi.Visible = false;
                }
            }
            this.CurrentQueryObject.QCustomerType = (SQueryCustomerType)type;
            if (this.CurrentQueryObject.QCustomerType != SQueryCustomerType.婚纱客户)
            {
                this.rdoanshenri.Checked = true;
                this.cmbAnhungqi.SelectedItem = PressMemorialDay.不限.ToString();
            }
            
        }

        public string Pak_PackagesClass;
        public string Price1;
        public string Price2;
        LYFZ.BLL.BLL_ErpSystemCategory scbll = new BLL.BLL_ErpSystemCategory();

        void BindCategory()
        {
            try
            {
                #region 套系类别
                LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.BindComboBoxTreeView_PackagesCategoryAndName(this.CtvPak_PackagesClass, "AAAAAAB", true);
                this.CtvPak_PackagesClass.IsSelectParentNode = true;
                #endregion
                #region 订单类别
                LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.BindComboBoxTreeView_SystemCategory("BFAGAHBFDGCABAJIH", this.cmbtreevOrdeClass, true);
                this.cmbtreevOrdeClass.IsSelectParentNode = true;
                #endregion
                #region 客户来源
                LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.BindComboBoxTreeView_SystemCategory("AAAAAAF", this.cmbtreevCustomerSource, true);
                this.cmbtreevCustomerSource.IsSelectParentNode = true;
                #endregion

                #region 客户地区
                DataTable tbl = new DataTable();
                tbl = scbll.GetList(" Sc_ClassParentID = '" + scbll.GetList("Sc_ClassCode='AAAAAAC'").Tables[0].Rows[0]["ID"].ToString().Trim() + "'").Tables[0];
                this.cmbCus_Region.Items.Add("");

                if (tbl.Rows.Count > 0)
                {
                    for (int i = 0; i < tbl.Rows.Count; i++)
                    {
                        this.cmbCus_Region.Items.Add(tbl.Rows[i]["Sc_ClassName"].ToString().Trim());
                    }
                }

                #endregion

                this.cmbAnshenri.DataSource = Enum.GetNames(typeof(PressMemorialDay));
                this.cmbAnhungqi.DataSource = Enum.GetNames(typeof(PressMemorialDay));
               
            }
            catch (Exception ex)
            {

                MessageBoxCustom.Show(ex.Message);
            }
        }

        #region 加载
        protected  void FrmHigehrSelect_Shown(object sender, EventArgs e)
        {
            
        }
        #endregion

    

       
        #region 取消
        protected  void btnCanle_Click(object sender, EventArgs e)
        {
            this.Close();
        }
        #endregion
        /// <summary>
        /// 获取查询表名
        /// </summary>
        /// <returns></returns>
        string GetSQueryTableName()
        {
            string tableName = "Vw_OrderCustomerList";//Vw_PersonalCustomerList
            if (this.grpJilianri.Enabled)
            {

                if (this.CurrentQueryObject.QCustomerType == SQueryCustomerType.婚纱客户
                    || this.CurrentQueryObject.QCustomerType == SQueryCustomerType.写真客户
                    || this.CurrentQueryObject.QCustomerType == SQueryCustomerType.其它客户)  
                {
                    if (
                        (this.rdoanshenri.Checked && GetPressMemorialDay(this.cmbAnshenri.Text) != PressMemorialDay.不限)
                        || (this.rdoanshui.Checked && this.numShuiZ.Value > 0 && this.numShuiA.Value <= this.numShuiZ.Value)
                        || (this.rdoantian.Checked && this.numTianZ.Value > 0 && this.numTianA.Value <= this.numTianZ.Value)
                        || this.cmbCus_Region.Text.Trim().Length>0
                        )
                    {
                        tableName = "Vw_PersonalCustomerList";
                    }
                }
            }
            return tableName;
        }
        /// <summary>
        /// 获取查询条件语句
        /// </summary>
        /// <returns></returns>
        string GetQueryWhereString()
        {
            string retWhereString = "1=1 ";
            //套系类别
            string Ord_PhotographyCategory = GetPackagesClass(this.CtvPak_PackagesClass.TreeView.SelectedNode);
            //套系名称
            string Ord_SeriesName = GetPackagesName(this.CtvPak_PackagesClass.TreeView.SelectedNode);
            //订单类别
            string Ord_OrderClass = GetTreeNodeAllNode(this.cmbtreevOrdeClass.TreeView.SelectedNode);
            //客户来源
            string Ord_CustomerSource = GetTreeNodeAllNode(this.cmbtreevCustomerSource.TreeView.SelectedNode);
            if (Ord_PhotographyCategory.Trim().Length > 0)
            {
                retWhereString += " and (Ord_PhotographyCategory='" + Ord_PhotographyCategory.Replace(",", "' or Ord_PhotographyCategory = '") + "')";
            }
            if (Ord_SeriesName.Trim().Length > 0)
            {
                retWhereString += " and (Ord_SeriesName='" + Ord_SeriesName.Trim() + "')";
            }
            if (Ord_OrderClass.Trim().Length > 0)
            {
                retWhereString += " and (Ord_OrderClass='" + Ord_OrderClass.Replace(",", "' or Ord_OrderClass = '") + "')";
            }
            if (Ord_CustomerSource.Trim().Length > 0)
            {
                retWhereString += " and (Ord_CustomerSource='" + Ord_CustomerSource.Replace(",", "' or Ord_CustomerSource = '") + "')";
            }
            switch (this.CurrentQueryObject.QCustomerType)
            {
                case SQueryCustomerType.婚纱客户:
                    retWhereString += " and Ord_Type='0' ";
                    break;
                case SQueryCustomerType.儿童客户:
                    retWhereString += " and Ord_Type='1' ";
                    break;
                case SQueryCustomerType.写真客户:
                    retWhereString += " and (Ord_Type='2')";
                    break;
                case SQueryCustomerType.其它客户:
                    retWhereString += " and (Ord_Type='3')";
                    break;
            }
            if (this.cmbCus_Region.Text.Trim().Length > 0)
            {
                retWhereString += " and (Cus_Region like '%" + this.cmbCus_Region.Text.Trim() + "%')";
               
            }

            //消费金额 yingFuPrice
           // int yingFuPrice = this.numTaoxijiageA.Value;
            if (this.numTaoxijiageZ.Value > 0 && this.numTaoxijiageA.Value <= this.numTaoxijiageZ.Value)
            {
                retWhereString += " and (yingFuPrice>=" +Convert.ToInt32(this.numTaoxijiageA.Value).ToString() + " and yingFuPrice<=" + Convert.ToInt32(this.numTaoxijiageZ.Value).ToString() + ") ";
            }

            //预约时间的起始时间
            DateTime appointmentTimeA = LYFZ.WinAPI.CustomPublicMethod.GetNullDateTime();
            //预约时间的结束时间
            DateTime appointmentTimeZ = LYFZ.WinAPI.CustomPublicMethod.GetNullDateTime();
            DateTime.TryParse(this.txtyuyueshijianA.Text.Trim(), out appointmentTimeA);
            DateTime.TryParse(this.txtyuyueshijianZ.Text.Trim(), out appointmentTimeZ);

            if (appointmentTimeZ>LYFZ.WinAPI.CustomPublicMethod.GetNullDateTime()&&appointmentTimeA <= appointmentTimeZ)
            {
                retWhereString += " and (Ord_CreateDateTime>='" + appointmentTimeA.ToString("yyyy-MM-dd") + "' and Ord_CreateDateTime<='" + appointmentTimeZ.ToString("yyyy-MM-dd") + "') ";
            }

            if (this.grpJilianri.Enabled)
            {
                PressMemorialDay anShenri=(PressMemorialDay)Enum.Parse(typeof(PressMemorialDay),this.cmbAnshenri.Text);
                int day = (int)anShenri;
                if (this.rdoanshenri.Checked && anShenri!= PressMemorialDay.不限)
                {
                    if (anShenri == PressMemorialDay.今天)
                    {
                        retWhereString += " and GregorianCalendar_NowYearBirthday ='" + SDateTime.Now.ToString("yyyy-MM-dd") + "' ";
                    }
                    else {
                        retWhereString += " and (GregorianCalendar_NowYearBirthday >='" + SDateTime.Now.ToString("yyyy-MM-dd") + "' and GregorianCalendar_NowYearBirthday<='" + SDateTime.Now.AddDays(day).ToString("yyyy-MM-dd") + "') ";
                    }
                }

                PressMemorialDay anHunQi = (PressMemorialDay)Enum.Parse(typeof(PressMemorialDay), this.cmbAnhungqi.Text);
                int hqiday = (int)anHunQi;
                if (this.rdoanhungqi.Checked && this.rdoanhungqi.Visible && anHunQi != PressMemorialDay.不限)
                {
                    if (anHunQi == PressMemorialDay.今天)
                    {
                        retWhereString += " and GregorianCalendar_NowYearDayForMarriage ='" + SDateTime.Now.ToString("yyyy-MM-dd") + "' ";
                    }
                    else
                    {
                        retWhereString += " and (GregorianCalendar_NowYearDayForMarriage >='" + SDateTime.Now.ToString("yyyy-MM-dd") + "' and GregorianCalendar_NowYearDayForMarriage<='" + SDateTime.Now.AddDays(hqiday).ToString("yyyy-MM-dd") + "') ";
                    }
                }
            }

            if (this.grpNianLing.Enabled)
            {
                if (this.rdoanshui.Checked && this.numShuiZ.Value > 0 && this.numShuiA.Value <= this.numShuiZ.Value)
                {
                    retWhereString += " and (Age_Year>=" + Convert.ToInt32(this.numShuiA.Value).ToString() + " and Age_Year<=" + Convert.ToInt32(this.numShuiZ.Value).ToString()  + ") ";
                }
                else if (this.rdoantian.Checked && this.numTianZ.Value > 0 && this.numTianA.Value <= this.numTianZ.Value)
                {
                    retWhereString += " and (Age_Day>=" + Convert.ToInt32(this.numTianA.Value).ToString() + " and Age_Day<=" + Convert.ToInt32(this.numTianZ.Value).ToString() + ") ";
                }
            }
           	

            return retWhereString;
        }
        /// <summary>
        /// 获取当前节点和所有子节点值
        /// </summary>
        /// <param name="node"></param>
        /// <returns></returns>
        string GetTreeNodeAllNode(TreeNode node)
        {
            string ret = "";
            if (node != null)
            {
                ret = node.Text.Trim();
                if (node.Nodes.Count > 0)
                {
                    foreach (TreeNode n in node.Nodes)
                    {
                            ret += "," + GetPackagesClass(n);
                    }
                }
            }
            return ret.Trim().Trim(',');
        }

        /// <summary>
        /// 获取套系类别
        /// </summary>
        /// <returns></returns>
        string GetPackagesClass(TreeNode node)
        {
            string ret = "";
            if (node != null)
            {
                if (node.Name.Trim() == "true")
                {
                    ret = node.Text.Trim();
                    if (node.Nodes.Count > 0)
                    {
                        foreach (TreeNode n in node.Nodes)
                        {
                            if (n.Name.Trim() == "true")
                                ret += "," + GetPackagesClass(n);
                        }
                    }
                }
            }
            return ret.Trim().Trim(',');
        }
        /// <summary>
        /// 获取套系名称
        /// </summary>
        /// <returns></returns>
        string GetPackagesName(TreeNode node)
        {
            string ret = "";
            if (node != null)
            {
                if (node.Name.Trim() != "true")
                {
                    ret = node.Text.Trim();

                }
            }
            return ret.Trim();
        }
        /// <summary>
        /// 获取纪念日
        /// </summary>
        /// <param name="text"></param>
        /// <returns></returns>
        PressMemorialDay GetPressMemorialDay(string text)
        {
            return (PressMemorialDay)Enum.Parse(typeof(PressMemorialDay), text);
        }

        #region 确定
        protected  void btnOk_Click(object sender, EventArgs e)
        {
         // this.CurrentQueryObject(Vw_OrderCustomerList)
            if (this.numTaoxijiageA.Value > this.numTaoxijiageZ.Value)
            {
                MessageBoxCustom.Show("消费金额的起始值不能大于结束值");
                return;
            }
            //预约时间的起始时间
            DateTime appointmentTimeA=LYFZ.WinAPI.CustomPublicMethod.GetNullDateTime();
            //预约时间的结束时间
            DateTime appointmentTimeZ = LYFZ.WinAPI.CustomPublicMethod.GetNullDateTime();

            if (this.txtyuyueshijianA.Text.Trim().Length>0&&!DateTime.TryParse(this.txtyuyueshijianA.Text.Trim(), out appointmentTimeA))
            {
                MessageBoxCustom.Show("预约时间的起始时间格式不正确");
                return;
            }
            if (this.txtyuyueshijianZ.Text.Trim().Length > 0 && !DateTime.TryParse(this.txtyuyueshijianZ.Text.Trim(), out appointmentTimeZ))
            {
                MessageBoxCustom.Show("预约时间的结束时间格式不正确");
                return;
            }
            if (appointmentTimeA > appointmentTimeZ)
            {
                MessageBoxCustom.Show("预约时间的起始时间不能大于结束时间");
                return;
            }

            if (this.grpNianLing.Enabled)
            {
                if (this.rdoanshui.Checked)
                {
                    if (this.numShuiA.Value > this.numShuiZ.Value)
                    {
                        MessageBoxCustom.Show("年龄起始值不能大于结束值");
                        return;
                    }
                }
                else if (this.rdoantian.Checked)
                {
                    if (this.numTianA.Value > this.numTianA.Value)
                    {
                        MessageBoxCustom.Show("起始天数不能大于结束天数");
                        return;
                    }
                }
            }
            this.CurrentQueryObject.SQueryTableName = GetSQueryTableName();
            this.CurrentQueryObject.SQueryWhereString = GetQueryWhereString();

          //  MessageBoxCustom.Show(this.CurrentQueryObject.SQueryWhereString);
            this.DialogResult = System.Windows.Forms.DialogResult.OK;
        }
        #endregion

        
    }
    /// <summary>
    /// 按纪念日
    /// </summary>
  public  enum PressMemorialDay
    { 
        不限=-1,
        今天=0,
        近两天=2,
        近三天 = 3,
        近五天 = 5,
        近七天 = 7,
        近十天 = 10,
        近十五天 = 15,
        近一个月 = 30,
        近三个月 = 90,
        近半年 = 180,
    }
    /// <summary>
    /// 查询客户类型
    /// </summary>
  public enum SQueryCustomerType
  { 
      全部=-1,
      婚纱客户=0,
      儿童客户=1,
      写真客户=2,
      其它客户 = 3
  }
    /// <summary>
    /// 查询对象
    /// </summary>
  public class SQueryObject
  {
      public SQueryObject() { 
         
      }

      string _SQueryTableName = "";
      /// <summary>
      /// 查询表名
      /// </summary>
      public string SQueryTableName
      {
          get { return _SQueryTableName; }
          set { _SQueryTableName = value; }
      }

      string _SQueryWhereString = "";
      /// <summary>
      /// 查询条件语句
      /// </summary>
      public string SQueryWhereString
      {
          get { return _SQueryWhereString; }
          set { _SQueryWhereString = value; }
      }

      SQueryCustomerType _QCustomerType = SQueryCustomerType.全部;
      /// <summary>
      /// 查询的客户类型
      /// </summary>
      public SQueryCustomerType QCustomerType
      {
          get { return _QCustomerType; }
          set { _QCustomerType = value; }
      }

  }
}