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 { }
}