internal bool DeleteWcsMenuDtl(WcsMenuDtl dtl)
{
string sql = string.Format("DELETE FROM wcs_menu_dtl where id = '{0}'", dtl.id);
int row = mSql.ExcuteSql(sql);
return(row >= 1);
}
public void AddMenuDtl(MenuModel md, short order)
{
WcsMenuDtl dtl = MenuDtlList.Find(c => c.id == md.Id);
if (dtl != null)//修改
{
EditMenuDtl(dtl, md, order);
}
else//添加
{
AddMenuDtlByModel(md, order);
}
if (md.MenuList != null)
{
short dtlorder = 1;
List <WcsMenuDtl> dtllist = GetMenuDtls(md.Id);
foreach (var item in md.MenuList)
{
WcsMenuDtl mdtl = MenuDtlList.Find(c => c.id == item.Id);
//修改
if (mdtl != null)
{
EditMenuDtl(mdtl, item, dtlorder);
}
else
{
//添加
AddMenuDtlByModel(item, dtlorder);
}
dtlorder++;
}
}
}
internal void AddWcsMenuDtl(WcsMenuDtl dtl)
{
string str = "INSERT INTO `wcs_menu_dtl`(`id`, `menu_id`, `name`, `folder`, `folder_id`, `module_id`, `order`)" +
" VALUES ({0}, {1}, '{2}', {3}, {4}, {5}, {6})";
string sql = string.Format(str, dtl.id, dtl.menu_id, dtl.name,
dtl.folder, dtl.folder_id, dtl.module_id, dtl.order);
int row = mSql.ExcuteSql(sql);
}
internal bool EditeWcsMenuDtl(WcsMenuDtl dtl)
{
string sql = "UPDATE `wcs_menu_dtl` SET `menu_id` = {0}, `name` = '{1}'," +
" `folder` = {2}, `folder_id` = {3}, `module_id` = {4}, `order` = {5} WHERE `id` = {6}";
sql = string.Format(sql, dtl.menu_id, dtl.name, dtl.folder, dtl.folder_id, dtl.module_id, dtl.order, dtl.id);
int row = mSql.ExcuteSql(sql);
return(row >= 1);
}
private void EditMenuDtl(WcsMenuDtl dtl, MenuModel md, short order)
{
dtl.name = md.Name;
dtl.folder = !md.OpenPage;
dtl.folder_id = md.FolderId;
dtl.menu_id = md.MenuId;
dtl.module_id = md.ModuleId;
dtl.order = order;
PubMaster.Mod.RoleSql.EditeWcsMenuDtl(dtl);
}
private void AddMenuDtlByModel(MenuModel md, short order)
{
WcsMenuDtl dtl = new WcsMenuDtl();
dtl.id = md.Id;
dtl.name = md.Name;
dtl.folder = !md.OpenPage;
dtl.folder_id = md.FolderId;
dtl.menu_id = md.MenuId;
dtl.module_id = md.ModuleId;
dtl.order = order;
PubMaster.Mod.RoleSql.AddWcsMenuDtl(dtl);
}
public void DeleteMenu(List <MenuModel> deletelist)
{
foreach (var item in deletelist)
{
WcsMenuDtl dtl = MenuDtlList.Find(c => c.id == item.Id);
if (dtl != null)
{
if (dtl.folder)
{
PubMaster.Mod.RoleSql.DeleteWcsMenuDtlsByFolderId(dtl.id);
}
PubMaster.Mod.RoleSql.DeleteWcsMenuDtl(dtl);
}
}
}
public MenuModel GetMenu(int id, bool getrf = false)
{
MenuModel menu = new MenuModel();
WcsMenuDtl dtl = GetMenuDtl(id);
if (dtl != null && (!dtl.rf || getrf))
{
menu.Id = dtl.id;
menu.FolderId = dtl.folder_id;
menu.Name = dtl.name;
menu.OpenPage = !dtl.folder;
menu.ModuleId = dtl.module_id;
menu.MenuId = dtl.menu_id;
menu.Rf = dtl.rf;
if (!dtl.folder)
{
WcsModule md = GetModule(dtl.module_id);
if (md != null)
{
menu.IKey = md.key;
}
else
{
menu.IKey = "没有配置菜单IKEY";
}
}
else
{
List <WcsMenuDtl> dtls = GetMenuDtls(dtl.id);
if (dtls.Count > 0)
{
dtls.Sort((x, y) => x.order.CompareTo(y.order));
}
foreach (var item in dtls)
{
menu.AddMenu(GetMenu(item.id));
}
}
return(menu);
}
return(null);
}
