/// <summary>
/// 喷漆打折城市配置是否重复
/// </summary>
/// <param name="conn"></param>
/// <param name="model"></param>
/// <param name="userTypes"></param>
/// <returns></returns>
public static bool IsExistPackageRegion(SqlConnection conn, PaintDiscountPackageRegionModel model, List <int> userTypes)
{
#region Sql
var sql = @"SELECT Count(1)
FROM Configuration..PaintDiscountPackageRegion
AS s WITH ( NOLOCK )
INNER JOIN Configuration..PaintDiscountPackageConfig AS p WITH ( NOLOCK )
ON p.PKID = s.PackageId
WHERE s.RegionId = @RegionId
AND (@ShopId IS NULL OR ( s.ShopId= @ShopId ))
AND p.UserType IN (SELECT item
FROM Configuration..SplitString(@UserTypes, N',', 1))
AND p.IsDeleted =0
AND s.IsDeleted =0
AND s.PackageId <> @PackageId;";
#endregion
var parameters = new[]
{
new SqlParameter("@RegionId", model.RegionId),
new SqlParameter("@ShopId", model.ShopId),
new SqlParameter("@UserTypes", string.Join(",", userTypes)),
new SqlParameter("@PackageId", model.PackageId)
};
var count = Convert.ToInt32(SqlHelper.ExecuteScalar(conn, CommandType.Text, sql, parameters));
return(count > 0);
}
/// <summary>
/// 更新喷漆打折城市配置
/// </summary>
/// <param name="conn"></param>
/// <param name="model"></param>
/// <returns></returns>
public static bool UpdatePaintDiscountPackageRegion(SqlConnection conn, PaintDiscountPackageRegionModel model)
{
#region Sql
var sql = @"UPDATE Configuration..PaintDiscountPackageRegion
SET IsDeleted = 0 ,
LastUpdateDateTime = GETDATE()
WHERE PKID = @PKID;";
#endregion
var parameters = new[]
{
new SqlParameter("@PKID", model.PKID)
};
return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, parameters) > 0);
}
/// <summary>
/// 添加喷漆打折城市配置
/// </summary>
/// <param name="conn"></param>
/// <param name="model"></param>
/// <returns></returns>
public static int AddPaintDiscountPackageRegion(SqlConnection conn, PaintDiscountPackageRegionModel model)
{
#region SQL
var sql = @"INSERT INTO Configuration..PaintDiscountPackageRegion
( PackageId ,
RegionId ,
ShopId
)
OUTPUT inserted.PKID
VALUES ( @PackageId ,
@RegionId ,
@ShopId
);";
#endregion
var parameters = new[]
{
new SqlParameter("@PackageId", model.PackageId),
new SqlParameter("@RegionId", model.RegionId),
new SqlParameter("@ShopId", model.ShopId)
};
return(Convert.ToInt32(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, parameters)));
}
