//public IQueryable<ChannelRole> GetRoleList()
//{
// using (var db = new NationalUnionContext())
// {
// var list = db.ChannelRoles.AsQueryable();
// return list;
// }
//}
public List <ChannelRole> GetRoleList()
{
using (var db = new NationalUnionContext())
{
var list = db.ChannelRoles.ToList();
return(list);
}
}
public int AddMoudle(ChannelMoudle entity)
{
using (var db = new NationalUnionContext())
{
db.ChannelMoudles.Add(entity);
return(db.SaveChanges());
}
}
public bool MoudleExistsById(string moudleId)
{
using (var db = new NationalUnionContext())
{
var count = db.ChannelMoudles.Count(cm => cm.MoudleId == moudleId);
return(count > 0);
}
}
public int EditMoudleOperate(ChannelMoudleOperate entity)
{
using (var db = new NationalUnionContext())
{
db.ChannelMoudleOperates.Attach(entity);
db.Entry(entity).State = EntityState.Modified;
return(db.SaveChanges());
}
}
public int DeleteMoudleOperate(string moudleOperateId)
{
using (var db = new NationalUnionContext())
{
ChannelMoudleOperate entity = db.ChannelMoudleOperates.SingleOrDefault(cmo => cmo.MoudleOperateId == moudleOperateId);
if (entity != null)
{
db.ChannelMoudleOperates.Remove(entity);
}
return(db.SaveChanges());
}
}
public int DeleteRole(string roleId)
{
using (var db = new NationalUnionContext())
{
var entity = db.ChannelRoles.SingleOrDefault(r => r.RoleId == roleId);
if (entity != null)
{
db.ChannelRoles.Remove(entity);
}
return(db.SaveChanges());
}
}
public List <ChannelMoudle> GetMenuByPersonName(string personName, string moudleId)
{
using (var db = new NationalUnionContext())
{
var menus = (from menu in db.ChannelMoudles
join right in db.ChannelRights
on menu.MoudleId equals right.MoudleId
join rm in db.ChannelRoleManagers
on right.RoleId equals rm.RoleId
where rm.Manager.ManagerName == personName
where right.RightFlag == 1
where menu.ParentId == moudleId
where menu.MoudleId != "0"
select menu).Distinct().OrderBy(a => a.Sort).ToList();
return(menus);
}
}
//public IQueryable<ChannelMoudle> GetMoudleByParent(string parentId)
//{
// using (var db = new NationalUnionContext())
// {
// //return db.ChannelMoudles.Where(cm => cm.ParentId == parentId).AsQueryable();
// var menus = (from m in db.ChannelMoudles
// where m.ParentId == parentId
// select m).Distinct();
// return menus;
// }
//}
public List <ChannelMoudle> GetMoudleByParent(string parentId)
{
using (var db = new NationalUnionContext())
{
var menus = db.ChannelMoudles.Where(cm => cm.ParentId == parentId && cm.MoudleId != "0")
.Distinct()
.OrderBy(a => a.Sort)
.ToList();
return(menus);
//var menus = (from m in db.ChannelMoudles
// where m.ParentId == parentId
// select m).Distinct().OrderBy(a => a.Sort).ToList();
//return menus;
}
}
/// <summary>
/// 获取模块的当前用户操作权限[换用存储过程]
/// </summary>
/// <param name="managerId"></param>
/// <param name="action"></param>
/// <returns></returns>
public List <ChannelRightOperate> GetCurrentPermission(Int64 managerId, string action)
{
using (var db = new NationalUnionContext())
{
var operate = (from rm in db.ChannelRoleManagers
where rm.ManagerId == managerId
from right in db.ChannelRights
where right.RoleId == rm.RoleId
from menu in db.ChannelMoudles
where menu.MoudleId == right.MoudleId
where menu.Url == action
from ro in db.ChannelRightOperates
where ro.RightId == right.RightId
where ro.IsValid == 1
select ro).Distinct().ToList();
return(operate);
}
}
public List <ChannelMoudle> GetMenuByParentId(string moudleId)
{
//var menus =
// this.FindBy(m => m.ParentId == moudleId && m.MoudleId != "0")
// .Distinct()
// .OrderBy(a => a.Sort)
// .ToList();
//return menus;
using (var db = new NationalUnionContext())
{
var menus = (from m in db.ChannelMoudles
where m.ParentId == moudleId
where m.MoudleId != "0"
select m).Distinct().OrderBy(a => a.Sort).ToList();
return(menus);
}
}
public IQueryable <GetShareStatistics> GetShareStatisticsesList()
{
var db = new NationalUnionContext();
IQueryable <GetShareStatistics> list = db.DataSummary.Select(ds =>
new GetShareStatistics
{
UserId = ds.UserID,
SummaryDate = ds.SummaryDate,
ChannelId = ds.ChannelID,
PlatformId = ds.PlatformID,
SharedClientId = ds.SharedClientID,
SharedQunatity = ds.SharedQunatity,
PV = ds.PV,
UV = ds.UV,
OrderQuantity = ds.OrderQuantity,
ProductQuantity = ds.ProductsQuantity,
OrderAmount = ds.OrderAmount,
EstimateCommission = ds.EstimateCommission
});
return(list);
}
public List <GetStatistics> GetDataStatisticsByDay(Int64 managerId)
{
using (var db = new NationalUnionContext())
{
var today = DateTime.Parse(DateTime.Now.ToShortDateString());
var lday = today.AddDays(-1);
List <GetStatistics> list =
db.DataSummary.Where(ds => ds.UserID == managerId && ds.SummaryDate == lday)
.GroupBy(ds => new { ds.UserID })
.Select(g => new GetStatistics
{
PV = g.Sum(ds => ds.PV),
UV = g.Sum(ds => ds.UV),
OrderQuantity = g.Sum(ds => ds.OrderQuantity),
OrderAmount = g.Sum(ds => ds.OrderAmount),
EstimateCommission = g.Sum(ds => ds.EstimateCommission),
AvaliableCommission = g.Sum(ds => ds.AvaliableCommission),
UserId = g.Key.UserID
}).ToList();
return(list);
}
}
public ManagerDetailRepository(NationalUnionContext context)
: base(context)
{
}
public int UpdatePermission(ChannelRightOperate entity)
{
var rightOperate = new ChannelRightOperate
{
RightOperateId = entity.RightOperateId,
RightId = entity.RightId,
KeyCode = entity.KeyCode,
IsValid = entity.IsValid
};
// 判断rightOperate是否存在，如果存在就更新rightOperate，否则就添加一条
using (var db = new NationalUnionContext())
{
ChannelRightOperate rightOpt = db.ChannelRightOperates.FirstOrDefault(ro => ro.RightOperateId == rightOperate.RightOperateId);
if (rightOpt != null)
{
rightOpt.IsValid = rightOperate.IsValid;
}
db.ChannelRightOperates.Add(rightOperate);
if (db.SaveChanges() > 0)
{
// 更新角色--模块的有效标志RightFlag
var right = (from rt in db.ChannelRights
where rt.RightId == rightOperate.RightId
select rt).First();
// 根据right.MoudleId right.RoleId，计算上级模块的RightFlag
var count = db.ChannelRightOperates.Count(ro => ro.RightId == (right.RoleId + right.MoudleId) && ro.IsValid == 1);
var rgt = db.ChannelRights.FirstOrDefault(r => r.RoleId == right.RoleId && r.MoudleId == right.MoudleId);
if (rgt != null)
{
if (count > 0)
{
rgt.RightFlag = 1;
}
rgt.RightFlag = 0;
}
string parentId = right.MoudleId;
while (parentId != null && parentId != "0")
{
var moudles = db.ChannelMoudles.Select(cm => cm.ParentId == parentId);
if (moudles.Any())
{
var objcount = (from cm in db.ChannelMoudles
where cm.ParentId == parentId
from cr in db.ChannelRights
where cr.RoleId == right.RoleId
where cr.MoudleId == cm.MoudleId
where cr.RightFlag == 1
select cr).Count();
var crgt = db.ChannelRights.FirstOrDefault(r => r.MoudleId == parentId && r.RoleId == right.RoleId);
if (crgt != null)
{
if (objcount > 0)
{
crgt.RightFlag = 1;
}
crgt.RightFlag = 0;
}
}
}
return(1);
}
db.SaveChanges();
}
return(0);
}
public ShareChannelRepository(NationalUnionContext context)
: base(context)
{
}
public ChannelManageRepository(NationalUnionContext context) : base(context)
{
}
