public bool SetMenuButton(List <MenuButtonModel> list)
{
using (IDbConnection conn = OpenConnection())
{
IDbTransaction tranc = conn.BeginTransaction();
try
{
foreach (MenuButtonModel model in list)
{
Sys_MenuButton mb = new Sys_MenuButton {
menu_btnID = Guid.NewGuid(), fk_btnID = model.btnId, fk_menuID = model.menuID
};
if (model.isSelected)
{
int count = conn.GetList <Sys_MenuButton>(new { fk_btnID = model.btnId, fk_menuID = model.menuID }, tranc).Count();
if (count <= 0)
{
conn.Insert <Guid>(mb, tranc);
}
}
else
{
conn.DeleteList <Sys_MenuButton>(new { fk_btnID = model.btnId, fk_menuID = model.menuID }, tranc);
}
}
tranc.Commit();
return(true);
}
catch (Exception ex)
{
tranc.Rollback();
return(false);
}
}
}
/// <summary>
/// 根据实体整个更新数据库
/// </summary>
/// <param name="model">实体</param>
/// <returns>是否成功</returns>
public bool Update(Sys_MenuButton model)
{
return DalSys_MenuButton.Singleton.Update(model);
}
/// <summary>
/// 根据ID进行实体更新
/// </summary>
/// <param name="model">实体</param>
/// <returns>是否成功</returns>
public bool Insert(Sys_MenuButton model)
{
return DalSys_MenuButton.Singleton.Insert(model);
}
