//新增编辑
public IActionResult Create(string KeyId)
{
sys_button model = null;
if (!string.IsNullOrEmpty(KeyId))
{
model = bll.GetModelById <sys_button>(KeyId);
}
model = model ?? new sys_button();
return(View(model));
}
/// <summary>
/// 分页
/// </summary>
/// <param name="PageIndex"></param>
/// <param name="PageSize"></param>
/// <param name="model"></param>
/// <returns></returns>
public PageModel <sys_button> ButtonPage(int PageIndex, int PageSize, sys_button model)
{
using (var db = SqlSugarDB.MasterDB)
{
int totalNumber = 0;
var list = db.Queryable <sys_button>()
.Where(item => item.IsDeleted == false)
.WhereIF(!string.IsNullOrEmpty(model.FullName), item => item.FullName.Contains(model.FullName))
.OrderBy(item => item.SortNum)
.ToPageList(PageIndex, PageSize, ref totalNumber);
return(GetPageInfo <sys_button>(PageIndex, PageSize, list, totalNumber));
}
}
//分页
public JsonResult PageData(int PageIndex, int PageSize, sys_button model)
{
var page = bll.ButtonPage(PageIndex, PageSize, model);
if (page != null && page.rows != null)
{
string json = JsonConvert.SerializeObject(page.rows);
JArray ja = (JArray)JsonConvert.DeserializeObject(json);
for (int i = 0; i < ja.Count; i++)
{
ja[i]["CreateDate"] = ja[i]["CreateDate"] == null ? "" : Convert.ToDateTime(ja[i]["CreateDate"].ToString()).ToString("yyyy-MM-dd HH:mm:ss");
}
page.rows = ja;
}
return(Json(page));
}
public IActionResult Create(sys_button model)
{
ExecuteResult Er = new ExecuteResult();
if (string.IsNullOrEmpty(model.KeyId))
{
int count = bll.GetList <sys_button>(item => item.FullName == model.FullName && item.IsDeleted == false).Count();
if (count > 0)
{
Er.Result = false;
Er.Message = "已存在相同的按钮名称";
}
else
{
#region 新增
model.IsDeleted = false;
model.CreateDate = DateTime.Now;
model.KeyId = Guid.NewGuid().ToString();
Er.Result = bll.Insert <sys_button>(model) > 0;
Er.Message = Er.Result ? "新增成功" : "新增失败";
#endregion
}
}
else
{
int count = bll.GetList <sys_button>(item => item.FullName == model.FullName && item.KeyId != model.KeyId && item.IsDeleted == false).Count();
if (count > 0)
{
Er.Result = false;
Er.Message = "已存在相同的按钮名称";
}
else
{
#region 修改
var old = bll.GetModelById <sys_button>(model.KeyId);
old.FullName = model.FullName;
old.ButtonEvent = model.ButtonEvent;
old.Description = model.Description;
old.SortNum = model.SortNum;
old.Icon = model.Icon;
Er.Result = bll.Update <sys_button>(old) > 0;
Er.Message = Er.Result ? "编辑成功" : "编辑失败";
#endregion
}
}
return(Json(Er));
}
/// <summary>
/// 分页
/// </summary>
/// <param name="PageIndex"></param>
/// <param name="PageSize"></param>
/// <param name="model"></param>
/// <returns></returns>
public PageModel <sys_button> ButtonPage(int PageIndex, int PageSize, sys_button model)
{
return(dal.ButtonPage(PageIndex, PageSize, model));
}
