/// <summary> /// 多条件搜索角色信息 /// </summary> /// <param name="operationParam">查询参数实体</param> /// <returns></returns> public IQueryable <SMFUNCTB> LoadSearchEntities(OperationParam operationParam) { Expression <Func <SMFUNCTB, bool> > whereLambda = PredicateBuilder.True <SMFUNCTB>(); if (!string.IsNullOrEmpty(operationParam.FUNC_NAME)) { whereLambda = whereLambda.And(u => u.FUNC_NAME.Contains(operationParam.FUNC_NAME)); } if (!string.IsNullOrEmpty(operationParam.STATUS)) { whereLambda = whereLambda.And(u => u.STATUS == operationParam.STATUS); } int count = 0; IQueryable <SMFUNCTB> queryData = null; if (!string.IsNullOrEmpty(operationParam.order) && !string.IsNullOrEmpty(operationParam.sort)) { bool isAsc = operationParam.order == "asc" ? true : false; queryData = LoadPageEntities <SMFUNCTB>(operationParam.page, operationParam.rows, out count, whereLambda, operationParam.sort, isAsc); } else { queryData = LoadPageEntities <SMFUNCTB>(operationParam.page, operationParam.rows, out count, whereLambda, operationParam.sort, null); } operationParam.TotalCount = count; return(queryData); }
/// <summary> /// Записать параметры операции в узел дерева. /// </summary> /// <param name="operationParameterNodes">Узел параметров операции /// </param> /// <param name="mode">Операции</param> private static void WriteObjectOperationParametersInNode( ref TreeNode operationParameterNodes, Mode mode) { bool operationParameterTitleIsWrited = false; for (int i = 0; i < mode.GetOperationParams().Items.Length; i++) { if (operationParameterTitleIsWrited == false) { var titleNode = new TreeNode(); titleNode.Tag = new string[] { "Описание параметра", "Lua имя" }; operationParameterNodes.Nodes.Add(titleNode); operationParameterTitleIsWrited = true; } string name = mode.GetOperationParams().Items[i].DisplayText[0]; OperationParam operationParameter = mode .GetOperationParams().Items[i] as OperationParam; var operationParameterNode = new TreeNode(name); operationParameterNode.Tag = new string[] { name, operationParameter.Param.GetNameLua() }; operationParameterNodes.Nodes.Add(operationParameterNode); } }
public JsonResult GetData(OperationParam operationParam) { int total = 0; var queryData = SMFUNCTBService.LoadSearchEntities(operationParam); total = operationParam.TotalCount; var data = queryData.ToList().Select(s => new { FUNC_ID = s.FUNC_ID, FUNC_NAME = s.FUNC_NAME, EVENT_NAME = s.EVENT_NAME, ICONIC = s.ICONIC, ORDERCODE = s.ORDERCODE, PARENTFUNC_CODE = s.PARENTFUNC_CODE, STATUS = s.STATUS.GetStatusName(), SM_SYSTEM = s.SM_SYSTEM, FUNC_CODE = s.FUNC_CODE, CLASS_NAME = s.CLASS_NAME }); //构造成Json的格式传递 var result = new { total = total, rows = data }; //return Json(result, JsonRequestBehavior.AllowGet); return(Json(result)); }
public Parameter(OperationParam parameter, Element element, Context context) { Name = context.CTSKeyWord[parameter.Name]; Notes = parameter.Notes; Default = parameter.Default ?? ""; ParameterType = context.GetCTSType(parameter.Type, element); }
public void Deserialize(Common.Serialization.IO.CompactReader reader) { identity = (StateTransferIdentity)reader.ReadObject(); opCode = (StateTransferOpCode)reader.ReadByte(); param = (OperationParam)reader.ReadObject(); }
public StateTransferOperation(StateTransferIdentity identity, StateTransferOpCode opCode, OperationParam param) { this.identity = identity; this.opCode = opCode; this.param = param; }
public void BucketTransferCompeleted(OperationParam op) { AckStateTransferCompeleted(op.GetParamValue(ParamName.BucketList) as ArrayList); }
public StateTxfrInfo GetBucketKeys(OperationParam op) { return(TransferBucketKeys((ArrayList)op.GetParamValue(ParamName.BucketList), (int)op.GetParamValue(ParamName.TransferId))); }
//public bool FreeResources() // { // try // { // BucketRemovalInfo info = null; // while (transferedBuckets.Count != 0) // { // lock (transferedBuckets) // { // transferedBuckets.TryDequeue(out info); // } // if (info != null) // { // BucketRemoval.Execute(info, Context.DatabasesManager, _isLocal, _isReplica); // } // } // if (_isTransferCompleted && transferedBuckets.Count == 0) // { // try // { // DropBucketKeysCollection(); // } // catch (Exception ex) // { // LoggerManager.Instance.StateXferLogger.Error("StateTxferCorresponder.FreeResources(1)", ex.Message); // } // return true; // } // } // catch (Exception ex) // { // LoggerManager.Instance.StateXferLogger.Error("StateTxferCorresponder.FreeResources(2)", ex.Message); // } // return false; // } public StateTxfrInfo GetBucketData(OperationParam op) { return(TransferBucket((ArrayList)op.GetParamValue(ParamName.BucketList), (bool)op.GetParamValue(ParamName.SparsedBuckets), (int)op.GetParamValue(ParamName.TransferId))); }
public ActionResult Index(OperationParam op) { #region 验证登录 User loginUser = AccountHelper.LoginUser; if (loginUser == null) { return(RedirectToAction("Login", "Home", new { area = "" })); } ViewBag.LoginUser = loginUser; #endregion #region 验证权限 string pageId = "Index_Pictures"; //站点目录中的id属性值 if (!Access.Validate(pageId)) { return(HttpNotFound()); } ViewBag.PageId = pageId; #endregion #region 翻页、查询、排序、显示全部、移动、删除 ReturnValue returnValue = new ReturnValue(); Picture deleteData = null; switch (op.OpType) { case OperationType.Pager: break; case OperationType.Query: break; case OperationType.Sort: break; case OperationType.ShowAll: break; case OperationType.RankUp: break; case OperationType.Delete: deleteData = db.Pictures.Find(Guid.Parse(op.OpArgument)); if (deleteData == null) { returnValue.Type = ReturnType.DeleteFailure; returnValue.Message = ResultMessage.DeleteFailure; } else { try { db.Pictures.Remove(deleteData); db.SaveChanges(); returnValue.Type = ReturnType.DeleteSuccess; returnValue.Message = ResultMessage.DeleteSuccess; } catch { db.Entry(deleteData).State = EntityState.Unchanged; returnValue.Type = ReturnType.DeleteFailure; returnValue.Message = ResultMessage.DeleteFailure; } } OperationParam.Reset(ModelState); break; case OperationType.Deletes: string[] ids = op.OpArgument.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries); bool success = true; foreach (string id in ids) { deleteData = db.Pictures.Find(Guid.Parse(id)); if (deleteData == null) { continue; } else { db.Pictures.Remove(deleteData); } try { db.SaveChanges(); } catch { db.Entry(deleteData).State = EntityState.Unchanged; success = false; } } if (success) { returnValue.Type = ReturnType.DeletesSuccess; returnValue.Message = ResultMessage.DeletesSuccess; } else { returnValue.Type = ReturnType.DeletesFailure; returnValue.Message = ResultMessage.DeletesFailure; } OperationParam.Reset(ModelState); break; } #endregion IQueryable <Picture> datas = QueryHelper.ExecuteQuery(db.Pictures, op.OpQueryString); //执行前台查询条件(延迟)。若有附加条件,后续添加.Where()子句 Pager pager = new Pager(datas.Count(), op.OpPager, null); //页码相关对象 ViewBag.Pager = pager; if (string.IsNullOrEmpty(op.OpSortProperty)) { op.OpSortProperty = "Name"; op.OpSortDirection = SortDirection.Ascending; } //首次打开页面的初始排序依据及方向 <需修改> IList <Picture> pictures = datas //.Include(s=>s.) //Include所有需要的导航属性和导航集合(含多级导航),一次性查询数据库 <需修改> .Sort(op.OpSortProperty, op.OpSortDirection) //排序 .GetPageData(pager) //选择当前页的数据 .ToList(); //执行查询 ViewBag.OperationParam = op; ViewBag.ReturnValue = returnValue.ToJson(); return(View(pictures)); }
public ActionResult Index(OperationParam op) { #region 验证登录 User loginUser = AccountHelper.LoginUser; if (loginUser == null) { return(RedirectToAction("Login", "Home", new { area = "" })); } ViewBag.LoginUser = loginUser; #endregion #region 验证权限 string pageId = "Index_Role";//站点目录中的id属性值 if (!Access.Validate(pageId)) { return(HttpNotFound()); } ViewBag.PageId = pageId; #endregion #region 除 ReturnValue returnValue = new ReturnValue(); switch (op.OpType) { case OperationType.Pager: break; case OperationType.Query: break; case OperationType.Sort: break; case OperationType.ShowAll: break; case OperationType.RankUp: break; case OperationType.Delete: try { Role role = db.Roles.Find(Guid.Parse(op.OpArgument)); if (role == null) { returnValue.Type = ReturnType.DeleteFailure; returnValue.Message = ResultMessage.DeleteFailure; } else { db.Roles.Remove(role); db.SaveChanges(); returnValue.Type = ReturnType.DeleteSuccess; returnValue.Message = ResultMessage.DeleteSuccess; } } catch { returnValue.Type = ReturnType.DeleteFailure; returnValue.Message = ResultMessage.DeleteFailure; } OperationParam.Reset(ModelState); break; case OperationType.Deletes: try { string[] ids = op.OpArgument.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries); foreach (string id in ids) { Role role = db.Roles.Find(Guid.Parse(id)); if (role == null) { continue; } else { db.Roles.Remove(role); } } db.SaveChanges(); returnValue.Type = ReturnType.DeletesSuccess; returnValue.Message = ResultMessage.DeletesSuccess; } catch { returnValue.Type = ReturnType.DeletesFailure; returnValue.Message = ResultMessage.DeletesFailure; } OperationParam.Reset(ModelState); break; } #endregion IQueryable <Role> datas = QueryHelper.ExecuteQuery(db.Roles, op.OpQueryString); //前台查询条件(延迟执行)。若附加条件,添加Where Pager pager = new Pager(datas.Count(), op.OpPager, null); //页码相关对象 ViewBag.Pager = pager; if (string.IsNullOrEmpty(op.OpSortProperty)) { op.OpSortProperty = "Name"; op.OpSortDirection = SortDirection.Descending; } //首次打开页面的初始排序依据及方向 <需修改> List <Role> roles = datas.Sort(op.OpSortProperty, op.OpSortDirection).GetPageData(pager).ToList(); //数据排序、执行查询 ViewBag.OperationParam = op; ViewBag.ReturnValue = returnValue.ToJson(); return(View(roles)); }