Files

215 lines
11 KiB
C#
Executable File

using Microsoft.Extensions.DependencyInjection;
using Newtonsoft.Json;
using Newtonsoft.Json.Linq;
using Opsoft.Data;
using Opsoft.NetCore.O3App.Domain;
using Opsoft.NetCore.O3App.Domain.Interface;
using Opsoft.NetCore.O3App.Domain.Models.ESOP;
using Opsoft.NetCore.O3App.Domain.UnitOfWork.ESOP.ESOP;
using Opsoft.NetCore.O3App.Domain.UnitOfWork.ESOP.IRepositories;
using Opsoft.NetCore.O3App.Domain.UnitOfWork.ESOP.IServices;
using Opsoft.NetCore.O3App.Domain.UnitOfWork.ESOP.Model;
using Opsoft.NetCore.O3App.Services.CommonFunction;
using Opsoft.NetCore.O3App.Shared;
using System;
using System.Collections;
using System.Collections.Generic;
using System.Data;
using System.IO;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
namespace Opsoft.NetCore.O3App.Services.ESOP
{
[MapTo(typeof(IESOPService), ServiceLifetime.Transient)]
public class ESOPService : ServiceBase<BaseEntity, IESOPRepository>, IESOPService
{
public ESOPService(IESOPRepository repository) : base(repository)
{
Init(repository);
}
/// <summary>
/// 获取文件信息
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public async Task<object> GetAnnounceAndFile(ESOPRequest request)
{
APPServerContext context = new APPServerContext(LoginInfo.DBAias, LoginInfo.UserID);
JObject returnJobject = new JObject();
returnJobject.Add("FTIME", DateTime.Now);
string sql = string.Empty;
#region 广播通知获取
JArray announceArray = new JArray();
returnJobject.Add("Announces", announceArray);
DataTable announceTable = context.Database.SqlQuery($@"SELECT T01.* FROM T_BD_ESOPNOTIFUCATION T01 INNER JOIN T_BD_ESOPNOTIFUCATIONENTRY T02 ON T01.FINTERID = T02.FINTERID
WHERE T01.FSTARTTIME<='{DateTime.Now}' AND T01.FDEADLINE>='{DateTime.Now}' AND T02.FSTATIONID= '{request.FSTATIONID}' ");
foreach (DataRow row in announceTable.Rows)
{
JObject tem = new JObject();
tem.Add("FTEXT", row["FTEXT"].ToStringEx());
announceArray.Add(tem);
}
#endregion 广播通知获取
List<T_SFC_WORKFILEMANAGE> workFileManageList = new List<T_SFC_WORKFILEMANAGE>();
///下发获取
if (request.FMode == 2)
{
sql = $@"SELECT C.*
FROM T_BD_ESOPTEMPDATA A
LEFT JOIN T_BD_ESOPTEMPDATA_ENTRY B ON A.FINTERID=B.FINTERID
INNER JOIN T_SFC_WORKFILEMANAGE C ON B.FFILEID=C.FINTERID
WHERE A.FSTATIONID='{request.FSTATIONID}' AND B.FSTARTTIME<='{DateTime.Now}' AND B.FENDTIME>='{DateTime.Now}'";
workFileManageList = await context.Database.SqlQueryAsync<T_SFC_WORKFILEMANAGE>(sql);
}
//主动获取
else if (request.FMode == 1)
{
//通过资源和工序识别码查资源现况表
DataTable table = context.Database.SqlQuery($@"SELECT * FROM T_SFC_RESOURCEWORKSTATEENTRY
WHERE FINTERID ='{request.FRESOURCEID}' AND FCODE='{request.FCODE}'");
if (table.Rows != null && table.Rows.Count > 0)
{
DataTable flowcardTable = context.Database.SqlQuery($@"SELECT T01.FPROCESSID,T02.FPROROUTEID FROM T_SFC_FLOWCARDENTRY T01 LEFT JOIN T_SFC_FLOWCARD T02 ON T01.FINTERID = T02.FINTERID
WHERE T01.FCODE='{request.FCODE}'");
if (flowcardTable.Rows != null && flowcardTable.Rows.Count > 0)
{
string fProcessID = flowcardTable.Rows[0]["FPROCESSID"].ToStringEx();
string fProRouteID = flowcardTable.Rows[0]["FPROROUTEID"].ToStringEx();
sql = $@"SELECT * FROM T_SFC_WORKFILEMANAGE WHERE FPROROUTEID='{fProRouteID}' AND FPROCESSID ='{fProcessID}'";
workFileManageList = await context.Database.SqlQueryAsync<T_SFC_WORKFILEMANAGE>(sql);
}
else
{
throw new O3AppException($@"不存在工序识别码为:{request.FCODE}的工序流转卡");
}
}
else
{
throw new O3AppException($@"资源编码:{request.FRESOURCENUMBER} 名称:{request.FRESOURCENAME},不存在工序识别码为:{request.FCODE}的生产活动");
}
}
string strErr = string.Empty;
foreach (var tem in workFileManageList)
{
tem.FIPPATH = Path.Combine(Path.Combine(GetCompleteUrl(), "src"), tem.FSERVICEFILEPATH).Replace("\\", "/");
CheckFilePath(tem.FIPPATH, context, ref strErr);
}
if (!strErr.IsNullOrEmpty())
{
throw new O3AppException(strErr);
}
returnJobject.Add("Files", JsonConvert.DeserializeObject<JArray>(JsonConvert.SerializeObject(workFileManageList)));
return returnJobject;
}
/// <summary>
/// (作业文件)验证文件是否存在,不存在则下载
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
private void CheckFilePath(string filepath, APPServerContext context, ref string strErr)
{
if (!UrlIsExist(filepath))//如果文件不存在的话那么从文件服务器上下载
{
//首先拼出文件服务器中的地址
string IISFilePath = filepath;
string prefixURL = GetCompleteUrl();
string relativePath = IISFilePath.Replace(prefixURL + "/src", "").Replace("/", "\\");//相对路径地址
Hashtable PBCursor = context.PBValue("WFMUpload,C,;");
//图片所在文件服务器中的路径
string FileServerFilePath = Path.Combine(PBCursor["WFMUpload"].ToStringEx(), relativePath.Substring(1, relativePath.Length - 1));
string IISAbsolutePath = Path.Combine(Path.Combine(Directory.GetCurrentDirectory(), "wwwroot"), relativePath.Substring(1, relativePath.Length - 1));//在IIS服务器中实际路径
//判断文件是否已经存在了,存在才能上
//上传服务器IP地址
string serverIP = context.Database.SqlQueryString("SELECT FVALUE FROM SYS_DEPARAMETERS WHERE FNUMBER = 'FileServerUrl' ");
if (serverIP.IsNullOrEmpty())
{
serverIP = "http://127.0.0.1";
}
FileUpDownInfo myUpInfo = new FileUpDownInfo()
{
SourceFullPath = FileServerFilePath,
TargetFullPath = IISAbsolutePath,
ServerIP = serverIP
};
//上传图片
FileHelper.WebDownLoadFile(myUpInfo);
}
}
/// <summary>
/// 判断Url是否存在
/// </summary>
/// <param name="URL"></param>
/// <returns></returns>
static bool UrlIsExist(string URL)
{
try
{
System.Net.WebRequest request = System.Net.WebRequest.Create(URL);
request.Timeout = 10000;
System.Net.WebResponse response = request.GetResponse();
return true;
}
catch
{
return false;
}
}
/// <summary>
/// 获取当前Url地址的前缀
/// </summary>
/// <returns></returns>
private string GetCompleteUrl()
{
return new StringBuilder()
.Append(Context.Request.Scheme)
.Append("://")
.Append(Context.Request.Host)
.Append(Context.Request.PathBase)
.ToString();
}
/// <summary>
/// 根据工位编码获取资源以及工序识别码信息
/// </summary>
/// <param name="stationCode"></param>
/// <returns></returns>
public async Task<ESopStationResponse> GetSourceAndCode(string stationCode)
{
APPServerContext context = new APPServerContext(LoginInfo.DBAias, LoginInfo.UserID);
ESopStationResponse eSopStationResponse = new ESopStationResponse();
var dataTable = context.Database.SqlQuery($@"SELECT A.FINTERID StationId,A.FNUMBER,A.FNAME,B.FINTERID,C.FCODE,D.FNUMBER SourceNumber,D.FNAME SourceName
FROM T_BD_ESOPSTATION A
LEFT JOIN T_ENG_RESOURCEENTRY6 B ON A.FINTERID=B.FSTATIONID
LEFT JOIN T_SFC_RESOURCEWORKSTATEENTRY C ON B.FINTERID=C.FINTERID
LEFT JOIN T_ENG_RESOURCE D ON B.FINTERID=D.FINTERID
WHERE A.FNUMBER='{stationCode}'");
if (dataTable != null && dataTable.Rows.Count > 0)
{
eSopStationResponse = new ESopStationResponse
{
StationId = dataTable.Rows[0]["StationId"].ToStringEx(),
StationNumber = dataTable.Rows[0]["FNUMBER"].ToStringEx(),
StationName = dataTable.Rows[0]["FNAME"].ToStringEx(),
SourceInfoList = dataTable.AsEnumerable().Where(t => !t["FINTERID"].IsNullOrEmpty()).GroupBy(t => t["FINTERID"].ToStringEx()).Select(t => new SourceResopnse
{
SourceId = t.Key,
SourceNumber = t.FirstOrDefault()?["SourceNumber"].ToStringEx(),
SourceName = t.FirstOrDefault()?["SourceName"].ToStringEx(),
ProcessCodeInfoList = t.Where(u => !u["FCODE"].IsNullOrEmpty()).GroupBy(u => u["FCODE"].ToStringEx()).Select(u => new ProcessCodeInfo
{
ProcessCode = u.Key
}).ToList()
}).ToList()
};
}
return eSopStationResponse;
}
}
}