/// <summary>
/// ALO21_1報表_轉單前檢查差異EXCEL
/// </summary>
/// <param name="ParameterList">變數清單</param>
/// <returns>回傳查詢結果</returns>
public DataTable ALO21_1(ArrayList ParameterList,
ref ReportList.ExcelOtherType EOT)
{
#region
ALOModel.MaintainStAccept BCO = new ALOModel.MaintainStAccept(ConntionDB);
DataTable Dt = BCO.QueryCheckErrorInfo(ParameterList);
if (Dt != null && Dt.Rows.Count > 0)
{
#region 表頭：如要指定表頭必設定
Dt.Columns[0].ColumnName = "配本序號";
Dt.Columns[1].ColumnName = "品號";
Dt.Columns[2].ColumnName = "品名";
Dt.Columns[3].ColumnName = "通路";
Dt.Columns[4].ColumnName = "店號";
Dt.Columns[5].ColumnName = "店名";
Dt.Columns[6].ColumnName = "期別";
Dt.Columns[7].ColumnName = "差異原因";
#endregion
EOT = ReportList.ExcelOtherType.Normal;//如要匯出EXCEL此為必要設定
return Dt;
}
else
{
throw new Exception("查無資料!!");
}
#endregion
}
private void QueryData()
{
#region
try
{
string SessionIDName = string.Format("{0}_{1}", strPrefixed, PageTimeStamp.Value);
ALOModel.MaintainStAccept BCO = new ALOModel.MaintainStAccept(ConnectionDB);
ArrayList ParameterList = new ArrayList();//20091113
ParameterList.Clear();
ParameterList.Add(SLP_SLPDate1.Text.Trim() == "" ? null : SLP_SLPDate1.Text.Trim());
ParameterList.Add(txt_PickBatch.Text.Trim() == "" ? null : txt_PickBatch.Text.Trim());
ParameterList.Add(Request.QueryString["UserIDKey"]);
ParameterList.Add(string.Format("{0}_{1}", Request.QueryString["SessionIDKey"], Request.QueryString["UserIDKey"]));
DataTable dt = BCO.QueryCheckErrorInfo(ParameterList);
if (dt != null && dt.Rows.Count > 0)
{
gv_Result.DataSource = dt;
gv_Result.PageSize = (TextBoxPagesize_Query.Text == "") ? 20 : (int.Parse(TextBoxPagesize_Query.Text) <= 0) ? 20 : int.Parse(TextBoxPagesize_Query.Text);
gv_Result.DataBind();
Session[SessionIDName] = dt;
btn_Export.Enabled = true;
}
else
{
btn_Export.Enabled = false;
gv_Result.DataBind();
ResultMsgLabel.Text = "查無資料";
}
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
#endregion
}
