/// <summary> /// /// </summary> private void SearchCuttingHeader() { try { splashScreenManager1.ShowWaitForm(); //create expression ParameterExpression argParam = Expression.Parameter(typeof(CuttingHeader), "s"); Expression nameProperty = Expression.Property(argParam, "CuttingHeaderID"); Expression namespaceProperty = Expression.Property(argParam, "StyleID"); var val1 = Expression.Constant(txtSearchBox.Text); var val2 = Expression.Constant(txtSearchBox.Text); //expresttion 1 Expression e1 = Expression.Call(nameProperty, "Contains", null, val1); // expresstion 2 Expression e2 = Expression.Call(namespaceProperty, "Contains", null, val2); var andExp = Expression.Or(e1, e2); // get expresttion to labda objet var lambda1 = Expression.Lambda<Func<CuttingHeader, bool>>(andExp, argParam); // pass object to query GenaricRepository<CuttingHeader> _SearchHeaderRepository = new GenaricRepository<CuttingHeader>(new ItrackContext()); var selected = from item in _SearchHeaderRepository.SearchFor(lambda1).ToList() select new { item.CuttingHeaderID, item.StyleID, item.OrderQuantity, item.Date, item.Remark }; //check is record exist in selected item if (selected.Count() > 0) { grdSearch.Show(); btnClose.Show(); grdSearch.DataSource = selected; } else { grdSearch.DataSource = null; } splashScreenManager1.CloseWaitForm(); } catch (Exception ex) { Debug.WriteLine(ex.Message); MessageBox.Show(ex.Message, "Error - B-0007", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void Search() { try { //create expression ParameterExpression argParam = Expression.Parameter(typeof(ScaningTimeSchadual), "s"); Expression nameProperty = Expression.Property(argParam, "ScaningTime"); Expression namespaceProperty = Expression.Property(argParam, "ScaningTime"); var val1 = Expression.Constant(txtScanTime.Text); var val2 = Expression.Constant(txtScanTime.Text); //expresttion 1 Expression e1 = Expression.Call(nameProperty, "Contains", null, val1); // expresstion 2 Expression e2 = Expression.Call(namespaceProperty, "Contains", null, val2); var andExp = Expression.Or(e1, e2); GenaricRepository<ScaningTimeSchadual> _ScaningTimeSchadualRepository = new GenaricRepository<ScaningTimeSchadual>(new ItrackContext()); // get expresttion to labda objet var lambda1 = Expression.Lambda<Func<ScaningTimeSchadual, bool>>(andExp, argParam); // pass object to query var selected = from item in _ScaningTimeSchadualRepository.SearchFor(lambda1).ToList() select new { item.ScaningTimeSchadualID, item.HourNO, item.ScaningTime }; grdSearch.Show(); //check is record exist in selected item if (selected.Count() > 0) { grdSearch.DataSource = selected; } else { grdSearch.DataSource = null; } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error - B-0007", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void SearchPo() { try { GenaricRepository<PO> _PORepo = new GenaricRepository<PO>(new ItrackContext()); //create expression ParameterExpression argParam = Expression.Parameter(typeof(PO), "s"); Expression nameProperty = Expression.Property(argParam, "POID"); Expression namespaceProperty = Expression.Property(argParam, "SupplierMasterID"); var val1 = Expression.Constant(txtSearchBox.Text); var val2 = Expression.Constant(txtSearchBox.Text); //expresttion 1 Expression e1 = Expression.Call(nameProperty, "Contains", null, val1); // expresstion 2 Expression e2 = Expression.Call(namespaceProperty, "Contains", null, val2); var andExp = Expression.Or(e1, e2); // get expresttion to labda objet var lambda1 = Expression.Lambda<Func<PO, bool>>(andExp, argParam); // pass object to query var selected = from item in _PORepo.SearchFor(lambda1).ToList() select new { item.POID, item.SupplierName, item.Date }; //check is record exist in selected item if (selected.Count() > 0) { grdPOSearch.Show(); btnClose.Show(); grdPOSearch.DataSource = selected; } else { grdPOSearch.DataSource = null; } } catch (Exception ex) { } }
private void SearchOperation() { try { GenaricRepository<OperationPool> _OperationRepository = new GenaricRepository<OperationPool>(new ItrackContext()); //create expression ParameterExpression argParam = Expression.Parameter(typeof(OperationPool), "s"); Expression nameProperty = Expression.Property(argParam, "OperationPoolID"); Expression namespaceProperty = Expression.Property(argParam, "OpationName"); var val1 = Expression.Constant(txtOperationNo.Text); var val2 = Expression.Constant(txtOName.Text); //expresttion 1 Expression e1 = Expression.Call(nameProperty, "Contains", null, val1); // expresstion 2 Expression e2 = Expression.Call(namespaceProperty, "Contains", null, val2); if (chkAnd.Checked == true) { var andExp = Expression.And(e1, e2); // get expresttion to labda objet var lambda1 = Expression.Lambda<Func<OperationPool, bool>>(andExp, argParam); // pass object to query var selected = from item in _OperationRepository.SearchFor(lambda1).ToList() select new { item.OperationPoolID, item.OpationName, item.SMV, item.SMVType, item.PartName, item.MachineType }; lst.Clear(); foreach (var op in selected) { lst.Add(new OperationListSelection(op.OperationPoolID, op.OpationName, op.SMV, 0, false, op.SMVType, op.PartName, "None", op.MachineType)); } } else if (chkOr.Checked == true) { var andExp = Expression.Or(e1, e2); // get expresttion to labda objet var lambda1 = Expression.Lambda<Func<OperationPool, bool>>(andExp, argParam); // pass object to query var selected = from item in _OperationRepository.SearchFor(lambda1).ToList() select new { item.OperationPoolID, item.OpationName, item.SMV, item.SMVType, item.PartName, item.MachineType }; lst.Clear(); foreach (var op in selected) { lst.Add(new OperationListSelection(op.OperationPoolID, op.OpationName, op.SMV, 0, false, op.SMVType, op.PartName, "None", op.MachineType)); } } //check is record exist in selected item if (lst.Count() > 0) { grdOpList.Show(); grdOpList.DataSource = lst; grdOpList.RefreshDataSource(); } else { grdOpList.DataSource = null; } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error - B-0007", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void SearchItemType() { try { GenaricRepository<CustomeFieldSetup> _CustomFieldRepo = new GenaricRepository<CustomeFieldSetup>(new ItrackContext()); //create expression ParameterExpression argParam = Expression.Parameter(typeof(CustomeFieldSetup), "s"); Expression nameProperty = Expression.Property(argParam, "ItemType"); Expression namespaceProperty = Expression.Property(argParam, "CustomField1"); var val1 = Expression.Constant(txtItemType.Text); var val2 = Expression.Constant(txtItemType.Text); //expresttion 1 Expression e1 = Expression.Call(nameProperty, "Contains", null, val1); // expresstion 2 Expression e2 = Expression.Call(namespaceProperty, "Contains", null, val2); var andExp = Expression.Or(e1, e2); // get expresttion to labda objet var lambda1 = Expression.Lambda<Func<CustomeFieldSetup, bool>>(andExp, argParam); // pass object to query var selected = from item in _CustomFieldRepo.SearchFor(lambda1).ToList() select new {item.CustomeFieldSetupID ,item.ItemType }; //check is record exist in selected item if (selected.Count() > 0) { grdSearchItemType.Show(); btnClose.Show(); grdSearchItemType.DataSource = selected; } else { grdSearchItemType.DataSource = null; } } catch (Exception ex) { } }
//Search Items private void SearchItem() { try { splashScreenManager1.ShowWaitForm(); GenaricRepository<Items> _ItemMasterRepo = new GenaricRepository<Items>(new ItrackContext()); //create expression ParameterExpression argParam = Expression.Parameter(typeof(Items), "s"); Expression nameProperty = Expression.Property(argParam, "ItemsID"); Expression namespaceProperty = Expression.Property(argParam, "CustomFiled1"); var val1 = Expression.Constant(txtSearchBox.Text); var val2 = Expression.Constant(txtSearchBox.Text); //expresttion 1 Expression e1 = Expression.Call(nameProperty, "Contains", null, val1); // expresstion 2 Expression e2 = Expression.Call(namespaceProperty, "Contains", null, val2); var andExp = Expression.Or(e1, e2); // get expresttion to labda objet var lambda1 = Expression.Lambda<Func<Items, bool>>(andExp, argParam); // pass object to query var selected = from item in _ItemMasterRepo.SearchFor(lambda1).ToList() select new { item.ItemsID,item.ItemType,item.CustomFiled1,item.CustomField2 }; //check is record exist in selected item if (selected.Count() > 0) { grdSearch.Show(); btnClose.Show(); grdSearch.DataSource = selected; } else { grdSearch.DataSource = null; } splashScreenManager1.CloseWaitForm(); } catch(Exception ex) { } }
private void SearchCompany() { try { splashScreenManager1.ShowWaitForm(); GenaricRepository<Company> _genaricrepositorycompany = new GenaricRepository<Company>(new ItrackContext()); //create expression ParameterExpression argParam = Expression.Parameter(typeof(Company), "s"); Expression nameProperty = Expression.Property(argParam, "CompanyName"); Expression namespaceProperty = Expression.Property(argParam, "CompanyName"); var val1 = Expression.Constant(txtSearchBox.Text); var val2 = Expression.Constant(txtSearchBox.Text); //expresttion 1 Expression e1 = Expression.Call(nameProperty, "Contains", null, val1); // expresstion 2 Expression e2 = Expression.Call(namespaceProperty, "Contains", null, val2); var andExp = Expression.Or(e1, e2); // get expresttion to labda objet var lambda1 = Expression.Lambda<Func<Company, bool>>(andExp, argParam); // pass object to query var selected = from item in _genaricrepositorycompany.SearchFor(lambda1).ToList() select new { item.CompanyID, item.CompanyName, item.CompanyAddress }; //check is record exist in selected item if (selected.Count() > 0) { grdCompany.Show(); btnClose.Show(); grdCompany.DataSource = selected; } else { grdCompany.DataSource = null; } splashScreenManager1.CloseWaitForm(); } catch (Exception ex) { } }