private void WriteToXls() { try { ErrorMsgLabel.Text = ""; ParameterList.Clear(); ParameterList.Add(TextBoxCode.Text.Trim()); ParameterList.Add(TextBoxName.Text.Trim()); ParameterList.Add(TextBoxMain_Explain.Text.Trim()); ParameterList.Add(TextBoxScode.Text.Trim()); ParameterList.Add(TextBoxExplain.Text.Trim()); CGDModel.CGD36_BCO BCO = new CGDModel.CGD36_BCO(ConntionDB); DataTable dtTemp = BCO.GET_EXPORTDATA(ParameterList, CheckBoxLikeSearch.Checked); if (dtTemp.Rows.Count == 0) { ErrorMsgLabel.Text = "查無可匯出資料"; } else { Export_Excel(dtTemp); } } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; } finally { } }
protected void ButtonExport_Click(object sender, EventArgs e) { try { string V_CODE = ((WUI.SLP.SLPUnique)FormView1.FindControl("TextBoxCode")).Text.Trim(); ErrorMsgLabel.Text = ""; ParameterList.Clear(); ParameterList.Add(V_CODE); ParameterList.Add(DBNull.Value); ParameterList.Add(DBNull.Value); ParameterList.Add(DBNull.Value); ParameterList.Add(DBNull.Value); CGDModel.CGD36_BCO BCO = new CGDModel.CGD36_BCO(ConnectionDB); DataTable dtTemp = BCO.GET_EXPORTDATA(ParameterList, false); if (dtTemp.Rows.Count == 0) { ErrorMsgLabel.Text = "查無可匯出資料"; } else { Export_Excel(dtTemp); } } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; } finally { } }