protected void SubmitButton_Click(object sender, EventArgs e)
{
ProductClassInfo productClass = new ProductClassInfo();
productClass.ID = RequestHelper.GetQueryString <int>("ID");
productClass.FatherID = Convert.ToInt32(this.FatherID.Text);
productClass.OrderID = Convert.ToInt32(this.OrderID.Text);
productClass.ClassName = this.ClassName.Text;
productClass.Keywords = this.Keywords.Text;
productClass.Description = this.Description.Text;
productClass.IsDownload = Convert.ToInt32(this.IsDownload.Text);
string alertMessage = ShopLanguage.ReadLanguage("AddOK");
if (productClass.ID == -2147483648)
{
base.CheckAdminPower("AddProductClass", PowerCheckType.Single);
int id = ProductClassBLL.AddProductClass(productClass);
AdminLogBLL.AddAdminLog(ShopLanguage.ReadLanguage("AddRecord"), ShopLanguage.ReadLanguage("ProductClass"), id);
}
else
{
base.CheckAdminPower("UpdateProductClass", PowerCheckType.Single);
ProductClassBLL.UpdateProductClass(productClass);
AdminLogBLL.AddAdminLog(ShopLanguage.ReadLanguage("UpdateRecord"), ShopLanguage.ReadLanguage("ProductClass"), productClass.ID);
alertMessage = ShopLanguage.ReadLanguage("UpdateOK");
}
AdminBasePage.Alert(alertMessage, RequestHelper.RawUrl);
}
private string ReadSystemClassID(string taobaoClassIDList)
{
string str = string.Empty;
if (taobaoClassIDList != string.Empty)
{
foreach (string str2 in taobaoClassIDList.Split(new char[] { ',' }))
{
if (str2 != string.Empty)
{
ProductClassInfo info = ProductClassBLL.ReadProductClassCacheByTaobaoID(Convert.ToInt64(str2));
if (info.FatherID == 0)
{
str = str + "|" + info.ID.ToString() + "|";
}
else
{
string str4 = str;
str = str4 + "|" + info.FatherID.ToString() + "|" + info.ID.ToString() + "|";
}
}
}
}
return(str);
}
/// <summary>
/// 修改分类排序
/// </summary>
/// <param name="id">要移动的id</param>
public void ChangeProductClassOrder(int pid, int oid)
{
ProductClassInfo tempProClass = Read(pid);
tempProClass.OrderId = oid;
Update(tempProClass);
}
public void Update(ProductClassInfo entity)
{
using (var conn = new SqlConnection(connectString))
{
string sql = @"update ProductClass set ParentId = @ParentId, ProductTypeId = @ProductTypeId, Name = @Name, Number = @Number, ProductCount = @ProductCount, Keywords = @Keywords, Remark = @Remark, OrderId = @OrderId, Tm = @Tm,Photo=@Photo,EnClassName=@EnClassName,PageTitle=@PageTitle,PageKeyWord=@PageKeyWord,PageSummary=@PageSummary,IsSystem=@IsSystem
where Id=@Id";
conn.Execute(sql, entity);
}
}
public int Add(ProductClassInfo entity)
{
using (var conn = new SqlConnection(connectString))
{
string sql = @"insert into ProductClass(ParentId,ProductTypeId,Name,Number,ProductCount,Keywords,Remark,OrderId,Tm,Photo,EnClassName,PageTitle,PageKeyWord,PageSummary,IsSystem)
values(@ParentId,@ProductTypeId,@Name,@Number,@ProductCount,@Keywords,@Remark,@OrderId,@Tm,@Photo,@EnClassName,@PageTitle,@PageKeyWord,@PageSummary,@IsSystem);
select SCOPE_IDENTITY()";
return(conn.Query <int>(sql, entity).Single());
}
}
/// <summary>
/// 通过IDataReader创建ProductClassInfo
/// </summary>
public static ProductClassInfo BuildFromReader(IDataReader reader)
{
ProductClassInfo model = new ProductClassInfo();
model.ProductClassID = TypeHelper.ObjectToInt(reader["ProductClassID"]);
model.ProductClassName = reader["ProductClassName"].ToString();
model.ParentProductClassID = TypeHelper.ObjectToInt(reader["ParentProductClassID"]);
model.DisplayOrder = TypeHelper.ObjectToInt(reader["DisplayOrder"]);
return(model);
}
public void UpdateProductClass(ProductClassInfo productClass)
{
SqlParameter[] pt = new SqlParameter[] { new SqlParameter("@id", SqlDbType.Int), new SqlParameter("@fatherID", SqlDbType.Int), new SqlParameter("@orderID", SqlDbType.Int), new SqlParameter("@className", SqlDbType.NVarChar), new SqlParameter("@keywords", SqlDbType.NVarChar), new SqlParameter("@description", SqlDbType.NText), new SqlParameter("@isDownload", SqlDbType.Int) };
pt[0].Value = productClass.ID;
pt[1].Value = productClass.FatherID;
pt[2].Value = productClass.OrderID;
pt[3].Value = productClass.ClassName;
pt[4].Value = productClass.Keywords;
pt[5].Value = productClass.Description;
pt[6].Value = productClass.IsDownload;
ShopMssqlHelper.ExecuteNonQuery(ShopMssqlHelper.TablePrefix + "UpdateProductClass", pt);
}
/// <summary>
/// 对List<ProductClassInfo>进行排序时作为参数使用（升序）
/// </summary>
/// <param name="c1"></param>
/// <param name="c2"></param>
/// <returns></returns>
private static int SortCompare(ProductClassInfo c1, ProductClassInfo c2)
{
if (c1.OrderID < c2.OrderID)
{
return(-1);
}
else if (c1.OrderID > c2.OrderID)
{
return(1);
}
return(0);
}
public int AddProductClass(ProductClassInfo productClass)
{
SqlParameter[] pt = new SqlParameter[] { new SqlParameter("@fatherID", SqlDbType.Int), new SqlParameter("@orderID", SqlDbType.Int), new SqlParameter("@className", SqlDbType.NVarChar), new SqlParameter("@keywords", SqlDbType.NVarChar), new SqlParameter("@description", SqlDbType.NText), new SqlParameter("@taobaoID", SqlDbType.BigInt), new SqlParameter("@isDownload", SqlDbType.Int) };
pt[0].Value = productClass.FatherID;
pt[1].Value = productClass.OrderID;
pt[2].Value = productClass.ClassName;
pt[3].Value = productClass.Keywords;
pt[4].Value = productClass.Description;
pt[5].Value = productClass.TaobaoID;
pt[6].Value = productClass.IsDownload;
return(Convert.ToInt32(ShopMssqlHelper.ExecuteScalar(ShopMssqlHelper.TablePrefix + "AddProductClass", pt)));
}
/// <summary>
/// 获取导航列表
/// </summary>
/// <returns></returns>
public static List <ProductClassInfo> GetProductClassList()
{
List <ProductClassInfo> list = new List <ProductClassInfo>();
IDataReader reader = BonSite.Core.BSData.RDBS.GetProductClassList();
while (reader.Read())
{
ProductClassInfo model = BuildFromReader(reader);
list.Add(model);
}
reader.Close();
return(list);
}
/// <summary>
/// 从缓存列表中读取产品分类
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static ProductClassInfo ReadProductClassCache(int id)
{
ProductClassInfo info = new ProductClassInfo();
List <ProductClassInfo> list = ReadProductClassCacheList();
foreach (ProductClassInfo info2 in list)
{
if (info2.ID == id)
{
return(info2);
}
}
return(info);
}
public static ProductClassInfo ReadProductClassCacheByTaobaoID(long taobaoID)
{
ProductClassInfo info = new ProductClassInfo();
List <ProductClassInfo> list = ReadProductClassCacheList();
foreach (ProductClassInfo info2 in list)
{
if (info2.TaobaoID == taobaoID)
{
return(info2);
}
}
return(info);
}
/// <summary>
/// 递归创建分类路径Path
/// </summary>
protected static void CreateProductClassPath(int productClassID, List <ProductClassInfo> resultList)
{
ProductClassInfo model = GetModelById(productClassID);
if (model != null)
{
resultList.Insert(0, model);
if (model.ParentProductClassID != 0)
{
CreateProductClassPath(model.ParentProductClassID, resultList);
}
}
}
/// <summary>
/// 创建产品分类
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int CreateProductClass(ProductClassInfo model)
{
DbParameter[] parms =
{
GenerateInParam("@ProductClassName", SqlDbType.NVarChar, 50, model.ProductClassName),
GenerateInParam("@ParentProductClassID", SqlDbType.Int, 4, model.ParentProductClassID),
GenerateInParam("@DisplayOrder", SqlDbType.Int, 4, model.DisplayOrder)
};
string commandText = string.Format("INSERT INTO [{0}ProductClass](ProductClassName,ParentProductClassID,DisplayOrder) VALUES(@ProductClassName,@ParentProductClassID,@DisplayOrder);SELECT SCOPE_IDENTITY()",
RDBSHelper.RDBSTablePre);
//RDBSHelper.ExecuteNonQuery(CommandType.Text, commandText, parms);
return(TypeHelper.ObjectToInt(RDBSHelper.ExecuteScalar(CommandType.Text, commandText, parms), -1));
}
public void PrepareProductClassModel(SqlDataReader dr, List <ProductClassInfo> productClassList)
{
while (dr.Read())
{
ProductClassInfo item = new ProductClassInfo();
item.ID = dr.GetInt32(0);
item.FatherID = dr.GetInt32(1);
item.OrderID = dr.GetInt32(2);
item.ClassName = dr[3].ToString();
item.Keywords = dr[4].ToString();
item.Description = dr[5].ToString();
item.TaobaoID = dr.GetInt64(6);
item.IsDownload = dr.GetInt32(7);
productClassList.Add(item);
}
}
/// <summary>
/// 提交按钮点击方法
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void SubmitButton_Click(object sender, EventArgs e)
{
ProductClassInfo productClass = new ProductClassInfo();
productClass.Id = RequestHelper.GetQueryString <int>("ID");
if (FatherID.Text.Trim() == RequestHelper.GetQueryString <string>("ID"))
{
ScriptHelper.Alert("不能将上级分类设置成自己", RequestHelper.RawUrl);
Response.End();
}
if (string.IsNullOrEmpty(ProductType.Text))
{
ScriptHelper.Alert("必须选择产品类型", RequestHelper.RawUrl);
Response.End();
}
productClass.ParentId = Convert.ToInt32(FatherID.Text);
productClass.OrderId = Convert.ToInt32(OrderID.Text);
productClass.Name = ClassName.Text;
productClass.Keywords = Keywords.Text;
productClass.Remark = Description.Value;
productClass.Photo = Photo.Text;
productClass.ProductTypeId = Convert.ToInt32(ProductType.Text);
productClass.Tm = DateTime.Now;
productClass.EnClassName = EnClassName.Text.Trim();
productClass.PageTitle = PageTitle.Text.Trim();
productClass.PageKeyWord = PageKeyWord.Text.Trim();
productClass.PageSummary = PageSummary.Text.Trim();
string alertMessage = ShopLanguage.ReadLanguage("AddOK");
if (productClass.Id == int.MinValue)
{
CheckAdminPower("AddProductClass", PowerCheckType.Single);
int id = ProductClassBLL.Add(productClass);
AdminLogBLL.Add(ShopLanguage.ReadLanguage("AddRecord"), ShopLanguage.ReadLanguage("ProductClass"), id);
}
else
{
CheckAdminPower("UpdateProductClass", PowerCheckType.Single);
ProductClassBLL.Update(productClass);
AdminLogBLL.Add(ShopLanguage.ReadLanguage("UpdateRecord"), ShopLanguage.ReadLanguage("ProductClass"), productClass.Id);
alertMessage = ShopLanguage.ReadLanguage("UpdateOK");
}
ScriptHelper.Alert(alertMessage, RequestHelper.RawUrl);
}
/// <summary>
/// 页面加载方法
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
FatherID.DataSource = ProductClassBLL.ReadNamedList();
FatherID.DataTextField = "Name";
FatherID.DataValueField = "ID";
FatherID.DataBind();
FatherID.Items.Insert(0, new ListItem("作为最大类", "0"));
//foreach (ProductClassInfo productClass in ProductClassBLL.ReadNamedList())
//{
// FatherID.Items.Add(new ListItem(productClass.Name, "|" + productClass.Id + "|"));
//}
//FatherID.Items.Insert(0, new ListItem("作为最大类", "0"));
ProductType.DataSource = ProductTypeBLL.ReadList();
ProductType.DataTextField = "Name";
ProductType.DataValueField = "ID";
ProductType.DataBind();
ProductType.Items.Insert(0, new ListItem("请选择类型", "0"));
int productClassID = RequestHelper.GetQueryString <int>("ID");
int fatherID = RequestHelper.GetQueryString <int>("FatherID");
if (productClassID != int.MinValue)
{
CheckAdminPower("ReadProductClass", PowerCheckType.Single);
ProductClassInfo productClass = ProductClassBLL.Read(productClassID);
FatherID.Text = productClass.ParentId.ToString();
OrderID.Text = productClass.OrderId.ToString();
ClassName.Text = productClass.Name;
Keywords.Text = productClass.Keywords;
Description.Value = productClass.Remark;
Photo.Text = productClass.Photo;
ProductType.Text = productClass.ProductTypeId.ToString();
EnClassName.Text = productClass.EnClassName;
PageTitle.Text = productClass.PageTitle;
PageKeyWord.Text = productClass.PageKeyWord;
PageSummary.Text = productClass.PageSummary;
}
else
{
FatherID.Text = fatherID.ToString();
}
}
}
/// <summary>
/// 同步远程产品信息
/// </summary>
public static int SynErpProduct()
{
int reNo = 0;
ProductsInfo pi = new ProductsInfo();
try
{
DataTable dt = Bdu9ErpDataEngineService.getProductList("");
foreach (DataRow dr in dt.Rows)
{
if (dr["P_NAME"].ToString().Trim() != "")
{
if (tbProductsInfo.ExistsProductsInfo(dr["P_NAME"].ToString().Trim()) == false)
{
pi.pStandard = "";
pi.pUnits = dr["p_rule_min"].ToString().Trim();
pi.pMaxUnits = dr["p_rule_max"].ToString().Trim();
pi.pToBoxNo = Utils.StrToInt(dr["p_rules"].ToString().Trim(), 0);
pi.pState = 0;
ProductClassInfo pci = DataClass.GetProductClassInfoModel(dr["typename"].ToString().Trim());
if (pci != null)
{
pi.ProductClassID = pci.ProductClassID;
}
pi.pBrand = dr["typename"].ToString().Trim();
pi.pPrice = decimal.Parse(Utils.StrToFloat(dr["a_price"].ToString().Trim(), 0).ToString());
pi.pCode = Utils.GetRanDomCode();
pi.pBarcode = dr["p_code"].ToString().Trim();
pi.pName = dr["p_name"].ToString().Trim();
pi.pAppendTime = DateTime.Now;
tbProductsInfo.AddProductsInfo(pi);
reNo++;
}
}
}
}
finally
{
pi = null;
}
return(reNo);
}
/// <summary>
/// 读取编排好的产品分类---后台展示
/// </summary>
/// <param name="idList"></param>
public static string ProductClassNameListAdmin(string idList)
{
string content = string.Empty;
if (!string.IsNullOrEmpty(idList))
{
idList = idList.Substring(1, idList.Length - 2);
}
idList = idList.Replace("||", "#");
if (idList.Length > 0)
{
foreach (string temp in idList.Split('#'))
{
string tempProductClassName = string.Empty;
foreach (string id in temp.Split('|'))
{
ProductClassInfo proClass = ProductClassBLL.Read(Convert.ToInt32(id));
if (string.IsNullOrEmpty(tempProductClassName))
{
//tempProductClassName = "<a href=\"/List.html?cat=" + ReadFullParentId(proClass.Id) + "\" target=\"_blank\" title=\"" + proClass.Name + "\">" + StringHelper.Substring(proClass.Name, 10) + "</a>";
tempProductClassName = StringHelper.Substring(proClass.Name, 10);
}
else
{
//tempProductClassName += " > <a href=\"/List.html?cat=" + ReadFullParentId(proClass.Id) + "\" target=\"_blank\" title=\"" + proClass.Name + "\">" + StringHelper.Substring(proClass.Name, 10) + "</a>";
tempProductClassName += " > " + StringHelper.Substring(proClass.Name, 10);
}
}
if (!string.IsNullOrEmpty(tempProductClassName))
{
if (string.IsNullOrEmpty(content))
{
content = tempProductClassName;
}
else
{
content += "，" + tempProductClassName;
}
}
}
}
return(content);
}
/// <summary>
/// 更新产品分类
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool UpdateProductClass(ProductClassInfo model)
{
DbParameter[] parms =
{
GenerateInParam("@ProductClassID", SqlDbType.Int, 4, model.ProductClassID),
GenerateInParam("@ProductClassName", SqlDbType.NVarChar, 50, model.ProductClassName),
GenerateInParam("@ParentProductClassID", SqlDbType.Int, 4, model.ParentProductClassID),
GenerateInParam("@DisplayOrder", SqlDbType.NVarChar, 250, model.DisplayOrder)
};
string commandText = string.Format("UPDATE [{0}ProductClass] SET ProductClassName=@ProductClassName, ParentProductClassID=@ParentProductClassID, DisplayOrder=@DisplayOrder WHERE [ProductClassID]=@ProductClassID",
RDBSHelper.RDBSTablePre);
if (RDBSHelper.ExecuteNonQuery(CommandType.Text, commandText, parms) > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 根据商品分类逐级获取分类的Remark（售后服务）
/// </summary>
/// <param name="classId">商品分类</param>
/// <returns></returns>
protected string GetProductClassRemark(string classId)
{
string result = string.Empty;
if (classId.IndexOf("|") >= 0)
{
foreach (string _cid in classId.Split(new char[] { '|' }, StringSplitOptions.RemoveEmptyEntries))
{
int cid = 0;
if (int.TryParse(_cid, out cid))
{
if (cid > 0)
{
ProductClassInfo proClass = ProductClassBLL.Read(cid);
if (!string.IsNullOrEmpty(proClass.Remark))
{
result = proClass.Remark;
}
}
}
}
}
else
{
int cid = 0;
if (int.TryParse(classId, out cid))
{
if (cid > 0)
{
ProductClassInfo proClass = ProductClassBLL.Read(cid);
if (!string.IsNullOrEmpty(proClass.Remark))
{
result = proClass.Remark;
}
}
}
}
return(result);
}
private static List <ProductClassInfo> ReadProductClassChildList(int fatherID, int depth)
{
List <ProductClassInfo> list = new List <ProductClassInfo>();
List <ProductClassInfo> list2 = ReadProductClassCacheList();
foreach (ProductClassInfo info in list2)
{
if (info.FatherID == fatherID)
{
ProductClassInfo item = (ProductClassInfo)ServerHelper.CopyClass(info);
string str = string.Empty;
for (int i = 1; i < depth; i++)
{
str = str + HttpContext.Current.Server.HtmlDecode(" ");
}
item.ClassName = str + item.ClassName;
list.Add(item);
list.AddRange(ReadProductClassChildList(item.ID, depth + 1));
}
}
return(list);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!this.Page.IsPostBack)
{
this.FatherID.DataSource = ProductClassBLL.ReadProductClassNamedList();
this.FatherID.DataTextField = "ClassName";
this.FatherID.DataValueField = "ID";
this.FatherID.DataBind();
this.FatherID.Items.Insert(0, new ListItem("作为最大类", "0"));
int queryString = RequestHelper.GetQueryString <int>("ID");
if (queryString != -2147483648)
{
base.CheckAdminPower("ReadProductClass", PowerCheckType.Single);
ProductClassInfo info = ProductClassBLL.ReadProductClassCache(queryString);
this.FatherID.Text = info.FatherID.ToString();
this.OrderID.Text = info.OrderID.ToString();
this.ClassName.Text = info.ClassName;
this.Keywords.Text = info.Keywords;
this.Description.Text = info.Description;
this.IsDownload.Text = info.IsDownload.ToString();
}
}
}
/// <summary>
/// 创建产品类型
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static int Create(ProductClassInfo model)
{
return(BonSite.Core.BSData.RDBS.CreateProductClass(model));
}
public static void UpdateProductClass(ProductClassInfo productClass)
{
dal.UpdateProductClass(productClass);
CacheHelper.Remove(cacheKey);
}
protected override void PageLoad()
{
base.PageLoad();
var queryClass = StringHelper.AddSafe(HttpUtility.UrlDecode(RequestHelper.GetQueryString <string>("cat"))).Split(',');
int classLevel1 = 0, classLevel2 = 0, classLevel3 = 0;
if (queryClass.Length > 0)
{
classLevel1 = ShopCommon.ConvertToT <int>(queryClass[0]);
}
if (queryClass.Length > 1)
{
classLevel2 = ShopCommon.ConvertToT <int>(queryClass[1]);
}
if (queryClass.Length > 2)
{
classLevel3 = ShopCommon.ConvertToT <int>(queryClass[2]);
}
int currentClassId = classLevel3 > 0 ? classLevel3 : classLevel2 > 0 ? classLevel2 : classLevel1;
if (currentClassId < 0)
{
currentClassId = 0;
}
//if (currentClassId < 1) ResponseHelper.Redirect("/");
//面包屑区域--分类
showClassList = ProductClassBLL.ReadList();
currentClass = showClassList.FirstOrDefault(k => k.Id == currentClassId) ?? new ProductClassInfo();
levelClass.Add("level1", showClassList.FirstOrDefault(k => k.Id == classLevel1) ?? new ProductClassInfo());
levelClass.Add("level2", showClassList.FirstOrDefault(k => k.Id == classLevel2) ?? new ProductClassInfo());
levelClass.Add("level3", showClassList.FirstOrDefault(k => k.Id == classLevel3) ?? new ProductClassInfo());
//热门商品
int hotCount = 0;
hotProductList = ProductBLL.SearchList(1, 7, new ProductSearchInfo {
IsHot = (int)BoolType.True, IsSale = (int)BoolType.True
}, ref hotCount);
//商品列表
currentPage = RequestHelper.GetQueryString <int>("Page");
if (currentPage < 1)
{
currentPage = 1;
}
int pageSize = 6; int count = 0;
string brandIds = StringHelper.AddSafe(HttpUtility.UrlDecode(RequestHelper.GetQueryString <string>("brand")));
string attributeIds = StringHelper.AddSafe(HttpUtility.UrlDecode(RequestHelper.GetQueryString <string>("at")));
string attributeValues = StringHelper.AddSafe(HttpUtility.UrlDecode(RequestHelper.GetQueryString <string>("ex").Trim()));
string orderField = StringHelper.AddSafe(HttpUtility.UrlDecode(RequestHelper.GetQueryString <string>("sort")));
string orderType = "";
var orderParams = orderField.Split('_');
if (orderParams.Length > 1)
{
orderField = orderParams[0];
orderType = orderParams[1];
}
int minPrice = RequestHelper.GetQueryString <int>("min");
int maxPrice = RequestHelper.GetQueryString <int>("max");
string keywords = StringHelper.AddSafe(HttpUtility.UrlDecode(RequestHelper.GetQueryString <string>("kw")));
#region 添加到搜索记录
if (keywords != string.Empty)
{
var historySearch = Server.UrlDecode(CookiesHelper.ReadCookieValue("HistorySearch"));
if (("," + historySearch + ",").IndexOf("," + Server.UrlDecode(keywords) + ",") == -1)
{
if (historySearch == "")
{
historySearch = Server.UrlDecode(keywords);
}
else
{
historySearch = Server.UrlDecode(keywords) + "," + historySearch;
}
if (historySearch.ToString().IndexOf(",") > -1)
{
if (historySearch.Split(',').Length > 8)
{
historySearch = historySearch.Substring(0, historySearch.LastIndexOf(","));
}
}
CookiesHelper.AddCookie("HistorySearch", Server.UrlEncode(historySearch));
}
}
#endregion
int isNew = RequestHelper.GetQueryString <int>("isNew");
int isHot = RequestHelper.GetQueryString <int>("isHot");
int isSpecial = RequestHelper.GetQueryString <int>("isSpecial");
int isTop = RequestHelper.GetQueryString <int>("isTop");
productList = ProductBLL.SearchList(currentPage, pageSize, currentClassId, brandIds, attributeIds, attributeValues, orderField, orderType, minPrice, maxPrice, keywords, "", isNew, isHot, isSpecial, isTop, ref count, ref showAttributeList, ref showBrandList);
//手机端特殊，显示所有当前产品类型下的品牌和属性，不会判断有无产品
if (currentClassId > 0)
{
//取得当前分类所属类型
ProductTypeInfo productType = ProductTypeBLL.Read(ProductClassBLL.Read(currentClassId).ProductTypeId);
showBrandList = ProductBrandBLL.ReadList(Array.ConvertAll <string, int>(productType.BrandIds.Split(new char[] { ';' }, StringSplitOptions.RemoveEmptyEntries), k => Convert.ToInt32(k)));
showAttributeList = ProductTypeAttributeBLL.ReadList(productType.Id);
}
#region 添加热门关键词
//如果有搜索结果且关键词不为空
if (productList.Count > 0 && !string.IsNullOrEmpty(keywords))
{
var theSearchKey = HotSearchKeyBLL.Read(keywords);
//之前没有则增加
if (theSearchKey.Id <= 0)
{
theSearchKey.Name = keywords;
theSearchKey.SearchTimes = 1;
HotSearchKeyBLL.Add(theSearchKey);
}
else
{ //有则修改更新搜索次数
theSearchKey.SearchTimes += 1;
HotSearchKeyBLL.Update(theSearchKey);
}
}
#endregion
ProductClassInfo thisProductClass = new ProductClassInfo();
if (classLevel3 > 0)
{
thisProductClass = ProductClassBLL.Read(classLevel3);
}
else if (classLevel2 > 0)
{
thisProductClass = ProductClassBLL.Read(classLevel2);
}
else
{
thisProductClass = ProductClassBLL.Read(classLevel1);
}
Title = thisProductClass.PageTitle.Trim() == "" ? thisProductClass.Name : thisProductClass.PageTitle;
Keywords = thisProductClass.PageKeyWord.Trim() == "" ? thisProductClass.Name : thisProductClass.PageKeyWord;
//Description = thisProductClass.PageSummary.Trim() == "" ? thisProductClass.Remark : thisProductClass.PageSummary;
Description = thisProductClass.PageSummary;
}
public static int AddProductClass(ProductClassInfo productClass)
{
productClass.ID = dal.AddProductClass(productClass);
CacheHelper.Remove(cacheKey);
return(productClass.ID);
}
protected override void PageLoad()
{
base.PageLoad();
var queryClass = RequestHelper.GetQueryString <string>("cat").Split(',');
int classLevel1 = 0, classLevel2 = 0, classLevel3 = 0;
if (queryClass.Length > 0)
{
classLevel1 = ShopCommon.ConvertToT <int>(queryClass[0]);
}
if (queryClass.Length > 1)
{
classLevel2 = ShopCommon.ConvertToT <int>(queryClass[1]);
}
if (queryClass.Length > 2)
{
classLevel3 = ShopCommon.ConvertToT <int>(queryClass[2]);
}
int currentClassId = classLevel3 > 0 ? classLevel3 : classLevel2 > 0 ? classLevel2 : classLevel1;
if (currentClassId < 1)
{
ResponseHelper.Redirect("/");
}
if (classLevel1 > 0)
{
switch (classLevel1)
{
case 1:
topNav = 2;
break;
case 2:
topNav = 3;
break;
case 4:
topNav = 4;
break;
case 6:
topNav = 5;
break;
}
}
//面包屑区域--分类
showClassList = ProductClassBLL.ReadList();
currentClass = showClassList.FirstOrDefault(k => k.Id == currentClassId) ?? new ProductClassInfo();
levelClass.Add("level1", showClassList.FirstOrDefault(k => k.Id == classLevel1) ?? new ProductClassInfo());
levelClass.Add("level2", showClassList.FirstOrDefault(k => k.Id == classLevel2) ?? new ProductClassInfo());
levelClass.Add("level3", showClassList.FirstOrDefault(k => k.Id == classLevel3) ?? new ProductClassInfo());
//热门商品
int hotCount = 0;
hotProductList = ProductBLL.SearchList(1, 7, new ProductSearchInfo {
IsHot = (int)BoolType.True, IsSale = (int)BoolType.True
}, ref hotCount);
//商品列表
currentPage = RequestHelper.GetQueryString <int>("Page");
if (currentPage < 1)
{
currentPage = 1;
}
int pageSize = 15; int count = 0;
string brandIds = RequestHelper.GetQueryString <string>("brand");
string attributeIds = RequestHelper.GetQueryString <string>("at");
string attributeValues = RequestHelper.GetQueryString <string>("ex");
string orderField = RequestHelper.GetQueryString <string>("sort");
string orderType = "";
var orderParams = orderField.Split('_');
if (orderParams.Length > 1)
{
orderField = orderParams[0];
orderType = orderParams[1];
}
int minPrice = RequestHelper.GetQueryString <int>("min");
int maxPrice = RequestHelper.GetQueryString <int>("max");
string keywords = RequestHelper.GetQueryString <string>("kw");
int isNew = RequestHelper.GetQueryString <int>("isNew");
int isHot = RequestHelper.GetQueryString <int>("isHot");
int isSpecial = RequestHelper.GetQueryString <int>("isSpecial");
int isTop = RequestHelper.GetQueryString <int>("isTop");
productList = ProductBLL.SearchList(currentPage, pageSize, currentClassId, brandIds, attributeIds, attributeValues, orderField, orderType, minPrice, maxPrice, keywords, "", isNew, isHot, isSpecial, isTop, ref count, ref showAttributeList, ref showBrandList);
pager.Init(currentPage, pageSize, count, !string.IsNullOrEmpty(isMobile));
//pager.CurrentPage = currentPage;
//pager.PageSize = pageSize;
//pager.Count = count;
//pager.FirstPage = "<<首页";
//pager.PreviewPage = "<<上一页";
//pager.NextPage = "下一页>>";
//pager.LastPage = "末页>>";
//pager.ListType = false;
//pager.DisCount = false;
//pager.PrenextType = true;
ProductClassInfo thisProductClass = new ProductClassInfo();
if (classLevel3 > 0)
{
thisProductClass = ProductClassBLL.Read(classLevel3);
}
else if (classLevel2 > 0)
{
thisProductClass = ProductClassBLL.Read(classLevel2);
}
else
{
thisProductClass = ProductClassBLL.Read(classLevel1);
}
Title = thisProductClass.PageTitle.Trim() == "" ? thisProductClass.Name : thisProductClass.PageTitle;
Keywords = thisProductClass.PageKeyWord.Trim() == "" ? thisProductClass.Name : thisProductClass.PageKeyWord;
Description = thisProductClass.PageSummary.Trim() == "" ? thisProductClass.Remark : thisProductClass.PageSummary;
}
public string lastName = "";//修改前的名称
protected virtual void Page_Load(object sender, EventArgs e)
{
if (this.userid > 0)
{
if (CheckUserPopedoms("X") || CheckUserPopedoms("2-1-1"))
{
Act = HTTPRequest.GetString("Act");
pClassName = Utils.ChkSQL(HTTPRequest.GetString("tName").Trim());
productClassID = HTTPRequest.GetInt("classID", 0);
lastName = HTTPRequest.GetString("lastName").Trim();
if (productClassID > 0)
{
pi = DataClass.GetProductClassInfoModel(productClassID);
}
if (ispost)
{
//添加
if (Act.IndexOf("add") > -1)
{
ProductClassInfo li = new ProductClassInfo();
if (pClassName != "")
{
li.pParentID = productClassID;
li.pClassName = pClassName;
li.pOrder = HTTPRequest.GetInt("tOrder", 0);
li.pAppendTime = DateTime.Now;
bool hValue = DataClass.ExistsProductClassInfo(HTTPRequest.GetString("tName"), productClassID);
if (hValue)
{
AddErrLine("操作失败，该条分类已经存在，请核对后重新添加！");
}
else
{
int addCount = DataClass.AddProductClassInfo(li);
if (addCount > 0)
{
//记录成功操作
Logs.AddEventLog(this.userid, "添加" + pClassName + "商品分类");
AddMsgLine("操作成功！");
AddScript("window.setTimeout('window.parent.HidBox();',1000);");
}
else
{
AddErrLine("操作失败，请重新添加！");
}
}
}
else
{
AddErrLine("操作失败，请重新添加！");
}
}
//修改
if (Act.IndexOf("update") > -1)
{
if (pClassName != "")
{
pi.ProductClassID = productClassID;
pi.pClassName = pClassName;
pi.pAppendTime = DateTime.Now;
int count = DataClass.UpdateProductClassInfo(pi);
if (count > 0)
{
//记录修改操作
Logs.AddEventLog(this.userid, "将" + lastName + "商品修改为" + pClassName);
AddMsgLine("修改成功！");
AddScript("window.setTimeout('window.parent.HidBox();',1000);");
}
else
{
AddErrLine("修改失败！");
}
}
else
{
AddErrLine("修改失败！");
}
}
}
}
else
{
AddErrLine("权限不足!");
AddScript("window.parent.HidBox();");
}
}
else
{
AddErrLine("请先登录!");
SetBackLink("login.aspx?referer=" + Utils.UrlEncode(Utils.GetUrlReferrer()));
SetMetaRefresh(1, "login.aspx?referer=" + Utils.UrlEncode(Utils.GetUrlReferrer()));
}
}
/// <summary>
/// 更新产品类型
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static bool Update(ProductClassInfo model)
{
return(BonSite.Core.BSData.RDBS.UpdateProductClass(model));
}
