public override OperationResult Create(FacilityInfo info)
{
OperationResult result = new OperationResult(OperationResultType.Error, "操作失败,请稍后重试!");
using (var DbContext = new UCDbContext())
{
Facility entity = new Facility();
DESwap.FacilityDTE(info, entity);
FacilityRpt.Insert(DbContext, entity);
/*关联功能是否为空*/
if (info.FacilityFunctionInfoList != null)
{
/*****新增列表*********/
List<FacilityFunction> insertlist = new List<FacilityFunction>();
/*****删除列表*********/
List<FacilityFunction> deletelist = new List<FacilityFunction>();
/*原有列表*/
var existlist = (from i in DbContext.FacilityFunction
where i.FacilityId.Equals(info.Id)
select i).ToList();
/*************如果为选中且没有关联表id则为新增******************/
foreach (var ffinfo in info.FacilityFunctionInfoList)
{
if (string.IsNullOrEmpty(ffinfo.Id) && ffinfo.Selected)
{
/*************如果为选中且没有关联表id则为新增******************/
ffinfo.Id = System.Guid.NewGuid().ToString();
ffinfo.FacilityId = info.Id;
FacilityFunction facilityFunction = new FacilityFunction();
DESwap.FacilityFunctionDTE(ffinfo, facilityFunction);
insertlist.Add(facilityFunction);
}
else if (!string.IsNullOrEmpty(ffinfo.Id) && ffinfo.Selected == false)
{
/*************如果为未选中且有关联表id则为删除******************/
var facilityFunction = existlist.Where(x => x.Id.Equals(ffinfo.Id)).FirstOrDefault();
if (facilityFunction == null)
{
deletelist.Add(facilityFunction);
}
}
}
FacilityFunctionRpt.Insert(DbContext, insertlist);
FacilityFunctionRpt.Delete(DbContext, deletelist);
}
DbContext.SaveChanges();
result.ResultType = OperationResultType.Success;
result.Message = "操作成功!";
return result;
}
}
public override OperationResult Create(StationInfo info)
{
OperationResult result = new OperationResult(OperationResultType.Error, "操作失败,请稍后重试!");
using (var DbContext = new UCDbContext())
{
Station entity = new Station();
DESwap.StationDTE(info, entity);
StationRpt.Insert(DbContext, entity);
/*关联角色是否为空*/
if (info.StationRoleInfoList != null)
{
/*****新增列表*********/
List<StationRole> insertlist = new List<StationRole>();
/*****删除列表*********/
List<StationRole> deletelist = new List<StationRole>();
/*原有列表*/
var existlist = (from i in DbContext.StationRole
where i.StationId.Equals(info.Id)
select i).ToList();
/*************如果为选中且没有关联表id则为新增******************/
foreach (var rfinfo in info.StationRoleInfoList)
{
if (string.IsNullOrEmpty(rfinfo.Id) && rfinfo.Selected)
{
/*************如果为选中且没有关联表id则为新增******************/
rfinfo.Id = System.Guid.NewGuid().ToString();
rfinfo.StationId = info.Id;
StationRole StationRole = new StationRole();
DESwap.StationRoleDTE(rfinfo, StationRole);
insertlist.Add(StationRole);
}
else if (!string.IsNullOrEmpty(rfinfo.Id) && rfinfo.Selected == false)
{
/*************如果为未选中且有关联表id则为删除******************/
var StationRole = existlist.Where(x => x.Id.Equals(rfinfo.Id)).FirstOrDefault();
if (StationRole == null)
{
deletelist.Add(StationRole);
}
}
}
StationRoleRpt.Insert(DbContext, insertlist);
StationRoleRpt.Delete(DbContext, deletelist);
}
DbContext.SaveChanges();
result.ResultType = OperationResultType.Success;
result.Message = "操作成功!";
return result;
}
}
public virtual OperationResult Create(StationInfo info)
{
OperationResult result = new OperationResult(OperationResultType.Error, "操作失败,请稍后重试!");
using (var DbContext = new UCDbContext())
{
Station entity = new Station();
DESwap.StationDTE(info, entity);
StationRpt.Insert(DbContext, entity);
DbContext.SaveChanges();
}
result.ResultType = OperationResultType.Success;
result.Message = "操作成功!";
return result;
}
public virtual OperationResult Create(CompanyClientTypeInfo info)
{
OperationResult result = new OperationResult(OperationResultType.Error, "操作失败,请稍后重试!");
using (var DbContext = new UCDbContext())
{
CompanyClientType entity = new CompanyClientType();
DESwap.CompanyClientTypeDTE(info, entity);
CompanyClientTypeRpt.Insert(DbContext, entity);
DbContext.SaveChanges();
}
result.ResultType = OperationResultType.Success;
result.Message = "操作成功!";
return result;
}
public virtual OperationResult Create(IEnumerable<StationInfo> infoList)
{
OperationResult result = new OperationResult(OperationResultType.Error, "操作失败,请稍后重试!");
List<Station> eList = new List<Station>();
infoList.ForEach(x =>
{
Station entity = new Station();
DESwap. StationDTE(x, entity);
eList.Add(entity);
});
using (var DbContext = new UCDbContext())
{
StationRpt.Insert(DbContext, eList);
DbContext.SaveChanges();
}
result.ResultType = OperationResultType.Success;
result.Message = "操作成功!";
return result;
}
public PageResult<AppInfo> ListByCondition(NameValueCollection searchCondtionCollection, NameValueCollection sortCollection, int pageNumber, int pageSize)
{
PageResult<AppInfo> result = new PageResult<AppInfo>();
int skip = (pageNumber - 1) * pageSize;
int take = pageSize;
List<AppInfo> list = null;
using (var DbContext = new UCDbContext())
{
var query = from i in DbContext.App
select new AppInfo()
{
Id = i.Id,
AppCode = i.AppCode,
AppName = i.AppName,
PublicKey = i.PublicKey,
PrivateKey = i.PrivateKey,
SYS_IsValid = i.SYS_IsValid,
SYS_OrderSeq = i.SYS_OrderSeq,
SYS_AppId = i.SYS_AppId,
SYS_StaffId = i.SYS_StaffId,
SYS_StationId = i.SYS_StationId,
SYS_DepartmentId = i.SYS_DepartmentId,
SYS_CompanyId = i.SYS_CompanyId,
SYS_CreateTime = i.SYS_CreateTime
};
#region 条件
foreach (string key in searchCondtionCollection)
{
string condition = searchCondtionCollection[key];
switch (key.ToLower())
{
case "appname":
query = query.Where(x => x.AppName.Contains(condition));
break;
case "appcode":
query = query.Where(x => x.AppCode.Contains(condition));
break;
case "isvalid":
int value = Convert.ToInt32(condition);
query = query.Where(x => x.SYS_IsValid.Equals(value));
break;
default:
break;
}
}
#endregion
result.TotalRecords = query.Count();
#region 排序
foreach (string sort in sortCollection)
{
string direct = sortCollection[sort];
switch (sort.ToLower())
{
case "createtime":
if (direct.ToLower().Equals("asc"))
{
query = query.OrderBy(x => new { x.SYS_CreateTime }).Skip(skip).Take(take);
}
else
{
query = query.OrderByDescending(x => new { x.SYS_CreateTime }).Skip(skip).Take(take);
}
break;
case "appname":
if (direct.ToLower().Equals("asc"))
{
query = query.OrderBy(x => x.AppName).Skip(skip).Take(take);
}
else
{
query = query.OrderByDescending(x => x.AppName).Skip(skip).Take(take);
}
break;
default:
query = query.OrderByDescending(x => new { x.SYS_OrderSeq }).Skip(skip).Take(take);
break;
}
}
#endregion
list = query.ToList();
}
result.PageSize = pageSize;
result.PageNumber = pageNumber;
result.Data = list;
return result; ;
}
public PageResult<StaffInfo> ListByCondition(NameValueCollection searchCondtionCollection, NameValueCollection sortCollection, int pageNumber, int pageSize)
{
PageResult<StaffInfo> result = new PageResult<StaffInfo>();
int skip = (pageNumber - 1) * pageSize;
int take = pageSize;
List<StaffInfo> list = null;
using (var DbContext = new UCDbContext())
{
var query = from i in DbContext.Staff
join d in DbContext.Department on i.DepartmentId equals d.Id
join c in DbContext.Company on d.CompanyId equals c.Id
select new StaffInfo()
{
Id = i.Id,
UserCode = i.UserCode,
UserName = i.UserName,
Sex = i.Sex,
Mobile = i.Mobile,
DepartmentId = i.DepartmentId,
DepartmentName = d.DepartmentName,
CompanyId = d.CompanyId,
CompanyName = c.CompanyName,
SYS_IsValid = i.SYS_IsValid,
SYS_OrderSeq = i.SYS_OrderSeq,
SYS_AppId = i.SYS_AppId,
SYS_StaffId = i.SYS_StaffId,
SYS_StationId = i.SYS_StationId,
SYS_DepartmentId = i.SYS_DepartmentId,
SYS_CompanyId = i.SYS_CompanyId,
SYS_CreateTime = i.SYS_CreateTime
};
#region 条件
foreach (string key in searchCondtionCollection)
{
string condition = searchCondtionCollection[key];
switch (key.ToLower())
{
case "username":
query = query.Where(x => x.UserName.Contains(condition));
break;
case "departmentid":
query = query.Where(x => x.DepartmentId.Equals(condition));
break;
case "companyid":
query = query.Where(x => x.CompanyId.Equals(condition));
break;
case "isvalid":
int value = Convert.ToInt32(condition);
query = query.Where(x => x.SYS_IsValid.Equals(value));
break;
default:
break;
}
}
#endregion
result.TotalRecords = query.Count();
#region 排序
foreach (string sort in sortCollection)
{
string direct = sortCollection[sort];
switch (sort.ToLower())
{
case "createtime":
if (direct.ToLower().Equals("asc"))
{
query = query.OrderBy(x => new { x.SYS_CreateTime }).Skip(skip).Take(take);
}
else
{
query = query.OrderByDescending(x => new { x.SYS_CreateTime }).Skip(skip).Take(take);
}
break;
case "username":
if (direct.ToLower().Equals("asc"))
{
query = query.OrderBy(x => x.CompanyName).Skip(skip).Take(take);
}
else
{
query = query.OrderByDescending(x => x.CompanyName).Skip(skip).Take(take);
}
break;
default:
query = query.OrderByDescending(x => new { x.SYS_OrderSeq }).Skip(skip).Take(take);
break;
}
}
#endregion
list = query.ToList();
}
result.PageSize = pageSize;
result.PageNumber = pageNumber;
result.Data = list;
return result;
}
/// <summary>
/// 用户登陆
/// </summary>
/// <param name="usercode">账号</param>
/// <param name="password">密码</param>
/// <returns></returns>
public OperationResult Login(string usercode, string password)
{
OperationResult result = new OperationResult(OperationResultType.Error, "操作失败,请稍后重试!");
using (var DbContext = new UCDbContext())
{
var infolist = (from i in DbContext.Staff
where i.UserCode.Equals(usercode)
select i).ToList();
if (infolist != null && infolist.Count > 0)
{
StaffInfo info = new StaffInfo();
DESwap.StaffETD(infolist[0], info);
/*加载用户对应的功能*/
if (info.Password == password)
{
var rolefacilitylist = (from ss in DbContext.StaffStation
join sr in DbContext.StationRole on ss.StationId equals sr.StationId
join rf in DbContext.RoleFacility on sr.RoleId equals rf.RoleId
select rf).Distinct().ToList();
List<RoleFacilityInfo> ilist = new List<RoleFacilityInfo>();
rolefacilitylist.ForEach(x =>
{
RoleFacilityInfo rfInfo = new RoleFacilityInfo();
DESwap.RoleFacilityETD(x, rfInfo);
ilist.Add(rfInfo);
});
result.ResultType = OperationResultType.Success;
result.Message = "登陆成功!";
result.AppendData = ilist;
}
else
{
result.ResultType = OperationResultType.Warning;
result.Message = "用户账号或密码不正确!";
}
}
else
{
result.ResultType = OperationResultType.Warning;
result.Message = "用户账号或密码不正确!";
}
}
return result;
}
/// <summary>
/// 重载读取岗位内容，加载关联的功能列表
/// </summary>
/// <param name="key"></param>
/// <returns></returns>
public override StaffInfo Load(string key)
{
StaffInfo info = new StaffInfo();
using (var DbContext = new UCDbContext())
{
Staff entity = StaffRpt.Get(DbContext, key);
if (info != null)
{
DESwap.StaffETD(entity, info);
/*******查询关联权限*******/
var fflist = (from i in DbContext.StaffStation
where i.StaffId.Equals(info.Id)
select i).ToList();
info.StaffStationInfoList = new List<StaffStationInfo>();
fflist.ForEach(x =>
{
StaffStationInfo rfinfo = new StaffStationInfo();
DESwap.StaffStationETD(x, rfinfo);
info.StaffStationInfoList.Add(rfinfo);
});
}
}
return info;
}
public virtual OperationResult Modify(CompanyStaffInfo info)
{
OperationResult result = new OperationResult(OperationResultType.Error, "操作失败,请稍后重试!");
using (var DbContext = new UCDbContext())
{
CompanyStaff entity = CompanyStaffRpt.Get(DbContext, info.Id);
DESwap.CompanyStaffDTE(info, entity);
CompanyStaffRpt.Update(DbContext, entity);
DbContext.SaveChanges();
}
result.ResultType = OperationResultType.Success;
result.Message = "操作成功!";
return result;
}
public virtual FacilityFunctionInfo Load(string key)
{
FacilityFunctionInfo info = new FacilityFunctionInfo();
using (var DbContext = new UCDbContext())
{
FacilityFunction entity = FacilityFunctionRpt.Get(DbContext, key);
DESwap.FacilityFunctionETD(entity,info);
}
return info;
}
public virtual OperationResult Remove(IEnumerable<string> keyList)
{
OperationResult result = new OperationResult(OperationResultType.Error, "操作失败,请稍后重试!");
List<Station> eList = new List<Station>();
using (var DbContext = new UCDbContext())
{
keyList.ForEach(x =>
{
Station entity = StationRpt.Get(DbContext, x);
eList.Add(entity);
});
StationRpt.Delete(DbContext, eList);
DbContext.SaveChanges();
}
result.ResultType = OperationResultType.Success;
result.Message = "操作成功!";
return result;
}
public virtual CompanyClientTypeInfo Load(string key)
{
CompanyClientTypeInfo info = new CompanyClientTypeInfo();
using (var DbContext = new UCDbContext())
{
CompanyClientType entity = CompanyClientTypeRpt.Get(DbContext, key);
DESwap.CompanyClientTypeETD(entity,info);
}
return info;
}
public virtual OperationResult Modify(IEnumerable<RoleFacilityInfo> infoList)
{
OperationResult result = new OperationResult(OperationResultType.Error, "操作失败,请稍后重试!");
List<RoleFacility> eList = new List<RoleFacility>();
infoList.ForEach(x =>
{
RoleFacility entity = new RoleFacility();
DESwap. RoleFacilityDTE(x, entity);
eList.Add(entity);
});
using (var DbContext = new UCDbContext())
{
RoleFacilityRpt.Update(DbContext, eList);
DbContext.SaveChanges();
}
result.ResultType = OperationResultType.Success;
result.Message = "操作成功!";
return result;
}
public PageResult<RoleFacilityInfo> ListByCondition(NameValueCollection searchCondtionCollection, NameValueCollection sortCollection, int pageNumber, int pageSize)
{
PageResult<RoleFacilityInfo> result = new PageResult<RoleFacilityInfo>();
int skip = (pageNumber - 1) * pageSize;
int take = pageSize;
List<RoleFacility> list = null;
using (var DbContext = new UCDbContext())
{
var query = from i in DbContext.RoleFacility
select i;
#region 条件
foreach (string key in searchCondtionCollection)
{
string condition = searchCondtionCollection[key];
switch (key.ToLower())
{
case "isvalid":
int value = Convert.ToInt32(condition);
query = query.Where(x => x.SYS_IsValid.Equals(value));
break;
default:
break;
}
}
#endregion
result.TotalRecords = query.Count();
#region 排序
foreach (string sort in sortCollection)
{
string direct = string.Empty;
switch (sort.ToLower())
{
case "createtime":
if (direct.ToLower().Equals("asc"))
{
query = query.OrderBy(x => new { x.SYS_CreateTime }).Skip(skip).Take(take);
}
else
{
query = query.OrderByDescending(x => new { x.SYS_CreateTime }).Skip(skip).Take(take);
}
break;
default:
query = query.OrderByDescending(x => new { x.SYS_OrderSeq }).Skip(skip).Take(take);
break;
}
}
list = query.ToList();
}
#endregion
#region linq to entity
List<RoleFacilityInfo> ilist = new List<RoleFacilityInfo>();
list.ForEach(x =>
{
RoleFacilityInfo info = new RoleFacilityInfo();
DESwap.RoleFacilityETD(x, info);
ilist.Add(info);
});
#endregion
result.PageSize = pageSize;
result.PageNumber = pageNumber;
result.Data = ilist;
return result;;
}
public virtual OperationResult Modify(RoleFacilityInfo info)
{
OperationResult result = new OperationResult(OperationResultType.Error, "操作失败,请稍后重试!");
using (var DbContext = new UCDbContext())
{
RoleFacility entity = RoleFacilityRpt.Get(DbContext, info.Id);
DESwap.RoleFacilityDTE(info, entity);
RoleFacilityRpt.Update(DbContext, entity);
DbContext.SaveChanges();
}
result.ResultType = OperationResultType.Success;
result.Message = "操作成功!";
return result;
}
public virtual RoleFacilityInfo Load(string key)
{
RoleFacilityInfo info = new RoleFacilityInfo();
using (var DbContext = new UCDbContext())
{
RoleFacility entity = RoleFacilityRpt.Get(DbContext, key);
DESwap.RoleFacilityETD(entity,info);
}
return info;
}
public PageResult<ClientTypeInfo> ListByCondition(NameValueCollection searchCondtionCollection, NameValueCollection sortCollection, int pageNumber, int pageSize)
{
PageResult<ClientTypeInfo> result = new PageResult<ClientTypeInfo>();
int skip = (pageNumber - 1) * pageSize;
int take = pageSize;
List<ClientTypeInfo> list = null;
using (var DbContext = new UCDbContext())
{
var query = from i in DbContext.ClientType
join p in DbContext.ClientType on i.ParentId equals p.Id into parent
from tp in parent.DefaultIfEmpty()
select new ClientTypeInfo()
{
Id = i.Id,
ClientTypeCode = i.ClientTypeCode,
ClientTypeName = i.ClientTypeName,
ParentId = i.ParentId,
TreeNode = i.TreeNode,
SYS_IsValid = i.SYS_IsValid,
SYS_OrderSeq = i.SYS_OrderSeq,
SYS_AppId = i.SYS_AppId,
SYS_StaffId = i.SYS_StaffId,
SYS_StationId = i.SYS_StationId,
SYS_DepartmentId = i.SYS_DepartmentId,
SYS_CompanyId = i.SYS_CompanyId,
SYS_CreateTime = i.SYS_CreateTime,
ParentName = tp.ClientTypeName == null ? "" : tp.ClientTypeName
};
#region 条件
foreach (string key in searchCondtionCollection)
{
string condition = searchCondtionCollection[key];
switch (key.ToLower())
{
case "clienttypename":
query = query.Where(x => x.ClientTypeName.Contains(condition));
break;
case "clienttypecode":
query = query.Where(x => x.ClientTypeCode.Contains(condition));
break;
case "parentid":
query = query.Where(x => x.ParentId.Equals(condition));
break;
case "isvalid":
int value = Convert.ToInt32(condition);
query = query.Where(x => x.SYS_IsValid.Equals(value));
break;
default:
break;
}
}
#endregion
result.TotalRecords = query.Count();
#region 排序
foreach (string sort in sortCollection)
{
string direct = sortCollection[sort];
switch (sort.ToLower())
{
case "createtime":
if (direct.ToLower().Equals("asc"))
{
query = query.OrderBy(x => new { x.SYS_CreateTime }).Skip(skip).Take(take);
}
else
{
query = query.OrderByDescending(x => new { x.SYS_CreateTime }).Skip(skip).Take(take);
}
break;
case "clienttypename":
if (direct.ToLower().Equals("asc"))
{
query = query.OrderBy(x => x.ClientTypeName).Skip(skip).Take(take);
}
else
{
query = query.OrderByDescending(x => x.ClientTypeName).Skip(skip).Take(take);
}
break;
default:
query = query.OrderByDescending(x => new { x.SYS_OrderSeq }).Skip(skip).Take(take);
break;
}
}
#endregion
list = query.ToList();
}
result.PageSize = pageSize;
result.PageNumber = pageNumber;
result.Data = list;
return result;
}
public virtual StationInfo Load(string key)
{
StationInfo info = new StationInfo();
using (var DbContext = new UCDbContext())
{
Station entity = StationRpt.Get(DbContext, key);
DESwap.StationETD(entity,info);
}
return info;
}
/// <summary>
/// 重载修改权限信息内容，编辑关承功能列表
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public override OperationResult Modify(RoleInfo info)
{
OperationResult result = new OperationResult(OperationResultType.Error, "操作失败,请稍后重试!");
using (var DbContext = new UCDbContext())
{
Role entity = RoleRpt.Get(DbContext, info.Id);
DESwap.RoleDTE(info, entity);
RoleRpt.Update(DbContext, entity);
/*关联权限是否为空*/
if (info.RoleFacilityInfoList != null)
{
/*****新增列表*********/
List<RoleFacility> insertlist = new List<RoleFacility>();
/*****删除列表*********/
List<RoleFacility> deletelist = new List<RoleFacility>();
/*原有列表*/
var existlist = (from i in DbContext.RoleFacility
where i.RoleId.Equals(info.Id)
select i).ToList();
/*************如果为选中且没有关联表id则为新增******************/
foreach (var rfinfo in info.RoleFacilityInfoList)
{
if (string.IsNullOrEmpty(rfinfo.Id) && rfinfo.Selected)
{
/*************如果为选中且没有关联表id则为新增******************/
rfinfo.Id = System.Guid.NewGuid().ToString();
rfinfo.RoleId = info.Id;
RoleFacility roleFacility = new RoleFacility();
DESwap.RoleFacilityDTE(rfinfo, roleFacility);
insertlist.Add(roleFacility);
}
else if (!string.IsNullOrEmpty(rfinfo.Id) && rfinfo.Selected == false)
{
/*************如果为未选中且有关联表id则为删除******************/
var facilityFunction = existlist.Where(x => x.Id.Equals(rfinfo.Id)).FirstOrDefault();
if (facilityFunction != null)
{
deletelist.Add(facilityFunction);
}
}
}
RoleFacilityRpt.Insert(DbContext, insertlist);
RoleFacilityRpt.Delete(DbContext, deletelist);
}
DbContext.SaveChanges();
result.ResultType = OperationResultType.Success;
result.Message = "操作成功!";
return result;
}
}
public virtual OperationResult Remove(string key)
{
OperationResult result = new OperationResult(OperationResultType.Error, "操作失败,请稍后重试!");
using (var DbContext = new UCDbContext())
{
Station entity = StationRpt.Get(DbContext, key);
StationRpt.Delete(DbContext, entity);
DbContext.SaveChanges();
}
result.ResultType = OperationResultType.Success;
result.Message = "操作成功!";
return result;
}
/// <summary>
/// 重载读取权限信息内容，加载关联的功能列表
/// </summary>
/// <param name="key"></param>
/// <returns></returns>
public override FacilityInfo Load(string key)
{
FacilityInfo info = new FacilityInfo();
using (var DbContext = new UCDbContext())
{
Facility entity = FacilityRpt.Get(DbContext, key);
if (info != null)
{
DESwap.FacilityETD(entity, info);
/*******查询关联权限*******/
var fflist = (from i in DbContext.FacilityFunction
where i.FacilityId.Equals(info.Id)
select i).ToList();
info.FacilityFunctionInfoList = new List<FacilityFunctionInfo>();
fflist.ForEach(x =>
{
FacilityFunctionInfo ffinfo = new FacilityFunctionInfo();
DESwap.FacilityFunctionETD(x, ffinfo);
info.FacilityFunctionInfoList.Add(ffinfo);
});
}
}
return info;
}
public virtual OperationResult Modify(IEnumerable<CompanyClientTypeInfo> infoList)
{
OperationResult result = new OperationResult(OperationResultType.Error, "操作失败,请稍后重试!");
List<CompanyClientType> eList = new List<CompanyClientType>();
infoList.ForEach(x =>
{
CompanyClientType entity = new CompanyClientType();
DESwap. CompanyClientTypeDTE(x, entity);
eList.Add(entity);
});
using (var DbContext = new UCDbContext())
{
CompanyClientTypeRpt.Update(DbContext, eList);
DbContext.SaveChanges();
}
result.ResultType = OperationResultType.Success;
result.Message = "操作成功!";
return result;
}
public virtual DepartmentInfo Load(string key)
{
DepartmentInfo info = new DepartmentInfo();
using (var DbContext = new UCDbContext())
{
Department entity = DepartmentRpt.Get(DbContext, key);
DESwap.DepartmentETD(entity,info);
}
return info;
}
public virtual List<StationInfo> ListAllByCondition(NameValueCollection searchCondtionCollection, NameValueCollection sortCollection)
{
List<Station> list = null;
using (var DbContext = new UCDbContext())
{
var query = from i in DbContext.Station
select i;
#region 条件
foreach (string key in searchCondtionCollection)
{
string condition = searchCondtionCollection[key];
switch (key.ToLower())
{
case "isvalid":
int value = Convert.ToInt32(condition);
query = query.Where(x => x.SYS_IsValid.Equals(value));
break;
default:
break;
}
}
#endregion
#region 排序
foreach (string sort in sortCollection)
{
string direct = string.Empty;
switch (sort.ToLower())
{
case "createtime":
if (direct.ToLower().Equals("asc"))
{
query = query.OrderBy(x => new { x.SYS_CreateTime });
}
else
{
query = query.OrderByDescending(x => new { x.SYS_CreateTime });
}
break;
default:
query = query.OrderByDescending(x => new { x.SYS_OrderSeq });
break;
}
}
list = query.ToList();
}
#endregion
#region linq to entity
List<StationInfo> ilist = new List<StationInfo>();
list.ForEach(x =>
{
StationInfo info = new StationInfo();
DESwap.StationETD(x, info);
ilist.Add(info);
});
#endregion
return ilist;;
}
/// <summary>
/// 重载读取权限信息内容，加载关联的功能列表
/// </summary>
/// <param name="key"></param>
/// <returns></returns>
public override RoleInfo Load(string key)
{
RoleInfo info = new RoleInfo();
using (var DbContext = new UCDbContext())
{
Role entity = RoleRpt.Get(DbContext, key);
if (info != null)
{
DESwap.RoleETD(entity, info);
/*******查询关联权限*******/
var fflist = (from i in DbContext.RoleFacility
where i.RoleId.Equals(info.Id)
select i).ToList();
info.RoleFacilityInfoList = new List<RoleFacilityInfo>();
fflist.ForEach(x =>
{
RoleFacilityInfo rfinfo = new RoleFacilityInfo();
DESwap.RoleFacilityETD(x, rfinfo);
info.RoleFacilityInfoList.Add(rfinfo);
});
}
}
return info;
}
