/// <summary>
/// 创建一个模块
/// </summary>
/// <param name="entity">一个对象</param>
/// <returns></returns>
public int Create(SysMenu entity)
{
using (SysEntities db = new SysEntities())
{
Create(db, entity);
return(this.Save(db));
}
}
public bool Edit(SysMenu model)
{
using (var conn = OpenConnection())
{
string sql = "update SysMenu set Name=@Name,Url=@Url,Remark=@Remark,OrderNum=@OrderNum where Id=@Id ";
return(conn.Execute(sql, model) > 0);
}
}
public void Update(SysMenu menu)
{
using (MAction action = new MAction(tableName))
{
action.Data.LoadFrom(menu);
action.Update();
}
}
public bool Add(SysMenu model)
{
using (var conn = OpenConnection())
{
string sql = "insert into SysMenu(Name,Url,Remark,OrderNum) values (@Name,@Url,@Remark,@OrderNum)";
return(conn.Execute(sql, model) > 0);
}
}
public void Insert(SysMenu menu)
{
using (MAction action = new MAction(tableName))
{
action.Data.LoadFrom(menu);
action.Insert();
}
}
/// <summary>
/// 删除一个模块
/// </summary>
/// <param name="db">实体数据</param>
/// <param name="id">一条模块的主键</param>
public void Delete(SysEntities db, string id)
{
SysMenu deleteItem = GetById(db, id);
if (deleteItem != null)
{
db.SysMenu.DeleteObject(deleteItem);
}
}
public int Edit(SysMenu entity)
{
entity.EditTime = DateTime.Now;
entity.Editor = 1;// AuthenWidget.CurrentOperator?.UserID ?? AuthenWidget.CurrentCustomer?.CustomerID;
this.DbContext.SysMenu.Attach(entity);
this.DbContext.Entry(entity).State = EntityState.Modified;
return(this.DbContext.SaveChanges() <= 0 ? OperationWidget.Failed : OperationWidget.Success);
}
public SysMenu GetObjectByCondition(string where)
{
sysMenu = new SysMenu();
using (MAction action = new MAction(tableName))
{
if (action.Fill(where))
{
sysMenu = action.Data.ToEntity <SysMenu>();
}
}
return(sysMenu);
}
/// <summary>
/// 获取菜单权限
/// </summary>
/// <param name="menuCode"></param>
/// <returns></returns>
public List <string> GetMenuAuth(string menuCode)
{
List <string> list = new List <string>();
SysMenu menu = Detail(menuCode);
if (!string.IsNullOrEmpty(menu?.Operation))
{
var operation = JsonConvert.DeserializeObject <List <MenuOperation> >(menu.Operation);
foreach (var item in operation)
{
list.Add($"{menu.MenuCode}_{item.Code}");
}
}
return(list);
}
public void CopyTo(SysMenu obj)
{
obj.ID = this.ID;
obj.CODE = this.CODE;
obj.Name = this.Name;
obj.PageUrl = this.PageUrl;
obj.LevelNo = this.LevelNo;
obj.IsRoot = this.IsRoot;
obj.ParentCode = this.ParentCode;
obj.BU = this.BU;
obj.SITE = this.SITE;
obj.MEMO = this.MEMO;
obj.CreatedDate = this.CreatedDate;
obj.UpdatedDate = this.UpdatedDate;
obj.UpdatedBy = this.UpdatedBy;
}
public int Add(SysMenu entity)
{
entity.IsActive = (int)IsActive.否;
entity.Creator = 1; // AuthenWidget.CurrentOperator?.UserID ?? AuthenWidget.CurrentCustomer?.CustomerID;
entity.CreateTime = DateTime.Now;
entity.Editor = 1; //AuthenWidget.CurrentOperator?.UserID ?? AuthenWidget.CurrentCustomer?.CustomerID;
entity.EditTime = DateTime.Now;
this.DbContext.SysMenu.Add(entity);
this.DbContext.Entry(entity).State = EntityState.Added;
if (this.DbContext.SaveChanges() <= 0)
{
return(OperationWidget.Failed);
}
return(OperationWidget.Success);
}
public Object Clone()
{
SysMenu obj = new SysMenu();
obj.ID = this.ID;
obj.CODE = this.CODE;
obj.Name = this.Name;
obj.PageUrl = this.PageUrl;
obj.LevelNo = this.LevelNo;
obj.IsRoot = this.IsRoot;
obj.ParentCode = this.ParentCode;
obj.BU = this.BU;
obj.SITE = this.SITE;
obj.MEMO = this.MEMO;
obj.CreatedDate = this.CreatedDate;
obj.UpdatedDate = this.UpdatedDate;
obj.UpdatedBy = this.UpdatedBy;
return(obj);
}
/// <summary>
/// 编辑一个模块对象
/// </summary>
/// <param name="db">实体数据</param>
/// <param name="entity">将要编辑的一个模块对象</param>
public SysMenu Edit(SysEntities db, SysMenu entity)
{
db.SysMenu.Attach(entity);
db.ObjectStateManager.ChangeObjectState(entity, EntityState.Modified);
return(entity);
}
/// <summary>
/// 获取节点的字符串
/// </summary>
/// <param name="item"></param>
/// <returns></returns>
public string GetNode(SysMenu item, bool isLeaf = false)
{
List<string> dataoptions = new List<string>();
if (!string.IsNullOrWhiteSpace(item.Iconic))
{
dataoptions.Add(string.Format("iconCls:'{0}'", item.Iconic));
}
if (isLeaf)
{
return string.Format("<li data-options=@{0}@><a href=@#@ icon=@{1}@ rel=@{2}@ id=@{3}@>{4}</a></li>^", string.Join(",", dataoptions), item.Iconic, item.Url, item.Id, item.Name);
}
else
{
////此处可以在数据字典中配置，将State字段，配置为下拉框，下拉框其中有一个值是"收缩"
if (!string.IsNullOrWhiteSpace(item.State))//收缩展开 && item.State == "收缩"
{//菜单默认显示关闭
dataoptions.Add(string.Format("state:'closed'"));
}
return string.Format("<li data-options=@{0}@><span>{1}</span><ul>^</ul></li>", string.Join(",", dataoptions), item.Name);
}
}
