public string SaveSysButton(SysButton mo, string savetype)
{
int num = 0;
if (string.IsNullOrWhiteSpace(mo.Pid))
{
mo.Pid = Guid.Empty.ToString();
}
using (var db = new ContextBase())
{
if (savetype == "add")
{
db.SysButton.Add(mo);
}
else
{
db.SysButton.Update(mo);
}
num = db.SaveChanges();
}
//清理缓存
Core.CacheTo.Remove(Func.Common.GlobalCacheKey.SysButton);
return(num > 0 ? "success" : "fail");
}
public ActionResultVM SaveSysButton(SysButton mo, string savetype)
{
var vm = new ActionResultVM();
if (string.IsNullOrWhiteSpace(mo.SbPid))
{
mo.SbPid = Guid.Empty.ToString();
}
if (mo.SbBtnHide == null)
{
mo.SbBtnHide = -1;
}
using (var db = new ContextBase())
{
if (savetype == "add")
{
mo.SbId = Guid.NewGuid().ToString();
db.SysButton.Add(mo);
}
else
{
db.SysButton.Update(mo);
}
int num = db.SaveChanges();
vm.Set(num > 0);
}
//清理缓存
Core.CacheTo.Remove(Func.Common.GlobalCacheKey.SysButton);
return(vm);
}
public SharedResultVM SaveSysButton(SysButton mo, string savetype)
{
var vm = new SharedResultVM();
if (string.IsNullOrWhiteSpace(mo.SbPid))
{
mo.SbPid = Guid.Empty.ToString();
}
if (mo.SbBtnHide == null)
{
mo.SbBtnHide = -1;
}
if (savetype == "add")
{
mo.SbId = Guid.NewGuid().ToString();
db.SysButton.Add(mo);
}
else
{
db.SysButton.Update(mo);
}
int num = db.SaveChanges();
vm.Set(num > 0);
//清理缓存
Core.CacheTo.Remove(Application.CommonService.GlobalCacheKey.SysButton);
return(vm);
}
/// <summary>
/// 修改按钮
/// </summary>
/// <param name="sysButton"></param>
/// <returns></returns>
public async Task <bool> UpdateButton(SysButton sysButton)
{
sysButton.UpdateDate = DateTime.Now;
return(await _buttonRepositoty.UpdateNotQueryAsync(sysButton,
x => x.Name, x => x.Memo, x => x.KeyCode, x => x.APIAddress, x => x.ButtonStyle, x => x.MenuId, x => x.IsShow,
x => x.UpdateDate, x => x.UpdateId, x => x.UpdateName,
x => x.Sort) > 0);
}
public void Insert(SysButton user)
{
using (MAction action = new MAction(tableName))
{
action.Data.LoadFrom(user);
action.Insert();
}
}
public void Update(SysButton user)
{
using (MAction action = new MAction(tableName))
{
action.Data.LoadFrom(user);
action.Update();
}
}
public bool HasButton(SysButton btn)
{
if (UserModel == null || UserModel.FirstMenu == null)
{
return(false);
}
return((UserModel.FirstMenu.Buttons & btn) == btn);
}
public bool HasButton(SysButton btn)
{
if (UserInfo == null || UserInfo.CurrentMenu == null)
{
return(false);
}
return((UserInfo.CurrentMenu.Buttons & btn) != SysButton.None);
}
/// <summary>
/// TODO...重建菜单角色缓存
/// </summary>
/// <param name="sysMenuDto"></param>
/// <param name="buttons"></param>
/// <returns></returns>
public async Task CreateOrUpdateAsync(SysMenuDto sysMenuDto, IEnumerable <SysButtonDto> buttons)
{
SysMenu menu;
ICollection <SysButton> sysButtons = new List <SysButton>();
if (!string.IsNullOrEmpty(sysMenuDto.Id))
{
menu = await GetObjectAsync(_ => _.Id == sysMenuDto.Id);
menu.Update(sysMenuDto);
}
else
{
menu = new SysMenu(sysMenuDto);
}
IEnumerable <string> modifySysButtons = buttons.Where(_ => !string.IsNullOrEmpty(_.Id)).Select(_ => _.Id);
IEnumerable <SysButton> updateBUttons;
if (modifySysButtons.Any())
{
updateBUttons = await _sysButtonService.GetFullListAsync(_ => modifySysButtons.Contains(_.Id));
}
else
{
updateBUttons = new List <SysButton>();
}
foreach (var item in buttons)
{
if (string.IsNullOrEmpty(item.ButtonName))
{
continue;
}
SysButton sysButton;
if (string.IsNullOrEmpty(item.Id))
{
sysButton = new SysButton(item);
sysButton.MenuId = menu.Id;
}
else
{
sysButton = updateBUttons.FirstOrDefault(_ => _.Id == item.Id);
sysButton.Update(item);
}
sysButtons.Add(sysButton);
}
await BeginTransactionAsync(async() =>
{
if (sysButtons.Any())
{
await _sysButtonService.SaveObjectListAsync(sysButtons);
}
await SaveObjectAsync(menu);
});
await GetMenuDtoByCacheAsync(true);
}
public void TestProcedureGetModel()
{
using (IDbConnection connection = ConnectionFactory.CreateMsSqlConnection())
{
var p = new DynamicParameters();
p.Add("@BtnId", "00000000-0000-0000-0000-000000000000");
SysButton SysButton =
connection.Query <SysButton>("Sys_Button_GetModel", p, commandType: CommandType.StoredProcedure)
.First();
Console.WriteLine(SysButton.BtnIcon);
}
}
public async Task <MessageModel <string> > UpdateButton([FromBody] SysButton sysButton)
{
var data = new MessageModel <string>();
data.success = await _buttonServer.UpdateButton(sysButton);
if (data.success)
{
data.msg = "按钮修改成功";
}
return(data);
}
public SysButton GetObjectByCondition(string where)
{
SysButton sysButton = new SysButton();
using (MAction action = new MAction(tableName))
{
if (action.Fill(where))
{
sysButton = action.Data.ToEntity <SysButton>();
}
}
return(sysButton);
}
private List <SysButton> GetLstBtn(SysButton buttons)
{
var lstBtn = new List <SysButton>();
foreach (var btn in buttons.GetDescriptDict())
{
var button = (SysButton)btn.Key;
if (buttons.HasFlag(button))
{
lstBtn.Add(button);
}
}
return(lstBtn);
}
public void AddTest()
{
for (int i = 1; i < 10; i++)
{
var model = new SysButton
{
SysId = "cf9d52cc-0500-4829-9611-fd005696192" + i.ToString(CultureInfo.InvariantCulture),
MenuId = "cf9d52cc-0500-4829-9611-fd0056961234",
BtnName = "按钮" + i.ToString(CultureInfo.InvariantCulture),
BtnIcon = "图标路径",
BtnOrder = i,
RecordStatus = string.Format("创建时间：{0},创建人：{1}", DateTime.Now.ToString(CultureInfo.InvariantCulture), "jim"),
IsVisible = 1
};
Console.WriteLine(repository.Add(model));
}
}
public JsonResult EnableMenuButton(string enButtonIds, string disButtonIds)
{
string[] disBtIds = disButtonIds.Split(',');
string[] enBtIds = enButtonIds.Split(',');
using (var tran = RepositoryFactory.ConfigRepository.Connection.BeginTransaction())
{
for (int i = 0; i < disBtIds.Length; i++)
{
if (!string.IsNullOrEmpty(disBtIds[i]))
{
SysButton button = RepositoryFactory.ButtonRepository.GetModel(disBtIds[i]);
button.IsVisible = (long)PrivilegeOperation.Disable;
//SysButton button = RepositoryFactory.ButtonRepository.GetModel(buttonIds);
if (RepositoryFactory.ButtonRepository.Update(button, tran) == 0)
{
tran.Rollback();
return(Json(false));
}
}
}
for (int i = 0; i < enBtIds.Length; i++)
{
if (!string.IsNullOrEmpty(enBtIds[i]))
{
SysButton button = RepositoryFactory.ButtonRepository.GetModel(enBtIds[i]);
button.IsVisible = (long)PrivilegeOperation.Enable;
if (RepositoryFactory.ButtonRepository.Update(button, tran) == 0)
{
tran.Rollback();
return(Json(false));
}
}
}
tran.Commit();
}
/*Logger.LogMsg(
* LogLevel.Info,
* string.Format("禁用菜单按钮,enButtonIds:{0},disButtonIds:{1} 成功", enButtonIds, disButtonIds),
* UserData.SysId,
* UserData.UserName,
* "RestApi->EnableMenuButton");*/
return(Json(true));
}
public void UpdateButton(SysButton sb)
{
}
public static AjaxResult AddButton(SysButton entity)
{
entity.BtnIcon = entity.BtnIcon.Substring(entity.BtnIcon.IndexOf("lib/"));
return(DB.InsertEntity <SysButton>(entity));
}
/// <summary>
/// 保存
/// </summary>
/// <param name="entity"></param>
/// <param name="message"></param>
/// <returns></returns>
public void Save(SysButton entity)
{
Ser_SysButton.InsertOrUpdateExt(entity);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public bool Update(SysButton model)
{
var rows = fsql.Update <SysButton>().SetSource(model).IgnoreColumns(p => new { p.CreateBy, p.CreateOn }).ExecuteAffrows();
return(rows > 0);
}
public void Save(SysButton model)
{
_ISysButtonServices.Save(model);
}
public void AddButton(SysButton sb)
{
}
public IActionResult Form(SysButton button)
{
button.EnCode = button.JsEvent;
button.CreatorAccountId = CurrentUser.AccountId;
return(Json(_sysButtonService.Save(button)));
}
/// <summary>
/// 添加按钮
/// </summary>
/// <param name="sysButton"></param>
/// <returns></returns>
public async Task <bool> AddButton(SysButton sysButton)
{
return(await _buttonRepositoty.InsertAsync(sysButton));
}
