/// <summary>
/// 保存临时扫描表
/// </summary>
/// <param name="dto">保存参数</param>
/// <returns></returns>
public DataSet SaveTempScan(SaveTempScanModel dto)
{
List <SmartDbParameter> paramList = new List <SmartDbParameter>();
paramList.Add(CreateInSmartDbParameter("ORDERNO", DbType.String, dto.OrderNo));
paramList.Add(CreateInSmartDbParameter("ORDERTYPE", DbType.String, dto.OrderType));
paramList.Add(CreateInSmartDbParameter("CMCHWCODE", DbType.String, dto.DesWarehouse));
paramList.Add(CreateInSmartDbParameter("CWHCODE", DbType.String, dto.Warehouse));
paramList.Add(CreateInSmartDbParameter("CPOSCODE", DbType.String, dto.Position));
paramList.Add(CreateInSmartDbParameter("CMPOSCODE", DbType.String, dto.DesPosition));
paramList.Add(CreateInSmartDbParameter("BARCODE", DbType.String, dto.Barcode));
paramList.Add(CreateInSmartDbParameter("OPERUSER", DbType.String, dto.OperUser));
paramList.Add(CreateInSmartDbParameter("QTY", DbType.Int32, dto.Qty));
paramList.Add(CreateInSmartDbParameter("BDEL", DbType.Int32, dto.DeleteMark == true?1:0));
return(base.ExecuteDataSetByProc("[TEMPSCAN_SAVE]", paramList));
}
/// <summary>
/// 保存临时扫描表
/// </summary>
/// <param name="dto">保存参数</param>
/// <returns></returns>
public DataTable SaveTempScan(SaveTempScanModel dto)
{
IAppCommon dal = base.baseDal as IAppCommon;
return(dal.SaveTempScan(dto).Tables[0]);
}
public async Task <KgmApiResultEntity> SaveTempScan([FromBody] SaveTempScanModel dto)
{
string[] str = dto.Barcode.Split('|');
KgmApiResultEntity result = new KgmApiResultEntity();
SearchCondition search = new SearchCondition();
search.AddCondition("F_EnCode", dto.Warehouse, SqlOperator.Equal);
var warehouse = BLLFactory <Mst_Warehouse> .Instance.FindSingle(search.BuildConditionSql().Replace("Where", string.Empty));
if (warehouse == null)
{
result.result = false;
result.message = "仓库编码错误";
return(result);
}
;
dto.Warehouse = warehouse.F_Id;
search = new SearchCondition();
search.AddCondition("F_EnCode", str[0], SqlOperator.Equal);
search = new SearchCondition();
search.AddCondition("F_EnCode", dto.Position, SqlOperator.Equal);
var position = BLLFactory <Mst_CargoPosition> .Instance.FindSingle(search.BuildConditionSql().Replace("Where", string.Empty));
if (position == null)
{
result.result = false;
result.message = "货位编码错误";
return(result);
}
dto.Position = position.F_Id;
if (!String.IsNullOrEmpty(dto.DesPosition))
{
search = new SearchCondition();
search.AddCondition("F_EnCode", dto.DesPosition, SqlOperator.Equal);
var DesPosition = BLLFactory <Mst_CargoPosition> .Instance.FindSingle(search.BuildConditionSql().Replace("Where", string.Empty));
if (DesPosition == null)
{
result.result = false;
result.message = "目标仓库编码错误";
return(result);
}
}
if (!string.IsNullOrEmpty(dto.DesWarehouse))
{
search = new SearchCondition();
search.AddCondition("F_EnCode", dto.DesWarehouse, SqlOperator.Equal);
var DesWarehouse = BLLFactory <Mst_CargoPosition> .Instance.FindSingle(search.BuildConditionSql().Replace("Where", string.Empty));
if (DesWarehouse == null)
{
result.result = false;
result.message = "目标货位编码错误";
return(result);
}
}
result.result = true;
return(await Task.Run(() =>
{
var dt = BLLFactory <AppCommon> .Instance.SaveTempScan(dto);
if (!string.IsNullOrEmpty(dt.Rows[0][0].ToString()))
{
result.result = false;
}
result.message = result.result == true ? "操作成功" : dt.Rows[0][0].ToString();
if (dto.DeleteMark)
{
result.message = result.result == true ? "删除成功" : dt.Rows[0][0].ToString();
}
return result;
}));
}
