lyfz_repos/铂金版源码/LYFZ.Software.MainBusiness/DoorCityProcess/ClientServiceArrangementFormMain.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.DoorCityProcess
{
    public partial class ClientServiceArrangementFormMain : LYFZ.Software.UI.DoorCityProcess.ClientServiceArrangementFormMain
    {
        LYFZ.BLL.BLL_ErpOrder orbll = new BLL.BLL_ErpOrder();
        LYFZ.BLL.BLL_ErpClientServiceTask cstbll = new BLL.BLL_ErpClientServiceTask();
        public ClientServiceArrangementFormMain()
        {
            this.Load += ClientServiceArrangementFormMain_Load;
            this.Shown += ClientServiceArrangementFormMain_Shown;
            this.Resize += ClientServiceArrangementFormMain_Resize;
            this.btnQuery.Click += btnQuery_Click;
            this.btnTaskAnPai.Click += btnTaskAnPai_Click;
            this.btnTaskStatistics.Click += btnTaskStatistics_Click;
            this.btnTaskUpdate.Click += btnTaskUpdate_Click;
            this.btnTaskEcex.Click += btnTaskEcex_Click;
            this.btnCloseed.Click += btnCloseed_Click;
            this.cmbtreevTaskType.ComboBoxTree_NodeMouseClick += cmbtreevTaskType_ComboBoxTree_NodeMouseClick;
            this.tabControlEx1.SelectedIndexChanged += tabControlEx1_SelectedIndexChanged;
        }

        /// <summary>
        /// 员工编号
        /// </summary>
        string StrUserID = LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.LoginUserModel.User_EmployeeID;
        /// <summary>
        /// 窗体加载事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void ClientServiceArrangementFormMain_Load(object sender, EventArgs e)
        {
            this.btnTaskAnPai.Enabled = LYFZ.BLL.BLL_ErpUser.GetRights(LYFZ.BLL.BLL_ErpUser.CurrentUserRights.StoresClientService, CustomAttributes.OperatingAuthority.ClientServiceTaskAnPai);
            this.btnTaskUpdate.Enabled = this.btnTaskAnPai.Enabled;

            this.dtDateTimeStart.DateValue = SDateTime.Now.AddMonths(-1).ToString("yyyy-MM-01");
            this.dtDateTimeEnd.DateValue = SDateTime.Now.ToString("yyyy-MM-dd");
            this.panelDateTime.Visible = false;
            this.cmbtreevTaskItem.Enabled = false;
            LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.BindComboxTreeView(this.cmbtreevTaskType, StrBindData: "全部," + LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.GetTaskItem());
            this.cmbtreevTaskType.TextFindTag("全部");
        }
        /// <summary>
        /// 窗体加载事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void ClientServiceArrangementFormMain_Shown(object sender, EventArgs e)
        {
            //LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.BindComboBoxTreeView_DepartmentAndEmployee(this.cmbtreevClientServicePerson, IsFirstNodeNull: true, IsFirstNodeName: "全部", IsShowResign: false);
            this.BindComboBoxTreeViewPerson(0);
            if (!LYFZ.BLL.BLL_ErpUser.IsAdministrator())
            {
                this.cmbtreevClientServicePerson.TagFindText(StrUserID);
                this.cmbtreevClientServicePerson.Enabled = false;
                //this.tabPage_TimeoutCompleted.Parent = null;
                //this.tabPage_Completed.Parent = null;
                this.cmbtreevClientServicePerson.Text = LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.LoginUserModel.User_Name;
            }
            else
            { this.cmbtreevClientServicePerson.TextFindTag("全部"); }
            this.PublicFunctionRows();

            bool b = LYFZ.Software.MainBusiness.VersionControl.StaticVersion.UIFunctionVersion(VersionControl.VersionFunctionEnum.客服中心客服安排);
            if (!b)
            {
                this.Close();
            }
        }
        /// <summary>
        /// 获取人员
        /// </summary>
        /// <param name="IndexCount"></param>
        void BindComboBoxTreeViewPerson(int IndexCount)
        {
            this.cmbtreevClientServicePerson.Nodes.Clear();
            string StrWhere = "User_Name is not null";
            switch (IndexCount)
            {
                case 0:
                    StrWhere += " And Cst_CompletionIntStatus = 0";
                    break;
                case 1:
                    StrWhere += " And Cst_CompletionIntStatus = 0 And (Cst_TaskTermTime+1) < getdate()";
                    break;
                case 2:
                    StrWhere += " And Cst_CompletionIntStatus = 1 And Cst_TaskTermTime < Cst_CompletionTime";
                    break;
                case 3:
                    StrWhere += " And Cst_CompletionIntStatus = 1";
                    break;
            }
            DataTable dt = orbll.GetView_Custom("tb_ErpClientServiceTask Left Join tb_ErpUser on User_EmployeeID = Cst_ServicePerson", StrWhere: StrWhere, ShowColumnName: "Cst_ServicePerson,User_Name", GroupBy: "Cst_ServicePerson,User_Name").Tables[0];
            TreeNode root = null;
            root = new TreeNode();
            root.Text = "全部";
            root.Tag = "";
            root.Name = "";
            this.cmbtreevClientServicePerson.Nodes.Add(root);
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                root = new TreeNode();
                root.Text = dt.Rows[i]["User_Name"].ToString().Trim();
                root.Tag = dt.Rows[i]["Cst_ServicePerson"].ToString().Trim();
                root.Name = dt.Rows[i]["Cst_ServicePerson"].ToString().Trim();
                this.cmbtreevClientServicePerson.Nodes.Add(root);
            }
        }
        /// <summary>
        /// 窗体大小发生变化
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void ClientServiceArrangementFormMain_Resize(object sender, EventArgs e)
        {
            switch (this.btnQuery.Location.Y)
            {
                case 3:
                    this.flowLayoutPanel1.Height = 38;
                    break;
                case 38:
                    this.flowLayoutPanel1.Height = 72;
                    break;
                case 73:
                    this.flowLayoutPanel1.Height = 107;
                    break;
            }
        }
        /// <summary>
        /// 查询
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void btnQuery_Click(object sender, EventArgs e)
        {
            this.PublicFunctionRows();
        }
        /// <summary>
        /// 任务安排
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void btnTaskAnPai_Click(object sender, EventArgs e)
        {
            LYFZ.Software.MainBusiness.DoorCityProcess.SetSmallForm.ClientServiceTaskStatisticsSmallForm frm = new SetSmallForm.ClientServiceTaskStatisticsSmallForm();
            frm.IsWorkAnPai = true;
            frm.Location = new Point(LYFZ.EnumPublic.FormLocation_X, LYFZ.EnumPublic.FormLocation_Y);
            frm.Size = new System.Drawing.Size(LYFZ.EnumPublic.FormSize_Width, LYFZ.EnumPublic.FormSize_Height);
            frm.StartPosition = FormStartPosition.Manual;
            frm.ShowDialog();
        }
        /// <summary>
        /// 任务统计
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void btnTaskStatistics_Click(object sender, EventArgs e)
        {
            LYFZ.Software.MainBusiness.DoorCityProcess.SetSmallForm.ClientServiceTaskStatisticsSmallForm frm = new SetSmallForm.ClientServiceTaskStatisticsSmallForm();
            frm.IsWorkAnPai = false;
            frm.Location = new Point(LYFZ.EnumPublic.FormLocation_X, LYFZ.EnumPublic.FormLocation_Y);
            frm.Size = new System.Drawing.Size(LYFZ.EnumPublic.FormSize_Width, LYFZ.EnumPublic.FormSize_Height);
            frm.StartPosition = FormStartPosition.Manual;
            frm.ShowDialog();
        }
        /// <summary>
        /// 任务修改
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void btnTaskUpdate_Click(object sender, EventArgs e)
        {
            if (this.dgvData.SelectedRows.Count > 0)
            {
                LYFZ.Model.ClientServiceTaskAnPaiModel model = new Model.ClientServiceTaskAnPaiModel();
                model.StrDateTime = this.dgvData.CurrentRow.Cells["任务时间"].Value.ToString().Trim();
                model.StrRemark = this.dgvData.CurrentRow.Cells["任务说明"].Value.ToString().Trim();
                model.StrUserName = this.dgvData.CurrentRow.Cells["客服人员"].Value.ToString().Trim();
                LYFZ.Software.MainBusiness.DoorCityProcess.SetSmallForm.ClientServiceTaskAnPaiSmallForm frm = new SetSmallForm.ClientServiceTaskAnPaiSmallForm();
                frm.model = model;
                frm.ShowDialog();
                if (frm.IsSaveed)
                {
                    model = frm.model;
                    DataTable dt = orbll.GetView_Custom("tb_ErpClientServiceTask", StrWhere: "ID = '" + this.dgvData.CurrentRow.Cells["ID"].Value.ToString().Trim() + "'", ShowColumnName: "*").Tables[0];
                    LYFZ.Model.Model_ErpClientServiceTask modelCst = cstbll.DataRowToModel(dt.Rows[0]);
                    modelCst.Cst_TaskTermTime = Convert.ToDateTime(model.StrDateTime);
                    modelCst.Cst_ServicePerson = model.StrUserID;
                    modelCst.Cst_TaskRemark = model.StrRemark;
                    if (cstbll.Update(modelCst))
                    {
                        MessageBoxCustom.Show("安排成功！");
                        int SelectIndex = this.dgvData.CurrentRow.Index;
                        this.PublicFunctionRows();
                        this.dgvData.Rows[SelectIndex].Selected = true;
                    }
                    else
                    { MessageBoxCustom.Show("安排失败！"); }
                }
            }
            else
            { MessageBoxCustom.Show("请选择您要转接的任务！"); return; }
        }
        /// <summary>
        /// 任务执行
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void btnTaskEcex_Click(object sender, EventArgs e)
        {
            if (this.dgvData.SelectedRows.Count > 0)
            {
                if (this.dgvData.SelectedRows.Count > 1)
                { MessageBoxCustom.Show("执行的任务不能选择多条！"); return; }
                if (!this.dgvData.SelectedRows[0].Cells["客服人员"].Value.ToString().Trim().Equals(LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.LoginUserModel.User_Name.Trim()) && !LYFZ.BLL.BLL_ErpUser.IsAdministrator())
                { MessageBoxCustom.Show("只能执行自己的任务！"); return; }
                string StrClientGroupNumber = "";
                string StrClientNumber = "";
                string StrHospitalNumber = "";
                switch ((LYFZ.EnumPublic.ClientServiceTaskItem)Enum.Parse(typeof(LYFZ.EnumPublic.ClientServiceTaskItem), this.dgvData.SelectedRows[0].Cells["具体事项"].Value.ToString().Trim()))
                {
                    case EnumPublic.ClientServiceTaskItem.选衣服客人:
                    case EnumPublic.ClientServiceTaskItem.拍照客人:
                    case EnumPublic.ClientServiceTaskItem.选片客人:
                    case EnumPublic.ClientServiceTaskItem.看版客人:
                    case EnumPublic.ClientServiceTaskItem.取件客人:
                    case EnumPublic.ClientServiceTaskItem.服务客人:
                    case EnumPublic.ClientServiceTaskItem.已定未拍:
                    case EnumPublic.ClientServiceTaskItem.已拍未拍完:
                    case EnumPublic.ClientServiceTaskItem.已拍未选:
                    case EnumPublic.ClientServiceTaskItem.已修未选:
                    case EnumPublic.ClientServiceTaskItem.已设计未看:
                    case EnumPublic.ClientServiceTaskItem.部分回件未取:
                    case EnumPublic.ClientServiceTaskItem.全部回件未取:
                    case EnumPublic.ClientServiceTaskItem.接单回访:
                    case EnumPublic.ClientServiceTaskItem.选衣回访:
                    case EnumPublic.ClientServiceTaskItem.拍照回访:
                    case EnumPublic.ClientServiceTaskItem.选片回访:
                    case EnumPublic.ClientServiceTaskItem.看版回访:
                    case EnumPublic.ClientServiceTaskItem.取件回访:
                    case EnumPublic.ClientServiceTaskItem.服务回访:
                    case EnumPublic.ClientServiceTaskItem.其它回访:
                    case EnumPublic.ClientServiceTaskItem.订单意向:
                        StrClientGroupNumber = this.dgvData.SelectedRows[0].Cells["Cst_ClientGroupNumber"].Value.ToString().Trim();
                        break;
                    case EnumPublic.ClientServiceTaskItem.结婚客人:
                    case EnumPublic.ClientServiceTaskItem.结婚纪念日:
                    case EnumPublic.ClientServiceTaskItem.客户生日:
                    case EnumPublic.ClientServiceTaskItem.宝贝生日:
                    case EnumPublic.ClientServiceTaskItem.转介绍客户:
                    case EnumPublic.ClientServiceTaskItem.会员积分:
                    case EnumPublic.ClientServiceTaskItem.孕妇周期:
                    case EnumPublic.ClientServiceTaskItem.意向客户:
                        StrClientNumber = this.dgvData.SelectedRows[0].Cells["Cst_ViceNumber"].Value.ToString().Trim();
                        break;
                    case EnumPublic.ClientServiceTaskItem.摄控医院客人:
                        StrHospitalNumber = this.dgvData.SelectedRows[0].Cells["Cst_OrderNumber"].Value.ToString().Trim();
                        StrClientNumber = this.dgvData.SelectedRows[0].Cells["Cst_ViceNumber"].Value.ToString().Trim();
                        break;
                    case EnumPublic.ClientServiceTaskItem.医院意向:
                        StrHospitalNumber = this.dgvData.SelectedRows[0].Cells["Cst_OrderNumber"].Value.ToString().Trim();
                        StrClientNumber = "0";
                        break;
                }
                bool IsSaveed = false;
                string StrClientServiceDateTime = "";
                string StrCompletionRemark = "";
                switch ((LYFZ.EnumPublic.ClientServiceTaskItem)Enum.Parse(typeof(LYFZ.EnumPublic.ClientServiceTaskItem), this.dgvData.SelectedRows[0].Cells["具体事项"].Value.ToString().Trim()))
                {
                    case EnumPublic.ClientServiceTaskItem.医院意向:
                    case EnumPublic.ClientServiceTaskItem.摄控医院客人:
                        LYFZ.Software.MainBusiness.HospitalTrackingSystem.AddingTrackRecord frm2 = new HospitalTrackingSystem.AddingTrackRecord();
                        frm2.IsShowDatimeRemind = false;
                        frm2.StrOrderNumber = StrHospitalNumber;
                        frm2.IsGoForm = false;
                        frm2.intDispatchDoorID = Convert.ToInt32(StrClientNumber);
                        frm2.ShowDialog();
                        StrClientServiceDateTime = frm2.StrClientServiceDateTime;
                        StrCompletionRemark = frm2.StrCompletionRemark;
                        IsSaveed = frm2.IsSaveed;
                        break;
                    case EnumPublic.ClientServiceTaskItem.接单回访:
                    case EnumPublic.ClientServiceTaskItem.选衣回访:
                    case EnumPublic.ClientServiceTaskItem.拍照回访:
                    case EnumPublic.ClientServiceTaskItem.选片回访:
                    case EnumPublic.ClientServiceTaskItem.看版回访:
                    case EnumPublic.ClientServiceTaskItem.取件回访:
                    case EnumPublic.ClientServiceTaskItem.服务回访:
                    case EnumPublic.ClientServiceTaskItem.其它回访:
                        LYFZ.Software.MainBusiness.CustomerSatisfactionRecord.Satisfaction.SatisfactionSurveyDetailSmallForm frm3 = new CustomerSatisfactionRecord.Satisfaction.SatisfactionSurveyDetailSmallForm();
                        frm3.StrOrdNumber = this.dgvData.CurrentRow.Cells["Cst_OrderNumber"].Value.ToString().Trim();
                        frm3.StrShowOrdNumber = this.dgvData.CurrentRow.Cells["订单号"].Value.ToString().Trim();
                        frm3.StrClientName = this.dgvData.CurrentRow.Cells["客户姓名"].Value.ToString().Trim();
                        frm3.StrPhotographName = this.dgvData.CurrentRow.Cells["拍摄名称"].Value.ToString().Trim();
                        frm3.StrOrdViceNumber = this.dgvData.CurrentRow.Cells["Cst_ViceNumber"].Value.ToString().Trim();
                        frm3.StrSatisfactionName = this.dgvData.SelectedRows[0].Cells["具体事项"].Value.ToString().Trim();
                        frm3.ShowDialog();
                        StrClientServiceDateTime = frm3.StrClientServiceDateTime;
                        IsSaveed = frm3.IsSaveed;
                        break;
                    default:
                        LYFZ.Software.MainBusiness.CameraControlBook.SuperSmallForm.AddClientServiceExecTaskSuperSmallForm frm = new CameraControlBook.SuperSmallForm.AddClientServiceExecTaskSuperSmallForm();
                        frm.StrClientNumber = StrClientNumber;
                        frm.StrHospitalNumber = StrHospitalNumber;
                        frm.StrClientGroupNumber = StrClientGroupNumber;
                        frm.StrTaskType = this.dgvData.SelectedRows[0].Cells["任务类型"].Value.ToString().Trim();
                        frm.StrTaskItem = this.dgvData.SelectedRows[0].Cells["具体事项"].Value.ToString().Trim();
                        frm.StrTaskNumber = this.dgvData.SelectedRows[0].Cells["Cst_Number"].Value.ToString().Trim();
                        frm.ShowDialog();
                        StrClientServiceDateTime = frm.StrClientServiceDateTime;
                        StrCompletionRemark = frm.StrCompletionRemark;
                        IsSaveed = frm.IsSaveed;
                        break;
                }
                if (IsSaveed)
                {
                    DataTable dt = orbll.GetView_Custom("tb_ErpClientServiceTask", StrWhere: "ID = '" + this.dgvData.CurrentRow.Cells["ID"].Value.ToString().Trim() + "'", ShowColumnName: "*").Tables[0];
                    LYFZ.Model.Model_ErpClientServiceTask modelCst = cstbll.DataRowToModel(dt.Rows[0]);
                    modelCst.Cst_CompletionStatus = "OK";
                    modelCst.Cst_CompletionIntStatus = 1;
                    modelCst.Cst_CompletionPerson = this.StrUserID;
                    modelCst.Cst_CompletionTime = Convert.ToDateTime(StrClientServiceDateTime);
                    modelCst.Cst_CompletionRemark = StrCompletionRemark;
                    modelCst.Cst_UpdateDateTime = SDateTime.Now;
                    modelCst.Cst_UpdateName = this.StrUserID;
                    if (cstbll.Update(modelCst))
                    {
                        MessageBoxCustom.Show("执行完成！");
                        this.PublicFunctionRows();
                    }
                    else
                    { MessageBoxCustom.Show("执行失败！"); }
                }
            }
            else
            { MessageBoxCustom.Show("请选择您要执行的任务！"); return; }
        }
        /// <summary>
        /// 关闭
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void btnCloseed_Click(object sender, EventArgs e)
        {
            this.Close();
        }
        /// <summary>
        /// 沟通类型选项
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void cmbtreevTaskType_ComboBoxTree_NodeMouseClick(object sender, TreeNodeMouseClickEventArgs e)
        {
            if (!this.cmbtreevTaskType.Text.Trim().Equals("全部") && this.cmbtreevTaskType.Text.Trim().Length > 0)
            {
                string StrNodes = "全部," + LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.GetTaskItemSelect(this.cmbtreevTaskType.Text.Trim());
                if (!this.cmbtreevTaskItem.Enabled)
                { this.cmbtreevTaskItem.Enabled = true; }
                this.cmbtreevTaskItem.SetTextAndTag_ValueNull();
                LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.BindComboxTreeView(this.cmbtreevTaskItem, StrNodes);
                this.cmbtreevTaskItem.TextFindTag("全部");
            }
        }
        /// <summary>
        /// 选项卡选择事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void tabControlEx1_SelectedIndexChanged(object sender, EventArgs e)
        {
            switch (this.tabControlEx1.SelectedTab.Name.Trim())
            {
                case "tabPage_ExecIn":
                case "tabPage_Timeout":
                    this.btnTaskEcex.Enabled = true;
                    this.btnTaskUpdate.Enabled = true;
                    this.panelDateTime.Visible = false;
                    break;
                case "tabPage_TimeoutCompleted":
                case "tabPage_Completed":
                    this.btnTaskEcex.Enabled = false;
                    this.btnTaskUpdate.Enabled = false;
                    this.panelDateTime.Visible = true;
                    break;
            }
            this.BindComboBoxTreeViewPerson(this.tabControlEx1.SelectedIndex);
            this.PublicFunctionRows();
        }
        /// <summary>
        /// 创建行
        /// </summary>
        void PublicFunctionRows()
        {
            string StrWhere = "";
            bool IsShowCompletionRemark = false;
            switch (this.tabControlEx1.SelectedTab.Name.Trim())
            {
                case "tabPage_ExecIn": StrWhere += " And Cst_CompletionIntStatus = 0"; break;
                case "tabPage_Timeout": StrWhere += " And Cst_CompletionIntStatus = 0 And (Cst_TaskTermTime + 1) < getdate()"; break;
                case "tabPage_TimeoutCompleted": StrWhere += " And Cst_CompletionIntStatus = 1 And Cst_TaskTermTime < Cst_CompletionTime"; IsShowCompletionRemark = true; break;
                case "tabPage_Completed": StrWhere += " And Cst_CompletionIntStatus = 1"; IsShowCompletionRemark = true; break;
            }
            if (this.panelDateTime.Visible)
            {
                if (this.tabControlEx1.SelectedTab.Name.Trim() == "tabPage_TimeoutCompleted")
                {
                    StrWhere += " And (Cst_CompletionTime between '" + this.dtDateTimeStart.DateValue + "' And '" + this.dtDateTimeEnd.DateValue + "')";
                }
                else
                {
                    StrWhere += LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.GetDateTime("Cst_CompletionTime", this.dtDateTimeStart.DateValue, this.dtDateTimeEnd.DateValue);
                }
            }
            if (this.cmbtreevTaskType.Text.Trim().Length > 0 && !this.cmbtreevTaskType.Text.Trim().Equals("全部"))
            { StrWhere += " And Cst_TaskModule = '" + this.cmbtreevTaskType.Text.Trim() + "'"; }
            if (this.cmbtreevTaskItem.Text.Trim().Length > 0 && !this.cmbtreevTaskItem.Text.Trim().Equals("全部"))
            { StrWhere += " And Cst_TaskItem = '" + this.cmbtreevTaskItem.Text.Trim() + "'"; }
            if (this.cmbtreevClientServicePerson.Text.Trim().Length > 0 && this.cmbtreevClientServicePerson.Tag != null && !this.cmbtreevClientServicePerson.Text.Trim().Equals("全部"))
            {
                StrWhere += " And Cst_ServicePerson = '" + this.cmbtreevClientServicePerson.Tag.ToString().Trim() + "'";
                //LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.GetTreeViewSelectPersonTagQueryConditionEqual(this.cmbtreevClientServicePerson, ref StrWhere, "Cst_ServicePerson", ConnectWord: "And"); 
            }
            StrWhere += LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.GetQueryTextQueryCondition(this.cmbQueryText.Text.Trim());
            DataTable dt = LYFZ.BLL.BLL_ErpOrderView.GetData_ClientServiceTask(StrWhere, IsShowCompletionRemark);
            this.dgvData.DataSource(dt, strHideField: "ID,Cst_Number,Cst_ClientGroupNumber,Cst_OrderNumber,Cst_ViceNumber");
            this.dgvData.Columns["套系价格"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
            this.dgvData.Columns["客户姓名"].Frozen = true;
            this.dgvData.Columns["拍摄名称"].Width = 180;
            this.dgvData.Columns["订单类型"].Width = 70;
            this.dgvData.Columns["客户电话"].Width = 150;
            this.dgvData.Columns["年龄"].Width = 50;
            this.dgvData.Columns["客户性别"].Width = 70;
            this.dgvData.Columns["客服人员"].Width = 70;
            this.dgvData.Columns["任务时间"].Width = 70;
            this.dgvData.Columns["完成状态"].Width = 70;
            this.dgvData.Columns["完成时间"].Width = 70;
            this.dgvData.Columns["套系价格"].Width = 70;
            if (IsShowCompletionRemark)
            {
                this.dgvData.Columns["任务说明"].Width = 250;
                this.dgvData.Columns["完成说明"].Width = 250;
            }
            else
            { this.dgvData.FillLastColumn(false); }
        }
    }
}