public static JsonJqGridData ConvertFlexGridToJqGrid(JsonFlexiGridData data,PageView view,string columns) { JsonJqGridData returndata = new JsonJqGridData {page=view.PageIndex+1,records=view.RecordCount }; returndata.total = view.RecordCount / view.PageSize + 1; returndata.rows = new List<JqGridRow>(); if (data.total>0 && data.rows != null && data.rows.Count > 0) { string[] Column = columns.Split(','); int length = Column.Length; foreach (FlexiGridRow row in data.rows) { JqGridRow r = new JqGridRow(); r.id = row.id; r.cell = new List<object>(); var o = new { id="",value="" }; for (int i = 0; i < length; i++) { //r.cell.Add(Column[i]); //r.cell.Add(":"); r.cell.Add(row.cell[i]); } returndata.rows.Add(r); } } return returndata; }
public void Save(PageView currentPage, string controlPlaceId, ControlData[] data) { if(_connectionString!=string.Empty) { SqlContext context = new SqlContext(); context.ConnectionString=_connectionString; try { context.BeginTransaction(); //delete all controls in control place SqlHelper.ExecuteNonQuery(context,CommandType.StoredProcedure,"page_ControlPropertiesDeleteAllInControlPlace", new SqlParameter("@PageUID",currentPage.Id),new SqlParameter("@ControlPlaceID",controlPlaceId)); //add new controls from array "data" for(int i=0;i<data.Length;i++) { SqlHelper.ExecuteNonQuery(context,CommandType.StoredProcedure,"page_ControlPropertiesInsertInControlPlace", new SqlParameter("@PageUID",currentPage.Id), new SqlParameter("@ControlPlaceID",controlPlaceId), new SqlParameter("@ControlIndex",i), new SqlParameter("@ControlUID",data[i].ControlUID), new SqlParameter("@ControlProperties",data[i].Settings)); } context.Commit(); } catch { context.Rollback(); throw; } }//if(_connectionString!=string.Empty) }
// // GET: /Reg/ public ActionResult RegUser() { PageView view =new PageView(); view.PageIndex = 0; view.PageSize = 35; view.RecordCount = 0; JsonFlexiGridData data = Bo.BoFactory.GetSMC_UnitBo.QueryUnitByUnitCode(view, ""); List<SelectListItem> unitList = new List<SelectListItem>(); foreach (FlexiGridRow r in data.rows) { SelectListItem u = new SelectListItem(); u.Value =r.cell[0]; u.Text = r.cell[1]; unitList.Add(u); } List<SelectListItem> genderList = new List<SelectListItem>(); genderList.Add(new SelectListItem { Text = "男", Value = "male" }); genderList.Add(new SelectListItem { Text = "女", Value = "female" }); ViewData["Unit_ID"] = unitList; ViewData["UL_Gender"] = genderList; return View(); }
public HttpResponseMessage Print(RequestData request) { Opts.AppName = "Viewer"; Opts.FileName = request.fileName; Opts.FolderName = request.folderName; Opts.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name; try { if (Opts.FolderName.Contains("..")) { throw new Exception("Break-in attempt"); } var doc = new Document(Opts.WorkingFileName); var lst = new PageView[doc.Pages.Count]; for (int i = 0; i < doc.Pages.Count; i++) { lst[i] = PreparePageView(doc, i + 1); } return(Request.CreateResponse(HttpStatusCode.OK, lst)); } catch (Exception ex) { return(ExceptionResponse(ex)); } }
public virtual void Process() { var ctl = CreateControllerInstance(); try { var ret = InvokeAction(ctl); if (ret is IView) { ((IView)ret).Render(); } else if (ret == null || (string)ret == "") { var view = new PageView(Action.ViewName, ctl, Controller); view.Render(); } else { HttpContextHandler.Instance.Redirect((string)ret, false); } } catch (ThreadAbortException) { throw; } catch (Exception ex) { OnException(ex, ctl); } }
public void Reset() { // home button tapped view.SelectionView.ChangeSelecion(null, SelectionChangedType.Clear, false); if (explorationViewModel.ViewStatus.SelectedCount > 0) { // exploration view에서 올라가 있는 것 다 제거 foreach (PageView pageView in ExplorationViewModel.SelectedPageViews) { view.ExplorationView.RemoveNonTopPage(pageView); } // exploration view model 에서 선택된 page view 다 지움 ExplorationViewModel.SelectedPageViews.Clear(); // 빈 view status로 반영 ViewStatus emptyViewStatus = new ViewStatus(); // 현재 preview에 해당하는 page view를 비어있게 PageView topPageView = view.ExplorationView.TopPageView; PageViewModel topPageViewModel = topPageView.ViewModel; topPageViewModel.ViewStatus = emptyViewStatus; topPageViewModel.State = PageViewModel.PageViewState.Empty; topPageView.ReflectState(); ReflectAll(emptyViewStatus, ReflectReason.Reset); } }
public ActionResult GetLogInfo(FormCollection form) { JsonFlexiGridData data = null; PageView view = new PageView(form); data = BoFactory.GetVersionTrackBo.GetLogInfoList(view); return Json(data); }
public static PageVersion UpdatePage(IScribeDatabase database, User user, PageView view, Action <PageView> action, ApprovalStatus status = ApprovalStatus.None, bool published = false) { var service = new ScribeService(database, null, GetSearchService(), user); action(view); service.SavePage(view); database.SaveChanges(); switch (status) { case ApprovalStatus.Approved: service.UpdatePage(new PageUpdate { Id = view.Id, Type = PageUpdateType.Approve }); break; case ApprovalStatus.Rejected: service.UpdatePage(new PageUpdate { Id = view.Id, Type = PageUpdateType.Reject }); break; } if (published) { service.UpdatePage(new PageUpdate { Id = view.Id, Type = PageUpdateType.Publish }); } database.SaveChanges(); return(database.PageVersions.OrderByDescending(x => x.PageId == view.Id).First()); }
/// <summary> /// 获取答卷列表 /// </summary> /// <param name="request"></param> /// <returns></returns> public override async Task <RpcResult <APaperListRsp> > QueryAPaperListAsync(QueryAPaperReq request) { var res = new RpcResult <APaperListRsp>(); res.Data = new APaperListRsp(); var view = new PageView(request.Page, request.Rp); var plist = await this._apaperRepo.QueryAPaperList(request.Qtext, request.QpaperId, request.CheckRole?request.Identity : "", view); res.Data.Total = view.PageIndex == 0 ? plist.Total : -1; if (plist != null && plist.DataList != null && plist.DataList.Count > 0) { foreach (var apaper in plist.DataList) { res.Data.List.Add(new DTOAPaper() { ApaperId = apaper.PaperId, CreateTime = apaper.CreateTime.ToString("yyyy-MM-dd HH:mm:ss"), QpaperId = apaper.QpaperId, UserId = apaper.UserId, QpaperSubject = apaper.QpaperSubject ?? "", QpaperUserId = apaper.QpaperUserId ?? "", Remark = apaper.Remark }); } } return(res); }
public JsonFlexiGridData QueryApplicationCategoryList(PageView view) { string column = "*"; string sql = "select * from ApplicationCategory "; return(base.QueryDataForFlexGridByPager(column, string.Format("({0}) as temp", sql), view.OrderBy.ToString(), "seq", string.Empty, view)); }
/// <summary> /// 分页查询 /// </summary> /// <typeparam name="T">查询类型</typeparam> /// <param name="options">分页查询条件</param> /// <returns>返回PageView<T></returns> public static PageView <T> GetPageList <T>(PageSearchOptions options) { const string pageProcedureName = "Proc_GetPageData"; //构造参数,存储过程固定 var p = new DynamicParameters(); p.Add("TableName", options.TableName); p.Add("PrimaryKey", options.PrimaryKey); p.Add("Fields", options.Fields); p.Add("Condition", options.Condition); p.Add("CurrentPage", options.PageIndex); p.Add("PageSize", options.PageSize); p.Add("Sort", options.Sort); p.Add("RecordCount", dbType: DbType.Int32, direction: ParameterDirection.Output); var pageData = new PageView <T>(options.PageIndex, options.PageSize); if (HasDangerousContents(options.Condition)) { return(pageData); } pageData.List = DBHelper.Query <T>(pageProcedureName, p, CommandType.StoredProcedure); pageData.TotalCount = p.Get <int>("RecordCount"); return(pageData); }
/// <summary> /// 分页查询单表 /// </summary> /// <typeparam name="T"></typeparam> /// <param name="view"></param> /// <param name="where">userid=1 and username='******'</param> /// <param name="param"></param> /// <param name="sqlOrder">排序字段 包含Order by </param> /// <returns></returns> protected Task <PagedList <T> > SimplePagedQueryAsync <T>(PageView view, string where, object param, string sqlOrder) where T : BaseEntity { string sqlColumns = GetAllColumns <T>(); string sqlTable = GetTableName <T>(); return(PagedQueryAsync <T>(view, sqlColumns, sqlTable, where, param, sqlOrder)); }
public PagedList <EMPLOYEE> QueryEmpList(EmpInfoSearch search, PageView view) { int deptId = search.GroupID; List <int> deptIds = new List <int>(); //获取所有大区、区域、门店 if (deptId > 0) { deptIds.Add(deptId); var groups = _groupRepo.GetRecursiveAllByParentID(deptId); List <int> groupIds = groups.Select(m => m.ID).ToList(); if (groupIds.Count > 0) { deptIds.AddRange(groupIds); } } //else //{ // groupIds.Add(deptId); //} //var stores = _storeRepo.GetByGroupID(groupIds.ToArray()); //if (stores.Count > 0) //{ // var storeIds = stores.Select(m => m.ID).ToList(); // deptIds.AddRange(storeIds); //} return(_empRepo.QueryList(deptIds.ToArray(), search, view)); }
/// <summary> /// 分页查询列表 /// </summary> /// <typeparam name="T">返回列表的实体对象类型</typeparam> /// <param name="view">分页查询信息</param> /// <param name="sqlColumns">查询的字符串</param> /// <param name="sqlTable">查询的表,可以为多表,即From后面 where之前的内容</param> /// <param name="sqlCondition">查询条件 Where 后面的部分.</param> /// <param name="param">查询实体值得实体对象.</param> /// <param name="sqlOrder">排序字段 包含Order by.</param> /// <returns>返回分页信息,当查询为第一页时 返回总记录数</returns> protected PagedList <T> PagedQuery <T>(PageView view, string sqlColumns, string sqlTable, string sqlCondition, object param, string sqlOrder) { PagedList <T> pList = new PagedList <T>(); var totalCount = -1; if (view.PageIndex == 1 || view.IsFirstQueryTotal == false) { string totalSql = string.Format(" select count(1) from {0} where 1=1 {1} ;", sqlTable, sqlCondition); totalCount = ExecuteScalar <int>(totalSql, param); } //if (string.IsNullOrEmpty(sqlOrder)) //{ // sqlOrder = " ORDER BY " + sqlPk; //} int pageStartIndex = view.PageSize * (view.PageIndex - 1); int currentPageCount = view.PageSize; string sql = string.Format(" select {0} from {1} where 1=1 {2} {3} limit {4},{5} ;", sqlColumns, sqlTable, sqlCondition, sqlOrder, pageStartIndex, currentPageCount); pList.DataList = Query <T>(sql, param); pList.Total = (int)totalCount; pList.PageIndex = view.PageIndex; pList.PageSize = view.PageSize; return(pList); }
/// <summary> /// 分页查询列表 /// </summary> /// <typeparam name="T">返回列表的实体对象类型</typeparam> /// <param name="view">分页查询信息</param> /// <param name="sqlColumns">查询的字符串</param> /// <param name="sqlTable">查询的表,可以为多表,即From后面 where之前的内容</param> /// <param name="sqlCondition">查询条件 Where 后面的部分.</param> /// <param name="param">查询实体值得实体对象.</param> /// <param name="sqlPk">该条查询的唯一键.</param> /// <param name="sqlOrder">排序字段 包含Order by.</param> /// <returns>返回分页信息,当查询为第一页时 返回总记录数</returns> public PagedList <T> PagedQuery <T>(PageView view, string sqlColumns, string sqlTable, string sqlCondition, object param, string sqlPk, string sqlOrder) { PagedList <T> pList = new PagedList <T>(); long totalCount = -1; if (view.PageIndex == 0) { string totalSql = string.Format(" select count(1) from {0} where 1=1 {1} ;", sqlTable, sqlCondition); totalCount = Get <long>(totalSql, param); } if (string.IsNullOrEmpty(sqlOrder)) { sqlOrder = " ORDER BY " + sqlPk; } int pageStartIndex = view.PageSize * view.PageIndex; int currentPageCount = view.PageSize; string sql = string.Format(" select {0} from {1} where 1=1 {2} {3} limit {4},{5} ;", sqlColumns, sqlTable, sqlCondition, sqlOrder, pageStartIndex, currentPageCount); pList.DataList = Query <T>(sql, param); pList.Total = (int)totalCount; pList.PageIndex = view.PageIndex; pList.PageSize = view.PageSize; return(pList); }
private async Task <IActionResult> ReadPageTaggedAsync(long tenantId, long pageId, string tags) { IPageContext context = await GetPageContextAsync(tenantId, pageId, tags); PageView pageView = await _pageViewService.ReadPageViewAsync(tenantId, pageId); Dictionary <long, ElementPartialView> elements = new Dictionary <long, ElementPartialView>(); foreach (PageViewZone pageViewZone in pageView.PageViewZones) { foreach (PageViewZoneElement pageViewZoneElement in pageViewZone.PageViewZoneElements) { if (!elements.ContainsKey(pageViewZoneElement.ElementId)) { elements.Add(pageViewZoneElement.ElementId, await GetElementPartialViewAsync(tenantId, pageViewZoneElement.ElementTypeId, pageViewZoneElement.ElementId, context)); } } } PageViewModel viewModel = new PageViewModel { View = pageView, Elements = elements }; return(View("Read", viewModel)); }
//查询粉丝发送给商户的消息记录 public PagedList <CUST_MSG_RECORD_EX> QueryFansMessagesN(PageView view, string toUserName, bool?isStar, bool?isReturn, string searchText) { StringBuilder sqlWhere = new StringBuilder(" AND cmr.State = 0"); sqlWhere.Append(string.Format(" AND cmr.FROMUSERNAME not in (select FROMUSERNAME from Emp_Cust)")); if (!string.IsNullOrEmpty(toUserName)) { sqlWhere.Append(string.Format(" AND cmr.TOUSERNAME ='******'", toUserName)); } if (isStar.HasValue) { sqlWhere.Append(string.Format(" AND cmr.IS_STAR = '{0}'", isStar.Value)); } if (isReturn.HasValue) { if (isReturn.Value) { sqlWhere.Append(string.Format(" AND cmr.IS_RETURN = '{0}'", isReturn.Value)); } else { sqlWhere.Append(string.Format(" AND (cmr.IS_RETURN = '{0}' or cmr.IS_RETURN IS NULL)", isReturn.Value)); } } if (!string.IsNullOrEmpty(searchText)) { sqlWhere.Append(string.Format(" AND cf.NAME LIKE '%{0}%' ", searchText)); } return(base.PageGet <CUST_MSG_RECORD_EX>(view, @" cf.NAME as Fname,cf.IMAGE,cmr.*", "[WXCUST_MSG_RECORD] cmr LEFT JOIN [WXCUST_FANS] cf ON cmr.FROMUSERNAME = cf.FROMUSERNAME", sqlWhere.ToString(), "cmr.ID", "ORDER BY cmr.CREATE_DATE DESC")); }
void ReleaseDesignerOutlets() { if (CatView != null) { CatView.Dispose(); CatView = null; } if (PageView != null) { PageView.Dispose(); PageView = null; } if (PreviousButton != null) { PreviousButton.Dispose(); PreviousButton = null; } if (NextButton != null) { NextButton.Dispose(); NextButton = null; } }
public static void ChangeView(PageView page, Frame frame) { ConnectionView.Visibility = Visibility.Hidden; ImportView.Visibility = Visibility.Hidden; ExportView.Visibility = Visibility.Hidden; Page displayPage; switch (page) { case PageView.Import: ImportView.Visibility = Visibility.Visible; displayPage = ImportView; break; case PageView.Connection: ConnectionView.Visibility = Visibility.Visible; displayPage = ConnectionView; break; case PageView.Export: ExportView.Visibility = Visibility.Visible; displayPage = ExportView; break; default: ConnectionView.Visibility = Visibility.Visible; displayPage = ConnectionView; break; } frame.Content = displayPage; }
public void PageView(PageView reg) { TimeStamp stamp = new TimeStamp(); reg.Day = stamp.Day; reg.Hour = stamp.Hour; reg.Minute = stamp.Minute; reg.Second = stamp.Second; reg.Month = stamp.Month; reg.Quarter = stamp.Quarter; reg.Year = stamp.Year; reg.Week = stamp.Week; reg.Timestamp = stamp.Stamp; reg.Session = APIContext.Current.Session; reg.WidgetAPIKeyId = APIContext.Current.WidgetToken != null ? APIContext.Current.WidgetToken.APIKeyId : (long?)null; Task.Factory.StartNew(() => { using (var context = ContextFactory.AnalyticsContext) { context.PageViews.AddObject(reg); context.SaveChanges(); } }); }
private void detailPage() { //Frame rootFrame = Window.Current.Content as Frame; PageView.Navigate(typeof(DetailPage)); VisualStateChange(); }
protected override void OnNavigatedTo(NavigationEventArgs e) { Frame rootFrame = Window.Current.Content as Frame; DataService.ReadFileAsync(); Windows.UI.Core.SystemNavigationManager.GetForCurrentView().AppViewBackButtonVisibility = Windows.UI.Core.AppViewBackButtonVisibility.Collapsed; if (e.NavigationMode != NavigationMode.New) { if (ApplicationData.Current.LocalSettings.Values.ContainsKey("selected")) { foreach (var item in ViewModel.AllItems) { if (item.id == (string)ApplicationData.Current.LocalSettings.Values["selected"]) { ViewModel.selectedItem = item; } } } if (ApplicationData.Current.LocalSettings.Values.ContainsKey("pageNavigationState")) { PageView.SetNavigationState((string)ApplicationData.Current.LocalSettings.Values["pageNavigationState"]); } ApplicationData.Current.LocalSettings.Values.Remove("selected"); ApplicationData.Current.LocalSettings.Values.Remove("pageNavigationState"); } }
private void newPage() { //Frame rootFrame = Window.Current.Content as Frame; PageView.Navigate(typeof(NewPage)); ViewModel.selectedItem = null; VisualStateChange(); }
public JsonFlexiGridData QueryClientTypeList(PageView view) { string column = "*"; string sql = "select * from ClientType"; return(base.QueryDataForFlexGridByPager(column, string.Format("({0}) as temp", sql), view.OrderBy.ToString(), "ClientType", string.Empty, view)); }
private void Init() { InitToolData(); InitToolImageState(); InitBoxImageState(); _pageView = transform.GetComponentInParent <PageView>(); if (null != _btnClick) { _btnClick.OnClick.AddListener(OnClickEvent); } if (!_raycastCamera) { _raycastCamera = Camera.main; } if (true == _isBackKeepTop) { _markDragBackEffect = _backEffect; _markDragBackDuring = _backDuring; } DragValidCheckEvent += OnDragValidCheck; }
/// <summary> /// 分页获取问卷列表 /// </summary> /// <param name="request"></param> /// <returns></returns> public override async Task <RpcResult <QPaperListRsp> > QueryQPaperListAsync(QueryQPaperReq request) { var res = new RpcResult <QPaperListRsp>(); res.Data = new QPaperListRsp(); var userId = request.CheckRole ? request.Identity : String.Empty; var view = new PageView(request.Page, request.Rp); var plist = await this._qpaperRepo.QueryQPaperList(Utility.ClearSafeStringParma(request.Query), userId, view); res.Data.Total = view.PageIndex == 0 ? plist.Total : -1; if (plist != null && plist.DataList != null && plist.DataList.Count > 0) { foreach (var qpaper in plist.DataList) { res.Data.List.Add(new DTOQPaper() { QpaperId = qpaper.QpaperId, Subject = qpaper.Subject, Description = qpaper.Description, ApaperCount = qpaper.ApaperCount, StartTime = qpaper.StartTime.HasValue ? qpaper.StartTime.Value.ToString("yyyy-MM-dd HH:mm:ss") : "", EndTime = qpaper.EndTime.HasValue ? qpaper.EndTime.Value.ToString("yyyy-MM-dd HH:mm:ss") : "" }); } } return(res); }
/// <summary> /// 按角色、单位、上级权限ID查询权限,Upper_FN_ID为0则查询顶级权限 /// </summary> /// <param name="view"></param> /// <param name="Role_ID"></param> /// <param name="Unit_ID"></param> /// <param name="Upper_FN_ID"></param> /// <returns></returns> public JsonFlexiGridData QueryFunctions(PageView view, int Role_ID, int Unit_ID, int Upper_FN_ID) { //select f.* from [dbo].[SMC_FunctionRole] fr join [dbo].[SMC_Functions] f //on fr.FN_ID = f.FN_ID where fr.Role_ID = '' and f.Unit_ID='' and f.Upper_FN_ID = '' Orderby F.FN_ID DESC string column = @"f.*"; string sWhere = ""; if (Role_ID > 0) { sWhere = string.Format(" AND fr.Role_ID = '{0}'", Role_ID); } if (Unit_ID > 0) { sWhere += string.Format(" AND f.Unit_ID = '{0}'", Unit_ID); } if (Upper_FN_ID > 0) { sWhere += string.Format(" AND F.Upper_FN_ID = '{0}'", Upper_FN_ID); } else { sWhere += " AND F.Upper_FN_ID IS NULL "; } return(base.QueryDataForFlexGridByPager(column, @" [dbo].[SMC_FunctionRole] fr join [dbo].[SMC_Functions] f on fr.FN_ID = f.FN_ID ", view.OrderBy.ToString(), "F.FN_ID DESC", sWhere, view)); }
/// <summary> /// 查询操作日志 /// </summary> /// <param name="view">分页信息</param> /// <param name="qtext">查询日志内容</param> /// <param name="optype">操作类别</param> /// <param name="logtyp">日志类别</param> /// <returns></returns> public PagedList <Log> QueryOperLog(PageView view, string qtext, string optype, LogType logtype) { // 过滤字符 qtext = Utility.ClearSafeStringParma(qtext); optype = Utility.ClearSafeStringParma(optype); return(logRepository.QueryOperLog(view, qtext, optype, logtype)); }
public JsonResult List(EmpSearch search, FormCollection form) { PageView view = new PageView(form); if (search == null) { search = new EmpSearch(); } search.FirstTime = form["FirstTime"]; search.EndTime = form["EndTime"]; search.DeptId = form["DeptId"]; search.StoreName = form["StoreName"]; List <string> deptIdList = new List <string>(); if (deptTree == null) { setDeptTree(); } List <EMPLOYEE_EX> pList = _service.QueryEmplReport(search); string colkey = form["colkey"]; string colsinfo = form["colsinfo"]; JsonQTable fdata = JsonQTable.ConvertFromList <EMPLOYEE_EX>(pList, colkey, colsinfo.Split(',')); return(Json(fdata)); }
/// <summary> /// Kthe ne shqip te gjitha deklarimet qe jane ne anglisht te crystalReportViewer1 /// </summary> private void RifreskoRaportin() { foreach (Control child in this.crystalReportViewer1.Controls) { if (child is CrystalDecisions.Windows.Forms.PageView) { PageView child1 = child as PageView; foreach (Control child2 in child1.Controls) { if (child2 is System.Windows.Forms.TabControl) { foreach (Control child3 in child2.Controls) { DocumentControl child4 = child3 as DocumentControl; if (child4 != null) { child4.Text = "Raporti Kryesor"; } } } } } else if (child is System.Windows.Forms.StatusBar) { StatusBar status = child as StatusBar; status.Panels[0].Text = status.Panels[0].Text.Replace("Current Page No:", "Numri i faqes korrente"); status.Panels[1].Text = status.Panels[1].Text.Replace("Total Page No:", "Numri total i faqeve:"); status.Panels[2].Text = status.Panels[2].Text.Replace("Zoom Factor:", "Shkalla e zmadhimit:"); } } }
public JsonResult OrgUserList(string OrgCode, FormCollection form) { string colkey = form["colkey"]; string colsinfo = form["colsinfo"]; if (string.IsNullOrEmpty(colkey)) { throw new ArgumentNullException("colkey", "主键表示没有传递,请在前台js中配置"); } if (string.IsNullOrEmpty(colsinfo)) { throw new ArgumentNullException("colsinfo", "列信息不能为空,请在前台js中配置"); } int pageIndex = Convert.ToInt32(form["page"]); int pageSize = Convert.ToInt32(form["rp"]); PageView view = new PageView(); view.PageIndex = pageIndex - 1; view.PageSize = pageSize; PagedList <UserInfo> pageList = sysManageService.QueryOrgUserList(view, OrgCode); var data = JsonFlexiGridData.ConvertFromPagedList(pageList, colkey, colsinfo.Split(',')); return(Json(data)); }
public JsonResult RoleUserRelationList(FormCollection form) { string colkey = form["colkey"]; string colsinfo = form["colsinfo"]; int roleId = Convert.ToInt32(form["RoleID"]); //TODO:验证是否能管理这个角色 string qtext = form["qtext"]; if (string.IsNullOrEmpty(colkey)) { throw new ArgumentNullException("colkey", "主键表示没有传递,请在前台js中配置"); } if (string.IsNullOrEmpty(colsinfo)) { throw new ArgumentNullException("colsinfo", "列信息不能为空,请在前台js中配置"); } int pageIndex = Convert.ToInt32(form["page"]); int pageSize = Convert.ToInt32(form["rp"]); PageView view = new PageView(); view.PageIndex = pageIndex - 1; view.PageSize = pageSize; PagedList <UserInfo> pageList = sysManageService.QueryRoletUserList(view, roleId, qtext); var data = JsonFlexiGridData.ConvertFromPagedList(pageList, colkey, colsinfo.Split(',')); return(Json(data)); }
public JsonResult LogList(FormCollection form) { int pageIndex = Convert.ToInt32(form["page"]); int pageSize = Convert.ToInt32(form["rp"]); PageView view = new PageView(); view.PageIndex = pageIndex - 1; view.PageSize = pageSize; string colkey = form["colkey"]; string colsinfo = form["colsinfo"]; string qtext = form["QText"]; string optype = form["OperateCode"]; LogType logtype = LogType.None; switch (form["LogType"]) { case "0": logtype = LogType.Debug; break; case "1": logtype = LogType.Trace; break; case "2": logtype = LogType.Error; break; } ILogService service = ObjectFactory.GetInstance <ILogService>(); PagedList <Log> plist = service.QueryOperLog(view, qtext, optype, logtype); JsonFlexiGridData fdata = JsonFlexiGridData.ConvertFromPagedList <Log>(plist, colkey, colsinfo.Split(',')); return(Json(fdata)); }
public PagedResults <FileView> GetFiles(PagedRequest request = null) { var query = _database.Files.Where(x => !x.IsDeleted); request = request ?? new PagedRequest(); request.Cleanup(); if (!string.IsNullOrWhiteSpace(request.Filter)) { query = request.FilterValues?.Any() == true ? query.Where(request.Filter, request.FilterValues) : query.Where(request.Filter); } query = query.OrderBy(string.IsNullOrWhiteSpace(request.Order) ? "Name" : request.Order); return(GetPagedResults(query, request, x => new FileView { Id = x.Id, ModifiedOn = x.ModifiedOn, Name = x.Name, NameForLink = PageView.ConvertTitleForLink(x.Name), Size = x.Size / 1024 + " kb", Type = x.Type })); }
public JsonResult QueryUser(FormCollection form) { JsonFlexiGridData data = null; PageView view = new PageView(form); data = SBO.QueryUser(view); return Json(data); }
public ActionResult GetUserInfo(FormCollection form, string UserStatus) { JsonFlexiGridData data = null; PageView view = new PageView(form); SearchConfig search = new SearchConfig(); search.status = UserStatus; data = BoFactory.GetVersionTrackBo.GetUserInfo(view, search); return Json(data); }
public virtual JsonFlexiGridData QueryMonitorConfig(PageView view) { try { return MonitorConfigDao.QueryMonitorConfig(view); } catch (DalException ex) { throw new BOException("获取插件相关所有信息出错", ex); } }
public virtual JsonFlexiGridData QueryPushNotificationList(PageView view) { try { return dao.QueryPushNotificationList(view); } catch (DalException ex) { throw new BOException("查询推送日志出错", ex); } }
public JsonResult QueryDeviceBindList(FormCollection form) { JsonFlexiGridData data = new JsonFlexiGridData(); PageView view = new PageView(form); try { data = BoFactory.GetVersionTrackBo.QueryDeviceBindList(view); } catch { } return Json(data); }
public JsonResult QueryApplyDeviceBindList(FormCollection form) { string unit_id = ""; if (!this.IsSystemManager) { unit_id = this.CurrentUser.UnitCode; } JsonFlexiGridData data = new JsonFlexiGridData(); PageView view = new PageView(form); try { data = BoFactory.GetVersionTrackBo.QueryApplyDeviceBindList(view); } catch { } string columns = "operate,UserUid,DeviceId,Ip,Status,ApplyTime,Description,ID"; var returnValue = ConvertJsonGrid.ConvertFlexGridToJqGrid(data, view, columns); var d= Json(returnValue); return d; }
public ControlData[] Load(PageView currentPage, string controlPlaceId) { ArrayList retVal=new ArrayList(); if(_connectionString!=string.Empty) { SqlContext context = new SqlContext(); context.ConnectionString=this.ConnectionString; using(IDataReader reader = SqlHelper.ExecuteReader(context,CommandType.StoredProcedure,"page_ControlPropertiesSelectAllInControlPlace", new SqlParameter("@PageUID",currentPage.Id), new SqlParameter("@ControlPlaceID",controlPlaceId))) { while(reader.Read()) { retVal.Add(new ControlData(reader.GetString(1), reader.GetString(2))); }//while(reader.Read()) }//using(IDataReader reader = SqlHelper.ExecuteReader(context,CommandType.StoredProcedure,"page_ControlsSelectAllInControlPlace", }//if(_connectionString!=string.Empty) return (ControlData[])retVal.ToArray(typeof(ControlData)); }
public ActionResult GetMiansInfo(FormCollection form) { ViewData["clientType"] = Request.QueryString["type"]; JsonFlexiGridData data = null; PageView view = new PageView(form); data = BoFactory.GetVersionTrackBo.QueryMiansInfo(view); return Json(data); }
public ActionResult MainGlobalInfoManage() { JsonFlexiGridData data = null; PageView view = new PageView(); view.CurrentUserId = null; view.PageIndex = 0; view.PageSize = 15; view.RecordCount = 0; data = BoFactory.GetVersionTrackBo.QueryMiansInfo(view); //int i = data.rows.Count; if (data.rows!=null) return RedirectToAction("MainInfoManage");//��������id,��ת�������-��������� else return RedirectToAction("UpdateGlobalConfigInfo");//��������id,����ȫ�����ù������ }
public JsonResult QueryPcExtList(FormCollection form) { JsonFlexiGridData data = new JsonFlexiGridData(); PageView view = new PageView(form); string uid = HttpContext.User.Identity.Name; Dictionary<string, string> r = BoFactory.GetSMC_UserListBo.GetUnitByUL_UID(uid); string unitcode = ""; if (r != null) { foreach (KeyValuePair<string, string> p in r) { unitcode = p.Value; } } data = BoFactory.GetVersionTrackBo.QueryPackageExtList(view,"PC", unitcode); return Json(data); }
public virtual JsonFlexiGridData QueryPackageAsyncResultList(PageView pageview, string sync_bat_no, string sync_time_start, string sync_time_end, string sync_status, string packageName) { try { return SMC_PackageExtSyncToOutsideDao.QueryPackageAsyncResultList(pageview, sync_bat_no, sync_time_start, sync_time_end, sync_status, packageName); } catch (DalException ex) { throw new BOException("查询包的同步结果出错", ex); } }
private void BindData(bool needToBind) { pageView = new PageView(false, PageViewType.Static, string.Empty, this.Page, MetaClassName); mc = MetaClass.Load(MetaClassName); if (ObjectId > 0) obj = MetaDataWrapper.LoadMetaObject(ObjectId, MetaClassName); if (obj == null) obj = MetaDataWrapper.NewMetaObject(ObjectId, MetaClassName); GenerateMainTable(); LoadControls(needToBind); wasBound = true; }
public ActionResult GetUnitListByUnitCode(FormCollection form, string unit_id) { JsonFlexiGridData data = null; PageView view = new PageView(form); data = BoFactory.GetSMC_UnitBo.QueryUnitByUnitCode(view, unit_id); return Json(data); }
public ActionResult GetVersionTrackList(FormCollection form, string id) { JsonFlexiGridData data = null; PageView view = new PageView(form); SearchVersionTrack search = new SearchVersionTrack(); search.PluginCode = id; data = BoFactory.GetVersionTrackBo.QueryVersionTrackInfo(view, search); return Json(data); }
public virtual JsonFlexiGridData QueryBUAUserAsyncToInsideResultList(PageView pageview, string sync_bat_no, string sync_time_start, string sync_time_end, string sync_status, string userName) { try { return SMC_BUAUserSyncToInsideDao.QueryBUAUserAsyncToInsideResultList(pageview, sync_bat_no, sync_time_start, sync_time_end, sync_status, userName); } catch (DalException ex) { throw new BOException("查询包的同步结果出错", ex); } }
public void AddToPageView(PageView pageView) { base.AddObject("PageView", pageView); }
public static PageView CreatePageView(int pageViewId, string viewed, global::System.TimeSpan timeSpentOnPage) { PageView pageView = new PageView(); pageView.PageViewId = pageViewId; pageView.Viewed = viewed; pageView.TimeSpentOnPage = timeSpentOnPage; return pageView; }
public ActionResult DelRole(int role_id) { JsonReturnMessages data = new JsonReturnMessages() { IsSuccess = true, Msg = "操作成功" }; SMC_Role role = BoFactory.GetSMC_RoleBo.Get(role_id); if (role != null) { //判断是否被关联引用 PageView view = new PageView(); view.PageIndex = 0; view.PageSize = 15; var rel=BoFactory.GetSMC_UserListBo.QueryUserListHasRole(view, role_id); if (rel.total > 0) { data.IsSuccess = false; data.Msg = "角色已经分配给用户,请先取消分配关系!"; return Json(data); } else { if (BoFactory.GetSMC_FunctionRoleBo.IsFuncAssigned(role_id)) { data.IsSuccess = false; data.Msg = "角色已经分配了权限,请先取消分配关系!"; return Json(data); } } } else { data.IsSuccess = false; data.Msg = "角色不存在"; } if (role != null) { //BoFactory.GetSMC_UserListBo.DeleteByRoleID(role_id); BoFactory.GetSMC_RoleBo.Delete(role); } return Json(data); }
public ActionResult DelUnit(string unit_id) { JsonReturnMessages data = new JsonReturnMessages() { IsSuccess = true, Msg = "操作成功" }; SMC_Unit unit = BoFactory.GetSMC_UnitBo.Get(unit_id); if (unit != null) { //判断是否被关联引用 PageView view = new PageView(); view.PageIndex = 0; view.PageSize = 15; //看是否有下级组织机构 var units = BoFactory.GetSMC_UnitBo.QueryUnitByUpperUnitCode(view,unit_id); if (units.total > 0) { data.IsSuccess = false; data.Msg = "该组织存在下级组织,请先删除下级组织后再执行此操作!"; return Json(data); } var rel = BoFactory.GetSMC_RoleBo.QueryRolesByUnitID(view,unit_id); if (rel.total > 0) { data.IsSuccess = false; data.Msg = "有角色的组织不能删除,请先删除组织下的角色后再执行此操作!"; return Json(data); } else { rel = BoFactory.GetSMC_UserListBo.QueryUserListByUnitID(view,unit_id); if (rel.total > 0) { data.IsSuccess = false; data.Msg = "有用户的组织不能删除,请先删除组织下的用户后再执行此操作!"; return Json(data); } } } else { data.IsSuccess = false; data.Msg = "组织不存在"; } try { //从同意授权 Beyondbit.BUA.Client.IOrgService os = Beyondbit.BUA.Client.ServiceFactory.Instance().GetOrgService(); os.DelOrg(unit_id); } catch (Exception e) { //ata.IsSuccess = false; //data.Msg = e.Message; } if (unit != null) { BoFactory.GetSMC_UnitBo.Delete(unit); } return Json(data); }
public ActionResult GetFunctionListByUpperFNID(FormCollection form, string upper_fn_id) { JsonFlexiGridData data = null; PageView view = new PageView(form); int _upper_fn_id = 0; if (upper_fn_id != null) { _upper_fn_id = int.Parse(upper_fn_id); } data = BoFactory.GetSMC_FunctionsBo.QueryFunctionByUpperFNID(view, _upper_fn_id); return Json(data); }
public ActionResult GetConfigInfo(FormCollection form) { JsonFlexiGridData data = null; PageView view = new PageView(form); data = BoFactory.GetMonitorBO.QueryMonitorConfig(view); return Json(data); }
public virtual JsonFlexiGridData QueryNeedImportedPackageList(PageView view) { try { Package4AIDao dao = new Package4AIDao(AppConfig.statisticDBKey); return dao.QueryNeedImportedPackageList(view); } catch (DalException ex) { throw new BOException("查询包的同步信息出错", ex); } }
public JsonResult GetVersionTrackList(FormCollection form) { JsonFlexiGridData data = null; PageView view = new PageView(form); SearchVersionTrack search = new SearchVersionTrack(); search.PluginCode = Common.Entities.Constants.MianPluginId.ToString(); data = BoFactory.GetVersionTrackBo.QueryVersionTrackInfo(view, search); return Json(data); }
private PageView BuildPageViewContents(int gId) { PageView pageView = new PageView(); StringBuilder returnString = new StringBuilder(); string str = ""; CateNewsBSO catenewsBSO = new CateNewsBSO(); CateNewsGroupBSO catenewsGroupBSO = new CateNewsGroupBSO(); CateNewsGroup cateGroup = catenewsGroupBSO.GetCateNewsGroupByGroupCate(gId); if (cateGroup.IsPage == true) catenewsBSO.MenuJqueryCateGroupUrl(returnString, 0, Language.language, "", gId, ResolveUrl("~/") + "CategoryPages/" + gId + "/", "/default.aspx"); else catenewsBSO.MenuJqueryCateGroupUrl(returnString, 0, Language.language, "", gId, ResolveUrl("~/") + "Category/" + gId + "/", "/default.aspx"); //str = "<div id='menu'>" + returnString.ToString() + "</div>"; str = "<div style='position:absolute;left:" + cateGroup.Position + "px;white-space: nowrap;'><div id='menu'>" + returnString.ToString() + "</div></div>"; pageView.Controls.Add(new LiteralControl(str)); return pageView; }
public JsonResult QueryPushNotificationList(FormCollection form) { JsonFlexiGridData data = new JsonFlexiGridData(); PageView view = new PageView(form); data = BoFactory.GetPushManageBO.QueryPushNotificationList(view); return Json(data); }
public ActionResult GetUnitListByUpperUnitCode(FormCollection form, string upper_unit_id) { JsonFlexiGridData data = null; PageView view = new PageView(form); bool isSystemManager = BoFactory.GetVersionTrackBo.IsSystemManager(this.User.Identity.Name); if (isSystemManager) data = BoFactory.GetSMC_UnitBo.QueryUnitByUpperUnitCode(view, upper_unit_id); else { //单位管理员只看自己单位列表 string Unit_ID = BoFactory.GetSMC_UserListBo.GetUnitIdByUID(this.User.Identity.Name); data = BoFactory.GetSMC_UnitBo.QueryUnitByUpperUnitCodeWithSelfUnit(view, upper_unit_id, Unit_ID); } ViewData["unit_id"] = upper_unit_id; return Json(data, JsonRequestBehavior.AllowGet); }