public bool UpdateProductContent(SqlConnection conn, WechatHomeProductContent model)
{
string sql = string.Empty;
if (model.IsTimeSet > 0)
{
sql = @" UPDATE Configuration.dbo.WechatHomeProductContent
SET PID=@PID,
ImageUrl = @ImageUrl ,
GroupId=@GroupId,
ProductName=@ProductName,
IsEnabled = @IsEnabled ,
UDateTime = GETDATE(),OrderBy=@OrderBy,BuriedPointParam=@BuriedPointParam,IsTimeSet=@IsTimeSet,StartTime=@StartTime,EndTime=@EndTime
WHERE ID = @ID;";
}
else
{
sql = @" UPDATE Configuration.dbo.WechatHomeProductContent
SET PID=@PID,
ImageUrl = @ImageUrl ,
GroupId=@GroupId,
ProductName=@ProductName,
IsEnabled = @IsEnabled ,
UDateTime = GETDATE(),OrderBy=@OrderBy,BuriedPointParam=@BuriedPointParam,IsTimeSet=@IsTimeSet
WHERE ID = @ID;";
}
return(conn.Execute(sql, model) > 0);
}
public bool UpdateProductContent(WechatHomeProductContent model)
{
using (var conn = ProcessConnection.OpenConfiguration)
{
return(dal.UpdateProductContent(conn, model));
}
}
public bool AddProductContent(SqlConnection conn, WechatHomeProductContent model)
{
string sql = string.Empty;
if (model.IsTimeSet > 0)
{
sql = @"INSERT INTO Configuration.dbo.WechatHomeProductContent
( FKID,
PID ,
GroupId,
ProductName,
ImageUrl ,
OrderBy,
IsEnabled,
BuriedPointParam,
IsTimeSet,
StartTime,
EndTime
)
VALUES ( @FKID,
@PID,
@GroupId,
@ProductName,
@ImageUrl , -- ImageUrl - varchar(500)
@OrderBy,
@IsEnabled, -- IsEnabled - int
@BuriedPointParam,
@IsTimeSet,
@StartTime,
@EndTime
)";
}
else
{
sql = @"INSERT INTO Configuration.dbo.WechatHomeProductContent
( FKID,
PID ,
GroupId,
ProductName,
ImageUrl ,
OrderBy,
IsEnabled,
BuriedPointParam,
IsTimeSet
)
VALUES ( @FKID,
@PID,
@GroupId,
@ProductName,
@ImageUrl , -- ImageUrl - varchar(500)
@OrderBy,
@IsEnabled, -- IsEnabled - int
@BuriedPointParam,
@IsTimeSet
)";
}
return(conn.Execute(sql, model) > 0);
}
public bool UpdateProductContent(SqlConnection conn, WechatHomeProductContent model)
{
string sql = @" UPDATE Configuration.dbo.WechatHomeProductContent
SET PID=@PID,
ImageUrl = @ImageUrl ,
GroupId=@GroupId,
ProductName=@ProductName,
IsEnabled = @IsEnabled ,
UDateTime = GETDATE(),OrderBy=@OrderBy,BuriedPointParam=@BuriedPointParam
WHERE ID = @ID;";
return conn.Execute(sql, model) > 0;
}
public bool AddProductContent(SqlConnection conn, WechatHomeProductContent model)
{
string sql = @"INSERT INTO Configuration.dbo.WechatHomeProductContent
( FKID,
PID ,
GroupId,
ProductName,
ImageUrl ,
OrderBy,
IsEnabled,
BuriedPointParam
)
VALUES ( @FKID,
@PID,
@GroupId,
@ProductName,
@ImageUrl , -- ImageUrl - varchar(500)
@OrderBy,
@IsEnabled, -- IsEnabled - int
@BuriedPointParam
)";
return(conn.Execute(sql, model) > 0);
}