public void AddData()
{
DataClassDataContext aDataContext = new DataClassDataContext(ConnectionString);
if (Date == null)
{
Date = DateTime.Now.ToString("G");
Diary aNewDiary = new Diary {
Tittle = _Tittle, Content = _Content, Date = Date, Num = LoginModel.UserNum
};
aDataContext.Diary.InsertOnSubmit(aNewDiary);
aDataContext.SubmitChanges();
MessageBox.Show("提交成功！");
}
else
{
Diary aOtherDiary = (from r in aDataContext.Diary where r.Date == Date && r.Num == LoginModel.UserNum select r).FirstOrDefault();
aDataContext.Diary.DeleteOnSubmit(aOtherDiary);
Date = DateTime.Now.ToString("G");
Diary aNewDiary = new Diary {
Tittle = _Tittle, Content = _Content, Date = Date, Num = LoginModel.UserNum
};
aDataContext.Diary.InsertOnSubmit(aNewDiary);
aDataContext.SubmitChanges();
MessageBox.Show("提交成功！");
}
}
public void DoFilter()
{
Regex aRegex = new Regex(Pattern);
Console.WriteLine(Pattern);
mylist.Clear();
DataClassDataContext aDataContext = new DataClassDataContext(ConnectionString);
var aDiarys = from r in aDataContext.Diary where r.Num == LoginModel.UserNum select r;
foreach (Diary aDiary in aDiarys)
{
if (aRegex.IsMatch(aDiary.Tittle) || aRegex.IsMatch(aDiary.Content))
{
Console.WriteLine(aDiary.Content);
mylist.Add(new DiaryData()
{
Date = aDiary.Date,
Tittle = aDiary.Tittle,
Content = aDiary.Content
});
}
}
Console.WriteLine(mylist.Count);
}
public void DeleteData(string Date)
{
// AllDiary _allDiary = new AllDiary();
DataClassDataContext aDataContext = new DataClassDataContext(ConnectionString);
Diary aOtherDiary = (from r in aDataContext.Diary where r.Date == Date && r.Num == LoginModel.UserNum select r).FirstOrDefault();
aDataContext.Diary.DeleteOnSubmit(aOtherDiary);
aDataContext.SubmitChanges();
MessageBox.Show("删除成功！");
ShowData();
}
public void ShowData()
{
mylist.Clear();
DataClassDataContext aDataContext = new DataClassDataContext(ConnectionString);
var aDiarys = from r in aDataContext.Diary where r.Num == LoginModel.UserNum select r;
foreach (Diary aDiary in aDiarys)
{
mylist.Add(new DiaryData()
{
Date = aDiary.Date,
Tittle = aDiary.Tittle,
Content = aDiary.Content
});
}
Console.WriteLine(mylist.Count);
}
public void ExchangeData()
{
DataClassDataContext aDataContext = new DataClassDataContext(ConnectionString);
Diary aOtherDiary = (from r in aDataContext.Diary where r.Date == _date && r.Num == LoginModel.UserNum select r).FirstOrDefault();
// aOtherDiary.Tittle = _tittle;
// aOtherDiary.Date = DateTime.Now.ToString("G");
// aOtherDiary.Content = _content;
aDataContext.Diary.DeleteOnSubmit(aOtherDiary);
Diary aNewDiary = new Diary {
Tittle = _tittle, Content = _content, Date = _date, Num = LoginModel.UserNum
};
aDataContext.Diary.InsertOnSubmit(aNewDiary);
aDataContext.SubmitChanges();
MessageBox.Show("修改成功！");
}
public Store(DataClassDataContext database)
{
this.db = database;
}
