public JsonResult GetBasPdcSequence(GridParam gp) { int pageCount, totalCount; Dictionary <string, string> dic = new Dictionary <string, string>(); dic.Add("Pdc", Request.QueryString["Pdc"]); var data = _BasPdcSequenceDBAccess.GetList(gp, dic, out pageCount, out totalCount).ToList(); var jsonData = new { total = pageCount, //totalpages page = gp.page, records = totalCount, rows = (from c in data select new { cell = new string[] { c.BasPdcSequenceId, c.Pdc, c.SequenceNumber.ToString(), c.CreatedUserCode, c.CreatedDate.ToString("yyyy-MM-dd"), c.Active?"<=Yes>":"<=No>" } } ).ToArray() }; return(Json(jsonData, JsonRequestBehavior.AllowGet)); }
public async Task <HtmlGrid <UserListDetails> > GetUserLists(GridParam gridParam) { List <Task <UserListDetails> > tasksUserlists = new List <Task <UserListDetails> >(); var details = _userManagementRepository.GetUserLists(StoredProcedureName, gridParam); foreach (UserListDetails user in details) { tasksUserlists.Add(Task.Run(() => UserGridManagement(user))); } var results = await Task.WhenAll(tasksUserlists); var userList = results.ToList(); _log.Information("User details got as {0}", JsonConvert.SerializeObject(userList)); var userLists = new HtmlGrid <UserListDetails> { aaData = userList }; var firstDefault = userList.FirstOrDefault(); if (firstDefault != null) { userLists.iTotalDisplayRecords = Convert.ToInt32(firstDefault.FilterCount); userLists.iTotalRecords = Convert.ToInt32(firstDefault.FilterCount); } return(userLists); }
public JsonResult GetBasNormalScheduleVTmDet(GridParam gp) { string basNormalScheduleVTmId = Request.QueryString["BasNormalScheduleVTmId"]; var data = _BasNormalScheduleVTmDetDBAccess.GetList(basNormalScheduleVTmId).OrderBy(gp.sidx, gp.sord).ToList(); var jsonData = new { rows = (from c in data select new { cell = new string[] { c.BasNormalScheduleVTmDetId, c.Pdc, c.TransMode, c.SecondVLeadtime.ToString(), c.SecondVLeadtimeAmPm, c.SecondVLeadtimeStart.ToString("HH:mm:ss"), c.SecondVLeadtimeEnd.ToString("HH:mm:ss") } } ).ToArray() }; return(Json(jsonData, JsonRequestBehavior.AllowGet)); }
public JsonResult GetBasSpecialScheduleIndex(GridParam gp) { int pageCount, totalCount; Dictionary <string, string> dic = new Dictionary <string, string>(); dic.Add("ScheduleNo", Request.QueryString["ScheduleNo"]); var data = _BasSpecialScheduleIndexDBAccess.GetList(gp, dic, out pageCount, out totalCount).ToList(); var jsonData = new { total = pageCount, //totalpages page = gp.page, records = totalCount, rows = (from c in data select new { cell = new string[] { c.BasSpecialScheduleIndexId, c.ScheduleNo, c.EffectiveDate.ToString("yyyy-MM-dd"), c.ExpirationDate.ToString("yyyy-MM-dd"), c.Remark, c.CreatedUserCode, c.CreatedDate.ToString("yyyy-MM-dd") } } ).ToArray() }; return(Json(jsonData, JsonRequestBehavior.AllowGet)); }
public IQueryable <SysRole> GetList(GridParam gp, Dictionary <string, string> condition, out int pageCount, out int totalCount) { IQueryable <SysRole> originalSource = DataContext.SysRole.OrderByDescending(r => r.RoleCode); string RoleCode = condition.ContainsKey("RoleCode") == true ? condition["RoleCode"] : ""; if (!RoleCode.IsNullString()) { originalSource = originalSource.Where(o => o.RoleCode.Contains(RoleCode)); } string RoleName = condition.ContainsKey("RoleName") == true ? condition["RoleName"] : ""; if (!RoleName.IsNullString()) { originalSource = originalSource.Where(o => o.RoleName.Contains(RoleName)); } //string SysOrganizationId = condition.ContainsKey("SysOrganizationId") == true ? condition["SysOrganizationId"] : ""; //if (!SysOrganizationId.IsNullString()) // originalSource = originalSource.Where(o => o.SysOrganizationId == SysOrganizationId); //string OrganizationName = condition.ContainsKey("OrganizationName") == true ? condition["OrganizationName"] : ""; //if (!OrganizationName.IsNullString()) // originalSource = originalSource.Where(o => o.SysOrganization.OrganizationName.Contains(OrganizationName)); pageCount = 0; totalCount = originalSource.Count(); originalSource = originalSource.OrderBy(gp.sidx, gp.sord); var dataSouce = Paging <SysRole>(originalSource, gp.rows, gp.page, out pageCount); return(dataSouce); }
public IQueryable <SysUserRole> GetList(GridParam gp, Dictionary <string, string> condition, out int pageCount, out int totalCount) { IQueryable <SysUserRole> originalSource = DataContext.SysUserRole.OrderByDescending(r => r.SysUserRoleId); string SysRoleId = condition.ContainsKey("SysRoleId") == true ? condition["SysRoleId"] : ""; if (!SysRoleId.IsNullString()) { originalSource = originalSource.Where(o => o.SysRoleId == SysRoleId); } string SysUserId = condition.ContainsKey("SysUserId") == true ? condition["SysUserId"] : ""; if (!SysUserId.IsNullString()) { originalSource = originalSource.Where(o => o.SysUserId == SysUserId); } pageCount = 0; totalCount = originalSource.Count(); var dataSouce = Paging <SysUserRole>(originalSource, gp.rows, gp.page, out pageCount); return(dataSouce); }
public IQueryable <CBasCodeType> GetList(GridParam gp, Dictionary <string, string> condition, out int pageCount, out int totalCount) { IQueryable <CBasCodeType> originalSource = DataContext.CBasCodeType.OrderByDescending(r => r.UpdatedDate); string CodeType = condition["CodeType"]; if (!string.IsNullOrEmpty(CodeType)) { originalSource = originalSource.Where(o => o.CodeType.Contains(CodeType)); } string CodeName = condition["CodeName"]; if (!string.IsNullOrEmpty(CodeName)) { originalSource = originalSource.Where(o => o.CodeName.Contains(CodeName)); } pageCount = 0; originalSource = originalSource.OrderBy(gp.sidx, gp.sord); totalCount = originalSource.Count(); //originalSource = originalSource.FilterSource().OrderBy(c=>c.UpdatedDate); var dataSouce = Paging <CBasCodeType>(originalSource, gp.rows, gp.page, out pageCount); return(dataSouce); }
public JsonResult GetDashboardData(GridParam gp) { int pageCount, totalCount; Dictionary <string, string> dic = new Dictionary <string, string>(); dic.Add("UserId", System.Web.HttpContext.Current.User.Identity.Name); var data = dashboard.GetList(gp, dic, out pageCount, out totalCount).ToList(); var jsonData = new { total = totalCount, rows = (from c in data select new DashboardInfo() { Guid = c.Guid, ReportName = c.ReportName, ReportSpecName = c.ReportSpecName, ReportType = c.ReportType == "PieChart" ? "Pie" : c.ReportType == "LineChart" ? "Line" : c.ReportType == "Bar" ? "Bar" : "Group Bar", ReportSpec = c.ReportSpec } ).ToArray() }; return(Json(jsonData, JsonRequestBehavior.AllowGet)); }
public HtmlGrid <RoleLists> GetRoleLists(GridParam roleDetails) { List <RoleLists> roleLists = new List <RoleLists>(); var details = _roleManagementRepository.GetRoleLists(roleDetails, StoredProcedureName); foreach (RoleLists role in details) { var detail = new RoleLists() { Name = role.Name, FilterCount = role.FilterCount }; var roleId = _encryptionService.EncryptString(role.Id); StringBuilder actionDetails = new StringBuilder(); if (_roleExtension.HasPermission(PermissionValueLists.EditRole)) { actionDetails.Append("<a href='" + _configuration["ApplicationData:RootUrl"] + "/CoreSetup/Role/EditRole/" + roleId + "' class='btn btn-sm btn-link btn-round' title='Edit Role'><i class=\"fas fa-user-edit\"></i></a>"); } detail.Action = actionDetails.ToString(); roleLists.Add(detail); } _log.Information("role list get list response as {0}", JsonConvert.SerializeObject(roleLists)); var roleList = new HtmlGrid <RoleLists>(); roleList.aaData = roleLists; var firstDefault = roleLists.FirstOrDefault(); if (firstDefault != null) { roleList.iTotalDisplayRecords = Convert.ToInt32(firstDefault.FilterCount); roleList.iTotalRecords = Convert.ToInt32(firstDefault.FilterCount); } return(roleList); }
public string GetGridDetails(GridDetails param) { var accountDetails = new GridParam { DisplayLength = param.length, DisplayStart = param.start, SortDir = param.order[0].dir, SortCol = param.order[0].column, Flag = "A", Search = param.search.value, UserName = StaticData.GetUser() }; var gridList = buss.GetGridList(accountDetails); foreach (var item in gridList) { item.Action = StaticData.GetActions(ControllerName, item.UniqueId, "", AddEditId); //item.CreatedDate = StaticData.DBToFrontDate(item.CreatedDate); } HtmlGrid <GroceriesCommon> companyGrid = new HtmlGrid <GroceriesCommon>(); var firstDefault = gridList.FirstOrDefault(); companyGrid.aaData = gridList; if (firstDefault != null) { companyGrid.iTotalDisplayRecords = Convert.ToInt32(firstDefault.FilterCount); companyGrid.iTotalRecords = Convert.ToInt32(firstDefault.FilterCount); } var result = JsonConvert.SerializeObject(companyGrid).ToString(); return(result); }
public JsonResult GetBasAdjustmentTable(GridParam gp) { int pageCount, totalCount; Dictionary <string, string> dic = new Dictionary <string, string>(); dic.Add("AdjustmentType", Request.QueryString["AdjustmentType"]); var data = _BasAdjustmentTableDBAccess.GetList(gp, dic, out pageCount, out totalCount).ToList(); var jsonData = new { total = pageCount, //totalpages page = gp.page, records = totalCount, rows = (from c in data select new { cell = new string[] { c.PrintDate.HasValue?c.PrintDate.Value.ToString("yyyy-MM-dd") : "", c.TnNo, c.TnProperty } } ).ToArray() }; return(Json(jsonData, JsonRequestBehavior.AllowGet)); }
/// <summary> /// Get Role Lists For Grid /// </summary> /// <param name="roleDetails"></param> /// <param name="storedProcedureName"></param> /// <returns></returns> public List <RoleLists> GetRoleLists(GridParam roleDetails, string storedProcedureName) { _log.Information("sp call for getting available roles as with query {0} {1}", "EXEC " + storedProcedureName, JsonConvert.SerializeObject(roleDetails)); var response = _dapperDao.ExecuteQuery <RoleLists>(storedProcedureName, roleDetails); _log.Information("response returned as {0}", JsonConvert.SerializeObject(response)); return(response); }
public List <UserListDetails> GetUserLists(string storedProcedureName, GridParam gridParam) { _log.Information("sp call for getting list of user with query {0} {1}", "EXEC " + storedProcedureName, JsonConvert.SerializeObject(gridParam)); var response = _dapperDao.ExecuteQuery <UserListDetails>(storedProcedureName, gridParam); _log.Information("response returned as {0}", JsonConvert.SerializeObject(response)); return(response); }
public IQueryable <SysFunction> GetList(GridParam gp, Dictionary <string, string> dicCondtion, out int pageCount, out int totalCount) { IQueryable <SysFunction> originalSource = DataContext.SysFunction.OrderByDescending(r => r.SysFunctionId); string FunctionName = dicCondtion.ContainsKey("FunctionName") == true ? dicCondtion["FunctionName"] : ""; if (!string.IsNullOrEmpty(FunctionName)) { originalSource = originalSource.Where(o => o.FunctionName.Contains(FunctionName)); } string ActionName = dicCondtion.ContainsKey("ActionName") == true ? dicCondtion["ActionName"] : ""; if (!string.IsNullOrEmpty(ActionName)) { originalSource = originalSource.Where(o => o.ActionName.Contains(ActionName)); } string ControllerName = dicCondtion.ContainsKey("ControllerName") == true ? dicCondtion["ControllerName"] : ""; if (!string.IsNullOrEmpty(ControllerName)) { originalSource = originalSource.Where(o => o.ControllerName.Contains(ControllerName)); } string ParentId = dicCondtion.ContainsKey("ParentId") == true ? dicCondtion["ParentId"] : ""; if (!string.IsNullOrEmpty(ParentId)) { originalSource = originalSource.Where(o => o.ParentId.Contains(ParentId)); } string FunctionType = dicCondtion.ContainsKey("FunctionType") == true ? dicCondtion["FunctionType"] : ""; if (!string.IsNullOrEmpty(FunctionType)) { int iFuncType = Convert.ToInt16(FunctionType); originalSource = originalSource.Where(o => o.FunctionType == iFuncType); } string GroupType = dicCondtion.ContainsKey("GroupType") == true ? dicCondtion["GroupType"] : ""; if (!string.IsNullOrEmpty(GroupType)) { int igroupType = Convert.ToInt16(GroupType); originalSource = originalSource.Where(o => o.GroupType == igroupType); } pageCount = 0; totalCount = originalSource.Count(); originalSource = originalSource.OrderBy(gp.sidx, gp.sord); var dataSouce = Paging <SysFunction>(originalSource, gp.rows, gp.page, out pageCount); return(dataSouce); }
public ActionResult GetGridList(GridParam gp, string F_Equipment_Id = null) { var data = new { rows = maintenanceBLLBLL.GetGridList(gp, F_Equipment_Id), total = gp.total }; return(Content(data.ToJson())); }
public ActionResult GetDetailById(string f_id, GridParam gp) { var data = new { rows = bomDetailBLL.GetDetailById(f_id, gp), total = gp.total }; return(Content(data.ToJson())); }
public ActionResult GetGridList(GridParam gp) { var data = new { rows = GetProductMakeList(ProductMakeBLL.GetGridList(gp)), total = gp.total }; return(Content(data.ToJson())); }
public DataTable GetGridList(GridParam gp) { StringBuilder sb = new StringBuilder(@"SELECT * FROM (SELECT T1.*,T2.F_NAME AS F_PRODUCT_NAME FROM T_BOM T1 INNER JOIN T_PRODUCT T2 ON T1.F_PRODUCT_ID=T2.F_ID WHERE T1.F_DELETE_MARK = 0) T2 WHERE 1=1"); if (!string.IsNullOrEmpty(gp.query)) { sb.Append(ConditionBuilder.GetWhereSql2(gp.query.JsonToList <Condition>())); } return(Repository().FindTablePageBySql(sb.ToString(), ref gp)); }
public ActionResult GetGridList(GridParam gp) { var data = new { rows = partBLL.GetGridList(gp), total = gp.total }; return(Content(data.ToJson())); }
public ActionResult GetProductList(GridParam gp) { List <T_Product> list = new ProductBLL().GetGridList(gp).ToList(); var data = new { rows = list, total = gp.total }; return(Content(data.ToJson())); }
/// <summary> /// 查询数据列表、返回List /// </summary> /// <param name="strSql">Sql语句</param> /// <param name="jqgridparam">分页参数</param> /// <returns></returns> public List <T> FindListPageBySql(string strSql, ref GridParam gp) { int pageIndex = gp.offset / gp.limit + 1; int pageSize = gp.limit; int totalRow = 0; List <T> List = DataFactory.Database().FindListPageBySql <T>(strSql, gp.sort, gp.order, pageIndex, pageSize, ref totalRow); gp.total = totalRow; AddGridSql2Cahce(strSql); return(List); }
public static IQueryable <T> TakePage <T>(this IQueryable <T> query, GridParam gridParam) where T : class { var newQuery = query; if (!string.IsNullOrEmpty(gridParam.Sort)) { var sortProperty = gridParam.Sort.Pascalize(); newQuery = OrderingHelper(newQuery, sortProperty, gridParam.SortDirection == SortDirection.DESC, false); } return(newQuery.Skip(gridParam.SkipCount).Take(gridParam.MaxResultCount)); }
/// <summary> /// 查询数据列表、返回 DataTable /// </summary> /// <param name="strSql">Sql语句</param> /// <param name="jqgridparam">分页参数</param> /// <returns></returns> public DataTable FindTablePageBySql(string strSql, ref GridParam gp) { int pageIndex = gp.offset / gp.limit + 1; int pageSize = gp.limit; int totalRow = 0; DataTable dt = DataFactory.Database().FindTablePageBySql(strSql, gp.sort, gp.order, pageIndex, pageSize, ref totalRow); AddGridSql2Cahce(strSql); gp.total = totalRow; return(dt); }
public IQueryable <CBasNormalScheduleVCtDet> GetList(GridParam gp, Dictionary <string, string> condition, out int pageCount, out int totalCount) { IQueryable <CBasNormalScheduleVCtDet> originalSource = DataContext.CBasNormalScheduleVCtDet; pageCount = 0; originalSource = originalSource.OrderBy(gp.sidx, gp.sord); totalCount = originalSource.Count(); var dataSouce = Paging <CBasNormalScheduleVCtDet>(originalSource, gp.rows, gp.page, out pageCount); return(dataSouce); }
/// <summary> /// 查询数据列表、返回List /// </summary> /// <param name="WhereSql">条件</param> /// <param name="parameters">sql语句对应参数</param> /// <param name="jqgridparam">分页参数</param> /// <returns></returns> public List <T> FindListPage(string WhereSql, DbParameter[] parameters, ref GridParam gp) { int pageIndex = gp.offset / gp.limit + 1; int pageSize = gp.limit; int totalRow = 0; string querySql = string.Empty; List <T> List = DataFactory.Database().FindListPage <T>(WhereSql, parameters, gp.sort, gp.order, pageIndex, pageSize, ref totalRow, out querySql); gp.total = totalRow; AddGridSql2Cahce(querySql); return(List); }
//获取表格列表 By 阮创 2017/11/30 public List <T_User_Log> GetGridList(GridParam gp) { string select = "SELECT * FROM", where = "WHERE 1=1"; string from = "SELECT T1.* FROM T_USER_LOG T1 WHERE T1.F_DELETE_MARK = 0"; if (!string.IsNullOrEmpty(gp.query)) { where += ConditionBuilder.GetWhereSql2(gp.query.JsonToList <Condition>()); } string sql = string.Format("{0} ({1}) TT {2}", select, from, where); return(Repository().FindListPageBySql(sql, ref gp)); }
public IQueryable <CBasSpecialSchedule> GetList(GridParam gp, Dictionary <string, string> condition, out int pageCount, out int totalCount) { IQueryable <CBasSpecialSchedule> originalSource = DataContext.CBasSpecialSchedule; string BasSpecialScheduleIndexId = condition["BasSpecialScheduleIndexId"]; if (!string.IsNullOrEmpty(BasSpecialScheduleIndexId)) { originalSource = originalSource.Where(o => o.BasSpecialScheduleIndexId == BasSpecialScheduleIndexId); } string dealerCode = condition["DealerCode"]; if (!string.IsNullOrEmpty(dealerCode)) { originalSource = originalSource.Where(o => o.DealerCode.Contains(dealerCode)); } if (condition.ContainsKey("PickupDayFrom")) { string startdate = condition["PickupDayFrom"]; if (!string.IsNullOrEmpty(startdate)) { DateTime startDate = Convert.ToDateTime(startdate); if (startDate != null) { originalSource = originalSource.Where(o => o.PickupDay >= startDate); } } } if (condition.ContainsKey("PickupDayTo")) { string endingdate = condition["PickupDayTo"]; if (!string.IsNullOrEmpty(endingdate)) { DateTime endingDate = Convert.ToDateTime(endingdate); if (endingDate != null) { originalSource = originalSource.Where(o => o.PickupDay <= endingDate); } } } pageCount = 0; originalSource = originalSource.OrderBy(gp.sidx, gp.sord); totalCount = originalSource.Count(); var dataSouce = Paging <CBasSpecialSchedule>(originalSource, gp.rows, gp.page, out pageCount); return(dataSouce); }
public IQueryable <CBasCity> GetList(GridParam gp, Dictionary <string, string> condition, out int pageCount, out int totalCount) { IQueryable <CBasCity> originalSource = DataContext.BasCity; string CityCode = condition["CityCode"]; if (!CityCode.IsNullString()) { originalSource = originalSource.Where(o => o.CityCode.Contains(CityCode)); } string CityName = condition["CityName"]; if (!CityName.IsNullString()) { originalSource = originalSource.Where(o => o.CityName.Contains(CityName)); } string CityTypeCode = condition["CityTypeCode"]; if (!CityTypeCode.IsNullString()) { originalSource = originalSource.Where(o => o.CityTypeCode == CityTypeCode); } string ProvinceId = condition["ProvinceId"]; if (!ProvinceId.IsNullString()) { originalSource = originalSource.Where(o => o.ProvinceId == ProvinceId); } string Active = condition["Active"]; if (Active == "Y") { originalSource = originalSource.Where(o => o.Active); } else if (Active == "N") { originalSource = originalSource.Where(o => !o.Active); } pageCount = 0; originalSource = originalSource.OrderBy(gp.sidx, gp.sord); totalCount = originalSource.Count(); var dataSouce = Paging <CBasCity>(originalSource, gp.rows, gp.page, out pageCount); return(dataSouce); }
public List <ClothesCommon> GetGridList(GridParam gridParam) { var list = new List <ClothesCommon>(); try { var sql = "EXEC proc_tblClothes "; sql += " @FLAG = " + dao.FilterString("A"); sql += ",@User = "******",@Search = " + dao.FilterString(gridParam.Search); sql += ",@DisplayLength = " + dao.FilterString(gridParam.DisplayLength.ToString()); sql += ",@DisplayStart = " + dao.FilterString(gridParam.DisplayStart.ToString()); sql += ",@SortDir = " + dao.FilterString(gridParam.SortDir); sql += ",@SortCol = " + dao.FilterString(gridParam.SortCol.ToString()); var dt = dao.ExecuteDataTable(sql); if (null != dt) { int sn = 1; foreach (System.Data.DataRow item in dt.Rows) { var common = new ClothesCommon() { UniqueId = Convert.ToInt32(item["RowId"]), ProductReferenceId = item["ProductReferenceId"].ToString(), ProductDestintId = item["ProductDestintId"].ToString(), Brand = item["Brand"].ToString(), ProductName = item["ProductName"].ToString(), ProductPrice = item["ProductPrice"].ToString(), DiscountPercent = item["DiscountPercent"].ToString(), ProductFor = item["ProductFor"].ToString(), //ProductName = item["ProductName"].ToString(), //ProductName = item["ProductName"].ToString(), User = item["CreatedBy"].ToString(), CreatedDate = item["CreatedDate"].ToString(), FilterCount = item["FilterCount"].ToString(), }; sn++; list.Add(common); } } return(list); } catch (Exception e) { return(list); } }
public List <T_Part> GetGridList(GridParam gp) { string select = "SELECT * FROM", where = "WHERE 1=1"; string from = @"SELECT T1.* FROM V_PART T1"; if (!string.IsNullOrEmpty(gp.search)) { where += string.Format(" AND (F_NAME LIKE '%{0}%' OR F_CODE LIKE '%{0}%' OR F_SPEC LIKE '%{0}%')", gp.search); } string sql = string.Format("{0} ({1}) TT {2}", select, from, where); return(new Repository <T_Part>().FindListPageBySql(sql, ref gp)); }