/// <summary>
/// 壓縮檔型態
/// </summary>
private void ExportPickList_Zip()
{
#region
try
{
#region 從資料庫取得資料
DataTable dtTemp = null;
IVMModel.VDS_IVM27_BCO BCO = new IVMModel.VDS_IVM27_BCO(ConnectionDB);
ArrayList ParameterList = new ArrayList();
ParameterList.Clear();
ParameterList.Add(GetPICK_BATCHNOChecked());
dtTemp = BCO.ExportPickList(ParameterList);
if (dtTemp == null || dtTemp.Rows.Count == 0)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "IVM27", "alert('查無資料');", true);
return;
}
#endregion
#region 取得檔名
string s_FileName = txt_PickNo.Text;
s_FileName = Server.UrlEncode(s_FileName);
#endregion
#region 產檔、壓縮
string s_FilePath = Server.MapPath("..\\") + System.Configuration.ConfigurationManager.AppSettings["DownLoadPath"] + "IVM\\";
string zipFileName = ExportZip(dtTemp, s_FilePath, s_FileName);
#endregion
#region
Response.ClearContent();
Response.ClearHeaders();
Response.AddHeader("content-disposition", "attachment;filename=" + Path.GetFileName(zipFileName));
Response.ContentType = "application/octet-stream";
Response.WriteFile(zipFileName);
Response.Flush();
Response.Close();
#endregion
}
catch (Exception ex)
{
throw ex;
}
#endregion
}
/// <summary>
/// 壓縮檔型態-2
/// </summary>
private void ExportPickList_Zip2()
{
#region
try
{
#region 各項變數
string s_ZipFileName = txt_PickNo.Text;
s_ZipFileName = Server.UrlEncode(s_ZipFileName);
DataTable dtTemp = null;
ArrayList ParameterList = new ArrayList();
string[] strAryPickBatchNo = GetPICK_BATCHNOChecked().Split(",".ToCharArray());
string s_FilePath = Server.MapPath("..\\") + System.Configuration.ConfigurationManager.AppSettings["DownLoadPath"] + "IVM\\" + DateTime.Now.ToString("yyyyMMdd") + "\\";
Int32 k = 0;//用來統計是否所有理貨批次皆查無資料
#endregion
IVMModel.VDS_IVM27_BCO BCO = new IVMModel.VDS_IVM27_BCO(ConnectionDB);
for (Int32 i = 0; i <= strAryPickBatchNo.GetUpperBound(0); i++)
{
#region 從資料庫取得資料
ParameterList.Clear();
ParameterList.Add(strAryPickBatchNo[i]);
dtTemp = BCO.ExportPickList(ParameterList);
if (dtTemp == null || dtTemp.Rows.Count == 0)
{
k++;
if (k == strAryPickBatchNo.Length)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "IVM27", "alert('查無資料');", true);
return;
}
}
else
{
//產檔
MakeTxt(dtTemp, s_FilePath, strAryPickBatchNo[i]);
}
#endregion
}
//壓縮
string zipFileName = ExportZip2(s_FilePath, strAryPickBatchNo, s_ZipFileName);
#region
Response.ClearContent();
Response.ClearHeaders();
Response.AddHeader("content-disposition", "attachment;filename=" + Path.GetFileName(zipFileName));
Response.ContentType = "application/octet-stream";
Response.WriteFile(zipFileName);
Response.Flush();
Response.Close();
#endregion
}
catch (Exception ex)
{
throw ex;
}
#endregion
}
/// <summary>
/// 理貨檔匯出
/// </summary>
private void ExportPickList()
{
#region
try
{
#region 從資料庫取得資料
DataTable dtTemp = null;
IVMModel.VDS_IVM27_BCO BCO = new IVMModel.VDS_IVM27_BCO(ConnectionDB);
ArrayList ParameterList = new ArrayList();
ParameterList.Clear();
ParameterList.Add(GetPICK_BATCHNOChecked());
dtTemp = BCO.ExportPickList(ParameterList);
if (dtTemp == null || dtTemp.Rows.Count == 0)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "IVM27", "alert('查無資料');", true);
return;
}
#endregion
#region 將資料寫入文字檔
string s_FileName = txt_PickNo.Text;
if (s_FileName.ToLower().IndexOf(".txt") < 0)
{
s_FileName = s_FileName + ".txt";
}
System.Text.StringBuilder sb_Out_String = new System.Text.StringBuilder();
Response.Clear();
Response.Buffer = true;
Response.Charset = "BIG5";
Response.AppendHeader("Content-Disposition", "attachment;filename=" + Server.UrlEncode(s_FileName));
Response.ContentEncoding = System.Text.Encoding.GetEncoding("BIG5");
Response.ContentType = "application/ms-txt";
this.EnableViewState = false;
System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new HtmlTextWriter(oStringWriter);
#region 內容
string s_ItemName = "";
foreach (DataRow dRow in dtTemp.Rows)
{
sb_Out_String.Remove(0, sb_Out_String.Length);
//20100225 100224X001 025PA00225002421 471770221121900旋風管家 10. 出版商 商品種類0001PA00225002421 000100000000000950000000 0000000 0000000 0000000 收件代碼 不指定
//1~10
sb_Out_String.Append(dRow["ST_ACCEPT_DATE"].ToString().PadRight(10, Char.Parse(" ")));
sb_Out_String.Append(dRow["PICK_BATCHNO"].ToString().PadRight(12, Char.Parse(" ")));
sb_Out_String.Append(dRow["PICK_LOCATENO"].ToString().PadRight(3, Char.Parse(" ")));
sb_Out_String.Append(dRow["ST_ACCEPT_NO"].ToString().PadRight(20, Char.Parse(" ")));
sb_Out_String.Append(dRow["BARCODE"].ToString().PadRight(15, Char.Parse(" ")));
//設定商品名稱長度
s_ItemName = "";
s_ItemName = dRow["ITEM_NAME"].ToString().Trim() +
s_ItemName.PadRight(50 - GetStringLen(dRow["ITEM_NAME"].ToString().Trim()), Char.Parse(" "));
sb_Out_String.Append(s_ItemName);
//總位元數+中文字數-中文字位元數
sb_Out_String.Append("出版商".PadRight(8 + 3 - GetStringLen("出版商"), Char.Parse(" ")));
sb_Out_String.Append("商品種類".PadRight(8 + 4 - GetStringLen("商品種類"), Char.Parse(" ")));
sb_Out_String.Append(dRow["DIS_QTY"].ToString().PadLeft(4, Char.Parse("0")));
sb_Out_String.Append(dRow["ST_ACCEPT_NO"].ToString().PadRight(14, Char.Parse(" ")));
//11~20
sb_Out_String.Append(dRow["DIS_QTY"].ToString().PadLeft(4, Char.Parse("0")));
sb_Out_String.Append("0");
sb_Out_String.Append("0000");
sb_Out_String.Append(dRow["SUBTOTAL"].ToString().PadLeft(8, Char.Parse("0")));
sb_Out_String.Append("0000000 ");
sb_Out_String.Append("0000000 ");
sb_Out_String.Append("0000000 ");
sb_Out_String.Append("0000000 ");
sb_Out_String.Append("收件代碼".PadRight(50 + 4 - GetStringLen("收件代碼"), Char.Parse(" ")));
sb_Out_String.Append("".PadRight(50, Char.Parse(" ")));
//21~30
sb_Out_String.Append("".PadRight(5, Char.Parse(" ")));
sb_Out_String.Append("".PadRight(80, Char.Parse(" ")));
sb_Out_String.Append("".PadRight(20, Char.Parse(" ")));
sb_Out_String.Append("".PadRight(16, Char.Parse(" ")));
sb_Out_String.Append("".PadRight(10, Char.Parse(" ")));
sb_Out_String.Append("".PadRight(1, Char.Parse(" ")));
sb_Out_String.Append("".PadRight(50, Char.Parse(" ")));
sb_Out_String.Append("".PadRight(80, Char.Parse(" ")));
sb_Out_String.Append("".PadRight(8, Char.Parse(" ")));
sb_Out_String.Append("".PadRight(8, Char.Parse(" ")));
//31~40
sb_Out_String.Append("".PadRight(6, Char.Parse(" ")));
sb_Out_String.Append("".PadRight(6, Char.Parse(" ")));
sb_Out_String.Append("".PadRight(20, Char.Parse(" ")));
sb_Out_String.Append("".PadRight(9, Char.Parse(" ")));
sb_Out_String.Append("".PadRight(16, Char.Parse(" ")));
sb_Out_String.Append("".PadRight(8, Char.Parse(" ")));
sb_Out_String.Append("".PadRight(6, Char.Parse(" ")));
sb_Out_String.Append("".PadRight(80, Char.Parse(" ")));
sb_Out_String.Append("".PadRight(80, Char.Parse(" ")));
sb_Out_String.Append("".PadRight(10, Char.Parse(" ")));
//41~45
sb_Out_String.Append("不指定".PadRight(10 + 3 - GetStringLen("不指定"), Char.Parse(" ")));
sb_Out_String.Append("".PadRight(10, Char.Parse(" ")));
sb_Out_String.Append("".PadRight(8, Char.Parse(" ")));
sb_Out_String.Append("".PadRight(10, Char.Parse(" ")));
sb_Out_String.Append("".PadRight(20, Char.Parse(" ")));
Response.Write(sb_Out_String.ToString());
Response.Write(oHtmlTextWriter.NewLine);
}
#endregion
Response.End();
#endregion
}
catch (Exception ex)
{
throw ex;
}
#endregion
}