/// <summary>
/// 添加保养项目加价配置
/// </summary>
/// <param name="conn"></param>
/// <param name="model"></param>
/// <returns></returns>
public static int AddBaoYangInstallFeeConfig(SqlConnection conn, BaoYangInstallFeeConfigModel model)
{
var sql = @"INSERT BaoYang..BaoYangInstallFeeConfig
( ServiceId ,
CarMinPrice ,
CarMaxPrice ,
AddInstallFee
)
VALUES ( @ServiceId ,
@CarMinPrice ,
@CarMaxPrice ,
@AddInstallFee
);
SELECT SCOPE_IDENTITY()";
var parameters = new[]
{
new SqlParameter("@ServiceId", model.ServiceId),
new SqlParameter("@CarMinPrice", model.CarMinPrice),
new SqlParameter("@CarMaxPrice", model.CarMaxPrice),
new SqlParameter("@AddInstallFee", model.AddInstallFee)
};
return(Convert.ToInt32(SqlHelper.ExecuteScalar(conn, CommandType.Text, sql, parameters)));
}
public static BaoYangInstallFeeConfigModel GetDeletedBaoYangInstallFeeConfig(SqlConnection conn, BaoYangInstallFeeConfigModel model)
{
#region SQL
var sql = @"SELECT PKID ,
s.ServiceId ,
s.CarMinPrice ,
s.CarMaxPrice ,
s.AddInstallFee ,
s.IsDeleted ,
s.CreateDateTime ,
s.LastUpdateDateTime
FROM BaoYang..BaoYangInstallFeeConfig AS s WITH ( NOLOCK )
WHERE s.ServiceId = @ServiceId
AND s.CarMinPrice = @CarMinPrice
AND s.CarMaxPrice = @CarMaxPrice
AND s.AddInstallFee = @AddInstallFee
AND s.IsDeleted = 1;";
#endregion
var parameters = new[]
{
new SqlParameter("@ServiceId", model.ServiceId),
new SqlParameter("@CarMinPrice", model.CarMinPrice),
new SqlParameter("@CarMaxPrice", model.CarMaxPrice),
new SqlParameter("@AddInstallFee", model.AddInstallFee)
};
return(SqlHelper.ExecuteDataTable(conn, CommandType.Text, sql, parameters).ConvertTo <BaoYangInstallFeeConfigModel>().ToList().FirstOrDefault());
}