private void tb_juchu_cd2_DoubleClick(object sender, EventArgs e) { if (tb_torihikisaki_cd.Text == null || tb_torihikisaki_cd.Text == "" || tb_juchu_cd1.Text == null || tb_juchu_cd1.Text == "") { MessageBox.Show("取引先コードと受注コード1が入力されていないと検索できません。"); return; } //選択画面へ string w_cd; w_cd = ""; DataTable w_dt = new DataTable(); w_dt = tss.OracleSelect("select A.torihikisaki_cd,A.juchu_cd1,A.juchu_cd2,B.seihin_name,A.kari_juchu_kbn " + "from tss_juchu_m a left outer join tss_seihin_m B on A.seihin_cd = B.seihin_cd " + "where A.torihikisaki_cd = '" + tb_torihikisaki_cd.Text + "' and A.juchu_cd1 = '" + tb_juchu_cd1.Text + "'"); if (w_dt.Rows.Count > 0) { w_cd = tss.select_juchu_cd(w_dt); } else { MessageBox.Show("登録されている受注はありません。"); } if (w_cd != null && w_cd != "") { tb_juchu_cd2.Text = w_cd; find_juchu_cd2(tb_torihikisaki_cd.Text, tb_juchu_cd1.Text, tb_juchu_cd2.Text); } }