using HH.AutoBom.Core;
|
using HH.WMS.Common;
|
using HH.WMS.Entitys;
|
using HH.WMS.WebUI.Controllers;
|
using Newtonsoft.Json;
|
using System;
|
using System.Collections.Generic;
|
using System.Data;
|
using System.Linq;
|
using System.Web;
|
using System.Web.Mvc;
|
|
namespace HH.WMS.WebUI.Areas.AllQuery.Controllers
|
{
|
public class ProjectYuShouController : BaseController
|
{
|
//
|
// GET: /AllQuery/AllQueryYuShou/
|
|
/// <summary>
|
/// 库存数量汇总
|
/// </summary>
|
/// <returns></returns>
|
public ActionResult InventoryIndex()
|
{
|
return View();
|
}
|
|
/// <summary>
|
/// 出入库明细（上下架记录）
|
/// </summary>
|
/// <returns></returns>
|
public ActionResult InventoryLocationHistory()
|
{
|
return View();
|
}
|
|
/// <summary>
|
/// 库存业务明细
|
/// </summary>
|
/// <returns></returns>
|
public ActionResult InventoryOrderBussQuery(){
|
return View();
|
}
|
|
/// <summary>
|
/// 货位物料明细
|
/// </summary>
|
/// <returns></returns>
|
public ActionResult InventoryLocation()
|
{
|
return View();
|
}
|
|
#region 宇寿需求变更20190926 新增业务汇总查询
|
|
public ActionResult InventorySummary()
|
{
|
return View();
|
}
|
|
public string GetInventorySummary(int pageIndex, int pageSize, string stockCode, string stockArea, string cn_s_ext2, string itemCode, string opType, string opNo, string location, string itemName, string model,
|
string productionBatch, string owner, string valueDate, string trayCode = "")
|
{
|
string[] date = new string[2];
|
if (!string.IsNullOrEmpty(valueDate))
|
date = JsonConvert.DeserializeObject<string[]>(valueDate);
|
|
var loginer = FormsAuth.GetUserData<LoginerBase>();
|
var searchModel = new
|
{
|
TokenId = loginer.Extend1,
|
PageIndex = pageIndex,
|
PageSize = pageSize,
|
SearchCondition = new
|
{
|
CN_S_STOCK_CODE = stockCode,
|
CN_S_STOCK_AREA = stockArea,
|
CN_S_LOCATION_CODE = location,
|
CN_S_ITEM_CODE = itemCode,
|
CN_S_ITEM_NAME = itemName,
|
CN_S_MODEL = model,
|
CN_S_PRODUCTION_BATCH = productionBatch,
|
CN_S_OP_NO = opNo,
|
CN_S_OWNER = owner,
|
CN_T_START = !string.IsNullOrEmpty(valueDate) ? date[0] : "",
|
CN_T_END = !string.IsNullOrEmpty(valueDate) ? date[1] : "",
|
CN_S_TRAY_CODE = trayCode,
|
CN_S_EXT2 = cn_s_ext2
|
}
|
};
|
return HttpWMS_Post("api/Inventory/GetInventorySummary", JsonConvert.SerializeObject(searchModel));
|
}
|
|
public string ExportInventorySummary()
|
{
|
//XML文件流
|
var sr = new System.IO.StreamReader(Request.InputStream);
|
var stream = sr.ReadToEnd();
|
var loginer = FormsAuth.GetUserData<LoginerBase>();
|
var TokenId = loginer.Extend1;//TokenId
|
var DynamicObject = JsonConvert.DeserializeObject<dynamic>(stream);
|
dynamic formData = DynamicObject["formData"];
|
var searchModel = new
|
{
|
TokenId = loginer.Extend1,
|
SearchCondition = new
|
{
|
CN_S_STOCK_CODE = Util.ToStringInput(formData.stockCode),
|
CN_S_STOCK_AREA = Util.ToStringInput(formData.stockArea),
|
CN_S_ITEM_CODE = Util.ToStringInput(formData.itemCode),
|
CN_S_ITEM_NAME = Util.ToStringInput(formData.itemName),
|
CN_S_MODEL = Util.ToStringInput(formData.model),
|
CN_S_PRODUCTION_BATCH = Util.ToStringInput(formData.productionBatch),
|
CN_S_OP_NO = Util.ToStringInput(formData.opNo),
|
CN_S_STATE = Util.ToStringInput(formData.state),
|
CN_S_OWNER = Util.ToStringInput(formData.owner),
|
CN_S_EXT2 = Util.ToStringInput(formData.cn_s_ext2),
|
showArea = Util.ToStringInput(formData.showArea)
|
}
|
};
|
string result = HttpWMS_Post("api/Inventory/ExportInventorySummary", JsonConvert.SerializeObject(searchModel));
|
OperateResult or = JsonConvert.DeserializeObject<OperateResult>(result);
|
|
string s = ((dynamic)or.Data).rows.ToString();
|
|
DataTable dt = HH.WMS.Utils.ZConvert.ToDataTableTwo(s);
|
//dt.Columns.Add("STOCKQTY");
|
//dt.Columns.Add("CN_F_STOCK_QTY");
|
//foreach (DataRow dr in dt.Rows)
|
//{
|
// dr["STOCKQTY"] = Convert.ToDecimal(dr["CN_F_QUANTITY"]) + Convert.ToDecimal(dr["CN_F_PLANNED_QTY"]) - Convert.ToDecimal(dr["CN_F_ALLOC_QTY"]);
|
// dr["CN_F_STOCK_QTY"] = Convert.ToDecimal(dr["CN_F_PLANNED_QTY"]) == 0 ? 0 : Convert.ToDecimal(dr["CN_F_QUANTITY"]) / Convert.ToDecimal(dr["CN_F_PLANNED_QTY"]);
|
//}
|
dynamic columns = DynamicObject["columns"];
|
string title = "库存业务汇总统计";
|
|
string fileName = title + "_" + DateTime.Now.ToString("yyyyMMddHHmmssffff") + ".xls";
|
or = ExcelHelper.SaveTemp(columns, title, dt, fileName);
|
if (or.Status == ResultStatus.Success)
|
return JsonConvert.SerializeObject(OperateResult.Succeed("", new { fileName = fileName }));
|
else
|
return JsonConvert.SerializeObject(or);
|
}
|
|
#endregion
|
}
|
}
|
