using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Threading.Tasks;
|
using Microsoft.AspNetCore.Mvc;
|
using Microsoft.Extensions.Logging;
|
using Newtonsoft.Json;
|
using Tiger.Model;
|
using Rhea.Common;
|
using Tiger.Model.SeaStone.Shelf;
|
using System.Threading;
|
using SqlSugar;
|
using Tiger.IBusiness;
|
using Autofac;
|
using System.Data;
|
using System.Linq.Expressions;
|
using Apache.NMS.ActiveMQ.Commands;
|
using Tiger.Model.Sharetronic.Shelf;
|
using Newtonsoft.Json.Linq;
|
using Tiger.Api.iBiz;
|
|
namespace Tiger.Api.Controllers.Test
|
{
|
/// <summary>
|
/// 测试控制器
|
/// </summary>
|
public partial class TestController : ControllerBase
|
{
|
/// <summary>
|
/// GetAsync
|
/// </summary>
|
/// <returns></returns>
|
[HttpGet]
|
public IActionResult GetDBSchemaAsync()
|
{
|
return Ok(Biz.Db.DbMaintenance.GetTableInfoList());
|
}
|
|
/// <summary>
|
/// GetAsync
|
/// </summary>
|
/// <returns></returns>
|
[HttpGet]
|
public async Task<IActionResult> GetAsync(string param)
|
{
|
//var data = await Biz.Db.Queryable<SYS_PARAM>().Where(q => q.PARAM_CODE == param).FirstAsync();
|
//var data = Biz.SysParam["Blue"];
|
//var data = Biz.SysParam.Groups;
|
//var data = Biz.CodeRule["X0001"];
|
//取号测试
|
//var data = Biz.Db.Queryable<BAS_CODE_RULE>().Where(q => q.RULE_CODE == "X0001").IncludesAllFirstLayer().First();
|
//var key = string.Join("|", data.Details.Where(q => q.DATA_TYPE == BAS_CODE_DTL.DATA_TYPEs.DbCheck.GetValue()).Select(q => q.GenerateValue));
|
//key = "1|2|3";
|
//for (int i = 0; i < 10; i++)
|
//{
|
// var index = i;
|
// Task.Run(() =>
|
// {
|
// try
|
// {
|
// var dtl = data.Details.First(q => q.RULE_SEQ == 6);
|
// var sn = Biz.CodeRule.FetchSerialNo(key, dtl, index.ToString(), false);
|
// Console.WriteLine($"{index}: {DateTime.Now:HH:mm:ss.fff} > 取号完成[{sn}]");
|
// }
|
// catch (Exception ex)
|
// {
|
// Console.WriteLine($"{index}: {DateTime.Now:HH:mm:ss.fff} > 取号失败：{ex.Message}");
|
// }
|
// });
|
//}
|
//var data = Biz.CodeRule["X0001"].Generate("PDFG", 5);
|
//var data1 = Biz.CodeRule["X0001"].TryGenerate("PDFG", 6);
|
//条码规则验证
|
//Expression<Func<BAS_CODE_RULE, bool>> predicate = q => true;
|
////predicate = predicate.And(q => q.RULE_CODE == "X0002" || q.RULE_CODE == "X0001");
|
//predicate = predicate.And(q => q.RULE_TYPE == 0);
|
////var data = Biz.CodeRule.Rules.Where(predicate.Compile());
|
//var data = Biz.CodeRule.Verify("AB23#7930000002010", predicate.Compile());
|
return Ok("");
|
}
|
|
/// <summary>
|
/// Get2Async
|
/// </summary>
|
/// <returns></returns>
|
[HttpGet]
|
public async Task<IActionResult> Get2Async(string param)
|
{
|
//var auth = new AuthOption() { UserId = "admin", ByOrg = true, ByWh = true };
|
//var data = await Biz.Db.Queryable<BIZ_ERP_PO>().Where(q => q.BILLTYPE == 11)
|
// //.ByAuth("admin", DbAuth.Org | DbAuth.Wh)
|
// .ByAuth(auth)
|
// .ToListAsync();
|
//data = await Biz.Db.Queryable<BIZ_ERP_PO>().ByAuth("admin", DbAuth.Org).Where(q => q.BILLTYPE == 11).ToListAsync();
|
var data = await Biz.Db.Queryable<BIZ_ERP_PO>().Where(q => q.BILLTYPE == 11).ToListAsync();
|
//var dtl = await Biz.Db.Queryable<BIZ_ERP_PO_DTL>().ByAuth("admin", DbAuth.Org | DbAuth.Wh).Where(q => q.BILLCODE == "AH3301-221000108").ToListAsync();
|
return Ok(data);
|
}
|
|
/// <summary>
|
/// Get3Async
|
/// </summary>
|
/// <returns></returns>
|
[HttpGet]
|
public async Task<IActionResult> Get3Async(string param)
|
{
|
//var b = new Barcode("AA0930230891113222980001#CBF");
|
//var cutSerial = Convert.ToString(b.ReprintNo ?? 0, 2);
|
//cutSerial = cutSerial == "0" ? "1" : cutSerial;
|
//var orglSn = b.SN.Split("#")[0];
|
|
//var nSplitSn = $"{orglSn}#CA{Convert.ToString(Convert.ToInt32(cutSerial + "0", 2), 16).ToUpper()}";
|
//var nRemainSn = $"{orglSn}#CB{Convert.ToString(Convert.ToInt32(cutSerial + "1", 2), 16).ToUpper()}";
|
|
//var data = nSplitSn;
|
|
//var t = Biz.T("WMS.ProdMReq.ScanItem.LocationIsNull", "dasdsa", "asdasda");
|
|
//var data = Biz.WmsItem.Suggest("test12345", "K33084103", "", "", "", "", new() { ByOrg = true, UserId = "admin", }, (decimal)100000);
|
//foreach (var item in data.Data)
|
//{
|
// //item.Items.First().AddToPool("XCSJ", nameof(BIZ_ERP_PROD_OUT), "test12345", null, 100000, false);
|
//}
|
|
//var data = 0;
|
//try
|
//{
|
// data = Biz.Db.Ado.UseStoredProcedure().ExecuteCommand("pkg_ImportItemFromSRM", new SugarParameter("dlvyNo", "BAD202308240443"));
|
//}
|
//catch (System.Exception ex)
|
//{
|
|
//}
|
//var data = await Biz.Db.Queryable<WMS_WAREHOUSE>().Where(q =>1!= 1).ToListAsync();
|
//foreach (var item in data)
|
//{
|
// item.UPDATE_TIME = DateTime.Now;
|
// item.UPDATE_USER = "admin";
|
//}
|
//Biz.Db.Fastest<WMS_WAREHOUSE>().BulkUpdate(data, new string[] { "ID" }, new string[] { "UPDATE_TIME", "UPDATE_USER" });
|
//Biz.Db.Insertable(data, "Interface").ExecuteCommand();
|
|
//var root = new SugarParameter("root", "system01");
|
//var dt = Biz.Db.Ado.UseStoredProcedure().GetDataTable("PKG_SYS_GET_MENU", root);//返回dt
|
//var data = Biz.Db.Ado.UseStoredProcedure().SqlQuery<SYS_MENU>("PKG_SYS_GET_MENU", root);//返回List
|
;
|
//var data = Biz.Db.Queryable<BIZ_SRM_DLVY>()
|
// .IncludesAllFirstLayer()
|
//c .ToList();
|
|
//var data1 = Biz.Db.Queryable<SYS_ROLE>().Where(q => q.ROLE_CODE == "administrators")
|
// .IncludesAllFirstLayer()
|
// .ToList();
|
//var data = Biz.Db.Queryable<SYS_MENU>().Where(q => q.FUNC_CODE == "system01")
|
// .AsNavQueryable().Includes(q1 => q1.Children, q2 => q2.Children, q3 => q3.Children, q4 => q4.Children)
|
// .ToList();
|
|
//var data = Biz.Db.Queryable<BIZ_ERP_PO>().Where(q => q.BILLCODE == "AH3301-211200047")
|
// .Includes(q => q.Details).First();
|
//var d9 = data.Details.First(q => q.BILLLINE == 9);
|
//var d10 = d9.Clone();
|
//d9.QTY = 9;
|
//d10.BILLLINE = 10;
|
//data.Details.Add(d10);
|
////保存到数据库
|
//var db = Business.Biz.Db;
|
//var dbTran = db.UseTran(async () =>
|
//{
|
// db.InsertNav(data).Include(q => q.Details, new() { OneToManyIfExistsNoInsert = true }).ExecuteCommand();
|
//});
|
//if (!dbTran.IsSuccess)
|
//{
|
// throw dbTran.ErrorException;
|
//}
|
return Ok("");
|
}
|
/// <summary>
|
///
|
/// </summary>
|
private void TestAsyncSuggest()
|
{
|
var begin = DateTime.Now;
|
var ElapsedTime = 0.0;
|
//Debug.WriteLine($"Async suggest begin at {begin:T}");
|
var order = "";
|
var warehouse = "";
|
var erpwh = "";
|
var region = "";
|
var shelf = "";
|
var option = new AuthOption() { ByOrg = true, UserId = "admin", };
|
var dic = new Dictionary<string, Result<List<SuggestItem>>>();
|
//foreach (var item in dic)
|
//{
|
// var key = item.Key;
|
// Work.DoAsync(() => {
|
// dic[item.Key] = Biz.WmsItem.Suggest(order, item.Key, erpwh, warehouse, region, shelf, option, 1);
|
// });
|
//}
|
//while (!dic.Any(q => q.Value.IsNormal)) ;
|
ElapsedTime = (DateTime.Now - begin).TotalSeconds;
|
//Debug.WriteLine($"Async suggest end, elapsed total {ElapsedTime} seconds");
|
}
|
|
/// <summary>
|
/// D1Async
|
/// </summary>
|
/// <returns></returns>
|
[HttpGet]
|
public async Task<IActionResult> D1Async(string param)
|
{
|
//Logger.Scheduler.Info("这是一次成功的测试");
|
//var data = iBiz.Biz.Db.Queryable<BAS_CODE_RULE>()
|
// .IncludesAllFirstLayer()
|
// .ToList();
|
//var data = iBiz.WMS.WmsItem.Get("123");
|
//var data1 = iBiz.WMS.WmsItem.Get("123");
|
|
//var s = "{\"GetChuteInfoResult\":{\"IsSuccess\":true,\"ItemCode\":\"0\",\"ResultValue\":\"{\\\"shelfNo\\\":\\\"A31F\\\",\\\"ledStartIndex\\\":26,\\\"ledNum\\\":1,\\\"ledAddrs\\\":[501],\\\"ledAddressList\\\":[{\\\"ledAddress\\\":501,\\\"isOccupy\\\":true}]}\",\"Type\":\"\"}}";
|
//JObject jObj = JObject.Parse(s.IsNullOrEmpty("{}"));
|
//var r = JsonConvert.DeserializeObject<ShelfApiResult>(jObj.First?.First?.ToString() ?? "");
|
//var t = JsonConvert.DeserializeObject<ShelfApiResult>("");
|
|
var data = DI.Resolve<ITest>().show();
|
return Ok(data);
|
}
|
|
[HttpGet]
|
public async Task<IActionResult> D2Async(string param)
|
{
|
DI.Resolve<ITest>().set(param);
|
return Ok($"设置{param}成功");
|
}
|
|
[HttpPost]
|
public async Task<IActionResult> TestTask([FromBody] ApiAction action)
|
{
|
string msg = "";
|
await Task.Run(() =>
|
{
|
msg = "成功";
|
});
|
await Task.Run(() =>
|
{
|
Thread.Sleep(10*60*1000);
|
msg = "异步成功";
|
Logger.Default.Info(msg);
|
});
|
return Ok(action.GetResponse(msg));
|
}
|
|
/// <summary>
|
/// CloseShelfAllLight
|
/// </summary>
|
/// <param name="action"></param>
|
/// <returns></returns>
|
[HttpPost]
|
public async Task<IActionResult> CloseShelfAllLightAsync([FromBody] ApiAction action)
|
{
|
var shelfs = action.Data.ToString().Split(new string[]{ "," }, StringSplitOptions.RemoveEmptyEntries).Select(q => q + "F").ToList();
|
shelfs.AddRange(shelfs.Select(q => q.Substring(0, q.Length - 1) + "R").ToList());
|
var success = new List<string>();
|
//foreach (var shelf in shelfs)
|
//{
|
// var result = await Share.Shelf.DownAll(shelf);
|
// if (result.IsSuccess)
|
// {
|
// success.Add(shelf);
|
// }
|
//}
|
shelfs.RemoveAll(q => success.Contains(q));
|
return Ok($"{(success.IsNullOrEmpty() ? "" : $"货架[{string.Join(",", success)}]灭灯成功")}{(shelfs.IsNullOrEmpty() ? "" : $"货架[{string.Join(",", shelfs)}]灭灯失败")}");
|
}
|
|
}
|
|
/// <summary>
|
/// 测试控制器
|
/// </summary>
|
[ApiController]
|
[Route("api/[controller]/[action]")]
|
public partial class _TestController : ControllerBase
|
{
|
[HttpGet]
|
public async Task<IActionResult> DoSomething(int duration)
|
{
|
var begin = DateTime.Now;
|
while ((DateTime.Now - begin).TotalSeconds <= duration)
|
{
|
Thread.Sleep(1000);
|
var total = (DateTime.Now - begin).TotalSeconds;
|
var percent = total / duration;
|
ConsoleExt.WriteLine($"Working {begin:mmssfff} ... {(percent > 1 ? 1 : percent):P0} ...", ConsoleColor.Green);
|
}
|
Logger.Default.Info($"{begin:mmssfff} completed");
|
return Ok($"{begin:mmssfff} completed");
|
}
|
|
[HttpGet]
|
public async Task<IActionResult> DoSomething1(int duration)
|
{
|
var begin = DateTime.Now;
|
|
return Ok($"{begin:mmssfff} completed");
|
}
|
|
/// <summary>
|
/// SendMQTTAsync
|
/// </summary>
|
/// <param name="action"></param>
|
/// <returns></returns>
|
[HttpPost]
|
public async Task<IActionResult> SendMQTTAsync([FromBody] ApiAction action)
|
{
|
string msg = "";
|
await Task.Run(() =>
|
{
|
msg = action.ID;
|
MQTTHelper.Send("TestSendMQTT001", new MQTTMessage()
|
{
|
Type = "TestSendMQTT001",
|
Content = "TestSendMQTT001，测试消息！",
|
Data = "",
|
DataType = typeof(String).Name,
|
IsSuccessed = true,
|
});
|
});
|
return Ok(MQTTHelper.Send(action.GetResponse(msg)));
|
}
|
|
/// <summary>
|
/// DeleteMQTTTopicAsync
|
/// </summary>
|
/// <param name="action"></param>
|
/// <returns></returns>
|
[HttpPost]
|
public async Task<IActionResult> DeleteMQTTTopicAsync([FromBody] ApiAction action)
|
{
|
string msg = "";
|
await Task.Run(() =>
|
{
|
msg = MQTTHelper.DeleteTopic(action.ID) ? "删除Topic成功" : "删除Topic失败";
|
});
|
return Ok(action.GetResponse(msg));
|
}
|
}
|
}
|
