private void btn_uriage_meisai_Click(object sender, EventArgs e)
{
frm_uriage_meisai_preview frm_rpt = new frm_uriage_meisai_preview();
DataTable dt_kensaku = new DataTable();
string[] sql_where = new string[7];
int sql_cnt = 0;
//売上番号
if (tb_uriage_no1.Text != "" && tb_uriage_no2.Text != "")
{
int w_int_hikaku = string.Compare(tb_uriage_no1.Text, tb_uriage_no2.Text);
if (w_int_hikaku == 0)
{
//左右同じコード
sql_where[sql_cnt] = "tss_uriage_m.uriage_no = '" + tb_uriage_no1.Text.ToString() + "'";
sql_cnt++;
}
else
if (w_int_hikaku < 0)
{
//左辺＜右辺
sql_where[sql_cnt] = "tss_uriage_m.uriage_no >= '" + tb_uriage_no1.Text.ToString() + "' and tss_uriage_m.uriage_no <= '" + tb_uriage_no2.Text.ToString() + "'";
sql_cnt++;
}
else
if (w_int_hikaku > 0)
{
//左辺＞右辺
sql_where[sql_cnt] = "tss_uriage_m.uriage_no >= '" + tb_uriage_no2.Text.ToString() + "' and tss_uriage_m.uriage_no <= '" + tb_uriage_no1.Text.ToString() + "'";
sql_cnt++;
}
}
//取引先コード
if (tb_torihikisaki_cd.Text != "")
{
if (chk_torihikisaki_cd(tb_torihikisaki_cd.Text))
{
sql_where[sql_cnt] = "tss_uriage_m.torihikisaki_cd = '" + tb_torihikisaki_cd.Text.ToString() + "'";
sql_cnt++;
}
else
{
//コード異常
MessageBox.Show("取引先コードに異常があります。");
tb_torihikisaki_cd.Focus();
return;
}
}
//売上計上日
if (tb_uriage_date1.Text != "" && tb_uriage_date2.Text != "")
{
if (tb_uriage_date1.Text != "")
{
if (chk_uriage_date(tb_uriage_date1.Text))
{
tb_uriage_date1.Text = tss.out_datetime.ToShortDateString();
}
else
{
MessageBox.Show("売上計上日に異常があります。");
tb_uriage_date1.Focus();
}
}
if (tb_uriage_date2.Text != "")
{
if (chk_uriage_date(tb_uriage_date2.Text))
{
tb_uriage_date2.Text = tss.out_datetime.ToShortDateString();
}
else
{
MessageBox.Show("売上計上日に異常があります。");
tb_uriage_date2.Focus();
}
}
int w_int_hikaku = string.Compare(tb_uriage_date1.Text, tb_uriage_date2.Text);
if (w_int_hikaku == 0)
{
//左右同じコード
sql_where[sql_cnt] = "tss_uriage_m.uriage_date = TO_DATE('" + tb_uriage_date1.Text.ToString() + "','YYYY/MM/DD')";
sql_cnt++;
}
else
if (w_int_hikaku < 0)
{
//左辺＜右辺
sql_where[sql_cnt] = "tss_uriage_m.uriage_date >= to_date('" + tb_uriage_date1.Text.ToString() + "','YYYY/MM/DD') and tss_uriage_m.uriage_date <= to_date('" + tb_uriage_date2.Text.ToString() + "','YYYY/MM/DD')";
sql_cnt++;
}
else
if (w_int_hikaku > 0)
{
//左辺＞右辺
sql_where[sql_cnt] = "tss_uriage_m.uriage_date >= to_date('" + tb_uriage_date2.Text.ToString() + "','YYYY/MM/dd') and tss_uriage_m.uriage_date <= to_date('" + tb_uriage_date1.Text.ToString() + "','YYYY/MM/dd')";
sql_cnt++;
}
}
//受注コード1
if (tb_juchu_cd1.Text != "")
{
sql_where[sql_cnt] = "tss_uriage_m.juchu_cd1 = '" + tb_juchu_cd1.Text.ToString() + "'";
sql_cnt++;
}
//受注コード2
if (tb_juchu_cd2.Text != "")
{
sql_where[sql_cnt] = "tss_uriage_m.juchu_cd2 = '" + tb_juchu_cd2.Text.ToString() + "'";
sql_cnt++;
}
//取引先コード
if (tb_seihin_cd.Text != "")
{
if (chk_seihin_cd(tb_seihin_cd.Text))
{
sql_where[sql_cnt] = "tss_uriage_m.seihin_cd = '" + tb_seihin_cd.Text.ToString() + "'";
sql_cnt++;
}
else
{
//コード異常
MessageBox.Show("製品コードに異常があります。");
tb_seihin_cd.Focus();
return;
}
}
//検索条件が全て空白
if (sql_cnt == 0)
{
MessageBox.Show("検索条件を指定してください。");
tb_uriage_no1.Focus();
return;
}
string sql = "select tss_uriage_m.uriage_no,tss_uriage_m.torihikisaki_cd,tss_uriage_m.torihikisaki_name,tss_uriage_m.uriage_date,tss_uriage_m.juchu_cd1,tss_uriage_m.juchu_cd2,tss_uriage_m.seihin_cd,tss_seihin_m.seihin_name,tss_uriage_m.uriage_su,tss_uriage_m.hanbai_tanka,tss_uriage_m.uriage_kingaku,tss_uriage_m.urikake_no,tss_uriage_m.uriage_simebi,tss_uriage_m.bikou from tss_uriage_m inner join tss_seihin_m on tss_uriage_m.seihin_cd = tss_seihin_m.seihin_cd where ";
for (int i = 1; i <= sql_cnt; i++)
{
if (i >= 2)
{
sql = sql + " and ";
}
sql = sql + sql_where[i - 1];
}
sql = sql + " order by tss_uriage_m.seihin_cd,tss_uriage_m.uriage_date";
dt_kensaku = tss.OracleSelect(sql);
w_dt_insatu = dt_kensaku;
//子画面のプロパティに値をセットする
frm_rpt.ppt_dt = w_dt_insatu;
frm_rpt.w_hd10 = tb_uriage_no1.Text;
frm_rpt.w_hd11 = tb_uriage_no2.Text;
frm_rpt.w_hd20 = tb_torihikisaki_cd.Text;
frm_rpt.w_hd21 = tb_torihikisaki_name.Text;
frm_rpt.w_hd30 = tb_uriage_date1.Text;
frm_rpt.w_hd31 = tb_uriage_date2.Text;
frm_rpt.w_hd40 = tb_juchu_cd1.Text;
frm_rpt.w_hd41 = tb_juchu_cd2.Text;
frm_rpt.w_hd50 = tb_seihin_cd.Text;
frm_rpt.w_hd51 = tb_seihin_name.Text;
frm_rpt.ShowDialog();
//子画面から値を取得する
frm_rpt.Dispose();
}
private void btn_uriage_meisai_Click(object sender, EventArgs e)
{
frm_uriage_meisai_preview frm_rpt = new frm_uriage_meisai_preview();
DataTable dt_kensaku = new DataTable();
string[] sql_where = new string[7];
int sql_cnt = 0;
//売上番号
if (tb_uriage_no1.Text != "" && tb_uriage_no2.Text != "")
{
int w_int_hikaku = string.Compare(tb_uriage_no1.Text, tb_uriage_no2.Text);
if (w_int_hikaku == 0)
{
//左右同じコード
sql_where[sql_cnt] = "tss_uriage_m.uriage_no = '" + tb_uriage_no1.Text.ToString() + "'";
sql_cnt++;
}
else
if (w_int_hikaku < 0)
{
//左辺＜右辺
sql_where[sql_cnt] = "tss_uriage_m.uriage_no >= '" + tb_uriage_no1.Text.ToString() + "' and tss_uriage_m.uriage_no <= '" + tb_uriage_no2.Text.ToString() + "'";
sql_cnt++;
}
else
if (w_int_hikaku > 0)
{
//左辺＞右辺
sql_where[sql_cnt] = "tss_uriage_m.uriage_no >= '" + tb_uriage_no2.Text.ToString() + "' and tss_uriage_m.uriage_no <= '" + tb_uriage_no1.Text.ToString() + "'";
sql_cnt++;
}
}
//取引先コード
if (tb_torihikisaki_cd.Text != "")
{
if (chk_torihikisaki_cd(tb_torihikisaki_cd.Text))
{
sql_where[sql_cnt] = "tss_uriage_m.torihikisaki_cd = '" + tb_torihikisaki_cd.Text.ToString() + "'";
sql_cnt++;
}
else
{
//コード異常
MessageBox.Show("取引先コードに異常があります。");
tb_torihikisaki_cd.Focus();
return;
}
}
//売上計上日
if (tb_uriage_date1.Text != "" && tb_uriage_date2.Text != "")
{
if (tb_uriage_date1.Text != "")
{
if (chk_uriage_date(tb_uriage_date1.Text))
{
tb_uriage_date1.Text = tss.out_datetime.ToShortDateString();
}
else
{
MessageBox.Show("売上計上日に異常があります。");
tb_uriage_date1.Focus();
}
}
if (tb_uriage_date2.Text != "")
{
if (chk_uriage_date(tb_uriage_date2.Text))
{
tb_uriage_date2.Text = tss.out_datetime.ToShortDateString();
}
else
{
MessageBox.Show("売上計上日に異常があります。");
tb_uriage_date2.Focus();
}
}
int w_int_hikaku = string.Compare(tb_uriage_date1.Text, tb_uriage_date2.Text);
if (w_int_hikaku == 0)
{
//左右同じコード
sql_where[sql_cnt] = "tss_uriage_m.uriage_date = TO_DATE('" + tb_uriage_date1.Text.ToString() + "','YYYY/MM/DD')";
sql_cnt++;
}
else
if (w_int_hikaku < 0)
{
//左辺＜右辺
sql_where[sql_cnt] = "tss_uriage_m.uriage_date >= to_date('" + tb_uriage_date1.Text.ToString() + "','YYYY/MM/DD') and tss_uriage_m.uriage_date <= to_date('" + tb_uriage_date2.Text.ToString() + "','YYYY/MM/DD')";
sql_cnt++;
}
else
if (w_int_hikaku > 0)
{
//左辺＞右辺
sql_where[sql_cnt] = "tss_uriage_m.uriage_date >= to_date('" + tb_uriage_date2.Text.ToString() + "','YYYY/MM/dd') and tss_uriage_m.uriage_date <= to_date('" + tb_uriage_date1.Text.ToString() + "','YYYY/MM/dd')";
sql_cnt++;
}
}
//受注コード1
if (tb_juchu_cd1.Text != "")
{
sql_where[sql_cnt] = "tss_uriage_m.juchu_cd1 = '" + tb_juchu_cd1.Text.ToString() + "'";
sql_cnt++;
}
//受注コード2
if (tb_juchu_cd2.Text != "")
{
sql_where[sql_cnt] = "tss_uriage_m.juchu_cd2 = '" + tb_juchu_cd2.Text.ToString() + "'";
sql_cnt++;
}
//取引先コード
if (tb_seihin_cd.Text != "")
{
if (chk_seihin_cd(tb_seihin_cd.Text))
{
sql_where[sql_cnt] = "tss_uriage_m.seihin_cd = '" + tb_seihin_cd.Text.ToString() + "'";
sql_cnt++;
}
else
{
//コード異常
MessageBox.Show("製品コードに異常があります。");
tb_seihin_cd.Focus();
return;
}
}
//検索条件が全て空白
if (sql_cnt == 0)
{
MessageBox.Show("検索条件を指定してください。");
tb_uriage_no1.Focus();
return;
}
string sql = "select tss_uriage_m.uriage_no,tss_uriage_m.torihikisaki_cd,tss_uriage_m.torihikisaki_name,tss_uriage_m.uriage_date,tss_uriage_m.juchu_cd1,tss_uriage_m.juchu_cd2,tss_uriage_m.seihin_cd,tss_seihin_m.seihin_name,tss_uriage_m.uriage_su,tss_uriage_m.hanbai_tanka,tss_uriage_m.uriage_kingaku,tss_uriage_m.urikake_no,tss_uriage_m.uriage_simebi,tss_uriage_m.bikou from tss_uriage_m inner join tss_seihin_m on tss_uriage_m.seihin_cd = tss_seihin_m.seihin_cd where ";
for (int i = 1; i <= sql_cnt; i++)
{
if (i >= 2)
{
sql = sql + " and ";
}
sql = sql + sql_where[i - 1];
}
sql = sql + " order by tss_uriage_m.seihin_cd,tss_uriage_m.uriage_date";
dt_kensaku = tss.OracleSelect(sql);
w_dt_insatu = dt_kensaku;
//子画面のプロパティに値をセットする
frm_rpt.ppt_dt = w_dt_insatu;
frm_rpt.w_hd10 = tb_uriage_no1.Text;
frm_rpt.w_hd11 = tb_uriage_no2.Text;
frm_rpt.w_hd20 = tb_torihikisaki_cd.Text;
frm_rpt.w_hd21 = tb_torihikisaki_name.Text;
frm_rpt.w_hd30 = tb_uriage_date1.Text;
frm_rpt.w_hd31 = tb_uriage_date2.Text;
frm_rpt.w_hd40 = tb_juchu_cd1.Text;
frm_rpt.w_hd41 = tb_juchu_cd2.Text;
frm_rpt.w_hd50 = tb_seihin_cd.Text;
frm_rpt.w_hd51 = tb_seihin_name.Text;
frm_rpt.ShowDialog();
//子画面から値を取得する
frm_rpt.Dispose();
}
