private void SearchOrderBackgroud(OrdersArgs oa) { entity.CainzOrder o = oa.OrderForSearch; using (var db = PublicDB.getDB(60)) { if (o == null) { oa.Orders = (from a in db.CainzOrder where a.IsDelete == 0 && (a.Status == 0 || a.Status == 1) orderby a.OrderNo descending select a).ToList(); } else { oa.Orders = (from a in db.CainzOrder where a.IsDelete == 0 && (a.Status == 0 || a.Status == 1) && (a.OrderExNo.Contains(o.OrderExNo) || a.OrderNo.Contains(o.OrderExNo)) && a.TraderName.Contains(o.TraderName) orderby a.OrderNo descending select a).ToList(); } } }
private void SearchForMain() { Frozen(true); entity.CainzOrder _orderForSearch = new entity.CainzOrder(); _orderForSearch.OrderExNo = txbSearch.Text.Trim(); _orderForSearch.TraderName = txbTraderForSearch.Text.Trim(); BackgroundWorker work = new BackgroundWorker(); work.DoWork += Work_DoWork; work.RunWorkerCompleted += Work_RunWorkerCompleted; OrdersArgs oa = new OrdersArgs(); oa.OrderForSearch = _orderForSearch; work.RunWorkerAsync(oa); }