// // GET: /Sale/ public ActionResult Search() { string sCreated = Request["trade_sdate"]; string sHours = Request["trade_sdate_hour"]; string sMinutes = Request["trade_sdate_minute"]; string eCreated = Request["trade_edate"]; string eHours = Request["trade_edate_hour"]; string eMinutes = Request["trade_edate_minute"]; string productName = Request["pdt_name"]; string buyer_nick = Request["buyer_nick"]; string trade_num = Request["trade_num"]; string trade_status = Request["trade_status"]; int shop = 0; int page = 1; int pageSize = 30; int.TryParse(Request["page"], out page); int.TryParse(Request["pagesize"], out pageSize); int.TryParse(Request["trade_shop"], out shop); if (page <= 0) { page = 1; } if (pageSize <= 0) { pageSize = 30; } DateTime sDate = DateTime.MinValue; DateTime eDate = DateTime.MinValue; if (!string.IsNullOrEmpty(sCreated) && !string.IsNullOrEmpty(sHours) && !string.IsNullOrEmpty(sMinutes)) { sDate = Convert.ToDateTime(sCreated); int h = 0; int m = 0; int.TryParse(sHours, out h); int.TryParse(sMinutes, out m); sDate = new DateTime(sDate.Year, sDate.Month, sDate.Day, h, m, 0); } if (!string.IsNullOrEmpty(eCreated) && !string.IsNullOrEmpty(eHours) && !string.IsNullOrEmpty(eMinutes)) { eDate = Convert.ToDateTime(eCreated); int h = 0; int m = 0; int.TryParse(eHours, out h); int.TryParse(eMinutes, out m); eDate = new DateTime(eDate.Year, eDate.Month, eDate.Day, h, m, 0); } string user_id = HttpContext.User.Identity.Name; UserManager userMgr = new UserManager(int.Parse(user_id), null); BUser user = userMgr.CurrentUser; StockManager stockManager = new StockManager(userMgr.CurrentUser, userMgr.Shop, userMgr.CurrentUserPermission); SalesManager saleManager = new SalesManager(userMgr.CurrentUser, userMgr.Shop, userMgr.CurrentUserPermission); ShopManager shopManager = new ShopManager(userMgr.CurrentUser, userMgr.Shop, userMgr.CurrentUserPermission, userMgr); int total = 0; long sTime = 0; long eTime = 0; if (sDate != DateTime.MinValue) { sTime = DateTimeUtil.ConvertDateTimeToInt(sDate); } if (eDate != DateTime.MinValue) { eTime = DateTimeUtil.ConvertDateTimeToInt(eDate); } string[] nums = null; if (!string.IsNullOrEmpty(trade_num)) { nums = trade_num.Split(','); } string[] status = null; if (!string.IsNullOrEmpty(trade_status)) { status = trade_status.Split(','); } List<BSale> sales = saleManager.SearchSales(null, productName, nums, status, null, buyer_nick, sTime, eTime, page, pageSize, out total, shop); BPageData data = new BPageData(); data.Data = sales; data.TotalRecords = total; data.Page = page; data.PageSize = pageSize; data.URL = Request.RawUrl; List<BShop> childShops = shopManager.SearchChildShops(); ViewData["ChildShop"] = childShops; ViewData["CurrentShop"] = userMgr.Shop; ViewData["MainShop"] = userMgr.Main_Shop; return View(data); }
public PQGridData SearchSales() { PQGridData data = new PQGridData(); HttpContextBase context = (HttpContextBase)Request.Properties["MS_HttpContext"]; HttpRequestBase request = context.Request; string user_id = User.Identity.Name; UserManager userMgr = new UserManager(int.Parse(user_id), null); BUser user = userMgr.CurrentUser; StockManager stockManager = new StockManager(userMgr.CurrentUser, userMgr.Shop, userMgr.CurrentUserPermission); SalesManager saleManager = new SalesManager(userMgr.CurrentUser, userMgr.Shop, userMgr.CurrentUserPermission); int page = 1; int pageSize = 30; long stime = 0; long etime = 0; if (!string.IsNullOrEmpty(request["sdate"])) { DateTime sdate = DateTime.MinValue; DateTime.TryParse(request["sdate"], out sdate); if (sdate != DateTime.MinValue) { stime = DateTimeUtil.ConvertDateTimeToInt(sdate); } } if (!string.IsNullOrEmpty(request["edate"])) { DateTime edate = DateTime.MinValue; DateTime.TryParse(request["edate"], out edate); if (edate != DateTime.MinValue) { etime = DateTimeUtil.ConvertDateTimeToInt(edate); } } int.TryParse(request["page"], out page); int.TryParse(request["pageSize"], out pageSize); int total = 0; data.data = saleManager.SearchSales(null,null,null,null, null,null, stime, etime, page, pageSize, out total); data.totalRecords = total; return data; }