using HH.AutoBom.Core;
using HH.WMS.WebUI.Controllers;
using Newtonsoft.Json;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;

namespace HH.WMS.WebUI.Areas.Check.Controllers
{
    /// <summary>
    /// 盘点（南通桑德）
    /// </summary>
    public class CheckNtsdController : BaseController
    {
        /// <summary>
        /// 盘点首页
        /// </summary>
        /// <returns></returns>
        public ActionResult Index()
        {
            return View();
        }

        public ActionResult Add()
        {
            return View();
        }

        #region GET

        /// <summary>
        /// 获取盘点主表数据
        /// </summary>
        ///  <param name="CN_S_OP_NO">盘点单号</param>
        /// <param name="CN_S_STOCK_CODE">仓库编码</param>
        /// <param name="CN_S_STOCK_AREA">库区</param>
        /// <param name="CN_S_ITEM_CODE">物料编码</param>
        /// <param name="CN_T_OPERATE">盘点日期</param>
        /// <param name="CN_S_TYPE">类型</param>
        /// <returns></returns>
        /// <history>[HanHe(LT)] CREATED 2018/7/4</history>
        public string GetCheckMst(int pageIndex, int pageSize, string CN_S_OP_NO, string CN_S_TYPE, string CN_S_STOCK_CODE, string CHECKTIME, string CN_S_STATE, string valueDate)
        {
            string sqlWhere = "WHERE 1=1";

            //仓库编码
            if (!string.IsNullOrEmpty(CN_S_OP_NO))
            {
                sqlWhere += " AND CN_S_OP_NO like '%" + CN_S_OP_NO.Trim() + "%'";
            }
            //仓库编码
            if (!string.IsNullOrEmpty(CN_S_STOCK_CODE))
            {
                sqlWhere += " AND CN_S_STOCK_CODE = '" + CN_S_STOCK_CODE + "'";
            }
            //类型
            if (!string.IsNullOrEmpty(CN_S_TYPE))
            {
                sqlWhere += " AND CN_S_TYPE = '" + CN_S_TYPE + "' ";
            }

            string[] date = new string[2];
            if (!string.IsNullOrEmpty(valueDate))
            {
                date = JsonConvert.DeserializeObject<string[]>(valueDate);

                ////开始时间
                if (!string.IsNullOrEmpty(date[0]))
                {
                    sqlWhere += " AND CN_T_CREATE >= '" + date[0] + "' ";
                }
                //结束时间
                if (!string.IsNullOrEmpty(date[1]))
                {
                    sqlWhere += " AND CN_T_CREATE <= DateAdd(dd, 1, '" + date[1] + "')";
                }
            }
            ////开始时间
            //if (!string.IsNullOrEmpty(STARTTIME))
            //{
            //    sqlWhere += " AND CN_T_CREATE >= '" + STARTTIME + "' ";
            //}
            ////结束时间
            //if (!string.IsNullOrEmpty(ENDTIME))
            //{
            //    sqlWhere += " AND CN_T_CREATE <= DateAdd(dd, 1, '" + ENDTIME + "')";
            //}

            //状态
            if (!string.IsNullOrEmpty(CN_S_STATE))
            {
                sqlWhere += " AND CN_S_STATE = '" + CN_S_STATE + "'";
            }
            string OrdeBy = " order by  CN_T_CREATE DESC";

            var loginer = FormsAuth.GetUserData<LoginerBase>();
            var entity = new
            {
                tokenId = loginer.Extend1,
                OrdeBy = OrdeBy,
                sqlWhere = sqlWhere,
                pageSize = pageSize,
                pageIndex = pageIndex
            };
            string stringjson = JsonConvert.SerializeObject(entity);
            string list = HttpWMS_Post("Api/CheckNtsd/GetCheckMst", stringjson);
            return list;
        }

        /// <summary>
        /// 获取盘点明细数据
        /// </summary>
        /// <param name="CN_S_OP_NO">仓库编码</param>
        /// <returns></returns>
        /// <history>[HanHe(LT)] CREATED 2018/7/4</history>
        /// <history>[HanHe(dbs)] CREATED 2019/3/18</history>
        public string GetCheckDtl(string opNo)
        {
            string list = HttpWMS_Get("Api/CheckNtsd/GetCheckDtl?opNo=" + opNo);
            return list;
        }

        public string GetCheckList(int pageIndex, int pageSize,string CN_S_STOCK_CODE)
        {
            string sqlWhere = "WHERE 1=1";

            ////仓库编码
            //if (!string.IsNullOrEmpty(CN_S_OP_NO))
            //{
            //    sqlWhere += " AND CN_S_OP_NO like '%" + CN_S_OP_NO.Trim() + "%'";
            //}
            ////仓库编码
            //if (!string.IsNullOrEmpty(CN_S_STOCK_CODE))
            //{
            //    sqlWhere += " AND CN_S_STOCK_CODE = '" + CN_S_STOCK_CODE + "'";
            //}
            ////类型
            //if (!string.IsNullOrEmpty(CN_S_TYPE))
            //{
            //    sqlWhere += " AND CN_S_TYPE = '" + CN_S_TYPE + "' ";
            //}

            //string[] date = new string[2];
            //if (!string.IsNullOrEmpty(valueDate))
            //{
            //    date = JsonConvert.DeserializeObject<string[]>(valueDate);

            //    ////开始时间
            //    if (!string.IsNullOrEmpty(date[0]))
            //    {
            //        sqlWhere += " AND CN_T_CREATE >= '" + date[0] + "' ";
            //    }
            //    //结束时间
            //    if (!string.IsNullOrEmpty(date[1]))
            //    {
            //        sqlWhere += " AND CN_T_CREATE <= DateAdd(dd, 1, '" + date[1] + "')";
            //    }
            //}
            ////开始时间
            //if (!string.IsNullOrEmpty(STARTTIME))
            //{
            //    sqlWhere += " AND CN_T_CREATE >= '" + STARTTIME + "' ";
            //}
            ////结束时间
            //if (!string.IsNullOrEmpty(ENDTIME))
            //{
            //    sqlWhere += " AND CN_T_CREATE <= DateAdd(dd, 1, '" + ENDTIME + "')";
            //}

            //状态
            //if (!string.IsNullOrEmpty(CN_S_STATE))
            //{
            //    sqlWhere += " AND CN_S_STATE = '" + CN_S_STATE + "'";
            //}
            string OrdeBy = " order by  CN_T_CREATE DESC";

            var loginer = FormsAuth.GetUserData<LoginerBase>();
            var entity = new
            {
                tokenId = loginer.Extend1,
                OrdeBy = OrdeBy,
                sqlWhere = sqlWhere,
                pageSize = pageSize,
                pageIndex = pageIndex
            };
            string stringjson = JsonConvert.SerializeObject(entity);
            string list = HttpWMS_Post("Api/CheckNtsd/GetCheckMst", stringjson);
            return list;
        }

        #endregion


        #region ADD



        #endregion


    }
}