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