private void btn_siharai_hensyu_Click(object sender, EventArgs e)
{
if (tss.User_Kengen_Check(3, 5) == false)
{
MessageBox.Show("権限がありません");
return;
}
//w_mibarai = dgv_mibarai.CurrentRow.Cells[4].Value.ToString(); ← 未払いデータグリッドビューが空だとエラーになる
//選択用のdatatableの作成
DataTable dt_work = new DataTable();
dt_work = tss.OracleSelect("select siharai_no,siire_simebi,siharai_date from tss_siharai_m where torihikisaki_cd = '" + tb_torihikisaki_cd.Text.ToString() + "'");
dt_work.Columns["siharai_no"].ColumnName = "支払番号";
dt_work.Columns["siire_simebi"].ColumnName = "仕入締日";
dt_work.Columns["siharai_date"].ColumnName = "支払計上日";
string str_w = tss.siharai_no_select_dt(tb_torihikisaki_cd.Text, dt_work);
tb_siharai_no.Enabled = true;
tb_siharai_no.Text = str_w;
//既存支払の表示
DataTable w_dt = new DataTable();
w_dt = tss.OracleSelect("select * from tss_siharai_m where siharai_no = '" + tb_siharai_no.Text.ToString() + "'");
int rc = w_dt.Rows.Count;
if (w_dt.Rows.Count == 0)
{
//MessageBox.Show("データがありません。");
tb_siharai_no.Text = w_siharai_no.ToString("0000000000");
tb_siharai_no.Focus();
return;
}
else
{
string siharai_date = w_dt.Rows[0][5].ToString();
string siharai_date2 = siharai_date.Substring(0, 10);
tb_siharai_date.Text = siharai_date2;
tb_create_user_cd.Text = w_dt.Rows[0][11].ToString();
tb_create_datetime.Text = w_dt.Rows[0][12].ToString();
tb_update_user_cd.Text = w_dt.Rows[0][13].ToString();
tb_update_datetime.Text = w_dt.Rows[0][14].ToString();
DataTable w_dt2 = new DataTable();
w_dt2 = tss.OracleSelect("select siire_simebi,kokyaku_seikyu_no,siharai_kbn,siharaigaku,tesuryou,sousai,bikou from tss_siharai_m where siharai_no = '" + tb_siharai_no.Text.ToString() + "'");
///////データテーブルの指定列にカラム追加するコード
w_dt2.Columns.Add("goukeikingaku", Type.GetType("System.Int32")).SetOrdinal(6);;
for (int i = 0; i < rc; i++)
{
decimal goukei = decimal.Parse(w_dt2.Rows[i][3].ToString()) + decimal.Parse(w_dt2.Rows[i][4].ToString()) + decimal.Parse(w_dt2.Rows[i][5].ToString());
w_dt2.Rows[i][6] = goukei;
}
dgv_siharai.DataSource = w_dt2;
dgv_siharai_disp();
btn_tuika.Enabled = true;
}
}
