You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
55 lines
1.6 KiB
55 lines
1.6 KiB
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;
|
|
|
|
namespace NFine.Web.Areas.DHAY.Controllers
|
|
{
|
|
public class ICSCheckListController : ControllerBase
|
|
{
|
|
// GET: WMS/PickMaterial
|
|
ICSCheckListApp App = new ICSCheckListApp();
|
|
|
|
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());
|
|
}
|
|
|
|
[HttpPost]
|
|
public void StatementExportAll(string StartDate,string EndDate,string InvCode,string WHCode,string LocationCode)
|
|
{
|
|
//ID = ID.Substring(0, ID.Length - 2);
|
|
DataTable dt = App.StatementExportAll( StartDate, EndDate, InvCode, WHCode,LocationCode);
|
|
AsposeCell.Export(dt);
|
|
}
|
|
|
|
}
|
|
}
|