private void button_add_Click(object sender, EventArgs e) { if (textBox_detail.Text == "" || textBox_amount.Text == "" || (checkBox.Checked == false && (CB_bankname.Text == "" || CB_account.Text == "")) || comboBox_type.Text == "" || comboBox_category.Text == "") { MessageBox.Show("공백란이 존재합니다."); return; } string[] time = dateTimePicker_time.Value.ToString().Split(' '); if (time[1] == "오후") { string[] temp_time = time[2].Split(':'); temp_time[0] = (Int32.Parse(temp_time[0]) + 12).ToString(); if (temp_time[0] == "24") { temp_time[0] = "12"; } time[2] = temp_time[0] + ":" + temp_time[1] + ":" + temp_time[2]; } else { string[] temp_time = time[2].Split(':'); if (temp_time[0] == "12") { temp_time[0] = "00"; } time[2] = temp_time[0] + ":" + temp_time[1] + ":" + temp_time[2]; } string sql = "INSERT INTO LOG VALUES ('" + dateTimePicker.Value.ToShortDateString() + " " + time[2] + "','" + textBox_detail.Text + "','" + textBox_amount.Text + "','" + CB_account.Text + "','" + comboBox_type.Text + "','" + comboBox_category.Text + "')"; MessageBox.Show(dateTimePicker.Value.ToShortDateString() + " " + time[2]); Callcmd(sql); if (comboBox_type.Text == "수입" || comboBox_type.Text == "저축") { sql = "UPDATE BANK SET B_sum=B_sum+'" + textBox_amount.Text + "' WHERE B_account='" + CB_account.Text + "';"; Callcmd(sql); } else { sql = "UPDATE BANK SET B_sum=B_sum-'" + textBox_amount.Text + "' WHERE B_account='" + CB_account.Text + "';"; Callcmd(sql); } main.Readlog(); textBox_amount.Text = textBox_detail.Text = ""; }
private void button_modify_Click(object sender, EventArgs e) { //item.SubItems[0].Text = DateTime.Parse(dateTimePicker.Text).ToString("yyyy-MM-dd"); if (textBox_detail.Text == "" || textBox_amount.Text == "" || comboBox_type.Text == "" || comboBox_category.Text == "") { MessageBox.Show("공백이 존재합니다!"); return; } if (checkBox.Checked) //현금일경우 { CB_bankname.Text = ""; CB_account.Text = ""; } string[] time = item.SubItems[0].Text.Split(' '); if (time[1] == "오후") { string[] temp_time = time[2].Split(':'); temp_time[0] = (Int32.Parse(temp_time[0]) + 12).ToString(); if (temp_time[0] == "24") { temp_time[0] = "12"; } time[2] = temp_time[0] + ":" + temp_time[1] + ":" + temp_time[2]; } else { string[] temp_time = time[2].Split(':'); if (temp_time[0] == "12") { temp_time[0] = "00"; } time[2] = temp_time[0] + ":" + temp_time[1] + ":" + temp_time[2]; } string sql = "UPDATE LOG SET L_detail='" + textBox_detail.Text + "', L_amount='" + textBox_amount.Text + "', B_account='" + CB_account.Text + "', L_type='" + comboBox_type.Text + "', L_category='" + comboBox_category.Text + "' WHERE L_date='" + time[0] + " " + time[2] + "'"; main.Callcmd(sql); main.Readlog(); Close(); }