public async Task <IActionResult> List(int page = 1, int pageSize = 10, string storeName = "", string businessId = "") { string where = _commonAppService.GetWhere(); if (!string.IsNullOrEmpty(storeName)) { where = $" and c.Name like '%{storeName}%'"; } if (!string.IsNullOrEmpty(businessId)) { where += $" and c.BusinessId = {businessId}"; } int total; DataSet ds = _AppService.GetPage(page, pageSize, "c.sort desc, c.id desc", out total, where); IPagedList pageList = new PagedList <DataRow>(ds.Tables[0].Select(), page, pageSize, total); if (Request.Headers.ContainsKey("x-requested-with")) { return(View("_Table", pageList)); } List <BusinessDropDownDto> dtoList = (await _businessAppService.GetDropDown()); ViewData.Add("Business", new Microsoft.AspNetCore.Mvc.Rendering.SelectList(dtoList, "Id", "BusinessName")); return(View(pageList)); }
public async Task <IActionResult> List(int pageIndex = 1, int pageSize = 10, string Name = "", string BusinessId = "") { string where = string.Empty; if (!string.IsNullOrEmpty(Name)) { where += $" and Name like '%{Name}%'"; } if (!string.IsNullOrEmpty(BusinessId)) { where += $" and *.BusinessId = {BusinessId}"; } int total; DataSet ds = _roleAppService.GetRolePage(pageIndex, pageSize, "id desc", out total, where); IPagedList page = new PagedList <DataRow>(ds.Tables[0].Select(), pageIndex, pageSize, total); if (Request.Headers.ContainsKey("x-requested-with")) { return(View("_Table", page)); } List <BusinessDropDownDto> businessdtoList = (await _businessAppService.GetDropDown()); ViewData.Add("Business", new Microsoft.AspNetCore.Mvc.Rendering.SelectList(businessdtoList, "Id", "BusinessName")); List <BusinessDropDownDto> dtoList = (await _businessAppService.GetDropDown()); return(View(page)); }
public async Task <IActionResult> List(int page = 1, int pageSize = 10, string storeName = "", string businessId = "") { string where = _commonAppService.GetWhere(); if (!string.IsNullOrEmpty(storeName)) { where = $" and c.Name like '%{storeName}%'"; } if (!string.IsNullOrEmpty(businessId)) { where += $" and c.BusinessId = {businessId}"; } int total; string table = $@"select c.id,c.IsSystem, c.Name,cast(c.AvailablePoint as float) AvailablePoint, c.AvailableSmsCount,cast(c.AvailableValue as float) AvailableValue,cast( c.SettlementMoney as float) SettlementMoney from TChainStore c where 1=1"; DataSet ds = _AppService.GetPage(page, pageSize, "c.sort desc, c.id desc", out total, where, table); IPagedList pageList = new PagedList <DataRow>(ds.Tables[0].Select(), page, pageSize, total); ViewBag.PageSize = pageSize; if (Request.Headers.ContainsKey("x-requested-with")) { return(View("_Table", pageList)); } List <BusinessDropDownDto> dtoList = (await _businessAppService.GetDropDown()); ViewData.Add("Business", new Microsoft.AspNetCore.Mvc.Rendering.SelectList(dtoList, "Id", "BusinessName")); return(View(pageList)); }
public async Task <IActionResult> List( int page = 1, int pageSize = 10, string RoleId = "", string Name = "", string BusinessId = "") { string where = string.Empty; if (!string.IsNullOrEmpty(Name)) { where += $" and s.UserName like '%{Name}%'"; } if (!string.IsNullOrEmpty(RoleId)) { where += $" and RoleId = {RoleId}"; } if (!string.IsNullOrEmpty(BusinessId)) { where += $" and r.BusinessId = {BusinessId}"; } int total; DataSet ds = _userAppService.GetUserPage(page, pageSize, "id desc", out total, where); IPagedList pageList = new PagedList <DataRow>(ds.Tables[0].Select(), page, pageSize, total); if (Request.Headers.ContainsKey("x-requested-with")) { return(View("_Table", pageList)); } List <RoleDropDownDto> dtoList = (await _roleAppService.GetDropDown()); ViewData.Add("Roles", new SelectList(dtoList, "Id", "DisplayName")); List <BusinessDropDownDto> businessdtoList = (await _AppService.GetDropDown()); ViewData.Add("Business", new Microsoft.AspNetCore.Mvc.Rendering.SelectList(businessdtoList, "Id", "BusinessName")); EditUserModalViewModel s = new EditUserModalViewModel(); s.User = new UserDto(); s.Roles = dtoList; ViewBag.EditUser = s; return(View(pageList)); }