CyclecountHeaderApp.cs 5.31 KB
using Infrastructure;
using Microsoft.AspNetCore.Hosting;
using Microsoft.AspNetCore.Http;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Linq.Expressions;
using WebRepository;

namespace WebApp
{
    /// <summary>
	/// 盘点单主表
	/// </summary>
    
    public partial class CyclecountHeaderApp
    {
        private IUnitWork _unitWork;
        public IRepository<CyclecountHeader> _app;
        private static IHostingEnvironment _hostingEnvironment;
        ExcelHelper imp = new ExcelHelper(_hostingEnvironment);

        public CyclecountHeaderApp(IUnitWork unitWork, IRepository<CyclecountHeader> repository, IHostingEnvironment hostingEnvironment)
        {
            _unitWork = unitWork;
            _app = repository;
            _hostingEnvironment = hostingEnvironment;
        }
        
        public CyclecountHeaderApp SetLoginInfo(LoginInfo loginInfo)
        {
            _app._loginInfo = loginInfo;
            return this;
        }
        
        public TableData Load(PageReq pageRequest, CyclecountHeader entity)
        {
            return _app.Load(pageRequest, entity);
        }

        public void Ins(CyclecountHeader entity)
        {
            entity.Code = entity.Code.Insert(0, TaskNo.盘点);
            entity.Status = ReceiptHeaderStatus.新建;
            entity.UploadTime = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.ffff"));
            _app.Add(entity);
        }

        public void Upd(CyclecountHeader entity)
        {
            _app.Update(entity);
        }

        public void DelByIds(int[] ids)
        {
            _app.Delete(u => ids.Contains(u.Id.Value));
        }
        
        public CyclecountHeader FindSingle(Expression<Func<CyclecountHeader, bool>> exp)
        {
            return _app.FindSingle(exp);
        }

        public IQueryable<CyclecountHeader> Find(Expression<Func<CyclecountHeader, bool>> exp)
        {
            return _app.Find(exp);
        }

        public Response ImportIn(IFormFile excelfile)
        {
            Response result = new Infrastructure.Response();
            List<CyclecountHeader> exp = imp.ConvertToModel<CyclecountHeader>(excelfile);
            string sErrorMsg = "";

            for (int i = 0; i < exp.Count; i++)
            {
                try
                {
                    CyclecountHeader e = exp[i];
                    e.Id = null;
                    _app.Add(e);
                }
                catch (Exception ex)
                {
                    sErrorMsg += "第" + (i + 2) + "行:" + ex.Message + "<br>";
                    result.Message = sErrorMsg;
                    break;
                }
            }
            if (sErrorMsg.Equals(string.Empty))
            {
                if (exp.Count == 0)
                {
                    sErrorMsg += "没有发现有效数据, 请确定模板是否正确, 或是否有填充数据!";
                    result.Message = sErrorMsg;
                }
                else
                {
                    result.Message = "导入完成";
                }
            }
            else
            {
                result.Status = false;
                result.Message = result.Message;
            }
            return result;
        }

        public TableData ExportData(CyclecountHeader entity)
        {
            return _app.ExportData(entity);
        }

        public TableData Query(CyclecountHeader entity)
        {
            var result = new TableData();
            var data = _app.Find(EntityToExpression<CyclecountHeader>.GetExpressions(entity));

            GetData(data, result);
            result.count = data.Count();

            return result;
        }

        public void GetData(IQueryable<CyclecountHeader> data, TableData result, PageReq pageRequest = null)
        {
            _app.GetData(data, result, pageRequest);
        }
        /// <summary>
        /// 手动删除盘点单数据
        /// </summary>
        /// <param name="receiptHeaders">盘点单数据组</param>
        /// <returns></returns>
        public TableData DelHeader(List<CyclecountHeader> CyclecountHeaders)
        {
            TableData tab = new TableData();
            tab.code = 200;
            List<CyclecountDetail> CyclecountDetails = new List<CyclecountDetail>();
            try
            {
                foreach (CyclecountHeader CyclecountHeader in CyclecountHeaders)
                {
                    
                    if (CyclecountHeader.Status == ReceiptHeaderStatus.回传)
                    {
                        CyclecountDetails = _unitWork.Find<CyclecountDetail>(n => n.Code == CyclecountHeader.Code).ToList();
                        foreach (CyclecountDetail CyclecountDetail in CyclecountDetails)
                        {
                           _unitWork.Delete(CyclecountDetail);
                        }
                        _unitWork.Delete(CyclecountHeader);
                    }
                    else
                    {
                        tab.code = 300;
                        tab.msg = "盘点单状态不允许删除";
                    }
                }
            }
            catch (Exception ex)
            {
                tab.code = 300;
                tab.msg += ex.Message;
            }
            return tab;
        }
    }
}