public string GenGetOrderWhere(WaveSearchCondition SearchCondition)
{
StringBuilder sb = new StringBuilder();
if (!string.IsNullOrEmpty(SearchCondition.WaveNumber))
{
sb.Append(" and w.WaveNumber='" + SearchCondition.WaveNumber + "'");
}
if (SearchCondition.CustomerID != 0)
{
sb.Append(" and w.CustomerID=" + SearchCondition.CustomerID);
}
if (SearchCondition.WarehouseID != 0)
{
sb.Append(" and w.WarehouseID=" + SearchCondition.WarehouseID);
}
if (!string.IsNullOrEmpty(SearchCondition.OrderNumber))
{
sb.Append(" and w.ID in(select WaveID from WMS_WaveDetail where OrderNumber='" + SearchCondition.OrderNumber + "')");
}
if (!string.IsNullOrEmpty(SearchCondition.ExternOrderNumber))
{
sb.Append(" and w.ID in(select WaveID from WMS_WaveDetail where ExternOrderNumber='" + SearchCondition.ExternOrderNumber + "')");
}
if (!string.IsNullOrEmpty(SearchCondition.PreOrderNumber))
{
sb.Append(" and w.ID in(select WaveID from WMS_WaveDetail where PreOrderNumber='" + SearchCondition.PreOrderNumber + "')");
}
if (!string.IsNullOrEmpty(SearchCondition.StartCreateTime.ToString()))
{
sb.Append(" and w.CreateTime>='" + SearchCondition.StartCreateTime.DateTimeToString("yyyy-MM-dd 00:00:00.00") + "'");
}
if (!string.IsNullOrEmpty(SearchCondition.EndCreateTime.ToString()))
{
sb.Append(" and w.CreateTime<='" + SearchCondition.EndCreateTime.DateTimeToString("yyyy-MM-dd 23:59:59.99") + "'");
}
if (!string.IsNullOrEmpty(SearchCondition.StartCompleteTime.ToString()))
{
sb.Append(" and w.CreateTime>='" + SearchCondition.StartCompleteTime.DateTimeToString("yyyy-MM-dd 00:00:00.00") + "'");
}
if (!string.IsNullOrEmpty(SearchCondition.EndCompleteTime.ToString()))
{
sb.Append(" and w.CreateTime<='" + SearchCondition.EndCompleteTime.DateTimeToString("yyyy-MM-dd 23:59:59.99") + "'");
}
return(sb.ToString());
}
public GetWaveByConditionResponse GetWaveHeaderByCondition(WaveSearchCondition SearchCondition, int pageIndex, int pageSize, out int rowCount)
{
GetWaveByConditionResponse response = new GetWaveByConditionResponse();
string sqlWhere = this.GenGetOrderWhere(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)
};
DataSet ds = this.ExecuteDataSet("Proc_WMS_GetWaveHeaderByCondition", dbParams);
rowCount = (int)dbParams[3].Value;
response.WaveCollection = ds.Tables[0].ConvertToEntityCollection <WMS_Wave>();
return(response);
}
