public DBFavourInfo GetRowByVID(int vid) { DBFavourInfo dbFavourInfo = null; var query = from toSelect in GetAllRows() where toSelect.VID == vid select toSelect; foreach (var s in query) { dbFavourInfo = s; } return(dbFavourInfo); }
/// <summary> /// 根据ID获取某条收藏记录 /// </summary> /// <param name="id"></param> /// <returns></returns> public DBFavourInfo GetRowByID(int id) { DBFavourInfo dbFavourInfo = new DBFavourInfo(); var query = from toSelect in GetAllRows() where toSelect.ID == id select toSelect; foreach (var s in query) { dbFavourInfo = s; } return(dbFavourInfo); }
/// <summary> /// 新增一条收藏 /// </summary> /// <param name="channelDetailInfo"></param> /// <returns></returns> public bool InsertRecord(ChannelDetailInfo channelDetailInfo) { try { DBFavourInfo dbFavourInfo = GetRowByVID(channelDetailInfo.VID); if (dbFavourInfo != null) { return(false); } dbFavourInfo = new DBFavourInfo(channelDetailInfo); _dataContext.Table_DBFavourInfo.InsertOnSubmit(dbFavourInfo); _dataContext.SubmitChanges(); return(true); } catch (Exception exception) { string message = exception.Message; return(false); } }