lyfz_repos/铂金版源码/LYFZ.Software.MainBusiness/DoorCityProcess/PhotosPrintsFormMain.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 PhotosPrintsFormMain : LYFZ.Software.UI.DoorCityProcess.PhotosPrintsFormMain
    {
        LYFZ.BLL.BLL_ErpOrder orbll = new BLL.BLL_ErpOrder();
        public PhotosPrintsFormMain()
        {
            this.Shown += PhotosPrintsFormMain_Shown;
            this.Load += PhotosPrintsFormMain_Load;
            this.cmbtreevStoreName.ComboBoxTree_NodeMouseClick += cmbtreevStoreName_ComboBoxTree_NodeMouseClick;
            this.cmbQueryText.KeyDown += cmbQueryText_KeyDown;
            this.btnQuery.Click += btnQuery_Click;
            this.btnPhotoPrints.Click += btnPhotoPrints_Click;
            this.btnPhotofinishingMonth.Click += btnPhotofinishingMonth_Click;
            this.btnClose.Click += btnClose_Click;
            this.chkDressVersion.Click += chkDressVersion_Click;
            this.chkKidsVersion.Click += chkKidsVersion_Click;
            this.chkPortraitVersion.Click += chkPortraitVersion_Click;
            this.Resize += PhotosPrintsFormMain_Resize;
            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.btnReworkStatistics.Click += btnReworkStatistics_Click;
            this.flowLayoutPanel1.Height = 34;
            ///设计为冲印相片
            this.cbx_DesignNotPrint.Click += btnDesignNotPrint_Click;
            this.ucPagerEx1.EventPaging += ucPagerEx1_EventPaging;
            this.chkCompleteOrder.Click += ChkCompleteOrder_Click;
        }

        private void ChkCompleteOrder_Click(object sender, EventArgs e)
        {
            this.ucPagerEx1.PageCurrent = 1;
            this.ucPagerEx1.Bind();
        }

        int ucPagerEx1_EventPaging(UCPager.EventPagingArg e)
        {
            //pageData.PageSize = LYFZ.BLL.BLL_SystemGlobalSetting.SysTemGlobalSetMoel.ReportFormPageSize;
            this.ucPagerEx1.PageSize = LYFZ.BLL.BLL_SystemGlobalSetting.SysTemGlobalSetMoel.ReportFormPageSize;

            //PublicFunctionRows();
            if (cbx_DesignNotPrint.Checked)
            {
                PublicFunctionRows(" Ordv_DesignerStatus=2 and Opps_PhotoName is null ");
            }
            else
            {
                PublicFunctionRows();
            }
            
            return ucPagerEx1.NMax;
        }

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

        }

        void btnDesignNotPrint_Click(object sender, EventArgs e)
        {
            //if (cbx_DesignNotPrint.Checked)
            //{
            //    PublicFunctionRows(" Ordv_DesignerStatus=2 and Opps_PhotoName is null ");
            //}
            //else
            //{
            //    PublicFunctionRows();

            //}
            this.ucPagerEx1.PageCurrent = 1;
            this.ucPagerEx1.Bind();
        }

        /// <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 PhotosPrintsFormMain_Shown(object sender, EventArgs e)
        {
            LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.BindGroupStoreName(this.cmbtreevStoreName, StrGroupKeyCode: "retailProcess", StrKeyCode: "st012");
            this.PublicFunctionRights();
            //this.PublicFunctionRows();
            this.PhotosPrintsFormMain_Resize(this, null);
            
            this.ucPagerEx1.Bind();
            this.IsFirstRun = false;
            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 PhotosPrintsFormMain_Load(object sender, EventArgs e)
        {
            LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.GetSystemVersion(this.chkPortraitVersion, this.chkDressVersion, this.chkKidsVersion);
        }
        /// <summary>
        /// 选择分店获取权限
        /// </summary>
        void PublicFunctionRights()
        {
            this.btnPhotofinishingMonth.Enabled = LYFZ.BLL.BLL_ErpUser.GetRights(LYFZ.BLL.BLL_ErpUser.CurrentUserRights.StoresPhotosPrints, LYFZ.CustomAttributes.OperatingAuthority.PhotosPrints);
        }
        /// <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 btnReworkStatistics_Click(object sender, EventArgs e)
        {
            LYFZ.Software.MainBusiness.DoorCityProcess.SetSmallForm.PhotofinishingReworkStatisticSmallForm frm = new SetSmallForm.PhotofinishingReworkStatisticSmallForm();
            frm.StartPosition = System.Windows.Forms.FormStartPosition.Manual;
            frm.Location = new Point(LYFZ.EnumPublic.FormLocation_X, LYFZ.EnumPublic.FormLocation_Y);
            frm.Size = new Size(LYFZ.EnumPublic.FormSize_Width, LYFZ.EnumPublic.FormSize_Height);
            frm.ShowDialog();
        }
        /// <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.BLL.BLL_ErpUser.GetRights(LYFZ.BLL.BLL_ErpUser.CurrentUserRights.StoresPhotosPrints, LYFZ.CustomAttributes.OperatingAuthority.PhotosPrints))
                    { this.btnPhotoPrints_Click(null, null); }
                }
            }
        }
        /// <summary>
        /// 相片冲印资料
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void btnPhotoPrints_Click(object sender, EventArgs e)
        {
            if (this.dgvData.Rows.Count > 0)
            {
                if (this.dgvData.SelectedRows.Count > 0)
                {
                    string ViceName = "";
                    if (this.dgvData.CurrentRow.Cells["Ord_Type"].Value.ToString().Trim() == Convert.ToInt32(LYFZ.EnumPublic.OrderType.儿童订单).ToString().Trim())
                    {
                        try { ViceName = this.dgvData.CurrentRow.Cells["拍摄名称"].Value.ToString().Trim(); }
                        catch { }
                    }
                    LYFZ.Software.MainBusiness.DoorCityProcess.SetSmallForm.PhotofinishingManageSmallForm frm = new SetSmallForm.PhotofinishingManageSmallForm();
                    Dictionary<string, string> DictDataArray = new Dictionary<string, string>();
                    frm.EntViceNumber = this.dgvData.Rows[this.dgvData.CurrentRow.Index].Cells["Ordv_ViceNumber"].Value.ToString().Trim();
                    frm.EntOrdNumber = this.dgvData.Rows[this.dgvData.CurrentRow.Index].Cells["Ord_Number"].Value.ToString().Trim();
                    frm.StrSightsName = ViceName;
                    frm.ShowDialog();
                    if (frm.IsSaveed)
                    {
                        //this.PublicFunctionRows();
                        this.ucPagerEx1.PageCurrent = 1;
                        this.ucPagerEx1.Bind();
                    }
                }
                else { MessageBoxCustom.Show("请选择订单"); return; }
            }
        }
        /// <summary>
        /// 本月冲印
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void btnPhotofinishingMonth_Click(object sender, EventArgs e)
        {
            LYFZ.Software.MainBusiness.DoorCityProcess.SetSmallForm.PhotofinishingMonthSmallForm frm = new SetSmallForm.PhotofinishingMonthSmallForm();
            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 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 PhotosPrintsFormMain_Resize(object sender, EventArgs e)
        {
            if (!this.IsFirstRun)
            {
                switch (this.panelPortraitVersion.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,tb_ErpOrderPhotoPrints.ID"; }
                else
                { this.StrSortField = "Ord_CreateDateTime " + this.StrSortOrder + ",Ordv_DigitalNumber,tb_ErpOrderPhotoPrints.ID"; }
                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 "Ordpg_PhotographyStatus";
                case "初修师": return "Ordv_EarlyRepairName";
                case "初修日期": return "Ordv_EarlyRepairTime";
                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 "Opps_PhotoName";
                case "数量": return "Opps_PhotoQuantity";
                case "面积": return "Opps_PhotoArea";
                case "发出状态": return "Opps_SendVendor";
                case "发出日期": return "Opps_SendTime";
                case "返工状态": return "Opps_ReworkStatus";
                case "返工日期": return "Opps_ReworkTime";
                case "完成状态": return "Opps_CompletedStatus";
                case "完成日期": return "Opps_CompletedTime";
                case "会员卡号": return "Mc_CradNumber";
                default: return "";
            }
        }
        /// <summary>
        /// 当前点击的字段
        /// </summary>
        string StrCurrentClickField = "";
        /// <summary>
        /// 排序字段
        /// </summary>
        string StrSortField = "Ord_CreateDateTime DESC,Ordv_DigitalNumber,tb_ErpOrderPhotoPrints.ID";
        /// <summary>
        /// 排序顺序
        /// </summary>
        string StrSortOrder = "DESC";
        /// <summary>
        /// 创建行
        /// </summary>
        void PublicFunctionRows(string sqlWhere ="" )
        {
            this.dgvData.dgvCurrentColumnOriginalSet = "Ord_Number,Ord_Type,Ordv_ViceNumber,订单号,客户姓名,客户性别,客户电话,订单类型,接单人,套系名称,套系价格,加急,加急日期,拍摄名称,拍照状态,设计状态,设计师,设计日期,看版状态,看版师,看版日期,相片名称,数量,面积,发出状态,发出日期,返工状态,返工日期,完成状态,完成日期,取件状态,会员卡号";
            string StrGuidName = LYFZ.EnumPublic.dgvGuidName.E_FormAll_A0007.ToString().Trim();
            if ((LYFZ.BLL.BLL_SystemGlobalSetting.SysTemGlobalSetMoel.MemberCardShowHide))
            {
                this.dgvData.dgvFixedHideColumn = "Ord_Number,Ord_Type,Ordv_ViceNumber,会员卡号";
            }
            else
            {
                this.dgvData.dgvFixedHideColumn = "Ord_Number,Ord_Type,Ordv_ViceNumber";
            }
            
            this.dgvData.dgvGuidName = StrGuidName;
            this.dgvData.dgvUserEmployeeID = this.StrUserID;
            this.dgvData.StrValueNullColumn = "订单号,客户姓名,客户性别,客户电话,订单类型,接单人,套系名称,套系价格,会员卡号";
            this.dgvData.StrSecondStageNull = "加急,加急日期,拍摄名称,拍照状态,设计状态,设计师,设计日期,看版状态,看版师,看版日期,取件状态";
            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))
            {
                this.cmbQueryText.Text = LYFZ.BLL.BLL_ErpOrder.CurrentSelectedOrderNumber;
                DataTable dt = orbll.GetView_Custom("tb_ErpOrder", StrWhere: "Ord_SinceOrderNumber = '" + LYFZ.BLL.BLL_ErpOrder.CurrentSelectedOrderNumber + "' And Ord_Type in ('0','1','2')", ShowColumnName: "ID").Tables[0];
                if (dt.Rows.Count <= 0)
                { this.dgvData.DataColumns(this.dgvData.dgvCurrentColumnOriginalSet, this.dgvData.dgvFixedHideColumn); return; }
                else
                {
                    string StrWhere = " Where Ord_SinceOrderNumber = '" + LYFZ.BLL.BLL_ErpOrder.CurrentSelectedOrderNumber + "'" + LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.GetVersionQuerySQL(this.chkPortraitVersion, this.chkDressVersion, this.chkKidsVersion, StrOrdType: "0,1,2");
                    StrQueryCondition = StrWhere + LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.GetGroupQueryOrderClickWhere(this.cmbtreevStoreName, "Ord_DividedShop");
                }
            }
            else
            { StrQueryCondition = this.GetWhereStr(); }

            if(!string.IsNullOrEmpty(sqlWhere))
            {
                if(!string.IsNullOrEmpty(StrQueryCondition))
                {
                    StrQueryCondition += " and  " + sqlWhere;
                }
                else
                {
                    StrQueryCondition += " where  " + sqlWhere;
                }
            }

            int intTopCount = LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.GetPageSize();
            List<string> listColumns = new List<string>(StrSortField.Replace(" DESC", "").Replace(" ASC", "").Split(','));
            Hashtable htData = LYFZ.ComponentLibrary.DataGridOrderView.GetData_OrderPhotosPrints(this.dgvData, dictColumns, listColumns, 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 Ord_Class = '1' " + LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.GetGroupQueryWhere(this.cmbtreevStoreName, "Ord_DividedShop");
            if (chkCompleteOrder.Checked)
            {
                StrWhere += " and ( (Ords_ServiceIntStatus = 2 or ServiceCount=0 ) and (Ords_ProductPickupIntStatus = 2 or productCount=0 ) and (ServiceCount>0 or productCount>0) ) ";
            }
            else
            {
                if (BLL.BLL_SystemGlobalSetting.SysTemGlobalSetMoel.HidePickUpOrder && !this.chkCompleteOrder.Checked && string.IsNullOrEmpty(this.cmbQueryText.Text))
                {

                    StrWhere += " and (Ords_ProductPickupIntStatus  in (0,1) and productCount>0  )  ";

                }
                else
                {
                    StrWhere += " and ( (Ords_ServiceIntStatus in (0,1) and ServiceCount>0 ) or (Ords_ProductPickupIntStatus  in (0,1) and productCount>0  )  or ( ServiceCount = 0 and productCount = 0 )  ) ";
                }
            }
            StrWhere += LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.GetQueryTextQueryCondition(this.cmbQueryText.Text.Trim());
            StrWhere += LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.GetVersionQuerySQL(this.chkPortraitVersion, this.chkDressVersion, this.chkKidsVersion, StrOrdType: "0,1,2");
            return StrWhere;
        }
    }
}