public MsgResult RemoveUserToGroup(string groupId, string userId)
{
MsgResult msg = new MsgResult();
using (ISession session = DbUtils.GetSession())
{
using (ITransaction tx = session.BeginTransaction())
{
try
{
Group group = session.Get <Group>(groupId);
for (int i = 0; i < group.Users.Count; i++)
{
if (group.Users[i].Id == userId)
{
group.Users.Remove(group.Users[i]);
}
}
session.Save(group);
tx.Commit();
msg.Status = StatusEnum.SUCCESS;
msg.Obj = "移除成功";
return(msg);
}
catch (Exception ex)
{
tx.Rollback();
throw ex;
}
}
}
}
public MsgResult RemoveGroupToRole(string roleId, string groupId)
{
MsgResult msg = new MsgResult();
using (ISession session = DbUtils.GetSession())
{
using (ITransaction tx = session.BeginTransaction())
{
try
{
Role role = session.Get <Role>(roleId);
for (int i = 0; i < role.Groups.Count; i++)
{
if (role.Groups[i].Id == groupId)
{
role.Groups.Remove(role.Groups[i]);
}
}
session.Save(role);
tx.Commit();
msg.Status = StatusEnum.SUCCESS;
msg.Obj = "移除成功";
return(msg);
}
catch (Exception ex)
{
tx.Rollback();
throw ex;
}
}
}
}
public MsgResult DeleteGroup(string groupId)
{
MsgResult msg = new MsgResult();
using (ISession session = DbUtils.GetSession())
{
using (ITransaction tx = session.BeginTransaction())
{
try
{
Group group = session.Get <Group>(groupId);
if (group.Users.Count > 0)
{
msg.Status = StatusEnum.FAILURE;
msg.Obj = "有关联的用户，不能删除。";
return(msg);
}
session.Delete(group);
tx.Commit();
msg.Status = StatusEnum.SUCCESS;
msg.Obj = "删除成功";
return(msg);
}
catch (Exception ex)
{
tx.Rollback();
throw ex;
}
}
}
}
public object DeletePremItem(string premId)
{
MsgResult msg = new MsgResult();
using (ISession session = DbUtils.GetSession())
{
using (ITransaction tx = session.BeginTransaction())
{
try
{
Prem prem = session.Get <Prem>(premId);
session.Delete(prem);
tx.Commit();
msg.Status = StatusEnum.SUCCESS;
msg.Obj = "删除成功";
return(msg);
}
catch (Exception ex)
{
tx.Rollback();
throw ex;
}
}
}
}
public MsgResult DeleteUser(string userId)
{
MsgResult msg = new MsgResult();
using (ISession session = DbUtils.GetSession())
{
using (ITransaction tx = session.BeginTransaction())
{
try
{
User user = session.Get <User>(userId);
session.Delete(user);
tx.Commit();
msg.Status = StatusEnum.SUCCESS;
msg.Obj = "删除成功";
return(msg);
}
catch (Exception ex)
{
tx.Rollback();
throw ex;
}
}
}
}
public MsgResult SaveGroupToUser(string userId, string groupIds)
{
MsgResult msg = new MsgResult();
using (ISession session = DbUtils.GetSession())
{
using (ITransaction tx = session.BeginTransaction())
{
try
{
User user = session.Get <User>(userId);
user.Groups.Clear();
foreach (string groupId in groupIds.Split(','))
{
Group group = session.Get <Group>(groupId);
user.Groups.Add(group);
}
session.Save(user);
tx.Commit();
msg.Status = StatusEnum.SUCCESS;
msg.Obj = "修改成功";
return(msg);
}
catch (Exception ex)
{
tx.Rollback();
throw ex;
}
}
}
}
public MsgResult SaveRoleToGroup(string groupId, string roleIds)
{
MsgResult msg = new MsgResult();
using (ISession session = DbUtils.GetSession())
{
using (ITransaction tx = session.BeginTransaction())
{
try
{
Group group = session.Get <Group>(groupId);
group.Roles.Clear();
foreach (string roleId in roleIds.Split(','))
{
Role role = session.Get <Role>(roleId);
group.Roles.Add(role);
}
session.Save(group);
tx.Commit();
msg.Status = StatusEnum.SUCCESS;
msg.Obj = "修改成功";
return(msg);
}
catch (Exception ex)
{
tx.Rollback();
throw ex;
}
}
}
}
public async Task <JsonResult> UpdateProducts(ProductDto model)
{
try
{
var res = await _manager.EditProduct(model);
if (res == 1)
{
_msg = new MsgResult
{
Info = "修改成功",
IsSuccess = true
};
}
else
{
_msg = new MsgResult
{
Info = "修改失败",
IsSuccess = false
};
}
}
catch (Exception e)
{
LogHelper log = new LogHelper(typeof(ProductController));
log.Error("修改商品错误", e);
}
return(Json(_msg));
}
/// <summary>
/// 根据Id获取节点数据
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public MsgResult GetMenuTreeNodeById(int id = 0)
{
MsgResult result = new MsgResult();
SysMenus menu = new SysMenus();
try
{
if (id <= 0)
{
result.IsSuccess = false;
result.Message = "传递参数错误";
}
else
{
var node = SysMenuDal.GetModels(x => x.IsDeleted == false & x.Id == id).FirstOrDefault();
var parentNode = SysMenuDal.GetModels(x => x.IsDeleted == false & x.Id == node.ParentId).FirstOrDefault();
menu = Mapper.Map <SysMenus>(node);
menu.ParentName = parentNode.MenuName;
result.IsSuccess = true;
result.Data = JsonConvert.SerializeObject(menu);
}
}
catch (Exception ex)
{
result.IsSuccess = false;
result.Message = ex.Message;
logger.Error(ex.Message);
}
return(result);
}
public IActionResult GetH3COasisTableInfo()
{
var msg = new MsgResult();
msg.data = _h3CService.H3COasisTableInfo();
ReqOasisTableInfo req = Request.Method.ToLower() == "post" ? this.GetRequest <ReqOasisTableInfo>().Result : new ReqOasisTableInfo()
{
year = Request.Query["year"],
quarter = Request.Query["quarter"],
productLine = Request.Query["productLine"],
office = Request.Query["office"],
isDownload = Request.Query["isDownload"]
};
if (Request.Method.ToLower() == "post")
{
return(ReJson(msg));
}
else
{
var filepath = "C:\\Users\\HowieZhan\\Desktop\\图标.xls";
using (var sw = new FileStream(filepath, FileMode.Open))
{
var bytes = new byte[sw.Length];
sw.Read(bytes, 0, bytes.Length);
sw.Close();
return(new FileContentResult(bytes, "application/vnd.ms-excel"));
}
}
}
/// <summary>
/// 勾选商品
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
public string Do_ChoseGoods(BaseApi baseApi)
{
MsgResult msg = new MsgResult();
ChoseGoodsParam choseGoodsParam = JsonConvert.DeserializeObject <ChoseGoodsParam>(baseApi.param.ToString());
if (choseGoodsParam.goodsId == "" || choseGoodsParam.goodsId == null)
{
throw new ApiException(CodeMessage.InvalidGoodsIdCode, "InvalidGoodsIdCode");
}
string shopId = Util.GetUserShopId(baseApi.token);
ActiveDao activeDao = new ActiveDao();
if (choseGoodsParam.type)
{
if (!activeDao.InsertActiveGoods(shopId, choseGoodsParam))
{
throw new ApiException(CodeMessage.DBAddError, "DBAddError");
}
}
else
{
if (!activeDao.DeleteActiveGoods(shopId, choseGoodsParam))
{
throw new ApiException(CodeMessage.DBDelError, "DBDelError");
}
}
return("");
}
public IActionResult GetServerInfo()
{
var msg = new MsgResult();
msg.data = ComputerHelper.GetComputerInfo();
return(ReJson(msg));
}
/// <summary>
/// 跟新实体部分字段
/// </summary>
/// <param name="entity">实体</param>
/// <param name="fieldNames">跟新字段集合</param>
/// <returns></returns>
public MsgResult UpdateEntityFields(T entity, List <string> fieldNames)
{
MsgResult result = new MsgResult();
try
{
BaseDal.UpdateEntityFields(entity, fieldNames);
BaseDal.SaveChanges();
result.IsSuccess = true;
result.Message = "修改成功";
}
catch (DbEntityValidationException ex)
{
StringBuilder sb = new StringBuilder();
foreach (var ve in ex.EntityValidationErrors.SelectMany(eve => eve.ValidationErrors))
{
sb.AppendLine(ve.PropertyName + ":" + ve.ErrorMessage);
}
result.IsSuccess = false;
result.Message = "修改失败：" + sb.ToString();
}
catch (Exception ex)
{
result.IsSuccess = false;
result.Message = "修改失败：" + ex.Message;
}
return(result);
}
public MsgResult SavePremToUser(string userId, string premIds)
{
MsgResult msg = new MsgResult();
using (ISession session = DbUtils.GetSession())
{
using (ITransaction tx = session.BeginTransaction())
{
try
{
User user = session.Get <User>(userId);
user.Menus.Clear();
foreach (string menuId in premIds.Split(','))
{
Menu menu = session.Get <Menu>(menuId);
user.Menus.Add(menu);
}
session.Save(user);
tx.Commit();
msg.Status = StatusEnum.SUCCESS;
msg.Obj = "修改成功";
return(msg);
}
catch (Exception ex)
{
tx.Rollback();
throw ex;
}
}
}
}
public override void OnAuthorization(AuthorizationContext filterContext)
{
string userId = (string)filterContext.HttpContext.Session["LoginUserId"];
if (userId == null)
{
if (filterContext.HttpContext.Request.IsAjaxRequest())
{
MsgResult result = new MsgResult();
result.IsSuccess = false;
result.Data = "/login/index";
result.Message = "没有登录";
result.MsgCode = 10001;
filterContext.Result = new JsonResult()
{
Data = result
};
}
else
{
filterContext.Result = new RedirectResult("/Main/Login");
}
}
else
{
//1 ,判断角色，获取所有的权限
//2 , 判断是否包含当前的权限
}
}
/// <summary>
/// 标记删除节点
/// </summary>
/// <param name="node"></param>
/// <returns></returns>
public MsgResult MarkDeleteNode(SysMenus node)
{
MsgResult result = new MsgResult();
T_SysMenus menuEntity = new T_SysMenus();
try
{
menuEntity = Mapper.Map <T_SysMenus>(node);
menuEntity.IsDeleted = true;
SysMenuDal.MarkDelete(menuEntity);
SysMenuDal.SaveChanges();
CacheHelper.RemoveCache("menuList");
result.IsSuccess = true;
result.Message = "删除数据成功";
}
catch (DbEntityValidationException ex)
{
StringBuilder sb = new StringBuilder();
foreach (var ve in ex.EntityValidationErrors.SelectMany(eve => eve.ValidationErrors))
{
sb.AppendLine(ve.PropertyName + ":" + ve.ErrorMessage);
}
result.IsSuccess = false;
result.Message = "删除数据失败：" + sb.ToString();
}
catch (Exception ex)
{
result.IsSuccess = false;
result.Message = "删除数据失败：" + ex.Message;
}
return(result);
}
/// <summary>
/// 根据菜单节点获取子菜单数据
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public MsgResult GetMenuTreeChildNodeListById(int id = 0)
{
MsgResult result = new MsgResult();
List <SysMenus> list = new List <SysMenus>();
SysMenus menu = new SysMenus();
try
{
if (id <= 0)
{
result.IsSuccess = false;
result.Message = "传递参数错误";
}
else
{
var parentNode = SysMenuDal.GetModels(x => x.IsDeleted == false & x.Id == id).FirstOrDefault();
var model = SysMenuDal.GetModels(x => x.IsDeleted == false && x.ParentId == id).ToList();
//注意mapper 需要在查询出结果之后再使用，不能加入EF的表达式树中进行计算
list = model.Select(x => Mapper.Map <SysMenus>(x)).ToList();
list.ForEach(x => x.ParentName = parentNode.MenuName);
result.IsSuccess = true;
result.Data = JsonConvert.SerializeObject(list);
}
}
catch (Exception ex)
{
result.IsSuccess = false;
result.Message = ex.Message;
logger.Error(ex.Message);
}
return(result);
}
/// <summary>
/// 跟新菜单节点
/// </summary>
/// <param name="node"></param>
/// <returns></returns>
public MsgResult UpdateMenuNode(SysMenus node)
{
MsgResult result = new MsgResult();
T_SysMenus menuEntity = new T_SysMenus();
try
{
menuEntity = Mapper.Map <T_SysMenus>(node);
SysMenuDal.UpdateEntityFields(menuEntity, new List <string> {
"MenuName", "MenuUrl", "SortNum"
});
SysMenuDal.SaveChanges();
CacheHelper.RemoveCache("menuList");
result.IsSuccess = true;
result.Message = "跟新数据成功";
}
catch (DbEntityValidationException ex)
{
StringBuilder sb = new StringBuilder();
foreach (var ve in ex.EntityValidationErrors.SelectMany(eve => eve.ValidationErrors))
{
sb.AppendLine(ve.PropertyName + ":" + ve.ErrorMessage);
}
result.IsSuccess = false;
result.Message = "跟新失败：" + sb.ToString();
}
catch (Exception ex)
{
result.IsSuccess = false;
result.Message = "跟新失败：" + ex.Message;
}
return(result);
}
/// <summary>
/// 增加菜单节点
/// </summary>
/// <param name="node"></param>
/// <returns></returns>
public MsgResult AddMenuNode(SysMenus node)
{
MsgResult result = new MsgResult();
T_SysMenus entity = new T_SysMenus();
try
{
entity = Mapper.Map <T_SysMenus>(node);
entity.Guid = Guid.NewGuid().ToString("N");
entity.CreateUser = 1;
entity.CreateTime = DateTime.Now;
SysMenuDal.Add(entity);
SysMenuDal.SaveChanges();
CacheHelper.RemoveCache("menuList");
result.IsSuccess = true;
result.Message = "增加成功";
}
catch (DbEntityValidationException ex)
{
StringBuilder sb = new StringBuilder();
foreach (var ve in ex.EntityValidationErrors.SelectMany(eve => eve.ValidationErrors))
{
sb.AppendLine(ve.PropertyName + ":" + ve.ErrorMessage);
}
result.IsSuccess = false;
result.Message = "增加失败：" + sb.ToString();
}
catch (Exception ex)
{
result.IsSuccess = false;
result.Message = "增加失败：" + ex.Message;
}
return(result);
}
public MsgResult SaveGroup(Group group)
{
using (ISession session = DbUtils.GetSession())
{
using (ITransaction tx = session.BeginTransaction())
{
try
{
MsgResult msg = new MsgResult();
msg.Status = StatusEnum.SUCCESS;
if (string.IsNullOrEmpty(group.Id))
{
group.Id = Guid.NewGuid().ToString();
group.CreateDate = DateTime.Now;
session.Save(group);
msg.Obj = "添加成功";
}
else
{
Group oldGroup = session.Get <Group>(group.Id);
oldGroup.Name = group.Name;
session.Update(oldGroup);
msg.Obj = "修改成功";
}
tx.Commit();
return(msg);
}
catch (Exception ex)
{
tx.Rollback();
throw ex;
}
}
}
}
public async Task <JsonResult> UpdateProductState(string id, bool state)
{
try
{
_msg = new MsgResult();
var result = await _manager.EditCategoryState(Guid.Parse(id), state);
switch (result)
{
case 1:
_msg.IsSuccess = true;
_msg.Info = "修改状态成功";
break;
default:
_msg.IsSuccess = false;
_msg.Info = "修改状态失败";
break;
}
}
catch (Exception e)
{
LogHelper log = new LogHelper(typeof(ProductCategoryController));
log.Error("修改一级商品类别错误", e);
}
return(Json(_msg));
}
/// <summary>
/// 清空表的数据
/// </summary>
/// <param name="tableName"></param>
/// <returns></returns>
public MsgResult Clear(string tableName)
{
MsgResult result = new MsgResult();
try
{
int count = BaseDal.Clear(tableName);
if (count > 0)
{
result.IsSuccess = true;
result.Message = "清除" + tableName + "成功";
}
else
{
result.IsSuccess = false;
result.Message = "清除" + tableName + "失败";
}
}
catch (Exception ex)
{
result.IsSuccess = false;
result.Message = "清除" + tableName + "失败" + ex.Message;
}
return(result);
}
public async Task <JsonResult> AddFirstCategory(string categoryName)
{
_msg = new MsgResult();
try
{
var result = await _manager.AddCategory(categoryName);
if (result == 1)
{
_msg.IsSuccess = true;
_msg.Info = "添加成功";
}
else
{
_msg.IsSuccess = false;
_msg.Info = "添加失败";
}
}
catch (Exception e)
{
_log.Error("添加以及商品分类错误", e);
}
return(Json(_msg));
}
/// <summary>
/// 增加实体
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public MsgResult AddEntity(T entity)
{
MsgResult result = new MsgResult();
try
{
T t = BaseDal.Add(entity);
BaseDal.SaveChanges();
result.IsSuccess = true;
result.Message = "增加成功";
result.Data = JsonConvert.SerializeObject(t);
}
catch (DbEntityValidationException ex)
{
StringBuilder sb = new StringBuilder();
foreach (var ve in ex.EntityValidationErrors.SelectMany(eve => eve.ValidationErrors))
{
sb.AppendLine(ve.PropertyName + ":" + ve.ErrorMessage);
}
result.IsSuccess = false;
result.Message = "增加失败：" + sb.ToString();
}
catch (Exception ex)
{
result.IsSuccess = false;
result.Message = "增加失败：" + ex.Message + " " + ex.InnerException.Message;
}
return(result);
}
/// <summary>
/// 获取用户的菜单
/// </summary>
/// <param name="userId"></param>
/// <returns></returns>
public MsgResult GetSysMenusByUserId(int userId)
{
MsgResult result = new MsgResult();
try
{
List <T_SysMenus> list = SysMenusDal.GetSysMenusByUserId(userId);
if (list.Count <= 0)
{
result.IsSuccess = false;
result.Message = "当前用户未分配菜单";
}
else
{
List <SysMenu> menuList = list.Select(x => Mapper.Map <SysMenu>(x)).ToList();
result.IsSuccess = true;
result.Data = JsonConvert.SerializeObject(menuList);
}
}
catch (Exception ex)
{
result.IsSuccess = false;
result.Message = ex.Message;
//Logger.Error(ex.Message);
}
return(result);
}
/// <summary>
/// 获取所有的菜单树节点
/// </summary>
/// <returns></returns>
public MsgResult GetZtreeNodeByUserId()
{
MsgResult result = new MsgResult();
try
{
List <ZtreeNode> nodeList = new List <ZtreeNode>();
List <T_SysMenus> sysMenus = SysMenusDal.GetModel(x => x.Id >= 0).ToList();
for (int i = 0; i < sysMenus.Count; i++)
{
ZtreeNode node = new ZtreeNode();
node.Id = sysMenus[i].Id;
node.Name = sysMenus[i].MenuName;
node.Pid = sysMenus[i].ParentId;
nodeList.Add(node);
}
result.IsSuccess = true;
result.Data = JsonConvert.SerializeObject(nodeList);
}
catch (Exception ex)
{
result.IsSuccess = false;
result.Message = ex.Message;
}
return(result);
}
/// <summary>
/// 获取点击菜单节点详情数据
/// </summary>
/// <returns></returns>
public MsgResult GetZtreeNodeDetailById(int id)
{
MsgResult result = new MsgResult();
try
{
var node = SysMenusDal.GetModel(x => x.Id == id).FirstOrDefault();
List <SysMenu> list = new List <SysMenu>();
if (node != null)
{
if (node.IsLeaf)
{
var parent = SysMenusDal.GetModel(x => x.Id == node.ParentId).FirstOrDefault();
list = SysMenusDal.GetModel(x => x.ParentId == node.ParentId).ToList().Select(x => Mapper.Map <SysMenu>(x)).ToList();
list.ForEach(x => x.ParentName = parent.MenuName);
}
else
{
SysMenu menu = Mapper.Map <SysMenu>(node);
list.Add(menu);
list.ForEach(x => x.ParentName = "");
}
result.IsSuccess = true;
result.Data = JsonConvert.SerializeObject(list);
}
}
catch (Exception ex)
{
result.IsSuccess = false;
result.Message = ex.Message;
}
return(result);
}
private void RpairCom_Click(object sender, RoutedEventArgs e)
{
EquipmentClass _Eclass = new EquipmentClass();
var a = this.repair_Grid.SelectedItem;
var b = a as DataRowView;
int _Eid = Convert.ToInt32(b.Row[0]);
MsgResult r = JXMessageBox.Show(this, "您需要对此设备申请入库？", "提示", MsgButton.Yes_No_Cancel, MsgImage.Exclamation);
//MessageBox.Show(r.ToString());
if (r == MsgResult.OK)
{
int state = _Eclass.repairEquipmentComing(_Eid);
if (state == BaseRequest.SUCCESS)
{
DataSet set = _Eclass.getRepairEquipmentList();
this.page.ShowPages(this.repair_Grid, set, BaseRequest.PAGE_SIZE);
JXMessageBox.Show(this, "申请出库成功", MsgImage.Success);
NewEquipment newEquipment = DeviceMigrationsFactory.NewEquipment;
DataSet deliverySet = _Eclass.comingEquipment();
newEquipment.page.ShowPages(newEquipment.comingGrild, deliverySet, BaseRequest.PAGE_SIZE);
}
else
{
JXMessageBox.Show(this, "操作失败!系统异常，请联系管理员!", MsgImage.Error);
}
}
}
public async Task <JsonResult> UpdateAdminState(string stateId, string adminId)
{
try
{
_msg = new MsgResult();
var result = await _manager.UpdateAdminState(stateId, Guid.Parse(adminId));
if (result == 1)
{
_msg.IsSuccess = true;
_msg.Info = "操作成功";
}
else
{
_msg.IsSuccess = false;
_msg.Info = "error";
}
}
catch (Exception e)
{
LogHelper log = new LogHelper(typeof(AdminController));
log.Error("修改管理员状态错误信息", new Exception(e.Message));
}
return(Json(_msg, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 批量增加实体
/// </summary>
/// <param name="list"></param>
/// <returns></returns>
public MsgResult AddRange(List <T> list)
{
MsgResult result = new MsgResult();
try
{
BaseDal.AddRange(list);
BaseDal.SaveChanges();
result.IsSuccess = true;
result.Message = "批量增加数据成功";
}
catch (DbEntityValidationException ex)
{
StringBuilder sb = new StringBuilder();
foreach (var ve in ex.EntityValidationErrors.SelectMany(eve => eve.ValidationErrors))
{
sb.AppendLine(ve.PropertyName + ":" + ve.ErrorMessage);
}
result.IsSuccess = false;
result.Message = "批量增加数据失败：" + sb.ToString();
}
catch (Exception ex)
{
result.IsSuccess = false;
result.Message = "批量增加数据失败：" + ex.Message;
}
return(result);
}
private void btnCancel_Click(object sender, RoutedEventArgs e)
{
this.msgResult = MsgResult.Cancel;
this.Close();
}
public MsgBox.MsgResult UserMsgBox(MsgTypes msgType, MsgButtons msgButtons, MsgResult defaultMsgResult, string msg)
{
return UserMsgBox(SharedObjects.MainWin, msgType, msgButtons, defaultMsgResult, msg);
}
private void btnNo_Click(object sender, RoutedEventArgs e)
{
this.msgResult = MsgResult.No;
this.Close();
}
