using HH.WMS.BLL;
|
using HH.WMS.Entitys;
|
using Newtonsoft.Json;
|
using System;
|
using System.Collections.Generic;
|
using System.Data;
|
using System.Linq;
|
using System.Net;
|
using System.Net.Http;
|
using System.Web.Http;
|
|
namespace HH.WMS.WebApi.Areas.Common.Controllers
|
{
|
public class TestController : ApiController
|
{
|
/// <summary>
|
/// 事务测试
|
/// </summary>
|
/// <returns></returns>
|
[HttpGet]
|
public OperateResult TestTransaction()
|
{
|
TN_WM_INCREASE_INVENTORY_MSTEntity entity = new TN_WM_INCREASE_INVENTORY_MSTEntity()
|
{
|
CN_S_OP_NO = "Test22",
|
CN_T_CREATE = DateTime.Now,
|
CN_T_MODIFY = DateTime.Now,
|
CN_S_FROM_NO = "Test22",
|
CN_S_OP_TYPE = "DapperT2t",
|
CN_S_STOCK_CODE = "CK002",
|
CN_T_OPERATE = DateTime.Now,
|
//CN_S_ORGAN = "Test21",
|
CN_S_STATE = "已审核"
|
};
|
entity.DTLEntity = new List<TN_WM_INCREASE_INVENTORY_DTLEntity>();
|
entity.DTLEntity.Add(new TN_WM_INCREASE_INVENTORY_DTLEntity()
|
{
|
CN_GUID = Guid.NewGuid().ToString(),
|
CN_S_OP_NO = entity.CN_S_OP_NO,
|
CN_S_ITEM_CODE = "ItemCodeTest1",
|
CN_S_ITEM_STATE = "state",
|
CN_F_QUANTITY = 11,
|
CN_F_ALLOT_QTY = 11,
|
CN_C_IS_BALANCE = "N",
|
CN_C_IS_SCRAP = "N"
|
});
|
OperateResult result = BLLCreator.Create<TestBLL>().Test(entity);
|
|
return result;
|
}
|
|
/// <summary>
|
/// 查询测试
|
/// </summary>
|
/// <returns></returns>
|
[HttpGet]
|
public OperateResult TestQuery()
|
{
|
//单表查询-查所有
|
var list1 = BLLCreator.Create<DapperBLL<TN_WM_INCREASE_INVENTORY_MSTEntity>>().GetList();
|
//单表查询-带条件
|
var list2 = BLLCreator.Create<DapperBLL<TN_WM_INCREASE_INVENTORY_MSTEntity>>()
|
.GetList(new
|
{
|
CN_S_OP_NO = "Test11"
|
});
|
//单表查询-查单条（where参数不传，默认返回第一条）
|
var entity = BLLCreator.Create<DapperBLL<TN_WM_INCREASE_INVENTORY_MSTEntity>>().GetSingleEntity(new
|
{
|
CN_S_OP_NO = "Test11"
|
});
|
//----针对复杂的多表查询，需要自建BLL和DAL------
|
//多表查询动态列 List
|
List<dynamic> list3 = BLLCreator.Create<TestBLL>().GetTestDynamicList("Test11");
|
//多表查询指定实体 List
|
List<TN_WM_INCREASE_INVENTORY_MSTEntity> list4 = BLLCreator.Create<TestBLL>().GetTestList("Test11");
|
//多表查询 Datatable
|
DataTable dt = BLLCreator.Create<TestBLL>().GetTestDataTable("Test11");
|
|
return OperateResult.Succeed();
|
}
|
}
|
}
|
