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;
}
}
}