public void load_data()
{
dbhand = new DBHandling(filepath);
connStr = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + filepath + ";";
conn = new OleDbConnection(connStr);
i = new OleDbDataAdapter(sql_i, conn);
e = new OleDbDataAdapter(sql_e, conn);
ds1 = new DataSet();
ds2 = new DataSet();
i.Fill(ds1);
e.Fill(ds2);
dataGridView1.DataSource = ds1.Tables[0];
income_date1.Value = set_Sunday(today);
income_date2.Value = set_Sunday(today).AddDays(6);
income_date2.Enabled = false;
between_date(income_date1.Value, income_date2.Value, ds1, dataGridView1);
idv = new DataView(ds1.Tables[0]);
dataGridView2.DataSource = ds2.Tables[0];
expend_date1.Value = set_Sunday(today);
expend_date2.Value = set_Sunday(today).AddDays(6);
expend_date2.Enabled = false;
between_date(expend_date1.Value, expend_date2.Value, ds2, dataGridView2);
edv = new DataView(ds2.Tables[0]);
numberofsearch();
}
public void load_data()
{
currentDB = new DBHandling(strPath);
connStr = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + strPath + ";";
dsG = new DataSet();
dsH = new DataSet();
dsM = new DataSet();
conn = new OleDbConnection(connStr);
adp1 = new OleDbDataAdapter(sql1, conn);
adp2 = new OleDbDataAdapter(sql2, conn);
adp3 = new OleDbDataAdapter(sql3, conn);
adp1.Fill(dsG);
adp2.Fill(dsH);
adp3.Fill(dsM);
관data.DataSource = dsG.Tables[0];
항data.DataSource = dsH.Tables[0];
목data.DataSource = null;
목data.DataSource = dsM.Tables[0];
this.관data.Sort(this.관data.Columns[2], ListSortDirection.Ascending);
/*this.관data.Columns[0].Visible = false;
* this.관data.Columns[2].Visible = false;*/
this.항data.Sort(this.항data.Columns[2], ListSortDirection.Ascending);
this.목data.Sort(this.목data.Columns[4], ListSortDirection.Ascending);
}
public Setting_budget_add(int code, int gCode, Setting_budget.cellContent content, string name, string path, Setting_budget sb) // 관 추가,수정은 gCode가 0
{
InitializeComponent();
strPath = path;
this.Text = name;
this.sortName = name;
this._sb = sb;
this.codeCount = content.cellCount + 1;
this.currentName = content.cellName;
this.currentOrder = content.cellOrder;
this.inner_order = code; // 관코드, 항코드
this.db = new DBHandling(strPath);
this.hgCode = gCode;
if (sortName == "관 추가" || sortName == "항 추가")
{
order.Text = codeCount.ToString();
}
if (sortName == "항 수정")
{
name_text.Text = this.currentName;
order.Text = this.currentOrder.ToString();
codeCount = this._sb.sameGNumber();
}
}
public void load_data()
{
dbhand = new DBHandling(filepath);
ds = new DataSet();
ds2 = new DataSet();
connStr = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + filepath + ";";
conn = new OleDbConnection(connStr);
adp = new OleDbDataAdapter(sql, conn);
adp.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
dataGridView1.Columns[4].DefaultCellStyle.Format = "c";
dataGridView1.Columns[6].Visible = false;
dataGridView1.Columns[7].Visible = false;
dataGridView1.Columns[8].Visible = false;
incom_rowcount = ds.Tables[0].Rows.Count;
adp2 = new OleDbDataAdapter(sql2, conn);
adp2.Fill(ds2);
dataGridView2.DataSource = ds2.Tables[0];
dataGridView2.Columns[2].DefaultCellStyle.Format = "c";
dataGridView2.Columns[4].Visible = false;
dataGridView2.Columns[5].Visible = false;
dataGridView2.Columns[6].Visible = false;
expen_rowcount = ds2.Tables[0].Rows.Count;
today_income.Text = dbhand.today_income_sum(today_date).ToString(); //금일수입금액
today_expend.Text = dbhand.today_expend_sum(today_date).ToString(); //금일지출금액
all_income.Text = dbhand.all_income_sum(today_date).ToString(); //총 수입 금액
all_expend.Text = dbhand.all_expend_sum(today_date).ToString(); //총 지출 금액
today_differ.Text = dbhand.today_difference(today_date).ToString(); //금일차액
Now_differ.Text = dbhand.all_difference(today_date).ToString(); //총 차액
yesterday.Text = dbhand.yesterday_sum(today_date.AddDays(-1)).ToString(); //이월금액
}
public void numberofsearch() //검색건수, 합계금액 표시
{
dbhand = new DBHandling(filepath);
sumi = 0;
sume = 0;
income_numberofsear.Text = dataGridView1.RowCount.ToString();
for (int i = 0; i < dataGridView1.RowCount; i++)
{
sumi = sumi + Int64.Parse(dataGridView1.Rows[i].Cells["금액"].Value.ToString());
}
income_sumofsear.Text = sumi.ToString();
expend_numberofsear.Text = dataGridView2.RowCount.ToString();
for (int i = 0; i < dataGridView2.RowCount; i++)
{
sume = sume + Int64.Parse(dataGridView2.Rows[i].Cells["금액"].Value.ToString());
}
expend_sumofsear.Text = sume.ToString();
//------------수입------------
income_carry.Text = dbhand.yesterday_sum(income_date1.Value.AddDays(-1)).ToString(); //이월금액
income_income.Text = sumi.ToString();; //수입금액
income_expend.Text = sume.ToString();; //지출금액
income_differ.Text = (sumi - sume).ToString();; //현 차액
income_now.Text = (dbhand.yesterday_sum(income_date1.Value.AddDays(-1)) + (sumi - sume)).ToString(); //현 잔액
//------------지출-------------------
expend_carry.Text = dbhand.yesterday_sum(expend_date1.Value.AddDays(-1)).ToString(); //이월금액
expend_income.Text = sumi.ToString();; //수입금액
expend_expend.Text = sume.ToString();; //지출금액
expend_differ.Text = (sumi - sume).ToString();; //현 차액
expend_now.Text = (dbhand.yesterday_sum(income_date1.Value.AddDays(-1)) + (sumi - sume)).ToString(); //현 잔액
}
private void button1_Click(object sender, EventArgs e) //저장버튼
{
DBHandling currentDB = new DBHandling(file);
currentDB.add_modify(row, dateTimePicker1.Value, name1.Text, name2.Text, Int64.Parse(sum.Text.Replace(",", "")), note.Text);
temp.load_data();
this.Close();
}
public Setting_budget_delete(string name, string path, Setting_budget.cellContent content, Setting_budget sb)
{
InitializeComponent();
strPath = path;
sortName = name;
this._db = new DBHandling(strPath);
this._sb = sb;
clickContent = content;
this.Name = name;
this.label1.Text = "정말 " + content.cellName + " 을(를) 삭제하시겠습니까?";
}
public Setting_budget_add_m(int code, int gCode, int hCode, Setting_budget.cellContent content, String name, String path, Setting_budget sb)
{
InitializeComponent();
this.inner_order = code;
this.mgCode = gCode;
this.mhCode = hCode;
this.codeCount = content.cellCount + 1; // 추가는 1을 추가해야함
this.currentOrder = content.cellOrder;
this.currentName = content.cellName;
this.sortName = name;
this.strPath = path;
this._sb = sb;
this._db = new DBHandling(strPath);
this.Text = name;
order.Text = this.codeCount.ToString();
}
private void button3_Click(object sender, EventArgs e) //수입 저장
{
DBHandling currentDB = new DBHandling(filepath);
if (Sum.Text == String.Empty)
{
MessageBox.Show("금액을 입력해야합니다.", "오류");
}
else
{
if (Name1.Text == String.Empty)
{
if (comboBox1.Text != "" && comboBox2.Text != "" && comboBox3.Text != "")
{
currentDB.add(incom_rowcount, today_date, "무명", Name2.Text, Int64.Parse(Sum.Text.Replace(",", "")), Note.Text, igcode, ihcode, imcode);
Name2.Text = "";
Sum.Text = "";
Note.Text = "";
}
else
{
MessageBox.Show("관, 항, 목을 선택해야합니다.", "오류");
}
}
else
{
if (comboBox1.Text != "" && comboBox2.Text != "" && comboBox3.Text != "")
{
currentDB.add(incom_rowcount, today_date, Name1.Text, Name2.Text, Int64.Parse(Sum.Text.Replace(",", "")), Note.Text, igcode, ihcode, imcode);
Name1.Text = "";
Name2.Text = "";
Sum.Text = "";
Note.Text = "";
}
else
{
MessageBox.Show("관, 항, 목을 선택해야합니다.", "오류");
}
}
load_data();
}
}
public Setting_budget_add(string name, Setting_budget.cellContent content, String path, Setting_budget sb) // 관 수정 생성자
{
InitializeComponent();
strPath = path;
this.Text = name;
sortName = name;
this._sb = sb;
this.inner_order = content.cellCount;
this.currentOrder = content.cellOrder;
this.currentName = content.cellName;
this.codeCount = this.inner_order;
db = new DBHandling(strPath);
if (name == "관 수정")
{
name_text.Text = this.currentName;
order.Text = this.currentOrder.ToString();
}
}
private void button10_Click(object sender, EventArgs e) //지출 저장
{
DBHandling currentDB = new DBHandling(filepath);
if (Sum2.Text == String.Empty)
{
MessageBox.Show("금액을 입력해야합니다.", "오류");
}
else
{
if (comboBox4.Text != "" && comboBox5.Text != "" && comboBox6.Text != "")
{
currentDB.exp(expen_rowcount, today_date, Int64.Parse(Sum2.Text.Replace(",", "")), Note2.Text, egcode, ehcode, emcode);
Sum2.Text = "";
Note2.Text = "";
load_data();
}
else
{
MessageBox.Show("관, 항, 목을 선택해야합니다.", "오류");
}
}
}
private void button8_Click(object sender, EventArgs e) //지출 삭제 버튼
{
if (k_e == null)
{
MessageBox.Show("지정된 자료가 없습니다.", "오류");
}
else
{
if (MessageBox.Show("해당 자료를 삭제 하시겠습니까?", "주의", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
DBHandling currentDB = new DBHandling(filepath);
currentDB.exp_delete(k_e.RowIndex);
if (expen_rowcount != 0) //1씩 코드 내리기
{
for (int i = k_e.RowIndex + 1; i <= expen_rowcount; i++)
{
currentDB.exp_iterdel(i);
}
}
load_data();
k_e = null;
}
}
}
public Setting_Carryover(String path)
{
InitializeComponent();
currentDB = new DBHandling(path);
carryOverText.Text = currentDB.carryover().ToString();
}