public IActionResult AddSave(sys_role vmodel)
{
if (vmodel != null)
{
if (string.IsNullOrEmpty(vmodel.Role_ID))
{
if (string.IsNullOrEmpty(vmodel.Role_Name))
{
return(Json(new { code = 100, msg = "请输入角色名" }));
}
vmodel.Role_ID = Guid.NewGuid().ToString();
vmodel.Role_CreateTime = DateTime.Now;
vmodel.Role_IsDelete = 1;
_sys_RoleService.Insert(vmodel);
}
else
{
return(Json(new { code = 100, msg = "无效参数" }));
}
}
else
{
return(Json(new { code = 100, msg = "无效参数" }));
}
return(Json(new { code = 200, msg = "操作成功" }));
}
public ActionResult Edit(sys_role collection)
{
ReturnMessage RM = new ReturnMessage(false);
if (ModelState.IsValid)
{
try
{
var q = Query.And(Query <sys_role> .EQ(t => t.role_name, collection.role_name),
Query <sys_role> .NE(t => t.Rid, collection.Rid));
var query = BusinessContext.sys_role.GetList(q);
if (query.Count > 0)
{
RM.Message = "角色名称已被占用";
}
else
{
sys_role old = BusinessContext.sys_role.Get(Query <sys_role> .EQ(t => t.Rid, collection.Rid));
RM.IsSuccess = BusinessContext.sys_role.Update(collection);
if (RM.IsSuccess)
{
OperateLogHelper.Edit <sys_role>(collection, old);
}
}
}
catch (Exception ex)
{
RM.Message = ex.Message;
}
}
return(Json(RM));
}
public JsonResult Edit(sys_role one)
{
bool edit = _bll.Update(one);
CRUDModel cm = CRUDModelHelper.GetRes(CRUD.EDIT, edit);
return(Json(cm));
}
/// <summary>
/// 角色列表
/// </summary>
/// <param name="pageNum"></param>
/// <param name="numPerPage"></param>
/// <param name="model"></param>
/// <returns></returns>
public ActionResult Index(int?pageNum, int?numPerPage, sys_role model)
{
int pageIndex = pageNum.HasValue ? pageNum.Value : 1;
int pageSize = numPerPage.HasValue && numPerPage.Value > 0 ? numPerPage.Value : 20;
int recordCount = 0;
//(q) => q.id,排序的字段
Expression <Func <sys_role, bool> > wherelambad = u => 1 == 1;//查询条件;
if (!string.IsNullOrWhiteSpace(model.S_name))
{
wherelambad = wherelambad = u => u.S_name.Contains(model.S_name);//模糊查找
}
LogUtil.WiteLog.WriteLogs("小五测试abc", "testlog");
//true,升序,false降序
var data = Bll.GetPageEntities <DateTime>(pageIndex, pageSize, out recordCount, wherelambad, (q) => q.CreateTime, false);
ViewData["pageIndex"] = pageIndex;
ViewData["pageSize"] = pageSize;
ViewData["recordCount"] = recordCount;
ViewData["S_name"] = model.S_name;
var list = data.ToList();
return(View(list));
}
public ActionResult Edit(sys_role collection)
{
ReturnMessage RM = new ReturnMessage(false);
if (ModelState.IsValid)
{
try
{
var query = BusinessContext.sys_role.GetModelList(String.Format("role_name='{0}' and TblRcdId<>{1}", collection.role_name, collection.TblRcdId));
if (query.Count > 0)
{
RM.Message = "角色名称已被占用";
}
else
{
sys_role old = BusinessContext.sys_role.GetModel(collection.TblRcdId);
RM.IsSuccess = BusinessContext.sys_role.Update(collection);
if (RM.IsSuccess)
{
OperateLogHelper.Edit <sys_role>(collection, old);
}
}
}
catch (Exception ex)
{
RM.Message = ex.Message;
}
}
return(Json(RM));
}
// GET: Roles/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
sys_role sys_role = db.sys_role.Find(id);
if (sys_role == null)
{
return(HttpNotFound());
}
var cookie = Request.Cookies[FormsAuthentication.FormsCookieName];
var ticket = FormsAuthentication.Decrypt(cookie.Value);
Global.loginInfo = JsonConvert.DeserializeObject <Global.LoginInfo>(ticket.UserData);
string userId = Global.loginInfo.user_id.ToString();
Dictionary <string, string> dic = new Dictionary <string, string>();
dic = getButtonPriv(userId, "priv");
ViewBag.showPrivBtn = false;
if (dic.ContainsKey("editPriv"))
{
ViewBag.showPrivBtn = true;
}
return(View(sys_role));
}
public IActionResult Save(sys_role vmodel)
{
if (vmodel != null)
{
if (string.IsNullOrEmpty(vmodel.Role_Name))
{
throw new MessageBox("请输入角色名");
}
if (string.IsNullOrEmpty(vmodel.Role_ID))
{
vmodel.Role_ID = Guid.NewGuid().ToString();
vmodel.Role_CreateTime = DateTime.Now;
_sys_RoleService.Insert(vmodel);
}
else
{
_sys_RoleService.Update(vmodel);
}
}
else
{
return(Json(new { status = 0, msg = "无效参数" }));
}
return(Json(new { status = 1, msg = "操作成功" }));
}
public ActionResult Edit(sys_role collection)
{
var rm = new ReturnMessage(false);
if (ModelState.IsValid)
{
try
{
var q = Query.And(Query <sys_role> .EQ(t => t.role_name, collection.role_name),
Query <sys_role> .NE(t => t.Rid, collection.Rid));
var query = BusinessContext.sys_role.GetList(q);
if (query.Count > 0)
{
rm.Message = "角色名称已被占用";
}
else
{
collection.ModifyOn = DateTime.Now;
collection.ModifyBy = CurrentHelper.CurrentUser.User.UserName;
rm.IsSuccess = BusinessContext.sys_role.Update(collection);
}
}
catch (Exception ex)
{
rm.Message = ex.Message;
}
}
return(Json(rm));
}
/// <summary>
/// 设置角色信息
/// </summary>
/// <param name="sys_role">角色类型</param>
/// <returns></returns>
public int SetRole(sys_role role)
{
StringBuilder strSql = new StringBuilder();
strSql.Clear();
strSql.Append("select count(*)as cnt from sys_role where Ledger=@Ledger and Role_id!=@Role_id and Descr=@Descr");
object obj = SQLHelper.ExecuteScalar(strSql.ToString(), new { Ledger = this.Ledger, Role_id = role.Role_id, Descr = role.Descr });
if (CommFunc.ConvertDBNullToInt32(obj) > 0)
{
throw new Exception("角色:" + role.Descr + "已存在");
}
if (role.Role_id == 0)
{
strSql.Clear();
strSql.Append("select max(Role_id)as Role_id from sys_role where Ledger=@Ledger");
obj = SQLHelper.ExecuteScalar(strSql.ToString(), new { Ledger = this.Ledger });
role.Role_id = CommFunc.ConvertDBNullToInt32(obj) + 1;
//////////
strSql.Clear();
strSql.Append("insert sys_role(Ledger,Role_id,Descr,Update_by,Update_dt,Remark)values(@Ledger,@Role_id,@Descr,@Update_by,now(),@Remark)");
return(SQLHelper.Execute(strSql.ToString(), new { Ledger = this.Ledger, Role_id = role.Role_id, Descr = role.Descr, Update_by = this.SysUid, Remark = role.Remark }));
}
else
{
strSql.Clear();
strSql.Append("update sys_role set Descr=@Descr,Remark=@Remark,Update_by=@Update_by,Update_dt=now() where Ledger=@Ledger and Role_id=@Role_id");
return(SQLHelper.Execute(strSql.ToString(), new { Ledger = this.Ledger, Role_id = role.Role_id, Descr = role.Descr, Update_by = this.SysUid, Remark = role.Remark }));
}
}
public ActionResult Create(sys_role collection, string isContinue = "0")
{
var rm = new ReturnMessage(false);
if (ModelState.IsValid)
{
try
{
var query =
BusinessContext.sys_role.GetList(Query <sys_role> .EQ(t => t.role_name, collection.role_name));
if (query.Count > 0)
{
rm.Message = "角色名称已被占用";
}
else
{
collection.CreateOn = DateTime.Now;
collection.CreateBy = CurrentHelper.CurrentUser.User.UserName;
var res = BusinessContext.sys_role.Add(collection);
rm.IsSuccess = res;
if (rm.IsSuccess)
{
rm.IsContinue = isContinue == "1";
}
}
}
catch (Exception ex)
{
rm.Message = ex.Message;
}
}
return(Json(rm));
}
public dynamic DelectRole(sys_role data)
{
if (roleFactory.CreatRoleService().DelectRole(data))
{
return "OK";
}
return "FAIL";
}
public JsonResult Add(sys_role one)
{
one.id = Guid.NewGuid().ToString();
bool add = _bll.Insert(one);
CRUDModel cm = CRUDModelHelper.GetRes(CRUD.ADD, add);
return(Json(cm, JsonRequestBehavior.AllowGet));
}
public void InsertRoleData(sys_role dto)
{
dto.role_code = dto.role_code ?? string.Empty;
dto.id = IdWorkerHelper.NewId();
dto.create_person = UserCookie.AccountName;
dto.create_time = DateTime.Now;
_sysroleRepository.Insert(dto);
}
/// <summary>
/// 添加用户的界面
/// </summary>
/// <returns></returns>
public ActionResult Add()
{
sys_role one = new sys_role {
createtime = DateTime.Now
};
return(View(one));
}
public MsgModel UpdateRole(sys_role sys_role)
{
if (!_baseSysRoleService.Update(sys_role))
{
return(MsgModel.Fail("角色更新失败！"));
}
return(MsgModel.Success("角色更新成功！"));
}
/// <summary>
/// 新增
/// </summary>
/// <param name="dto"></param>
public void InsertRoleData(sys_role dto, LoginUserDto UserCookie)
{
dto.role_code = dto.role_code ?? string.Empty;
dto.id = IdWorkerHelper.NewId();
dto.create_person = UserCookie.AccountName;
dto.create_time = DateTime.Now;
Sqldb.Insert(dto).ExecuteAffrows();
}
public void InsertRoleData(sys_role dto)
{
dto.role_code = dto.role_code ?? string.Empty;
dto.id = IdWorkerHelper.NewId();
dto.create_person = UserCookie.AccountName;
dto.create_time = DateTime.Now;
Sqldb.Insertable(dto).ExecuteCommand();
}
/// <summary>
/// 角色管理：更新角色的禁用状态
/// </summary>
/// <param name="id"></param>
/// <param name="status"></param>
public MsgModel UpdateStatus(int id, bool status)
{
sys_role sys_role = _baseSysRoleService.GetModels(a => a.id == id).SingleOrDefault();
sys_role.status = status;
bool result = _baseSysRoleService.Update(sys_role);
return(result ? MsgModel.Success("角色禁用状态更新成功！") : MsgModel.Fail("角色禁用状态更新失败！"));
}
public void UpdateRoleData(sys_role dto)
{
sys_role sys_role = _sysroleRepository.GetById(dto.id);
dto.role_code = dto.role_code ?? string.Empty;
dto.create_person = sys_role.create_person ?? string.Empty;
dto.create_time = sys_role.create_time;
_sysroleRepository.Update(dto);
}
//订单管理 134
//餐桌管理 137
//桌位结算 159
//菜品管理 133
//营业详情 144
//商户设置 147
//员工管理 148
//会员管理 150
public void SavePosition(int posId, string posName, List <int> rightList)
{
try
{
DianDianEntities db = new DianDianEntities();
var pos = db.sys_role.Find(posId);
if (pos == null)
{
pos = new sys_role();
pos.rolename = posName;
pos.createtime = DateTime.Now.ToString();
pos.isdel = "0";
pos.state = "1";
pos.shopkey = Properties.Settings.Default.shopkey;
db.sys_role.Add(pos);
}
else
{
pos.rolename = posName;
db.sys_role.Attach(pos);
var stateEntity = ((IObjectContextAdapter)db).ObjectContext.ObjectStateManager.GetObjectStateEntry(pos);
stateEntity.SetModifiedProperty("rolename");
}
var delList = db.sys_right.Where(p => p.sysroleid == pos.sysroleid & !rightList.Contains(p.menuid.Value)).ToList();
foreach (var item in delList)
{
db.sys_right.Attach(item);
db.sys_right.Remove(item);
}
db.SaveChanges();
foreach (int menuId in rightList)
{
var item = db.sys_right.Where(p => p.menuid == menuId && p.sysroleid == pos.sysroleid).FirstOrDefault();
if (item == null)
{
item = new sys_right();
item.menuid = menuId;
item.sysroleid = Convert.ToInt32(pos.sysroleid);
item.userid = 1000;
item.type = "menu1";
item.optime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
db.sys_right.Add(item);
}
}
db.SaveChanges();
}
catch (Exception e)
{
log.Error("SavePosition error. msg=" + e.Message);
throw;
}
}
/// <summary>
/// 编辑
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ActionResult Edit(int id)
{
sys_role dpt = BusinessContext.sys_role.Get(Query <sys_role> .EQ(t => t.Rid, id));
if (dpt == null)
{
return(HttpNotFound());
}
return(View(dpt));
}
/// <summary>
/// 明细
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ActionResult Details(int id = 0)
{
sys_role sys_role = BusinessContext.sys_role.GetModel(id); //db.sys_role.Single(s => s.TblRcdId == id);
if (sys_role == null)
{
return(HttpNotFound());
}
return(View(sys_role));
}
/// <summary>
/// 编辑
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ActionResult Edit(int id)
{
sys_role dpt = BusinessContext.sys_role.GetModel(id);
if (dpt == null)
{
return(HttpNotFound());
}
return(View(dpt));
}
/// <summary>
/// 明细
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ActionResult Details(int id = 0)
{
sys_role sys_role = BusinessContext.sys_role.Get(Query <sys_role> .EQ(t => t.Rid, id)); //db.sys_role.Single(s => s.Rid == id);
if (sys_role == null)
{
return(HttpNotFound());
}
return(View(sys_role));
}
public HttpResponseMessage UpdateRoleStatus(int ID, int Status)
{
sys_role role = db.Sys_roleRepository.Find(ID);
role.Status = Status;
db.Sys_roleRepository.Update(role, new string[] { "Status" });
db.Save();
var res = new { Result = "OK" };
return(new Models.JsonpResultAPI <object>(res));
}
public HttpResponseMessage UpdateRoleInfo(string name, int id)
{
sys_role role = db.Sys_roleRepository.Find(id);
role.RoleName = name;
db.Sys_roleRepository.Update(role, new string[] { "RoleName" });
db.Save();
var res = new { Result = "OK" };
return(new Models.JsonpResultAPI <object>(res));
}
/// <summary>
/// 角色管理分页
/// </summary>
/// <param name="PageIndex">当前页</param>
/// <param name="PageSize">每页显示数量</param>
/// <returns></returns>
public PageModel <sys_role> RolePage(int PageIndex, int PageSize, sys_role model)
{
using (var db = SqlSugarDB.MasterDB)
{
int totalNumber = 0;
var list = db.Queryable <sys_role>().Where(a => a.IsDeleted == false)
.WhereIF(!string.IsNullOrEmpty(model.FullName), a => a.FullName.Contains(model.FullName))
.ToPageList(PageIndex, PageSize, ref totalNumber);
return(GetPageInfo <sys_role>(PageIndex, PageSize, list, totalNumber));
}
}
public async Task <IActionResult> Create([Bind("id,rolename")] sys_role sys_role)
{
if (ModelState.IsValid)
{
_context.Add(sys_role);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(sys_role));
}
//新增修改
public IActionResult Create(string KeyId)
{
sys_role model = null;
if (!string.IsNullOrEmpty(KeyId))
{
model = bll.GetModelById <sys_role>(KeyId);
}
model = model ?? new sys_role();
return(View(model));
}
public void modifyrole()
{
RoleService rs = new RoleService();
sys_role role = new sys_role()
{
id = 1,
title = "sysadmin",
status = 1
};
rs.Modify(role);
}
public ActionResult Grid1_Delete(JArray selectedRows, JArray Grid1_fields)
{
foreach (string rowId in selectedRows)
{
sys_role role = db.sys_role.Find(Convert.ToInt32(rowId));
db.sys_role.Remove(role);
}
db.SaveChanges();
UpdateGrid(Grid1_fields);
return(UIHelper.Result());
}
/// <summary>
/// 新增角色
/// </summary>
/// <param name="role"></param>
/// <returns></returns>
public dynamic AddRole(sys_role role)
{
try
{
db.BeginTransaction();
// var sql = String.Format(@"insert sys_role(RoleName,Description) values (@0,@1) ");
// int result = (int)db.Insert("sys_role", "role.RoleName,", role.RoleName, role.Description);
int result = (int)db.Insert("sys_role", "RoleID", role);
var sql1=String.Format(@"INSERT sys_roleMenuMap(RoleID,MenuID,isEnble) values (@0,1,1),(@1,2,1),(@2,3,1),(@3,4,1)
,(@4,5,1),(@5,6,1),(@6,7,1),(@7,8,1),,(@7,9,1)");
db.Execute(sql1, result, result, result, result, result, result, result, result);
db.CompleteTransaction();
return true;
}
catch (Exception)
{
return false;
}
return false;
}
/// <summary>
/// 修改角色信息
/// </summary>
/// <param name="role"></param>
/// <returns></returns>
public dynamic ModifyRole(sys_role role)
{
try
{
db.BeginTransaction();
var sql = String.Format(@"update sys_role set RoleName=@0 , Description=@1 where RoleID=@2 ");
var result = db.Execute(sql, role.RoleName,role.Description,role.RoleID);
db.CompleteTransaction();
return true;
}
catch (Exception)
{
return false;
}
return false;
}
/// <summary>
/// 删除角色
/// </summary>
/// <param name="role"></param>
/// <returns></returns>
public dynamic DelectRole(sys_role role)
{
try
{
db.BeginTransaction();
var sql = String.Format(@"delete from sys_role where RoleID=@0 ");
var result = db.Execute(sql, role.RoleID);
db.CompleteTransaction();
return true;
}
catch (Exception)
{
return false;
}
return false;
}
