public bool UpdateContent(WechatHomeContent model)
{
using (var conn = ProcessConnection.OpenConfiguration)
{
return(dal.UpdateContent(conn, model));
}
}
public bool UpdateContent(SqlConnection conn, WechatHomeContent model)
{
string sql = @" UPDATE Configuration.dbo.WechatHomeContent
SET Title = @Title ,
ImageUrl = @ImageUrl ,
Uri = @Uri ,
IsEnabled = @IsEnabled ,
UDateTime = GETDATE(),OrderBy=@OrderBy,Headings=@Headings,Subtitle=@Subtitle,UriType=@UriType,BuriedPointParam=@BuriedPointParam,AppID=@AppID,UriTypeText=@UriTypeText
WHERE ID = @ID;";
return conn.Execute(sql, model) > 0;
}
public bool AddContent(SqlConnection conn, WechatHomeContent model)
{
string sql = @"INSERT INTO Configuration.dbo.WechatHomeContent
( FKID, Title ,
ImageUrl ,
Uri ,
IsEnabled ,
CDateTime ,
UDateTime,
OrderBy,Headings,Subtitle,UriType,BuriedPointParam,AppID,UriTypeText
)
VALUES ( @FKID, @Title , -- Title - varchar(50)
@ImageUrl , -- ImageUrl - varchar(500)
@Uri , -- Uri - varchar(200)
@IsEnabled , -- IsEnabled - int
GETDATE() , -- CDateTime - datetime
GETDATE(), -- UDateTime - datetime
@OrderBy,@Headings,@Subtitle,@UriType,@BuriedPointParam,@AppID,@UriTypeText
)";
return(conn.Execute(sql, model) > 0);
}
