/// <summary> /// 判断当前节点是否已存在相同的 /// </summary> /// <param name="entity"></param> /// <returns></returns> public int ExistNum(ClassBrandEntity entity) { ///id=0,判断总数,ID>0判断除自己之外的总数 string sql = @"Select count(1) from dbo.[ClassBrand] WITH(NOLOCK) "; string where = "where "; if (entity.Id == 0) { where += " BrandId=@BrandId and [ClassId]=@ClassId "; } else { where += " Id<>@Id and BrandId=@BrandId and [ClassId]=@ClassId "; } sql = sql + where; DbCommand cmd = db.GetSqlStringCommand(sql); db.AddInParameter(cmd, "@BrandId", DbType.Int32, entity.BrandId); db.AddInParameter(cmd, "@ClassId", DbType.Int32, entity.ClassId); if (entity.Id > 0) { db.AddInParameter(cmd, "@Id", DbType.Int32, entity.Id); } object identity = db.ExecuteScalar(cmd); if (identity == null || identity == DBNull.Value) { return(0); } return(Convert.ToInt32(identity)); }
/// <summary> /// 更新一条ClassBrand记录。 /// 该方法提供给界面等UI层调用 /// </summary> /// <param name="classBrand">待更新的实体对象</param> /// <param name="columns">要更新的列名,不提供任何列名时默认将更新主键之外的所有列</param> public int UpdateClassBrand(ClassBrandEntity classBrand) { if (ClassBrandBLL.Instance.IsExist(classBrand)) { return((int)CommonStatus.ADD_Fail_Exist); } return(ClassBrandDA.Instance.UpdateClassBrand(classBrand)); }
/// <summary> /// 分类品牌信息 /// </summary> /// <returns></returns> public ActionResult ClassBrandInfo() { int _classid = QueryString.IntSafeQ("classid", 0); int _id = QueryString.IntSafeQ("id", 0); ClassBrandEntity entity = ClassBrandBLL.Instance.GetClassBrand(_id); string _BrandName = BrandBLL.Instance.GetBrand(entity.BrandId, false).Name; ViewBag.entity = entity; ViewBag.classid = _classid; ViewBag.BrandName = _BrandName; return(View()); }
/// <summary> /// 根据主键值更新记录的全部字段(注意:该方法不会对自增字段、timestamp类型字段以及主键字段更新!如果要更新主键字段,请使用Update方法)。 /// 如果数据库有数据被更新了则返回True,否则返回False /// </summary> /// <param name="db">数据库操作对象</param> /// <param name="classBrand">待更新的实体对象</param> public int UpdateClassBrand(ClassBrandEntity entity) { string sql = @" UPDATE dbo.[ClassBrand] SET [ClassId]=@ClassId,[BrandId]=@BrandId,[Sort]=@Sort WHERE [Id]=@id"; DbCommand cmd = db.GetSqlStringCommand(sql); db.AddInParameter(cmd, "@Id", DbType.Int32, entity.Id); db.AddInParameter(cmd, "@ClassId", DbType.Int32, entity.ClassId); db.AddInParameter(cmd, "@BrandId", DbType.Int32, entity.BrandId); db.AddInParameter(cmd, "@Sort", DbType.Int32, entity.Sort); return(db.ExecuteNonQuery(cmd)); }
/// <summary> /// 分类品牌信息添加 /// </summary> /// <returns></returns> public int ClassBrandInfoAdd() { int _classid = FormString.IntSafeQ("classid"); int _brandid = FormString.IntSafeQ("brandid"); int _sort = FormString.IntSafeQ("sort"); ClassBrandEntity entity = new ClassBrandEntity(); entity.ClassId = _classid; entity.BrandId = _brandid; entity.Sort = _sort; int _result = ClassBrandBLL.Instance.AddClassBrand(entity); return(_result); }
/// <summary> /// 插入一条记录到表ClassBrand,如果表中存在自增字段,则返回值为新记录的自增字段值,否则返回0。 /// 该方法提供给界面等UI层调用 /// </summary> /// <param name="classBrand">要添加的ClassBrand数据实体对象</param> public int AddClassBrand(ClassBrandEntity classBrand) { if (classBrand.Id > 0) { return(UpdateClassBrand(classBrand)); } else if (ClassBrandBLL.Instance.IsExist(classBrand)) { return((int)CommonStatus.ADD_Fail_Exist); } else { return(ClassBrandDA.Instance.AddClassBrand(classBrand)); } }
/// <summary> /// 分类品牌信息修改 /// </summary> /// <returns></returns> public int ClassBrandInfoUpdate() { int _id = FormString.IntSafeQ("id"); int _classid = FormString.IntSafeQ("classid"); int _brandid = FormString.IntSafeQ("brandid"); int _sort = FormString.IntSafeQ("sort"); ClassBrandEntity entity = ClassBrandBLL.Instance.GetClassBrand(_id); entity.ClassId = _classid; entity.BrandId = _brandid; entity.Sort = _sort; int _result = ClassBrandBLL.Instance.UpdateClassBrand(entity); return(_result); }
/// <summary> /// 插入一条记录到表ClassBrand,如果表中存在自增字段,则返回值为新记录的自增字段值,否则返回0 /// </summary> /// <param name="db">数据库操作对象</param> /// <param name="classBrand">待插入的实体对象</param> public int AddClassBrand(ClassBrandEntity entity) { string sql = @"insert into ClassBrand( [ClassId],[BrandId],[Sort],Status)VALUES ( @ClassId,@BrandId,@Sort,@Status); SELECT SCOPE_IDENTITY();" ; DbCommand cmd = db.GetSqlStringCommand(sql); db.AddInParameter(cmd, "@ClassId", DbType.Int32, entity.ClassId); db.AddInParameter(cmd, "@BrandId", DbType.Int32, entity.BrandId); db.AddInParameter(cmd, "@Sort", DbType.Int32, entity.Sort); db.AddInParameter(cmd, "@Status", DbType.Int32, entity.Status); 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 <ClassBrandEntity> GetClassBrandAll() { string sql = @"SELECT [Id],[ClassId],[BrandId],[Sort] from dbo.[ClassBrand] WITH(NOLOCK) "; IList <ClassBrandEntity> entityList = new List <ClassBrandEntity>(); DbCommand cmd = db.GetSqlStringCommand(sql); using (IDataReader reader = db.ExecuteReader(cmd)) { while (reader.Read()) { ClassBrandEntity entity = new ClassBrandEntity(); entity.Id = StringUtils.GetDbInt(reader["Id"]); entity.ClassId = StringUtils.GetDbInt(reader["ClassId"]); entity.BrandId = StringUtils.GetDbInt(reader["BrandId"]); entity.Sort = StringUtils.GetDbInt(reader["Sort"]); entityList.Add(entity); } } return(entityList); }
/// <summary> /// 根据主键值读取记录。如果数据库不存在这条数据将返回null /// </summary> /// <param name="db">数据库操作对象</param> /// <param name="columns">需要返回的列,不提供任何列名时默认将返回所有列</param> public ClassBrandEntity GetClassBrand(int id) { string sql = @"SELECT [Id],[ClassId],[BrandId],[Sort] FROM dbo.[ClassBrand] WITH(NOLOCK) WHERE [Id]=@id" ; DbCommand cmd = db.GetSqlStringCommand(sql); db.AddInParameter(cmd, "@Id", DbType.Int32, id); ClassBrandEntity entity = new ClassBrandEntity(); using (IDataReader reader = db.ExecuteReader(cmd)) { if (reader.Read()) { entity.Id = StringUtils.GetDbInt(reader["Id"]); entity.ClassId = StringUtils.GetDbInt(reader["ClassId"]); entity.BrandId = StringUtils.GetDbInt(reader["BrandId"]); entity.Sort = StringUtils.GetDbInt(reader["Sort"]); } } return(entity); }
/// <summary> /// 读取记录列表。 /// </summary> /// <param name="db">数据库操作对象</param> /// <param name="columns">需要返回的列,不提供任何列名时默认将返回所有列</param> public IList <ClassBrandEntity> GetClassBrandList(int pagesize, int pageindex, ref int recordCount, int classid) { string where = " WHERE 1=1 "; if (classid > 0) { where += " and ClassId=@ClassId "; } string sql = @"SELECT [Id],[ClassId],[BrandId],[Sort],[Name],[Manufacturer] FROM (SELECT ROW_NUMBER() OVER (ORDER BY a.Id desc) AS ROWNUMBER, a.[Id],a.[ClassId],a.[BrandId],a.[Sort] ,b.[Name],b.[Manufacturer] from dbo.[ClassBrand] a WITH(NOLOCK) inner join dbo.[Brand] b WITH(NOLOCK) on a.BrandId = b.Id " + where + @") as temp where rownumber BETWEEN ((@PageIndex - 1) * @PageSize + 1) AND @PageIndex * @PageSize" ; string sql2 = @"Select count(1) from dbo.[ClassBrand] a with (nolock) " + where; IList <ClassBrandEntity> entityList = new List <ClassBrandEntity>(); DbCommand cmd = db.GetSqlStringCommand(sql); db.AddInParameter(cmd, "@PageIndex", DbType.Int32, pageindex); db.AddInParameter(cmd, "@PageSize", DbType.Int32, pagesize); if (classid > 0) { db.AddInParameter(cmd, "@ClassId", DbType.Int32, classid); } using (IDataReader reader = db.ExecuteReader(cmd)) { while (reader.Read()) { ClassBrandEntity entity = new ClassBrandEntity(); entity.Id = StringUtils.GetDbInt(reader["Id"]); entity.ClassId = StringUtils.GetDbInt(reader["ClassId"]); entity.BrandId = StringUtils.GetDbInt(reader["BrandId"]); entity.Sort = StringUtils.GetDbInt(reader["Sort"]); if (classid > 0) { entity.BrandName = StringUtils.GetDbString(reader["Name"]); entity.Manufacturer = StringUtils.GetDbString(reader["Manufacturer"]); } entityList.Add(entity); } } cmd = db.GetSqlStringCommand(sql2); if (classid > 0) { db.AddInParameter(cmd, "@ClassId", DbType.Int32, classid); } using (IDataReader reader = db.ExecuteReader(cmd)) { if (reader.Read()) { recordCount = StringUtils.GetDbInt(reader[0]); } else { recordCount = 0; } } return(entityList); }
/// <summary> /// 判断对象是否存在 /// </summary> /// <param name="dicEnum"></param> /// <returns></returns> public bool IsExist(ClassBrandEntity classBrand) { return(ClassBrandDA.Instance.ExistNum(classBrand) > 0); }