using Cksoft.Data; using Cksoft.Data.Repository; using Cksoft.Unity; using Cksoft.Unity.Log4NetConfig; using DllEapDal; using DllEapEntity; using DllEapEntity.Dtos; using Microsoft.AspNetCore.Authorization; using Microsoft.AspNetCore.Mvc; using System; using System.Collections.Generic; using System.Text; namespace DllEapBll.Controllers { /// /// 参数明细 /// [Authorize] [ApiController] [Route("eap/api/[controller]/[action]")] public class SecDetailController : ControllerBase { /// /// 列表 /// /// /// /// /// /// /// [HttpGet] public LayuiModel Get(string filter, int pageIndex = 1, int pageSize = 10, string sortField = "ID", string sortOrder = "ascend") { if (sortOrder == "descend") { sortOrder = "desc"; } else { sortOrder = "asc"; } int start, end; start = (pageIndex - 1) * pageSize + 1; end = start + pageSize; using (IDatabase db = DbFactory.Base("eapslave")) { db.BeginTrans(); var dal = new MMSecDetailDal(db); var total = dal.GetCount(filter); string errorinfo = string.Empty; var roles = dal.Get(start, pageSize, sortOrder, sortField, filter, errorinfo); return new LayuiModel { code = 1, count = total, data = roles, msg = "" }; } } /// /// 详情 /// /// /// [HttpGet] public MMSecDetail GetSingle(int id) { using (IDatabase db = DbFactory.Base("eapslave")) { var dal = new MMSecDetailDal(db); return dal.Get(id); } } /// /// 新增/修改 /// /// /// [HttpPost] public EapResponse Add([FromBody] MMSecDetail programMst) { string usercode = Request.Headers["usercode"]; using (IDatabase db = DbFactory.Base("eap")) { db.BeginTrans(); var dal = new MMSecDetailDal(db); string errorinfo = string.Empty; var response = new EapResponse() { Code = 1, Msg = string.Empty }; int id = -1; if (programMst.ID == 0) { id = dal.Add(programMst, usercode, ref errorinfo); } else { // id = dal.Update(programMst, usercode, ref errorinfo); } if (id < 0) { db.Rollback(); response.Code = -1; response.Msg = errorinfo; } else { db.Commit(); if (programMst.ID == 0) { LogHelper.LogFatal("新增MMSecDetail-->" + Json.ToJson(programMst), "用户操作", usercode); } else LogHelper.LogFatal("修改MMSecDetail-->" + Json.ToJson(programMst), "用户操作", usercode); } response.Id = id; return response; } } /// /// 删除 /// /// /// [HttpPost] public EapResponse Delete([FromBody] int id) { if (id == 0) { return new EapResponse { Code = 1, Msg = string.Empty }; } IDatabase db = null; string errormsg = string.Empty; try { db = DbFactory.Base("eap"); var dal = new MMSecDetailDal(db); db.BeginTrans(); var model = dal.getmodelsubdetail(id); var modelsec = dal.Get(id); var res = dal.Delete(id, ref errormsg); if (res < 0) { db.Rollback(); return new EapResponse() { Code = -1, Msg = errormsg }; } db.Commit(); LogHelper.LogFatal("删除MMSecDetail-->:" + Json.ToJson(modelsec) + ";modelsubdetail" + Json.ToJson(model), "用户操作", Request.Headers["usercode"]); return new EapResponse() { Code = 1, Msg = "" }; } catch (Exception e) { errormsg = e.Message; return new EapResponse { Code = -1, Msg = errormsg }; } finally { if (db != null) db.Close(); } } } }