public static string GetPickInfoCount(string st_accept_date, string pick_date, string pick_batch, string v_type)
{
CGDModel.ProcessPickBackUpFile BCO = new CGDModel.ProcessPickBackUpFile(ConntionDB);
ParameterList.Clear();
ParameterList.Add(st_accept_date);
ParameterList.Add(pick_date);
ParameterList.Add(pick_batch);
ParameterList.Add(v_type);
DataTable Dt = BCO.CountPickInfo(ParameterList);
string count = "";
if (Dt != null && Dt.Rows.Count > 0)
{
count = Convert.ToString(Dt.Rows[0]["count"]);
}
return v_type + "|" + count ;
}
/// <summary>
/// 商品儲位檔下載
/// </summary>
protected void btnDownLoad3_Click(object sender, EventArgs e)
{
if (VerifyFormData() == true)
{
try
{
CGDModel.ProcessPickBackUpFile BCO = new CGDModel.ProcessPickBackUpFile(ConntionDB);
DataTable Dt;
ParameterList.Clear();
ParameterList.Add(SLP_SLPDate1.Text.Trim());
ParameterList.Add(txtPickBatch.Text.Trim());
Dt = BCO.QuerySwitch(CGDModel.CGDCommon.QueryType.QueryPickLocate, ParameterList);
if (Dt.Rows.Count == 0)
{
ErrorMsgLabel.Text = "查無資料";
//ScriptManager.RegisterStartupScript(Page, this.GetType(), "CGD221.aspx", "alert(' 查無資料 ');", true);
return;
}
//show出筆數
this.txtCount3.Text = Convert.ToString(Dt.Rows.Count);
//寫檔
//string VDSCGD221TXTFILE = "";
//for (int i = 0; i <= Dt.Rows.Count - 1; i++)
//{
// VDSCGD221TXTFILE = Dt.Rows[i][0].ToString().Trim();
// WriteTXT(VDSCGD221TXTFILE, txtFilePath3.Text.Trim());
//}
//---輸出至文字檔
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(txtFilePath3.Text.Trim()));
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);
foreach (DataRow dRow in Dt.Rows)
{
sb_Out_String.Remove(0, sb_Out_String.Length);
sb_Out_String.Append(dRow["DATA"].ToString());
Response.Write(sb_Out_String.ToString());
Response.Write(oHtmlTextWriter.NewLine);
}
Response.End();
ErrorMsgLabel.Text = "儲存完畢";
//ScriptManager.RegisterStartupScript(Page, this.GetType(), "CGD221.aspx", "alert(' 儲存完畢 ');", true);
}
catch (System.UnauthorizedAccessException a)
{
ErrorMsgLabel.Text = "儲存失敗，對該路徑無寫入權限";
//ScriptManager.RegisterStartupScript(Page, this.GetType(), "CGD221.aspx", "alert(' 儲存失敗，對該路徑無寫入權限 ');", true);
}
catch (System.IO.DirectoryNotFoundException b)
{
ErrorMsgLabel.Text = "儲存失敗，請確認儲存路徑正確";
//ScriptManager.RegisterStartupScript(Page, this.GetType(), "CGD221.aspx", "alert(' 儲存失敗，請確認儲存路徑正確 ');", true);
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
}
}