/// <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);
}
}
