示例#1
0
        public IQueryable <TLSPN_QAMeasurements> QAMeasurementQuery(SpinningQueryParameters parameters)
        {
            IQueryable <TLSPN_QAMeasurements> QAItems = null;

            QAItems = _context.TLSPN_QAMeasurements.Where(x => x.YarnQA_Date >= parameters.FromDate && x.YarnQA_Date <= parameters.ToDate && x.YarnQA_MeasureNo == parameters.MeasurementOpt).AsQueryable();

            if (parameters.MeasurementOpt == 3)
            {
                if (!parameters.OutSideTolerance)
                {
                    QAItems = QAItems.Where(x => x.YarnQA_12H00 > parameters.LowerTolerance && x.YarnQA_12H00 <= parameters.UpperTolerance).AsQueryable();
                }
                else
                {
                    QAItems = QAItems.Where(x => x.YarnQA_12H00 < parameters.LowerTolerance || x.YarnQA_12H00 >= parameters.UpperTolerance).AsQueryable();
                }
            }

            if (parameters.Machines.Count > 0)
            {
                var MeasurementPredicate = PredicateBuilder.False <TLSPN_QAMeasurements>();
                foreach (var Machine in parameters.Machines)
                {
                    var temp = Machine;
                    MeasurementPredicate = MeasurementPredicate.Or(s => s.YarnQA_MachineNo_FK == temp.MD_Pk);
                }

                QAItems = QAItems.AsExpandable().Where(MeasurementPredicate);
            }


            return(QAItems);
        }
示例#2
0
        public IQueryable <TLSPN_YarnOrder> YarnOrderQuery(SpinningQueryParameters parameters)
        {
            var yarnOrders = _context.TLSPN_YarnOrder.Where(x => !(bool)x.Yarno_Closed && x.YarnO_Date >= parameters.FromDate && x.YarnO_Date <= parameters.ToDate).AsQueryable();

            if (parameters.YarnOrders.Count > 0)
            {
                var yarnOrderPredicate = PredicateBuilder.False <TLSPN_YarnOrder>();
                foreach (var yarnOrder in parameters.YarnOrders)
                {
                    var temp = yarnOrder;
                    yarnOrderPredicate = yarnOrderPredicate.Or(s => s.YarnO_Pk == temp.YarnO_Pk);
                }

                yarnOrders = yarnOrders.AsExpandable().Where(yarnOrderPredicate);
            }

            if (parameters.YarnTypes.Count > 0)
            {
                var yarnTypePredicate = PredicateBuilder.False <TLSPN_YarnOrder>();
                foreach (var yarnType in parameters.YarnTypes)
                {
                    var temp = yarnType;
                    yarnTypePredicate = yarnTypePredicate.Or(s => s.Yarno_YarnType_FK == temp.YA_Id);
                }

                yarnOrders = yarnOrders.AsExpandable().Where(yarnTypePredicate);
            }

            return(yarnOrders);
        }
示例#3
0
        private void frmQAReportSelection_Load(object sender, EventArgs e)
        {
            formloaded = false;


            QueryParms = new SpinningQueryParameters();

            txtBottomTolerance.Text = "4410";
            txtTopTolerance.Text    = "4590";

            core = new Util();

            txtBottomTolerance.KeyPress += core.txtWin_KeyPress;
            txtBottomTolerance.KeyDown  += core.txtWin_KeyDownJI;

            txtTopTolerance.KeyPress += core.txtWin_KeyPress;
            txtTopTolerance.KeyDown  += core.txtWin_KeyDownJI;


            rbOutsideTNo.Checked = true;



            using (var context = new TTI2Entities())
            {
                var deptdetails = context.TLADM_Departments.Where(x => x.Dep_ShortCode == "SPIN").FirstOrDefault();
                if (deptdetails != null)
                {
                    var Machines = context.TLADM_MachineDefinitions.Where(x => x.MD_Department_FK == deptdetails.Dep_Id).OrderBy(x => x.MD_Description).ToList();
                    foreach (var Machine in Machines)
                    {
                        cmboRSBMachines.Items.Add(new Spinning.CheckComboBoxItem(Machine.MD_Pk, Machine.MD_MachineCode, false));
                    }

                    cmboRSBMachines.SelectedValue = 0;
                }
            }

            formloaded = true;
        }