/// <summary>
/// 添加 功能菜单
/// </summary>
/// <param name="func"></param>
/// <returns></returns>
public static bool AddFunctions(xpGrid_Functions func)
{
//1.为空，返回false
if (func.FuncCode.Length <= 0)
{
return(false);
}
//2.用户已经存在，返回false
if (IsExistFunc(func.FuncCode))
{
return(false);
}
using (DBContext dbContext = new DBContext())
{
//添加纪录
xpGrid_Functions funcNew = new xpGrid_Functions
{
FuncCode = func.FuncCode,
FuncName = func.FuncName,
Enable = func.Enable,
FuncImg = func.FuncImg,
FuncParent = func.FuncParent,
DisplayOrder = func.DisplayOrder,
FuncUrl = func.FuncUrl
};
dbContext.xpGrid_Functions.Add(funcNew);
dbContext.SaveChanges();
}
return(true);
}
/// <summary>
/// 查找 功能菜单
/// </summary>
/// <param name="FuncCode"></param>
/// <returns></returns>
public static xpGrid_Functions GetFunctionByFuncCode(string FuncCode)
{
using (DBContext dbContext = new DBContext())
{
xpGrid_Functions funcInfo = dbContext.xpGrid_Functions.Where(u => u.FuncCode == FuncCode).FirstOrDefault();
return(funcInfo);
}
}
/// <summary>
/// 批量删除功能菜单
/// </summary>
/// <param name="pmIdList"></param>
public static void Delfunclist(string[] pmIdList)
{
using (DBContext dbContext = new DBContext())
{
//循环删除，性能不好 ？
foreach (string funcCode in pmIdList)
{
xpGrid_Functions Func = dbContext.xpGrid_Functions.Where(u => u.FuncCode == funcCode).FirstOrDefault();
if (Func != null)
{
dbContext.xpGrid_Functions.Remove(Func);
}
}
dbContext.SaveChanges();
}
}
public static bool IsExistFunc(string FuncCode)
{
using (DBContext dbContext = new DBContext())
{
xpGrid_Functions func = dbContext.xpGrid_Functions.Where(u => u.FuncCode == FuncCode).FirstOrDefault();
if (func != null)
{
return(true);
}
else
{
return(false);
}
}
}
/// <summary>
/// 修改功能菜单
/// </summary>
/// <param name="fid"></param>
/// <param name="func"></param>
public static void UpdateFunc(string fid, xpGrid_Functions func)
{
using (DBContext dbContext = new DBContext())
{
xpGrid_Functions Func = dbContext.xpGrid_Functions.Where(u => u.FuncCode == fid).FirstOrDefault();
if (Func == null)
{
return;//空
}
Func.FuncName = func.FuncName;
Func.FuncUrl = func.FuncUrl;
Func.FuncParent = func.FuncParent;
Func.Enable = func.Enable;
Func.DisplayOrder = func.DisplayOrder;
//提交修改
dbContext.SaveChanges();
}
}
/// <summary>
/// 删除功能菜单
/// </summary>
/// <param name="funcCode"></param>
public static void DeleteFunc(string funcCode)
{
try
{
using (DBContext dbContext = new DBContext())
{
xpGrid_Functions func = dbContext.xpGrid_Functions.Where(u => u.FuncCode == funcCode).FirstOrDefault();
if (func != null)
{
dbContext.xpGrid_Functions.Remove(func);
dbContext.SaveChanges();
}
}
}
catch (Exception Ex)
{
throw Ex;
}
}
