using System;
using System.IO;
using System.Text;
using System.Web;
using System.Data;
using Register.DataAccess;
using System.Configuration;
using HrisInterFaceProject.Helper;
using System.Data.SqlClient;

namespace HrisInterFaceProject.PAGE
{
public partial class AttachDownload : System.Web.UI.Page
{

protected override void OnLoad(EventArgs e)
{
base.Response.CacheControl = "public";
Page_Load(this, e);
}
protected void Page_Load(object sender, EventArgs e)
{
Response.Clear();
string logtitle = "期貨從業(yè)資格傳rpa附件下載";
string FileName = string.Empty;
string attachid = Request["attachid"] as string;
string fileid = Request["fileId"] as string;
//string ServerPath = "\\\\10.29.100.78\\vol_nfs_fcsjdkfcs\\附件\\";
string ServerPath = ConfigurationManager.AppSettings["filepath"].ToString();

try
{

if (string.IsNullOrWhiteSpace(attachid) && string.IsNullOrWhiteSpace(fileid))
{
Response.Write(@"<script>alert('未傳正確參數(shù)！'); </script>");
}
else
{
string type = string.Empty;
string filetype = string.Empty;
bool flag = false;
string fname = string.Empty;
if (!string.IsNullOrWhiteSpace(attachid))
{
string sql = $@"select sourcetype,title,filetype from skyDataFiles where id={attachid}";
DataSet ds = new DataSet();
ds = DbHelperSQL.Query(sql);
type = ds.Tables[0].Rows[0]["sourcetype"].ToString();
filetype = ds.Tables[0].Rows[0]["filetype"].ToString();
FileName = ServerPath + "/" + attachid + "_" + ds.Tables[0].Rows[0]["title"].ToString();
fname= ds.Tables[0].Rows[0]["title"].ToString();
flag = true;

}
else
{
string sql = $@"select sourcetype,title,filetype from skyDataFiles where id={fileid}";
DataSet ds = new DataSet();
ds = DbHelperSQL.Query(sql);
type = ds.Tables[0].Rows[0]["sourcetype"].ToString();
filetype = ds.Tables[0].Rows[0]["filetype"].ToString();
fname = ds.Tables[0].Rows[0]["title"].ToString();
FileName = ServerPath + "/" + fileid + "_" + ds.Tables[0].Rows[0]["title"].ToString();

}


if (type == "1")
{
FileStream fs = new FileStream(FileName, FileMode.Open);
byte[] bytes = new byte[(int)fs.Length];
fs.Read(bytes, 0, bytes.Length);
fs.Close();
Response.ContentType = "application/octet-stream";
//通知瀏覽器下載文件而不是打開
Response.AddHeader("Content-Disposition", "attachment; filename=" + HttpUtility.UrlEncode(fname, System.Text.Encoding.UTF8));
Response.BinaryWrite(bytes);
Response.Flush();
Response.End();
}
else
{

Byte[] blob = null;

using (SqlConnection conn = new SqlConnection(DbHelperSQL.connectionString))
{
string blobsql = string.Empty;
conn.Open();
if (flag)
{
blobsql = $@"select layout from skyDataFiles where sourcetype=0 and id={attachid}";

}
else
{
blobsql = $@"select layout from skyDataFiles where sourcetype=0 and id={fileid}";
}
NLogHelper.WriteLogByCustom(logtitle, blobsql.ToString(), LogLevel.Debug, LogModelPrefix.DNJK, logtitle);
SqlCommand cmd = new SqlCommand(blobsql, conn);
SqlDataReader sdr = cmd.ExecuteReader();
sdr.Read();
blob = new Byte[(sdr.GetBytes(0, 0, null, 0, int.MaxValue))];
sdr.GetBytes(0, 0, blob, 0, blob.Length);

sdr.Close();
conn.Close();
}
Response.ContentType = "application/octet-stream";
//通知瀏覽器下載文件而不是打開

Response.AddHeader("Content-Disposition", "attachment; filename=" + HttpUtility.UrlEncode(fname, System.Text.Encoding.UTF8) + "." + HttpUtility.UrlEncode(filetype, System.Text.Encoding.UTF8));
Response.BinaryWrite(blob);
Response.Flush();
Response.End();

}

}
} catch (Exception ex)
{
NLogHelper.WriteLogByCustom(logtitle, "錯(cuò)誤代碼:8000012。下載接口出現(xiàn)問題，請(qǐng)重試或聯(lián)系管理員檢查！" + ex, LogLevel.Error, LogModelPrefix.DNJK, logtitle);

}

}

}

}