public GetBarCodeByConditionResponse QueryBarCodeList(BarCodeSearchCondition SearchCondition, int pageIndex, int pageSize, out int rowCount)
{
string sqlWhere = "";
if (SearchCondition != null)
{
sqlWhere = GetConditionStr(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_GetBarCodeByConditionPage]", dbParams);
rowCount = (int)dbParams[3].Value;
GetBarCodeByConditionResponse response = new GetBarCodeByConditionResponse();
response.BarCodeCollection = dt.ConvertToEntityCollection <BarCodeInfo>();
return(response);
}
public string GetConditionStr(BarCodeSearchCondition SearchCondition)
{
StringBuilder sb = new StringBuilder();
if (SearchCondition.CustomerID != 0)
{
sb.Append(" AND CustomerID='").Append(SearchCondition.CustomerID).Append("' ");
}
if (SearchCondition.WarehouseID != 0)
{
sb.Append(" AND WarehouseID='").Append(SearchCondition.WarehouseID).Append("' ");
}
if (!string.IsNullOrEmpty(SearchCondition.Type))
{
sb.Append(" AND Type='").Append(SearchCondition.Type).Append("' ");
}
if (!string.IsNullOrEmpty(SearchCondition.OrderNumber))
{
sb.Append(" AND OrderNumber='").Append(SearchCondition.OrderNumber).Append("' ");
}
if (!string.IsNullOrEmpty(SearchCondition.SKU))
{
sb.Append(" AND SKU='").Append(SearchCondition.SKU).Append("' ");
}
if (!string.IsNullOrEmpty(SearchCondition.BarCode))
{
sb.Append(" AND BarCode='").Append(SearchCondition.BarCode).Append("' ");
}
if (SearchCondition.StartCreateTime != null)
{
sb.Append(" AND CreateTime>='").Append(SearchCondition.StartCreateTime.DateTimeToString("yyyy-MM-dd 00:00:00.00")).Append("' ");
}
if (SearchCondition.EndCreateTime != null)
{
sb.Append(" AND CreateTime<='").Append(SearchCondition.EndCreateTime.DateTimeToString("yyyy-MM-dd 23:59:59.99")).Append("' ");
}
return(sb.ToString());
}
