public ActionResult Search(string filter, string saldo, int? page, int? pagesize)
        {
            try
            {
                LogBLL.Insert(new LogDado("Search", "Material", _idUsuario));
                using (var db = new Context())
                {
                    var _bll = new BLL.MaterialBLL(db, _idUsuario);
                    ViewBag.saldo = saldo;

                    var result = _bll.Search(filter, saldo, page, pagesize);

                    return View("Index", result);
				}
            }
            catch (Exception ex)
            {
                Util.Entity.ErroLog.Add(ex, Session.SessionID, _idUsuario);
                return RedirectToAction("Index", "Erro", new { area = string.Empty });
            }
        }		
        public JsonResult JsSearch(string filter, int? page, int? pagesize)
        {
            try
            {
                using (var db = new Context())
                {
                    var _bll = new BLL.MaterialBLL(db, _idUsuario);

                    var result = _bll.Search(filter, "todos", page, pagesize);

                    var list = result.Select(s => new 
                    {
                        s.idMaterial,
                        s.nome,
                        s.margemGanho,
                        s.preco
                    });

                    return Json(new Util.Class.JsonCollection { result = list, count = result.TotalCount }, JsonRequestBehavior.AllowGet);
				}
            }
            catch (Exception ex)
            {
                Response.StatusCode = 500;
                return Json(RP.Util.Exception.Message.Get(ex), JsonRequestBehavior.AllowGet);
            }
        }