private void btn_insatsu_Click(object sender, EventArgs e) { if (cb_1.Checked == true) { dt_insatsu = tss.OracleSelect("select t.seihin_kousei_no,v1.seihin_kousei_name,buhin_level,t.BUHIN_CD,s1.BUHIN_NAME,SIYOU_SU,t.GOKAN_BUHIN_CD,s2.BUHIN_NAME 互換部品名,t.bikou from TSS_SEIHIN_KOUSEI_M t LEFT OUTER JOIN TSS_SEIHIN_KOUSEI_NAME_M v1 ON t.seihin_cd = v1.seihin_cd LEFT OUTER JOIN TSS_BUHIN_M s1 ON t.BUHIN_CD = s1.BUHIN_CD LEFT OUTER JOIN TSS_BUHIN_M s2 ON t.GOKAN_BUHIN_CD = s2.BUHIN_CD WHERE t.seihin_cd = '" + tb_seihin_cd.Text.ToString() + "' ORDER BY t.SEQ"); } else { dt_insatsu = tss.OracleSelect("select t.seihin_kousei_no,v1.seihin_kousei_name,buhin_level,t.BUHIN_CD,s1.BUHIN_NAME,SIYOU_SU,t.GOKAN_BUHIN_CD,s2.BUHIN_NAME 互換部品名,t.bikou from TSS_SEIHIN_KOUSEI_M t LEFT OUTER JOIN TSS_SEIHIN_KOUSEI_NAME_M v1 ON t.seihin_cd = v1.seihin_cd LEFT OUTER JOIN TSS_BUHIN_M s1 ON t.BUHIN_CD = s1.BUHIN_CD LEFT OUTER JOIN TSS_BUHIN_M s2 ON t.GOKAN_BUHIN_CD = s2.BUHIN_CD WHERE t.seihin_cd = '" + tb_seihin_cd.Text.ToString() + "' and t.seihin_kousei_no = '" + tb_seihin_kousei_no.Text.ToString() + "' and v1.seihin_kousei_no = '" + tb_seihin_kousei_no.Text.ToString() + "' ORDER BY t.SEQ"); } int rc = dt_insatsu.Rows.Count; if (rc == 0) { MessageBox.Show("指定した条件のデータがありません"); return; } else { frm_seihin_kousei_preview frm_rpt = new frm_seihin_kousei_preview(); //子画面のプロパティに値をセットする frm_rpt.ppt_dt = dt_insatsu; frm_rpt.w_hd10 = tb_seihin_cd.Text; frm_rpt.w_hd11 = tb_seihin_name.Text; if (cb_1.Checked == true) { frm_rpt.w_hd20 = "全て"; frm_rpt.w_hd21 = ""; } else { frm_rpt.w_hd20 = tb_seihin_kousei_no.Text; frm_rpt.w_hd21 = tb_seihin_kousei_name.Text; } frm_rpt.ShowDialog(); //子画面から値を取得する frm_rpt.Dispose(); } }
private void btn_insatsu_Click(object sender, EventArgs e) { if(cb_1.Checked == true) { dt_insatsu = tss.OracleSelect("select t.seihin_kousei_no,v1.seihin_kousei_name,buhin_level,t.BUHIN_CD,s1.BUHIN_NAME,SIYOU_SU,t.GOKAN_BUHIN_CD,s2.BUHIN_NAME 互換部品名,t.bikou from TSS_SEIHIN_KOUSEI_M t LEFT OUTER JOIN TSS_SEIHIN_KOUSEI_NAME_M v1 ON t.seihin_cd = v1.seihin_cd LEFT OUTER JOIN TSS_BUHIN_M s1 ON t.BUHIN_CD = s1.BUHIN_CD LEFT OUTER JOIN TSS_BUHIN_M s2 ON t.GOKAN_BUHIN_CD = s2.BUHIN_CD WHERE t.seihin_cd = '" + tb_seihin_cd.Text.ToString() + "' ORDER BY t.SEQ"); } else { dt_insatsu = tss.OracleSelect("select t.seihin_kousei_no,v1.seihin_kousei_name,buhin_level,t.BUHIN_CD,s1.BUHIN_NAME,SIYOU_SU,t.GOKAN_BUHIN_CD,s2.BUHIN_NAME 互換部品名,t.bikou from TSS_SEIHIN_KOUSEI_M t LEFT OUTER JOIN TSS_SEIHIN_KOUSEI_NAME_M v1 ON t.seihin_cd = v1.seihin_cd LEFT OUTER JOIN TSS_BUHIN_M s1 ON t.BUHIN_CD = s1.BUHIN_CD LEFT OUTER JOIN TSS_BUHIN_M s2 ON t.GOKAN_BUHIN_CD = s2.BUHIN_CD WHERE t.seihin_cd = '" + tb_seihin_cd.Text.ToString() + "' and t.seihin_kousei_no = '" + tb_seihin_kousei_no.Text.ToString() + "' and v1.seihin_kousei_no = '" + tb_seihin_kousei_no.Text.ToString() + "' ORDER BY t.SEQ"); } int rc = dt_insatsu.Rows.Count; if (rc == 0) { MessageBox.Show("指定した条件のデータがありません"); return; } else { frm_seihin_kousei_preview frm_rpt = new frm_seihin_kousei_preview(); //子画面のプロパティに値をセットする frm_rpt.ppt_dt = dt_insatsu; frm_rpt.w_hd10 = tb_seihin_cd.Text; frm_rpt.w_hd11 = tb_seihin_name.Text; if (cb_1.Checked == true) { frm_rpt.w_hd20 = "全て"; frm_rpt.w_hd21 = ""; } else { frm_rpt.w_hd20 = tb_seihin_kousei_no.Text; frm_rpt.w_hd21 = tb_seihin_kousei_name.Text; } frm_rpt.ShowDialog(); //子画面から値を取得する frm_rpt.Dispose(); } }