public DataSet Get_ProductIndexes(string Title, string SortOrder = "LastUpdate_Date", string Direction = "ASC")
{
string Table_Name = "view_NexusShop_ProductIndex_List";
string Filter = "";
if (!DataEval.IsEmptyQuery(Title))
{
Filter += "Title Like " + DataEval.QuoteTextLike(Title);
}
if (DataEval.IsEmptyQuery(SortOrder))
{
SortOrder = "LastUpdate_Date DESC";
}
else
{
if (!DataEval.IsEmptyQuery(Direction))
{
SortOrder += " " + Direction;
}
}
return(Show_Items(Table_Name, null, null, SortOrder, -1));
}
public DataSet Get_Product_Search(
string Search_Field,
string Keyword,
string Product_VariantID,
string CategoryID,
string ManufacturerID,
string IsActive = "ALL",
string Index_IsActive = "ALL",
string SortOrder = "Product_Title",
string Direction = "ASC",
int PageNum = 1,
int PageSize = -1)
{
string Table_Name = "View_NexusShop_Product_List";
string Filter = "";
if (!DataEval.IsEmptyQuery(Search_Field) && !DataEval.IsEmptyQuery(Keyword))
{
if (Search_Field == "Both_Title")
{
Filter += "("
+ "Title LIKE " + DataEval.QuoteTextLike(Keyword)
+ " OR "
+ "Product_Title LIKE " + DataEval.QuoteTextLike(Keyword)
+ ")";
}
else
{
Filter += Search_Field + " LIKE " + DataEval.QuoteTextLike(Keyword);
}
}
if (!DataEval.IsNegativeQuery(Product_VariantID))
{
if (!DataEval.IsEmptyQuery(Filter))
{
Filter += " AND ";
}
Filter += "Product_VariantID = " + DataEval.QuoteText(Product_VariantID);
}
if (!DataEval.IsNegativeQuery(CategoryID))
{
if (!DataEval.IsEmptyQuery(Filter))
{
Filter += " AND ";
}
Filter += "CategoryID = " + DataEval.QuoteText(CategoryID);
}
if (!DataEval.IsNegativeQuery(ManufacturerID))
{
if (!DataEval.IsEmptyQuery(Filter))
{
Filter += " AND ";
}
Filter += "ManufacturerID = " + DataEval.QuoteText(ManufacturerID);
}
if (IsActive != "ALL")
{
if (!DataEval.IsEmptyQuery(Filter))
{
Filter += " AND ";
}
Filter += "IsActive = " + IsActive;
}
if (Index_IsActive != "ALL")
{
if (!DataEval.IsEmptyQuery(Filter))
{
Filter += " AND ";
}
Filter += "Index_IsActive = " + Index_IsActive;
}
if (DataEval.IsEmptyQuery(SortOrder))
{
SortOrder = "Product_Title";
}
else
{
if (!DataEval.IsEmptyQuery(Direction))
{
SortOrder += " " + Direction;
}
}
return(Show_Items(Table_Name, null, Filter, SortOrder, PageNum, PageSize));
}
