/// <summary>
/// 更新车品配置
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static bool UpdateCarProductsFloorConfig(CarProductsFloorConfig model)
{
using (var conn = new SqlConnection(StrConn))
{
const string sql = @"UPDATE Configuration..CarProductsFloorConfig
SET FKFloorID = @FKFloorID,
Name = @Name,
Code = @Code,
PidCount = @PidCount,
PIDS = @PIDS,
IsEnabled = @IsEnabled,
UpdateTime = GETDATE()
WHERE PKID = @PKID;";
var sqlPrams = new[]
{
new SqlParameter("@FKFloorID", model.FKFloorID),
new SqlParameter("@Name", model.Name),
new SqlParameter("@Code", model.Code),
new SqlParameter("@PidCount", model.PidCount),
new SqlParameter("@PIDS", model.PIDS),
new SqlParameter("@IsEnabled", model.IsEnabled),
new SqlParameter("@PKID", model.PKID)
};
return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, sqlPrams) > 0);
}
}
/// <summary>
/// 更新banner图片
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool UpdateCarProductsFloorConfig(CarProductsFloorConfig model)
{
try
{
return(DALCarProducts.UpdateCarProductsFloorConfig(model));
}
catch (Exception ex)
{
logger.Error("UpdateCarProductsFloorConfig", ex);
}
return(false);
}
/// <summary>
/// 添加车品配置
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static bool InsertCarProductsFloorConfig(CarProductsFloorConfig model)
{
using (var conn = new SqlConnection(StrConn))
{
const string sql = @"INSERT INTO Configuration..CarProductsFloorConfig
( FKFloorID ,
Name ,
Code ,
PidCount ,
PIDS ,
CreateTime ,
UpdateTime ,
IsEnabled
)
VALUES ( @FKFloorID ,
@Name ,
@Code ,
@PidCount ,
@PIDS ,
@CreateTime ,
@UpdateTime ,
@IsEnabled
)";
var sqlPrams = new[]
{
new SqlParameter("@FKFloorID", model.FKFloorID),
new SqlParameter("@Name", model.Name),
new SqlParameter("@Code", model.Code),
new SqlParameter("@PidCount", model.PidCount),
new SqlParameter("@PIDS", model.PIDS),
new SqlParameter("@CreateTime", DateTime.Now),
new SqlParameter("@UpdateTime", DateTime.Now),
new SqlParameter("@IsEnabled", model.IsEnabled)
};
return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, sqlPrams) > 0);
}
}