Files

96 lines
4.7 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.UnitOfWork.ESOP.ESOP;
using Opsoft.NetCore.O3App.Domain.UnitOfWork.ESOP.IRepositories;
using Opsoft.NetCore.O3App.Domain.UnitOfWork.ESOP.Model;
using Opsoft.NetCore.O3App.Shared;
using System;
using System.Collections.Generic;
using System.Data;
using System.IO;
using System.Threading.Tasks;
namespace Opsoft.NetCore.O3App.Repositories.ESOP
{
[MapTo(typeof(IESOPRepository), ServiceLifetime.Transient)]
public class ESOPRepository : RepositoryBase<BaseEntity>, IESOPRepository
{
//public ESOPRepository() : base()
//{
//}
///// <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}'";
// 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. 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}的生产活动");
// }
// }
// returnJobject.Add("Files", JsonConvert.DeserializeObject<JArray>(JsonConvert.SerializeObject(workFileManageList)));
// return returnJobject;
//}
}
}