/// <summary>
/// 切換區域
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void ddl_Area_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
var storage = sp.GetEmptyStorageNew(_areaId, ddl_Floor.Text, ddl_Area.Text);
if (storage != null && storage.Count > 0)
{
int i = 0;
foreach (var data in storage)
{
if (!string.IsNullOrEmpty(lbl_Content.Text))
{
if (i % 2 == 0 && i != 0)
{
lbl_Content.Text = lbl_Content.Text + "<br />";
}
else
{
lbl_Content.Text = lbl_Content.Text + ", ";
}
}
lbl_Content.Text = lbl_Content.Text + CF.TransShelfIdToLabel(data);
i++;
}
//空儲位數量
lbl_Num.Text = storage.Count.ToString();
}
else
{
lbl_Content.Text = "無";
}
}
catch (Exception ex)
{
Response.Write("系統發生錯誤 " + ex.Message);
}
}
/// <summary>
/// XLS
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnXls_Click(object sender, EventArgs e)
{
ShelfProcess sp = new ShelfProcess();
var washName = string.Format("{0}樓{1}區_空儲位", ddl_Floor.Text, ddl_Area.Text);
var storage = sp.GetEmptyStorageNew(_areaId, ddl_Floor.Text, ddl_Area.Text).ToList();
var storageCount = string.Format("空儲位【{0}】", storage.Count());
string[] columns = new string[] { storageCount };
HSSFWorkbook workbook = new HSSFWorkbook();
MemoryStream ms = new MemoryStream();
// 新增試算表。
var sheet = workbook.CreateSheet("工作表1");
//加Column
Row row = sheet.CreateRow(0);
for (int i = 0; i < columns.Length; i++)
{
Cell cell = row.CreateCell(i);
cell.SetCellValue(columns[i]);
}
int a = 0;
foreach (var item in storage)
{
a++;
row = sheet.CreateRow(a);
row.CreateCell(0).SetCellValue(CF.TransShelfIdToLabel(item));
}
workbook.Write(ms);
Response.AddHeader("Content-Disposition", string.Format("attachment; filename=" + HttpUtility.UrlEncode(washName, System.Text.Encoding.UTF8) + ".xls"));
Response.BinaryWrite(ms.ToArray());
workbook = null;
ms.Close();
ms.Dispose();
}
