using HH.WMS.BLL;
using HH.WMS.BLL.Basic;
using HH.WMS.BLL.MoveStock;
using HH.WMS.Entitys;
using HH.WMS.Entitys.Common;
using HH.WMS.Entitys.MoveStock;
using HH.WMS.WebApi.Areas.Common.Controllers;
using Newtonsoft.Json;
using Newtonsoft.Json.Converters;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Net;
using System.Net.Http;
using System.Text;
using System.Web.Http;

namespace HH.WMS.WebApi.Areas.MoveStock.Controllers
{
    public class MoveStockTaskController : BaseController
    {
        [HttpPost]
        public string GetMoveStockTaskMsts(SearchModel model)
        {
             return ValidateToken(model.TokenId, t =>
                 {
                     long total;
                     StringBuilder str = new StringBuilder();
                     str.Append(" select * from TN_WM_MOVE_STOCK_TASK_MST where 1=1");

                     if (model.SearchCondition != null)
                     {  //判断是否页面第一次加载
                     //    if (model.SearchCondition.CN_S_STOCK_CODE != "")
                     //    {
                     //        str.Append(" AND CN_S_STOCK_CODE ='" + model.SearchCondition.CN_S_STOCK_CODE + "'");
                     //    }
                     //    if (model.SearchCondition.CN_S_OP_MODE != "")
                     //    {
                     //        str.Append(" AND CN_S_OP_MODE ='" + model.SearchCondition.CN_S_OP_MODE + "'");
                     //    }
                     //    if (model.SearchCondition.CN_S_OP_NO != "")
                     //    {
                     //        str.Append(" AND CN_S_OP_NO like '%" + model.SearchCondition.CN_S_OP_NO + "%'");
                     //    }
                         if (!string.IsNullOrEmpty(model.SearchCondition.CN_S_STATE.ToString()))
                         {
                             str.Append(" AND CN_S_STATE ='" + model.SearchCondition.CN_S_STATE + "'");
                         }
                         if (!string.IsNullOrEmpty(model.SearchCondition.CN_T_START.ToString()))
                         {
                             str.Append(" AND CN_T_CREATE >='" + model.SearchCondition.CN_T_START + "'");
                         }
                         if (!string.IsNullOrEmpty(model.SearchCondition.CN_T_END.ToString()))
                         {
                             str.Append(" AND CN_T_CREATE <= DateAdd(dd, 1, '" + model.SearchCondition.CN_T_END + "')");
                         }
                     }

                     DataTable dt = BLLCreator.Create<MoveStockTaskBLL>().GetDataList(str.ToString(), model.PageIndex, model.PageSize, out total, null);
                     dt.Columns["CN_S_START_AREA"].ReadOnly = false;
                     dt.Columns["CN_S_END_AREA"].ReadOnly = false;
                     foreach (DataRow dr in dt.Rows)
                     {
                         var startArea = BLLCreator.Create<TN_AB_B_STOCK_AREABLL>().GetStockAreaEntity(dr["CN_S_START_AREA"].ToString());
                         var endArea = BLLCreator.Create<TN_AB_B_STOCK_AREABLL>().GetStockAreaEntity(dr["CN_S_END_AREA"].ToString());
                         if (startArea != null)
                         {
                             dr["CN_S_START_AREA"] = startArea.CN_S_AREA_NAME;
                         }
                         if (endArea != null)
                         {
                             dr["CN_S_END_AREA"] = endArea.CN_S_AREA_NAME;
                         }
                     }
                     OperateResult res = OperateResult.Succeed(null, new { rows = dt, total = total });
                     IsoDateTimeConverter timeFormat = new IsoDateTimeConverter();
                     timeFormat.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
                     return JsonConvert.SerializeObject(res, timeFormat);
                 });
        }

        [HttpGet]
        public string GetMoveStockTaskDtls(string guid)
        {
            var dt = BLLCreator.Create<DapperBLL<TN_WM_MOVE_STOCK_TASK_DTLEntity>>().GetDataTable(new { CN_PARENT_GUID = guid });
            OperateResult res = OperateResult.Succeed("", dt);
            return JsonConvert.SerializeObject(res);
        }

        [HttpGet]
        public OperateResult Delete(string guid)
        {
            var result = BLL.BLLCreator.Create<MoveStockTaskBLL>().Delete(guid);
            if (result.Success)
            {
                return OperateResult.Succeed();
            }
            return OperateResult.Error(result.Msg);
        }
    }
}