lyfz_repos/铂金版源码/LYFZ.Software.MainBusiness/DoorCityProcess/DigitalArrangeFormMain.cs

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

namespace LYFZ.Software.MainBusiness.DoorCityProcess
{
    public partial class DigitalArrangeFormMain : LYFZ.Software.UI.DoorCityProcess.DigitalArrangeFormMain
    {
        public DigitalArrangeFormMain()
        {
            this.Shown += DigitalArrangeFormMain_Shown;
            this.Load += DigitalArrangeFormMain_Load;
            this.cmbQueryText.KeyDown += cmbQueryText_KeyDown;
            this.btnQuery.Click += btnQuery_Click;
            this.btnConditionQuery.Click += btnConditionQuery_Click;
            this.btnAnPaiWork.Click += btnAnPaiWork_Click;
            this.btnViewAnPai.Click += btnViewAnPai_Click;
            this.btnIWork.Click += btnIWork_Click;
            this.btnClose.Click += btnClose_Click;
            this.chkDressVersion.Click += chkDressVersion_Click;
            this.chkKidsVersion.Click += chkKidsVersion_Click;
            this.chkPortraitVersion.Click += chkPortraitVersion_Click;
            this.chkShowCompleteOrder.Click += chkShowCompleteOrder_Click;
            this.Resize += DigitalArrangeFormMain_Resize;
            this.cmbtreevStoreName.ComboBoxTree_NodeMouseClick += cmbtreevStoreName_ComboBoxTree_NodeMouseClick;
            this.dgvData.ColumnHeaderMouseClick += dgvData_ColumnHeaderMouseClick;
            this.dgvData.CellMouseDown += dgvData_CellMouseDown;
            this.dgvData.CellClick += dgvData_CellClick;
            this.dgvData.CellMouseDoubleClick += dgvData_CellMouseDoubleClick;
            this.dgvData.MouseDoubleClick += dgvData_MouseDoubleClick;
            this.flowLayoutPanel1.Height = 34;
            this.ucPagerEx1.EventPaging += ucPagerEx1_EventPaging;
        }
        int ucPagerEx1_EventPaging(UCPager.EventPagingArg e)
        {
            //pageData.PageSize = LYFZ.BLL.BLL_SystemGlobalSetting.SysTemGlobalSetMoel.ReportFormPageSize;
            this.ucPagerEx1.PageSize = LYFZ.BLL.BLL_SystemGlobalSetting.SysTemGlobalSetMoel.ReportFormPageSize;

            PublicFunctionRows();

            return ucPagerEx1.NMax;
        }

        public void BindPageData(int pageIndx, int pageSize, int totalCount)
        {
            ucPagerEx1.NMax = totalCount;
            ucPagerEx1.CurrentPageCount = (pageSize);
            ucPagerEx1.PageCurrent = pageIndx;

        }

        /// <summary>
        /// 是否首次运行
        /// </summary>
        bool IsFirstRun = true;
        /// <summary>
        /// 查询条件
        /// </summary>
        private Dictionary<string, string> DictData = new Dictionary<string, string>();
        /// <summary>
        /// 员工编号
        /// </summary>
        string StrUserID = LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.LoginUserModel.User_EmployeeID;
        /// <summary>
        /// 窗体加载事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void DigitalArrangeFormMain_Shown(object sender, EventArgs e)
        {
            LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.BindGroupStoreName(this.cmbtreevStoreName, StrGroupKeyCode: "retailProcess", StrKeyCode: "st014");
            this.PublicFunctionRights();
            //this.PublicFunctionRows();
            
            this.ucPagerEx1.PageCurrent = 1;
            this.ucPagerEx1.Bind();
            this.IsFirstRun = false;
            this.DigitalArrangeFormMain_Resize(this, null);

            //数码安排版本权限
            bool b = LYFZ.Software.MainBusiness.VersionControl.StaticVersion.UIFunctionVersion(
                VersionControl.VersionFunctionEnum.订单数码安排数码安排);
            if(!b)
            {
                this.Close();
            }
        }
        /// <summary>
        /// 窗体加载事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void DigitalArrangeFormMain_Load(object sender, EventArgs e)
        {
            LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.GetSystemVersion(this.chkPortraitVersion, this.chkDressVersion, this.chkKidsVersion);
        }
        /// <summary>
        /// 选择分店获取权限
        /// </summary>
        void PublicFunctionRights()
        {
            this.btnAnPaiWork.Enabled = LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.GetGroupStoreRights(this.cmbtreevStoreName, "StoresDigital", LYFZ.CustomAttributes.OperatingAuthority.AnPaiWork);
            this.btnViewAnPai.Enabled = LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.GetGroupStoreRights(this.cmbtreevStoreName, "StoresDigital", LYFZ.CustomAttributes.OperatingAuthority.SeeAnPaiWork);
        }
        /// <summary>
        /// 分店选择查询数据
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void cmbtreevStoreName_ComboBoxTree_NodeMouseClick(object sender, TreeNodeMouseClickEventArgs e)
        {
            this.PublicFunctionRights();
            //this.PublicFunctionRows();
            this.ucPagerEx1.PageCurrent = 1;
            this.ucPagerEx1.Bind();
        }
        /// <summary>
        /// 回车
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void cmbQueryText_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
            { this.btnQuery_Click(this, null); }
        }
        /// <summary>
        /// 查询
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void btnQuery_Click(object sender, EventArgs e)
        {
            this.DictData.Clear();
            //this.PublicFunctionRows();
            this.ucPagerEx1.PageCurrent = 1;
            this.ucPagerEx1.Bind();
        }
        /// <summary>
        /// 条件查询
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void btnConditionQuery_Click(object sender, EventArgs e)
        {
            LYFZ.Software.MainBusiness.DoorCityProcess.SetSmallForm.ConditionQueryDigitalSamllForm frm = new SetSmallForm.ConditionQueryDigitalSamllForm();
            frm.ShowDialog();
            if (frm.DictDataArray.Count > 0)
            {
                this.DictData = frm.DictDataArray;
                //this.PublicFunctionRows();
                this.ucPagerEx1.PageCurrent = 1;
                this.ucPagerEx1.Bind();
            }
        }
        /// <summary>
        /// 安排工作
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void btnAnPaiWork_Click(object sender, EventArgs e)
        {
            if (this.dgvData.Rows.Count > 0)
            {
                if (dgvData.SelectedRows.Count > 0)
                {
                    try
                    {
                        if (this.dgvData.CurrentRow.Cells["拍摄状态"].Value.ToString().Trim() != "OK")
                        { MessageBoxCustom.Show("拍照流程未完成"); return; }
                    }
                    catch { }
                    string strVid = "";
                    for (int i = 0; i < dgvData.SelectedRows.Count; i++)
                    {
                        if (i == 0) { strVid += "'" + dgvData.SelectedRows[i].Cells["Ordv_ViceNumber"].Value.ToString().Trim() + "'"; }
                        else
                        { strVid += ",'" + dgvData.SelectedRows[i].Cells["Ordv_ViceNumber"].Value.ToString().Trim() + "'"; }
                    }
                    LYFZ.Software.MainBusiness.DoorCityProcess.SetSmallForm.AnPaiWorkSmallForm frm = new SetSmallForm.AnPaiWorkSmallForm();
                    frm.StrViceNumber = strVid;
                    frm.ShowDialog();
                    if (frm.IsSave == true)
                    {
                        //this.PublicFunctionRows();
                        this.ucPagerEx1.PageCurrent = 1;
                        this.ucPagerEx1.Bind();
                    }
                }
                else { MessageBoxCustom.Show("请选择订单"); }
            }
        }
        /// <summary>
        /// 查看安排
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void btnViewAnPai_Click(object sender, EventArgs e)
        {
            LYFZ.Software.MainBusiness.DoorCityProcess.SetSmallForm.AnPaiWorkDigitalSmallForm frm = new SetSmallForm.AnPaiWorkDigitalSmallForm();
            frm.Text = "数码部工作安排";
            frm.ShowDialog();
        }
        /// <summary>
        /// 我的工作
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void btnIWork_Click(object sender, EventArgs e)
        {
            LYFZ.Software.MainBusiness.DoorCityProcess.SetSmallForm.AnPaiWorkDigitalSmallForm frm = new SetSmallForm.AnPaiWorkDigitalSmallForm();
            frm.Text = "我的工作";
            frm.ShowDialog();
        }
        /// <summary>
        /// 关闭
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void btnClose_Click(object sender, EventArgs e)
        { this.Close(); }
        /// <summary>
        /// 数据列表列双击事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void dgvData_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
        {
            if (this.dgvData.Rows.Count > 0)
            {
                if (e.RowIndex != -1 && e.ColumnIndex != -1)
                {
                    if (LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.GetGroupStoreRights(this.cmbtreevStoreName, "StoresDigital", LYFZ.CustomAttributes.OperatingAuthority.AnPaiWork))
                    { this.btnAnPaiWork_Click(null, null); }
                }
            }
        }
        /// <summary>
        /// 儿童版
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void chkKidsVersion_Click(object sender, EventArgs e)
        {
            if (this.chkKidsVersion.Checked)
            { this.chkPortraitVersion.Checked = false; this.chkKidsVersion.Checked = true; this.chkDressVersion.Checked = false; }
            this.cmbQueryText.Text = "";
            //this.PublicFunctionRows();
            this.ucPagerEx1.PageCurrent = 1;
            this.ucPagerEx1.Bind();
        }
        /// <summary>
        /// 婚纱版
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void chkDressVersion_Click(object sender, EventArgs e)
        {
            if (this.chkDressVersion.Checked)
            { this.chkPortraitVersion.Checked = false; this.chkDressVersion.Checked = true; this.chkKidsVersion.Checked = false; }
            this.cmbQueryText.Text = "";
            //this.PublicFunctionRows();
            this.ucPagerEx1.PageCurrent = 1;
            this.ucPagerEx1.Bind();
        }
        /// <summary>
        /// 写真版
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void chkPortraitVersion_Click(object sender, EventArgs e)
        {
            if (this.chkPortraitVersion.Checked)
            { this.chkPortraitVersion.Checked = true; this.chkDressVersion.Checked = false; this.chkKidsVersion.Checked = false; }
            this.cmbQueryText.Text = "";
            //this.PublicFunctionRows();
            this.ucPagerEx1.PageCurrent = 1;
            this.ucPagerEx1.Bind();
        }
        /// <summary>
        /// 完成订单
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void chkShowCompleteOrder_Click(object sender, EventArgs e)
        {
            //this.PublicFunctionRows();
            this.ucPagerEx1.PageCurrent = 1;
            this.ucPagerEx1.Bind();
        }
        /// <summary>
        /// 窗体大小发生改变事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void DigitalArrangeFormMain_Resize(object sender, EventArgs e)
        {
            if (!this.IsFirstRun)
            {
                switch (this.chkShowCompleteOrder.Location.Y)
                {
                    case 4: this.flowLayoutPanel1.Height = 36; break;
                    case 36: this.flowLayoutPanel1.Height = 68; break;
                }
            }
        }
        /// <summary>
        /// 右键菜单
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void dgvData_CellMouseDown(object sender, DataGridViewCellMouseEventArgs e)
        {
            if (e.Button == MouseButtons.Right)
            {
                if (e.RowIndex >= 0 && e.ColumnIndex >= 0)
                {
                    ToolStripMenuItem item = new ToolStripMenuItem();
                    Hashtable htData = new Hashtable();
                    htData["StrNumber"] = this.dgvData.Rows[e.RowIndex].Cells["Ord_Number"].Value.ToString().Trim();
                    htData["StrViceNumber"] = this.dgvData.Rows[e.RowIndex].Cells["Ordv_ViceNumber"].Value.ToString().Trim();
                    item.Text = "订单备注";
                    item.Tag = htData;
                    item.Name = "OrderRemark";
                    this.dgvData.conMenu.Items.Add(item);

                   // this.dgvData.conMenu.Show(MousePosition.X, MousePosition.Y);//弹出操作菜单
                    this.dgvData.conMenu.ItemClicked -= dgvData_DataGridViewConMenu_ItemClicked;
                    this.dgvData.conMenu.ItemClicked += dgvData_DataGridViewConMenu_ItemClicked;
                    // this.dgvData.conMenu.Show();
                    if (!this.dgvData.conMenu.Visible)
                    {
                        this.dgvData.conMenu.Show(MousePosition.X, MousePosition.Y);//弹出操作菜单
                    }
                }
                else
                {
                    this.dgvData.conMenu.Items.Clear();
                    ToolStripMenuItem item = new ToolStripMenuItem();
                    item.Text = "设置标题";
                    item.Tag = "SetColumnShow";
                    item.Name = "SetColumnShow";
                    this.dgvData.conMenu.Items.Add(item);

                   // this.dgvData.conMenu.Show(MousePosition.X, MousePosition.Y);//弹出操作菜单
                    this.dgvData.conMenu.ItemClicked -= dgvData_DataGridViewConMenu_ItemClicked;
                    this.dgvData.conMenu.ItemClicked += dgvData_DataGridViewConMenu_ItemClicked;
                    //this.dgvData.conMenu.Show();
                    if (!this.dgvData.conMenu.Visible)
                    {
                        this.dgvData.conMenu.Show(MousePosition.X, MousePosition.Y);//弹出操作菜单
                    }
                }
            }
        }
        /// <summary>
        /// 列表单击事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void dgvData_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            try
            {
                string StrNumber = this.dgvData.CurrentRow.Cells["订单号"].Value.ToString().Trim();
                if (string.IsNullOrEmpty(StrNumber) || StrNumber.Trim() == "(取件OK)")
                {
                    bool IsFind = false;
                    int i = this.dgvData.CurrentRow.Index;
                    while (!IsFind)
                    {
                        i = i - 1;
                        if (!string.IsNullOrEmpty(this.dgvData.Rows[i].Cells["订单号"].Value.ToString().Trim()))
                        { StrNumber = this.dgvData.Rows[i].Cells["订单号"].Value.ToString().Trim(); IsFind = true; }
                    }
                }
                LYFZ.BLL.BLL_ErpOrder.CurrentSelectedOrderNumber = StrNumber;
            }
            catch
            { }
        }
        /// <summary>
        /// 对列表控件双击事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void dgvData_MouseDoubleClick(object sender, MouseEventArgs e)
        {
            Point hit = this.dgvData.PointToClient(Cursor.Position);
            DataGridView.HitTestInfo hitTest = this.dgvData.HitTest(hit.X, hit.Y);
            if (hitTest.RowIndex < 0 && hitTest.ColumnIndex < 0)
            {
                if (!string.IsNullOrEmpty(this.cmbQueryText.Text.Trim()))
                {
                    LYFZ.BLL.BLL_ErpOrder.CurrentSelectedOrderNumber = "";
                    this.cmbQueryText.Text = "";
                    //this.PublicFunctionRows();
                    this.ucPagerEx1.PageCurrent = 1;
                    this.ucPagerEx1.Bind();
                }
            }
        }
        /// <summary>
        /// 右键菜单选择项事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void dgvData_DataGridViewConMenu_ItemClicked(object sender, ToolStripItemClickedEventArgs e)
        {
            ToolStripItem item = e.ClickedItem;
            if (item.Name.Trim() == "SetColumnShow")
            {
                if (LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.ShowDataGridViewSetColumn(this.dgvData))
                {
                    //this.PublicFunctionRows();
                    this.ucPagerEx1.PageCurrent = 1;
                    this.ucPagerEx1.Bind();
                }
            }
            else if (item.Name.ToString().Trim() == "OrderRemark")
            {
                Hashtable htData = (Hashtable)item.Tag;
                LYFZ.Software.MainBusiness.DoorCityProcess.SuperSmallForm.OrderRemarkRecordAddSuperSmallForm frm = new SuperSmallForm.OrderRemarkRecordAddSuperSmallForm();
                frm.StrOrderNumber = htData["StrNumber"].ToString().Trim();
                frm.StrOrdViceNumber = htData["StrViceNumber"].ToString().Trim();
                frm.StrOrdModuleName = LYFZ.EnumPublic.EnumOrderRemarkModule.数码安排.ToString().Trim();
                frm.ShowDialog();
            }
        }
        /// <summary>
        /// 点击列标头排序
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void dgvData_ColumnHeaderMouseClick(object sender, DataGridViewCellMouseEventArgs e)
        {
            if (e.Button == MouseButtons.Left)
            {
                string StrColumnName = GetOrderByName(this.dgvData.Columns[e.ColumnIndex].Name.Trim());
                if (StrColumnName == this.StrCurrentClickField || string.IsNullOrEmpty(this.StrCurrentClickField))
                {
                    if (this.StrSortOrder == "ASC")
                    { this.StrSortOrder = "DESC"; }
                    else
                    { this.StrSortOrder = "ASC"; }
                }
                else
                { this.StrSortOrder = "DESC"; }

                if (this.dgvData.StrValueNullColumn.Trim().IndexOf(StrColumnName) == -1 || StrColumnName.Trim() == "欠款" || StrColumnName.Trim() == "套系金额")
                { this.StrSortField = StrColumnName + " " + this.StrSortOrder + ",Ord_CreateDateTime,Ordv_DigitalNumber"; }
                else
                { this.StrSortField = "Ord_CreateDateTime " + this.StrSortOrder + ",Ordv_DigitalNumber"; }
                this.StrCurrentClickField = StrColumnName;
                //this.PublicFunctionRows();
                this.ucPagerEx1.PageCurrent = 1;
                this.ucPagerEx1.Bind();
            }
        }
        string GetOrderByName(string StrColumnName)
        {
            switch (StrColumnName)
            {
                case "订单号": return "Ord_SinceOrderNumber";
                case "客户姓名": return "Cus_Name";
                case "客户性别": return "Cus_Sex_cs";
                case "客户电话": return "Cus_Telephone";
                case "订单类型": return "Ord_Type";
                case "接单人": return "Ord_OrderPersonName";
                case "套系名称": return "Ord_SeriesName";
                case "套系价格": return "Ord_SeriesPrice";
                case "加急": return "IsExpedited";
                case "加急日期": return "ExpeditedTime";
                case "拍摄名称": return "Ordpg_Sights";
                case "初修状态": return "Ordv_EarlyRepairStatus";
                case "选片状态": return "Ordv_FilmSelectionStatus";
                case "精修状态": return "Ordv_RefinementStatus";
                case "精修日期": return "Ordv_RefinementTime";
                case "设计状态": return "Ordv_DesignerStatus";
                case "设计师": return "Ordv_DesignerName";
                case "设计日期": return "Ordv_DesignerTime";
                case "看版师": return "Ordv_LookDesignName";
                case "看版日期": return "Ordv_LookDesignTime";
                case "看版状态": return "Ordv_LookDesignStatus";
                case "看版要求": return "Ordv_LookDesignClaim";
                case "取件状态": return "Ords_ProductPickupIntStatus";
                case "会员卡号": return "Mc_CradNumber";
                case "拍照状态": return "Ordpg_PhotographyStatus";
                case "选片时间": return "Ordv_FilmSelectionTime";
                case "拍摄时间": return "Ordpg_PhotographyTime";
                case "是否完成": return "Ords_ProductCompletedIntStatus";
                case "商品名称": return "OPlist_ProdName";
                case "预约取件日期": return "OPlist_ReservationTakeTime";
                case "商品取走日期": return "OPlist_PickupTime";
                case "是否发出": return "OPlist_SendVendor";
                case "商品完成状态": return "OPlist_CompletedStatus";
                case "是否取走": return "OPlist_PickupStatus";
                default: return "";
            }
        }
        /// <summary>
        /// 当前点击的字段
        /// </summary>
        string StrCurrentClickField = "";
        /// <summary>
        /// 排序字段
        /// </summary>
        string StrSortField = "Ord_CreateDateTime DESC,Ordv_DigitalNumber";
        /// <summary>
        /// 排序顺序
        /// </summary>
        string StrSortOrder = "DESC";
        /// <summary>
        /// 创建行
        /// </summary>
        void PublicFunctionRows()
        {
            this.dgvData.dgvCurrentColumnOriginalSet = "Ord_Number,Ordv_ViceNumber,订单号,客户姓名,客户性别,客户电话,婚期,订单类型,接单人,套系名称,套系价格,加急,加急日期,拍摄名称,拍照状态,初修状态,初修日期,选片状态,选片日期,精修状态,精修日期,设计状态,设计日期,看版状态,看版日期,取件状态,会员卡号";
            string StrGuidName = LYFZ.EnumPublic.dgvGuidName.E_FormAll_A0009.ToString().Trim();
            if ((LYFZ.BLL.BLL_SystemGlobalSetting.SysTemGlobalSetMoel.MemberCardShowHide))
            {
                this.dgvData.dgvFixedHideColumn = "Ord_Number,Ordv_ViceNumber,会员卡号";
            }
            else
            {
                this.dgvData.dgvFixedHideColumn = "Ord_Number,Ordv_ViceNumber";
            }
            
            this.dgvData.dgvGuidName = StrGuidName;
            this.dgvData.dgvUserEmployeeID = this.StrUserID;
            this.dgvData.StrValueNullColumn = "订单号,客户姓名,客户性别,客户电话,婚期,订单类型,接单人,套系名称,套系价格,加急,加急日期,会员卡号";
            this.dgvData.DataColumns(this.dgvData.dgvCurrentColumnOriginalSet, strHideField: this.dgvData.dgvFixedHideColumn);
            Dictionary<string, string> dictColumns = LYFZ.DAL.DAL_GridViewDisplayIndex.GetGridViewShowColumns(this.StrUserID, StrGuidName, this.dgvData.dgvCurrentColumnOriginalSet);
            this.dgvData.dictShowColumName = dictColumns;
            string StrQueryCondition = "";
            if (IsFirstRun && !string.IsNullOrEmpty(LYFZ.BLL.BLL_ErpOrder.CurrentSelectedOrderNumber))
            {
                string StrWhere = " Where (Ordpg_PhotographyStatus in (1,2) or Ordv_EarlyRepairStatus in ('1','2')) And Ord_Class = '1' And Ord_SinceOrderNumber = '" + LYFZ.BLL.BLL_ErpOrder.CurrentSelectedOrderNumber + "'" + LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.GetVersionQuerySQL(this.chkPortraitVersion, this.chkDressVersion, this.chkKidsVersion, StrOrdType: "0,1,2");
                this.cmbQueryText.Text = LYFZ.BLL.BLL_ErpOrder.CurrentSelectedOrderNumber;
                StrQueryCondition = StrWhere + LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.GetGroupQueryOrderClickWhere(this.cmbtreevStoreName, "Ord_DividedShop");
            }
            else
            { StrQueryCondition = this.GetWhereStr(); }
            int intTopCount = LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.GetPageSize();
            Hashtable htData = LYFZ.ComponentLibrary.DataGridOrderView.GetData_OrderDigitalArrange(this.dgvData, dictColumns, StrQueryCondition, intTopCount, this.StrSortField, ucPagerEx1.PageCurrent);
            this.dataGridViewStatisticsCount1.LocationX = this.dgvData.RowHeadersWidth;
            this.dataGridViewStatisticsCount1.CurrenQuantity = Convert.ToInt32(htData["CurrentCount"]);
            this.dataGridViewStatisticsCount1.TotalQuantity = Convert.ToInt32(htData["TotalCount"]);

            BindPageData(ucPagerEx1.PageCurrent, Convert.ToInt32(htData["CurrentCount"]), Convert.ToInt32(htData["TotalCount"]));
        }
        /// <summary>
        /// 返回要操作的条件
        /// </summary>
        /// <returns></returns>
        string GetWhereStr()
        {
            string StrWhere = " Where (Ordpg_PhotographyStatus in (1,2) or Ordv_EarlyRepairStatus in ('1','2')) And Ord_Class = '1' " + LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.GetGroupQueryWhere(this.cmbtreevStoreName, "Ord_DividedShop");
            if (this.cmbQueryText.Text.Trim().Length > 0)
            { StrWhere += LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.GetQueryTextQueryCondition(this.cmbQueryText.Text.Trim()); }
            else
            {
                if (DictData.ContainsKey("PhotographyStatus") && DictData["PhotographyStatus"].Trim().Length > 0)
                { StrWhere += " and Ordpg_PhotographyStatus = '" + DictData["PhotographyStatus"].Trim() + "'"; }
                if (DictData.ContainsKey("EarlyRepairStatus") && DictData["EarlyRepairStatus"].Trim().Length > 0)
                { StrWhere += " and Ordv_EarlyRepairStatus = '" + DictData["EarlyRepairStatus"].Trim() + "'"; }
                if (DictData.ContainsKey("FilmSelectionStatus") && DictData["FilmSelectionStatus"].Trim().Length > 0)
                { StrWhere += " and Ordv_FilmSelectionStatus = '" + DictData["FilmSelectionStatus"].Trim() + "'"; }
                if (DictData.ContainsKey("RefinementStatus") && DictData["RefinementStatus"].Trim().Length > 0)
                { StrWhere += " and Ordv_RefinementStatus = '" + DictData["RefinementStatus"].Trim() + "'"; }
                if (DictData.ContainsKey("DesignStatus") && DictData["DesignStatus"].Trim().Length > 0)
                { StrWhere += " and Ordv_DesignerStatus = '" + DictData["DesignStatus"].Trim() + "'"; }
                if (DictData.ContainsKey("LookDesignStatus") && DictData["LookDesignStatus"].Trim().Length > 0)
                { StrWhere += " and Ordv_LookDesignStatus = '" + DictData["LookDesignStatus"].Trim() + "'"; }
                if (this.chkShowCompleteOrder.Checked)
                { StrWhere += " And Ords_ProductPickupIntStatus = 2"; }
                else
                { StrWhere += " And Ords_ProductPickupIntStatus in (0,1)"; }
                StrWhere += LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.GetVersionQuerySQL(this.chkPortraitVersion, this.chkDressVersion, this.chkKidsVersion, StrOrdType: "0,1,2");

                if (DictData.ContainsKey("FilmSelectionStartDateTime") && DictData["FilmSelectionStartDateTime"].Length > 0 && DictData.ContainsKey("FilmSelectionEndDateTime") && DictData["FilmSelectionEndDateTime"].Length > 0)
                { StrWhere += LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.GetDateTime("isnull(Ordv_FilmSelectionTime,Ordv_ReservationFilmSelectionTime)", DictData["FilmSelectionStartDateTime"], DictData["FilmSelectionEndDateTime"]); }
                if (DictData.ContainsKey("LookDesignStartDateTime") && DictData["LookDesignStartDateTime"].Length > 0 && DictData.ContainsKey("LookDesignEndDateTime") && DictData["LookDesignEndDateTime"].Length > 0)
                { StrWhere += LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.GetDateTime("isnull(Ordv_LookDesignTime,Ordv_ReservationLookDesignTime)", DictData["LookDesignStartDateTime"].Trim(), DictData["LookDesignEndDateTime"].Trim()); }
            }
            return StrWhere;
        }
    }
}