everlight.eap/backend/DllEapBll/Controllers/MacProgramController.cs

using DllEapEntity.Dtos;
using DllEapEntity;
using Microsoft.AspNetCore.Mvc;
using System;
using System.Collections.Generic;
using System.Text;
using Cksoft.Data;
using Cksoft.Data.Repository;
using DllEapDal;
using System.Linq;
using DllUfpDal;
using Cksoft.Unity;
using Cksoft.Unity.Log4NetConfig;
using Microsoft.AspNetCore.Authorization;
using System.Threading.Tasks;
using DllEapCommon.NPOI;
using System.IO;
using AutoMapper;

namespace DllEapBll.Controllers
{
    /// <summary>
    /// 机台程序
    /// </summary>
    [Authorize]
    [ApiController]
    [Route("eap/api/[controller]/[action]")]
    public class MacProgramController : ControllerBase
    {
        private IMapper _mapper;
        public MacProgramController(IMapper mapper)
        {

            _mapper = mapper;
        }
        /// <summary>
        /// 机台程序列表
        /// </summary>
        /// <param name="filter"></param>
        /// <param name="sort"></param>
        /// <param name="pageIndex"></param>
        /// <param name="pageSize"></param>
        /// <param name="sortField"></param>
        /// <param name="sortOrder"></param>
        /// <returns></returns>
        [HttpGet]
        public LayuiModel<MacProgram> Get(string filter, string sort, int pageIndex = 1, int pageSize = 10, string sortField = "a.version", string sortOrder = "ascend")
        {
            string userCode = Request.Headers["usercode"];
            if (!string.IsNullOrEmpty(sort))
            {
                var arr = sort.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
                if (arr != null && arr.Length > 0)
                {
                    sortField = arr[0];
                    sortOrder = arr[1];
                }
            }
            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 MacProgramDal(db, userCode);
                var total = dal.GetVersionCount(filter);
                string errorinfo = string.Empty;

                var roles = dal.Get(start, pageSize, sortOrder, sortField, filter, errorinfo);
                return new LayuiModel<MacProgram>
                {
                    code = 1,
                    count = total,
                    data = roles,
                    msg = ""
                };
            }
        }

        /// <summary>
        /// 删除程序
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        [HttpPost]
        public EapResponse Delete([FromBody] int id)
        {
            IDatabase db = null;
            string errormsg = string.Empty;
            try
            {
                db = DbFactory.Base("eap");
                var dal = new MacProgramDal(db);
                db.BeginTrans();
                var model = dal.getBusinessFile(id);
                var res = dal.Delete(id, ref errormsg);
                if (res < 0)
                {
                    db.Rollback();
                    return new EapResponse()
                    {
                        Code = -1,
                        Msg = errormsg
                    };
                }
                db.Commit();
                LogHelper<MacProgram>.LogFatal("删除MacProgram-->id：" + 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();
            }
        }

        /// <summary>
        /// 获取机台程序列表
        /// </summary>
        /// <param name="filter"></param>
        /// <param name="sort"></param>
        /// <param name="pageIndex"></param>
        /// <param name="pageSize"></param>
        /// <param name="sortField"></param>
        /// <param name="sortOrder"></param>
        /// <returns></returns>
        [HttpGet]
        public LayuiModel<MacProgramDto> GetProgramsNew(string filter, string sort, int pageIndex = 1, int pageSize = 10, string sortField = "b.FCode,programName", string sortOrder = "ascend")
        {
            string userCode = Request.Headers["usercode"];
            if (!string.IsNullOrEmpty(sort))
            {
                var arr = sort.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
                if (arr != null && arr.Length > 0)
                {
                    sortField = arr[0];
                    sortOrder = arr[1];
                }
            }
            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 MacProgramDal(db, userCode);
                var total = dal.GetGroupedCount(filter);
                string errorinfo = string.Empty;
                var roles = dal.GetGrouped(start, pageSize, sortOrder, sortField, filter, errorinfo);
                return new LayuiModel<MacProgramDto>
                {
                    code = 1,
                    count = total,
                    data = roles,
                    msg = ""
                };
            }
        }
        /// <summary>
        /// 导出机台程序列表
        /// </summary>
        /// <param name="filterInfo"></param>
        /// <returns></returns>
        [HttpPost]
        public async Task<IActionResult> ExportProgramsNew(IDictionary<string, string> filterInfo)
        {
            string filter = string.Empty, sort = string.Empty, sortField = "b.FCode,programName", sortOrder = "ascend";
            int pageIndex = 1, pageSize = 100000;
            if (filterInfo.ContainsKey("filter"))
            {
                filter = filterInfo["filter"];
            }

            if (filterInfo.ContainsKey("sortField"))
            {
                sortField = filterInfo["sortField"];
            }
            if (filterInfo.ContainsKey("sortOrder"))
            {
                sortOrder = filterInfo["sortOrder"];
            }
            if (filterInfo.ContainsKey("sort"))
            {
                sortOrder = filterInfo["sort"];
            }

            if (filterInfo.ContainsKey("pageSize") && !string.IsNullOrEmpty(filterInfo["pageSize"]))
            {
                pageSize = Convert.ToInt32(filterInfo["pageSize"]) > 0 ? Convert.ToInt32(filterInfo["pageSize"]) : pageSize;
            }
            if (filterInfo.ContainsKey("pageIndex") && !string.IsNullOrEmpty(filterInfo["pageIndex"]))
            {
                pageIndex = Convert.ToInt32(filterInfo["pageIndex"]) > 0 ? Convert.ToInt32(filterInfo["pageIndex"]) : pageIndex;
            }
            var roles = GetProgramsNew(filter, sort, pageIndex, pageSize, sortField, sortOrder).data;
            var list = _mapper.Map<IEnumerable<ExportMacProgramDto>>(roles).ToList();
            var book = DataExportHelper.EntityToExcel(list);
            MemoryStream ms = new MemoryStream();
            ms.Position = 0;
            book.Write(ms);
            ms.Dispose();
            ms.Close();
            await Task.CompletedTask;
            return File(ms.ToArray(), "application/octet-stream");
        }
       
        /// <summary>
        /// 获取程序文件名称
        /// </summary>
        /// <param name="macCode"></param>
        /// <param name="programName"></param>
        /// <returns></returns>
        [HttpGet]
        public LayuiModel<string> GetProgramFiles(string macCode, string programName)
        {
            string errorinfo = string.Empty;
            using (IDatabase db = DbFactory.Base("eapslave"))
            {
                var programdal = new MacProgramDal(db);
                var dirs = programdal.GetProgramFiles(macCode, programName, ref errorinfo);
                if (dirs != null)
                {
                    return new LayuiModel<string>()
                    {
                        code = 1,
                        count = dirs.Count(),
                        data = dirs,
                        msg = string.Empty
                    };
                }
                return new LayuiModel<string>()
                {
                    code = -1,
                    data = null,
                    msg = errorinfo
                };
            }
        }

        /// <summary>
        /// 设置默认程序
        /// </summary>
        /// <param name="valuePairs"></param>
        /// <returns></returns>
        [HttpPost]
        public EapResponse SetDefault([FromBody] IDictionary<string, string> valuePairs)
        {
            string errorinfo = string.Empty;
            string userCode = Request.Headers["usercode"];
            string btnCode = "SetDefaultProgram";
            using (IDatabase ufpDb = DbFactory.Base("ufp"))
            {
                var btnFuncDal = new BtnFuncDal(ufpDb);
                var res = btnFuncDal.IsPermitted(userCode, btnCode, ref errorinfo);
                if (!res)
                {
                    return new EapResponse
                    {
                        Code = -1,
                        Msg = errorinfo
                    };
                }
            }
            var id = Convert.ToInt32(valuePairs["id"]);
            var isDefault = Convert.ToInt32(valuePairs["isDefault"]);
            var macId = Convert.ToInt32(valuePairs["macId"]);
            var programName = valuePairs["programName"];
            using (IDatabase db = DbFactory.Base("eap"))
            {
                var dal = new MacProgramDal(db);
                var res = dal.UpdateField(id, isDefault, macId, programName, ref errorinfo);
                if (res > 0)
                {
                    LogHelper<MacProgram>.LogFatal("修改BusinessFileRelation-->" + "isDefault" + isDefault + ";id" + id, "用户操作", userCode);
                }
                var response = new EapResponse
                {
                    Code = res,
                    Msg = errorinfo
                };
                return response;
            }
        }

        /// <summary>
        /// 修改程序名
        /// </summary>
        /// <param name="valuePairs"></param>
        /// <returns></returns>
        [HttpPost]
        public EapResponse ChangeProName([FromBody] IDictionary<string, string> valuePairs)
        {
            if (valuePairs == null || valuePairs.Keys.Count == 0)
                return null;
            var macCode = valuePairs["macCode"];
            var oldName = valuePairs["oldName"];
            var newName = valuePairs["newName"];
            newName = newName.TrimStart().TrimEnd();   // 去除新程序名的前后空格
            var bll = new EapBll("eap");
            string errorinfo = string.Empty;
            var res = bll.ModifyProgramName(macCode, oldName, newName.Trim(), ref errorinfo);
            if (res > 0)
            {
                LogHelper<MacProgram>.LogFatal("ModifyProgramName-->macCode" + macCode + ";oldName" + oldName + ";newName" + newName, "用户操作", "none");
                return new EapResponse { Code = 1, Msg = string.Empty };
            }
            return new EapResponse { Code = -1, Msg = errorinfo };
        }

        /// <summary>
        /// 复制单个程序
        /// </summary>
        /// <param name="valuePairs"></param>
        /// <returns></returns>
        [HttpPost]
        public EapResponse CopySingleProgram([FromBody] IDictionary<string, string> valuePairs)
        {
            if (valuePairs == null || valuePairs.Keys.Count == 0)
                return null;
            string errorinfo = string.Empty;
            var macCodes = valuePairs["macCodes"];
            var proid = Convert.ToInt32(valuePairs["proId"]);
            var macCodeArr = macCodes.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
            string usercode = Request.Headers["usercode"];
            using (IDatabase db = DbFactory.Base("eap"))
            {
                var dal = new MacProgramDal(db);
                var res = dal.CopyProgramVersion(macCodeArr, proid, usercode, ref errorinfo);
                if (res > 0)
                    LogHelper<MacProgram>.LogFatal("CopyProgramVersion-->macCodeArr" + macCodeArr + ";proid" + proid, "用户操作", usercode);
                return new EapResponse { Code = 1, Msg = errorinfo };
            }
        }

        /// <summary>
        /// 复制全部程序
        /// </summary>
        /// <param name="valuePairs"></param>
        /// <returns></returns>
        [HttpPost]
        public EapResponse CopyWholeProgram([FromBody] IDictionary<string, string> valuePairs)
        {
            if (valuePairs == null || valuePairs.Keys.Count == 0)
                return null;
            string errorinfo = string.Empty;
            var macCodes = valuePairs["macCodes"];
            var oriMacCode = valuePairs["oriMacCode"];
            var macCodeArr = macCodes.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
            string usercode = Request.Headers["usercode"];
            using (IDatabase db = DbFactory.Base("eap"))
            {
                var dal = new MacProgramDal(db);
                var res = dal.CopyWholePrograms(macCodeArr, oriMacCode, usercode, ref errorinfo);
                if (res > 0)
                    LogHelper<MacProgram>.LogFatal("CopyWholePrograms-->macCodeArr" + macCodeArr + ";oriMacCode" + oriMacCode, "用户操作", usercode);
                return new EapResponse { Code = 1, Msg = errorinfo };
            }
        }

        /// <summary>
        /// 删除版本
        /// </summary>
        /// <param name="valuePairs"></param>
        /// <returns></returns>
        [HttpPost]
        public EapResponse DeleteVersion([FromBody] IDictionary<string, string> valuePairs)
        {
            if (valuePairs == null || valuePairs.Keys.Count == 0)
                return null;
            string errorinfo = string.Empty;
            var macCode = valuePairs["macCode"];
            var id = Convert.ToInt32(valuePairs["id"]);
            string usercode = Request.Headers["usercode"];
            using (IDatabase db = DbFactory.Base("eap"))
            {
                var dal = new MacProgramDal(db);
                db.BeginTrans();
                var model = dal.getBusinessFileRelation(id);
                var modelsec = dal.getBusinessFile(model);
                var res = dal.DeleteSingVersion(id, macCode, ref errorinfo);
                var eapRes = new EapResponse() { Code = 1, Msg = string.Empty };
                if (res < 0)
                {
                    db.Rollback();
                    eapRes.Code = -1;
                    eapRes.Msg = errorinfo;
                }
                db.Commit();
                LogHelper<MacProgram>.LogFatal("删除MacProgram-->BusinessFileRelation：" + Json.ToJson(model) + ";BusinessFile-->" + Json.ToJson(modelsec), "用户操作", usercode);
                return eapRes;
            }
        }

        /// <summary>
        /// 删除单个程序
        /// </summary>
        /// <param name="valuePairs"></param>
        /// <returns></returns>
        [HttpPost]
        public EapResponse DeleteSingleWholeProgram([FromBody] IDictionary<string, string> valuePairs)
        {
            if (valuePairs == null || valuePairs.Keys.Count == 0)
                return null;
            string errorinfo = string.Empty;
            var macCode = valuePairs["macCode"];
            var proName = valuePairs["proName"];
            string usercode = Request.Headers["usercode"];
            using (IDatabase db = DbFactory.Base("eap"))
            {
                var dal = new MacProgramDal(db);
                db.BeginTrans();
                var model = dal.getbusinessfilerelation(proName, macCode, ref errorinfo);
                var modelsec = dal.getBusinessFile(proName, macCode, ref errorinfo);
                var res = dal.DeleteWholeProgram(proName, macCode, ref errorinfo);
                var eapRes = new EapResponse() { Code = 1, Msg = string.Empty };
                if (res < 0)
                {
                    db.Rollback();
                    eapRes.Code = -1;
                    eapRes.Msg = errorinfo;
                }
                db.Commit();
                LogHelper<MacProgram>.LogFatal("businessfilerelation-->：" + Json.ToJson(model) + ";BusinessFile" + Json.ToJson(modelsec) + "; macCode" + macCode, "用户操作", usercode);
                return eapRes;
            }
        }
    }
}