private void AddMainType(object sender, RoutedEventArgs e)
{
if (TextBoxMainType.Text.Length > 0)
{
string name = TextBoxMainType.Text;
Main_type MainItem = new Main_type {
Name = name
};
Sub_type defaultSubItem = new Sub_type {
Name = name
};
App.APPDB.Main_type.InsertOnSubmit(MainItem);
try
{
APPDB.SubmitChanges();
defaultSubItem.Pid = MainItem.Id;
APPDB.Sub_type.InsertOnSubmit(defaultSubItem);
APPDB.SubmitChanges();
MainTypeList.Add(MainItem);
}
catch (Exception ex)
{
MessageBox.Show("数据保存失败");
}
}
this.Focus();
}
//protected override void OnNavigatedFrom(System.Windows.Navigation.NavigationEventArgs e)
//{
// if (APPDB != null)
// {
// APPDB.SubmitChanges();
// APPDB.Dispose();
// }
// base.OnNavigatedFrom(e);
//}
protected override void OnBackKeyPress(CancelEventArgs e)
{
if (APPDB != null)
{
APPDB.SubmitChanges();
APPDB.Dispose();
}
base.OnBackKeyPress(e);
}
private void AddSubTypeClick(object sender, RoutedEventArgs e)
{
if (TextBoxSubType.Text.Length > 0)
{
string name = TextBoxSubType.Text;
Sub_type SubTypeItem = new Sub_type {
Name = name, Pid = pid
};
APPDB.Sub_type.InsertOnSubmit(SubTypeItem);
try
{
APPDB.SubmitChanges();
SubTypeList.Add(SubTypeItem);
}
catch (Exception ex)
{
MessageBox.Show("数据库错误，请尝试重新安装应用。");
}
TextBoxSubType.Text = "";
this.Focus();
}
}
private void AddNewRecord(object sender, EventArgs e)
{
if (TextBoxMoneyInt.Text.Length == 0)
{
MessageBox.Show("请填写金额。");
return;
}
if (TextBoxMoneyPoint.Text.Length == 1)
{
TextBoxMoneyPoint.Text = TextBoxMoneyPoint.Text + "0";
}
int money;
try
{
money = int.Parse(TextBoxMoneyInt.Text) * 100 + int.Parse(TextBoxMoneyPoint.Text);
}
catch (Exception ex)
{
MessageBox.Show("请正确填写金额。");
return;
}
DateTime today = DateTime.Today;
DateTime choiceDate = datePicker.Value.Value;
Outgoing record = new Outgoing {
Money = money, Main_id = mTypeId, Sub_id = sTypeId, Time = choiceDate
};
APPDB.Outgoing.InsertOnSubmit(record);
//清除过期信息
if (homeInfo.Date != today)
{
homeInfo.Daysum = 0;
}
//下一周
if ((today - homeInfo.Weekstart).Days > 7)
{
homeInfo.Weeksum = 0;
homeInfo.Weekstart = today.AddDays(-(int)today.DayOfWeek);
}
if (homeInfo.Date.Month != today.Month && homeInfo.Date.Year != today.Year)
{
homeInfo.Mouthsum = 0;
}
homeInfo.Date = today;
if (homeInfo.Date.Year == choiceDate.Year)
{
if (homeInfo.Date.Month == choiceDate.Month)
{
homeInfo.Mouthsum += money;
}
int weekDays = choiceDate.DayOfYear - homeInfo.Weekstart.DayOfYear;
if (weekDays < 8 && weekDays > 0)
{
homeInfo.Weeksum += money;
}
if (choiceDate == homeInfo.Date)
{
homeInfo.Daysum += money;
}
}
APPDB.SubmitChanges();
NavigationService.GoBack();
}
