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