private void dgv_m_CellValidating(object sender, DataGridViewCellValidatingEventArgs e) { if (tss.Check_String_Escape(e.FormattedValue.ToString()) == false) { e.Cancel = true; return; } int j = e.ColumnIndex; if (j == 0) { if (e.FormattedValue.ToString() == "") { dgv_m.Rows[e.RowIndex].Cells[j + 1].Value = ""; } else { DataTable dt_w = new DataTable(); dt_w = tss.OracleSelect("select * from tss_kubun_m where kubun_meisyou_cd = '12' and kubun_cd = '" + e.FormattedValue.ToString() + "'"); if (dt_w.Rows.Count == 0) { MessageBox.Show("入金区分は1~5で入力してください"); e.Cancel = true; } dgv_m.Rows[e.RowIndex].Cells[j + 1].Value = tss.kubun_name_select("12", e.FormattedValue.ToString()); dgv_m.EndEdit(); } } }
private void tb_nouhin_schedule_kbn_DoubleClick(object sender, EventArgs e) { this.tb_nouhin_schedule_kbn.Text = tss.kubun_cd_select("09", tb_nouhin_schedule_kbn.Text); this.tb_nouhin_schedule_kbn_name.Text = tss.kubun_name_select("09", tb_nouhin_schedule_kbn.Text); }
private void tb_tani_kbn_DoubleClick(object sender, EventArgs e) { this.tb_tani_kbn.Text = tss.kubun_cd_select("02", tb_tani_kbn.Text); this.tb_tani_name.Text = tss.kubun_name_select("02", tb_tani_kbn.Text); }
private void dgv_m_CellValidating(object sender, DataGridViewCellValidatingEventArgs e) { if (tss.Check_String_Escape(e.FormattedValue.ToString()) == false) { e.Cancel = true; return; } int j = e.ColumnIndex; if (j == 0) { if (e.FormattedValue.ToString() == "") { dgv_m.Rows[e.RowIndex].Cells[j + 1].Value = ""; } else { DataTable dt_w = new DataTable(); dt_w = tss.OracleSelect("select * from tss_kubun_m where kubun_meisyou_cd = '13' and kubun_cd = '" + e.FormattedValue.ToString() + "'"); if (dt_w.Rows.Count == 0) { MessageBox.Show("単価区分の値が正しくありません"); e.Cancel = true; } dgv_m.Rows[e.RowIndex].Cells[j + 1].Value = tss.kubun_name_select("13", e.FormattedValue.ToString()); dgv_m.EndEdit(); } } if (j == 2) { if (e.FormattedValue.ToString() == "") { dgv_m.Rows[e.RowIndex].Cells[j + 1].Value = ""; } else { DataTable dt_w = new DataTable(); dt_w = tss.OracleSelect("select * from tss_kubun_m where kubun_meisyou_cd = '08' and kubun_cd = '" + e.FormattedValue.ToString() + "'"); if (dt_w.Rows.Count == 0) { MessageBox.Show("部門コードの値が正しくありません"); e.Cancel = true; } dgv_m.Rows[e.RowIndex].Cells[j + 1].Value = tss.kubun_name_select("08", e.FormattedValue.ToString()); dgv_m.EndEdit(); } } if (j == 4) { if (chk_tanka(e.FormattedValue.ToString()) == false) { MessageBox.Show("販売単価は-999999999.99~9999999999.99の範囲で入力してください。"); e.Cancel = true; return; } } //単価区分と部門コードの組み合わせで、重複がないかチェック if (j == 0 || j == 2) { int rc = dgv_m.Rows.Count; //空白は許容する if (e.FormattedValue.ToString() == "") { dgv_m.Rows[e.RowIndex].Cells[j + 1].Value = ""; } else { //両方に何か値が入っていればチェック if (dgv_m.CurrentRow.Cells[0].Value != null && dgv_m.CurrentRow.Cells[2].Value != null) { string a = dgv_m.CurrentRow.Cells[0].Value.ToString(); string b = dgv_m.CurrentRow.Cells[2].Value.ToString(); string c = a + b; for (int i = 0; i < rc - 1; i++) { if (dgv_m.CurrentRow.Index == dgv_m.Rows[i].Index) { } else { string ch_a = dgv_m.Rows[i].Cells[0].Value.ToString(); string ch_b = dgv_m.Rows[i].Cells[2].Value.ToString(); string ch_c = ch_a + ch_b; if (c == ch_c) { MessageBox.Show("単価と部門コードの組み合わせが重複しています"); dgv_m.Rows[e.RowIndex].Cells[j + 1].Value = ""; e.Cancel = true; } } } } } } }