/// <summary> /// 更新车品信息 /// </summary> /// <param name="model"></param> /// <returns></returns> public static bool UpdateCarProductsFloor(CarProductsFloor model) { using (var conn = new SqlConnection(StrConn)) { const string sql = @"UPDATE Configuration.dbo.CarProductsFloor SET DisplayName = @DisplayName, Name = @Name, Code = @Code, IsEnabled = @IsEnabled, Sort = @Sort, UpdateTime = GETDATE() WHERE PKID = @PKID;"; var sqlPrams = new[] { new SqlParameter("@DisplayName", model.DisplayName), new SqlParameter("@Name", model.Name), new SqlParameter("@Code", model.Code), new SqlParameter("@UpdateTime", DateTime.Now), new SqlParameter("@IsEnabled", model.IsEnabled), new SqlParameter("@Sort", model.Sort), new SqlParameter("@PKID", model.PKID) }; return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, sqlPrams) > 0); } }
/// <summary> /// 添加车品信息 /// </summary> /// <param name="model"></param> /// <returns></returns> public static int InsertCarProductsFloor(CarProductsFloor model) { using (var conn = new SqlConnection(StrConn)) { const string sql = @"INSERT INTO Configuration.dbo.CarProductsFloor ( DisplayName , Name , Code , Sort , IsEnabled , CreateTime , UpdateTime ) VALUES ( @DisplayName , @Name , @Code , @Sort , @IsEnabled , @CreateTime , @UpdateTime );Select @@identity;"; var sqlPrams = new[] { new SqlParameter("@DisplayName", model.DisplayName), new SqlParameter("@Name", model.Name), new SqlParameter("@Code", model.Code), new SqlParameter("@IsEnabled", model.IsEnabled), new SqlParameter("@Sort", model.Sort), new SqlParameter("@CreateTime", DateTime.Now), new SqlParameter("@UpdateTime", DateTime.Now) }; return(Convert.ToInt32(SqlHelper.ExecuteScalar(conn, CommandType.Text, sql, sqlPrams))); } }
/// <summary> /// 更新banner图片 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool UpdateCarProductsFloor(CarProductsFloor model) { try { return(DALCarProducts.UpdateCarProductsFloor(model)); } catch (Exception ex) { logger.Error("UpdateCarProductsFloor"); } return(false); }
/// <summary> /// 插入banner图片 /// </summary> /// <param name="model"></param> /// <returns></returns> public int InsertCarProductsFloor(CarProductsFloor model) { try { return(DALCarProducts.InsertCarProductsFloor(model)); } catch (Exception ex) { logger.Error("InsertCarProductsFloor", ex); } return(0); }
/// <summary> /// 是否存在相同楼层 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool IsExistEqualFloorName(CarProductsFloor model) { var result = true; try { result = DALCarProducts.IsExistEqualFloorName(model); } catch (Exception ex) { logger.Error("IsExistEqualFloorName", ex); } return(result); }
/// <summary> /// 是否存在相同排序 /// </summary> /// <param name="model"></param> /// <returns></returns> public static bool IsExistEqualFloorSort(CarProductsFloor model) { using (var conn = new SqlConnection(StrConn)) { var sql = @"SELECT COUNT(0) FROM Configuration..CarProductsFloor WHERE IsEnabled = 1 AND Sort = @Sort" ; sql += (model.PKID.HasValue && model.PKID.Value > 0) ? $" AND PKID != {model.PKID.Value}" : ""; var parameters = new SqlParameter[] { new SqlParameter("@Sort", model.Sort) }; var count = SqlHelper.ExecuteScalar(conn, CommandType.Text, sql, parameters); return(Convert.ToInt32(count) > 0); } }