using HH.AutoBom.Core;
using HH.WMS.Common;
using HH.WMS.Entitys;
using HH.WMS.Entitys.Common;
using HH.WMS.Entitys.MoveStock;
using HH.WMS.WebUI.Controllers;
using Newtonsoft.Json;
using Newtonsoft.Json.Linq;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Mvc;
namespace HH.WMS.WebUI.Areas.MoveStock.Controllers
{
    public class MoveController : BaseController
    {
        //
        // GET: /MoveStock/Move/

        public ActionResult Index()
        {
            return View();
        }
        public ActionResult Edit() 
        {
            return View();
        }

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

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

        public string GetMoveMst(int pageIndex, int pageSize, string stockCode, string type, string opNo, string opMode, string state, string valueDate)
        {
            string[] date = new string[2];
            if (!string.IsNullOrEmpty(valueDate))
                date = JsonConvert.DeserializeObject<string[]>(valueDate);
            SearchModel searchModel = new SearchModel()
            {
                TokenId = GetTokenId(),
                PageIndex = pageIndex,
                PageSize = pageSize,
                SearchCondition = new
                {
                    CN_S_STOCK_CODE = stockCode,
                    CN_S_OP_MODE = opMode,
                    CN_S_OP_NO = opNo,
                    CN_S_OP_TYPE = type,
                    CN_S_STATE = state,
                    CN_T_START = !string.IsNullOrEmpty(valueDate) ? date[0] : "",
                    CN_T_END = !string.IsNullOrEmpty(valueDate) ? date[1] : ""
                }
            };
            var result= HttpWMS_Post("api/MoveStock/GetList", JsonConvert.SerializeObject(searchModel));
            return result;
        }

        public string GetMoveStockTaskMsts(int pageIndex, int pageSize, string state, string valueDate)
        {
            string[] date = new string[2];
            if (!string.IsNullOrEmpty(valueDate))
                date = JsonConvert.DeserializeObject<string[]>(valueDate);

            SearchModel searchModel = new SearchModel()
            {
                TokenId = GetTokenId(),
                PageIndex = pageIndex,
                PageSize = pageSize,
                SearchCondition = new
                {
                    CN_S_STATE = state,
                    CN_T_START = !string.IsNullOrEmpty(valueDate) ? date[0] : "",
                    CN_T_END = !string.IsNullOrEmpty(valueDate) ? date[1] : ""
                }
            };
            var result = HttpWMS_Post("api/MoveStockTask/GetMoveStockTaskMsts", JsonConvert.SerializeObject(searchModel));
            return result;
        }

        public string GetMoveStockTaskDtls(string guid)
        {
            var result = HttpWMS_Get("api/MoveStockTask/GetMoveStockTaskDtls?guid=" + guid, "");
            return result;
        }

        public string DeleteTask(string guid)
        {
            string returnstr = HttpWMS_Get("Api/MoveStockTask/Delete?guid=" + guid);
            return returnstr;
        }

        //public string GetCreateList(string stockCode, string stockArea, string locationCode, string opMode, string opType, string itemCode, string itemName)
        //{
        //    SearchModel searchModel = new SearchModel()
        //    {
        //        TokenId = GetTokenId(),
        //        SearchCondition = new
        //        {
        //            CN_S_STOCK_CODE = stockCode,
        //            CN_S_OP_MODE = opMode,
        //            CN_S_OP_TYPE = opType,
        //            CN_S_STATE = opMode,
        //            CN_S_ITEM_CODE = itemCode,
        //            CN_S_ITEM_NAME = itemName
        //        }
        //    };
        //    //todo  后台还没有写
        //    return HttpWMS_Post("api/MoveStock/GetMoveItem", JsonConvert.SerializeObject(searchModel));
        //}


        #region 获取移库货位物料数据
        /// <summary>
        /// 获取移库货位物料数据
        /// </summary>
        /// <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/12/17</history>
        public string GetCreateList(string CN_S_OP_MODE, string CN_S_STOCK_CODE,string CN_S_START_AREA, string CN_S_ITEM_CODE, int pageIndex, int pageSize)
        {
            string sqlWhere = "WHERE 1=1";
            //库区
            if (!string.IsNullOrEmpty(CN_S_START_AREA))
            {
                sqlWhere += " AND CN_S_STOCK_AREA = '" + CN_S_START_AREA + "' ";
            }
            //物料编码
            if (!string.IsNullOrEmpty(CN_S_ITEM_CODE))
            {
                sqlWhere += " AND CN_S_ITEM_CODE LIKE '%" + CN_S_ITEM_CODE + "%' ";
            }
            ////批次号
            //if (!string.IsNullOrEmpty(CN_S_LOT_NO))
            //{
            //    sqlWhere += " AND CN_S_LOT_CODE LIKE '%" + CN_S_LOT_NO + "%' ";
            //}

            //仓库编码
            if (!string.IsNullOrEmpty(CN_S_STOCK_CODE))
            {
                sqlWhere += " AND CN_S_STOCK_CODE = '" + CN_S_STOCK_CODE + "' ";
            }

            sqlWhere += " AND CN_S_STOCK_AREA<>'XNWXK' ";

            string OrdeBy = " order by  CN_S_ITEM_CODE DESC";
            var entity = new
            {
                OrdeBy = OrdeBy,
                sqlWhere = sqlWhere,
                pageSize = pageSize,
                pageIndex = pageIndex,
                type = CN_S_OP_MODE,
                tokenId = GetTokenId()

            };
            string stringjson = JsonConvert.SerializeObject(entity);
            string list = "";

            list = HttpWMS_Post("Api/MoveStock/GetCreateList", stringjson);

            return list;
        }
        #endregion

        #region 货位列表-分页
        /// <summary>
        /// 物料列表-分页
        /// </summary>
        /// <param name="pageIndex"></param>
        /// <param name="pageSize"></param>
        /// <returns></returns>
        public string LocationExtList(int pageIndex, int pageSize, string locationCode, string areaCode)
        {
            var loginer = FormsAuth.GetUserData<LoginerBase>();
            var tokenId = loginer.Extend1;
            var searchModel = new
            {
                tokenId = tokenId,
                PageIndex = pageIndex,
                PageSize = pageSize,
                SearchCondition = new
                {
                    CN_S_LOCATION_CODE = locationCode,
                    CN_S_AREA_CODE = areaCode
                }
            };
            return HttpWMS_Post("api/LocationExt/GetLocationExtList", JsonConvert.SerializeObject(searchModel));
        }
        #endregion

        #region 新增
        /// <summary>
        /// 新增
        /// </summary>
        /// <param name="obj"></param>
        /// <returns></returns>
        /// <history>[HanHe(LT)] CREATED 2018/9/13</history>
        public string MoveAdd(JObject obj)
        {
            var loginer = FormsAuth.GetUserData<LoginerBase>();
            List<TN_WM_MOVE_DTLEntity> dtl = JsonConvert.DeserializeObject<List<TN_WM_MOVE_DTLEntity>>(obj.Value<object>("dtl").ToString());
            TN_WM_MOVE_MSTEntity mst = JsonConvert.DeserializeObject<TN_WM_MOVE_MSTEntity>(obj.Value<object>("mst").ToString());
            mst.CN_S_OP_NO = GetCode(Constants.MoveCode);
            var time = DateTime.Now;
            mst.CN_S_OPREATOR = loginer.UserName;
            mst.CN_T_OP_DATE = time;
            mst.CN_S_CREATOR = loginer.UserCode;
            mst.CN_S_CREATOR_BY = loginer.UserName;
            mst.CN_T_CREATE = time;
            mst.CN_S_MODIFY = loginer.UserCode;
            mst.CN_S_MODIFY_BY = loginer.UserName;
            mst.CN_T_MODIFY = time;
            var entity = new
            {
                mst = mst,
                dtl = dtl,
                tokenId = loginer.Extend1
            };
            string jsonentity = JsonConvert.SerializeObject(entity);

            return HttpWMS_Post("api/MoveStock/Add", jsonentity); ;
        }
        #endregion

        #region 查询移库子表数据分页
        /// <summary>
        /// 查询移库子表数据分页
        /// <returns></returns>
        /// <history>[HanHe(LT)] CREATED 2018/9/18</history>
        public string GetStockMoveDtl(string opNo)
        {
            string sqlWhere = "";
            //移库单号
            if (!string.IsNullOrEmpty(opNo))
            {
                sqlWhere += " CN_S_OP_NO like '%" + opNo + "%' ";
                sqlWhere += " order by  CN_S_OP_NO DESC";
            }
            string list = HttpWMS_Get("Api/MoveStock/GetMoveDtlList?sqlWhere=" + sqlWhere);
            return list;
        }
        #endregion

        #region 查询移库明细数据分页
        /// <summary>
        /// 查询移库明细数据分页
        /// <returns></returns>
        /// <history>[HanHe(LT)] CREATED 2018/9/18</history>
        public string GetMoveResultGroup(string opNo)
        {
            string sqlWhere = "";
            //移库单号
            if (!string.IsNullOrEmpty(opNo))
            {
                sqlWhere += "  WHERE CN_S_OP_NO like '%" + opNo + "%' ";
                sqlWhere += " order by  CN_S_OP_NO DESC";
            }
            string list = HttpWMS_Get("Api/MoveStock/GetMoveResultList?sqlWhere=" + sqlWhere);
            return list;
        }
        #endregion

        #region 根据单号删除
        /// <summary>
        /// 根据单号删除
        /// </summary>
        /// <param name="obj"></param>
        /// <returns></returns>
        ///  <history>[HanHe(LT)] CREATED 2018/9/18</history>
        public string DeleteStockMove(string opNo)
        {
            string returnstr = HttpWMS_Get("Api/MoveStock/DeleteStockMove?opNo=" + opNo);
            return returnstr;
        }
        #endregion

        #region 查询移库单主表
        /// <summary>
        /// 查询移库单主表
        /// </summary>
        /// <param name="CN_S_OP_NO">移库单号</param>
        /// <returns></returns>
        /// <history>[HanHe(LT)] CREATED 2018/9/19</history>
        public string GetMstDtl(string opNo)
        {
            string returnstr = HttpWMS_Get("Api/MoveStock/GetMstDtl?opNo=" + opNo);
            return returnstr;
        }
        #endregion

        #region 修改
        /// <summary>
        /// 修改
        /// </summary>
        /// <param name="obj"></param>
        /// <returns></returns>
        /// <history>[HanHe(LT)] CREATED 2018/9/19</history>
        public string MoveUpdate(JObject obj)
        {

            var loginer = FormsAuth.GetUserData<LoginerBase>();
            List<TN_WM_MOVE_DTLEntity> dtl = JsonConvert.DeserializeObject<List<TN_WM_MOVE_DTLEntity>>(obj.Value<object>("dtl").ToString());
            TN_WM_MOVE_MSTEntity mst = JsonConvert.DeserializeObject<TN_WM_MOVE_MSTEntity>(obj.Value<object>("mst").ToString());
            mst.CN_S_MODIFY = loginer.UserCode;
            mst.CN_S_MODIFY_BY = loginer.UserName;
            mst.CN_T_MODIFY = DateTime.Now;
            var entity = new
            {
                mst = mst,
                dtl = dtl,
                tokenId = loginer.Extend1
            };
            string jsonentity = JsonConvert.SerializeObject(entity);

            return HttpWMS_Post("api/MoveStock/MoveUpdate", jsonentity); ;
        }
        #endregion

        #region 提交
        /// <summary>
        /// 提交
        /// </summary>
        /// <param name="obj"></param>
        /// <returns></returns>
        ///  <history>[HanHe(LT)] CREATED 2018/9/13</history>
        public string Submit(JObject obj)
        {
            var loginer = FormsAuth.GetUserData<LoginerBase>();
            var entity = new
            {
                opNo = obj.Value<string>("opNo"),
                CN_S_CREATOR = loginer.UserCode,
                CN_S_CREATOR_BY = loginer.UserName,
                OrgCode = loginer.ParentOrgCode,
                OrgFlag = loginer.OrgFlag,
                tokenId = loginer.Extend1
            };
            string jsonentity = JsonConvert.SerializeObject(entity);
            string returnstr = HttpWMS_Post("Api/MoveStock/Submit", jsonentity);
            return returnstr;
        }
        #endregion

        #region 获取虚拟库区
        /// <summary>
        /// 获取虚拟库区
        /// </summary>
        /// <param name="include">包含库区类型 1:库区  2：作业区   3：逻辑分区  4：1+2 </param>
        /// <returns></returns>
        /// <history>[HanHe(LT)] CREATED 2018/12/22</history>
        public string GetXNAreaList(string stockCode, string areaCode, int include)
        {
            var data = HttpWMS_Get("Api/MoveStock/GetXNAreaList?stockCode=" + stockCode + "&areaCode=" + areaCode + "&include=" + include);
            return data;
        }
        #endregion

        #region 导出移库列表
        /// <summary>
        /// 导出
        /// </summary>
        ///<param name="obj">实体</param>
        /// <returns></returns>
        /// <history>[HanHe(LT)] CREATED 2019/1/24</history>
        public string ExportMoveList(JObject obj)
        {
            string sqlWhere = "";
            //移库单号
            if (!string.IsNullOrEmpty(obj["opNo"].ToString()))
            {
                sqlWhere += "  WHERE CN_S_OP_NO ='" + obj["opNo"].ToString() + "' ";
            }
            string list = HttpWMS_Get("Api/MoveStock/GetMoveResultList?sqlWhere=" + sqlWhere);

            OperateResult or = JsonConvert.DeserializeObject<OperateResult>(list);
            if (or.Status == ResultStatus.Success)
            {
                string s = ((dynamic)or.Data).ToString();

                DataTable dt = HH.WMS.Utils.ZConvert.ToDataTableTwo(s);
                dynamic columns = obj["columns"];
                string title = "移库单列表";
                string fileName = title + "_" + DateTime.Now.ToString("yyyyMMddHHmmssffff") + ".xls";
                or = ExcelHelper.SaveTemp(columns, title, dt, fileName);
                return JsonConvert.SerializeObject(OperateResult.Succeed("", new { fileName = fileName }));
            }
            else
            {
                return JsonConvert.SerializeObject(or);
            }
        }
        #endregion
    }
}