//查询列表
public IQueryable <BaseCase> GetAllAuthorizeAndSelfQuery(Infrastructure.Identity.Model.User user, int?version, string borrownname, string caseNum)
{
var pers = GetDataPermission(user);
var predicate = PredicateBuilder.True <BaseCase>();
predicate = predicate.And(testc => pers.Contains(testc.DistrictID));
predicate = predicate.And(testc => pers.Contains(testc.SalesGroupID));
predicate = predicate.And(t => t.Version > 0);
predicate = predicate.Or(t => t.CreateUser == user.UserName);
var ulist = base.GetAll(predicate);
if (version != null)
{
ulist = ulist.Where(t => t.Version == version);
}
if (!string.IsNullOrEmpty(borrownname) && !string.IsNullOrWhiteSpace(borrownname))
{
ulist = ulist.Where(t => t.BorrowerName.Contains(borrownname));
}
if (!string.IsNullOrEmpty(caseNum) && !string.IsNullOrWhiteSpace(caseNum))
{
ulist = ulist.Where(t => t.NewCaseNum.Contains(caseNum));
}
ulist = ulist.OrderByDescending(t => t.CaseNum);
return(ulist);
}
/// <summary>
/// 获取限制数据权限后的最新版本案件
/// 数据权限限制为分公司或者创建者
/// yanminchun 2016-10-12 增加数据权限限制
/// </summary>
/// <param name="key"></param>
/// <param name="user"></param>
/// <returns></returns>
public BaseAudit GetAuthorizeAndSelf(object key, Infrastructure.Identity.Model.User user)
{
var entity = base.Get(key);
if (entity == null)
{
return(null);
}
var maxentity = GetAll().Where(t => t.NewCaseNum == entity.NewCaseNum).OrderByDescending(t => t.Version).FirstOrDefault();
if (entity.Version < 0 || entity.Version != maxentity.Version)
{
return(null);
}
var pers = GetDataPermission(user);
if (((pers.Contains(entity.DistrictID) && pers.Contains(entity.SalesGroupID)) || entity.CreateUser == user.UserName))
{
return(entity);
}
else
{
return(null);
}
}
public IEnumerable <BaseAuditDTO> GetAll(Infrastructure.Identity.Model.User user)
{
var pers = GetDataPermission(user.Id);
BaseAuditDTODAL bad = new BaseAuditDTODAL();
var basrauditlist = bad.GetAllBySql("SELECT * FROM baseauditview");
var ulist = basrauditlist.Where(s => pers.Contains(s.SalesGroupID));
if (pers.Contains(CaseMode.WeiXuanZe) && pers.Contains(CaseMode.ZiYouZiJin))
{
ulist = ulist.Where(t => t.CaseMode == CaseMode.ZiYouZiJin || pers.Contains(t.ThirdParty) || t.ThirdParty == null);
}
else if (pers.Contains(CaseMode.ZiYouZiJin))
{
ulist = ulist.Where(t => t.CaseMode == CaseMode.ZiYouZiJin || pers.Contains(t.ThirdParty));
}
else if (pers.Contains(CaseMode.WeiXuanZe))
{
ulist = ulist.Where(t => pers.Contains(t.ThirdParty) || (t.ThirdParty == null && t.CaseMode == null));
}
else
{
ulist = ulist.Where(t => pers.Contains(t.ThirdParty));
}
ulist = ulist.OrderByDescending(t => t.CaseNum);
return(ulist);
}
/// <summary>
/// 获取限制数据权限后的数据
/// 数据权限限制为分公司或者创建者
/// yanminchun 2016-10-12 增加数据权限限制
/// </summary>
/// <param name="user"></param>
/// <returns></returns>
public IQueryable <BaseAudit> GetAllAuthorizeAndSelf(Infrastructure.Identity.Model.User user)
{
var pers = GetDataPermission(user);
var list = base.GetAll();
list = list.Where(t => t.Version >= 0 && ((pers.Contains(t.DistrictID) && pers.Contains(t.SalesGroupID)) || t.CreateUser == user.UserName));
list = list.GroupBy(t => t.CaseNum, (x, xs) => xs.OrderByDescending(a => a.Version).FirstOrDefault());
return(list);
}
public bool RejectCase(string id, Infrastructure.Identity.Model.User user)
{
AuditHelp ah = new AuditHelp();
BaseAuditDAL bad = new BaseAuditDAL();
var baseaduit = bad.GetAuthorizeAndSelf(id, user);
if (baseaduit != null && baseaduit.CaseStatus == CaseStatus.Lending)
{
// baseaduit.CreateUser = createUser;
ah.CopyBaseAudit(baseaduit, user.UserName, CaseStatus.SpecialClose);
return(true);
}
return(false);
}
/// <summary>
/// 获取限制数据权限后的数据
/// 数据权限限制为分公司或者创建者
/// yanminchun 2016-10-12 增加数据权限限制
/// </summary>
/// <param name="user"></param>
/// <param name="key"></param>
/// <returns></returns>
public Lending GetAuthorizeAndSelf(object key, Infrastructure.Identity.Model.User user)
{
BaseAuditDAL bd = new BaseAuditDAL();
var curr = bd.GetAuthorizeAndSelf(key, user);
if (curr != null)
{
var aud = bd.GetbyCaseSataus(curr.NewCaseNum, CaseStatus.Lending);
if (aud != null)
{
return(base.Get(aud.ID));
}
}
return(null);
}
public async Task <ActionResult> Register(RegisterViewModel model)
{
UserDAL userdal = new UserDAL();
Infrastructure.Identity.Model.User user = new Infrastructure.Identity.Model.User();
user.DisplayName = model.DisplayName;
user.Password = model.Password;
user.UserName = model.LoginName;
IdentityResult result = await userdal.Create(user);
if (result.Succeeded)
{
return(Content("Success"));
}
else
{
return(Content("Failed"));
}
}
public BaseCase GetAuthorizeAndSelf(object key, Infrastructure.Identity.Model.User user)
{
var entity = base.Get(key);
if (entity == null)
{
return(null);
}
var pers = GetDataPermission(user);
if (((pers.Contains(entity.DistrictID) && pers.Contains(entity.SalesGroupID)) || entity.CreateUser == user.UserName))
{
return(entity);
}
else
{
return(null);
}
}
/// <summary>
/// 获取限制数据权限后的数据
/// 数据权限限制为分公司或者创建者
/// yanminchun 2016-10-12 增加数据权限限制
/// </summary>
/// <param name="casestatus"></param>
/// <param name="user"></param>
/// <returns></returns>
public IQueryable <BaseAudit> GetAllAuthorizeAndSelfByPublic(string casestatus, Infrastructure.Identity.Model.User user)
{
var pers = GetDataPermission(user);
var predicate = PredicateBuilder.True <BaseAudit>();
predicate = predicate.And(testc => pers.Contains(testc.DistrictID));
predicate = predicate.And(testc => pers.Contains(testc.SalesGroupID));
predicate = predicate.Or(t => t.CreateUser == user.UserName);
var list = base.GetAll(predicate).Where(t => t.Version >= 0 && t.CaseStatus == casestatus).GroupBy(t => t.CaseNum, (x, xs) => xs.OrderByDescending(a => a.Version).FirstOrDefault());
// var list = base.GetAll().Where(t => t.Version >= 0 && t.CaseStatus == casestatus);
var statuslist = this.GetAll();
var returnlist = from i in statuslist
join j in list
on i.NewCaseNum equals j.NewCaseNum
select i;
return(returnlist);
}
/// <summary>
/// 获取限制数据权限后的数据
/// 数据权限限制为分公司或者创建者
/// yanminchun 2016-10-12 增加数据权限限制
/// </summary>
/// <param name="start"></param>
/// <param name="end"></param>
/// <param name="user"></param>
/// <returns></returns>
public IQueryable <BaseAudit> GetAllAuthorizeAndSelf(DateTime?start, DateTime?end, Infrastructure.Identity.Model.User user)
{
BaseAuditDAL bd = new BaseAuditDAL();
var pers = GetDataPermission(user);
var predicate = PredicateBuilder.True <BaseAudit>();
predicate = predicate.And(testc => pers.Contains(testc.DistrictID));
predicate = predicate.And(testc => pers.Contains(testc.SalesGroupID));
predicate = predicate.Or(t => t.CreateUser == user.UserName);
var modellist = bd.GetHasStatus(CaseStatus.Lending);
modellist = modellist.Where(predicate);
if (start != null)
{
var starttime = new DateTime(start.Value.Year, start.Value.Month, start.Value.Day).AddSeconds(-1);
modellist = modellist.Where(t => t.LendingDate >= starttime);
}
if (end != null)
{
var endtime = new DateTime(end.Value.Year, end.Value.Month, end.Value.Day).AddDays(1);
modellist = modellist.Where(t => t.LendingDate < endtime);
}
return(modellist);
}
