using HH.AutoBom.Core;
using HH.WMS.Common;
using HH.WMS.Entitys;
using HH.WMS.Utils.NPOI.HSSF.UserModel;
using HH.WMS.WebUI.Controllers;
using Newtonsoft.Json;
using Newtonsoft.Json.Linq;
using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using System.Xml;


namespace HH.WMS.WebUI.Areas.OutStock.Controllers
{
    public class SortingController : BaseController
    {
        public ActionResult SortingList()
        {
            return View();
        }

        public ActionResult FilePathDownload(string opNo, string province,string fromNo)
        {
            var ss = HttpWMS_Get("api/Sorting/GetOrderSortingRelByOrderNo?opNo=" + opNo);
            var obj = JObject.Parse(ss);
            List<TN_WM_ORDER_SORTING_RELEntity> list = JsonConvert.DeserializeObject<List<TN_WM_ORDER_SORTING_RELEntity>>(obj["Data"].ToString());

            XmlDocument xml = new XmlDocument();

            //创建第一行描述信息  
            //版本   编码格式    
            XmlDeclaration theFirstRowOfXml = xml.CreateXmlDeclaration("1.0", "UTF-8", null);
            xml.AppendChild(theFirstRowOfXml);

            //保存之前要创建根节点,根节点的名字是Datalist  
            XmlElement Datalist = xml.CreateElement("Datalist");
            Datalist.SetAttribute("corpName", "宁波三生生物科技有限公司");//添加属性
            Datalist.SetAttribute("dataType", "wareHouseOut");
            Datalist.SetAttribute("version", "1.1");
            Datalist.SetAttribute("xmlns:xsi", "http://www.w3.org/2001/XMLSchema-instance");
            Datalist.SetAttribute("xsi:noNamespaceSchemaLocation", "兽药产品出库数据1.1.xsd");
            //再把创建的根节点加入到xml中  
            xml.AppendChild(Datalist);
            //
            XmlElement Product = xml.CreateElement("Product");
            Datalist.AppendChild(Product);
            //var loginer = FormsAuth.GetUserData<LoginerBase>();
            XmlElement Batch = xml.CreateElement("Batch");
            Batch.SetAttribute("operator", list[0].CN_S_CREATOR_BY);
            Batch.SetAttribute("oprDate", DateTime.Now.ToString("yyyy/MM/dd"));
            string toProvince = string.Empty, toUnit = string.Empty;
            if (!string.IsNullOrEmpty(province) && province != "null")
            {
                if (province.EndsWith("省"))
                {
                    toProvince = province;
                    toUnit = province.TrimEnd('省');
                }else if (province.EndsWith("市"))
                {
                    toProvince = province;
                    toUnit = province.TrimEnd('市');
                }

            }
            Batch.SetAttribute("toProvince", toProvince);
            Batch.SetAttribute("toUnit", toUnit);
            Product.AppendChild(Batch);

            foreach (TN_WM_ORDER_SORTING_RELEntity entity in list)
            {
                if (!string.IsNullOrEmpty(entity.CN_S_UNIQUE_CODE))
                {
                    XmlElement Data = xml.CreateElement("Data");
                    Data.SetAttribute("code", entity.CN_S_UNIQUE_CODE);
                    Batch.AppendChild(Data);
                }
            }
            //string dir = Server.MapPath("~/XmlTemplate");
            //dir = dir + "\\"+DateTime.Now.ToString("yyyyMMddHHmmss")+".xml";
            //xml.Save(dir);//保存
            //var path = dir;
            byte[] data;
            //byte[] fileContents = Encoding.Default.GetBytes(sbHtml.ToString());
            using (MemoryStream ms = new MemoryStream())
            {
                xml.Save(ms);
                data = ms.ToArray();
            }

            var no = "";
            if (!string.IsNullOrEmpty(fromNo)&&fromNo!="null")
            {
                no = fromNo;
            }
            else 
            {
                no = opNo;
            }

            return File(data, "text/xml", "" + no + ".xml");
        }


        #region 分拣单列表
        /// <summary>
        /// 分拣单列表
        /// </summary>
        /// <param name="searchModel"></param>
        /// <returns></returns>
        public string GetSortingList(int pageIndex, int pageSize, string sortingNo)
        {
            var searchModel = new
            {
                PageIndex = pageIndex,
                PageSize = pageSize,
                SearchCondition = new
                {
                    SortingNo = sortingNo
                }
            };
            return HttpWMS_Post("api/Sorting/GetSortingList", JsonConvert.SerializeObject(searchModel));
        }
        #endregion

        #region 分拣数据
        /// <summary>
        /// 分拣数据
        /// </summary>
        /// <param name="sortingNo"></param>
        /// <returns></returns>
        public string GetSortingDtl(string sortingNo)
        {
            return HttpWMS_Get("api/Sorting/GetSortingDtl?sortingNo=" + sortingNo);
        }
        #endregion

        #region 分拣明细
        /// <summary>
        /// 分拣明细
        /// </summary>
        /// <param name="sortingNo"></param>
        /// <returns></returns>
        public string GetSortingLocation(string sortingNo)
        {
            return HttpWMS_Get("api/Sorting/GetCurrentSortingLocation?sortingNo=" + sortingNo);
        }
        #endregion

        #region 分拣结果
        /// <summary>
        /// 分拣结果
        /// </summary>
        /// <param name="sortingNo"></param>
        /// <returns></returns>
        public string GetSortingResult(string sortingNo)
        {
            return HttpWMS_Get("api/Sorting/GetSortingResult?sortingNo=" + sortingNo);
        }
        #endregion

        #region 分拣单实体

        /// <summary>
        /// 分拣单实体
        /// </summary>
        /// <param name="sortingNo"></param>
        /// <returns></returns>
        public string GetSortingModel(string sortingNo)
        {
            return HttpWMS_Get("api/Sorting/GetSortingModel?sortingNo=" + sortingNo);
        }
        #endregion

#region 导出xml文件
        public string CreateXmlFile(string opNo, string province)
        {

            var result = "";
            var ss = HttpWMS_Get("api/Sorting/GetOrderSortingRel?opNo=" + opNo);
            var obj = JObject.Parse(ss);
            List<TN_WM_ORDER_SORTING_RELEntity> list = JsonConvert.DeserializeObject<List<TN_WM_ORDER_SORTING_RELEntity>>(obj["Data"].ToString());

            XmlDocument xml = new XmlDocument();

            //创建第一行描述信息  
            //版本   编码格式    
            XmlDeclaration theFirstRowOfXml = xml.CreateXmlDeclaration("1.0", "UTF-8", null);
            xml.AppendChild(theFirstRowOfXml);

            //保存之前要创建根节点,根节点的名字是Datalist  
            XmlElement Datalist = xml.CreateElement("Datalist");
            Datalist.SetAttribute("corpName", "宁波三生生物科技有限公司");//添加属性
            Datalist.SetAttribute("dataType", "wareHouseOut");
            Datalist.SetAttribute("version", "1.1");
            Datalist.SetAttribute("xmlns:xsi", "http://www.w3.org/2001/XMLSchema-instance");
            Datalist.SetAttribute("xsi:noNamespaceSchemaLocation", "兽药产品出库数据1.1.xsd");
            //再把创建的根节点加入到xml中  
            xml.AppendChild(Datalist);
            //
            XmlElement Product = xml.CreateElement("Product");
            Datalist.AppendChild(Product);
            var loginer = FormsAuth.GetUserData<LoginerBase>();
            XmlElement Batch = xml.CreateElement("Batch");
            Batch.SetAttribute("toUnit", province);
            Batch.SetAttribute("toProvince", province);
            Batch.SetAttribute("oprDate", DateTime.Now.ToString("yyyy-MM-dd"));
            Batch.SetAttribute("operator", loginer.UserName);
            Product.AppendChild(Batch);

            foreach (TN_WM_ORDER_SORTING_RELEntity entity in list)
            {
                XmlElement Data = xml.CreateElement("Data");
                Data.SetAttribute("code", entity.CN_S_UNIQUE_CODE);
                Batch.AppendChild(Data);
            }
            try
            {
                this.Response.Clear();
                this.Response.Buffer = true;
                this.Response.ContentType = "text/xml";
                this.Response.AppendHeader("Content-Disposition", "attachment;filename=" + "sorting.xml");
                this.Response.AppendHeader("base", "target=\"_blank\"");

                this.Response.Write(xml);
                //this.Response.End();
                string dir = Environment.GetFolderPath(Environment.SpecialFolder.DesktopDirectory);
                dir = dir + "\\sorting.xml";
                xml.Save(dir);
                result = JsonConvert.SerializeObject(OperateResult.Succeed());
                return result;
            }
            catch (Exception e)
            {
                return JsonConvert.SerializeObject(OperateResult.Error(e.Message));
                //显示错误信息    
                //Console.WriteLine(e.Message);
            }
            //Console.ReadLine();    

        }
        #endregion
        

        #region 导出注释
        //public void CreateXmlFile(string opNo)
        //{

        //    XmlDocument xmlDoc = new XmlDocument();
        //    //创建类型声明节点    
        //    XmlNode node = xmlDoc.CreateXmlDeclaration("1.0", "UTF-8", "");
        //    xmlDoc.AppendChild(node);


        //    List<string> clist = new List<string>();
        //    int ii = clist.Count;

        //    //创建根节点    
        //    XmlNode Datalist = xmlDoc.CreateElement("DataList");
        //    xmlDoc.AppendChild(Datalist);

        //    //var root = xmlDoc.DocumentElement;//取到根结点
        //    XmlElement Datalistnodes = (XmlElement)xmlDoc.SelectSingleNode("DataList");//获取节点添加属性
        //    //newNode.InnerText = "WPF"<a>WPF</a>
        //    Datalistnodes.SetAttribute("corpName", "宁波三生生物科技有限公司");//<a corpName=""></a>
        //    Datalistnodes.SetAttribute("dataType", "wareHouseOut");
        //    Datalistnodes.SetAttribute("version", "1.1");
        //    Datalistnodes.SetAttribute("xmlns:xsi", "http://www.w3.org/2001/XMLSchema-instance");
        //    Datalistnodes.SetAttribute("xsi:noNamespaceSchemaLocation", "兽药产品出库数据1.1.xsd");

        //    //添加下级节点
        //    XmlNode Product = xmlDoc.CreateNode(XmlNodeType.Element, "Product", null);
        //    Datalist.AppendChild(Product);
        //    //节点
        //    XmlNode Batch = xmlDoc.CreateNode(XmlNodeType.Element, "Batch", null);
        //    Product.AppendChild(Batch);
        //    XmlElement Batchnodes = (XmlElement)xmlDoc.SelectSingleNode("Batch");//获取节点添加属性
        //    Datalistnodes.SetAttribute("operator", "PDA管理员");
        //    Datalistnodes.SetAttribute("dataType", "2018/10/31");
        //    Datalistnodes.SetAttribute("toProvince", "江苏省");
        //    Datalistnodes.SetAttribute("toUnit", "江苏");


        //    for (int i = 0; i < ii; i++)
        //    {
        //        CreateNode(xmlDoc, Datalist, "Ids", "1");
        //        CreateNode(xmlDoc, Datalist, "Id", "2");
        //        CreateNode(xmlDoc, Datalist, "PC", "3");
        //    }
        //    try
        //    {
        //        xmlDoc.Save("c://sorting.xml");
        //    }
        //    catch (Exception e)
        //    {
        //        //显示错误信息    
        //        Console.WriteLine(e.Message);
        //    }
        //    //Console.ReadLine();    

        //}
        ///// <summary>      
        ///// 创建节点      
        ///// </summary>      
        ///// <param name="xmldoc"></param>  xml文档    
        ///// <param name="parentnode"></param>父节点      
        ///// <param name="name"></param>  节点名    
        ///// <param name="value"></param>  节点值    
        /////     
        //public void CreateNode(XmlDocument xmlDoc, XmlNode parentNode, string name, string value)
        //{
        //    XmlNode node = xmlDoc.CreateNode(XmlNodeType.Element, name, null);
        //    node.InnerText = value;
        //    parentNode.AppendChild(node);
        //}
        #endregion
    }
}