using Furion.DatabaseAccessor; using Furion.DependencyInjection; using Furion.DynamicApiController; using iWare.Wms.Core; using iWare.Wms.Core.Enum; using Microsoft.AspNetCore.Authorization; using Microsoft.AspNetCore.Mvc; using Microsoft.EntityFrameworkCore; using StackExchange.Redis; using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; using System.Xml.Linq; namespace iWare.Wms.Application.Service.WmsBase.WmsSeed { /// /// 获取种子数据 /// [ApiDescriptionSettings("种子数据", Name = "WmsSeed", Order = 100)] [Route("api/[Controller]")] public class WmsSeed : IDynamicApiController, ITransient { private readonly IRepository _wmsTask; private readonly IRepository _wmsMaterialStock; private readonly IRepository _wmsContainerPlace; private readonly IRepository _wmsMaterialContainer; private readonly IRepository _sysDictData; private readonly IRepository _sysMenu; public WmsSeed( IRepository wmsTask, IRepository wmsMaterialStock, IRepository wmsContainerPlace, IRepository wmsMaterialContainer, IRepository sysDictData, IRepository sysMenu ) { _wmsTask = wmsTask; _wmsMaterialStock = wmsMaterialStock; _wmsContainerPlace = wmsContainerPlace; _wmsMaterialContainer = wmsMaterialContainer; _sysDictData = sysDictData; _sysMenu = sysMenu; } /// /// 任务管理实体种子 /// /// [HttpGet("WmsTaskSeed")] [AllowAnonymous] public async Task> WmsTaskSeed() { var taskList = await _wmsTask.Where(n => n.IsDeleted == false).ToListAsync(); var newtaskList = new List(); var TaskModel1 = ""; var TaskType1 = ""; var TaskStatus1 = ""; foreach (var item in taskList) { if (item.TaskModel == TaskModel.SHOUDONG) TaskModel1 = "TaskModel.SHOUDONG"; if (item.TaskModel == TaskModel.ZIDONG) TaskModel1 = "TaskModel.ZIDONG"; if (item.TaskType == TaskType.RUKU) TaskType1 = "TaskType.RUKU"; if (item.TaskType == TaskType.CHUKU) TaskType1 = "TaskType.CHUKU"; if (item.TaskType == TaskType.YIKU) TaskType1 = "TaskType.YIKU"; if (item.TaskStatus == Core.Enum.TaskStatus.WEIZHIXING) TaskStatus1 = "Core.Enum.TaskStatus.WEIZHIXING"; if (item.TaskStatus == Core.Enum.TaskStatus.ZHIXINGZHONG) TaskStatus1 = "Core.Enum.TaskStatus.ZHIXINGZHONG"; if (item.TaskStatus == Core.Enum.TaskStatus.WANCHENG) TaskStatus1 = "Core.Enum.TaskStatus.WANCHENG"; var task = string.Format("Id={0},TaskNo=\"{1}\",TaskModel={2},TaskType={3},TaskLevel={4},TaskStatus={5},ContainerCode=\"{6}\",SourcePlace=\"{7}\",ToPlace=\"{8}\",Aisle={9},AreaName=\"{10}\",OrderNo=\"{11}\",SendTimes={12}", item.Id, item.TaskNo, TaskModel1, TaskType1, item.TaskLevel, TaskStatus1, item.ContainerCode, item.SourcePlace, item.ToPlace, item.Aisle, item.AreaName, item.OrderNo, item.SendTimes); newtaskList.Add("new WmsTask{"+task+ "}"); } return newtaskList; } /// /// 库存表实体种子 /// /// [HttpGet("WmsMaterialStockSeed")] [AllowAnonymous] public async Task> WmsMaterialStockSeed() { var stockList = await _wmsMaterialStock.Where(n => n.IsDeleted == false).ToListAsync(); var newstockList = new List(); var MaterialType1 = ""; var MaterialInspection1 = ""; var UnitType1 = ""; var UnitnoType1 = ""; foreach (var item in stockList) { if (item.MaterialType == MaterialType.YUANCAILIAO) MaterialType1 = "MaterialType.YUANCAILIAO"; if (item.MaterialType == MaterialType.BANCHENGPING) MaterialType1 = "MaterialType.BANCHENGPING"; if (item.MaterialType == MaterialType.CHENGPING) MaterialType1 = "MaterialType.CHENGPING"; if (item.MaterialType == MaterialType.KONGTUO) MaterialType1 = "MaterialType.KONGTUO"; if (item.InspectionMethod == MaterialInspection.MIANJIAN) MaterialInspection1 = "MaterialInspection.MIANJIAN"; if (item.InspectionMethod == MaterialInspection.CHOUJIAN) MaterialInspection1 = "MaterialInspection.CHOUJIAN"; if (item.UnitType == UnitType.CHANGDU) UnitType1 = "UnitType.CHANGDU"; if (item.UnitType == UnitType.ZHONGLIANG) UnitType1 = "UnitType.ZHONGLIANG"; if (item.UnitNo == UnitnoType.CM) UnitnoType1 = "UnitnoType.CM"; if (item.UnitNo == UnitnoType.T) UnitnoType1 = "UnitnoType.T"; var stock = string.Format("Id={0},MaterialNo=\"{1}\",MaterialType={2},MaterialBatch=\"{3}\",MaterialName=\"{4}\",MaterialSpec=\"{5}\",InspectionMethod={6},UnitType={7},UnitNo={8},StockNumber=(decimal){9},PlaceCode=\"{10}\",ContainerCode=\"{11}\",AreaId={12}", item.Id, item.MaterialNo, MaterialType1, item.MaterialBatch, item.MaterialName, item.MaterialSpec, MaterialInspection1, UnitType1, UnitnoType1, item.StockNumber, item.PlaceCode, item.ContainerCode, item.AreaId); newstockList.Add("new WmsMaterialStock{" + stock+ "}"); } return newstockList; } /// /// 托盘库位关系表实体种子 /// /// [HttpGet("WmsContainerPlaceSeed")] [AllowAnonymous] public async Task> WmsContainerPlaceSeed() { var placeList = await _wmsContainerPlace.Where(n => n.IsDeleted == false).ToListAsync(); var newplaceList = new List(); var CommonStatus1 = ""; foreach (var item in placeList) { //if (item.ContainerPlaceStatus == CommonStatus.ENABLE) CommonStatus1 = "CommonStatus.ENABLE"; //if (item.ContainerPlaceStatus == CommonStatus.DISABLE) CommonStatus1 = "CommonStatus.DISABLE"; //if (item.ContainerPlaceStatus == CommonStatus.DELETED) CommonStatus1 = "CommonStatus.DELETED"; //var place = string.Format("Id={0},PlaceId={1},PlaceCode=\"{2}\",ContainerId={3},ContainerCode=\"{4}\",ContainerPlaceStatus={5}", item.Id, item.PlaceId, item.PlaceCode, item.ContainerId, item.ContainerCode, CommonStatus1); //newplaceList.Add("new WmsContainerPlace{"+place+"}"); } return newplaceList; } /// /// 物料托盘关系表实体种子 /// /// [HttpGet("WmsMaterialContainerSeed")] [AllowAnonymous] public async Task> WmsMaterialContainerSeed() { var masterList = await _wmsMaterialContainer.Where(n => n.IsDeleted == false).ToListAsync(); var newmasterList = new List(); var CommonStatus1 = ""; foreach (var item in masterList) { if (item.BindStatus == CommonStatus.ENABLE) CommonStatus1 = "CommonStatus.ENABLE"; if (item.BindStatus == CommonStatus.DISABLE) CommonStatus1 = "CommonStatus.DISABLE"; if (item.BindStatus == CommonStatus.DELETED) CommonStatus1 = "CommonStatus.DELETED"; var master = string.Format("Id={0},ContainerId={1},ContainerCode=\"{2}\",MaterialName=\"{3}\",MaterialNo=\"{4}\",MaterialBatch=\"{5}\",MaterialSpec=\"{6}\",MaterialId={7},BindQuantity=(decimal){8},BindStatus={9},SampleQty=(decimal){10},OrderNo=\"{11}\"", item.Id, item.ContainerId, item.ContainerCode, item.MaterialName, item.MaterialNo, item.MaterialBatch, item.MaterialSpec, item.MaterialId, item.BindQuantity, CommonStatus1, item.SampleQty, item.OrderNo); newmasterList.Add("new WmsMaterialContainer{"+master+"}"); } return newmasterList; } /// /// 字典表实体种子 /// /// [HttpGet("SysDictDataSeed")] [AllowAnonymous] public async Task> SysDictDataSeed() { var dictdataList = await _sysDictData.Where(n => n.IsDeleted == false).ToListAsync(); var newdictdataList = new List(); foreach (var item in dictdataList) { var Zhi = string.Format("Id={0},TypeId={1},Value=\"{2}\",Code=\"{3}\",Sort={4},Remark=\"{5}\",Status={6}", item.Id, item.TypeId, item.Value, item.Code, item.Sort, item.Remark, item.Status); newdictdataList.Add("new SysDictData{" + Zhi + "}"); } return newdictdataList; } /// /// 系统菜单表实体种子 /// /// [HttpGet("SysMenuSeed")] [AllowAnonymous] public async Task> SysMenuSeed() { var menuList = await _sysMenu.Where(n => n.IsDeleted == false).ToListAsync(); var newmenuList = new List(); var MenuType1 = ""; var MenuOpenType1 = ""; var MenuWeight1 = ""; var CommonStatus1 = ""; foreach (var item in menuList) { if (item.Type == MenuType.DIR) MenuType1 = "MenuType.DIR"; if (item.Type == MenuType.MENU) MenuType1 = "MenuType.MENU"; if (item.Type == MenuType.BTN) MenuType1 = "MenuType.BTN"; if (item.OpenType == MenuOpenType.NONE) MenuOpenType1 = "MenuOpenType.NONE"; if (item.OpenType == MenuOpenType.COMPONENT) MenuOpenType1 = "MenuOpenType.COMPONENT"; if (item.OpenType == MenuOpenType.INNER) MenuOpenType1 = "MenuOpenType.INNER"; if (item.OpenType == MenuOpenType.OUTER) MenuOpenType1 = "MenuOpenType.OUTER"; if (item.Weight == MenuWeight.SUPER_ADMIN_WEIGHT) MenuWeight1 = "MenuWeight.SUPER_ADMIN_WEIGHT"; if (item.Weight == MenuWeight.DEFAULT_WEIGHT) MenuWeight1 = "MenuWeight.DEFAULT_WEIGHT"; if (item.Status == CommonStatus.ENABLE) CommonStatus1 = "CommonStatus.ENABLE"; if (item.Status == CommonStatus.DISABLE) CommonStatus1 = "CommonStatus.DISABLE"; if (item.Status == CommonStatus.DELETED) CommonStatus1 = "CommonStatus.DELETED"; var Zhi = ""; if (item.Pid == 0) { Zhi = string.Format("Id={0},Pid={1},Pids=\"{2}\",Name=\"{3}\",Code=\"{4}\",Type={5},Icon=\"{6}\",Router=\"{7}\",Component=\"{8}\",Application=\"{9}\",OpenType={10},Visible=\"{11}\",Weight={12},Sort={13},Status={14}", item.Id, item.Pid, item.Pids, item.Name, item.Code, MenuType1, item.Icon, item.Router, item.Component, item.Application, MenuOpenType1, item.Visible, MenuWeight1, item.Sort, CommonStatus1); } else { Zhi = string.Format("Id={0},Pid={1},Pids=\"{2}\",Name=\"{3}\",Code=\"{4}\",Type={5},Permission=\"{6}\",Application=\"{7}\",OpenType={8},Visible=\"{9}\",Weight={10},Sort={11},Status={12}", item.Id, item.Pid, item.Pids, item.Name, item.Code, MenuType1, item.Permission, item.Application, MenuOpenType1, item.Visible, MenuWeight1, item.Sort, CommonStatus1); } newmenuList.Add("new SysMenu{" + Zhi + "}"); } return newmenuList; } } }