Files

1612 lines
85 KiB
C#
Executable File
Raw Permalink Blame History

This file contains ambiguous Unicode characters
This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.
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
}
}