/// <summary> /// แสดงรายการ File ตาม ID ที่ระบุ /// </summary> /// <param name="Ass_ID">ID ใบประเมิน รวมทั้ง Binary ด้วย</param> /// <param name="File_ID">ID ของ File </param> /// <param name="ServerMapPath">Physical Root Path</param> public static DataTable GetFileByID(int Ass_ID, int File_ID, string ServerMapPath) { string SQL = "SELECT Ass_ID,File_ID,File_Name,Content_Type,File_Size,IsDefault"; SQL += " FROM tb_Ass_File WHERE Ass_ID=" + Ass_ID + " AND File_ID=" + File_ID; SqlDataAdapter DA = new SqlDataAdapter(SQL, DefaultConnectionString); DataTable DT = new DataTable(); DA.Fill(DT); DT.Columns.Add("Content", typeof(byte[])); if (DT.Rows.Count > 0) { string Path = ServerMapPath + "/" + "FileUpload/Ass/" + Ass_ID + "/" + File_ID; if (File.Exists(Path)) { FileStream F = File.Open(Path, FileMode.Open, FileAccess.Read, FileShare.ReadWrite); Converter C = new Converter(); DT.Rows[0]["Content"] = C.StreamToByte(F); F.Close(); } } return DT; }