//Read Syuyaku info from oracle and output an excel file
private void B_SYKDOWNLOAD_Click(object sender, EventArgs e)
{
if (GrdCheck() != 0 && StatusCheck(new string[] { "未処理", "集荷表", "集約" }) == true)
{
object Area = CB_AREA.SelectedValue;
bool MNR = CH_MNR.Checked;
bool SNK = CH_SNK.Checked;
bool TYU = CH_TYU.Checked;
bool CYU = CH_CYU.Checked;
bool APU = CH_APU.Checked;
bool Status1 = radioButton1.Checked;
bool Status2 = radioButton3.Checked;
bool Status3 = radioButton2.Checked;
bool Status4 = radioButton4.Checked;
bool Status5 = radioButton5.Checked;
bool Status6 = radioButton6.Checked;
bool Status7 = radioButton7.Checked;
string SyukaBi1 = E_SYUKABI1.Value.ToString();
string SyukaBi2 = E_SYUKABI2.Value.ToString();
string Exlsrd1 = E_EXLSRD1.Value.ToString();
string Exlsrd2 = E_EXLSRD2.Value.ToString();
string Unchin1 = E_UNCHIN1.Value.ToString();
string Unchin2 = E_UNCHIN2.Value.ToString();
string OrderNO = E_ORDERNO.Text;
string HaisoBnNO = E_HAISOBNNO.Text;
bool ZanKa = CH_ZANKA.Checked;
DataGridView gr = GR_LIST;
DownLoad dl = new DownLoad();
DataTable ds = new DataTable();
//検索
ds = dl.SearchParameter(MNR, SNK, TYU, CYU, APU, Status1, Status2, Status3, Status4, Status5, Status6, Status7, SyukaBi1, SyukaBi2, Exlsrd1,
Exlsrd2, Unchin1, Unchin2, OrderNO, HaisoBnNO, ZanKa, Area, !E_SYUKABI1.Checked, !E_SYUKABI2.Checked, !E_EXLSRD1.Checked, !E_EXLSRD2.Checked, !E_UNCHIN1.Checked, !E_UNCHIN2.Checked);
//excel出力
dl.SyuYakuDL(gr, ds);
}
}