/// <summary>
/// 数据显示及保存
/// </summary>
/// <param name="operate">操作事件</param>
/// <param name="itemId">项目id</param>
/// <param name="oldPath">老图路径</param>
/// <param name="newPath">新图路径</param>
/// <param name="status">状态</param>
/// <param name="summary">摘要</param>
public void WriteMessage(int operate, string itemId, string oldPath, string newPath, int status, string summary)
{
SnowflakeIdWorker snowflakeIdWorker = new SnowflakeIdWorker(1, 1);
Data_TempCopy tempCopyData = new Data_TempCopy();
tempCopyData.Id = snowflakeIdWorker.NextId().ToString();
tempCopyData.OperateKey = _OperateKey;
tempCopyData.Operate = operate;
tempCopyData.ItemId = itemId;
tempCopyData.OldPath = oldPath;
tempCopyData.NewPath = newPath;
tempCopyData.Status = status;
tempCopyData.Summary = summary;
tempCopyData.CreateDate = DateTime.Now;
if (status == 0)
{
int index = this._dataGV.Rows.Add();
this._dataGV.Rows[index].Cells[0].Value = tempCopyData.Id;
this._dataGV.Rows[index].Cells[1].Value = tempCopyData.OperateKey;
this._dataGV.Rows[index].Cells[2].Value = OperatebyEmun((int)tempCopyData.Operate);
this._dataGV.Rows[index].Cells[3].Value = tempCopyData.ItemId;
this._dataGV.Rows[index].Cells[4].Value = tempCopyData.OldPath;
this._dataGV.Rows[index].Cells[5].Value = tempCopyData.NewPath;
this._dataGV.Rows[index].Cells[6].Value = StatusbyEmun((int)tempCopyData.Status);
this._dataGV.Rows[index].Cells[7].Value = tempCopyData.Summary;
this._dataGV.Rows[index].Cells[8].Value = tempCopyData.CreateDate;
}
else
{
using (var context = new DataModelEntities())
{
context.Data_TempCopy.Add(tempCopyData);
int index = this._dataGV.Rows.Add();
this._dataGV.Rows[index].Cells[0].Value = tempCopyData.Id;
this._dataGV.Rows[index].Cells[1].Value = tempCopyData.OperateKey;
this._dataGV.Rows[index].Cells[2].Value = OperatebyEmun((int)tempCopyData.Operate);
this._dataGV.Rows[index].Cells[3].Value = tempCopyData.ItemId;
this._dataGV.Rows[index].Cells[4].Value = tempCopyData.OldPath;
this._dataGV.Rows[index].Cells[5].Value = tempCopyData.NewPath;
this._dataGV.Rows[index].Cells[6].Value = StatusbyEmun((int)tempCopyData.Status);
this._dataGV.Rows[index].Cells[7].Value = tempCopyData.Summary;
this._dataGV.Rows[index].Cells[8].Value = tempCopyData.CreateDate;
//context.SaveChangesAsync();
context.SaveChanges();
}
}
this._dataGV.FirstDisplayedScrollingRowIndex = this._dataGV.Rows[this._dataGV.Rows.Count - 1].Index;
}
/// <summary>
/// 当前项目
/// </summary>
/// <param name="itemid">项目ID</param>
/// <param name="fileSrcStr">加密的文件路径</param>
public void DataUpdata(string itemid, string fileSrcStr)
{
try
{
using (var context = new DataModelEntities())
{
var itemData = context.Web_ItemLibrary.FirstOrDefault(o => o.ItemId.Equals(itemid));
if (itemData != null)
{
itemData.ItemFilePath = fileSrcStr;
context.SaveChanges();
}
}
}
catch (Exception ex)
{
Console.WriteLine("Failed with error info: {0}", ex.Message);
MessageBox.Show(string.Format("保存数据出错！{0}", ex.Message));
}
}
private void imgTextResourceObj(List <Web_UserBuildingCircle> data)
{
//var domainData = data.Where(o => !string.IsNullOrEmpty(o.ResourceObj) && o.FirstTitleImg.Contains(_domainOne)).ToList();
List <CallbackUploadInfo> callbackUploadInfos = new List <CallbackUploadInfo>();
foreach (var item in data)
{
CallbackUploadInfo callbackUploadInfo = new CallbackUploadInfo();
string url = item.FirstTitleImg.Split('?').FirstOrDefault();
callbackUploadInfo.smallImgUrl = url + smallImg;
callbackUploadInfo.bigImgUrl = url + string.Format(bigImg, 90);
callbackUploadInfos.Add(callbackUploadInfo);
// 保存数据
try
{
using (var context = new DataModelEntities())
{
var itemData = context.Web_UserBuildingCircle.FirstOrDefault(o => o.TalkId.Equals(item.TalkId));
if (itemData != null)
{
itemData.ResourceObj = callbackUploadInfos.Count == 0 ? null : callbackUploadInfos.ToJson();
itemData.TalkTitle = itemData.TalkTitle.Equals("NULL") ? null : itemData.TalkTitle;
context.SaveChanges();
}
}
}
catch (Exception ex)
{
Console.WriteLine("Failed with error info: {0}", ex.Message);
MessageBox.Show(string.Format("保存数据出错！{0}", ex.Message));
}
}
}
/// <summary>
/// 当前项目
/// </summary>
/// <param name="itemid">项目ID</param>
/// <param name="itemContent">项目内容数据</param>
/// <param name="callback">9宫格对象</param>
public void DataUpdata(string itemid, string itemContent, List <CallbackUploadInfo> callback)
{
try
{
using (var context = new DataModelEntities())
{
var itemData = context.Web_ItemLibrary.FirstOrDefault(o => o.ItemId.Equals(itemid));
if (itemData != null)
{
itemData.ItemContentBefore = itemContent;
itemData.ResourceObj = callback.Count == 0 ? null : callback.ToJson();
context.SaveChanges();
}
}
}
catch (Exception ex)
{
Console.WriteLine("Failed with error info: {0}", ex.Message);
MessageBox.Show(string.Format("保存数据出错！{0}", ex.Message));
}
}
private void videoPro(List <Web_UserBuildingCircle> data)
{
Stopwatch watch = new Stopwatch();
watch.Start();
//过来只有在服务器上的数据https://www.pic.jzbl.com
var domainData = data.Where(o => o.FirstTitleImg.Contains(_domain)).ToList();
string domainOSSFirstTitlet = string.Empty;
foreach (var item in domainData)
{
//处理封面图片数据
string filePath = item.FirstTitleImg.ToLower()
.Replace(_domain, _D)
.Replace(_itemfiles.ToLower(), ItemImages.ToLower())
.Replace('/', '\\').ToLower();
if (filePath.Contains(_nS))
{
filePath = filePath.Replace(_nS, "\\");
//判断/s/里面的图片是否带 Ori_
string tempFilePath = filePath.Replace(filePath.Split('\\').LastOrDefault(), "Ori_" + filePath.Split('\\').LastOrDefault());
if (File.Exists(tempFilePath))
{
filePath = tempFilePath;
}
}
//判断文件是否存在
if (File.Exists(filePath))
{
var fileInfo = new System.IO.FileInfo(filePath);
if (fileInfo.Length >= ImgLeng)
{
CompressImg.PicCompress(filePath);
}
// 移动操作
string ossImgPath = filePath
.Replace(ItemImages.ToLower(), _itemfiles.ToLower())
.Remove(0, 3)
.Replace('\\', '/').ToLower();
//处理带Ori的数据
if (ossImgPath.Contains("Ori_".ToLower()))
{
ossImgPath = ossImgPath.Replace("Ori_".ToLower(), "");
}
this.OssUpload(ossImgPath, filePath, ref infoStatus);
domainOSSFirstTitlet = _domainOne + ossImgPath + firstTitletImg;
}
//处理 对象数据
var obj = item.ResourceObj.ToList <CallbackUploadInfo>();
List <CallbackUploadInfo> callbackUploadInfos = new List <CallbackUploadInfo>();
if (obj != null)
{
foreach (var itemRes in obj)
{
string filePathRes = itemRes.smallImgUrl
.Replace(_domain, _D)
.Replace(_itemfiles.ToLower(), ItemImages.ToLower())
.Replace('/', '\\').ToLower();
if (filePathRes.Contains(_nS))
{
filePathRes = filePathRes.Replace(_nS, "\\");
//判断/s/里面的图片是否带 Ori_
string tempFilePath = filePathRes.Replace(filePathRes.Split('\\').LastOrDefault(), "Ori_" + filePathRes.Split('\\').LastOrDefault());
if (File.Exists(tempFilePath))
{
filePathRes = tempFilePath;
}
//判断文件是否存在
if (File.Exists(filePathRes))
{
var fileInfo = new System.IO.FileInfo(filePathRes);
if (fileInfo.Length >= ImgLeng)
{
CompressImg.PicCompress(filePathRes);
}
// 移动操作
string ossImgPath = filePathRes
.Replace(ItemImages.ToLower(), _itemfiles.ToLower())
.Remove(0, 3)
.Replace('\\', '/').ToLower();
//处理带Ori的数据
if (ossImgPath.Contains("Ori_".ToLower()))
{
ossImgPath = ossImgPath.Replace("Ori_".ToLower(), "");
}
this.OssUpload(ossImgPath, filePathRes, ref infoStatus);
CallbackUploadInfo callback = new CallbackUploadInfo();
string ossPro = string.Empty;
if (fileInfo.Length >= 500000)
{
ossPro = string.Format(bigImg, 20);
}
else if (fileInfo.Length >= 400000)
{
ossPro = string.Format(bigImg, 30);
}
else if (fileInfo.Length >= 300000)
{
ossPro = string.Format(bigImg, 40);
}
else if (fileInfo.Length >= 200000)
{
ossPro = string.Format(bigImg, 50);
}
else if (fileInfo.Length >= 100000)
{
ossPro = string.Format(bigImg, 90);
}
else
{
ossPro = string.Format(bigImg, 100);
}
string ossUrl = _domainOne + ossImgPath + ossPro;
callback.smallImgUrl = _domainOne + ossImgPath + smallImg;
callback.bigImgUrl = ossUrl;
callback.fileName = itemRes.fileName;
callbackUploadInfos.Add(callback);
}
}
}
}
// 保存数据
try
{
using (var context = new DataModelEntities())
{
var itemData = context.Web_UserBuildingCircle.FirstOrDefault(o => o.TalkId.Equals(item.TalkId));
if (itemData != null)
{
itemData.FirstTitleImg = domainOSSFirstTitlet;
itemData.ResourceObj = callbackUploadInfos.Count == 0 ? null : callbackUploadInfos.ToJson();
itemData.TalkContent = string.IsNullOrEmpty(itemData.TalkContent.Trim()) ? itemData.TalkTitle : itemData.TalkContent;
itemData.TalkTitle = string.IsNullOrEmpty(itemData.TalkTitle) ? null : "NULL";
context.SaveChanges();
}
}
}
catch (Exception ex)
{
Console.WriteLine("Failed with error info: {0}", ex.Message);
MessageBox.Show(string.Format("保存数据出错！{0}", ex.Message));
}
if (this.InvokeRequired)
{
this.Invoke(new DelegateWriteMessage(_comm.WriteMessage), new object[] { 2, item.TalkId, filePath, infoStatus.OldPath, infoStatus.iStatus, infoStatus.Summary });
this.Invoke(new DelegateCurrent(_comm.Current), new object[] { 1, item.TalkId });
this.Invoke(new DelegateTimeCost(_comm.TimeCost), new object[] { watch.Elapsed.ToString() });
}
else
{
_comm.WriteMessage(2, item.TalkId, filePath, infoStatus.OldPath, infoStatus.iStatus, infoStatus.Summary);
_comm.Current(1, item.TalkId);
_comm.TimeCost(watch.Elapsed.ToString());
}
}
}
private void imgTextPro(List <Web_UserBuildingCircle> data)
{
Stopwatch watch = new Stopwatch();
watch.Start();
//过来只有在服务器上的数据
var domainData = data.Where(o => !string.IsNullOrEmpty(o.FirstTitleImg) && o.FirstTitleImg.Contains(_domain)).ToList();
string domainOSSFirstTitlet = string.Empty;
foreach (var item in domainData)
{
infoStatus.Summary = "处理再" + _domain + "域名数据";
//处理封面图片数据
string filePath = item.FirstTitleImg.ToLower()
.Replace(_domain, _D)
.Replace(_itemfiles.ToLower(), ItemImages.ToLower())
.Replace('/', '\\').ToLower();
if (filePath.Contains(_nS))
{
filePath = filePath.Replace(_nS, "\\");
//判断/s/里面的图片是否带 Ori_
string tempFilePath = filePath.Replace(filePath.Split('\\').LastOrDefault(), "Ori_" + filePath.Split('\\').LastOrDefault());
if (File.Exists(tempFilePath))
{
filePath = tempFilePath;
}
}
//判断文件是否存在
if (File.Exists(filePath))
{
var fileInfo = new System.IO.FileInfo(filePath);
if (fileInfo.Length >= ImgLeng)
{
CompressImg.PicCompress(filePath);
}
// 移动操作
string ossImgPath = filePath
.Replace(ItemImages.ToLower(), _itemfiles.ToLower())
.Remove(0, 3)
.Replace('\\', '/').ToLower();
//处理带Ori的数据
if (ossImgPath.Contains("Ori_".ToLower()))
{
ossImgPath = ossImgPath.Replace("Ori_".ToLower(), "");
}
this.OssUpload(ossImgPath, filePath, ref infoStatus);
domainOSSFirstTitlet = _domainOne + ossImgPath + firstTitletImg;
}
//处理 对象数据
var obj = item.ResourceObj.ToList <CallbackUploadInfo>();
List <CallbackUploadInfo> callbackUploadInfos = new List <CallbackUploadInfo>();
if (obj != null)
{
foreach (var itemRes in obj)
{
string filePathRes = itemRes.smallImgUrl
.Replace(_domain, _D)
.Replace(_itemfiles.ToLower(), ItemImages.ToLower())
.Replace('/', '\\').ToLower();
if (filePathRes.Contains(_nS))
{
filePathRes = filePathRes.Replace(_nS, "\\");
//判断/s/里面的图片是否带 Ori_
string tempFilePath = filePathRes.Replace(filePathRes.Split('\\').LastOrDefault(), "Ori_" + filePathRes.Split('\\').LastOrDefault());
if (File.Exists(tempFilePath))
{
filePathRes = tempFilePath;
}
//判断文件是否存在
if (File.Exists(filePathRes))
{
var fileInfo = new System.IO.FileInfo(filePathRes);
if (fileInfo.Length >= ImgLeng)
{
CompressImg.PicCompress(filePathRes);
}
// 移动操作
string ossImgPath = filePathRes
.Replace(ItemImages.ToLower(), _itemfiles.ToLower())
.Remove(0, 3)
.Replace('\\', '/').ToLower();
//处理带Ori的数据
if (ossImgPath.Contains("Ori_".ToLower()))
{
ossImgPath = ossImgPath.Replace("Ori_".ToLower(), "");
}
this.OssUpload(ossImgPath, filePathRes, ref infoStatus);
CallbackUploadInfo callback = new CallbackUploadInfo();
string ossPro = string.Empty;
if (fileInfo.Length >= 500000)
{
ossPro = string.Format(bigImg, 20);
}
else if (fileInfo.Length >= 400000)
{
ossPro = string.Format(bigImg, 30);
}
else if (fileInfo.Length >= 300000)
{
ossPro = string.Format(bigImg, 40);
}
else if (fileInfo.Length >= 200000)
{
ossPro = string.Format(bigImg, 50);
}
else if (fileInfo.Length >= 100000)
{
ossPro = string.Format(bigImg, 90);
}
else
{
ossPro = string.Format(bigImg, 100);
}
string ossUrl = _domainOne + ossImgPath + ossPro;
callback.smallImgUrl = _domainOne + ossImgPath + "?x-oss-process=image/quality,q_90/resize,w_400";
callback.bigImgUrl = ossUrl;
callback.fileName = itemRes.fileName;
callbackUploadInfos.Add(callback);
}
}
}
}
// 保存数据
try
{
using (var context = new DataModelEntities())
{
var itemData = context.Web_UserBuildingCircle.FirstOrDefault(o => o.TalkId.Equals(item.TalkId));
if (itemData != null)
{
itemData.FirstTitleImg = domainOSSFirstTitlet;
itemData.ResourceObj = callbackUploadInfos.Count == 0 ? null : callbackUploadInfos.ToJson();
itemData.TalkContent = string.IsNullOrEmpty(itemData.TalkContent.Trim()) ? itemData.TalkTitle : itemData.TalkContent;
itemData.TalkTitle = string.IsNullOrEmpty(itemData.TalkTitle) ? null : "NULL";
context.SaveChanges();
}
}
}
catch (Exception ex)
{
Console.WriteLine("Failed with error info: {0}", ex.Message);
MessageBox.Show(string.Format("保存数据出错！{0}", ex.Message));
}
if (this.InvokeRequired)
{
this.Invoke(new DelegateWriteMessage(_comm.WriteMessage), new object[] { 2, item.TalkId, filePath, infoStatus.OldPath, infoStatus.iStatus, infoStatus.Summary });
this.Invoke(new DelegateCurrent(_comm.Current), new object[] { 1, item.TalkId });
this.Invoke(new DelegateTimeCost(_comm.TimeCost), new object[] { watch.Elapsed.ToString() });
}
else
{
_comm.WriteMessage(2, item.TalkId, filePath, infoStatus.OldPath, infoStatus.iStatus, infoStatus.Summary);
_comm.Current(1, item.TalkId);
_comm.TimeCost(watch.Elapsed.ToString());
}
}
// 修改https://www.pic1.jzbl.com 的后缀
var domainOneData = data.Where(o => !string.IsNullOrEmpty(o.FirstTitleImg) && o.FirstTitleImg.Contains(_domainOne)).ToList();
// var domainOneData = data.Where(o =>o.TalkId.Equals("615a6f97-4fda-439a-b5c4-3b0e708bce13")).ToList();
foreach (var itemOne in domainOneData)
{
infoStatus.Summary = "处理再" + _domainOne + "域名数据";
List <CallbackUploadInfo> callbackUploadInfos = new List <CallbackUploadInfo>();
//处理oss图片有后缀的，只压缩图片就行
if (itemOne.FirstTitleImg.Split('.').LastOrDefault().ToLower().Equals("jpg"))
{
domainOSSFirstTitlet = itemOne.FirstTitleImg + firstTitletImg;
//处理 对象数据
var obj = itemOne.ResourceObj.ToList <CallbackUploadInfo>();
if (obj != null)
{
foreach (var itemRes in obj)
{
CallbackUploadInfo callback = new CallbackUploadInfo();
string ossPro = string.Empty;
ossPro = string.Format(bigImg, 90);
string ossUrl = itemRes.smallImgUrl + ossPro;
callback.smallImgUrl = itemRes.smallImgUrl + "?x-oss-process=image/quality,q_90/resize,w_400";
callback.bigImgUrl = ossUrl;
callback.fileName = itemRes.fileName;
callbackUploadInfos.Add(callback);
}
}
infoStatus.Summary = "处理oss图片有后缀的，只压缩图片就行";
}
else
{
string sourcekey = itemOne.FirstTitleImg.Replace(_domainOne, "");
string targetkey = sourcekey + ".jpg";
CopyObject(bucketName, sourcekey, bucketName, targetkey);
domainOSSFirstTitlet = _domainOne + targetkey;
//处理 对象数据
var obj = itemOne.ResourceObj.ToList <CallbackUploadInfo>();
if (obj != null)
{
foreach (var itemRes in obj)
{
CallbackUploadInfo callback = new CallbackUploadInfo();
string sourcekeylist = itemRes.smallImgUrl.Replace(_domainOne, "");
string targetkeylist = sourcekeylist + ".jpg";
CopyObject(bucketName, sourcekeylist, bucketName, targetkeylist);
string ossPro = string.Empty;
ossPro = string.Format(bigImg, 90);
string ossUrl = itemRes.smallImgUrl + ossPro;
callback.smallImgUrl = itemRes.smallImgUrl + "?x-oss-process=image/quality,q_90/resize,w_400";
callback.bigImgUrl = ossUrl;
callback.fileName = itemRes.fileName;
callbackUploadInfos.Add(callback);
}
}
infoStatus.Summary = "处理oss图片没有后缀，先拷贝，再删除原图";
}
// 保存数据
try
{
using (var context = new DataModelEntities())
{
var itemData = context.Web_UserBuildingCircle.FirstOrDefault(o => o.TalkId.Equals(itemOne.TalkId));
if (itemData != null)
{
itemData.FirstTitleImg = domainOSSFirstTitlet;
itemData.ResourceObj = callbackUploadInfos.Count == 0 ? null : callbackUploadInfos.ToJson();
itemData.TalkContent = string.IsNullOrEmpty(itemData.TalkContent.Trim()) ? itemData.TalkTitle : itemData.TalkContent;
itemData.TalkTitle = string.IsNullOrEmpty(itemData.TalkTitle) ? null : "NULL";
context.SaveChanges();
}
}
}
catch (Exception ex)
{
Console.WriteLine("Failed with error info: {0}", ex.Message);
MessageBox.Show(string.Format("保存数据出错！{0}", ex.Message));
}
if (this.InvokeRequired)
{
this.Invoke(new DelegateWriteMessage(_comm.WriteMessage), new object[] { 2, itemOne.TalkId, "---------", infoStatus.OldPath, infoStatus.iStatus, infoStatus.Summary });
this.Invoke(new DelegateCurrent(_comm.Current), new object[] { 1, itemOne.TalkId });
this.Invoke(new DelegateTimeCost(_comm.TimeCost), new object[] { watch.Elapsed.ToString() });
}
else
{
_comm.WriteMessage(2, itemOne.TalkId, "---------", infoStatus.OldPath, infoStatus.iStatus, infoStatus.Summary);
_comm.Current(1, itemOne.TalkId);
_comm.TimeCost(watch.Elapsed.ToString());
}
}
}