public Flexigride GetJson(JObject json)
{
SearchMod <SYS_Button> searchModel = new SearchMod <SYS_Button>();
searchModel.page = Convert.ToInt32(json["page"].ToString()); //当前页
searchModel.rp = Convert.ToInt32(json["rp"].ToString()); //页面大小
searchModel.sortorder = json["sortorder"].ToString(); //排序字段
searchModel.sortname = json["sortname"].ToString(); //排序方式
SYS_Button model = JsonToObject <SYS_Button>(json);
IQueryable <SYS_Button> query = DPBase.db.SYS_Button;
query = string.IsNullOrEmpty(searchModel.sortorder) ? query.OrderByDescending(c => searchModel.sortorder) : query.OrderBy(c => searchModel.sortorder);
if (!string.IsNullOrEmpty(model.BTN_Name))
{
query = query.Where(c => c.BTN_Name.Contains(model.BTN_Name));
}
if (!string.IsNullOrEmpty(model.BTN_Name_En))
{
query = query.Where(c => c.BTN_Name_En.Contains(model.BTN_Name_En));
}
searchModel.query = query;
Flexigride grid = new Flexigride();
grid.rows = DPBase.DPGetQueryLst(searchModel, out searchModel);
grid.page = searchModel.page;
grid.total = searchModel.total;
return(grid);
}
public SYS_Button Get(JObject json)
{
var model = JsonToObject <SYS_Button>(json);
SYS_Button _model = DPBase.Get <SYS_Button>(model.BTN_Id);
return(_model);
}
public JsonResult UpdateButton(SYS_Button button)
{
JsonResult result = new JsonResult();
string msg = "";
try
{
button.ModifiedTime = DateTime.Now;
button.Modifier = (Session["user"] as SYS_User)?.UserName;
bool isSuccess = buttonService.UpdateButton(button);
if (isSuccess)
{
msg = "修改成功";
}
else
{
msg = "修改失败";
}
log.Info(msg);
}
catch (DbEntityValidationException e)
{
log.Error(e.Message);
}
catch (Exception e)
{
log.Error(e.Message);
}
finally
{
result = Json(new { msg = msg }, JsonRequestBehavior.AllowGet);
}
return(result);
}
/// <summary>
/// 按钮内容HTML
/// </summary>
/// <param name="btn">按钮对象</param>
/// <returns></returns>
public string ButtonInnerHtml(SYS_Button btn)
{
string icon = "<i class='layui-icon " + btn.BtnIcon + "'></i>";
string text = btn.BtnName;
string innerHtml = "按钮";
var showType = (BtnShowType)btn.ShowType;
switch (showType)
{
case BtnShowType.图标加文字:
innerHtml = icon + text;
break;
case BtnShowType.纯图标:
innerHtml = icon;
break;
case BtnShowType.纯文字:
innerHtml = text;
break;
default:
break;
}
return(innerHtml);
}
public int Add(JObject json)
{
SYS_Button model = JsonToObject <SYS_Button>(json);
model.BTN_IsSuspended = false; //默认为false
model.BTN_Mark = model.BTN_Name_En;
model.BTN_CreatedBy = UserSession.username; //当前用户
model.BTN_CreatedOn = DateTime.Now;
return(DPBase.Add(model));
}
public string ValBtnAttribute(JObject json)
{
if (string.IsNullOrEmpty(json["BTN_OrderIndex"].ToString()))
{
json["BTN_OrderIndex"] = 0;
}
SYS_Button model = JsonToObject <SYS_Button>(json);
return(DPButton.DPValBtnAttribute(model));
}
/// <summary>
/// 删除按钮
/// </summary>
/// <param name="id">按钮ID</param>
/// <returns></returns>
public bool DeleteButton(Guid id)
{
using (var db = base.GDDSVSPDb)
{
int isdel = Convert.ToInt32(IsDel.未删除);
SYS_Button Button = db.SYS_Button.SingleOrDefault(p => p.ButtonID == id && p.IsDel == isdel);
Button.IsDel = Convert.ToInt32(IsDel.已删除);
return(db.SaveChanges() > 0);
}
}
/// <summary>
/// 验证按钮属性
/// </summary>
/// <returns></returns>
public static string DPValBtnAttribute(SYS_Button Btn)
{
try
{
using (NERPEntities context = new NERPEntities())
{
string flag = string.Empty;
IQueryable <SYS_Button> _valbBtn = context.SYS_Button;
if (Btn.BTN_Id != 0)
{
_valbBtn = _valbBtn.Where(c => c.BTN_Id != Btn.BTN_Id);
}
var _valName = _valbBtn.Where(c => c.BTN_Name == Btn.BTN_Name);
if (_valName.Count() != 0)
{
flag = "0";
}
else
{
var _valName_En = _valbBtn.Where(c => c.BTN_Name_En == Btn.BTN_Name_En);
if (_valName_En.Count() != 0)
{
flag = "1";
}
else
{
var _valMark = _valbBtn.Where(c => c.BTN_Mark == Btn.BTN_Mark);
if (_valMark.Count() != 0)
{
flag = "3";
}
//}
}
}
return(flag);
}
}
catch (Exception ex)
{
throw new Exception(ex.Message + "转换的过程中发生了错误！");
}
}
/// <summary>
/// 添加按钮
/// </summary>
/// <param name="Button">按钮对象</param>
/// <returns></returns>
public bool InsertButton(SYS_Button Button)
{
try
{
using (var transaction = new TransactionScope(TransactionScopeOption.RequiresNew, new TransactionOptions {
IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted
}))
{
using (var db = base.GDDSVSPDb)
{
db.SYS_Button.Add(Button);
db.SaveChanges();
List <SYS_Menu> menuList = db.SYS_Menu.ToList();
List <SYS_REL_MenuButton> mblist = new List <SYS_REL_MenuButton>();
int isdel = Convert.ToInt32(IsDel.已删除);
foreach (var menu in menuList)
{
SYS_REL_MenuButton mb = new SYS_REL_MenuButton()
{
ID = Guid.NewGuid(),
BtnCode = Button.BtnCode,
MenuCode = menu.MenuCode,
State = isdel
};
mblist.Add(mb);
}
db.SYS_REL_MenuButton.BulkInsert(mblist);
db.BulkSaveChanges();
}
transaction.Complete();
}
}
catch (DbEntityValidationException ex)
{
throw ex;
}
return(true);
}
/// <summary>
/// 修改按钮
/// </summary>
/// <param name="obj">按钮对象</param>
/// <returns></returns>
public bool UpdateButton(SYS_Button obj)
{
try
{
using (var db = base.GDDSVSPDb)
{
int isdel = Convert.ToInt32(IsDel.未删除);
SYS_Button Button = db.SYS_Button.SingleOrDefault(p => p.ButtonID == obj.ButtonID && p.IsDel == isdel);
Button.BtnCode = obj.BtnCode;
Button.BtnName = obj.BtnName;
Button.BtnOrder = obj.BtnOrder;
Button.BtnDescribe = obj.BtnDescribe;
Button.BtnIcon = obj.BtnIcon;
Button.BtnType = obj.BtnType;
Button.ShowType = obj.ShowType;
return(db.SaveChanges() > 0);
}
}
catch (DbEntityValidationException ex)
{
throw ex;
}
}
public JsonResult InsertEmployee(SYS_Button btn)
{
JsonResult result = new JsonResult();
try
{
btn.ButtonID = Guid.NewGuid();
btn.IsDel = 0;
btn.CreateTime = DateTime.Now;
btn.Creator = (Session["user"] as SYS_User)?.UserName;
bool isSuccess = buttonService.InsertButton(btn);
log.Info("添加成功");
}
catch (Exception e)
{
log.Error(e.Message);
}
finally
{
result = Json(new { msg = "添加成功" }, JsonRequestBehavior.AllowGet);
}
return(result);
}
public string Edit(JObject json)
{
SYS_Button model = JsonToObject <SYS_Button>(json);
return(DPBase.Update(model) ? "新增成功！" : "新增失败");
}
