using HH.AutoBom.Core;
|
using HH.WMS.Common;
|
using HH.WMS.Entitys;
|
using HH.WMS.Entitys.Check;
|
using HH.WMS.Entitys.Common;
|
using HH.WMS.WebUI.Controllers;
|
using Newtonsoft.Json;
|
using Newtonsoft.Json.Linq;
|
using System;
|
using System.Collections.Generic;
|
using System.Data;
|
using System.Linq;
|
using System.Web;
|
using System.Web.Mvc;
|
|
namespace HH.WMS.WebUI.Areas.Check.Controllers
|
{
|
public class CheckController : BaseController
|
{
|
//
|
// GET: /Check/Check/
|
|
public ActionResult Index()
|
{
|
return View();
|
}
|
/// <summary>
|
/// 新增
|
/// </summary>
|
/// <returns></returns>
|
public ActionResult CheckAdd()
|
{
|
return View();
|
}
|
|
public ActionResult Batch()
|
{
|
return View();
|
}
|
|
public ActionResult CheckCount()
|
{
|
return View();
|
}
|
|
#region 获取盘点主表数据
|
/// <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/Check/GetDataTable", 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/Check/GetCheckDtl?opNo=" + opNo);
|
return list;
|
}
|
|
/// <summary>
|
/// 获取盘点明细表数据
|
/// </summary>
|
/// <param name="CN_S_OP_NO">仓库编码</param>
|
/// <returns></returns>
|
/// <history>[HanHe(LT)] CREATED 2018/7/4</history>
|
public string GetCheckList(string opNo)
|
{
|
return HttpWMS_Get("Api/Check/GetCheckList?opNo=" + opNo);
|
}
|
#endregion
|
|
public string GetModel(string opNo)
|
{
|
return HttpWMS_Get("Api/Check/GetModel?opNo=" + opNo);
|
}
|
#region 获取盘点子表数据
|
/// <summary>
|
/// 获取盘点主表数据
|
/// </summary>
|
/// <param name="CN_S_OP_NO">仓库编码</param>
|
/// <returns></returns>
|
/// <history>[HanHe(LT)] CREATED 2018/7/4</history>
|
public string GetDataTableDtls(string CN_S_OP_NO, string ps, string pg)
|
{
|
string sqlWhere = "WHERE 1=1";
|
//业务号
|
if (!string.IsNullOrEmpty(CN_S_OP_NO))
|
{
|
sqlWhere += " AND CN_S_OP_NO = '" + CN_S_OP_NO + "'";
|
}
|
|
string OrdeBy = " order by CN_S_OP_NO DESC";
|
|
var loginer = FormsAuth.GetUserData<LoginerBase>();
|
|
var TokenId = loginer.Extend1;//TokenId
|
var entity = new
|
{
|
tokenId = TokenId,
|
OrdeBy = OrdeBy,
|
sqlWhere = sqlWhere,
|
pageSize = ps,
|
pageIndex = pg
|
};
|
string stringjson = JsonConvert.SerializeObject(entity);
|
string list = HttpWMS_Post("Api/Check/GetDataTableDtl", stringjson);
|
return list;
|
}
|
|
/// <summary>
|
/// 获取子表数据
|
/// </summary>
|
/// <param name="CN_S_OP_NO">盘点数据</param>
|
/// <returns></returns>
|
/// <history>[HanHe(LT)] CREATED 2018/7/13</history>
|
public string GetCheckMstDtlBywhere(string CN_S_OP_NO)
|
{
|
string sqlwhere = "";
|
if (!string.IsNullOrEmpty(CN_S_OP_NO))
|
{
|
sqlwhere += "AND a.CN_S_OP_NO='" + CN_S_OP_NO + "'";
|
}
|
string list = HttpWMS_Get("Api/Check/GetCheckMstDtlBywhere?sqlwhere=" + sqlwhere);
|
return list;
|
}
|
#endregion
|
|
#region 获取盘点明细表数据
|
/// <summary>
|
/// 获取盘点明细表数据
|
/// </summary>
|
/// <param name="CN_S_OP_NO">仓库编码</param>
|
/// <returns></returns>
|
/// <history>[HanHe(LT)] CREATED 2018/7/4</history>
|
public string GetDataTableCheckLists(string CN_S_OP_NO, string ps, string pg)
|
{
|
string sqlWhere = "WHERE 1=1";
|
//业务号
|
if (!string.IsNullOrEmpty(CN_S_OP_NO))
|
{
|
sqlWhere += " AND CN_S_OP_NO = '" + CN_S_OP_NO + "'";
|
}
|
|
string OrdeBy = " order by CN_S_OP_NO DESC";
|
var loginer = FormsAuth.GetUserData<LoginerBase>();
|
|
var TokenId = loginer.Extend1;//TokenId
|
var entity = new
|
{
|
tokenId = TokenId,
|
OrdeBy = OrdeBy,
|
sqlWhere = sqlWhere,
|
pageSize = ps,
|
pageIndex = pg
|
};
|
string stringjson = JsonConvert.SerializeObject(entity);
|
string list = HttpWMS_Post("Api/Check/GetGroupDataTable", stringjson);
|
return list;
|
}
|
|
public string GetDataTableCheckLists(string CN_S_OP_NO, string CN_S_STOCK_CODE, string CN_S_STOCK_AREA, string CN_S_ITEM_CODE, string ps, string pg)
|
{
|
string sqlWhere = "WHERE 1=1";
|
//盘点号
|
if (!string.IsNullOrEmpty(CN_S_OP_NO))
|
{
|
sqlWhere += " AND CN_S_OP_NO = '" + CN_S_OP_NO + "'";
|
}
|
//仓库
|
if (!string.IsNullOrEmpty(CN_S_STOCK_CODE))
|
{
|
sqlWhere += " AND CN_S_STOCK_CODE = '" + CN_S_STOCK_CODE + "'";
|
}
|
//库区
|
if (!string.IsNullOrEmpty(CN_S_STOCK_AREA))
|
{
|
sqlWhere += " AND CN_S_STOCK_AREA = '" + CN_S_STOCK_AREA + "'";
|
}
|
//物料编码
|
if (!string.IsNullOrEmpty(CN_S_ITEM_CODE))
|
{
|
sqlWhere += " AND CN_S_ITEM_CODE = '" + CN_S_ITEM_CODE + "'";
|
}
|
string OrdeBy = " order by CN_S_OP_NO DESC";
|
var entity = new
|
{
|
OrdeBy = OrdeBy,
|
sqlWhere = sqlWhere,
|
pageSize = ps,
|
pageIndex = pg
|
};
|
string stringjson = JsonConvert.SerializeObject(entity);
|
string list = HttpWMS_Post("Api/Check/GetGroupDataTable", stringjson);
|
return list;
|
}
|
#endregion
|
|
#region 获取盘点货位物料数据
|
/// <summary>
|
/// 获取盘点货位物料数据
|
/// </summary>
|
/// <param name="checkType">盘点类型</param>
|
/// <param name="stockCode">仓库号</param>
|
/// <param name="stockArea">库区</param>
|
/// <param name="itemCode">物料编号</param>
|
/// <param name="owner">货主</param>
|
/// <param name="lotNo">到货批次</param>
|
/// <param name="locationCode">货位</param>
|
/// <param name="pageIndex"></param>
|
/// <param name="pageSize"></param>
|
/// <returns></returns>
|
/// <history>[HanHe(DBS)] CREATED 2019/3/14</history>
|
public string GetTrayLocation(string checkType, string stockCode, string stockArea, string itemCode, string owner, string lotNo, string locationCode, int pageIndex, int pageSize)
|
{
|
var loginer = FormsAuth.GetUserData<LoginerBase>();
|
SearchModel searchModel = new SearchModel()
|
{
|
TokenId = loginer.Extend1,
|
PageIndex = pageIndex,
|
PageSize = pageSize,
|
SearchCondition = new
|
{
|
CN_S_TYPE = checkType,
|
CN_S_STOCK_CODE = stockCode,
|
CN_S_STOCK_AREA = stockArea,
|
CN_S_ITEM_CODE = itemCode,
|
CN_S_OWNER = owner,
|
CN_S_LOT_NO = lotNo,
|
CN_S_LOCATION_CODE = locationCode
|
}
|
};
|
|
return HttpWMS_Post("Api/Check/GetTrayLocation", JsonConvert.SerializeObject(searchModel));
|
}
|
#endregion
|
|
#region 新增
|
/// <summary>
|
/// 新增
|
/// </summary>
|
/// <param name="obj"></param>
|
/// <returns></returns>
|
/// <history>[HanHe(LT)] CREATED 2018/7/12</history>
|
/// <history>[HanHe(DBS)] CREATED 2019/3/18</history>
|
public string Add(JObject obj)
|
{
|
var loginer = FormsAuth.GetUserData<LoginerBase>();
|
string code = GetCode(Constants.CheckCode);
|
var time = DateTime.Now;
|
TN_WM_CHECK_MSTEntity entitymst = new TN_WM_CHECK_MSTEntity()
|
{
|
TokenId = ViewConstants.TokenId,
|
CN_S_OP_NO = code,
|
CN_S_STOCK_CODE = obj.Value<string>("stockcode"),
|
CN_T_OP_TIME = time,
|
CN_S_STATE = obj.Value<string>("state"),
|
CN_S_TYPE = obj.Value<string>("type"),
|
CN_S_CREATOR = ViewConstants.UserData.UserCode,
|
CN_S_CREATOR_BY = ViewConstants.UserData.UserName,
|
CN_T_CREATE = time,
|
CN_S_MODIFY = ViewConstants.UserData.UserCode,
|
CN_S_MODIFY_BY = ViewConstants.UserData.UserName,
|
CN_T_MODIFY = time,
|
dtls = JsonConvert.DeserializeObject<List<TN_WM_CHECK_DTLEntity>>(obj["rows"].ToString())
|
};
|
for(int i=0;i< entitymst.dtls.Count;i++)
|
{
|
entitymst.dtls[i].CN_S_OP_NO = code;
|
entitymst.dtls[i].CN_N_ROW_NO = i + 1;
|
};
|
string jsonentity = JsonConvert.SerializeObject(entitymst);
|
var str = HttpWMS_Post("Api/Check/AddCheck", jsonentity);
|
return str;
|
}
|
#endregion
|
|
#region 提交
|
/// <summary>
|
/// 提交
|
/// </summary>
|
/// <param name="obj"></param>
|
/// <returns></returns>
|
/// <history>[HanHe(LT)] CREATED 2018/8/24</history>
|
public string Submit(JObject obj)
|
{
|
var loginer = FormsAuth.GetUserData<LoginerBase>();
|
var entity = new
|
{
|
opNo = obj.Value<string>("opNo"),
|
//type = obj.Value<string>("type"),
|
tokenid = loginer.Extend1
|
};
|
string jsonentity = JsonConvert.SerializeObject(entity);
|
string returnstr = HttpWMS_Post("Api/Check/Submit", jsonentity);
|
return returnstr;
|
}
|
#endregion
|
|
#region 根据盘点单号删除
|
/// <summary>
|
/// 根据盘点单号删除
|
/// </summary>
|
/// <param name="obj"></param>
|
/// <returns></returns>
|
/// <history>[HanHe(LT)] CREATED 2018/8/24</history>
|
public string Delete(string opNo)
|
{
|
return HttpWMS_Get("Api/Check/Delete?opNo=" + opNo);
|
}
|
#endregion
|
|
#region 新增批量
|
/// <summary>
|
/// 新增
|
/// </summary>
|
/// <param name="obj"></param>
|
/// <returns></returns>
|
/// <history>[HanHe(LT)] CREATED 2018/7/12</history>
|
public string AddBatch(JObject obj)
|
{
|
var loginer = FormsAuth.GetUserData<LoginerBase>();;
|
string code = GetCode(Constants.CheckCode);
|
|
TN_WM_CHECK_MSTEntity entitymst = new TN_WM_CHECK_MSTEntity();
|
|
//TN_WM_CHECK_DTLEntity entity = JsonHelper.ParseFormJson<TN_WM_CHECK_DTLEntity>(obj.ToString());
|
string CN_S_STOCK_CODE = obj.Value<string>("CN_S_STOCK_CODE");
|
string CN_S_STOCK_AREA = obj.Value<string>("CN_S_STOCK_AREA");
|
string CN_S_ITEM_CODE = obj.Value<string>("CN_S_ITEM_CODE");
|
string CN_S_OWNER = obj.Value<string>("CN_S_OWNER");
|
string CN_S_LOT_NO = obj.Value<string>("CN_S_LOT_NO");
|
string CN_S_LOCATION_CODE = obj.Value<string>("CN_S_LOCATION_CODE");
|
var time = DateTime.Now;
|
entitymst.CN_S_OP_NO = code;
|
entitymst.CN_S_STOCK_CODE = obj.Value<string>("CN_S_STOCK_CODE");
|
entitymst.CN_T_OP_TIME = time;
|
entitymst.CN_S_STATE = "新建";
|
entitymst.CN_S_TYPE = "自定义盘点";
|
entitymst.CN_S_CREATOR = loginer.UserCode;
|
entitymst.CN_S_CREATOR_BY = loginer.UserName;
|
entitymst.CN_T_CREATE = time;
|
entitymst.CN_S_MODIFY = loginer.UserCode;
|
entitymst.CN_S_MODIFY_BY = loginer.UserName;
|
entitymst.CN_T_MODIFY = time;
|
|
|
string sqlWhere = "WHERE 1=1";
|
//仓库编码
|
if (!string.IsNullOrEmpty(CN_S_STOCK_CODE))
|
{
|
sqlWhere += " AND CN_S_STOCK_CODE = '" + CN_S_STOCK_CODE + "'";
|
}
|
//库区
|
if (!string.IsNullOrEmpty(CN_S_STOCK_AREA))
|
{
|
sqlWhere += " AND CN_S_STOCK_AREA = '" + CN_S_STOCK_AREA + "' ";
|
}
|
//物料编码
|
if (!string.IsNullOrEmpty(CN_S_ITEM_CODE))
|
{
|
sqlWhere += " AND CN_S_ITEM_CODE LIKE '%" + CN_S_ITEM_CODE.Trim() + "%' ";
|
}
|
//货主
|
if (!string.IsNullOrEmpty(CN_S_OWNER))
|
{
|
sqlWhere += " AND CN_S_OWNER = '" + CN_S_OWNER + "' ";
|
}
|
//批次号
|
if (!string.IsNullOrEmpty(CN_S_LOT_NO))
|
{
|
sqlWhere += " AND CN_S_LOT_NO like '%" + CN_S_LOT_NO.Trim() + "%' ";
|
}
|
//货位编码
|
if (!string.IsNullOrEmpty(CN_S_LOCATION_CODE))
|
{
|
sqlWhere += " AND CN_S_LOCATION_CODE like '%" + CN_S_LOCATION_CODE.ToUpper().Trim() + "%'";
|
}
|
|
sqlWhere += " AND CN_F_QUANTITY>0";
|
var entity = new
|
{
|
entityMst = entitymst,
|
sqlwhere = sqlWhere,
|
type = "货位盘点",
|
tokenId = loginer.Extend1
|
};
|
string jsonentity = JsonConvert.SerializeObject(entity);
|
string returnstr = HttpWMS_Post("Api/Check/AddCheckBatch", jsonentity);
|
return returnstr;
|
}
|
#endregion
|
|
#region 修改
|
/// <summary>
|
/// 修改
|
/// </summary>
|
/// <param name="obj"></param>
|
/// <returns></returns>
|
/// <history>[HanHe(LT)] CREATED 2018/7/12</history>
|
public string Update(JObject obj)
|
{
|
|
TN_WM_CHECK_MSTEntity entitymst = new TN_WM_CHECK_MSTEntity();
|
entitymst.TokenId = ViewConstants.TokenId;
|
entitymst.CN_S_OP_NO = obj.Value<string>("opNo");
|
entitymst.CN_S_MODIFY = ViewConstants.UserData.UserCode;
|
entitymst.CN_S_MODIFY_BY = ViewConstants.UserData.UserName;
|
entitymst.CN_T_MODIFY = DateTime.Now;
|
entitymst.dtls =JsonConvert.DeserializeObject<List<TN_WM_CHECK_DTLEntity>>(obj.Value<object>("rows").ToString());
|
|
for (int i = 0; i < entitymst.dtls.Count; i++)
|
{
|
entitymst.dtls[i].CN_S_OP_NO = entitymst.CN_S_OP_NO;
|
entitymst.dtls[i].CN_N_ROW_NO = i + 1;
|
};
|
//var entity = new
|
//{
|
// entityMst = entitymst,
|
// entityDtl = entityDtls,
|
// tokenId = loginer.Extend1
|
//};
|
string jsonentity = JsonConvert.SerializeObject(entitymst);
|
return HttpWMS_Post("Api/Check/Update", jsonentity);
|
}
|
#endregion
|
|
#region 获取盘点明细表数据
|
/// <summary>
|
/// 获取盘点明细表数据
|
/// </summary>
|
/// <param name="opNo">
|
/// <param name="stockArea"></param>
|
/// <param name="itemCode"></param></param>
|
/// <param name="pageIndex"></param>
|
/// <param name="pageSize"></param>
|
/// <returns></returns>
|
/// <history>[HanHe(dbs)] CREATED 2019/3/22</history>
|
public string CheckCounts(string opNo, string stockArea, string itemCode, int pageIndex, int pageSize)
|
{
|
var loginer = FormsAuth.GetUserData<LoginerBase>();
|
SearchModel entity = new SearchModel()
|
{
|
PageIndex = pageIndex,
|
PageSize = pageSize,
|
TokenId = loginer.Extend1,
|
SearchCondition = new
|
{
|
CN_S_OP_NO = opNo,
|
CN_S_STOCK_AREA=stockArea,
|
CN_S_ITEM_CODE=itemCode
|
}
|
};
|
string stringjson = JsonConvert.SerializeObject(entity);
|
string list = HttpWMS_Post("Api/Check/CheckResultShow", stringjson);
|
return list;
|
}
|
#endregion
|
|
#region 盘点单确认
|
/// <summary>
|
/// 盘点单确认
|
/// </summary>
|
/// <param name="opNo">盘点单号</param>
|
/// <returns></returns>
|
/// <history>[HanHe(DBS)] CREATED 2019/3/22</history>
|
public string confirm(string opNo)
|
{
|
return HttpWMS_Get("Api/Check/CheckConfirm?opNo="+opNo);
|
}
|
#endregion
|
|
#region 执行盘点
|
/// <summary>
|
/// 执行盘点
|
/// </summary>
|
/// <param name="obj">执行盘点操作</param>
|
/// <returns></returns>
|
/// <history>[HanHe(LT)] CREATED 2018/8/31</history>
|
public string implement(string opNo)
|
{
|
string info = HttpWMS_Get("Api/Check/implement?opNo=" + opNo);
|
return info;
|
}
|
#endregion
|
|
#region 导出盘点列表
|
/// <summary>
|
/// 导出
|
/// </summary>
|
///<param name="obj">实体</param>
|
/// <returns></returns>
|
/// <history>[HanHe(LT)] CREATED 2019/1/24</history>
|
public string ExportCheckList(JObject obj)
|
{
|
string list = HttpWMS_Get("Api/Check/GetCheckList?opNo=" + obj["opNo"].ToString());
|
//string list = HttpWMS_Get("Api/Check/GetGroupDT?CN_S_OP_NO=" + obj["opNo"].ToString());
|
OperateResult or = JsonConvert.DeserializeObject<OperateResult>(list);
|
if (or.Status == ResultStatus.Success)
|
{
|
string s = ((dynamic)or.Data).ToString();
|
|
DataTable dt = HH.WMS.Utils.ZConvert.ToDataTableTwo(s);
|
dt.Columns.Add("BREAKQUANTITY");
|
foreach (DataRow dr in dt.Rows)
|
{
|
dr["BREAKQUANTITY"] =Convert.ToDecimal(dr["CN_F_CHECK_QTY"]) - Convert.ToDecimal(dr["CN_F_QUANTITY"]);
|
}
|
dynamic columns = obj["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 }));
|
return JsonConvert.SerializeObject(or);
|
}
|
else {
|
return JsonConvert.SerializeObject(or);
|
}
|
}
|
|
|
/// <summary>
|
/// 导出盈亏统计
|
/// </summary>
|
///<param name="obj">实体</param>
|
/// <returns></returns>
|
/// <history>[HanHe(LT)] CREATED 2019/1/24</history>
|
public string ExportCheckListCount(JObject obj)
|
{
|
JObject formData = (JObject)obj["formData"];
|
|
string sqlWhere = "";
|
|
var opNo = formData["CN_S_OP_NO"].ToString();
|
|
var stockCode =formData["CN_S_STOCK_CODE"].ToString();
|
|
var areaCode =formData["CN_S_STOCK_AREA"].ToString();
|
|
var itemCode = formData["CN_S_ITEM_CODE"].ToString();
|
|
//盘点号
|
if (!string.IsNullOrEmpty(opNo))
|
{
|
sqlWhere += " AND CN_S_OP_NO = '" + opNo + "'";
|
}
|
//仓库
|
if (!string.IsNullOrEmpty(stockCode))
|
{
|
sqlWhere += " AND CN_S_STOCK_CODE = '" + stockCode + "'";
|
}
|
//库区
|
if (!string.IsNullOrEmpty(areaCode))
|
{
|
sqlWhere += " AND CN_S_STOCK_AREA = '" + areaCode + "'";
|
}
|
//物料编码
|
if (!string.IsNullOrEmpty(itemCode))
|
{
|
sqlWhere += " AND CN_S_ITEM_CODE like '%" + itemCode + "%'";
|
}
|
|
string list = HttpWMS_Get("Api/Check/GetChecklistGroup?sqlWhere=" + sqlWhere);
|
OperateResult or = JsonConvert.DeserializeObject<OperateResult>(list);
|
if (or.Status == ResultStatus.Success)
|
{
|
string s = ((dynamic)or.Data).ToString();
|
|
DataTable dt = HH.WMS.Utils.ZConvert.ToDataTableTwo(s);
|
dynamic columns = obj["columns"];
|
string title = "盘点单列表";
|
string fileName = title + "_" + DateTime.Now.ToString("yyyyMMddHHmmssffff") + ".xls";
|
or = ExcelHelper.SaveTemp(columns, title, dt, fileName);
|
return JsonConvert.SerializeObject(OperateResult.Succeed("", new { fileName = fileName }));
|
}
|
else
|
{
|
return JsonConvert.SerializeObject(or);
|
}
|
}
|
#endregion
|
|
}
|
}
|
