/// <summary>
/// 条件拼接
/// </summary>
/// <param name="SearchCondition"></param>
/// <returns></returns>
private string GenGetWhere(LogOperationSearchCondition SearchCondition)
{
StringBuilder sb = new StringBuilder();
if (SearchCondition.CustomerID != 0)
{
sb.Append(" AND a.CustomerID='").Append(SearchCondition.CustomerID).Append("' ");
}
if (!string.IsNullOrEmpty(SearchCondition.OrderNumber))
{
sb.Append(" AND a.OrderNumber='").Append(SearchCondition.OrderNumber).Append("' ");
}
if (!string.IsNullOrEmpty(SearchCondition.ExternOrderNumber))
{
sb.Append(" AND a.ExternOrderNumber='").Append(SearchCondition.ExternOrderNumber).Append("' ");
}
if (SearchCondition.StartCreateTime != null)
{
sb.Append(" AND a.CreateTime>='" + SearchCondition.StartCreateTime.ToString() + "'");
}
if (SearchCondition.EndCreateTime != null)
{
sb.Append(" AND a.CreateTime<='" + SearchCondition.EndCreateTime.ToString() + "'");
}
if (!string.IsNullOrEmpty(SearchCondition.Warehouse))
{
sb.Append(" AND a.WarehouseName='").Append(SearchCondition.Warehouse).Append("' ");
}
return(sb.ToString());
}
/// <summary>
/// 查询显示 分页查询
/// </summary>
/// <param name="SearchCondition"></param>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="rowCount"></param>
/// <returns></returns>
public IEnumerable <WMS_Log_Operation> GetLogOperationByCondition(LogOperationSearchCondition SearchCondition, int pageIndex, int pageSize, out int rowCount)
{
string sqlWhere = this.GenGetWhere(SearchCondition);
int tempRowCount = 0;
DbParam[] dbParams = new DbParam[] {
new DbParam("@Where", DbType.String, sqlWhere, ParameterDirection.Input),
new DbParam("@PageIndex", DbType.Int32, pageIndex, ParameterDirection.Input),
new DbParam("@PageSize", DbType.Int32, pageSize, ParameterDirection.Input),
new DbParam("@RowCount", DbType.Int32, tempRowCount, ParameterDirection.Output)
};
DataTable dt = this.ExecuteDataTable("Proc_WMS_GetLogOperationByCondition", dbParams);
rowCount = (int)dbParams[3].Value;
return(dt.ConvertToEntityCollection <WMS_Log_Operation>());
}
