/// <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; })); }