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); }