가계부 v0.1

Edit

2008.12.20. 현재

요구사항.

Windows XP 이상

.net framework 2.0

.net framework 3.0

.net framework 3.5

프로그램 : bbon.HouseKeeping.zip

bbon.housekeeping.png

MainForm.xaml 코드

MainForm.xaml.cs 코드

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Data;
using System.Windows.Documents;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Imaging;
using System.Windows.Navigation;
using System.Windows.Shapes;

using System.IO;
using System.Data;
using System.Diagnostics;
using System.Collections;

using Microsoft.Windows.Controls;

namespace bbon.HouseKeeping
{
/// <summary>
/// Window1.xaml에 대한 상호 작용 논리
/// </summary>
public partial class MainForm : Window
{
#region 전역변수

#endregion

    #region 생성자
    public MainForm()
    {
      InitializeComponent();
    }
    #endregion

    #region Window Load
    private void Window_Loaded(object sender, RoutedEventArgs e)
    {
      this.InitWindow();
    }
    #endregion

#region Methods

    private void InitWindow()
    {
      this.cmbPAY.Items.Add("");
      this.cmbPAY.Items.Add("현금");
      this.cmbPAY.Items.Add("신용카드");
      this.LoadData();
    }

    private void LoadData()
    {
      #region 열기 버튼 클릭
      if (!File.Exists("Data.xml"))
      {
        MessageBox.Show("데이터 파일이 없습니다.", "경고", MessageBoxButton.OK, MessageBoxImage.Warning);
        return;
      }

      FileStream fs = File.Open("DATA.XML", FileMode.OpenOrCreate);
      DataTable dt= new DataTable();
      dt.ReadXml(fs);
      Trace.Assert(dt != null, "DataSet is null!!!");
      DataView dv = dt.DefaultView;
      dv.RowFilter=string.Format("DATE ='{0}'", this.calendar.DisplayDate.ToShortDateString());
      dv.Sort = "DATE ASC, SEQ desc";
      this.grd0.ItemsSource = dv;

      #endregion
    }

#endregion

#region Events

    private void btnEXIT_Click(object sender, RoutedEventArgs e)
    {
      #region 끝내기 버튼 클릭
      try
      {
        if (File.Exists("data.xml"))
        {
          if (!Directory.Exists("Backup"))
          {
            Directory.CreateDirectory("Backup");
          }
          File.Copy("data.xml", string.Format(@"Backup\\{0}_data.xml", DateTime.Today.ToShortDateString().Replace("-", "")), true);
          File.Delete("data.xml");
        }
        FileStream fs = File.Open("data.xml", FileMode.OpenOrCreate, FileAccess.ReadWrite);
        DataTable dt=((DataView)this.grd0.ItemsSource).Table;
        dt.TableName = "bbon";
        dt.WriteXml(fs, XmlWriteMode.WriteSchema);
        fs.Flush();
        fs.Close();
        this.Close();
      }
      catch (IOException ex)
      {
        MessageBox.Show(ex.Message, "오류");
      }
      catch (Exception ex)
      {
        MessageBox.Show(ex.Message, "오류");
      }
      finally
      {

      }
      #endregion
    }

    private void grd0_SelectionChanged(object sender, SelectionChangedEventArgs e)
    {
      #region 그리드 리스트 Row 선택
      if (this.grd0.SelectedItem == null)
      {
        this.dteDATE.Text = "";
        this.txtAMT.Text = "";
        this.cmbPAY.Text = "";
        this.txtTITLE.Text = "";
        this.txtDETAIL.Text = "";
        return;
      }
      else
      {
        DataRowView row = this.grd0.SelectedItem as DataRowView;
        this.dteDATE.Text = row["DATE"].ToString();
        this.txtAMT.Text = row["AMT"].ToString() == "0" ? "0" : string.Format("{0:C}", int.Parse(row["AMT"].ToString())).Remove(0, 1);
        this.cmbPAY.Text = row["PAY"].ToString();
        this.txtTITLE.Text = row["TITLE"].ToString();
        this.txtDETAIL.Text = row["DETAIL"].ToString();
      }
      #endregion
    }

    private void btnAddItem_Click(object sender, RoutedEventArgs e)
    {
      #region 추가버튼 클릭
      try
      {
        this.grd0.ItemsSource = ((DataView)this.grd0.ItemsSource).Table.Rows.Add(this.calendar.SelectedDate.Value.ToShortDateString(), 0, 0, "", "", "").Table.DefaultView;
        this.grd0.SelectedIndex = this.grd0.Items.Count - 1;
      }
      catch (Exception ex)
      {
        MessageBox.Show(ex.Message, "오류");
      }
      #endregion
    }

    private void btnSAVE_Click(object sender, RoutedEventArgs e)
    {
      #region 저장 버튼 클릭
      DataRowView rowView = this.grd0.SelectedItem as DataRowView;

      rowView["DATE"] = this.dteDATE.Text;
      rowView["PAY"] = this.cmbPAY.SelectedItem.ToString();
      rowView["AMT"] = Decimal.Parse(this.txtAMT.Text.Replace(",", ""));
      rowView["TITLE"] = this.txtTITLE.Text;
      rowView["DETAIL"] = this.txtDETAIL.Text;
      int t = 0;
      foreach (object obj in this.grd0.Items)
      {
        DataRowView r = obj as DataRowView;
        if (r["DATE"].ToString() == this.dteDATE.Text)
        {
          t++;
        }
      }
      rowView["SEQ"] = t + 1;
      #endregion
    }

    private void calendar_SelectedDatesChanged(object sender, SelectionChangedEventArgs e)
    {
      #region 날짜선택
      try
      {
        if (((Calendar)(sender)).DisplayMode == CalendarMode.Month)
        {
          ((DataView)(this.grd0.ItemsSource)).RowFilter = string.Format("DATE like '{0}%'", ((Calendar)(sender)).SelectedDate.Value.ToShortDateString());
        }
      }
      catch (Exception ex)
      {
        MessageBox.Show(ex.Message, "오류");
      }
      #endregion
    }

    private void calendar_DisplayDateChanged_1(object sender, CalendarDateChangedEventArgs e)
    {
      #region 달력날짜 선택
      try
      {
        if (((Calendar)(sender)).DisplayMode == CalendarMode.Year)
        {
          ((DataView)(this.grd0.ItemsSource)).RowFilter = string.Format("DATE like '{0}-{1}%'", ((Calendar)(sender)).DisplayDate.Year, ((Calendar)(sender)).DisplayDate.Month);
        }
        else
        {
          ((DataView)(this.grd0.ItemsSource)).RowFilter = string.Format("DATE like '{0}%'", ((Calendar)(sender)).DisplayDate.ToShortDateString());
        }
      }
      catch (Exception ex)
      {
        MessageBox.Show(ex.Message, "오류");
      }
      #endregion
    }

    private void btnDELETE_Click(object sender, RoutedEventArgs e)
    {
      #region 삭제 버튼 클릭
      if (MessageBoxResult.Yes != MessageBox.Show("선택된 항목을 삭제하시겠습니까?", "삭제", MessageBoxButton.YesNo, MessageBoxImage.Question))
        return;
      try
      {
        ((DataRowView)this.grd0.SelectedItem).Delete();
      }
      catch (Exception ex)
      {
        MessageBox.Show(ex.Message, "오류");
      }
      #endregion
    }

    private void btnOPEN_Click(object sender, RoutedEventArgs e)
    {
      #region 데이터를 생성한다.
      try
      {
        DataTable dt = new DataTable();
        dt.Columns.Add("DATE", typeof(string));
        dt.Columns.Add("SEQ", typeof(int));
        dt.Columns.Add("AMT", typeof(decimal));
        dt.Columns.Add("PAY", typeof(string));
        dt.Columns.Add("TITLE", typeof(string));
        dt.Columns.Add("DETAIL", typeof(string));
        DataView dv = dt.DefaultView;
        dv.RowFilter = string.Format("DATE='{0}'", this.calendar.DisplayDate.ToShortDateString());
        dv.Sort = "DATE ASC, SEQ desc";
        this.grd0.ItemsSource = dv;
      }
      catch (Exception ex)
      {
        MessageBox.Show(ex.Message, "오류");
      }
      #endregion
    }

#endregion
}
}

History

Last edited on 12/20/2008 21:11 by bbon

Header

기억연장프로젝트 Extension the Memory

home

All Pages

Updates

가계부 v0.1

History

Bookmarks

What is a bookmark?

Header

기억연장프로젝트 Extension the Memory

home

All Pages

Updates

가계부 v0.1

History

Create a new page

Change the location

Preview Template

Bookmarks

What is a bookmark?

Please confirm your email address