/// <summary>
/// 插入移库单明细表
/// </summary>
/// <param name="entity"></param>
/// <param name="userName"></param>
/// <returns></returns>
public int SaveStockTransferDetail(StockTransEntity entity, string uniqueCode)
{
string sql = "INSERT INTO wm_stock_transfer_detail(SKU_CODE,SOURCE_LC_CODE,TARGET_LC_CODE,QTY,SKU_NAME,UNIQUE_CODE,CREATE_TIME) "
+ "VALUES('{0}','{1}','{2}',{3},'{4}','{5}',now());";
IMapper map = DatabaseInstance.Instance();
return(map.Execute(String.Format(sql, entity.Material, entity.Location, entity.TargetLocation, entity.TransferQty, entity.MaterialName, uniqueCode)));
}
/// <summary>
/// 当前订单量（获取结果集）
/// </summary>
/// <param name="gID"></param>
/// <returns></returns>
public List <StockTransEntity> GetResultByGID(string gID)
{
List <StockTransEntity> list = new List <StockTransEntity>();
try
{
#region 请求数据
System.Text.StringBuilder loStr = new System.Text.StringBuilder();
loStr.Append("gId=").Append(gID);
string jsonQuery = WebWork.SendRequest(loStr.ToString(), WebWork.URL_GetResultByGID);
if (string.IsNullOrEmpty(jsonQuery))
{
MsgBox.Warn(WebWork.RESULT_NULL);
//LogHelper.InfoLog(WebWork.RESULT_NULL);
return(list);
}
#endregion
#region 正常错误处理
JsonGetResultByGID bill = JsonConvert.DeserializeObject <JsonGetResultByGID>(jsonQuery);
if (bill == null)
{
MsgBox.Warn(WebWork.JSON_DATA_NULL);
return(list);
}
if (bill.flag != 0)
{
MsgBox.Warn(bill.error);
return(list);
}
#endregion
#region 赋值
foreach (JsonGetResultByGIDResult tm in bill.result)
{
StockTransEntity sku = new StockTransEntity();
//tm.fromStockId;
sku.IsCase = Convert.ToInt32(tm.isCase);
sku.Location = tm.Location;
sku.Material = tm.Material;
sku.TransferQty = Convert.ToDecimal(tm.TransferQty);
sku.MaterialName = tm.skuName;
sku.Spec = tm.spec;
sku.TargetLocation = tm.TargetLocation;
sku.UnitName = tm.umName;
list.Add(sku);
}
return(list);
#endregion
}
catch (Exception ex)
{
MsgBox.Err(ex.Message);
}
return(list);
}
/// <summary>
/// 触发补货任务---开始计算
/// </summary>
/// <returns></returns>
public List <StockTransEntity> InquiryStock()
{
List <StockTransEntity> list = new List <StockTransEntity>();
try
{
#region 请求数据
System.Text.StringBuilder loStr = new System.Text.StringBuilder();
loStr.Append("billState=").Append(BillStateConst.ASN_STATE_CODE_COMPLETE).Append("&");
//loStr.Append("wareHouseCode=").Append(warehouseCode);
string jsonQuery = WebWork.SendRequest(string.Empty, WebWork.URL_InquiryStock);
if (string.IsNullOrEmpty(jsonQuery))
{
MsgBox.Warn(WebWork.RESULT_NULL);
//LogHelper.InfoLog(WebWork.RESULT_NULL);
return(list);
}
#endregion
#region 正常错误处理
JsonInquiryStock bill = JsonConvert.DeserializeObject <JsonInquiryStock>(jsonQuery);
if (bill == null)
{
MsgBox.Warn(WebWork.JSON_DATA_NULL);
return(list);
}
if (bill.flag != 0)
{
MsgBox.Warn(bill.error);
return(list);
}
#endregion
#region 赋值数据
foreach (JsonInquiryStockResult jbr in bill.result)
{
StockTransEntity asnEntity = new StockTransEntity();
#region 0-10
asnEntity.Location = jbr.lcCode;
asnEntity.Material = jbr.skuCode;
asnEntity.MaterialName = jbr.skuName;
asnEntity.OccupyQty = Convert.ToDecimal(jbr.occupyQty);
asnEntity.PickingQty = Convert.ToDecimal(jbr.pickingQty);
asnEntity.Qty = Convert.ToDecimal(jbr.qty);
asnEntity.StockID = Convert.ToInt32(jbr.stockId);
asnEntity.TransferQty = Convert.ToDecimal(jbr.transQty);
asnEntity.UnitName = jbr.umName;
asnEntity.TargetLocation = jbr.toLcCode;
#endregion
try
{
//if (!string.IsNullOrEmpty(jbr.closeDate))
// asnEntity.CloseDate = Convert.ToDateTime(jbr.closeDate);
//if (!string.IsNullOrEmpty(jbr.printedTime))
// asnEntity.PrintedTime = Convert.ToDateTime(jbr.printedTime);
//if (!string.IsNullOrEmpty(jbr.createDate))
// asnEntity.CreateDate = Convert.ToDateTime(jbr.createDate);
}
catch (Exception msg)
{
MsgBox.Warn(msg.Message);
//LogHelper.errorLog("FrmVehicle+QueryNotRelatedBills", msg);
}
list.Add(asnEntity);
}
return(list);
#endregion
}
catch (Exception ex)
{
MsgBox.Err(ex.Message);
}
return(list);
}
/// <summary>
/// 库存转移--查询
/// </summary>
/// <param name="location"></param>
/// <param name="materialName"></param>
/// <returns></returns>
public List <StockTransEntity> QueryStockRemove(string location, string materialName)
{
List <StockTransEntity> list = new List <StockTransEntity>();
try
{
#region 请求数据
System.Text.StringBuilder loStr = new System.Text.StringBuilder();
loStr.Append("location=").Append(location).Append("&");
loStr.Append("materialName=").Append(materialName);
string jsonQuery = WebWork.SendRequest(loStr.ToString(), WebWork.URL_QueryStockRemove);
if (string.IsNullOrEmpty(jsonQuery))
{
//MsgBox.Warn(WebWork.RESULT_NULL);
LogHelper.InfoLog(WebWork.RESULT_NULL);
return(list);
}
#endregion
#region 正常错误处理
JsonQueryStockRemove bill = JsonConvert.DeserializeObject <JsonQueryStockRemove>(jsonQuery);
if (bill == null)
{
MsgBox.Warn(WebWork.JSON_DATA_NULL);
return(list);
}
if (bill.flag != 0)
{
MsgBox.Warn(bill.error);
return(list);
}
#endregion
#region 赋值数据
foreach (JsonQueryStockRemoveResult jbr in bill.result)
{
StockTransEntity asnEntity = new StockTransEntity();
#region 0- 10
asnEntity.Location = jbr.lcCode;
asnEntity.OccupyQty = Convert.ToDecimal(jbr.occupyQty);
asnEntity.PickingQty = Convert.ToDecimal(jbr.pickingQty);
asnEntity.Qty = Convert.ToDecimal(jbr.qty);
asnEntity.StockID = Convert.ToInt32(jbr.stkId);
asnEntity.UnitName = jbr.umName;
asnEntity.ZoneName = jbr.znName;
asnEntity.Material = jbr.skuCode;
asnEntity.MaterialName = jbr.skuName;
#endregion
try
{
if (!string.IsNullOrEmpty(jbr.expDate))
{
asnEntity.ExpDate = Convert.ToDateTime(jbr.expDate);
}
}
catch (Exception msg)
{
LogHelper.errorLog("FrmVehicle+QueryNotRelatedBills", msg);
}
list.Add(asnEntity);
}
return(list);
#endregion
}
catch (Exception ex)
{
MsgBox.Err(ex.Message);
}
return(list);
}
