public DbQueryResult GetHSDocking(HSDockingQuery query)
{
StringBuilder stringBuilder = new StringBuilder();
if (!string.IsNullOrEmpty(query.OrderId))
{
if (stringBuilder.Length > 0)
{
stringBuilder.Append(" AND ");
}
stringBuilder.AppendFormat(" OrderId LIKE '%{0}%'", DataHelper.CleanSearchString(query.OrderId));
}
//if (!string.IsNullOrEmpty(query.OrderPacketsID.ToString()))
//{
// if (stringBuilder.Length > 0)
// {
// stringBuilder.Append(" AND ");
// }
// stringBuilder.AppendFormat(" OrderPacketsID LIKE '%{0}%'", DataHelper.CleanSearchString(query.OrderPacketsID.ToString()));
//}
if (!string.IsNullOrEmpty(query.OrderStatus.ToString()) && query.OrderStatus.ToString() != "-1")
{
if (stringBuilder.Length > 0)
{
stringBuilder.Append(" AND ");
}
stringBuilder.AppendFormat(" OrderStatus = {0} ", int.Parse(query.OrderStatus.ToString()));
}
if (!string.IsNullOrEmpty(query.LogisticsStatus.ToString()) && query.LogisticsStatus.ToString() != "-1")
{
if (stringBuilder.Length > 0)
{
stringBuilder.Append(" AND ");
}
stringBuilder.AppendFormat(" LogisticsStatus = {0} ", int.Parse(query.LogisticsStatus.ToString()));
}
if (!string.IsNullOrEmpty(query.PaymentStatus.ToString()) && query.PaymentStatus.ToString() != "-1")
{
if (stringBuilder.Length > 0)
{
stringBuilder.Append(" AND ");
}
stringBuilder.AppendFormat(" PaymentStatus = {0} ", int.Parse(query.PaymentStatus.ToString()));
}
if (!string.IsNullOrEmpty(query.payerIdStatus.ToString()) && query.payerIdStatus.ToString() != "-1")
{
if (stringBuilder.Length > 0)
{
stringBuilder.Append(" AND ");
}
stringBuilder.AppendFormat(" payerIdStatus = {0} ", int.Parse(query.payerIdStatus.ToString()));
}
//return DataHelper.PagingByRownumber(query.PageIndex, query.PageSize, query.SortBy, query.SortOrder, query.IsCount, "FND_HS_CODE ", "HS_CODE_ID", (stringBuilder.Length > 0) ? stringBuilder.ToString() : null, "*");
return(DataHelper.PagingByRownumber(query.PageIndex, query.PageSize, query.SortBy, query.SortOrder, query.IsCount, "vw_Ecshop_OrderHS_Docking ", "HS_Docking_ID", (stringBuilder.Length > 0) ? stringBuilder.ToString() : null, "*"));
}
public static DbQueryResult GetHSDocking(HSDockingQuery query)
{
return(new HSCodeDao().GetHSDocking(query));
}
