//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) { }