/// <summary>
/// 根据主键获取一个ClassesFound实体记录。
/// 该方法提供给其他实体的业务逻辑层（Logic）方法调用
/// </summary>
/// <returns>ClassesFound实体</returns>
/// <param name="columns">要返回的列</param>
public ClassesFoundEntity GetClassesFound(int id, bool iscache = false)
{
if (iscache)
{
string _cachekey = "ClassesFound_" + id.ToString();// SysCacheKey.ClassesFoundListKey;
object _objcache = MemCache.GetCache(_cachekey);
ClassesFoundEntity _obj = new ClassesFoundEntity();
if (_objcache == null)
{
_obj = ClassesFoundDA.Instance.GetClassesFound(id);
MemCache.AddCache(_cachekey, _obj);
}
else
{
_obj = (ClassesFoundEntity)_objcache;
}
return(_obj);
}
else if (iscache == false)
{
return(ClassesFoundDA.Instance.GetClassesFound(id));
}
else
{
return(null);
}
}
/// <summary>
/// 根据主键值更新记录的全部字段（注意：该方法不会对自增字段、timestamp类型字段以及主键字段更新！如果要更新主键字段，请使用Update方法）。
/// 如果数据库有数据被更新了则返回True，否则返回False
/// </summary>
/// <param name="db">数据库操作对象</param>
/// <param name="classesFound">待更新的实体对象</param>
public int UpdateClassesFound(ClassesFoundEntity entity)
{
string sql = @" UPDATE dbo.[ClassesFound] SET
[Code]=@Code,[Name]=@Name,[FullName]=@FullName,[PYFirst]=@PYFirst,[PYShort]=@PYShort,[PYFull]=@PYFull,[AdId]=@AdId,[Sort]=@Sort,[IsActive]=@IsActive,[IsHot]=@IsHot,[CreateTime]=@CreateTime,[UpdateTime]=@UpdateTime,[ClassLevel]=@ClassLevel,[IsEnd]=@IsEnd,[HasProperties]=@HasProperties, [ParentId]=@ParentId, [ClassType]=@ClassType
WHERE [Id]=@id";
DbCommand cmd = db.GetSqlStringCommand(sql);
db.AddInParameter(cmd, "@Id", DbType.Int32, entity.Id);
db.AddInParameter(cmd, "@Code", DbType.String, entity.Code);
db.AddInParameter(cmd, "@Name", DbType.String, entity.Name);
db.AddInParameter(cmd, "@FullName", DbType.String, entity.FullName);
db.AddInParameter(cmd, "@PYFirst", DbType.String, entity.PYFirst);
db.AddInParameter(cmd, "@PYShort", DbType.String, entity.PYShort);
db.AddInParameter(cmd, "@PYFull", DbType.String, entity.PYFull);
db.AddInParameter(cmd, "@AdId", DbType.Int32, entity.AdId);
db.AddInParameter(cmd, "@Sort", DbType.Int32, entity.Sort);
db.AddInParameter(cmd, "@IsActive", DbType.Int32, entity.IsActive);
db.AddInParameter(cmd, "@IsHot", DbType.Int32, entity.IsHot);
db.AddInParameter(cmd, "@CreateTime", DbType.DateTime, entity.CreateTime);
db.AddInParameter(cmd, "@UpdateTime", DbType.DateTime, entity.UpdateTime);
db.AddInParameter(cmd, "@ClassLevel", DbType.Int32, entity.ClassLevel);
db.AddInParameter(cmd, "@IsEnd", DbType.Int32, entity.IsEnd);
db.AddInParameter(cmd, "@ParentId", DbType.Int32, entity.ParentId);
db.AddInParameter(cmd, "@HasProperties", DbType.Int32, entity.HasProperties);
db.AddInParameter(cmd, "@PropertiesClassId", DbType.Int32, entity.PropertiesClassId);
db.AddInParameter(cmd, "@HasProduct", DbType.Int32, entity.HasProduct);
db.AddInParameter(cmd, "@ClassType", DbType.Int32, entity.ClassType);
return(db.ExecuteNonQuery(cmd));
}
public ActionResult Search()
{
int classid = QueryString.IntSafeQ("cl");
int brandid = QueryString.IntSafeQ("bd");
int siteid = QueryString.IntSafeQ("s");
int pageindex = QueryString.IntSafeQ("pi");
int jishi = QueryString.IntSafeQ("js", -1);
if (jishi == -1)
{
jishi = (int)JiShiSongEnum.Normal;
}
if (classid > 0)
{
ClassesFoundEntity _classentity = ClassesFoundBLL.Instance.GetClassesFound(classid, true);
ViewBag.SelectClassName = _classentity.Name;
ViewBag.SelectClassId = classid;
}
if (brandid > 0)
{
BrandEntity brand = BrandBLL.Instance.GetBrand(brandid, true);
ViewBag.SelectBrandName = brand.Name;
ViewBag.SelectBrandId = brandid;
}
if (pageindex < 1)
{
pageindex = 1;
}
int pagesize = CommonKey.PageSizeList;
string querykey = QueryString.SafeQ("key");
return(View());
}
/// <summary>
/// 分类品牌管理
/// </summary>
/// <returns></returns>
public ActionResult ClassBrandManage()
{
int _classid = QueryString.IntSafeQ("classid", 0);
ClassesFoundEntity entity = ClassesFoundBLL.Instance.GetClassesFound(_classid, false);
int _pageindex = QueryString.IntSafeQ("pageindex", 1);
int _pagesize = CommonKey.PageSizeBrand;
int _recordCount = 0;
IList <ConditionUnit> wherelist = new List <ConditionUnit>();
wherelist.Add(new ConditionUnit {
FieldName = "ClassId", CompareValue = _classid.ToString()
});
IList <ClassBrandEntity> entitylist = ClassBrandBLL.Instance.GetClassBrandList(_pagesize, _pageindex, ref _recordCount, wherelist);
ViewBag.entitylist = entitylist;
string _url = "/Class/ClassBrandManage?classid=" + _classid;
string PageStr = HTMLPage.SetOrderListPage(_recordCount, _pagesize, _pageindex, _url);
ViewBag.PageStr = PageStr;
ViewBag.entity = entity;
return(View());
}
/// <summary>
/// 读取记录列表。
/// </summary>
/// <param name="db">数据库操作对象</param>
/// <param name="columns">需要返回的列，不提供任何列名时默认将返回所有列</param>
public IList <ClassesFoundEntity> GetClassesFoundAll()
{
string sql = @"SELECT [Id],[Code],[Name],[PYFirst],[PYShort],[PYFull],[AdId],[Sort],[IsActive],[IsHot],[CreateTime],[UpdateTime],[ClassLevel],[IsEnd],[HasProperties],[HasSpecific],[SpecificTitle],[ParentId],[StyleEnd],[HasProduct] from dbo.[ClassesFound] WITH(NOLOCK) ";
IList <ClassesFoundEntity> entityList = new List <ClassesFoundEntity>();
DbCommand cmd = db.GetSqlStringCommand(sql);
using (IDataReader reader = db.ExecuteReader(cmd))
{
while (reader.Read())
{
ClassesFoundEntity entity = new ClassesFoundEntity();
entity.Id = StringUtils.GetDbInt(reader["Id"]);
entity.Code = StringUtils.GetDbString(reader["Code"]);
entity.Name = StringUtils.GetDbString(reader["Name"]);
entity.PYFirst = StringUtils.GetDbString(reader["PYFirst"]);
entity.PYShort = StringUtils.GetDbString(reader["PYShort"]);
entity.PYFull = StringUtils.GetDbString(reader["PYFull"]);
entity.AdId = StringUtils.GetDbInt(reader["AdId"]);
entity.Sort = StringUtils.GetDbInt(reader["Sort"]);
entity.IsActive = StringUtils.GetDbInt(reader["IsActive"]);
entity.IsHot = StringUtils.GetDbInt(reader["IsHot"]);
entity.CreateTime = StringUtils.GetDbDateTime(reader["CreateTime"]);
entity.UpdateTime = StringUtils.GetDbDateTime(reader["UpdateTime"]);
entity.ClassLevel = StringUtils.GetDbInt(reader["ClassLevel"]);
entity.IsEnd = StringUtils.GetDbInt(reader["IsEnd"]);
entity.HasProperties = StringUtils.GetDbInt(reader["HasProperties"]);
entity.ParentId = StringUtils.GetDbInt(reader["ParentId"]);
entityList.Add(entity);
}
}
return(entityList);
}
/// <summary>
/// 判断当前节点是否已存在相同的
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public int ExistNum(ClassesFoundEntity entity)
{
///id=0,判断总数，ID>0判断除自己之外的总数
string sql = @"Select count(1) from dbo.[ClassesFound] WITH(NOLOCK) ";
string where = "where ";
if (entity.Id == 0)
{
where = where + " (Name=@Name) ";
}
else
{
where = where + " id<>@Id and (Name=@Name) ";
}
sql = sql + where;
DbCommand cmd = db.GetSqlStringCommand(sql);
if (entity.Id > 0)
{
db.AddInParameter(cmd, "@Id", DbType.Int32, entity.Id);
}
db.AddInParameter(cmd, "@Name", DbType.String, entity.Name);
object identity = db.ExecuteScalar(cmd);
if (identity == null || identity == DBNull.Value)
{
return(0);
}
return(Convert.ToInt32(identity));
}
public List <int> GetSubClassEndList(int classid, bool cache = false)
{
List <int> _listint = new List <int>();
if (cache == false)
{
ClassesFoundEntity _entity = GetClassesFound(classid, cache);
int redirectclassid = _entity.RedirectClassId;
if (redirectclassid == 0)
{
redirectclassid = _entity.Id;
}
_listint.Add(redirectclassid);
if (_entity.IsEnd == 0 && redirectclassid > 0)
{
IList <ClassesFoundEntity> _entitylist2 = GetClassesAllByPId(redirectclassid, cache, -1);
if (_entitylist2 != null && _entitylist2.Count > 0)
{
foreach (ClassesFoundEntity _entity2 in _entitylist2)
{
List <int> listsub = GetSubClassEndList(_entity2.Id, cache);
_listint.AddRange(listsub);
}
}
}
}
else
{
string _cachekey = "GetSubClassEndList_" + classid;
object obj = MemCache.GetCache(_cachekey);
if (obj == null)
{
ClassesFoundEntity _entity = GetClassesFound(classid, false);
int redirectclassid = _entity.RedirectClassId;
if (redirectclassid == 0)
{
redirectclassid = _entity.Id;
}
_listint.Add(redirectclassid);
if (_entity.IsEnd == 0 && redirectclassid > 0)
{
IList <ClassesFoundEntity> _entitylist2 = GetClassesAllByPId(redirectclassid, false, -1);
if (_entitylist2 != null && _entitylist2.Count > 0)
{
foreach (ClassesFoundEntity _entity2 in _entitylist2)
{
List <int> listsub = GetSubClassEndList(_entity2.Id);
_listint.AddRange(listsub);
}
}
}
}
else
{
_listint = (List <int>)obj;
}
}
return(_listint);
}
/// <summary>
/// 特价商品列表
/// </summary>
/// <returns></returns>
private IList <ClassesFoundEntity> ListRavStr(ClassesFoundEntity _classentity)
{
IList <ClassesFoundEntity> list = new List <ClassesFoundEntity>();
list.Add(_classentity);
if (_classentity != null)
{
if (_classentity.ParentId > 0)
{
ClassesFoundEntity _classentity2 = ClassesFoundBLL.Instance.GetClassesFound(_classentity.ParentId, false);
if (_classentity.Name != _classentity2.Name)
{
list.Add(_classentity2);
}
if (_classentity2.ParentId > 0)
{
ClassesFoundEntity _classentity3 = ClassesFoundBLL.Instance.GetClassesFound(_classentity2.ParentId, false);
if (_classentity2.Name != _classentity3.Name)
{
list.Add(_classentity3);
}
if (_classentity3.ParentId > 0)
{
ClassesFoundEntity _classentity4 = ClassesFoundBLL.Instance.GetClassesFound(_classentity3.ParentId, false);
if (_classentity3.Name != _classentity4.Name)
{
list.Add(_classentity4);
}
}
}
}
}
return(list);
}
// /// <summary>
// /// 插入一条记录到表ClassesFound，如果表中存在自增字段，则返回值为新记录的自增字段值，否则返回0
// /// </summary>
// /// <param name="db">数据库操作对象</param>
// /// <param name="classesFound">待插入的实体对象</param>
// public int AddClassesFound(ClassesFoundEntity entity)
// {
// string sql = @"insert into ClassesFound( [Code],[Name],[PYFirst],[PYShort],[PYFull],[AdId],[Sort],[IsActive],[IsHot],[CreateTime],[UpdateTime],[ClassLevel],[IsEnd],[HasProperties],[HasSpecific],[SpecificTitle],[ParentId],[StyleEnd],[HasProduct])VALUES
// ( @Code,@Name,@PYFirst,@PYShort,@PYFull,@AdId,@Sort,@IsActive,@IsHot,@CreateTime,@UpdateTime,@ClassLevel,@IsEnd,@HasProperties,@HasSpecific,@SpecificTitle,@ParentId,@StyleEnd,@HasProduct);
//SELECT SCOPE_IDENTITY();";
// DbCommand cmd = db.GetSqlStringCommand(sql);
// db.AddInParameter(cmd, "@Code", DbType.String, entity.Code);
// db.AddInParameter(cmd, "@Name", DbType.String, entity.Name);
// db.AddInParameter(cmd, "@PYFirst", DbType.String, entity.PYFirst);
// db.AddInParameter(cmd, "@PYShort", DbType.String, entity.PYShort);
// db.AddInParameter(cmd, "@PYFull", DbType.String, entity.PYFull);
// db.AddInParameter(cmd, "@AdId", DbType.Int32, entity.AdId);
// db.AddInParameter(cmd, "@Sort", DbType.Int32, entity.Sort);
// db.AddInParameter(cmd, "@IsActive", DbType.Int32, entity.IsActive);
// db.AddInParameter(cmd, "@IsHot", DbType.Int32, entity.IsHot);
// db.AddInParameter(cmd, "@CreateTime", DbType.DateTime, entity.CreateTime);
// db.AddInParameter(cmd, "@UpdateTime", DbType.DateTime, entity.UpdateTime);
// db.AddInParameter(cmd, "@ClassLevel", DbType.Int32, entity.ClassLevel);
// db.AddInParameter(cmd, "@IsEnd", DbType.Int32, entity.IsEnd);
// db.AddInParameter(cmd, "@HasProperties", DbType.Int32, entity.HasProperties);
// db.AddInParameter(cmd, "@ParentId", DbType.Int32, entity.ParentId);
// object identity = db.ExecuteScalar(cmd);
// if (identity == null || identity == DBNull.Value) return 0;
// return Convert.ToInt32(identity);
// }
/// <summary>
/// 插入一条记录到表ClassesFound，如果表中存在自增字段，则返回值为新记录的自增字段值，否则返回0
/// </summary>
/// <param name="db">数据库操作对象</param>
/// <param name="classesFound">待插入的实体对象</param>
public int AddClassesFound(ClassesFoundEntity entity)
{
string sql = @"insert into ClassesFound( [Code],[Name],[FullName],[PYFirst],[PYShort],[PYFull],[AdId],[Sort],[IsActive],[IsHot],[CreateTime],[UpdateTime],[ClassLevel],[IsEnd],[ParentId],[HasProperties],[PropertiesClassId],[HasProduct],[SiteId],ClassType)VALUES
( @Code,@Name,@FullName,@PYFirst,@PYShort,@PYFull,@AdId,@Sort,@IsActive,@IsHot,@CreateTime,@UpdateTime,@ClassLevel,@IsEnd,@ParentId,@HasProperties,@PropertiesClassId,@HasProduct,@SiteId,@ClassType);
SELECT SCOPE_IDENTITY();" ;
DbCommand cmd = db.GetSqlStringCommand(sql);
db.AddInParameter(cmd, "@Code", DbType.String, entity.Code);
db.AddInParameter(cmd, "@Name", DbType.String, entity.Name);
db.AddInParameter(cmd, "@FullName", DbType.String, entity.FullName);
db.AddInParameter(cmd, "@PYFirst", DbType.String, entity.PYFirst);
db.AddInParameter(cmd, "@PYShort", DbType.String, entity.PYShort);
db.AddInParameter(cmd, "@PYFull", DbType.String, entity.PYFull);
db.AddInParameter(cmd, "@AdId", DbType.Int32, entity.AdId);
db.AddInParameter(cmd, "@Sort", DbType.Int32, entity.Sort);
db.AddInParameter(cmd, "@IsActive", DbType.Int32, entity.IsActive);
db.AddInParameter(cmd, "@IsHot", DbType.Int32, entity.IsHot);
db.AddInParameter(cmd, "@CreateTime", DbType.DateTime, entity.CreateTime);
db.AddInParameter(cmd, "@UpdateTime", DbType.DateTime, entity.UpdateTime);
db.AddInParameter(cmd, "@ClassLevel", DbType.Int32, entity.ClassLevel);
db.AddInParameter(cmd, "@IsEnd", DbType.Int32, entity.IsEnd);
db.AddInParameter(cmd, "@ParentId", DbType.Int32, entity.ParentId);
db.AddInParameter(cmd, "@HasProperties", DbType.Int32, entity.HasProperties);
db.AddInParameter(cmd, "@PropertiesClassId", DbType.Int32, entity.PropertiesClassId);
db.AddInParameter(cmd, "@HasProduct", DbType.Int32, entity.HasProduct);
db.AddInParameter(cmd, "@SiteId", DbType.Int32, entity.SiteId);
db.AddInParameter(cmd, "@ClassType", DbType.Int32, entity.ClassType);
object identity = db.ExecuteScalar(cmd);
if (identity == null || identity == DBNull.Value)
{
return(0);
}
return(Convert.ToInt32(identity));
}
public IList <ClassesFoundEntity> GetClassesAllByBrandId(int siteid, int brandid)
{
string where = " where a.BrandId=@BrandId ";
if (siteid > 0)
{
where += " and b.SiteId=@SiteId ";
}
string sql = @" SELECT b.[Id],[Code],[Name],[PYFirst],[PYShort],[PYFull],[AdId],b.[Sort],[IsActive],[IsHot],[CreateTime],[UpdateTime],[ClassLevel],[IsEnd],[HasProperties],[ParentId],PropertiesClassId,HasProduct,ClassType
from ClassBrand a WITH(NOLOCK) inner join dbo.[ClassesFound] b WITH(NOLOCK) ON a.ClassId=b.Id " + where;
IList <ClassesFoundEntity> entityList = new List <ClassesFoundEntity>();
DbCommand cmd = db.GetSqlStringCommand(sql);
if (brandid != -1)
{
db.AddInParameter(cmd, "@BrandId", DbType.Int32, brandid);
}
if (siteid > 0)
{
db.AddInParameter(cmd, "@SiteId", DbType.Int32, siteid);
}
using (IDataReader reader = db.ExecuteReader(cmd))
{
while (reader.Read())
{
ClassesFoundEntity entity = new ClassesFoundEntity();
entity.Id = StringUtils.GetDbInt(reader["Id"]);
entity.Code = StringUtils.GetDbString(reader["Code"]);
entity.Name = StringUtils.GetDbString(reader["Name"]);
entity.PYFirst = StringUtils.GetDbString(reader["PYFirst"]);
entity.PYShort = StringUtils.GetDbString(reader["PYShort"]);
entity.PYFull = StringUtils.GetDbString(reader["PYFull"]);
entity.AdId = StringUtils.GetDbInt(reader["AdId"]);
entity.Sort = StringUtils.GetDbInt(reader["Sort"]);
entity.IsActive = StringUtils.GetDbInt(reader["IsActive"]);
entity.IsHot = StringUtils.GetDbInt(reader["IsHot"]);
entity.CreateTime = StringUtils.GetDbDateTime(reader["CreateTime"]);
entity.UpdateTime = StringUtils.GetDbDateTime(reader["UpdateTime"]);
entity.ClassLevel = StringUtils.GetDbInt(reader["ClassLevel"]);
entity.IsEnd = StringUtils.GetDbInt(reader["IsEnd"]);
entity.HasProperties = StringUtils.GetDbInt(reader["HasProperties"]);
entity.PropertiesClassId = StringUtils.GetDbInt(reader["PropertiesClassId"]);
entity.HasProduct = StringUtils.GetDbInt(reader["HasProduct"]);
entity.ParentId = StringUtils.GetDbInt(reader["ParentId"]);
entity.ClassType = StringUtils.GetDbInt(reader["ClassType"]);
entityList.Add(entity);
}
}
return(entityList);
}
/// <summary>
/// 分类信息修改
/// </summary>
/// <returns></returns>
public int ClassInfoUpdate()
{
int _id = FormString.IntSafeQ("id");
int _adid = FormString.IntSafeQ("adid");
int _ishot = FormString.IntSafeQ("ishot");
int _isactive = FormString.IntSafeQ("isactive");
int _sort = FormString.IntSafeQ("sort");
int _hasproduct = FormString.IntSafeQ("hasproduct");
int _productnum = FormString.IntSafeQ("productnum");
int _hasproperty = FormString.IntSafeQ("hasproperty");
int _haspropertyclassid = FormString.IntSafeQ("haspropertyclassid");
string _code = FormString.SafeQ("code");
string _name = FormString.SafeQ("name");
int _classtype = FormString.IntSafeQ("classtype");
string _fullname = FormString.SafeQ("fullname");
string _pyshort = FormString.SafeQ("pyshort");
string _pyfull = FormString.SafeQ("pyfull");
ClassesFoundEntity entity = ClassesFoundBLL.Instance.GetClassesFound(_id, false);
entity.AdId = _adid;
entity.IsHot = _ishot;
entity.IsActive = _isactive;
entity.Sort = _sort;
entity.HasProduct = _hasproduct;
entity.ClassType = _productnum;
entity.HasProperties = _hasproperty;
entity.PropertiesClassId = _haspropertyclassid;
entity.Code = _code;
entity.Name = _name;
entity.FullName = _fullname;
entity.ClassType = _classtype;
entity.PYShort = _pyshort;
entity.PYFull = _pyfull;
entity.UpdateTime = DateTime.Now;
int _result = ClassesFoundBLL.Instance.UpdateClassesFound(entity);
return(_result);
}
/// <summary>
/// 插入一条记录到表ClassesFound，如果表中存在自增字段，则返回值为新记录的自增字段值，否则返回0。
/// 该方法提供给界面等UI层调用
/// </summary>
/// <param name="classesFound">要添加的ClassesFound数据实体对象</param>
public int AddClassesFound(ClassesFoundEntity classesFound)
{
if (classesFound.Id > 0)
{
return(UpdateClassesFound(classesFound));
}
else if (string.IsNullOrEmpty(classesFound.Name))
{
return((int)CommonStatus.ADD_Fail_Empty);
}
else if (ClassesFoundBLL.Instance.IsExist(classesFound))
{
return((int)CommonStatus.ADD_Fail_Exist);
}
else
{
return(ClassesFoundDA.Instance.AddClassesFound(classesFound));
}
}
public IList <BrandEntity> GetBrandByKey(int classid, int pid, string key)
{
string classidstr = "";
if (classid > 0)
{
ClassesFoundEntity _classentity = ClassesFoundBLL.Instance.GetClassesFound(classid, false);
IList <int> classintlist = new List <int>();
if (_classentity.RedirectClassId > 0)
{
classintlist = ClassesFoundBLL.Instance.GetSubClassEndList(_classentity.RedirectClassId);
}
else
{
classintlist = ClassesFoundBLL.Instance.GetSubClassEndList(classid);
}
if (classintlist != null && classintlist.Count > 0)
{
classidstr = string.Join("_", classintlist);
}
else
{
classidstr = StringUtils.GetDbString(classid);
}
}
string _cachekey = "GetBrandByKey_" + classid.ToString() + "_" + pid.ToString() + "_" + key;
object _objcache = MemCache.GetCache(_cachekey);//依据键获取值
IList <BrandEntity> _obj = new List <BrandEntity>();
if (_objcache == null)
{
_obj = BrandDA.Instance.GetBrandByKey(classidstr, pid, key);
MemCache.AddCache(_cachekey, _obj);
}
else
{
_obj = (IList <BrandEntity>)_objcache;
}
return(_obj);
}
/// <summary>
/// 分类编辑
/// </summary>
/// <returns></returns>
public ActionResult ClassEdit()
{
string _op = QueryString.SafeQ("op");
int _id = QueryString.IntSafeQ("id");
int _parentid = QueryString.IntSafeQ("parentid");
int _siteid = QueryString.IntSafeQ("siteid");
ClassesFoundEntity entity = new ClassesFoundEntity();
if (_op == "add")
{
entity.ParentId = _parentid;
entity.SiteId = _siteid;
}
else
{
entity = ClassesFoundBLL.Instance.GetClassesFound(_id, false);
}
ViewBag.op = _op;
ViewBag.entity = entity;
return(View());
}
/// <summary>
/// 根据主键值读取记录。如果数据库不存在这条数据将返回null
/// </summary>
/// <param name="db">数据库操作对象</param>
/// <param name="columns">需要返回的列，不提供任何列名时默认将返回所有列</param>
public ClassesFoundEntity GetClassesFound(int id)
{
string sql = @"SELECT [Id],[Code],[FullName],[Name],[PYFirst],[PYShort],[PYFull],[AdId],[Sort],[IsActive],[IsHot],[CreateTime],[UpdateTime],[ClassLevel],[IsEnd],[HasProperties],[HasProduct],PropertiesClassId, [ParentId],
RedirectClassId,ClassType,SiteId FROM dbo.[ClassesFound] WITH(NOLOCK) WHERE [Id]=@Id";
DbCommand cmd = db.GetSqlStringCommand(sql);
db.AddInParameter(cmd, "@Id", DbType.Int32, id);
ClassesFoundEntity entity = new ClassesFoundEntity();
using (IDataReader reader = db.ExecuteReader(cmd))
{
if (reader.Read())
{
entity.Id = StringUtils.GetDbInt(reader["Id"]);
entity.Code = StringUtils.GetDbString(reader["Code"]);
entity.FullName = StringUtils.GetDbString(reader["FullName"]);
entity.Name = StringUtils.GetDbString(reader["Name"]);
entity.PYFirst = StringUtils.GetDbString(reader["PYFirst"]);
entity.PYShort = StringUtils.GetDbString(reader["PYShort"]);
entity.PYFull = StringUtils.GetDbString(reader["PYFull"]);
entity.AdId = StringUtils.GetDbInt(reader["AdId"]);
entity.Sort = StringUtils.GetDbInt(reader["Sort"]);
entity.IsActive = StringUtils.GetDbInt(reader["IsActive"]);
entity.IsHot = StringUtils.GetDbInt(reader["IsHot"]);
entity.CreateTime = StringUtils.GetDbDateTime(reader["CreateTime"]);
entity.UpdateTime = StringUtils.GetDbDateTime(reader["UpdateTime"]);
entity.ClassLevel = StringUtils.GetDbInt(reader["ClassLevel"]);
entity.IsEnd = StringUtils.GetDbInt(reader["IsEnd"]);
entity.HasProperties = StringUtils.GetDbInt(reader["HasProperties"]);
entity.HasProduct = StringUtils.GetDbInt(reader["HasProduct"]);
entity.PropertiesClassId = StringUtils.GetDbInt(reader["PropertiesClassId"]);
entity.ClassType = StringUtils.GetDbInt(reader["ClassType"]);
entity.ParentId = StringUtils.GetDbInt(reader["ParentId"]);
entity.RedirectClassId = StringUtils.GetDbInt(reader["RedirectClassId"]);
entity.SiteId = StringUtils.GetDbInt(reader["SiteId"]);
}
}
return(entity);
}
/// <summary>
/// 产品编辑
/// </summary>
/// <returns></returns>
public ActionResult ProductEdit()
{
//判断是否是修改
int productid = QueryString.IntSafeQ("productid");
int siteid = QueryString.IntSafeQ("siteid");
if (siteid == 0 && productid == 0)
{
return(Redirect(SuperMarketWebUrl.GetSysSelectSiteIdUrl()));
}
int classid = 0;
int brandid = 0;
VWProductEntity _vwproductentity = new VWProductEntity();
if (productid > 0)
{
_vwproductentity = ProductBLL.Instance.GetProductVW(productid);
_vwproductentity.ProductPics = ProductStylePicsBLL.Instance.GetListPicsByProductId(productid); //获取样式图片列表
_vwproductentity.ProductPropertys = ProductPropertyBLL.Instance.GetListByProductId(productid); //获取样式属性列表
ProductBLL.Instance.Assignment(ref _vwproductentity, productid);
classid = _vwproductentity.ClassId;
brandid = _vwproductentity.BrandId;
siteid = _vwproductentity.SiteId;
ClassesFoundEntity _classentity = ClassesFoundBLL.Instance.GetClassesFound(classid, false);
BrandEntity _brandntity = BrandBLL.Instance.GetBrand(brandid, false);
}
else
{
classid = QueryString.IntSafeQ("classid");
brandid = QueryString.IntSafeQ("brandid");
}
ViewBag.SiteId = siteid;
ViewBag.Product = _vwproductentity;
ViewBag.MemId = memid;
return(View());
}
/// <summary>
/// 分类编辑
/// </summary>
/// <returns></returns>
public ActionResult ClassEdit()
{
int _pid = QueryString.IntSafeQ("pid");
int _id = QueryString.IntSafeQ("id");
ClassesFoundEntity entity = new ClassesFoundEntity();
ClassesFoundEntity pentity = new ClassesFoundEntity();
if (_id > 0)
{
entity = ClassesFoundBLL.Instance.GetClassesFound(_id, false);
}
if (entity.ParentId > 0)
{
pentity = ClassesFoundBLL.Instance.GetClassesFound(entity.ParentId, false);
}
else if (_pid > 0)
{
pentity = ClassesFoundBLL.Instance.GetClassesFound(_pid, false);
}
ViewBag.Entity = entity;
ViewBag.ParentEntity = entity;
return(View());
}
/// <summary>
/// 分类信息删除
/// </summary>
/// <returns></returns>
public int ClassDelete()
{
int _id = FormString.IntSafeQ("id");
ClassesFoundEntity entity = ClassesFoundBLL.Instance.GetClassesFound(_id, false);
int _result = 0;
if (entity.ClassLevel == 3) //叶子节点直接删除
{
_result = ClassesFoundBLL.Instance.DeleteClassesFoundByKey(_id); //删除三级节点
}
else if (entity.ClassLevel == 2) //非叶子节点级联删除
{
_result = ClassesFoundBLL.Instance.DeleteClassesFoundByKey(_id); //删除二级节点
if (_result > 0)
{
_result = ClassesFoundBLL.Instance.DeleteClassesFoundByParentId(_id);//删除三级节点
}
}
else if (entity.ClassLevel == 1) //非叶子节点级联删除
{
_result = ClassesFoundBLL.Instance.DeleteClassesFoundByKey(_id); //删除一级节点
if (_result > 0)
{
IList <ClassesFoundEntity> entitylist = ClassesFoundBLL.Instance.GetClassesAllByPId(_id, false, -1);
if (entitylist != null && entitylist.Count > 0)
{
foreach (ClassesFoundEntity item in entitylist)
{
_result = ClassesFoundBLL.Instance.DeleteClassesFoundByKey(item.Id); //删除二级节点
_result = ClassesFoundBLL.Instance.DeleteClassesFoundByParentId(item.Id); //删除三级节点
}
}
}
}
return(_result);
}
/// <summary>
/// 常规商品列表
/// </summary>
/// <returns></returns>
public ActionResult List()
{
string title = "易店心,";
string _key = QueryString.SafeQ("key");
int classid = QueryString.IntSafeQ("cid");
int brandid = QueryString.IntSafeQ("bd");
int order_i = QueryString.IntSafeQ("px");//排序类型
//if (classid == 0) { return Redirect("/"); }
int siteid = QueryString.IntSafeQ("s");
if (siteid <= 0)
{
siteid = (int)SiteIdEnum.BathRoom;
}
ViewBag.SiteId = siteid;
///获取已选择的分类属性
string propertiesstr = QueryString.SafeQ("pp");
//if (classid == 0) RedirectToAction("Home", "Index");
ClassesFoundEntity _classentity = ClassesFoundBLL.Instance.GetClassesFound(classid, false);
if (_classentity != null && _classentity.Id > 0)
{
title += "类别：" + _classentity.Name + ",";
}
ViewBag.ClassId = classid;
ViewBag.SelectClassName = _classentity.Name;
ViewBag.SiteId = _classentity.SiteId;
ViewBag.OrderBy = order_i;
ViewBag.ClassEntity = _classentity;
ViewBag.BrandId = brandid;
int rediclassid = classid;//实际指向分类
if (rediclassid == -1)
{
rediclassid = 0;
}
if (_classentity.RedirectClassId > 0)
{
rediclassid = _classentity.RedirectClassId;
}
siteid = _classentity.SiteId;
//if(siteid == 0&& rediclassid>0)
//{
// ClassesFoundEntity _classredirectentity = ClassesFoundBLL.Instance.GetClassesFound(rediclassid, false);
//}
if (brandid > 0 && classid == 0)
{
//获取子集分类
IList <ClassesFoundEntity> classes = ClassesFoundBLL.Instance.GetClassesAllByBrandId(siteid, brandid, false);
ViewBag.ClassList = classes;
}
else
{
//分类导航显示
if (_classentity.IsEnd == 0)
{
//获取子集分类
IList <ClassesFoundEntity> classes = ClassesFoundBLL.Instance.GetClassesAllByPId(rediclassid, false, siteid);
ViewBag.ClassList = classes;
}
}
if (classid > 0)
{
//ViewBag.RavClassList = ListRavStr(_classentity);
if (brandid == 0)
{
//获取分类对应品牌
IList <BrandEntity> brands = ClassBrandBLL.Instance.GetBrandByClass(rediclassid);
ViewBag.BrandList = brands;
}
////获取分类属性
//IList<ClassPropertiesEntity> _ClassPropertieslist = ClassPropertiesBLL.Instance.GetAllPropertyByClassId(classid);
//ViewBag.PropertiesList = _ClassPropertieslist;
}
if (brandid > 0)
{
BrandEntity brand = BrandBLL.Instance.GetBrand(brandid, false);
ViewBag.SelectBrandName = brand.Name;
ViewBag.BrandSelect = brand;
title += "品牌：" + brand.Name + ",";
}
//ViewBag.PropertiesStr = propertiesstr;
int pageindex = QueryString.IntSafeQ("pageindex");
int pagesize = CommonKey.PageSizeList;
int record = 0;
if (pageindex == 0)
{
pageindex = 1;
}
string classidstr = "";
if (classid > 0)
{
IList <int> classintlist = new List <int>();
if (_classentity.RedirectClassId > 0)
{
classintlist = ClassesFoundBLL.Instance.GetSubClassEndList(_classentity.RedirectClassId);
}
else
{
classintlist = ClassesFoundBLL.Instance.GetSubClassEndList(classid);
}
if (classintlist != null && classintlist.Count > 100)
{
classintlist = classintlist.Take(100).ToList <int>();
}
if (classintlist != null && classintlist.Count > 0)
{
classidstr = string.Join("_", classintlist);
}
else if (_classentity.RedirectClassId > 0)
{
classidstr = StringUtils.GetDbString(_classentity.RedirectClassId);
}
else
{
classidstr = StringUtils.GetDbString(classid);
}
}
else
{
IList <int> classintlist = new List <int>();
classintlist = ClassesFoundBLL.Instance.GetSubClassEndListBySite(siteid);
if (classintlist != null && classintlist.Count > 100)
{
classintlist = classintlist.Take(100).ToList <int>();
}
if (classintlist != null && classintlist.Count > 0)
{
classidstr = string.Join("_", classintlist);
}
else if (_classentity.RedirectClassId > 0)
{
classidstr = StringUtils.GetDbString(_classentity.RedirectClassId);
}
else
{
classidstr = StringUtils.GetDbString(classid);
}
}
IList <VWProductEntity> _productlist = new List <VWProductEntity>();// ProductBLL.Instance.GetProductListProc(pagesize, pageindex, ref record, classidstr, brandid, propertiesstr, order_i, _key );
_productlist = ProductBLL.Instance.GetProductListProc(pagesize, pageindex, ref record, classidstr, brandid, propertiesstr, order_i, _key);
MemberLoginEntity member = CookieBLL.GetLoginCookie();
if (member != null && member.MemId > 0)
{
ViewBag.MemId = member.MemId;
ViewBag.MemStatus = member.Status;
foreach (VWProductEntity _entity in _productlist)
{
_entity.ActualPrice = Calculate.GetPrice(member.Status, member.IsStore, member.StoreType, member.MemGrade, _entity.TradePrice, _entity.Price, _entity.IsBP, _entity.DealerPrice);
}
}
else
{
foreach (VWProductEntity _entity in _productlist)
{
_entity.ActualPrice = 0;
}
}
ViewBag.Title = title;
ViewBag.ProductList = _productlist;
ViewBag.TotalNum = record;
//ViewBag.ListShowMethod = (int)ListShowMethodEnum.Normal;
string url = "/Product/list.html?px=" + order_i + "&cid=" + classid + "&bd=" + brandid + "&pp=" + propertiesstr + "&s=" + siteid + "&ct=0&key=" + _key;
ViewBag.SiteId = siteid;
string pagehtml = HTMLPage.SetOrderListPage(record, pagesize, pageindex, url);
ViewBag.PageHtml = pagehtml;
int maxpage = record / pagesize;
if (record % pagesize > 0)
{
maxpage = maxpage + 1;
}
ViewBag.MaxPageIndex = maxpage;
return(View());
}
/// <summary>
/// 更新一条ClassesFound记录。
/// 该方法提供给界面等UI层调用
/// </summary>
/// <param name="classesFound">待更新的实体对象</param>
/// <param name="columns">要更新的列名，不提供任何列名时默认将更新主键之外的所有列</param>
public int UpdateClassesFound(ClassesFoundEntity classesFound)
{
return(ClassesFoundDA.Instance.UpdateClassesFound(classesFound));
}
/// <summary>
/// 获取品牌，并按照首字母建立层级结构
/// </summary>
/// <param name="classid"></param>
/// <returns></returns>
public IList <VWTreeBrandEntity> GetTreeBrandAll(int classid, bool iscache = false)
{
IList <VWTreeBrandEntity> resultlist = new List <VWTreeBrandEntity>();
string _cachekey = "GetTreeBrandAll" + classid;
if (iscache)
{
object obj = MemCache.GetCache(_cachekey);
if (obj == null)
{
int rediclassid = classid;
ClassesFoundEntity _classentity = ClassesFoundBLL.Instance.GetClassesFound(classid, false);
if (_classentity.RedirectClassId > 0)
{
rediclassid = _classentity.RedirectClassId;
}
IList <int> classintlist = new List <int>();
classintlist = ClassesFoundBLL.Instance.GetSubClassEndList(rediclassid);
string classidstr = "";
if (classintlist != null && classintlist.Count > 0)
{
classidstr = string.Join("_", classintlist);
}
else
{
classidstr = StringUtils.GetDbString(classid);
}
IList <VWTreeBrandEntity> list = null;
list = BrandDA.Instance.GetBrandAllByClassStr(classidstr);
if (list != null && list.Count > 0)
{
//string[] firstletter = new Array();
ArrayList firstletter = new ArrayList();
foreach (VWTreeBrandEntity entity in list)
{
if (!firstletter.Contains(entity.PYFirst))
{
firstletter.Add(entity.PYFirst);
}
firstletter.Sort();
}
foreach (string letter in firstletter)
{
VWTreeBrandEntity entity = new VWTreeBrandEntity();
entity.PYFirst = letter;
resultlist.Add(entity);
}
foreach (VWTreeBrandEntity entity in list)
{
foreach (VWTreeBrandEntity entity2 in resultlist)
{
if (entity.PYFirst == entity2.PYFirst)
{
if (entity2.Children == null)
{
entity2.Children = new List <VWTreeBrandEntity>();
}
entity2.Children.Add(entity);
break;
}
}
}
}
MemCache.AddCache(_cachekey, resultlist);
}
else
{
resultlist = (IList <VWTreeBrandEntity>)obj;
}
}
else
{
int rediclassid = classid;
ClassesFoundEntity _classentity = ClassesFoundBLL.Instance.GetClassesFound(classid, false);
if (_classentity.RedirectClassId > 0)
{
rediclassid = _classentity.RedirectClassId;
}
IList <int> classintlist = new List <int>();
classintlist = ClassesFoundBLL.Instance.GetSubClassEndList(rediclassid);
string classidstr = "";
if (classintlist != null && classintlist.Count > 0)
{
classidstr = string.Join("_", classintlist);
}
else
{
classidstr = StringUtils.GetDbString(classid);
}
IList <VWTreeBrandEntity> list = null;
list = BrandDA.Instance.GetBrandAllByClassStr(classidstr);
if (list != null && list.Count > 0)
{
//string[] firstletter = new Array();
ArrayList firstletter = new ArrayList();
foreach (VWTreeBrandEntity entity in list)
{
if (!firstletter.Contains(entity.PYFirst))
{
firstletter.Add(entity.PYFirst);
}
firstletter.Sort();
}
foreach (string letter in firstletter)
{
VWTreeBrandEntity entity = new VWTreeBrandEntity();
entity.PYFirst = letter;
resultlist.Add(entity);
}
foreach (VWTreeBrandEntity entity in list)
{
foreach (VWTreeBrandEntity entity2 in resultlist)
{
if (entity.PYFirst == entity2.PYFirst)
{
if (entity2.Children == null)
{
entity2.Children = new List <VWTreeBrandEntity>();
}
entity2.Children.Add(entity);
break;
}
}
}
}
}
return(resultlist);
}
public ActionResult Search()
{
int classid = QueryString.IntSafeQ("cl");
int brandid = QueryString.IntSafeQ("bd");
int siteid = QueryString.IntSafeQ("s");
int pageindex = QueryString.IntSafeQ("pi");
int jishi = QueryString.IntSafeQ("js", -1);
if (jishi == -1)
{
jishi = (int)JiShiSongEnum.Normal;
}
if (classid > 0)
{
ClassesFoundEntity _classentity = ClassesFoundBLL.Instance.GetClassesFound(classid, true);
ViewBag.SelectClassName = _classentity.Name;
ViewBag.SelectClassId = classid;
}
if (brandid > 0)
{
BrandEntity brand = BrandBLL.Instance.GetBrand(brandid, true);
ViewBag.SelectBrandName = brand.Name;
ViewBag.SelectBrandId = brandid;
}
if (pageindex < 1)
{
pageindex = 1;
}
int pagesize = CommonKey.PageSizeList;
string querykey = QueryString.SafeQ("key");
//SearchIndex search = new SearchIndex();
//GyLuceneEntity luceneentity = search.LuceneSearch(querykey, siteid, brandid, classid,jishi, pagesize, pageindex);
IList <VWProductEntity> _productlist = new List <VWProductEntity>();
//List<ProductLuceneEntity> list = luceneentity.ProductList;
IList <ClassesFoundEntity> listclass = new List <ClassesFoundEntity>();
//if (luceneentity.ClassList != null && luceneentity.ClassList.Count > 0)
//{
// foreach (int cid in luceneentity.ClassList)
// {
// ClassesFoundEntity entity = ClassesFoundBLL.Instance.GetClassesFound(cid, true);
// listclass.Add(entity);
// }
//}
IList <BrandEntity> listbrand = new List <BrandEntity>();
//if (luceneentity.BrandList != null && luceneentity.BrandList.Count > 0)
//{
// foreach (int cid in luceneentity.BrandList)
// {
// BrandEntity entity = BrandBLL.Instance.GetBrand(cid, true);
// listbrand.Add(entity);
// }
//}
if (brandid > 0)
{
BrandEntity brandentity = BrandBLL.Instance.GetBrand(brandid, true);
ViewBag.BrandSelect = brandentity;
}
if (classid > 0)
{
ClassesFoundEntity classentity = ClassesFoundBLL.Instance.GetClassesFound(classid, true);
ViewBag.ClassSelect = classentity;
}
int listmethod = (int)SuperMarket.Model.ListShowMethodEnum.Default;
//if (list != null && list.Count > 0)
//{
// bool haslogin = false;
// MemberLoginEntity member = CookieBLL.GetLoginCookie();
// if (member != null && member.MemId > 0)
// {
// ViewBag.MemId = member.MemId;
// ViewBag.MemStatus = member.Status;
// haslogin = true;
// }
// foreach (ProductLuceneEntity _productentity in list)
// {
// VWProductEntity productentity = ProductBLL.Instance.GetProVWByDetailId(_productentity.ProductDetailId);
// if (productentity.ListShowMethod == (int)SuperMarket.Model.ListShowMethodEnum.Normal)
// {
// listmethod = productentity.ListShowMethod;
// }
// if (haslogin)
// {
// productentity.ActualPrice = Calculate.GetPrice(member.Status,member.IsStore, member.StoreType, member.MemGrade, productentity.TradePrice, productentity.Price, productentity.IsBP, productentity.DealerPrice);
// }
// else
// {
// productentity.ActualPrice = 0;
// }
// _productlist.Add(productentity);
// }
// //else
// //{
// // foreach (ProductLuceneEntity product in list)
// // {
// // if (product.ListShowMethod == (int)SuperMarket.Model.ListShowMethodEnum.Normal)
// // {
// // listmethod = product.ListShowMethod;
// // break;
// // }
// // }
// //}
//}
//int record = luceneentity.Count;
//string url = "/Product/Search.html?s=" + siteid + "&cl=" + classid + "&bd=" + brandid + "&key=" + querykey;
//string pagehtml = HTMLPage.SetOrderListPage(record, pagesize, pageindex, url);
//ViewBag.MaxPageIndex = record;
//ViewBag.PageHtml = pagehtml;
ViewBag.ListShowMethod = listmethod;
ViewBag.BrandId = brandid;
ViewBag.ClassId = classid;
ViewBag.SiteId = siteid;
ViewBag.SearchKey = querykey;
ViewBag.ProductList = _productlist;
ViewBag.ClassList = listclass;
ViewBag.BrandList = listbrand;
ViewBag.JiShiSong = jishi;
return(View());
}
public IList <ClassesFoundEntity> GetClassesAllByPId(int pid, int level, int siteid)
{
string where = " where 1=1 and IsActive=1";
if (pid > 0)
{
where += " and ParentId=@ParentId";
}
else
{
if (pid == 0)
{
where += " and ParentId=0";
}
if (siteid != -1)
{
where += " and SiteId=@SiteId";
}
}
string sql = @"SELECT [Id],[Code],[Name],[PYFirst],[PYShort],[PYFull],[AdId],[Sort],[IsActive],[IsHot],[CreateTime],[UpdateTime],[ClassLevel],[IsEnd],[HasProperties],[ParentId],PropertiesClassId,HasProduct,ClassType ,RedirectClassId from dbo.[ClassesFound] WITH(NOLOCK) "+ where + " Order By Sort desc";
IList <ClassesFoundEntity> entityList = new List <ClassesFoundEntity>();
DbCommand cmd = db.GetSqlStringCommand(sql);
if (pid > 0)
{
db.AddInParameter(cmd, "@ParentId", DbType.Int32, pid);
}
else
{
if (pid <= 0 && siteid != -1)
{
db.AddInParameter(cmd, "@SiteId", DbType.Int32, siteid);
}
}
using (IDataReader reader = db.ExecuteReader(cmd))
{
while (reader.Read())
{
ClassesFoundEntity entity = new ClassesFoundEntity();
entity.Id = StringUtils.GetDbInt(reader["Id"]);
entity.Code = StringUtils.GetDbString(reader["Code"]);
entity.Name = StringUtils.GetDbString(reader["Name"]);
entity.PYFirst = StringUtils.GetDbString(reader["PYFirst"]);
entity.PYShort = StringUtils.GetDbString(reader["PYShort"]);
entity.PYFull = StringUtils.GetDbString(reader["PYFull"]);
entity.AdId = StringUtils.GetDbInt(reader["AdId"]);
entity.Sort = StringUtils.GetDbInt(reader["Sort"]);
entity.IsActive = StringUtils.GetDbInt(reader["IsActive"]);
entity.IsHot = StringUtils.GetDbInt(reader["IsHot"]);
entity.CreateTime = StringUtils.GetDbDateTime(reader["CreateTime"]);
entity.UpdateTime = StringUtils.GetDbDateTime(reader["UpdateTime"]);
entity.ClassLevel = StringUtils.GetDbInt(reader["ClassLevel"]);
entity.IsEnd = StringUtils.GetDbInt(reader["IsEnd"]);
entity.HasProperties = StringUtils.GetDbInt(reader["HasProperties"]);
entity.PropertiesClassId = StringUtils.GetDbInt(reader["PropertiesClassId"]);
entity.HasProduct = StringUtils.GetDbInt(reader["HasProduct"]);
entity.ParentId = StringUtils.GetDbInt(reader["ParentId"]);
entity.ClassType = StringUtils.GetDbInt(reader["ClassType"]);
entity.RedirectClassId = StringUtils.GetDbInt(reader["RedirectClassId"]);
entityList.Add(entity);
}
}
return(entityList);
}
/// <summary>
/// 读取记录列表。
/// </summary>
/// <param name="db">数据库操作对象</param>
/// <param name="columns">需要返回的列，不提供任何列名时默认将返回所有列</param>
public IList <ClassesFoundEntity> GetClassesFoundList(int pagesize, int pageindex, ref int recordCount, int level, string name, int parentid, int isactive, int classtype, int classmenutype, int siteid)
{
string where = "WHERE 1=1";
if (siteid > 0)
{
where += " and SiteId=@SiteId ";
}
if (level > 0)
{
where += " And ClassLevel=@ClassLevel";
}
if (isactive > -1)
{
where += " And IsActive=@IsActive";
}
if (parentid > -1)
{
where += " And ParentId=@ParentId";
}
if (name != string.Empty)
{
where += " And Name like @Name";
}
if (classtype != -1)
{
where += " And ClassType = @ClassType";
}
if (classmenutype != -1)
{
where += " And ClassMenuType = @ClassMenuType";
}
string sql = @"SELECT [Id],[Code],[Name],[PYFirst],[PYShort],[PYFull],[AdId],[Sort],[IsActive],[IsHot],[CreateTime],[UpdateTime],[ClassLevel],[IsEnd],[HasProperties] ,[ParentId],ClassType
FROM
(SELECT ROW_NUMBER() OVER (ORDER BY Id desc) AS ROWNUMBER,
[Id],[Code],[Name],[PYFirst],[PYShort],[PYFull],[AdId],[Sort],[IsActive],[IsHot],[CreateTime],[UpdateTime],[ClassLevel],[IsEnd],[HasProperties],[ParentId],ClassType from dbo.[ClassesFound] WITH(NOLOCK)
" + where + @" ) as temp
where rownumber BETWEEN ((@PageIndex - 1) * @PageSize + 1) AND @PageIndex * @PageSize" ;
string sql2 = @"Select count(1) from dbo.[ClassesFound] with (nolock) " + where;
IList <ClassesFoundEntity> entityList = new List <ClassesFoundEntity>();
DbCommand cmd = db.GetSqlStringCommand(sql);
db.AddInParameter(cmd, "@PageIndex", DbType.Int32, pageindex);
db.AddInParameter(cmd, "@PageSize", DbType.Int32, pagesize);
if (siteid > 0)
{
db.AddInParameter(cmd, "@SiteId", DbType.Int32, siteid);
}
if (level > 0)
{
db.AddInParameter(cmd, "@ClassLevel", DbType.Int32, level);
}
if (isactive > -1)
{
db.AddInParameter(cmd, "@IsActive", DbType.Int32, isactive);
}
if (parentid > -1)
{
db.AddInParameter(cmd, "@ParentId", DbType.Int32, parentid);
}
if (name != string.Empty)
{
db.AddInParameter(cmd, "@Name", DbType.String, "%" + name + "%");
}
if (classtype != -1)
{
db.AddInParameter(cmd, "@ClassType", DbType.Int32, classtype);
}
if (classmenutype != -1)
{
db.AddInParameter(cmd, "@ClassMenuType", DbType.Int32, classmenutype);
}
using (IDataReader reader = db.ExecuteReader(cmd))
{
while (reader.Read())
{
ClassesFoundEntity entity = new ClassesFoundEntity();
entity.Id = StringUtils.GetDbInt(reader["Id"]);
entity.Code = StringUtils.GetDbString(reader["Code"]);
entity.Name = StringUtils.GetDbString(reader["Name"]);
entity.PYFirst = StringUtils.GetDbString(reader["PYFirst"]);
entity.PYShort = StringUtils.GetDbString(reader["PYShort"]);
entity.PYFull = StringUtils.GetDbString(reader["PYFull"]);
entity.AdId = StringUtils.GetDbInt(reader["AdId"]);
entity.Sort = StringUtils.GetDbInt(reader["Sort"]);
entity.IsActive = StringUtils.GetDbInt(reader["IsActive"]);
entity.IsHot = StringUtils.GetDbInt(reader["IsHot"]);
entity.CreateTime = StringUtils.GetDbDateTime(reader["CreateTime"]);
entity.UpdateTime = StringUtils.GetDbDateTime(reader["UpdateTime"]);
entity.ClassLevel = StringUtils.GetDbInt(reader["ClassLevel"]);
entity.IsEnd = StringUtils.GetDbInt(reader["IsEnd"]);
entity.HasProperties = StringUtils.GetDbInt(reader["HasProperties"]);
entity.ParentId = StringUtils.GetDbInt(reader["ParentId"]);
entity.ClassType = StringUtils.GetDbInt(reader["ClassType"]);
entityList.Add(entity);
}
}
cmd = db.GetSqlStringCommand(sql2);
if (siteid > 0)
{
db.AddInParameter(cmd, "@SiteId", DbType.Int32, siteid);
}
if (level > 0)
{
db.AddInParameter(cmd, "@ClassLevel", DbType.Int32, level);
}
if (isactive > -1)
{
db.AddInParameter(cmd, "@IsActive", DbType.Int32, isactive);
}
if (parentid > -1)
{
db.AddInParameter(cmd, "@ParentId", DbType.Int32, parentid);
}
if (name != string.Empty)
{
db.AddInParameter(cmd, "@Name", DbType.String, "%" + name + "%");
}
if (classtype != -1)
{
db.AddInParameter(cmd, "@ClassType", DbType.Int32, classtype);
}
if (classmenutype != -1)
{
db.AddInParameter(cmd, "@ClassMenuType", DbType.Int32, classmenutype);
}
using (IDataReader reader = db.ExecuteReader(cmd))
{
if (reader.Read())
{
recordCount = StringUtils.GetDbInt(reader[0]);
}
else
{
recordCount = 0;
}
}
return(entityList);
}
public ClassesFoundEntity GetClassesFoundByName(string name, int classtype, int ClassMenuType, int isend)
{
string sql = @"
IF ( SELECT COUNT(1)
FROM dbo.[ClassesFound] WITH ( NOLOCK )
WHERE [Name] = @Name
AND IsActive = 1
AND RedirectClassId = 0
AND IsEnd = @IsEnd
AND ClassType = @ClassType
AND ClassMenuType = @ClassMenuType
) = 1
BEGIN
SELECT [Id] ,
[Code] ,
[FullName] ,
[Name] ,
[PYFirst] ,
[PYShort] ,
[PYFull] ,
[AdId] ,
[Sort] ,
[IsActive] ,
[IsHot] ,
[CreateTime] ,
[UpdateTime] ,
[ClassLevel] ,
[IsEnd] ,
[HasProperties] ,
[HasProduct] ,
PropertiesClassId ,
[ParentId] ,
ClassType ,
RedirectClassId
FROM dbo.[ClassesFound] WITH ( NOLOCK )
WHERE [Name] = @Name
AND IsActive = 1
AND RedirectClassId = 0
AND IsEnd = @IsEnd
AND ClassType = @ClassType
AND ClassMenuType = @ClassMenuType
END
ELSE
BEGIN
SELECT [Id] ,
[Code] ,
[FullName] ,
[Name] ,
[PYFirst] ,
[PYShort] ,
[PYFull] ,
[AdId] ,
[Sort] ,
[IsActive] ,
[IsHot] ,
[CreateTime] ,
[UpdateTime] ,
[ClassLevel] ,
[IsEnd] ,
[HasProperties] ,
[HasProduct] ,
PropertiesClassId ,
[ParentId] ,
ClassType ,
RedirectClassId
FROM dbo.[ClassesFound] WITH ( NOLOCK )
WHERE [FullName] = @Name
AND IsActive = 1
AND RedirectClassId = 0
AND IsEnd = @IsEnd
AND ClassType = @ClassType
AND ClassMenuType = @ClassMenuType
END
";
DbCommand cmd = db.GetSqlStringCommand(sql);
db.AddInParameter(cmd, "@Name", DbType.String, name);
db.AddInParameter(cmd, "@ClassType", DbType.String, classtype);
db.AddInParameter(cmd, "@IsEnd", DbType.Int16, isend);
db.AddInParameter(cmd, "@ClassMenuType", DbType.String, ClassMenuType);
ClassesFoundEntity entity = new ClassesFoundEntity();
using (IDataReader reader = db.ExecuteReader(cmd))
{
if (reader.Read())
{
entity.Id = StringUtils.GetDbInt(reader["Id"]);
entity.Code = StringUtils.GetDbString(reader["Code"]);
entity.FullName = StringUtils.GetDbString(reader["FullName"]);
entity.Name = StringUtils.GetDbString(reader["Name"]);
entity.PYFirst = StringUtils.GetDbString(reader["PYFirst"]);
entity.PYShort = StringUtils.GetDbString(reader["PYShort"]);
entity.PYFull = StringUtils.GetDbString(reader["PYFull"]);
entity.AdId = StringUtils.GetDbInt(reader["AdId"]);
entity.Sort = StringUtils.GetDbInt(reader["Sort"]);
entity.IsActive = StringUtils.GetDbInt(reader["IsActive"]);
entity.IsHot = StringUtils.GetDbInt(reader["IsHot"]);
entity.CreateTime = StringUtils.GetDbDateTime(reader["CreateTime"]);
entity.UpdateTime = StringUtils.GetDbDateTime(reader["UpdateTime"]);
entity.ClassLevel = StringUtils.GetDbInt(reader["ClassLevel"]);
entity.IsEnd = StringUtils.GetDbInt(reader["IsEnd"]);
entity.HasProperties = StringUtils.GetDbInt(reader["HasProperties"]);
entity.HasProduct = StringUtils.GetDbInt(reader["HasProduct"]);
entity.PropertiesClassId = StringUtils.GetDbInt(reader["PropertiesClassId"]);
entity.ParentId = StringUtils.GetDbInt(reader["ParentId"]);
entity.ClassType = StringUtils.GetDbInt(reader["ClassType"]);
entity.RedirectClassId = StringUtils.GetDbInt(reader["RedirectClassId"]);
}
}
return(entity);
}
public string GetJsonList()
{
ListObj result = new ListObj();
int classid = QueryString.IntSafeQ("cl");
int brandid = QueryString.IntSafeQ("bd");
int cartype = QueryString.IntSafeQ("ct");
int producttype = QueryString.IntSafeQ("pt");
int jishi = QueryString.IntSafeQ("js");
if (jishi == 0)
{
jishi = (int)JiShiSongEnum.Normal;
}
if (producttype == 0)
{
producttype = (int)ProductType.Normal;
}
int siteid = QueryString.IntSafeQ("s");
if (siteid <= 0)
{
siteid = (int)SiteEnum.Default;
}
int pageindex = QueryString.IntSafeQ("pageindex");
int pagesize = CommonKey.PageSizeList;
int record = 0;
int order_i = 0;//默认排序
int _classtype = -1;
_classtype = QueryString.IntSafeQ("clt");
ViewBag.ClassType = _classtype;
if (pageindex == 0)
{
pageindex = 1;
}
ViewBag.SelectClassId = classid;
ViewBag.SelectBrandId = brandid;
ViewBag.CarType = cartype;
int _classmenutype = (int)ClassMenuTypeEnum.Normal; //分类列表选择类型
int rediclassid = classid;
string classidstr = ""; //分类子集
//获取选择的车型
if (cartype > 0)
{
CarTypeModelEntity cartypemodel = CarTypeModelBLL.Instance.GetCarTypeModel(cartype);
ViewBag.SelectCarTypeName = cartypemodel.ModelName;
}
if (classid > 0)
{
ClassesFoundEntity _classentity = ClassesFoundBLL.Instance.GetClassesFound(classid, true);
if (_classentity.RedirectClassId > 0)
{
rediclassid = _classentity.RedirectClassId;
}
ViewBag.SelectClassName = _classentity.Name;
IList <int> classintlist = new List <int>();
if (_classentity.RedirectClassId > 0)
{
classintlist = ClassesFoundBLL.Instance.GetSubClassEndList(_classentity.RedirectClassId);
}
else
{
classintlist = ClassesFoundBLL.Instance.GetSubClassEndList(classid);
}
if (classintlist != null && classintlist.Count > 0)
{
classidstr = string.Join("_", classintlist);
}
else if (_classentity.RedirectClassId > 0)
{
classidstr = StringUtils.GetDbString(_classentity.RedirectClassId);
}
else
{
classidstr = StringUtils.GetDbString(classid);
}
}
else
{
IList <int> classintlist = new List <int>();
classintlist = ClassesFoundBLL.Instance.GetSubClassEndListBySite(siteid);
if (classintlist != null && classintlist.Count > 0)
{
classidstr = string.Join("_", classintlist);
}
}
IList <VWProductEntity> _productlist = new List <VWProductEntity>();// ProductBLL.Instance.GetProductListProcCYC(pagesize, pageindex, ref record, classidstr, brandid, "", order_i, producttype, cartype ,jishi);
MemberLoginEntity member = CookieBLL.GetLoginCookie();
if (member != null && member.MemId > 0)
{
ViewBag.MemId = member.MemId;
ViewBag.MemStatus = member.Status;
foreach (VWProductEntity _entity in _productlist)
{
_entity.ActualPrice = Calculate.GetPrice(member.Status, member.IsStore, member.StoreType, member.MemGrade, _entity.TradePrice, _entity.Price, _entity.IsBP, _entity.DealerPrice);
}
}
else
{
foreach (VWProductEntity _entity in _productlist)
{
_entity.ActualPrice = 0;
}
}
result.Total = record;
result.List = _productlist;
string liststr = JsonJC.ObjectToJson(result);
return(liststr);
}
/// <summary>
/// 网站首页
/// </summary>
/// <returns></returns>
public ActionResult List()
{
int classid = QueryString.IntSafeQ("cl");
int brandid = QueryString.IntSafeQ("bd");
int cartypemodelid = QueryString.IntSafeQ("ct");//车型
int siteid = QueryString.IntSafeQ("s");
if (siteid == 0)
{
siteid = (int)SiteIdEnum.BathRoom;
}
int producttype = QueryString.IntSafeQ("pt");
if (producttype == 0)
{
producttype = (int)ProductType.Normal;
}
int pageindex = QueryString.IntSafeQ("pageindex");
int _classmenutype = (int)ClassMenuTypeEnum.Normal;//分类列表选择类型
int _pagesize = CommonKey.PageSizeList;
int _recordCount = 0;
int order_i = 0;//默认排序
int _classtype = -1;
_classtype = QueryString.IntSafeQ("clt");
ViewBag.ClassType = _classtype;
if (pageindex == 0)
{
pageindex = 1;
}
ViewBag.SelectClassId = classid;
ViewBag.SelectBrandId = brandid;
ViewBag.CarTypeModelId = cartypemodelid;
ViewBag.ProductType = producttype;
int rediclassid = classid;
string classidstr = "";//分类子集
//获取选择的品牌
if (brandid > 0)
{
BrandEntity brand = BrandBLL.Instance.GetBrand(brandid, true);
ViewBag.SelectBrandName = brand.Name;
}
//获取选择的车型
if (cartypemodelid > 0)
{
CarTypeModelEntity cartypemodel = CarTypeModelBLL.Instance.GetCarTypeModel(cartypemodelid);
ViewBag.SelectCarTypeName = cartypemodel.ModelName;
}
if (classid > 0)
{
ClassesFoundEntity _classentity = ClassesFoundBLL.Instance.GetClassesFound(classid, true);
siteid = _classentity.SiteId;
if (_classentity.RedirectClassId > 0)
{
rediclassid = _classentity.RedirectClassId;
}
ViewBag.SelectClassName = _classentity.Name;
//获取分类子集
IList <int> classintlist = new List <int>();
classintlist = ClassesFoundBLL.Instance.GetSubClassEndList(rediclassid);
if (classintlist != null && classintlist.Count > 0)
{
classidstr = string.Join("_", classintlist);
}
else
{
classidstr = StringUtils.GetDbString(rediclassid);
}
}
if (classid > 0)
{
ClassesFoundEntity _classentity = ClassesFoundBLL.Instance.GetClassesFound(classid, true);
if (_classentity.RedirectClassId > 0)
{
rediclassid = _classentity.RedirectClassId;
}
ViewBag.SelectClassName = _classentity.Name;
IList <int> classintlist = new List <int>();
if (_classentity.RedirectClassId > 0)
{
classintlist = ClassesFoundBLL.Instance.GetSubClassEndList(_classentity.RedirectClassId);
}
else
{
classintlist = ClassesFoundBLL.Instance.GetSubClassEndList(classid);
}
if (classintlist != null && classintlist.Count > 0)
{
classidstr = string.Join("_", classintlist);
}
else if (_classentity.RedirectClassId > 0)
{
classidstr = StringUtils.GetDbString(_classentity.RedirectClassId);
}
else
{
classidstr = StringUtils.GetDbString(classid);
}
}
else
{
IList <int> classintlist = new List <int>();
classintlist = ClassesFoundBLL.Instance.GetSubClassEndListBySite(siteid);
if (classintlist != null && classintlist.Count > 0)
{
classidstr = string.Join("_", classintlist);
}
}
IList <VWProductEntity> _productlist = new List <VWProductEntity>();// ProductBLL.Instance.GetProductListProcCYC(_pagesize, pageindex, ref _recordCount, classidstr, brandid, "", order_i, producttype, cartypemodelid,jishi);
MemberLoginEntity member = CookieBLL.GetLoginCookie();
if (member != null && member.MemId > 0)
{
ViewBag.MemId = member.MemId;
ViewBag.MemStatus = member.Status;
foreach (VWProductEntity _entity in _productlist)
{
_entity.ActualPrice = Calculate.GetPrice(member.Status, member.IsStore, member.StoreType, member.MemGrade, _entity.TradePrice, _entity.Price, _entity.IsBP, _entity.DealerPrice);
}
}
else
{
foreach (VWProductEntity _entity in _productlist)
{
_entity.ActualPrice = 0;
}
}
ViewBag.ProductList = _productlist;
ViewBag.SiteId = siteid;
int maxpage = _recordCount / _pagesize;
if (_recordCount % _pagesize > 0)
{
maxpage = maxpage + 1;
}
ViewBag.MaxPageIndex = maxpage;
ViewBag.ClassmMenuType = _classmenutype;
return(View());
}
/// <summary>
/// 分类信息添加
/// </summary>
/// <returns></returns>
public int ClassInfoAdd()
{
int _pid = FormString.IntSafeQ("pid");
int _adid = FormString.IntSafeQ("adid");
int _isend = FormString.IntSafeQ("isend");
int _isactive = FormString.IntSafeQ("isactive");
int _sort = FormString.IntSafeQ("sort");
int _hasproduct = FormString.IntSafeQ("hasproduct");
int _classtype = FormString.IntSafeQ("classtype");
int _hasproperty = FormString.IntSafeQ("hasproperty");
int _haspropertyclassid = FormString.IntSafeQ("haspropertyclassid");
int _siteid = FormString.IntSafeQ("siteid");
string _code = FormString.SafeQ("code");
string _name = FormString.SafeQ("name");
string _fullname = FormString.SafeQ("fullname");
string _pyshort = FormString.SafeQ("pyshort");
string _pyfull = FormString.SafeQ("pyfull");
ClassesFoundEntity entity = new ClassesFoundEntity();
entity.AdId = _adid;
entity.IsEnd = _isend;
entity.IsActive = _isactive;
entity.Sort = _sort;
entity.HasProduct = _hasproduct;
entity.ClassType = _classtype;
entity.HasProperties = _hasproperty;
entity.PropertiesClassId = _haspropertyclassid;
entity.Code = _code;
entity.Name = _name;
entity.FullName = _fullname;
entity.PYShort = _pyshort;
entity.PYFull = _pyfull;
entity.SiteId = _siteid;
entity.UpdateTime = entity.CreateTime = DateTime.Now;
if (_pid == 0)
{
entity.ClassLevel = 1;
entity.ParentId = 0;
entity.IsEnd = 0;
}
else if (_pid > 0)
{
ClassesFoundEntity temp = ClassesFoundBLL.Instance.GetClassesFound(_pid, false);
entity.ClassLevel = temp.ClassLevel + 1;
entity.ParentId = temp.Id;
//if (entity.ClassLevel == 4)
//{
// entity.IsEnd = 1;
//}
//else
//{
// entity.IsEnd = 0;
//}
}
int _result = ClassesFoundBLL.Instance.AddClassesFound(entity);
return(_result);
}
public ActionResult Detail()
{
string title = "易店心,";
int _productdetailid = QueryString.IntSafeQ("pd");
int _producttype = (int)ProductType.Normal;
if (_productdetailid == 0)
{
_productdetailid = StringUtils.GetDbInt(RouteData.Values["pd"]);
if (_productdetailid == 0)
{
return(Redirect("/"));
}
}
VWProductEntity _vwentity = new VWProductEntity();
_vwentity = ProductBLL.Instance.GetProVWByDetailId(_productdetailid);
int _productid = _vwentity.ProductId;
_producttype = _vwentity.ProductType;
//if(_vwentity.ProductType== (int)ProductType.SpecialPrice)
//{
// return RedirectToAction( "SProductDetail", new { pd = _productdetailid });
//}
title += _vwentity.AdTitle;
ViewBag.Title = title;
IList <ProductStylePicsEntity> productpiclist = null;
ClassesFoundEntity _classentity = ClassesFoundBLL.Instance.GetClassesFound(_vwentity.ClassId, false);
BrandEntity _brandrntity = BrandBLL.Instance.GetBrand(_vwentity.BrandId, false);
ViewBag.RavClassList = ListRavStr(_classentity);
ViewBag.Brand = _brandrntity;
productpiclist = ProductStylePicsBLL.Instance.GetListPicsByProductId(_productid);
_vwentity.ProductPics = productpiclist;
IList <ProductPropertyEntity> productpropertylist = ProductPropertyBLL.Instance.GetListByProductId(_productid);
_vwentity.ProductPropertys = productpropertylist;
if (!string.IsNullOrEmpty(_vwentity.Spec1))
{
ViewBag.Spec1Name = _vwentity.Spec1;
IList <VWProductEntity> plist = ProductBLL.Instance.GetListSpecsByStyleId(_vwentity.SiteId, _vwentity.ProductType, _vwentity.CGMemId);
//ViewBag.SpecList = plist;
var listfilter = (from c in plist
select new { c.Spec1, c.Spec2, c.PicUrlLittle, c.ProductId, c.ProductDetailId });
string liststr = JsonJC.ObjectToJson(listfilter);
ViewBag.SpecListJson = liststr;
IList <string> OBJSpec1 = (from c in plist
where !string.IsNullOrEmpty(c.Spec1)
select c.Spec1).Distinct().OrderBy(p => p).ToList();
ViewBag.Spec1List = OBJSpec1;
if (!string.IsNullOrEmpty(_vwentity.Spec2))
{
ViewBag.Spec2Name = _vwentity.Spec2;
IList <string> OBJSpec2 = (from c in plist
where !string.IsNullOrEmpty(c.Spec2)
select c.Spec2).Distinct().OrderBy(p => p).ToList <string>();
ViewBag.Spec2List = OBJSpec2;
}
}
MemberLoginEntity member = CookieBLL.GetLoginCookie();
if (member != null && member.MemId > 0)
{
ViewBag.MemId = member.MemId;
ViewBag.MemStatus = member.Status;
ViewBag.Member = member;
_vwentity.ActualPrice = Calculate.GetPrice(member.Status, member.IsStore, member.StoreType, member.MemGrade, _vwentity.TradePrice, _vwentity.Price, _vwentity.IsBP, _vwentity.DealerPrice);
}
ViewBag.VWProductEntity = _vwentity;
return(View());
}
public string GetJsonList()
{
ListObj result = new ListObj();
string _key = QueryString.SafeQ("key");
int classid = QueryString.IntSafeQ("cid");
int brandid = QueryString.IntSafeQ("bd");
int siteid = QueryString.IntSafeQ("s");
if (siteid <= 0)
{
siteid = (int)SiteIdEnum.BathRoom;
}
int pageindex = QueryString.IntSafeQ("pageindex");
int pagesize = CommonKey.PageSizeList;
int record = 0;
int order_i = 0;//默认排序
if (pageindex == 0)
{
pageindex = 1;
}
ViewBag.SelectClassId = classid;
ViewBag.SelectBrandId = brandid;
int rediclassid = classid;
string classidstr = "";//分类子集
if (classid > 0)
{
ClassesFoundEntity _classentity = ClassesFoundBLL.Instance.GetClassesFound(classid, false);
if (_classentity.RedirectClassId > 0)
{
rediclassid = _classentity.RedirectClassId;
}
IList <int> classintlist = new List <int>();
if (_classentity.RedirectClassId > 0)
{
classintlist = ClassesFoundBLL.Instance.GetSubClassEndList(_classentity.RedirectClassId);
}
else
{
classintlist = ClassesFoundBLL.Instance.GetSubClassEndList(classid);
}
if (classintlist != null && classintlist.Count > 0)
{
classidstr = string.Join("_", classintlist);
}
else if (_classentity.RedirectClassId > 0)
{
classidstr = StringUtils.GetDbString(_classentity.RedirectClassId);
}
else
{
classidstr = StringUtils.GetDbString(classid);
}
}
else
{
IList <int> classintlist = new List <int>();
classintlist = ClassesFoundBLL.Instance.GetSubClassEndListBySite(siteid);
if (classintlist != null && classintlist.Count > 0)
{
classidstr = string.Join("_", classintlist);
}
}
IList <VWProductEntity> _productlist = new List <VWProductEntity>();// ProductBLL.Instance.GetProductListProcCYC(pagesize, pageindex, ref record, classidstr, brandid, "", order_i, producttype, cartype ,jishi);
_productlist = ProductBLL.Instance.GetProductListProc(pagesize, pageindex, ref record, classidstr, brandid, "", order_i, _key);
MemberLoginEntity member = CookieBLL.GetLoginCookie();
if (member != null && member.MemId > 0)
{
ViewBag.MemId = member.MemId;
ViewBag.MemStatus = member.Status;
foreach (VWProductEntity _entity in _productlist)
{
_entity.ActualPrice = Calculate.GetPrice(member.Status, member.IsStore, member.StoreType, member.MemGrade, _entity.TradePrice, _entity.Price, _entity.IsBP, _entity.DealerPrice);
}
}
else
{
foreach (VWProductEntity _entity in _productlist)
{
_entity.ActualPrice = 0;
}
}
result.Total = record;
result.List = _productlist;
string liststr = JsonJC.ObjectToJson(result);
return(liststr);
}
