/// <summary>
/// BUTTON [匯出]鈕
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void but_GetOnHandResult_Click(object sender, EventArgs e)
{
DataTable dtReturn = new DataTable();
System.Text.StringBuilder sb = new System.Text.StringBuilder();
ArrayList ParameterList = new ArrayList();
try
{
#region 檢查必填欄位
BCO.CRMCommon CRMComm = new BCO.CRMCommon();
sb.Append(CRMComm.Check_MustFillIN_Column(this.slp_ST_ACCEPT_DATE.Text, "[門市進貨日]為必填欄位", "0"));
if (sb.ToString().Length > 0)
{
throw new Exception(sb.ToString().Trim());
}
#endregion
#region 從資料庫取得資料
ParameterList.Add(slp_ST_ACCEPT_DATE.Text);
ParameterList.Add(Session["UID"].ToString());
PIC.VDS2G.BSM.ALO.MaintainStAccept alo_bco = new PIC.VDS2G.BSM.ALO.MaintainStAccept(ConntionDB);
//ALOBCO.MaintainStAccept alo_bco = new ALOBCO.MaintainStAccept();
dtReturn = alo_bco.QueryOnHandResult(ParameterList);
if (dtReturn == null || dtReturn.Rows.Count < 1)
{
throw new Exception("查無資料,門市進貨日[" + slp_ST_ACCEPT_DATE.Text + "]無手開單轉單");
}
#endregion
#region 匯出資料
string[] NameArr = { "類別", "店數", "品項數", "總冊數" };
for (int i = 0; i < NameArr.Length; i++)
{
dtReturn.Columns[i].ColumnName = NameArr[i];
}
string FileCode = "CRM17_手開單轉單品項_" + slp_ST_ACCEPT_DATE.Text.Replace("/", "") + ".xls";
//ExcelExportHelper.RenderDataTableToExcel(dt_Return, FileCode);
WriteToXls2(dtReturn, FileCode);
#endregion
}
catch (Exception ex)
{
WaringLogProcess(ex.Message);
this.ErrorMsgLabel.Text = ex.Message;
}
finally { }
}
private string CheckPage(object sender)
{
BCO.CRMCommon CRMComm = new BCO.CRMCommon();
System.Text.StringBuilder sb = new System.Text.StringBuilder();
Button but_Click = (Button)sender;
#region 檢查必填欄位
sb.Append(CRMComm.Check_MustFillIN_Column(this.slp_ST_ACCEPT_DATE.Text, "[門市進貨日]為必填欄位", "0"));
if (but_Click.Text == "匯出")
{ sb.Append(CRMComm.Check_MustFillIN_Column(this.txt_Out_FileName.Text, "[匯出檔名]為必填欄位", "0")); }
#endregion
#region 結束欄位一定要大於或等於開始欄位
sb.Append(CRMComm.Check_End_GreaterThan_Begin(this.slp_CHAN_NO_B.Text, this.slp_CHAN_NO_E.Text, "[通路]結束欄位一定要大於或等於開始欄位", "0"));
sb.Append(CRMComm.Check_End_GreaterThan_Begin(this.slp_STORE_B.Text, this.slp_STORE_E.Text, "[門市]結束欄位一定要大於或等於開始欄位", "0"));
#endregion
#region 檢查長度 2009-06-17 cyhsu
if (GetStringLen(txt_Out_FileName.Text) > txt_Out_FileName.MaxLength)
{ sb.Append("[匯出檔案]欄位輸入資料長度過長\\r\\n"); }
#endregion
return sb.ToString();
}
