public static bool UploadImage(string base64String, string path, string fileName, string pageID, string ownerID, Boolean thumbnail = true)
{
bool flag = false;
try
{
byte[] fs = Convert.FromBase64String(base64String);
//fileName = Guid.NewGuid().ToString().Replace("-", "") + "." + fileName.Split('.')[1];
//获取上传案例图片路径
string fullpath = System.Web.HttpContext.Current.Server.MapPath(path);
//string fullpath = @"D:\Work\yaodaibao\Code\Release\Files";/// 调试用
if (!Directory.Exists(fullpath))
{
Directory.CreateDirectory(fullpath);
}
//定义并实例化一个内存流，以存放提交上来的字节数组。
MemoryStream m = new MemoryStream(fs);
//定义实际文件对象，保存上载的文件。
FileStream f = new FileStream(fullpath + "\\" + fileName, FileMode.Create);
//把内内存里的数据写入物理文件
m.WriteTo(f);
if (thumbnail)
{
System.Drawing.Image originalImage = System.Drawing.Image.FromStream(m);
System.Drawing.Image img = GetThumbnail(originalImage, 80, 50);
img.Save(fullpath + "\\" + "T_" + fileName);
img = null;
originalImage = null;
}
m.Close();
f.Close();
f = null;
m = null;
string sql = "";
sql = "INSERT INTO Attachments(FPageID,FOwnerID,FFileName,FPath)VALUES('" + pageID + "','" + ownerID + "','" + fileName + "','" + path + "')";
SQLServerHelper runner = new SQLServerHelper();
runner.ExecuteSqlNone(sql);
runner = null;
flag = true;
}
catch (Exception ex)
{
throw ex;
}
return(flag);
}
public static void WriteToDB(string log, string type = "AppMessage", string caller = "", string method = "", string database = "yaodaibao")
{
try
{
string sql = "Insert Into " + database + ".dbo.AppLogs(FCaller,FMethod,FLog,FType)Values('{0}','{1}','{2}','{3}')";
sql = string.Format(sql, caller, method, log.Replace("'", "''"), type);
SQLServerHelper runner = new SQLServerHelper();
runner.ExecuteSqlNone(sql);
runner = null;
}
catch (Exception err)
{
throw err;
}
}
/// <summary>
/// 保存文件
/// </summary>
/// <param name="base64String">文件base64</param>
/// <param name="path">保存路径</param>
/// <param name="fileID">文件ID</param>
/// <param name="sql">保存完成之后需要执行的sql</param>
/// <param name="connectStr">连接字符串</param>
/// <returns></returns>
public static bool UploadFile(string base64String, string path, long fileID, string sql = "", string connectStr = "")
{
bool flag = false;
try
{
byte[] fs = Convert.FromBase64String(base64String);
if (!Directory.Exists(path))
{
Directory.CreateDirectory(path);
}
//定义并实例化一个内存流，以存放提交上来的字节数组。
MemoryStream m = new MemoryStream(fs);
//定义实际文件对象，保存上载的文件。
FileStream f = new FileStream(path + "\\" + fileID, FileMode.Create);
//把内存里的数据写入物理文件
m.WriteTo(f);
m.Close();
f.Close();
f = null;
m = null;
if (sql != "" && connectStr != "")
{
SQLServerHelper runner = new SQLServerHelper(connectStr);
runner.ExecuteSqlNone(sql);
}
else if (sql != "" && connectStr == "")
{
SQLServerHelper runner = new SQLServerHelper();
runner.ExecuteSqlNone(sql);
}
flag = true;
}
catch (Exception ex)
{
throw ex;
}
return(flag);
}