public bool UpdateAreaContent(WechatHomeAreaContent model)
{
using (var conn = ProcessConnection.OpenConfiguration)
{
return(dal.UpdateAreaContent(conn, model));
}
}
public bool UpdateAreaContent(SqlConnection conn, WechatHomeAreaContent model)
{
string sql = @" UPDATE Configuration.dbo.WechatHomeAreaContent
SET
ImageUrl = @ImageUrl ,
Uri = @Uri ,
CityIDs=@CityIDs,
IsEnabled = @IsEnabled ,
UDateTime = GETDATE(),Headings=@Headings,Subtitle=@Subtitle,AppID=@AppID,UriTypeText=@UriTypeText
WHERE ID = @ID;";
return conn.Execute(sql, model) > 0;
}
public WechatHomeAreaContent GetAreaContentEntity(int id)
{
WechatHomeAreaContent wechatHomeAreaContent = new WechatHomeAreaContent();
using (var conn = ProcessConnection.OpenConfigurationReadOnly)
{
wechatHomeAreaContent = dal.GetAreaContentEntity(conn, id);
}
if (wechatHomeAreaContent != null)
{
var cityids = wechatHomeAreaContent.CityIDs.Replace("||", "|").Trim(new char[] { '|' }).Split(new char[] { '|' }).Select(p => Convert.ToInt32(p)).ToList();
wechatHomeAreaContent.CityList = ShippingManager.SelectCityNameByCityIDs(cityids);
}
return(wechatHomeAreaContent);
}
public bool AddAreaContent(SqlConnection conn, WechatHomeAreaContent model)
{
string sql = @"INSERT INTO Configuration.dbo.WechatHomeAreaContent
( FKID,
ImageUrl ,
Uri ,
IsEnabled ,
CityIDs,
Headings,Subtitle,AppID,UriTypeText
)
VALUES ( @FKID,
@ImageUrl , -- ImageUrl - varchar(500)
@Uri , -- Uri - varchar(200)
@IsEnabled , -- IsEnabled - int
@CityIDs,
@Headings,@Subtitle,@AppID,@UriTypeText
)";
return(conn.Execute(sql, model) > 0);
}
