using CSFrameworkV5.Business;
using CSFrameworkV5.Common;
using CSFrameworkV5.Core;
using CSFrameworkV5.Language;
using CSFrameworkV5.Library;
using CSFrameworkV5.Library.CommonClass;
using DevExpress.XtraEditors;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace CSFrameworkV5.womcaa
{
    public partial class frmWOMPlanQZ : frmBaseDataForm
    {
        private DataTable tb = new DataTable();
        private DataTable tbWOMDAA = new DataTable();
        private string GCD = "";
        private string idString = "";

        private DataTable tbWOMGCA = new DataTable();//合并表

        private DataTable tbWOMCAA = new DataTable();
        private DataTable XT;//线体表

        private DataTable JT;//机台表
        private DataTable CF;//已拆分数量表
        private bllyhj_womcaa _BLLInstance;//业务逻辑层对象引用
        private DataTable tbWOMDAAA = new DataTable();
        private DataTable tbWOMDAAA_B = new DataTable();

        private DataTable tbGCBOM = new DataTable();//高冲bom
        //private DataTable tbWOMDAAA;//线体表
        private DataTable tbyp = new DataTable();//已排指令表
        /// <summary>
        /// 是否拆分了工单
        /// </summary>
        public bool IsSplit = false;
        private DataTable RY;
        private DataTable GYLX;
        private DataTable tbWOMDAAA_ONE = new DataTable();
        private DataTable tbBM;

        public frmWOMPlanQZ()
        {
            InitializeComponent();
        }

        public override void InitButtons()
        {
            var btnClose = ToolbarRegister.CreateButton("btnClose",
                LanLib.Get("关闭"), ToolBarGroup.关闭窗体, Globals.LoadBitmap("32_Exit.png"), new Size(57, 28), false, true,
                DoClose);
            _buttons.AddButton(btnClose);

            var btnRefresh = ToolbarRegister.CreateButton("btnRefreshDataDict",
                LanLib.Get("查询未排"), ToolBarGroup.数据操作, Globals.LoadBitmap("32_Refresh.png"), new Size(57, 28), true,
                true, DoSeleteData);
            _buttons.AddButton(btnRefresh);

            if (ButtonAuthorized(ButtonAuthority.DELETE))
            {
                var btnDelete = ToolbarRegister.CreateButton("btnDelete", LanLib.Get("拆分"), ToolBarGroup.数据操作,
                    Globals.LoadBitmap("32_Del.png"), new Size(57, 28), false, true, SplitWorkOrder);
                Buttons.AddButton(btnDelete);
            }

            //if (ButtonAuthorized(ButtonAuthority.EDIT))
            //{
            //    var btnSave = ToolbarRegister.CreateButton("btnSave", LanLib.Get("下达"), ToolBarGroup.数据操作,
            //        Globals.LoadBitmap("32_Save.png"), new Size(57, 28), false, true, doXiaDaZhiLing);
            //    Buttons.AddButton(btnSave);
            //}


            if (ButtonAuthorized(ButtonAuthority.EDIT))
            {
                var btnSave = ToolbarRegister.CreateButton("btnSave", LanLib.Get("合并下达"), ToolBarGroup.数据操作,
                    Globals.LoadBitmap("32_Save.png"), new Size(57, 28), false, true, HBXD);
                Buttons.AddButton(btnSave);
            }


            //if (ButtonAuthorized(ButtonAuthority.EDIT))
            //{
            //    var btnCXTJ = ToolbarRegister.CreateButton("btnSave", LanLib.Get("查询推荐"), ToolBarGroup.数据操作,
            //        Globals.LoadBitmap("Zoom_32x32.png"), new Size(57, 28), false, true, CXTJ);
            //    Buttons.AddButton(btnCXTJ);
            //}


            //if (ButtonAuthorized(ButtonAuthority.EDIT))
            //{
            //    var btnQXTJ = ToolbarRegister.CreateButton("btnSave", LanLib.Get("取消推荐"), ToolBarGroup.数据操作,
            //        Globals.LoadBitmap("32_Undo.png"), new Size(57, 28), false, true, QXTJ);
            //    Buttons.AddButton(btnQXTJ);
            //}

            //if (ButtonAuthorized(ButtonAuthority.EDIT))
            //{
            //    var btnQXAllTJ = ToolbarRegister.CreateButton("btnSave", LanLib.Get("取消全部推荐"), ToolBarGroup.数据操作,
            //        Globals.LoadBitmap("32_Void.png"), new Size(57, 28), false, true, QXAllTJ);
            //    Buttons.AddButton(btnQXAllTJ);
            //}
            //if (ButtonAuthorized(ButtonAuthority.EDIT))
            //{
            //    var btnSavet = ToolbarRegister.CreateButton("btnSave", LanLib.Get("合并"), ToolBarGroup.数据操作,
            //        Globals.LoadBitmap("32_Save.png"), new Size(57, 28), false, true, hb);
            //    Buttons.AddButton(btnSavet);
            //}
        }


        // 合并下达
        private void HBXD(IButtonInfo sender)
        {
            //MessageBox.Show("功能暂时关闭");
            //return;

            //获取gridview中当前cell的行号
            int rowHandle = gridView2.FocusedRowHandle;


            gridView2.FocusedRowHandle = rowHandle;
            gridView2.FocusedColumn = gridView2.Columns["DAA001"];

            string bilo = "";
            int no = 0;  //合并指令数

            string GCA059 = "";//销售订单号
            string GCA010 = "";//总装工单号
            string GCA074 = "";//总装产品编码

            string ZLS = "";//指令集
            decimal NewShu = 0;//拆分集合里的数量
            decimal OldShu = 0;//数据库里的数量（排除了拆分集合里的数量）

            if (tb.Rows.Count == 0)
            {
                MessageBox.Show("还没有数据，请查询未排工单！");
                return;
            }
            DataRow[] selRow = tb.Select("SelL='Y' AND ChaiFenGeShu>0");
            if (selRow.Length == 0)
            {
                MessageBox.Show("请选择工单,并录入拆分个数");
                return;
            }
            //if (tbWOMDAA.Rows.Count > 0)
            //{
            //    tbWOMDAA.Clear();
            //}

            if (!IsSplit)
            {
                MessageBox.Show("工单未拆分，不能下达！");
                return;
            }
            if (tbWOMDAA.Rows.Count == 0)
            {
                MessageBox.Show("请先拆分指令!");
                return;
            }
            //对数据的检测
            foreach (DataRow dr in tbWOMDAA.Rows)
            {
                if (dr["DAA042"].ToString() == "")
                {
                    MessageBox.Show("存在线别为空，不能下达指令！");
                    return;
                }
                if (dr["DAA040"].ToString() == " ")
                {
                    MessageBox.Show("存在人员为空，不能下达指令！");
                    return;
                }
                //if (dr["DAA069"].ToString() == "")
                //{
                //    MessageBox.Show("设备名称为空，不能下达指令！");
                //    return;
                //}
                if (Convert.ToInt32(dr["DAA027"]) <= 0)
                {
                    MessageBox.Show("存在数量小于等于0，不能下达指令！");
                    return;
                }
            }


            //计算合并工单的总指令数
            bilo = tbWOMDAA.Rows[0]["DAA014"].ToString();
            string plan_type = tbWOMDAA.Rows[0]["DAA071"].ToString();
            foreach (DataRow dr in tbWOMDAA.Rows)
            {
                no = no + Convert.ToInt32(dr["DAA027"]);
                GCA010 = GCA059 + dr["DAA010"].ToString() + ",";
                GCA059 = GCA059 + dr["DAA059"].ToString()+",";
                GCA074 = GCA074 + dr["DAA074"].ToString() + ",";
                if (dr["DAA014"].ToString() != bilo)
                {
                    MessageBox.Show("产品编码不一致，不能合并下达！！！");
                    return;
                }
                if (dr["DAA071"].ToString() != plan_type)
                {
                    MessageBox.Show("计划类型不一致，不能合并下达！！！");
                    return;
                }
            }

    //        var duplicates = tbWOMDAA.AsEnumerable()
    //.GroupBy(row => row.Field<string>("DAA010")) // 假设DAA010是字符串类型，如果不是请修改类型  
    //.Where(group => group.Count() > 1) // 查找包含两条或更多条数据的组  
    //.Select(group => group.Key); // 选择重复的DAA010值  


            // 使用LINQ查询非空的DAA010字段值并分组，然后筛选出那些包含两条或更多条目的组  
            var duplicates = tbWOMDAA.AsEnumerable()
                .Where(row => !string.IsNullOrEmpty(row.Field<string>("DAA010"))) // 排除空值  
                .GroupBy(row => row.Field<string>("DAA010"))
                .Where(group => group.Count() > 1); // 选择那些有多于一个条目的组

            // 如果找到了重复的DAA010值，显示错误消息框  
            if (duplicates.Any())
            {
                string errorMessage = "在新开指令中发现了重复的总装指令工单: " + string.Join(", ", duplicates);
                MessageBox.Show(errorMessage, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); // 如果你使用的是Windows                                                                           // 如果不是Windows Forms，你可能需要使用不同的方式显示消息  
                return;
            }


            //判断拆分出来的数量不能超过原工单数量
            DataTable dtDAA = tbWOMDAA.DefaultView.ToTable(true, new string[] { "DAA038", "DAA014" });
            foreach (DataRow dr in dtDAA.Rows)
            {
                NewShu = 0;
                OldShu = 0;
                string filter = string.Format("DAA038 ='{0}' AND DAA014='{1}' and DAA001 not like '%-B' ", dr["DAA038"], dr["DAA014"]);
                DataRow[] arrayRow = tbWOMDAA.Select(filter);
                foreach (DataRow dr1 in arrayRow)
                {
                    ZLS += "'" + dr1["DAA001"].ToString() + "',";
                    NewShu += Convert.ToDecimal(dr1["DAA027"]);
                }
                OldShu = GetYiChaiFenShu(dr["DAA038"].ToString(), ZLS.TrimEnd(','), dr["DAA014"].ToString());

                DataRow[] yRow = tb.Select("CAA001='" + dr["DAA038"] + "'");
                decimal YuanGDShu = yRow.Length > 0 ? Convert.ToDecimal(yRow[0]["CAA012"]) : 0;
                if (NewShu + OldShu > YuanGDShu)
                {
                    MessageBox.Show(string.Format("工单[{0}]的拆分数量[{1}]+[{2}]不能大于工单总量[{3}]，请修改！",
                        dr["DAA038"].ToString(), NewShu.ToString(), OldShu.ToString(), YuanGDShu));
                    return;
                }
            }


            //合并单据
            try
            {
                GCD = CommonData.GetDocNo("MOHB");

                DataRow drNew = tbWOMGCA.NewRow();
                Guid newId = Guid.NewGuid();
                idString = newId.ToString();
                drNew["ID"] = idString;
                drNew["GCA001"] = GCD;//	合并指令单号 
                drNew["GCA003"] = tbWOMDAA.Rows[0]["DAA003"];//	客户编号
                drNew["GCA004"] = "5102";    //	工单单别
                drNew["GCA005"] = DateTime.Now.ToString("yyyy-MM-dd HH:mm"); //	开单日期
                drNew["GCA006"] = "00:00";//	开单时间
                drNew["GCA007"] = "0000";//	开单版本
                                         //drNew["GCA011"] = tbGCBOM.Rows[0]["生产方案"].ToString(); ;//	生产方案
                drNew["GCA014"] = tbWOMDAA.Rows[0]["DAA014"];//	产品编码
                drNew["GCA015"] = tbWOMDAA.Rows[0]["DAA015"];//	产品名称
                drNew["GCA016"] = tbWOMDAA.Rows[0]["DAA016"];//	产品规格
                drNew["GCA017"] = tbWOMDAA.Rows[0]["DAA017"];//	单位
                drNew["GCA018"] = DateTime.Now.ToString("yyyy-MM-dd");//变更成下达时间dr["CAA010"].GetString().Substring(0, 10);//	预计开工日期
                drNew["GCA019"] = DateTime.Now.ToString("yyyy-MM-dd");//变更成下达时间dr["CAA011"].GetString().Substring(0, 10);//	预计完工日期
                drNew["GCA020"] = tbWOMDAA.Rows[0]["DAA018"].ToString().Substring(0, 10); //dr["CAA010"].ToString().Length > 10 ? dr["CAA010"].ToString().Substring(11, 5) : "08:00";//	预计开工时间
                drNew["GCA021"] = tbWOMDAA.Rows[0]["DAA019"].ToString().Substring(0, 10); //dr["CAA011"].ToString().Length > 10 ? dr["CAA010"].ToString().Substring(11, 5) : "17:30";//	预计完工时间
                drNew["GCA022"] = "新开指令";//	生产状态  新单
                drNew["GCA027"] = no;//	工单数量
                drNew["GCA028"] = 0;
                drNew["GCA029"] = 0;
                drNew["GCA030"] = 0;
                drNew["GCA031"] = tbWOMDAA.Rows[0]["DAA031"];//	BOM版次
                drNew["GCA032"] = tbWOMDAA.Rows[0]["DAA032"];//	工作中心
                drNew["GCA034"] = "";//指令物料超发类型 
                drNew["GCA035"] = "";//指令组
                drNew["GCA036"] = tbWOMDAA.Rows[0]["DAA036"];//图号
                drNew["GCA037"] = 0;//备料齐套生产 
                drNew["GCA038"] = tbWOMDAA.Rows[0]["DAA038"];//	计划批次
                drNew["GCA039"] = tbWOMDAA.Rows[0]["DAA039"];//	客户名称
                drNew["GCA040"] = tbWOMDAA.Rows[0]["DAA040"];//	备注
                drNew["GCA041"] = "";//	目标指令编码
                drNew["GCA042"] = tbWOMDAA.Rows[0]["DAA042"];//	生产线别
                drNew["GCA043"] = tbWOMDAA.Rows[0]["DAA043"];//	生产批次编码
                drNew["GCA044"] = "";//	RoHS区分
                drNew["GCA045"] = "1";//dr["CAA045"];	返工标记（1-量产2试做,3-有任务单返工;4-无任务单返工
                drNew["GCA046"] = Loginer.CurrentUser.Account;//	审核者
                drNew["GCA047"] = "N";//	程序校验
                drNew["GCA048"] = 0;//Convert.ToDecimal(dr["FAuxInHighLimitQty"]);	入库上限值
                drNew["GCA049"] = "3";//	板面标识
                drNew["GCA050"] = 0; //不良品数
                drNew["GCA051"] = 0; //备用ObjectToDecimal(dr["FStdWorkHour"]).ToString();
                drNew["GCA052"] = 0;//产线人员
                drNew["GCA053"] = 0;//是否退料
                drNew["GCA054"] = 0;//发料仓库
                drNew["GCA055"] = 0;//生产优先级
                drNew["GCA056"] = 0;//下一个指令编码
                //drNew["GCA057"] = tbWOMDAA.Rows[0]["CAA001"];  //工单单号  udpObjectToDecimal(dr["FOldStdWorkHour"]).ToString();
                //drNew["GCA058"] = tbWOMDAA.Rows[0]["CAA016"];//	客户订单
                drNew["GCA059"] = GCA059;//	销售订单号
                drNew["GCA067"] = tbWOMDAA.Rows[0]["DAA067"];
                drNew["GCA068"] = tbWOMDAA.Rows[0]["DAA068"];
                drNew["GCA069"] = tbWOMDAA.Rows[0]["DAA069"];
                drNew["GCA071"] = tbWOMDAA.Rows[0]["DAA071"];
                drNew["GCA073"] = tbWOMDAA.Rows[0]["DAA073"];
                drNew["GCA074"] = GCA074;//	总装产品编码
                drNew["GYLX"] = tbWOMDAA.Rows[0]["GYLX"];//	总装产品编码

                if (tbWOMDAA.Rows[0]["DAA071"].ToString() == "计划外")
                {
                    drNew["flagApp"] = "N";
                }

                tbWOMGCA.Rows.Add(drNew);

                _BLLInstance.InstDataSet(tbWOMGCA, "WOMGCA");


            }
            catch(Exception EEE)
            {
                MessageBox.Show("合并工单失败!"+EEE.Message);
                return;
            }




            try
            {
                int i = 0;
                //格式化时间控件的值
                foreach (DataRow dr in tbWOMDAA.Rows)
                {
                    
                    dr["ID"] = Guid.NewGuid();
                    dr["DAA020"] = dr["DAA018"].ToString().Substring(0, 10);
                    dr["DAA021"] = dr["DAA019"].ToString().Substring(0, 10);
                    dr["DAA050"] = 0;
                    dr["DAA051"] = 0;
                    dr["DAA052"] = 0;
                    dr["DAA028"] = 0;
                    dr["DAA029"] = 0;
                    dr["DAA030"] = 0;
                    dr["DAA033"] = 0;
                    dr["AppNAME"] = "指令工单";
                    dr["GCID"] = idString;
                    dr["DAA070"] = ++i;
                    dr["HBGD"] = GCD;//合并工单

                    if (dr["DAA071"].ToString() == "计划外")
                    {
                        dr["flagApp"] = "N";
                    }

                }

                

                //保存数据
                // PB.StepProgressBar(1, "正在保存指令数据!");
                if (_BLLInstance.InstDataSet(tbWOMDAA, "WOMDAA"))
                {
                    //更新已下达的数量
                    foreach (DataRow row in dtDAA.Rows)
                    {
                        UpdateIssueWorkOrder(row["DAA038"].ToString(), row["DAA014"].ToString());
                        string WOMCAAKG = string.Format("EXEC WMS_CREATE_WOMCAAKG  '{0}'", row["DAA038"].ToString());
                        _BLLInstance.InsDataSet(WOMCAAKG);

                    }
                    //生成指令明细数据                    
                    foreach (DataRow dr in tbWOMDAA.Rows)
                    {

                        //string SQL_WOMDAB = string.Format("EXEC WMS_CREATE_WOMDABGC '{0}','{1}'", dr["DAA001"].ToString(),dr["DAA038"].ToString());
                        //_BLLInstance.InsDataSet(SQL_WOMDAB);

                        string SQL1 = string.Format("EXEC WOM_UPDATE_ZZGD '{0}' ", dr["DAA001"].ToString());
                        _BLLInstance.InsDataSet(SQL1);

                        string GCBOMBG = string.Format("EXEC WMS_CREATE_WOMDAB '{0}' ",dr["DAA001"].ToString());
                        _BLLInstance.InsDataSet(GCBOMBG);

                    }

                    // PB.StepProgressBar(1, "正在更新已开指令数!");


                    MessageBox.Show("合并工单<" + GCD +">下达成功!");
                    tbWOMDAA.Clear();
                    tbWOMGCA.Clear();
                    tbyp.Clear();
                    tb.Clear();
                    string sql = string.Format(@";WITH B AS(SELECT DISTINCT DAA059,SUM(ISNULL(DAA027,0)) F
                          FROM WOMDAA(NOLOCK) WHERE  DAA032 IN ('洗衣机装配车间','风扇装配车间','罩极装配车间') AND ISNULL(DAA059,'')<>''  GROUP BY DAA059),
                          ZZYPGD_WP AS (SELECT DAA001 总装指令工单,DAA027 总装指令已排数,ISNULL(DAA059,'') 销售订单号,DAA020 总装预计开工时间
                                     FROM WOMDAA(NOLOCK) AA WHERE ISNULL(DAA059,'') <> '' AND DAA022 <> '完工' AND DAA032 IN ('洗衣机装配车间','风扇装配车间','罩极装配车间') AND NOT EXISTS(SELECT 1 FROM WOMDAA(NOLOCK) BB WHERE BB.DAA010 = AA.DAA001 AND DAA032 = '{0}' )),
                          ZZYPGD_SUM AS (SELECT DAA001 总装指令工单,DAA027 总装指令已排数,ISNULL(DAA059,'') 销售订单号,DAA020 总装预计开工时间
                                     FROM WOMDAA(NOLOCK) AA WHERE ISNULL(DAA059,'') <> ''  AND DAA032 IN ('洗衣机装配车间','风扇装配车间','罩极装配车间'))
                          SELECT A.CAA002,A.CAA003,A.CAA005,A.CAA018,A.CAA006,A.CAA007,A.CAA008,A.CAA009,A.CAA010,A.CAA011,A.CAA012,A.CAA013,A.CAA014,A.CAA015,A.CAA016,A.CAA022,A.CAA017,A.CAA021,A.ERPID,C.WL069,'1' ChaiFenGeShu,'N' SelL,ZZYPGD_WP.总装指令已排数 WeiPaiShu,isnull(B.F,0)  ZWEI ,WL008,D.CAA006  总装产品编码,A.CAA012-isNull(A.CAA013,0) 工单总未排数,
                                 '计划内' 类型,PQZ006 计划排产时间,ZZYPGD_WP.总装指令工单 总装指令工单,ZZYPGD_WP.总装指令已排数 总装指令数量  FROM WOMCAA(nolock) A
                          LEFT JOIN  B ON B.DAA059=A.CAA018
                          LEFT JOIN  GS_WL(NOLOCK) C ON C.WL001=A.CAA006
                          LEFT JOIN  (SELECT distinct CAA006, CAA018 FROM WOMCAA(NOLOCK) WHERE CAA014 IN ('风扇装配车间','洗衣机装配车间','罩极装配车间') AND  SUBSTRING(CAA006,1,2)='01' AND ISNULL(CAA018,'')<>'') D  ON D.CAA018=A.CAA018
                          LEFT JOIN GS_PLAN_QZ(NOLOCK) E ON PQZ002 = A.CAA001
                          RIGHT JOIN ZZYPGD_WP ON ZZYPGD_WP.销售订单号 = A.CAA018
                          WHERE  A.CAA013<A.CAA012  AND A.CAA014='{0}' AND ISNULL(A.CAA026,0)>0  AND ISNULL(A.flagApp,'') <> 'N' AND ISNULL(CAA029,'0') NOT IN ('5','6','7')
                          union
                          SELECT A.CAA002,A.CAA003,A.CAA005,A.CAA018,A.CAA006,A.CAA007,A.CAA008,A.CAA009,A.CAA010,A.CAA011,A.CAA012,A.CAA013,A.CAA014,A.CAA015,A.CAA016,A.CAA022,A.CAA017,A.CAA021,A.ERPID,C.WL069,'1' ChaiFenGeShu,'N' SelL,A.CAA012-(SELECT SUM(总装指令已排数) FROM ZZYPGD_SUM WHERE ZZYPGD_SUM.销售订单号 = A.CAA018 ) WeiPaiShu ,isnull(B.F,0)  ZWEI ,WL008,D.CAA006  总装产品编码,A.CAA012-isNull(A.CAA013,0) 工单总未排数,
                                '计划外' 类型,'' 计划排产时间,'' 总装指令工单,'' 总装指令数量 FROM WOMCAA(nolock) A
                          LEFT JOIN  B ON B.DAA059=A.CAA018
                          LEFT JOIN  GS_WL(NOLOCK) C ON C.WL001=A.CAA006
                          LEFT JOIN  (SELECT distinct CAA006, CAA018 FROM WOMCAA(NOLOCK) WHERE CAA014 IN ('风扇装配车间','洗衣机装配车间','罩极装配车间') AND  SUBSTRING(CAA006,1,2)='01' AND ISNULL(CAA018,'')<>'') D  ON D.CAA018=A.CAA018
                          WHERE  A.CAA013<A.CAA012  AND A.CAA014='{0}' AND ISNULL(A.CAA026,0)>0  AND ISNULL(A.flagApp,'') <> 'N' AND ISNULL(CAA029,'0') NOT IN ('5','6','7')
                            AND (A.CAA012-(SELECT SUM(总装指令已排数) FROM ZZYPGD_SUM WHERE ZZYPGD_SUM.销售订单号 = A.CAA018 ) > 0) AND  EXISTS(SELECT 1 FROM ZZYPGD_SUM WHERE ZZYPGD_SUM.销售订单号 = A.CAA018)
                          union
                          SELECT A.CAA002,A.CAA003,A.CAA005,A.CAA018,A.CAA006,A.CAA007,A.CAA008,A.CAA009,A.CAA010,A.CAA011,A.CAA012,A.CAA013,A.CAA014,A.CAA015,A.CAA016,A.CAA022,A.CAA017,A.CAA021,A.ERPID,C.WL069,'1' ChaiFenGeShu,'N' SelL,A.CAA012 WeiPaiShu ,isnull(B.F,0)  ZWEI ,WL008,D.CAA006  总装产品编码,A.CAA012-isNull(A.CAA013,0) 工单总未排数,
                                '计划外' 类型,'' 计划排产时间,'' 总装指令工单,'' 总装指令数量 FROM WOMCAA(nolock) A
                          LEFT JOIN  B ON B.DAA059=A.CAA018
                          LEFT JOIN  GS_WL(NOLOCK) C ON C.WL001=A.CAA006
                          LEFT JOIN  (SELECT distinct CAA006, CAA018 FROM WOMCAA(NOLOCK) WHERE CAA014 IN ('风扇装配车间','洗衣机装配车间','罩极装配车间') AND  SUBSTRING(CAA006,1,2)='01' AND ISNULL(CAA018,'')<>'') D  ON D.CAA018=A.CAA018
                          WHERE  A.CAA013<A.CAA012  AND A.CAA014='{0}' AND ISNULL(A.CAA026,0)>0  AND ISNULL(A.flagApp,'') <> 'N' AND ISNULL(CAA029,'0') NOT IN ('5','6','7')
                            AND NOT EXISTS(SELECT 1 FROM ZZYPGD_SUM WHERE ZZYPGD_SUM.销售订单号 = A.CAA018)", searchLookUpEdit1.Text);
                    tb = _BLLInstance.GETDAT(sql);
                    this.gridControl1.DataSource = tb;
                    return;
                }
                else
                {
                    MessageBox.Show("指令下达失败!");
                    return;
                }
            }
            finally
            {
                // PB.MoveProgressBar();
            }



        }


        /// <summary>
        ///更新工单已开指令数
        /// </summary>
        /// <param name="Order">The order.</param>
        public void UpdateIssueWorkOrder(string Order, string PartNo)
        {
            string sql = string.Format(@"update WOMCAA SET CAA013 = ISNULL((SELECT SUM(DAA027) FROM WOMDAA WHERE DAA038 = CAA001 AND DAA014 = CAA006 and DAA001 not  like '%-B'), 0),CAA028 = 2
                                       WHERE CAA001 = '{0}' and CAA006='{1}' ", Order, PartNo);
            _BLLInstance.InsDataSet(sql);
        }


        #region 得到数据库里的已拆分数量（排除了拆分集合里的数量）DataTable GetYiChaiFenShu(string DAA038,string DAA001)        
        /// <summary>
        /// 得到数据库里的已拆分数量（排除了拆分集合里的数量）
        /// </summary>
        /// <param name="DAA038">工单号</param>
        /// <param name="DAA001">指令号集合</param>
        /// <returns></returns>
        public decimal GetYiChaiFenShu(string DAA038, string DAA001, string DAA014)
        {
            string sql = string.Format("select ISNULL(sum(DAA027),0) sl from WOMDAA where DAA038='{0}' AND DAA014='{2}' and DAA001 not in ({1}) and DAA001 not like '%-B' ", DAA038, DAA001, DAA014);
            CF = _BLLInstance.GETDAT(sql);
            return Convert.ToDecimal(CF.Rows[0]["sl"]);
        }
        #endregion

        //拆分
        private void SplitWorkOrder(IButtonInfo sender)
        {
            if (tb.Rows.Count == 0)
            {
                MessageBox.Show("还没有数据，请查询未排工单！");
                return;
            }
            DataRow[] selRow = tb.Select("SelL='Y'");
            if (selRow.Length == 0)
            {
                MessageBox.Show("请选择工单,并录入拆分个数");
                return;
            }
            if (tbWOMDAA.Rows.Count > 0)
            {
                tbWOMDAA.Clear();
            }

            if (tbWOMGCA.Rows.Count > 0)
            {
                tbWOMGCA.Clear();
            }


            Dictionary<string, int> workorderCount = new Dictionary<string, int>();
            Dictionary<string, int> workorderCount1 = new Dictionary<string, int>();

            // 遍历selRow中的所有行  
            foreach (DataRow row in selRow)
            {
                string workorder = row["任务单号"].ToString();

                // 如果工单号不在字典中，则将其添加并设置计数为0  
                if (!workorderCount.ContainsKey(workorder))
                    workorderCount[workorder] = 0;

                if (!workorderCount1.ContainsKey(workorder))
                    workorderCount1[workorder] = 0;

                // 对每种工单号进行计数  
                workorderCount[workorder]++;
                workorderCount1[workorder]++;
            }

            #region
            /* foreach (DataRow dr in selRow)
             {

               *//*  if (Convert.ToInt32(dr["ChaiFenGeShu"]) == 0)
                     continue;*/

            /*  tbWOMDAAA_ONE.Clear();
              tbWOMDAAA.Clear();
              string sqlstr = String.Format(@"SELECT  DISTINCT  A.DAA001 指令单号,A.DAA027 指令数量,(A.DAA027-SUM(ISNULL(C.DAA027,0))) 已排数量,A.DAA020  预计开工时间,A.DAA014 物料编码, A.DAA015 物料名称 ,A.DAA016 物料规格,A.DAA059 销售订单号   FROM WOMDAA  A
                                          LEFT JOIN WOMDAA C  ON C.DAA010 = A.DAA001
                                          WHERE A.DAA059 = '{0}' AND A.DAA032 IN('风扇装配车间','洗衣机装配车间','罩极装配车间')  AND A.DAA022 NOT IN('完工', '停工')  AND ISNULL(C.DAA010,'')= '' AND ISNULL(C.DAA027,0)< A.DAA027 AND ISNULL(A.DAA075,0) = 0  AND ISNULL(A.DAA059,'') <> ''
                                          GROUP BY A.DAA001 ,A.DAA027 ,A.DAA020  ,A.DAA014 , A.DAA015  ,A.DAA016,A.DAA059 ", dr["CAA018"].ToString());//WHERE ISNULL(DAA028,0)<DAA027
              tbWOMDAAA_ONE = _BLLInstance.GETDAT(sqlstr);



              if (tbWOMDAAA_ONE.Rows.Count > 0)
              { 
                  foreach (DataRow row in tbWOMDAAA_ONE.Rows)
                  {
                      // 创建一个新的DataRow对象，并设置其ItemArray为当前行的ItemArray  
                      // 注意：这里假设tbWOMDAAA的列与tbWOMDAAA_ONE的列完全相同  
                      DataRow newRow = tbWOMDAAA.NewRow();
                      newRow.ItemArray = row.ItemArray;

                      // 将新行添加到tbWOMDAAA中  
                      tbWOMDAAA.Rows.Add(newRow);
                  }
              }*//*


             // DataRow newRow_NULL = tbWOMDAAA.NewRow();

              // 将新行添加到tbWOMDAAA中  
             // tbWOMDAAA.Rows.Add(newRow_NULL);


              //       string sqlstr1 = String.Format(@" SELECT A.BOM001 AS 生产方案,A.BOM002 AS 产品编码,A.BOM003 AS 产品名称, A.BOM004 AS 产品规格, A.BOM007 AS 模具类型 ,
              //B.BOMM002  AS 用料编码,B.BOMM003 AS 用料名称,B.BOMM004 AS 用料规格
              //FROM GS_BOM AS A LEFT JOIN GS_MBOM AS B ON A.ID = B.PID where BOM002 = '{0}'  ", dr["CAA006"].ToString());//WHERE ISNULL(DAA028,0)<DAA027
              //       tbGCBOM = _BLLInstance.GETDAT(sqlstr1);
              //       repositoryItemSearchLookUpEdit2.ValueMember = "生产方案";
              //       repositoryItemSearchLookUpEdit2.DisplayMember = "生产方案";
              //       repositoryItemSearchLookUpEdit2.ShowClearButton = false;
              //       repositoryItemSearchLookUpEdit2.DataSource = tbGCBOM;
              //       repositoryItemSearchLookUpEdit2.View.OptionsView.ColumnAutoWidth = true;



              string SQLL = String.Format(@"SELECT CAA006 FROM WOMCAA WITH(NOLOCK) WHERE  CAA014 LIKE '%装配%' AND CAA018='{0}' ", dr["CAA018"].ToString());
              tbWOMCAA  = _BLLInstance.GETDAT(SQLL);
              decimal avg = Convert.ToInt32(Convert.ToInt32(dr["WeiPaiShu"]) / Convert.ToInt32(dr["ChaiFenGeShu"]));
              int No = Convert.ToInt32(GetMaxBillNo(dr["CAA002"].ToString()));

              for (int i = 0; i < Convert.ToInt32(dr["ChaiFenGeShu"]); i++)
              {
                  No = No + 1+workorderCount[dr["CAA002"].ToString()]- workorderCount1[dr["CAA002"].ToString()];
                  string erp_column = dr["CAA018"].ToString() == "" ? "DAA043" : "DAA059";
                  string erp_wo = dr["CAA018"].ToString() == "" ? dr["CAA002"].ToString() : dr["CAA018"].ToString();//使用销售订单号来作单号,如果没有销售订单号就用工单号
                  string BillType = "5102";
                  //GetMaxBillNO("5102", SystemDate);//dr["CAA002"].ToString();这里直接使用任务单号
                  //if (!IsSysBillType(BillType)) BillType = "5102";
                  //取任务单的单号;
                  //strCurrLineNo = string.IsNullOrEmpty(CurrWorkLineNo) ? MyRow["FWorkSNo"].ToString().Trim() : CurrWorkLineNo;
                  //int iWorkerNum = Manager.GetLineWorkerNum(strCurrLineNo);
                  string BillNo = dr["CAA002"].ToString() + "-" + No.ToString();

                  workorderCount1[dr["CAA002"].ToString()]--;
                  DataTable dt = null;// GetBanMianBiaoShi(dr["CAA006"].GetString());
                  //if (dt.Rows.Count>1)
                  if (1 != 1)  
                  {
                      foreach (DataRow row in dt.Rows)
                      {
                          if (row[0].ToString() == "") continue;
                          #region AB面
                          DataRow drNew = tbWOMDAA.NewRow();
                          drNew["DAA001"] = BillNo + "-" + row[0];//	指令单号 
                          drNew["DAA003"] = dr["CAA003"];//	客户编号
                          drNew["DAA004"] = BillType;    //	工单单别
                          drNew["DAA005"] = DateTime.Now.ToString("yyyy-MM-dd HH:mm");//	开单日期
                          drNew["DAA006"] = "00:00";//	开单时间
                          drNew["DAA007"] = "0000";//	开单版本
                          drNew["DAA010"] = dr["总装指令工单"];//	总装工单号                              //	
                          drNew["DAA014"] = dr["CAA006"];//	产品编码
                          drNew["DAA015"] = dr["CAA007"];//	产品名称
                          drNew["DAA016"] = dr["CAA008"];//	产品规格
                          drNew["DAA017"] = dr["CAA009"];//	单位
                          drNew["DAA018"] = dr["CAA020"];//变更成下达时间dr["CAA010"].GetString().Substring(0, 10);//	预计开工日期
                          drNew["DAA019"] = dr["CAA020"];//变更成下达时间dr["CAA011"].GetString().Substring(0, 10);//	预计完工日期
                          drNew["DAA020"] = "00:00";//dr["CAA010"].ToString().Length > 10 ? dr["CAA010"].ToString().Substring(11, 5) : "08:00";//	预计开工时间
                          drNew["DAA021"] = "00:00";//dr["CAA011"].ToString().Length > 10 ? dr["CAA010"].ToString().Substring(11, 5) : "17:30";//	预计完工时间
                          drNew["DAA022"] = "新开指令";//	生产状态  新单
                          drNew["DAA027"] = dr["WeiPaiShu"];//	工单数量
                          drNew["DAA028"] = 0;
                          drNew["DAA029"] = 0;
                          drNew["DAA030"] = 0;
                          drNew["DAA031"] = dr["CAA015"];//	BOM版次
                          drNew["DAA032"] = dr["CAA014"];//	工作中心
                          drNew["DAA034"] = "";//指令物料超发类型 
                          drNew["DAA035"] = "";//指令组
                          drNew["DAA036"] = dr["WL008"];//图号
                          drNew["DAA037"] = 0;//备料齐套生产 
                          drNew["DAA038"] = dr["CAA001"];// ERP工单号//dr["CAA002"];//	计划批次
                          drNew["DAA039"] = dr["CAA017"];//	客户订单号
                          drNew["DAA040"] = dr["CAA021"];//	备注
                          drNew["DAA041"] = dr["总装产品编码"];//	目标指令编码
                          drNew["DAA042"] = "";//	生产线别
                          drNew["DAA043"] = dr["CAA002"]; ;//	生产批次编码
                          drNew["DAA044"] = "";//	RoHS区分
                          drNew["DAA045"] = "";//	相关说明
                          drNew["DAA046"] = Loginer.CurrentUser.Account;
                          drNew["DAA047"] = "N";//	程序校验
                          drNew["DAA048"] = 0;//	周计划已开指令
                          drNew["DAA049"] = row[0].ToString() == "A" ? "1" : "2";//	板面标识
                          drNew["DAA050"] = 0; //不良品数
                          drNew["DAA051"] = 0;//备用
                          drNew["DAA052"] = 0;//备用
                          drNew["DAA053"] = 0;//是否退料
                          drNew["DAA054"] = 0;//发料仓库
                          drNew["DAA055"] = 0;//生产优先级
                          drNew["DAA056"] = 0;//下一个指令编码
                          drNew["DAA057"] = dr["CAA018"]; //工单单号
                          drNew["DAA058"] = dr["CAA016"];//	生产工艺
                          drNew["DAA059"] = dr["CAA018"];//	
                          drNew["DAA066"] = tbWOMCAA.Rows[0]["CAA006"].ToString();//
                          drNew["PID"] = dr["ERPID"];//	销售订单号
                          tbWOMDAA.Rows.Add(drNew);
                          #endregion
                      }
                  }
                  else
                  {
                      #region 整体面
                      DataRow drNew = tbWOMDAA.NewRow();
                      drNew["CREATE_BY"] = Loginer.CurrentUser.Account;//	创建者
                      drNew["CREATE_DATE"] = DateTime.Now.ToString("yyyy-MM-dd HH:mm");//	创建时间
                      drNew["DAA001"] = BillNo;//	指令单号 
                      drNew["DAA003"] = dr["CAA003"];//	客户编号
                      drNew["DAA004"] = BillType;    //	工单单别
                      drNew["DAA005"] = DateTime.Now.ToString("yyyy-MM-dd HH:mm"); //	开单日期
                      drNew["DAA006"] = "00:00";//	开单时间
                      drNew["DAA007"] = "0000";//	开单版本
                      //drNew["DAA011"] = tbGCBOM.Rows[0]["生产方案"].ToString(); ;//	生产方案
                      drNew["DAA010"] = dr["总装指令工单"];//	总装工单号    
                      drNew["DAA014"] = dr["CAA006"];//	产品编码
                      drNew["DAA015"] = dr["CAA007"];//	产品名称
                      drNew["DAA016"] = dr["CAA008"];//	产品规格
                      drNew["DAA017"] = dr["CAA009"];//	单位
                      drNew["DAA018"] = DateTime.Now.ToString("yyyy-MM-dd");//变更成下达时间dr["CAA010"].GetString().Substring(0, 10);//	预计开工日期
                      drNew["DAA019"] = DateTime.Now.ToString("yyyy-MM-dd");//变更成下达时间dr["CAA011"].GetString().Substring(0, 10);//	预计完工日期
                      drNew["DAA020"] = "00:00";//dr["CAA010"].ToString().Length > 10 ? dr["CAA010"].ToString().Substring(11, 5) : "08:00";//	预计开工时间
                      drNew["DAA021"] = "00:00";//dr["CAA011"].ToString().Length > 10 ? dr["CAA010"].ToString().Substring(11, 5) : "17:30";//	预计完工时间
                      drNew["DAA022"] = "新开指令";//	生产状态  新单
                      drNew["DAA027"] = dr["WeiPaiShu"]; //i == Convert.ToInt32(dr["ChaiFenGeShu"]) - 1 ? Convert.ToInt32(dr["WeiPaiShu"]) - avg * (Convert.ToInt32(dr["ChaiFenGeShu"]) - 1) : avg;//	工单数量
                      drNew["DAA028"] = 0;
                      drNew["DAA029"] = 0;
                      drNew["DAA030"] = 0;
                      drNew["DAA031"] = dr["CAA015"];//	BOM版次
                      drNew["DAA032"] = dr["CAA014"];//	工作中心
                      drNew["DAA034"] = "";//指令物料超发类型 
                      drNew["DAA035"] = "";//指令组
                      drNew["DAA036"] = dr["WL008"];//图号
                      drNew["DAA037"] = 0;//备料齐套生产 
                      drNew["DAA038"] = dr["CAA001"];//	计划批次
                      drNew["DAA039"] = dr["CAA017"];//	客户名称
                      drNew["DAA040"] = dr["CAA021"];//	备注
                      drNew["DAA041"] = dr["总装产品编码"];//	目标指令编码
                      drNew["DAA042"] = "";//	生产线别
                      drNew["DAA043"] = dr["CAA002"];//	生产批次编码
                      drNew["DAA044"] = "";//	RoHS区分
                      drNew["DAA045"] = "1";//dr["CAA045"];	返工标记（1-量产2试做,3-有任务单返工;4-无任务单返工
                      drNew["DAA046"] = Loginer.CurrentUser.Account;//	审核者
                      drNew["DAA047"] = "N";//	程序校验
                      drNew["DAA048"] = 0;//Convert.ToDecimal(dr["FAuxInHighLimitQty"]);	入库上限值
                      drNew["DAA049"] = "3";//	板面标识
                      drNew["DAA050"] = 0; //不良品数
                      drNew["DAA051"] = 0; //备用ObjectToDecimal(dr["FStdWorkHour"]).ToString();
                      drNew["DAA052"] = 0;//产线人员
                      drNew["DAA053"] = 0;//是否退料
                      drNew["DAA054"] = 0;//发料仓库
                      drNew["DAA055"] = 0;//生产优先级
                      drNew["DAA056"] = 0;//下一个指令编码
                      drNew["DAA057"] = dr["CAA001"];  //工单单号  udpObjectToDecimal(dr["FOldStdWorkHour"]).ToString();
                      drNew["DAA058"] = dr["CAA016"];//	客户订单
                      drNew["DAA059"] = dr["CAA018"];//	销售订单号
                      drNew["DAA067"] = "";
                      drNew["DAA068"] = "";
                      drNew["DAA069"] = "";
                      drNew["DAA071"] = dr["类型"];
                      drNew["DAA073"] = "否";//	是否急料
                      if (tbWOMCAA.Rows.Count<1)
                      {
                          drNew["DAA066"] = "";
                      }
                      else
                      {
                          drNew["DAA066"] = tbWOMCAA.Rows[0]["CAA006"].ToString();
                      }
                      drNew["DAA074"] = dr["总装产品编码"];
                      drNew["PID"] = dr["ERPID"];//
                      tbWOMDAA.Rows.Add(drNew);
                      #endregion		
                  }
              }



              this.gridControl2.DataSource = tbWOMDAA;
              IsSplit = true;

          }

          repositoryItemSearchLookUpEdit1.ValueMember = "指令单号";
          repositoryItemSearchLookUpEdit1.DisplayMember = "指令单号";
          repositoryItemSearchLookUpEdit1.ShowClearButton = false;
          repositoryItemSearchLookUpEdit1.DataSource = tbWOMDAAA;
          //默认筛选框
          this.repositoryItemSearchLookUpEdit1.View.OptionsView.ShowAutoFilterRow = true;

          this.repositoryItemSearchLookUpEdit1.View.BestFitColumns();*/
            #endregion
            string sqlc = string.Format(@"select *  from yhj_womdaa   where  1=2");

            tbWOMDAA = _BLLInstance.GETDAT(sqlc);

            foreach (DataRow row in selRow)
            {
                string workorder = row["任务单号"].ToString();

                // 生成新的工单号
                int count = workorderCount[workorder];
                
                DataRow drNew = tbWOMDAA.NewRow();
                drNew["pc_user"] = Loginer.CurrentUser.Account;//	创建者
                drNew["pc_time"] = DateTime.Now.ToString("yyyy-MM-dd HH:mm");//	创建时间
                drNew["daa001"] = workorder+"-"+ count;
                drNew["item_id"] = row["物料id"].ToString();
                drNew["daa014"] = row["投料单号"].ToString();
                drNew["sccj"] = row["车间"].ToString();

                tbWOMDAA.Rows.Add(drNew);
              
            }
            this.gridControl2.DataSource = tbWOMDAA;
        }

        private string GetMaxBillNo(string erp_wo)
        {
            string sql = string.Format(@"SELECT  ISNULL(max(convert(int,substring(DAA001,charindex('-',DAA001)+1,len(DAA001)-charindex('-',DAA001)))),0) A FROM WOMDAA
            WHERE DAA043='{0}' ", erp_wo);
            DataTable Bno = _BLLInstance.GETDAT(sql);
            return Bno.Rows[0]["A"].ToString();
        }

        //查询
        private void DoSeleteData(IButtonInfo sender)
        {
            

            if (string.IsNullOrEmpty(searchLookUpEdit1.Text))
            {
                MessageBox.Show("请选择车间");
                return;
            }
            frmWaitingEx.ShowMe(this);

            string sql = string.Format(@"select 'N' SelL,c.caa001 任务单号,c.item_id 物料id,c.gd_num 任务数量,isnull(c.YP_num,0)已排数量,c.yj_kgtime 预计开工时间,c.yj_wgtime 预计完工时间,c.ppbom 投料单号,c.cj 车间,b.item_name 物料编号
,b.item_name 物料名称,b.item_no 物料编码

from yhj_womcaa c left join yhj_wlbom b on cast(c.item_id as float)=cast(b.item_id as float) 

where c.gd_num<>isnull(c.YP_num,0)  and cj='{0}'", searchLookUpEdit1.Text);
            tb = _BLLInstance.GETDAT(sql);
            tb.Columns.Add("Sel", Type.GetType("System.Boolean"));
           /* string sqlWOMDAA = string.Format(@"SELECT A.* FROM WOMDAA  A WHERE 1=2 ");
            tbWOMDAA = _BLLInstance.GETDAT(sqlWOMDAA);*/

           /* string sqlWOMGCA = string.Format(@"SELECT A.* FROM WOMGCA  A WHERE 1=2 ");
            tbWOMGCA = _BLLInstance.GETDAT(sqlWOMGCA);*/

            this.gridControl1.DataSource = tb;

            //tbWOMDAAA.Clear();


         /*   string sq1 = string.Format(@"select XT001 线体名称,XT002 所属车间 FROM GS_XT WHERE XT002 = '{0}' ", searchLookUpEdit1.Text);
            XT = _BLLInstance.GETDAT(sq1);

            //tbWOMDAA = CommonData.GetEmptyTable(Globals.DEF_US_DBName, "WOMDAA"); repositoryItemGridLookUpEdit1
            this.repositoryItemGridLookUpEdit1.DataSource = XT;
            this.repositoryItemGridLookUpEdit1.ValueMember = "线体名称";
            this.repositoryItemGridLookUpEdit1.DisplayMember = "线体名称";//控件返回值
            this.repositoryItemCheckEdit1.QueryCheckStateByValue += RepositoryItemCheckEdit1_QueryCheckStateByValue;
*/
            frmWaitingEx.HideMe(this);
        }

        private void frmWOMPlanr_Load(object sender, EventArgs e)
        {
            InitButtons();
            this.gridView2.OptionsView.ShowGroupPanel = false;
            this.gridView3.OptionsView.ShowGroupPanel = false;
            this.gridView1.OptionsView.ShowAutoFilterRow = true;

            //frmGridCustomize.RegisterGrid(gridView1);//注册表格组件，自动添加样式管理、弹出菜单

            //frmGridCustomize.RegisterGrid(gridView2);//注册表格组件，自动添加样式管理、弹出菜单

            //DevStyle.SetDetailGridViewLayout(this.gridView1);//明细表表格样式设置

            //DevStyle.SetDetailGridViewLayout(this.gridView2);//明细表表格样式设置

            gridView2.CellValueChanged += GridView2_CellValueChanged;

            this.gridControl1.DataSource = tb;
            _BLLInstance = new bllyhj_womcaa();


        /*    string sq2 = string.Format(@"SELECT RY002 人员编号,RY003 人员 FROM GS_RY (NOLOCK)");
            RY = _BLLInstance.GETDAT(sq2);*/

            //tbWOMDAA = CommonData.GetEmptyTable(Globals.DEF_US_DBName, "WOMDAA"); repositoryItemGridLookUpEdit1
       /*     this.repositoryItemGridLookUpEdit3.DataSource = RY;
            this.repositoryItemGridLookUpEdit3.ValueMember = "人员";
            this.repositoryItemGridLookUpEdit3.DisplayMember = "人员";//控件返回值
            //默认筛选框
            this.repositoryItemGridLookUpEdit3.View.OptionsView.ShowAutoFilterRow = true;

            string sq3 = string.Format(@"SELECT GYA001 工艺路线,GYA002 生产车间 FROM GS_GYA (NOLOCK)");
            GYLX = _BLLInstance.GETDAT(sq3);

            //tbWOMDAA = CommonData.GetEmptyTable(Globals.DEF_US_DBName, "WOMDAA"); repositoryItemGridLookUpEdit1
            this.repositoryItemSearchLookUpEdit3.DataSource = GYLX;
            this.repositoryItemSearchLookUpEdit3.ValueMember = "工艺路线";
            this.repositoryItemSearchLookUpEdit3.DisplayMember = "工艺路线";//控件返回值
            //默认筛选框
            this.repositoryItemSearchLookUpEdit3.View.OptionsView.ShowAutoFilterRow = true;


            string sqlstr = String.Format(@"SELECT  DISTINCT  A.DAA001 指令单号,A.DAA027 指令数量,(A.DAA027-SUM(ISNULL(C.DAA027,0))) 已排数量,A.DAA020  预计开工时间,A.DAA014 物料编码, A.DAA015 物料名称 ,A.DAA016 物料规格,A.DAA059 销售订单号   FROM WOMDAA  A
                                            LEFT JOIN WOMDAA C  ON C.DAA010 = A.DAA001
                                            WHERE 1=2  
                                            GROUP BY A.DAA001 ,A.DAA027 ,A.DAA020  ,A.DAA014 , A.DAA015  ,A.DAA016,A.DAA059");//WHERE ISNULL(DAA028,0)<DAA027
            tbWOMDAAA = _BLLInstance.GETDAT(sqlstr);
            tbWOMDAAA_B = _BLLInstance.GETDAT(sqlstr);*/


            string sqlstr4 = "SELECT distinct cj 生产车间 FROM yhj_womcaa (NOLOCK) ";//WHERE ISNULL(DAA028,0)<DAA027
            tbBM = _BLLInstance.GETDAT(sqlstr4);
            searchLookUpEdit1.Properties.ValueMember = "生产车间";
            searchLookUpEdit1.Properties.DisplayMember = "生产车间";
            searchLookUpEdit1.Properties.ShowClearButton = false;
            searchLookUpEdit1.Properties.DataSource = tbBM;

            //默认筛选框
            searchLookUpEdit1.Properties.View.OptionsView.ShowAutoFilterRow = true;
            //默认自适应列宽
            searchLookUpEdit1.Properties.View.OptionsView.ColumnAutoWidth = true;




            //关闭自适应列宽
            this.gridView1.BestFitColumns(true);
            //this.gridView2.BestFitColumns(false);
        }

        private void RepositoryItemCheckEdit1_QueryCheckStateByValue(object sender, DevExpress.XtraEditors.Controls.QueryCheckStateByValueEventArgs e)
        {
            string val = "";
            if (e.Value != null)
            {
                val = e.Value.ToString();
            }
            else
            {
                val = "False";//默认为不选   
            }
            switch (val)
            {
                case "True":
                case "Yes":
                case "1":
                    e.CheckState = CheckState.Checked;
                    break;
                case "False":
                case "No":
                case "0":
                    e.CheckState = CheckState.Unchecked;
                    break;
                default:
                    e.CheckState = CheckState.Checked;
                    break;
            }
            //e.Handled = true;
        }

        private void repositoryItemCheckEdit1_Click(object sender, EventArgs e)
        {
            if (tbyp.Rows.Count > 0)
            {
                tbyp.Clear();
            }
      /*      string sq = string.Format(@"SELECT * FROM WOMDAA WHERE left(DAA001,8)='{0}'", gridView1.GetDataRow(gridView1.FocusedRowHandle)["任务单号"].ToString());
            tbyp = _BLLInstance.GETDAT(sq);
            gridControl3.DataSource = tbyp;*/
            if (gridView1.GetDataRow(gridView1.FocusedRowHandle)["SelL"].ToString() == "N")
            {
                gridView1.GetDataRow(gridView1.FocusedRowHandle)["SelL"] = "Y";
            }
            else
            {
                gridView1.GetDataRow(gridView1.FocusedRowHandle)["SelL"] = "N";
            }


        }


        private void gridView1_RowStyle(object sender, DevExpress.XtraGrid.Views.Grid.RowStyleEventArgs e)
        {

         /*   if (e.RowHandle >= 0)
            {
                // 获取类型字段的值  
                string type = gridView1.GetRowCellValue(e.RowHandle, "类型").ToString();

                // 只有当类型是“计划内”时，我们才继续处理  
                if (type == "计划内")
                {
                    e.Appearance.BackColor = Color.Gold;
                    //// 尝试获取后道预计开工时间字段的值  
                    //string startDateString = gridView1.GetRowCellValue(e.RowHandle, "后道预计开工时间").ToString();

                    //// 转换为DateTime类型  
                    //DateTime startDate;
                    //if (DateTime.TryParse(startDateString, out startDate))
                    //{
                    //    // 获取当前日期  
                    //    DateTime currentDate = DateTime.Now.Date;

                    //    // 判断后道预计开工时间是否在今天之前  
                    //    if (startDate < currentDate)
                    //    {
                    //        // 后道预计开工时间在今天之前  
                    //        e.Appearance.BackColor = Color.Gray;
                    //    }
                    //    else
                    //    {
                    //        // 后道预计开工时间在今天之后  
                    //        TimeSpan difference = startDate - currentDate;

                    //        // 根据日期差异设置背景色  
                    //        if (difference.TotalDays <= 1)
                    //        {
                    //            // 未来一天内  
                    //            e.Appearance.BackColor = Color.Red;
                    //        }
                    //        else if (difference.TotalDays <= 3)
                    //        {
                    //            // 未来三天内  
                    //            e.Appearance.BackColor = Color.Gold;
                    //        }
                    //        else if (difference.TotalDays <= 7)
                    //        {
                    //            // 未来七天内  
                    //            e.Appearance.BackColor = Color.LightGreen;
                    //        }
                    //        else
                    //        {
                    //            // 超过未来七天  
                    //            e.Appearance.BackColor = Color.LightBlue;
                    //        }
                    //    }
                    //}
                    //else
                    //{
                    //    // 如果startDateString不是有效的日期时间，可以选择设置一个默认颜色或忽略  
                    //    // e.Appearance.BackColor = Color.White; // 或者其他颜色  
                    //}
                }
            }*/
        }

        

        // 更新模据信息
        private void repositoryItemSearchLookUpEdit2_EditValueChanged(object sender, EventArgs e)
        {


            //获取选择的方案
            int a = repositoryItemSearchLookUpEdit2.GetIndexByKeyValue(gridView2.EditingValue.ToString());

            //遍历，所选工单的方案一致
            foreach (DataRow dr in tbWOMDAA.Rows)
            {
                this.gridView2.SetRowCellValue(gridView2.FocusedRowHandle, gridView2.Columns["DAA068"], tbGCBOM.Rows[a]["模具类型"].ToString());

                this.gridView2.SetRowCellValue(gridView2.FocusedRowHandle, gridView2.Columns["DAA067"], tbGCBOM.Rows[a]["生产方案"].ToString());

                dr["DAA068"] = tbGCBOM.Rows[a]["模具类型"].ToString();
                dr["DAA067"] = tbGCBOM.Rows[a]["生产方案"].ToString();
            }


            string sq = string.Format(@"select MG005 设备名称,MG001 设备编号 FROM BOMMG WHERE MG002 = '{0}'", tbGCBOM.Rows[a]["模具类型"].ToString());

            JT = _BLLInstance.GETDAT(sq);

            ////tbWOMDAA = CommonData.GetEmptyTable(Globals.DEF_US_DBName, "WOMDAA"); repositoryItemGridLookUpEdit1
            this.repositoryItemGridLookUpEdit2.DataSource = JT;
            this.repositoryItemGridLookUpEdit2.ValueMember = "设备名称";
            this.repositoryItemGridLookUpEdit2.DisplayMember = "设备名称";//控件返回值

            //this.repositoryItemCheckEdit1.QueryCheckStateByValue += RepositoryItemCheckEdit1_QueryCheckStateByValue;
        }

        //private void repositoryItemGridLookUpEdit2_EditValueChanged(object sender, EventArgs e)
        //{
        //    int a = repositoryItemGridLookUpEdit2.GetIndexByKeyValue(gridView2.EditingValue.ToString());
            


        //    foreach (DataRow dr in tbWOMDAA.Rows)
        //    {

        //        dr["DAA069"] = gridView2.EditingValue.ToString();
        //        if(gridView2.EditingValue.ToString().Contains("1"))
        //        {
        //            dr["DAA042"] = "高冲1号机";
        //        }
        //        if (gridView2.EditingValue.ToString().Contains("2"))
        //        {
        //            dr["DAA042"] = "高冲2号机";
        //        }
        //        if (gridView2.EditingValue.ToString().Contains("3"))
        //        {
        //            dr["DAA042"] = "高冲3号机";
        //        }
        //        if (gridView2.EditingValue.ToString().Contains("4"))
        //        {
        //            dr["DAA042"] = "高冲4号机";
        //        }
        //        if (gridView2.EditingValue.ToString().Contains("5"))
        //        {
        //            dr["DAA042"] = "高冲5号机";
        //        }
        //        if (gridView2.EditingValue.ToString().Contains("6"))
        //        {
        //            dr["DAA042"] = "高冲6号机";
        //        }
        //        if (gridView2.EditingValue.ToString().Contains("7"))
        //        {
        //            dr["DAA042"] = "高冲7号机";
        //        }
        //        if (gridView2.EditingValue.ToString().Contains("8"))
        //        {
        //            dr["DAA042"] = "高冲8号机";
        //        }
        //        if (gridView2.EditingValue.ToString().Contains("9"))
        //        {
        //            dr["DAA042"] = "高冲9号机";
        //        }

        //    }
        //}



        // 添加CellValueChanged事件的处理方法
        
// CellValueChanged事件处理方法
        private void GridView2_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
        {
            // 获取当前改变的单元格所在的行和列信息
            int rowHandle = e.RowHandle;
            int columnIndex = e.Column.VisibleIndex;


            // 遍历所有行
            if (e.Column.ToString() == "开工日期")
            {
                foreach (DataRow dr in tbWOMDAA.Rows)
                {

                    dr["DAA018"] = gridView2.EditingValue.ToString();
                    dr["DAA019"] = gridView2.EditingValue.ToString();
                }
                return;
            }

            if (e.Column.ToString() == "完工日期")
            {
                foreach (DataRow dr in tbWOMDAA.Rows)
                {

                    dr["DAA019"] = gridView2.EditingValue.ToString();
                }
                return;
            }

            if (e.Column.ToString() == "人员")
            {
                foreach (DataRow dr in tbWOMDAA.Rows)
                {

                    dr["DAA040"] = gridView2.EditingValue.ToString();
                }
                return;
            }


            if (e.Column.ToString() == "线别")
            {
                foreach (DataRow dr in tbWOMDAA.Rows)
                {

                    dr["DAA042"] = gridView2.EditingValue.ToString();
                }
                return;
            }

            if (e.Column.ToString() == "工艺路线")
            {
                foreach (DataRow dr in tbWOMDAA.Rows)
                {

                    dr["GYLX"] = gridView2.EditingValue.ToString();
                }
                return;
            }

            if (e.Column.ToString() == "是否急料")
            {
                foreach (DataRow dr in tbWOMDAA.Rows)
                {

                    dr["DAA073"] = gridView2.EditingValue.ToString();
                }
                return;
            }

            return;

        }

       
    }
}