public ActionResult Index(ListItem_model Model, int?page) { var pageNumber = page ?? 1; int total = new int(); List <DisplayItem_model> lstModel = new List <DisplayItem_model>(); List <GetCatetory_model> lstcombobox = new List <GetCatetory_model>(); if (!string.IsNullOrEmpty(Session["code"] as string)) { Model.code = Session["code"].ToString(); } if (!string.IsNullOrEmpty(Session["name"] as string)) { Model.name = Session["name"].ToString(); } if (Session["category_id"] as int? != null) { Model.category_id = (int)Session["category_id"]; } _itemBLL.Search(Model, out lstModel, out total, pageNumber); var list = new StaticPagedList <DisplayItem_model>(lstModel, pageNumber, 15, total); ViewBag.ListSearch = lstModel.OrderByDescending(x => x.id); _itemBLL.GetCategory(true, out lstcombobox); ViewBag.lstcombobox = lstcombobox; ViewBag.page = 0; if (page != null) { ViewBag.page = pageNumber - 1; } return(View(new Tuple <ListItem_model, IPagedList <DisplayItem_model> >(Model, list))); }
public int Search(ListItem_model searchCondition, out List <DisplayItem_model> lstModel, out int total, int _page) { _page = _page * 15 - 15; int returnCode = (int)Common.ReturnCode.Succeed; lstModel = new List <DisplayItem_model>(); total = new int(); try { string sql = "SELECT item.`id`, item.`code`, item.`name`, cate.`name` AS category_name, item.`specification`, item.`description` "; sql += "FROM `product_item` AS item "; sql += "JOIN (SELECT c.`id`, cpp.`name` AS category_parent_name, c.`name` "; sql += "FROM `product_category` AS c "; sql += "LEFT JOIN (SELECT cp.`name`, cp.`id` FROM `product_category` cp) cpp on cpp.`id` = c.`parent_id` "; sql += ") cate ON item.`category_id` = cate.`id` WHERE TRUE "; string _sql = "SELECT count(item.`id`) "; _sql += "FROM `product_item` AS item "; _sql += "JOIN (SELECT c.`id`, cpp.`name` AS category_parent_name, c.`name` "; _sql += "FROM `product_category` AS c "; _sql += "LEFT JOIN (SELECT cp.`name`, cp.`id` FROM `product_category` cp) cpp on cpp.`id` = c.`parent_id` "; _sql += ") cate ON item.`category_id` = cate.`id` WHERE TRUE "; if (!string.IsNullOrEmpty(searchCondition.category_id.ToString())) { sql += "AND (item.`category_id` = @category_id OR item.`category_id` IN (SELECT cate.`id` FROM `product_category` cate WHERE cate.`parent_id` = @category_id)) "; _sql += "AND (item.`category_id` = @category_id OR item.`category_id` IN (SELECT cate.`id` FROM `product_category` cate WHERE cate.`parent_id` = @category_id)) "; } if (!string.IsNullOrEmpty(searchCondition.code)) { sql += "AND item.`code` LIKE @code "; _sql += "AND item.`code` LIKE @code "; } if (!string.IsNullOrEmpty(searchCondition.name)) { sql += "AND item.`name` LIKE @name "; _sql += "AND item.`name` LIKE @name "; } sql += " LIMIT @page,15"; lstModel = db.Query <DisplayItem_model>(sql, new { category_id = searchCondition.category_id, code = '%' + searchCondition.code + '%', name = '%' + searchCondition.name + '%', page = _page }).ToList(); total = db.ExecuteScalar <int>(_sql, new { category_id = searchCondition.category_id, code = '%' + searchCondition.code + '%', name = '%' + searchCondition.name + '%', page = _page }); } catch (Exception ex) { return(returnCode = (int)Common.ReturnCode.UnSuccess); } return(returnCode); }
public ActionResult IndexPost(ListItem_model Model, int?page) { var pageNumber = page ?? 1; List <DisplayItem_model> lstModel = new List <DisplayItem_model>(); List <GetCatetory_model> lstcombobox = new List <GetCatetory_model>(); int total = new int(); _itemBLL.Search(Model, out lstModel, out total, pageNumber); var list = new StaticPagedList <DisplayItem_model>(lstModel, pageNumber, 15, total); ViewBag.ListSearch = lstModel.OrderByDescending(x => x.id); Session["code"] = Model.code; Session["name"] = Model.name; Session["category_id"] = Model.category_id; TempData["CountResult"] = total.ToString() + " row(s) found!"; _itemBLL.GetCategory(true, out lstcombobox); ViewBag.lstcombobox = lstcombobox; return(View(new Tuple <ListItem_model, IPagedList <DisplayItem_model> >(Model, list))); }
public int Search(ListItem_model model, out List <DisplayItem_model> lstmodel, out int total, int _page) { return(item_bll.Search(model, out lstmodel, out total, _page)); }