using HH.AutoBom.Core;
|
using HH.WMS.WebUI.Controllers;
|
using Newtonsoft.Json;
|
using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Web;
|
using System.Web.Mvc;
|
|
namespace HH.WMS.WebUI.Areas.Check.Controllers
|
{
|
/// <summary>
|
/// 盘点（南通桑德）
|
/// </summary>
|
public class CheckNtsdController : BaseController
|
{
|
/// <summary>
|
/// 盘点首页
|
/// </summary>
|
/// <returns></returns>
|
public ActionResult Index()
|
{
|
return View();
|
}
|
|
public ActionResult Add()
|
{
|
return View();
|
}
|
|
#region GET
|
|
/// <summary>
|
/// 获取盘点主表数据
|
/// </summary>
|
/// <param name="CN_S_OP_NO">盘点单号</param>
|
/// <param name="CN_S_STOCK_CODE">仓库编码</param>
|
/// <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/7/4</history>
|
public string GetCheckMst(int pageIndex, int pageSize, string CN_S_OP_NO, string CN_S_TYPE, string CN_S_STOCK_CODE, string CHECKTIME, string CN_S_STATE, string valueDate)
|
{
|
string sqlWhere = "WHERE 1=1";
|
|
//仓库编码
|
if (!string.IsNullOrEmpty(CN_S_OP_NO))
|
{
|
sqlWhere += " AND CN_S_OP_NO like '%" + CN_S_OP_NO.Trim() + "%'";
|
}
|
//仓库编码
|
if (!string.IsNullOrEmpty(CN_S_STOCK_CODE))
|
{
|
sqlWhere += " AND CN_S_STOCK_CODE = '" + CN_S_STOCK_CODE + "'";
|
}
|
//类型
|
if (!string.IsNullOrEmpty(CN_S_TYPE))
|
{
|
sqlWhere += " AND CN_S_TYPE = '" + CN_S_TYPE + "' ";
|
}
|
|
string[] date = new string[2];
|
if (!string.IsNullOrEmpty(valueDate))
|
{
|
date = JsonConvert.DeserializeObject<string[]>(valueDate);
|
|
////开始时间
|
if (!string.IsNullOrEmpty(date[0]))
|
{
|
sqlWhere += " AND CN_T_CREATE >= '" + date[0] + "' ";
|
}
|
//结束时间
|
if (!string.IsNullOrEmpty(date[1]))
|
{
|
sqlWhere += " AND CN_T_CREATE <= DateAdd(dd, 1, '" + date[1] + "')";
|
}
|
}
|
////开始时间
|
//if (!string.IsNullOrEmpty(STARTTIME))
|
//{
|
// sqlWhere += " AND CN_T_CREATE >= '" + STARTTIME + "' ";
|
//}
|
////结束时间
|
//if (!string.IsNullOrEmpty(ENDTIME))
|
//{
|
// sqlWhere += " AND CN_T_CREATE <= DateAdd(dd, 1, '" + ENDTIME + "')";
|
//}
|
|
//状态
|
if (!string.IsNullOrEmpty(CN_S_STATE))
|
{
|
sqlWhere += " AND CN_S_STATE = '" + CN_S_STATE + "'";
|
}
|
string OrdeBy = " order by CN_T_CREATE DESC";
|
|
var loginer = FormsAuth.GetUserData<LoginerBase>();
|
var entity = new
|
{
|
tokenId = loginer.Extend1,
|
OrdeBy = OrdeBy,
|
sqlWhere = sqlWhere,
|
pageSize = pageSize,
|
pageIndex = pageIndex
|
};
|
string stringjson = JsonConvert.SerializeObject(entity);
|
string list = HttpWMS_Post("Api/CheckNtsd/GetCheckMst", stringjson);
|
return list;
|
}
|
|
/// <summary>
|
/// 获取盘点明细数据
|
/// </summary>
|
/// <param name="CN_S_OP_NO">仓库编码</param>
|
/// <returns></returns>
|
/// <history>[HanHe(LT)] CREATED 2018/7/4</history>
|
/// <history>[HanHe(dbs)] CREATED 2019/3/18</history>
|
public string GetCheckDtl(string opNo)
|
{
|
string list = HttpWMS_Get("Api/CheckNtsd/GetCheckDtl?opNo=" + opNo);
|
return list;
|
}
|
|
public string GetCheckList(int pageIndex, int pageSize,string CN_S_STOCK_CODE)
|
{
|
string sqlWhere = "WHERE 1=1";
|
|
////仓库编码
|
//if (!string.IsNullOrEmpty(CN_S_OP_NO))
|
//{
|
// sqlWhere += " AND CN_S_OP_NO like '%" + CN_S_OP_NO.Trim() + "%'";
|
//}
|
////仓库编码
|
//if (!string.IsNullOrEmpty(CN_S_STOCK_CODE))
|
//{
|
// sqlWhere += " AND CN_S_STOCK_CODE = '" + CN_S_STOCK_CODE + "'";
|
//}
|
////类型
|
//if (!string.IsNullOrEmpty(CN_S_TYPE))
|
//{
|
// sqlWhere += " AND CN_S_TYPE = '" + CN_S_TYPE + "' ";
|
//}
|
|
//string[] date = new string[2];
|
//if (!string.IsNullOrEmpty(valueDate))
|
//{
|
// date = JsonConvert.DeserializeObject<string[]>(valueDate);
|
|
// ////开始时间
|
// if (!string.IsNullOrEmpty(date[0]))
|
// {
|
// sqlWhere += " AND CN_T_CREATE >= '" + date[0] + "' ";
|
// }
|
// //结束时间
|
// if (!string.IsNullOrEmpty(date[1]))
|
// {
|
// sqlWhere += " AND CN_T_CREATE <= DateAdd(dd, 1, '" + date[1] + "')";
|
// }
|
//}
|
////开始时间
|
//if (!string.IsNullOrEmpty(STARTTIME))
|
//{
|
// sqlWhere += " AND CN_T_CREATE >= '" + STARTTIME + "' ";
|
//}
|
////结束时间
|
//if (!string.IsNullOrEmpty(ENDTIME))
|
//{
|
// sqlWhere += " AND CN_T_CREATE <= DateAdd(dd, 1, '" + ENDTIME + "')";
|
//}
|
|
//状态
|
//if (!string.IsNullOrEmpty(CN_S_STATE))
|
//{
|
// sqlWhere += " AND CN_S_STATE = '" + CN_S_STATE + "'";
|
//}
|
string OrdeBy = " order by CN_T_CREATE DESC";
|
|
var loginer = FormsAuth.GetUserData<LoginerBase>();
|
var entity = new
|
{
|
tokenId = loginer.Extend1,
|
OrdeBy = OrdeBy,
|
sqlWhere = sqlWhere,
|
pageSize = pageSize,
|
pageIndex = pageIndex
|
};
|
string stringjson = JsonConvert.SerializeObject(entity);
|
string list = HttpWMS_Post("Api/CheckNtsd/GetCheckMst", stringjson);
|
return list;
|
}
|
|
#endregion
|
|
|
#region ADD
|
|
|
|
#endregion
|
|
|
}
|
}
|
