public static DbQueryResult GetPurchaseOrders(PurchaseOrderQuery query)
{
return SalesProvider.Instance().GetPurchaseOrders(query);
}
public override DbQueryResult GetPurchaseOrders(PurchaseOrderQuery query)
{
StringBuilder builder = new StringBuilder();
bool flag = false;
if (!string.IsNullOrEmpty(query.PurchaseOrderId))
{
builder.AppendFormat("PurchaseOrderId = '{0}'", query.PurchaseOrderId);
}
else
{
if (!string.IsNullOrEmpty(query.DistributorName))
{
builder.AppendFormat("DistributorName = '{0}'", query.DistributorName);
flag = true;
}
if (!string.IsNullOrEmpty(query.ShipTo))
{
if (flag)
{
builder.Append(" AND");
}
builder.AppendFormat(" ShipTo LIKE '%{0}%'", query.ShipTo);
flag = true;
}
if (!string.IsNullOrEmpty(query.OrderId))
{
if (flag)
{
builder.Append(" AND");
}
builder.AppendFormat(" OrderId = '{0}'", query.OrderId);
flag = true;
}
if (!string.IsNullOrEmpty(query.ProductName))
{
if (flag)
{
builder.Append(" AND");
}
builder.AppendFormat(" PurchaseOrderId IN (SELECT PurchaseOrderId FROM Hishop_PurchaseOrderItems WHERE ItemDescription LIKE '%{0}%')", DataHelper.CleanSearchString(query.ProductName));
flag = true;
}
if (query.StartDate.HasValue)
{
if (flag)
{
builder.Append(" AND");
}
builder.AppendFormat(" PurchaseDate >= '{0}'", query.StartDate.Value);
flag = true;
}
if (query.EndDate.HasValue)
{
if (flag)
{
builder.Append(" AND");
}
builder.AppendFormat(" PurchaseDate <= '{0}'", query.EndDate.Value);
flag = true;
}
if (query.PurchaseStatus != OrderStatus.All)
{
if (flag)
{
builder.Append(" AND");
}
builder.AppendFormat(" PurchaseStatus ={0}", Convert.ToInt32(query.PurchaseStatus));
}
if (query.ShippingModeId.HasValue)
{
if (flag)
{
builder.Append(" AND");
}
builder.AppendFormat(" ShippingModeId = {0}", query.ShippingModeId.Value);
}
if (query.IsPrinted.HasValue)
{
if (flag)
{
builder.Append(" AND");
}
builder.AppendFormat(" ISNULL(IsPrinted, 0)={0}", query.IsPrinted.Value);
}
}
return DataHelper.PagingByRownumber(query.PageIndex, query.PageSize, query.SortBy, query.SortOrder, query.IsCount, "Hishop_PurchaseOrders", "PurchaseOrderId", builder.ToString(), "OrderId, PurchaseOrderId, PurchaseDate,RefundStatus, ShipTo, OrderTotal, PurchaseTotal, PurchaseStatus,Distributorname,DistributorWangwang,ManagerMark,ManagerRemark,DistributorId,ISNULL(IsPrinted,0) IsPrinted");
}
public override DbQueryResult GetPurchaseOrders(PurchaseOrderQuery query)
{
StringBuilder builder = new StringBuilder();
builder.AppendFormat("DistributorId = {0}", HiContext.Current.User.UserId);
if (query.IsManualPurchaseOrder)
{
builder.AppendFormat("AND OrderId IS NULL", new object[0]);
}
else
{
builder.AppendFormat("AND OrderId IS NOT NULL", new object[0]);
}
if (!string.IsNullOrEmpty(query.ShipTo))
{
builder.AppendFormat(" AND ShipTo LIKE '%{0}%'", DataHelper.CleanSearchString(query.ShipTo));
}
if (!string.IsNullOrEmpty(query.PurchaseOrderId))
{
builder.AppendFormat(" AND PurchaseOrderId = '{0}'", query.PurchaseOrderId);
}
if (!string.IsNullOrEmpty(query.OrderId))
{
builder.AppendFormat(" AND OrderId = '{0}'", query.OrderId);
}
if (!string.IsNullOrEmpty(query.ProductName))
{
builder.AppendFormat(" AND PurchaseOrderId IN (SELECT PurchaseOrderId FROM Hishop_PurchaseOrderItems WHERE ItemDescription LIKE '%{0}%')", DataHelper.CleanSearchString(query.ProductName));
}
if (query.StartDate.HasValue)
{
builder.AppendFormat(" AND PurchaseDate >= '{0}'", query.StartDate.Value);
}
if (query.EndDate.HasValue)
{
builder.AppendFormat(" AND PurchaseDate <= '{0}'", query.EndDate.Value);
}
if (query.PurchaseStatus != OrderStatus.All)
{
builder.AppendFormat(" AND PurchaseStatus ={0}", Convert.ToInt32(query.PurchaseStatus));
}
return DataHelper.PagingByRownumber(query.PageIndex, query.PageSize, query.SortBy, query.SortOrder, query.IsCount, "Hishop_PurchaseOrders", "PurchaseOrderId", builder.ToString(), "OrderId,ShipTo,RefundStatus, PurchaseOrderId, TaobaoOrderId, PurchaseDate, OrderTotal, PurchaseTotal, PurchaseStatus");
}
public abstract DbQueryResult GetPurchaseOrders(PurchaseOrderQuery query);
private PurchaseOrderQuery GetPurchaseOrderQuery()
{
PurchaseOrderQuery query = new PurchaseOrderQuery();
if (!string.IsNullOrEmpty(Page.Request.QueryString["ShipTo"]))
{
query.ShipTo = Globals.UrlDecode(Page.Request.QueryString["ShipTo"]);
}
if (!string.IsNullOrEmpty(Page.Request.QueryString["PurchaseOrderId"]))
{
query.PurchaseOrderId = Globals.UrlDecode(Page.Request.QueryString["PurchaseOrderId"]);
}
if (!string.IsNullOrEmpty(Page.Request.QueryString["startDate"]))
{
query.StartDate = new DateTime?(DateTime.Parse(Page.Request.QueryString["startDate"]));
}
if (!string.IsNullOrEmpty(Page.Request.QueryString["endDate"]))
{
query.EndDate = new DateTime?(DateTime.Parse(Page.Request.QueryString["endDate"]));
}
if (!string.IsNullOrEmpty(Page.Request.QueryString["PurchaseStatus"]))
{
int result = 0;
if (int.TryParse(Page.Request.QueryString["PurchaseStatus"], out result))
{
query.PurchaseStatus = (OrderStatus)result;
}
}
query.PageIndex = pager.PageIndex;
query.PageSize = pager.PageSize;
query.SortOrder = SortAction.Desc;
query.SortBy = "PurchaseDate";
return query;
}
private PurchaseOrderQuery GetPurchaseOrderQuery()
{
PurchaseOrderQuery query = new PurchaseOrderQuery();
if (!string.IsNullOrEmpty(Page.Request.QueryString["OrderId"]))
{
query.OrderId = Globals.UrlDecode(Page.Request.QueryString["OrderId"]);
}
if (!string.IsNullOrEmpty(Page.Request.QueryString["PurchaseOrderId"]))
{
query.PurchaseOrderId = Globals.UrlDecode(Page.Request.QueryString["PurchaseOrderId"]);
}
if (!string.IsNullOrEmpty(Page.Request.QueryString["ShopTo"]))
{
query.ShipTo = Globals.UrlDecode(Page.Request.QueryString["ShopTo"]);
}
if (!string.IsNullOrEmpty(Page.Request.QueryString["ProductName"]))
{
query.ProductName = Globals.UrlDecode(Page.Request.QueryString["ProductName"]);
}
if (!string.IsNullOrEmpty(Page.Request.QueryString["DistributorName"]))
{
query.DistributorName = Globals.UrlDecode(Page.Request.QueryString["DistributorName"]);
}
if (!string.IsNullOrEmpty(Page.Request.QueryString["startDate"]))
{
query.StartDate = new DateTime?(DateTime.Parse(Page.Request.QueryString["startDate"]));
}
if (!string.IsNullOrEmpty(Page.Request.QueryString["endDate"]))
{
query.EndDate = new DateTime?(DateTime.Parse(Page.Request.QueryString["endDate"]));
}
if (!string.IsNullOrEmpty(Page.Request.QueryString["PurchaseStatus"]))
{
int result = 0;
if (int.TryParse(Page.Request.QueryString["PurchaseStatus"], out result))
{
query.PurchaseStatus = (OrderStatus)result;
}
}
if (!string.IsNullOrEmpty(Page.Request.QueryString["IsPrinted"]))
{
int num2 = 0;
if (int.TryParse(Page.Request.QueryString["IsPrinted"], out num2))
{
query.IsPrinted = new int?(num2);
}
}
if (!string.IsNullOrEmpty(Page.Request.QueryString["ModeId"]))
{
int num3 = 0;
if (int.TryParse(Page.Request.QueryString["ModeId"], out num3))
{
query.ShippingModeId = new int?(num3);
}
}
query.PageIndex = pager.PageIndex;
query.PageSize = pager.PageSize;
query.SortOrder = SortAction.Desc;
query.SortBy = "PurchaseDate";
return query;
}
