using NFine.Application.WMS;
using System;
using System.Collections.Generic;
using System.Data;
using System.IO;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using NFine.Code;
using System.Data.SqlClient;
using NFine.Data.Extensions;
using System.Data.OleDb;
using System.Configuration;
using ICS.Application.Entity;
using NFine.Application.DHAY;

namespace NFine.Web.Areas.DHAY.Controllers
{
    public class ICSOtherInOutController : ControllerBase
    {
        // GET: WMS/PickMaterial
        ICSOtherInOutApp App = new ICSOtherInOutApp();
       
        public ActionResult Index()
        {
            return View();
        }

   
        /// <summary>
        /// 查询其他入库出库主表信息
        /// </summary>
        /// <param name="pagination"></param>
        /// <param name="queryJson"></param>
        /// <returns></returns>
        public ActionResult GetList(Pagination pagination, string queryJson)
        {
            DataTable ListData = App.GetList(queryJson,ref pagination);
            var JsonData = new
            {
                total = pagination.total,
                page = pagination.page,
                records = pagination.records,
                rows = ListData,
            };
            return Content(JsonData.ToJson());
        }

   
        /// <summary>
        /// 查询其他入库出库子表信息
        /// </summary>
        /// <param name="pagination"></param>
        /// <param name="queryJson"></param>
        /// <returns></returns>
       
        public ActionResult GetDetails(Pagination pagination, string queryJson,string ID)
        {
            DataTable ListData = App.GetDetails(queryJson, ref pagination,ID);
            var JsonData = new
            {
                total = pagination.total,
                page = pagination.page,
                records = pagination.records,
                rows = ListData,
            };
            return Content(JsonData.ToJson());
        }

        [HttpPost]
        public void StatementExportAll(string StartDate,string EndDate,string InvCode,string WHCode,string LocationCode,string BatchCode)
        {
            //ID = ID.Substring(0, ID.Length - 2);
            DataTable dt = App.StatementExportAll( StartDate,  EndDate,  InvCode,  WHCode,LocationCode,BatchCode);
            AsposeCell.Export(dt);
        }

    }
}