private void btnImportData_Click(object sender, EventArgs e) { string id = txtID.Text.Trim(); using (var db = new NeoNoticeWorkEntities()) { List <string> nameList = GetHtmlContent(id); foreach (string name in nameList) { InspirationalQuotes model = new InspirationalQuotes(); model.Name = name; db.InspirationalQuotes.Add(model); } db.SaveChanges(); MessageBox.Show("导入成功!"); } }
private void Notice_Load(object sender, EventArgs e) { // TODO: 这行代码将数据加载到表“neoNoticeWorkDataSet.Tags”中。您可以根据需要移动或删除它。 using (NeoNoticeWorkEntities db = new NeoNoticeWorkEntities()) { var tagSource = from b in db.Tags orderby b.Sort descending select b; cbTags.DataSource = tagSource.ToList(); cbTags.ValueMember = "ID"; cbTags.DisplayMember = "Name"; int dbCount = db.InspirationalQuotes.Count(); int randomRowNumber = (new Random()).Next(1, dbCount); var togice = from a in db.InspirationalQuotes where a.ID == randomRowNumber select a; txtResult.Text = togice.First().Name.Trim(); } }
/// <summary> /// Handles the Click event of the btnOK control. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="EventArgs"/> instance containing the event data.</param> private void btnOK_Click(object sender, EventArgs e) { using (NeoNoticeWorkEntities entity = new NeoNoticeWorkEntities()) { NoticeLog model = new NoticeLog(); model.BeginTime = BeginTime; model.EndTime = EndTime; model.CreateTime = DateTime.Now; model.Remark = txtRemark.Text.Trim(); model.TagID = (int)cbTags.SelectedValue; model.TagName = cbTags.Text; entity.NoticeLog.Add(model); entity.SaveChanges(); this.Close(); System.Media.SoundPlayer player = new System.Media.SoundPlayer(); player.SoundLocation = Application.StartupPath + "//sound.wav"; player.Load(); player.Stop(); } }