/// <summary>
/// 根据主键删除信息
/// </summary>
/// <param name="FileCabinetAId"></param>
public static void DeleteFileCabinetAByID(string FileCabinetAId)
{
Model.SUBHSSEDB db = Funs.DB;
Model.InformationProject_FileCabinetA FileCabinetA = db.InformationProject_FileCabinetA.FirstOrDefault(e => e.FileCabinetAId == FileCabinetAId);
{
db.InformationProject_FileCabinetA.DeleteOnSubmit(FileCabinetA);
db.SubmitChanges();
}
}
/// <summary>
/// 修改文件柜
/// </summary>
/// <param name="FileCabinetA"></param>
public static void UpdateFileCabinetA(Model.InformationProject_FileCabinetA FileCabinetA)
{
Model.SUBHSSEDB db = Funs.DB;
Model.InformationProject_FileCabinetA newFileCabinetA = db.InformationProject_FileCabinetA.FirstOrDefault(e => e.FileCabinetAId == FileCabinetA.FileCabinetAId);
if (newFileCabinetA != null)
{
newFileCabinetA.Code = FileCabinetA.Code;
newFileCabinetA.Title = FileCabinetA.Title;
newFileCabinetA.SupFileCabinetAId = FileCabinetA.SupFileCabinetAId;
newFileCabinetA.IsEndLever = FileCabinetA.IsEndLever;
db.SubmitChanges();
}
}
/// <summary>
/// 添加文件柜
/// </summary>
/// <param name="FileCabinetA"></param>
public static void AddFileCabinetA(Model.InformationProject_FileCabinetA FileCabinetA)
{
Model.SUBHSSEDB db = Funs.DB;
Model.InformationProject_FileCabinetA newFileCabinetA = new Model.InformationProject_FileCabinetA
{
FileCabinetAId = FileCabinetA.FileCabinetAId,
ProjectId = FileCabinetA.ProjectId,
MenuId = FileCabinetA.MenuId,
Code = FileCabinetA.Code,
Title = FileCabinetA.Title,
SupFileCabinetAId = FileCabinetA.SupFileCabinetAId,
IsEndLever = FileCabinetA.IsEndLever
};
db.InformationProject_FileCabinetA.InsertOnSubmit(newFileCabinetA);
db.SubmitChanges();
}
/// <summary>
///
/// </summary>
/// <param name="menuId"></param>
/// <param name="dataId"></param>
/// <param name="content"></param>
/// <param name="url"></param>
/// <param name="projectId"></param>
public static void AddDataToFileCabinetA(string menuId, string dataId, string content, string url, string projectId)
{
var sysMenu = BLL.SysMenuService.GetSysMenuByMenuId(menuId);
if (sysMenu != null)
{
Model.InformationProject_FileCabinetA newFileCabinetA = new Model.InformationProject_FileCabinetA
{
FileCabinetAId = SQLHelper.GetNewID(typeof(Model.InformationProject_FileCabinetA)),
ProjectId = projectId,
Code = sysMenu.SortIndex.ToString(),
Title = sysMenu.MenuName,
MenuId = menuId
};
if (menuId == "0")
{
newFileCabinetA.SupFileCabinetAId = "0";
}
else
{
newFileCabinetA.SupFileCabinetAId = null;
}
newFileCabinetA.IsEndLever = sysMenu.IsEnd;
BLL.FileCabinetAService.AddFileCabinetA(newFileCabinetA);
///查询是否存在下级菜单
var fileCabinetAList = from x in Funs.DB.InformationProject_FileCabinetA
join y in Funs.DB.Sys_Menu on x.MenuId equals y.MenuId
where x.SupFileCabinetAId == null && x.ProjectId == projectId && y.SuperMenu == menuId
select x;
if (fileCabinetAList.Count() > 0)
{
foreach (var item in fileCabinetAList)
{
item.SupFileCabinetAId = newFileCabinetA.FileCabinetAId;
BLL.FileCabinetAService.UpdateFileCabinetA(item);
}
}
if (sysMenu.IsEnd == true) ///增加明细
{
AddDataToFileCabinetAItem(dataId, content, newFileCabinetA.FileCabinetAId, url);
}
var fileCabinetASuper = BLL.FileCabinetAService.GetFileCabinetAByMenuIdProjectId(sysMenu.SuperMenu, projectId);
if (fileCabinetASuper == null) ///继续增加上级菜单
{
AddDataToFileCabinetA(sysMenu.SuperMenu, dataId, content, url, projectId);
}
else
{
var fileCabinetASuperList = from x in Funs.DB.InformationProject_FileCabinetA
join y in Funs.DB.Sys_Menu on x.MenuId equals y.MenuId
where x.ProjectId == projectId && y.SuperMenu == fileCabinetASuper.MenuId && x.SupFileCabinetAId == null
select x;
if (fileCabinetASuperList.Count() > 0)
{
foreach (var item in fileCabinetASuperList)
{
item.SupFileCabinetAId = fileCabinetASuper.FileCabinetAId;
BLL.FileCabinetAService.UpdateFileCabinetA(item);
}
}
}
}
else
{
///查询是否存在下级菜单
var fileCabinetAList = from x in Funs.DB.InformationProject_FileCabinetA
where x.SupFileCabinetAId == null && x.ProjectId == projectId
select x;
if (fileCabinetAList.Count() > 0)
{
foreach (var item in fileCabinetAList)
{
item.SupFileCabinetAId = "0";
BLL.FileCabinetAService.UpdateFileCabinetA(item);
}
}
}
}
