96 lines
4.7 KiB
C#
Executable File
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;
|
|
//}
|
|
|
|
}
|
|
}
|