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;
}
}
}
}
}
}
}
