1612 lines
85 KiB
C#
Executable File
1612 lines
85 KiB
C#
Executable File
using Microsoft.Extensions.DependencyInjection;
|
||
using Newtonsoft.Json.Linq;
|
||
using Opsoft.Data;
|
||
using Opsoft.NetCore.O3App.Domain;
|
||
using Opsoft.NetCore.O3App.Domain.Interface;
|
||
using Opsoft.NetCore.O3App.Domain.UnitOfWork.IPadReport.IRepositories;
|
||
using Opsoft.NetCore.O3App.Domain.UnitOfWork.IPadReport.Model;
|
||
using Opsoft.NetCore.O3App.Shared;
|
||
using System;
|
||
using System.Collections;
|
||
using System.Collections.Generic;
|
||
using System.Data;
|
||
using System.Linq;
|
||
|
||
namespace Opsoft.NetCore.O3App.Repositories.IPadReport
|
||
{
|
||
/// <summary>
|
||
/// 汇报信息检查验证底层实现
|
||
/// </summary>
|
||
[MapTo(typeof(IReportCheckRepository), ServiceLifetime.Transient)]
|
||
public class ReportCheckRepository : RepositoryBase<BaseEntity>, IReportCheckRepository
|
||
{
|
||
/// <summary>
|
||
/// 无参构造
|
||
/// </summary>
|
||
public ReportCheckRepository() : base()
|
||
{ }
|
||
|
||
#region 判断资源是否唯一登录
|
||
/// <summary>
|
||
/// 判断资源是否唯一登录
|
||
/// </summary>
|
||
/// <param name="xAPServer"></param>
|
||
/// <param name="phoneID"></param>
|
||
/// <param name="resourceNO"></param>
|
||
/// <returns></returns>
|
||
public Dictionary<string, string> JudgeResourceIsUsed(string phoneID, string resourceNO)
|
||
{
|
||
//APserver
|
||
using APPServerContext xAPServer = new APPServerContext(LoginInfo.DBAias, LoginInfo.UserID);
|
||
//返回值
|
||
Dictionary<string, string> retDicData = new Dictionary<string, string>();
|
||
string SQL = string.Format(@"
|
||
SELECT
|
||
S.FINTERID
|
||
,S.FCOMPUTERID
|
||
,S.FDELETED
|
||
,S.FSTANDPRO
|
||
,S.FSTOCKID
|
||
,S.FSTOCKLOCID
|
||
,S1.FCOMPUTERID AS FSTATECOMPUTERID
|
||
,S2.FINTERID AS FREINTERID
|
||
,S3.FINTERID AS FWORKCENTERID
|
||
FROM T_ENG_RESOURCE S
|
||
LEFT JOIN T_SFC_RESOURCEWORKSTATE S1 ON S1.FINTERID=S.FINTERID --AND S1.FCOMPUTERID=S.FCOMPUTERID
|
||
LEFT JOIN T_SFC_REPORT S2 ON S2.FINTERID=S1.FREPORTID
|
||
LEFT JOIN T_ENG_WORKCENTERENTRY S3 ON S3.FRESOURCEID=S.FINTERID
|
||
WHERE S.FNUMBER='{0}'", resourceNO);
|
||
DataTable dtResult = xAPServer.Database.SqlQuery(SQL);
|
||
if (dtResult == null || dtResult.Rows.Count <= 0)
|
||
{
|
||
throw new O3AppException($"{resourceNO}资源信息未找到!", 404);
|
||
}
|
||
if (dtResult.Rows[0]["FDELETED"].ToBoolean())
|
||
{
|
||
throw new O3AppException($"{resourceNO}资源信息已被禁用!", 404);
|
||
}
|
||
DataRow dataRow = dtResult.Rows[0];
|
||
if (dataRow["FCOMPUTERID"].ToStringEx().IsNullOrEmpty())
|
||
{
|
||
xAPServer.Database.SqlNonQueryAsync($@"UPDATE T_ENG_RESOURCE SET FCOMPUTERID='{phoneID}' WHERE FINTERID='{dataRow["FINTERID"].ToStringEx()}'");
|
||
}
|
||
else
|
||
{
|
||
if (!dataRow["FCOMPUTERID"].ToStringEx().Equals(phoneID))
|
||
{
|
||
throw new O3AppException($"{resourceNO}当前资源已在别处汇报平台打开!", 404);
|
||
}
|
||
}
|
||
|
||
retDicData = new Dictionary<string, string> {
|
||
{ "resourceID",dataRow["FINTERID"].ToStringEx()},
|
||
{ "standPro",dataRow["FSTANDPRO"].ToStringEx()},
|
||
{ "stockID",dataRow["FSTOCKID"].ToStringEx()},
|
||
{ "spID",dataRow["FSTOCKLOCID"].ToStringEx()},
|
||
{ "workStateID",dataRow["FINTERID"].ToStringEx()},
|
||
{ "reportID",dataRow["FREINTERID"].ToStringEx()},
|
||
{ "workCenterID",dataRow["FWORKCENTERID"].ToStringEx()}
|
||
};
|
||
|
||
return retDicData;
|
||
}
|
||
#endregion
|
||
|
||
#region 检查是否可以排到此资源
|
||
/// <summary>
|
||
/// 检查是否可以排到此资源
|
||
/// </summary>
|
||
/// <param name="wType">1=工序识别码,2=流转卡行内吗</param>
|
||
/// <param name="wValue">传入值</param>
|
||
/// <param name="fResID">资源内码</param>
|
||
public void CanResourceUse(int wType, string wValue, string fResID, string resourceNO)
|
||
{
|
||
//APserver
|
||
using APPServerContext xAPServer = new APPServerContext(LoginInfo.DBAias, LoginInfo.UserID);
|
||
DataTable dtResult = null;
|
||
//1=工作中心 2=资源
|
||
string WhereSQL = "";
|
||
switch (wType)
|
||
{
|
||
case 1:
|
||
dtResult = ProcessHandleRepository.GetReportData(xAPServer, 1, wValue);
|
||
WhereSQL = string.Format("A.FCODE='{0}'", wValue);
|
||
break;
|
||
case 2:
|
||
dtResult = ProcessHandleRepository.GetReportData(xAPServer, 2, wValue);
|
||
WhereSQL = string.Format("A.FDETAILID='{0}'", wValue);
|
||
break;
|
||
}
|
||
if (dtResult != null && dtResult.Rows.Count > 0)
|
||
{
|
||
if (dtResult.Rows[0]["FISALLOWCENTEREMPTY"].ToBoolean())
|
||
{
|
||
return;
|
||
}
|
||
}
|
||
#region 注释代码
|
||
//string SQL = string.Format(@" SELECT 1
|
||
// FROM T_SFC_FLOWCARDENTRY3(NOLOCK) T
|
||
// LEFT JOIN T_SFC_FLOWCARDENTRY(NOLOCK) T1 ON T.FBODYID= T1.FDETAILID
|
||
// LEFT JOIN T_ENG_WORKCENTERENTRY(NOLOCK) T2 ON T.FWORKRESOURCEID=T2.FINTERID
|
||
// WHERE T.FTYPEID= '1' AND {0} AND T2.FRESOURCEID= '{1}'
|
||
// UNION
|
||
// SELECT 1
|
||
// FROM
|
||
// T_SFC_FLOWCARDENTRY3(NOLOCK) T
|
||
// LEFT JOIN T_SFC_FLOWCARDENTRY(NOLOCK) T1 ON T.FBODYID= T1.FDETAILID
|
||
// WHERE T.FTYPEID= '2' AND {0} AND T.FWORKRESOURCEID= '{1}' ",
|
||
// WhereSQL, fResID);
|
||
//DataTable TemTable = xAPServer.Database.SqlQuery(SQL);
|
||
//if (TemTable.Rows.Count == 0)
|
||
//{
|
||
// throw new O3AppException("当前流转卡未排到此资源", 400);
|
||
//}
|
||
#endregion
|
||
string SQL = $@" SELECT C.FINTERID FROM dbo.T_SFC_FLOWCARDENTRY A
|
||
INNER JOIN dbo.T_SFC_FLOWCARDENTRY3 B ON A.FDETAILID=B.FBODYID AND B.FTYPEID=2
|
||
INNER JOIN dbo.T_ENG_RESOURCE C ON B.FWORKRESOURCEID=C.FINTERID
|
||
WHERE {WhereSQL}
|
||
UNION ALL
|
||
SELECT D.FINTERID FROM dbo.T_SFC_FLOWCARDENTRY A
|
||
INNER JOIN dbo.T_SFC_FLOWCARDENTRY3 B ON A.FDETAILID=B.FBODYID AND B.FTYPEID=1
|
||
INNER JOIN dbo.T_ENG_WORKCENTERENTRY C ON B.FWORKRESOURCEID=C.FINTERID
|
||
INNER JOIN dbo.T_ENG_RESOURCE D ON C.FRESOURCEID=D.FINTERID
|
||
WHERE {WhereSQL}";
|
||
DataTable TemTable = xAPServer.Database.SqlQuery(SQL);
|
||
if (TemTable == null || TemTable.Rows.Count < 1)
|
||
{
|
||
throw new O3AppException($"资源【{resourceNO}】:工序流转卡未设置汇报资源!", 400);
|
||
}
|
||
if (TemTable.Select($"FINTERID='{fResID}'").Count() < 1)
|
||
{
|
||
throw new O3AppException($"资源【{resourceNO}】:工序流转卡设置的汇报资源与当前资源不匹配!", 400);
|
||
}
|
||
}
|
||
#endregion
|
||
|
||
#region 检查模具是否在流转卡中绑定
|
||
/// <summary>
|
||
/// 检查模具是否在流转卡中绑定
|
||
/// </summary>
|
||
/// <param name="moudleData"></param>
|
||
/// <param name="reportMsg"></param>
|
||
public void CheckMouldInFlowCard(List<Basic> moudleData, ProductionAct reportMsg)
|
||
{
|
||
//APserver
|
||
using APPServerContext xAPServer = new APPServerContext(LoginInfo.DBAias, LoginInfo.UserID);
|
||
|
||
//验证模具状态是否正确,应该为无计划或休息
|
||
List<Basic> listErrorMould = xAPServer.Database.SqlQuery<Basic>(
|
||
string.Format(@" SELECT
|
||
FINTERID AS FID
|
||
,FNUMBER AS FNO
|
||
,FNAME
|
||
,FCOMPANYID
|
||
FROM T_ENG_MOULDANDJIG
|
||
WHERE (FMOULDSTATUS!=1 AND FMOULDSTATUS!=3) AND FINTERID IN ('" + string.Join("','", moudleData.Select(o => o.FID).ToList()) + "') ")).ToList();
|
||
if (listErrorMould.Count > 0)
|
||
{
|
||
throw new O3AppException($"模具信息【{string.Join("','", listErrorMould.Select(o => o.FNO).ToList())}】正在使用中,不能上模", 500);
|
||
}
|
||
//验证模具寿命是否大于0
|
||
List<Basic> listLifeMould = xAPServer.Database.SqlQuery<Basic>(
|
||
string.Format(@" SELECT
|
||
FINTERID AS FID
|
||
,FNUMBER AS FNO
|
||
,FNAME
|
||
,FCOMPANYID
|
||
FROM T_ENG_MOULDANDJIG
|
||
WHERE FREMAINLIFE<=0 AND FINTERID IN ('" + string.Join("','", moudleData.Select(o => o.FID).ToList()) + "') ")).ToList();
|
||
if (listLifeMould.Count > 0)
|
||
{
|
||
throw new O3AppException($"模具信息【{string.Join("','", listLifeMould.Select(o => o.FNO).ToList())}】寿命已扣为0,不能上模", 500);
|
||
}
|
||
//工序流转卡模具查询
|
||
DataTable dtResult = xAPServer.Database.SqlQuery(@"SELECT FMOULDID FROM T_SFC_FLOWCARDENTRY2
|
||
WHERE FBODYID='" + reportMsg.FFlowCardDetailID + "' ");
|
||
if (dtResult == null || dtResult.Rows.Count <= 0)
|
||
{
|
||
throw new O3AppException("当前工序流转卡未绑定模具信息", 500);
|
||
}
|
||
foreach (var sub in moudleData)
|
||
{
|
||
if (dtResult.Select("FMOULDID='" + sub.FID + "'").Length <= 0)
|
||
{
|
||
throw new O3AppException($"当前工序流转卡未绑定模具【{sub.FNAME}】信息", 500);
|
||
}
|
||
}
|
||
|
||
//检验是否已经上模
|
||
if (reportMsg.MouldInfos.Count > 0)
|
||
{
|
||
foreach (var sub in reportMsg.MouldInfos)
|
||
{
|
||
if (!sub.FENDTIME.HasValue && moudleData.Exists(o => o.FID.Equals(sub.FINTERID)))
|
||
{
|
||
throw new O3AppException($"模具信息【{sub.FNAME}】已上模", 500);
|
||
}
|
||
}
|
||
}
|
||
reportMsg.FMouldCount = dtResult.Rows.Count;
|
||
}
|
||
#endregion
|
||
|
||
#region 投料信息检查
|
||
/// <summary>
|
||
/// 投料信息检查
|
||
/// </summary>
|
||
/// <param name="paramaters"></param>
|
||
/// <param name="reportMsg"></param>
|
||
public Dictionary<string, object> CheckUseMaterialInfo(JObject paramaters, ProductionAct reportMsg)
|
||
{
|
||
#region 变量定义
|
||
//APserver
|
||
using APPServerContext xAPServer = new APPServerContext(LoginInfo.DBAias, LoginInfo.UserID);
|
||
int seq = 1, barType = paramaters["barType"].ToInt();
|
||
string fMaterialID = string.Empty, fUnitID = string.Empty, fAuxPropID = string.Empty, SQL = string.Empty,
|
||
fBarCodeNO = paramaters["barCode"].ToStringEx(), fBatchNO = paramaters["fBatchNO"].ToStringEx();
|
||
decimal fQty = paramaters["fQty"].ToDecimal();
|
||
|
||
var barcodeTD = CheckMaterialSn(xAPServer, fBarCodeNO);
|
||
if (barcodeTD == null || barcodeTD.Rows.Count <= 0)
|
||
{
|
||
throw new O3AppException($"该条码信息在条码表中未找到", 404);
|
||
}
|
||
#endregion
|
||
SQL = string.Format(@" SELECT
|
||
T.FMATERIALID,
|
||
T2.FTYPEID
|
||
FROM T_PRD_PPBOMENTRY T(NOLOCK)
|
||
LEFT JOIN T_PRD_PPBOM T1(NOLOCK) ON T.FINTERID=T1.FINTERID
|
||
LEFT JOIN T_BD_MATERIAL T2(NOLOCK) ON T.FMATERIALID= T2.FINTERID
|
||
WHERE T.FOPERID='{0}' AND T1.FMOENTRYID='{1}'
|
||
GROUP BY T.FMATERIALID, T2.FTYPEID",
|
||
reportMsg.FProcessID, reportMsg.FMODETAILID);
|
||
DataTable resultDT = xAPServer.Database.SqlQuery(SQL);
|
||
if (resultDT == null || resultDT.Rows.Count <= 0)
|
||
{
|
||
throw new O3AppException($"当前工序在投料单中未设定物料信息", 404);
|
||
}
|
||
//物料内码
|
||
fMaterialID = barcodeTD.Rows[0]["FMATERIALID"].ToStringEx();
|
||
//辅助属性
|
||
//fAuxPropID = barcodeTD.Rows[0]["FAUXPROPID"].ToStringEx();
|
||
//单位内码
|
||
fUnitID = barcodeTD.Rows[0]["FUNITID"].ToStringEx();
|
||
switch (barType)
|
||
{
|
||
case 2://系统条码
|
||
if (barcodeTD.Rows[0]["FBARTYPE"].ToStringEx().Equals("3") && !barcodeTD.Rows[0]["FLOT"].ToStringEx().Equals(fBatchNO))
|
||
{
|
||
//3=批次条码
|
||
throw new O3AppException($"该条码对应的批号和条码表中不同", 500);
|
||
}
|
||
if (resultDT.Select("FMATERIALID='" + barcodeTD.Rows[0]["FMATERIALID"].ToStringEx() + "'").Length <= 0)
|
||
{
|
||
throw new O3AppException($"该条码对应的物料不在工序投料清单中", 404);
|
||
}
|
||
else
|
||
{
|
||
SQL = string.Format(@"
|
||
SELECT
|
||
FSEQ,
|
||
FQTY,
|
||
FOUTQTY
|
||
FROM T_SFC_REPORTENTRY3
|
||
WHERE FCODE='{0}' AND FMBARCODE='{1}'", reportMsg.FCode, fBarCodeNO);
|
||
DataTable cursor = xAPServer.Database.SqlQuery(SQL);
|
||
if (cursor != null && cursor.Rows.Count > 0)
|
||
{
|
||
if (!barcodeTD.Rows[0]["FBARTYPE"].ToStringEx().Equals("3"))
|
||
{
|
||
throw new O3AppException($"该条码信息在工序投料表中已存在,不能重复扫描!", 500);
|
||
}
|
||
else
|
||
{
|
||
seq = cursor.AsEnumerable().Max(s => Convert.ToInt32(s.Field<int>("FSEQ"))) + 1;
|
||
}
|
||
}
|
||
else
|
||
{
|
||
seq = 1;
|
||
}
|
||
}
|
||
break;
|
||
case 3://非系统条码
|
||
if (!string.IsNullOrEmpty(fBarCodeNO))
|
||
{
|
||
string maxSeq = xAPServer.Database.SqlQueryString(string.Format(@"SELECT MAX(FSEQ) FROM T_SFC_REPORTENTRY3(NOLOCK) WHERE FCODE='{0}' AND FMBARCODE='{1}'", reportMsg.FCode, fBarCodeNO));
|
||
if (!string.IsNullOrEmpty(maxSeq))
|
||
{
|
||
seq = Convert.ToInt32(maxSeq) + 1;
|
||
}
|
||
}
|
||
break;
|
||
default:
|
||
throw new O3AppException($"当前条码类型不支持!", 404);
|
||
}
|
||
//返回值定义
|
||
Dictionary<string, object> returnData = new Dictionary<string, object>() {
|
||
{"FMATERIALID" ,fMaterialID},
|
||
{"FUNITID" ,fUnitID},
|
||
{"FAUXPROPID" ,fAuxPropID},
|
||
{"FSEQ" ,seq}
|
||
};
|
||
|
||
return returnData;
|
||
}
|
||
#endregion
|
||
|
||
/// <summary>
|
||
/// 检查物料条码状态
|
||
/// </summary>
|
||
/// <param name="sn"></param>
|
||
/// <param name="msg"></param>
|
||
/// <returns></returns>
|
||
internal DataTable CheckMaterialSn(APPServerContext xAPServer, string sn)
|
||
{
|
||
|
||
string sqlWip = $@"SELECT A.FWIPCODE,
|
||
A.FQTY,
|
||
A.FMATERIALID,
|
||
B.FNUMBER,
|
||
B.FNAME,
|
||
B.FPRODUCEUNITID AS FUNITID,
|
||
A.FQUALITYSTATUS,
|
||
A.FBATCHNO AS FLOT,
|
||
A.FBARSTATUS,
|
||
2 AS FBARTYPE
|
||
FROM T_SFC_BARCODEWIP A
|
||
LEFT JOIN T_BD_MATERIAL B
|
||
ON A.FMATERIALID = B.FINTERID
|
||
WHERE FWIPCODE = '{sn}'; ";
|
||
try
|
||
{
|
||
var wipDt = xAPServer.Database.SqlQuery(sqlWip);
|
||
if (wipDt.Rows.Count > 0)
|
||
{
|
||
if (wipDt.Rows[0]["FQUALITYSTATUS"].ToInt() == 1)
|
||
{
|
||
throw new O3AppException("在制品不合格,不可投入", 404);
|
||
}
|
||
if (wipDt.Rows[0]["FBARSTATUS"].ToInt() == 3)
|
||
{
|
||
throw new O3AppException("在制品已消耗,不可投入", 404);
|
||
}
|
||
return wipDt;
|
||
}
|
||
else
|
||
{
|
||
string sqlSNRS = $@"SELECT A.FBARTYPE,A.FISBOX,A.FISMIX,A.FBARCODESTATUS,
|
||
A.FLOT,
|
||
A.FQUALITYSTATUS,
|
||
B.FCHECKINCOMING,
|
||
A.FQTY,
|
||
A.FKFDATE,
|
||
B.FISKFPERIOD,
|
||
B.FKFPERIOD,
|
||
A.FAUXPROPID,
|
||
A.FMATERIALID,
|
||
B.FPRODUCEUNITID AS FUNITID,
|
||
A.FUSEFULDATE ,
|
||
B.FNUMBER,
|
||
B.FNAME,
|
||
A.FSTOCKSTATUS,
|
||
A.FSTOCKID,
|
||
A.FSTOCKLOCID,
|
||
C.FISVIRTUAL
|
||
FROM T_BD_BARCODERS(NOLOCK) A
|
||
LEFT JOIN T_BD_MATERIAL(NOLOCK) B
|
||
ON A.FMATERIALID = B.FINTERID
|
||
LEFT JOIN dbo.T_BD_STOCK(NOLOCK) C
|
||
ON A.FSTOCKID = C.FINTERID
|
||
WHERE A.FBARCODE = '{sn}';";
|
||
var dt = xAPServer.Database.SqlQuery(sqlSNRS);
|
||
if (dt == null || dt.Rows.Count < 1)
|
||
{
|
||
throw new O3AppException("物料条码不存在", 404);
|
||
}
|
||
else
|
||
{
|
||
if (dt.Rows[0]["FISKFPERIOD"].ToBoolean() && dt.Rows[0]["FUSEFULDATE"].ToDateTime() < DateTime.Now)
|
||
{
|
||
throw new O3AppException("该物料已过保质期", 404);
|
||
}
|
||
if (dt.Rows[0]["FCHECKINCOMING"].ToBoolean() && dt.Rows[0]["FQUALITYSTATUS"].ToInt() != 1)
|
||
{
|
||
throw new O3AppException("该物料未经检验或检验不合格", 404);
|
||
}
|
||
if (dt.Rows[0]["FISMIX"].ToBoolean())
|
||
{
|
||
throw new O3AppException("目前不支持混装条码投料", 404);
|
||
}
|
||
//if (!isUseLineWareHouse)
|
||
//{
|
||
// if (dt.Rows[0]["FSTOCKSTATUS"].ToInt() != 2 && dt.Rows[0]["FSTOCKSTATUS"].ToInt() != 4)
|
||
// {
|
||
// throw new O3AppException("当前条码非出库状态,不可投料!";
|
||
// }
|
||
//}
|
||
//else
|
||
//{
|
||
// if (dt.Rows[0]["FSTOCKSTATUS"].ToInt() != 1)
|
||
// {
|
||
// throw new O3AppException("当前条码不是入库状态,不可投料!";
|
||
// }
|
||
//}
|
||
if (dt.Rows[0]["FBARCODESTATUS"].ToInt() == 10)
|
||
{
|
||
throw new O3AppException("条码已废弃,不可投入", 404);
|
||
}
|
||
return dt;
|
||
}
|
||
}
|
||
}
|
||
catch (Exception ex)
|
||
{
|
||
throw new O3AppException(ex.Message);
|
||
}
|
||
}
|
||
|
||
#region 汇报前检查首检、巡检状态
|
||
/// <summary>
|
||
/// 汇报前检查首检、巡检状态
|
||
/// </summary>
|
||
/// <param name="moudleData"></param>
|
||
/// <param name="reportMsg"></param>
|
||
public void CheckInspectionStatus(ProductionAct reportMsg)
|
||
{
|
||
//APserver
|
||
using APPServerContext xAPServer = new APPServerContext(LoginInfo.DBAias, LoginInfo.UserID);
|
||
//查询sql
|
||
string SQL = string.Empty;
|
||
#region 是否必须首检
|
||
//必须首检
|
||
if (reportMsg.FIsHeadQC)
|
||
{
|
||
SQL = string.Format(@" SELECT TOP 1 FBILLNO,FTESTRESULT,FSTATUS FROM T_SFC_FIRSTINPECTION WHERE FCODE='{0}' AND FREPORTID='{1}' ORDER BY C_YMD DESC ", reportMsg.FCode, reportMsg.FReportID);
|
||
DataTable dtFirstInp = xAPServer.Database.SqlQuery(SQL);
|
||
if (dtFirstInp.Rows.Count > 0)
|
||
{
|
||
if (dtFirstInp.Rows[0]["FSTATUS"].ToStringEx() != "40")
|
||
{
|
||
throw new O3AppException($"工序必须首检,首检单据没有审核!", 500);
|
||
}
|
||
//FTESTRESULT:1=合格
|
||
if (dtFirstInp.Rows[0]["FTESTRESULT"].ToStringEx() != "1")
|
||
{
|
||
throw new O3AppException($"工序必须首检,首检判定不合格!", 500);
|
||
}
|
||
}
|
||
else
|
||
{
|
||
throw new O3AppException($"工序必须首检,没有首检单!", 500);
|
||
}
|
||
}
|
||
#endregion
|
||
|
||
#region 检查定期巡检
|
||
if (reportMsg.FInspectionCycle > 0)
|
||
{
|
||
//首检算第一次巡检
|
||
SQL = string.Format(@"SELECT FBILLNO FROM T_SFC_PROCESSINPECTION WHERE FWORKTYPE=2 AND FCODE='{0}' AND ISNULL(FTESTRESULT,-1)<>-1 AND DATEDIFF(MINUTE, ISNULL(M_YMD,C_YMD), GetDate())/CONVERT(FLOAT,60)<={1}
|
||
UNION ALL
|
||
SELECT FBILLNO FROM T_SFC_FIRSTINPECTION WHERE FCODE='{0}' AND ISNULL(FTESTRESULT,-1)<>-1 AND DATEDIFF(MINUTE, ISNULL(M_YMD,C_YMD), GetDate())/CONVERT(FLOAT,60)<={1} ", reportMsg.FCode, reportMsg.FInspectionCycle);
|
||
string strValue = xAPServer.Database.SqlQueryString(SQL);
|
||
if (strValue.IsNullOrEmpty())
|
||
{
|
||
throw new O3AppException($"有效期内未找到符合要求的巡检任务!", 500);
|
||
}
|
||
}
|
||
#endregion
|
||
|
||
}
|
||
#endregion
|
||
|
||
#region 工序调机前检查首检方案是否满足条件
|
||
/// <summary>
|
||
/// 工序调机前检查首检方案是否满足条件
|
||
/// </summary>
|
||
/// <param name="fCode"></param>
|
||
public DataTable CheckInspectSolution(ProductionAct reportMsg)
|
||
{
|
||
//返回值
|
||
DataTable returnData = null;
|
||
//APserver
|
||
using APPServerContext xAPServer = new APPServerContext(LoginInfo.DBAias, LoginInfo.UserID);
|
||
//查询sql 首先得到检验方案
|
||
string SQL = string.Format(@" SELECT FISHEADQC,FHEADQCSCHEMEID AS FQCTYPE FROM T_SFC_FLOWCARDENTRY WHERE FCODE='{0}'", reportMsg.FCode);
|
||
DataTable dtResult = xAPServer.Database.SqlQuery(SQL);
|
||
if (dtResult == null || dtResult.Rows.Count <= 0)
|
||
{
|
||
throw new O3AppException($"工序流转卡信息未找到!", 404);
|
||
}
|
||
if (dtResult.Rows[0]["FISHEADQC"].ToBoolean())
|
||
{
|
||
string qcID = dtResult.Rows[0]["FQCTYPE"].ToStringEx();
|
||
if (qcID.IsNullOrEmpty())
|
||
{
|
||
throw new O3AppException("当前工序必须首检,但检查方案信息为空", 500);
|
||
}
|
||
//取得此方案下面的所有检验项目资料
|
||
SQL = string.Format(@"SELECT
|
||
T.FINTERID
|
||
,T.FSAMPLEPLAN
|
||
,T1.FINSPECTITEMID
|
||
,T1.FVALUE
|
||
,T1.FENTRYID
|
||
,T1.FUPPERLIMIT
|
||
,T1.FLWERLIMIT
|
||
,T1.FTESTWAY
|
||
,T1.FANALYSISWAY
|
||
FROM T_QM_INSPECTSOLUTION (NOLOCK) T
|
||
LEFT JOIN T_QM_INSPECTSOLUTIONENTRY(NOLOCK) T1 ON T1.FINTERID=T.FINTERID
|
||
WHERE T.FINTERID='{0}'", qcID);
|
||
returnData = xAPServer.Database.SqlQuery(SQL);
|
||
if (returnData == null || returnData.Rows.Count <= 0)
|
||
{
|
||
throw new O3AppException("当前工序对应的检验方案信息为空", 500);
|
||
}
|
||
}
|
||
return returnData;
|
||
}
|
||
#endregion
|
||
|
||
#region 校验工序流转卡、工单中信息
|
||
/// <summary>
|
||
/// 校验工序流转卡、工单中信息
|
||
/// //0表示工序汇报,1表示完工注销
|
||
/// </summary>
|
||
/// <param name="fCode"></param>
|
||
public DataTable CheckFlowCardInfo(string fCode, int operationType, string resourceNo, bool IsReport = false, ReportClass reportClass = null)
|
||
{
|
||
//APserver
|
||
using APPServerContext xAPServer = new APPServerContext(LoginInfo.DBAias, LoginInfo.UserID);
|
||
//查询sql 首先得到检验方案
|
||
string SQL = string.Format(@" SELECT
|
||
S.FINTERID
|
||
,S.FDETAILID
|
||
,S.FPROCESSID
|
||
,S.FCODE
|
||
,S.FPRODUCTID
|
||
,S.FHANGUP
|
||
,S.FREPORTMODE
|
||
,S.FISCONTROLPLANQTY
|
||
,S.FISCLOSESTATUS
|
||
,S.FSNMODE
|
||
,S.FPRINTMODE
|
||
,S.FISCONTROLORDER
|
||
,S.FPRINTBAD
|
||
,S.FTOTALFINISHQTY
|
||
,S.FOVERRATIO
|
||
,S.FAUXQTY * (ISNULL(S.FOVERRATIO,0) * 0.01 + 1) AS FAUXQTY
|
||
,S.FBOXNUM
|
||
,S.FSTARTMODE
|
||
,S.FPROCESSSTATUS
|
||
,S.FISHEADQC
|
||
,S.FHEADQCSCHEMEID AS FQCTYPE
|
||
,S.FUNITID AS FSEMIPRODUCTUNITID
|
||
,S.FUNITCONVERT
|
||
,S.FQUAQTY
|
||
,S.FISFEED
|
||
,ISNULL((SELECT SUM(FQUAQTY) FROM T_SFC_REPORTENTRY WHERE (FDATATYPE='E' OR FDATATYPE='J') AND FFLOWCARDDETAILID=S.FDETAILID),0) AS REPORTQUAQTY
|
||
,ISNULL((SELECT SUM(FBADQTY) FROM T_SFC_REPORTENTRY WHERE (FDATATYPE='E' OR FDATATYPE='J') AND FFLOWCARDDETAILID=S.FDETAILID),0) AS REPORTBADQTY
|
||
,(SELECT ISNULL(SUM(FQUAQTY),0)+ISNULL(SUM(FBADQTY),0) FROM T_SFC_REPORTENTRY WHERE (FDATATYPE='E' OR FDATATYPE='J') AND FFLOWCARDDETAILID=S.FDETAILID) AS FREPORTQTY
|
||
,S1.FBILLNO AS FFLOWCARDNO
|
||
,ISNULL(S1.FFLOWCLOSE,0) AS FFLOWCLOSE
|
||
,S1.FMODETAILID
|
||
,S1.FMOBILLNO
|
||
,S1.FBATCHNO
|
||
,S1.FUNITID
|
||
,S1.FCOMPANYID
|
||
,S1.FDEPTID
|
||
,S2.FENTRYID AS FMOENTRYID
|
||
,S2.FBSTATUS AS FMOSTATUS
|
||
,S2.FINTERID AS FMOID
|
||
,S2.FAUXPROPID
|
||
,S2.FBASEUNITID
|
||
,S2.FORDERINTERID
|
||
,S2.FORDERENTRYID
|
||
,S2.FORDERDETAILID
|
||
,S2.FTOTALFINISHQTY AS FMOTOTALFINISHQTY
|
||
,S2.FQTY
|
||
,S4.FBILLNO AS FMOBILLNO
|
||
,S3.FKFUNIT
|
||
,S3.FKFPERIOD
|
||
,S5.FCUSTOMERID --订单客户
|
||
FROM T_SFC_FLOWCARDENTRY S (NOLOCK)
|
||
LEFT JOIN T_SFC_FLOWCARD S1 (NOLOCK) ON S1.FINTERID = S.FINTERID
|
||
LEFT JOIN T_PRD_MOENTRY S2 (NOLOCK) ON S2.FDETAILID = S1.FMODETAILID
|
||
LEFT JOIN T_BD_MATERIAL S3 (NOLOCK) ON S3.FINTERID = S1.FPRODUCTID
|
||
LEFT JOIN T_PRD_MO S4 (NOLOCK) ON S4.FINTERID = S2.FINTERID
|
||
LEFT JOIN T_SAL_ORDER S5 (NOLOCK) ON S5.FINTERID = S2.FORDERINTERID
|
||
WHERE S.FCODE='{0}'", fCode);
|
||
DataTable dtResult = xAPServer.Database.SqlQuery(SQL);
|
||
if (dtResult == null || dtResult.Rows.Count <= 0)
|
||
{
|
||
throw new O3AppException($"资源【{resourceNo}】:工序流转卡信息未找到,请检查!", 404);
|
||
}
|
||
else if (dtResult.Select("FHANGUP=1").Length > 0)
|
||
{
|
||
throw new O3AppException($"资源【{resourceNo}】:工序流转卡中存在工序被挂起,请检查!", 500);
|
||
}
|
||
else if (string.IsNullOrEmpty(dtResult.Rows[0]["FFLOWCARDNO"].ToStringEx()))
|
||
{
|
||
throw new O3AppException($"资源【{resourceNo}】:工序流转卡信息未找到,请检查!", 404);
|
||
}
|
||
else if (string.IsNullOrEmpty(dtResult.Rows[0]["FMOBILLNO"].ToStringEx()))
|
||
{
|
||
throw new O3AppException($"资源【{resourceNo}】:生产任务单信息未找到,请检查!", 404);
|
||
}
|
||
else if (operationType == 0 && (dtResult.Rows[0]["FFLOWCLOSE"].ToInt() == 1 || dtResult.Rows[0]["FFLOWCLOSE"].ToInt() == 2))
|
||
{
|
||
throw new O3AppException($"资源【{resourceNo}】:工序流转卡已关闭,请检查!", 500);
|
||
}
|
||
else if (dtResult.Rows[0]["FMOSTATUS"].ToStringEx().Equals("6"))
|
||
{
|
||
throw new O3AppException($"资源【{resourceNo}】:工单已结案,请检查!", 500);
|
||
}
|
||
//汇报的情况,验证下面信息
|
||
if (IsReport)
|
||
{
|
||
switch (dtResult.Rows[0]["FSTARTMODE"].ToInt())
|
||
{
|
||
case 2:
|
||
case 3:
|
||
case 4:
|
||
string sql = $"SELECT SUM(FQTY) as FQTY FROM dbo.T_SFC_REPORTENTRY WHERE FINTERID='{reportClass.FReportID}'";
|
||
var dt = xAPServer.Database.SqlQuery(sql);
|
||
string sqlReport = $"SELECT * FROM dbo.T_SFC_REPORT WHERE FINTERID='{reportClass.FReportID}'";
|
||
var reportDataTable = xAPServer.Database.SqlQuery(sqlReport);
|
||
if (reportDataTable.Rows[0]["FSTARTQTY"].ToDecimal() < reportClass.FBadQty + reportClass.FPassQty + dt.Rows[0]["FQTY"].ToDecimal())
|
||
{
|
||
throw new O3AppException($"资源【{resourceNo}】:汇报数量大于开工数量{reportDataTable.Rows[0]["FSTARTQTY"].ToDecimal()}", 404);
|
||
}
|
||
break;
|
||
default:
|
||
break;
|
||
}
|
||
switch (dtResult.Rows[0]["FPROCESSSTATUS"].ToInt())
|
||
{
|
||
case 0:
|
||
case 1:
|
||
throw new O3AppException($"资源【{resourceNo}】:流转卡未开工,不可汇报", 500);
|
||
case 4:
|
||
throw new O3AppException($"资源【{resourceNo}】:流转卡已委外发出,不可汇报", 500);
|
||
case 9:
|
||
throw new O3AppException($"资源【{resourceNo}】:流转卡已关闭,不可汇报", 500);
|
||
default:
|
||
break;
|
||
}
|
||
int controlPlanQty = dtResult.Rows[0]["FISCONTROLPLANQTY"].ToInt();// 控制计划数量 0=不控制;1=合格数量;2=汇报数量
|
||
decimal auxQty = dtResult.Rows[0]["FAUXQTY"].ToDecimal();//计划生产数量+超产数量
|
||
decimal reportQuaQty = dtResult.Rows[0]["REPORTQUAQTY"].ToDecimal();//已汇报良品数量
|
||
decimal reportBadQty = dtResult.Rows[0]["REPORTBADQTY"].ToDecimal();//已汇报不良品数量
|
||
bool isControlSort = dtResult.Rows[0]["FISCONTROLORDER"].ToBoolean(); // 控制顺序 当道工序汇报数量不能超过上道工序已汇报合格数量
|
||
|
||
|
||
switch (controlPlanQty)
|
||
{//控制计划数量 0=不控制;1=合格数量;2=合格数量+不良数据;3=汇报数量
|
||
case 1:
|
||
if (reportClass.FPassQty > (auxQty - reportQuaQty))
|
||
{
|
||
throw new O3AppException($"资源【{resourceNo}】:本次合格数量 > 计划数量 + 最大可超产数量 - 累计已汇报合格数量!", 500);
|
||
}
|
||
break;
|
||
case 2:
|
||
if ((reportClass.FPassQty + reportClass.FBadQty) > (auxQty - reportQuaQty - reportBadQty))
|
||
{
|
||
throw new O3AppException($"资源【{resourceNo}】:本次汇报数量 > 计划数量 + 最大可超产数量 - 累计已汇报数量!", 500);
|
||
}
|
||
break;
|
||
}
|
||
|
||
if (isControlSort)
|
||
{//控制顺序,当道工序汇报数量不能超过上道工序已汇报合格数量
|
||
//上一道需要汇报的工序
|
||
string frontDetailID = ProcessHandleRepository.GetFrontDetailID(xAPServer, dtResult.Rows[0]["FINTERID"].ToStringEx(), dtResult.Rows[0]["FDETAILID"].ToStringEx(), true, true);
|
||
if (!frontDetailID.IsNullOrEmpty())
|
||
{
|
||
SQL = string.Format(@" SELECT
|
||
FQUAQTY AS FQTY
|
||
FROM T_SFC_FLOWCARDENTRY S
|
||
WHERE FDETAILID='{0}'", frontDetailID);
|
||
DataTable tempTB = xAPServer.Database.SqlQuery(SQL);
|
||
if (tempTB != null && tempTB.Rows.Count > 0)
|
||
{
|
||
if ((reportClass.FPassQty + reportClass.FBadQty + reportQuaQty + reportBadQty) > tempTB.Rows[0]["FQTY"].ToDecimal())
|
||
{
|
||
throw new O3AppException($"资源【{resourceNo}】:此次汇报数量 > 上道工序汇报的合格数量!", 500);
|
||
}
|
||
}
|
||
}
|
||
}
|
||
}
|
||
return dtResult;
|
||
}
|
||
#endregion
|
||
|
||
#region 工序识别码开工
|
||
/// <summary>
|
||
/// 工序识别码开工检验
|
||
/// </summary>
|
||
/// <param name="Fcode"></param>
|
||
public decimal CheckFcode(string Fcode, string resourceNo)
|
||
{
|
||
//APserver
|
||
using APPServerContext xAPServer = new APPServerContext(LoginInfo.DBAias, LoginInfo.UserID);
|
||
string SQL = $@"SELECT FSTARTMODE,FREPORTMODE,FINTERID,FDETAILID,FAUXQTY,FTOTALFINISHQTY FROM T_SFC_FLOWCARDENTRY WHERE FCODE = '{Fcode}'";
|
||
DataTable dtResult = xAPServer.Database.SqlQuery(SQL);
|
||
if (dtResult == null || dtResult.Rows.Count <= 0)
|
||
{
|
||
throw new O3AppException($"资源【{resourceNo}】:输入的工序识别码不存在,请检查!", 404);
|
||
}
|
||
if (dtResult.Rows[0]["FSTARTMODE"].ToInt() == 0)
|
||
{
|
||
throw new O3AppException($"资源【{resourceNo}】:当前流转卡未设置汇报模式,请检查!", 404);
|
||
}
|
||
if (dtResult.Rows[0]["FSTARTMODE"].ToInt() != 1)
|
||
{
|
||
string type = string.Empty;
|
||
switch (dtResult.Rows[0]["FSTARTMODE"].ToInt())
|
||
{
|
||
case 2:
|
||
type = "序列号开工";
|
||
break;
|
||
case 3:
|
||
type = "周转码开工";
|
||
break;
|
||
case 4:
|
||
type = "在制品开工";
|
||
break;
|
||
default:
|
||
break;
|
||
}
|
||
throw new O3AppException($"资源【{resourceNo}】:当前条码属于{type},与识别码开工模式不匹配,请检查!", 404);
|
||
}
|
||
|
||
string beforeflowcarddetailid = ProcessHandleRepository.GetFrontDetailID(xAPServer, dtResult.Rows[0]["FINTERID"].ToString(), dtResult.Rows[0]["FDETAILID"].ToString(), true, true);
|
||
if (!beforeflowcarddetailid.IsNullOrEmpty())
|
||
{
|
||
DataTable beforeflowcard = ProcessHandleRepository.GetReportData(xAPServer, 2, beforeflowcarddetailid);
|
||
if (beforeflowcard != null && beforeflowcard.Rows.Count > 0)
|
||
{
|
||
if (beforeflowcard.Rows[0]["FISOUTSOURCE"].ToInt() == 1 && beforeflowcard.Rows[0]["FISENDQC"].ToBoolean())
|
||
{
|
||
string sql = $"SELECT 1 FROM T_SFC_OUTINPECTION WHERE FFLOWCARDDETAILID='{beforeflowcarddetailid}' AND FDELETED= 0 AND FSTATUS=40";
|
||
var dt = xAPServer.Database.SqlQuery(sql);
|
||
if (dt.Rows.Count < 1)
|
||
{
|
||
throw new O3AppException($"资源【{resourceNo}】:前工序配置委外检验,但是未进行委外检验!", 404);
|
||
}
|
||
}
|
||
if (beforeflowcard.Rows[0]["FISCOURSEQC"].ToBoolean())
|
||
{
|
||
string sql = $"SELECT 1 FROM T_SFC_PROCESSINPECTION WHERE FFLOWCARDDETAILID='{beforeflowcard.Rows[0]["FDETAILID"]}' AND FDELETED= 0 AND FSTATUS=40";
|
||
var dt = xAPServer.Database.SqlQuery(sql);
|
||
if (dt.Rows.Count < 1)
|
||
{
|
||
throw new O3AppException($"资源【{resourceNo}】:前工序配置过程检,但是未进行过程检验!", 404);
|
||
}
|
||
}
|
||
}
|
||
}
|
||
return dtResult.Rows[0]["FAUXQTY"].ToDecimal() - dtResult.Rows[0]["FTOTALFINISHQTY"].ToDecimal();
|
||
}
|
||
#endregion
|
||
|
||
#region 序列号开工/汇报
|
||
/// <summary>
|
||
/// 序列号开工/汇报
|
||
/// </summary>
|
||
/// <param name="SNCode"></param>
|
||
/// <param name="operateType">1=开工,2=汇报</param>
|
||
/// <returns></returns>
|
||
public string CheckSNAndReturnFlowDetailId(string resourceID, string SNCode, int operateType, string resourceNo)
|
||
{
|
||
//APserver
|
||
using APPServerContext xAPServer = new APPServerContext(LoginInfo.DBAias, LoginInfo.UserID);
|
||
//查询sql 得到SN序列号信息
|
||
string SQL = string.Format(@" SELECT
|
||
FSOURCEINTERID
|
||
,FSNSTATUS
|
||
,FQUALITYSTATUS
|
||
,FQTY
|
||
,FISDEPLETE
|
||
,FSTOCKID
|
||
,FSTOCKLOCID
|
||
,FISCHECK
|
||
FROM T_SFC_BARCODESN (NOLOCK)
|
||
WHERE FSNCODE='{0}'", SNCode);
|
||
DataTable dtResult = xAPServer.Database.SqlQuery(SQL);
|
||
if (dtResult == null || dtResult.Rows.Count <= 0)
|
||
{
|
||
throw new O3AppException($"资源【{resourceNo}】:输入的序列号不存在,请检查!", 404);
|
||
}
|
||
//检验状态
|
||
if (dtResult.Rows[0]["FQUALITYSTATUS"].ToBoolean())
|
||
{
|
||
throw new O3AppException($"资源【{resourceNo}】:输入的序列号质量不合格,请检查!", 500);
|
||
}
|
||
if (dtResult.Rows[0]["FISDEPLETE"].ToBoolean())
|
||
{
|
||
throw new O3AppException($"资源【{resourceNo}】:输入的序列号被消耗,请检查!", 500);
|
||
}
|
||
//条码状态
|
||
int snStatus = dtResult.Rows[0]["FSNSTATUS"].ToInt();
|
||
DataTable flowDetail = new DataTable();
|
||
switch (operateType)
|
||
{
|
||
case 1:
|
||
{
|
||
switch (snStatus)
|
||
{
|
||
case 0://初始状态
|
||
SQL = string.Format(@"
|
||
SELECT TOP 1 T1.FDETAILID,T1.FCODE,T1.FSTARTMODE,T1.FISREPORT,T2.FWIPSTATUS
|
||
FROM T_SFC_FLOWCARDENTRY (nolock) T1
|
||
LEFT JOIN T_SFC_BARCODESN (nolock) T2 ON T2.FSOURCEINTERID = T1.FINTERID AND T1.FPROCESSID=T2.FNEXTPROCESSID
|
||
WHERE T2.FSNCODE = '{0}' AND T1.FISREPORT=1
|
||
ORDER BY T1.FPROCESSSEQ ", SNCode);
|
||
|
||
//else if (operateType == 2)
|
||
//{//汇报操作
|
||
// SQL = string.Format(@"
|
||
// SELECT TOP 1 T1.FDETAILID,T1.FSTARTMODE
|
||
// FROM T_SFC_FLOWCARDENTRY (nolock) T1
|
||
// LEFT JOIN T_SFC_BARCODESN (nolock) T2 ON T2.FSOURCEINTERID = T1.FINTERID AND T2.FSOURCETRANTYPE=3
|
||
// WHERE T2.FSNCODE = '{0}' AND T1.FREPORTMODE = 3
|
||
// ORDER BY T1.FPROCESSSEQ ", SNCode);
|
||
//}
|
||
break;
|
||
case 1://开工
|
||
SQL = string.Format(@"
|
||
SELECT TOP 1 T1.FDETAILID,T1.FCODE,T1.FSTARTMODE,T1.FISREPORT,T2.FWIPSTATUS
|
||
FROM T_SFC_FLOWCARDENTRY (nolock) T1
|
||
LEFT JOIN T_SFC_BARCODESN (nolock) T2 ON T2.FSOURCEINTERID = T1.FINTERID AND T1.FPROCESSID = T2.FNEXTPROCESSID
|
||
WHERE T2.FSNCODE = '{0}' AND T1.FISREPORT=1
|
||
ORDER BY T1.FPROCESSSEQ ", SNCode);
|
||
//throw new O3AppException($"已经用此序列号开过工,请检查!", 500);
|
||
//else if (operateType == 2)
|
||
//{//汇报操作
|
||
// SQL = string.Format(@"
|
||
// SELECT TOP 1 T1.FDETAILID,T1.FSTARTMODE
|
||
// FROM T_SFC_FLOWCARDENTRY(nolock) T1
|
||
// LEFT JOIN T_SFC_BARCODESN (nolock) T2 ON T2.FSOURCEINTERID = T1.FINTERID AND T1.FPROCESSID = T2.FCURPROCESSID AND T2.FSOURCETRANTYPE=3
|
||
// WHERE T2.FSNCODE = '{0}' AND (T1.FSTARTMODE = 2 OR T1.FREPORTMODE = 3 ) ", SNCode);
|
||
//}
|
||
|
||
break;
|
||
case 2://不良
|
||
case 3://报废
|
||
case 5://维修
|
||
throw new O3AppException($"输入的序列号状态不正确,请检查!", 500);
|
||
case 4://汇报
|
||
SQL = string.Format(@"
|
||
SELECT TOP 1 T1.FDETAILID,T1.FCODE,T1.FSTARTMODE,T1.FISREPORT,T2.FWIPSTATUS
|
||
FROM T_SFC_FLOWCARDENTRY (nolock) T1
|
||
LEFT JOIN T_SFC_BARCODESN (nolock) T2 ON T2.FSOURCEINTERID = T1.FINTERID AND T2.FSOURCETRANTYPE=3
|
||
WHERE T2.FSNCODE = '{0}' AND T1.FISREPORT=1
|
||
AND T1.FPROCESSID = T2.FNEXTPROCESSID
|
||
ORDER BY T1.FPROCESSSEQ ", SNCode);
|
||
//else if (operateType == 2)
|
||
//{//汇报操作
|
||
// SQL = string.Format(@"
|
||
// SELECT TOP 1 T1.FDETAILID,T1.FSTARTMODE
|
||
// FROM T_SFC_FLOWCARDENTRY (nolock) T1
|
||
// LEFT JOIN T_SFC_BARCODESN (nolock) T2 ON T2.FSOURCEINTERID = T1.FINTERID AND T2.FSOURCETRANTYPE=3
|
||
// WHERE T2.FSNCODE = '{0}' AND T1.FREPORTMODE = 3
|
||
// AND T1.FPROCESSSEQ > (SELECT TOP 1 FPROCESSSEQ
|
||
// FROM T_SFC_FLOWCARDENTRY(nolock)
|
||
// WHERE FPROCESSID = T2.FCURPROCESSID AND FINTERID = T2.FSOURCEINTERID)
|
||
// ORDER BY T1.FPROCESSSEQ ", SNCode);
|
||
//}
|
||
break;
|
||
case 6://维修完成
|
||
SQL = string.Format(@"
|
||
SELECT TOP 1 T1.FDETAILID,T1.FCODE,T1.FSTARTMODE,T1.FISREPORT,T2.FWIPSTATUS
|
||
FROM T_SFC_FLOWCARDENTRY(nolock) T1
|
||
LEFT JOIN T_SFC_BARCODESN(nolock) T2 ON T1.FPROCESSID = T2.FNEXTPROCESSID AND T1.FINTERID = T2.FSOURCEINTERID AND T2.FSOURCETRANTYPE=3
|
||
WHERE T2.FSNCODE = '{0}' ", SNCode);
|
||
break;
|
||
}
|
||
|
||
flowDetail = xAPServer.Database.SqlQuery(SQL);
|
||
if (flowDetail.Rows.Count < 1)
|
||
{
|
||
throw new O3AppException($"资源【{resourceNo}】:SN不能在当前站点开工,请检查!", 404);
|
||
}
|
||
if (!flowDetail.Rows[0]["FISREPORT"].ToBoolean())
|
||
{
|
||
throw new O3AppException($"资源【{resourceNo}】:当前工序无需汇报!", 404);
|
||
}
|
||
|
||
if (flowDetail.Rows[0]["FSTARTMODE"].ToInt() == 0)
|
||
{
|
||
throw new O3AppException($"资源【{resourceNo}】:当前流转卡未设置汇报模式!", 404);
|
||
}
|
||
|
||
if (flowDetail.Rows[0]["FSTARTMODE"].ToInt() != 2)
|
||
{
|
||
string type = string.Empty;
|
||
switch (flowDetail.Rows[0]["FSTARTMODE"].ToInt())
|
||
{
|
||
case 1:
|
||
type = "流转卡开工";
|
||
break;
|
||
case 3:
|
||
type = "周转码开工";
|
||
break;
|
||
case 4:
|
||
type = "在制品开工";
|
||
break;
|
||
default:
|
||
break;
|
||
}
|
||
|
||
throw new O3AppException($"资源【{resourceNo}】:当前条码属于{type},与序列号开工模式不匹配,请检查!", 404);
|
||
}
|
||
|
||
string beforeflowcarddetailid = ProcessHandleRepository.GetFrontDetailID(xAPServer, dtResult.Rows[0]["FSOURCEINTERID"].ToString(), flowDetail.Rows[0]["FDETAILID"].ToString(), true, true);
|
||
if (!beforeflowcarddetailid.IsNullOrEmpty())
|
||
{
|
||
DataTable beforeflowcard = ProcessHandleRepository.GetReportData(xAPServer, 2, beforeflowcarddetailid);
|
||
if (beforeflowcard != null && beforeflowcard.Rows.Count > 0)
|
||
{
|
||
if (beforeflowcard.Rows[0]["FISOUTSOURCE"].ToInt() == 1 && beforeflowcard.Rows[0]["FISENDQC"].ToBoolean())
|
||
{
|
||
if (!dtResult.Rows[0]["FISCHECK"].ToBoolean())
|
||
{
|
||
throw new O3AppException($"资源【{resourceNo}】:前工序配置委外检验,当前条码未经过委外检验!", 404);
|
||
}
|
||
}
|
||
if (beforeflowcard.Rows[0]["FISCOURSEQC"].ToBoolean())
|
||
{
|
||
if (!dtResult.Rows[0]["FISCHECK"].ToBoolean())
|
||
{
|
||
throw new O3AppException($"资源【{resourceNo}】:前工序配置过程检验,当前条码未经过过程检验!", 404);
|
||
}
|
||
}
|
||
}
|
||
}
|
||
//校验仓库仓位
|
||
if (!CheckStock(resourceID, dtResult.Rows[0]["FSTOCKID"].ToStringEx(), dtResult.Rows[0]["FSTOCKLOCID"].ToStringEx(), out string msg))
|
||
{
|
||
if (!msg.IsNullOrEmpty())
|
||
{
|
||
throw new O3AppException($"资源【{ resourceNo }】:" + msg, 404);
|
||
}
|
||
}
|
||
break;
|
||
}
|
||
case 2:
|
||
{
|
||
|
||
}
|
||
break;
|
||
}
|
||
return flowDetail.Rows[0]["FDETAILID"].ToStringEx();
|
||
}
|
||
#endregion
|
||
|
||
#region 周转码开工/汇报
|
||
/// <summary>
|
||
/// 周转码开工/汇报
|
||
/// </summary>
|
||
/// <param name="TCCode"></param>
|
||
/// <param name="operateType">1=开工,2=汇报</param>
|
||
/// <returns></returns>
|
||
public string CheckTCAndReturnFlowDetailId(string resourceID, string TCCode, int operateType,string resourceNo, out decimal reportQty)
|
||
{
|
||
//APserver
|
||
using APPServerContext xAPServer = new APPServerContext(LoginInfo.DBAias, LoginInfo.UserID);
|
||
//查询sql 首先得到周转码数据
|
||
string SQL = string.Format(@" SELECT
|
||
*
|
||
FROM T_SFC_BARCODETC (NOLOCK)
|
||
WHERE FTCCODE='{0}'", TCCode);
|
||
DataTable dtResult = xAPServer.Database.SqlQuery(SQL);
|
||
if (dtResult == null || dtResult.Rows.Count <= 0)
|
||
{
|
||
throw new O3AppException($"资源【{resourceNo}】:输入的周转码不存在,请检查!", 404);
|
||
}
|
||
//检验状态
|
||
if (dtResult.Rows[0]["FQUALITYSTATUS"].ToBoolean())
|
||
{
|
||
throw new O3AppException($"资源【{resourceNo}】:输入的周转码质量不合格,请检查!", 500);
|
||
}
|
||
if (dtResult.Rows[0]["FISDEPLETE"].ToBoolean())
|
||
{
|
||
throw new O3AppException($"资源【{resourceNo}】:输入的周转码被消耗,请检查!", 500);
|
||
}
|
||
if (dtResult.Rows[0]["FDELETED"].ToBoolean())
|
||
{
|
||
throw new O3AppException($"资源【{resourceNo}】:输入的周转码已作废,请检查!");
|
||
}
|
||
//周转码状态
|
||
int tcStatus = dtResult.Rows[0]["FTCSTATUS"].ToInt();
|
||
|
||
switch (tcStatus)
|
||
{
|
||
case 0://初始状态
|
||
if (operateType == 1)
|
||
{//开工操作
|
||
SQL = string.Format(@"
|
||
SELECT TOP 1 T1.FDETAILID,T2.FQTY,T1.FSTARTMODE,T2.FWIPSTATUS,T2.FTOTQTY
|
||
FROM T_SFC_FLOWCARDENTRY (nolock) T1
|
||
LEFT JOIN T_SFC_BARCODETC (nolock) T2 ON T2.FSOURCEINTERID = T1.FINTERID AND T1.FPROCESSID = T2.FCURPROCESSID AND T2.FSOURCETRANTYPE=1
|
||
WHERE T2.FTCCODE = '{0}' AND T1.FISREPORT=1
|
||
ORDER BY T1.FPROCESSSEQ ", TCCode);
|
||
}
|
||
else if (operateType == 2)
|
||
{//汇报操作
|
||
throw new O3AppException($"资源【{resourceNo}】:此周转码还未开过工,请检查!", 500);
|
||
}
|
||
break;
|
||
case 1://开工
|
||
if (operateType == 1)
|
||
{//开工操作
|
||
SQL = string.Format(@"
|
||
SELECT TOP 1 T1.FDETAILID,T2.FQTY,T1.FSTARTMODE,T2.FWIPSTATUS,T2.FTOTQTY
|
||
FROM T_SFC_FLOWCARDENTRY (nolock) T1
|
||
LEFT JOIN T_SFC_BARCODETC (nolock) T2 ON T2.FSOURCEINTERID = T1.FINTERID AND T1.FPROCESSID = T2.FCURPROCESSID AND T2.FSOURCETRANTYPE=1
|
||
WHERE T2.FTCCODE = '{0}' AND T1.FISREPORT=1
|
||
ORDER BY T1.FPROCESSSEQ ", TCCode);
|
||
//throw new O3AppException($"已经用此周转码开过工,请检查!", 500);
|
||
}
|
||
else if (operateType == 2)
|
||
{//汇报操作
|
||
SQL = string.Format(@"
|
||
SELECT TOP 1 T1.FDETAILID,T1.FSTARTMODE,T2.FWIPSTATUS,T2.FTOTQTY
|
||
FROM T_SFC_FLOWCARDENTRY(nolock) T1
|
||
LEFT JOIN T_SFC_BARCODETC(nolock) T2 ON T1.FPROCESSID = T2.FCURPROCESSID AND T1.FINTERID = T2.FSOURCEINTERID AND T2.FSOURCETRANTYPE=1
|
||
WHERE T2.FTCCODE = '{0}' AND (T1.FSTARTMODE = 3 AND T1.FREPORTMODE = 4 ) ", TCCode);
|
||
}
|
||
|
||
break;
|
||
case 2://不良
|
||
case 3://报废
|
||
case 5://维修
|
||
throw new O3AppException($"资源【{resourceNo}】:输入的周转码状态不正确,请检查!", 500);
|
||
case 4://汇报
|
||
if (operateType == 1)
|
||
{//开工操作
|
||
SQL = string.Format(@"
|
||
SELECT TOP 1 T1.FDETAILID,T2.FQTY,T1.FSTARTMODE,T2.FWIPSTATUS,T2.FTOTQTY
|
||
FROM T_SFC_FLOWCARDENTRY (nolock) T1
|
||
LEFT JOIN T_SFC_BARCODETC (nolock) T2 ON T2.FSOURCEINTERID = T1.FINTERID AND T2.FSOURCETRANTYPE=1
|
||
WHERE T2.FTCCODE = '{0}' AND T1.FISREPORT=1
|
||
AND T1.FPROCESSID = T2.FCURPROCESSID
|
||
ORDER BY T1.FPROCESSSEQ ", TCCode);
|
||
}
|
||
else if (operateType == 2)
|
||
{//汇报操作
|
||
throw new O3AppException($"资源【{resourceNo}】:输入的周转码状态不正确,请检查!", 500);
|
||
}
|
||
break;
|
||
case 6://维修完成
|
||
SQL = string.Format(@"
|
||
SELECT TOP 1 T1.FDETAILID,T2.FQTY,T1.FSTARTMODE,T2.FWIPSTATUS,T2.FTOTQTY
|
||
FROM T_SFC_FLOWCARDENTRY(nolock) T1
|
||
LEFT JOIN T_SFC_BARCODETC(nolock) T2 ON T1.FPROCESSID = T2.FCURPROCESSID AND T1.FINTERID = T2.FSOURCEINTERID AND T2.FSOURCETRANTYPE=1
|
||
WHERE T2.FTCCODE = '{0}' ", TCCode);
|
||
break;
|
||
}
|
||
|
||
DataTable flowDetail = xAPServer.Database.SqlQuery(SQL);
|
||
if (flowDetail.Rows.Count < 1)
|
||
{
|
||
throw new O3AppException($"资源【{resourceNo}】:输入的周转码不存在,请检查!", 404);
|
||
}
|
||
if (flowDetail.Rows[0]["FSTARTMODE"].ToInt() == 0)
|
||
{
|
||
throw new O3AppException($"资源【{resourceNo}】:当前流转卡未设置汇报模式!", 404);
|
||
}
|
||
else
|
||
{
|
||
if (flowDetail.Rows[0]["FSTARTMODE"].ToInt() != 3 && operateType == 1)
|
||
{
|
||
string type = string.Empty;
|
||
switch (flowDetail.Rows[0]["FSTARTMODE"].ToInt())
|
||
{
|
||
case 1:
|
||
type = "流转卡开工";
|
||
break;
|
||
case 2:
|
||
type = "序列号开工";
|
||
break;
|
||
case 4:
|
||
type = "在制品开工";
|
||
break;
|
||
default:
|
||
break;
|
||
}
|
||
throw new O3AppException($"资源【{resourceNo}】:当前条码属于{type},与周转码开工模式不匹配,请检查!", 404);
|
||
}
|
||
}
|
||
|
||
string beforeflowcarddetailid = ProcessHandleRepository.GetFrontDetailID(xAPServer, dtResult.Rows[0]["FSOURCEINTERID"].ToString(), flowDetail.Rows[0]["FDETAILID"].ToString(), true, true);
|
||
if (!beforeflowcarddetailid.IsNullOrEmpty())
|
||
{
|
||
DataTable beforeflowcard = ProcessHandleRepository.GetReportData(xAPServer, 2, beforeflowcarddetailid);
|
||
if (beforeflowcard != null && beforeflowcard.Rows.Count > 0)
|
||
{
|
||
if (beforeflowcard.Rows[0]["FISOUTSOURCE"].ToInt() == 1 && beforeflowcard.Rows[0]["FISENDQC"].ToBoolean())
|
||
{
|
||
if (!dtResult.Rows[0]["FISCHECK"].ToBoolean())
|
||
{
|
||
throw new O3AppException($"资源【{resourceNo}】:前工序配置委外检验,当前条码未经过委外检验!", 404);
|
||
}
|
||
}
|
||
if (beforeflowcard.Rows[0]["FISCOURSEQC"].ToBoolean())
|
||
{
|
||
if (!dtResult.Rows[0]["FISCHECK"].ToBoolean())
|
||
{
|
||
throw new O3AppException($"资源【{resourceNo}】:前工序配置过程检验,当前条码未经过过程检验!", 404);
|
||
}
|
||
}
|
||
}
|
||
}
|
||
//校验仓库仓位
|
||
if (!CheckStock(resourceID, dtResult.Rows[0]["FSTOCKID"].ToStringEx(), dtResult.Rows[0]["FSTOCKLOCID"].ToStringEx(), out string msg))
|
||
{
|
||
if (!msg.IsNullOrEmpty())
|
||
{
|
||
throw new O3AppException($"资源【{ resourceNo }】:" + msg, 404);
|
||
}
|
||
}
|
||
reportQty = flowDetail.Rows[0]["FQTY"].ToDecimal() - flowDetail.Rows[0]["FTOTQTY"].ToDecimal();
|
||
return flowDetail.Rows[0]["FDETAILID"].ToStringEx();
|
||
|
||
//string flowDetail = xAPServer.Database.SqlQueryString(SQL);
|
||
//if (flowDetail.IsNullOrEmpty())
|
||
//{
|
||
// throw new O3AppException($"输入的周转码不存在,请检查!", 404);
|
||
//}
|
||
|
||
//return flowDetail;
|
||
}
|
||
#endregion
|
||
|
||
#region 在制品开工
|
||
/// <summary>
|
||
/// 在制品开工
|
||
/// </summary>
|
||
/// <param name="WIPCode"></param>
|
||
/// <returns></returns>
|
||
public string CheckWIPAndReturnFlowDetailId(string resourceID, string WIPCode, ProductionAct productionAct, out decimal reportQty)
|
||
{
|
||
//APserver
|
||
using APPServerContext xAPServer = new APPServerContext(LoginInfo.DBAias, LoginInfo.UserID);
|
||
//查询sql 首先得到在制品条码数据
|
||
string SQL = string.Format(@" SELECT
|
||
FFLOWCARDID
|
||
,FWIPSTATUS
|
||
,FQUALITYSTATUS
|
||
,FQTY
|
||
,FISDEPLETE
|
||
,FSTOCKID
|
||
,FSTOCKLOCID
|
||
,FBARSTATUS
|
||
,FISCHECK
|
||
FROM T_SFC_BARCODEWIP (NOLOCK)
|
||
WHERE FWIPCODE='{0}'", WIPCode);
|
||
DataTable dtResult = xAPServer.Database.SqlQuery(SQL);
|
||
if (dtResult == null || dtResult.Rows.Count <= 0)
|
||
{
|
||
throw new O3AppException($"资源【{productionAct.ResourcesNO}】:输入的在制品条码不存在,请检查!", 404);
|
||
}
|
||
//检验状态
|
||
if (dtResult.Rows[0]["FQUALITYSTATUS"].ToBoolean())
|
||
{
|
||
throw new O3AppException($"资源【{productionAct.ResourcesNO}】:输入的在制品条码不合格,请检查!", 500);
|
||
}
|
||
if (dtResult.Rows[0]["FISDEPLETE"].ToBoolean())
|
||
{
|
||
throw new O3AppException($"资源【{productionAct.ResourcesNO}】:输入的在制品条码被消耗,请检查!", 500);
|
||
}
|
||
if (dtResult.Rows[0]["FBARSTATUS"].ToInt() == 3)
|
||
{
|
||
throw new O3AppException($"资源【{productionAct.ResourcesNO}】:输入的在制品条码被消耗,请检查!", 500);
|
||
}
|
||
//条码状态
|
||
int tcStatus = dtResult.Rows[0]["FWIPSTATUS"].ToInt();
|
||
if (tcStatus == 1)
|
||
{
|
||
throw new O3AppException($"资源【{productionAct.ResourcesNO}】:输入的在制品条码已被投料,请检查!", 500);
|
||
}
|
||
if (tcStatus == 3)
|
||
{
|
||
throw new O3AppException($"资源【{productionAct.ResourcesNO}】:输入的在制品条码已汇报,不可再次汇报,请检查!", 500);
|
||
}
|
||
switch (tcStatus)
|
||
{
|
||
case 0://初始状态
|
||
//开工操作
|
||
SQL = string.Format(@"
|
||
SELECT TOP 1 T1.FDETAILID,T1.FSTARTMODE,T2.FWIPSTATUS
|
||
FROM T_SFC_FLOWCARDENTRY (nolock) T1
|
||
LEFT JOIN T_SFC_BARCODEWIP (nolock) T2 ON T2.FFLOWCARDID = T1.FINTERID
|
||
WHERE T2.FWIPCODE = '{0}' AND T1.FISREPORT=1
|
||
AND T1.FPROCESSID = T2.FPROCESSID", WIPCode);
|
||
|
||
break;
|
||
//case 1://投料
|
||
// //开工操作
|
||
// SQL = string.Format(@"
|
||
// SELECT TOP 1 T1.FDETAILID,T1.FSTARTMODE
|
||
// FROM T_SFC_FLOWCARDENTRY (nolock) T1
|
||
// LEFT JOIN T_SFC_BARCODEWIP (nolock) T2 ON T2.FFLOWCARDID = T1.FINTERID AND T1.FPROCESSID = T2.FPROCESSID
|
||
// WHERE T2.FWIPCODE = '{0}' AND T1.FISREPORT=1
|
||
// ORDER BY T1.FPROCESSSEQ ", WIPCode);
|
||
// //throw new O3AppException($"已经用此在制品条码开过工,请检查!", 500);
|
||
// break;
|
||
case 2://维修完成
|
||
SQL = string.Format(@"
|
||
SELECT TOP 1 T1.FDETAILID,T1.FSTARTMODE,T2.FWIPSTATUS
|
||
FROM T_SFC_FLOWCARDENTRY (nolock) T1
|
||
LEFT JOIN T_SFC_BARCODEWIP (nolock) T2 ON T2.FFLOWCARDID = T1.FINTERID
|
||
WHERE T2.FWIPCODE = '{0}' AND T1.FSTARTMODE = 4 AND T1.FISREPORT=1
|
||
ORDER BY T1.FPROCESSSEQ ", WIPCode);
|
||
break;
|
||
//case 3://汇报
|
||
// SQL = string.Format(@"
|
||
// SELECT TOP 1 T1.FDETAILID,T1.FSTARTMODE
|
||
// FROM T_SFC_FLOWCARDENTRY (nolock) T1
|
||
// LEFT JOIN T_SFC_BARCODEWIP (nolock) T2 ON T2.FFLOWCARDID = T1.FINTERID
|
||
// WHERE T2.FWIPCODE = '{0}' AND T1.FSTARTMODE = 4 AND T1.FISREPORT=1
|
||
// AND T1.FPROCESSSEQ > (SELECT TOP 1 FPROCESSSEQ
|
||
// FROM T_SFC_FLOWCARDENTRY(nolock)
|
||
// WHERE FPROCESSID = T2.FPROCESSID AND FINTERID=T2.FFLOWCARDID)
|
||
// ORDER BY T1.FPROCESSSEQ ", WIPCode);
|
||
// break;
|
||
}
|
||
|
||
DataTable flowDetail = xAPServer.Database.SqlQuery(SQL);
|
||
if (flowDetail.Rows.Count < 1)
|
||
{
|
||
throw new O3AppException($"资源【{productionAct.ResourcesNO}】:输入的在制品条码不存在,请检查!", 404);
|
||
}
|
||
if (flowDetail.Rows[0]["FSTARTMODE"].ToInt() == 0)
|
||
{
|
||
throw new O3AppException($"资源【{productionAct.ResourcesNO}】:当前流转卡未设置汇报模式", 404);
|
||
}
|
||
|
||
if (flowDetail.Rows[0]["FSTARTMODE"].ToInt() != 4)
|
||
{
|
||
string type = string.Empty;
|
||
switch (flowDetail.Rows[0]["FSTARTMODE"].ToInt())
|
||
{
|
||
case 1:
|
||
type = "流转卡开工";
|
||
break;
|
||
case 2:
|
||
type = "序列号开工";
|
||
break;
|
||
case 3:
|
||
type = "周转码开工";
|
||
break;
|
||
default:
|
||
break;
|
||
}
|
||
throw new O3AppException($"资源【{productionAct.ResourcesNO}】:当前条码属于{type},与在制品开工模式不匹配,请检查!", 404);
|
||
}
|
||
|
||
//string flowDetail = xAPServer.Database.SqlQueryString(SQL);
|
||
//if (flowDetail.IsNullOrEmpty())
|
||
//{
|
||
// throw new O3AppException($"输入的在制品条码不存在,请检查!", 404);
|
||
//}
|
||
|
||
SQL = string.Format($@"SELECT 1 FROM dbo.T_SFC_REPORTENTRY3 WHERE FMBARCODE='{WIPCode}'");
|
||
var rp = xAPServer.Database.SqlQuery(SQL);
|
||
if (rp != null && rp.Rows.Count > 0)
|
||
{
|
||
throw new O3AppException($"资源【{productionAct.ResourcesNO}】:该在制品条码已开工过,不可再次投入使用!", 404);
|
||
}
|
||
|
||
string beforeflowcarddetailid = ProcessHandleRepository.GetFrontDetailID(xAPServer, dtResult.Rows[0]["FFLOWCARDID"].ToString(), flowDetail.Rows[0]["FDETAILID"].ToString(), true, true);
|
||
if (!beforeflowcarddetailid.IsNullOrEmpty())
|
||
{
|
||
DataTable beforeflowcard = ProcessHandleRepository.GetReportData(xAPServer, 2, beforeflowcarddetailid);
|
||
if (beforeflowcard != null && beforeflowcard.Rows.Count > 0)
|
||
{
|
||
if (beforeflowcard.Rows[0]["FISOUTSOURCE"].ToInt() == 1 && beforeflowcard.Rows[0]["FISENDQC"].ToBoolean())
|
||
{
|
||
if (!dtResult.Rows[0]["FISCHECK"].ToBoolean())
|
||
{
|
||
throw new O3AppException($"资源【{productionAct.ResourcesNO}】:前工序配置委外检验,当前条码未经过委外检验!", 404);
|
||
}
|
||
}
|
||
if (beforeflowcard.Rows[0]["FISCOURSEQC"].ToBoolean())
|
||
{
|
||
if (!dtResult.Rows[0]["FISCHECK"].ToBoolean())
|
||
{
|
||
throw new O3AppException($"资源【{productionAct.ResourcesNO}】:前工序配置过程检验,当前条码未经过过程检验!", 404);
|
||
}
|
||
}
|
||
}
|
||
}
|
||
//校验仓库仓位
|
||
if (!CheckStock(resourceID, dtResult.Rows[0]["FSTOCKID"].ToStringEx(), dtResult.Rows[0]["FSTOCKLOCID"].ToStringEx(), out string msg))
|
||
{
|
||
if (!msg.IsNullOrEmpty())
|
||
{
|
||
throw new O3AppException($"资源【{ productionAct.ResourcesNO }】:" + msg, 404);
|
||
}
|
||
}
|
||
|
||
//启用了车间在制品管理的情况下,验证在制品的仓库仓位与资源的仓库仓位时候相等
|
||
//if (ReportParams.FNeedWorkInProcessYN)
|
||
//{
|
||
// if (!(productionAct.StockID == dtResult.Rows[0]["FSTOCKID"].ToStringEx() && productionAct.SPID == dtResult.Rows[0]["FSTOCKLOCID"].ToStringEx()))
|
||
// {
|
||
// throw new O3AppException($"启用车间在制品管理,但是在制品的仓库仓位与当前资源的仓库仓位不一致,请检查!", 400);
|
||
// }
|
||
//}
|
||
reportQty = dtResult.Rows[0]["FQTY"].ToDecimal();
|
||
return flowDetail.Rows[0]["FDETAILID"].ToStringEx();
|
||
}
|
||
#endregion
|
||
|
||
#region 汇报前检查周转码
|
||
/// <summary>
|
||
/// 汇报前检查周转码
|
||
/// </summary>
|
||
/// <returns></returns>
|
||
public DataTable DoCheckTCBeforeReport(ProductionAct productionAct, ReportClass reportClass, int workStatus)
|
||
{
|
||
//APserver
|
||
using APPServerContext xAPServer = new APPServerContext(LoginInfo.DBAias, LoginInfo.UserID);
|
||
//周转码开工数量
|
||
DataTable tcDataInfo = xAPServer.Database.SqlQuery($"SELECT FQTY,FTOTQTY,FTOTQUAQTY FROM dbo.T_SFC_BARCODETC WHERE FTCCODE='{productionAct.FInputBarCode}'");
|
||
if (tcDataInfo.Rows.Count < 1)
|
||
{
|
||
throw new O3AppException("周转码不存在", 404);
|
||
}
|
||
decimal tcqty = tcDataInfo.Rows[0]["FQTY"].ToDecimal();
|
||
decimal tcfinishqty = tcDataInfo.Rows[0]["FTOTQTY"].ToDecimal();
|
||
if (workStatus == 2)
|
||
{
|
||
if (reportClass.FPassQty + reportClass.FBadQty > tcqty - tcfinishqty)
|
||
{
|
||
throw new O3AppException($"调机数量【{reportClass.FPassQty + reportClass.FBadQty}】不可大于周转码未汇报数量【{tcqty - tcfinishqty}】", 500);
|
||
}
|
||
}
|
||
else
|
||
{
|
||
if (reportClass.FPassQty + reportClass.FBadQty > tcqty - tcfinishqty)
|
||
{
|
||
throw new O3AppException($"汇报数量【{reportClass.FPassQty + reportClass.FBadQty}】不可大于周转码未汇报数量【{tcqty - tcfinishqty}】", 500);
|
||
}
|
||
}
|
||
return tcDataInfo;
|
||
}
|
||
#endregion
|
||
|
||
#region 汇报前检查在制品
|
||
/// <summary>
|
||
/// 汇报前检查在制品
|
||
/// </summary>
|
||
/// <returns></returns>
|
||
public DataTable DoCheckWipBeforeReport(ProductionAct productionAct, ReportClass reportClass, int workStatus)
|
||
{
|
||
//APserver
|
||
using APPServerContext xAPServer = new APPServerContext(LoginInfo.DBAias, LoginInfo.UserID);
|
||
//在制品开工数量
|
||
DataTable wipDataInfo = xAPServer.Database.SqlQuery($"SELECT FQTY,0 as FTOTQTY FROM dbo.T_SFC_BARCODEWIP WHERE FWIPCODE='{productionAct.FInputBarCode}'");
|
||
var rptQtyDt = xAPServer.Database.SqlQuery($"SELECT SUM(A.FQTY) AS QTY FROM dbo.T_SFC_REPORTENTRY A WHERE A.FINTERID='{productionAct.FReportID}'");
|
||
decimal rptQty = rptQtyDt.Rows[0]["QTY"].ToDecimal();
|
||
if (wipDataInfo.Rows.Count < 1)
|
||
{
|
||
throw new O3AppException("在制品不存在", 404);
|
||
}
|
||
decimal tcqty = wipDataInfo.Rows[0]["FQTY"].ToDecimal();
|
||
if (workStatus == 2)
|
||
{
|
||
if (reportClass.FPassQty + reportClass.FBadQty + rptQty > tcqty)
|
||
{
|
||
throw new O3AppException("调机数量不可大于在制品数量", 500);
|
||
}
|
||
}
|
||
else
|
||
{
|
||
if (reportClass.FPassQty + reportClass.FBadQty + rptQty > tcqty)
|
||
{
|
||
throw new O3AppException("汇报数量不可大于在制品数量", 500);
|
||
}
|
||
}
|
||
foreach (DataColumn item in wipDataInfo.Columns)
|
||
{
|
||
item.ReadOnly = false;
|
||
}
|
||
wipDataInfo.Rows[0]["FTOTQTY"] = rptQty;
|
||
return wipDataInfo;
|
||
}
|
||
#endregion
|
||
|
||
#region 汇报前检查SN
|
||
/// <summary>
|
||
/// 汇报前检查在制品
|
||
/// </summary>
|
||
/// <returns></returns>
|
||
public void CheckSnReport(ProductionAct productionAct, ReportClass reportClass, DataTable dtFlowCard, string snCode, int workStatus)
|
||
{
|
||
//APserver
|
||
using APPServerContext xAPServer = new APPServerContext(LoginInfo.DBAias, LoginInfo.UserID);
|
||
DataTable dt = xAPServer.Database.SqlQuery($"SELECT FSNSTATUS,FCURPROCESSID,FNEXTPROCESSID,FQUALITYSTATUS,FSOURCEINTERID FROM dbo.T_SFC_BARCODESN WHERE FSNCODE='{snCode}'");
|
||
if (dt.Rows.Count < 1)
|
||
{
|
||
throw new O3AppException("SN不存在", 404);
|
||
}
|
||
if (dt.Rows[0]["FSNSTATUS"] == null || dt.Rows[0]["FSNSTATUS"].ToString().IsNullOrEmpty())
|
||
{
|
||
throw new O3AppException("SN状态丢失", 500);
|
||
}
|
||
if (dt.Rows[0]["FQUALITYSTATUS"].ToBoolean())
|
||
{
|
||
throw new O3AppException("SN不合格,不可再次汇报", 500);
|
||
}
|
||
if (dtFlowCard.Rows[0]["FSTARTMODE"].ToInt() == 2)
|
||
{
|
||
if (dt.Rows[0]["FSNSTATUS"].ToInt() != 1)
|
||
{
|
||
throw new O3AppException("SN非开工状态,不可汇报", 500);
|
||
}
|
||
if (!dt.Rows[0]["FCURPROCESSID"].Equals(dtFlowCard.Rows[0]["FPROCESSID"].ToString()))
|
||
{
|
||
DataTable process = xAPServer.Database.SqlQuery($"SELECT FNAME FROM dbo.T_SFC_PROCESS WHERE FINTERID='{dt.Rows[0]["FCURPROCESSID"]}'");
|
||
throw new O3AppException($"工序错误,应在{process.Rows[0]["FNAME"].ToStringEx()}汇报", 500);
|
||
}
|
||
|
||
}
|
||
else
|
||
{
|
||
var state = dtFlowCard.Rows[0]["FPROCESSSTATUS"].ToInt();
|
||
switch (state)
|
||
{
|
||
case 0:
|
||
case 1:
|
||
throw new O3AppException("流转卡未开工,不可汇报", 500);
|
||
case 4:
|
||
throw new O3AppException("流转卡已委外发出,不可汇报", 500);
|
||
case 9:
|
||
throw new O3AppException("流转卡已关闭,不可汇报", 500);
|
||
default:
|
||
break;
|
||
}
|
||
if (!dt.Rows[0]["FSOURCEINTERID"].ToStringEx().Equals(dtFlowCard.Rows[0]["FINTERID"].ToStringEx()))
|
||
{
|
||
throw new O3AppException("SN不属于当前流转卡", 500);
|
||
}
|
||
string sql = $"SELECT 1 FROM dbo.T_SFC_REPORTENTRY WHERE FBARCODE='{snCode}' AND FPROCESSID='{dtFlowCard.Rows[0]["FPROCESSID"]}' AND FQTY>0";
|
||
dt = xAPServer.Database.SqlQuery(sql);
|
||
if (dt.Rows.Count > 0)
|
||
{
|
||
throw new O3AppException("SN已汇报,无需汇报", 500);
|
||
}
|
||
}
|
||
}
|
||
#endregion
|
||
|
||
#region 检查仓位仓位是否匹配
|
||
/// <summary>
|
||
/// 检查仓位仓位是否匹配
|
||
/// </summary>
|
||
/// <param name="resid">资源内码</param>
|
||
/// <param name="stockid">仓库</param>
|
||
/// <param name="stocklocid">仓位</param>
|
||
/// <param name="msg">返回的错误信息</param>
|
||
/// <returns></returns>
|
||
public bool CheckStock(string resid, string stockid, string stocklocid, out string msg)
|
||
{
|
||
using APPServerContext context = new APPServerContext(LoginInfo.DBAias, LoginInfo.UserID);
|
||
//启用了车间在制品管理的情况下,验证在制品的仓库仓位与资源的仓库仓位时候相等
|
||
Hashtable ht = context.PBValue("FNeedWorkInProcessYN,L,Y;");
|
||
if (ht != null && ht.Contains("FNeedWorkInProcessYN"))
|
||
{
|
||
bool FNeedWorkInProcessYN = Convert.ToBoolean(ht["FNeedWorkInProcessYN"]);
|
||
if (FNeedWorkInProcessYN)
|
||
{
|
||
GetResourceStock(resid, out string stockidtmp, out string stocklocidtmp, out bool isopenloc, out msg);
|
||
if (!string.IsNullOrEmpty(msg))
|
||
{
|
||
return false;
|
||
}
|
||
if (stockid.IsNullOrEmpty())
|
||
{
|
||
msg = $"启用车间在制品管理,但是在制品条码未设置仓库仓位,请检查!";
|
||
return false;
|
||
}
|
||
if (!stockid.Equals(stockidtmp))
|
||
{
|
||
msg = $"启用车间在制品管理,资源仓库与条码所在仓库不一致!";
|
||
return false;
|
||
}
|
||
if (isopenloc)
|
||
{
|
||
msg = $"启用车间在制品管理,资源仓位与条码所在仓位不一致!";
|
||
return false;
|
||
}
|
||
}
|
||
}
|
||
msg = "";
|
||
return true;
|
||
}
|
||
#endregion
|
||
|
||
#region 根据资源获取仓库仓位
|
||
/// <summary>
|
||
/// 根据资源获取仓库仓位
|
||
/// </summary>
|
||
/// <param name="resid">资源</param>
|
||
/// <param name="stockid">仓库</param>
|
||
/// <param name="stocklocid">仓位</param>
|
||
/// <param name="isopenlocation">是否启用仓位</param>
|
||
/// <returns></returns>
|
||
public bool GetResourceStock(string resid, out string stockid, out string stocklocid, out bool isopenlocation, out string msg)
|
||
{
|
||
using APPServerContext xAPServer = new APPServerContext(LoginInfo.DBAias, LoginInfo.UserID);
|
||
try
|
||
{
|
||
isopenlocation = true;
|
||
string sql = $"SELECT FSTOCKID,FSTOCKLOCID FROM dbo.T_ENG_RESOURCE WHERE FINTERID='{resid}'";
|
||
var dt = xAPServer.Database.SqlQuery(sql);
|
||
if (dt.Rows.Count < 1)
|
||
{
|
||
stockid = "";
|
||
stocklocid = "";
|
||
msg = "资源不存在";
|
||
isopenlocation = false;
|
||
return false;
|
||
}
|
||
//获取资源的仓库仓位
|
||
stockid = dt.Rows[0]["FSTOCKID"].ToString();
|
||
stocklocid = dt.Rows[0]["FSTOCKLOCID"].ToString();
|
||
if (string.IsNullOrEmpty(stockid))
|
||
{
|
||
stockid = "";
|
||
stocklocid = "";
|
||
msg = "该资源未设置仓库";
|
||
isopenlocation = false;
|
||
return false;
|
||
}
|
||
//获取仓库的信息
|
||
sql = $"SELECT FISOPENLOCATION FROM T_BD_STOCK WHERE FINTERID='{stockid}'";
|
||
dt = xAPServer.Database.SqlQuery(sql);
|
||
if (dt.Rows.Count < 1)
|
||
{
|
||
stockid = "";
|
||
stocklocid = "";
|
||
msg = "资源设定的仓库不存在!";
|
||
isopenlocation = false;
|
||
return false;
|
||
}
|
||
//获取是否启用仓位管理
|
||
isopenlocation = dt.Rows[0]["FISOPENLOCATION"].ToBoolean();
|
||
if (isopenlocation && stocklocid.IsNullOrEmpty())
|
||
{
|
||
stockid = "";
|
||
stocklocid = "";
|
||
msg = "资源设定的仓库启用了仓位管理,但是该资源未设置仓位!";
|
||
return false;
|
||
}
|
||
msg = "";
|
||
return true;
|
||
}
|
||
catch (Exception ex)
|
||
{
|
||
isopenlocation = false;
|
||
stockid = "";
|
||
stocklocid = "";
|
||
msg = ex.Message;
|
||
return false;
|
||
}
|
||
|
||
}
|
||
#endregion
|
||
|
||
}
|
||
}
|