/// <summary> ///导出库存变更数据 /// </summary> /// <param name="request"></param> /// <returns></returns> public Response <GetAdjustmentDetailByConditionResponse> ExportAdjustmentByCondition(GetAdjustmentByConditionRequest request) { Response <GetAdjustmentDetailByConditionResponse> response = new Response <GetAdjustmentDetailByConditionResponse>() { Result = new GetAdjustmentDetailByConditionResponse() }; if (request == null || request.SearchCondition == null) { ArgumentNullException ex = new ArgumentNullException("GetExportByConditionRequest request"); LogError(ex); response.ErrorCode = ErrorCode.Argument; response.Exception = ex; return(response); } try { AdjustmentManagementAccessor accessor = new AdjustmentManagementAccessor(); response.Result = accessor.ExportadjustByCondition(request.SearchCondition); response.IsSuccess = true; } catch (Exception ex) { LogError(ex); response.Exception = ex; response.IsSuccess = false; response.ErrorCode = ErrorCode.Technical; } return(response); }
//明细单条的查看或者编辑 public Response <AdjustmentAndAdjustmentDetail> GetAdjustmentInfos(GetAdjustmentByConditionRequest request) { Response <AdjustmentAndAdjustmentDetail> response = new Response <AdjustmentAndAdjustmentDetail>(); if (request == null) { ArgumentNullException ex = new ArgumentNullException("GetAdjustmentByConditionRequest request"); LogError(ex); response.ErrorCode = ErrorCode.Argument; response.Exception = ex; return(response); } try { AdjustmentManagementAccessor accessor = new AdjustmentManagementAccessor(); response.Result = accessor.GetAdjustmentInfos(request.ID); response.IsSuccess = true; } catch (Exception ex) { LogError(ex); response.IsSuccess = false; response.ErrorCode = ErrorCode.Technical; } return(response); }
//批量完成 public Response <bool> PLComplet(string ID, string type) { Response <bool> response = new Response <bool>(); try { string result = new AdjustmentManagementAccessor().PLComplet(ID, type); if (result.Contains("提交成功")) { response.IsSuccess = true; response.SuccessMessage = "操作成功"; } else { response.IsSuccess = false; response.SuccessMessage = result; } } catch (Exception ex) { LogError(ex); response.IsSuccess = false; response.ErrorCode = ErrorCode.Technical; } return(response); }
public Response <GetAdjustmentDetailByConditionResponse> GetAdjustmentByCondition(GetAdjustmentByConditionRequest request) { Response <GetAdjustmentDetailByConditionResponse> response = new Response <GetAdjustmentDetailByConditionResponse>() { Result = new GetAdjustmentDetailByConditionResponse() }; if (request == null || request.SearchCondition == null) { ArgumentNullException ex = new ArgumentNullException("GetReceiptByConditionRequest request"); LogError(ex); response.ErrorCode = ErrorCode.Argument; response.Exception = ex; return(response); } try { AdjustmentManagementAccessor accessor = new AdjustmentManagementAccessor(); int RowCount; response.Result = accessor.GetadjustByCondition(request.SearchCondition, request.PageIndex, request.PageSize, out RowCount); response.Result.PageCount = RowCount % request.PageSize == 0 ? RowCount / request.PageSize : RowCount / request.PageSize + 1; response.Result.PageIndex = request.PageIndex; response.IsSuccess = true; } catch (Exception ex) { LogError(ex); response.Exception = ex; response.IsSuccess = false; response.ErrorCode = ErrorCode.Technical; } return(response); }
//批量取消操作 public bool Cancels(string asnid) { bool ve = true; try { ve = new AdjustmentManagementAccessor().Cancels(asnid); } catch (Exception ex) { LogError(ex); } return(ve); }
/// <summary> /// 提交 /// </summary> /// <param name="request"></param> /// <returns></returns> public Response <string> UpdateAndInsertInventory(AddAdjustmentandAdjustmentDetailRequest request, string Inventorytype) { Response <string> response = new Response <string>(); string message = ""; if (request == null || request.adjustmentDetails == null || !request.adjustmentDetails.Any()) { ArgumentNullException ex = new ArgumentNullException("AddInventroyRequest request"); LogError(ex); response.ErrorCode = ErrorCode.Argument; response.Exception = ex; return(response); } try { message = new AdjustmentManagementAccessor().UpdateAndInsertInventory(request, Inventorytype); if (message.Contains("提交成功")) { response.Result = message; response.IsSuccess = true; } else { response.Result = message; response.IsSuccess = false; } return(response); } catch (Exception ex) { LogError(ex); response.IsSuccess = false; response.ErrorCode = ErrorCode.Technical; response.Result = message + ex.Message; } return(response); }
/// <summary> /// 更新暂存 /// </summary> /// <param name="request"></param> /// <returns></returns> public Response <string> UpdateAdjustmentANDAdjustmentDetail(AddAdjustmentandAdjustmentDetailRequest request) { Response <string> response = new Response <string>(); string message = ""; if (request == null || request.adjustment == null || !request.adjustment.Any()) { ArgumentNullException ex = new ArgumentNullException("UpdateAdjustmentANDAdjustmentDetail request"); LogError(ex); response.ErrorCode = ErrorCode.Argument; response.Exception = ex; return(response); } try { message = new AdjustmentManagementAccessor().UpdateAdjustmentANDAdjustmentDetail(request); if (message == "更新成功") { response.Result = message; response.IsSuccess = true; } else { response.Result = message; response.IsSuccess = false; } return(response); } catch (Exception ex) { LogError(ex); response.IsSuccess = false; response.ErrorCode = ErrorCode.Technical; response.Result = message + ex.Message; } return(response); }
/// <summary> /// 移库 /// </summary> /// <param name="CustomerID"></param> /// <param name="WarehouseName"></param> /// <param name="BoxNumber"></param> /// <param name="Location"></param> /// <param name="Creator"></param> /// <returns></returns> public int MoveLocation(long CustomerID, string WarehouseName, string BoxNumber, string Location, string Creator) { try { string SqlCheckLocation = @"select wl.* from WMS_Warehouse w left join WMS_Warehouse_Location wl on w.ID = wl.WarehouseID where wl.Location = '" + Location + @"' and w.WarehouseName='" + WarehouseName + "' "; if (this.ScanDataTable(SqlCheckLocation).Rows.Count < 1) { return(2); } string sqlCheck = (@"select * from WMS_Inventory_103 where Warehouse='" + WarehouseName + @"' and Location='" + BoxNumber + @"' and InventoryType!=9"); IEnumerable <Inventorys> inventorys = this.ScanDataTable(sqlCheck).ConvertToEntityCollection <Inventorys>(); //提交前查看是否还有数据Check if (inventorys == null || inventorys.Count() == 0) { return(0); } string AdjustmentNumber = "ADJ" + DateTime.Now.Ticks; //新建库存移动单 string SqlAdjustment = (@" DECLARE @AID bigint; insert into [WMS_Adjustment] ([AdjustmentNumber] ,[CustomerID] ,[CustomerName] ,[Warehouse] ,[Status] ,[AdjustmentType] ,[AdjustmentReason] ,[AdjustmentTime] ,[IsHold] ,[Creator] ,[CreateTime] ,[Remark] ,Str3) values('" + AdjustmentNumber + @"' ,'" + inventorys.First().CustomerID + @"' ,'" + inventorys.First().CustomerName + @"' ,'" + inventorys.First().Warehouse + @"' ,1 ,'库存移动单' ,'RF主动移库' ,getdate() ,0 ,'" + Creator + @"' ,getdate() ,'RF主动移库','QQQQQQ' ) set @AID=@@IDENTITY insert into WMS_AdjustmentDetail ([AID] ,[AdjustmentNumber] ,[CustomerID] ,[CustomerName] ,[FromLot] ,[ToLot] ,[SKU] ,[UPC] ,[BatchNumber] ,[BoxNumber] ,[GoodsName] ,[FromWarehouse] ,[ToWarehouse] ,[FromArea] ,[ToArea] ,[FromLocation] ,[ToLocation] ,[FromQty] ,[ToQty] ,[FromGoodsType] ,[ToGoodsType] ,[Unit] ,[Specifications] ,[IsHold] ,[AdjustmentReason] ,[Creator] ,[CreateTime],Str3 ) ( select @AID,'" + AdjustmentNumber + @"', CustomerID,CustomerName,null,null,SKU,UPC,BatchNumber,BoxNumber,GoodsName,Warehouse,Warehouse,Area,Area, Location,'" + Location + @"',Qty,Qty,GoodsType,GoodsType,Unit,Specifications,0,'','" + Creator + @"',getdate(),Str3 from WMS_Inventory_103 where InventoryType=1 and Warehouse='" + WarehouseName + "' and Location='" + BoxNumber + @"' ) select * from WMS_Adjustment where [CustomerID]=" + CustomerID + " and AdjustmentNumber='" + AdjustmentNumber + @"'"); //SqlAdjustment += (@""); Adjustment adjustment = this.ScanDataTable(SqlAdjustment).ConvertToEntity <Adjustment>(); AdjustmentManagementAccessor adjustmentDetail = new AdjustmentManagementAccessor(); string str = adjustmentDetail.Complets(adjustment.ID, "库存移动单"); if (str.Contains("提交成功")) { return(1); } else { string UpdateadjustmentSql = (@" update WMS_Adjustment set Status=-1 where AdjustmentNumber='" + AdjustmentNumber + @"' and CustomerID=" + CustomerID); this.ScanDataTable(UpdateadjustmentSql); return(0); } //return this.ScanExecuteNonQuery(sqlCheck); //return dt.ConvertToEntityCollection<Inventorys>(); } catch (Exception ex) { SysLogWriter.Error("MoveLocation(Dao层)" + Creator + ex.ToString()); } return(0); }