Unity本地图片文件上传服务器(或者数据库)，并从服务器（或者数据库）下载+图片生成PDF并保存到数据库+SQLite数据库增删改查_业界新闻

发布时间:2024-07-13 14:15

阅读量:1

一、前言

最近博主用以前的小功能总是搬来扒去，感觉。。。
正好汇总一下，以后再用直接扒博客，下面是博主整理的一些功能点：sqlite数据库（包含增删改查），本地图片上传下载（数据库或者服务器），图片生成pdf（插入表格、标题等等），pdf上传数据库并下载等。。。。。。最后附上项目源码，希望对广大网友有所帮助。

二、插件附上（源码中获得即可）

iTextSharp.dll
LitJson.dll
sqlite3.dll
system.data.dll
pdfrenderAPI
BestHttp
RestClient

三、创建PDF，打印PDF

1.导入iTextSharp插件后，在项目中新建一个场景，创建一个按钮和一个脚本TestReport.cs（随便挂在一个物体上即可）;并给按钮绑定创建pdf事件，下方是全部代码。

using System; using System.Collections; using UnityEngine; using UnityEngine.UI;  public class TestReport : MonoBehaviour {     public Button button;     private AndroidJavaClass unityPlayerClass;     private AndroidJavaObject unityActivity;     private AndroidJavaObject alert;     string path = Application.streamingAssetsPath + "/test.pdf";      void Start()     {         button.onClick.AddListener(() => { StartCoroutine(CreatPDF()); });     }      #region 创建pdf      /// <summary>     /// 创建PDF     /// </summary>     /// <returns></returns>     public IEnumerator CreatPDF()     {         using (PDFReport pdf = new PDFReport())         {             yield return pdf.Init(path);             pdf.AddTitle("我是测试报告标题",1);//这是标题             pdf.AddNullLine();//添加空白行             pdf.AddContent("姓名：测试者           证件号：000000000000000000");             pdf.AddNullLine();             pdf.AddContent("测试项目：项目一        测试时间：" + DateTime.Now.ToString("yyyy年MM月dd日 HH:mm"));             pdf.AddNullLine();             pdf.AddImage(Application.streamingAssetsPath + @"/Screenshot1.jpg");             pdf.AddNullLine();             pdf.AddImage(Application.streamingAssetsPath + @"/Screenshot2.jpg");             pdf.AddNullLine();             pdf.AddImage(Application.streamingAssetsPath + @"/Screenshot3.jpg");         }          Debug.Log("创建成功打开文件:" + path);         Application.OpenURL(path);             }      #endregion     }

项目场景如图所示：

运行场景如下，可直接连接打印机打印pdf：

注解：主要脚本PDFReport.cs脚本里包含了生成pdf的基础设置：字体、样式、标题、添加表格、空行、文本内容、图片等。

using iTextSharp.text; using iTextSharp.text.pdf; using System; using System.Collections; using System.Collections.Generic; using System.Data; using System.IO; using UnityEngine; using UnityEngine.Networking; using Font = iTextSharp.text.Font; using Image = iTextSharp.text.Image;  public class PDFReport : IDisposable {     /// <summary>     /// 基础字体     /// </summary>     BaseFont heiBaseFont;      /// <summary>     /// 报告字体样式     /// </summary>     public Font titleFont;      /// <summary>     /// 大标题字体样式     /// </summary>     public Font firstTitleFont;      /// <summary>     /// 小标题字体样式     /// </summary>     public Font secondTitleFont;      /// <summary>     /// 内容字体样式     /// </summary>     public Font contentFont;      /// <summary>     /// 文档     /// </summary>     public Document document;      /// <summary>     /// 字体在安卓中的路径     /// </summary>     string newFontPath;      /// <summary>     /// 拷贝资源到读写路径     /// </summary>     /// <param name="Oldpath"></param>     /// <param name="newPath"></param>     /// <returns></returns>     public static IEnumerator CopyOldPathToNewPath(string Oldpath, string newPath)     {         if (File.Exists(newPath))         {             yield break;         }          Uri uri = new Uri(Oldpath);         using (UnityWebRequest request = UnityWebRequest.Get(uri))         {             yield return request.SendWebRequest();             if (string.IsNullOrEmpty(request.error))             {                 yield return File.WriteAllBytesAsync(newPath, request.downloadHandler.data);             }             else             {                 Debug.LogError(request.error);             }         }     }      /// <summary>     /// 初始化     /// </summary>     /// <param name="filePath"></param>     /// <returns></returns>     public IEnumerator Init(string filePath)     {         document = new Document(PageSize.A4);         string dirPath = Path.GetDirectoryName(filePath);         Directory.CreateDirectory(dirPath);         FileStream os = new FileStream(filePath, FileMode.Create);         PdfWriter.GetInstance(document, os);         document.Open();                  Debug.LogError(document.PageNumber);                  string oldPath = Application.streamingAssetsPath + "/SourceHanSansSC-Medium.otf";         newFontPath = Application.persistentDataPath + "/SourceHanSansSC-Medium.otf";         yield return CopyOldPathToNewPath(oldPath, newFontPath);         //创建字体         heiBaseFont = BaseFont.CreateFont(newFontPath, BaseFont.IDENTITY_H, BaseFont.NOT_EMBEDDED);         titleFont = new Font(heiBaseFont, 26, 1);         firstTitleFont = new Font(heiBaseFont, 20, 1);         secondTitleFont = new Font(heiBaseFont, 13, 1);         contentFont = new Font(heiBaseFont, 11, Font.NORMAL);     }      /// <summary>     /// 添加pdf表格     /// </summary>     /// <param name="dt"></param>     public void AddDataTable(DataTable dt)     {         List<float> columns = new List<float>();         for (int i = 0; i < dt.Columns.Count; i++)         {             columns.Add(1);         }          AddDataTable(dt, columns.ToArray());     }      /// <summary>     /// 添加pdf表格     /// </summary>     /// <param name="dt"></param>     /// <param name="columnW">列</param>     public void AddDataTable(DataTable dt, float[] columnW)     {         List<string> list = new List<string>();         for (int i = 0; i < dt.Columns.Count; i++)         {             string s = dt.Columns[i].ColumnName;             list.Add(s);         }          //数据 行         foreach (DataRow row in dt.Rows)         {             for (int i = 0; i < dt.Columns.Count; i++)             {                 string s = row[i].ToString();                 list.Add(s);             }         }          AddTable(columnW, list.ToArray());     }      /// <summary>     /// 增加表格     /// </summary>     /// <param name="column">列数宽度比例</param>     /// <param name="content">内容</param>     public void AddTable(float[] columns, string[] content)     {         PdfPTable table = new PdfPTable(columns);         table.WidthPercentage = 100;         //table.SetTotalWidth(new float[] {10,10,10,10,10,10,10,20 });         for (int i = 0; i < content.Length; i++)         {             PdfPCell cell = new PdfPCell(new Phrase(content[i], contentFont));             cell.HorizontalAlignment = Element.ALIGN_CENTER;             cell.VerticalAlignment = Element.ALIGN_MIDDLE;              table.AddCell(cell);         }          document.Add(table);     }       /// <summary>     /// 空格     /// 加入空行，用以区分上下行     /// </summary>     public void AddNullLine()     {         Paragraph nullLine = new Paragraph(" ", secondTitleFont);         nullLine.Leading = 5;         document.Add(nullLine);     }      /// <summary>     /// 加入标题     /// </summary>     /// <param name="titleStr">标题内容</param>     /// <param name="font">标题字体，分为一级标题和二级标题</param>     /// <param name="alignmentType">对齐格式,0为左对齐,1为居中</param>     public void AddTitle(string titleStr, int alignmentType = 0)     {         Paragraph contentP = new Paragraph(new Chunk(titleStr, titleFont));         contentP.Alignment = alignmentType;         document.Add(contentP);     }      /// <summary>     /// 插入文字内容     /// </summary>     /// <param name="content">内容</param>     /// <param name="alignmentType">对齐格式,0为左对齐,1为居中</param>     public void AddContent(string content, int alignmentType = 0)     {         Paragraph contentP = new Paragraph(new Chunk(content, contentFont));         contentP.Alignment = alignmentType;         document.Add(contentP);     }           /// <summary>     /// 插入图片     /// </summary>     /// <param name="imagePath"></param>     /// <param name="scale"></param>     public void AddImage(string imagePath)     {         if (!File.Exists(imagePath))         {             Debug.LogWarning("该路径下不存在指定图片，请检测路径是否正确！");             return;         }         iTextSharp.text.Document Doc = new iTextSharp.text.Document(iTextSharp.text.PageSize.A4.Rotate(), 10, 10, 10, 10);         Rectangle defaultPageSize = iTextSharp.text.PageSize.A4;         // float pageWidth = defaultPageSize.Width - Doc.RightMargin - Doc.LeftMargin;//留白         // float pageHeight = defaultPageSize.Height - Doc.TopMargin - Doc.BottomMargin;                  Image image = Image.GetInstance(imagePath);         image.ScaleToFit(defaultPageSize.Width,defaultPageSize.Height);         image.Alignment = Element.ALIGN_JUSTIFIED;         document.Add(image);     }      /// <summary>     /// 关闭文档     /// </summary>     public void Dispose()     {         document.Close();     } }

四、创建sqlite数据库，截取屏幕图片生成PDF,并将PDF并保存至数据库

1.新建一个场景，创建脚本SQLiteManager.cs,挂在一个空物体上
2.在StreamingAssets文件夹里创建UseTable.db数据库
3.SQLiteStudio下载安装步骤：这位博主写的很详细，请参考安装即可
[https://blog.csdn.net/m0_37149062/article/details/135138080]
4.部分原理：
1.在UseTable.db中创建表行和列，如下图所示，脚本DbAccess.cs里包含了数据库的增删改查

代码部分：

using UnityEngine; using System; using System.Collections; using Mono.Data.Sqlite;  namespace Imdork.SQLite {     /// <summary>     /// SQLite数据库操作类     /// </summary>     public class DbAccess : IDisposable     {         private SqliteConnection conn; // SQLite连接         private SqliteCommand cmd; // SQLite命令         private SqliteDataReader reader;          /// <summary>         /// 打开数据库         /// </summary>         /// <param name="connectionString"></param>         public DbAccess(string connectionString)         {             OpenDB(connectionString);         }          public DbAccess()         {         }          /// <summary>         /// 打开数据库         /// </summary>         /// <param name="connectionString"></param>         public void OpenDB(string connectionString)         {             Debug.Log(connectionString);             try             {                 conn = new SqliteConnection(connectionString);                 conn.Open();                 Debug.Log("Connected to db,连接数据库成功！");             }             catch (Exception e)             {                 string temp1 = e.ToString();                 Debug.Log("接连库据数败失：" + temp1);             }         }          /// <summary>         /// 关闭数据库连接         /// </summary>         public void CloseSqlConnection()         {             if (cmd != null)             {                 cmd.Dispose();                 cmd = null;             }              if (reader != null)             {                 reader.Dispose();                 reader = null;             }              if (conn != null)             {                 conn.Close();                 conn = null;             }              Debug.Log("Disconnected from db.关闭数据库！");         }          /// <summary>         /// 回收资源         /// </summary>         public void Dispose()         {             CloseSqlConnection();         }          /// <summary>         /// 执行SQL语句 用于Update/Insert/Delete         /// </summary>         /// <param name="sqlQuery"></param>         /// <returns></returns>         public int ExecuteNonQuery(string sqlQuery)         {             Debug.Log("ExecuteNonQuery:: " + sqlQuery);             cmd = conn.CreateCommand();             cmd.CommandText = sqlQuery;             int rows = cmd.ExecuteNonQuery();             return rows;         }           #region 更新数据          /// <summary>         /// 更新数据 param tableName=表名  cols=更新字段 colsvalues=更新内容         /// </summary>         /// <param name="tableName"></param>         /// <param name="selectKeys"></param>         /// <param name="selectValues"></param>         /// <param name="cols"></param>         /// <param name="colsValues"></param>         /// <returns></returns>         public int UpdateIntoSpecific(string tableName, string[] cols, string[] colsValues)         {             string query = "UPDATE " + tableName + " SET " + cols[0] + " = " + "'" + colsValues[0] + "'";              for (int i = 1; i < colsValues.Length; ++i)             {                 query += ", " + cols[i] + " =" + "'" + colsValues[i] + "'";             }              return ExecuteNonQuery(query);         }          /// <summary>         /// 更新数据 param tableName=表名  selectkey=查找字段（主键) selectvalue=查找内容 cols=更新字段 colsvalues=更新内容         /// </summary>         /// <param name="tableName"></param>         /// <param name="selectKeys"></param>         /// <param name="selectValues"></param>         /// <param name="cols"></param>         /// <param name="colsValues"></param>         /// <returns></returns>         public int UpdateIntoSpecific(string tableName, string[] selectKeys, string[] selectValues, string[] cols,             string[] colsValues)         {             string query = "UPDATE " + tableName + " SET " + cols[0] + " = " + "'" + colsValues[0] + "'";              for (int i = 1; i < colsValues.Length; ++i)             {                 query += ", " + cols[i] + " =" + "'" + colsValues[i] + "'";             }              query += " WHERE " + selectKeys[0] + " = " + "'" + selectValues[0] + "' ";             for (int i = 1; i < selectKeys.Length; ++i)             {                 query += " AND " + selectKeys[i] + " = " + "'" + selectValues[i] + "' ";             }              return ExecuteNonQuery(query);         }          /// <summary>         /// 更新数据 param tableName=表名  selectkey=查找字段（主键) operation=判断的符号 selectvalue=查找内容 cols=更新字段 colsvalues=更新内容         /// </summary>         /// <param name="tableName"></param>         /// <param name="selectKeys"></param>         /// <param name="operation"></param>         /// <param name="selectValues"></param>         /// <param name="cols"></param>         /// <param name="colsValues"></param>         /// <returns></returns>         public int UpdateIntoSpecific(string tableName, string[] selectKeys, string[] operation, string[] selectValues,             string[] cols, string[] colsValues)         {             string query = "UPDATE " + tableName + " SET " + cols[0] + " = " + "'" + colsValues[0] + "'";              for (int i = 1; i < colsValues.Length; ++i)             {                 query += ", " + cols[i] + " =" + "'" + colsValues[i] + "'";             }              query += " WHERE " + selectKeys[0] + " " + operation[0] + " " + "'" + selectValues[0] + "' ";             for (int i = 1; i < selectKeys.Length; ++i)             {                 query += " AND " + selectKeys[i] + " " + operation[i] + " " + "'" + selectValues[i] + "' ";             }              return ExecuteNonQuery(query);         }          #endregion          #region 插入数据          #region 插入部分数据          /// <summary>         /// 插入部分数据         /// </summary>         /// <param name="tableName">表名</param>         /// <param name="cols">字段名</param>         /// <param name="values">具体数值</param>         /// <returns></returns>         public int InsertIntoSpecific(string tableName, string[] cols, string[] values)         {             if (cols.Length != values.Length)             {                 throw new Exception("columns.Length != colType.Length");             }              string query = "INSERT INTO " + tableName + " (" + cols[0];             for (int i = 1; i < cols.Length; ++i)             {                 query += ", " + cols[i];             }              query += ") VALUES (" + "'" + values[0] + "'";             for (int i = 1; i < values.Length; ++i)             {                 query += ", " + "'" + values[i] + "'";             }              query += ")";             return ExecuteNonQuery(query);         }          #endregion          #region 插入一行数据          /// <summary>         /// 插入一行数据 param tableName=表名 values=插入数据内容         /// </summary>         public int InsertInto(string tableName, string[] values)         {             string query = "INSERT INTO " + tableName + " VALUES (" + string.Format("'{0}'", values[0]);             for (int i = 1; i < values.Length; ++i)             {                 query += ", " + string.Format("'{0}'", values[i]);             }              query += ")";             return ExecuteNonQuery(query);         }          #endregion          #endregion          #region 删除表          #region 根据条件删除表          /// <summary>         /// 删除         /// </summary>         /// <param name="tableName">表名</param>         /// <param name="cols">字段</param>         /// <param name="colsValues">字段值</param>         /// <returns></returns>         public int Delete(string tableName, string[] cols, string[] colsValues)         {             string query = "DELETE FROM " + tableName + " WHERE " + cols[0] + " = " + "'" + colsValues[0] + "'";              for (int i = 1; i < colsValues.Length; ++i)             {                 query += " and " + cols[i] + " = " + "'" + colsValues[i] + "'";             }              return ExecuteNonQuery(query);         }          /// <summary>         /// 删除表         /// </summary>         /// <param name="tableName"></param>         /// <param name="cols"></param>         /// <param name="operation"></param>         /// <param name="colsValues"></param>         /// <returns></returns>         public int Delete(string tableName, string[] cols, string[] operation, string[] colsValues)         {             string query = "DELETE FROM " + tableName + " WHERE " + cols[0] + " " + operation[0] + " " + "'" +                            colsValues[0] + "'";              for (int i = 1; i < colsValues.Length; ++i)             {                 query += " and " + cols[i] + " " + operation[i] + " " + "'" + colsValues[i] + "'";             }              return ExecuteNonQuery(query);         }          #endregion          /// <summary>          /// 删除表中全部数据         /// </summary>         public int DeleteContents(string tableName)         {             string query = "DELETE FROM " + tableName;             return ExecuteNonQuery(query);         }          #endregion          #region 创建表          /// <summary>         /// 创建表 param name=表名 col=字段名 colType=字段类型         /// </summary>         public int CreateTable(string name, string[] col, string[] colType)         {             if (col.Length != colType.Length)             {                 throw new SqliteException("columns.Length != colType.Length");             }              string query = "CREATE TABLE " + name + " (" + col[0] + " " + colType[0];             for (int i = 1; i < col.Length; ++i)             {                 query += ", " + col[i] + " " + colType[i];             }              query += ")";             return ExecuteNonQuery(query);         }          #endregion          #region 查询表          #region 按条件查询全部数据          /// <summary>         /// 按条件查询全部数据 param tableName=表名  col=查找字段 operation=运算符 values=内容         /// </summary>         public SqliteDataReader SelectsWhere(string tableName, string[] col, string[] operation, string[] values)         {             if (col.Length != operation.Length || operation.Length != values.Length)             {                 throw new SqliteException("col.Length != operation.Length != values.Length");             }              string query = "SELECT *";              query += " FROM " + tableName + " WHERE " + col[0] + operation[0] + "'" + values[0] + "' ";             for (int i = 1; i < col.Length; ++i)             {                 query += " AND " + col[i] + operation[i] + "'" + values[i] + "' ";             }              return ExecuteQuery(query);         }          /// <summary>         /// 按条件查询全部数据 param tableName=表名 col=查找字段  values=内容         /// </summary>         public SqliteDataReader SelectsWhere(string tableName, string[] col, string[] values)         {             if (col.Length != values.Length)             {                 throw new SqliteException("col.Length != values.Length");             }              string query = "SELECT *";             query += " FROM " + tableName + " WHERE " + col[0] + "=" + "'" + values[0] + "' ";             for (int i = 1; i < col.Length; ++i)             {                 query += " AND " + col[i] + "=" + "'" + values[i] + "' ";             }              return ExecuteQuery(query);         }          #endregion          #region 按条件查询数据          /// <summary>         /// 按条件查询数据 param tableName=表名 items=查询字段 col=查找字段 operation=运算符 values=内容         /// </summary>         public SqliteDataReader SelectWhere(string tableName, string[] items, string[] col, string[] operation,             string[] values)         {             if (col.Length != operation.Length || operation.Length != values.Length)             {                 throw new SqliteException("col.Length != operation.Length != values.Length");             }              string query = "SELECT " + items[0];             for (int i = 1; i < items.Length; ++i)             {                 query += ", " + items[i];             }              query += " FROM " + tableName + " WHERE " + col[0] + operation[0] + "'" + values[0] + "' ";             for (int i = 1; i < col.Length; ++i)             {                 query += " AND " + col[i] + operation[i] + "'" + values[i] + "' ";             }              return ExecuteQuery(query);         }          /// <summary>         /// 按条件查询数据 param tableName=表名 items=查询字段 col=查找字段  values=内容         /// </summary>         public SqliteDataReader SelectWhere(string tableName, string[] items, string[] col, string[] values)         {             if (col.Length != values.Length)             {                 throw new SqliteException("col.Length != values.Length");             }              string query = "SELECT " + items[0];             for (int i = 1; i < items.Length; ++i)             {                 query += ", " + items[i];             }              query += " FROM " + tableName + " WHERE " + col[0] + "=" + "'" + values[0] + "' ";             for (int i = 1; i < col.Length; ++i)             {                 query += " AND " + col[i] + "=" + "'" + values[i] + "' ";             }              return ExecuteQuery(query);         }          #endregion          #region 按条件查询 单个字段数据          /// <summary>         ///  查询表         /// </summary>         /// <param name="tableName">表名</param>         /// <param name="col">查找字段</param>         /// <param name="operation">运算符</param>         /// <param name="values">内容</param>         /// <returns></returns>         public SqliteDataReader Select(string tableName, string col, string operation, string values)         {             string query = "SELECT * FROM " + tableName + " WHERE " + col + " " + operation + " " +                            string.Format("'{0}'", values);             return ExecuteQuery(query);         }          /// <summary>         /// 查询表         /// </summary>         /// <param name="tableName">表名</param>         /// <param name="col">查找字段</param>         /// <param name="values">内容</param>         /// <returns></returns>         public SqliteDataReader Select(string tableName, string col, string values)         {             string query = "SELECT * FROM " + tableName + " WHERE " + col + " = " + string.Format("'{0}'", values);             return ExecuteQuery(query);         }          #endregion          #region 升序查询/降序查询/查询表行数/查询表全部数据          /// <summary>         /// 升序查询         /// </summary>         public SqliteDataReader SelectOrderASC(string tableName, string col)         {             string query = "SELECT * FROM " + tableName + " ORDER BY " + col + " ASC";             return ExecuteQuery(query);         }          /// <summary>         /// 降序查询         /// </summary>         public SqliteDataReader SelectOrderDESC(string tableName, string col)         {             string query = "SELECT * FROM " + tableName + " ORDER BY " + col + " DESC";             return ExecuteQuery(query);         }          /// <summary>         /// 查询表行数         /// </summary>         public SqliteDataReader SelectCount(string tableName)         {             string query = "SELECT COUNT(*) FROM " + tableName;             return ExecuteQuery(query);         }          /// <summary>         /// 查询表中全部数据 param tableName=表名          /// </summary>         public SqliteDataReader ReadFullTable(string tableName)         {             string query = "SELECT * FROM " + tableName;             return ExecuteQuery(query);         }          #endregion          /// <summary>         /// 执行SQL语句 用于SelectWhere查询语句         /// </summary>         /// <param name="sqlQuery"></param>         /// <returns></returns>         public SqliteDataReader ExecuteQuery(string sqlQuery)         {             Debug.Log("ExecuteQuery:: " + sqlQuery);             cmd = conn.CreateCommand();             cmd.CommandText = sqlQuery;             try             {                 reader = cmd.ExecuteReader();             }             catch (Exception e)             {                  Debug.LogError(e);                 return null;             }              return reader;         }          #endregion     } }

2.屏幕截图，获取图片的base64字节流

3.将pdf文件转成base64字节流插入数据库

4.完整代码如下：

using System; using System.Collections; using System.Collections.Generic; using System.IO; using System.Threading.Tasks; using Cysharp.Threading.Tasks; using Imdork.SQLite; using Manager; using Tool; using UnityEngine; using UnityEngine.UI;  public class SQLiteManager : MonoSingleton<SQLiteManager> {     #region 数据基本设置      /// <summary>     /// 数据库名称     /// </summary>     [Header("数据库名称")] public string UseTableName = "UseTable";      /// <summary>     /// 数据库路径     /// </summary>     private string UseTablePath;      [HideInInspector] public List<DataBase> dataList;      /// <summary>     /// 打印层相机     /// </summary>     public Camera printCamera;      /// <summary>     /// 所有图片更新GO     /// </summary>     public List<GameObject> AllTables;      /// <summary>     /// 截图路径     /// </summary>     string _path = Application.streamingAssetsPath + "/PrintImage/Screenshot";      string pathPDF = Application.streamingAssetsPath + @"\test.pdf"; //要打印的目标图片      private List<string> allImagePath;      private Coroutine _CreatPDF;     private GameObject curGO;     Rect rect;     RenderTexture rt;      void Awake()     {         rect = new Rect(0, 0, 1920, 1080);         rt = new RenderTexture((int)rect.width, (int)rect.height, 0);         UseTablePath = "Data Source = " + Application.streamingAssetsPath + "/" + UseTableName;     }      public void Start()     {         for (int i = 0; i < AllTables.Count; i++)         {             AllTables[i].SetActive(false);         }          ToInsertData();     }      void ToInsertData()     {         DataBase curDataBase = new DataBase();         curDataBase.ProjectName = "我是测试项目";         curDataBase.UserName = "测试";         curDataBase.UserID = "000000000000000000";         curDataBase.Time = DateTime.Now.ToString("yyyy年MM月dd日 HH:mm");         PrintImage(curDataBase);     }      /// <summary>     /// 读取配置文件  账号登录     /// </summary>     /// <param name="path"></param>     /// <param name="callBack"></param>     /// <returns></returns>     private bool ReadData(string path, Action<string> callBack)     {         if (!File.Exists(path))         {             return false;         }          var str = File.ReadAllText(path);         callBack?.Invoke(str);         return true;     }      #endregion      #region 用户信息表格      /// <summary>     /// 获取当前用户的所有信息     /// </summary>     public void GetAllUseData()     {         GetDB(db =>         {             var reader = db.ReadFullTable("UserData");              List<DataBase> _userDatas = SQLiteUtility.GetDataValues(reader);             dataList.Clear();             if (_userDatas != null)             {                 for (int i = 0; i < _userDatas.Count; i++)                 {                     if (_userDatas[i].UserID == "000000000000000000")                     {                         dataList.Add(_userDatas[i]);                     }                 }             }         });     }      /// <summary>     /// 插入当前患者数据     /// </summary>     /// <param name="curUserData"></param>     public void InsertUserData(DataBase curUserData)     {         GetDB(db =>         {             db.InsertInto("UserData", GetSingleUserData(curUserData));             if (_CreatPDF != null) StopCoroutine(_CreatPDF);         });     }      /// <summary>     /// 将单个userdata数据拼接成字符串  按照数据库表顺序     /// </summary>     /// <param name="curUserData"></param>     /// <returns></returns>     String[] GetSingleUserData(DataBase curUserData)     {         List<string> strList = new List<string>();          strList.Add(curUserData.UserName);         strList.Add(curUserData.UserID);         strList.Add(curUserData.ProjectName);         strList.Add(curUserData.Time);         strList.Add(curUserData.PrintImage);          return strList.ToArray();     }      #endregion       /// <summary>     /// 调用数据库     /// </summary>     /// <param name="action"></param>     public void GetDB(Action<DbAccess> action)     {         //Path数据库文件，一定是StreamingAssets文件夹下 填写的路径文件不需要填写.db后缀         //创建数据库读取类         SQLiteHelper helper = new SQLiteHelper(UseTablePath);         //打开数据库 存储数据库操作类         using (var db = helper.Open())         {             //调用数据库委托             action(db);         }         /*          因为每次使用数据 添/删/改/查 都需要使用完后Close掉          重复代码，写无数次太麻烦 因为数据库操作类 继承了IDisposable接口 所以，          using会自动关闭数据库连接，我们无需手动关闭数据库          */     }       private void OnDestroy()     {         GetDB(db => db.Dispose());     }      #region 截图  打印      /// <summary>     /// 截图     /// </summary>     public async void PrintImage(DataBase _dataBase)     {         Debug.LogError(_dataBase.ProjectName);         for (int i = 0; i < AllTables.Count; i++)         {             Debug.LogError(AllTables[i].name);             if (_dataBase.ProjectName.Contains(AllTables[i].name))             {                 AllTables[i].SetActive(true);                 curGO = AllTables[i];             }             else             {                 AllTables[i].SetActive(false);             }         }          allImagePath = new List<string>();         Debug.LogError(curGO.transform.childCount);         for (int i = 0; i < curGO.transform.childCount; i++)         {             allImagePath.Add(_path + i + ".png");             ScreenTool(_path + i + ".png");             await Task.Delay(500);             curGO.transform.GetChild(i).gameObject.SetActive(false);         }          _CreatPDF = StartCoroutine(CreatPDF(_dataBase));     }      /// <summary>     /// 截图     /// </summary>     /// <param name="path"></param>     async void ScreenTool(string path)     {         printCamera.targetTexture = rt;         printCamera.Render();         RenderTexture.active = rt;         Texture2D _screenShot = new Texture2D((int)rect.width, (int)rect.height, TextureFormat.RGBA32, false);         _screenShot.ReadPixels(rect, 0, 0);         _screenShot.Apply();         await UniTask.Yield(PlayerLoopTiming.LastPostLateUpdate);         printCamera.targetTexture = null;         RenderTexture.active = null;         var bytes = _screenShot.EncodeToPNG();         await File.WriteAllBytesAsync(path, bytes);         Debug.LogError($"截屏了一张照片: {path}");     }      /// <summary>     /// 创建pdf     /// </summary>     /// <param name="_dataBase"></param>     /// <returns></returns>     public IEnumerator CreatPDF(DataBase _dataBase)     {         using (PDFReport pdf = new PDFReport())         {             yield return pdf.Init(pathPDF);             for (int i = 0; i < allImagePath.Count; i++)             {                 pdf.AddImage(allImagePath[i]);             }         }          yield return new WaitForSeconds(0.2f);         string strBase = System.Convert.ToBase64String(File.ReadAllBytes(pathPDF));         _dataBase.PrintImage = strBase;         InsertUserData(_dataBase);         Debug.Log("创建成功打开文件:" + pathPDF);     }      #endregion }

五、将本地图片文件上传至服务器，服务器返回一个图片文件下载地址，通过下载地址下载对应的图片文件

注解：在这里需要一个后台服务器用来储存文件地址并返回下载地址，所以在此直接做成一个工具类，调用接口直接传服务器请求URL和本地文件路径：

using System; using System.IO; using System.Net; using System.Text; using UnityEngine;  public static class HttpTool {     /// <summary>     /// Http上传文件     /// </summary>     /// <param name="url">服务器地址</param>     /// <param name="path">文件路径</param>     /// <returns>服务器返回的文件下载地址</returns>     public static string HttpUploadFile(string url, string path)     {         HttpWebRequest request = WebRequest.Create(url) as HttpWebRequest;         CookieContainer cookieContainer = new CookieContainer();         request.CookieContainer = cookieContainer;         request.AllowAutoRedirect = true;         request.Method = "POST";         string boundary = DateTime.Now.Ticks.ToString("X"); // 随机分隔线         request.ContentType = "multipart/form-data;charset=utf-8;boundary=" + boundary;         byte[] itemBoundaryBytes = Encoding.UTF8.GetBytes("\r\n--" + boundary + "\r\n");         byte[] endBoundaryBytes = Encoding.UTF8.GetBytes("\r\n--" + boundary + "--\r\n");         int pos = path.LastIndexOf("\\");         string fileName = path.Substring(pos + 1);          StringBuilder sbHeader = new StringBuilder(string.Format("Content-Disposition:form-data;name=\"file\";filename=\"{0}\"\r\nContent-Type:application/octet-stream\r\n\r\n", fileName));         byte[] postHeaderBytes = Encoding.UTF8.GetBytes(sbHeader.ToString());          FileStream fs = new FileStream(path, FileMode.Open, FileAccess.Read);         byte[] bArr = new byte[fs.Length];         fs.Read(bArr, 0, bArr.Length);         fs.Close();          Stream postStream = request.GetRequestStream();         postStream.Write(itemBoundaryBytes, 0, itemBoundaryBytes.Length);         postStream.Write(postHeaderBytes, 0, postHeaderBytes.Length);         postStream.Write(bArr, 0, bArr.Length);         postStream.Write(endBoundaryBytes, 0, endBoundaryBytes.Length);         postStream.Close();         HttpWebResponse response = request.GetResponse() as HttpWebResponse;         Stream instream = response.GetResponseStream();         StreamReader sr = new StreamReader(instream, Encoding.UTF8);         string content = sr.ReadToEnd();         DataShellStr _data = JsonUtility.FromJson<DataShellStr>(content);//这里需要序列化，获取后台返回的文件下载地址         Debug.Log(content);         return _data.data;     }      }