/// <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));
}
