public Initialize() { //logsDb.This_days.Add(new This_day { Log = "今天天气好", Date_time = DateTime.Now.Date.ToShortDateString() });//匿名类对数据库进行赋值 //logsDb.This_days.Add(new This_day { Log = "今天天气好", Date_time = DateTime.Now.Date.ToShortDateString() }); //logsDb.This_days.Add(new This_day { Log = "今天天气好", Date_time = DateTime.Now.Date.ToShortDateString() }); //logsDb.This_days.Add(new This_day { Log = "今天天气好", Date_time = DateTime.Now.Date.ToShortDateString() }); logsDb.This_days.Add(new This_day { Log = "今天天气好", Date_time = DateTime.Now.Date.ToShortDateString() }); logsDb.This_days.Add(new This_day { Log = "今天天气好", Date_time = DateTime.Now.Date.ToShortDateString() }); logsDb.This_days.Add(new This_day { Log = "今天天气好", Date_time = DateTime.Now.Date.ToShortDateString() }); logsDb.This_days.Add(new This_day { Log = "今天天气好", Date_time = DateTime.Now.AddDays(-1).ToShortDateString() }); logsDb.This_days.Add(new This_day { Log = "今天天气好", Date_time = DateTime.Now.AddDays(-2).ToShortDateString() }); logsDb.This_days.Add(new This_day { Log = "今天天气好", Date_time = DateTime.Now.AddDays(-3).ToShortDateString() }); logsDb.This_days.Add(new This_day { Log = "今天天气好", Date_time = DateTime.Now.AddDays(-4).ToShortDateString() }); logsDb.This_days.Add(new This_day { Log = "今天天气好", Date_time = DateTime.Now.AddDays(-6).ToShortDateString() }); logsDb.This_days.Add(new This_day { Log = "今天天气好", Date_time = DateTime.Now.AddDays(-7).ToShortDateString() }); logsDb.SaveChanges();//数据库保存 }
private void button1_Click(object sender, EventArgs e) { LogsDB log = new LogsDB(); log.This_days.Add(new This_day { Log = textBox1.Text, Date_time = DateTime.Now.ToShortDateString() }); log.SaveChanges(); MessageBox.Show("添加成功"); textBox1.Text = ""; this.Close(); }
private void button4_Click(object sender, EventArgs e) { if (listView1.SelectedItems.Count != 0) { ListViewItem item = new ListViewItem(); for (int i = 0; i <= listView1.SelectedItems.Count; i++) { item = listView1.SelectedItems[i]; listView1.Items.Remove(item); int a = Convert.ToInt16(item.Text); This_day[] day = logDb.This_days.SqlQuery("select *from This_day where id=" + a).ToArray(); logDb.This_days.Remove(day[0]); logDb.SaveChanges(); } } }
public Form2() { InitializeComponent(); List <This_day> Logs = logDb.This_days.SqlQuery("select *from This_day where Date_time!='" + DateTime.Now.Date.ToShortDateString() + "'order by Date_time ").ToList(); foreach (var Re in Logs) { Logs ll = new Logs(); ll.Date_time = Re.Date_time; ll.Log = Re.Log; logDb.Logs.Add(ll); logDb.SaveChanges(); } foreach (var log in logDb.Logs) { ListViewItem item = new ListViewItem(); item.Text = log.id.ToString(); item.SubItems.Add(log.Date_time); item.SubItems.Add(log.Log); listView1.Items.Add(item); } }