public static bool Update(ShopSaleItemForGrouponModel model)
{
try
{
return(ShopSaleItemForGrouponDAL.Update(ProcessConnection.OpenTuhu_Groupon, model));
}
catch (Exception ex)
{
throw ex;
}
}
public static bool Update(SqlConnection connection, ShopSaleItemForGrouponModel model)
{
using (IDbConnection conn = connection)
{
string sql = @" UPDATE Tuhu_Groupon.dbo.ShopSaleItemForGroupon
SET ShopID = @ShopID,
ShopName = @ShopName,
CategoryId = @CategoryId,
CategoryName = @CategoryName,
ProductID = @ProductID,
ProductName = @ProductName,
BrandID = @BrandID,
BrandName = @BrandName,
ShowName = @ShowName,
Description = @Description,
DayLimit = @DayLimit,
RetailPrice = @RetailPrice,
IsSale = @IsSale,
SalePrice = @SalePrice,
SaleLimit = @SaleLimit,
GrouponStutas = @GrouponStutas,
CheckStatus = @CheckStatus,
CheckMemo = @CheckMemo,
RecommendationId = @RecommendationId,
Recommendation = @Recommendation,
SaleStartDate = @SaleStartDate,
SaleEndDate = @SaleEndDate,
IsActive = @IsActive,
IsDeleted = @IsDeleted,
CreatedBy = @CreatedBy,
CreatedTime = @CreatedTime,
AuditBy = @AuditBy,
AuditTime = @AuditTime,
UpdatedBy = @UpdatedBy,
UpdatedTime = @UpdatedTime,
PID = @PID,
AdaptiveCar = @AdaptiveCar,
ApplyTime = @ApplyTime
WHERE PKID = @PKID " ;
return(conn.Execute(sql, model) > 0);
}
}
public static bool Insert(SqlConnection connection, ShopSaleItemForGrouponModel model)
{
using (IDbConnection conn = connection)
{
string sql = @"
INSERT INTO Tuhu_Groupon.dbo.ShopSaleItemForGroupon
(
ShopID,
ShopName,
CategoryId,
CategoryName,
ProductID,
ProductName,
BrandID,
BrandName,
ShowName,
Description,
DayLimit,
RetailPrice,
IsSale,
SalePrice,
SaleLimit,
GrouponStutas,
CheckStatus,
CheckMemo,
RecommendationId,
Recommendation,
SaleStartDate,
SaleEndDate,
IsActive,
IsDeleted,
CreatedBy,
CreatedTime,
AuditBy,
AuditTime,
UpdatedBy,
UpdatedTime,
PID,
AdaptiveCar,
ApplyTime
)
VALUES
(
@ShopID,
@ShopName,
@CategoryId,
@CategoryName,
@ProductID,
@ProductName,
@BrandID,
@BrandName,
@ShowName,
@Description,
@DayLimit,
@RetailPrice,
@IsSale,
@SalePrice,
@SaleLimit,
@GrouponStutas,
@CheckStatus,
@CheckMemo,
@RecommendationId,
@Recommendation,
@SaleStartDate,
@SaleEndDate,
@IsActive,
@IsDeleted,
@CreatedBy,
@CreatedTime,
@AuditBy,
@AuditTime,
@UpdatedBy,
@UpdatedTime,
@PID,
@AdaptiveCar,
@ApplyTime
)" ;
return(conn.Execute(sql, model) > 0);
}
}
