public Response <WMSOrderStatusResponse> QueryWMSOrderRange(WMSOrderStatusRequest request) { Response <WMSOrderStatusResponse> response = new Response <WMSOrderStatusResponse>() { Result = new WMSOrderStatusResponse() }; try { WMSOrderStatusAccessor accessor = new WMSOrderStatusAccessor(); int RowCount; response.Result.WMSOrderCollection = accessor.QueryWMSOrderRange(request); //response.Result.PageIndex = 1; //response.Result.transOrder = accessor.QueryTransOrderRange(request, out RowCount); //response.Result.PageIndex response.IsSuccess = true; } catch (Exception ex) { LogError(ex); response.Exception = ex; response.IsSuccess = false; response.ErrorCode = ErrorCode.Technical; } return(response); }
public IEnumerable <WMSOrderStatusInfo> QueryWMSOrderRange(WMSOrderStatusRequest Request)//, out int RowCount { string SqlWhere = GenQueryAttachmentSql(Request); int tempRowCount = 0; DbParam[] dbParams = new DbParam[] { new DbParam("@SqlWhere", DbType.String, SqlWhere, ParameterDirection.Input), // new DbParam("@RowCount", DbType.Int32, tempRowCount, ParameterDirection.Output) //new DbParam("@EndTime", DbType.DateTime, EndTime, ParameterDirection.Input), //new DbParam("@ShipperID", DbType.Int64, ShipperID, ParameterDirection.Input) }; //RowCount = (int)dbParams[3].Value; return(base.ExecuteDataTable("Proc_WMSOrderStatus", dbParams).ConvertToEntityCollection <WMSOrderStatusInfo>()); }
private string GenQueryAttachmentSql(WMSOrderStatusRequest Request) { StringBuilder sb = new StringBuilder(); if (!string.IsNullOrEmpty(Request.Project)) { sb.Append(" and Project='" + Request.Project + "'"); } if (Request.StartCreateTime != null) { sb.Append("and CreateTime>='" + Request.StartCreateTime + "'"); } if (Request.EndCreateTime != null) { sb.Append("and CreateTime<'" + Request.EndCreateTime + "'"); } return(sb.ToString()); }