lyfz_repos/铂金版源码/LYFZ.Software.MainBusiness/FinancialManagement/FrmPayroll.cs

using LYFZ.ComponentLibrary;
using System;
using System.Collections;
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.FinancialManagement
{
    public partial class FrmPayroll : LYFZ.Software.UI.FinancialManagement.FrmPayroll
    {
        LYFZ.BLL.BLL_ErpOrder orbll = new LYFZ.BLL.BLL_ErpOrder();
        LYFZ.BLL.BLL_ErpPayment ptbll = new BLL.BLL_ErpPayment();
        LYFZ.BLL.BLL_AllViewSet avsbll = new BLL.BLL_AllViewSet();
        LYFZ.BLL.BLL_ErpWagesSet wsbll = new BLL.BLL_ErpWagesSet();
        LYFZ.BLL.BLL_ErpSystemConfigure sgbll = new BLL.BLL_ErpSystemConfigure();
        LYFZ.BLL.BLL_ErpOrdersPhotography opbll = new BLL.BLL_ErpOrdersPhotography();
        LYFZ.BLL.BLL_ErpWageCommissionSet wcsbll = new BLL.BLL_ErpWageCommissionSet();
        LYFZ.BLL.BLL_ErpCommissionPercentage cpbll = new BLL.BLL_ErpCommissionPercentage();
        LYFZ.BLL.BLL_ErpWageCommissionRecords wcrbll = new BLL.BLL_ErpWageCommissionRecords();
        LYFZ.BLL.BLL_ErpPieceCommissionRecords pcrbll = new BLL.BLL_ErpPieceCommissionRecords();
        private delegate void UpdateControl();
        public FrmPayroll()
        {
            this.dgv.RowsAdded += dgv_RowsAdded;
            this.txtTimeStart.Leave += txtTimeStart_Leave;
            this.Resize += FrmPayroll_Resize;
        }

        /// <summary>
        /// 一级景点个数
        /// </summary>
        int OneLevelCount = 0;
        /// <summary>
        /// 二级景点个数
        /// </summary>
        int TwoLevelCount = 0;
        /// <summary>
        /// 三级景点个数
        /// </summary>
        int ThreeLevelCount = 0;
        //景点等级比重
        /// <summary>
        /// 一级景点比重
        /// </summary>
        decimal OneLevel = 0;
        /// <summary>
        /// 二级景点比重
        /// </summary>
        decimal TwoLevel = 0;
        /// <summary>
        /// 三级景点比重
        /// </summary>
        decimal ThreeLevel = 0;
        /// <summary>
        /// 摄影比重
        /// </summary>
        decimal MainPhotography = 0;
        /// <summary>
        /// 摄影助理比重
        /// </summary>
        decimal DeputyPhotography = 0;
        /// <summary>
        /// 化妆比重
        /// </summary>
        decimal MainMake = 0;
        /// <summary>
        /// 化妆助理比重
        /// </summary>
        decimal DeputyMake = 0;
        /// <summary>
        /// 引导比重
        /// </summary>
        decimal MainBootDivision = 0;
        /// <summary>
        /// 引导助理比重
        /// </summary>
        decimal DeputyBootDivision = 0;
        /// <summary>
        /// 
        /// </summary>
        DataTable dt_SystemConfigure = new DataTable();
        /// <summary>
        /// 
        /// </summary>
        DataTable tblSystemCategory = new DataTable();
        /// <summary>
        /// 是否首次远行
        /// </summary>
        bool IsFirstRun = true;
        /// <summary>
        /// 窗体加载事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected override void FrmPayroll_Shown(object sender, EventArgs e)
        {
            this.tblSystemCategory = new LYFZ.BLL.BLL_ErpSystemCategory().GetAllList(filedOrder: "ID asc").Tables[0];
            this.txtTimeStart.DateValue = SDateTime.Now.Year + "-" + SDateTime.Now.Month + "-01";
            this.txtTimeEnd.DateValue = Convert.ToDateTime(this.txtTimeStart.DateValue).AddMonths(1).AddSeconds(-1).ToString("yyyy-MM-dd");
            dt_SystemConfigure = sgbll.GetAllList().Tables[0];
            // 部门人员绑定
            LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.BindComboBoxTreeView_DepartmentAndEmployee(this.cmbEmployeeName, IsFirstNodeNull: true, IsFirstNodeName: "全部", IsShowResign: false, IsShowAdmin: true);
            //项目类别
            LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.BindComboxTreeView(this.cmbItemCategory, StrBindData: "订单前期,服务前期,订单后期,服务后期,其它消费,会员充值,服务卡充值,计件提成,礼服租售", IsFirstNodeNull: true);
            //流程状态
            LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.BindComboxTreeView(this.cmbProcessStatus, StrBindData: "拍照OK,选片OK,取件OK", IsFirstNodeNull: true);
            //客户来源
            LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.BindComboBoxTreeView_SystemCategory("AAAAAAF", this.cmbCustomerSource, IsFirstNodeNull: true, tbl: tblSystemCategory);
            //套系类别
            LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.BindComboBoxTreeView_SystemCategory("BFAGAHBFDGCABAJIH", this.CtvPak_Name, IsFirstNodeNull: true, tbl: tblSystemCategory);
            //计件提成
            LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.BindComboBoxTreeView_SystemCategory("BEBBAFACDCCFBJFI", this.cmbCommissionScheme, IsFirstNodeNull: true, tbl: tblSystemCategory);
            ////景点类别
            //LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.BindComboxTreeView(this.cmbtreevSightsCategory, "内景,外景", IsFirstNodeNull: true);

            // 查看
            this.cmbEmployeeName.Enabled = LYFZ.BLL.BLL_ErpUser.GetRights(LYFZ.BLL.BLL_ErpUser.CurrentUserRights.StatisticalInquiryAllWagesCompetence, CustomAttributes.OperatingAuthority.ViewAll);
            if (LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.LoginUserModel.User_Account != LYFZ.AuthorizeUserName.AdministratorsName)
            {
                this.cmbEmployeeName.TagFindText(LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.LoginUserModel.User_EmployeeID);
                this.cmbEmployeeName_ComboBoxTree_NodeMouseClick(null, null);
            }
            // 录入
            btnSave.Enabled = LYFZ.BLL.BLL_ErpUser.GetRights(LYFZ.BLL.BLL_ErpUser.CurrentUserRights.StatisticalInquiryAllWagesCompetence, CustomAttributes.OperatingAuthority.Add);
            // 导出
            btnExPort.Enabled = LYFZ.BLL.BLL_ErpUser.GetRights(LYFZ.BLL.BLL_ErpUser.CurrentUserRights.StatisticalInquiryAllWagesCompetence, CustomAttributes.OperatingAuthority.DataExport);

            // 获取景点等级级别比重
            if (cpbll.GetList("Cp_ProportionCode='BEBBBCADDEBFJDFFC'").Tables[0].Rows.Count > 0)
            { OneLevel = Convert.ToDecimal(cpbll.GetList("Cp_ProportionCode='BEBBBCADDEBFJDFFC'").Tables[0].Rows[0]["Cp_Proportion"]); }
            if (cpbll.GetList("Cp_ProportionCode='BEBBBCADEGBGAFFJC'").Tables[0].Rows.Count > 0)
            { TwoLevel = Convert.ToDecimal(cpbll.GetList("Cp_ProportionCode='BEBBBCADEGBGAFFJC'").Tables[0].Rows[0]["Cp_Proportion"]); }
            if (cpbll.GetList("Cp_ProportionCode='BEBBBCADAFBHBCHCI'").Tables[0].Rows.Count > 0)
            { ThreeLevel = Convert.ToDecimal(cpbll.GetList("Cp_ProportionCode='BEBBBCADAFBHBCHCI'").Tables[0].Rows[0]["Cp_Proportion"]); }
            // 获取摄影比重
            if (cpbll.GetList("Cp_ProportionCode='MainPhotography'").Tables[0].Rows.Count > 0)
            { MainPhotography = Convert.ToDecimal(cpbll.GetList("Cp_ProportionCode='MainPhotography'").Tables[0].Rows[0]["Cp_Proportion"]); }

            if (cpbll.GetList("Cp_ProportionCode='DeputyPhotography'").Tables[0].Rows.Count > 0)
            { DeputyPhotography = Convert.ToDecimal(cpbll.GetList("Cp_ProportionCode='DeputyPhotography'").Tables[0].Rows[0]["Cp_Proportion"]); }
            //  获取化妆比重
            if (cpbll.GetList("Cp_ProportionCode='MainMake'").Tables[0].Rows.Count > 0)
            { MainMake = Convert.ToDecimal(cpbll.GetList("Cp_ProportionCode='MainMake'").Tables[0].Rows[0]["Cp_Proportion"]); }
            if (cpbll.GetList("Cp_ProportionCode='DeputyMake'").Tables[0].Rows.Count > 0)
            { DeputyMake = Convert.ToDecimal(cpbll.GetList("Cp_ProportionCode='DeputyMake'").Tables[0].Rows[0]["Cp_Proportion"]); }

            //  获取引导比重
            if (cpbll.GetList("Cp_ProportionCode='MainBootDivision'").Tables[0].Rows.Count > 0)
            { MainBootDivision = Convert.ToDecimal(cpbll.GetList("Cp_ProportionCode='MainBootDivision'").Tables[0].Rows[0]["Cp_Proportion"]); }
            if (cpbll.GetList("Cp_ProportionCode='DeputyBootDivision'").Tables[0].Rows.Count > 0)
            { DeputyBootDivision = Convert.ToDecimal(cpbll.GetList("Cp_ProportionCode='DeputyBootDivision'").Tables[0].Rows[0]["Cp_Proportion"]); }
            this.IsFirstRun = false;
            this.FrmPayroll_Resize(this, null);
        }
        /// <summary>
        /// 获取儿童阶段金额
        /// </summary>
        /// <param name="OrdNumber">主订单号</param>
        /// <param name="YsAmount">应该金额</param>
        /// <param name="BcAmount">本次收款金额</param>
        /// <param name="SightsName">景点名称</param>
        /// <returns></returns>
        public decimal GetChildrenAmount(string OrdNumber, decimal YsAmount, decimal BcAmount, string SightsName)
        {
            decimal Sum = 0;
            decimal ChildrenAmount = 0;
            decimal EveryAmount = 0;
            DataTable tbl = opbll.GetList("Ordpg_Number = '" + OrdNumber + "'", "Ordpg_ViceNumber ASC").Tables[0];
            int Count = tbl.Rows.Count;
            //每次收款金额（平均分）
            if (Count > 0)
            { EveryAmount = YsAmount / Count; }
            //获取收款金额
            DataTable dt = ptbll.GetSum("Pay_OrdNumber = '" + OrdNumber + "'  and Pay_Category != '后期收款'").Tables[0];
            if (!string.IsNullOrEmpty(dt.Rows[0]["Pay_AmountOf"].ToString()))
            { ChildrenAmount = Convert.ToDecimal(dt.Rows[0]["Pay_AmountOf"].ToString()); }

            //for (int i = 0; i < tbl.Rows.Count; i++)
            //{
            //    if (SightsName == tbl.Rows[i]["Ordpg_Sights"].ToString().Trim())
            //    {
            //        ChildrenAmount = ChildrenAmount - EveryAmount;
            //        if (ChildrenAmount > EveryAmount)
            //        { Sum = EveryAmount; }
            //        else
            //        { Sum = ChildrenAmount; }
            //        break;
            //    }
            //    else
            //    { ChildrenAmount = ChildrenAmount - EveryAmount; }
            //}

            if ((ChildrenAmount / Count) == EveryAmount)
            {
                if (ptbll.GetList("Pay_OrdNumber = '" + OrdNumber + "'  and Pay_Category != '后期收款'").Tables[0].Rows.Count == 1)
                { Sum = EveryAmount; }
                else
                { Sum = BcAmount / Count; }
            }
            else
            {
                if (ChildrenAmount < EveryAmount)
                {
                    for (int i = 0; i < tbl.Rows.Count; i++)
                    {
                        string Ordpg_Sights = tbl.Rows[i]["Ordpg_Sights"].ToString();
                        if (SightsName == Ordpg_Sights)
                        {
                            if (i + 1 == 1)
                            { Sum = ChildrenAmount / ptbll.GetList("Pay_OrdNumber='" + OrdNumber + "'  and Pay_Category!='后期收款'").Tables[0].Rows.Count; }
                            else
                            { Sum = 0; }
                        }
                    }
                }
                if (ChildrenAmount >= EveryAmount)
                {
                    for (int i = 0; i < tbl.Rows.Count; i++)
                    {
                        string Ordpg_Sights = tbl.Rows[i]["Ordpg_Sights"].ToString();
                        if (SightsName == Ordpg_Sights)
                        {
                            if (ChildrenAmount > (EveryAmount * (i + 1)))
                            {
                                if (ptbll.GetList("Pay_OrdNumber='" + OrdNumber + "'  and Pay_Category!='后期收款'").Tables[0].Rows.Count == 1)
                                { Sum = EveryAmount; }
                                else
                                { Sum = EveryAmount / ptbll.GetList("Pay_OrdNumber='" + OrdNumber + "'  and Pay_Category!='后期收款'").Tables[0].Rows.Count; }
                            }
                            else
                            { Sum = 0; }
                        }
                    }
                }
            }
            return Convert.ToDecimal(Sum.ToString("N2"));
        }
        /// <summary>
        /// 获取所有业绩列表
        /// </summary>
        /// <param name="StartTime"></param>
        /// <param name="EndTime"></param>
        /// <param name="EmployeeName"></param>
        /// <param name="backgroundWorker"></param>
        /// <returns></returns>
        public decimal BindPerformance(string StartTime, string EndTime, string EmployeeName, BackgroundWorker backgroundWorker)
        {
            this.Invoke(new UpdateControl(delegate()
            {
                this.dgv.Rows.Clear();
            }));

            string StrUserName = "";
            if (!string.IsNullOrEmpty(EmployeeName))
            {
                DataRow dtRow = LYFZ.DAL.DAL_ErpUser.SimpleUserDataTable.Rows.Find(EmployeeName);
                if (dtRow != null)
                { StrUserName = dtRow["User_Name"].ToString().Trim(); }
            }

            decimal Sum = 0;
            string s = "";
            StringBuilder strBuilder = new StringBuilder();

            #region 列表
            if (string.IsNullOrEmpty(this.Str_ItemCategory.Trim()) || this.Str_ItemCategory.Trim() == "订单前期" || this.Str_ItemCategory.Trim() == "订单后期" || this.Str_ItemCategory.Trim() == "其它消费" || this.Str_ItemCategory.Trim() == "礼服租售")
            {
                #region 获取订单收款(前期收款，后期收款，其它消费)收款后即分提成
                strBuilder.Append(" 1 = 1 ");
                string StrPaymentWhere = "";
                if (string.IsNullOrEmpty(this.Str_ProcessStatus.Trim()))
                { strBuilder.Append("and 收款时间>='" + StartTime + "' and 收款时间<='" + EndTime + " 23:59:59.000' "); }
                //if (string.IsNullOrEmpty(this.Str_ProcessStatus.Trim()))
                //{ StrPaymentWhere = "and Pay_CreateDatetime >= '" + StartTime + "' and 收款时间<='" + EndTime + " 23:59:59.000' "; }
                else if (!string.IsNullOrEmpty(this.Str_ProcessStatus.Trim()))
                {
                    if (this.Str_ProcessStatus.Trim() == "拍照OK")
                    { strBuilder.Append("and 未拍个数 = 0 and (最后拍摄时间 >= '" + StartTime + "' and 最后拍摄时间 <= '" + EndTime + " 23:59:59.000')"); }
                    if (this.Str_ProcessStatus.Trim() == "选片OK")
                    { strBuilder.Append("and 选片状态 = '1' and (选片时间 >= '" + StartTime + "' and 选片时间 <= '" + EndTime + " 23:59:59.000')"); }
                    if (this.Str_ProcessStatus.Trim() == "取件OK")
                    { strBuilder.Append("and 取件状态 = 'OK' and (取件日期 >= '" + StartTime + "' and 取件日期 <= '" + EndTime + " 23:59:59.000')"); }
                    strBuilder.Append("and (收款类别 = '全款' or 收款类别 = '预约补款' or 收款类别 = '预约收款' or 二销类别编号 = 'BEBCABBAAHFCJBJGJ')");
                }
                if (EmployeeName != null && !string.IsNullOrEmpty(EmployeeName))
                { strBuilder.Append("and 接单人编号 like '%" + EmployeeName + "%'"); }
                if (!string.IsNullOrEmpty(this.Str_Scores1))
                { strBuilder.Append("and (门市满意总分>=" + this.Str_Scores1 + " and 门市满意总分<=" + this.Str_Scores2 + ")"); }
                bool IsQuery = true;
                s = BindSelect1(ref IsQuery);
                if (IsQuery)
                {
                    DataTable dtCount = orbll.GetView_Custom("Vw_StaffPerformance_OrdersPerson", StrWhere: strBuilder.ToString() + s.ToString(), ShowColumnName: "Count(ID) CountID").Tables[0];
                    //DataTable dtCount = LYFZ.BLL.BLL_ErpPaymentPayrollClass.GetPayrollOrderPerson(StrPaymentWhere, strBuilder.ToString() + s.ToString()); // orbll.GetView_Custom("Vw_StaffPerformance_OrdersPerson", StrWhere: strBuilder.ToString() + s.ToString(), ShowColumnName: "Count(ID) CountID").Tables[0];
                    if (dtCount.Rows.Count > 0)
                    {
                        if (Convert.ToInt32(dtCount.Rows[0]["CountID"]) > 0)
                        {
                            backgroundWorker.ReportProgress(0, "正在获取'门市接单' ...");
                            string StrColumnName = "订单号,接单人名称,主门市,客户名称,主门市金额,副门市金额,收款时间,收款类型,套系类别,套系名称,项目名称,应收金额,收款类别,付款方式名称,未拍个数,最后拍摄时间,选片状态,选片时间,取件状态,取件日期,拍摄阶段,门市满意总分";
                            //DataTable dt_OrderPayment = avsbll.Vw_StaffPerformance_OrdersPerson(str.ToString() + s.ToString()).Tables[0];
                            DataTable dt_OrderPayment = orbll.GetView_Custom("Vw_StaffPerformance_OrdersPerson", StrWhere: strBuilder.ToString() + s.ToString(), ShowColumnName: StrColumnName).Tables[0];
                            for (int t = 0; t < dt_OrderPayment.Rows.Count; t++)
                            {
                                #region
                                DataGridViewRow dgvr = new DataGridViewRow();
                                DataGridViewCell cell = null;

                                //订单号
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dt_OrderPayment.Rows[t]["订单号"].ToString().Trim();
                                dgvr.Cells.Add(cell);

                                //员工
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dt_OrderPayment.Rows[t]["接单人名称"].ToString().Trim();
                                dgvr.Cells.Add(cell);

                                //职务
                                cell = new DataGridViewTextBoxCell();
                                #region 前期收款，后期收款
                                if (!string.IsNullOrEmpty(dt_OrderPayment.Rows[t]["主门市"].ToString()))
                                {
                                    if (dt_OrderPayment.Rows[t]["主门市"].ToString() == EmployeeName)
                                    { cell.Value = "主接单人"; }
                                    else
                                    { cell.Value = "副接单人"; }
                                }
                                #endregion
                                dgvr.Cells.Add(cell);

                                //客户姓名
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dt_OrderPayment.Rows[t]["客户名称"].ToString().Trim();
                                dgvr.Cells.Add(cell);

                                //收款金额
                                cell = new DataGridViewTextBoxCell();
                                #region 前期收款，后期收款
                                if (!string.IsNullOrEmpty(dt_OrderPayment.Rows[t]["主门市"].ToString()))
                                {
                                    if (dt_OrderPayment.Rows[t]["主门市"].ToString() == EmployeeName)
                                    { cell.Value = Convert.ToDecimal(dt_OrderPayment.Rows[t]["主门市金额"]).ToString("N2"); }
                                    else
                                    { cell.Value = Convert.ToDecimal(dt_OrderPayment.Rows[t]["副门市金额"]).ToString("N2"); }
                                }
                                #endregion
                                dgvr.Cells.Add(cell);

                                //收款时间
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dt_OrderPayment.Rows[t]["收款时间"].ToString().Trim();
                                dgvr.Cells.Add(cell);

                                //套系类别
                                cell = new DataGridViewTextBoxCell();
                                if (dt_OrderPayment.Rows[t]["收款类型"].ToString() == "0")
                                { cell.Value = dt_OrderPayment.Rows[t]["套系类别"].ToString().Trim(); }
                                if (dt_OrderPayment.Rows[t]["收款类型"].ToString() == "1")
                                { cell.Value = "/其它消费"; }
                                if (dt_OrderPayment.Rows[t]["收款类型"].ToString() == "2")
                                { cell.Value = "/礼服租售"; }
                                dgvr.Cells.Add(cell);

                                //套系名称
                                cell = new DataGridViewTextBoxCell();
                                if (dt_OrderPayment.Rows[t]["收款类型"].ToString() == "0")
                                { cell.Value = dt_OrderPayment.Rows[t]["套系名称"].ToString().Trim(); }
                                if (dt_OrderPayment.Rows[t]["收款类型"].ToString() == "1")
                                { cell.Value = dt_OrderPayment.Rows[t]["项目名称"].ToString().Trim(); }
                                dgvr.Cells.Add(cell);

                                //应收金额
                                cell = new DataGridViewTextBoxCell();
                                if (!string.IsNullOrEmpty(dt_OrderPayment.Rows[t]["应收金额"].ToString().Trim()))
                                { cell.Value = Convert.ToDecimal(dt_OrderPayment.Rows[t]["应收金额"]).ToString("N2").Trim(); }
                                else
                                { cell.Value = 0; }
                                dgvr.Cells.Add(cell);

                                //项目名称
                                cell = new DataGridViewTextBoxCell();
                                if (dt_OrderPayment.Rows[t]["收款类型"].ToString() == "0")
                                {
                                    if (string.IsNullOrEmpty(dt_OrderPayment.Rows[t]["项目名称"].ToString().Trim()))
                                    { cell.Value = dt_OrderPayment.Rows[t]["收款类别"].ToString(); }
                                    else
                                    { cell.Value = dt_OrderPayment.Rows[t]["项目名称"].ToString().Trim(); }
                                }
                                else
                                { cell.Value = dt_OrderPayment.Rows[t]["项目名称"].ToString().Trim(); }
                                dgvr.Cells.Add(cell);

                                //付款名称
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dt_OrderPayment.Rows[t]["付款方式名称"].ToString().Trim();
                                dgvr.Cells.Add(cell);

                                #region
                                if (dt_OrderPayment.Rows[t]["收款类型"].ToString() == "0")
                                {
                                    //拍摄状态
                                    cell = new DataGridViewTextBoxCell();
                                    if (Convert.ToInt32(dt_OrderPayment.Rows[t]["未拍个数"]) == 0)
                                    { cell.Value = "OK"; }
                                    else
                                    { cell.Value = "未拍"; }
                                    dgvr.Cells.Add(cell);

                                    //拍摄时间
                                    cell = new DataGridViewTextBoxCell();
                                    cell.Value = dt_OrderPayment.Rows[t]["最后拍摄时间"].ToString();
                                    dgvr.Cells.Add(cell);

                                    //选片状态
                                    cell = new DataGridViewTextBoxCell();
                                    if (dt_OrderPayment.Rows[t]["选片状态"].ToString() == "1")
                                    { cell.Value = "OK"; }
                                    else
                                    { cell.Value = "未选"; }
                                    dgvr.Cells.Add(cell);

                                    //选片时间
                                    cell = new DataGridViewTextBoxCell();
                                    cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt_OrderPayment.Rows[t]["选片时间"], "yyyy-MM-dd HH:mm");
                                    dgvr.Cells.Add(cell);

                                    //取件状态
                                    cell = new DataGridViewTextBoxCell();
                                    if (dt_OrderPayment.Rows[t]["取件状态"].ToString() == "OK")
                                    { cell.Value = "OK"; }
                                    else
                                    { cell.Value = "未取"; }
                                    dgvr.Cells.Add(cell);

                                    //拍摄阶段
                                    cell = new DataGridViewTextBoxCell();
                                    cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt_OrderPayment.Rows[t]["取件日期"], "yyyy-MM-dd HH:mm");
                                    dgvr.Cells.Add(cell);

                                    //取件时间
                                    cell = new DataGridViewTextBoxCell();
                                    cell.Value = dt_OrderPayment.Rows[t]["拍摄阶段"].ToString();
                                    dgvr.Cells.Add(cell);

                                    //订单类型
                                    cell = new DataGridViewTextBoxCell();
                                    cell.Value = "";
                                    dgvr.Cells.Add(cell);

                                    //收款类型
                                    cell = new DataGridViewTextBoxCell();
                                    cell.Value = "";
                                    dgvr.Cells.Add(cell);

                                    //副订单
                                    cell = new DataGridViewTextBoxCell();
                                    cell.Value = "";
                                    dgvr.Cells.Add(cell);

                                    //门市满意度
                                    cell = new DataGridViewTextBoxCell();
                                    cell.Value = dt_OrderPayment.Rows[t]["门市满意总分"].ToString();
                                    dgvr.Cells.Add(cell);
                                }
                                #endregion
                                this.Invoke(new UpdateControl(delegate()
                                {
                                    this.dgv.Rows.Add(dgvr);
                                }));
                                #endregion
                            }
                        }
                    }
                }
                #endregion
            }
            if (this.Str_ItemCategory.Trim() == "" || this.Str_ItemCategory.Trim() == "服务前期" || this.Str_ItemCategory.Trim() == "服务后期")
            {
                #region 获取流程状态（前期收款(摄影，化妆，引导，初修，精修，设计)前期业绩，选片二销业绩）
                if (this.Str_ItemCategory.Trim() == "" || this.Str_ItemCategory.Trim() == "服务前期")
                {
                    #region 前期业绩
                    DataRow[] ConfigureRow = dt_SystemConfigure.Select("Sconfig_Code='PhotographersEarly' and Sconfig_IsEnabled=1");
                    if (ConfigureRow.Length > 0)
                    {
                        if (ConfigureRow[0]["Sconfig_Value"].ToString() == "1")
                        {
                            if (this.Str_ProjectTitle.Trim() == "" || this.Str_ProjectTitle.Trim() == "摄影前期")
                            {
                                #region 主摄影师
                                s = "";
                                strBuilder = new StringBuilder();
                                strBuilder.Append(" 收款类别 <> '后期收款'");
                                if (EmployeeName != null && !string.IsNullOrEmpty(EmployeeName))
                                { strBuilder.Append(" And 主摄影师ID like '%" + EmployeeName + "%' "); }
                                if (this.Str_ProcessStatus.Trim() == "")
                                { strBuilder.Append(" And 未拍个数 = 0 And (服务前期查询时间 >= '" + StartTime + "' And 服务前期查询时间 <= '" + EndTime + " 23:59:59.000')"); }
                                if (this.Str_ProcessStatus.Trim() == "拍照OK")
                                { strBuilder.Append(" And 未拍个数 = 0 And (最后拍摄时间>='" + StartTime + "' And 最后拍摄时间 <= '" + EndTime + " 23:59:59.000')"); }
                                if (this.Str_ProcessStatus.Trim() == "选片OK")
                                { strBuilder.Append(" And 选片状态 = 'OK' And (选片时间 >= '" + StartTime + "' And 选片时间 <= '" + EndTime + " 23:59:59.000')"); }
                                if (this.Str_ProcessStatus.Trim() == "取件OK")
                                { strBuilder.Append(" And 取件状态 = 'OK' And (取件日期 >= '" + StartTime + "' And 取件日期 <= '" + EndTime + " 23:59:59.000')"); }
                                if (!string.IsNullOrEmpty(this.Str_Scores1))
                                { strBuilder.Append(" and (主摄影满意总分>=" + this.Str_Scores1 + " and 主摄影满意总分<=" + this.Str_Scores2 + ")"); }
                                s = BindSelect5();
                                DataTable dtCount1 = orbll.GetView_Custom("Vw_StaffPerformance_Photograph", StrWhere: strBuilder.ToString() + s.ToString(), ShowColumnName: "Count(ID) CountID").Tables[0];
                                if (dtCount1.Rows.Count > 0)
                                {
                                    if (Convert.ToInt32(dtCount1.Rows[0]["CountID"]) > 0)
                                    {
                                        backgroundWorker.ReportProgress(0, "正在获取'主摄影师前期业绩' ...");
                                        string StrColumnName = "订单号,客户名称,订单类型,收款金额,应收金额,拍摄名称,收款时间,套系类别,套系名称,项目名称,收款类别,付款方式名称,未拍个数,最后拍摄时间,选片状态,选片时间,取件状态,取件日期,副订单,主摄影满意总分";
                                        DataTable dt_MainPhotographer = orbll.GetView_Custom("Vw_StaffPerformance_Photograph", StrWhere: strBuilder.ToString() + s.ToString(), ShowColumnName: StrColumnName).Tables[0];
                                        for (int t = 0; t < dt_MainPhotographer.Rows.Count; t++)
                                        {
                                            #region
                                            DataGridViewRow dgvr = new DataGridViewRow();
                                            DataGridViewCell cell = null;

                                            //订单号
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_MainPhotographer.Rows[t]["订单号"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //员工
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = StrUserName;
                                            dgvr.Cells.Add(cell);

                                            //职务
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = "主摄影师";
                                            dgvr.Cells.Add(cell);

                                            //客户姓名
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_MainPhotographer.Rows[t]["客户名称"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //收款金额
                                            cell = new DataGridViewTextBoxCell();
                                            if (dt_MainPhotographer.Rows[t]["订单类型"].ToString() != "1")
                                            { cell.Value = Convert.ToDecimal(dt_MainPhotographer.Rows[t]["收款金额"]).ToString("N2"); }
                                            else
                                            { cell.Value = GetChildrenAmount(dt_MainPhotographer.Rows[t]["订单号"].ToString().Trim(), Convert.ToDecimal(dt_MainPhotographer.Rows[t]["应收金额"]), Convert.ToDecimal(dt_MainPhotographer.Rows[t]["收款金额"]), dt_MainPhotographer.Rows[t]["拍摄名称"].ToString()); }
                                            dgvr.Cells.Add(cell);

                                            //收款时间
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_MainPhotographer.Rows[t]["收款时间"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //套系类别
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_MainPhotographer.Rows[t]["套系类别"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //套系名称
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_MainPhotographer.Rows[t]["套系名称"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //应收金额
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = Convert.ToDecimal(dt_MainPhotographer.Rows[t]["应收金额"]).ToString("N2").Trim();
                                            dgvr.Cells.Add(cell);

                                            //项目名称
                                            cell = new DataGridViewTextBoxCell();
                                            if (string.IsNullOrEmpty(dt_MainPhotographer.Rows[t]["项目名称"].ToString().Trim()))
                                            { cell.Value = dt_MainPhotographer.Rows[t]["收款类别"].ToString(); }
                                            else
                                            { cell.Value = dt_MainPhotographer.Rows[t]["项目名称"].ToString().Trim(); }
                                            dgvr.Cells.Add(cell);

                                            //付款名称
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_MainPhotographer.Rows[t]["付款方式名称"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //拍摄状态
                                            cell = new DataGridViewTextBoxCell();
                                            if (Convert.ToInt32(dt_MainPhotographer.Rows[t]["未拍个数"]) == 0)
                                            { cell.Value = "OK"; }
                                            else
                                            { cell.Value = "未拍"; }
                                            dgvr.Cells.Add(cell);

                                            //拍摄时间
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_MainPhotographer.Rows[t]["最后拍摄时间"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //选片状态
                                            cell = new DataGridViewTextBoxCell();
                                            if (dt_MainPhotographer.Rows[t]["选片状态"].ToString() == "OK")
                                            { cell.Value = "OK"; }
                                            else
                                            { cell.Value = "未选"; }
                                            dgvr.Cells.Add(cell);

                                            //选片时间
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt_MainPhotographer.Rows[t]["选片时间"], "yyyy-MM-dd HH:mm");
                                            dgvr.Cells.Add(cell);

                                            //取件状态
                                            cell = new DataGridViewTextBoxCell();
                                            if (dt_MainPhotographer.Rows[t]["取件状态"].ToString() == "OK")
                                            { cell.Value = "OK"; }
                                            else
                                            { cell.Value = "未取"; }
                                            dgvr.Cells.Add(cell);

                                            //取件时间
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt_MainPhotographer.Rows[t]["取件日期"], "yyyy-MM-dd HH:mm");
                                            dgvr.Cells.Add(cell);

                                            //拍摄名称
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_MainPhotographer.Rows[t]["拍摄名称"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //订单类型
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_MainPhotographer.Rows[t]["订单类型"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //收款类型
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_MainPhotographer.Rows[t]["收款类别"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //副订单
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_MainPhotographer.Rows[t]["副订单"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //主摄影满意总分
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_MainPhotographer.Rows[t]["主摄影满意总分"].ToString();
                                            dgvr.Cells.Add(cell);

                                            this.Invoke(new UpdateControl(delegate()
                                            {
                                                this.dgv.Rows.Add(dgvr);
                                            }));
                                            #endregion
                                        }
                                    }
                                }
                                #endregion

                                #region 摄影助理
                                s = "";
                                strBuilder = new StringBuilder();
                                strBuilder.Append(" 收款类别 <> '后期收款'");
                                if (EmployeeName != null && !string.IsNullOrEmpty(EmployeeName))
                                { strBuilder.Append(" And 摄影助理ID like '%" + EmployeeName + "%' "); }
                                if (this.Str_ProcessStatus.Trim() == "")
                                { strBuilder.Append(" And 未拍个数 = 0 And (服务前期查询时间 >= '" + StartTime + "' And 服务前期查询时间 <= '" + EndTime + " 23:59:59.000')"); }
                                if (this.Str_ProcessStatus.Trim() == "拍照OK")
                                { strBuilder.Append(" And 未拍个数 = 0 And (最后拍摄时间 >= '" + StartTime + "' And 最后拍摄时间 <= '" + EndTime + " 23:59:59.000')"); }
                                if (this.Str_ProcessStatus.Trim() == "选片OK")
                                { strBuilder.Append(" And 选片状态 = 'OK' And (选片时间 >= '" + StartTime + "' And 选片时间 <= '" + EndTime + " 23:59:59.000')"); }
                                if (this.Str_ProcessStatus.Trim() == "取件OK")
                                { strBuilder.Append(" And 取件状态 = 'OK' And (取件日期 >= '" + StartTime + "' And 取件日期 <= '" + EndTime + " 23:59:59.000')"); }
                                if (!string.IsNullOrEmpty(this.Str_Scores1))
                                { strBuilder.Append(" and (摄影助理满意总分>=" + this.Str_Scores1 + " and 摄影助理满意总分<=" + this.Str_Scores2 + ")"); }
                                s = BindSelect5();
                                DataTable dtCount2 = orbll.GetView_Custom("Vw_StaffPerformance_Photograph", StrWhere: strBuilder.ToString() + s.ToString(), ShowColumnName: "Count(ID) CountID").Tables[0];
                                if (dtCount2.Rows.Count > 0)
                                {
                                    if (Convert.ToInt32(dtCount2.Rows[0]["CountID"]) > 0)
                                    {
                                        backgroundWorker.ReportProgress(0, "正在获取'摄影助理前期业绩' ...");
                                        string StrColumnName = "订单号,客户名称,订单类型,收款金额,应收金额,拍摄名称,收款时间,套系类别,套系名称,项目名称,收款类别,付款方式名称,未拍个数,最后拍摄时间,选片状态,选片时间,取件状态,取件日期,副订单,摄影助理满意总分";
                                        DataTable dt_VicePhotographer = orbll.GetView_Custom("Vw_StaffPerformance_Photograph", StrWhere: strBuilder.ToString() + s.ToString(), ShowColumnName: StrColumnName).Tables[0];
                                        for (int t = 0; t < dt_VicePhotographer.Rows.Count; t++)
                                        {
                                            #region
                                            DataGridViewRow dgvr = new DataGridViewRow();
                                            DataGridViewCell cell = null;

                                            //订单号
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_VicePhotographer.Rows[t]["订单号"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //员工
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = StrUserName;
                                            dgvr.Cells.Add(cell);

                                            //职务
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = "摄影助理";
                                            dgvr.Cells.Add(cell);

                                            //客户姓名
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_VicePhotographer.Rows[t]["客户名称"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //收款金额
                                            cell = new DataGridViewTextBoxCell();
                                            if (dt_VicePhotographer.Rows[t]["订单类型"].ToString() != "1")
                                            { cell.Value = Convert.ToDecimal(dt_VicePhotographer.Rows[t]["收款金额"]).ToString("N2"); }
                                            else
                                            { cell.Value = GetChildrenAmount(dt_VicePhotographer.Rows[t]["订单号"].ToString().Trim(), Convert.ToDecimal(dt_VicePhotographer.Rows[t]["应收金额"]), Convert.ToDecimal(dt_VicePhotographer.Rows[t]["收款金额"]), dt_VicePhotographer.Rows[t]["拍摄名称"].ToString()); }
                                            dgvr.Cells.Add(cell);

                                            //收款时间
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_VicePhotographer.Rows[t]["收款时间"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //套系类别
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_VicePhotographer.Rows[t]["套系类别"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //套系名称
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_VicePhotographer.Rows[t]["套系名称"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //应收金额
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_VicePhotographer.Rows[t]["应收金额"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //项目名称
                                            cell = new DataGridViewTextBoxCell();
                                            if (string.IsNullOrEmpty(dt_VicePhotographer.Rows[t]["项目名称"].ToString().Trim()))
                                            { cell.Value = dt_VicePhotographer.Rows[t]["收款类别"].ToString(); }
                                            else { cell.Value = dt_VicePhotographer.Rows[t]["项目名称"].ToString().Trim(); }
                                            dgvr.Cells.Add(cell);

                                            //付款名称
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_VicePhotographer.Rows[t]["付款方式名称"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //拍摄状态
                                            cell = new DataGridViewTextBoxCell();
                                            if (Convert.ToInt32(dt_VicePhotographer.Rows[t]["未拍个数"]) == 0)
                                            { cell.Value = "OK"; }
                                            else { cell.Value = "未拍"; }
                                            dgvr.Cells.Add(cell);

                                            //拍摄时间
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_VicePhotographer.Rows[t]["最后拍摄时间"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //选片状态
                                            cell = new DataGridViewTextBoxCell();
                                            if (dt_VicePhotographer.Rows[t]["选片状态"].ToString() == "OK")
                                            { cell.Value = "OK"; }
                                            else { cell.Value = "未选"; }
                                            dgvr.Cells.Add(cell);

                                            //选片时间
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt_VicePhotographer.Rows[t]["选片时间"], "yyyy-MM-dd HH:mm");
                                            dgvr.Cells.Add(cell);

                                            //取件状态
                                            cell = new DataGridViewTextBoxCell();
                                            if (dt_VicePhotographer.Rows[t]["取件状态"].ToString() == "OK")
                                            { cell.Value = "OK"; }
                                            else { cell.Value = "未取"; }
                                            dgvr.Cells.Add(cell);

                                            //取件时间
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt_VicePhotographer.Rows[t]["取件日期"], "yyyy-MM-dd HH:mm");
                                            dgvr.Cells.Add(cell);

                                            //拍摄名称
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_VicePhotographer.Rows[t]["拍摄名称"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //订单类型
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_VicePhotographer.Rows[t]["订单类型"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //收款类型
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_VicePhotographer.Rows[t]["收款类别"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //副订单
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_VicePhotographer.Rows[t]["副订单"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //摄影助理满意总分
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_VicePhotographer.Rows[t]["摄影助理满意总分"].ToString();
                                            dgvr.Cells.Add(cell);

                                            this.Invoke(new UpdateControl(delegate()
                                            {
                                                this.dgv.Rows.Add(dgvr);
                                            }));
                                            #endregion
                                        }
                                    }
                                }
                                #endregion
                            }
                        }
                    }

                    ConfigureRow = dt_SystemConfigure.Select("Sconfig_Code='MakeupArtistEarly' and Sconfig_IsEnabled=1");
                    if (ConfigureRow.Length > 0)
                    {
                        if (ConfigureRow[0]["Sconfig_Value"].ToString() == "1")
                        {
                            if (this.Str_ProjectTitle.Trim() == "" || this.Str_ProjectTitle.Trim() == "化妆前期")
                            {
                                #region 主化妆师
                                s = "";
                                strBuilder = new StringBuilder();
                                strBuilder.Append(" 收款类别 <> '后期收款'");
                                if (EmployeeName != null && !string.IsNullOrEmpty(EmployeeName))
                                { strBuilder.Append(" And 主化妆ID like '%" + EmployeeName + "%' "); }
                                if (this.Str_ProcessStatus.Trim() == "")
                                { strBuilder.Append(" And 未拍个数 = 0 And (服务前期查询时间 >= '" + StartTime + "' And 服务前期查询时间 <= '" + EndTime + " 23:59:59.000')"); }
                                if (this.Str_ProcessStatus.Trim() == "拍照OK")
                                { strBuilder.Append(" And 未拍个数 = 0 And (最后拍摄时间 >= '" + StartTime + "' And 最后拍摄时间 <= '" + EndTime + " 23:59:59.000')"); }
                                if (this.Str_ProcessStatus.Trim() == "选片OK")
                                { strBuilder.Append(" And 选片状态 = 'OK' And (选片时间 >= '" + StartTime + "' And 选片时间 <= '" + EndTime + " 23:59:59.000')"); }
                                if (this.Str_ProcessStatus.Trim() == "取件OK")
                                { strBuilder.Append(" And 取件状态 = 'OK' And (取件日期 >= '" + StartTime + "' And 取件日期 <= '" + EndTime + " 23:59:59.000')"); }
                                if (!string.IsNullOrEmpty(this.Str_Scores1))
                                { strBuilder.Append(" and (主化妆满意总分>=" + this.Str_Scores1 + " and 主化妆满意总分<=" + this.Str_Scores2 + ")"); }
                                s = BindSelect5();
                                DataTable dtCount1 = orbll.GetView_Custom("Vw_StaffPerformance_Photograph", StrWhere: strBuilder.ToString() + s.ToString(), ShowColumnName: "Count(ID) CountID").Tables[0];
                                if (dtCount1.Rows.Count > 0)
                                {
                                    if (Convert.ToInt32(dtCount1.Rows[0]["CountID"]) > 0)
                                    {
                                        backgroundWorker.ReportProgress(0, "正在获取'主化妆师前期业绩' ...");
                                        string StrColumnName = "订单号,客户名称,订单类型,收款金额,应收金额,拍摄名称,收款时间,套系类别,套系名称,项目名称,收款类别,付款方式名称,未拍个数,最后拍摄时间,选片状态,选片时间,取件状态,取件日期,副订单,主化妆满意总分";
                                        DataTable dt_MainMakeupArtist = orbll.GetView_Custom("Vw_StaffPerformance_Photograph", StrWhere: strBuilder.ToString() + s.ToString(), ShowColumnName: StrColumnName).Tables[0];
                                        for (int t = 0; t < dt_MainMakeupArtist.Rows.Count; t++)
                                        {
                                            #region
                                            DataGridViewRow dgvr = new DataGridViewRow();
                                            DataGridViewCell cell = null;

                                            //订单号
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_MainMakeupArtist.Rows[t]["订单号"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //员工
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = StrUserName;
                                            dgvr.Cells.Add(cell);

                                            //职务
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = "主化妆师";
                                            dgvr.Cells.Add(cell);

                                            //客户姓名
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_MainMakeupArtist.Rows[t]["客户名称"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //收款金额
                                            cell = new DataGridViewTextBoxCell();
                                            if (dt_MainMakeupArtist.Rows[t]["订单类型"].ToString() != "1")
                                            { cell.Value = Convert.ToDecimal(dt_MainMakeupArtist.Rows[t]["收款金额"]).ToString("N2"); }
                                            else
                                            { cell.Value = GetChildrenAmount(dt_MainMakeupArtist.Rows[t]["订单号"].ToString().Trim(), Convert.ToDecimal(dt_MainMakeupArtist.Rows[t]["应收金额"]), Convert.ToDecimal(dt_MainMakeupArtist.Rows[t]["收款金额"]), dt_MainMakeupArtist.Rows[t]["拍摄名称"].ToString()); }
                                            dgvr.Cells.Add(cell);

                                            //收款时间
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_MainMakeupArtist.Rows[t]["收款时间"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //套系类别
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_MainMakeupArtist.Rows[t]["套系类别"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //套系名称
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_MainMakeupArtist.Rows[t]["套系名称"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //应收金额
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = Convert.ToDecimal(dt_MainMakeupArtist.Rows[t]["应收金额"]).ToString("N2").Trim();
                                            dgvr.Cells.Add(cell);

                                            //项目名称
                                            cell = new DataGridViewTextBoxCell();
                                            if (string.IsNullOrEmpty(dt_MainMakeupArtist.Rows[t]["项目名称"].ToString().Trim()))
                                            { cell.Value = dt_MainMakeupArtist.Rows[t]["收款类别"].ToString(); }
                                            else
                                            { cell.Value = dt_MainMakeupArtist.Rows[t]["项目名称"].ToString().Trim(); }
                                            dgvr.Cells.Add(cell);

                                            //付款名称
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_MainMakeupArtist.Rows[t]["付款方式名称"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //拍摄状态
                                            cell = new DataGridViewTextBoxCell();
                                            if (Convert.ToInt32(dt_MainMakeupArtist.Rows[t]["未拍个数"]) == 0)
                                            { cell.Value = "OK"; }
                                            else
                                            { cell.Value = "未拍"; }
                                            dgvr.Cells.Add(cell);

                                            //拍摄时间
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_MainMakeupArtist.Rows[t]["最后拍摄时间"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //选片状态
                                            cell = new DataGridViewTextBoxCell();
                                            if (dt_MainMakeupArtist.Rows[t]["选片状态"].ToString() == "OK")
                                            { cell.Value = "OK"; }
                                            else
                                            { cell.Value = "未选"; }
                                            dgvr.Cells.Add(cell);

                                            //选片时间
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt_MainMakeupArtist.Rows[t]["选片时间"], "yyyy-MM-dd HH:mm");
                                            dgvr.Cells.Add(cell);

                                            //取件状态
                                            cell = new DataGridViewTextBoxCell();
                                            if (dt_MainMakeupArtist.Rows[t]["取件状态"].ToString() == "OK")
                                            { cell.Value = "OK"; }
                                            else
                                            { cell.Value = "未取"; }
                                            dgvr.Cells.Add(cell);

                                            //取件时间
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt_MainMakeupArtist.Rows[t]["取件日期"], "yyyy-MM-dd HH:mm");
                                            dgvr.Cells.Add(cell);

                                            //拍摄名称
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_MainMakeupArtist.Rows[t]["拍摄名称"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //订单类型
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_MainMakeupArtist.Rows[t]["订单类型"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //收款类型
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_MainMakeupArtist.Rows[t]["收款类别"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //副订单
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_MainMakeupArtist.Rows[t]["副订单"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //主化妆满意总分
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_MainMakeupArtist.Rows[t]["主化妆满意总分"].ToString();
                                            dgvr.Cells.Add(cell);
                                            #endregion

                                            this.Invoke(new UpdateControl(delegate()
                                            {
                                                this.dgv.Rows.Add(dgvr);
                                            }));
                                        }
                                    }
                                }
                                #endregion

                                #region 化妆助理
                                s = "";
                                strBuilder = new StringBuilder();
                                strBuilder.Append(" 收款类别 <> '后期收款'");
                                if (EmployeeName != null && !string.IsNullOrEmpty(EmployeeName))
                                { strBuilder.Append(" And 化妆助理ID like '%" + EmployeeName + "%' "); }
                                if (this.Str_ProcessStatus.Trim() == "")
                                { strBuilder.Append(" And 未拍个数 = 0 And (服务前期查询时间 >= '" + StartTime + "' And 服务前期查询时间 <= '" + EndTime + " 23:59:59.000')"); }
                                if (this.Str_ProcessStatus.Trim() == "拍照OK")
                                { strBuilder.Append(" And 未拍个数 = 0 And (最后拍摄时间 >= '" + StartTime + "' And 最后拍摄时间 <= '" + EndTime + " 23:59:59.000')"); }
                                if (this.Str_ProcessStatus.Trim() == "选片OK")
                                { strBuilder.Append(" And 选片状态 = 'OK' And (选片时间 >= '" + StartTime + "' And 选片时间 <= '" + EndTime + " 23:59:59.000')"); }
                                if (this.Str_ProcessStatus.Trim() == "取件OK")
                                { strBuilder.Append(" And 取件状态 = 'OK' And (取件日期 >= '" + StartTime + "' And 取件日期 <= '" + EndTime + " 23:59:59.000')"); }
                                if (!string.IsNullOrEmpty(this.Str_Scores1))
                                { strBuilder.Append(" and (化妆助理满意总分>=" + this.Str_Scores1 + " and 化妆助理满意总分<=" + this.Str_Scores2 + ")"); }
                                s = BindSelect5();
                                DataTable dtCount2 = orbll.GetView_Custom("Vw_StaffPerformance_Photograph", StrWhere: strBuilder.ToString() + s.ToString(), ShowColumnName: "Count(ID) CountID").Tables[0];
                                if (dtCount2.Rows.Count > 0)
                                {
                                    if (Convert.ToInt32(dtCount2.Rows[0]["CountID"]) > 0)
                                    {
                                        backgroundWorker.ReportProgress(0, "正在获取'化妆助理前期业绩' ...");
                                        string StrColumnName = "订单号,客户名称,订单类型,收款金额,应收金额,拍摄名称,收款时间,套系类别,套系名称,项目名称,收款类别,付款方式名称,未拍个数,最后拍摄时间,选片状态,选片时间,取件状态,取件日期,副订单,化妆助理满意总分";
                                        DataTable dt_ViceMakeupArtist = orbll.GetView_Custom("Vw_StaffPerformance_Photograph", StrWhere: strBuilder.ToString() + s.ToString(), ShowColumnName: StrColumnName).Tables[0];
                                        for (int t = 0; t < dt_ViceMakeupArtist.Rows.Count; t++)
                                        {
                                            #region
                                            DataGridViewRow dgvr = new DataGridViewRow();
                                            DataGridViewCell cell = null;

                                            //订单号
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_ViceMakeupArtist.Rows[t]["订单号"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //员工
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = StrUserName;
                                            dgvr.Cells.Add(cell);

                                            //职务
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = "化妆助理";
                                            dgvr.Cells.Add(cell);

                                            //客户姓名
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_ViceMakeupArtist.Rows[t]["客户名称"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //收款金额
                                            cell = new DataGridViewTextBoxCell();
                                            if (dt_ViceMakeupArtist.Rows[t]["订单类型"].ToString() != "1")
                                            { cell.Value = Convert.ToDecimal(dt_ViceMakeupArtist.Rows[t]["收款金额"]).ToString("N2"); }
                                            else { cell.Value = GetChildrenAmount(dt_ViceMakeupArtist.Rows[t]["订单号"].ToString().Trim(), Convert.ToDecimal(dt_ViceMakeupArtist.Rows[t]["应收金额"]), Convert.ToDecimal(dt_ViceMakeupArtist.Rows[t]["收款金额"]), dt_ViceMakeupArtist.Rows[t]["拍摄名称"].ToString()); }
                                            dgvr.Cells.Add(cell);

                                            //收款时间
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_ViceMakeupArtist.Rows[t]["收款时间"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //套系类别
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_ViceMakeupArtist.Rows[t]["套系类别"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //套系名称
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_ViceMakeupArtist.Rows[t]["套系名称"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //应收金额
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = Convert.ToDecimal(dt_ViceMakeupArtist.Rows[t]["应收金额"]).ToString("N2").Trim();
                                            dgvr.Cells.Add(cell);

                                            //项目名称
                                            cell = new DataGridViewTextBoxCell();
                                            if (string.IsNullOrEmpty(dt_ViceMakeupArtist.Rows[t]["项目名称"].ToString().Trim()))
                                            { cell.Value = dt_ViceMakeupArtist.Rows[t]["收款类别"].ToString(); }
                                            else { cell.Value = dt_ViceMakeupArtist.Rows[t]["项目名称"].ToString().Trim(); }
                                            dgvr.Cells.Add(cell);

                                            //付款名称
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_ViceMakeupArtist.Rows[t]["付款方式名称"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //拍摄状态
                                            cell = new DataGridViewTextBoxCell();
                                            if (Convert.ToInt32(dt_ViceMakeupArtist.Rows[t]["未拍个数"]) == 0)
                                            { cell.Value = "OK"; }
                                            else { cell.Value = "未拍"; }
                                            dgvr.Cells.Add(cell);

                                            //拍摄时间
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_ViceMakeupArtist.Rows[t]["最后拍摄时间"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //选片状态
                                            cell = new DataGridViewTextBoxCell();
                                            if (dt_ViceMakeupArtist.Rows[t]["选片状态"].ToString() == "OK")
                                            { cell.Value = "OK"; }
                                            else { cell.Value = "未选"; }
                                            dgvr.Cells.Add(cell);

                                            //选片时间
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt_ViceMakeupArtist.Rows[t]["选片时间"], "yyyy-MM-dd HH:mm");
                                            dgvr.Cells.Add(cell);

                                            //取件状态
                                            cell = new DataGridViewTextBoxCell();
                                            if (dt_ViceMakeupArtist.Rows[t]["取件状态"].ToString() == "OK")
                                            { cell.Value = "OK"; }
                                            else { cell.Value = "未取"; }
                                            dgvr.Cells.Add(cell);

                                            //取件时间
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt_ViceMakeupArtist.Rows[t]["取件日期"], "yyyy-MM-dd HH:mm");
                                            dgvr.Cells.Add(cell);

                                            //拍摄名称
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_ViceMakeupArtist.Rows[t]["拍摄名称"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //订单类型
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_ViceMakeupArtist.Rows[t]["订单类型"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //收款类型
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_ViceMakeupArtist.Rows[t]["收款类别"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //副订单
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_ViceMakeupArtist.Rows[t]["副订单"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //化妆助理满意总分
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_ViceMakeupArtist.Rows[t]["化妆助理满意总分"].ToString();
                                            dgvr.Cells.Add(cell);
                                            #endregion

                                            this.Invoke(new UpdateControl(delegate()
                                            {
                                                this.dgv.Rows.Add(dgvr);
                                            }));
                                        }
                                    }
                                }
                                #endregion
                            }
                        }
                    }

                    ConfigureRow = dt_SystemConfigure.Select("Sconfig_Code='BootDivisionEarly' and Sconfig_IsEnabled=1");
                    if (ConfigureRow.Length > 0)
                    {
                        if (ConfigureRow[0]["Sconfig_Value"].ToString() == "1")
                        {
                            if (this.Str_ProjectTitle.Trim() == "" || this.Str_ProjectTitle.Trim() == "引导前期")
                            {
                                #region 引导师
                                s = "";
                                strBuilder = new StringBuilder();
                                strBuilder.Append(" 收款类别 <> '后期收款'");
                                if (EmployeeName != null && !string.IsNullOrEmpty(EmployeeName))
                                { strBuilder.Append(" And 引导师ID like '%" + EmployeeName + "%' "); }
                                if (this.Str_ProcessStatus.Trim() == "")
                                { strBuilder.Append(" And 未拍个数 = 0 And (服务前期查询时间 >= '" + StartTime + "' And 服务前期查询时间 <= '" + EndTime + " 23:59:59.000')"); }
                                if (this.Str_ProcessStatus.Trim() == "拍照OK")
                                { strBuilder.Append(" And 未拍个数 = 0 And (最后拍摄时间 >= '" + StartTime + "' And 最后拍摄时间 <= '" + EndTime + " 23:59:59.000')"); }
                                if (this.Str_ProcessStatus.Trim() == "选片OK")
                                { strBuilder.Append(" And 选片状态 = 'OK' And (选片时间 >= '" + StartTime + "' And 选片时间 <= '" + EndTime + " 23:59:59.000')"); }
                                if (this.Str_ProcessStatus.Trim() == "取件OK")
                                { strBuilder.Append(" And 取件状态 = 'OK' And (取件日期 >= '" + StartTime + "' And 取件日期 <= '" + EndTime + " 23:59:59.000')"); }
                                if (!string.IsNullOrEmpty(this.Str_Scores1))
                                { strBuilder.Append(" and (引导满意总分>=" + this.Str_Scores1 + " and 引导满意总分<=" + this.Str_Scores2 + ")"); }
                                s = BindSelect5();
                                DataTable dtCount1 = orbll.GetView_Custom("Vw_StaffPerformance_Photograph", StrWhere: strBuilder.ToString() + s.ToString(), ShowColumnName: "Count(ID) CountID").Tables[0];
                                if (dtCount1.Rows.Count > 0)
                                {
                                    if (Convert.ToInt32(dtCount1.Rows[0]["CountID"]) > 0)
                                    {
                                        backgroundWorker.ReportProgress(0, "正在获取'引导师前期业绩' ...");
                                        string StrColumnName = "订单号,客户名称,订单类型,收款金额,应收金额,拍摄名称,收款时间,套系类别,套系名称,项目名称,收款类别,付款方式名称,未拍个数,最后拍摄时间,选片状态,选片时间,取件状态,取件日期,副订单,引导满意总分";
                                        DataTable dt_BootDivisiont = orbll.GetView_Custom("Vw_StaffPerformance_Photograph", StrWhere: strBuilder.ToString() + s.ToString(), ShowColumnName: StrColumnName).Tables[0];
                                        for (int t = 0; t < dt_BootDivisiont.Rows.Count; t++)
                                        {
                                            #region
                                            DataGridViewRow dgvr = new DataGridViewRow();
                                            DataGridViewCell cell = null;

                                            //订单号
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_BootDivisiont.Rows[t]["订单号"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //员工
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = StrUserName;
                                            dgvr.Cells.Add(cell);

                                            //职务
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = "引导师";
                                            dgvr.Cells.Add(cell);

                                            //客户姓名
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_BootDivisiont.Rows[t]["客户名称"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //收款金额
                                            cell = new DataGridViewTextBoxCell();
                                            if (dt_BootDivisiont.Rows[t]["订单类型"].ToString() != "1")
                                            { cell.Value = Convert.ToDecimal(dt_BootDivisiont.Rows[t]["收款金额"]).ToString("N2"); }
                                            else { cell.Value = GetChildrenAmount(dt_BootDivisiont.Rows[t]["订单号"].ToString().Trim(), Convert.ToDecimal(dt_BootDivisiont.Rows[t]["应收金额"]), Convert.ToDecimal(dt_BootDivisiont.Rows[t]["收款金额"]), dt_BootDivisiont.Rows[t]["拍摄名称"].ToString()); }
                                            dgvr.Cells.Add(cell);

                                            //收款时间
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_BootDivisiont.Rows[t]["收款时间"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //套系类别
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_BootDivisiont.Rows[t]["套系类别"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //套系名称
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_BootDivisiont.Rows[t]["套系名称"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //应收金额
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = Convert.ToDecimal(dt_BootDivisiont.Rows[t]["应收金额"]).ToString("N2").Trim();
                                            dgvr.Cells.Add(cell);

                                            //项目名称
                                            cell = new DataGridViewTextBoxCell();
                                            if (string.IsNullOrEmpty(dt_BootDivisiont.Rows[t]["项目名称"].ToString().Trim()))
                                            { cell.Value = dt_BootDivisiont.Rows[t]["收款类别"].ToString(); }
                                            else { cell.Value = dt_BootDivisiont.Rows[t]["项目名称"].ToString().Trim(); }
                                            dgvr.Cells.Add(cell);

                                            //付款名称
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_BootDivisiont.Rows[t]["付款方式名称"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //拍摄状态
                                            cell = new DataGridViewTextBoxCell();
                                            if (Convert.ToInt32(dt_BootDivisiont.Rows[t]["未拍个数"]) == 0)
                                            { cell.Value = "OK"; }
                                            else { cell.Value = "未拍"; }
                                            dgvr.Cells.Add(cell);

                                            //拍摄时间
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_BootDivisiont.Rows[t]["最后拍摄时间"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //选片状态
                                            cell = new DataGridViewTextBoxCell();
                                            if (dt_BootDivisiont.Rows[t]["选片状态"].ToString() == "OK")
                                            { cell.Value = "OK"; }
                                            else { cell.Value = "未选"; }
                                            dgvr.Cells.Add(cell);

                                            //选片时间
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt_BootDivisiont.Rows[t]["选片时间"], "yyyy-MM-dd HH:mm");
                                            dgvr.Cells.Add(cell);

                                            //取件状态
                                            cell = new DataGridViewTextBoxCell();
                                            if (dt_BootDivisiont.Rows[t]["取件状态"].ToString() == "OK")
                                            { cell.Value = "OK"; }
                                            else { cell.Value = "未取"; }
                                            dgvr.Cells.Add(cell);

                                            //取件时间
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt_BootDivisiont.Rows[t]["取件日期"], "yyyy-MM-dd HH:mm");
                                            dgvr.Cells.Add(cell);

                                            //拍摄名称
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_BootDivisiont.Rows[t]["拍摄名称"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //订单类型
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_BootDivisiont.Rows[t]["订单类型"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //收款类型
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_BootDivisiont.Rows[t]["收款类别"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //副订单
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_BootDivisiont.Rows[t]["副订单"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //引导满意总分
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_BootDivisiont.Rows[t]["引导满意总分"].ToString();
                                            dgvr.Cells.Add(cell);
                                            #endregion

                                            this.Invoke(new UpdateControl(delegate()
                                            {
                                                this.dgv.Rows.Add(dgvr);
                                            }));
                                        }
                                    }
                                }
                                #endregion

                                #region 引导助理
                                s = "";
                                strBuilder = new StringBuilder();
                                strBuilder.Append(" 收款类别 <> '后期收款'");
                                if (EmployeeName != null && !string.IsNullOrEmpty(EmployeeName))
                                { strBuilder.Append(" And 引导助理ID like '%" + EmployeeName + "%' "); }
                                if (this.Str_ProcessStatus.Trim() == "")
                                { strBuilder.Append(" And 未拍个数 = 0 And (服务前期查询时间 >= '" + StartTime + "' And 服务前期查询时间 <= '" + EndTime + " 23:59:59.000')"); }
                                if (this.Str_ProcessStatus.Trim() == "拍照OK")
                                { strBuilder.Append(" And 未拍个数 = 0 And (最后拍摄时间 >= '" + StartTime + "' And 最后拍摄时间 <= '" + EndTime + " 23:59:59.000')"); }
                                if (this.Str_ProcessStatus.Trim() == "选片OK")
                                { strBuilder.Append(" And 选片状态 = 'OK' And (选片时间 >= '" + StartTime + "' And 选片时间 <= '" + EndTime + " 23:59:59.000')"); }
                                if (this.Str_ProcessStatus.Trim() == "取件OK")
                                { strBuilder.Append(" And 取件状态 = 'OK' And (取件日期 >= '" + StartTime + "' And 取件日期 <= '" + EndTime + " 23:59:59.000')"); }
                                if (!string.IsNullOrEmpty(this.Str_Scores1))
                                { strBuilder.Append(" and (引导助理满意总分>=" + this.Str_Scores1 + " and 引导助理满意总分<=" + this.Str_Scores2 + ")"); }
                                s = BindSelect5();
                                DataTable dtCount2 = orbll.GetView_Custom("Vw_StaffPerformance_Photograph", StrWhere: strBuilder.ToString() + s.ToString(), ShowColumnName: "Count(ID) CountID").Tables[0];
                                if (dtCount2.Rows.Count > 0)
                                {
                                    if (Convert.ToInt32(dtCount2.Rows[0]["CountID"]) > 0)
                                    {
                                        backgroundWorker.ReportProgress(0, "正在获取'引导师助理前期业绩' ...");
                                        string StrColumnName = "订单号,客户名称,订单类型,收款金额,应收金额,拍摄名称,收款时间,套系类别,套系名称,项目名称,收款类别,付款方式名称,未拍个数,最后拍摄时间,选片状态,选片时间,取件状态,取件日期,副订单,引导助理满意总分";
                                        DataTable dt_BootDivisiont = orbll.GetView_Custom("Vw_StaffPerformance_Photograph", StrWhere: strBuilder.ToString() + s.ToString(), ShowColumnName: StrColumnName).Tables[0];
                                        for (int t = 0; t < dt_BootDivisiont.Rows.Count; t++)
                                        {
                                            #region
                                            DataGridViewRow dgvr = new DataGridViewRow();
                                            DataGridViewCell cell = null;

                                            //订单号
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_BootDivisiont.Rows[t]["订单号"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //员工
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = StrUserName;
                                            dgvr.Cells.Add(cell);

                                            //职务
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = "引导助理";
                                            dgvr.Cells.Add(cell);

                                            //客户姓名
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_BootDivisiont.Rows[t]["客户名称"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //收款金额
                                            cell = new DataGridViewTextBoxCell();
                                            if (dt_BootDivisiont.Rows[t]["订单类型"].ToString() != "1")
                                            { cell.Value = Convert.ToDecimal(dt_BootDivisiont.Rows[t]["收款金额"]).ToString("N2"); }
                                            else { cell.Value = GetChildrenAmount(dt_BootDivisiont.Rows[t]["订单号"].ToString().Trim(), Convert.ToDecimal(dt_BootDivisiont.Rows[t]["应收金额"]), Convert.ToDecimal(dt_BootDivisiont.Rows[t]["收款金额"]), dt_BootDivisiont.Rows[t]["拍摄名称"].ToString()); }
                                            dgvr.Cells.Add(cell);

                                            //收款时间
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_BootDivisiont.Rows[t]["收款时间"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //套系类别
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_BootDivisiont.Rows[t]["套系类别"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //套系名称
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_BootDivisiont.Rows[t]["套系名称"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //应收金额
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = Convert.ToDecimal(dt_BootDivisiont.Rows[t]["应收金额"]).ToString("N2").Trim();
                                            dgvr.Cells.Add(cell);

                                            //项目名称
                                            cell = new DataGridViewTextBoxCell();
                                            if (string.IsNullOrEmpty(dt_BootDivisiont.Rows[t]["项目名称"].ToString().Trim()))
                                            { cell.Value = dt_BootDivisiont.Rows[t]["收款类别"].ToString(); }
                                            else { cell.Value = dt_BootDivisiont.Rows[t]["项目名称"].ToString().Trim(); }
                                            dgvr.Cells.Add(cell);

                                            //付款名称
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_BootDivisiont.Rows[t]["付款方式名称"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //拍摄状态
                                            cell = new DataGridViewTextBoxCell();
                                            if (Convert.ToInt32(dt_BootDivisiont.Rows[t]["未拍个数"]) == 0)
                                            { cell.Value = "OK"; }
                                            else { cell.Value = "未拍"; }
                                            dgvr.Cells.Add(cell);

                                            //拍摄时间
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_BootDivisiont.Rows[t]["最后拍摄时间"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //选片状态
                                            cell = new DataGridViewTextBoxCell();
                                            if (dt_BootDivisiont.Rows[t]["选片状态"].ToString() == "OK")
                                            { cell.Value = "OK"; }
                                            else { cell.Value = "未选"; }
                                            dgvr.Cells.Add(cell);

                                            //选片时间
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt_BootDivisiont.Rows[t]["选片时间"], "yyyy-MM-dd HH:mm");
                                            dgvr.Cells.Add(cell);

                                            //取件状态
                                            cell = new DataGridViewTextBoxCell();
                                            if (dt_BootDivisiont.Rows[t]["取件状态"].ToString() == "OK")
                                            { cell.Value = "OK"; }
                                            else { cell.Value = "未取"; }
                                            dgvr.Cells.Add(cell);

                                            //取件时间
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt_BootDivisiont.Rows[t]["取件日期"], "yyyy-MM-dd HH:mm");
                                            dgvr.Cells.Add(cell);

                                            //拍摄名称
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_BootDivisiont.Rows[t]["拍摄名称"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //订单类型
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_BootDivisiont.Rows[t]["订单类型"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //收款类型
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_BootDivisiont.Rows[t]["收款类别"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //副订单
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_BootDivisiont.Rows[t]["副订单"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //引导满意总分
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_BootDivisiont.Rows[t]["引导助理满意总分"].ToString();
                                            dgvr.Cells.Add(cell);
                                            #endregion

                                            this.Invoke(new UpdateControl(delegate()
                                            {
                                                this.dgv.Rows.Add(dgvr);
                                            }));
                                        }
                                    }
                                }
                                #endregion
                            }
                        }
                    }

                    ConfigureRow = dt_SystemConfigure.Select("Sconfig_Code='FirstRepairDivisionEarly' and Sconfig_IsEnabled=1");
                    if (ConfigureRow.Length > 0)
                    {
                        if (ConfigureRow[0]["Sconfig_Value"].ToString() == "1")
                        {
                            if (this.Str_ProjectTitle.Trim() == "" || this.Str_ProjectTitle.Trim() == "初修前期")
                            {
                                #region 初修师
                                s = "";
                                strBuilder = new StringBuilder();
                                strBuilder.Append(" 收款类别 <> '后期收款'");
                                if (EmployeeName != null && !string.IsNullOrEmpty(EmployeeName))
                                { strBuilder.Append(" And 初修师ID like '%" + EmployeeName + "%' "); }
                                if (this.Str_ProcessStatus.Trim() == "")
                                { strBuilder.Append(" And 未拍个数 = 0 And 服务前期初修查询状态 = '2' And (服务前期初修查询时间 >= '" + StartTime + "' And 服务前期初修查询时间 <= '" + EndTime + " 23:59:59.000')"); }
                                if (this.Str_ProcessStatus.Trim() == "拍照OK")
                                { strBuilder.Append(" And 未拍个数 = 0 And (最后拍摄时间 >= '" + StartTime + "' And 最后拍摄时间 <= '" + EndTime + " 23:59:59.000')"); }
                                if (this.Str_ProcessStatus.Trim() == "选片OK")
                                { strBuilder.Append(" And 选片状态 = 'OK' And (选片时间 >= '" + StartTime + "' And 选片时间 <= '" + EndTime + " 23:59:59.000')"); }
                                if (this.Str_ProcessStatus.Trim() == "取件OK")
                                { strBuilder.Append(" And 取件状态 = 'OK' And (取件日期 >= '" + StartTime + "' And 取件日期 <= '" + EndTime + " 23:59:59.000')"); }
                                if (!string.IsNullOrEmpty(this.Str_Scores1))
                                { strBuilder.Append(" and (初修师满意总分>=" + this.Str_Scores1 + " and 初修师满意总分<=" + this.Str_Scores2 + ")"); }
                                s = BindSelect5();
                                DataTable dtCount = orbll.GetView_Custom("Vw_StaffPerformance_Photograph", StrWhere: strBuilder.ToString() + s.ToString(), ShowColumnName: "Count(ID) CountID").Tables[0];
                                if (dtCount.Rows.Count > 0)
                                {
                                    if (Convert.ToInt32(dtCount.Rows[0]["CountID"]) > 0)
                                    {
                                        backgroundWorker.ReportProgress(0, "正在获取'初修师前期业绩' ...");
                                        string StrColumnName = "订单号,客户名称,订单类型,收款金额,应收金额,拍摄名称,收款时间,套系类别,套系名称,项目名称,收款类别,付款方式名称,未拍个数,最后拍摄时间,选片状态,选片时间,取件状态,取件日期,副订单,初修师满意总分";
                                        DataTable dt_EarlyRepair = orbll.GetView_Custom("Vw_StaffPerformance_Photograph", StrWhere: strBuilder.ToString() + s.ToString(), ShowColumnName: StrColumnName).Tables[0];
                                        for (int t = 0; t < dt_EarlyRepair.Rows.Count; t++)
                                        {
                                            #region
                                            DataGridViewRow dgvr = new DataGridViewRow();
                                            DataGridViewCell cell = null;

                                            //订单号
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_EarlyRepair.Rows[t]["订单号"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //员工
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = StrUserName;
                                            dgvr.Cells.Add(cell);

                                            //职务
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = "初修师";
                                            dgvr.Cells.Add(cell);

                                            //客户姓名
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_EarlyRepair.Rows[t]["客户名称"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //收款金额
                                            cell = new DataGridViewTextBoxCell();
                                            if (dt_EarlyRepair.Rows[t]["订单类型"].ToString() != "1")
                                            { cell.Value = Convert.ToDecimal(dt_EarlyRepair.Rows[t]["收款金额"]).ToString("N2"); }
                                            else { cell.Value = GetChildrenAmount(dt_EarlyRepair.Rows[t]["订单号"].ToString().Trim(), Convert.ToDecimal(dt_EarlyRepair.Rows[t]["应收金额"]), Convert.ToDecimal(dt_EarlyRepair.Rows[t]["收款金额"]), dt_EarlyRepair.Rows[t]["拍摄名称"].ToString()); }
                                            dgvr.Cells.Add(cell);

                                            //收款时间
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_EarlyRepair.Rows[t]["收款时间"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //套系类别
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_EarlyRepair.Rows[t]["套系类别"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //套系名称
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_EarlyRepair.Rows[t]["套系名称"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //应收金额
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = Convert.ToDecimal(dt_EarlyRepair.Rows[t]["应收金额"]).ToString("N2").Trim();
                                            dgvr.Cells.Add(cell);

                                            //项目名称
                                            cell = new DataGridViewTextBoxCell();
                                            if (string.IsNullOrEmpty(dt_EarlyRepair.Rows[t]["项目名称"].ToString().Trim()))
                                            { cell.Value = dt_EarlyRepair.Rows[t]["收款类别"].ToString(); }
                                            else { cell.Value = dt_EarlyRepair.Rows[t]["项目名称"].ToString().Trim(); }
                                            dgvr.Cells.Add(cell);

                                            //付款名称
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_EarlyRepair.Rows[t]["付款方式名称"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //拍摄状态
                                            cell = new DataGridViewTextBoxCell();
                                            if (Convert.ToInt32(dt_EarlyRepair.Rows[t]["未拍个数"]) == 0)
                                            { cell.Value = "OK"; }
                                            else { cell.Value = "未拍"; }
                                            dgvr.Cells.Add(cell);

                                            //拍摄时间
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_EarlyRepair.Rows[t]["最后拍摄时间"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //选片状态
                                            cell = new DataGridViewTextBoxCell();
                                            if (dt_EarlyRepair.Rows[t]["选片状态"].ToString() == "OK")
                                            { cell.Value = "OK"; }
                                            else { cell.Value = "未选"; }
                                            dgvr.Cells.Add(cell);

                                            //选片时间
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt_EarlyRepair.Rows[t]["选片时间"], "yyyy-MM-dd HH:mm");
                                            dgvr.Cells.Add(cell);

                                            //取件状态
                                            cell = new DataGridViewTextBoxCell();
                                            if (dt_EarlyRepair.Rows[t]["取件状态"].ToString() == "OK")
                                            { cell.Value = "OK"; }
                                            else { cell.Value = "未取"; }
                                            dgvr.Cells.Add(cell);

                                            //取件时间
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt_EarlyRepair.Rows[t]["取件日期"], "yyyy-MM-dd HH:mm");
                                            dgvr.Cells.Add(cell);

                                            //拍摄名称
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_EarlyRepair.Rows[t]["拍摄名称"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //订单类型
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_EarlyRepair.Rows[t]["订单类型"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //收款类型
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_EarlyRepair.Rows[t]["收款类别"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //副订单
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_EarlyRepair.Rows[t]["副订单"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //初修师满意总分
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_EarlyRepair.Rows[t]["初修师满意总分"].ToString();
                                            dgvr.Cells.Add(cell);
                                            #endregion

                                            this.Invoke(new UpdateControl(delegate()
                                            {
                                                this.dgv.Rows.Add(dgvr);
                                            }));
                                        }
                                    }
                                }
                                #endregion
                            }
                        }
                    }

                    ConfigureRow = dt_SystemConfigure.Select("Sconfig_Code='FinishingDivisionEarly' and Sconfig_IsEnabled=1");
                    if (ConfigureRow.Length > 0)
                    {
                        if (ConfigureRow[0]["Sconfig_Value"].ToString() == "1")
                        {
                            if (this.Str_ProjectTitle.Trim() == "" || this.Str_ProjectTitle.Trim() == "精修前期")
                            {
                                #region 精修师
                                s = "";
                                strBuilder = new StringBuilder();
                                strBuilder.Append(" 收款类别 <> '后期收款'");
                                if (EmployeeName != null && !string.IsNullOrEmpty(EmployeeName))
                                { strBuilder.Append(" And 精修师ID like '%" + EmployeeName + "%' "); }
                                if (this.Str_ProcessStatus.Trim() == "")
                                { strBuilder.Append(" And 未拍个数 = 0 And 服务前期精修查询状态 = '2' And (服务前期精修查询时间 >= '" + StartTime + "' And 服务前期精修查询时间 <= '" + EndTime + " 23:59:59.000')"); }
                                if (this.Str_ProcessStatus.Trim() == "拍照OK")
                                { strBuilder.Append(" And 未拍个数 = 0 And (最后拍摄时间 >= '" + StartTime + "' And 最后拍摄时间 <= '" + EndTime + " 23:59:59.000')"); }
                                if (this.Str_ProcessStatus.Trim() == "选片OK")
                                { strBuilder.Append(" And 选片状态 = 'OK' And (选片时间 >= '" + StartTime + "' And 选片时间 <= '" + EndTime + " 23:59:59.000')"); }
                                if (this.Str_ProcessStatus.Trim() == "取件OK")
                                { strBuilder.Append(" And 取件状态 = 'OK' And (取件日期 >= '" + StartTime + "' And 取件日期 <= '" + EndTime + " 23:59:59.000')"); }
                                if (!string.IsNullOrEmpty(this.Str_Scores1))
                                { strBuilder.Append(" and (精修师满意总分>=" + this.Str_Scores1 + " and 精修师满意总分<=" + this.Str_Scores2 + ")"); }
                                s = BindSelect5();
                                DataTable dtCount = orbll.GetView_Custom("Vw_StaffPerformance_Photograph", StrWhere: strBuilder.ToString() + s.ToString(), ShowColumnName: "Count(ID) CountID").Tables[0];
                                if (dtCount.Rows.Count > 0)
                                {
                                    if (Convert.ToInt32(dtCount.Rows[0]["CountID"]) > 0)
                                    {
                                        backgroundWorker.ReportProgress(0, "正在获取'精修师前期业绩' ...");
                                        string StrColumnName = "订单号,客户名称,订单类型,收款金额,应收金额,拍摄名称,收款时间,套系类别,套系名称,项目名称,收款类别,付款方式名称,未拍个数,最后拍摄时间,选片状态,选片时间,取件状态,取件日期,副订单,精修师满意总分";
                                        DataTable dt_Refinement = orbll.GetView_Custom("Vw_StaffPerformance_Photograph", StrWhere: strBuilder.ToString() + s.ToString(), ShowColumnName: StrColumnName).Tables[0];
                                        for (int t = 0; t < dt_Refinement.Rows.Count; t++)
                                        {
                                            #region
                                            DataGridViewRow dgvr = new DataGridViewRow();
                                            DataGridViewCell cell = null;

                                            //订单号
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_Refinement.Rows[t]["订单号"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //员工
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = StrUserName;
                                            dgvr.Cells.Add(cell);

                                            //职务
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = "精修师";
                                            dgvr.Cells.Add(cell);

                                            //客户姓名
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_Refinement.Rows[t]["客户名称"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //收款金额
                                            cell = new DataGridViewTextBoxCell();
                                            if (dt_Refinement.Rows[t]["订单类型"].ToString() != "1")
                                            { cell.Value = Convert.ToDecimal(dt_Refinement.Rows[t]["收款金额"]).ToString("N2"); }
                                            else { cell.Value = GetChildrenAmount(dt_Refinement.Rows[t]["订单号"].ToString().Trim(), Convert.ToDecimal(dt_Refinement.Rows[t]["应收金额"]), Convert.ToDecimal(dt_Refinement.Rows[t]["收款金额"]), dt_Refinement.Rows[t]["拍摄名称"].ToString()); }
                                            dgvr.Cells.Add(cell);

                                            //收款时间
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_Refinement.Rows[t]["收款时间"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //套系类别
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_Refinement.Rows[t]["套系类别"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //套系名称
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_Refinement.Rows[t]["套系名称"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //应收金额
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = Convert.ToDecimal(dt_Refinement.Rows[t]["应收金额"]).ToString("N2").Trim();
                                            dgvr.Cells.Add(cell);

                                            //项目名称
                                            cell = new DataGridViewTextBoxCell();
                                            if (string.IsNullOrEmpty(dt_Refinement.Rows[t]["项目名称"].ToString().Trim()))
                                            { cell.Value = dt_Refinement.Rows[t]["收款类别"].ToString(); }
                                            else { cell.Value = dt_Refinement.Rows[t]["项目名称"].ToString().Trim(); }
                                            dgvr.Cells.Add(cell);

                                            //付款名称
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_Refinement.Rows[t]["付款方式名称"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //拍摄状态
                                            cell = new DataGridViewTextBoxCell();
                                            if (Convert.ToInt32(dt_Refinement.Rows[t]["未拍个数"]) == 0)
                                            { cell.Value = "OK"; }
                                            else { cell.Value = "未拍"; }
                                            dgvr.Cells.Add(cell);

                                            //拍摄时间
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_Refinement.Rows[t]["最后拍摄时间"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //选片状态
                                            cell = new DataGridViewTextBoxCell();
                                            if (dt_Refinement.Rows[t]["选片状态"].ToString() == "OK")
                                            { cell.Value = "OK"; }
                                            else { cell.Value = "未选"; }
                                            dgvr.Cells.Add(cell);

                                            //选片时间
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt_Refinement.Rows[t]["选片时间"], "yyyy-MM-dd HH:mm");
                                            dgvr.Cells.Add(cell);

                                            //取件状态
                                            cell = new DataGridViewTextBoxCell();
                                            if (dt_Refinement.Rows[t]["取件状态"].ToString() == "OK")
                                            { cell.Value = "OK"; }
                                            else { cell.Value = "未取"; }
                                            dgvr.Cells.Add(cell);

                                            //取件时间
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt_Refinement.Rows[t]["取件日期"], "yyyy-MM-dd HH:mm");
                                            dgvr.Cells.Add(cell);

                                            //拍摄名称
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_Refinement.Rows[t]["拍摄名称"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //订单类型
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_Refinement.Rows[t]["订单类型"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //收款类型
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_Refinement.Rows[t]["收款类别"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //副订单
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_Refinement.Rows[t]["副订单"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //精修师满意总分
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_Refinement.Rows[t]["精修师满意总分"].ToString();
                                            dgvr.Cells.Add(cell);
                                            #endregion

                                            this.Invoke(new UpdateControl(delegate()
                                            {
                                                this.dgv.Rows.Add(dgvr);
                                            }));
                                        }
                                    }
                                }
                                #endregion
                            }
                        }
                    }

                    ConfigureRow = dt_SystemConfigure.Select("Sconfig_Code='DesignersEarly' and Sconfig_IsEnabled=1");
                    if (ConfigureRow.Length > 0)
                    {
                        if (ConfigureRow[0]["Sconfig_Value"].ToString() == "1")
                        {
                            if (this.Str_ProjectTitle.Trim() == "" || this.Str_ProjectTitle.Trim() == "设计前期")
                            {
                                #region 设计师
                                s = "";
                                strBuilder = new StringBuilder();
                                strBuilder.Append(" 收款类别 <> '后期收款'");
                                if (EmployeeName != null && !string.IsNullOrEmpty(EmployeeName))
                                { strBuilder.Append(" And 设计师ID like '%" + EmployeeName + "%' "); }
                                if (this.Str_ProcessStatus.Trim() == "")
                                { strBuilder.Append(" And 未拍个数 = 0 And 服务前期设计查询状态 = '2' And (服务前期设计查询时间 >= '" + StartTime + "' And 服务前期设计查询时间 <= '" + EndTime + " 23:59:59.000')"); }
                                if (this.Str_ProcessStatus.Trim() == "拍照OK")
                                { strBuilder.Append(" And 未拍个数 = 0 And (最后拍摄时间 >= '" + StartTime + "' And 最后拍摄时间 <= '" + EndTime + " 23:59:59.000')"); }
                                if (this.Str_ProcessStatus.Trim() == "选片OK")
                                { strBuilder.Append(" And 选片状态 = 'OK' And (选片时间 >= '" + StartTime + "' And 选片时间 <= '" + EndTime + " 23:59:59.000')"); }
                                if (this.Str_ProcessStatus.Trim() == "取件OK")
                                { strBuilder.Append(" And 取件状态 = 'OK' And (取件日期 >= '" + StartTime + "' And 取件日期 <= '" + EndTime + " 23:59:59.000')"); }
                                if (!string.IsNullOrEmpty(this.Str_Scores1))
                                { strBuilder.Append(" and (设计师满意总分>=" + this.Str_Scores1 + " and 设计师满意总分<=" + this.Str_Scores2 + ")"); }
                                s = BindSelect5();
                                DataTable dtCount = orbll.GetView_Custom("Vw_StaffPerformance_Photograph", StrWhere: strBuilder.ToString() + s.ToString(), ShowColumnName: "Count(ID) CountID").Tables[0];
                                if (dtCount.Rows.Count > 0)
                                {
                                    if (Convert.ToInt32(dtCount.Rows[0]["CountID"]) > 0)
                                    {
                                        backgroundWorker.ReportProgress(0, "正在获取'设计师前期业绩' ...");
                                        string StrColumnName = "订单号,客户名称,订单类型,收款金额,应收金额,拍摄名称,收款时间,套系类别,套系名称,项目名称,收款类别,付款方式名称,未拍个数,最后拍摄时间,选片状态,选片时间,取件状态,取件日期,副订单,设计师满意总分";
                                        DataTable dt_Designer = orbll.GetView_Custom("Vw_StaffPerformance_Photograph", StrWhere: strBuilder.ToString() + s.ToString(), ShowColumnName: StrColumnName).Tables[0];
                                        for (int t = 0; t < dt_Designer.Rows.Count; t++)
                                        {
                                            #region
                                            DataGridViewRow dgvr = new DataGridViewRow();
                                            DataGridViewCell cell = null;

                                            //订单号
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_Designer.Rows[t]["订单号"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //员工
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = StrUserName;
                                            dgvr.Cells.Add(cell);

                                            //职务
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = "设计师";
                                            dgvr.Cells.Add(cell);

                                            //客户姓名
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_Designer.Rows[t]["客户名称"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //收款金额
                                            cell = new DataGridViewTextBoxCell();
                                            if (dt_Designer.Rows[t]["订单类型"].ToString() != "1")
                                            { cell.Value = Convert.ToDecimal(dt_Designer.Rows[t]["收款金额"]).ToString("N2"); }
                                            else
                                            { cell.Value = GetChildrenAmount(dt_Designer.Rows[t]["订单号"].ToString().Trim(), Convert.ToDecimal(dt_Designer.Rows[t]["应收金额"]), Convert.ToDecimal(dt_Designer.Rows[t]["收款金额"]), dt_Designer.Rows[t]["拍摄名称"].ToString()); }
                                            dgvr.Cells.Add(cell);

                                            //收款时间
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_Designer.Rows[t]["收款时间"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //套系类别
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_Designer.Rows[t]["套系类别"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //套系名称
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_Designer.Rows[t]["套系名称"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //应收金额
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = Convert.ToDecimal(dt_Designer.Rows[t]["应收金额"]).ToString("N2").Trim();
                                            dgvr.Cells.Add(cell);

                                            //项目名称
                                            cell = new DataGridViewTextBoxCell();
                                            if (string.IsNullOrEmpty(dt_Designer.Rows[t]["项目名称"].ToString().Trim()))
                                            { cell.Value = dt_Designer.Rows[t]["收款类别"].ToString(); }
                                            else
                                            { cell.Value = dt_Designer.Rows[t]["项目名称"].ToString().Trim(); }
                                            dgvr.Cells.Add(cell);

                                            //付款名称
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_Designer.Rows[t]["付款方式名称"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //拍摄状态
                                            cell = new DataGridViewTextBoxCell();
                                            if (Convert.ToInt32(dt_Designer.Rows[t]["未拍个数"]) == 0)
                                            { cell.Value = "OK"; }
                                            else
                                            { cell.Value = "未拍"; }
                                            dgvr.Cells.Add(cell);

                                            //拍摄时间
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_Designer.Rows[t]["最后拍摄时间"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //选片状态
                                            cell = new DataGridViewTextBoxCell();
                                            if (dt_Designer.Rows[t]["选片状态"].ToString() == "OK")
                                            { cell.Value = "OK"; }
                                            else
                                            { cell.Value = "未选"; }
                                            dgvr.Cells.Add(cell);

                                            //选片时间
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt_Designer.Rows[t]["选片时间"], "yyyy-MM-dd HH:mm");
                                            dgvr.Cells.Add(cell);

                                            //取件状态
                                            cell = new DataGridViewTextBoxCell();
                                            if (dt_Designer.Rows[t]["取件状态"].ToString() == "OK")
                                            { cell.Value = "OK"; }
                                            else
                                            { cell.Value = "未取"; }
                                            dgvr.Cells.Add(cell);

                                            //取件时间
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt_Designer.Rows[t]["取件日期"], "yyyy-MM-dd HH:mm");
                                            dgvr.Cells.Add(cell);

                                            //拍摄名称
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_Designer.Rows[t]["拍摄名称"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //订单类型
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_Designer.Rows[t]["订单类型"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //收款类型
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_Designer.Rows[t]["收款类别"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //副订单
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_Designer.Rows[t]["副订单"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //设计师满意总分
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_Designer.Rows[t]["设计师满意总分"].ToString();
                                            dgvr.Cells.Add(cell);
                                            #endregion

                                            this.Invoke(new UpdateControl(delegate()
                                            {
                                                this.dgv.Rows.Add(dgvr);
                                            }));
                                        }
                                    }
                                }
                                #endregion
                            }
                        }
                    }
                    #endregion
                }
                if (this.Str_ItemCategory.Trim() == "" || this.Str_ItemCategory.Trim() == "服务后期")
                {
                    #region 选片二销业绩
                    DataRow[] ConfigureRow = dt_SystemConfigure.Select("Sconfig_Code='PhotographerSelectionFilms' and Sconfig_IsEnabled=1");
                    if (ConfigureRow.Length > 0)
                    {
                        if (ConfigureRow[0]["Sconfig_Value"].ToString() == "1")
                        {
                            if (this.Str_ProjectTitle.Trim() == "" || this.Str_ProjectTitle.Trim() == "摄影选片二销")
                            {
                                #region 主摄影师
                                s = "";
                                strBuilder = new StringBuilder();
                                if (EmployeeName != null && !string.IsNullOrEmpty(EmployeeName))
                                { strBuilder.Append(" And 主摄影师ID like '%" + EmployeeName + "%' "); }
                                if (this.Str_ProcessStatus.Trim() == "")
                                { strBuilder.Append(" And 未拍个数 = 0 And (收款时间 >= '" + StartTime + "' And 收款时间 <= '" + EndTime + " 23:59:59.000')"); }
                                if (this.Str_ProcessStatus.Trim() == "拍照OK")
                                { strBuilder.Append(" And 未拍个数 = 0 And (最后拍摄时间 >= '" + StartTime + "' And 最后拍摄时间 <= '" + EndTime + " 23:59:59.000')"); }
                                if (this.Str_ProcessStatus.Trim() == "选片OK")
                                { strBuilder.Append(" And 选片状态 = 'OK' And (选片时间 >= '" + StartTime + "' And 选片时间 <= '" + EndTime + " 23:59:59.000')"); }
                                if (this.Str_ProcessStatus.Trim() == "取件OK")
                                { strBuilder.Append(" And 取件状态 = 'OK' And (取件日期 >= '" + StartTime + "' And 取件日期 <= '" + EndTime + " 23:59:59.000')"); }
                                if (!string.IsNullOrEmpty(this.Str_Scores1))
                                { strBuilder.Append(" and (主摄影满意总分>=" + this.Str_Scores1 + " and 主摄影满意总分<=" + this.Str_Scores2 + ")"); }
                                s = BindSelect5();
                                DataTable dtCount1 = orbll.GetView_Custom("Vw_StaffPerformance_Photograph", StrWhere: "二销类别编号='BEBCABBAAHFCJBJGJ'" + strBuilder.ToString() + s.ToString(), ShowColumnName: "Count(ID) CountID").Tables[0];
                                if (dtCount1.Rows.Count > 0)
                                {
                                    if (Convert.ToInt32(dtCount1.Rows[0]["CountID"]) > 0)
                                    {
                                        backgroundWorker.ReportProgress(0, "正在获取'主摄影师选片二销业绩' ...");
                                        string StrColumnName = "订单号,客户名称,收款金额,收款时间,套系类别,套系名称,应收金额,项目名称,收款类别,付款方式名称,未拍个数,最后拍摄时间,选片状态,选片时间,取件状态,取件日期,拍摄名称,订单类型,副订单,主摄影满意总分";
                                        DataTable dt_MainPhotographer = orbll.GetView_Custom("Vw_StaffPerformance_Photograph", StrWhere: "二销类别编号='BEBCABBAAHFCJBJGJ'" + strBuilder.ToString() + s.ToString(), ShowColumnName: StrColumnName).Tables[0];
                                        for (int t = 0; t < dt_MainPhotographer.Rows.Count; t++)
                                        {
                                            #region
                                            DataGridViewRow dgvr = new DataGridViewRow();
                                            DataGridViewCell cell = null;

                                            //订单号
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_MainPhotographer.Rows[t]["订单号"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //员工
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = StrUserName;
                                            dgvr.Cells.Add(cell);

                                            //职务
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = "主摄影选片二销";
                                            dgvr.Cells.Add(cell);

                                            //客户姓名
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_MainPhotographer.Rows[t]["客户名称"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //收款金额
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = Convert.ToDecimal(dt_MainPhotographer.Rows[t]["收款金额"]).ToString("N2");
                                            dgvr.Cells.Add(cell);

                                            //收款时间
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_MainPhotographer.Rows[t]["收款时间"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //套系类别
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_MainPhotographer.Rows[t]["套系类别"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //套系名称
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_MainPhotographer.Rows[t]["套系名称"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //应收金额
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = Convert.ToDecimal(dt_MainPhotographer.Rows[t]["应收金额"]).ToString("N2").Trim();
                                            dgvr.Cells.Add(cell);

                                            //项目名称
                                            cell = new DataGridViewTextBoxCell();
                                            if (string.IsNullOrEmpty(dt_MainPhotographer.Rows[t]["项目名称"].ToString().Trim()))
                                            { cell.Value = dt_MainPhotographer.Rows[t]["收款类别"].ToString(); }
                                            else { cell.Value = dt_MainPhotographer.Rows[t]["项目名称"].ToString().Trim(); }
                                            dgvr.Cells.Add(cell);

                                            //付款名称
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_MainPhotographer.Rows[t]["付款方式名称"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //拍摄状态
                                            cell = new DataGridViewTextBoxCell();
                                            if (Convert.ToInt32(dt_MainPhotographer.Rows[t]["未拍个数"]) == 0)
                                            { cell.Value = "OK"; }
                                            else { cell.Value = "未拍"; }
                                            dgvr.Cells.Add(cell);

                                            //拍摄时间
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_MainPhotographer.Rows[t]["最后拍摄时间"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //选片状态
                                            cell = new DataGridViewTextBoxCell();
                                            if (dt_MainPhotographer.Rows[t]["选片状态"].ToString() == "OK")
                                            { cell.Value = "OK"; }
                                            else { cell.Value = "未选"; }
                                            dgvr.Cells.Add(cell);

                                            //选片时间
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt_MainPhotographer.Rows[t]["选片时间"], "yyyy-MM-dd HH:mm");
                                            dgvr.Cells.Add(cell);

                                            //取件状态
                                            cell = new DataGridViewTextBoxCell();
                                            if (dt_MainPhotographer.Rows[t]["取件状态"].ToString() == "OK")
                                            { cell.Value = "OK"; }
                                            else { cell.Value = "未取"; }
                                            dgvr.Cells.Add(cell);

                                            //取件时间
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt_MainPhotographer.Rows[t]["取件日期"], "yyyy-MM-dd HH:mm");
                                            dgvr.Cells.Add(cell);

                                            //拍摄名称
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_MainPhotographer.Rows[t]["拍摄名称"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //订单类型
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_MainPhotographer.Rows[t]["订单类型"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //收款类型
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_MainPhotographer.Rows[t]["收款类别"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //副订单
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_MainPhotographer.Rows[t]["副订单"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //主摄影满意总分
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_MainPhotographer.Rows[t]["主摄影满意总分"].ToString();
                                            dgvr.Cells.Add(cell);
                                            #endregion

                                            this.Invoke(new UpdateControl(delegate()
                                            {
                                                this.dgv.Rows.Add(dgvr);
                                            }));
                                        }
                                    }
                                }
                                #endregion

                                #region 摄影助理
                                s = "";
                                strBuilder = new StringBuilder();
                                if (EmployeeName != null && !string.IsNullOrEmpty(EmployeeName))
                                { strBuilder.Append(" And 摄影助理ID like '%" + EmployeeName + "%' "); }
                                if (this.Str_ProcessStatus.Trim() == "")
                                { strBuilder.Append(" And 未拍个数 = 0 And (收款时间 >= '" + StartTime + "' And 收款时间 <= '" + EndTime + " 23:59:59.000')"); }
                                if (this.Str_ProcessStatus.Trim() == "拍照OK")
                                { strBuilder.Append(" And 未拍个数 = 0 And (最后拍摄时间 >= '" + StartTime + "' And 最后拍摄时间 <= '" + EndTime + " 23:59:59.000')"); }
                                if (this.Str_ProcessStatus.Trim() == "选片OK")
                                { strBuilder.Append(" And 选片状态 = 'OK' And (选片时间 >= '" + StartTime + "' And 选片时间 <= '" + EndTime + " 23:59:59.000')"); }
                                if (this.Str_ProcessStatus.Trim() == "取件OK")
                                { strBuilder.Append(" And 取件状态 = 'OK' And (取件日期 >= '" + StartTime + "' And 取件日期 <= '" + EndTime + " 23:59:59.000')"); }
                                if (!string.IsNullOrEmpty(this.Str_Scores1))
                                { strBuilder.Append(" and (摄影助理满意总分>=" + this.Str_Scores1 + " and 摄影助理满意总分<=" + this.Str_Scores2 + ")"); }
                                s = BindSelect5();
                                DataTable dtCount2 = orbll.GetView_Custom("Vw_StaffPerformance_Photograph", StrWhere: "二销类别编号='BEBCABBAAHFCJBJGJ'" + strBuilder.ToString() + s.ToString(), ShowColumnName: "Count(ID) CountID").Tables[0];
                                if (dtCount2.Rows.Count > 0)
                                {
                                    if (Convert.ToInt32(dtCount2.Rows[0]["CountID"]) > 0)
                                    {
                                        backgroundWorker.ReportProgress(0, "正在获取'摄影助理选片二销业绩' ...");
                                        string StrColumnName = "订单号,客户名称,收款金额,收款时间,套系类别,套系名称,应收金额,项目名称,收款类别,付款方式名称,未拍个数,最后拍摄时间,选片状态,选片时间,取件状态,取件日期,拍摄名称,订单类型,副订单,摄影助理满意总分";
                                        DataTable dt_VicePhotographer = orbll.GetView_Custom("Vw_StaffPerformance_Photograph", StrWhere: "二销类别编号='BEBCABBAAHFCJBJGJ'" + strBuilder.ToString() + s.ToString(), ShowColumnName: StrColumnName).Tables[0];
                                        for (int t = 0; t < dt_VicePhotographer.Rows.Count; t++)
                                        {
                                            #region
                                            DataGridViewRow dgvr = new DataGridViewRow();
                                            DataGridViewCell cell = null;

                                            //订单号
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_VicePhotographer.Rows[t]["订单号"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //员工
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = StrUserName;
                                            dgvr.Cells.Add(cell);

                                            //职务
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = "摄影助理选片二销";
                                            dgvr.Cells.Add(cell);

                                            //客户姓名
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_VicePhotographer.Rows[t]["客户名称"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //收款金额
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = Convert.ToDecimal(dt_VicePhotographer.Rows[t]["收款金额"]).ToString("N2");
                                            dgvr.Cells.Add(cell);

                                            //收款时间
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_VicePhotographer.Rows[t]["收款时间"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //套系类别
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_VicePhotographer.Rows[t]["套系类别"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //套系名称
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_VicePhotographer.Rows[t]["套系名称"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //应收金额
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = Convert.ToDecimal(dt_VicePhotographer.Rows[t]["应收金额"]).ToString("N2").Trim();
                                            dgvr.Cells.Add(cell);

                                            //项目名称
                                            cell = new DataGridViewTextBoxCell();
                                            if (string.IsNullOrEmpty(dt_VicePhotographer.Rows[t]["项目名称"].ToString().Trim()))
                                            { cell.Value = dt_VicePhotographer.Rows[t]["收款类别"].ToString(); }
                                            else { cell.Value = dt_VicePhotographer.Rows[t]["项目名称"].ToString().Trim(); }
                                            dgvr.Cells.Add(cell);

                                            //付款名称
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_VicePhotographer.Rows[t]["付款方式名称"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //拍摄状态
                                            cell = new DataGridViewTextBoxCell();
                                            if (Convert.ToInt32(dt_VicePhotographer.Rows[t]["未拍个数"]) == 0)
                                            { cell.Value = "OK"; }
                                            else { cell.Value = "未拍"; }
                                            dgvr.Cells.Add(cell);

                                            //拍摄时间
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_VicePhotographer.Rows[t]["最后拍摄时间"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //选片状态
                                            cell = new DataGridViewTextBoxCell();
                                            if (dt_VicePhotographer.Rows[t]["选片状态"].ToString() == "OK")
                                            { cell.Value = "OK"; }
                                            else { cell.Value = "未选"; }
                                            dgvr.Cells.Add(cell);

                                            //选片时间
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt_VicePhotographer.Rows[t]["选片时间"], "yyyy-MM-dd HH:mm");
                                            dgvr.Cells.Add(cell);

                                            //取件状态
                                            cell = new DataGridViewTextBoxCell();
                                            if (dt_VicePhotographer.Rows[t]["取件状态"].ToString() == "OK")
                                            { cell.Value = "OK"; }
                                            else { cell.Value = "未取"; }
                                            dgvr.Cells.Add(cell);

                                            //取件时间
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt_VicePhotographer.Rows[t]["取件日期"], "yyyy-MM-dd HH:mm");
                                            dgvr.Cells.Add(cell);

                                            //拍摄名称
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_VicePhotographer.Rows[t]["拍摄名称"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //订单类型
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_VicePhotographer.Rows[t]["订单类型"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //收款类型
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_VicePhotographer.Rows[t]["收款类别"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //副订单
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_VicePhotographer.Rows[t]["副订单"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //摄影助理满意总分
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_VicePhotographer.Rows[t]["摄影助理满意总分"].ToString();
                                            dgvr.Cells.Add(cell);
                                            #endregion

                                            this.Invoke(new UpdateControl(delegate()
                                            {
                                                this.dgv.Rows.Add(dgvr);
                                            }));
                                        }
                                    }
                                }
                                #endregion
                            }
                        }
                    }

                    ConfigureRow = dt_SystemConfigure.Select("Sconfig_Code='MakeupArtistSelectionFilms' and Sconfig_IsEnabled=1");
                    if (ConfigureRow.Length > 0)
                    {
                        if (ConfigureRow[0]["Sconfig_Value"].ToString() == "1")
                        {
                            if (this.Str_ProjectTitle.Trim() == "" || this.Str_ProjectTitle.Trim() == "化妆选片二销")
                            {
                                #region 主化妆师
                                s = "";
                                strBuilder = new StringBuilder();
                                if (EmployeeName != null && !string.IsNullOrEmpty(EmployeeName))
                                { strBuilder.Append(" And 主化妆ID like '%" + EmployeeName + "%' "); }
                                if (this.Str_ProcessStatus.Trim() == "")
                                { strBuilder.Append(" And 未拍个数 = 0 And (收款时间 >= '" + StartTime + "' And 收款时间 <= '" + EndTime + " 23:59:59.000')"); }
                                if (this.Str_ProcessStatus.Trim() == "拍照OK")
                                { strBuilder.Append(" And 未拍个数 = 0 And (最后拍摄时间 >= '" + StartTime + "' And 最后拍摄时间 <= '" + EndTime + " 23:59:59.000')"); }
                                if (this.Str_ProcessStatus.Trim() == "选片OK")
                                { strBuilder.Append(" And 选片状态 = 'OK' And (选片时间 >= '" + StartTime + "' And 选片时间 <= '" + EndTime + " 23:59:59.000')"); }
                                if (this.Str_ProcessStatus.Trim() == "取件OK")
                                { strBuilder.Append(" And 取件状态 = 'OK' And (取件日期 >= '" + StartTime + "' And 取件日期 <= '" + EndTime + " 23:59:59.000')"); }
                                if (!string.IsNullOrEmpty(this.Str_Scores1))
                                { strBuilder.Append(" and (主化妆满意总分>=" + this.Str_Scores1 + " and 主化妆满意总分<=" + this.Str_Scores2 + ")"); }
                                s = BindSelect5();
                                DataTable dtCount1 = orbll.GetView_Custom("Vw_StaffPerformance_Photograph", StrWhere: "二销类别编号='BEBCABBAAHFCJBJGJ'" + strBuilder.ToString() + s.ToString(), ShowColumnName: "Count(ID) CountID").Tables[0];
                                if (dtCount1.Rows.Count > 0)
                                {
                                    if (Convert.ToInt32(dtCount1.Rows[0]["CountID"]) > 0)
                                    {
                                        backgroundWorker.ReportProgress(0, "正在获取'主化妆师选片二销业绩' ...");
                                        string StrColumnName = "订单号,客户名称,收款金额,收款时间,套系类别,套系名称,应收金额,项目名称,收款类别,付款方式名称,未拍个数,最后拍摄时间,选片状态,选片时间,取件状态,取件日期,拍摄名称,订单类型,副订单,主化妆满意总分";
                                        DataTable dt_MainMakeupArtist = orbll.GetView_Custom("Vw_StaffPerformance_Photograph", StrWhere: "二销类别编号='BEBCABBAAHFCJBJGJ'" + strBuilder.ToString() + s.ToString(), ShowColumnName: StrColumnName).Tables[0];
                                        for (int t = 0; t < dt_MainMakeupArtist.Rows.Count; t++)
                                        {
                                            #region
                                            DataGridViewRow dgvr = new DataGridViewRow();
                                            DataGridViewCell cell = null;

                                            //订单号
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_MainMakeupArtist.Rows[t]["订单号"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //员工
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = StrUserName;
                                            dgvr.Cells.Add(cell);

                                            //职务
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = "主化妆选片二销";
                                            dgvr.Cells.Add(cell);

                                            //客户姓名
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_MainMakeupArtist.Rows[t]["客户名称"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //收款金额
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = Convert.ToDecimal(dt_MainMakeupArtist.Rows[t]["收款金额"]).ToString("N2");
                                            dgvr.Cells.Add(cell);

                                            //收款时间
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_MainMakeupArtist.Rows[t]["收款时间"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //套系类别
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_MainMakeupArtist.Rows[t]["套系类别"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //套系名称
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_MainMakeupArtist.Rows[t]["套系名称"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //应收金额
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = Convert.ToDecimal(dt_MainMakeupArtist.Rows[t]["应收金额"]).ToString("N2").Trim();
                                            dgvr.Cells.Add(cell);

                                            //项目名称
                                            cell = new DataGridViewTextBoxCell();
                                            if (string.IsNullOrEmpty(dt_MainMakeupArtist.Rows[t]["项目名称"].ToString().Trim()))
                                            { cell.Value = dt_MainMakeupArtist.Rows[t]["收款类别"].ToString(); }
                                            else { cell.Value = dt_MainMakeupArtist.Rows[t]["项目名称"].ToString().Trim(); }
                                            dgvr.Cells.Add(cell);

                                            //付款名称
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_MainMakeupArtist.Rows[t]["付款方式名称"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //拍摄状态
                                            cell = new DataGridViewTextBoxCell();
                                            if (Convert.ToInt32(dt_MainMakeupArtist.Rows[t]["未拍个数"]) == 0)
                                            { cell.Value = "OK"; }
                                            else { cell.Value = "未拍"; }
                                            dgvr.Cells.Add(cell);

                                            //拍摄时间
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_MainMakeupArtist.Rows[t]["最后拍摄时间"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //选片状态
                                            cell = new DataGridViewTextBoxCell();
                                            if (dt_MainMakeupArtist.Rows[t]["选片状态"].ToString() == "OK")
                                            { cell.Value = "OK"; }
                                            else { cell.Value = "未选"; }
                                            dgvr.Cells.Add(cell);

                                            //选片时间
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt_MainMakeupArtist.Rows[t]["选片时间"], "yyyy-MM-dd HH:mm");
                                            dgvr.Cells.Add(cell);

                                            //取件状态
                                            cell = new DataGridViewTextBoxCell();
                                            if (dt_MainMakeupArtist.Rows[t]["取件状态"].ToString() == "OK")
                                            { cell.Value = "OK"; }
                                            else { cell.Value = "未取"; }
                                            dgvr.Cells.Add(cell);

                                            //取件时间
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt_MainMakeupArtist.Rows[t]["取件日期"], "yyyy-MM-dd HH:mm");
                                            dgvr.Cells.Add(cell);

                                            //拍摄名称
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_MainMakeupArtist.Rows[t]["拍摄名称"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //订单类型
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_MainMakeupArtist.Rows[t]["订单类型"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //收款类型
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_MainMakeupArtist.Rows[t]["收款类别"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //副订单
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_MainMakeupArtist.Rows[t]["副订单"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //主化妆满意总分
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_MainMakeupArtist.Rows[t]["主化妆满意总分"].ToString();
                                            dgvr.Cells.Add(cell);
                                            #endregion

                                            this.Invoke(new UpdateControl(delegate()
                                            {
                                                this.dgv.Rows.Add(dgvr);
                                            }));
                                        }
                                    }
                                }
                                #endregion

                                #region 化妆助理
                                s = "";
                                strBuilder = new StringBuilder();
                                if (EmployeeName != null && !string.IsNullOrEmpty(EmployeeName))
                                { strBuilder.Append(" And 化妆助理ID like '%" + EmployeeName + "%' "); }
                                if (this.Str_ProcessStatus.Trim() == "")
                                { strBuilder.Append(" And 未拍个数 = 0 And (收款时间 >= '" + StartTime + "' And 收款时间 <= '" + EndTime + " 23:59:59.000')"); }
                                if (this.Str_ProcessStatus.Trim() == "拍照OK")
                                { strBuilder.Append(" And 未拍个数 = 0 And (最后拍摄时间 >= '" + StartTime + "' And 最后拍摄时间 <= '" + EndTime + " 23:59:59.000')"); }
                                if (this.Str_ProcessStatus.Trim() == "选片OK")
                                { strBuilder.Append(" And 选片状态 = 'OK' And (选片时间 >= '" + StartTime + "' And 选片时间 <= '" + EndTime + " 23:59:59.000')"); }
                                if (this.Str_ProcessStatus.Trim() == "取件OK")
                                { strBuilder.Append(" And 取件状态 = 'OK' And (取件日期 >= '" + StartTime + "' And 取件日期 <= '" + EndTime + " 23:59:59.000')"); }
                                if (!string.IsNullOrEmpty(this.Str_Scores1))
                                { strBuilder.Append(" and (化妆助理满意总分>=" + this.Str_Scores1 + " and 化妆助理满意总分<=" + this.Str_Scores2 + ")"); }
                                s = BindSelect5();
                                DataTable dtCount2 = orbll.GetView_Custom("Vw_StaffPerformance_Photograph", StrWhere: "二销类别编号='BEBCABBAAHFCJBJGJ'" + strBuilder.ToString() + s.ToString(), ShowColumnName: "Count(ID) CountID").Tables[0];
                                if (dtCount2.Rows.Count > 0)
                                {
                                    if (Convert.ToInt32(dtCount2.Rows[0]["CountID"]) > 0)
                                    {
                                        backgroundWorker.ReportProgress(0, "正在获取'化妆助理选片二销业绩' ...");
                                        string StrColumnName = "订单号,客户名称,收款金额,收款时间,套系类别,套系名称,应收金额,项目名称,收款类别,付款方式名称,未拍个数,最后拍摄时间,选片状态,选片时间,取件状态,取件日期,拍摄名称,订单类型,副订单,化妆助理满意总分";
                                        DataTable dt_ViceMakeupArtist = orbll.GetView_Custom("Vw_StaffPerformance_Photograph", StrWhere: "二销类别编号='BEBCABBAAHFCJBJGJ'" + strBuilder.ToString() + s.ToString(), ShowColumnName: StrColumnName).Tables[0];
                                        for (int t = 0; t < dt_ViceMakeupArtist.Rows.Count; t++)
                                        {
                                            #region
                                            DataGridViewRow dgvr = new DataGridViewRow();
                                            DataGridViewCell cell = null;

                                            //订单号
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_ViceMakeupArtist.Rows[t]["订单号"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //员工
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = StrUserName;
                                            dgvr.Cells.Add(cell);

                                            //职务
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = "化妆助理选片二销";
                                            dgvr.Cells.Add(cell);

                                            //客户姓名
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_ViceMakeupArtist.Rows[t]["客户名称"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //收款金额
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = Convert.ToDecimal(dt_ViceMakeupArtist.Rows[t]["收款金额"]).ToString("N2");
                                            dgvr.Cells.Add(cell);

                                            //收款时间
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_ViceMakeupArtist.Rows[t]["收款时间"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //套系类别
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_ViceMakeupArtist.Rows[t]["套系类别"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //套系名称
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_ViceMakeupArtist.Rows[t]["套系名称"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //应收金额
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = Convert.ToDecimal(dt_ViceMakeupArtist.Rows[t]["应收金额"]).ToString("N2").Trim();
                                            dgvr.Cells.Add(cell);

                                            //项目名称
                                            cell = new DataGridViewTextBoxCell();
                                            if (string.IsNullOrEmpty(dt_ViceMakeupArtist.Rows[t]["项目名称"].ToString().Trim()))
                                            { cell.Value = dt_ViceMakeupArtist.Rows[t]["收款类别"].ToString(); }
                                            else { cell.Value = dt_ViceMakeupArtist.Rows[t]["项目名称"].ToString().Trim(); }
                                            dgvr.Cells.Add(cell);

                                            //付款名称
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_ViceMakeupArtist.Rows[t]["付款方式名称"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //拍摄状态
                                            cell = new DataGridViewTextBoxCell();
                                            if (Convert.ToInt32(dt_ViceMakeupArtist.Rows[t]["未拍个数"]) == 0)
                                            { cell.Value = "OK"; }
                                            else { cell.Value = "未拍"; }
                                            dgvr.Cells.Add(cell);

                                            //拍摄时间
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_ViceMakeupArtist.Rows[t]["最后拍摄时间"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //选片状态
                                            cell = new DataGridViewTextBoxCell();
                                            if (dt_ViceMakeupArtist.Rows[t]["选片状态"].ToString() == "OK")
                                            { cell.Value = "OK"; }
                                            else { cell.Value = "未选"; }
                                            dgvr.Cells.Add(cell);

                                            //选片时间
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt_ViceMakeupArtist.Rows[t]["选片时间"], "yyyy-MM-dd HH:mm");
                                            dgvr.Cells.Add(cell);

                                            //取件状态
                                            cell = new DataGridViewTextBoxCell();
                                            if (dt_ViceMakeupArtist.Rows[t]["取件状态"].ToString() == "OK")
                                            { cell.Value = "OK"; }
                                            else { cell.Value = "未取"; }
                                            dgvr.Cells.Add(cell);

                                            //取件时间
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt_ViceMakeupArtist.Rows[t]["取件日期"], "yyyy-MM-dd HH:mm");
                                            dgvr.Cells.Add(cell);

                                            //拍摄名称
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_ViceMakeupArtist.Rows[t]["拍摄名称"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //订单类型
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_ViceMakeupArtist.Rows[t]["订单类型"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //收款类型
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_ViceMakeupArtist.Rows[t]["收款类别"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //副订单
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_ViceMakeupArtist.Rows[t]["副订单"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //化妆助理满意总分
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_ViceMakeupArtist.Rows[t]["化妆助理满意总分"].ToString();
                                            dgvr.Cells.Add(cell);
                                            #endregion

                                            this.Invoke(new UpdateControl(delegate()
                                            {
                                                this.dgv.Rows.Add(dgvr);
                                            }));
                                        }
                                    }
                                }
                                #endregion
                            }
                        }
                    }

                    ConfigureRow = dt_SystemConfigure.Select("Sconfig_Code='GuideSelectionFilmsDivision' and Sconfig_IsEnabled=1");
                    if (ConfigureRow.Length > 0)
                    {
                        if (ConfigureRow[0]["Sconfig_Value"].ToString() == "1")
                        {
                            if (this.Str_ProjectTitle.Trim() == "" || this.Str_ProjectTitle.Trim() == "引导选片二销")
                            {
                                #region 引导师
                                s = "";
                                strBuilder = new StringBuilder();
                                if (EmployeeName != null && !string.IsNullOrEmpty(EmployeeName))
                                { strBuilder.Append(" And 引导师ID like '%" + EmployeeName + "%' "); }
                                if (this.Str_ProcessStatus.Trim() == "")
                                { strBuilder.Append(" And 未拍个数 = 0 And (收款时间 >= '" + StartTime + "' And 收款时间 <= '" + EndTime + " 23:59:59.000')"); }
                                if (this.Str_ProcessStatus.Trim() == "拍照OK")
                                { strBuilder.Append(" And 未拍个数 = 0 And (最后拍摄时间 >= '" + StartTime + "' And 最后拍摄时间 <= '" + EndTime + " 23:59:59.000')"); }
                                if (this.Str_ProcessStatus.Trim() == "选片OK")
                                { strBuilder.Append(" And 选片状态 = 'OK' And (选片时间 >= '" + StartTime + "' And 选片时间 <= '" + EndTime + " 23:59:59.000')"); }
                                if (this.Str_ProcessStatus.Trim() == "取件OK")
                                { strBuilder.Append(" And 取件状态 = 'OK' And (取件日期 >= '" + StartTime + "' And 取件日期 <= '" + EndTime + " 23:59:59.000')"); }
                                if (!string.IsNullOrEmpty(this.Str_Scores1))
                                { strBuilder.Append(" and (引导满意总分>=" + this.Str_Scores1 + " and 引导满意总分<=" + this.Str_Scores2 + ")"); }
                                s = BindSelect5();
                                DataTable dtCount1 = orbll.GetView_Custom("Vw_StaffPerformance_Photograph", StrWhere: "二销类别编号='BEBCABBAAHFCJBJGJ'" + strBuilder.ToString() + s.ToString(), ShowColumnName: "Count(ID) CountID").Tables[0];
                                if (dtCount1.Rows.Count > 0)
                                {
                                    if (Convert.ToInt32(dtCount1.Rows[0]["CountID"]) > 0)
                                    {
                                        backgroundWorker.ReportProgress(0, "正在获取'引导师选片二销业绩' ...");
                                        string StrColumnName = "订单号,客户名称,收款金额,收款时间,套系类别,套系名称,应收金额,项目名称,收款类别,付款方式名称,未拍个数,最后拍摄时间,选片状态,选片时间,取件状态,取件日期,拍摄名称,订单类型,副订单,引导满意总分";
                                        DataTable dt_BootDivisiont = orbll.GetView_Custom("Vw_StaffPerformance_Photograph", StrWhere: "二销类别编号='BEBCABBAAHFCJBJGJ'" + strBuilder.ToString() + s.ToString(), ShowColumnName: StrColumnName).Tables[0];
                                        for (int t = 0; t < dt_BootDivisiont.Rows.Count; t++)
                                        {
                                            #region
                                            DataGridViewRow dgvr = new DataGridViewRow();
                                            DataGridViewCell cell = null;

                                            //订单号
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_BootDivisiont.Rows[t]["订单号"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //员工
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = StrUserName;
                                            dgvr.Cells.Add(cell);

                                            //职务
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = "引导选片二销";
                                            dgvr.Cells.Add(cell);

                                            //客户姓名
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_BootDivisiont.Rows[t]["客户名称"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //收款金额
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = Convert.ToDecimal(dt_BootDivisiont.Rows[t]["收款金额"]).ToString("N2");
                                            dgvr.Cells.Add(cell);

                                            //收款时间
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_BootDivisiont.Rows[t]["收款时间"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //套系类别
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_BootDivisiont.Rows[t]["套系类别"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //套系名称
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_BootDivisiont.Rows[t]["套系名称"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //应收金额
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = Convert.ToDecimal(dt_BootDivisiont.Rows[t]["应收金额"]).ToString("N2").Trim();
                                            dgvr.Cells.Add(cell);

                                            //项目名称
                                            cell = new DataGridViewTextBoxCell();
                                            if (string.IsNullOrEmpty(dt_BootDivisiont.Rows[t]["项目名称"].ToString().Trim()))
                                            { cell.Value = dt_BootDivisiont.Rows[t]["收款类别"].ToString(); }
                                            else { cell.Value = dt_BootDivisiont.Rows[t]["项目名称"].ToString().Trim(); }
                                            dgvr.Cells.Add(cell);

                                            //付款名称
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_BootDivisiont.Rows[t]["付款方式名称"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //拍摄状态
                                            cell = new DataGridViewTextBoxCell();
                                            if (Convert.ToInt32(dt_BootDivisiont.Rows[t]["未拍个数"]) == 0)
                                            { cell.Value = "OK"; }
                                            else { cell.Value = "未拍"; }
                                            dgvr.Cells.Add(cell);

                                            //拍摄时间
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_BootDivisiont.Rows[t]["最后拍摄时间"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //选片状态
                                            cell = new DataGridViewTextBoxCell();
                                            if (dt_BootDivisiont.Rows[t]["选片状态"].ToString() == "OK")
                                            { cell.Value = "OK"; }
                                            else { cell.Value = "未选"; }
                                            dgvr.Cells.Add(cell);

                                            //选片时间
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt_BootDivisiont.Rows[t]["选片时间"], "yyyy-MM-dd HH:mm");
                                            dgvr.Cells.Add(cell);

                                            //取件状态
                                            cell = new DataGridViewTextBoxCell();
                                            if (dt_BootDivisiont.Rows[t]["取件状态"].ToString() == "OK")
                                            { cell.Value = "OK"; }
                                            else { cell.Value = "未取"; }
                                            dgvr.Cells.Add(cell);

                                            //取件时间
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt_BootDivisiont.Rows[t]["取件日期"], "yyyy-MM-dd HH:mm");
                                            dgvr.Cells.Add(cell);

                                            //拍摄名称
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_BootDivisiont.Rows[t]["拍摄名称"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //订单类型
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_BootDivisiont.Rows[t]["订单类型"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //收款类型
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_BootDivisiont.Rows[t]["收款类别"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //副订单
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_BootDivisiont.Rows[t]["副订单"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //引导满意总分
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_BootDivisiont.Rows[t]["引导满意总分"].ToString();
                                            dgvr.Cells.Add(cell);
                                            #endregion

                                            this.Invoke(new UpdateControl(delegate()
                                            {
                                                this.dgv.Rows.Add(dgvr);
                                            }));
                                        }
                                    }
                                }
                                #endregion

                                #region 引导助理
                                s = "";
                                strBuilder = new StringBuilder();
                                if (EmployeeName != null && !string.IsNullOrEmpty(EmployeeName))
                                { strBuilder.Append(" And 引导助理ID like '%" + EmployeeName + "%' "); }
                                if (this.Str_ProcessStatus.Trim() == "")
                                { strBuilder.Append(" And 未拍个数 = 0 And (收款时间 >= '" + StartTime + "' And 收款时间 <= '" + EndTime + " 23:59:59.000')"); }
                                if (this.Str_ProcessStatus.Trim() == "拍照OK")
                                { strBuilder.Append(" And 未拍个数 = 0 And (最后拍摄时间 >= '" + StartTime + "' And 最后拍摄时间 <= '" + EndTime + " 23:59:59.000')"); }
                                if (this.Str_ProcessStatus.Trim() == "选片OK")
                                { strBuilder.Append(" And 选片状态 = 'OK' And (选片时间 >= '" + StartTime + "' And 选片时间 <= '" + EndTime + " 23:59:59.000')"); }
                                if (this.Str_ProcessStatus.Trim() == "取件OK")
                                { strBuilder.Append(" And 取件状态 = 'OK' And (取件日期 >= '" + StartTime + "' And 取件日期 <= '" + EndTime + " 23:59:59.000')"); }
                                if (!string.IsNullOrEmpty(this.Str_Scores1))
                                { strBuilder.Append(" and (引导助理满意总分>=" + this.Str_Scores1 + " and 引导助理满意总分<=" + this.Str_Scores2 + ")"); }
                                s = BindSelect5();
                                DataTable dtCount2 = orbll.GetView_Custom("Vw_StaffPerformance_Photograph", StrWhere: "二销类别编号='BEBCABBAAHFCJBJGJ'" + strBuilder.ToString() + s.ToString(), ShowColumnName: "Count(ID) CountID").Tables[0];
                                if (dtCount2.Rows.Count > 0)
                                {
                                    if (Convert.ToInt32(dtCount2.Rows[0]["CountID"]) > 0)
                                    {
                                        backgroundWorker.ReportProgress(0, "正在获取'引导助理选片二销业绩' ...");
                                        string StrColumnName = "订单号,客户名称,收款金额,收款时间,套系类别,套系名称,应收金额,项目名称,收款类别,付款方式名称,未拍个数,最后拍摄时间,选片状态,选片时间,取件状态,取件日期,拍摄名称,订单类型,副订单,引导助理满意总分";
                                        DataTable dt_BootDivisiont = orbll.GetView_Custom("Vw_StaffPerformance_Photograph", StrWhere: "二销类别编号='BEBCABBAAHFCJBJGJ'" + strBuilder.ToString() + s.ToString(), ShowColumnName: StrColumnName).Tables[0];
                                        for (int t = 0; t < dt_BootDivisiont.Rows.Count; t++)
                                        {
                                            #region
                                            DataGridViewRow dgvr = new DataGridViewRow();
                                            DataGridViewCell cell = null;

                                            //订单号
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_BootDivisiont.Rows[t]["订单号"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //员工
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = StrUserName;
                                            dgvr.Cells.Add(cell);

                                            //职务
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = "引导助理选片二销";
                                            dgvr.Cells.Add(cell);

                                            //客户姓名
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_BootDivisiont.Rows[t]["客户名称"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //收款金额
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = Convert.ToDecimal(dt_BootDivisiont.Rows[t]["收款金额"]).ToString("N2");
                                            dgvr.Cells.Add(cell);

                                            //收款时间
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_BootDivisiont.Rows[t]["收款时间"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //套系类别
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_BootDivisiont.Rows[t]["套系类别"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //套系名称
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_BootDivisiont.Rows[t]["套系名称"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //应收金额
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = Convert.ToDecimal(dt_BootDivisiont.Rows[t]["应收金额"]).ToString("N2").Trim();
                                            dgvr.Cells.Add(cell);

                                            //项目名称
                                            cell = new DataGridViewTextBoxCell();
                                            if (string.IsNullOrEmpty(dt_BootDivisiont.Rows[t]["项目名称"].ToString().Trim()))
                                            { cell.Value = dt_BootDivisiont.Rows[t]["收款类别"].ToString(); }
                                            else { cell.Value = dt_BootDivisiont.Rows[t]["项目名称"].ToString().Trim(); }
                                            dgvr.Cells.Add(cell);

                                            //付款名称
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_BootDivisiont.Rows[t]["付款方式名称"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //拍摄状态
                                            cell = new DataGridViewTextBoxCell();
                                            if (Convert.ToInt32(dt_BootDivisiont.Rows[t]["未拍个数"]) == 0)
                                            { cell.Value = "OK"; }
                                            else { cell.Value = "未拍"; }
                                            dgvr.Cells.Add(cell);

                                            //拍摄时间
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_BootDivisiont.Rows[t]["最后拍摄时间"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //选片状态
                                            cell = new DataGridViewTextBoxCell();
                                            if (dt_BootDivisiont.Rows[t]["选片状态"].ToString() == "OK")
                                            { cell.Value = "OK"; }
                                            else { cell.Value = "未选"; }
                                            dgvr.Cells.Add(cell);

                                            //选片时间
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt_BootDivisiont.Rows[t]["选片时间"], "yyyy-MM-dd HH:mm");
                                            dgvr.Cells.Add(cell);

                                            //取件状态
                                            cell = new DataGridViewTextBoxCell();
                                            if (dt_BootDivisiont.Rows[t]["取件状态"].ToString() == "OK")
                                            { cell.Value = "OK"; }
                                            else { cell.Value = "未取"; }
                                            dgvr.Cells.Add(cell);

                                            //取件时间
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt_BootDivisiont.Rows[t]["取件日期"], "yyyy-MM-dd HH:mm");
                                            dgvr.Cells.Add(cell);

                                            //拍摄名称
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_BootDivisiont.Rows[t]["拍摄名称"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //订单类型
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_BootDivisiont.Rows[t]["订单类型"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //收款类型
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_BootDivisiont.Rows[t]["收款类别"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //副订单
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_BootDivisiont.Rows[t]["副订单"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //引导满意总分
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_BootDivisiont.Rows[t]["引导助理满意总分"].ToString();
                                            dgvr.Cells.Add(cell);
                                            #endregion

                                            this.Invoke(new UpdateControl(delegate()
                                            {
                                                this.dgv.Rows.Add(dgvr);
                                            }));
                                        }
                                    }
                                }
                                #endregion
                            }
                        }
                    }

                    ConfigureRow = dt_SystemConfigure.Select("Sconfig_Code='FirstRepairDivisionSelectionFilms' and Sconfig_IsEnabled=1");
                    if (ConfigureRow.Length > 0)
                    {
                        if (ConfigureRow[0]["Sconfig_Value"].ToString() == "1")
                        {
                            if (this.Str_ProjectTitle.Trim() == "" || this.Str_ProjectTitle.Trim() == "初修选片二销")
                            {
                                #region 初修师
                                s = "";
                                strBuilder = new StringBuilder();
                                if (EmployeeName != null && !string.IsNullOrEmpty(EmployeeName))
                                { strBuilder.Append(" And 初修师ID like '%" + EmployeeName + "%' "); }
                                if (this.Str_ProcessStatus.Trim() == "")
                                { strBuilder.Append(" And 未拍个数 = 0 And 服务前期初修查询状态 = '2' And (初修二销查询时间 >= '" + StartTime + "' And 初修二销查询时间 <= '" + EndTime + " 23:59:59.000')"); }
                                if (this.Str_ProcessStatus.Trim() == "拍照OK")
                                { strBuilder.Append(" And 未拍个数 = 0 And (最后拍摄时间 >= '" + StartTime + "' And 最后拍摄时间 <= '" + EndTime + " 23:59:59.000')"); }
                                if (this.Str_ProcessStatus.Trim() == "选片OK")
                                { strBuilder.Append(" And 选片状态 = 'OK' And (选片时间 >= '" + StartTime + "' And 选片时间 <= '" + EndTime + " 23:59:59.000')"); }
                                if (this.Str_ProcessStatus.Trim() == "取件OK")
                                { strBuilder.Append(" And 取件状态 = 'OK' And (取件日期 >= '" + StartTime + "' And 取件日期 <= '" + EndTime + " 23:59:59.000')"); }
                                if (!string.IsNullOrEmpty(this.Str_Scores1))
                                { strBuilder.Append(" and (初修师满意总分>=" + this.Str_Scores1 + " and 初修师满意总分<=" + this.Str_Scores2 + ")"); }
                                s = BindSelect5();
                                DataTable dtCount = orbll.GetView_Custom("Vw_StaffPerformance_Photograph", StrWhere: "二销类别编号='BEBCABBAAHFCJBJGJ'" + strBuilder.ToString() + s.ToString(), ShowColumnName: "Count(ID) CountID").Tables[0];
                                if (dtCount.Rows.Count > 0)
                                {
                                    if (Convert.ToInt32(dtCount.Rows[0]["CountID"]) > 0)
                                    {
                                        backgroundWorker.ReportProgress(0, "正在获取'初修师选片二销业绩' ...");
                                        string StrColumnName = "订单号,客户名称,收款金额,收款时间,套系类别,套系名称,应收金额,项目名称,收款类别,付款方式名称,未拍个数,最后拍摄时间,选片状态,选片时间,初修状态,初修时间,取件状态,取件日期,拍摄名称,订单类型,副订单,初修师满意总分";
                                        DataTable dt_EarlyRepair = orbll.GetView_Custom("Vw_StaffPerformance_Photograph", StrWhere: "二销类别编号='BEBCABBAAHFCJBJGJ'" + strBuilder.ToString() + s.ToString(), ShowColumnName: StrColumnName).Tables[0];
                                        for (int t = 0; t < dt_EarlyRepair.Rows.Count; t++)
                                        {
                                            #region
                                            DataGridViewRow dgvr = new DataGridViewRow();
                                            DataGridViewCell cell = null;

                                            //订单号
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_EarlyRepair.Rows[t]["订单号"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //员工
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = StrUserName;
                                            dgvr.Cells.Add(cell);

                                            //职务
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = "初修师选片二销";
                                            dgvr.Cells.Add(cell);

                                            //客户姓名
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_EarlyRepair.Rows[t]["客户名称"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //收款金额
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = Convert.ToDecimal(dt_EarlyRepair.Rows[t]["收款金额"]).ToString("N2");
                                            dgvr.Cells.Add(cell);

                                            //收款时间
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_EarlyRepair.Rows[t]["收款时间"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //套系类别
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_EarlyRepair.Rows[t]["套系类别"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //套系名称
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_EarlyRepair.Rows[t]["套系名称"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //应收金额
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = Convert.ToDecimal(dt_EarlyRepair.Rows[t]["应收金额"]).ToString("N2").Trim();
                                            dgvr.Cells.Add(cell);

                                            //项目名称
                                            cell = new DataGridViewTextBoxCell();
                                            if (string.IsNullOrEmpty(dt_EarlyRepair.Rows[t]["项目名称"].ToString().Trim()))
                                            { cell.Value = dt_EarlyRepair.Rows[t]["收款类别"].ToString(); }
                                            else { cell.Value = dt_EarlyRepair.Rows[t]["项目名称"].ToString().Trim(); }
                                            dgvr.Cells.Add(cell);

                                            //付款名称
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_EarlyRepair.Rows[t]["付款方式名称"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //拍摄状态
                                            cell = new DataGridViewTextBoxCell();
                                            if (Convert.ToInt32(dt_EarlyRepair.Rows[t]["未拍个数"]) == 0)
                                            { cell.Value = "OK"; }
                                            else { cell.Value = "未拍"; }
                                            dgvr.Cells.Add(cell);

                                            //拍摄时间
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_EarlyRepair.Rows[t]["最后拍摄时间"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //选片状态
                                            cell = new DataGridViewTextBoxCell();
                                            if (dt_EarlyRepair.Rows[t]["选片状态"].ToString() == "OK")
                                            { cell.Value = "OK"; }
                                            else { cell.Value = "未选"; }
                                            dgvr.Cells.Add(cell);

                                            //选片时间
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt_EarlyRepair.Rows[t]["选片时间"], "yyyy-MM-dd HH:mm");
                                            dgvr.Cells.Add(cell);

                                            //取件状态
                                            cell = new DataGridViewTextBoxCell();
                                            if (dt_EarlyRepair.Rows[t]["取件状态"].ToString() == "OK")
                                            { cell.Value = "OK"; }
                                            else { cell.Value = "未取"; }
                                            dgvr.Cells.Add(cell);

                                            //取件时间
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt_EarlyRepair.Rows[t]["取件日期"], "yyyy-MM-dd HH:mm");
                                            dgvr.Cells.Add(cell);

                                            //拍摄名称
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_EarlyRepair.Rows[t]["拍摄名称"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //订单类型
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_EarlyRepair.Rows[t]["订单类型"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //收款类型
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_EarlyRepair.Rows[t]["收款类别"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //副订单
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_EarlyRepair.Rows[t]["副订单"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //初修师满意总分
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_EarlyRepair.Rows[t]["初修师满意总分"].ToString();
                                            dgvr.Cells.Add(cell);
                                            #endregion

                                            this.Invoke(new UpdateControl(delegate()
                                            {
                                                this.dgv.Rows.Add(dgvr);
                                            }));
                                        }
                                    }
                                }
                                #endregion
                            }
                        }
                    }

                    ConfigureRow = dt_SystemConfigure.Select("Sconfig_Code = 'StoreSelectionFilms' and Sconfig_IsEnabled = 1");
                    if (ConfigureRow.Length > 0)
                    {
                        if (ConfigureRow[0]["Sconfig_Value"].ToString() == "1")
                        {
                            if (this.Str_ProjectTitle.Trim() == "" || this.Str_ProjectTitle.Trim() == "门市选片二销")
                            {
                                #region 门市
                                s = "";
                                strBuilder = new StringBuilder();
                                if (EmployeeName != null && !string.IsNullOrEmpty(EmployeeName))
                                { strBuilder.Append(" And 订单门市 like '%" + EmployeeName + "%' "); }
                                if (this.Str_ProcessStatus.Trim() == "")
                                { strBuilder.Append(" And 未拍个数 = 0 And (收款时间 >= '" + StartTime + " 00:00:00.000' And 收款时间 <= '" + EndTime + " 23:59:59.000')"); }
                                if (this.Str_ProcessStatus.Trim() == "拍照OK")
                                { strBuilder.Append(" And 未拍个数 = 0 And (最后拍摄时间 >= '" + StartTime + "' And 最后拍摄时间 <= '" + EndTime + " 23:59:59.000')"); }
                                if (this.Str_ProcessStatus.Trim() == "选片OK")
                                { strBuilder.Append(" And 选片状态 = 'OK' And (选片时间 >= '" + StartTime + "' And 选片时间 <= '" + EndTime + " 23:59:59.000')"); }
                                if (this.Str_ProcessStatus.Trim() == "取件OK")
                                { strBuilder.Append(" And 取件状态 = 'OK' And (取件日期 >= '" + StartTime + "' And 取件日期 <= '" + EndTime + " 23:59:59.000')"); }
                                s = BindSelect5();
                                DataTable dtCount = orbll.GetView_Custom("Vw_StaffPerformance_Photograph", StrWhere: "二销类别编号='BEBCABBAAHFCJBJGJ'" + strBuilder.ToString() + s.ToString(), ShowColumnName: "Count(ID) CountID").Tables[0];
                                if (dtCount.Rows.Count > 0)
                                {

                                    if (Convert.ToInt32(dtCount.Rows[0]["CountID"]) > 0)
                                    {
                                        backgroundWorker.ReportProgress(0, "正在获取'门市选片二销业绩' ...");
                                        string StrColumnName = "订单号,客户名称,收款金额,收款时间,套系类别,套系名称,应收金额,项目名称,收款类别,付款方式名称,未拍个数,最后拍摄时间,选片状态,选片时间,取件状态,取件日期,拍摄名称,订单类型,副订单";
                                        DataTable dt_OrderPerson = orbll.GetView_Custom("Vw_StaffPerformance_Photograph", StrWhere: "二销类别编号='BEBCABBAAHFCJBJGJ'" + strBuilder.ToString() + s.ToString(), ShowColumnName: StrColumnName).Tables[0];
                                        for (int t = 0; t < dt_OrderPerson.Rows.Count; t++)
                                        {
                                            #region
                                            DataGridViewRow dgvr = new DataGridViewRow();
                                            DataGridViewCell cell = null;

                                            //订单号
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_OrderPerson.Rows[t]["订单号"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //员工
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = StrUserName;
                                            dgvr.Cells.Add(cell);

                                            //职务
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = "门市选片二销";
                                            dgvr.Cells.Add(cell);

                                            //客户姓名
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_OrderPerson.Rows[t]["客户名称"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //收款金额
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = Convert.ToDecimal(dt_OrderPerson.Rows[t]["收款金额"]).ToString("N2");
                                            dgvr.Cells.Add(cell);

                                            //收款时间
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_OrderPerson.Rows[t]["收款时间"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //套系类别
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_OrderPerson.Rows[t]["套系类别"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //套系名称
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_OrderPerson.Rows[t]["套系名称"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //应收金额
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = Convert.ToDecimal(dt_OrderPerson.Rows[t]["应收金额"]).ToString("N2").Trim();
                                            dgvr.Cells.Add(cell);

                                            //项目名称
                                            cell = new DataGridViewTextBoxCell();
                                            if (string.IsNullOrEmpty(dt_OrderPerson.Rows[t]["项目名称"].ToString().Trim()))
                                            { cell.Value = dt_OrderPerson.Rows[t]["收款类别"].ToString(); }
                                            else { cell.Value = dt_OrderPerson.Rows[t]["项目名称"].ToString().Trim(); }
                                            dgvr.Cells.Add(cell);

                                            //付款名称
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_OrderPerson.Rows[t]["付款方式名称"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //拍摄状态
                                            cell = new DataGridViewTextBoxCell();
                                            if (Convert.ToInt32(dt_OrderPerson.Rows[t]["未拍个数"]) == 0)
                                            { cell.Value = "OK"; }
                                            else { cell.Value = "未拍"; }
                                            dgvr.Cells.Add(cell);

                                            //拍摄时间
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_OrderPerson.Rows[t]["最后拍摄时间"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //选片状态
                                            cell = new DataGridViewTextBoxCell();
                                            if (dt_OrderPerson.Rows[t]["选片状态"].ToString() == "OK")
                                            { cell.Value = "OK"; }
                                            else { cell.Value = "未选"; }
                                            dgvr.Cells.Add(cell);

                                            //选片时间
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt_OrderPerson.Rows[t]["选片时间"], "yyyy-MM-dd HH:mm");
                                            dgvr.Cells.Add(cell);

                                            //取件状态
                                            cell = new DataGridViewTextBoxCell();
                                            if (dt_OrderPerson.Rows[t]["取件状态"].ToString() == "OK")
                                            { cell.Value = "OK"; }
                                            else { cell.Value = "未取"; }
                                            dgvr.Cells.Add(cell);

                                            //取件时间
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt_OrderPerson.Rows[t]["取件日期"], "yyyy-MM-dd HH:mm");
                                            dgvr.Cells.Add(cell);

                                            //拍摄名称
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_OrderPerson.Rows[t]["拍摄名称"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //订单类型
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_OrderPerson.Rows[t]["订单类型"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //收款类型
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_OrderPerson.Rows[t]["收款类别"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //副订单
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_OrderPerson.Rows[t]["副订单"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //门市满意总分
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = "";
                                            dgvr.Cells.Add(cell);
                                            #endregion

                                            this.Invoke(new UpdateControl(delegate()
                                            {
                                                this.dgv.Rows.Add(dgvr);
                                            }));
                                        }
                                    }
                                }
                                #endregion
                            }
                        }
                    }

                    ConfigureRow = dt_SystemConfigure.Select("Sconfig_Code='DesignerSelectionFilms' and Sconfig_IsEnabled=1");
                    if (ConfigureRow.Length > 0)
                    {
                        if (ConfigureRow[0]["Sconfig_Value"].ToString() == "1")
                        {
                            if (this.Str_ProjectTitle.Trim() == "" || this.Str_ProjectTitle.Trim() == "设计选片二销")
                            {
                                #region 设计师
                                s = "";
                                strBuilder = new StringBuilder();
                                if (EmployeeName != null && !string.IsNullOrEmpty(EmployeeName))
                                { strBuilder.Append(" And 设计师ID like '%" + EmployeeName + "%' "); }
                                if (this.Str_ProcessStatus.Trim() == "")
                                { strBuilder.Append(" And 未拍个数 = 0 And 服务前期设计查询状态 = '2' And (设计二销查询时间 >= '" + StartTime + "' And 设计二销查询时间 <= '" + EndTime + " 23:59:59.000')"); }
                                if (this.Str_ProcessStatus.Trim() == "拍照OK")
                                { strBuilder.Append(" And 未拍个数 = 0 And (最后拍摄时间 >= '" + StartTime + "' And 最后拍摄时间 <= '" + EndTime + " 23:59:59.000')"); }
                                if (this.Str_ProcessStatus.Trim() == "选片OK")
                                { strBuilder.Append(" And 选片状态 = 'OK' And (选片时间 >= '" + StartTime + "' And 选片时间 <= '" + EndTime + " 23:59:59.000')"); }
                                if (this.Str_ProcessStatus.Trim() == "取件OK")
                                { strBuilder.Append(" And 取件状态 = 'OK' And (取件日期 >= '" + StartTime + "' And 取件日期 <= '" + EndTime + " 23:59:59.000')"); }
                                if (!string.IsNullOrEmpty(this.Str_Scores1))
                                { strBuilder.Append(" and (设计师满意总分>=" + this.Str_Scores1 + " and 设计师满意总分<=" + this.Str_Scores2 + ")"); }
                                s = BindSelect5();
                                DataTable dtCount = orbll.GetView_Custom("Vw_StaffPerformance_Photograph", StrWhere: "二销类别编号='BEBCABBAAHFCJBJGJ'" + strBuilder.ToString() + s.ToString(), ShowColumnName: "Count(ID) CountID").Tables[0];
                                if (dtCount.Rows.Count > 0)
                                {
                                    if (Convert.ToInt32(dtCount.Rows[0]["CountID"]) > 0)
                                    {
                                        backgroundWorker.ReportProgress(0, "正在获取'设计师选片二销业绩' ...");
                                        string StrColumnName = "订单号,客户名称,收款金额,收款时间,套系类别,套系名称,应收金额,项目名称,收款类别,付款方式名称,未拍个数,最后拍摄时间,选片状态,选片时间,设计状态,设计时间,取件状态,取件日期,拍摄名称,订单类型,副订单,设计师满意总分";
                                        DataTable dt_EarlyRepair = orbll.GetView_Custom("Vw_StaffPerformance_Photograph", StrWhere: "二销类别编号='BEBCABBAAHFCJBJGJ'" + strBuilder.ToString() + s.ToString(), ShowColumnName: StrColumnName).Tables[0];
                                        for (int t = 0; t < dt_EarlyRepair.Rows.Count; t++)
                                        {
                                            #region
                                            DataGridViewRow dgvr = new DataGridViewRow();
                                            DataGridViewCell cell = null;

                                            //订单号
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_EarlyRepair.Rows[t]["订单号"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //员工
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = StrUserName;
                                            dgvr.Cells.Add(cell);

                                            //职务
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = "设计师选片二销";
                                            dgvr.Cells.Add(cell);

                                            //客户姓名
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_EarlyRepair.Rows[t]["客户名称"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //收款金额
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = Convert.ToDecimal(dt_EarlyRepair.Rows[t]["收款金额"]).ToString("N2");
                                            dgvr.Cells.Add(cell);

                                            //收款时间
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_EarlyRepair.Rows[t]["收款时间"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //套系类别
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_EarlyRepair.Rows[t]["套系类别"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //套系名称
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_EarlyRepair.Rows[t]["套系名称"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //应收金额
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = Convert.ToDecimal(dt_EarlyRepair.Rows[t]["应收金额"]).ToString("N2").Trim();
                                            dgvr.Cells.Add(cell);

                                            //项目名称
                                            cell = new DataGridViewTextBoxCell();
                                            if (string.IsNullOrEmpty(dt_EarlyRepair.Rows[t]["项目名称"].ToString().Trim()))
                                            { cell.Value = dt_EarlyRepair.Rows[t]["收款类别"].ToString(); }
                                            else { cell.Value = dt_EarlyRepair.Rows[t]["项目名称"].ToString().Trim(); }
                                            dgvr.Cells.Add(cell);

                                            //付款名称
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_EarlyRepair.Rows[t]["付款方式名称"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //拍摄状态
                                            cell = new DataGridViewTextBoxCell();
                                            if (Convert.ToInt32(dt_EarlyRepair.Rows[t]["未拍个数"]) == 0)
                                            { cell.Value = "OK"; }
                                            else { cell.Value = "未拍"; }
                                            dgvr.Cells.Add(cell);

                                            //拍摄时间
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_EarlyRepair.Rows[t]["最后拍摄时间"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //选片状态
                                            cell = new DataGridViewTextBoxCell();
                                            if (dt_EarlyRepair.Rows[t]["选片状态"].ToString() == "OK")
                                            { cell.Value = "OK"; }
                                            else { cell.Value = "未选"; }
                                            dgvr.Cells.Add(cell);

                                            //选片时间
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt_EarlyRepair.Rows[t]["选片时间"], "yyyy-MM-dd HH:mm");
                                            dgvr.Cells.Add(cell);

                                            //取件状态
                                            cell = new DataGridViewTextBoxCell();
                                            if (dt_EarlyRepair.Rows[t]["取件状态"].ToString() == "OK")
                                            { cell.Value = "OK"; }
                                            else { cell.Value = "未取"; }
                                            dgvr.Cells.Add(cell);

                                            //取件时间
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt_EarlyRepair.Rows[t]["取件日期"], "yyyy-MM-dd HH:mm");
                                            dgvr.Cells.Add(cell);

                                            //拍摄名称
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_EarlyRepair.Rows[t]["拍摄名称"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //订单类型
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_EarlyRepair.Rows[t]["订单类型"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //收款类型
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_EarlyRepair.Rows[t]["收款类别"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //副订单
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_EarlyRepair.Rows[t]["副订单"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //初修师满意总分
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_EarlyRepair.Rows[t]["设计师满意总分"].ToString();
                                            dgvr.Cells.Add(cell);
                                            #endregion

                                            this.Invoke(new UpdateControl(delegate()
                                            {
                                                this.dgv.Rows.Add(dgvr);
                                            }));
                                        }
                                    }
                                }
                                #endregion
                            }
                        }
                    }

                    ConfigureRow = dt_SystemConfigure.Select("Sconfig_Code='RefinedRepairSelectionFilms' and Sconfig_IsEnabled=1");
                    if (ConfigureRow.Length > 0)
                    {
                        if (ConfigureRow[0]["Sconfig_Value"].ToString() == "1")
                        {
                            if (this.Str_ProjectTitle.Trim() == "" || this.Str_ProjectTitle.Trim() == "精修选片二销")
                            {
                                #region 精修师
                                s = "";
                                strBuilder = new StringBuilder();
                                if (EmployeeName != null && !string.IsNullOrEmpty(EmployeeName))
                                { strBuilder.Append(" And 精修师ID like '%" + EmployeeName + "%' "); }
                                if (this.Str_ProcessStatus.Trim() == "")
                                { strBuilder.Append(" And 未拍个数 = 0 And 服务前期精修查询状态 = '2' And (精修二销查询时间 >= '" + StartTime + "' And 精修二销查询时间 <= '" + EndTime + " 23:59:59.000')"); }
                                if (this.Str_ProcessStatus.Trim() == "拍照OK")
                                { strBuilder.Append(" And 未拍个数 = 0 And (最后拍摄时间 >= '" + StartTime + "' And 最后拍摄时间 <= '" + EndTime + " 23:59:59.000')"); }
                                if (this.Str_ProcessStatus.Trim() == "选片OK")
                                { strBuilder.Append(" And 选片状态 = 'OK' And (选片时间 >= '" + StartTime + "' And 选片时间 <= '" + EndTime + " 23:59:59.000')"); }
                                if (this.Str_ProcessStatus.Trim() == "取件OK")
                                { strBuilder.Append(" And 取件状态 = 'OK' And (取件日期 >= '" + StartTime + "' And 取件日期 <= '" + EndTime + " 23:59:59.000')"); }
                                if (!string.IsNullOrEmpty(this.Str_Scores1))
                                { strBuilder.Append(" and (精修师满意总分>=" + this.Str_Scores1 + " and 精修师满意总分<=" + this.Str_Scores2 + ")"); }
                                s = BindSelect5();
                                DataTable dtCount = orbll.GetView_Custom("Vw_StaffPerformance_Photograph", StrWhere: "二销类别编号='BEBCABBAAHFCJBJGJ'" + strBuilder.ToString() + s.ToString(), ShowColumnName: "Count(ID) CountID").Tables[0];
                                if (dtCount.Rows.Count > 0)
                                {
                                    if (Convert.ToInt32(dtCount.Rows[0]["CountID"]) > 0)
                                    {
                                        backgroundWorker.ReportProgress(0, "正在获取'精修师选片二销业绩' ...");
                                        string StrColumnName = "订单号,客户名称,收款金额,收款时间,套系类别,套系名称,应收金额,项目名称,收款类别,付款方式名称,未拍个数,最后拍摄时间,选片状态,选片时间,精修状态,精修时间,取件状态,取件日期,拍摄名称,订单类型,副订单,精修师满意总分";
                                        DataTable dt_EarlyRepair = orbll.GetView_Custom("Vw_StaffPerformance_Photograph", StrWhere: "二销类别编号='BEBCABBAAHFCJBJGJ'" + strBuilder.ToString() + s.ToString(), ShowColumnName: StrColumnName).Tables[0];
                                        for (int t = 0; t < dt_EarlyRepair.Rows.Count; t++)
                                        {
                                            #region
                                            DataGridViewRow dgvr = new DataGridViewRow();
                                            DataGridViewCell cell = null;

                                            //订单号
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_EarlyRepair.Rows[t]["订单号"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //员工
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = StrUserName;
                                            dgvr.Cells.Add(cell);

                                            //职务
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = "精修师选片二销";
                                            dgvr.Cells.Add(cell);

                                            //客户姓名
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_EarlyRepair.Rows[t]["客户名称"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //收款金额
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = Convert.ToDecimal(dt_EarlyRepair.Rows[t]["收款金额"]).ToString("N2");
                                            dgvr.Cells.Add(cell);

                                            //收款时间
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_EarlyRepair.Rows[t]["收款时间"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //套系类别
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_EarlyRepair.Rows[t]["套系类别"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //套系名称
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_EarlyRepair.Rows[t]["套系名称"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //应收金额
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = Convert.ToDecimal(dt_EarlyRepair.Rows[t]["应收金额"]).ToString("N2").Trim();
                                            dgvr.Cells.Add(cell);

                                            //项目名称
                                            cell = new DataGridViewTextBoxCell();
                                            if (string.IsNullOrEmpty(dt_EarlyRepair.Rows[t]["项目名称"].ToString().Trim()))
                                            { cell.Value = dt_EarlyRepair.Rows[t]["收款类别"].ToString(); }
                                            else { cell.Value = dt_EarlyRepair.Rows[t]["项目名称"].ToString().Trim(); }
                                            dgvr.Cells.Add(cell);

                                            //付款名称
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_EarlyRepair.Rows[t]["付款方式名称"].ToString().Trim();
                                            dgvr.Cells.Add(cell);

                                            //拍摄状态
                                            cell = new DataGridViewTextBoxCell();
                                            if (Convert.ToInt32(dt_EarlyRepair.Rows[t]["未拍个数"]) == 0)
                                            { cell.Value = "OK"; }
                                            else { cell.Value = "未拍"; }
                                            dgvr.Cells.Add(cell);

                                            //拍摄时间
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_EarlyRepair.Rows[t]["最后拍摄时间"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //选片状态
                                            cell = new DataGridViewTextBoxCell();
                                            if (dt_EarlyRepair.Rows[t]["选片状态"].ToString() == "OK")
                                            { cell.Value = "OK"; }
                                            else { cell.Value = "未选"; }
                                            dgvr.Cells.Add(cell);

                                            //选片时间
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt_EarlyRepair.Rows[t]["选片时间"], "yyyy-MM-dd HH:mm");
                                            dgvr.Cells.Add(cell);

                                            //取件状态
                                            cell = new DataGridViewTextBoxCell();
                                            if (dt_EarlyRepair.Rows[t]["取件状态"].ToString() == "OK")
                                            { cell.Value = "OK"; }
                                            else { cell.Value = "未取"; }
                                            dgvr.Cells.Add(cell);

                                            //取件时间
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt_EarlyRepair.Rows[t]["取件日期"], "yyyy-MM-dd HH:mm");
                                            dgvr.Cells.Add(cell);

                                            //拍摄名称
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_EarlyRepair.Rows[t]["拍摄名称"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //订单类型
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_EarlyRepair.Rows[t]["订单类型"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //收款类型
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_EarlyRepair.Rows[t]["收款类别"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //副订单
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_EarlyRepair.Rows[t]["副订单"].ToString();
                                            dgvr.Cells.Add(cell);

                                            //初修师满意总分
                                            cell = new DataGridViewTextBoxCell();
                                            cell.Value = dt_EarlyRepair.Rows[t]["精修师满意总分"].ToString();
                                            dgvr.Cells.Add(cell);
                                            #endregion

                                            this.Invoke(new UpdateControl(delegate()
                                            {
                                                this.dgv.Rows.Add(dgvr);
                                            }));
                                        }
                                    }
                                }
                                #endregion
                            }
                        }
                    }
                    #endregion
                }
                #endregion
            }
            if (this.Str_ItemCategory.Trim() == "" || this.Str_ItemCategory.Trim() == "会员充值")
            {
                #region 获取会员充值
                s = "";
                strBuilder = new StringBuilder();
                bool IsQuery = true;
                if (string.IsNullOrEmpty(this.Str_ProcessStatus.Trim()))
                {
                    strBuilder.Append("and 创建时间 >= '" + StartTime + "' and 创建时间 <= '" + EndTime + " 23:59:59.000' ");
                    if (EmployeeName != null && !string.IsNullOrEmpty(EmployeeName))
                    { strBuilder.Append("and 接单人编号 like '%" + EmployeeName + "%'"); }
                    s = BindSelect2(ref IsQuery);
                }
                else
                { IsQuery = false; }
                if (IsQuery)
                {
                    DataTable dtCount = orbll.GetView_Custom("Vw_StaffPerformance_MemberCardRechargeRecord", StrWhere: " 1 = 1 " + strBuilder.ToString() + s.ToString(), ShowColumnName: "Count(ID) CountID").Tables[0];
                    if (dtCount.Rows.Count > 0)
                    {
                        if (Convert.ToInt32(dtCount.Rows[0]["CountID"]) > 0)
                        {
                            backgroundWorker.ReportProgress(0, "正在获取'会员充值' ...");
                            DataTable dt_MemberRecharge = avsbll.Vw_StaffPerformance_MemberCardRechargeRecord(strBuilder.ToString() + s.ToString()).Tables[0];
                            for (int t = 0; t < dt_MemberRecharge.Rows.Count; t++)
                            {
                                #region
                                DataGridViewRow dgvr = new DataGridViewRow();
                                DataGridViewCell cell = null;

                                //订单号
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dt_MemberRecharge.Rows[t]["充值编号"].ToString().Trim();
                                dgvr.Cells.Add(cell);

                                //员工
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dt_MemberRecharge.Rows[t]["接单人名称"].ToString().Trim();
                                dgvr.Cells.Add(cell);

                                //职务
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = "会员接单人";
                                dgvr.Cells.Add(cell);

                                //客户姓名
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dt_MemberRecharge.Rows[t]["客户姓名"].ToString().Trim();
                                dgvr.Cells.Add(cell);

                                //收款金额
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = Convert.ToDecimal(dt_MemberRecharge.Rows[t]["充值金额"]).ToString("N2").Trim();
                                dgvr.Cells.Add(cell);

                                //收款时间
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dt_MemberRecharge.Rows[t]["创建时间"].ToString().Trim();
                                dgvr.Cells.Add(cell);

                                //套系类别
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = "/会员充值";
                                dgvr.Cells.Add(cell);

                                //套系名称
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dt_MemberRecharge.Rows[t]["充值名称"].ToString().Trim();
                                dgvr.Cells.Add(cell);

                                //应收金额
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = Convert.ToDecimal(dt_MemberRecharge.Rows[t]["充值金额"]).ToString("N2").Trim();
                                dgvr.Cells.Add(cell);

                                //项目名称
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dt_MemberRecharge.Rows[t]["充值名称"].ToString().Trim();
                                dgvr.Cells.Add(cell);

                                //付款名称
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dt_MemberRecharge.Rows[t]["支付方式名称"].ToString().Trim();
                                dgvr.Cells.Add(cell);

                                //拍摄状态
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = "";
                                dgvr.Cells.Add(cell);

                                //拍摄时间
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = "";
                                dgvr.Cells.Add(cell);

                                //选片状态
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = "";
                                dgvr.Cells.Add(cell);

                                //选片时间
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = "";
                                dgvr.Cells.Add(cell);

                                //取件状态
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = "";
                                dgvr.Cells.Add(cell);

                                //取件时间
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = "";
                                dgvr.Cells.Add(cell);

                                //副订单
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = "";
                                dgvr.Cells.Add(cell);
                                #endregion

                                this.Invoke(new UpdateControl(delegate()
                                {
                                    this.dgv.Rows.Add(dgvr);
                                }));
                            }
                        }
                    }
                }
                #endregion
            }
            if (this.Str_ItemCategory.Trim() == "" || this.Str_ItemCategory.Trim() == "服务卡充值")
            {
                #region 获取服务卡充值
                s = "";
                strBuilder = new StringBuilder();
                bool IsQuery = true;
                if (string.IsNullOrEmpty(this.Str_ProcessStatus.Trim()))
                {
                    strBuilder.Append("and 创建日期>='" + StartTime + "' and 创建日期<='" + EndTime + " 23:59:59.000' ");
                    if (EmployeeName != null && !string.IsNullOrEmpty(EmployeeName))
                    { strBuilder.Append("and 接单人编号 like '%" + EmployeeName + "%'"); }
                    s = BindSelect3(ref IsQuery);
                }
                else
                { IsQuery = false; }

                if (IsQuery)
                {
                    DataTable dtCount = orbll.GetView_Custom("Vw_ErpMemberCardPayment", StrWhere: " 1 = 1 " + strBuilder.ToString() + s.ToString(), ShowColumnName: "Count(ID) CountID").Tables[0];
                    if (dtCount.Rows.Count > 0)
                    {
                        if (Convert.ToInt32(dtCount.Rows[0]["CountID"]) > 0)
                        {
                            backgroundWorker.ReportProgress(0, "正在获取'服务卡充值' ...");
                            DataTable dt_ServiceRecharge = avsbll.Vw_ErpMemberCardPayment(strBuilder.ToString() + s.ToString()).Tables[0];
                            for (int t = 0; t < dt_ServiceRecharge.Rows.Count; t++)
                            {
                                #region
                                DataGridViewRow dgvr = new DataGridViewRow();
                                DataGridViewCell cell = null;

                                //订单号
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dt_ServiceRecharge.Rows[t]["收款编号"].ToString().Trim();
                                dgvr.Cells.Add(cell);

                                //员工
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dt_ServiceRecharge.Rows[t]["接单人名称"].ToString().Trim();
                                dgvr.Cells.Add(cell);

                                //职务
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = "服务卡接单人";
                                dgvr.Cells.Add(cell);

                                //客户姓名
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dt_ServiceRecharge.Rows[t]["客户姓名"].ToString().Trim();
                                dgvr.Cells.Add(cell);

                                //收款金额
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = Convert.ToDecimal(dt_ServiceRecharge.Rows[t]["收款金额"]).ToString("N2").Trim();
                                dgvr.Cells.Add(cell);

                                //收款时间
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dt_ServiceRecharge.Rows[t]["创建日期"].ToString().Trim();
                                dgvr.Cells.Add(cell);

                                //套系类别
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = "/服务卡充值";
                                dgvr.Cells.Add(cell);

                                //套系名称
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dt_ServiceRecharge.Rows[t]["服务套系类别名称"].ToString().Trim();
                                dgvr.Cells.Add(cell);

                                //应收金额
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = Convert.ToDecimal(dt_ServiceRecharge.Rows[t]["收款金额"]).ToString("N2").Trim();
                                dgvr.Cells.Add(cell);

                                //项目名称
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dt_ServiceRecharge.Rows[t]["服务套系类别名称"].ToString().Trim();
                                dgvr.Cells.Add(cell);

                                //付款名称
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dt_ServiceRecharge.Rows[t]["支付方式名称"].ToString().Trim();
                                dgvr.Cells.Add(cell);

                                //拍摄状态
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = "";
                                dgvr.Cells.Add(cell);

                                //拍摄时间
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = "";
                                dgvr.Cells.Add(cell);

                                //选片状态
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = "";
                                dgvr.Cells.Add(cell);

                                //选片时间
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = "";
                                dgvr.Cells.Add(cell);

                                //取件状态
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = "";
                                dgvr.Cells.Add(cell);

                                //取件时间
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = "";
                                dgvr.Cells.Add(cell);

                                //副订单
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = "";
                                dgvr.Cells.Add(cell);
                                #endregion

                                this.Invoke(new UpdateControl(delegate()
                                {
                                    this.dgv.Rows.Add(dgvr);
                                }));
                            }
                        }
                    }
                }
                #endregion
            }
            if (this.Str_ItemCategory.Trim() == "" || this.Str_ItemCategory.Trim() == "计件提成")
            {
                #region 获取计件提成
                s = "";
                strBuilder = new StringBuilder();
                bool IsQuery = true;
                if (string.IsNullOrEmpty(this.Str_ProcessStatus.Trim()))
                {
                    strBuilder.Append("and Pcr_Date >= '" + StartTime + "' and Pcr_Date <= '" + EndTime + " 23:59:59.000' ");
                    if (EmployeeName != null && !string.IsNullOrEmpty(EmployeeName))
                    { strBuilder.Append("and Pcr_DigitalDivision like '%" + EmployeeName + "%'"); }
                    s = BindSelect4(ref IsQuery);
                }
                else
                { IsQuery = false; }

                if (IsQuery)
                {
                    DataTable dtCount = orbll.GetView_Custom("Vw_ErpPieceCommissionRecords", StrWhere: " 1 = 1 " + strBuilder.ToString() + s.ToString(), ShowColumnName: "Count(ID) CountID").Tables[0];
                    if (dtCount.Rows.Count > 0)
                    {
                        if (Convert.ToInt32(dtCount.Rows[0]["CountID"]) > 0)
                        {
                            backgroundWorker.ReportProgress(0, "正在获取'计件提成' ...");
                            DataTable dt_PieceCommission = pcrbll.Vw_ErpPieceCommissionRecords(strBuilder.ToString() + s.ToString()).Tables[0];
                            for (int t = 0; t < dt_PieceCommission.Rows.Count; t++)
                            {
                                #region
                                DataGridViewRow dgvr = new DataGridViewRow();
                                DataGridViewCell cell = null;

                                //订单号
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dt_PieceCommission.Rows[t]["Pcr_OrderNumber"].ToString().Trim();
                                dgvr.Cells.Add(cell);

                                //员工
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dt_PieceCommission.Rows[t]["Pcr_DigitalDivisionName"].ToString().Trim();
                                dgvr.Cells.Add(cell);

                                //职务
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = "计件接单人";
                                dgvr.Cells.Add(cell);

                                //客户姓名
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dt_PieceCommission.Rows[t]["Cus_Name"].ToString().Trim();
                                dgvr.Cells.Add(cell);

                                //收款金额
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dt_PieceCommission.Rows[t]["总价格"].ToString() == "" ? "0" : Convert.ToDecimal(dt_PieceCommission.Rows[t]["总价格"]).ToString("N2");
                                dgvr.Cells.Add(cell);

                                //收款时间
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dt_PieceCommission.Rows[t]["Pcr_Date"].ToString().Trim();
                                dgvr.Cells.Add(cell);

                                //套系类别
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = "/计件提成";
                                dgvr.Cells.Add(cell);

                                //套系名称
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dt_PieceCommission.Rows[t]["Pcr_CompletionContentsName"].ToString().Trim();
                                dgvr.Cells.Add(cell);

                                //应收金额
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dt_PieceCommission.Rows[t]["总价格"].ToString() == "" ? "0" : Convert.ToDecimal(dt_PieceCommission.Rows[t]["总价格"]).ToString("N2");
                                dgvr.Cells.Add(cell);

                                //项目名称
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dt_PieceCommission.Rows[t]["Pcr_CompletionContentsName"].ToString().Trim();
                                dgvr.Cells.Add(cell);

                                //付款名称
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = "";
                                dgvr.Cells.Add(cell);

                                //拍摄状态
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = "";
                                dgvr.Cells.Add(cell);

                                //拍摄时间
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = "";
                                dgvr.Cells.Add(cell);

                                //选片状态
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = "";
                                dgvr.Cells.Add(cell);

                                //选片时间
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = "";
                                dgvr.Cells.Add(cell);

                                //取件状态
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = "";
                                dgvr.Cells.Add(cell);

                                //取件时间
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = "";
                                dgvr.Cells.Add(cell);

                                //副订单
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = "";
                                dgvr.Cells.Add(cell);

                                //满意总分
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = "";
                                dgvr.Cells.Add(cell);

                                //
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = "";
                                dgvr.Cells.Add(cell);

                                //
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = "";
                                dgvr.Cells.Add(cell);

                                //
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = "";
                                dgvr.Cells.Add(cell);

                                //数量
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = Convert.ToInt32(dt_PieceCommission.Rows[t]["Pcr_Quantity"]).ToString().Trim();
                                dgvr.Cells.Add(cell);
                                #endregion

                                this.Invoke(new UpdateControl(delegate()
                                {
                                    this.dgv.Rows.Add(dgvr);
                                }));
                            }
                        }
                    }
                }
                #endregion
            }
            #endregion

            #region 显示绘画(计算业绩)
            backgroundWorker.ReportProgress(0, "正在计算业绩 ...");
            string StrWhere1 = "";
            string StrWhere2 = "";
            string StrMainNumber = "";
            string StrViceNumber = "";
            this.Invoke(new UpdateControl(delegate()
            {
                for (int i = 0; i < this.dgv.Rows.Count; i++)
                {
                    if (this.dgv.Rows[i].Cells["Column19"].Value != null)
                    {
                        if (this.dgv.Rows[i].Cells["Column19"].Value.ToString().Trim() != "1")
                        { StrMainNumber += "'" + this.dgv.Rows[i].Cells["Column1"].Value.ToString().Trim() + "',"; }
                        else
                        { StrViceNumber += "'" + this.dgv.Rows[i].Cells["Column21"].Value.ToString().Trim() + "',"; }
                    }
                }
            }));

            if (!string.IsNullOrEmpty(StrMainNumber))
            {
                //StrWhere1 += "主订单 in (" + StrMainNumber.TrimEnd(',') + ")";
                StrWhere1 += "Ordv_Number in (" + StrMainNumber.TrimEnd(',') + ")";
                StrWhere2 += "Ordpg_Number in (" + StrMainNumber.TrimEnd(',') + ")";
            }
            if (!string.IsNullOrEmpty(StrViceNumber))
            {
                if (string.IsNullOrEmpty(StrMainNumber))
                {
                    //StrWhere1 += "副订单 in (" + StrViceNumber.TrimEnd(',') + ")";
                    StrWhere1 += "Ordv_ViceNumber in (" + StrViceNumber.TrimEnd(',') + ")";
                    StrWhere2 += "Ordpg_ViceNumber in (" + StrViceNumber.TrimEnd(',') + ")";
                }
                else
                {
                    //StrWhere1 += " Or 副订单 in (" + StrViceNumber.TrimEnd(',') + ")";
                    StrWhere1 += " Or Ordv_ViceNumber in (" + StrViceNumber.TrimEnd(',') + ")";
                    StrWhere2 += " Or Ordpg_ViceNumber in (" + StrViceNumber.TrimEnd(',') + ")";
                }
            }
            DataTable dt_Level = new DataTable();
            DataTable dt_Sights = new DataTable();
            if (!string.IsNullOrEmpty(StrWhere1))
            {
                //dt_Level = orbll.GetView_Custom("Vw_StaffPerformance_Photograph", StrWhere: StrWhere1, ShowColumnName: "*").Tables[0];
                dt_Level = LYFZ.BLL.BLL_ErpPaymentPayrollClass.GetPayrollLevel(StrWhere1);
            }
            if (!string.IsNullOrEmpty(StrWhere2))
            { dt_Sights = orbll.GetView_Custom("tb_ErpOrdersPhotography", StrWhere: StrWhere2, ShowColumnName: "*").Tables[0]; }

            this.Invoke(new UpdateControl(delegate()
            {
                if (this.dgv.Rows.Count > 0)
                {
                    decimal CurrentPerformance = 0; //业绩
                    decimal PieceCommission = 0;
                    for (int i = 0; i < this.dgv.Rows.Count; i++)
                    {
                        #region  参数
                        string Ord_Number = this.dgv.Rows[i].Cells["Column1"].Value.ToString();
                        object DeputyOrd_Number = this.dgv.Rows[i].Cells["Column21"].Value;
                        object Ord_Type = this.dgv.Rows[i].Cells["Column19"].Value;
                        object Pay_Category = this.dgv.Rows[i].Cells["Column20"].Value;
                        object Project_Name = this.dgv.Rows[i].Cells["Column8"].Value;
                        object Post = this.dgv.Rows[i].Cells["Column17"].Value;
                        decimal Pay_AmountOf = Convert.ToDecimal(this.dgv.Rows[i].Cells["Column3"].Value);

                        //摄影师
                        string OrdPg_Photographer = "";
                        string OrdPg_PhotographyAssistant = "";
                        //等级
                        string OrdPg_SightsLevel = "";
                        //化妆
                        string OrdPg_MakeupArtist = "";
                        string OrdPg_MakeupAssistant = "";
                        //引导
                        string Ordpg_BootDivision = "";
                        string Ordpg_BootDivisionAssistant = "";
                        #endregion

                        #region 绘画前期业绩(摄影，化妆)
                        if (Ord_Type != null)
                        {
                            if (Pay_Category.ToString() == "预约收款" || Pay_Category.ToString() == "全款" || Pay_Category.ToString() == "预约补款" || Project_Name.ToString() == "选片二销")
                            {
                                if (Ord_Type.ToString() != "")
                                {
                                    #region 获取等级级别个数
                                    //以下为滕工版
                                    string StrWhere = "";
                                    //if (Ord_Type.ToString() != "1")
                                    //{ StrWhere = " 主订单='" + Ord_Number + "'"; }
                                    //else
                                    //{ StrWhere = " 副订单='" + DeputyOrd_Number + "'"; }
                                    if (Ord_Type.ToString() != "1")
                                    { StrWhere = " Ordv_Number='" + Ord_Number + "'"; }
                                    else
                                    { StrWhere = " Ordv_ViceNumber='" + DeputyOrd_Number + "'"; }
                                    DataRow[] dtRows = dt_Level.Select(StrWhere);
                                    if (dtRows.Length > 0)
                                    {
                                        OneLevelCount = Convert.ToInt32(dtRows[0]["景点一级个数"]);
                                        TwoLevelCount = Convert.ToInt32(dtRows[0]["景点二级个数"]);
                                        ThreeLevelCount = Convert.ToInt32(dtRows[0]["景点三级个数"]);
                                        OrdPg_Photographer = dtRows[0]["主摄影师ID"].ToString();
                                        OrdPg_PhotographyAssistant = dtRows[0]["摄影助理ID"].ToString();
                                        OrdPg_MakeupArtist = dtRows[0]["主化妆ID"].ToString();
                                        OrdPg_MakeupAssistant = dtRows[0]["化妆助理ID"].ToString();
                                        Ordpg_BootDivision = dtRows[0]["引导师ID"].ToString();
                                        Ordpg_BootDivisionAssistant = dtRows[0]["引导助理ID"].ToString();
                                    }

                                    #region 摄影工资
                                    if (Post.ToString() == "主摄影师" || Post.ToString() == "摄影助理" || Post.ToString() == "主摄影选片二销" || Post.ToString() == "摄影助理选片二销")
                                    {
                                        //修改前 if ((OneLevelCount >= 1 && TwoLevelCount == 0 && ThreeLevelCount == 0) || (OneLevelCount == 0 && TwoLevelCount >= 1 && ThreeLevelCount == 0) || (OneLevelCount == 0 && TwoLevelCount == 0 && ThreeLevelCount >= 1))
                                        //刘工修改 
                                        if ((OneLevelCount + TwoLevelCount + ThreeLevelCount) == 1)
                                        {
                                            #region 1.如果所以景点阶段都相同
                                            decimal Amount = 0;
                                            if (Post.ToString() == "主摄影师" || Post.ToString() == "主摄影选片二销")
                                            {
                                                OrdPg_Photographer = OrdPg_Photographer.TrimEnd(',');
                                                string[] OrdPg_Photographer_O = OrdPg_Photographer.Split(',');
                                                for (int t = 0; t < OrdPg_Photographer_O.Length; t++)
                                                {
                                                    if (OrdPg_Photographer_O[t] == EmployeeName)
                                                    {
                                                        if (!string.IsNullOrEmpty(OrdPg_Photographer.ToString().TrimEnd(',')) && !string.IsNullOrEmpty(OrdPg_PhotographyAssistant.ToString().TrimEnd(',')))
                                                        { Amount += (Pay_AmountOf * (MainPhotography / 100)) / OrdPg_Photographer_O.Length; }
                                                        else
                                                        { Amount += Pay_AmountOf / OrdPg_Photographer_O.Length; }
                                                    }
                                                }
                                            }
                                            if (Post.ToString() == "摄影助理" || Post.ToString() == "摄影助理选片二销")
                                            {
                                                OrdPg_PhotographyAssistant = OrdPg_PhotographyAssistant.TrimEnd(',');
                                                string[] OrdPg_PhotographyAssistant_O = OrdPg_PhotographyAssistant.Split(',');
                                                for (int t = 0; t < OrdPg_PhotographyAssistant_O.Length; t++)
                                                {
                                                    if (OrdPg_PhotographyAssistant_O[t] == EmployeeName)
                                                    {
                                                        if (!string.IsNullOrEmpty(OrdPg_Photographer.ToString().TrimEnd(',')) && !string.IsNullOrEmpty(OrdPg_PhotographyAssistant.ToString().TrimEnd(',')))
                                                        { Amount += (Pay_AmountOf * (DeputyPhotography / 100)) / OrdPg_PhotographyAssistant_O.Length; }
                                                        else
                                                        { Amount += Pay_AmountOf / OrdPg_PhotographyAssistant_O.Length; }
                                                    }
                                                }
                                            }
                                            this.dgv.Rows[i].Cells["Column3"].Value = Convert.ToDecimal(Amount).ToString("N2");
                                            #endregion
                                        }
                                        else
                                        {
                                            #region 2.如果等级不相同
                                            decimal Amount = 0;
                                            decimal Amount_A = 0;
                                            decimal Onej = 0;//一级景点工资
                                            decimal Twoj = 0; //二级景点工资
                                            decimal Threej = 0; //三级景点工资
                                            //获取景点等级总百分比
                                            decimal AttractionsPercentage = (OneLevelCount * OneLevel) + (TwoLevelCount * TwoLevel) + (ThreeLevelCount * ThreeLevel);
                                            if (AttractionsPercentage != 0)
                                            {
                                                Onej = Pay_AmountOf / AttractionsPercentage * OneLevel;
                                                Twoj = Pay_AmountOf / AttractionsPercentage * TwoLevel;
                                                Threej = Pay_AmountOf / AttractionsPercentage * ThreeLevel;
                                            }
                                            if (!string.IsNullOrEmpty(OrdPg_Photographer.ToString().TrimEnd(',')))
                                            {
                                                #region 主等于副
                                                if (OrdPg_Photographer.ToString().TrimEnd(',') == OrdPg_PhotographyAssistant.ToString().TrimEnd(','))
                                                {
                                                    if (Post.ToString() == "主摄影师" || Post.ToString() == "主摄影选片二销")
                                                    { Amount = (Pay_AmountOf * (MainPhotography / 100)); }
                                                    if (Post.ToString() == "摄影助理" || Post.ToString() == "摄影助理选片二销")
                                                    { Amount = (Pay_AmountOf * (DeputyPhotography / 100)); }
                                                }
                                                #endregion

                                                #region 副为空
                                                if (string.IsNullOrEmpty(OrdPg_PhotographyAssistant.ToString().TrimEnd(',')))
                                                {
                                                    //按照景点等级比重
                                                    if (Post.ToString() == "主摄影师" || Post.ToString() == "主摄影选片二销")
                                                    {
                                                        //获取摄影人员
                                                        DataRow[] dtRow = null;
                                                        if (Ord_Type.ToString() != "1")
                                                        { dtRow = dt_Sights.Select("Ordpg_Number='" + Ord_Number + "' and Ordpg_Photographer = '" + EmployeeName + "'"); }
                                                        else
                                                        { dtRow = dt_Sights.Select("Ordpg_ViceNumber='" + DeputyOrd_Number + "' and Ordpg_Photographer = '" + EmployeeName + "'"); }
                                                        if (dtRow != null)
                                                        {
                                                            for (int y = 0; y < dtRow.Length; y++)
                                                            {
                                                                OrdPg_SightsLevel = dtRow[y]["OrdPg_SightsLevel"].ToString();
                                                                //一级
                                                                if (OrdPg_SightsLevel == "BEBBBCADDEBFJDFFC")
                                                                { Amount += Onej; }
                                                                //二级
                                                                if (OrdPg_SightsLevel == "BEBBBCADEGBGAFFJC")
                                                                { Amount += Twoj; }
                                                                //三级
                                                                if (OrdPg_SightsLevel == "BEBBBCADAFBHBCHCI")
                                                                { Amount += Threej; }
                                                            }
                                                        }
                                                    }
                                                }
                                                #endregion

                                                #region 主副不为空并且不相等
                                                if ((!string.IsNullOrEmpty(OrdPg_Photographer.ToString().TrimEnd(',')) && !string.IsNullOrEmpty(OrdPg_PhotographyAssistant.ToString().TrimEnd(','))) && OrdPg_Photographer.ToString().TrimEnd(',') != OrdPg_PhotographyAssistant.ToString().TrimEnd(','))
                                                {
                                                    #region 主
                                                    if (Post.ToString() == "主摄影师" || Post.ToString() == "主摄影选片二销")
                                                    {
                                                        //获取摄影人员
                                                        DataRow[] dtRow = null;
                                                        if (Ord_Type.ToString() != "1")
                                                        { dtRow = dt_Sights.Select("Ordpg_Number='" + Ord_Number + "' and Ordpg_Photographer = '" + EmployeeName + "'"); }
                                                        else
                                                        { dtRow = dt_Sights.Select("Ordpg_ViceNumber='" + DeputyOrd_Number + "' and Ordpg_Photographer = '" + EmployeeName + "'"); }
                                                        if (dtRow != null)
                                                        {
                                                            Amount_A = Pay_AmountOf * (MainPhotography / 100);
                                                            for (int y = 0; y < dtRow.Length; y++)
                                                            {
                                                                OrdPg_SightsLevel = dtRow[y]["OrdPg_SightsLevel"].ToString();
                                                                if (AttractionsPercentage != 0)
                                                                {
                                                                    //一级
                                                                    if (OrdPg_SightsLevel == "BEBBBCADDEBFJDFFC")
                                                                    { Amount += Amount_A / AttractionsPercentage * OneLevel; }
                                                                    //二级
                                                                    if (OrdPg_SightsLevel == "BEBBBCADEGBGAFFJC")
                                                                    { Amount += Amount_A / AttractionsPercentage * TwoLevel; }
                                                                    //三级
                                                                    if (OrdPg_SightsLevel == "BEBBBCADAFBHBCHCI")
                                                                    { Amount += Amount_A / AttractionsPercentage * ThreeLevel; }
                                                                }
                                                            }
                                                        }
                                                    }
                                                    #endregion

                                                    #region 副
                                                    if (Post.ToString() == "摄影助理" || Post.ToString() == "摄影助理选片二销")
                                                    {
                                                        //获取摄影人员
                                                        DataRow[] dtRow = null;
                                                        if (Ord_Type.ToString() != "1")
                                                        { dtRow = dt_Sights.Select("Ordpg_Number='" + Ord_Number + "' and Ordpg_PhotographyAssistant = '" + EmployeeName + "'"); }
                                                        else
                                                        { dtRow = dt_Sights.Select("Ordpg_ViceNumber='" + DeputyOrd_Number + "' and Ordpg_PhotographyAssistant = '" + EmployeeName + "'"); }
                                                        if (dtRow != null)
                                                        {
                                                            Amount_A = Pay_AmountOf * (DeputyPhotography / 100);
                                                            for (int y = 0; y < dtRow.Length; y++)
                                                            {
                                                                OrdPg_SightsLevel = dtRow[y]["OrdPg_SightsLevel"].ToString();
                                                                if (AttractionsPercentage != 0)
                                                                {
                                                                    //一级
                                                                    if (OrdPg_SightsLevel == "BEBBBCADDEBFJDFFC")
                                                                    { Amount += Amount_A / AttractionsPercentage * OneLevel; }
                                                                    //二级
                                                                    if (OrdPg_SightsLevel == "BEBBBCADEGBGAFFJC")
                                                                    { Amount += Amount_A / AttractionsPercentage * TwoLevel; }
                                                                    //三级
                                                                    if (OrdPg_SightsLevel == "BEBBBCADAFBHBCHCI")
                                                                    { Amount += Amount_A / AttractionsPercentage * ThreeLevel; }
                                                                }
                                                            }
                                                        }
                                                    }
                                                    #endregion
                                                }
                                                #endregion
                                            }
                                            this.dgv.Rows[i].Cells["Column3"].Value = Convert.ToDecimal(Amount).ToString("N2");
                                            #endregion
                                        }
                                    }
                                    #endregion

                                    #region 化妆工资
                                    if (Post.ToString() == "主化妆师" || Post.ToString() == "化妆助理" || Post.ToString() == "主化妆选片二销" || Post.ToString() == "化妆助理选片二销")
                                    {
                                        //修改前 if ((OneLevelCount >= 1 && TwoLevelCount == 0 && ThreeLevelCount == 0) || (OneLevelCount == 0 && TwoLevelCount >= 1 && ThreeLevelCount == 0) || (OneLevelCount == 0 && TwoLevelCount == 0 && ThreeLevelCount >= 1))
                                        //刘工修改 
                                        if ((OneLevelCount + TwoLevelCount + ThreeLevelCount) == 1)
                                        {
                                            #region 1.如果所以景点阶段都相同
                                            decimal Amount = 0;
                                            if (Post.ToString() == "主化妆师" || Post.ToString() == "主化妆选片二销")
                                            {
                                                OrdPg_MakeupArtist = OrdPg_MakeupArtist.TrimEnd(',');
                                                string[] OrdPg_MakeupArtist_O = OrdPg_MakeupArtist.Split(',');
                                                for (int t = 0; t < OrdPg_MakeupArtist_O.Length; t++)
                                                {
                                                    if (OrdPg_MakeupArtist_O[t] == EmployeeName)
                                                    {
                                                        if (!string.IsNullOrEmpty(OrdPg_MakeupArtist.ToString().TrimEnd(',')) && !string.IsNullOrEmpty(OrdPg_MakeupAssistant.ToString().TrimEnd(',')))
                                                        { Amount += (Pay_AmountOf * (MainMake / 100)) / OrdPg_MakeupArtist_O.Length; }
                                                        else
                                                        { Amount += Pay_AmountOf / OrdPg_MakeupArtist_O.Length; }
                                                    }
                                                }
                                            }
                                            if (Post.ToString() == "化妆助理" || Post.ToString() == "化妆助理选片二销")
                                            {
                                                OrdPg_MakeupAssistant = OrdPg_MakeupAssistant.TrimEnd(',');
                                                string[] OrdPg_MakeupAssistant_O = OrdPg_MakeupAssistant.Split(',');
                                                for (int t = 0; t < OrdPg_MakeupAssistant_O.Length; t++)
                                                {
                                                    if (OrdPg_MakeupAssistant_O[t] == EmployeeName)
                                                    {
                                                        if (!string.IsNullOrEmpty(OrdPg_MakeupArtist.ToString().TrimEnd(',')) && !string.IsNullOrEmpty(OrdPg_MakeupAssistant.ToString().TrimEnd(',')))
                                                        { Amount += (Pay_AmountOf * (DeputyMake / 100)) / OrdPg_MakeupAssistant_O.Length; }
                                                        else
                                                        { Amount += Pay_AmountOf / OrdPg_MakeupAssistant_O.Length; }
                                                    }
                                                }
                                            }
                                            this.dgv.Rows[i].Cells["Column3"].Value = Convert.ToDecimal(Amount).ToString("N2");
                                            #endregion
                                        }
                                        else
                                        {
                                            #region 2.如果等级不相同
                                            decimal Amount = 0;
                                            decimal Amount_A = 0;
                                            decimal Onej = 0;//一级景点工资
                                            decimal Twoj = 0; //二级景点工资
                                            decimal Threej = 0; //三级景点工资

                                            //获取景点等级总百分比
                                            decimal AttractionsPercentage = (OneLevelCount * OneLevel) + (TwoLevelCount * TwoLevel) + (ThreeLevelCount * ThreeLevel);
                                            if (AttractionsPercentage != 0)
                                            {
                                                Onej = Pay_AmountOf / AttractionsPercentage * OneLevel;
                                                Twoj = Pay_AmountOf / AttractionsPercentage * TwoLevel;
                                                Threej = Pay_AmountOf / AttractionsPercentage * ThreeLevel;
                                            }
                                            if (!string.IsNullOrEmpty(OrdPg_MakeupArtist.ToString().TrimEnd(',')))
                                            {
                                                #region 主等于副
                                                if (OrdPg_MakeupArtist.ToString().TrimEnd(',') == OrdPg_MakeupAssistant.ToString().TrimEnd(','))
                                                {
                                                    if (Post.ToString() == "主化妆师" || Post.ToString() == "主化妆选片二销")
                                                    { Amount = (Pay_AmountOf * (MainMake / 100)); }
                                                    if (Post.ToString() == "化妆助理" || Post.ToString() == "化妆助理选片二销")
                                                    { Amount = (Pay_AmountOf * (DeputyMake / 100)); }
                                                }
                                                #endregion

                                                #region 副为空
                                                if (string.IsNullOrEmpty(OrdPg_MakeupAssistant.ToString().TrimEnd(',')))
                                                {
                                                    //按照景点等级比重
                                                    if (Post.ToString() == "主化妆师" || Post.ToString() == "主化妆选片二销")
                                                    {
                                                        //获取化妆人员
                                                        DataRow[] dtRow = null;
                                                        if (Ord_Type.ToString() != "1")
                                                        { dtRow = dt_Sights.Select("Ordpg_Number='" + Ord_Number + "' and Ordpg_MakeupArtist = '" + EmployeeName + "'"); }
                                                        else
                                                        { dtRow = dt_Sights.Select("Ordpg_ViceNumber='" + DeputyOrd_Number + "' and Ordpg_MakeupArtist = '" + EmployeeName + "'"); }
                                                        if (dtRow != null)
                                                        {
                                                            for (int y = 0; y < dtRow.Length; y++)
                                                            {
                                                                OrdPg_SightsLevel = dtRow[y]["OrdPg_SightsLevel"].ToString();
                                                                //一级
                                                                if (OrdPg_SightsLevel == "BEBBBCADDEBFJDFFC")
                                                                { Amount += Onej; }
                                                                //二级
                                                                if (OrdPg_SightsLevel == "BEBBBCADEGBGAFFJC")
                                                                { Amount += Twoj; }
                                                                //三级
                                                                if (OrdPg_SightsLevel == "BEBBBCADAFBHBCHCI")
                                                                { Amount += Threej; }
                                                            }
                                                        }
                                                    }
                                                }
                                                #endregion

                                                #region 主副不为空并且不相等
                                                if ((!string.IsNullOrEmpty(OrdPg_MakeupArtist.ToString().TrimEnd(',')) && !string.IsNullOrEmpty(OrdPg_MakeupAssistant.ToString().TrimEnd(','))) && OrdPg_MakeupArtist.ToString().TrimEnd(',') != OrdPg_MakeupAssistant.ToString().TrimEnd(','))
                                                {
                                                    #region 主
                                                    if (Post.ToString() == "主化妆师" || Post.ToString() == "主化妆选片二销")
                                                    {
                                                        //获取摄影人员
                                                        DataRow[] dtRow = null;
                                                        if (Ord_Type.ToString() != "1")
                                                        { dtRow = dt_Sights.Select("Ordpg_Number='" + Ord_Number + "' and Ordpg_MakeupArtist = '" + EmployeeName + "'"); }
                                                        else
                                                        { dtRow = dt_Sights.Select("Ordpg_ViceNumber='" + DeputyOrd_Number + "' and Ordpg_MakeupArtist = '" + EmployeeName + "'"); }
                                                        if (dtRow != null)
                                                        {
                                                            Amount_A = Pay_AmountOf * (MainMake / 100);
                                                            for (int y = 0; y < dtRow.Length; y++)
                                                            {
                                                                OrdPg_SightsLevel = dtRow[y]["OrdPg_SightsLevel"].ToString();
                                                                if (AttractionsPercentage != 0)
                                                                {
                                                                    //一级
                                                                    if (OrdPg_SightsLevel == "BEBBBCADDEBFJDFFC")
                                                                    { Amount += Amount_A / AttractionsPercentage * OneLevel; }
                                                                    //二级
                                                                    if (OrdPg_SightsLevel == "BEBBBCADEGBGAFFJC")
                                                                    { Amount += Amount_A / AttractionsPercentage * TwoLevel; }
                                                                    //三级
                                                                    if (OrdPg_SightsLevel == "BEBBBCADAFBHBCHCI")
                                                                    { Amount += Amount_A / AttractionsPercentage * ThreeLevel; }
                                                                }
                                                            }
                                                        }
                                                    }
                                                    #endregion

                                                    #region 副
                                                    if (Post.ToString() == "化妆助理" || Post.ToString() == "化妆助理选片二销")
                                                    {
                                                        //获取摄影人员
                                                        DataRow[] dtRow = null;
                                                        if (Ord_Type.ToString() != "1")
                                                        { dtRow = dt_Sights.Select("Ordpg_Number='" + Ord_Number + "' and Ordpg_MakeupAssistant = '" + EmployeeName + "'"); }
                                                        else
                                                        { dtRow = dt_Sights.Select("Ordpg_ViceNumber='" + DeputyOrd_Number + "' and Ordpg_MakeupAssistant = '" + EmployeeName + "'"); }
                                                        if (dtRow != null)
                                                        {
                                                            Amount_A = Pay_AmountOf * (DeputyMake / 100);
                                                            for (int y = 0; y < dtRow.Length; y++)
                                                            {
                                                                OrdPg_SightsLevel = dtRow[y]["OrdPg_SightsLevel"].ToString();
                                                                if (AttractionsPercentage != 0)
                                                                {
                                                                    //一级
                                                                    if (OrdPg_SightsLevel == "BEBBBCADDEBFJDFFC")
                                                                    { Amount += Amount_A / AttractionsPercentage * OneLevel; }
                                                                    //二级
                                                                    if (OrdPg_SightsLevel == "BEBBBCADEGBGAFFJC")
                                                                    { Amount += Amount_A / AttractionsPercentage * TwoLevel; }
                                                                    //三级
                                                                    if (OrdPg_SightsLevel == "BEBBBCADAFBHBCHCI")
                                                                    { Amount += Amount_A / AttractionsPercentage * ThreeLevel; }
                                                                }
                                                            }
                                                        }
                                                    }
                                                    #endregion
                                                }
                                                #endregion
                                            }
                                            this.dgv.Rows[i].Cells["Column3"].Value = Convert.ToDecimal(Amount).ToString("N2");
                                            #endregion
                                        }
                                    }
                                    #endregion

                                    #region 引导工资
                                    if (Post.ToString() == "引导师" || Post.ToString() == "引导助理" || Post.ToString() == "引导选片二销" || Post.ToString() == "引导助理选片二销")
                                    {
                                        //修改前 if ((OneLevelCount >= 1 && TwoLevelCount == 0 && ThreeLevelCount == 0) || (OneLevelCount == 0 && TwoLevelCount >= 1 && ThreeLevelCount == 0) || (OneLevelCount == 0 && TwoLevelCount == 0 && ThreeLevelCount >= 1))
                                        //刘工修改 
                                        if ((OneLevelCount + TwoLevelCount + ThreeLevelCount) == 1)
                                        {
                                            #region 1.如果所以景点阶段都相同
                                            decimal Amount = 0;
                                            if (Post.ToString() == "引导师" || Post.ToString() == "引导选片二销")
                                            {
                                                Ordpg_BootDivision = Ordpg_BootDivision.TrimEnd(',');
                                                string[] OrdPg_MakeupArtist_O = Ordpg_BootDivision.Split(',');
                                                for (int t = 0; t < OrdPg_MakeupArtist_O.Length; t++)
                                                {
                                                    if (OrdPg_MakeupArtist_O[t] == EmployeeName)
                                                    {
                                                        if (!string.IsNullOrEmpty(Ordpg_BootDivision.ToString().TrimEnd(',')) && !string.IsNullOrEmpty(Ordpg_BootDivisionAssistant.ToString().TrimEnd(',')))
                                                        { Amount += (Pay_AmountOf * (MainBootDivision / 100)) / OrdPg_MakeupArtist_O.Length; }
                                                        else
                                                        { Amount += Pay_AmountOf / OrdPg_MakeupArtist_O.Length; }
                                                    }
                                                }
                                            }
                                            if (Post.ToString() == "引导助理" || Post.ToString() == "引导助理选片二销")
                                            {
                                                Ordpg_BootDivisionAssistant = Ordpg_BootDivisionAssistant.TrimEnd(',');
                                                string[] OrdPg_MakeupAssistant_O = Ordpg_BootDivisionAssistant.Split(',');
                                                for (int t = 0; t < OrdPg_MakeupAssistant_O.Length; t++)
                                                {
                                                    if (OrdPg_MakeupAssistant_O[t] == EmployeeName)
                                                    {
                                                        if (!string.IsNullOrEmpty(Ordpg_BootDivision.ToString().TrimEnd(',')) && !string.IsNullOrEmpty(Ordpg_BootDivisionAssistant.ToString().TrimEnd(',')))
                                                        { Amount += (Pay_AmountOf * (DeputyBootDivision / 100)) / OrdPg_MakeupAssistant_O.Length; }
                                                        else
                                                        { Amount += Pay_AmountOf / OrdPg_MakeupAssistant_O.Length; }
                                                    }
                                                }
                                            }
                                            this.dgv.Rows[i].Cells["Column3"].Value = Convert.ToDecimal(Amount).ToString("N2");
                                            #endregion
                                        }
                                        else
                                        {
                                            #region 2.如果等级不相同
                                            decimal Amount = 0;
                                            decimal Amount_A = 0;
                                            decimal Onej = 0;//一级景点工资
                                            decimal Twoj = 0; //二级景点工资
                                            decimal Threej = 0; //三级景点工资

                                            //获取景点等级总百分比
                                            decimal AttractionsPercentage = (OneLevelCount * OneLevel) + (TwoLevelCount * TwoLevel) + (ThreeLevelCount * ThreeLevel);
                                            if (AttractionsPercentage != 0)
                                            {
                                                Onej = Pay_AmountOf / AttractionsPercentage * OneLevel;
                                                Twoj = Pay_AmountOf / AttractionsPercentage * TwoLevel;
                                                Threej = Pay_AmountOf / AttractionsPercentage * ThreeLevel;
                                            }
                                            if (!string.IsNullOrEmpty(Ordpg_BootDivision.ToString().TrimEnd(',')))
                                            {
                                                #region 主等于副
                                                if (Ordpg_BootDivision.ToString().TrimEnd(',') == Ordpg_BootDivisionAssistant.ToString().TrimEnd(','))
                                                {
                                                    if (Post.ToString() == "引导师" || Post.ToString() == "引导选片二销")
                                                    { Amount = (Pay_AmountOf * (MainBootDivision / 100)); }
                                                    if (Post.ToString() == "引导助理" || Post.ToString() == "引导助理选片二销")
                                                    { Amount = (Pay_AmountOf * (DeputyBootDivision / 100)); }
                                                }
                                                #endregion

                                                #region 副为空
                                                if (string.IsNullOrEmpty(Ordpg_BootDivisionAssistant.ToString().TrimEnd(',')))
                                                {
                                                    //按照景点等级比重
                                                    if (Post.ToString() == "引导师" || Post.ToString() == "引导选片二销")
                                                    {
                                                        //获取化妆人员
                                                        DataRow[] dtRow = null;
                                                        if (Ord_Type.ToString() != "1")
                                                        { dtRow = dt_Sights.Select("Ordpg_Number='" + Ord_Number + "' and Ordpg_BootDivision = '" + EmployeeName + "'"); }
                                                        else
                                                        { dtRow = dt_Sights.Select("Ordpg_ViceNumber='" + DeputyOrd_Number + "' and Ordpg_BootDivision = '" + EmployeeName + "'"); }
                                                        if (dtRow != null)
                                                        {
                                                            for (int y = 0; y < dtRow.Length; y++)
                                                            {
                                                                OrdPg_SightsLevel = dtRow[y]["OrdPg_SightsLevel"].ToString();
                                                                //一级
                                                                if (OrdPg_SightsLevel == "BEBBBCADDEBFJDFFC")
                                                                { Amount += Onej; }
                                                                //二级
                                                                if (OrdPg_SightsLevel == "BEBBBCADEGBGAFFJC")
                                                                { Amount += Twoj; }
                                                                //三级
                                                                if (OrdPg_SightsLevel == "BEBBBCADAFBHBCHCI")
                                                                { Amount += Threej; }
                                                            }
                                                        }
                                                    }
                                                }
                                                #endregion

                                                #region 主副不为空并且不相等
                                                if ((!string.IsNullOrEmpty(Ordpg_BootDivision.ToString().TrimEnd(',')) && !string.IsNullOrEmpty(Ordpg_BootDivisionAssistant.ToString().TrimEnd(','))) && Ordpg_BootDivision.ToString().TrimEnd(',') != Ordpg_BootDivisionAssistant.ToString().TrimEnd(','))
                                                {
                                                    #region 主
                                                    if (Post.ToString() == "引导师" || Post.ToString() == "引导选片二销")
                                                    {
                                                        //获取摄影人员
                                                        DataRow[] dtRow = null;
                                                        if (Ord_Type.ToString() != "1")
                                                        { dtRow = dt_Sights.Select("Ordpg_Number='" + Ord_Number + "' and Ordpg_BootDivision = '" + EmployeeName + "'"); }
                                                        else
                                                        { dtRow = dt_Sights.Select("Ordpg_ViceNumber='" + DeputyOrd_Number + "' and Ordpg_BootDivision = '" + EmployeeName + "'"); }
                                                        if (dtRow != null)
                                                        {
                                                            Amount_A = Pay_AmountOf * (MainBootDivision / 100);
                                                            for (int y = 0; y < dtRow.Length; y++)
                                                            {
                                                                OrdPg_SightsLevel = dtRow[y]["OrdPg_SightsLevel"].ToString();
                                                                if (AttractionsPercentage != 0)
                                                                {
                                                                    //一级
                                                                    if (OrdPg_SightsLevel == "BEBBBCADDEBFJDFFC")
                                                                    { Amount += Amount_A / AttractionsPercentage * OneLevel; }
                                                                    //二级
                                                                    if (OrdPg_SightsLevel == "BEBBBCADEGBGAFFJC")
                                                                    { Amount += Amount_A / AttractionsPercentage * TwoLevel; }
                                                                    //三级
                                                                    if (OrdPg_SightsLevel == "BEBBBCADAFBHBCHCI")
                                                                    { Amount += Amount_A / AttractionsPercentage * ThreeLevel; }
                                                                }
                                                            }
                                                        }
                                                    }
                                                    #endregion

                                                    #region 副
                                                    if (Post.ToString() == "引导助理" || Post.ToString() == "引导助理选片二销")
                                                    {
                                                        //获取摄影人员
                                                        DataRow[] dtRow = null;
                                                        if (Ord_Type.ToString() != "1")
                                                        { dtRow = dt_Sights.Select("Ordpg_Number='" + Ord_Number + "' and Ordpg_BootDivisionAssistant = '" + EmployeeName + "'"); }
                                                        else
                                                        { dtRow = dt_Sights.Select("Ordpg_ViceNumber='" + DeputyOrd_Number + "' and Ordpg_BootDivisionAssistant = '" + EmployeeName + "'"); }
                                                        if (dtRow != null)
                                                        {
                                                            Amount_A = Pay_AmountOf * (DeputyBootDivision / 100);
                                                            for (int y = 0; y < dtRow.Length; y++)
                                                            {
                                                                OrdPg_SightsLevel = dtRow[y]["OrdPg_SightsLevel"].ToString();
                                                                if (AttractionsPercentage != 0)
                                                                {
                                                                    //一级
                                                                    if (OrdPg_SightsLevel == "BEBBBCADDEBFJDFFC")
                                                                    { Amount += Amount_A / AttractionsPercentage * OneLevel; }
                                                                    //二级
                                                                    if (OrdPg_SightsLevel == "BEBBBCADEGBGAFFJC")
                                                                    { Amount += Amount_A / AttractionsPercentage * TwoLevel; }
                                                                    //三级
                                                                    if (OrdPg_SightsLevel == "BEBBBCADAFBHBCHCI")
                                                                    { Amount += Amount_A / AttractionsPercentage * ThreeLevel; }
                                                                }
                                                            }
                                                        }
                                                    }
                                                    #endregion
                                                }
                                                #endregion
                                            }
                                            this.dgv.Rows[i].Cells["Column3"].Value = Convert.ToDecimal(Amount).ToString("N2");
                                            #endregion
                                        }
                                    }
                                    #endregion
                                    #endregion
                                }
                            }
                        }
                        #endregion

                        #region 计件提成
                        object ItemName = this.dgv.Rows[i].Cells["Column5"].Value;
                        if (ItemName != null)
                        {
                            if (ItemName.ToString().Trim() == "/计件提成")
                            { PieceCommission += Convert.ToDecimal(this.dgv.Rows[i].Cells["Column3"].Value); }
                            else
                            { CurrentPerformance += Convert.ToDecimal(this.dgv.Rows[i].Cells["Column3"].Value); }
                        }
                        #endregion
                    }
                    //当前业绩
                    Sum = Convert.ToDecimal(CurrentPerformance);
                    // 计件提成
                    this.txtPieceCommission.Text = Convert.ToDecimal(PieceCommission).ToString("N2");
                }
                else
                {
                    this.txtCurrentPerformance.Text = "0.00";
                    this.txtPieceCommission.Text = "0.00";
                }
            }));
            #endregion
            return Sum;
        }
        /// <summary>
        /// 绑定业绩列表查询方法1（全部收款记录）
        /// </summary>
        /// <param name="IsQuery"></param>
        /// <returns></returns>
        public string BindSelect1(ref bool IsQuery)
        {
            StringBuilder str = new StringBuilder();
            if (!string.IsNullOrEmpty(Str_CustomerSource.Trim()) && Str_CustomerSourceTag != null)
            { str.Append(" and 客户来源='" + Str_CustomerSource.Trim() + "'"); }
            if (!string.IsNullOrEmpty(Str_PakName.Trim()) && Str_PakNameTag != null)
            { str.Append(" and 订单类别='" + Str_PakName.Trim() + "'"); }
            if (this.Str_ProjectTitle.Trim() != "选片二销")
            {
                if (!string.IsNullOrEmpty(this.Str_AmountRange1.Trim()))
                { str.Append(" and (应收金额>=" + this.Str_AmountRange1.Trim() + " and 应收金额<=" + this.Str_AmountRange2.Trim() + ")"); }
            }
            // 订单前期
            if (this.Str_ItemCategory.Trim() == "订单前期")
            {
                if (!string.IsNullOrEmpty(this.Str_ProjectTitle.Trim()))
                {
                    if (this.Str_ProjectTitle.Trim() == "实收")
                    { str.Append(" and 收款类别 <> '后期收款'"); }
                    if (this.Str_ProjectTitle.Trim() == "全款")
                    { str.Append(" and 应收金额 = 前期实收金额"); }
                }
                str.Append(" and 收款类别 <> '后期收款'");
            }
            // 订单后期
            if (this.Str_ItemCategory.Trim() == "订单后期")
            {
                if (!string.IsNullOrEmpty(this.Str_ProjectTitle.Trim()))
                {
                    if (!string.IsNullOrEmpty(this.Str_AmountRange1.Trim()))
                    {
                        if (this.Str_ProjectTitle.Trim() == "选片二销")
                        { str.Append(" and (收款金额>=" + this.Str_AmountRange1.Trim() + " and 收款金额<=" + this.Str_AmountRange2.Trim() + ")"); }
                    }
                    str.Append(" and 二销类别编号='" + this.Str_ProjectTitleTag.ToString().Trim() + "'");
                }
                str.Append(" and 收款类别='后期收款' and 收款类型=0");
            }
            // 其它消费
            if (this.Str_ItemCategory.Trim() == "其它消费")
            {
                if (!string.IsNullOrEmpty(this.Str_ProjectTitle.Trim()))
                { str.Append(" and 二销类别编号='" + this.Str_ProjectTitleTag.ToString().Trim() + "'"); }
                str.Append(" and 收款类型=1");
            }
            if (this.Str_ItemCategory.Trim() == "礼服租售")
            { str.Append(" and 收款类型 = '2' "); }
            // 其它
            //if (this.Str_ItemCategory.Trim() == "会员充值")
            //{ str.Append(" and id=-3"); }
            //if (this.Str_ItemCategory.Trim() == "服务卡充值")
            //{ str.Append(" and id=-3"); }
            //if (this.Str_ItemCategory.Trim() == "礼服租售")
            //{ str.Append(" and id=-3"); }
            //if (this.Str_ItemCategory.Trim() == "计件提成")
            //{ str.Append(" and id=-3"); }
            switch (this.Str_ItemCategory.Trim())
            {
                case "会员充值":
                case "服务卡充值":
                //case "礼服租售":
                case "计件提成":
                    IsQuery = false;
                    break;
                default:
                    IsQuery = true;
                    break;
            }
            return str.ToString();
        }
        /// <summary>
        /// 绑定业绩列表查询方法2
        /// </summary>
        /// <param name="IsQuery"></param>
        /// <returns></returns>
        public string BindSelect2(ref bool IsQuery)
        {
            if (!string.IsNullOrEmpty(this.Str_CustomerSource.Trim()) || (!string.IsNullOrEmpty(this.Str_PakName.Trim()) && this.Str_PakNameTag != null) || !string.IsNullOrEmpty(this.Str_ProcessStatus.Trim()) || (!string.IsNullOrEmpty(this.Str_ItemCategory.Trim()) && this.Str_ItemCategory.Trim() != "会员充值"))
            { IsQuery = false; }
            else
            { IsQuery = true; }
            StringBuilder str = new StringBuilder();
            if (!string.IsNullOrEmpty(this.Str_AmountRange1.Trim()))
            { str.Append(" and 充值金额 >= " + this.Str_AmountRange1.Trim() + " and 充值金额 <= " + this.Str_AmountRange2.Trim() + ""); }
            return str.ToString();

            //StringBuilder str = new StringBuilder();
            //if (!string.IsNullOrEmpty(this.Str_CustomerSource.Trim()))
            //{ str.Append(" and id = -3"); }
            //if (!string.IsNullOrEmpty(this.Str_PakName.Trim()) && this.Str_PakNameTag != null)
            //{ str.Append(" and  id = -3"); }
            //if (!string.IsNullOrEmpty(this.Str_AmountRange1.Trim()))
            //{ str.Append(" and 充值金额 >= " + this.Str_AmountRange1.Trim() + " and 充值金额 <= " + this.Str_AmountRange2.Trim() + ""); }
            //if (!string.IsNullOrEmpty(this.Str_ProcessStatus.Trim()))
            //{ str.Append(" and id = -3"); }
            ////  会员充值
            //if (!string.IsNullOrEmpty(this.Str_ItemCategory.Trim()))
            //{
            //    if (this.Str_ItemCategory.Trim() != "会员充值")
            //    { str.Append("and id = -3"); }
            //}
            //return str.ToString();
        }
        /// <summary>
        /// 绑定业绩列表查询方法3（服务卡）
        /// </summary>
        /// <param name="IsQuery"></param>
        /// <returns></returns>
        public string BindSelect3(ref bool IsQuery)
        {
            if (!string.IsNullOrEmpty(this.Str_CustomerSource.Trim()) || (!string.IsNullOrEmpty(this.Str_PakName.Trim()) && this.Str_PakNameTag != null) || !string.IsNullOrEmpty(this.Str_ProcessStatus.Trim()) || (!string.IsNullOrEmpty(this.Str_ItemCategory.Trim()) && this.Str_ItemCategory.Trim() != "服务卡充值"))
            { IsQuery = false; }
            else
            { IsQuery = true; }
            StringBuilder str = new StringBuilder();
            if (!string.IsNullOrEmpty(this.Str_AmountRange1.Trim()))
            { str.Append(" and 收款金额 >= " + this.Str_AmountRange1.Trim() + " and 收款金额 <= " + this.Str_AmountRange2.Trim() + ""); }
            return str.ToString();

            //StringBuilder str = new StringBuilder();
            //if (!string.IsNullOrEmpty(cmbCustomerSource.Text.Trim()))
            //{ str.Append(" and id=-3"); }
            //if (!string.IsNullOrEmpty(CtvPak_Name.Text.Trim()) && CtvPak_Name.Tag != null)
            //{ str.Append(" and id=-3"); }
            //if (!string.IsNullOrEmpty(txtAmountRange1.Text))
            //{ str.Append(" and 收款金额>=" + txtAmountRange1.Text.Trim() + " and 收款金额<=" + txtAmountRange2.Text.Trim() + ""); }
            //if (!string.IsNullOrEmpty(cmbProcessStatus.Text.Trim()))
            //{ str.Append(" and id=-3"); }
            //// 会员充值
            //if (!string.IsNullOrEmpty(cmbItemCategory.Text.Trim()))
            //{
            //    if (cmbItemCategory.Text.Trim() != "服务卡充值")
            //    { str.Append("and id=-3"); }
            //}
            //return str.ToString();
        }
        /// <summary>
        /// 绑定业绩列表查询方法4（计件）
        /// </summary>
        /// <param name="IsQuery"></param>
        /// <returns></returns>
        public string BindSelect4(ref bool IsQuery)
        {
            if (!string.IsNullOrEmpty(this.Str_CustomerSource.Trim()) || !string.IsNullOrEmpty(this.Str_ProcessStatus.Trim()) || (!string.IsNullOrEmpty(this.Str_ItemCategory.Trim()) && this.Str_ItemCategory.Trim() != "计件提成"))
            { IsQuery = false; }
            else
            { IsQuery = true; }
            StringBuilder str = new StringBuilder();
            if (!string.IsNullOrEmpty(this.Str_PakName.Trim()) && this.Str_PakNameTag != null)
            { str.Append(" and Ord_SeriesName = '" + this.Str_PakName.Trim() + "'"); }
            if (!string.IsNullOrEmpty(this.Str_AmountRange1.Trim()))
            { str.Append(" and 总价格 >= " + this.Str_AmountRange1.Trim() + " and 总价格 <= " + this.Str_AmountRange2.Trim() + ""); }
            //  计件
            if (!string.IsNullOrEmpty(this.Str_ItemCategory.Trim()))
            {
                if (this.Str_ItemCategory.Trim() == "计件提成")
                {
                    if (!string.IsNullOrEmpty(this.Str_ProjectTitle.Trim()))
                    { str.Append(" and Pcr_CompletionContents = '" + this.Str_ProjectTitleTag + "'"); }
                }
            }
            return str.ToString();

            //StringBuilder str = new StringBuilder();
            //if (!string.IsNullOrEmpty(cmbCustomerSource.Text.Trim()))
            //{ str.Append(" and id=-3"); }
            //if (!string.IsNullOrEmpty(CtvPak_Name.Text.Trim()) && CtvPak_Name.Tag != null)
            //{ str.Append(" and Ord_SeriesName='" + CtvPak_Name.Text.Trim() + "'"); }
            //if (!string.IsNullOrEmpty(txtAmountRange1.Text))
            //{ str.Append(" and 总价格>=" + txtAmountRange1.Text.Trim() + " and 总价格<=" + txtAmountRange2.Text.Trim() + ""); }
            //if (!string.IsNullOrEmpty(cmbProcessStatus.Text.Trim()))
            //{ str.Append(" and id=-3"); }
            ////  计件
            //if (!string.IsNullOrEmpty(cmbItemCategory.Text.Trim()))
            //{
            //    if (cmbItemCategory.Text.Trim() == "计件提成")
            //    {
            //        if (!string.IsNullOrEmpty(cmbProjectTitle.Text.Trim()))
            //        { str.Append(" and Pcr_CompletionContents='" + cmbProjectTitle.Tag + "'"); }
            //    }
            //    else
            //    { str.Append("and id=-3"); }
            //}
            //return str.ToString();
        }
        /// <summary>
        /// 绑定业绩列表查询方法5（拍照）
        /// </summary>
        /// <returns></returns>
        public string BindSelect5()
        {
            StringBuilder str = new StringBuilder();
            if (!string.IsNullOrEmpty(this.Str_CustomerSource.Trim()) && this.Str_CustomerSourceTag != null)
            { str.Append(" and 客户来源 = '" + this.Str_CustomerSource.Trim() + "'"); }
            if (!string.IsNullOrEmpty(this.Str_PakName.Trim()) && this.Str_PakNameTag != null)
            { str.Append(" and 订单类别 = '" + this.Str_PakName.Trim() + "'"); }
            if (!string.IsNullOrEmpty(this.Str_AmountRange1.Trim()))
            { str.Append(" and 应收金额 >= " + this.Str_AmountRange1.Trim() + " and 应收金额 <= " + this.Str_AmountRange2.Trim() + ""); }
            return str.ToString();
        }
        /// <summary>
        /// 统计业绩
        /// </summary>
        public void TotalPerformance()
        {
            DataTable dt = new DataTable();
            this.dgvAll.Rows.Clear();
            string StrWhere = "";
            if (this.cmbEmployeeName.StrGetName.ToString() == "Department")
            { StrWhere = " And User_Department = '" + this.cmbEmployeeName.Tag.ToString().Trim() + "'"; }
            else if (this.cmbEmployeeName.StrGetName.ToString() == "StoreName")
            { StrWhere = " And User_DividedShop = '" + this.cmbEmployeeName.Tag.ToString().Trim() + "'"; }
            string StrTimeStart = this.txtTimeStart.DateValue.ToString().Trim();
            string StrTimeEnd = this.txtTimeEnd.DateValue.ToString().Trim();

            LYFZ.ComponentLibrary.FrmLoadHandling.LoadDoWorkMethod(delegate(object obj, BackgroundWorker backgroundWorker)
            {
                dt = orbll.GetView_Custom("tb_ErpUser", StrWhere: "User_Status='在职'" + StrWhere, ShowColumnName: "User_Name,User_EmployeeID").Tables[0];
                for (int t = 0; t < dt.Rows.Count; t++)
                {
                    DataGridViewRow dgvr = new DataGridViewRow();
                    DataGridViewCell cell = null;

                    //员工编号
                    cell = new DataGridViewTextBoxCell();
                    cell.Value = dt.Rows[t]["User_EmployeeID"].ToString().Trim();
                    dgvr.Cells.Add(cell);

                    //员工姓名
                    cell = new DataGridViewTextBoxCell();
                    cell.Value = dt.Rows[t]["User_Name"].ToString().Trim();
                    dgvr.Cells.Add(cell);

                    //当前业绩
                    cell = new DataGridViewTextBoxCell();
                    cell.Value = Convert.ToDecimal(BindPerformance(StrTimeStart, StrTimeEnd, dt.Rows[t]["User_EmployeeID"].ToString().Trim(), backgroundWorker)).ToString();
                    dgvr.Cells.Add(cell);

                    this.Invoke(new UpdateControl(delegate()
                    {
                        this.dgvAll.Rows.Add(dgvr);
                    }));
                }
            });
        }
        /// <summary>
        /// 获取业绩个数
        /// </summary>
        /// <param name="Ord_OrdersPersonID"></param>
        /// <param name="StartTime"></param>
        /// <param name="EndTime"></param>
        /// <returns></returns>
        public string GetNumberOfResults(string Ord_OrdersPersonID, string StartTime, string EndTime)
        {
            //DataTable dt = new DataTable();
            //int OrderCount = 0;
            //int PhotographyCount = 0;
            //int PhotographyAssistantCount = 0;
            //int MakeUpCount = 0;
            //int MakeUpAssistantCount = 0;
            //int GuideCount = 0;
            //int FirstRepairCount = 0;
            //int RefinementCount = 0;
            //int DesignCount = 0;

            Hashtable htDataOrder = new Hashtable();
            Hashtable htDataPhotography = new Hashtable();
            Hashtable htDataPhotographyAssistant = new Hashtable();
            Hashtable htDataMakeUp = new Hashtable();
            Hashtable htDataMakeUpAssistant = new Hashtable();
            Hashtable htDataGuide = new Hashtable();
            Hashtable htDataGuideAssistant = new Hashtable();
            Hashtable htDataFirstRepair = new Hashtable();
            Hashtable htDataRefinement = new Hashtable();
            Hashtable htDataDesign = new Hashtable();
            #region 获取订单数
            //dt = orbll.GetView_Custom("Vw_Customer_PaymentOrders", StrWhere: "Ord_OrdersPersonID like '%" + Ord_OrdersPersonID + "%' and Ord_Class=1 and Ord_CreateDatetime>='" + StartTime + "' and Ord_CreateDatetime<='" + EndTime + "' ", ShowColumnName: "ID").Tables[0];
            //if (dt.Rows.Count > 0)
            //{ OrderCount = dt.Rows.Count; }   
            this.Invoke(new UpdateControl(delegate()
            {
                for (int i = 0; i < this.dgv.Rows.Count; i++)
                {
                    if (this.dgv.Rows[i].Cells["Column18"].Value != null && !string.IsNullOrEmpty(this.dgv.Rows[i].Cells["Column18"].Value.ToString().Trim()))
                    {
                        string StrKeys = this.dgv.Rows[i].Cells["Column1"].Value.ToString().Trim() + this.dgv.Rows[i].Cells["Column17"].Value.ToString().Trim();
                        switch (this.dgv.Rows[i].Cells["Column17"].Value.ToString().Trim())
                        {
                            case "主接单人":
                            case "副接单人":
                            case "门市选片二销":
                                if (!htDataOrder.ContainsKey(StrKeys))
                            { htDataOrder[StrKeys] = 1; }
                                break;
                            case "主摄影师":
                            case "主摄影选片二销":
                                if (!htDataPhotography.ContainsKey(StrKeys))
                                { htDataPhotography[StrKeys] = 1; }
                                break;
                            case "摄影助理":
                            case "摄影助理选片二销":
                                if (!htDataPhotographyAssistant.ContainsKey(StrKeys))
                                { htDataPhotographyAssistant[StrKeys] = 1; }
                                break;
                            case "主化妆师":
                            case "主化妆选片二销":
                                if (!htDataMakeUp.ContainsKey(StrKeys))
                                { htDataMakeUp[StrKeys] = 1; }
                                break;
                            case "化妆助理":
                            case "化妆助理选片二销":
                                if (!htDataMakeUpAssistant.ContainsKey(StrKeys))
                                { htDataMakeUpAssistant[StrKeys] = 1; }
                                break;
                            case "引导师":
                            case "引导选片二销":
                                if (!htDataGuide.ContainsKey(StrKeys))
                                { htDataGuide[StrKeys] = 1; }
                                break;
                            case "引导助理":
                            case "引导助理选片二销":
                                if (!htDataGuideAssistant.ContainsKey(StrKeys))
                                { htDataGuideAssistant[StrKeys] = 1; }
                                break;
                            case "初修师":
                            case "初修师选片二销":
                                if (!htDataFirstRepair.ContainsKey(StrKeys))
                                { htDataFirstRepair[StrKeys] = 1; }
                                break;
                            case "精修师":
                            case "精修师选片二销":
                                if (!htDataRefinement.ContainsKey(StrKeys))
                                { htDataRefinement[StrKeys] = 1; }
                                break;
                            case "设计师":
                            case "设计师选片二销":
                                if (!htDataDesign.ContainsKey(StrKeys))
                                { htDataDesign[StrKeys] = 1; }
                                break;
                        }
                    }
                }
            }));
            #endregion

            #region 摄影师个数
            //dt = new DataTable();
            //dt = orbll.GetView_Custom("Vw_OrdersWagePhotography", StrWhere: "摄影师ID like '%" + Ord_OrdersPersonID + "%' and Ord_Class=1 and 拍摄状态=1 and 拍摄时间>='" + StartTime + "' and 拍摄时间<='" + EndTime + "' ", ShowColumnName: "ID").Tables[0];
            //if (dt.Rows.Count > 0)
            //{
            //    PhotographyCount = dt.Rows.Count;
            //}
            #endregion

            #region 摄影助理个数
            //dt = new DataTable();
            //dt = orbll.GetView_Custom("Vw_OrdersWagePhotography", StrWhere: "摄影助理ID like '%" + Ord_OrdersPersonID + "%' and Ord_Class=1 and 拍摄状态=1 and 拍摄时间>='" + StartTime + "' and 拍摄时间<='" + EndTime + "' ", ShowColumnName: "ID").Tables[0];
            //if (dt.Rows.Count > 0)
            //{ PhotographyAssistantCount = dt.Rows.Count; }
            #endregion

            #region 化妆师个数
            //dt = new DataTable();
            //dt = orbll.GetView_Custom("Vw_OrdersWagePhotography", StrWhere: "化妆师ID like '%" + Ord_OrdersPersonID + "%' and Ord_Class=1 and 拍摄状态=1 and 拍摄时间>='" + StartTime + "' and 拍摄时间<='" + EndTime + "' ", ShowColumnName: "ID").Tables[0];
            //if (dt.Rows.Count > 0)
            //{ MakeUpCount = dt.Rows.Count; }
            #endregion

            #region 化妆助理个数
            //dt = new DataTable();
            //dt = orbll.GetView_Custom("Vw_OrdersWagePhotography", StrWhere: "化妆助理ID like '%" + Ord_OrdersPersonID + "%' and Ord_Class=1 and 拍摄状态=1 and 拍摄时间>='" + StartTime + "' and 拍摄时间<='" + EndTime + "' ", ShowColumnName: "ID").Tables[0];
            //if (dt.Rows.Count > 0)
            //{ MakeUpAssistantCount = dt.Rows.Count; }
            #endregion

            #region 引导师个数
            //dt = new DataTable();
            //dt = orbll.GetView_Custom("Vw_OrdersWagePhotography", StrWhere: "引导师ID like '%" + Ord_OrdersPersonID + "%' and Ord_Class=1 and 拍摄状态=1 and 拍摄时间>='" + StartTime + "' and 拍摄时间<='" + EndTime + "' ", ShowColumnName: "ID").Tables[0];
            //if (dt.Rows.Count > 0)
            //{ GuideCount = dt.Rows.Count; }
            #endregion

            #region 初修师个数
            //dt = new DataTable();
            //dt = orbll.GetView_Custom("Vw_OrdersWageDigital", StrWhere: "初修师ID like '%" + Ord_OrdersPersonID + "%' and Ord_Class=1 and 初修状态=2 and 初修时间>='" + StartTime + "' and 初修时间<='" + EndTime + "' ", ShowColumnName: "ID").Tables[0];
            //if (dt.Rows.Count > 0)
            //{ FirstRepairCount = dt.Rows.Count; }
            #endregion

            #region 精修师个数
            //dt = new DataTable();
            //dt = orbll.GetView_Custom("Vw_OrdersWageDigital", StrWhere: "精修师ID like '%" + Ord_OrdersPersonID + "%' and Ord_Class=1 and 精修状态=2 and 精修时间>='" + StartTime + "' and 精修时间<='" + EndTime + "' ", ShowColumnName: "ID").Tables[0];
            //if (dt.Rows.Count > 0)
            //{ RefinementCount = dt.Rows.Count; }
            #endregion

            #region 设计师个数
            //dt = new DataTable();
            //dt = orbll.GetView_Custom("Vw_OrdersWageDigital", StrWhere: "设计师ID like '%" + Ord_OrdersPersonID + "%' and Ord_Class=1 and 设计状态=2 and 设计时间>='" + StartTime + "' and 设计时间<='" + EndTime + "' ", ShowColumnName: "ID").Tables[0];
            //if (dt.Rows.Count > 0)
            //{ RefinementCount = dt.Rows.Count; }
            #endregion

            string StrCountSum = "订单数：" + htDataOrder.Count + "；摄影景点数：" + htDataPhotography.Count + "；摄影助理景点数：" + htDataPhotographyAssistant.Count + "；化妆数：" + htDataMakeUp.Count + "；化妆助理数：" + htDataMakeUpAssistant.Count;
            StrCountSum += "；引导数：" + htDataGuide.Count + "；引导助理数：" + htDataGuideAssistant.Count + "；初修景点数：" + htDataFirstRepair.Count + "；精修景点数：" + htDataRefinement.Count + "；设计景点数：" + htDataDesign.Count;
            return StrCountSum;
        }
        string Str_ItemCategory = "";
        string Str_ProcessStatus = "";
        string Str_CustomerSource = "";
        object Str_CustomerSourceTag = "";
        string Str_ProjectTitle = "";
        object Str_ProjectTitleTag = "";
        string Str_PakName = "";
        object Str_PakNameTag = "";
        string Str_AmountRange1 = "";
        string Str_AmountRange2 = "";
        string Str_Scores1 = "";
        string Str_Scores2 = "";
        //======================================================================操作事件==================================
        /// <summary>
        /// 选择人员姓名查询人员工资基本信息
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected override void cmbEmployeeName_ComboBoxTree_NodeMouseClick(object sender, TreeNodeMouseClickEventArgs e)
        {
            if (this.cmbEmployeeName.Tag != null)
            {
                if (this.cmbEmployeeName.StrGetName.Trim() == "User")
                {
                    this.dgvAll.Visible = false;
                    this.dgv.Visible = true;
                    DataTable dt = wsbll.GetList("Ws_StaffCode='" + this.cmbEmployeeName.Tag.ToString().Trim() + "'").Tables[0];
                    if (dt.Rows.Count > 0)
                    {
                        this.txtBasicwage.Text = dt.Rows[0]["Ws_BasicWage"].ToString();
                        this.txtPay_Remark.Text = dt.Rows[0]["Ws_Remark"].ToString();
                    }
                    else
                    {
                        this.txtBasicwage.Text = "0";
                        this.txtPay_Remark.Text = "";
                    }
                }
                else if (string.IsNullOrEmpty(this.cmbEmployeeName.StrGetName.Trim()) || this.cmbEmployeeName.StrGetName.Trim() == "StoreName" || this.cmbEmployeeName.StrGetName.Trim() == "Department")
                {
                    this.dgvAll.Visible = true;
                    this.dgv.Visible = false;
                    this.dgv.Rows.Clear();
                    this.txtBasicwage.Text = "0";
                    this.txtPay_Remark.Text = "";
                    this.txtCurrentPerformance.Text = "0";
                    this.cmbCommissionScheme.Text = "";
                    this.txtPieceCommission.Text = "0";
                    this.txtCommissionWages.Text = "0";
                }
            }
            else
            { MessageBoxCustom.Show("请选择人员！"); }
        }
        /// <summary>
        /// 对象转为时间
        /// </summary>
        /// <param name="timeObj"></param>
        /// <returns></returns>
        DateTime GetObjectToDateTime(object timeObj)
        {
            try
            {
                if (timeObj != null)
                {
                    return Convert.ToDateTime(timeObj.ToString());
                }
                else
                {
                    return DateTime.MinValue;
                }
            }
            catch { return DateTime.MinValue; }
        }
        /// <summary>
        /// 选择项目类别
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected override void cmbItemCategory_ComboBoxTree_NodeMouseClick(object sender, TreeNodeMouseClickEventArgs e)
        {
            //清空项目名称
            this.cmbProjectTitle.TreeView.Nodes.Clear();
            this.cmbProjectTitle.Text = "";
            this.cmbCommissionScheme.SetTextAndTag_ValueNull();
            this.cmbCommissionScheme.Enabled = true;
            this.cmbProjectTitle.Enabled = true;
            if (this.cmbItemCategory.Text.Trim() == "订单前期")
            { LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.BindComboxTreeView(this.cmbProjectTitle, StrBindData: "实收,全款", IsFirstNodeNull: true); }
            else if (this.cmbItemCategory.Text.Trim() == "服务前期")
            { LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.BindComboxTreeView(this.cmbProjectTitle, StrBindData: "摄影前期,化妆前期,引导前期,初修前期,精修前期,设计前期", IsFirstNodeNull: true); }
            else if (this.cmbItemCategory.Text.Trim() == "订单后期" || this.cmbItemCategory.Text.Trim() == "其它消费")
            { LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.BindComboBoxTreeView_SystemCategory("BEBACDAJDFDDEACGJ", this.cmbProjectTitle, IsFirstNodeNull: true, StrWhere: "Sc_ClassCode!='BEBCADBFBCDFBGJHC' and Sc_ClassCode!='BEBCADBFBDDEGGABF' and Sc_ClassCode!='BEBCBFBICGDHCGBEJ' and Sc_ClassCode!='BEBCABBAAICBDHDHI' and Sc_ClassCode!='BEBCABBAAICJAAGDG' and Sc_ClassCode!='BEBCBFBICFCECBHFF'"); }
            else if (this.cmbItemCategory.Text.Trim() == "服务后期")
            { LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.BindComboxTreeView(this.cmbProjectTitle, StrBindData: "门市选片二销,摄影选片二销,化妆选片二销,引导选片二销,初修选片二销,设计选片二销,精修选片二销", IsFirstNodeNull: true); }
            else if (this.cmbItemCategory.Text.Trim() == "会员充值" || this.cmbItemCategory.Text.Trim() == "服务卡充值")
            { this.cmbProjectTitle.Enabled = false; }
            else if (this.cmbItemCategory.Text.Trim() == "礼服租售")
            { LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.BindComboxTreeView(this.cmbProjectTitle, StrBindData: "礼服出租,礼服出售", IsFirstNodeNull: true); }
            else if (this.cmbItemCategory.Text.Trim() == "计件提成")
            {
                LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.BindComboBoxTreeView_SystemCategory("BEBBBABBEBAIHGDCB", this.cmbProjectTitle, IsFirstNodeNull: true, tbl: tblSystemCategory);
                this.cmbCommissionScheme.Enabled = false;
                this.cmbCommissionScheme.Text = "计件提成";
            }
        }
        /// <summary>
        /// 查询
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected override void btnSelect_Click(object sender, EventArgs e)
        {
            if (string.IsNullOrEmpty(this.txtTimeStart.DateValue))
            { MessageBoxCustom.Show("开始时间不能为空！"); return; }
            if (string.IsNullOrEmpty(this.txtTimeEnd.DateValue))
            { MessageBoxCustom.Show("结束时间不能为空！"); return; }
            if (this.cmbItemCategory.Text.Trim() == "订单后期" && this.cmbProjectTitle.Text.Trim() == "选片二销")
            { this.lblAmountDisplay.Text = "选片金额:"; }
            else
            { this.lblAmountDisplay.Text = "套系金额:"; }
            if (!string.IsNullOrEmpty(this.txtAmountRange1.Text))
            {
                if (string.IsNullOrEmpty(this.txtAmountRange2.Text))
                { MessageBoxCustom.Show("结束金额范围不能为空！"); return; }
            }
            if (!string.IsNullOrEmpty(this.txtAmountRange2.Text))
            {
                if (string.IsNullOrEmpty(this.txtAmountRange1.Text))
                { MessageBoxCustom.Show("开始金额范围不能为空！"); return; }
            }
            if (!string.IsNullOrEmpty(this.txtScores1.Text))
            {
                if (string.IsNullOrEmpty(this.txtScores2.Text))
                { MessageBoxCustom.Show("满意分值范围不能为空！"); return; }
            }
            if (!string.IsNullOrEmpty(this.txtScores2.Text))
            {
                if (string.IsNullOrEmpty(this.txtScores1.Text))
                { MessageBoxCustom.Show("满意分值范围不能为空！"); return; }
            }
            this.Str_ItemCategory = this.cmbItemCategory.Text.Trim();
            this.Str_ProcessStatus = this.cmbProcessStatus.Text.Trim();
            this.Str_CustomerSource = this.cmbCustomerSource.Text.Trim();
            this.Str_CustomerSourceTag = this.cmbCustomerSource.Tag;
            this.Str_ProjectTitle = this.cmbProjectTitle.Text.Trim();
            this.Str_ProjectTitleTag = this.cmbProjectTitle.Tag;
            this.Str_PakName = this.CtvPak_Name.Text.Trim();
            this.Str_PakNameTag = this.CtvPak_Name.Tag;
            this.Str_AmountRange1 = this.txtAmountRange1.Text.Trim();
            this.Str_AmountRange2 = this.txtAmountRange2.Text.Trim();
            this.Str_Scores1 = this.txtScores1.Text.Trim();
            this.Str_Scores2 = this.txtScores2.Text.Trim();
            if (this.cmbEmployeeName.Tag == null)
            { this.cmbEmployeeName.TagFindText(""); }
            string StrEmployeeNameTag = this.cmbEmployeeName.Tag.ToString().Trim();
            string StrDateStart = this.txtTimeStart.DateValue.ToString().Trim();
            string StrDateEnd = this.txtTimeEnd.DateValue.ToString().Trim();
            if (this.cmbEmployeeName.Tag != null)
            {
                if (this.cmbEmployeeName.StrGetName.Trim() == "User")
                {
                    this.txtCommissionWages.Text = "0";
                    LYFZ.ComponentLibrary.FrmLoadHandling.LoadDoWorkMethod(delegate(object obj, BackgroundWorker backgroundWorker)
                    {
                        string strCurrentPerformance = Convert.ToDecimal(this.BindPerformance(StrDateStart, StrDateEnd, StrEmployeeNameTag, backgroundWorker)).ToString("N2");
                        string StrCountSum = this.GetNumberOfResults(StrEmployeeNameTag, StrDateStart, StrDateEnd);
                        this.Invoke(new UpdateControl(delegate()
                        {
                            //获取员工业绩列表
                            this.txtCurrentPerformance.Text = strCurrentPerformance;
                            this.lblCountSum.Text = StrCountSum;
                        }));
                    });
                }
                else
                {
                    this.TotalPerformance();
                    this.dgvAll.Visible = true;
                }
            }
            //以下为滕工加，2016-01-28
            this.cmbCommissionScheme_ComboBoxTree_NodeMouseClick(this, null);
        }
        /// <summary>
        /// 输入框设置
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected override void txtAmountRange2_KeyPress(object sender, KeyPressEventArgs e)
        {
            if (!Char.IsNumber(e.KeyChar) && !Char.IsControl(e.KeyChar))
            { e.Handled = true; }
        }
        /// <summary>
        /// 输入框设置
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected override void txtAmountRange1_KeyPress(object sender, KeyPressEventArgs e)
        {
            if (!Char.IsNumber(e.KeyChar) && !Char.IsControl(e.KeyChar))
            { e.Handled = true; }
        }
        /// <summary>
        /// 关闭
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected override void btnClose_Click(object sender, EventArgs e)
        {
            this.Close();
        }
        /// <summary>
        /// 提成工资事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected override void cmbCommissionScheme_ComboBoxTree_NodeMouseClick(object sender, TreeNodeMouseClickEventArgs e)
        {
            if (!string.IsNullOrEmpty(this.cmbCommissionScheme.Text.Trim()) && this.cmbCommissionScheme.Tag != null)
            {
                if (this.cmbEmployeeName.Text.Trim() == "全部" || this.cmbEmployeeName.StrGetName.ToString() == "Department" || string.IsNullOrEmpty(this.cmbEmployeeName.Text.Trim()))
                {
                    MessageBoxCustom.Show("请选择员工！");
                    this.cmbCommissionScheme.Text = "";
                    return;
                }
                DataTable dt = wcsbll.GetList("Wcs_TypeCode='" + this.cmbCommissionScheme.Tag.ToString() + "'").Tables[0];
                if (dt.Rows.Count == 0)
                {
                    MessageBoxCustom.Show("请在工资设置，设置规则！");
                    this.cmbCommissionScheme.Text = "";
                    this.txtCommissionWages.Text = "0";
                    return;
                }
                else
                { this.txtCommissionWages.Text = wcsbll.GetCommissionSpecifications(this.cmbCommissionScheme.Tag.ToString(), Convert.ToDecimal(this.txtCurrentPerformance.Text)).ToString("N2"); }
            }
            else
            { this.txtCommissionWages.Text = "0"; }
        }
        /// <summary>
        /// 排序
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected override void dgvAll_SortCompare(object sender, DataGridViewSortCompareEventArgs e)
        {
            if (e.Column.Name == "员工姓名" || e.Column.Name == "当前业绩")
            { e.SortResult = (Convert.ToDouble(e.CellValue1) - Convert.ToDouble(e.CellValue2) > 0) ? 1 : (Convert.ToDouble(e.CellValue1) - Convert.ToDouble(e.CellValue2) < 0) ? -1 : 0; }
            //否则，按字符串比较
            else
            { e.SortResult = System.String.Compare(Convert.ToString(e.CellValue1), Convert.ToString(e.CellValue2)); }
            e.Handled = true;//不能省掉，不然没效果
        }
        /// <summary>
        /// 保存记录
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected override void btnSave_Click(object sender, EventArgs e)
        {
            if (string.IsNullOrEmpty(txtTimeStart.DateValue))
            { MessageBoxCustom.Show("开始时间不能为空！"); return; }
            if (string.IsNullOrEmpty(txtTimeEnd.DateValue))
            { MessageBoxCustom.Show("结束时间不能为空！"); return; }
            if (cmbEmployeeName.Text.Trim() == "全部" || cmbEmployeeName.StrGetName.ToString() == "Department" || string.IsNullOrEmpty(cmbEmployeeName.Text.Trim()))
            { MessageBoxCustom.Show("请选择员工！"); return; }
            if (string.IsNullOrEmpty(cmbCommissionScheme.Text.Trim()))
            { MessageBoxCustom.Show("请选择提成方案！"); return; }

            if (cmbCommissionScheme.Text.Trim() != "计件提成")
            {
                DataTable dt = wcsbll.GetList("Wcs_TypeCode='" + cmbCommissionScheme.Tag.ToString() + "'").Tables[0];
                if (dt.Rows.Count == 0)
                {
                    MessageBoxCustom.Show("请在工资设置，设置规则！");
                    cmbCommissionScheme.SetTextAndTag_ValueNull();
                    txtCommissionWages.Text = "0";
                    return;
                }
            }

            #region 保存工资提成记录
            LYFZ.Model.Model_ErpWageCommissionRecords WageCommissionRecordsModel = new Model.Model_ErpWageCommissionRecords();
            WageCommissionRecordsModel.Wcr_DividedShop = LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.GetLocalCompanyInfoID();
            WageCommissionRecordsModel.Wcr_EmployeeID = cmbEmployeeName.Tag.ToString();
            if (cmbCommissionScheme.Text.Trim() == "计件提成")
            { WageCommissionRecordsModel.Wcr_CommissionScheme = cmbCommissionScheme.Text.Trim(); }
            else
            { WageCommissionRecordsModel.Wcr_CommissionScheme = cmbCommissionScheme.Tag.ToString(); }
            WageCommissionRecordsModel.Wcr_CurrentPerformance = Convert.ToDecimal(txtCurrentPerformance.Text);
            WageCommissionRecordsModel.Wcr_PieceCommission = Convert.ToDecimal(txtPieceCommission.Text);
            WageCommissionRecordsModel.Wcr_CommissionWages = Convert.ToDecimal(txtCommissionWages.Text);
            WageCommissionRecordsModel.Wcr_PerformanceTimeStart = Convert.ToDateTime(txtTimeStart.Text);
            WageCommissionRecordsModel.Wcr_PerformanceTimeEnd = Convert.ToDateTime(txtTimeEnd.Text);
            WageCommissionRecordsModel.Wcr_CreateDateTime = LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.GetServerDateTime();
            WageCommissionRecordsModel.Wcr_CreateName = LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.LoginUserModel.User_EmployeeID;
            if (wcrbll.Add(WageCommissionRecordsModel))
            {
                MessageBoxCustom.Show("保存成功！");
                cmbCommissionScheme.SetTextAndTag_ValueNull();
                txtCommissionWages.Text = "0";
            }
            #endregion
        }
        /// <summary>
        /// 查看记录
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected override void btnSearchRecord_Click(object sender, EventArgs e)
        {
            if (string.IsNullOrEmpty(cmbEmployeeName.Text.Trim()))
            { MessageBoxCustom.Show("员工姓名不能为空！请选择！"); return; }
            LYFZ.Software.MainBusiness.FinancialManagement.Payroll.FrmSearchRecord frm = new Payroll.FrmSearchRecord();
            frm.N_NameText = cmbEmployeeName.Text.Trim();
            if (cmbEmployeeName.Text.Trim() != "全部")
            {
                frm.N_NameTag = cmbEmployeeName.Tag.ToString();
                frm.N_Name = cmbEmployeeName.Name;
            }
            frm.ShowDialog();
        }
        /// <summary>
        /// 添加行事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void dgv_RowsAdded(object sender, DataGridViewRowsAddedEventArgs e)
        {
            if (this.dgv.Rows[e.RowIndex].Cells["Column4"].Value != null && !string.IsNullOrEmpty(this.dgv.Rows[e.RowIndex].Cells["Column4"].Value.ToString().Trim()))
            { this.dgv.Rows[e.RowIndex].Cells["Column4"].Value = LYFZ.Command.Command_Validate.DateTimeToString(this.dgv.Rows[e.RowIndex].Cells["Column4"].Value, "yyyy-MM-dd HH:mm"); }
            if (this.dgv.Rows[e.RowIndex].Cells["Column11"].Value != null && !string.IsNullOrEmpty(this.dgv.Rows[e.RowIndex].Cells["Column11"].Value.ToString().Trim()))
            { this.dgv.Rows[e.RowIndex].Cells["Column11"].Value = LYFZ.Command.Command_Validate.DateTimeToString(this.dgv.Rows[e.RowIndex].Cells["Column11"].Value, "yyyy-MM-dd HH:mm"); }
            if (this.dgv.Rows[e.RowIndex].Cells["Column3"].Value != null && !string.IsNullOrEmpty(this.dgv.Rows[e.RowIndex].Cells["Column3"].Value.ToString().Trim()))
            { this.dgv.Rows[e.RowIndex].Cells["Column3"].Value = this.dgv.Rows[e.RowIndex].Cells["Column3"].Value.ToString(); }
        }
        /// <summary>
        /// 导出
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected override void btnExPort_Click(object sender, EventArgs e)
        {
            if (this.dgv.Visible)
            { this.dgv.DataToExcelPayroll(this.cmbEmployeeName.Text.Trim()); }
            else
            { this.dgvAll.ExportDataTable(); }
        }
        /// <summary>
        /// 开始时间改变
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void txtTimeStart_Leave(object sender, EventArgs e)
        {
            if (!string.IsNullOrEmpty(this.txtTimeStart.DateValue.Trim()))
            { this.txtTimeEnd.DateValue = Convert.ToDateTime(this.txtTimeStart.DateValue).AddMonths(1).AddSeconds(-1).ToString("yyyy-MM-dd"); }
        }
        /// <summary>
        /// 窗体大小发生改变事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void FrmPayroll_Resize(object sender, EventArgs e)
        {
            if (!this.IsFirstRun)
            {
                switch (this.panelSaveed.Location.Y)
                {
                    case 0: this.flowLayoutPanel1.Height = 29; break;
                    case 29: this.flowLayoutPanel1.Height = 59; break;
                    case 58: this.flowLayoutPanel1.Height = 89; break;
                    case 87: this.flowLayoutPanel1.Height = 119; break;
                    case 116: this.flowLayoutPanel1.Height = 149; break;
                }
            }
        }
    }
}