lyfz_repos/铂金版源码/LYFZ.Software.MainBusiness/CustomerSatisfactionRecord/FrmCustomerSatisfactionRecord.cs

using LYFZ.ComponentLibrary;
using LYFZ.Software.MainBusiness.DoorCityProcess;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace LYFZ.Software.MainBusiness.CustomerSatisfactionRecord
{
    public partial class FrmCustomerSatisfactionRecord : LYFZ.Software.UI.CustomerSatisfactionRecord.FrmCustomerSatisfactionRecord
    {
        private delegate void UpdateControl();
        List<LYFZ.Software.MainBusiness.EnumPermissions.BusinessType> Versions = LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.GetBusinessTypeList();
        LYFZ.BLL.BLL_ErpSatisfactionSurvey sfsbll = new BLL.BLL_ErpSatisfactionSurvey();
        public FrmCustomerSatisfactionRecord()
        {
            this.ucPagerEx1.EventPaging += ucPagerEx1_EventPaging;
            this.ucPagerEx2.EventPaging += ucPagerEx2_EventPaging;
            this.ucPagerEx3.EventPaging += ucPagerEx3_EventPaging;
            this.ucPagerEx4.EventPaging += ucPagerEx4_EventPaging;
            this.ucPagerEx5.EventPaging += ucPagerEx5_EventPaging;
            this.ucPagerEx6.EventPaging += ucPagerEx6_EventPaging;
            this.ucPagerEx7.EventPaging += ucPagerEx7_EventPaging;
            this.ucPagerEx8.EventPaging += ucPagerEx8_EventPaging;
            this.btnExport.Click += btnExport_Click;
            this.IsOthersurveys();

            this.dgv1.MouseDoubleClick += dgv1_MouseDoubleClick;
            this.dgv2.MouseDoubleClick += dgv2_MouseDoubleClick;
            this.dgv3.MouseDoubleClick += dgv3_MouseDoubleClick;
            this.dgv4.MouseDoubleClick += dgv4_MouseDoubleClick;
            this.dgv5.MouseDoubleClick += dgv5_MouseDoubleClick;
            this.dgv6.MouseDoubleClick += dgv6_MouseDoubleClick;
            this.dgv7.MouseDoubleClick += dgv7_MouseDoubleClick;
            this.dgv8.MouseDoubleClick += dgv8_MouseDoubleClick;
        }

        /// <summary>
        /// 窗体加载事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected override void FrmCustomerSatisfactionRecord_Shown(object sender, EventArgs e)
        {
            try
            {
                this.txtTimeStart.Text = SDateTime.Now.ToString("yyyy-MM") + "-01";
                this.txtTimeEnd.Text = Convert.ToDateTime(SDateTime.Now.ToString("yyyy-MM") + "-01").AddMonths(1).AddSeconds(-1).ToString();
                //近期订单
                this.BindOrderForm();
                // 权限设置
                this.btnDc.Enabled = LYFZ.BLL.BLL_ErpUser.GetRights(LYFZ.BLL.BLL_ErpUser.CurrentUserRights.CustomerSatisfactionRecordCompetence, CustomAttributes.OperatingAuthority.SatisfactionSurvey);
                this.btnDc.Enabled = LYFZ.BLL.BLL_ErpUser.GetRights(LYFZ.BLL.BLL_ErpUser.CurrentUserRights.CustomerSatisfactionRecordCompetence, CustomAttributes.OperatingAuthority.SatisfactionSurveySet);
            }
            catch (Exception ex)
            { MessageBoxCustom.Show(ex.Message); }
        }
        /// <summary>
        /// 是否存在其它调查
        /// </summary>
        public void IsOthersurveys()
        {
            LYFZ.BLL.BLL_ErpSatisfactionSurveySet bll = new BLL.BLL_ErpSatisfactionSurveySet();
            DataTable dt = bll.GetList("Sfss_Type=7", "id asc").Tables[0];
            if (dt.Rows.Count > 0)
            {
                #region
                DataGridViewTextBoxColumn acCode = new DataGridViewTextBoxColumn();
                acCode.Name = "订单号";
                acCode.HeaderText = "订单号";
                this.dgv8.Columns.Add(acCode);

                acCode = new DataGridViewTextBoxColumn();
                acCode.Name = "订单类型";
                acCode.HeaderText = "订单类型";
                this.dgv8.Columns.Add(acCode);

                acCode = new DataGridViewTextBoxColumn();
                acCode.Name = "客户名称";
                acCode.HeaderText = "客户名称";
                this.dgv8.Columns.Add(acCode);

                acCode = new DataGridViewTextBoxColumn();
                acCode.Name = "客户电话";
                acCode.HeaderText = "客户电话";
                this.dgv8.Columns.Add(acCode);

                acCode = new DataGridViewTextBoxColumn();
                acCode.Name = "订单日期";
                acCode.HeaderText = "订单日期";
                this.dgv8.Columns.Add(acCode);

                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    acCode = new DataGridViewTextBoxColumn();
                    acCode.Name = dt.Rows[i]["Sfss_Name"].ToString();
                    acCode.HeaderText = dt.Rows[i]["Sfss_Name"].ToString();
                    this.dgv8.Columns.Add(acCode);

                    acCode = new DataGridViewTextBoxColumn();
                    acCode.Name = "回访人员";
                    acCode.HeaderText = "回访人员";
                    this.dgv8.Columns.Add(acCode);

                    acCode = new DataGridViewTextBoxColumn();
                    acCode.Name = "回访日期";
                    acCode.HeaderText = "回访日期";
                    this.dgv8.Columns.Add(acCode);

                    acCode = new DataGridViewTextBoxColumn();
                    acCode.Name = "备注";
                    acCode.HeaderText = "备注";

                    this.dgv8.Columns.Add(acCode);
                }
                #endregion
            }
            else
            { this.tabPage8.Parent = null; }
        }
        /// <summary>
        /// 调查
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected override void btnDc_Click(object sender, EventArgs e)
        {
            LYFZ.Software.MainBusiness.CustomerSatisfactionRecord.Satisfaction.FrmSatisfactionInvestigation frm = new Satisfaction.FrmSatisfactionInvestigation();
            if (this.tab.SelectedTab.Name == "tabPage1")// 订单
            {
                if (this.dgv1.SelectedRows.Count == 0)
                { MessageBoxCustom.Show("请选择你要调查的订单！"); return; }
                frm.Ord_Number = this.dgv1.CurrentRow.Cells["Column1"].Value.ToString();
                frm.Ord_Number_Deputy = "";
                frm.CustomerName = this.dgv1.CurrentRow.Cells["Column2"].Value.ToString();
                frm.Type = "0";
            }
            else if (this.tab.SelectedTab.Name == "tabPage2")// 选衣
            {
                if (this.dgv2.SelectedRows.Count == 0)
                { MessageBoxCustom.Show("请选择你要调查的订单！"); return; }
                frm.Ord_Number = this.dgv2.CurrentRow.Cells["dataGridViewTextBoxColumn1"].Value.ToString();
                frm.Ord_Number_Deputy = this.dgv2.CurrentRow.Cells["Column83"].Value.ToString();
                frm.CustomerName = this.dgv2.CurrentRow.Cells["dataGridViewTextBoxColumn2"].Value.ToString();
                frm.Type = "1";
            }
            else if (this.tab.SelectedTab.Name == "tabPage3")// 拍照
            {
                if (this.dgv3.SelectedRows.Count == 0)
                { MessageBoxCustom.Show("请选择你要调查的订单！"); return; }
                frm.Ord_Number = this.dgv3.CurrentRow.Cells["dataGridViewTextBoxColumn10"].Value.ToString();
                frm.Ord_Number_Deputy = this.dgv3.CurrentRow.Cells["Column84"].Value.ToString();
                frm.CustomerName = this.dgv3.CurrentRow.Cells["dataGridViewTextBoxColumn11"].Value.ToString();
                frm.Type = "2";
            }
            else if (this.tab.SelectedTab.Name == "tabPage4")// 选片
            {
                if (this.dgv4.SelectedRows.Count == 0)
                { MessageBoxCustom.Show("请选择你要调查的订单！"); return; }
                frm.Ord_Number = this.dgv4.CurrentRow.Cells["dataGridViewTextBoxColumn19"].Value.ToString();
                frm.Ord_Number_Deputy = this.dgv4.CurrentRow.Cells["Column85"].Value.ToString();
                frm.CustomerName = this.dgv4.CurrentRow.Cells["dataGridViewTextBoxColumn20"].Value.ToString();
                frm.Type = "3";
            }
            else if (this.tab.SelectedTab.Name == "tabPage5")// 看样
            {
                if (this.dgv5.SelectedRows.Count == 0)
                { MessageBoxCustom.Show("请选择你要调查的订单！"); return; }
                frm.Ord_Number = this.dgv5.CurrentRow.Cells["dataGridViewTextBoxColumn28"].Value.ToString();
                frm.Ord_Number_Deputy = this.dgv5.CurrentRow.Cells["Column86"].Value.ToString();
                frm.CustomerName = this.dgv5.CurrentRow.Cells["dataGridViewTextBoxColumn29"].Value.ToString();
                frm.Type = "4";
            }
            else if (this.tab.SelectedTab.Name == "tabPage6")// 取件
            {
                if (this.dgv6.SelectedRows.Count == 0)
                { MessageBoxCustom.Show("请选择你要调查的订单！"); return; }
                frm.Ord_Number = this.dgv6.CurrentRow.Cells["dataGridViewTextBoxColumn39"].Value.ToString();
                frm.Ord_Number_Deputy = this.dgv6.CurrentRow.Cells["Column87"].Value.ToString();
                frm.CustomerName = this.dgv6.CurrentRow.Cells["dataGridViewTextBoxColumn40"].Value.ToString();
                frm.Type = "5";
            }
            else if (this.tab.SelectedTab.Name == "tabPage7")// 服务
            {
                if (dgv7.SelectedRows.Count == 0)
                { MessageBoxCustom.Show("请选择你要调查的订单！"); return; }
                frm.Ord_Number = this.dgv7.CurrentRow.Cells["dataGridViewTextBoxColumn48"].Value.ToString();
                frm.Ord_Number_Deputy = "";
                frm.CustomerName = this.dgv7.CurrentRow.Cells["dataGridViewTextBoxColumn49"].Value.ToString();
                frm.Type = "6";
                frm.fw1 = this.dgv7.CurrentRow.Cells["fw1"].Value.ToString();
                frm.fw2 = this.dgv7.CurrentRow.Cells["fw2"].Value.ToString();
            }
            else if (this.tab.SelectedTab.Name == "tabPage8")// 其它调查
            {
                if (this.dgv8.SelectedRows.Count == 0)
                { MessageBoxCustom.Show("请选择你要调查的订单！"); return; }
                frm.Ord_Number = this.dgv8.CurrentRow.Cells["订单号"].Value.ToString();
                frm.Ord_Number_Deputy = "";
                frm.CustomerName = this.dgv8.CurrentRow.Cells["客户名称"].Value.ToString();
                frm.Type = "7";
            }
            if (frm.ShowDialog() == DialogResult.OK)
            { this.btnSelect_Click(sender, e); }
        }
        /// <summary>
        ///  查询
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected override void btnSelect_Click(object sender, EventArgs e)
        {
            try
            {
                if (this.tab.SelectedTab.Name == "tabPage1")
                { this.BindOrderForm(); }
                else if (this.tab.SelectedTab.Name == "tabPage2")
                { this.BindChooseClothes(); }
                else if (this.tab.SelectedTab.Name == "tabPage3")
                { this.BindPhotography(); }
                else if (this.tab.SelectedTab.Name == "tabPage4")
                { this.BindSelectionFilms(); }
                else if (this.tab.SelectedTab.Name == "tabPage5")
                { this.BindLookLike(); }
                else if (this.tab.SelectedTab.Name == "tabPage6")
                { this.BindPickup(); }
                else if (this.tab.SelectedTab.Name == "tabPage7")
                { this.BindService(); }
                else if (this.tab.SelectedTab.Name == "tabPage8")
                { this.BindOtherSurveys(); }
            }
            catch (Exception ex)
            { MessageBoxCustom.Show(ex.Message); }
        }
        /// <summary>
        /// 导出
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void btnExport_Click(object sender, EventArgs e)
        {
            try
            {
                if (this.tab.SelectedTab.Name == "tabPage1")
                { this.dgv1.ExportDataTable(); }
                else if (this.tab.SelectedTab.Name == "tabPage2")
                { this.dgv2.ExportDataTable(); }
                else if (this.tab.SelectedTab.Name == "tabPage3")
                { this.dgv3.ExportDataTable(); }
                else if (this.tab.SelectedTab.Name == "tabPage4")
                { this.dgv4.ExportDataTable(); }
                else if (this.tab.SelectedTab.Name == "tabPage5")
                { this.dgv5.ExportDataTable(); }
                else if (this.tab.SelectedTab.Name == "tabPage6")
                { this.dgv6.ExportDataTable(); }
                else if (this.tab.SelectedTab.Name == "tabPage7")
                { this.dgv7.ExportDataTable(); }
                else if (this.tab.SelectedTab.Name == "tabPage8")
                { this.dgv8.ExportDataTable(); }
            }
            catch (Exception ex)
            { MessageBoxCustom.Show(ex.Message); }
        }
        /// <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 tab_SelectedIndexChanged(object sender, EventArgs e)
        {
            try
            {
                if (this.tab.SelectedTab.Name == "tabPage1")
                { this.BindOrderForm(); }
                else if (this.tab.SelectedTab.Name == "tabPage2")
                {
                    this.BindChooseClothes(); }
                else if (this.tab.SelectedTab.Name == "tabPage3")
                {
                    this.BindPhotography();
                }
                else if (this.tab.SelectedTab.Name == "tabPage4")
                {
                    this.BindSelectionFilms();
                }
                else if (this.tab.SelectedTab.Name == "tabPage5")
                {
                    this.BindLookLike();
                }
                else if (this.tab.SelectedTab.Name == "tabPage6")
                {
                    this.BindPickup();
                }
                else if (this.tab.SelectedTab.Name == "tabPage7")
                {
                    this.BindService();
                }
                else if (this.tab.SelectedTab.Name == "tabPage8")
                {
                    this.BindOtherSurveys();
                }
            }
            catch (Exception ex)
            { MessageBoxCustom.Show(ex.Message); }
        }
        /// <summary>
        /// 调查设置
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected override void btnSet_Click(object sender, EventArgs e)
        {
            LYFZ.Software.MainBusiness.CustomerSatisfactionRecord.Satisfaction.FrmCustomerSatisfactionSet frm = new Satisfaction.FrmCustomerSatisfactionSet();
            frm.ShowDialog();
        }

        #region 列表双击事件
        /// <summary>
        /// 
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void dgv1_MouseDoubleClick(object sender, MouseEventArgs e)
        {
            if (e.Location.Y > this.dgv1.ColumnHeadersHeight)
            {
                if (this.dgv1.SelectedRows.Count == 0)
                { MessageBoxCustom.Show("请选择你要调查的订单！"); return; }
                LYFZ.Software.MainBusiness.CustomerSatisfactionRecord.Satisfaction.FrmSatisfactionInvestigation frm = new Satisfaction.FrmSatisfactionInvestigation();
                frm.Ord_Number = this.dgv1.CurrentRow.Cells["Column1"].Value.ToString();
                frm.Ord_Number_Deputy = "";
                frm.CustomerName = this.dgv1.CurrentRow.Cells["Column2"].Value.ToString();
                frm.Type = "0";
                if (frm.ShowDialog() == DialogResult.OK)
                { this.btnSelect_Click(sender, e); }
            }
        }
        /// <summary>
        /// 
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void dgv2_MouseDoubleClick(object sender, MouseEventArgs e)
        {
            if (e.Location.Y > this.dgv2.ColumnHeadersHeight)
            {
                if (this.dgv2.SelectedRows.Count == 0)
                { MessageBoxCustom.Show("请选择你要调查的订单！"); return; }
                LYFZ.Software.MainBusiness.CustomerSatisfactionRecord.Satisfaction.FrmSatisfactionInvestigation frm = new Satisfaction.FrmSatisfactionInvestigation();
                frm.Ord_Number = this.dgv2.CurrentRow.Cells["dataGridViewTextBoxColumn1"].Value.ToString();
                frm.Ord_Number_Deputy = this.dgv2.CurrentRow.Cells["Column83"].Value.ToString();
                frm.CustomerName = this.dgv2.CurrentRow.Cells["dataGridViewTextBoxColumn2"].Value.ToString();
                frm.Type = "1";
                if (frm.ShowDialog() == DialogResult.OK)
                { this.btnSelect_Click(sender, e); }
            }
        }
        /// <summary>
        /// 
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void dgv3_MouseDoubleClick(object sender, MouseEventArgs e)
        {
            if (e.Location.Y > this.dgv3.ColumnHeadersHeight)
            {
                if (this.dgv3.SelectedRows.Count == 0)
                { MessageBoxCustom.Show("请选择你要调查的订单！"); return; }
                LYFZ.Software.MainBusiness.CustomerSatisfactionRecord.Satisfaction.FrmSatisfactionInvestigation frm = new Satisfaction.FrmSatisfactionInvestigation();
                frm.Ord_Number = this.dgv3.CurrentRow.Cells["dataGridViewTextBoxColumn10"].Value.ToString();
                frm.Ord_Number_Deputy = this.dgv3.CurrentRow.Cells["Column84"].Value.ToString();
                frm.CustomerName = this.dgv3.CurrentRow.Cells["dataGridViewTextBoxColumn11"].Value.ToString();
                frm.StrID = this.dgv3.CurrentRow.Cells["ID"].Value.ToString();
                frm.Type = "2";
                if (frm.ShowDialog() == DialogResult.OK)
                { btnSelect_Click(sender, e); }
            }
        }
        /// <summary>
        /// 
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void dgv4_MouseDoubleClick(object sender, MouseEventArgs e)
        {
            if (e.Location.Y > this.dgv4.ColumnHeadersHeight)
            {
                if (this.dgv4.SelectedRows.Count == 0)
                { MessageBoxCustom.Show("请选择你要调查的订单！"); return; }
                LYFZ.Software.MainBusiness.CustomerSatisfactionRecord.Satisfaction.FrmSatisfactionInvestigation frm = new Satisfaction.FrmSatisfactionInvestigation();
                frm.Ord_Number = this.dgv4.CurrentRow.Cells["dataGridViewTextBoxColumn19"].Value.ToString();
                frm.Ord_Number_Deputy = this.dgv4.CurrentRow.Cells["Column85"].Value.ToString();
                frm.CustomerName = this.dgv4.CurrentRow.Cells["dataGridViewTextBoxColumn20"].Value.ToString();
                frm.Type = "3";
                if (frm.ShowDialog() == DialogResult.OK)
                { this.btnSelect_Click(sender, e); }
            }
        }
        /// <summary>
        /// 
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void dgv5_MouseDoubleClick(object sender, MouseEventArgs e)
        {
            if (e.Location.Y > this.dgv5.ColumnHeadersHeight)
            {
                if (this.dgv5.SelectedRows.Count == 0)
                { MessageBoxCustom.Show("请选择你要调查的订单！"); return; }
                LYFZ.Software.MainBusiness.CustomerSatisfactionRecord.Satisfaction.FrmSatisfactionInvestigation frm = new Satisfaction.FrmSatisfactionInvestigation();
                frm.Ord_Number = this.dgv5.CurrentRow.Cells["dataGridViewTextBoxColumn28"].Value.ToString();
                frm.Ord_Number_Deputy = this.dgv5.CurrentRow.Cells["Column86"].Value.ToString();
                frm.CustomerName = this.dgv5.CurrentRow.Cells["dataGridViewTextBoxColumn29"].Value.ToString();
                frm.Type = "4";
                if (frm.ShowDialog() == DialogResult.OK)
                { this.btnSelect_Click(sender, e); }
            }
        }
        /// <summary>
        /// 
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void dgv6_MouseDoubleClick(object sender, MouseEventArgs e)
        {
            if (e.Location.Y > this.dgv6.ColumnHeadersHeight)
            {
                if (this.dgv6.SelectedRows.Count == 0)
                { MessageBoxCustom.Show("请选择你要调查的订单！"); return; }
                LYFZ.Software.MainBusiness.CustomerSatisfactionRecord.Satisfaction.FrmSatisfactionInvestigation frm = new Satisfaction.FrmSatisfactionInvestigation();
                frm.Ord_Number = this.dgv6.CurrentRow.Cells["dataGridViewTextBoxColumn39"].Value.ToString();
                frm.Ord_Number_Deputy = this.dgv6.CurrentRow.Cells["Column87"].Value.ToString();
                frm.CustomerName = this.dgv6.CurrentRow.Cells["dataGridViewTextBoxColumn40"].Value.ToString();
                frm.Type = "5";
                if (frm.ShowDialog() == DialogResult.OK)
                { this.btnSelect_Click(sender, e); }
            }
        }
        /// <summary>
        /// 
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void dgv7_MouseDoubleClick(object sender, MouseEventArgs e)
        {
            if (e.Location.Y > this.dgv7.ColumnHeadersHeight)
            {
                if (this.dgv7.SelectedRows.Count == 0)
                { MessageBoxCustom.Show("请选择你要调查的订单！"); return; }
                LYFZ.Software.MainBusiness.CustomerSatisfactionRecord.Satisfaction.FrmSatisfactionInvestigation frm = new Satisfaction.FrmSatisfactionInvestigation();
                frm.Ord_Number = this.dgv7.CurrentRow.Cells["dataGridViewTextBoxColumn48"].Value.ToString();
                frm.Ord_Number_Deputy = "";
                frm.CustomerName = this.dgv7.CurrentRow.Cells["dataGridViewTextBoxColumn49"].Value.ToString();
                frm.Type = "6";
                frm.fw1 = this.dgv7.CurrentRow.Cells["fw1"].Value.ToString();
                frm.fw2 = this.dgv7.CurrentRow.Cells["fw2"].Value.ToString();
                if (frm.ShowDialog() == DialogResult.OK)
                { this.btnSelect_Click(sender, e); }
            }
        }
        /// <summary>
        /// 
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void dgv8_MouseDoubleClick(object sender, MouseEventArgs e)
        {
            if (e.Location.Y > this.dgv8.ColumnHeadersHeight)
            {
                if (this.dgv8.SelectedRows.Count == 0)
                { MessageBoxCustom.Show("请选择你要调查的订单！"); return; }
                LYFZ.Software.MainBusiness.CustomerSatisfactionRecord.Satisfaction.FrmSatisfactionInvestigation frm = new Satisfaction.FrmSatisfactionInvestigation();
                frm.Ord_Number = this.dgv8.CurrentRow.Cells["订单号"].Value.ToString();
                frm.Ord_Number_Deputy = "";
                frm.CustomerName = this.dgv8.CurrentRow.Cells["客户名称"].Value.ToString();
                frm.Type = "7";
                if (frm.ShowDialog() == DialogResult.OK)
                { this.btnSelect_Click(sender, e); }
            }
        }
        #endregion

        #region 绑定数据
        #region 绑定近期订单
        /// <summary>
        /// 绑定近期订单
        /// </summary>
        public void BindOrderForm()
        {
            this.ucPagerEx1.PageCurrent = 1;
            this.ucPagerEx1.PageSize = LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.GetPageSize();
            this.ucPagerEx1.Bind();
        }
        /// <summary>
        /// 画分页
        /// </summary>
        /// <param name="e"></param>
        /// <returns></returns>
        private int ucPagerEx1_EventPaging(UCPager.EventPagingArg e)
        {
            LYFZ.UCPager.PageData pageData = new LYFZ.UCPager.PageData();
            this.dgv1.Rows.Clear();
            DataTable dt = new DataTable();
            StringBuilder sql = new StringBuilder();
            if (!string.IsNullOrEmpty(this.txtTimeStart.DateValue) && !string.IsNullOrEmpty(this.txtTimeEnd.DateValue))
            { sql.Append(PublicCodeClasses.GetDateTime("Ord_CreateDatetime", this.txtTimeStart.Text, this.txtTimeEnd.Text, ConnectWord: "") + "and Ord_Class='1'"); }
            else
            { sql.Append(" "); }
            DataTable dtSurvey = sfsbll.Vw_ErpSatisfactionSurvey("").Tables[0];
            LYFZ.ComponentLibrary.FrmLoadHandling.LoadDoWorkMethod(delegate(object obj, BackgroundWorker backgroundWorker)
            {
                pageData.TableName = "Vw_Customer_PaymentOrders";
                pageData.PageIndex = this.ucPagerEx1.PageCurrent;
                pageData.PageSize = this.ucPagerEx1.PageSize;
                pageData.QueryCondition = sql.ToString();
                pageData.QueryFieldName = "ID,Ord_Number,Ord_DividedShop,Ord_Type,Ord_PhotographyCategory,Ord_SeriesName,Ord_SeriesPrice,Ord_Class,GP_OrderNumber,GP_CustomerGroupID,Cus_Name,Cus_Name_py,Cus_Telephone,Ord_OrdersPersonID,Ord_OrdersPerson,Ord_CreateDatetime,PickupStatusCount";
                pageData.OrderStr = " ID desc ";
                dt = pageData.QueryDataTable().Tables[0];
                if (dt.Rows.Count > 0)
                {
                    this.Invoke(new UpdateControl(delegate()
                    {
                        for (int t = 0; t < dt.Rows.Count; t++)
                        {
                            #region
                            DataGridViewRow dgvr = new DataGridViewRow();
                            DataGridViewCell cell = null;

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["Ord_Number"].ToString().Trim();
                            dgvr.Cells.Add(cell);

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["Ord_Type"].ToString().Trim() == "0" ? "婚纱订单" : dt.Rows[t]["Ord_Type"].ToString().Trim() == "1" ? "儿童订单" : dt.Rows[t]["Ord_Type"].ToString().Trim() == "2" ? "写真订单" : dt.Rows[t]["Ord_Type"].ToString().Trim() == "3" ? "服务订单" : "其它消费";
                            dgvr.Cells.Add(cell);

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["Cus_Name"].ToString().Trim();
                            dgvr.Cells.Add(cell);

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["Cus_Telephone"].ToString().Trim();
                            dgvr.Cells.Add(cell);

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = Convert.ToDateTime(dt.Rows[t]["Ord_CreateDatetime"].ToString().Trim()).ToString("yyyy-MM-dd");
                            dgvr.Cells.Add(cell);

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["Ord_OrdersPerson"].ToString().Trim();
                            dgvr.Cells.Add(cell);

                            DataRow[] dtleng = dtSurvey.Select(" Sfs_OrderNumber='" + dt.Rows[t]["Ord_Number"].ToString().Trim() + "' and Sfs_Type=0 and Sfs_SurveySetID=1", " id asc");
                            if (dtleng.Length > 0)
                            {
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dtleng[0]["Sfs_RatingSetName"].ToString();
                                dgvr.Cells.Add(cell);

                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dtleng[0]["Sfs_CreateName"].ToString();
                                dgvr.Cells.Add(cell);

                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dtleng[0]["Sfs_CreateTime"].ToString();
                                dgvr.Cells.Add(cell);

                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dtleng[0]["Sfs_Remark"].ToString();
                                dgvr.Cells.Add(cell);
                            }
                            else
                            {
                                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);
                            }
                            this.dgv1.Rows.Add(dgvr);
                            #endregion
                        }
                    }));
                }
            });
            try
            {
                this.ucPagerEx1.TbDataSource = dt;
                this.dgv1.ClearSelection();
            }
            catch { }
            return pageData.TotalCount;
        }
        #endregion

        #region 绑定近期选衣
        /// <summary>
        /// 绑定近期选衣
        /// </summary>
        public void BindChooseClothes()
        {
            this.ucPagerEx2.PageCurrent = 1;
            this.ucPagerEx2.PageSize = LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.GetPageSize();
            this.ucPagerEx2.Bind();
        }
        /// <summary>
        /// 画分页
        /// </summary>
        /// <param name="e"></param>
        /// <returns></returns>
        private int ucPagerEx2_EventPaging(UCPager.EventPagingArg e)
        {
            LYFZ.UCPager.PageData pageData = new LYFZ.UCPager.PageData();
            this.dgv2.Rows.Clear();
            DataTable dt = new DataTable();
            StringBuilder sql = new StringBuilder();
            if (!string.IsNullOrEmpty(this.txtTimeStart.DateValue) && !string.IsNullOrEmpty(this.txtTimeEnd.DateValue))
            { sql.Append(PublicCodeClasses.GetDateTime("选衣时间", this.txtTimeStart.Text, this.txtTimeEnd.Text, ConnectWord: "") + " and 礼服师状态='1' and Ord_Class='1'"); }
            else
            { sql.Append(" "); }
            DataTable dtSurvey = sfsbll.Vw_ErpSatisfactionSurvey("").Tables[0];
            LYFZ.ComponentLibrary.FrmLoadHandling.LoadDoWorkMethod(delegate(object obj, BackgroundWorker backgroundWorker)
            {
                pageData.TableName = "Vw_OrdersWageDigital";
                pageData.PageIndex = this.ucPagerEx2.PageCurrent;
                pageData.PageSize = this.ucPagerEx2.PageSize;
                pageData.QueryCondition = sql.ToString();
                pageData.QueryFieldName = "Id,Ordv_Number,Ordv_ViceNumber,Ordv_DigitalNumber,Ord_Number,Ord_Type,Ord_Class,Ord_PhotographyCategory,Ord_SeriesName,Ord_SeriesPrice,拍摄名称,客户名称,客户电话,礼服师ID,礼服师,礼服师状态,选衣时间";
                pageData.OrderStr = " ID desc ";
                dt = pageData.QueryDataTable().Tables[0];
                if (dt.Rows.Count > 0)
                {
                    this.Invoke(new UpdateControl(delegate()
                    {
                        for (int t = 0; t < dt.Rows.Count; t++)
                        {
                            #region
                            DataGridViewRow dgvr = new DataGridViewRow();
                            DataGridViewCell cell = null;

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["Ord_Number"].ToString().Trim();
                            dgvr.Cells.Add(cell);

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["Ordv_ViceNumber"].ToString().Trim();
                            dgvr.Cells.Add(cell);

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["Ord_Type"].ToString().Trim() == "0" ? "婚纱订单" : dt.Rows[t]["Ord_Type"].ToString().Trim() == "1" ? "儿童订单" : dt.Rows[t]["Ord_Type"].ToString().Trim() == "2" ? "写真订单" : dt.Rows[t]["Ord_Type"].ToString().Trim() == "3" ? "服务订单" : "其它消费";
                            dgvr.Cells.Add(cell);

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

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["客户电话"].ToString().Trim();
                            dgvr.Cells.Add(cell);

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

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["选衣时间"].ToString().Trim() == "" ? "" : Convert.ToDateTime(dt.Rows[t]["选衣时间"].ToString().Trim()).ToString("yyyy-MM-dd");
                            dgvr.Cells.Add(cell);

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["礼服师状态"].ToString().Trim() == "1" ? "OK" : "未选";
                            dgvr.Cells.Add(cell);

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["礼服师ID"].ToString().Trim();
                            dgvr.Cells.Add(cell);

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["礼服师"].ToString().Trim();
                            dgvr.Cells.Add(cell);

                            DataRow[] dtleng = dtSurvey.Select(" Sfs_OrderNumber='" + dt.Rows[t]["Ord_Number"].ToString().Trim() + "' and Sfs_OrderNumberDeputy='" + dt.Rows[t]["Ordv_ViceNumber"].ToString().Trim() + "'  and Sfs_Type=1 and Sfs_SurveySetID=2", " id asc");
                            if (dtleng.Length > 0)
                            {
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dtleng[0]["Sfs_RatingSetName"].ToString();
                                dgvr.Cells.Add(cell);

                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dtleng[0]["Sfs_CreateName"].ToString();
                                dgvr.Cells.Add(cell);

                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dtleng[0]["Sfs_CreateTime"].ToString();
                                dgvr.Cells.Add(cell);

                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dtleng[0]["Sfs_Remark"].ToString();
                                dgvr.Cells.Add(cell);
                            }
                            else
                            {
                                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);
                            }
                            this.dgv2.Rows.Add(dgvr);
                            #endregion
                        }
                    }));
                }
            });
            try
            {
                this.ucPagerEx2.TbDataSource = dt;
                this.dgv2.ClearSelection();
            }
            catch
            { }
            return pageData.TotalCount;
        }
        #endregion

        #region 绑定近期拍照
        /// <summary>
        /// 绑定近期拍照
        /// </summary>
        public void BindPhotography()
        {
            this.ucPagerEx3.PageCurrent = 1;
            this.ucPagerEx3.PageSize = LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.GetPageSize();
            this.ucPagerEx3.Bind();
        }
        /// <summary>
        /// 画分页
        /// </summary>
        /// <param name="e"></param>
        /// <returns></returns>
        private int ucPagerEx3_EventPaging(UCPager.EventPagingArg e)
        {
            LYFZ.UCPager.PageData pageData = new LYFZ.UCPager.PageData();
            this.dgv3.Rows.Clear();
            DataTable dt = new DataTable();
            StringBuilder sql = new StringBuilder();
            if (!string.IsNullOrEmpty(this.txtTimeStart.Text) && !string.IsNullOrEmpty(this.txtTimeEnd.Text))
            { sql.Append(PublicCodeClasses.GetDateTime("拍摄时间", this.txtTimeStart.Text, this.txtTimeEnd.Text, ConnectWord: "") + " and 拍摄状态='1' and Ord_Class='1'"); }
            else
            { sql.Append(" "); }
            DataTable dtSurvey = sfsbll.Vw_ErpSatisfactionSurvey("").Tables[0];
            LYFZ.ComponentLibrary.FrmLoadHandling.LoadDoWorkMethod(delegate(object obj, BackgroundWorker backgroundWorker)
            {
                pageData.TableName = "Vw_OrdersWagePhotography";
                pageData.PageIndex = this.ucPagerEx3.PageCurrent;
                pageData.PageSize = this.ucPagerEx3.PageSize;
                pageData.QueryCondition = sql.ToString();
                pageData.QueryFieldName = "ID,Ordpg_Number,Ordpg_ViceNumber,Ord_Type,Ord_Class,Ord_PhotographyCategory,Ord_SeriesName,Ord_SeriesPrice,客户名称,客户电话,拍摄名称,景点类别,服装套数,摄影师ID,摄影师名称,拍摄时间,拍摄状态,摄影助理ID,摄影助理名称,化妆师ID,化妆师名称,化妆助理ID,化妆助理名称,引导师ID,引导师名称";
                pageData.OrderStr = " ID desc ";
                dt = pageData.QueryDataTable().Tables[0];
                if (dt.Rows.Count > 0)
                {
                    this.Invoke(new UpdateControl(delegate()
                    {
                        for (int t = 0; t < dt.Rows.Count; t++)
                        {
                            #region
                            DataGridViewRow dgvr = new DataGridViewRow();
                            DataGridViewCell cell = null;

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["Ordpg_Number"].ToString().Trim();
                            dgvr.Cells.Add(cell);

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["Ordpg_ViceNumber"].ToString().Trim();
                            dgvr.Cells.Add(cell);

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["Ord_Type"].ToString().Trim() == "0" ? "婚纱订单" : dt.Rows[t]["Ord_Type"].ToString().Trim() == "1" ? "儿童订单" : dt.Rows[t]["Ord_Type"].ToString().Trim() == "2" ? "写真订单" : dt.Rows[t]["Ord_Type"].ToString().Trim() == "3" ? "服务订单" : "其它消费";
                            dgvr.Cells.Add(cell);

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

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["客户电话"].ToString().Trim();
                            dgvr.Cells.Add(cell);

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

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["拍摄时间"].ToString().Trim() == "" ? "" : Convert.ToDateTime(dt.Rows[t]["拍摄时间"].ToString().Trim()).ToString("yyyy-MM-dd");
                            dgvr.Cells.Add(cell);

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["拍摄状态"].ToString().Trim() == "1" ? "OK" : "未拍";
                            dgvr.Cells.Add(cell);

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["摄影师ID"].ToString().Trim();
                            dgvr.Cells.Add(cell);

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["摄影师名称"].ToString().Trim();
                            dgvr.Cells.Add(cell);

                            #region 赋值
                            DataRow[] dtleng = dtSurvey.Select(" Sfs_OrderNumber='" + dt.Rows[t]["Ordpg_Number"].ToString().Trim() + "' and Sfs_OrderNumberDeputy='" + dt.Rows[t]["Ordpg_ViceNumber"].ToString().Trim() + "'  and Sfs_Type=2 and Sfs_SurveySetID=3", " id asc");
                            if (dtleng.Length > 0)
                            {
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dtleng[0]["Sfs_RatingSetName"].ToString();
                                dgvr.Cells.Add(cell);

                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dtleng[0]["Sfs_CreateName"].ToString();
                                dgvr.Cells.Add(cell);

                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dtleng[0]["Sfs_CreateTime"].ToString();
                                dgvr.Cells.Add(cell);

                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dtleng[0]["Sfs_Remark"].ToString();
                                dgvr.Cells.Add(cell);
                            }
                            else
                            {
                                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

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["摄影助理ID"].ToString().Trim();
                            dgvr.Cells.Add(cell);

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["摄影助理名称"].ToString().Trim();
                            dgvr.Cells.Add(cell);

                            #region 赋值
                            dtleng = dtSurvey.Select(" Sfs_OrderNumber='" + dt.Rows[t]["Ordpg_Number"].ToString().Trim() + "' and Sfs_OrderNumberDeputy='" + dt.Rows[t]["Ordpg_ViceNumber"].ToString().Trim() + "'  and Sfs_Type=2 and Sfs_SurveySetID=4", " id asc");
                            if (dtleng.Length > 0)
                            {
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dtleng[0]["Sfs_RatingSetName"].ToString();
                                dgvr.Cells.Add(cell);

                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dtleng[0]["Sfs_CreateName"].ToString();
                                dgvr.Cells.Add(cell);

                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dtleng[0]["Sfs_CreateTime"].ToString();
                                dgvr.Cells.Add(cell);

                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dtleng[0]["Sfs_Remark"].ToString();
                                dgvr.Cells.Add(cell);
                            }
                            else
                            {
                                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

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["化妆师ID"].ToString().Trim();
                            dgvr.Cells.Add(cell);

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["化妆师名称"].ToString().Trim();
                            dgvr.Cells.Add(cell);

                            #region 赋值
                            dtleng = dtSurvey.Select(" Sfs_OrderNumber='" + dt.Rows[t]["Ordpg_Number"].ToString().Trim() + "' and Sfs_OrderNumberDeputy='" + dt.Rows[t]["Ordpg_ViceNumber"].ToString().Trim() + "'  and Sfs_Type=2 and Sfs_SurveySetID=5", " id asc");
                            if (dtleng.Length > 0)
                            {
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dtleng[0]["Sfs_RatingSetName"].ToString();
                                dgvr.Cells.Add(cell);

                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dtleng[0]["Sfs_CreateName"].ToString();
                                dgvr.Cells.Add(cell);

                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dtleng[0]["Sfs_CreateTime"].ToString();
                                dgvr.Cells.Add(cell);

                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dtleng[0]["Sfs_Remark"].ToString();
                                dgvr.Cells.Add(cell);
                            }
                            else
                            {
                                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


                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["化妆助理ID"].ToString().Trim();
                            dgvr.Cells.Add(cell);

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["化妆助理名称"].ToString().Trim();
                            dgvr.Cells.Add(cell);

                            #region 赋值
                            dtleng = dtSurvey.Select(" Sfs_OrderNumber='" + dt.Rows[t]["Ordpg_Number"].ToString().Trim() + "' and Sfs_OrderNumberDeputy='" + dt.Rows[t]["Ordpg_ViceNumber"].ToString().Trim() + "'  and Sfs_Type=2 and Sfs_SurveySetID=6", " id asc");
                            if (dtleng.Length > 0)
                            {
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dtleng[0]["Sfs_RatingSetName"].ToString();
                                dgvr.Cells.Add(cell);

                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dtleng[0]["Sfs_CreateName"].ToString();
                                dgvr.Cells.Add(cell);

                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dtleng[0]["Sfs_CreateTime"].ToString();
                                dgvr.Cells.Add(cell);

                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dtleng[0]["Sfs_Remark"].ToString();
                                dgvr.Cells.Add(cell);
                            }
                            else
                            {
                                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

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["引导师ID"].ToString().Trim();
                            dgvr.Cells.Add(cell);

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["引导师名称"].ToString().Trim();
                            dgvr.Cells.Add(cell);

                            #region 赋值
                            dtleng = dtSurvey.Select(" Sfs_OrderNumber='" + dt.Rows[t]["Ordpg_Number"].ToString().Trim() + "' and Sfs_OrderNumberDeputy='" + dt.Rows[t]["Ordpg_ViceNumber"].ToString().Trim() + "'  and Sfs_Type=2 and Sfs_SurveySetID=7", " id asc");
                            if (dtleng.Length > 0)
                            {
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dtleng[0]["Sfs_RatingSetName"].ToString();
                                dgvr.Cells.Add(cell);

                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dtleng[0]["Sfs_CreateName"].ToString();
                                dgvr.Cells.Add(cell);

                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dtleng[0]["Sfs_CreateTime"].ToString();
                                dgvr.Cells.Add(cell);

                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dtleng[0]["Sfs_Remark"].ToString();
                                dgvr.Cells.Add(cell);
                            }
                            else
                            {
                                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.dgv3.Rows.Add(dgvr);
                            #endregion
                        }
                    }));
                }
            });
            try
            {
                this.ucPagerEx3.TbDataSource = dt;
                this.dgv3.ClearSelection();
            }
            catch
            { }
            return pageData.TotalCount;
        }
        #endregion

        #region 绑定近期选片
        /// <summary>
        /// 绑定近期选片
        /// </summary>
        public void BindSelectionFilms()
        {
            this.ucPagerEx4.PageCurrent = 1;
            this.ucPagerEx4.PageSize = LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.GetPageSize();
            this.ucPagerEx4.Bind();
        }
        /// <summary>
        /// 画分页
        /// </summary>
        /// <param name="e"></param>
        /// <returns></returns>
        private int ucPagerEx4_EventPaging(UCPager.EventPagingArg e)
        {
            LYFZ.UCPager.PageData pageData = new LYFZ.UCPager.PageData();
            this.dgv4.Rows.Clear();
            DataTable dt = new DataTable();
            StringBuilder sql = new StringBuilder();
            //if (!string.IsNullOrEmpty(this.txtTimeStart.Text) && !string.IsNullOrEmpty(this.txtTimeEnd.Text))
            //{ sql.Append(" 1=1 and ((" + PublicCodeClasses.GetDateTime("选片时间", this.txtTimeStart.Text, this.txtTimeEnd.Text, ConnectWord: "") + " and 选片状态='1') or (" + PublicCodeClasses.GetDateTime("初修时间", this.txtTimeStart.Text, this.txtTimeEnd.Text, ConnectWord: "") + " and 初修状态='2') or (" + PublicCodeClasses.GetDateTime("精修时间", this.txtTimeStart.Text, this.txtTimeEnd.Text, ConnectWord: "") + " and 精修状态='2')) and Ord_Class='1'"); }
            if (!string.IsNullOrEmpty(this.txtTimeStart.Text) && !string.IsNullOrEmpty(this.txtTimeEnd.Text))
            { sql.Append(PublicCodeClasses.GetDateTime("选片时间", this.txtTimeStart.Text, this.txtTimeEnd.Text, ConnectWord: "") + " and 选片状态='1' and Ord_Class='1'"); }
            DataTable dtSurvey = sfsbll.Vw_ErpSatisfactionSurvey("").Tables[0];
            LYFZ.ComponentLibrary.FrmLoadHandling.LoadDoWorkMethod(delegate(object obj, BackgroundWorker backgroundWorker)
            {
                pageData.TableName = "Vw_OrdersWageDigital";
                pageData.PageIndex = this.ucPagerEx4.PageCurrent;
                pageData.PageSize = this.ucPagerEx4.PageSize;
                pageData.QueryCondition = sql.ToString();
                pageData.QueryFieldName = "Id,Ordv_Number,Ordv_ViceNumber,Ordv_DigitalNumber,Ord_Number,Ord_Type,Ord_Class,Ord_PhotographyCategory,Ord_SeriesName,Ord_SeriesPrice,拍摄名称,客户名称,客户电话,选片师ID,选片师,选片状态,选片时间,初修师ID,初修师,初修状态,初修时间,精修师ID,精修师,精修状态,精修时间";
                pageData.OrderStr = " ID desc ";
                dt = pageData.QueryDataTable().Tables[0];
                if (dt.Rows.Count > 0)
                {
                    this.Invoke(new UpdateControl(delegate()
                    {
                        for (int t = 0; t < dt.Rows.Count; t++)
                        {
                            #region
                            DataGridViewRow dgvr = new DataGridViewRow();
                            DataGridViewCell cell = null;

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["Ord_Number"].ToString().Trim();
                            dgvr.Cells.Add(cell);

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["Ordv_ViceNumber"].ToString().Trim();
                            dgvr.Cells.Add(cell);

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["Ord_Type"].ToString().Trim() == "0" ? "婚纱订单" : dt.Rows[t]["Ord_Type"].ToString().Trim() == "1" ? "儿童订单" : dt.Rows[t]["Ord_Type"].ToString().Trim() == "2" ? "写真订单" : dt.Rows[t]["Ord_Type"].ToString().Trim() == "3" ? "服务订单" : "其它消费";
                            dgvr.Cells.Add(cell);

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

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["客户电话"].ToString().Trim();
                            dgvr.Cells.Add(cell);

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

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["选片时间"].ToString().Trim() == "" ? "" : Convert.ToDateTime(dt.Rows[t]["选片时间"].ToString().Trim()).ToString("yyyy-MM-dd");
                            dgvr.Cells.Add(cell);

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["选片状态"].ToString().Trim() == "1" ? "OK" : "未选";
                            dgvr.Cells.Add(cell);

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["选片师ID"].ToString().Trim();
                            dgvr.Cells.Add(cell);

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["选片师"].ToString().Trim();
                            dgvr.Cells.Add(cell);

                            #region 赋值
                            DataRow[] dtleng = dtSurvey.Select(" Sfs_OrderNumber='" + dt.Rows[t]["Ord_Number"].ToString().Trim() + "'  and Sfs_OrderNumberDeputy='" + dt.Rows[t]["Ordv_ViceNumber"].ToString().Trim() + "' and Sfs_Type=3 and Sfs_SurveySetID=8", " id asc");
                            if (dtleng.Length > 0)
                            {
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dtleng[0]["Sfs_RatingSetName"].ToString();
                                dgvr.Cells.Add(cell);

                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dtleng[0]["Sfs_CreateName"].ToString();
                                dgvr.Cells.Add(cell);

                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dtleng[0]["Sfs_CreateTime"].ToString();
                                dgvr.Cells.Add(cell);

                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dtleng[0]["Sfs_Remark"].ToString();
                                dgvr.Cells.Add(cell);
                            }
                            else
                            {
                                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

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["初修师ID"].ToString().Trim();
                            dgvr.Cells.Add(cell);

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["初修时间"].ToString().Trim() == "" ? "" : Convert.ToDateTime(dt.Rows[t]["初修时间"].ToString().Trim()).ToString("yyyy-MM-dd");
                            dgvr.Cells.Add(cell);

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["初修状态"].ToString().Trim() == "2" ? "OK" : "未修";
                            dgvr.Cells.Add(cell);

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["初修师"].ToString().Trim();
                            dgvr.Cells.Add(cell);

                            #region 赋值
                            dtleng = dtSurvey.Select(" Sfs_OrderNumber='" + dt.Rows[t]["Ord_Number"].ToString().Trim() + "'  and Sfs_OrderNumberDeputy='" + dt.Rows[t]["Ordv_ViceNumber"].ToString().Trim() + "' and Sfs_Type=3 and Sfs_SurveySetID=9", " id asc");
                            if (dtleng.Length > 0)
                            {
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dtleng[0]["Sfs_RatingSetName"].ToString();
                                dgvr.Cells.Add(cell);

                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dtleng[0]["Sfs_CreateName"].ToString();
                                dgvr.Cells.Add(cell);

                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dtleng[0]["Sfs_CreateTime"].ToString();
                                dgvr.Cells.Add(cell);

                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dtleng[0]["Sfs_Remark"].ToString();
                                dgvr.Cells.Add(cell);
                            }
                            else
                            {
                                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

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["精修师ID"].ToString().Trim();
                            dgvr.Cells.Add(cell);

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["精修时间"].ToString().Trim() == "" ? "" : Convert.ToDateTime(dt.Rows[t]["精修时间"].ToString().Trim()).ToString("yyyy-MM-dd");
                            dgvr.Cells.Add(cell);

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["精修状态"].ToString().Trim() == "2" ? "OK" : "未修";
                            dgvr.Cells.Add(cell);

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["精修师"].ToString().Trim();
                            dgvr.Cells.Add(cell);

                            #region 赋值
                            dtleng = dtSurvey.Select(" Sfs_OrderNumber='" + dt.Rows[t]["Ord_Number"].ToString().Trim() + "'  and Sfs_OrderNumberDeputy='" + dt.Rows[t]["Ordv_ViceNumber"].ToString().Trim() + "' and Sfs_Type=3 and Sfs_SurveySetID=10", " id asc");
                            if (dtleng.Length > 0)
                            {
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dtleng[0]["Sfs_RatingSetName"].ToString();
                                dgvr.Cells.Add(cell);

                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dtleng[0]["Sfs_CreateName"].ToString();
                                dgvr.Cells.Add(cell);

                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dtleng[0]["Sfs_CreateTime"].ToString();
                                dgvr.Cells.Add(cell);

                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dtleng[0]["Sfs_Remark"].ToString();
                                dgvr.Cells.Add(cell);
                            }
                            else
                            {
                                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.dgv4.Rows.Add(dgvr);
                            #endregion
                        }
                    }));
                }
            });
            try
            {
                this.ucPagerEx4.TbDataSource = dt;
                this.dgv4.ClearSelection();
            }
            catch { }
            return pageData.TotalCount;
        }
        #endregion

        #region 绑定近期看样
        /// <summary>
        /// 绑定近期看样
        /// </summary>
        public void BindLookLike()
        {
            this.ucPagerEx5.PageCurrent = 1;
            this.ucPagerEx5.PageSize = LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.GetPageSize();
            this.ucPagerEx5.Bind();
        }
        /// <summary>
        /// 画分页
        /// </summary>
        /// <param name="e"></param>
        /// <returns></returns>
        private int ucPagerEx5_EventPaging(UCPager.EventPagingArg e)
        {
            LYFZ.UCPager.PageData pageData = new LYFZ.UCPager.PageData();
            this.dgv5.Rows.Clear();
            DataTable dt = new DataTable();
            StringBuilder sql = new StringBuilder();
            //if (!string.IsNullOrEmpty(this.txtTimeStart.Text) && !string.IsNullOrEmpty(this.txtTimeEnd.Text))
            //{ sql.Append(" 1=1 and ((" + PublicCodeClasses.GetDateTime("看设计时间", this.txtTimeStart.Text, this.txtTimeEnd.Text, ConnectWord: "") + " and 看设计状态='1') or (" + PublicCodeClasses.GetDateTime("设计时间", this.txtTimeStart.Text, this.txtTimeEnd.Text, ConnectWord: "") + " and 设计状态='2')) and Ord_Class='1'"); 
            if (!string.IsNullOrEmpty(this.txtTimeStart.Text) && !string.IsNullOrEmpty(this.txtTimeEnd.Text))
            { sql.Append(PublicCodeClasses.GetDateTime("看设计时间", this.txtTimeStart.Text, this.txtTimeEnd.Text, ConnectWord: "") + " and 看设计状态='1' and Ord_Class='1'"); }
            DataTable dtSurvey = sfsbll.Vw_ErpSatisfactionSurvey("").Tables[0];
            LYFZ.ComponentLibrary.FrmLoadHandling.LoadDoWorkMethod(delegate(object obj, BackgroundWorker backgroundWorker)
            {
                pageData.TableName = "Vw_OrdersWageDigital";
                pageData.PageIndex = this.ucPagerEx5.PageCurrent;
                pageData.PageSize = this.ucPagerEx5.PageSize;
                pageData.QueryCondition = sql.ToString();
                pageData.QueryFieldName = "Id,Ordv_Number,Ordv_ViceNumber,Ordv_DigitalNumber,Ord_Number,Ord_Type,Ord_Class,Ord_PhotographyCategory,Ord_SeriesName,Ord_SeriesPrice,拍摄名称,客户名称,客户电话,看设计师ID,看设计师,看设计状态,看设计时间,设计师ID,设计师,设计状态,设计时间";
                pageData.OrderStr = " ID desc ";
                dt = pageData.QueryDataTable().Tables[0];
                if (dt.Rows.Count > 0)
                {
                    this.Invoke(new UpdateControl(delegate()
                    {
                        for (int t = 0; t < dt.Rows.Count; t++)
                        {
                            #region
                            DataGridViewRow dgvr = new DataGridViewRow();
                            DataGridViewCell cell = null;

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["Ord_Number"].ToString().Trim();
                            dgvr.Cells.Add(cell);

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["Ordv_ViceNumber"].ToString().Trim();
                            dgvr.Cells.Add(cell);

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["Ord_Type"].ToString().Trim() == "0" ? "婚纱订单" : dt.Rows[t]["Ord_Type"].ToString().Trim() == "1" ? "儿童订单" : dt.Rows[t]["Ord_Type"].ToString().Trim() == "2" ? "写真订单" : dt.Rows[t]["Ord_Type"].ToString().Trim() == "3" ? "服务订单" : "其它消费";
                            dgvr.Cells.Add(cell);

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

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["客户电话"].ToString().Trim();
                            dgvr.Cells.Add(cell);

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

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["看设计时间"].ToString().Trim() == "" ? "" : Convert.ToDateTime(dt.Rows[t]["看设计时间"].ToString().Trim()).ToString("yyyy-MM-dd");
                            dgvr.Cells.Add(cell);

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["看设计状态"].ToString().Trim() == "1" ? "OK" : "未看";
                            dgvr.Cells.Add(cell);

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["看设计师ID"].ToString().Trim();
                            dgvr.Cells.Add(cell);

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["看设计师"].ToString().Trim();
                            dgvr.Cells.Add(cell);

                            #region 赋值
                            DataRow[] dtleng = dtSurvey.Select(" Sfs_OrderNumber='" + dt.Rows[t]["Ord_Number"].ToString().Trim() + "'  and Sfs_OrderNumberDeputy='" + dt.Rows[t]["Ordv_ViceNumber"].ToString().Trim() + "' and Sfs_Type=4 and Sfs_SurveySetID=11", " id asc");
                            if (dtleng.Length > 0)
                            {
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dtleng[0]["Sfs_RatingSetName"].ToString();
                                dgvr.Cells.Add(cell);

                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dtleng[0]["Sfs_CreateName"].ToString();
                                dgvr.Cells.Add(cell);

                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dtleng[0]["Sfs_CreateTime"].ToString();
                                dgvr.Cells.Add(cell);

                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dtleng[0]["Sfs_Remark"].ToString();
                                dgvr.Cells.Add(cell);
                            }
                            else
                            {
                                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

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["设计时间"].ToString().Trim() == "" ? "" : Convert.ToDateTime(dt.Rows[t]["设计时间"].ToString().Trim()).ToString("yyyy-MM-dd");
                            dgvr.Cells.Add(cell);

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["设计状态"].ToString().Trim() == "2" ? "OK" : "未设计";
                            dgvr.Cells.Add(cell);

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["设计师ID"].ToString().Trim();
                            dgvr.Cells.Add(cell);

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["设计师"].ToString().Trim();
                            dgvr.Cells.Add(cell);

                            #region 赋值
                            dtleng = dtSurvey.Select(" Sfs_OrderNumber='" + dt.Rows[t]["Ord_Number"].ToString().Trim() + "'  and Sfs_OrderNumberDeputy='" + dt.Rows[t]["Ordv_ViceNumber"].ToString().Trim() + "' and Sfs_Type=4 and Sfs_SurveySetID=12", " id asc");
                            if (dtleng.Length > 0)
                            {
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dtleng[0]["Sfs_RatingSetName"].ToString();
                                dgvr.Cells.Add(cell);

                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dtleng[0]["Sfs_CreateName"].ToString();
                                dgvr.Cells.Add(cell);

                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dtleng[0]["Sfs_CreateTime"].ToString();
                                dgvr.Cells.Add(cell);

                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dtleng[0]["Sfs_Remark"].ToString();
                                dgvr.Cells.Add(cell);
                            }
                            else
                            {
                                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.dgv5.Rows.Add(dgvr);
                            #endregion
                        }
                    }));
                }
            });
            try
            {
                this.ucPagerEx5.TbDataSource = dt;
                this.dgv5.ClearSelection();
            }
            catch
            { }
            return pageData.TotalCount;
        }
        #endregion

        #region 绑定近期取件
        /// <summary>
        /// 绑定近期取件
        /// </summary>
        public void BindPickup()
        {
            this.ucPagerEx6.PageCurrent = 1;
            this.ucPagerEx6.PageSize = LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.GetPageSize();
            this.ucPagerEx6.Bind();
        }
        /// <summary>
        /// 画分页
        /// </summary>
        /// <param name="e"></param>
        /// <returns></returns>
        private int ucPagerEx6_EventPaging(UCPager.EventPagingArg e)
        {
            LYFZ.UCPager.PageData pageData = new LYFZ.UCPager.PageData();
            this.dgv6.Rows.Clear();
            DataTable dt = new DataTable();
            StringBuilder sql = new StringBuilder();
            if (!string.IsNullOrEmpty(this.txtTimeStart.Text) && !string.IsNullOrEmpty(this.txtTimeEnd.Text))
            { sql.Append(PublicCodeClasses.GetDateTime("取件日期", this.txtTimeStart.Text, this.txtTimeEnd.Text, ConnectWord: "") + " and Ord_Class='1'"); }
            else
            { sql.Append(" "); }
            DataTable dtSurvey = sfsbll.Vw_ErpSatisfactionSurvey("").Tables[0];
            LYFZ.ComponentLibrary.FrmLoadHandling.LoadDoWorkMethod(delegate(object obj, BackgroundWorker backgroundWorker)
            {
                pageData.TableName = "Vw_OrdersWageDigital";
                pageData.PageIndex = this.ucPagerEx6.PageCurrent;
                pageData.PageSize = this.ucPagerEx6.PageSize;
                pageData.QueryCondition = sql.ToString();
                pageData.QueryFieldName = "Id,Ordv_Number,Ordv_ViceNumber,Ordv_DigitalNumber,Ord_Number,Ord_Type,Ord_Class,Ord_PhotographyCategory,Ord_SeriesName,Ord_SeriesPrice,拍摄名称,客户名称,客户电话,取件状态,取件日期";
                pageData.OrderStr = " ID desc ";
                dt = pageData.QueryDataTable().Tables[0];
                if (dt.Rows.Count > 0)
                {
                    this.Invoke(new UpdateControl(delegate()
                    {
                        for (int t = 0; t < dt.Rows.Count; t++)
                        {
                            #region
                            DataGridViewRow dgvr = new DataGridViewRow();
                            DataGridViewCell cell = null;

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["Ord_Number"].ToString().Trim();
                            dgvr.Cells.Add(cell);

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["Ordv_ViceNumber"].ToString().Trim();
                            dgvr.Cells.Add(cell);

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["Ord_Type"].ToString().Trim() == "0" ? "婚纱订单" : dt.Rows[t]["Ord_Type"].ToString().Trim() == "1" ? "儿童订单" : dt.Rows[t]["Ord_Type"].ToString().Trim() == "2" ? "写真订单" : dt.Rows[t]["Ord_Type"].ToString().Trim() == "3" ? "服务订单" : "其它消费";
                            dgvr.Cells.Add(cell);

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

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["客户电话"].ToString().Trim();
                            dgvr.Cells.Add(cell);

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

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["取件日期"].ToString().Trim() == "" ? "" : Convert.ToDateTime(dt.Rows[t]["取件日期"].ToString().Trim()).ToString("yyyy-MM-dd");
                            dgvr.Cells.Add(cell);

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["取件状态"].ToString().Trim();
                            dgvr.Cells.Add(cell);

                            #region 赋值产品满意度
                            DataRow[] dtleng = dtSurvey.Select(" Sfs_OrderNumber='" + dt.Rows[t]["Ord_Number"].ToString().Trim() + "'  and Sfs_OrderNumberDeputy='" + dt.Rows[t]["Ordv_ViceNumber"].ToString().Trim() + "' and Sfs_Type=5 and Sfs_SurveySetID=13", " id asc");
                            if (dtleng.Length > 0)
                            {
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dtleng[0]["Sfs_RatingSetName"].ToString();
                                dgvr.Cells.Add(cell);

                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dtleng[0]["Sfs_CreateName"].ToString();
                                dgvr.Cells.Add(cell);

                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dtleng[0]["Sfs_CreateTime"].ToString();
                                dgvr.Cells.Add(cell);

                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dtleng[0]["Sfs_Remark"].ToString();
                                dgvr.Cells.Add(cell);

                            }
                            else
                            {
                                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

                            #region 赋值进度满意度
                            dtleng = dtSurvey.Select(" Sfs_OrderNumber='" + dt.Rows[t]["Ord_Number"].ToString().Trim() + "'  and Sfs_OrderNumberDeputy='" + dt.Rows[t]["Ordv_ViceNumber"].ToString().Trim() + "' and Sfs_Type=5 and Sfs_SurveySetID=14", " id asc");
                            if (dtleng.Length > 0)
                            {
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dtleng[0]["Sfs_RatingSetName"].ToString();
                                dgvr.Cells.Add(cell);

                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dtleng[0]["Sfs_CreateName"].ToString();
                                dgvr.Cells.Add(cell);

                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dtleng[0]["Sfs_CreateTime"].ToString();
                                dgvr.Cells.Add(cell);

                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dtleng[0]["Sfs_Remark"].ToString();
                                dgvr.Cells.Add(cell);
                            }
                            else
                            {
                                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.dgv6.Rows.Add(dgvr);
                            #endregion
                        }
                    }));
                }
            });
            try
            {
                this.ucPagerEx6.TbDataSource = dt;
                this.dgv6.ClearSelection();
            }
            catch
            { }
            return pageData.TotalCount;
        }
        #endregion

        #region 绑定近期服务
        /// <summary>
        /// 绑定近期服务
        /// </summary>
        public void BindService()
        {
            this.ucPagerEx7.PageCurrent = 1;
            this.ucPagerEx7.PageSize = LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.GetPageSize();
            this.ucPagerEx7.Bind();
        }
        /// <summary>
        /// 画分页
        /// </summary>
        /// <param name="e"></param>
        /// <returns></returns>
        private int ucPagerEx7_EventPaging(UCPager.EventPagingArg e)
        {
            LYFZ.UCPager.PageData pageData = new LYFZ.UCPager.PageData();
            this.dgv7.Rows.Clear();
            DataTable dt = new DataTable();
            StringBuilder sql = new StringBuilder();
            if (!string.IsNullOrEmpty(this.txtTimeStart.Text) && !string.IsNullOrEmpty(this.txtTimeEnd.Text))
            { sql.Append(PublicCodeClasses.GetDateTime("Ws_WeddingDate", this.txtTimeStart.Text, this.txtTimeEnd.Text, ConnectWord: "") + " and Ws_Status='1'"); }
            else
            { sql.Append(" "); }
            DataTable dtSurvey = sfsbll.Vw_ErpSatisfactionSurvey("").Tables[0];
            LYFZ.ComponentLibrary.FrmLoadHandling.LoadDoWorkMethod(delegate(object obj, BackgroundWorker backgroundWorker)
            {
                pageData.TableName = "View_ErpWeddingService";
                pageData.PageIndex = this.ucPagerEx7.PageCurrent;
                pageData.PageSize = this.ucPagerEx7.PageSize;
                pageData.QueryCondition = sql.ToString();
                pageData.QueryFieldName = "ID,Ws_Number,Ws_Type,Ws_ProdNumber,Ws_ProdName,Ws_ProdCostPrice,Ws_ProdSoldPrice,Ws_ProdQuantity,Ws_WeddingDate,Ws_WeddingDateLunar,Ws_Serviceman1ID,Ws_Serviceman2ID,Ws_Serviceman1,Ws_Serviceman2,Ws_Status,Ws_Remark,Ws_WeddingDispatcher,Ws_WeddingDispatchDate,Ws_UpdateDateTime,Ws_UpdateName,客户名称,客户电话";
                pageData.OrderStr = " ID desc ";
                dt = pageData.QueryDataTable().Tables[0];
                if (dt.Rows.Count > 0)
                {
                    this.Invoke(new UpdateControl(delegate()
                    {
                        for (int t = 0; t < dt.Rows.Count; t++)
                        {
                            #region
                            DataGridViewRow dgvr = new DataGridViewRow();
                            DataGridViewCell cell = null;

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["Ws_Number"].ToString().Trim();
                            dgvr.Cells.Add(cell);

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

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["客户电话"].ToString().Trim();
                            dgvr.Cells.Add(cell);

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["Ws_ProdName"].ToString().Trim();
                            dgvr.Cells.Add(cell);

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["Ws_WeddingDate"].ToString().Trim() == "" ? "" : Convert.ToDateTime(dt.Rows[t]["Ws_WeddingDate"].ToString().Trim()).ToString("yyyy-MM-dd");
                            dgvr.Cells.Add(cell);

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["Ws_Status"].ToString().Trim() == "1" ? "OK" : "未完成";
                            dgvr.Cells.Add(cell);

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["Ws_Serviceman1"].ToString().Trim();
                            dgvr.Cells.Add(cell);

                            #region 赋值
                            DataRow[] dtleng = dtSurvey.Select(" Sfs_OrderNumber='" + dt.Rows[t]["Ws_Number"].ToString().Trim() + "'  and Sfs_Type=6 and Sfs_SurveySetID=15", " id asc");
                            if (dtleng.Length > 0)
                            {
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dtleng[0]["Sfs_RatingSetName"].ToString();
                                dgvr.Cells.Add(cell);

                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dtleng[0]["Sfs_CreateName"].ToString();
                                dgvr.Cells.Add(cell);

                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dtleng[0]["Sfs_CreateTime"].ToString();
                                dgvr.Cells.Add(cell);

                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dtleng[0]["Sfs_Remark"].ToString();
                                dgvr.Cells.Add(cell);
                            }
                            else
                            {
                                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

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["Ws_Serviceman2"].ToString().Trim();
                            dgvr.Cells.Add(cell);

                            #region 赋值
                            dtleng = dtSurvey.Select(" Sfs_OrderNumber='" + dt.Rows[t]["Ws_Number"].ToString().Trim() + "'  and Sfs_Type=6 and Sfs_SurveySetID=16", " id asc");
                            if (dtleng.Length > 0)
                            {
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dtleng[0]["Sfs_RatingSetName"].ToString();
                                dgvr.Cells.Add(cell);

                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dtleng[0]["Sfs_CreateName"].ToString();
                                dgvr.Cells.Add(cell);

                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dtleng[0]["Sfs_CreateTime"].ToString();
                                dgvr.Cells.Add(cell);

                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dtleng[0]["Sfs_Remark"].ToString();
                                dgvr.Cells.Add(cell);
                            }
                            else
                            {
                                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

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["Ws_Serviceman1ID"].ToString().Trim();
                            dgvr.Cells.Add(cell);

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["Ws_Serviceman2ID"].ToString().Trim();
                            dgvr.Cells.Add(cell);

                            this.dgv7.Rows.Add(dgvr);
                            #endregion
                        }
                    }));
                }
            });
            try
            {
                this.ucPagerEx7.TbDataSource = dt;
                this.dgv7.ClearSelection();
            }
            catch
            { }
            return pageData.TotalCount;
        }
        #endregion

        #region 绑定近期其它调查
        /// <summary>
        /// 绑定近期其它调查
        /// </summary>
        public void BindOtherSurveys()
        {
            this.ucPagerEx8.PageCurrent = 1;
            this.ucPagerEx8.PageSize = LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.GetPageSize();
            this.ucPagerEx8.Bind();
        }
        /// <summary>
        /// 画分页
        /// </summary>
        /// <param name="e"></param>
        /// <returns></returns>
        private int ucPagerEx8_EventPaging(UCPager.EventPagingArg e)
        {
            LYFZ.UCPager.PageData pageData = new LYFZ.UCPager.PageData();
            this.dgv8.Rows.Clear();
            DataTable dt = new DataTable();
            StringBuilder sql = new StringBuilder();
            if (!string.IsNullOrEmpty(this.txtTimeStart.Text) && !string.IsNullOrEmpty(this.txtTimeEnd.Text))
            { sql.Append(PublicCodeClasses.GetDateTime("Ord_CreateDatetime", this.txtTimeStart.Text, this.txtTimeEnd.Text, ConnectWord: "") + " and Ord_Class='1'"); }
            else
            { sql.Append(" "); }
            DataTable dtSurvey = sfsbll.Vw_ErpSatisfactionSurvey("").Tables[0];
            LYFZ.BLL.BLL_ErpSatisfactionSurveySet setbll = new BLL.BLL_ErpSatisfactionSurveySet();
            LYFZ.ComponentLibrary.FrmLoadHandling.LoadDoWorkMethod(delegate(object obj, BackgroundWorker backgroundWorker)
            {
                pageData.TableName = "Vw_Customer_PaymentOrders";
                pageData.PageIndex = this.ucPagerEx8.PageCurrent;
                pageData.PageSize = this.ucPagerEx8.PageSize;
                pageData.QueryCondition = sql.ToString();
                pageData.QueryFieldName = "ID,Ord_Number,Ord_DividedShop,Ord_Type,Ord_PhotographyCategory,Ord_SeriesName,Ord_SeriesPrice,Ord_Class,GP_OrderNumber,GP_CustomerGroupID,Cus_Name,Cus_Name_py,Cus_Telephone,Ord_OrdersPersonID,Ord_OrdersPerson,Ord_CreateDatetime,PickupStatusCount";
                pageData.OrderStr = " ID desc ";
                dt = pageData.QueryDataTable().Tables[0];
                if (dt.Rows.Count > 0)
                {
                    this.Invoke(new UpdateControl(delegate()
                    {
                        for (int t = 0; t < dt.Rows.Count; t++)
                        {
                            #region
                            DataGridViewRow dgvr = new DataGridViewRow();
                            DataGridViewCell cell = null;

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["Ord_Number"].ToString().Trim();
                            dgvr.Cells.Add(cell);

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["Ord_Type"].ToString().Trim() == "0" ? "婚纱订单" : dt.Rows[t]["Ord_Type"].ToString().Trim() == "1" ? "儿童订单" : dt.Rows[t]["Ord_Type"].ToString().Trim() == "2" ? "写真订单" : dt.Rows[t]["Ord_Type"].ToString().Trim() == "3" ? "服务订单" : "其它消费";
                            dgvr.Cells.Add(cell);

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["Cus_Name"].ToString().Trim();
                            dgvr.Cells.Add(cell);

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["Cus_Telephone"].ToString().Trim();
                            dgvr.Cells.Add(cell);

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = Convert.ToDateTime(dt.Rows[t]["Ord_CreateDatetime"].ToString().Trim()).ToString("yyyy-MM-dd");
                            dgvr.Cells.Add(cell);

                            DataTable dtSet = setbll.GetList("Sfss_Type=7", "id asc").Tables[0];
                            if (dtSet.Rows.Count > 0)
                            {
                                for (int y = 0; y < dtSet.Rows.Count; y++)
                                {
                                    #region 赋值
                                    DataRow[] dtleng = dtSurvey.Select(" Sfs_OrderNumber='" + dt.Rows[t]["Ord_Number"].ToString().Trim() + "'  and Sfs_Type=7 and Sfs_SurveySetID=" + dtSet.Rows[y]["ID"].ToString() + "", " id asc");
                                    if (dtleng.Length > 0)
                                    {
                                        cell = new DataGridViewTextBoxCell();
                                        cell.Value = dtleng[0]["Sfs_RatingSetName"].ToString();
                                        dgvr.Cells.Add(cell);

                                        cell = new DataGridViewTextBoxCell();
                                        cell.Value = dtleng[0]["Sfs_CreateName"].ToString();
                                        dgvr.Cells.Add(cell);

                                        cell = new DataGridViewTextBoxCell();
                                        cell.Value = dtleng[0]["Sfs_CreateTime"].ToString();
                                        dgvr.Cells.Add(cell);

                                        cell = new DataGridViewTextBoxCell();
                                        cell.Value = dtleng[0]["Sfs_Remark"].ToString();
                                        dgvr.Cells.Add(cell);
                                    }
                                    else
                                    {
                                        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.dgv8.Rows.Add(dgvr);
                            #endregion
                        }
                    }));
                }
            });
            try
            {
                this.ucPagerEx8.TbDataSource = dt;
                this.dgv8.ClearSelection();
            }
            catch
            { }
            return pageData.TotalCount;
        }
        #endregion
        #endregion
    }
}