/// <summary>
/// 复杂查询操作
/// </summary>
protected void QueryRecord()
{
HttpContext context = HttpContext.Current;
HttpRequest request = context.Request;
HttpResponse response = context.Response;
string pageSize = request.Params["pageSize"];
string pageIndex = request.Params["pageIndex"];
string beginAddTime = request.Params["textBeginAddTime"];
string endAddTime = request.Params["textEndAddTime"];
string isSuccessId = request.Params["textIsSuccessId"];
string operationTable = request.Params["textOperationTable"];
string operationTypeCode = request.Params["selectOperationTypeCode"];
string resultCode = request.Params["textResultCode"];
string systemUserName = request.Params["textSystemUserName"];
CriterionAndOrder operationLogCriterionAndOrder = new CriterionAndOrder();
operationLogCriterionAndOrder.CriteriaName = typeof(OperationLog).FullName;
operationLogCriterionAndOrder.CriteriaAsName = "OL";
operationLogCriterionAndOrder.OrderList.Add(new Order("OL.AddTime", false));
CriterionAndOrder conLogCriterionAndOrder = new CriterionAndOrder();
conLogCriterionAndOrder.CriteriaName = "ConLogRef";
conLogCriterionAndOrder.CriteriaAsName = "CL";
conLogCriterionAndOrder.CriteriaSpecification = CriteriaSpecification.LeftJoin;
CriterionAndOrder systemUserCriterionAndOrder = new CriterionAndOrder();
systemUserCriterionAndOrder.CriteriaName = "SystemUserRef";
systemUserCriterionAndOrder.CriteriaAsName = "SU";
systemUserCriterionAndOrder.CriteriaSpecification = CriteriaSpecification.LeftJoin;
if (!String.IsNullOrEmpty(beginAddTime))
operationLogCriterionAndOrder.CriterionList.Add(Restrictions.Gt("OL.AddTime", Convert.ToDateTime(beginAddTime)));
if (!String.IsNullOrEmpty(endAddTime))
operationLogCriterionAndOrder.CriterionList.Add(Restrictions.Lt("OL.AddTime", Convert.ToDateTime(endAddTime)));
if (!String.IsNullOrEmpty(isSuccessId))
operationLogCriterionAndOrder.CriterionList.Add(Restrictions.Eq("OL.IsSuccessId", isSuccessId));
if (!String.IsNullOrEmpty(operationTable))
operationLogCriterionAndOrder.CriterionList.Add(Restrictions.Like("OL.OperationTable", "%" + operationTable + "%"));
if (!String.IsNullOrEmpty(operationTypeCode))
operationLogCriterionAndOrder.CriterionList.Add(Restrictions.Eq("OL.OperationTypeCode", operationTypeCode));
if (!String.IsNullOrEmpty(resultCode))
operationLogCriterionAndOrder.CriterionList.Add(Restrictions.Eq("OL.ResultCode", Convert.ToInt32(resultCode)));
if (!String.IsNullOrEmpty(systemUserName))
operationLogCriterionAndOrder.CriterionList.Add(Restrictions.Like("OL.SystemUserId", "%" + systemUserName + "%"));
ProjectionList pList = Projections.ProjectionList();
pList.Add(Projections.Property("OL.LogId").As("PrimaryKey"));
pList.Add(Projections.Property("OL.AddTime").As("AddTime"));
pList.Add(Projections.Property("OL.IsSuccessText").As("IsSuccessText"));
pList.Add(Projections.Property("OL.LogId").As("LogId"));
pList.Add(Projections.Property("OL.ObjectRecordId").As("ObjectRecordId"));
pList.Add(Projections.Property("OL.OperationContent").As("OperationContent"));
pList.Add(Projections.Property("OL.OperationTable").As("OperationTable"));
pList.Add(Projections.Property("OL.OperationTypeText").As("OperationTypeText"));
pList.Add(Projections.Property("OL.ResultText").As("ResultText"));
pList.Add(Projections.Property("SU.UserId").As("SystemUserId"));
pList.Add(Projections.Property("SU.UserName").As("SystemUserName"));
QueryTerms queryTerms = new QueryTerms();
queryTerms.PersistentClass = typeof(OperationLog);
queryTerms.ColumnList = pList;
queryTerms.CriterionAndOrderList.Add(operationLogCriterionAndOrder);
queryTerms.CriterionAndOrderList.Add(conLogCriterionAndOrder);
queryTerms.CriterionAndOrderList.Add(systemUserCriterionAndOrder);
queryTerms.PageSize = Convert.ToInt32(pageSize);
queryTerms.PageIndex = Convert.ToInt32(pageIndex) - 1;
ResultModel result = OperationLogBll.GetOperationLogList(queryTerms);
string jsonString = JsonConvert.SerializeObject(result, new JsonSerializerSettings()
{
NullValueHandling = NullValueHandling.Ignore,
ReferenceLoopHandling = ReferenceLoopHandling.Ignore
});
response.Write(jsonString);
}
/// <summary>
/// 复杂查询操作
/// </summary>
protected void QueryRecord()
{
HttpContext context = HttpContext.Current;
HttpRequest request = context.Request;
HttpResponse response = context.Response;
string pageSize = request.Params["pageSize"];
string pageIndex = request.Params["pageIndex"];
string addTime = request.Params["textAddTime"];
string description = request.Params["textDescription"];
string id = request.Params["textId"];
string name = request.Params["textName"];
string updateTime = request.Params["textUpdateTime"];
//keywords是处理AutoComplete下接框查询时设置的传入参数
string keywords = request.Params["keywords"];
CriterionAndOrder dictionaryTypeCriterionAndOrder = new CriterionAndOrder();
dictionaryTypeCriterionAndOrder.CriteriaName = typeof(DictionaryType).FullName;
dictionaryTypeCriterionAndOrder.CriteriaAsName = "DT";
dictionaryTypeCriterionAndOrder.OrderList.Add(new Order("DT.AddTime", false));
if (!String.IsNullOrEmpty(addTime))
dictionaryTypeCriterionAndOrder.CriterionList.Add(Restrictions.Gt("DT.AddTime", Convert.ToDateTime(addTime)));
if (!String.IsNullOrEmpty(description))
dictionaryTypeCriterionAndOrder.CriterionList.Add(Restrictions.Like("DT.Description", "%" + description + "%"));
if (!String.IsNullOrEmpty(keywords))
dictionaryTypeCriterionAndOrder.CriterionList.Add(Restrictions.Like("DT.Description", "%" + keywords + "%"));
if (!String.IsNullOrEmpty(id))
dictionaryTypeCriterionAndOrder.CriterionList.Add(Restrictions.Eq("DT.Id", id));
if (!String.IsNullOrEmpty(name))
dictionaryTypeCriterionAndOrder.CriterionList.Add(Restrictions.Like("DT.Name", "%" + name + "%"));
if (!String.IsNullOrEmpty(updateTime))
dictionaryTypeCriterionAndOrder.CriterionList.Add(Restrictions.Gt("DT.UpdateTime", Convert.ToDateTime(updateTime)));
ProjectionList pList = Projections.ProjectionList();
pList.Add(Projections.Property("DT.Id").As("PrimaryKey"));
pList.Add(Projections.Property("DT.AddTime").As("AddTime"));
pList.Add(Projections.Property("DT.Description").As("Description"));
pList.Add(Projections.Property("DT.Id").As("Id"));
pList.Add(Projections.Property("DT.Name").As("Name"));
pList.Add(Projections.Property("DT.UpdateTime").As("UpdateTime"));
QueryTerms queryTerms = new QueryTerms();
queryTerms.PersistentClass = typeof(DictionaryType);
queryTerms.ColumnList = pList;
queryTerms.CriterionAndOrderList.Add(dictionaryTypeCriterionAndOrder);
queryTerms.PageSize = Convert.ToInt32(pageSize);
queryTerms.PageIndex = Convert.ToInt32(pageIndex) - 1;
ResultModel result = DictionaryTypeBll.GetDictionaryTypeList(queryTerms);
string jsonString = JsonConvert.SerializeObject(result, new JsonSerializerSettings()
{
NullValueHandling = NullValueHandling.Ignore,
ReferenceLoopHandling = ReferenceLoopHandling.Ignore
});
response.Write(jsonString);
}
/// <summary>
/// 复杂查询操作
/// </summary>
protected void QueryRecord()
{
HttpContext context = HttpContext.Current;
HttpRequest request = context.Request;
HttpResponse response = context.Response;
string pageSize = request.Params["pageSize"];
string pageIndex = request.Params["pageIndex"];
string addTime = request.Params["textAddTime"];
string code = request.Params["textCode"];
string description = request.Params["textDescription"];
string id = request.Params["textId"];
string name = request.Params["textName"];
string typeName = request.Params["textTypeName"];
string updateTime = request.Params["textUpdateTime"];
string typeId = request.Params["textTypeId"];
CriterionAndOrder dictionaryCriterionAndOrder = new CriterionAndOrder();
dictionaryCriterionAndOrder.CriteriaName = typeof(Dictionary).FullName;
dictionaryCriterionAndOrder.CriteriaAsName = "D";
dictionaryCriterionAndOrder.OrderList.Add(new Order("D.TypeId", true));
dictionaryCriterionAndOrder.OrderList.Add(new Order("D.Code", true));
CriterionAndOrder dictionaryTypeCriterionAndOrder = new CriterionAndOrder();
dictionaryTypeCriterionAndOrder.CriteriaName = "TypeRef";
dictionaryTypeCriterionAndOrder.CriteriaAsName = "DT";
dictionaryTypeCriterionAndOrder.CriteriaSpecification = CriteriaSpecification.LeftJoin;
if (!String.IsNullOrEmpty(addTime))
dictionaryCriterionAndOrder.CriterionList.Add(Restrictions.Gt("D.AddTime", Convert.ToDateTime(addTime)));
if (!String.IsNullOrEmpty(code))
dictionaryCriterionAndOrder.CriterionList.Add(Restrictions.Eq("D.Code", Convert.ToChar(code)));
if (!String.IsNullOrEmpty(description))
dictionaryCriterionAndOrder.CriterionList.Add(Restrictions.Like("D.Description", "%" + description + "%"));
if (!String.IsNullOrEmpty(id))
dictionaryCriterionAndOrder.CriterionList.Add(Restrictions.Eq("D.Id", id));
if (!String.IsNullOrEmpty(name))
dictionaryCriterionAndOrder.CriterionList.Add(Restrictions.Like("D.Name", "%" + name + "%"));
if (!String.IsNullOrEmpty(typeId))
dictionaryCriterionAndOrder.CriterionList.Add(Restrictions.Eq("D.TypeId", typeId));
if (!String.IsNullOrEmpty(typeName))
dictionaryCriterionAndOrder.CriterionList.Add(Restrictions.Like("DT.Name", "%" + typeName + "%"));
if (!String.IsNullOrEmpty(updateTime))
dictionaryCriterionAndOrder.CriterionList.Add(Restrictions.Gt("D.UpdateTime", Convert.ToDateTime(updateTime)));
ProjectionList pList = Projections.ProjectionList();
pList.Add(Projections.Property("D.Id").As("PrimaryKey"));
pList.Add(Projections.Property("D.AddTime").As("AddTime"));
pList.Add(Projections.Property("D.Code").As("Code"));
pList.Add(Projections.Property("D.Description").As("Description"));
pList.Add(Projections.Property("D.Id").As("Id"));
pList.Add(Projections.Property("D.Name").As("Name"));
pList.Add(Projections.Property("DT.Id").As("TypeId"));
pList.Add(Projections.Property("DT.Name").As("TypeName"));
pList.Add(Projections.Property("D.UpdateTime").As("UpdateTime"));
QueryTerms queryTerms = new QueryTerms();
queryTerms.PersistentClass = typeof(Dictionary);
queryTerms.ColumnList = pList;
queryTerms.CriterionAndOrderList.Add(dictionaryCriterionAndOrder);
queryTerms.CriterionAndOrderList.Add(dictionaryTypeCriterionAndOrder);
queryTerms.PageSize = Convert.ToInt32(pageSize);
queryTerms.PageIndex = Convert.ToInt32(pageIndex) - 1;
ResultModel result = DictionaryBll.GetDictionaryList(queryTerms);
string jsonString = JsonConvert.SerializeObject(result, new JsonSerializerSettings()
{
NullValueHandling = NullValueHandling.Ignore,
ReferenceLoopHandling = ReferenceLoopHandling.Ignore
});
response.Write(jsonString);
}
/// <summary>
/// 复杂查询操作
/// </summary>
protected void QueryRecord()
{
HttpContext context = HttpContext.Current;
HttpRequest request = context.Request;
HttpResponse response = context.Response;
string pageSize = request.Params["pageSize"];
string pageIndex = request.Params["pageIndex"];
string addTime = request.Params["textAddTime"];
string description = request.Params["textDescription"];
string isPublic = request.Params["textIsPublic"];
string moduleId = request.Params["textModuleId"];
string moduleLevelId = request.Params["selectModuleLevelId"];
string moduleName = request.Params["textModuleName"];
string parentModuleId = request.Params["selectParentModuleId"];
string sortFieldId = request.Params["textSortFieldId"];
string order = request.Params["order"];
CriterionAndOrder moduleCriterionAndOrder = new CriterionAndOrder();
moduleCriterionAndOrder.CriteriaName = typeof(FunctionModule).FullName;
moduleCriterionAndOrder.CriteriaAsName = "FM";
if (!String.IsNullOrEmpty(order))
moduleCriterionAndOrder.OrderList.Add(new Order(order, false));
else
moduleCriterionAndOrder.OrderList.Add(new Order("FM.SortFieldId", true));
CriterionAndOrder parentModuleCriterionAndOrder = new CriterionAndOrder();
parentModuleCriterionAndOrder.CriteriaName = "ParentModuleRef";
parentModuleCriterionAndOrder.CriteriaAsName = "PF";
parentModuleCriterionAndOrder.CriteriaSpecification = CriteriaSpecification.LeftJoin;
parentModuleCriterionAndOrder.OrderList.Add(new Order("PF.SortFieldId", true));
if (!String.IsNullOrEmpty(addTime))
moduleCriterionAndOrder.CriterionList.Add(Restrictions.Eq("FM.AddTime", addTime));
if (!String.IsNullOrEmpty(description))
moduleCriterionAndOrder.CriterionList.Add(Restrictions.Eq("FM.Description", description));
if (!String.IsNullOrEmpty(isPublic))
moduleCriterionAndOrder.CriterionList.Add(Restrictions.Eq("FM.IsPublicId", isPublic));
if (!String.IsNullOrEmpty(moduleId))
moduleCriterionAndOrder.CriterionList.Add(Restrictions.Eq("FM.ModuleId", moduleId));
if (!String.IsNullOrEmpty(moduleLevelId))
moduleCriterionAndOrder.CriterionList.Add(Restrictions.Eq("FM.ModuleLevelId", Convert.ToInt32(moduleLevelId)));
if (!String.IsNullOrEmpty(moduleName))
moduleCriterionAndOrder.CriterionList.Add(Restrictions.Like("FM.ModuleName", "%" + moduleName + "%"));
if (!String.IsNullOrEmpty(parentModuleId))
moduleCriterionAndOrder.CriterionList.Add(Restrictions.Eq("FM.ParentModuleId", parentModuleId));
if (!String.IsNullOrEmpty(sortFieldId))
moduleCriterionAndOrder.CriterionList.Add(Restrictions.Eq("FM.SortFieldId", sortFieldId));
ProjectionList pList = Projections.ProjectionList();
pList.Add(Projections.Property("FM.ModuleId").As("ModuleId"));
pList.Add(Projections.Property("FM.ModuleId").As("PrimaryKey"));
pList.Add(Projections.Property("FM.ModuleName").As("ModuleName"));
pList.Add(Projections.Property("FM.UpdateTime").As("UpdateTime"));
pList.Add(Projections.Property("FM.AddTime").As("AddTime"));
pList.Add(Projections.Property("FM.ModuleLevelId").As("ModuleLevelId"));
pList.Add(Projections.Property("FM.ModuleLevelName").As("ModuleLevelName"));
pList.Add(Projections.Property("PF.ModuleId").As("ParentModuleId"));
pList.Add(Projections.Property("PF.ModuleName").As("ParentModuleName"));
pList.Add(Projections.Property("FM.SortFieldId").As("SortFieldId"));
pList.Add(Projections.Property("FM.SortFieldName").As("SortFieldName"));
pList.Add(Projections.Property("FM.IsPublicId").As("IsPublicId"));
pList.Add(Projections.Property("FM.IsPublicName").As("IsPublicName"));
QueryTerms queryTerms = new QueryTerms();
queryTerms.PersistentClass = typeof(FunctionModule);
queryTerms.ColumnList = pList;
queryTerms.CriterionAndOrderList.Add(moduleCriterionAndOrder);
queryTerms.CriterionAndOrderList.Add(parentModuleCriterionAndOrder);
queryTerms.PageSize = Convert.ToInt32(pageSize);
queryTerms.PageIndex = Convert.ToInt32(pageIndex) - 1;
ResultModel result = FunctionModuleBll.GetFunctionModuleList(queryTerms);
string jsonString = JsonConvert.SerializeObject(result, new JsonSerializerSettings()
{
NullValueHandling = NullValueHandling.Ignore,
ReferenceLoopHandling = ReferenceLoopHandling.Ignore
});
response.Write(jsonString);
}
/// <summary>
/// 根据角色查询相应功能模块
/// </summary>
protected void GetModuleListByRole()
{
HttpContext context = HttpContext.Current;
HttpRequest request = context.Request;
HttpResponse response = context.Response;
string roleId= request.Params["roleId"];
CriterionAndOrder moduleCriterionAndOrder = new CriterionAndOrder();
moduleCriterionAndOrder.CriteriaName = typeof(FunctionModule).FullName;
moduleCriterionAndOrder.CriteriaAsName = "FE";
CriterionAndOrder roleCriterionAndOrder = new CriterionAndOrder();
roleCriterionAndOrder.CriteriaName = "Role";
roleCriterionAndOrder.CriteriaAsName = "RO";
roleCriterionAndOrder.CriteriaSpecification = CriteriaSpecification.InnerJoin;
if (!String.IsNullOrEmpty(roleId))
moduleCriterionAndOrder.CriterionList.Add(Restrictions.Eq("RO.RoleId", roleId));
ProjectionList pList = Projections.ProjectionList();
pList.Add(Projections.Property("FE.ModuleId").As("ModuleId"));
QueryTerms queryTerms = new QueryTerms();
queryTerms.PersistentClass = typeof(FunctionModule);
queryTerms.ColumnList = pList;
queryTerms.CriterionAndOrderList.Add(moduleCriterionAndOrder);
queryTerms.CriterionAndOrderList.Add(roleCriterionAndOrder);
ResultModel result = FunctionModuleBll.GetFunctionModuleList(queryTerms);
string jsonString = JsonConvert.SerializeObject(result, new JsonSerializerSettings()
{
ReferenceLoopHandling = ReferenceLoopHandling.Ignore
});
response.Write(jsonString);
}
/// <summary>
/// 复杂查询操作
/// </summary>
protected void QueryRecord()
{
HttpContext contenxt = HttpContext.Current;
HttpRequest request = contenxt.Request;
HttpResponse response = contenxt.Response;
string pageSize = request.Params["pageSize"];
string pageIndex = request.Params["pageIndex"];
string userName = request.Params["textUserName"];
string beginAddTime = request.Params["textBeginAddTime"];
string endAddTime = request.Params["textEndAddTime"];
string onlineFlagId = request.Params["selectOnlineFlag"];
CriterionAndOrder systemUserCriterionAndOrder = new CriterionAndOrder();
systemUserCriterionAndOrder.CriteriaName = typeof(SystemUser).FullName;
systemUserCriterionAndOrder.CriteriaAsName = "SU";
systemUserCriterionAndOrder.OrderList.Add(new Order("SU.AddTime", false));
if (!String.IsNullOrEmpty(userName))
systemUserCriterionAndOrder.CriterionList.Add(Restrictions.Like("SU.UserName", "%" + userName + "%"));
if (!String.IsNullOrEmpty(beginAddTime))
systemUserCriterionAndOrder.CriterionList.Add(Restrictions.Gt("SU.AddTime", Convert.ToDateTime(beginAddTime)));
if (!String.IsNullOrEmpty(endAddTime))
systemUserCriterionAndOrder.CriterionList.Add(Restrictions.Lt("SU.AddTime", Convert.ToDateTime(endAddTime)));
if (!String.IsNullOrEmpty(onlineFlagId))
systemUserCriterionAndOrder.CriterionList.Add(Restrictions.Eq("SU.OnlineFlagId", Convert.ToChar(onlineFlagId)));
ProjectionList pList = Projections.ProjectionList();
pList.Add(Projections.Property("SU.GenderName").As("GenderName"));
pList.Add(Projections.Property("SU.OnlineFlagName").As("OnlineFlagName"));
pList.Add(Projections.Property("SU.UserId").As("UserId"));
pList.Add(Projections.Property("SU.UserId").As("PrimaryKey"));
pList.Add(Projections.Property("SU.UserName").As("UserName"));
pList.Add(Projections.Property("SU.RealName").As("RealName"));
pList.Add(Projections.Property("SU.NickName").As("NickName"));
pList.Add(Projections.Property("SU.AddTime").As("AddTime"));
QueryTerms queryTerms = new QueryTerms();
queryTerms.PersistentClass = typeof(SystemUser);
queryTerms.ColumnList = pList;
queryTerms.CriterionAndOrderList.Add(systemUserCriterionAndOrder);
queryTerms.PageSize = Convert.ToInt32(pageSize);
queryTerms.PageIndex = Convert.ToInt32(pageIndex) - 1;
ResultModel result = SystemUserBll.GetSystemUserList(queryTerms);
string jsonString = JsonConvert.SerializeObject(result, new JsonSerializerSettings()
{
NullValueHandling = NullValueHandling.Ignore,
ReferenceLoopHandling = ReferenceLoopHandling.Ignore
});
response.Write(jsonString);
}
/// <summary>
/// 复杂查询操作
/// </summary>
protected void QueryRecord()
{
HttpContext context = HttpContext.Current;
HttpRequest request = context.Request;
HttpResponse response = context.Response;
string pageSize = request.Params["pageSize"];
string pageIndex = request.Params["pageIndex"];
string addTime = request.Params["textAddTime"];
string description = request.Params["textDescription"];
string functionModule = request.Params["textFunctionModule"];
string menuId = request.Params["textMenuId"];
string menuName = request.Params["textMenuName"];
string webPageId = request.Params["textWebPageId"];
string url = request.Params["textUrl"];
string moduleLevel = request.Params["selectModuleLevelId"];
string parentModule = request.Params["selectParentModuleId"];
CriterionAndOrder linkMenuCriterionAndOrder = new CriterionAndOrder();
linkMenuCriterionAndOrder.CriteriaName = typeof(LinkMenu).FullName;
linkMenuCriterionAndOrder.CriteriaAsName = "LM";
CriterionAndOrder webPageCriterionAndOrder = new CriterionAndOrder();
webPageCriterionAndOrder.CriteriaName = "WebPageRef";
webPageCriterionAndOrder.CriteriaAsName = "WP";
webPageCriterionAndOrder.CriteriaSpecification = CriteriaSpecification.LeftJoin;
CriterionAndOrder functionModuleCriterionAndOrder = new CriterionAndOrder();
functionModuleCriterionAndOrder.CriteriaName = "FunctionModuleRef";
functionModuleCriterionAndOrder.CriteriaAsName = "FM";
functionModuleCriterionAndOrder.CriteriaSpecification = CriteriaSpecification.LeftJoin;
if (!String.IsNullOrEmpty(addTime))
linkMenuCriterionAndOrder.CriterionList.Add(Restrictions.Eq("LM.AddTime", Convert.ToDateTime(addTime)));
if (!String.IsNullOrEmpty(description))
linkMenuCriterionAndOrder.CriterionList.Add(Restrictions.Eq("LM.Description", description));
if (!String.IsNullOrEmpty(functionModule))
linkMenuCriterionAndOrder.CriterionList.Add(Restrictions.Eq("LM.FunctionModule", functionModule));
if (!String.IsNullOrEmpty(menuId))
linkMenuCriterionAndOrder.CriterionList.Add(Restrictions.Eq("LM.MenuId", menuId));
if (!String.IsNullOrEmpty(menuName))
linkMenuCriterionAndOrder.CriterionList.Add(Restrictions.Like("LM.MenuName", "%" + menuName + "%"));
if (!String.IsNullOrEmpty(webPageId))
webPageCriterionAndOrder.CriterionList.Add(Restrictions.Eq("WP.WebPageId", webPageId));
if (!String.IsNullOrEmpty(url))
webPageCriterionAndOrder.CriterionList.Add(Restrictions.Like("WP.Url", "%" + url + "%"));
if (!String.IsNullOrEmpty(moduleLevel))
functionModuleCriterionAndOrder.CriterionList.Add(Restrictions.Eq("FM.ModuleLevelId", Convert.ToInt32(moduleLevel)));
if (!String.IsNullOrEmpty(parentModule))
functionModuleCriterionAndOrder.CriterionList.Add(Restrictions.Eq("FM.ParentModuleId", parentModule));
ProjectionList pList = Projections.ProjectionList();
pList.Add(Projections.Property("LM.MenuId").As("PrimaryKey"));
pList.Add(Projections.Property("LM.MenuId").As("MenuId"));
pList.Add(Projections.Property("LM.MenuName").As("MenuName"));
pList.Add(Projections.Property("LM.AddTime").As("AddTime"));
pList.Add(Projections.Property("FM.ModuleId").As("FunctionModuleId"));
pList.Add(Projections.Property("FM.ModuleName").As("FunctionModuleName"));
pList.Add(Projections.Property("WP.PageId").As("WebPageId"));
pList.Add(Projections.Property("WP.Url").As("WebPageUrl"));
functionModuleCriterionAndOrder.OrderList.Add(new Order("FM.ModuleLevelId", true));
functionModuleCriterionAndOrder.OrderList.Add(new Order("FM.ParentModuleId", true));
functionModuleCriterionAndOrder.OrderList.Add(new Order("FM.SortFieldId", true));
QueryTerms queryTerms = new QueryTerms();
queryTerms.PersistentClass = typeof(LinkMenu);
queryTerms.ColumnList = pList;
queryTerms.CriterionAndOrderList.Add(linkMenuCriterionAndOrder);
queryTerms.CriterionAndOrderList.Add(webPageCriterionAndOrder);
queryTerms.CriterionAndOrderList.Add(functionModuleCriterionAndOrder);
queryTerms.PageSize = Convert.ToInt32(pageSize);
queryTerms.PageIndex = Convert.ToInt32(pageIndex) - 1;
ResultModel result = LinkMenuBll.GetLinkMenuList(queryTerms);
string jsonString = JsonConvert.SerializeObject(result, new JsonSerializerSettings()
{
ReferenceLoopHandling = ReferenceLoopHandling.Ignore
});
response.Write(jsonString);
}
