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