/// <summary> /// 判断当前节点是否已存在相同的 /// </summary> /// <param name="entity"></param> /// <returns></returns> public int ExistNum(CarTypeModelEntity entity) { ///id=0,判断总数,ID>0判断除自己之外的总数 string sql = @"Select count(1) from dbo.[CarTypeModel] WITH(NOLOCK) "; string where = "where "; if (entity.Id == 0) { where = where + " (ModelName=@ModelName) "; } else { where = where + " id<>@Id and (ModelName=@ModelName) "; } sql = sql + where; DbCommand cmd = db.GetSqlStringCommand(sql); if (entity.Id > 0) { db.AddInParameter(cmd, "@Id", DbType.Int32, entity.Id); } db.AddInParameter(cmd, "@ModelName", DbType.String, entity.ModelName); object identity = db.ExecuteScalar(cmd); if (identity == null || identity == DBNull.Value) { return(0); } return(Convert.ToInt32(identity)); }
/// <summary> /// 读取记录列表。 /// </summary> /// <param name="db">数据库操作对象</param> /// <param name="columns">需要返回的列,不提供任何列名时默认将返回所有列</param> public IList <CarTypeModelEntity> GetCarTypeModelAll(int seriesid) { string sql = @"SELECT [Id],[Code],[ParentCode],[BoxType],[Capacity],[CarYear],[ModelName],[SeriesId],[Status],[Engine] from dbo.[CarTypeModel] WITH(NOLOCK) where SeriesId=@SeriesId and Status=1 Order By ModelName "; IList <CarTypeModelEntity> entityList = new List <CarTypeModelEntity>(); DbCommand cmd = db.GetSqlStringCommand(sql); db.AddInParameter(cmd, "@SeriesId", DbType.Int32, seriesid); using (IDataReader reader = db.ExecuteReader(cmd)) { while (reader.Read()) { CarTypeModelEntity entity = new CarTypeModelEntity(); entity.Id = StringUtils.GetDbInt(reader["Id"]); entity.Code = StringUtils.GetDbString(reader["Code"]); entity.ParentCode = StringUtils.GetDbString(reader["ParentCode"]); entity.BoxType = StringUtils.GetDbString(reader["BoxType"]); entity.Capacity = StringUtils.GetDbString(reader["Capacity"]); entity.CarYear = StringUtils.GetDbInt(reader["CarYear"]); entity.ModelName = StringUtils.GetDbString(reader["ModelName"]); entity.SeriesId = StringUtils.GetDbInt(reader["SeriesId"]); entity.Status = StringUtils.GetDbInt(reader["Status"]); entity.Engine = StringUtils.GetDbString(reader["Engine"]); entityList.Add(entity); } } return(entityList); }
/// <summary> /// 根据主键值读取记录。如果数据库不存在这条数据将返回null /// </summary> /// <param name="db">数据库操作对象</param> /// <param name="columns">需要返回的列,不提供任何列名时默认将返回所有列</param> public CarTypeModelEntity GetCarTypeModel(int id) { string sql = @"SELECT [Id],[Code],[ParentCode],[BoxType],[Capacity],[CarYear],[ModelName],[SeriesId],[Status],[Engine] FROM dbo.[CarTypeModel] WITH(NOLOCK) WHERE [Id]=@id" ; DbCommand cmd = db.GetSqlStringCommand(sql); db.AddInParameter(cmd, "@Id", DbType.Int32, id); CarTypeModelEntity entity = new CarTypeModelEntity(); using (IDataReader reader = db.ExecuteReader(cmd)) { if (reader.Read()) { entity.Id = StringUtils.GetDbInt(reader["Id"]); entity.Code = StringUtils.GetDbString(reader["Code"]); entity.ParentCode = StringUtils.GetDbString(reader["ParentCode"]); entity.BoxType = StringUtils.GetDbString(reader["BoxType"]); entity.Capacity = StringUtils.GetDbString(reader["Capacity"]); entity.CarYear = StringUtils.GetDbInt(reader["CarYear"]); entity.ModelName = StringUtils.GetDbString(reader["ModelName"]); entity.SeriesId = StringUtils.GetDbInt(reader["SeriesId"]); entity.Status = StringUtils.GetDbInt(reader["Status"]); entity.Engine = StringUtils.GetDbString(reader["Engine"]); } } return(entity); }
/// <summary> /// 读取记录列表。 /// </summary> /// <param name="db">数据库操作对象</param> /// <param name="columns">需要返回的列,不提供任何列名时默认将返回所有列</param> public IList <CarTypeModelEntity> GetCarTypeModelList(int pagesize, int pageindex, ref int recordCount) { string sql = @"SELECT [Id],[Code],[ParentCode],[BoxType],[Capacity],[CarYear],[ModelName],[SeriesId],[Status],[Engine] FROM (SELECT ROW_NUMBER() OVER (ORDER BY Id desc) AS ROWNUMBER, [Id],[Code],[ParentCode],[BoxType],[Capacity],[CarYear],[ModelName],[SeriesId],[Status],[Engine] from dbo.[CarTypeModel] WITH(NOLOCK) WHERE 1=1 ) as temp where rownumber BETWEEN ((@PageIndex - 1) * @PageSize + 1) AND @PageIndex * @PageSize" ; string sql2 = @"Select count(1) from dbo.[CarTypeModel] with (nolock) "; IList <CarTypeModelEntity> entityList = new List <CarTypeModelEntity>(); DbCommand cmd = db.GetSqlStringCommand(sql); db.AddInParameter(cmd, "@PageIndex", DbType.Int32, pageindex); db.AddInParameter(cmd, "@PageSize", DbType.Int32, pagesize); using (IDataReader reader = db.ExecuteReader(cmd)) { while (reader.Read()) { CarTypeModelEntity entity = new CarTypeModelEntity(); entity.Id = StringUtils.GetDbInt(reader["Id"]); entity.Code = StringUtils.GetDbString(reader["Code"]); entity.ParentCode = StringUtils.GetDbString(reader["ParentCode"]); entity.BoxType = StringUtils.GetDbString(reader["BoxType"]); entity.Capacity = StringUtils.GetDbString(reader["Capacity"]); entity.CarYear = StringUtils.GetDbInt(reader["CarYear"]); entity.ModelName = StringUtils.GetDbString(reader["ModelName"]); entity.SeriesId = StringUtils.GetDbInt(reader["SeriesId"]); entity.Status = StringUtils.GetDbInt(reader["Status"]); entity.Engine = StringUtils.GetDbString(reader["Engine"]); entityList.Add(entity); } } cmd = db.GetSqlStringCommand(sql2); using (IDataReader reader = db.ExecuteReader(cmd)) { if (reader.Read()) { recordCount = StringUtils.GetDbInt(reader[0]); } else { recordCount = 0; } } return(entityList); }
/// <summary> /// 根据主键值更新记录的全部字段(注意:该方法不会对自增字段、timestamp类型字段以及主键字段更新!如果要更新主键字段,请使用Update方法)。 /// 如果数据库有数据被更新了则返回True,否则返回False /// </summary> /// <param name="db">数据库操作对象</param> /// <param name="carTypeModel">待更新的实体对象</param> public int UpdateCarTypeModel(CarTypeModelEntity entity) { string sql = @" UPDATE dbo.[CarTypeModel] SET [Code]=@Code,[ParentCode]=@ParentCode,[BoxType]=@BoxType,[Capacity]=@Capacity,[CarYear]=@CarYear,[ModelName]=@ModelName,[SeriesId]=@SeriesId,[Status]=@Status,[Engine]=@Engine 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, "@ParentCode", DbType.String, entity.ParentCode); db.AddInParameter(cmd, "@BoxType", DbType.String, entity.BoxType); db.AddInParameter(cmd, "@Capacity", DbType.String, entity.Capacity); db.AddInParameter(cmd, "@CarYear", DbType.Int32, entity.CarYear); db.AddInParameter(cmd, "@ModelName", DbType.String, entity.ModelName); db.AddInParameter(cmd, "@SeriesId", DbType.Int32, entity.SeriesId); db.AddInParameter(cmd, "@Status", DbType.Int32, entity.Status); db.AddInParameter(cmd, "@Engine", DbType.String, entity.Engine); return(db.ExecuteNonQuery(cmd)); }
/// <summary> /// 插入一条记录到表CarTypeModel,如果表中存在自增字段,则返回值为新记录的自增字段值,否则返回0。 /// 该方法提供给界面等UI层调用 /// </summary> /// <param name="carTypeModel">要添加的CarTypeModel数据实体对象</param> public int AddCarTypeModel(CarTypeModelEntity carTypeModel) { if (carTypeModel.Id > 0) { return(UpdateCarTypeModel(carTypeModel)); } else if (string.IsNullOrEmpty(carTypeModel.ModelName)) { return((int)CommonStatus.ADD_Fail_Empty); } else if (CarTypeModelBLL.Instance.IsExist(carTypeModel)) { return((int)CommonStatus.ADD_Fail_Exist); } else { return(CarTypeModelDA.Instance.AddCarTypeModel(carTypeModel)); } }
/// <summary> /// 插入一条记录到表CarTypeModel,如果表中存在自增字段,则返回值为新记录的自增字段值,否则返回0 /// </summary> /// <param name="db">数据库操作对象</param> /// <param name="carTypeModel">待插入的实体对象</param> public int AddCarTypeModel(CarTypeModelEntity entity) { string sql = @"insert into CarTypeModel( [Code],[ParentCode],[BoxType],[Capacity],[CarYear],[ModelName],[SeriesId],[Status],[Engine])VALUES ( @Code,@ParentCode,@BoxType,@Capacity,@CarYear,@ModelName,@SeriesId,@Status,@Engine); SELECT SCOPE_IDENTITY();" ; DbCommand cmd = db.GetSqlStringCommand(sql); db.AddInParameter(cmd, "@Code", DbType.String, entity.Code); db.AddInParameter(cmd, "@ParentCode", DbType.String, entity.ParentCode); db.AddInParameter(cmd, "@BoxType", DbType.String, entity.BoxType); db.AddInParameter(cmd, "@Capacity", DbType.String, entity.Capacity); db.AddInParameter(cmd, "@CarYear", DbType.Int32, entity.CarYear); db.AddInParameter(cmd, "@ModelName", DbType.String, entity.ModelName); db.AddInParameter(cmd, "@SeriesId", DbType.Int32, entity.SeriesId); db.AddInParameter(cmd, "@Status", DbType.Int32, entity.Status); db.AddInParameter(cmd, "@Engine", DbType.String, entity.Engine); object identity = db.ExecuteScalar(cmd); if (identity == null || identity == DBNull.Value) { return(0); } return(Convert.ToInt32(identity)); }
/// <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()); }
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> /// 更新一条CarTypeModel记录。 /// 该方法提供给界面等UI层调用 /// </summary> /// <param name="carTypeModel">待更新的实体对象</param> /// <param name="columns">要更新的列名,不提供任何列名时默认将更新主键之外的所有列</param> public int UpdateCarTypeModel(CarTypeModelEntity carTypeModel) { return(CarTypeModelDA.Instance.UpdateCarTypeModel(carTypeModel)); }
/// <summary> /// 判断对象是否存在 /// </summary> /// <param name="dicEnum"></param> /// <returns></returns> public bool IsExist(CarTypeModelEntity carTypeModel) { return(CarTypeModelDA.Instance.ExistNum(carTypeModel) > 0); }