耳座操作流程

        private void FormLug_Load(object sender, EventArgs e)
        {
            cbType.Items.Clear();
            FieldListLug.Clear();//字段清除
            //System.Drawing.Image img=Image.FromFile(@"");
            //pbShow.Image = img;
            string where = string.Format("DnX < {0} and DnD > {0}", DI);//定义查询条件
            //where = "DnX < " + DI.ToString() + " and DnD > " + DI.ToString();
            FieldListLug.Add("TypeE");//要查询的列
            tbType = GetAccessData(TypeName, FieldListLug, where);//获得查询出来的表
            TypeList = tbType.AsEnumerable().Select(p => p.Field<string>("TypeE")).Distinct().ToList();//将表变成列
            cbType.Items.AddRange(TypeList.ToArray());//变成列加入控件中
        }
        private void cbType_SelectedIndexChanged(object sender, EventArgs e)//CBTYPE里面数据变化时产生的操作
        {
            cbNum.Items.Clear();
            cbbHasCover.Enabled = true;//默认CHACKBOX初始时为可以改变
            FieldListLug.Clear();//清除耳座字段列表
            string where = string.Format("DnX < {0} and DnD > {0}", DI);//定义查找条件字符串
            FieldListLug.Add("LugNumber");//将需要的列的字段加入字段列 可以加入多个
            string TableName;
            if (cbType.Text == "A")
            {
                 TableName = "Y_SUPPORT_LUG_4712_3_2007_A";
                 tbNum = GetAccessData(TableName, FieldListLug,
                 where);//查询表 使用查询语句将表名 条件 字段列加入获得顶板表
            }
            else if(cbType.Text == "B")
            {
                 TableName = "Y_SUPPORT_LUG_4712_3_2007_B";
                 tbNum = GetAccessData(TableName, FieldListLug,
                 where);//查询表 使用查询语句将表名 条件 字段列加入获得顶板表
            }
            else if(cbType.Text == "C")
            {
                TableName = "Y_SUPPORT_LUG_4712_3_2007_C";
                tbNum = GetAccessData(TableName, FieldListLug,
                where);//查询表 使用查询语句将表名 条件 字段列加入获得顶板表
            }
            NumList = tbNum.AsEnumerable().Select(p => p.Field<int>("LugNumber").ToString()).Distinct().ToList();
            cbNum.Items.AddRange(NumList.ToArray());
            FieldListLug.Clear();//清除耳座字段列表
            FieldListLug.Add("HasCover");//将需要的列的字段加入字段列 可以加入多个
            string where1 = string.Format("DnX < {0} and DnD > {0} and TypeE ='{1}'", DI,cbType.Text);//定义查找条件字符串
            tbTopPlate = GetAccessData(TypeName, FieldListLug, where1);
            TopPlateList = tbTopPlate.AsEnumerable()
             .Select(p => p.Field<bool>("HasCover")).Distinct().ToList();//将获得的表变成列 p.Field<>中类型要保持一致，Distinct（）将重复的去除
            if (TopPlateList.Count == 1)//如果TopPlateList中只有一个数据 则始终不能改变
            {
                if (TopPlateList[0])//获取列中第一个数据 因为是一个BOOL型的列 如果第一个数据是TURE则有盖板并且成立
                {
                    cbbHasCover.Checked = true;//选择有盖板
                    cbbHasCover.Enabled = false;//并且不能改变
                }
                else//如果没有
                {
                    cbbHasCover.Checked = false;//选择无盖板
                    cbbHasCover.Enabled = false;//也不能改变
                }
                
            }
            else
            {
                TopPlateChange(cbbHasCover.Checked);
            }
        }
        private void TopPlateChange(bool hasTopPlate)
        {
            cbNum.Items.Clear();
            tbNum.Clear();
            FieldListLug.Clear();//清除耳座字段列表
            FieldListLug.Add("LugNumber");
            string where = string.Format("DnX < {0} and DnD > {0} and TypeE = '{1}' and HasCover = {2}", DI, cbType.Text,cbbHasCover.Checked);//定义查找条件字符串
            tbNum = GetAccessData(TypeName, FieldListLug,
                    where);//查询表 使用查询语句将表名 条件 字段列加入获得顶板表
            NumList1 = tbNum.AsEnumerable().Select(p => p.Field<int>("LugNumber").ToString()).Distinct().ToList();
            NumList1 = NumList1.Intersect(NumList).ToList();
            cbNum.Items.AddRange(NumList1.ToArray());
        }
        private void cbbHasCover_CheckedChanged(object sender, EventArgs e)
        {
            TopPlateChange(cbbHasCover.Checked);
        }
        private void cbNum_SelectedIndexChanged(object sender, EventArgs e)
        {
            FieldListLug.Clear();//继续清除字段
            if (cbType.Text == "A")//选择了A
            {
                string killedString = "";
                killedString = "ID,lugNumber,q1,q2,DnX,DnD,Th,kg";
                DataTable tbSize = GetAccessData("Y_SUPPORT_LUG_4712_3_2007_A");
                FieldListLug = tbSize.GetFieldList(killedString);
                string TableName = "Y_SUPPORT_LUG_4712_3_2007_A";//查询表A
                string where = string.Format("LugNumber = {0} ", int.Parse(cbNum.Text));//定义查询条件
                tbValue = GetAccessData(TableName, FieldListLug, where);//查出需要的表
            }
            else if (cbType.Text == "B")//选择B
            {
                string killedString = "";//定义去除字段
                killedString = "ID,lugNumber,q1,q2,DnX,DnD,Th,kg";//去除一些没用的字段
                DataTable tbSize = GetAccessData("Y_SUPPORT_LUG_4712_3_2007_B");//查找表
                FieldListLug = tbSize.GetFieldList(killedString);//获取去除后的字段清单
                string TableName = "Y_SUPPORT_LUG_4712_3_2007_B";//定义查询表
                string where = string.Format("LugNumber = {0} ", int.Parse(cbNum.Text));//定义条件
                tbValue = GetAccessData(TableName, FieldListLug, where);//查出需要的表 去除无用信息后的数据
            }
            else if (cbType.Text == "C")//选择C
            {
                string killedString = "";
                killedString = "ID,lugNumber,q1,q2,DnX,DnD,Th,kg";
                DataTable tbSize = GetAccessData("Y_SUPPORT_LUG_4712_3_2007_C");
                FieldListLug = tbSize.GetFieldList(killedString);
                string TableName = "Y_SUPPORT_LUG_4712_3_2007_C";
                string where = string.Format("LugNumber = {0} ", int.Parse(cbNum.Text));
                tbValue = GetAccessData(TableName, FieldListLug, where);
            }

        }