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