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); }