/// <summary>
/// 功能编号不能重复
/// </summary>
/// <param name="enCode">编号</param>
/// <param name="keyValue">主键</param>
/// <returns></returns>
public bool ExistEnCode(string enCode, string keyValue)
{
bool res = false;
IDbTransaction tran = null;
Logger(this.GetType(), "ExistEnCode-功能编号不能重复", () =>
{
using (var conn = this.BaseRepository().GetBaseConnection())
{
tran = conn.BeginTransaction();
var expression = LambdaExtension.True <ModuleEntity>();
expression = expression.And(t => t.EnCode == enCode);
if (!string.IsNullOrEmpty(keyValue))
{
expression = expression.And(t => t.Id != keyValue);
}
res = this.BaseRepository().FindList <ModuleEntity>(conn, expression, tran).ToList().Count == 0;
tran.Commit();
}
}, e =>
{
Trace.WriteLine(e.Message);
});
return(res);
}
/// <summary>
/// 新闻列表
/// </summary>
/// <param name="pagination">分页</param>
/// <param name="queryJson">查询参数</param>
/// <returns></returns>
public IEnumerable <NewsEntity> GetPageList(PaginationEntity pagination, string queryJson)
{
var expression = LambdaExtension.True <NewsEntity>();
JObject queryParam = queryJson.TryToJObject();
if (queryParam != null)
{
if (!queryParam["FullHead"].IsEmpty())
{
string FullHead = queryParam["FullHead"].ToString();
expression = expression.And(t => t.FullHead.Contains(FullHead));
}
if (!queryParam["Category"].IsEmpty())
{
string Category = queryParam["Category"].ToString();
expression = expression.And(t => t.Category == Category);
}
if (!queryParam["CategoryId"].IsEmpty())
{
string CategoryId = queryParam["CategoryId"].ToString();
expression = expression.And(t => t.CategoryId == CategoryId);
}
}
expression = expression.And(t => t.TypeId == 1);
return(this.BaseRepository().FindList(expression, pagination));
}
/// <summary>
/// 职位名称不能重复
/// </summary>
/// <param name="fullName">名称</param>
/// <param name="keyValue">主键</param>
/// <returns></returns>
public bool ExistFullName(string fullName, string keyValue)
{
bool res = false;
IDbTransaction tran = null;
Logger(this.GetType(), "ExistFullName-职位名称不能重复", () =>
{
using (var conn = this.BaseRepository().GetBaseConnection())
{
tran = conn.BeginTransaction();
var expression = LambdaExtension.True <RoleEntity>();
expression = expression.And(t => t.FullName == fullName).And(t => t.Category == 3);
if (!string.IsNullOrEmpty(keyValue))
{
expression = expression.And(t => t.Id != keyValue);
}
res = !this.BaseRepository().FindList <RoleEntity>(conn, expression, tran).Any() ? true : false;
tran.Commit();
}
}, e =>
{
Trace.WriteLine(e.Message);
});
return(res);
}
/// <summary>
/// 获取列表
/// </summary>
/// <param name="queryJson">查询参数</param>
/// <returns>返回列表</returns>
public IEnumerable <UserDemandEntity> GetList(string queryJson)
{
var expression = LambdaExtension.True <UserDemandEntity>();
JObject queryParam = queryJson.TryToJObject();
if (queryParam != null)
{
if (!queryParam["Title"].IsEmpty())
{
string Title = queryParam["Title"].ToString();
expression = expression.And(t => t.Title.Contains(Title));
}
if (!queryParam["CategoryId"].IsEmpty())
{
string CategoryId = queryParam["CategoryId"].ToString();
expression = expression.And(t => t.CategoryId == CategoryId);
}
}
if (OperatorProvider.Provider.Current().IsSystem)
{
expression = expression.And(t => t.IsDelete == false);
}
else
{
expression = expression.And(t => t.IsDelete == false && t.CreateUserId == OperatorProvider.Provider.Current().UserId);
}
return(this.BaseRepository().FindList(expression));
}
/// <summary>
/// 根据分类编号获取实体对象
/// </summary>
/// <param name="itemCode">编号</param>
/// <returns></returns>
public DataItemEntity GetEntityByCode(string itemCode)
{
DataItemEntity res = null;
IDbTransaction tran = null;
Logger(this.GetType(), "GetMemberList-获取成员列表", () =>
{
using (var conn = this.BaseRepository().GetBaseConnection())
{
tran = conn.BeginTransaction();
var expression = LambdaExtension.True <DataItemEntity>();
if (!string.IsNullOrEmpty(itemCode))
{
expression = expression.And(t => t.ItemCode == itemCode);
}
expression = expression.And(d => d.DeleteMark == false && d.EnabledMark == true);
res = this.BaseRepository().FindEntity <DataItemEntity>(conn, expression, tran);
tran.Commit();
}
}, e =>
{
Trace.WriteLine(e.Message);
});
return(res);
}
/// <summary>
/// 获取列表
/// </summary>
/// <param name="queryJson">查询参数</param>
/// <returns>返回列表</returns>
public IEnumerable <WechatConfigEntity> GetList(string queryJson)
{
IEnumerable <WechatConfigEntity> res = null;
IDbTransaction tran = null;
Logger(this.GetType(), "GetPageList-获取列表", () =>
{
using (var conn = this.BaseRepository().GetBaseConnection())
{
tran = conn.BeginTransaction();
var expression = LambdaExtension.True <WechatConfigEntity>();
JObject queryParam = queryJson.TryToJObject();
if (queryParam != null)
{
if (!queryParam["AppSecret"].IsEmpty())
{
string AppSecret = queryParam["AppSecret"].ToString();
expression = expression.And(t => t.AppSecret.Contains(AppSecret));
}
}
expression = expression.And(c => c.DeleteMark == false);
res = this.BaseRepository().FindList <WechatConfigEntity>(conn, expression, tran);
tran.Commit();
}
}, e =>
{
Trace.WriteLine(e.Message);
});
return(res);
}
/// <summary>
/// 按钮列表
/// </summary>
/// <param name="moduleId">功能Id</param>
/// <returns></returns>
public IEnumerable <ModuleButtonEntity> GetList(string moduleId)
{
var expression = LambdaExtension.True <ModuleButtonEntity>();
expression = expression.And(t => t.ModuleId == moduleId);
return(this.BaseRepository().FindList(expression).OrderBy(t => t.SortCode).ToList());
}
/// <summary>
/// 区域列表
/// </summary>
/// <param name="parentId">节点Id</param>
/// <param name="keyword">关键字查询</param>
/// <returns></returns>
public IEnumerable <AreaEntity> GetList(string parentId, string keyword)
{
IEnumerable <AreaEntity> res = null;
IDbTransaction tran = null;
Logger(this.GetType(), "GetList-区域列表", () =>
{
using (var conn = this.BaseRepository().GetBaseConnection())
{
tran = conn.BeginTransaction();
var expression = LambdaExtension.True <AreaEntity>();
if (!string.IsNullOrEmpty(parentId))
{
expression = expression.And(t => t.ParentId == parentId);
}
if (!string.IsNullOrEmpty(keyword))
{
expression = expression.And(t => t.AreaCode.Contains(keyword));
expression = expression.Or(t => t.AreaName.Contains(keyword));
}
res = this.BaseRepository().FindList(conn, expression, tran).OrderBy(t => t.CreateDate).ToList();
tran.Commit();
}
}, e =>
{
Trace.WriteLine(e.Message);
});
return(res);
}
/// <summary>
/// 用户组列表
/// </summary>
/// <param name="pagination">分页</param>
/// <param name="queryJson">查询参数</param>
/// <returns></returns>
public IEnumerable <RoleEntity> GetPageList(PaginationEntity pagination, string queryJson)
{
var expression = LambdaExtension.True <RoleEntity>();
JObject queryParam = queryJson.TryToJObject();
if (queryParam != null)
{
string enCode = queryParam["EnCode"].ToString();
string fullName = queryParam["FullName"].ToString();
if (!string.IsNullOrEmpty(enCode))
{
expression = expression.And(t => t.EnCode.Contains(enCode));
}
if (!string.IsNullOrEmpty(fullName))
{
expression = expression.And(t => t.FullName.Contains(fullName));
}
}
expression = expression.And(t => t.Category == 4 && t.DeleteMark == false && t.EnabledMark == true);
IEnumerable <RoleEntity> res = this.BaseRepository().FindList <RoleEntity>(expression, pagination);
return(res);
}
/// <summary>
/// 职位列表
/// </summary>
/// <param name="pagination">分页</param>
/// <param name="queryJson">查询参数</param>
/// <returns></returns>
public IEnumerable <RoleEntity> GetPageList(PaginationEntity pagination, string queryJson)
{
var expression = LambdaExtension.True <RoleEntity>();
JObject queryParam = queryJson.TryToJObject();
if (queryParam != null)
{
//机构主键
if (!queryParam["organizeId"].IsEmpty())
{
string organizeId = queryParam["organizeId"].ToString();
expression = expression.And(t => t.OrganizeId == organizeId);
}
//查询条件
if (!queryParam["condition"].IsEmpty() && !queryParam["keyword"].IsEmpty())
{
string condition = queryParam["condition"].ToString();
string keyword = queryParam["keyword"].ToString();
switch (condition)
{
case "EnCode": //职位编号
expression = expression.And(t => t.EnCode.Contains(keyword));
break;
case "FullName": //职位名称
expression = expression.And(t => t.FullName.Contains(keyword));
break;
}
}
}
expression = expression.And(t => t.Category == 3);
return(this.BaseRepository().FindList <RoleEntity>(expression, pagination));
}
/// <summary>
/// 判断模块是否已经有系统表单
/// </summary>
/// <param name="keyValue"></param>
/// <param name="moduleId"></param>
/// <returns></returns>
public bool IsExistModuleId(string keyValue, string moduleId)
{
bool res = false;
IDbTransaction tran = null;
this.Logger(this.GetType(), "判断模块是否已经有系统表单-IsExistModuleId", () =>
{
using (var conn = this.BaseRepository().GetBaseConnection())
{
tran = conn.BeginTransaction();
var expression = LambdaExtension.True <ModuleFormEntity>();
if (string.IsNullOrEmpty(keyValue))
{
expression = expression.And(t => t.ModuleId == moduleId);
}
else
{
expression = expression.And(t => t.ModuleId == moduleId && t.Id != keyValue);
}
ModuleFormEntity entity = this.BaseRepository().FindEntity <ModuleFormEntity>(conn, expression, tran);
res = entity != null;
tran.Commit();
}
}, e =>
{
Trace.WriteLine(e.Message);
});
return(res);
}
/// <summary>
/// 用户组列表
/// </summary>
/// <returns></returns>
public IEnumerable <RoleEntity> GetUserGroupList()
{
var expression = LambdaExtension.True <RoleEntity>();
expression = expression.And(r => r.Category == 4 && r.DeleteMark == false && r.EnabledMark == true);
IEnumerable <RoleEntity> res = o.BllSession.UserGroupBll.FindList(expression);
return(res);
}
/// <summary>
/// 用户列表
/// </summary>
/// <returns></returns>
public IEnumerable <UserEntity> GetUserList()
{
var expression = LambdaExtension.True <UserEntity>();
expression = expression.And(t => t.UserId != "System").And(t => t.EnabledMark == true).And(t => t.DeleteMark == false);
IEnumerable <UserEntity> res = o.BllSession.UserBll.IQueryable(expression).OrderByDesc(u => u.CreateDate).ToList();
return(res);
}
/// <summary>
/// 职位编号不能重复
/// </summary>
/// <param name="enCode">编号</param>
/// <param name="keyValue">主键</param>
/// <returns></returns>
public bool ExistEnCode(string enCode, string keyValue)
{
var expression = LambdaExtension.True <RoleEntity>();
expression = expression.And(t => t.EnCode == enCode).And(t => t.Category == 3);
if (!string.IsNullOrEmpty(keyValue))
{
expression = expression.And(t => t.Id != keyValue);
}
return(!this.BaseRepository().FindList <RoleEntity>(expression).Any() ? true : false);
}
/// <summary>
/// 功能名称不能重复
/// </summary>
/// <param name="fullName">名称</param>
/// <param name="keyValue">主键</param>
/// <returns></returns>
public bool ExistFullName(string fullName, string keyValue)
{
var expression = LambdaExtension.True <ModuleEntity>();
expression = expression.And(t => t.FullName == fullName);
if (!string.IsNullOrEmpty(keyValue))
{
expression = expression.And(t => t.Id != keyValue);
}
return(this.BaseRepository().FindList <ModuleEntity>(expression).ToList().Count == 0);
}
/// <summary>
/// 岗位列表
/// </summary>
/// <returns></returns>
public IEnumerable <RoleEntity> GetPostList()
{
var expression = LambdaExtension.True <RoleEntity>();
expression = expression.And(t => t.Category == 2).And(t => t.EnabledMark == true).And(t => t.DeleteMark == false);
IEnumerable <RoleEntity> res = o.BllSession.PostBll.FindList(expression);
res = res.OrderByDescending(r => r.CreateDate);
return(res);
}
/// <summary>
/// 职位列表
/// </summary>
/// <param name="pagination">分页</param>
/// <param name="queryJson">查询参数</param>
/// <returns></returns>
public IEnumerable <RoleEntity> GetPageList(PaginationEntity pagination, string queryJson)
{
IEnumerable <RoleEntity> res = null;
IDbTransaction tran = null;
Logger(this.GetType(), "GetPageList-职位列表", () =>
{
using (var conn = this.BaseRepository().GetBaseConnection())
{
tran = conn.BeginTransaction();
var expression = LambdaExtension.True <RoleEntity>();
JObject queryParam = queryJson.TryToJObject();
if (queryParam != null)
{
//机构主键
if (!queryParam["organizeId"].IsEmpty())
{
string organizeId = queryParam["organizeId"].ToString();
expression = expression.And(t => t.OrganizeId == organizeId);
}
//查询条件
if (!queryParam["condition"].IsEmpty() && !queryParam["keyword"].IsEmpty())
{
string condition = queryParam["condition"].ToString();
string keyword = queryParam["keyword"].ToString();
switch (condition)
{
case "EnCode": //职位编号
expression = expression.And(t => t.EnCode.Contains(keyword));
break;
case "FullName": //职位名称
expression = expression.And(t => t.FullName.Contains(keyword));
break;
}
}
}
expression = expression.And(t => t.Category == 3);
Tuple <IEnumerable <RoleEntity>, int> tuple = this.BaseRepository().FindList <RoleEntity>(conn, expression, pagination.sidx, pagination.sord.ToLower() == "asc", pagination.rows, pagination.page, tran);
pagination.records = tuple.Item2;
res = tuple.Item1;
tran.Commit();
}
}, e =>
{
Trace.WriteLine(e.Message);
});
return(res);
}
/// <summary>
/// 组名称不能重复
/// </summary>
/// <param name="fullName">名称</param>
/// <param name="keyValue">主键</param>
/// <returns></returns>
public bool ExistFullName(string fullName, string keyValue)
{
var expression = LambdaExtension.True <RoleEntity>();
expression = expression.And(t => t.FullName == fullName).And(t => t.Category == 4 && t.DeleteMark == false && t.EnabledMark == true);
if (!string.IsNullOrEmpty(keyValue))
{
expression = expression.And(t => t.RoleId != keyValue);
}
bool hasExist = o.BllSession.UserGroupBll.IQueryable(expression).Any();
return(hasExist);
}
/// <summary>
/// 岗位编号不能重复
/// </summary>
/// <param name="enCode">编号</param>
/// <param name="keyValue">主键</param>
/// <returns></returns>
public bool ExistEnCode(string enCode, string keyValue)
{
var expression = LambdaExtension.True <RoleEntity>();
expression = expression.And(t => t.EnCode == enCode).And(t => t.Category == 2 && t.DeleteMark == false && t.EnabledMark == true);
if (!string.IsNullOrEmpty(keyValue))
{
expression = expression.And(t => t.RoleId != keyValue);
}
bool hasExist = o.BllSession.PostBll.IQueryable(expression).Any();
return(hasExist);
}
/// <summary>
/// 中文名称不能重复
/// </summary>
/// <param name="shortName">中文名称</param>
/// <param name="keyValue">主键</param>
/// <returns></returns>
public bool ExistShortName(string shortName, string keyValue)
{
var expression = LambdaExtension.True <DepartmentEntity>();
expression = expression.And(t => t.ShortName == shortName);
if (!string.IsNullOrEmpty(keyValue))
{
expression = expression.And(t => t.DepartmentId != keyValue);
}
bool hasExist = o.BllSession.DepartmentBll.IQueryable(expression).Any();
return(hasExist);
}
/// <summary>
/// 外文名称不能重复
/// </summary>
/// <param name="enCode">外文名称</param>
/// <param name="keyValue">主键</param>
/// <returns></returns>
public bool ExistEnCode(string enCode, string keyValue)
{
var expression = LambdaExtension.True <OrganizeEntity>();
expression = expression.And(t => t.EnCode == enCode);
if (!string.IsNullOrEmpty(keyValue))
{
expression = expression.And(t => t.OrganizeId != keyValue);
}
bool hasExist = o.BllSession.OrganizeBll.IQueryable(expression).Any();
return(hasExist);
}
/// <summary>
/// 账户不能重复
/// </summary>
/// <param name="account">账户值</param>
/// <param name="keyValue">主键</param>
/// <returns></returns>
public bool ExistAccount(string account, string keyValue)
{
var expression = LambdaExtension.True <UserEntity>();
expression = expression.And(t => t.Account == account).And(t => t.DeleteMark == false && t.EnabledMark == true);
if (!string.IsNullOrEmpty(keyValue))
{
expression = expression.And(t => t.UserId != keyValue);
}
bool hasExist = o.BllSession.UserBll.IQueryable(expression).Any();
return(hasExist);
}
/// <summary>
/// 判断模块是否已经有系统表单
/// </summary>
/// <param name="keyValue"></param>
/// <param name="moduleId"></param>
/// <returns></returns>
public bool IsExistModuleId(string keyValue,string moduleId)
{
var expression = LambdaExtension.True<ModuleFormEntity>();
if(string.IsNullOrEmpty(keyValue))
{
expression = expression.And(t => t.ModuleId == moduleId);
}
else
{
expression = expression.And(t => t.ModuleId == moduleId && t.Id != keyValue);
}
ModuleFormEntity entity = this.BaseRepository().FindEntity<ModuleFormEntity>(expression);
return entity != null;
}
/// <summary>
/// 分类名称不能重复
/// </summary>
/// <param name="itemName">名称</param>
/// <param name="keyValue">主键</param>
/// <returns></returns>
public bool ExistItemName(string itemName, string keyValue)
{
var expression = LambdaExtension.True <DataItemEntity>();
expression = expression.And(t => t.ItemName == itemName);
if (!string.IsNullOrEmpty(keyValue))
{
expression = expression.And(t => t.Id != keyValue);
}
bool isExit = this.BaseRepository().FindList <DataItemEntity>(expression).Any();
return(isExit);
}
/// <summary>
/// 项目值不能重复
/// </summary>
/// <param name="itemValue">项目值</param>
/// <param name="keyValue">主键</param>
/// <param name="itemId">分类Id</param>
/// <returns></returns>
public bool ExistItemValue(string itemValue, string keyValue, string itemId)
{
var expression = LambdaExtension.True <DataItemDetailEntity>();
expression = expression.And(t => t.ItemValue == itemValue).And(t => t.ItemId == itemId);
if (!string.IsNullOrEmpty(keyValue))
{
expression = expression.And(t => t.ItemDetailId != keyValue);
}
bool hasExit = o.BllSession.DataItemDetailBll.IQueryable(expression).Any();
return(hasExit);
}
/// <summary>
/// 分类名称不能重复
/// </summary>
/// <param name="itemName">名称</param>
/// <param name="keyValue">主键</param>
/// <returns></returns>
public bool ExistItemName(string itemName, string keyValue)
{
var expression = LambdaExtension.True <DataItemEntity>();
expression = expression.And(t => t.ItemName == itemName);
if (!string.IsNullOrEmpty(keyValue))
{
expression = expression.And(t => t.ItemId != keyValue);
}
bool isExit = o.BllSession.DataItemBll.IQueryable(expression).Any();
return(isExit);
}
/// <summary>
/// 区域列表
/// </summary>
/// <param name="parentId">节点Id</param>
/// <param name="keyword">关键字查询</param>
/// <returns></returns>
public IEnumerable <AreaEntity> GetList(string parentId, string keyword)
{
var expression = LambdaExtension.True <AreaEntity>();
if (!string.IsNullOrEmpty(parentId))
{
expression = expression.And(t => t.ParentId == parentId);
}
if (!string.IsNullOrEmpty(keyword))
{
expression = expression.And(t => t.AreaCode.Contains(keyword));
expression = expression.Or(t => t.AreaName.Contains(keyword));
}
return(this.BaseRepository().FindList(expression).OrderBy(t => t.CreateDate).ToList());
}
/// <summary>
/// 根据分类编号获取实体对象
/// </summary>
/// <param name="itemCode">编号</param>
/// <returns></returns>
public DataItemEntity GetEntityByCode(string itemCode)
{
var expression = LambdaExtension.True <DataItemEntity>();
if (!string.IsNullOrEmpty(itemCode))
{
expression = expression.And(t => t.ItemCode == itemCode);
}
expression = expression.And(d => d.DeleteMark == false && d.EnabledMark == true);
DataItemEntity res = o.BllSession.DataItemBll.FindEntity(expression);
return(res);
}
/// <summary>
/// 日志列表
/// </summary>
/// <param name="pagination">分页</param>
/// <param name="queryJson">查询参数</param>
/// <returns></returns>
public IEnumerable <LogEntity> GetPageList(PaginationEntity pagination, string queryJson)
{
var expression = LambdaExtension.True <LogEntity>();
JObject queryParam = queryJson.TryToJObject();
if (queryParam != null)
{
//日志分类
if (!queryParam["Category"].IsEmpty())
{
int categoryId = queryParam["CategoryId"].ToInt();
expression = expression.And(t => t.CategoryId == categoryId);
}
//操作时间
if (!queryParam["StartTime"].IsEmpty() && !queryParam["EndTime"].IsEmpty())
{
DateTime startTime = queryParam["StartTime"].TryToDateTime();
DateTime endTime = queryParam["EndTime"].TryToDateTime().AddDays(1);
expression = expression.And(t => t.OperateTime >= startTime && t.OperateTime <= endTime);
}
//操作用户Id
if (!queryParam["OperateUserId"].IsEmpty())
{
string OperateUserId = queryParam["OperateUserId"].ToString();
expression = expression.And(t => t.OperateUserId == OperateUserId);
}
//操作用户账户
if (!queryParam["OperateAccount"].IsEmpty())
{
string OperateAccount = queryParam["OperateAccount"].ToString();
expression = expression.And(t => t.OperateAccount.Contains(OperateAccount));
}
//操作类型
if (!queryParam["OperateType"].IsEmpty())
{
string operateType = queryParam["OperateType"].ToString();
expression = expression.And(t => t.OperateType == operateType);
}
//功能模块
if (!queryParam["Module"].IsEmpty())
{
string module = queryParam["Module"].ToString();
expression = expression.And(t => t.Module.Contains(module));
}
}
return(this.BaseRepository().FindList <LogEntity>(expression, pagination));
}
/// <summary>
/// 用户列表
/// </summary>
/// <param name="pagination">分页</param>
/// <param name="queryJson">查询参数</param>
/// <returns></returns>
public IEnumerable <UserEntity> GetPageList(PaginationEntity pagination, string queryJson)
{
var expression = LambdaExtension.True <UserEntity>();
JObject queryParam = queryJson.TryToJObject();
if (queryParam != null)
{
//公司主键
if (!queryParam["organizeId"].IsEmpty())
{
string organizeId = queryParam["organizeId"].ToString();
expression = expression.And(t => t.OrganizeId == organizeId);
}
//部门主键
if (!queryParam["departmentId"].IsEmpty())
{
string departmentId = queryParam["departmentId"].ToString();
expression = expression.And(t => t.DepartmentId == departmentId);
}
//查询条件
if (!queryParam["condition"].IsEmpty() && !queryParam["keyword"].IsEmpty())
{
string condition = queryParam["condition"].ToString();
string keyord = queryParam["keyword"].ToString();
switch (condition)
{
case "Account": //账户
expression = expression.And(t => t.Account.Contains(keyord));
break;
case "RealName": //姓名
expression = expression.And(t => t.RealName.Contains(keyord));
break;
case "Mobile": //手机
expression = expression.And(t => t.Mobile.Contains(keyord));
break;
}
}
}
expression = expression.And(u => u.DeleteMark == false);
IEnumerable <UserEntity> res = this.BaseRepository().FindList <UserEntity>(expression, pagination);
return(res);
}
