123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252 |
- using System;
- using System.Collections.Generic;
- using System.Linq;
- using System.Web;
- using System.Web.Mvc;
- using Central.Control.Domain;
- using System.Collections;
- using MES.Production.Service.IService;
- using Ant.Service.Common;
- using System.Linq.Expressions;
- using Ant.Service.Common.Enums;
- using ChangFa.Machinery.WebPage.Controllers;
- using MES.Production.Entity.Entity;
- using MES.Production.Entity.Extensions;
- using Ant.Service.Utility;
- namespace ChangFa.Machinery.WebPage.Areas.SysManage.Controllers
- {
- /// <summary>
- /// 控制器描述:对岗位信息的CURD管理
- /// 创建标识:add by 季健国 2013-8-2 10:20
- /// </summary>
- public class DeviceSetController : BaseController
- {
- #region 基本视图
- /// <summary>
- /// 加载列表
- /// </summary>
- /// <returns></returns>
- [UserAuthorizeAttribute(ModuleAlias = "DeviceSet", OperaAction = "View")]
- public ActionResult Index()
- {
- try
- {
- #region 处理查询参数
- #endregion
- #region 加载列表
- var result = BindList();
- ViewBag.Search = base.keywords;
- #endregion
- return View(result);
- }
- catch (Exception e)
- {
- WriteLog(enumOperator.Select, "加载设备列表:", e);
- throw e.InnerException;
- }
- }
- /// <summary>
- /// 绑定页面需要的属性
- /// </summary>
- public PageInfo BindList()
- {
- using (Ant.ORM.AntORM orm = new Ant.ORM.AntORM())
- {
- orm.db = Ant.Data.DataAccessFactory.CreateDataConnection("CyclingItem");
- Ant.ORM.RequestModel request = new Ant.ORM.RequestModel();
- request.newSt = new Ant.ORM.SqlNote() { Author = "smj", NewSt = new System.Diagnostics.StackTrace(true), SqlDesc = "DeviceSetController-BindList" };
- var query = orm.Queryable<SYS_Device>().Where(p => p.IsDelete == 0);
- // 检索条件
- query = query.WhereIf(!string.IsNullOrEmpty(keywords), p => p.Name.Contains(keywords));
- // 分页查询
- var skipLimit = PageCollection.GetSkipLimit(base.page, base.pagesize);
- // 具体查询
- var list = query.OrderByDesc(o => o.ModifyDT).Skip(skipLimit.Item1).Top(skipLimit.Item2).ToList(request);
- // 查出总数
- var total = query.Count();
- return new PageInfo(base.page, base.pagesize, total, list.ResultModel);
- }
- }
- /// <summary>
- /// 加载详情
- /// </summary>
- /// <returns></returns>
- [HttpGet]
- [UserAuthorizeAttribute(ModuleAlias = "DeviceSet", OperaAction = "Detail")]
- public ActionResult Detail(string id)
- {
- using (Ant.ORM.AntORM orm = new Ant.ORM.AntORM())
- {
- orm.db = Ant.Data.DataAccessFactory.CreateDataConnection("CyclingItem");
- var result = orm.Queryable<SYS_Device>().Where(p => p.Id == id).FirstOrDefault();
- var _entity = result.ResultModel as SYS_Device ?? new SYS_Device();
- return View(_entity);
- }
- }
- /// <summary>
- /// 保存岗位
- /// </summary>
- [UserAuthorizeAttribute(ModuleAlias = "DeviceSet", OperaAction = "Add,Edit")]
- public ActionResult Save(SYS_Device entity)
- {
- Ant.ORM.RequestModel sqlQueryReq = new Ant.ORM.RequestModel();
- sqlQueryReq.newSt = new Ant.ORM.SqlNote() { Author = "smj", NewSt = new System.Diagnostics.StackTrace(true), SqlDesc = "DeviceSetController-Save" };
- bool isEdit = false;
- JsonHelper json = new JsonHelper() { Msg = "保存设备成功", Status = "n", ReUrl = "/DeviceSet/Index" };
- try
- {
- if (entity != null)
- {
- Ant.ORM.AntORM orm = new Ant.ORM.AntORM();
- orm.db = Ant.Data.DataAccessFactory.CreateDataConnection("CyclingItem");
- var _entity = new SYS_Device();
- //添加
- if (string.IsNullOrEmpty(entity.Id))
- {
- string id = IdGenerator.NewId();
- _entity = entity;
- _entity.Id = id;
- _entity.Password = id;
- _entity.CreateDT = DateTime.Now;
- _entity.CreateBY = CurrentUser.Id.ToString();
- _entity.ModifyDT = DateTime.Now;
- }
- else //修改
- {
- orm.db = Ant.Data.DataAccessFactory.CreateDataConnection("CyclingItem");
- var result = orm.GetEntity(entity, sqlQueryReq);
- _entity = entity;
- _entity.Name = entity.Name;
- _entity.Code = entity.Code;
- _entity.Address = entity.Address;
- _entity.ModifyDT = DateTime.Now;
- _entity.ModifyBY = CurrentUser.Id.ToString();
- isEdit = true;
- }
- //判断岗位是否重名
- var sqlQuery = orm.Queryable<SYS_Device>().Where(p => p.Code == entity.Code && p.Id != entity.Id).ToList();
- List<SYS_Device> sames = sqlQuery.ResultModel;
- if (sames?.Count > 0)
- {
- json.Msg = $"设备编码{entity.Code}已存在,不能重复添加";
- }
- else
- {
- Ant.ORM.ResponseModel saveResult = new Ant.ORM.ResponseModel();
- if (isEdit)
- {
- saveResult = orm.UpdateByLambda(_entity, p => p.Id == _entity.Id, sqlQueryReq);
- }
- else
- {
- saveResult = orm.Save(_entity, sqlQueryReq);
- }
- if (saveResult.IsSuccess)
- {
- json.Status = "y";
- }
- else
- {
- json.Msg = "保存失败";
- }
- }
- orm.Dispose();
- }
- else
- {
- json.Msg = "未找到需要保存的设备";
- }
- if (isEdit)
- {
- WriteLog(enumOperator.Edit, "修改设备,结果:" + json.Msg, enumLog4net.INFO);
- }
- else
- {
- WriteLog(enumOperator.Add, "添加设备,结果:" + json.Msg, enumLog4net.INFO);
- }
- }
- catch (Exception e)
- {
- json.Msg = "设备岗位发生内部错误!";
- WriteLog(enumOperator.None, "保存设备:", e);
- }
- return Json(json);
- }
- /// <summary>
- /// 删除岗位
- /// </summary>
- [UserAuthorizeAttribute(ModuleAlias = "DeviceSet", OperaAction = "Remove")]
- public ActionResult Delete(string idList)
- {
- JsonHelper json = new JsonHelper() { Msg = "删除设备完毕", Status = "n" };
- try
- {
- if (!string.IsNullOrEmpty(idList))
- {
- var ids = idList.Trim(',').Split(',').ToArray();
- using (Ant.ORM.AntORM orm = new Ant.ORM.AntORM())
- {
- orm.db = Ant.Data.DataAccessFactory.CreateDataConnection("CyclingItem");
- Ant.ORM.RequestModel sqlQueryReq = new Ant.ORM.RequestModel();
- sqlQueryReq.newSt = new Ant.ORM.SqlNote() { Author = "smj", NewSt = new System.Diagnostics.StackTrace(true), SqlDesc = "DeviceSetController-Delete" };
- var queryResult = orm.Queryable<SYS_Device>().Where(p => ids.Contains(p.Id)).ToList(sqlQueryReq);
- List<SYS_Device> olds = queryResult?.ResultModel;
- olds?.ForEach(item => {
- item.IsDelete = 1;
- orm.UpdateByLambda(item, p => p.Id == item.Id, sqlQueryReq);
- });
- json.Status = "y";
- }
- }
- else
- {
- json.Msg = "未找到要删除的设备记录";
- }
- WriteLog(enumOperator.Remove, "删除设备,结果:" + json.Msg, enumLog4net.WARN);
- }
- catch(Exception e)
- {
- json.Msg = "删除设备发生内部错误!";
- WriteLog(enumOperator.Remove, "删除设备:", e);
- }
- return Json(json);
- }
- /// <summary>
- /// 加载详情
- /// </summary>
- /// <returns></returns>
- [HttpGet]
- [UserAuthorizeAttribute(ModuleAlias = "DeviceSet", OperaAction = "ShowPassword")]
- public ActionResult ShowPassword(string id)
- {
- using (Ant.ORM.AntORM orm = new Ant.ORM.AntORM())
- {
- orm.db = Ant.Data.DataAccessFactory.CreateDataConnection("CyclingItem");
- var result = orm.Queryable<SYS_Device>().Where(p => p.Id == id).FirstOrDefault();
- SYS_Device _entity = result.ResultModel;
- return View(_entity);
- }
- }
- #endregion
- }
- }
|