lyfz_repos/铂金版源码/LYFZ.Software.MainBusiness/OAShopManagement/frmCallCenterList.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;
using System.Collections;
using System.IO;
using LYFZ.ComponentLibrary;
using LYFZ.Helper;
using System.Web.UI.WebControls;
namespace LYFZ.Software.MainBusiness.OAShopManagement
{
    public partial class frmCallCenterList : LYFZ.Software.UI.OAShopManagement.frmCallCenterList
    {
        LYFZ.BLL.BLL_ErpOrder orbll = new BLL.BLL_ErpOrder();
        public frmCallCenterList()
        {
            LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.BindComboBoxTreeView_DepartmentAndEmployee(this.cbtCustomerSupportStaff, IsFirstNodeNull: true, IsShowAdmin: true);
            this.Load += frmCallCenterList_Load;
            this.btnClose.Click += btnClose_Click;
            this.btnSelect.Click += btnSelect_Click;
            this.btnAudioPlayback.Click += btnAudioPlayback_Click;
            this.comboBoxType.SelectedIndexChanged += comboBoxType_SelectedIndexChanged;
            this.Resize += frmCallCenterList_Resize;
            this.cbxConcreteMatters.SelectedIndexChanged += cbxConcreteMatters_SelectedIndexChanged;
            this.cbxTalkMode.SelectedIndexChanged += cbxTalkMode_SelectedIndexChanged;
            this.cbtCustomerSupportStaff.ComboBoxTree_NodeMouseClick += cbtCustomerSupportStaff_ComboBoxTree_NodeMouseClick;
            this.txtKey.KeyDown += txtKey_KeyDown;
        }
        /// <summary>
        /// 订单编号
        /// </summary>
        public string StrOrdNumber = "";
        /// <summary>
        /// 是否第一次加载运行
        /// </summary>
        bool IsFirstRun = true;
        /// <summary>
        /// 窗体加载事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void frmCallCenterList_Load(object sender, EventArgs e)
        {
            this.dateTimePickerStart.DateValue = SDateTime.Now.ToString("yyyy-MM-01");
            this.dateTimePickerEnd.DateValue = Convert.ToDateTime(this.dateTimePickerStart.DateValue).AddMonths(1).AddSeconds(-1).ToString("yyyy-MM-dd");
            this.PublicFunctionRows();
            this.IsFirstRun = false;
            this.frmCallCenterList_Resize(this, null);

            bool b = LYFZ.Software.MainBusiness.VersionControl.StaticVersion.UIFunctionVersion(VersionControl.VersionFunctionEnum.通话中心);
            if (!b)
            {
                this.Close();
                return;
            }
        }
        /// <summary>
        /// 关键字查询
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void txtKey_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
            { this.btnSelect_Click(this, null); }
        }
        /// <summary>
        /// 客服人员下拉框选择查询事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void cbtCustomerSupportStaff_ComboBoxTree_NodeMouseClick(object sender, TreeNodeMouseClickEventArgs e)
        {
            this.btnSelect_Click(this, null);
        }
        /// <summary>
        /// 通话方式下拉框选择查询事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void cbxTalkMode_SelectedIndexChanged(object sender, EventArgs e)
        {
            this.btnSelect_Click(this, null);
        }
        /// <summary>
        /// 具体事项下拉框选择查询事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void cbxConcreteMatters_SelectedIndexChanged(object sender, EventArgs e)
        {
            this.btnSelect_Click(this, null);
        }
        ListItem item;
        /// <summary>
        /// 选择下拉框
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void comboBoxType_SelectedIndexChanged(object sender, EventArgs e)
        {
            string selectValue = this.comboBoxType.SelectedItem.ToString();
            this.cbxConcreteMatters.Items.Clear();
            this.cbxConcreteMatters.Text = "";
            switch (selectValue)
            {
                case "流程把控":
                    item = new ListItem();
                    item.Text = "";
                    item.Value = "";
                    this.cbxConcreteMatters.Items.Add(item);
                    item = new ListItem();
                    item.Text = "已定未拍";
                    item.Value = "已定未拍";
                    this.cbxConcreteMatters.Items.Add(item);
                    item = new ListItem();
                    item.Text = "已拍未修";
                    item.Value = "已拍未修";
                    this.cbxConcreteMatters.Items.Add(item);
                    item = new ListItem();
                    item.Text = "已拍未选";
                    item.Value = "已拍未选";
                    this.cbxConcreteMatters.Items.Add(item);
                    item = new ListItem();
                    item.Text = "已修未选";
                    item.Value = "已修未选";
                    this.cbxConcreteMatters.Items.Add(item);
                    item = new ListItem();
                    item.Text = "已选未设计";
                    item.Value = "已选未设计";
                    this.cbxConcreteMatters.Items.Add(item);
                    item = new ListItem();
                    item.Text = "已选未发片";
                    item.Value = "已选未发片";
                    this.cbxConcreteMatters.Items.Add(item);
                    item = new ListItem();
                    item.Text = "已设计未看";
                    item.Value = "已设计未看";
                    this.cbxConcreteMatters.Items.Add(item);
                    item = new ListItem();
                    item.Text = "已看未发片";
                    item.Value = "已看未发片";
                    this.cbxConcreteMatters.Items.Add(item);
                    item = new ListItem();
                    item.Text = "已发未回件";
                    item.Value = "已发未回件";
                    this.cbxConcreteMatters.Items.Add(item);
                    item = new ListItem();
                    item.Text = "已回件未取";
                    item.Value = "已回件未取";
                    this.cbxConcreteMatters.Items.Add(item);
                    break;
                case "流程按排":
                    item = new ListItem();
                    item.Text = "";
                    item.Value = "";
                    this.cbxConcreteMatters.Items.Add(item);
                    item = new ListItem();
                    item.Text = "按排摄影拍照";
                    item.Value = "安排拍照";
                    this.cbxConcreteMatters.Items.Add(item);
                    item = new ListItem();
                    item.Text = "按排选片时间";
                    item.Value = "安排选片";
                    this.cbxConcreteMatters.Items.Add(item);
                    item = new ListItem();
                    item.Text = "按排取件时间";
                    item.Value = "安排取件";
                    this.cbxConcreteMatters.Items.Add(item);
                    break;
                case "业务咨询":
                    item = new ListItem();
                    item.Text = "";
                    item.Value = "";
                    this.cbxConcreteMatters.Items.Add(item);
                    item = new ListItem();
                    item.Text = "婚纱套系";
                    item.Value = "婚纱套系";
                    this.cbxConcreteMatters.Items.Add(item);
                    item = new ListItem();
                    item.Text = "写真套系";
                    item.Value = "写真套系";
                    this.cbxConcreteMatters.Items.Add(item);
                    item = new ListItem();
                    item.Text = "最新活动";
                    item.Value = "最新活动";
                    this.cbxConcreteMatters.Items.Add(item);
                    break;
                case "满意度调查":
                    item = new ListItem();
                    item.Text = "";
                    item.Value = "";
                    this.cbxConcreteMatters.Items.Add(item);
                    item = new ListItem();
                    item.Text = "回访接单";
                    item.Value = "回访接单";
                    this.cbxConcreteMatters.Items.Add(item);
                    item = new ListItem();
                    item.Text = "回访拍摄";
                    item.Value = "回访拍摄";
                    this.cbxConcreteMatters.Items.Add(item);
                    break;
                case "意向跟踪":
                    item = new ListItem();
                    item.Text = "";
                    item.Value = "";
                    this.cbxConcreteMatters.Items.Add(item);
                    item = new ListItem();
                    item.Text = "意向客户跟踪";
                    item.Value = "意向客户跟踪";
                    this.cbxConcreteMatters.Items.Add(item);
                    item = new ListItem();
                    item.Text = "溜单追回";
                    item.Value = "溜单追回";
                    this.cbxConcreteMatters.Items.Add(item);
                    break;
                case "关系维护":
                    item = new ListItem();
                    item.Text = "";
                    item.Value = "";
                    this.cbxConcreteMatters.Items.Add(item);
                    item = new ListItem();
                    item.Text = "结婚纪念祝福";
                    item.Value = "结婚纪念祝福";
                    this.cbxConcreteMatters.Items.Add(item);
                    item = new ListItem();
                    item.Text = "生日祝福";
                    item.Value = "生日祝福";
                    this.cbxConcreteMatters.Items.Add(item);
                    item = new ListItem();
                    item.Text = "节日问候";
                    item.Value = "节日问候";
                    this.cbxConcreteMatters.Items.Add(item);
                    break;
            }
            this.btnSelect_Click(this, null);
        }
        /// <summary>
        /// 录音回放
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void btnAudioPlayback_Click(object sender, EventArgs e)
        {
            MessageBoxCustom.Show("暂时没有通话录音！");
        }
        /// <summary>
        /// 查询按钮
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void btnSelect_Click(object sender, EventArgs e)
        {
            this.dgvGridview.ClearSelection();
            if (string.IsNullOrEmpty(this.txtKey.Text.Trim()) && !string.IsNullOrEmpty(this.StrOrdNumber))
            { this.StrOrdNumber = ""; }
            this.PublicFunctionRows();
        }
        /// <summary>
        /// 关闭
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void btnClose_Click(object sender, EventArgs e)
        {
            this.Close();
        }
        /// <summary>
        /// 窗体大小发生变化事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void frmCallCenterList_Resize(object sender, EventArgs e)
        {
            if (!this.IsFirstRun)
            {
                int ControlsWidth = 0;
                int ForCount = 0;
                for (int i = 0; i < this.flowLayoutPanel1.Controls.Count; i++)
                {
                    if (this.flowLayoutPanel1.Controls[i].Visible)
                    {
                        ForCount++;
                        ControlsWidth += this.flowLayoutPanel1.Controls[i].Width;
                    }
                }
                ControlsWidth += ForCount * 6;
                int strWidth = this.Width;
                int IntCount = ControlsWidth / strWidth;
                if ((ControlsWidth % strWidth) > 0)
                { IntCount++; }
                if (IntCount == 1)
                { this.flowLayoutPanel1.Height = 33; }
                else
                {
                    ControlsWidth += 110;
                    IntCount = ControlsWidth / strWidth;
                    if ((ControlsWidth % strWidth) > 0)
                    { IntCount++; }
                    if (IntCount == 2)
                    { this.flowLayoutPanel1.Height = 65; }
                    else
                    { this.flowLayoutPanel1.Height = 95; }
                }
            }
        }
        /// <summary>
        /// 创建行
        /// </summary>
        void PublicFunctionRows()
        {
            if (!string.IsNullOrEmpty(this.dateTimePickerStart.DateValue.Trim()) && string.IsNullOrEmpty(this.dateTimePickerStart.DateValue.Trim()))
            { MessageBoxCustom.Show("开始日期不能为空！"); return; }
            else if (string.IsNullOrEmpty(this.dateTimePickerStart.DateValue.Trim()) && !string.IsNullOrEmpty(this.dateTimePickerStart.DateValue.Trim()))
            { MessageBoxCustom.Show("结束日期不能为空！"); return; }
            if (string.IsNullOrEmpty(this.txtKey.Text.Trim()) && (string.IsNullOrEmpty(this.dateTimePickerStart.DateValue.Trim()) || string.IsNullOrEmpty(this.dateTimePickerStart.DateValue.Trim())))
            { MessageBoxCustom.Show("开始日期不能为空！"); return; }
            string StrWhere = "";
            if (!string.IsNullOrEmpty(this.txtKey.Text.Trim()) || !String.IsNullOrEmpty(this.StrOrdNumber))
            {
                if (!String.IsNullOrEmpty(this.StrOrdNumber))
                {
                    string StrSQL = "";
                    string StrText = "";
                    DataTable dt = orbll.GetView_Custom("select Cus_CustomerNumber,Cus_Name from tb_ErpCustomerGroupMembers Left Join tb_ErpCustomerGroup on GP_CustomerGroupID = GM_CustomerGroupID Left Join tb_ErpCustomer on Cus_CustomerNumber = GM_CustomerID where Cus_Type != '儿童' And Cus_CustomerNumber is not null And GP_OrderNumber = '" + StrOrdNumber + "'").Tables[0];
                    for (int i = 0; i < dt.Rows.Count; i++)
                    {
                        StrSQL += "'" + dt.Rows[i]["Cus_CustomerNumber"].ToString().Trim() + "',";
                        StrText += dt.Rows[i]["Cus_Name"].ToString().Trim() + ",";
                    }
                    this.txtKey.Text = StrText.TrimEnd(',');
                    if (!string.IsNullOrEmpty(StrSQL))
                    { StrWhere += " And Cus_CustomerNumber in (" + StrSQL.TrimEnd(',') + ")"; }
                }
                else
                { StrWhere += " And (Cus_Telephone like '%" + this.txtKey.Text.Trim() + "%' or Cus_Name like '%" + this.txtKey.Text.Trim() + "%')"; }
            }
            else
            {
                StrWhere += LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.GetDateTime("TR_TraceDateTime", this.dateTimePickerStart.DateValue.Trim(), this.dateTimePickerEnd.DateValue.Trim());
                if (!string.IsNullOrEmpty(this.comboBoxType.Text.Trim()))
                { StrWhere += " And TR_TraceType = '" + this.comboBoxType.Text.Trim() + "'"; }
                if (!string.IsNullOrEmpty(this.cbxConcreteMatters.Text.Trim()))
                {
                    item = cbxConcreteMatters.SelectedItem as ListItem;
                    StrWhere += " And TR_SpecificMatters = '" + item.Value.Trim() + "'";
                }
                if (!string.IsNullOrEmpty(this.cbxTalkMode.Text.Trim()))
                { StrWhere += " And TR_TraceWay = '" + this.cbxTalkMode.Text.Trim() + "'"; }
                if (!string.IsNullOrEmpty(this.cbtCustomerSupportStaff.Text.Trim()))
                { StrWhere += " And User_Name = '" + this.cbtCustomerSupportStaff.Text.Trim() + "'"; }
            }

            DataTable newTable = new DataTable();
            LYFZ.ComponentLibrary.FrmLoadHandling.LoadDoWorkMethod(delegate(object obj, BackgroundWorker backgroundWorker)
            {
                newTable = LYFZ.BLL.BLL_ErpOrderView.GetData_StoreManagementCallCenter(StrWhere);
            });
            this.dgvGridview.DataSource(newTable, strHideField: "AutoID,客户编号");
            this.dgvGridview.FillLastColumn();
        }
    }
}