public override void DataBind()
{
if (bound)
{
return;
}
bound = true;
BrandsMgr pMgr = new BrandsMgr();
DataView regions = pMgr.GetBrands(Filter).DefaultView;
regions.Sort = "Title";
this.DataSource = regions;
base.DataBind();
}
public override void DataBind()
{
if (bound)
{
return;
}
bound = true;
BrandsMgr pMgr = new BrandsMgr();
string cond = "";
Object obj = null;
try
{
obj = DataBinder.Eval(this.NamingContainer, "DataItem.BrandId");
}
catch
{
}
if (obj == null)
{
if (region != "")
{
DataView regions = pMgr.GetBrands("Title='" + lw.Utils.StringUtils.SQLEncode(region) + "'").DefaultView;
if (regions.Count > 0)
{
cond = string.Format("BrandId={0}", regions[0]["BrandId"]);
}
}
}
else
{
cond = string.Format("BrandId={0}", obj);
}
string sql = "select * from Items where " + cond;
DataView schools = lw.Data.DBUtils.GetDataSet(sql, lw.Products.cte.lib).Tables[0].DefaultView;
schools.Sort = "Title, ProductNumber";
this.DataSource = schools;
base.DataBind();
}
public override void DataBind()
{
if (bound)
{
return;
}
bound = true;
BrandsMgr pMgr = new BrandsMgr();
DataView regions = pMgr.GetBrands("").DefaultView;
result = new StringBuilder();
result.Append("<select ");
foreach (string attributeKey in this.Attributes.Keys)
{
result.Append(string.Format(@" {0}=""{1}""", attributeKey, Attributes[attributeKey]));
}
result.Append(string.Format(" name='{0}' id='{0}'", this.ID));
result.Append(">");
if (true || AddEmptyOption)
{
result.Append("<option value=\"\">" + EmptyOptionText + "</option>");
}
string _value = WebContext.Request.Form[this.ID];
foreach (DataRowView region in regions)
{
if (region["Title"].ToString().ToLower() == "corporate")
{
continue;
}
string cond = "BrandId=" + region["BrandId"].ToString();
string sql = "select * from Items where " + cond;
DataView schools = DBUtils.GetDataSet(sql, lw.Products.cte.lib).Tables[0].DefaultView;
schools.Sort = "Title, ProductNumber";
if (schools.Count > 0)
{
result.Append(string.Format(@"<optgroup title=""{0}"" class=""{1}"" label=""{0}"">",
region["Title"], region["Title"].ToString().Replace(" ", "-")));
foreach (DataRowView school in schools)
{
string text = school["Title"].ToString();
if (school["ProductNumber"] != System.DBNull.Value && school["ProductNumber"].ToString() != "")
{
text += ", " + school["ProductNumber"].ToString();
}
result.Append(string.Format(@"<option value=""{0}"" {2}>{1}</option>",
school["ItemId"], text,
_value == school["ItemId"].ToString() ? "selected=true" : ""
));
}
result.Append("</optgroup>");
}
}
result.Append("</select>");
base.DataBind();
}
public override void DataBind()
{
if (_bound)
{
return;
}
_bound = true;
lw.Base.CustomPage page = this.Page as lw.Base.CustomPage;
if (WebContext.Request["Search"] == "1")
{
ListBy = ListItemsBy.Search;
}
switch (ListBy)
{
case ListItemsBy.Brand:
if (Brand == "")
{
_brand = page.GetQueryValue("Brand");
}
break;
case ListItemsBy.Category:
if (String.IsNullOrWhiteSpace(Category))
{
_category = page.GetQueryValue("Category");
}
if (String.IsNullOrWhiteSpace(SubCategory))
{
_subCategory = page.GetQueryValue("SubCategory");
}
break;
case ListItemsBy.Package:
object obj = DataBinder.Eval(this.NamingContainer, "DataItem.ItemId");
if (obj == null)
{
string uniqueName = page.GetQueryValue("Item");
if (uniqueName != "")
{
ProductsDS.ItemsRow Item = (new ItemsMgr()).GetItemByUniqueName(uniqueName);
_packageItemId = Item.ItemId;
}
}
else
{
_packageItemId = (int)obj;
}
break;
case ListItemsBy.Search:
Cond += string.Format(" and (ProductNumber like '%{0}%' or Title like '%{0}%' or Keywords like '%{0}%')", StringUtils.SQLEncode(page.GetQueryValue("q")));
break;
case ListItemsBy.All:
default:
break;
}
string categoryCondition = "";
if (!String.IsNullOrWhiteSpace(Category))
{
categoryCondition = string.Format("(Name='{0}' or Title='{0}')",
StringUtils.SQLEncode(Category));
}
if (!String.IsNullOrWhiteSpace(SubCategory))
{
categoryCondition += (categoryCondition != ""? " or " : "") +
string.Format("(Name='{0}' or Title='{0}')", StringUtils.SQLEncode(SubCategory));
}
string moreConditions = "";
if (!String.IsNullOrWhiteSpace(categoryCondition))
{
CategoriesMgr cMgr = new CategoriesMgr();
DataTable cat = cMgr.GetCategories(categoryCondition);
string cats = "", sep = "";
if (cat.Rows.Count > 0)
{
foreach (DataRow row in cat.Rows)
{
cats += sep + row["CategoryId"].ToString();
sep = ",";
}
Cond += string.Format(" and CategoryId in ({0})", cats);
}
if (!String.IsNullOrWhiteSpace(SubCategory))
{
moreConditions = @"Join (select ItemId, Count(*) as _Count from ItemCategories where CategoryId in (" + cats + ") group by ItemId) x on s.ItemId = x.ItemId where x._Count >= 2";
}
}
if (!String.IsNullOrWhiteSpace(Brand))
{
BrandsMgr bMgr = new BrandsMgr();
DataRow brand = bMgr.GetBrand(Brand);
if (brand != null)
{
Cond += string.Format(" and BrandId={0}", brand["BrandId"]);
}
}
if (BrandId != null)
{
Cond += string.Format(" and BrandId={0}", BrandId);
}
if (_packageItemId > 0)
{
Cond += string.Format(" and ItemId in (select ItemId1 from ItemPackages where ItemId={0})", _packageItemId);
}
string _status = page.GetQueryValue("status");
if (null != _status && _status != "")
{
Status = (ItemStatus)Enum.Parse(typeof(ItemStatus), _status);
}
Cond += string.Format(" and Status&{0}<>0", (int)Status);
if (Status == ItemStatus.OnSale)
{
Cond += string.Format(" and Status&{0}=0", (int)ItemStatus.Package);
}
SelectCommand = string.Format(@"Select Distinct top 100 percent s.ItemId,s.ProductNumber,s.Title,s.BrandId,s.Status,s.Price,s.Image1,s.Image2,
s.Image3,s.Image4,s.ThumbImage,s.ResellerPrice,s.DownloadableFile,s.Ranking,s.UserRating,s.Views,s.SalePrice,s.UniqueName,s.Inventory, s.Brand
from (select top {0}
* from itemsview ",
_max == -1 ? "100 PERCENT" : _max.ToString());
if (!String.IsNullOrWhiteSpace(WebContext.Request["ByPrice"]))
{
string temp = WebContext.Request["ByPrice"].Replace(";", "").Replace("<=", "Price <=").Replace(">=", "Price >=")
.Replace("< ", "Price < ").Replace("> ", "Price > ");
Cond += " and " + temp;
}
if (Cond != "")
{
System.Text.RegularExpressions.Regex r = new System.Text.RegularExpressions.Regex("^\\s*and");
SelectCommand += " where " + r.Replace(Cond, "");
}
SelectCommand += ") s " + moreConditions + " order by s.ItemId";
//WebContext.Response.Write(SelectCommand);
//WebContext.Response.End();
base.DataBind();
}
public override void DataBind()
{
if (bound)
{
return;
}
bound = true;
BrandsMgr pMgr = new BrandsMgr();
DataView regions = pMgr.GetBrands("").DefaultView;
result = new StringBuilder();
result.Append(@"<script type=""text/javascript"">
function Sabis_OpenWebsite(sel){
if(sel.value != """")
window.open(sel.value);
}
</script>");
result.Append("<select ");
foreach (string attributeKey in this.Attributes.Keys)
{
result.Append(string.Format(@" {0}=""{1}""", attributeKey, Attributes[attributeKey]));
}
result.Append(" onchange=\"Sabis_OpenWebsite(this)\"");
result.Append(">");
result.Append("<option value=\"\">Haga clic para seleccionar el sitio de red de un colegio</option>");
foreach (DataRowView region in regions)
{
string cond = "BrandId=" + region["BrandId"].ToString();
string sql = "select * from Items where " + cond;
DataView schools = lw.Data.DBUtils.GetDataSet(sql, lw.Products.cte.lib).Tables[0].DefaultView;
schools.Sort = "Title, ProductNumber";
if (schools.Count > 0)
{
result.Append(string.Format(@"<optgroup title=""{0}"" class=""{1}"" label=""{0}"">",
region["Title"], region["Title"].ToString().Replace(" ", "-")));
foreach (DataRowView school in schools)
{
string text = school["Title"].ToString();
if (school["ProductNumber"] != System.DBNull.Value && school["ProductNumber"].ToString() != "")
{
text += ", " + school["ProductNumber"].ToString();
}
string website = school["Website"].ToString();
if (website == "" || website.IndexOf("no website") >= 0)
{
text += " (no website)";
website = "";
}
result.Append(string.Format(@"<option value=""{0}"">{1}</option>",
website, text));
}
result.Append("</optgroup>");
}
}
result.Append("</select>");
base.DataBind();
}
