everlight.eap/backend/DllEapBll/OFILM/ReportlogicController.cs

using Cksoft.Data;
using Cksoft.Data.Repository;
using Cksoft.Unity;
using Cksoft.Unity.Log4NetConfig;
using DllEapDal.OFILM;
using DllEapEntity;
using DllEapEntity.Dtos;
using DllEapEntity.OFILM;
using Microsoft.AspNetCore.Hosting;
using Microsoft.AspNetCore.Mvc;
using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Text;


namespace DllEapBll.OFILM
{
    [Route("eap/api/[controller]/[action]")]
    public class ReportlogicController : ControllerBase
    {

        public ReportlogicController()
        {
        }
        [HttpGet]
        public LayuiModel<Reportlogic> Get(string filter, int pageIndex = 1, int pageSize = 10, string sortField = "Classes", 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 ReportlogicDal(db);
                string errorinfo = string.Empty;
                var roles = dal.Get(start, pageSize, sortOrder, sortField, filter, errorinfo);
                var total = dal.GetCount(filter);
                return new LayuiModel<Reportlogic>
                {
                    code = 1,
                    count = total,
                    data = roles,
                    msg = ""
                };
            }
        }

        //[HttpGet]
        //public Reportlogic GetSingle(int id)
        //{
        //    using (IDatabase db = DbFactory.Base("eapslave"))
        //    {
        //        var dal = new ReportlogicDal(db);
        //        return dal.Get(id);
        //    }
        //}
        [HttpGet]
        public Reportlogic GetSingle(string pageName)
        {
            using (IDatabase db = DbFactory.Base("eapslave"))
            {
                var dal = new ReportlogicDal(db);
                string errorinfo = "";
                return dal.GetSingle(pageName, errorinfo);
            }
        }
        [HttpPost]
        public EapResponse Add([FromBody] Reportlogic programMst)
        {
            string usercode = Request.Headers["usercode"];
            using (IDatabase db = DbFactory.Base("eap"))
            {
                db.BeginTrans();
                var dal = new ReportlogicDal(db);
                string errorinfo = string.Empty;
                var model= dal.GetSingle(programMst.pageName, errorinfo);
                var response = new EapResponse() { Code = 1, Msg = string.Empty };
                int id = -1;
                if (model!=null)
                {
                    id = dal.Update(programMst, usercode, ref errorinfo);
                    
                }
                else
                {
                    id = dal.Add(programMst, usercode, ref errorinfo);
                }
                if (id < 0)
                {
                    db.Rollback();
                    response.Code = -1;
                    response.Msg = errorinfo;
                }
                else
                {
                    db.Commit();
                    if (programMst.ID == 0)
                    {
                        LogHelper<WorkingProcedure>.LogFatal("新增WorkProcedure-->" + Json.ToJson(programMst), "用户操作", usercode);
                    }
                    else
                        LogHelper<WorkingProcedure>.LogFatal("修改WorkProcedure-->" + Json.ToJson(programMst), "用户操作", usercode);
                }
                response.Id = id;
                return response;
            }

        }
    }
}